Changeset 15566
- Timestamp:
- 2007/09/03 19:55:29 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/helper/SC_Helper_CSV.php
r15545 r15566 53 53 // }}} 54 54 // {{{ functions 55 56 /** 57 * CSV 項目を出力する. 58 * 59 * @param integer $csv_id CSV ID 60 * @param string $where SQL の WHERE 句 61 * @param array $arrVal WHERE 句の要素 62 * @return array CSV 項目の配列 63 */ 64 function sfgetCsvOutput($csv_id = "", $where = "", $arrVal = array()){ 65 $objQuery = new SC_Query(); 66 $arrData = array(); 67 $ret = array(); 68 69 $sql = ""; 70 $sql .= " SELECT "; 71 $sql .= " no, "; 72 $sql .= " csv_id, "; 73 $sql .= " col, "; 74 $sql .= " disp_name, "; 75 $sql .= " rank, "; 76 $sql .= " status, "; 77 $sql .= " create_date, "; 78 $sql .= " update_date "; 79 $sql .= " FROM "; 80 $sql .= " dtb_csv "; 81 82 if ($where != "") { 83 $sql .= $where; 84 $arrData = $arrVal; 85 }elseif($csv_id != ""){ 86 $sql .= " WHERE csv_id = ? "; 87 $arrData = array($csv_id); 88 } 89 90 $sql .= " ORDER BY "; 91 $sql .= " rank , no"; 92 $sql .= " "; 93 94 $ret = $objQuery->getall($sql, $arrData); 95 96 return $ret; 97 } 55 98 56 99
Note: See TracChangeset
for help on using the changeset viewer.