- 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.php
r21480 r21481 52 52 53 53 $masterData = new SC_DB_MasterData_Ex(); 54 $this->arrORDERSTATUS = $masterData->getMasterData( "mtb_order_status");55 $this->arrORDERSTATUS_COLOR = $masterData->getMasterData( "mtb_order_status_color");56 $this->arrSex = $masterData->getMasterData( "mtb_sex");57 $this->arrPageMax = $masterData->getMasterData( "mtb_page_max");54 $this->arrORDERSTATUS = $masterData->getMasterData('mtb_order_status'); 55 $this->arrORDERSTATUS_COLOR = $masterData->getMasterData('mtb_order_status_color'); 56 $this->arrSex = $masterData->getMasterData('mtb_sex'); 57 $this->arrPageMax = $masterData->getMasterData('mtb_page_max'); 58 58 59 59 $objDate = new SC_Date_Ex(); … … 71 71 72 72 // 支払い方法の取得 73 $this->arrPayments = SC_Helper_DB_Ex::sfGetIDValueList( "dtb_payment", "payment_id", "payment_method");73 $this->arrPayments = SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method'); 74 74 75 75 $this->httpCacheControl('nocache'); … … 180 180 */ 181 181 function lfInitParam(&$objFormParam) { 182 $objFormParam->addParam("注文番号1", "search_order_id1", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));183 $objFormParam->addParam("注文番号2", "search_order_id2", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));184 $objFormParam->addParam("対応状況", "search_order_status", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));185 $objFormParam->addParam("注文者 お名前", "search_order_name", STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));186 $objFormParam->addParam("注文者 お名前(フリガナ)", "search_order_kana", STEXT_LEN, 'KVCa', array('KANA_CHECK','MAX_LENGTH_CHECK'));187 $objFormParam->addParam("性別", "search_order_sex", INT_LEN, 'n', array('MAX_LENGTH_CHECK'));188 $objFormParam->addParam("年齢1", "search_age1", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));189 $objFormParam->addParam("年齢2", "search_age2", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));190 $objFormParam->addParam("メールアドレス", "search_order_email", STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));191 $objFormParam->addParam('TEL', "search_order_tel", STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));192 $objFormParam->addParam("支払い方法", "search_payment_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));193 $objFormParam->addParam("購入金額1", "search_total1", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));194 $objFormParam->addParam("購入金額2", "search_total2", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));195 $objFormParam->addParam("表示件数", "search_page_max", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));182 $objFormParam->addParam("注文番号1", 'search_order_id1', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 183 $objFormParam->addParam("注文番号2", 'search_order_id2', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 184 $objFormParam->addParam("対応状況", 'search_order_status', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 185 $objFormParam->addParam("注文者 お名前", 'search_order_name', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 186 $objFormParam->addParam("注文者 お名前(フリガナ)", 'search_order_kana', STEXT_LEN, 'KVCa', array('KANA_CHECK','MAX_LENGTH_CHECK')); 187 $objFormParam->addParam("性別", 'search_order_sex', INT_LEN, 'n', array('MAX_LENGTH_CHECK')); 188 $objFormParam->addParam("年齢1", 'search_age1', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 189 $objFormParam->addParam("年齢2", 'search_age2', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 190 $objFormParam->addParam("メールアドレス", 'search_order_email', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 191 $objFormParam->addParam('TEL', 'search_order_tel', STEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 192 $objFormParam->addParam("支払い方法", 'search_payment_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 193 $objFormParam->addParam("購入金額1", 'search_total1', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 194 $objFormParam->addParam("購入金額2", 'search_total2', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 195 $objFormParam->addParam("表示件数", 'search_page_max', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 196 196 // 受注日 197 $objFormParam->addParam("開始年", "search_sorderyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));198 $objFormParam->addParam("開始月", "search_sordermonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));199 $objFormParam->addParam("開始日", "search_sorderday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));200 $objFormParam->addParam("終了年", "search_eorderyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));201 $objFormParam->addParam("終了月", "search_eordermonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));202 $objFormParam->addParam("終了日", "search_eorderday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));197 $objFormParam->addParam("開始年", 'search_sorderyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 198 $objFormParam->addParam("開始月", 'search_sordermonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 199 $objFormParam->addParam("開始日", 'search_sorderday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 200 $objFormParam->addParam("終了年", 'search_eorderyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 201 $objFormParam->addParam("終了月", 'search_eordermonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 202 $objFormParam->addParam("終了日", 'search_eorderday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 203 203 // 更新日 204 $objFormParam->addParam("開始年", "search_supdateyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));205 $objFormParam->addParam("開始月", "search_supdatemonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));206 $objFormParam->addParam("開始日", "search_supdateday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));207 $objFormParam->addParam("終了年", "search_eupdateyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));208 $objFormParam->addParam("終了月", "search_eupdatemonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));209 $objFormParam->addParam("終了日", "search_eupdateday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));204 $objFormParam->addParam("開始年", 'search_supdateyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 205 $objFormParam->addParam("開始月", 'search_supdatemonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 206 $objFormParam->addParam("開始日", 'search_supdateday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 207 $objFormParam->addParam("終了年", 'search_eupdateyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 208 $objFormParam->addParam("終了月", 'search_eupdatemonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 209 $objFormParam->addParam("終了日", 'search_eupdateday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 210 210 // 生年月日 211 $objFormParam->addParam("開始年", "search_sbirthyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));212 $objFormParam->addParam("開始月", "search_sbirthmonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));213 $objFormParam->addParam("開始日", "search_sbirthday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));214 $objFormParam->addParam("終了年", "search_ebirthyear", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));215 $objFormParam->addParam("終了月", "search_ebirthmonth", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));216 $objFormParam->addParam("終了日", "search_ebirthday", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));217 $objFormParam->addParam("購入商品", "search_product_name",STEXT_LEN,'KVa',array('MAX_LENGTH_CHECK'));218 $objFormParam->addParam("ページ送り番号", "search_pageno", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));219 $objFormParam->addParam("受注ID", "order_id", INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK'));211 $objFormParam->addParam("開始年", 'search_sbirthyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 212 $objFormParam->addParam("開始月", 'search_sbirthmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 213 $objFormParam->addParam("開始日", 'search_sbirthday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 214 $objFormParam->addParam("終了年", 'search_ebirthyear', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 215 $objFormParam->addParam("終了月", 'search_ebirthmonth', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 216 $objFormParam->addParam("終了日", 'search_ebirthday', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 217 $objFormParam->addParam("購入商品",'search_product_name',STEXT_LEN,'KVa',array('MAX_LENGTH_CHECK')); 218 $objFormParam->addParam("ページ送り番号",'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 219 $objFormParam->addParam("受注ID", 'order_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK', 'NUM_CHECK')); 220 220 } 221 221 … … 231 231 232 232 // 相関チェック 233 $objErr->doFunc(array("注文番号1", "注文番号2", "search_order_id1", "search_order_id2"), array('GREATER_CHECK'));234 $objErr->doFunc(array("年齢1", "年齢2", "search_age1", "search_age2"), array('GREATER_CHECK'));235 $objErr->doFunc(array("購入金額1", "購入金額2", "search_total1", "search_total2"), array('GREATER_CHECK'));233 $objErr->doFunc(array("注文番号1", "注文番号2", 'search_order_id1', 'search_order_id2'), array('GREATER_CHECK')); 234 $objErr->doFunc(array("年齢1", "年齢2", 'search_age1', 'search_age2'), array('GREATER_CHECK')); 235 $objErr->doFunc(array("購入金額1", "購入金額2", 'search_total1', 'search_total2'), array('GREATER_CHECK')); 236 236 // 受注日 237 $objErr->doFunc(array("開始", "search_sorderyear", "search_sordermonth", "search_sorderday"), array('CHECK_DATE'));238 $objErr->doFunc(array("終了", "search_eorderyear", "search_eordermonth", "search_eorderday"), array('CHECK_DATE'));239 $objErr->doFunc(array("開始", "終了", "search_sorderyear", "search_sordermonth", "search_sorderday", "search_eorderyear", "search_eordermonth", "search_eorderday"), array('CHECK_SET_TERM'));237 $objErr->doFunc(array("開始", 'search_sorderyear', 'search_sordermonth', 'search_sorderday'), array('CHECK_DATE')); 238 $objErr->doFunc(array("終了", 'search_eorderyear', 'search_eordermonth', 'search_eorderday'), array('CHECK_DATE')); 239 $objErr->doFunc(array("開始", "終了", 'search_sorderyear', 'search_sordermonth', 'search_sorderday', 'search_eorderyear', 'search_eordermonth', 'search_eorderday'), array('CHECK_SET_TERM')); 240 240 // 更新日 241 $objErr->doFunc(array("開始", "search_supdateyear", "search_supdatemonth", "search_supdateday"), array('CHECK_DATE'));242 $objErr->doFunc(array("終了", "search_eupdateyear", "search_eupdatemonth", "search_eupdateday"), array('CHECK_DATE'));243 $objErr->doFunc(array("開始", "終了", "search_supdateyear", "search_supdatemonth", "search_supdateday", "search_eupdateyear", "search_eupdatemonth", "search_eupdateday"), array('CHECK_SET_TERM'));241 $objErr->doFunc(array("開始", 'search_supdateyear', 'search_supdatemonth', 'search_supdateday'), array('CHECK_DATE')); 242 $objErr->doFunc(array("終了", 'search_eupdateyear', 'search_eupdatemonth', 'search_eupdateday'), array('CHECK_DATE')); 243 $objErr->doFunc(array("開始", "終了", 'search_supdateyear', 'search_supdatemonth', 'search_supdateday', 'search_eupdateyear', 'search_eupdatemonth', 'search_eupdateday'), array('CHECK_SET_TERM')); 244 244 // 生年月日 245 $objErr->doFunc(array("開始", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday"), array('CHECK_DATE'));246 $objErr->doFunc(array("終了", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array('CHECK_DATE'));247 $objErr->doFunc(array("開始", "終了", "search_sbirthyear", "search_sbirthmonth", "search_sbirthday", "search_ebirthyear", "search_ebirthmonth", "search_ebirthday"), array('CHECK_SET_TERM'));245 $objErr->doFunc(array("開始", 'search_sbirthyear', 'search_sbirthmonth', 'search_sbirthday'), array('CHECK_DATE')); 246 $objErr->doFunc(array("終了", 'search_ebirthyear', 'search_ebirthmonth', 'search_ebirthday'), array('CHECK_DATE')); 247 $objErr->doFunc(array("開始", "終了", 'search_sbirthyear', 'search_sbirthmonth', 'search_sbirthday', 'search_ebirthyear', 'search_ebirthmonth', 'search_ebirthday'), array('CHECK_SET_TERM')); 248 248 249 249 return $objErr->arrErr; … … 273 273 break; 274 274 case 'search_order_name': 275 $where .= " AND " . $dbFactory->concatColumn(array( "order_name01", "order_name02")) . " LIKE ?";275 $where .= " AND " . $dbFactory->concatColumn(array('order_name01', 'order_name02')) . " LIKE ?"; 276 276 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 277 277 break; 278 278 case 'search_order_kana': 279 $where .= " AND " . $dbFactory->concatColumn(array( "order_kana01", "order_kana02")) . " LIKE ?";279 $where .= " AND " . $dbFactory->concatColumn(array('order_kana01', 'order_kana02')) . " LIKE ?"; 280 280 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 281 281 break; … … 307 307 break; 308 308 case 'search_order_tel': 309 $where .= " AND (" . $dbFactory->concatColumn(array( "order_tel01", "order_tel02", "order_tel03")) . " LIKE ?)";309 $where .= " AND (" . $dbFactory->concatColumn(array('order_tel01', 'order_tel02', 'order_tel03')) . " LIKE ?)"; 310 310 $arrValues[] = sprintf('%%%d%%', preg_replace('/[()-]+/','', $objFormParam->getValue($key))); 311 311 break; … … 401 401 $sqlval['del_flg'] = 1; 402 402 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 403 $objQuery->update( "dtb_order", $sqlval, $where, $arrParam);403 $objQuery->update('dtb_order', $sqlval, $where, $arrParam); 404 404 } 405 405 … … 422 422 423 423 $objCSV = new SC_Helper_CSV_Ex(); 424 $objCSV->sfDownloadCsv( "3", $where, $arrVal, $order, true);424 $objCSV->sfDownloadCsv('3', $where, $arrVal, $order, true); 425 425 } 426 426
Note: See TracChangeset
for help on using the changeset viewer.