Changeset 20735 for branches/version-2_5-dev
- Timestamp:
- 2011/03/20 07:42:06 (13 years ago)
- Location:
- branches/version-2_5-dev
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/Smarty/templates/admin/contents/subnavi.tpl
r20680 r20735 32 32 <li<!--{if $tpl_subno_csv == 'order'}--> class="on"<!--{/if}--> id="navi-csv-order"><a href="<!--{$smarty.const.ROOT_URLPATH}--><!--{$smarty.const.ADMIN_DIR}-->contents/csv.php?tpl_subno_csv=order"><span>受注管理</span></a></li> 33 33 <li<!--{if $tpl_subno_csv == 'category'}--> class="on"<!--{/if}--> id="navi-csv-category"><a href="<!--{$smarty.const.ROOT_URLPATH}--><!--{$smarty.const.ADMIN_DIR}-->contents/csv.php?tpl_subno_csv=category"><span>カテゴリ</span></a></li> 34 <li<!--{if $tpl_subno_csv == 'review'}--> class="on"<!--{/if}--> id="navi-csv-review"><a href="<!--{$smarty.const.ROOT_URLPATH}--><!--{$smarty.const.ADMIN_DIR}-->contents/csv.php?tpl_subno_csv=review"><span>レビュー</span></a></li> 34 35 <li<!--{if $tpl_subno_csv == 'csv_sql'}--> class="on"<!--{/if}--> id="navi-csv-sql"><a href="<!--{$smarty.const.ROOT_URLPATH}--><!--{$smarty.const.ADMIN_DIR}-->contents/csv_sql.php"><span>高度な設定</span></a></li> 35 36 </ul> -
branches/version-2_5-dev/data/class/helper/SC_Helper_CSV.php
r20734 r20735 59 59 2 => 'customer', 60 60 3 => 'order', 61 4 => 'review', 61 62 5 => 'category' 62 63 ); … … 66 67 2 => '顧客管理', 67 68 3 => '受注管理', 69 4 => 'レビュー', 68 70 5 => 'カテゴリ' 69 71 ); 70 71 $this->arrREVIEW_CVSCOL = array(72 'B.name',73 'A.status',74 'A.create_date',75 'A.reviewer_name',76 'A.sex',77 'A.recommend_level',78 'A.title',79 'A.comment'80 );81 82 $this->arrREVIEW_CVSTITLE = array(83 '商品名',84 'レビュー表示',85 '投稿日',86 '投稿者名',87 '性別',88 'おすすめレベル',89 'タイトル',90 'コメント'91 );92 72 } 93 73 … … 226 206 // 顧客の場合 227 207 $sql = "SELECT " . $cols . " FROM dtb_customer " . $where; 228 208 }else if($csv_id == '3') { 209 // 注文の場合 210 $sql = "SELECT " . $cols . " FROM dtb_order " . $where; 211 }else if($csv_id == '4') { 212 // レビューの場合 213 $sql = "SELECT " . $cols . " FROM dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id " . $where; 229 214 }else if($csv_id == '5') { 230 215 // カテゴリの場合 … … 279 264 unlink($tmp_filename); 280 265 return $res; 281 }282 283 // CSV出力データを作成する。(レビュー)284 function lfGetReviewCSV($where, $option, $arrval) {285 286 $from = "dtb_review AS A INNER JOIN dtb_products AS B on A.product_id = B.product_id ";287 $cols = SC_Utils_Ex::sfGetCommaList($this->arrREVIEW_CVSCOL);288 289 $objQuery =& SC_Query_Ex::getSingletonInstance();290 $objQuery->setOption($option);291 292 $list_data = $objQuery->select($cols, $from, $where, $arrval);293 294 $max = count($list_data);295 if (!isset($data)) $data = "";296 for($i = 0; $i < $max; $i++) {297 // 各項目をCSV出力用に変換する。298 $data .= $this->lfMakeReviewCSV($list_data[$i]);299 }300 return $data;301 266 } 302 267 -
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Review.php
r20541 r20735 113 113 //CSVダウンロード 114 114 if ($this->getMode() == 'csv') { 115 $this->lf Csv($where, $arrval);115 $this->lfDoOutputCsv($where, $arrval); 116 116 exit; 117 117 } … … 232 232 * @return void 233 233 */ 234 function lf Csv($where, $arrval) {234 function lfDoOutputCsv($where, $arrVal) { 235 235 $objCSV = new SC_Helper_CSV_Ex(); 236 // CSV出力タイトル行の作成 237 $head = SC_Utils_Ex::sfGetCSVList($objCSV->arrREVIEW_CVSTITLE); 238 $data = $objCSV->lfGetReviewCSV($where, '', $arrval); 239 // CSVを送信する。 240 list($fime_name, $data) = SC_Utils_Ex::sfGetCSVData($head.$data); 241 $this->sendResponseCSV($fime_name, $data); 236 if($where != ""){ 237 $where = "WHERE " . $where; 238 } 239 $objCSV->sfDownloadCsv("4", $where, $arrVal, "", true); 242 240 } 243 241 -
branches/version-2_5-dev/html/install/sql/insert_data.sql
r20733 r20735 282 282 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (153, 3, 'status', '対応状況', 51, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 283 283 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (154, 3, 'create_date', '注文日時', 52, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE'); 284 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (155, 3, ' create_date', '更新日時', 53, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE');284 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (155, 3, 'update_date', '更新日時', 53, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE'); 285 285 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (156, 3, 'commit_date', '発送完了日時', 54, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE'); 286 286 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (157, 3, 'device_type_id', '端末種別ID', 55, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); … … 288 288 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (159, 3, '(SELECT ARRAY_TO_STRING(ARRAY(SELECT shipping_id FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id), '','')) as shipping_ids', '配送情報ID', 57, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'SPTAB_CHECK,MAX_LENGTH_CHECK'); 289 289 290 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (180, 4, 'B.name', '商品名', 1, 2, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); 291 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (181, 4, '(SELECT name FROM mtb_disp WHERE mtb_disp.id = A.status) as status', 'レビュー表示', 2, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); 292 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (182, 4, 'A.create_date', '投稿日', 3, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'a', '', 'CHECK_DATE,EXIST_CHECK'); 293 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (183, 4, 'A.reviewer_name', '投稿者名', 4, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); 294 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (184, 4, '(SELECT name FROM mtb_sex WHERE mtb_sex.id = A.sex) as sex', '性別', 5, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); 295 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (185, 4, '(SELECT name FROM mtb_recommend WHERE mtb_recommend.id = A.recommend_level) as recommend_level', 'おすすめレベル', 6, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK'); 296 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (186, 4, 'A.title', 'タイトル', 7, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'STEXT_LEN', 'MAX_LENGTH_CHECK'); 297 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (187, 4, 'A.comment', 'コメント', 8, 1, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'KVa', 'LTEXT_LEN', 'MAX_LENGTH_CHECK'); 290 298 291 299 INSERT INTO dtb_csv (no, csv_id, col, disp_name, rank, rw_flg, status, create_date, update_date, mb_convert_kana_option, size_const_type, error_check_types) VALUES (195, 5, 'category_id', 'カテゴリID', 1, 3, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'n', 'INT_LEN', 'NUM_CHECK,MAX_LENGTH_CHECK');
Note: See TracChangeset
for help on using the changeset viewer.