- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_CSV.php
r21480 r21514 70 70 * @return mixed $is_download = true時 成功失敗フラグ(boolean) 、$is_downalod = false時 string 71 71 */ 72 function sfDownloadCsv($csv_id, $where = "", $arrVal = array(), $order = "", $is_download = false) {72 function sfDownloadCsv($csv_id, $where = '', $arrVal = array(), $order = '', $is_download = false) { 73 73 // 実行時間を制限しない 74 74 @set_time_limit(0); … … 92 92 }else if ($csv_id == '2') { 93 93 // 会員の場合 94 $sql = "SELECT " . $cols . " FROM dtb_customer ". $where;94 $sql = 'SELECT ' . $cols . ' FROM dtb_customer ' . $where; 95 95 }else if ($csv_id == '3') { 96 96 // 注文の場合 97 $sql = "SELECT " . $cols . " FROM dtb_order ". $where;97 $sql = 'SELECT ' . $cols . ' FROM dtb_order ' . $where; 98 98 }else if ($csv_id == '4') { 99 99 // レビューの場合 100 $sql = "SELECT " . $cols . " FROM dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id ". $where;100 $sql = 'SELECT ' . $cols . ' FROM dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id ' . $where; 101 101 }else if ($csv_id == '5') { 102 102 // カテゴリの場合 103 $sql = "SELECT " . $cols . " FROM dtb_category ". $where;103 $sql = 'SELECT ' . $cols . ' FROM dtb_category ' . $where; 104 104 } 105 105 // 固有処理ここまで … … 116 116 * @return array CSV 項目の配列 117 117 */ 118 function sfGetCsvOutput($csv_id = "", $where = '', $arrVal = array(), $order = 'rank, no') {118 function sfGetCsvOutput($csv_id = '', $where = '', $arrVal = array(), $order = 'rank, no') { 119 119 $objQuery =& SC_Query_Ex::getSingletonInstance(); 120 120 … … 123 123 124 124 if (SC_Utils_Ex::sfIsInt($csv_id)) { 125 if ($where == "") {126 $where = "csv_id = ?";125 if ($where == '') { 126 $where = 'csv_id = ?'; 127 127 } else { 128 128 $where = "$where AND csv_id = ?"; … … 147 147 if($val['status'] != CSV_COLUMN_STATUS_FLG_ENABLE 148 148 and $val['rw_flg'] == CSV_COLUMN_RW_FLG_READ_WRITE 149 and $val['error_check_types'] != ""149 and $val['error_check_types'] != '' 150 150 and strpos(strtoupper($val['error_check_types']), 'EXIST_CHECK') !== FALSE) { 151 151 //必須フィールド … … 235 235 // fopen('php://temp/maxmemory:'. (5*1024*1024), 'r+'); 236 236 $tmp_filename = tempnam(CSV_TEMP_REALDIR, $file_head . '_csv'); 237 $this->fpOutput = fopen($tmp_filename, "w+");237 $this->fpOutput = fopen($tmp_filename, 'w+'); 238 238 fwrite($this->fpOutput, $header); 239 239 $objQuery->doCallbackAll(array(&$this, 'cbOutputCSV'), $sql, $arrVal); … … 267 267 if (strlen($delimiter) != 1) { 268 268 trigger_error('delimiter must be a single character', E_USER_WARNING); 269 return "";269 return ''; 270 270 } 271 271 272 272 if (strlen($enclosure) < 1) { 273 273 trigger_error('enclosure must be a single character', E_USER_WARNING); 274 return "";274 return ''; 275 275 } 276 276 … … 302 302 * @return void 303 303 */ 304 function lfDownloadCsv($arrData, $prefix = "") {305 306 if ($prefix == "") {304 function lfDownloadCsv($arrData, $prefix = '') { 305 306 if ($prefix == '') { 307 307 $dir_name = SC_Utils_Ex::sfUpDirName(); 308 $file_name = $dir_name . date('ymdHis') . ".csv";308 $file_name = $dir_name . date('ymdHis') .'.csv'; 309 309 } else { 310 $file_name = $prefix . date('ymdHis') . ".csv";310 $file_name = $prefix . date('ymdHis') .'.csv'; 311 311 } 312 312 … … 314 314 Header("Content-disposition: attachment; filename=${file_name}"); 315 315 Header("Content-type: application/octet-stream; name=${file_name}"); 316 Header( "Cache-Control: ");317 Header( "Pragma: ");316 Header('Cache-Control: '); 317 Header('Pragma: '); 318 318 319 319 /* データを出力 */ … … 332 332 * @return void 333 333 */ 334 function lfDownloadCSVFile($filepath, $prefix = "") {335 $file_name = $prefix . date('YmdHis') . ".csv";334 function lfDownloadCSVFile($filepath, $prefix = '') { 335 $file_name = $prefix . date('YmdHis') . '.csv'; 336 336 337 337 /* HTTPヘッダの出力 */ 338 338 Header("Content-disposition: attachment; filename=${file_name}"); 339 339 Header("Content-type: application/octet-stream; name=${file_name}"); 340 Header( "Cache-Control: ");341 Header( "Pragma: ");340 Header('Cache-Control: '); 341 Header('Pragma: '); 342 342 343 343 /* データを出力 */
Note: See TracChangeset
for help on using the changeset viewer.