- Timestamp:
- 2012/02/06 11:05:15 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_CSV.php
r21420 r21441 84 84 85 85 // TODO: 固有処理 なんかエレガントな処理にしたい 86 if ($csv_id == '1') {86 if ($csv_id == '1') { 87 87 //商品の場合 88 88 $objProduct = new SC_Product_Ex(); … … 90 90 $inner_where = 'dtb_products_class.del_flg = 0'; 91 91 $sql = $objQuery->getSql($cols, $objProduct->prdclsSQL($inner_where),$where); 92 }else if ($csv_id == '2') {92 }else if ($csv_id == '2') { 93 93 // 会員の場合 94 94 $sql = "SELECT " . $cols . " FROM dtb_customer " . $where; 95 }else if ($csv_id == '3') {95 }else if ($csv_id == '3') { 96 96 // 注文の場合 97 97 $sql = "SELECT " . $cols . " FROM dtb_order " . $where; 98 }else if ($csv_id == '4') {98 }else if ($csv_id == '4') { 99 99 // レビューの場合 100 100 $sql = "SELECT " . $cols . " FROM dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id " . $where; 101 }else if ($csv_id == '5') {101 }else if ($csv_id == '5') { 102 102 // カテゴリの場合 103 103 $sql = "SELECT " . $cols . " FROM dtb_category " . $where; … … 122 122 $table = 'dtb_csv'; 123 123 124 if (SC_Utils_Ex::sfIsInt($csv_id)){125 if ($where == "") {124 if (SC_Utils_Ex::sfIsInt($csv_id)) { 125 if ($where == "") { 126 126 $where = "csv_id = ?"; 127 } else{127 } else { 128 128 $where = "$where AND csv_id = ?"; 129 129 } … … 144 144 function sfIsImportCSVFrame(&$arrCSVFrame) { 145 145 $result = true; 146 foreach ($arrCSVFrame as $key => $val) {146 foreach ($arrCSVFrame as $key => $val) { 147 147 if($val['status'] != CSV_COLUMN_STATUS_FLG_ENABLE 148 148 and $val['rw_flg'] == CSV_COLUMN_RW_FLG_READ_WRITE … … 164 164 function sfIsUpdateCSVFrame(&$arrCSVFrame) { 165 165 $result = true; 166 foreach ($arrCSVFrame as $key => $val) {166 foreach ($arrCSVFrame as $key => $val) { 167 167 if($val['status'] != CSV_COLUMN_STATUS_FLG_ENABLE 168 168 and $val['rw_flg'] == CSV_COLUMN_RW_FLG_KEY_FIELD) { … … 182 182 function sfGetCSVRecordCount($fp) { 183 183 $count = 0; 184 while (!feof($fp)) {184 while (!feof($fp)) { 185 185 $arrCSV = fgetcsv($fp, CSV_LINE_MAX); 186 186 $count++; … … 224 224 @set_time_limit(0); 225 225 // ヘッダ構築 226 if (is_array($arrHeader)) {226 if (is_array($arrHeader)) { 227 227 $header = $this->sfArrayToCSV($arrHeader); 228 228 $header = mb_convert_encoding($header, 'SJIS-Win'); … … 241 241 fclose($this->fpOutput); 242 242 243 if ($is_download) {243 if ($is_download) { 244 244 // CSVを送信する。 245 245 $this->lfDownloadCSVFile($tmp_filename, $file_head . "_"); 246 246 $res = true; 247 } else{247 } else { 248 248 $res = SC_Utils_Ex::sfReadFile($tmp_filename); 249 249 } … … 265 265 */ 266 266 function sfArrayToCsv($fields, $delimiter = ',', $enclosure = '"', $arrayDelimiter = '|') { 267 if (strlen($delimiter) != 1 ) {267 if (strlen($delimiter) != 1 ) { 268 268 trigger_error('delimiter must be a single character', E_USER_WARNING); 269 269 return ""; 270 270 } 271 271 272 if (strlen($enclosure) < 1 ) {272 if (strlen($enclosure) < 1 ) { 273 273 trigger_error('enclosure must be a single character', E_USER_WARNING); 274 274 return ""; … … 304 304 function lfDownloadCsv($arrData, $prefix = ""){ 305 305 306 if ($prefix == "") {306 if ($prefix == "") { 307 307 $dir_name = SC_Utils_Ex::sfUpDirName(); 308 308 $file_name = $dir_name . date('ymdHis') .".csv";
Note: See TracChangeset
for help on using the changeset viewer.