- Timestamp:
- 2012/02/15 19:56:17 (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
r21490 r21514 117 117 118 118 if (count($this->arrErr) == 0) { 119 $where = "del_flg = 0";119 $where = 'del_flg = 0'; 120 120 foreach ($arrParam as $key => $val) { 121 if ($val == "") {121 if ($val == '') { 122 122 continue; 123 123 } … … 125 125 } 126 126 127 $order = "update_date DESC";127 $order = 'update_date DESC'; 128 128 129 129 /* ----------------------------------------------- … … 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'));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 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'));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; … … 269 269 270 270 case 'search_product_name': 271 $where .= " AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)";271 $where .= ' AND EXISTS (SELECT 1 FROM dtb_order_detail od WHERE od.order_id = dtb_order.order_id AND od.product_name LIKE ?)'; 272 272 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 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; 282 282 case 'search_order_id1': 283 $where .= " AND order_id >= ?";283 $where .= ' AND order_id >= ?'; 284 284 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 285 285 break; 286 286 case 'search_order_id2': 287 $where .= " AND order_id <= ?";287 $where .= ' AND order_id <= ?'; 288 288 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 289 289 break; 290 290 case 'search_order_sex': 291 $tmp_where = "";291 $tmp_where = ''; 292 292 foreach ($objFormParam->getValue($key) as $element) { 293 if ($element != "") {293 if ($element != '') { 294 294 if (SC_Utils_Ex::isBlank($tmp_where)) { 295 $tmp_where .= " AND (order_sex = ?";295 $tmp_where .= ' AND (order_sex = ?'; 296 296 } else { 297 $tmp_where .= " OR order_sex = ?";297 $tmp_where .= ' OR order_sex = ?'; 298 298 } 299 299 $arrValues[] = $element; … … 302 302 303 303 if (!SC_Utils_Ex::isBlank($tmp_where)) { 304 $tmp_where .= ")";304 $tmp_where .= ')'; 305 305 $where .= " $tmp_where "; 306 306 } 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; 312 312 case 'search_order_email': 313 $where .= " AND order_email LIKE ?";313 $where .= ' AND order_email LIKE ?'; 314 314 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 315 315 break; 316 316 case 'search_payment_id': 317 $tmp_where = "";317 $tmp_where = ''; 318 318 foreach ($objFormParam->getValue($key) as $element) { 319 if ($element != "") {320 if ($tmp_where == "") {321 $tmp_where .= " AND (payment_id = ?";319 if ($element != '') { 320 if ($tmp_where == '') { 321 $tmp_where .= ' AND (payment_id = ?'; 322 322 } else { 323 $tmp_where .= " OR payment_id = ?";323 $tmp_where .= ' OR payment_id = ?'; 324 324 } 325 325 $arrValues[] = $element; … … 328 328 329 329 if (!SC_Utils_Ex::isBlank($tmp_where)) { 330 $tmp_where .= ")";330 $tmp_where .= ')'; 331 331 $where .= " $tmp_where "; 332 332 } 333 333 break; 334 334 case 'search_total1': 335 $where .= " AND total >= ?";335 $where .= ' AND total >= ?'; 336 336 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 337 337 break; 338 338 case 'search_total2': 339 $where .= " AND total <= ?";339 $where .= ' AND total <= ?'; 340 340 $arrValues[] = sprintf('%d', $objFormParam->getValue($key)); 341 341 break; … … 344 344 $objFormParam->getValue('search_sordermonth'), 345 345 $objFormParam->getValue('search_sorderday')); 346 $where.= " AND create_date >= ?";346 $where.= ' AND create_date >= ?'; 347 347 $arrValues[] = $date; 348 348 break; … … 351 351 $objFormParam->getValue('search_eordermonth'), 352 352 $objFormParam->getValue('search_eorderday'), true); 353 $where.= " AND create_date <= ?";353 $where.= ' AND create_date <= ?'; 354 354 $arrValues[] = $date; 355 355 break; … … 358 358 $objFormParam->getValue('search_supdatemonth'), 359 359 $objFormParam->getValue('search_supdateday')); 360 $where.= " AND update_date >= ?";360 $where.= ' AND update_date >= ?'; 361 361 $arrValues[] = $date; 362 362 break; … … 365 365 $objFormParam->getValue('search_eupdatemonth'), 366 366 $objFormParam->getValue('search_eupdateday'), true); 367 $where.= " AND update_date <= ?";367 $where.= ' AND update_date <= ?'; 368 368 $arrValues[] = $date; 369 369 break; … … 372 372 $objFormParam->getValue('search_sbirthmonth'), 373 373 $objFormParam->getValue('search_sbirthday')); 374 $where.= " AND order_birth >= ?";374 $where.= ' AND order_birth >= ?'; 375 375 $arrValues[] = $date; 376 376 break; … … 379 379 $objFormParam->getValue('search_ebirthmonth'), 380 380 $objFormParam->getValue('search_ebirthday'), true); 381 $where.= " AND order_birth <= ?";381 $where.= ' AND order_birth <= ?'; 382 382 $arrValues[] = $date; 383 383 break; 384 384 case 'search_order_status': 385 $where.= " AND status = ?";385 $where.= ' AND status = ?'; 386 386 $arrValues[] = $objFormParam->getValue($key); 387 387 break; … … 416 416 */ 417 417 function doOutputCSV($where, $arrVal, $order) { 418 if ($where != "") {418 if ($where != '') { 419 419 $where = " WHERE $where "; 420 420 }
Note: See TracChangeset
for help on using the changeset viewer.