Changeset 18867
- Timestamp:
- 2010/10/27 00:46:48 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/admin/customer/LC_Page_Admin_Customer.php
r18853 r18867 68 68 69 69 //---- CSVダウンロード用 70 $this->arrColumnCSV = array(0 => array("sql" => "customer_id", 71 "csv" => "customer_id", 72 "header" => "顧客ID"), 73 1 => array("sql" => "name01", 74 "csv" => "name01", 75 "header" => "名前1"), 76 2 => array("sql" => "name02", 77 "csv" => "name02", 78 "header" => "名前2"), 79 3 => array("sql" => "kana01", 80 "csv" => "kana01", 81 "header" => "お名前(フリガナ・姓)"), 82 4 => array("sql" => "kana02", 83 "csv" => "kana02", 84 "header" => "お名前(フリガナ・名)"), 85 5 => array("sql" => "zip01", 86 "csv" => "zip01", 87 "header" => "郵便番号1"), 88 6 => array("sql" => "zip02", 89 "csv" => "zip02", 90 "header" => "郵便番号2"), 91 7 => array("sql" => "pref", 92 "csv" => "pref", 93 "header" => "都道府県"), 94 8 => array("sql" => "addr01", 95 "csv" => "addr01", 96 "header" => "住所1"), 97 9 => array("sql" => "addr02", 98 "csv" => "addr02", 99 "header" => "住所2"), 100 10 => array("sql" => "email", 101 "csv" => "email", 102 "header" => "E-MAIL"), 103 11 => array("sql" => "tel01", 104 "csv" => "tel01", 105 "header" => "TEL1"), 106 12 => array("sql" => "tel02", 107 "csv" => "tel02", 108 "header" => "TEL2"), 109 13 => array("sql" => "tel03", 110 "csv" => "tel03", 111 "header" => "TEL3"), 112 14 => array("sql" => "fax01", 113 "csv" => "fax01", 114 "header" => "FAX1"), 115 15 => array("sql" => "fax02", 116 "csv" => "fax02", 117 "header" => "FAX2"), 118 16 => array("sql" => "fax03", 119 "csv" => "fax03", 120 "header" => "FAX3"), 121 17 => array("sql" => "CASE WHEN sex = 1 " 122 . " THEN '男性' " 123 . " ELSE '女性' END AS sex", 124 "csv" => "sex", 125 "header" => "性別"), 126 18 => array("sql" => "job", 127 "csv" => "job", 128 "header" => "職業"), 129 19 => array("sql" => "cast(birth as date) AS birth", 130 "csv" => "birth", 131 "header" => "誕生日"), 132 20 => array("sql" => "cast(first_buy_date as date) AS first_buy_date", 133 "csv" => "first_buy_date", 134 "header" => "初回購入日"), 135 21 => array("sql" => "cast(last_buy_date as date) AS last_buy_date", 136 "csv" => "last_buy_date", 137 "header" => "最終購入日"), 138 22 => array("sql" => "buy_times", 139 "csv" => "buy_times", 140 "header" => "購入回数"), 141 23 => array("sql" => "point", 142 "csv" => "point", 143 "header" => "ポイント残高"), 144 24 => array("sql" => "note", 145 "csv" => "note", 146 "header" => "備考"), 147 25 => array("sql" => "cast(create_date as date) AS create_date", 148 "csv" => "create_date", 149 "header" => "登録日"), 150 26 => array("sql" => "cast(update_date as date) AS update_date", 151 "csv" => "update_date", 152 "header" => "更新日") 153 ); 70 $this->arrColumnCSV = array( 71 array( 72 "sql" => "customer_id", 73 "csv" => "customer_id", 74 "header" => "顧客ID" 75 ), 76 array( 77 "sql" => "name01", 78 "csv" => "name01", 79 "header" => "名前1" 80 ), 81 array( 82 "sql" => "name02", 83 "csv" => "name02", 84 "header" => "名前2" 85 ), 86 array( 87 "sql" => "kana01", 88 "csv" => "kana01", 89 "header" => "お名前(フリガナ・姓)" 90 ), 91 array( 92 "sql" => "kana02", 93 "csv" => "kana02", 94 "header" => "お名前(フリガナ・名)" 95 ), 96 array( 97 "sql" => "zip01", 98 "csv" => "zip01", 99 "header" => "郵便番号1" 100 ), 101 array( 102 "sql" => "zip02", 103 "csv" => "zip02", 104 "header" => "郵便番号2" 105 ), 106 array( 107 "sql" => "pref", 108 "csv" => "pref", 109 "header" => "都道府県" 110 ), 111 array( 112 "sql" => "addr01", 113 "csv" => "addr01", 114 "header" => "住所1" 115 ), 116 array( 117 "sql" => "addr02", 118 "csv" => "addr02", 119 "header" => "住所2" 120 ), 121 array( 122 "sql" => "email", 123 "csv" => "email", 124 "header" => "E-MAIL" 125 ), 126 array( 127 "sql" => "tel01", 128 "csv" => "tel01", 129 "header" => "TEL1" 130 ), 131 array( 132 "sql" => "tel02", 133 "csv" => "tel02", 134 "header" => "TEL2" 135 ), 136 array( 137 "sql" => "tel03", 138 "csv" => "tel03", 139 "header" => "TEL3" 140 ), 141 array( 142 "sql" => "fax01", 143 "csv" => "fax01", 144 "header" => "FAX1" 145 ), 146 array( 147 "sql" => "fax02", 148 "csv" => "fax02", 149 "header" => "FAX2" 150 ), 151 array( 152 "sql" => "fax03", 153 "csv" => "fax03", 154 "header" => "FAX3" 155 ), 156 array( 157 "sql" => "CASE WHEN sex = 1 THEN '男性' ELSE '女性' END AS sex", 158 "csv" => "sex", 159 "header" => "性別" 160 ), 161 array( 162 "sql" => "job", 163 "csv" => "job", 164 "header" => "職業" 165 ), 166 array( 167 "sql" => "cast(birth as date) AS birth", 168 "csv" => "birth", 169 "header" => "誕生日" 170 ), 171 array( 172 "sql" => "cast(first_buy_date as date) AS first_buy_date", 173 "csv" => "first_buy_date", 174 "header" => "初回購入日" 175 ), 176 array( 177 "sql" => "cast(last_buy_date as date) AS last_buy_date", 178 "csv" => "last_buy_date", 179 "header" => "最終購入日" 180 ), 181 array( 182 "sql" => "buy_times", 183 "csv" => "buy_times", 184 "header" => "購入回数" 185 ), 186 array( 187 "sql" => "point", 188 "csv" => "point", 189 "header" => "ポイント残高" 190 ), 191 array( 192 "sql" => "note", 193 "csv" => "note", 194 "header" => "備考" 195 ), 196 array( 197 "sql" => "cast(create_date as date) AS create_date", 198 "csv" => "create_date", 199 "header" => "登録日" 200 ), 201 array( 202 "sql" => "cast(update_date as date) AS update_date", 203 "csv" => "update_date", 204 "header" => "更新日" 205 ), 206 ); 154 207 $this->httpCacheControl('nocache'); 155 208 }
Note: See TracChangeset
for help on using the changeset viewer.
