- Timestamp:
- 2012/02/15 19:56:17 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Customer.php
r21511 r21514 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 // 新規登録 … … 124 124 $arrRet = $objQuery->select('customer_id', 'dtb_order', "order_id = ?", array($order_id)); 125 125 $customer_id = $arrRet[0]['customer_id']; 126 if ($customer_id != ""&& $customer_id >= 1) {126 if ($customer_id != '' && $customer_id >= 1) { 127 127 if (USE_POINT !== false) { 128 128 $arrRet = $objQuery->select('point', 'dtb_customer', "customer_id = ?", array($customer_id)); … … 134 134 } 135 135 } else { 136 $total_point = "";137 $point = "";136 $total_point = ''; 137 $point = ''; 138 138 } 139 139 return array($point, $total_point); … … 159 159 } 160 160 161 $arrRet = $objQuery->select( "email, update_date, del_flg",161 $arrRet = $objQuery->select('email, update_date, del_flg', 162 162 'dtb_customer', 163 "email = ? OR email_mobile = ? ORDER BY del_flg",163 'email = ? OR email_mobile = ? ORDER BY del_flg', 164 164 array($email, $email)); 165 165 … … 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 … … 230 230 // 誕生日を年月日に分ける 231 231 if (isset($arrForm['birth'])) { 232 $birth = explode( " ", $arrForm['birth']);232 $birth = explode(' ', $arrForm['birth']); 233 233 list($arrForm['year'], $arrForm['month'], $arrForm['day']) = explode("-",$birth[0]); 234 234 } … … 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; … … 295 295 function sfGetCustomerId($uniqid, $check_status = false) { 296 296 $objQuery =& SC_Query_Ex::getSingletonInstance(); 297 $where = "secret_key = ?";297 $where = 'secret_key = ?'; 298 298 299 299 if ($check_status) { … … 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'));318 $objFormParam->addParam('会員ID', 'customer_id', INT_LEN, 'n', array('NUM_CHECK')); 319 319 $objFormParam->addParam('携帯メールアドレス', 'email_mobile', null, 'a', array('NO_SPTAB', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK', 'MOBILE_EMAIL_CHECK')); 320 $objFormParam->addParam( "会員状態", 'status', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));321 $objFormParam->addParam( "SHOP用メモ", 'note', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK'));322 $objFormParam->addParam( "所持ポイント", 'point', INT_LEN, 'n', array('NUM_CHECK'));320 $objFormParam->addParam('会員状態', 'status', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 321 $objFormParam->addParam('SHOP用メモ', 'note', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 322 $objFormParam->addParam('所持ポイント', 'point', INT_LEN, 'n', array('NUM_CHECK')); 323 323 } 324 324 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 } … … 357 357 function sfCustomerOtherDelivParam(&$objFormParam) { 358 358 SC_Helper_Customer_Ex::sfCustomerCommonParam($objFormParam); 359 $objFormParam->addParam( "", 'other_deliv_id');359 $objFormParam->addParam('', 'other_deliv_id'); 360 360 } 361 361 … … 368 368 */ 369 369 function sfCustomerCommonParam(&$objFormParam) { 370 $objFormParam->addParam( "お名前(姓)", 'name01', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK'));371 $objFormParam->addParam( "お名前(名)", 'name02', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' , 'MAX_LENGTH_CHECK'));372 $objFormParam->addParam( "お名前(フリガナ・姓)", 'kana01', STEXT_LEN, 'CKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK', 'KANA_CHECK'));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'));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'));379 $objFormParam->addParam( "お電話番号1", 'tel01', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));380 $objFormParam->addParam( "お電話番号2", 'tel02', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));381 $objFormParam->addParam( "お電話番号3", 'tel03', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));370 $objFormParam->addParam('お名前(姓)', 'name01', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK')); 371 $objFormParam->addParam('お名前(名)', 'name02', STEXT_LEN, 'aKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' , 'MAX_LENGTH_CHECK')); 372 $objFormParam->addParam('お名前(フリガナ・姓)', 'kana01', STEXT_LEN, 'CKV', array('EXIST_CHECK', 'NO_SPTAB', 'SPTAB_CHECK' ,'MAX_LENGTH_CHECK', 'KANA_CHECK')); 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')); 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')); 379 $objFormParam->addParam('お電話番号1', 'tel01', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 380 $objFormParam->addParam('お電話番号2', 'tel02', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 381 $objFormParam->addParam('お電話番号3', 'tel03', TEL_ITEM_LEN, 'n', array('EXIST_CHECK', 'SPTAB_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 382 382 } 383 383 … … 391 391 */ 392 392 function sfCustomerRegisterParam(&$objFormParam, $isAdmin = false, $is_mypage = false) { 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'));395 $objFormParam->addParam( "パスワード確認用の質問", 'reminder', STEXT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));396 $objFormParam->addParam( "性別", 'sex', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));397 $objFormParam->addParam( "職業", 'job', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'));398 $objFormParam->addParam( "年", 'year', 4, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false);399 $objFormParam->addParam( "月", 'month', 2, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false);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'));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')); 395 $objFormParam->addParam('パスワード確認用の質問', 'reminder', STEXT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 396 $objFormParam->addParam('性別', 'sex', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK')); 397 $objFormParam->addParam('職業', 'job', INT_LEN, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK')); 398 $objFormParam->addParam('年', 'year', 4, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false); 399 $objFormParam->addParam('月', 'month', 2, 'n', array('NUM_CHECK', 'MAX_LENGTH_CHECK'), "", false); 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')); 402 402 403 403 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE) { 404 $objFormParam->addParam( "FAX番号1", 'fax01', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK'));405 $objFormParam->addParam( "FAX番号2", 'fax02', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK'));406 $objFormParam->addParam( "FAX番号3", 'fax03', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK'));404 $objFormParam->addParam('FAX番号1', 'fax01', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK')); 405 $objFormParam->addParam('FAX番号2', 'fax02', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK')); 406 $objFormParam->addParam('FAX番号3', 'fax03', TEL_ITEM_LEN, 'n', array('SPTAB_CHECK')); 407 407 $objFormParam->addParam('メールアドレス', 'email', null, 'a', array('NO_SPTAB', 'EXIST_CHECK', 'EMAIL_CHECK', 'SPTAB_CHECK' ,'EMAIL_CHAR_CHECK')); 408 408 $objFormParam->addParam("パスワード(確認)", 'password02', STEXT_LEN, 'a', array('EXIST_CHECK', 'SPTAB_CHECK' ,'ALNUM_CHECK'), "", false); … … 439 439 if ($objCustomer->isLoginSuccess(true) 440 440 && SC_Helper_Customer_Ex::sfCustomerEmailDuplicationCheck($objCustomer->getValue('customer_id'), $objFormParam->getValue('email'))) { 441 $objErr->arrErr['email'] .= "※ すでに会員登録で使用されているメールアドレスです。<br />";441 $objErr->arrErr['email'] .= '※ すでに会員登録で使用されているメールアドレスです。<br />'; 442 442 } 443 443 if ($objCustomer->isLoginSuccess(true) 444 444 && SC_Helper_Customer_Ex::sfCustomerEmailDuplicationCheck($objCustomer->getValue('customer_id'), $objFormParam->getValue('email_mobile'))) { 445 $objErr->arrErr['email_mobile'] .= "※ すでに会員登録で使用されているメールアドレスです。<br />";445 $objErr->arrErr['email_mobile'] .= '※ すでに会員登録で使用されているメールアドレスです。<br />'; 446 446 } 447 447 … … 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; … … 508 508 */ 509 509 function sfCustomerRegisterErrorCheck(&$objErr, $isAdmin = false) { 510 $objErr->doFunc(array( "生年月日", 'year', 'month', 'day'), array('CHECK_BIRTHDAY'));510 $objErr->doFunc(array('生年月日', 'year', 'month', 'day'), array('CHECK_BIRTHDAY')); 511 511 512 512 if (SC_Display_Ex::detectDevice() !== DEVICE_TYPE_MOBILE) { … … 515 515 $objErr->doFunc(array('メールアドレス', 'メールアドレス(確認)', 'email', 'email02') ,array('EQUAL_CHECK')); 516 516 } 517 $objErr->doFunc(array('FAX番号', 'fax01', 'fax02', 'fax03') ,array('TEL_CHECK')); 517 518 $objErr->doFunc(array('パスワード', 'パスワード(確認)', 'password', 'password02') ,array('EQUAL_CHECK')); 518 $objErr->doFunc(array("FAX番号", 'fax01', 'fax02', 'fax03') ,array('TEL_CHECK'));519 519 } 520 520 521 521 if (!$isAdmin) { 522 522 // 現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可 523 $objErr->doFunc(array( "メールアドレス", 'email'), array('CHECK_REGIST_CUSTOMER_EMAIL'));524 $objErr->doFunc(array( "携帯メールアドレス", 'email_mobile'), array('CHECK_REGIST_CUSTOMER_EMAIL', 'MOBILE_EMAIL_CHECK'));523 $objErr->doFunc(array('メールアドレス', 'email'), array('CHECK_REGIST_CUSTOMER_EMAIL')); 524 $objErr->doFunc(array('携帯メールアドレス', 'email_mobile'), array('CHECK_REGIST_CUSTOMER_EMAIL', 'MOBILE_EMAIL_CHECK')); 525 525 } 526 526 return $objErr; … … 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'));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 602 603 603 if ((SC_Utils_Ex::sfIsInt($array['search_buy_total_from']) 604 604 && SC_Utils_Ex::sfIsInt($array['search_buy_total_to'])) 605 605 && ($array['search_buy_total_from'] > $array['buy_total_to'])) { 606 $objErr->arrErr['search_buy_total_from'] .= "※ 購入金額の指定範囲が不正です。";606 $objErr->arrErr['search_buy_total_from'] .= '※ 購入金額の指定範囲が不正です。'; 607 607 } 608 608 … … 610 610 && SC_Utils_Ex::sfIsInt($array['search_buy_times_to'])) 611 611 && ($array['search_buy_times_from'] > $array['search_buy_times_to'])) { 612 $objErr->arrErr['search_buy_times_from'] .= "※ 購入回数の指定範囲が不正です。";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.