Changeset 15582 for branches/feature-module-update
- Timestamp:
- 2007/09/04 12:52:10 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/helper/SC_Helper_CSV.php
r15581 r15582 291 291 292 292 /** 293 * CSV出力項目を取得する.294 *295 * @param integer $csv_id CSV ID296 * @param string $where SQL の WHERE 句297 * @param array $arrVal WHERE 句の要素298 * @return array CSV 出力項目の配列299 */300 function sfgetCsvOutput($csv_id = "", $where = "", $arrVal = array()){301 $objQuery = new SC_Query();302 $arrData = array();303 $ret = array();304 305 $sql = "";306 $sql .= " SELECT ";307 $sql .= " no, ";308 $sql .= " csv_id, ";309 $sql .= " col, ";310 $sql .= " disp_name, ";311 $sql .= " rank, ";312 $sql .= " status, ";313 $sql .= " create_date, ";314 $sql .= " update_date ";315 $sql .= " FROM ";316 $sql .= " dtb_csv ";317 318 if ($where != "") {319 $sql .= $where;320 $arrData = $arrVal;321 }elseif($csv_id != ""){322 $sql .= " WHERE csv_id = ? ";323 $arrData = array($csv_id);324 }325 326 $sql .= " ORDER BY ";327 $sql .= " rank , no";328 $sql .= " ";329 330 $ret = $objQuery->getall($sql, $arrData);331 332 return $ret;333 }334 335 /**336 293 * 項目情報を初期化する. 337 294 *
Note: See TracChangeset
for help on using the changeset viewer.