Changeset 21481 for branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order_Disp.php
- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order_Disp.php
r21480 r21481 85 85 $masterData = new SC_DB_MasterData_Ex(); 86 86 $this->arrPref = $masterData->getMasterData('mtb_pref'); 87 $this->arrORDERSTATUS = $masterData->getMasterData( "mtb_order_status");87 $this->arrORDERSTATUS = $masterData->getMasterData('mtb_order_status'); 88 88 $this->arrDeviceType = $masterData->getMasterData('mtb_device_type'); 89 89 90 90 // 支払い方法の取得 91 $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList( "dtb_payment", "payment_id", "payment_method");91 $this->arrPayment = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method'); 92 92 93 93 // 配送業者の取得 94 $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList( "dtb_deliv", "deliv_id", 'name');94 $this->arrDeliv = SC_Helper_DB_Ex::sfGetIDValueList('dtb_deliv', 'deliv_id', 'name'); 95 95 } 96 96 … … 150 150 151 151 // お客様情報 152 $objFormParam->addParam("会員名1", "order_name01", STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));153 $objFormParam->addParam("会員名2", "order_name02", STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));154 $objFormParam->addParam("会員名カナ1", "order_kana01", STEXT_LEN, 'KVCa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));155 $objFormParam->addParam("会員名カナ2", "order_kana02", STEXT_LEN, 'KVCa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));156 $objFormParam->addParam("メールアドレス", "order_email", null, 'KVCa', array('NO_SPTAB', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK'));157 $objFormParam->addParam("郵便番号1", "order_zip01", ZIP01_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK'));158 $objFormParam->addParam("郵便番号2", "order_zip02", ZIP02_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK'));159 $objFormParam->addParam("都道府県", "order_pref", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));160 $objFormParam->addParam("住所1", "order_addr01", MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));161 $objFormParam->addParam("住所2", "order_addr02", MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));162 $objFormParam->addParam("電話番号1", "order_tel01", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));163 $objFormParam->addParam("電話番号2", "order_tel02", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));164 $objFormParam->addParam("電話番号3", "order_tel03", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));152 $objFormParam->addParam("会員名1", 'order_name01', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 153 $objFormParam->addParam("会員名2", 'order_name02', STEXT_LEN, 'KVa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 154 $objFormParam->addParam("会員名カナ1", 'order_kana01', STEXT_LEN, 'KVCa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 155 $objFormParam->addParam("会員名カナ2", 'order_kana02', STEXT_LEN, 'KVCa', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 156 $objFormParam->addParam("メールアドレス", 'order_email', null, 'KVCa', array('NO_SPTAB', 'EMAIL_CHECK', 'EMAIL_CHAR_CHECK')); 157 $objFormParam->addParam("郵便番号1", 'order_zip01', ZIP01_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK')); 158 $objFormParam->addParam("郵便番号2", 'order_zip02', ZIP02_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK')); 159 $objFormParam->addParam("都道府県", 'order_pref', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 160 $objFormParam->addParam("住所1", 'order_addr01', MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 161 $objFormParam->addParam("住所2", 'order_addr02', MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 162 $objFormParam->addParam("電話番号1", 'order_tel01', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 163 $objFormParam->addParam("電話番号2", 'order_tel02', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 164 $objFormParam->addParam("電話番号3", 'order_tel03', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 165 165 166 166 // 受注商品情報 167 167 $objFormParam->addParam("値引き", 'discount', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 168 $objFormParam->addParam("送料", "deliv_fee", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');168 $objFormParam->addParam("送料", 'deliv_fee', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 169 169 $objFormParam->addParam("手数料", 'charge', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 170 170 171 171 // ポイント機能ON時のみ 172 172 if (USE_POINT !== false) { 173 $objFormParam->addParam("利用ポイント", "use_point", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'));173 $objFormParam->addParam("利用ポイント", 'use_point', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK')); 174 174 } 175 175 176 $objFormParam->addParam("配送業者", "deliv_id", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'));177 $objFormParam->addParam("お支払い方法", "payment_id", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'));176 $objFormParam->addParam("配送業者", 'deliv_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK')); 177 $objFormParam->addParam("お支払い方法", 'payment_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK')); 178 178 $objFormParam->addParam("対応状況", 'status', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK')); 179 $objFormParam->addParam("お支払方法名称", "payment_method");179 $objFormParam->addParam("お支払方法名称", 'payment_method'); 180 180 181 181 // 受注詳細情報 182 $objFormParam->addParam("商品種別ID", "product_type_id", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');182 $objFormParam->addParam("商品種別ID", 'product_type_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 183 183 $objFormParam->addParam("単価", 'price', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 184 184 $objFormParam->addParam("数量", 'quantity', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 185 $objFormParam->addParam("商品ID", "product_id", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');186 $objFormParam->addParam("商品規格ID", "product_class_id", INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');187 $objFormParam->addParam("ポイント付与率", "point_rate");188 $objFormParam->addParam("商品コード", "product_code");189 $objFormParam->addParam("商品名", "product_name");190 $objFormParam->addParam("規格名1", "classcategory_name1");191 $objFormParam->addParam("規格名2", "classcategory_name2");185 $objFormParam->addParam("商品ID", 'product_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 186 $objFormParam->addParam("商品規格ID", 'product_class_id', INT_LEN, 'n', array('EXIST_CHECK', 'MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 187 $objFormParam->addParam("ポイント付与率", 'point_rate'); 188 $objFormParam->addParam("商品コード", 'product_code'); 189 $objFormParam->addParam("商品名", 'product_name'); 190 $objFormParam->addParam("規格名1", 'classcategory_name1'); 191 $objFormParam->addParam("規格名2", 'classcategory_name2'); 192 192 $objFormParam->addParam("メモ", 'note', MTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 193 $objFormParam->addParam("削除用項番", "delete_no", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));193 $objFormParam->addParam("削除用項番", 'delete_no', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 194 194 195 195 // DB読込用 196 196 $objFormParam->addParam("小計", 'subtotal'); 197 197 $objFormParam->addParam("合計", 'total'); 198 $objFormParam->addParam("支払い合計", "payment_total");199 $objFormParam->addParam("加算ポイント", "add_point");200 $objFormParam->addParam("お誕生日ポイント", "birth_point");198 $objFormParam->addParam("支払い合計", 'payment_total'); 199 $objFormParam->addParam("加算ポイント", 'add_point'); 200 $objFormParam->addParam("お誕生日ポイント", 'birth_point'); 201 201 $objFormParam->addParam("消費税合計", 'tax'); 202 $objFormParam->addParam("最終保持ポイント", "total_point");203 $objFormParam->addParam("会員ID", "customer_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');204 $objFormParam->addParam("会員ID", "edit_customer_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');205 $objFormParam->addParam("現在のポイント", "customer_point");202 $objFormParam->addParam("最終保持ポイント", 'total_point'); 203 $objFormParam->addParam("会員ID", 'customer_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 204 $objFormParam->addParam("会員ID", 'edit_customer_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 205 $objFormParam->addParam("現在のポイント", 'customer_point'); 206 206 $objFormParam->addParam("受注前ポイント", 'point'); 207 $objFormParam->addParam("注文番号", "order_id");208 $objFormParam->addParam("受注日", "create_date");209 $objFormParam->addParam("発送日", "commit_date");207 $objFormParam->addParam("注文番号", 'order_id'); 208 $objFormParam->addParam("受注日", 'create_date'); 209 $objFormParam->addParam("発送日", 'commit_date'); 210 210 $objFormParam->addParam("備考", 'message'); 211 $objFormParam->addParam("入金日", "payment_date");212 $objFormParam->addParam("端末種別", "device_type_id");211 $objFormParam->addParam("入金日", 'payment_date'); 212 $objFormParam->addParam("端末種別", 'device_type_id'); 213 213 214 214 // 複数情報 215 $objFormParam->addParam("配送数", "shipping_quantity", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), 1);216 $objFormParam->addParam("配送ID", "shipping_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), 0);217 $objFormParam->addParam("お名前1", "shipping_name01", STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));218 $objFormParam->addParam("お名前2", "shipping_name02", STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));219 $objFormParam->addParam("お名前(フリガナ・姓)", "shipping_kana01", STEXT_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));220 $objFormParam->addParam("お名前(フリガナ・名)", "shipping_kana02", STEXT_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));221 $objFormParam->addParam("郵便番号1", "shipping_zip01", ZIP01_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK'));222 $objFormParam->addParam("郵便番号2", "shipping_zip02", ZIP02_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK'));223 $objFormParam->addParam("都道府県", "shipping_pref", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));224 $objFormParam->addParam("住所1", "shipping_addr01", MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));225 $objFormParam->addParam("住所2", "shipping_addr02", MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));226 $objFormParam->addParam("電話番号1", "shipping_tel01", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));227 $objFormParam->addParam("電話番号2", "shipping_tel02", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));228 $objFormParam->addParam("電話番号3", "shipping_tel03", TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK'));229 $objFormParam->addParam("お届け時間ID", "time_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));230 $objFormParam->addParam("お届け日(年)", "shipping_date_year", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));231 $objFormParam->addParam("お届け日(月)", "shipping_date_month", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));232 $objFormParam->addParam("お届け日(日)", "shipping_date_day", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));233 $objFormParam->addParam("お届け日", "shipping_date", STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));234 $objFormParam->addParam("配送商品数量", "shipping_product_quantity", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));235 236 $objFormParam->addParam("商品規格ID", "shipment_product_class_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));237 $objFormParam->addParam("商品コード", "shipment_product_code");238 $objFormParam->addParam("商品名", "shipment_product_name");239 $objFormParam->addParam("規格名1", "shipment_classcategory_name1");240 $objFormParam->addParam("規格名2", "shipment_classcategory_name2");241 $objFormParam->addParam("単価", "shipment_price", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');242 $objFormParam->addParam("数量", "shipment_quantity", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0');215 $objFormParam->addParam("配送数", 'shipping_quantity', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), 1); 216 $objFormParam->addParam("配送ID", 'shipping_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), 0); 217 $objFormParam->addParam("お名前1", 'shipping_name01', STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 218 $objFormParam->addParam("お名前2", 'shipping_name02', STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 219 $objFormParam->addParam("お名前(フリガナ・姓)", 'shipping_kana01', STEXT_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 220 $objFormParam->addParam("お名前(フリガナ・名)", 'shipping_kana02', STEXT_LEN, 'KVCa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 221 $objFormParam->addParam("郵便番号1", 'shipping_zip01', ZIP01_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK')); 222 $objFormParam->addParam("郵便番号2", 'shipping_zip02', ZIP02_LEN, 'n', array('NUM_CHECK', 'NUM_COUNT_CHECK')); 223 $objFormParam->addParam("都道府県", 'shipping_pref', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 224 $objFormParam->addParam("住所1", 'shipping_addr01', MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 225 $objFormParam->addParam("住所2", 'shipping_addr02', MTEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 226 $objFormParam->addParam("電話番号1", 'shipping_tel01', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 227 $objFormParam->addParam("電話番号2", 'shipping_tel02', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 228 $objFormParam->addParam("電話番号3", 'shipping_tel03', TEL_ITEM_LEN, 'n', array('MAX_LENGTH_CHECK' ,'NUM_CHECK')); 229 $objFormParam->addParam("お届け時間ID", 'time_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 230 $objFormParam->addParam("お届け日(年)", 'shipping_date_year', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 231 $objFormParam->addParam("お届け日(月)", 'shipping_date_month', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 232 $objFormParam->addParam("お届け日(日)", 'shipping_date_day', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 233 $objFormParam->addParam("お届け日", 'shipping_date', STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 234 $objFormParam->addParam("配送商品数量", 'shipping_product_quantity', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 235 236 $objFormParam->addParam("商品規格ID", 'shipment_product_class_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 237 $objFormParam->addParam("商品コード", 'shipment_product_code'); 238 $objFormParam->addParam("商品名", 'shipment_product_name'); 239 $objFormParam->addParam("規格名1", 'shipment_classcategory_name1'); 240 $objFormParam->addParam("規格名2", 'shipment_classcategory_name2'); 241 $objFormParam->addParam("単価", 'shipment_price', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 242 $objFormParam->addParam("数量", 'shipment_quantity', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'), '0'); 243 243 244 244 $objFormParam->addParam("商品項番", 'no', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 245 $objFormParam->addParam("追加商品規格ID", "add_product_class_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));246 $objFormParam->addParam("修正商品規格ID", "edit_product_class_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));247 $objFormParam->addParam("アンカーキー", "anchor_key", STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK'));245 $objFormParam->addParam("追加商品規格ID", 'add_product_class_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 246 $objFormParam->addParam("修正商品規格ID", 'edit_product_class_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 247 $objFormParam->addParam("アンカーキー", 'anchor_key', STEXT_LEN, 'KVa', array('SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 248 248 } 249 249 … … 266 266 foreach ($arrShippingsTmp as $row) { 267 267 // お届け日の処理 268 if (!SC_Utils_Ex::isBlank($row[ "shipping_date"])) {269 $ts = strtotime($row[ "shipping_date"]);268 if (!SC_Utils_Ex::isBlank($row['shipping_date'])) { 269 $ts = strtotime($row['shipping_date']); 270 270 $row['shipping_date_year'] = date('Y', $ts); 271 271 $row['shipping_date_month'] = date('n', $ts);
Note: See TracChangeset
for help on using the changeset viewer.