- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Customer.php
r21480 r21481 44 44 $objQuery->begin(); 45 45 46 $array[ "update_date"] = 'CURRENT_TIMESTAMP'; // 更新日46 $array['update_date'] = 'CURRENT_TIMESTAMP'; // 更新日 47 47 48 48 // salt値の生成(insert時)または取得(update時)。 49 49 if (is_numeric($customer_id)) { 50 $salt = $objQuery->get('salt', "dtb_customer", "customer_id = ? ", array($customer_id));50 $salt = $objQuery->get('salt', 'dtb_customer', "customer_id = ? ", array($customer_id)); 51 51 52 52 // 旧バージョン(2.11未満)からの移行を考慮 … … 71 71 } 72 72 //-- 秘密の質問の更新がある場合は暗号化 73 if ($array[ "reminder_answer"] == DEFAULT_PASSWORD or $array["reminder_answer"] == "") {73 if ($array['reminder_answer'] == DEFAULT_PASSWORD or $array['reminder_answer'] == "") { 74 74 //更新しない 75 unset($array[ "reminder_answer"]);75 unset($array['reminder_answer']); 76 76 77 77 // 旧バージョン(2.11未満)からの移行を考慮 78 78 if ($old_version_flag && $is_password_updated) { 79 79 // パスワードが更新される場合は、平文になっている秘密の質問を暗号化する 80 $reminder_answer = $objQuery->get('reminder_answer', "dtb_customer", "customer_id = ? ", array($customer_id));81 $array[ "reminder_answer"] = SC_Utils_Ex::sfGetHashString($reminder_answer, $salt);80 $reminder_answer = $objQuery->get('reminder_answer', 'dtb_customer', "customer_id = ? ", array($customer_id)); 81 $array['reminder_answer'] = SC_Utils_Ex::sfGetHashString($reminder_answer, $salt); 82 82 } 83 83 } else { … … 87 87 unset($array['salt']); 88 88 } else { 89 $array[ "reminder_answer"] = SC_Utils_Ex::sfGetHashString($array["reminder_answer"], $salt);89 $array['reminder_answer'] = SC_Utils_Ex::sfGetHashString($array['reminder_answer'], $salt); 90 90 } 91 91 } … … 94 94 if (is_numeric($customer_id)) { 95 95 // 編集 96 $objQuery->update( "dtb_customer", $array, "customer_id = ? ", array($customer_id));96 $objQuery->update('dtb_customer', $array, "customer_id = ? ", array($customer_id)); 97 97 } else { 98 98 // 新規登録 … … 102 102 $array['customer_id'] = $customer_id; 103 103 // 作成日 104 if (is_null($array[ "create_date"])) {105 $array[ "create_date"] = 'CURRENT_TIMESTAMP';106 } 107 $objQuery->insert( "dtb_customer", $array);104 if (is_null($array['create_date'])) { 105 $array['create_date'] = 'CURRENT_TIMESTAMP'; 106 } 107 $objQuery->insert('dtb_customer', $array); 108 108 } 109 109 … … 122 122 function sfGetCustomerPoint($order_id, $use_point, $add_point) { 123 123 $objQuery =& SC_Query_Ex::getSingletonInstance(); 124 $arrRet = $objQuery->select( "customer_id", "dtb_order", "order_id = ?", array($order_id));124 $arrRet = $objQuery->select('customer_id', 'dtb_order', "order_id = ?", array($order_id)); 125 125 $customer_id = $arrRet[0]['customer_id']; 126 126 if ($customer_id != "" && $customer_id >= 1) { 127 127 if (USE_POINT !== false) { 128 $arrRet = $objQuery->select('point', "dtb_customer", "customer_id = ?", array($customer_id));128 $arrRet = $objQuery->select('point', 'dtb_customer', "customer_id = ?", array($customer_id)); 129 129 $point = $arrRet[0]['point']; 130 130 $total_point = $arrRet[0]['point'] - $use_point + $add_point; … … 160 160 161 161 $arrRet = $objQuery->select("email, update_date, del_flg", 162 "dtb_customer",162 'dtb_customer', 163 163 "email = ? OR email_mobile = ? ORDER BY del_flg", 164 164 array($email, $email)); … … 221 221 222 222 // 会員情報DB取得 223 $ret = $objQuery->select("*", "dtb_customer","customer_id=?", array($customer_id));223 $ret = $objQuery->select("*",'dtb_customer',"customer_id=?", array($customer_id)); 224 224 $arrForm = $ret[0]; 225 225 … … 257 257 if ($add_where == '') { 258 258 $where = 'customer_id = ?'; 259 $arrData = $objQuery->getRow("*", "dtb_customer", $where, array($customer_id));259 $arrData = $objQuery->getRow("*", 'dtb_customer', $where, array($customer_id)); 260 260 } else { 261 261 $where = $add_where; … … 264 264 $arrAddVal[] = $customer_id; 265 265 } 266 $arrData = $objQuery->getRow("*", "dtb_customer", $where, $arrAddVal);266 $arrData = $objQuery->getRow("*", 'dtb_customer', $where, $arrAddVal); 267 267 } 268 268 return $arrData; … … 280 280 do { 281 281 $uniqid = SC_Utils_Ex::sfGetUniqRandomId('r'); 282 $exists = $objQuery->exists( "dtb_customer", "secret_key = ?", array($uniqid));282 $exists = $objQuery->exists('dtb_customer', "secret_key = ?", array($uniqid)); 283 283 } while ($exists); 284 284 return $uniqid; … … 301 301 } 302 302 303 return $objQuery->get( "customer_id", "dtb_customer", $where, array($uniqid));303 return $objQuery->get('customer_id', 'dtb_customer', $where, array($uniqid)); 304 304 } 305 305 … … 316 316 SC_Helper_Customer_Ex::sfCustomerRegisterParam($objFormParam, $isAdmin); 317 317 if ($isAdmin) { 318 $objFormParam->addParam("会員ID", "customer_id", INT_LEN, 'n', array('NUM_CHECK'));319 $objFormParam->addParam('携帯メールアドレス', "email_mobile", null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK'));318 $objFormParam->addParam("会員ID", 'customer_id', INT_LEN, 'n', array('NUM_CHECK')); 319 $objFormParam->addParam('携帯メールアドレス', 'email_mobile', null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK')); 320 320 $objFormParam->addParam("会員状態", 'status', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 321 321 $objFormParam->addParam("SHOP用メモ", 'note', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); … … 325 325 if (SC_Display_Ex::detectDevice() == DEVICE_TYPE_MOBILE) { 326 326 // 登録確認画面の「戻る」ボタンのためのパラメーター 327 $objFormParam->addParam("戻る", "return", '', '', array(), '', false);327 $objFormParam->addParam("戻る", 'return', '', '', array(), '', false); 328 328 } 329 329 } … … 340 340 SC_Helper_Customer_Ex::sfCustomerRegisterParam($objFormParam, false, true); 341 341 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE) { 342 $objFormParam->addParam('携帯メールアドレス', "email_mobile", null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK'));343 $objFormParam->addParam('携帯メールアドレス(確認)', "email_mobile02", null, 'a', array('NO_SPTAB', 'EMAIL_CHECK','SPTAB_CHECK' , 'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK'), "", false);344 } else { 345 $objFormParam->addParam('携帯メールアドレス', "email_mobile", null, 'a', array('EXIST_CHECK', 'NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK'));342 $objFormParam->addParam('携帯メールアドレス', 'email_mobile', null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK')); 343 $objFormParam->addParam('携帯メールアドレス(確認)', 'email_mobile02', null, 'a', array('NO_SPTAB', 'EMAIL_CHECK','SPTAB_CHECK' , 'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK'), "", false); 344 } else { 345 $objFormParam->addParam('携帯メールアドレス', 'email_mobile', null, 'a', array('EXIST_CHECK', 'NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK')); 346 346 $objFormParam->addParam('メールアドレス', 'email', null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK')); 347 347 } … … 372 372 $objFormParam->addParam("お名前(フリガナ・姓)", 'kana01', STEXT_LEN, 'CKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK', 'KANA_CHECK')); 373 373 $objFormParam->addParam("お名前(フリガナ・名)", 'kana02', STEXT_LEN, 'CKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK', 'KANA_CHECK')); 374 $objFormParam->addParam("郵便番号1", "zip01", ZIP01_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK' ,'NUM_CHECK', 'NUM_COUNT_CHECK'));375 $objFormParam->addParam("郵便番号2", "zip02", ZIP02_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK' ,'NUM_CHECK', 'NUM_COUNT_CHECK'));374 $objFormParam->addParam("郵便番号1", 'zip01', ZIP01_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK' ,'NUM_CHECK', 'NUM_COUNT_CHECK')); 375 $objFormParam->addParam("郵便番号2", 'zip02', ZIP02_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK' ,'NUM_CHECK', 'NUM_COUNT_CHECK')); 376 376 $objFormParam->addParam("都道府県", 'pref', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK')); 377 $objFormParam->addParam("住所1", "addr01", MTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));378 $objFormParam->addParam("住所2", "addr02", MTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));377 $objFormParam->addParam("住所1", 'addr01', MTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 378 $objFormParam->addParam("住所2", 'addr02', MTEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 379 379 $objFormParam->addParam("お電話番号1", 'tel01', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 380 380 $objFormParam->addParam("お電話番号2", 'tel02', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); … … 392 392 function sfCustomerRegisterParam(&$objFormParam, $isAdmin = false, $is_mypage = false) { 393 393 $objFormParam->addParam("パスワード", 'password', STEXT_LEN, 'a', array('EXIST_CHECK', 'SPTAB_CHECK', 'ALNUM_CHECK', 'MAX_LENGTH_CHECK')); 394 $objFormParam->addParam("パスワード確認用の質問の答え", "reminder_answer", STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK'));394 $objFormParam->addParam("パスワード確認用の質問の答え", 'reminder_answer', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'SPTAB_CHECK', 'MAX_LENGTH_CHECK')); 395 395 $objFormParam->addParam("パスワード確認用の質問", 'reminder', STEXT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 396 396 $objFormParam->addParam("性別", 'sex', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); … … 399 399 $objFormParam->addParam("月", 'month', 2, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false); 400 400 $objFormParam->addParam("日", 'day', 2, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false); 401 $objFormParam->addParam("メールマガジン", "mailmaga_flg", INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));401 $objFormParam->addParam("メールマガジン", 'mailmaga_flg', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 402 402 403 403 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE) { … … 408 408 if (!$isAdmin) { 409 409 $objFormParam->addParam("パスワード(確認)", 'password02', STEXT_LEN, 'a', array('EXIST_CHECK', 'SPTAB_CHECK' ,'ALNUM_CHECK'), "", false); 410 $objFormParam->addParam('メールアドレス(確認)', "email02", null, 'a', array('NO_SPTAB', 'EXIST_CHECK', 'EMAIL_CHECK','SPTAB_CHECK' , 'EMAIL_CHAR_CHECK'), "", false);410 $objFormParam->addParam('メールアドレス(確認)', 'email02', null, 'a', array('NO_SPTAB', 'EXIST_CHECK', 'EMAIL_CHECK','SPTAB_CHECK' , 'EMAIL_CHAR_CHECK'), "", false); 411 411 } 412 412 } else { … … 494 494 $objErr->arrErr = $objFormParam->checkError(); 495 495 496 $objErr->doFunc(array("お電話番号", "tel01", "tel02", "tel03"),array('TEL_CHECK'));497 $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array('ALL_EXIST_CHECK'));496 $objErr->doFunc(array("お電話番号", 'tel01', 'tel02', 'tel03'),array('TEL_CHECK')); 497 $objErr->doFunc(array("郵便番号", 'zip01', 'zip02'), array('ALL_EXIST_CHECK')); 498 498 499 499 return $objErr; … … 513 513 if (!$isAdmin) { 514 514 $objErr->doFunc(array('パスワード', 'password', PASSWORD_MIN_LEN, PASSWORD_MAX_LEN) ,array('SPTAB_CHECK', 'NUM_RANGE_CHECK')); 515 $objErr->doFunc(array('パスワード', 'パスワード(確認)', 'password', "password02") ,array('EQUAL_CHECK'));516 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', 'email', "email02") ,array('EQUAL_CHECK'));517 } 518 $objErr->doFunc(array("FAX番号", "fax01", "fax02", "fax03") ,array('TEL_CHECK'));515 $objErr->doFunc(array('パスワード', 'パスワード(確認)', 'password', 'password02') ,array('EQUAL_CHECK')); 516 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', 'email', 'email02') ,array('EQUAL_CHECK')); 517 } 518 $objErr->doFunc(array("FAX番号", 'fax01', 'fax02', 'fax03') ,array('TEL_CHECK')); 519 519 } 520 520 … … 589 589 $objErr = new SC_CheckError_Ex($objFormParam->getHashArray()); 590 590 // 拡張エラーチェック 591 $objErr->doFunc(array("誕生日(開始日)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array('CHECK_DATE'));592 $objErr->doFunc(array("誕生日(終了日)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array('CHECK_DATE'));593 594 $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'));595 $objErr->doFunc(array("登録・更新日(開始日)", "search_start_year", "search_start_month", "search_start_day",), array('CHECK_DATE'));596 $objErr->doFunc(array("登録・更新日(終了日)", "search_end_year", "search_end_month", "search_end_day"), array('CHECK_DATE'));597 $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'));598 $objErr->doFunc(array("最終購入日(開始日)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array('CHECK_DATE'));599 $objErr->doFunc(array("最終購入(終了日)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array('CHECK_DATE'));591 $objErr->doFunc(array("誕生日(開始日)", 'search_b_start_year', 'search_b_start_month', 'search_b_start_day'), array('CHECK_DATE')); 592 $objErr->doFunc(array("誕生日(終了日)", 'search_b_end_year', 'search_b_end_month', 'search_b_end_day'), array('CHECK_DATE')); 593 594 $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')); 595 $objErr->doFunc(array("登録・更新日(開始日)", 'search_start_year', 'search_start_month', 'search_start_day',), array('CHECK_DATE')); 596 $objErr->doFunc(array("登録・更新日(終了日)", 'search_end_year', 'search_end_month', 'search_end_day'), array('CHECK_DATE')); 597 $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')); 598 $objErr->doFunc(array("最終購入日(開始日)", 'search_buy_start_year', 'search_buy_start_month', 'search_buy_start_day',), array('CHECK_DATE')); 599 $objErr->doFunc(array("最終購入(終了日)", 'search_buy_end_year', 'search_buy_end_month', 'search_buy_end_day'), array('CHECK_DATE')); 600 600 //購入金額(from) > 購入金額(to) の場合はエラーとする 601 $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'));602 603 if ((SC_Utils_Ex::sfIsInt($array[ "search_buy_total_from"])604 && SC_Utils_Ex::sfIsInt($array[ "search_buy_total_to"]))605 && ($array[ "search_buy_total_from"] > $array["buy_total_to"])) {606 $objErr->arrErr[ "search_buy_total_from"] .= "※ 購入金額の指定範囲が不正です。";607 } 608 609 if ((SC_Utils_Ex::sfIsInt($array[ "search_buy_times_from"])610 && SC_Utils_Ex::sfIsInt($array[ "search_buy_times_to"]))611 && ($array[ "search_buy_times_from"] > $array["search_buy_times_to"])) {612 $objErr->arrErr[ "search_buy_times_from"] .= "※ 購入回数の指定範囲が不正です。";601 $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')); 602 603 if ((SC_Utils_Ex::sfIsInt($array['search_buy_total_from']) 604 && SC_Utils_Ex::sfIsInt($array['search_buy_total_to'])) 605 && ($array['search_buy_total_from'] > $array['buy_total_to'])) { 606 $objErr->arrErr['search_buy_total_from'] .= "※ 購入金額の指定範囲が不正です。"; 607 } 608 609 if ((SC_Utils_Ex::sfIsInt($array['search_buy_times_from']) 610 && SC_Utils_Ex::sfIsInt($array['search_buy_times_to'])) 611 && ($array['search_buy_times_from'] > $array['search_buy_times_to'])) { 612 $objErr->arrErr['search_buy_times_from'] .= "※ 購入回数の指定範囲が不正です。"; 613 613 } 614 614 if (!SC_Utils_Ex::isBlank($objErr->arrErr)) {
Note: See TracChangeset
for help on using the changeset viewer.