- Timestamp:
- 2011/03/20 07:42:06 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
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
Note: See TracChangeset
for help on using the changeset viewer.