Changeset 20734
- Timestamp:
- 2011/03/20 06:24:47 (13 years ago)
- Location:
- branches/version-2_5-dev/data/class
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/helper/SC_Helper_CSV.php
r20686 r20734 227 227 $sql = "SELECT " . $cols . " FROM dtb_customer " . $where; 228 228 229 }else if($csv_id == '5') { 230 // カテゴリの場合 231 $sql = "SELECT " . $cols . " FROM dtb_category " . $where; 229 232 } 230 233 // 固有処理ここまで … … 296 299 } 297 300 return $data; 298 }299 300 // CSVを送信する。(カテゴリ)301 function sfDownloadCategoryCsv() {302 303 // CSV出力タイトル行の作成304 $arrOutput = SC_Utils_Ex::sfSwapArray($this->sfGetCsvOutput(5, 'status = ' . CSV_COLUMN_STATUS_FLG_ENABLE));305 if (count($arrOutput) <= 0) return false; // 失敗終了306 $arrOutputCols = $arrOutput['col'];307 308 $objQuery =& SC_Query_Ex::getSingletonInstance();309 $objQuery->setOrder('rank DESC');310 311 $dataRows = $objQuery->select(312 SC_Utils_Ex::sfGetCommaList($arrOutputCols)313 ,'dtb_category'314 ,'del_flg = 0'315 );316 317 $outputArray = array();318 319 // ヘッダ行320 $outputArray[] = $arrOutput['disp_name'];321 322 // データ行323 foreach ($dataRows as $row) {324 $outputArray[] = $row;325 }326 327 // CSVを送信する。328 $this->lfDownloadCsv($outputArray, 'category');329 330 // 成功終了331 return true;332 301 } 333 302 -
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php
r20688 r20734 164 164 // CSVダウンロード 165 165 case 'csv': 166 // CSVを送信する 。正常終了の場合、終了。166 // CSVを送信する 167 167 $objCSV = new SC_Helper_CSV_Ex(); 168 $objCSV->sfDownloadCategoryCsv() && exit; 168 $objCSV->sfDownloadCsv("5", "", array(), "", true); 169 exit; 169 170 break; 170 171 default:
Note: See TracChangeset
for help on using the changeset viewer.