- Timestamp:
- 2011/02/21 02:13:44 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/helper/SC_Helper_Customer.php
r20244 r20281 469 469 */ 470 470 function sfSetSearchParam(&$objFormParam) { 471 $objFormParam->addParam('顧客ID', ' customer_id', ID_MAX_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));472 $objFormParam->addParam('顧客名', ' name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));473 $objFormParam->addParam('顧客名(カナ)', ' kana', STEXT_LEN, 'CKV', array("SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANABLANK_CHECK"));474 $objFormParam->addParam('都道府県', ' pref', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));475 $objFormParam->addParam('誕生日(開始年)', ' b_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));476 $objFormParam->addParam('誕生日(開始月)', ' b_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));477 $objFormParam->addParam('誕生日(開始日)', ' b_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));478 479 $objFormParam->addParam('誕生日(終了年)', ' b_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));480 $objFormParam->addParam('誕生日(終了月)', ' b_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));481 $objFormParam->addParam('誕生日(終了日)', ' b_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));482 $objFormParam->addParam('誕生月', ' birth_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));483 $objFormParam->addParam('メールアドレス', ' email', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));484 $objFormParam->addParam('携帯メールアドレス', ' email_mobile', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));485 $objFormParam->addParam('電話番号', ' birth_month', TEL_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));486 $objFormParam->addParam('購入金額(開始)', ' buy_total_from', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));487 $objFormParam->addParam('購入金額(終了)', ' buy_total_to', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));488 $objFormParam->addParam('購入回数(開始)', ' buy_times_from', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));489 $objFormParam->addParam('購入回数(終了)', ' buy_times_to', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));490 $objFormParam->addParam('登録・更新日(開始年)', 's tart_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));491 $objFormParam->addParam('登録・更新日(開始月)', 's tart_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));492 $objFormParam->addParam('登録・更新日(開始日)', 's tart_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));493 $objFormParam->addParam('登録・更新日(終了年)', ' end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));494 $objFormParam->addParam('登録・更新日(終了月)', ' end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));495 $objFormParam->addParam('登録・更新日(終了日)', ' end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));496 $objFormParam->addParam('表示件数', ' page_rows', 3, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));497 $objFormParam->addParam('最終購入日(開始年)', ' buy_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));498 $objFormParam->addParam('最終購入日(開始月)', ' buy_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));499 $objFormParam->addParam('最終購入日(開始日)', ' buy_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));500 $objFormParam->addParam('最終購入日(終了年)', ' buy_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));501 $objFormParam->addParam('最終購入日(終了月)', ' buy_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));502 $objFormParam->addParam('最終購入日(終了日)', ' buy_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));503 $objFormParam->addParam('購入商品コード', ' buy_product_code', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));504 $objFormParam->addParam('購入商品名', ' buy_product_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));505 $objFormParam->addParam('カテゴリ', ' category_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));506 $objFormParam->addParam('編集対象顧客ID', ' edit_customer_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK"));507 $objFormParam->addParam('性別', 'se x');508 $objFormParam->addParam('会員状態', 's tatus');509 $objFormParam->addParam('職業', ' job');471 $objFormParam->addParam('顧客ID', 'search_customer_id', ID_MAX_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 472 $objFormParam->addParam('顧客名', 'search_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 473 $objFormParam->addParam('顧客名(カナ)', 'search_kana', STEXT_LEN, 'CKV', array("SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANABLANK_CHECK")); 474 $objFormParam->addParam('都道府県', 'search_pref', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 475 $objFormParam->addParam('誕生日(開始年)', 'search_b_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 476 $objFormParam->addParam('誕生日(開始月)', 'search_b_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 477 $objFormParam->addParam('誕生日(開始日)', 'search_b_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 478 479 $objFormParam->addParam('誕生日(終了年)', 'search_b_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 480 $objFormParam->addParam('誕生日(終了月)', 'search_b_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 481 $objFormParam->addParam('誕生日(終了日)', 'search_b_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 482 $objFormParam->addParam('誕生月', 'search_birth_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 483 $objFormParam->addParam('メールアドレス', 'search_email', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 484 $objFormParam->addParam('携帯メールアドレス', 'search_email_mobile', MTEXT_LEN, 'a', array("SPTAB_CHECK", "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 485 $objFormParam->addParam('電話番号', 'search_birth_month', TEL_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 486 $objFormParam->addParam('購入金額(開始)', 'search_buy_total_from', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 487 $objFormParam->addParam('購入金額(終了)', 'search_buy_total_to', PRICE_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 488 $objFormParam->addParam('購入回数(開始)', 'search_buy_times_from', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 489 $objFormParam->addParam('購入回数(終了)', 'search_buy_times_to', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 490 $objFormParam->addParam('登録・更新日(開始年)', 'search_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 491 $objFormParam->addParam('登録・更新日(開始月)', 'search_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 492 $objFormParam->addParam('登録・更新日(開始日)', 'search_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 493 $objFormParam->addParam('登録・更新日(終了年)', 'search_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 494 $objFormParam->addParam('登録・更新日(終了月)', 'search_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 495 $objFormParam->addParam('登録・更新日(終了日)', 'search_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 496 $objFormParam->addParam('表示件数', 'search_page_rows', 3, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 497 $objFormParam->addParam('最終購入日(開始年)', 'search_buy_start_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 498 $objFormParam->addParam('最終購入日(開始月)', 'search_buy_start_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 499 $objFormParam->addParam('最終購入日(開始日)', 'search_buy_start_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 500 $objFormParam->addParam('最終購入日(終了年)', 'search_buy_end_year', 4, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 501 $objFormParam->addParam('最終購入日(終了月)', 'search_buy_end_month', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 502 $objFormParam->addParam('最終購入日(終了日)', 'search_buy_end_day', 2, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 503 $objFormParam->addParam('購入商品コード', 'search_buy_product_code', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 504 $objFormParam->addParam('購入商品名', 'search_buy_product_name', STEXT_LEN, 'KVa', array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 505 $objFormParam->addParam('カテゴリ', 'search_category_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 506 $objFormParam->addParam('編集対象顧客ID', 'search_edit_customer_id', INT_LEN, 'n', array("NUM_CHECK","MAX_LENGTH_CHECK")); 507 $objFormParam->addParam('性別', 'search_sex', INT_LEN, "n", array("MAX_LENGTH_CHECK")); 508 $objFormParam->addParam('会員状態', 'search_status', INT_LEN, "n", array("MAX_LENGTH_CHECK")); 509 $objFormParam->addParam('職業', 'search_job', INT_LEN, "n", array("MAX_LENGTH_CHECK")); 510 510 } 511 511 … … 523 523 $objErr = new SC_CheckError($objFormParam->getHashArray()); 524 524 // 拡張エラーチェック 525 $objErr->doFunc(array("誕生日(開始日)", " b_start_year", "b_start_month", "b_start_day"), array("CHECK_DATE"));526 $objErr->doFunc(array("誕生日(終了日)", " b_end_year", "b_end_month", "b_end_day"), array("CHECK_DATE"));525 $objErr->doFunc(array("誕生日(開始日)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array("CHECK_DATE")); 526 $objErr->doFunc(array("誕生日(終了日)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_DATE")); 527 527 528 $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", " b_start_year", "b_start_month", "b_start_day", "b_end_year", "b_end_month", "b_end_day"), array("CHECK_SET_TERM"));529 $objErr->doFunc(array("登録・更新日(開始日)", "s tart_year", "start_month", "start_day",), array("CHECK_DATE"));530 $objErr->doFunc(array("登録・更新日(終了日)", " end_year", "end_month", "end_day"), array("CHECK_DATE"));531 $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "s tart_year", "start_month", "start_day", "end_year", "end_month", "end_day"), array("CHECK_SET_TERM"));532 $objErr->doFunc(array("最終購入日(開始日)", " buy_start_year", "buy_start_month", "buy_start_day",), array("CHECK_DATE"));533 $objErr->doFunc(array("最終購入(終了日)", " buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_DATE"));528 $objErr->doFunc(array("誕生日(開始日)","誕生日(終了日)", "search_b_start_year", "search_b_start_month", "search_b_start_day", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_SET_TERM")); 529 $objErr->doFunc(array("登録・更新日(開始日)", "search_start_year", "search_start_month", "search_start_day",), array("CHECK_DATE")); 530 $objErr->doFunc(array("登録・更新日(終了日)", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_DATE")); 531 $objErr->doFunc(array("登録・更新日(開始日)","登録・更新日(終了日)", "search_start_year", "search_start_month", "search_start_day", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_SET_TERM")); 532 $objErr->doFunc(array("最終購入日(開始日)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array("CHECK_DATE")); 533 $objErr->doFunc(array("最終購入(終了日)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_DATE")); 534 534 //購入金額(from) > 購入金額(to) の場合はエラーとする 535 $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", " buy_start_year", "buy_start_month", "buy_start_day", "buy_end_year", "buy_end_month", "buy_end_day"), array("CHECK_SET_TERM"));536 537 if ((SC_Utils_Ex::sfIsInt($array[" buy_total_from"])538 && SC_Utils_Ex::sfIsInt($array[" buy_total_to"]))539 && ($array[" buy_total_from"] > $array["buy_total_to"])) {540 $objErr->arrErr[" buy_total_from"] .= "※ 購入金額の指定範囲が不正です。";541 } 542 543 if ((SC_Utils_Ex::sfIsInt($array[" buy_times_from"])544 && SC_Utils_Ex::sfIsInt($array[" buy_times_to"]))545 && ($array[" buy_times_from"] > $array["buy_times_to"])) {546 $objErr->arrErr[" buy_times_from"] .= "※ 購入回数の指定範囲が不正です。";535 $objErr->doFunc(array("最終購入日(開始日)","登録・更新日(終了日)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_SET_TERM")); 536 537 if ((SC_Utils_Ex::sfIsInt($array["search_buy_total_from"]) 538 && SC_Utils_Ex::sfIsInt($array["search_buy_total_to"])) 539 && ($array["search_buy_total_from"] > $array["buy_total_to"])) { 540 $objErr->arrErr["search_buy_total_from"] .= "※ 購入金額の指定範囲が不正です。"; 541 } 542 543 if ((SC_Utils_Ex::sfIsInt($array["search_buy_times_from"]) 544 && SC_Utils_Ex::sfIsInt($array["search_buy_times_to"])) 545 && ($array["search_buy_times_from"] > $array["search_buy_times_to"])) { 546 $objErr->arrErr["search_buy_times_from"] .= "※ 購入回数の指定範囲が不正です。"; 547 547 } 548 548 if(!SC_Utils::isBlank($objErr->arrErr)) {
Note: See TracChangeset
for help on using the changeset viewer.
