Changeset 11730 for branches/comu/html/cp/default/entry.php
- Timestamp:
- 2007/03/11 06:27:25 (19 years ago)
- File:
-
- 1 edited
-
branches/comu/html/cp/default/entry.php (modified) (22 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/comu/html/cp/default/entry.php
r11729 r11730 9 9 class LC_Page { 10 10 function LC_Page() { 11 $this->tpl_css = URL_DIR.'css/layout/entry/index.css'; // メインCSSパス12 $this->tpl_mainpage = 'entry/index.tpl'; // メインテンプレート13 $this->tpl_title .= ' 会員登録(入力ページ)'; // ページタイトル14 } 15 } 16 17 //---- ページ初期設定18 $CONF = sf_getBasisData(); // 店舗基本情報11 $this->tpl_css = URL_DIR.'css/layout/entry/index.css'; // ¥á¥¤¥óCSS¥Ñ¥¹ 12 $this->tpl_mainpage = 'entry/index.tpl'; // ¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È 13 $this->tpl_title .= '²ñ°÷ÅÐÏ¿(ÆþÎÏ¥Ú¡¼¥¸)'; //¡¡¥Ú¡¼¥¸¥¿¥¤¥È¥ë 14 } 15 } 16 17 //---- ¥Ú¡¼¥¸½é´üÀßÄê 18 $CONF = sf_getBasisData(); // ŹÊÞ´ðËܾðÊó 19 19 $objConn = new SC_DbConn(); 20 20 $objQuery = new SC_Query(); … … 26 26 $objPage->arrJob = $arrJob; 27 27 $objPage->arrReminder = $arrReminder; 28 $objPage->arrYear = $objDate->getYear('', 1950); // 日付プルダウン設定28 $objPage->arrYear = $objDate->getYear('', 1950); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 29 29 $objPage->arrMonth = $objDate->getMonth(); 30 30 $objPage->arrDay = $objDate->getDay(); 31 31 32 //SSLURL 判定32 //SSLURLȽÄê 33 33 if (SSLURL_CHECK == 1){ 34 34 $ssl_url= sfRmDupSlash(SSL_URL.$_SERVER['REQUEST_URI']); … … 38 38 } 39 39 40 // レイアウトデザインを取得40 // ¥ì¥¤¥¢¥¦¥È¥Ç¥¶¥¤¥ó¤ò¼èÆÀ 41 41 $objPage = sfGetPageLayout($objPage, false, DEF_LAYOUT); 42 42 43 //---- 登録用カラム配列43 //---- ÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó 44 44 $arrRegistColumn = array( 45 45 array( "column" => "name01", "convert" => "aKV" ), … … 71 71 ); 72 72 73 //---- 登録除外用カラム配列73 //---- ÅÐÏ¿½ü³°ÍÑ¥«¥é¥àÇÛÎó 74 74 $arrRejectRegistColumn = array("year", "month", "day", "email02", "email_mobile02", "password02"); 75 75 76 76 if ($_SERVER["REQUEST_METHOD"] == "POST") { 77 77 78 //-- POST データの引き継ぎ78 //-- POST¥Ç¡¼¥¿¤Î°ú¤·Ñ¤® 79 79 $objPage->arrForm = $_POST; 80 80 … … 83 83 } 84 84 85 $objPage->arrForm['email'] = strtolower($objPage->arrForm['email']); // email はすべて小文字で処理86 $objPage->arrForm['email02'] = strtolower($objPage->arrForm['email02']); // email はすべて小文字で処理87 88 //-- 入力データの変換85 $objPage->arrForm['email'] = strtolower($objPage->arrForm['email']); // email¤Ï¤¹¤Ù¤Æ¾®Ê¸»ú¤Ç½èÍý 86 $objPage->arrForm['email02'] = strtolower($objPage->arrForm['email02']); // email¤Ï¤¹¤Ù¤Æ¾®Ê¸»ú¤Ç½èÍý 87 88 //-- ÆþÎϥǡ¼¥¿¤ÎÊÑ´¹ 89 89 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); 90 90 91 //-- 入力エラーチェック91 //--¡¡ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 92 92 $objPage->arrErr = lfErrorCheck($objPage->arrForm); 93 93 94 if ($objPage->arrErr || $_POST["mode"] == "return") { // 入力エラーのチェック94 if ($objPage->arrErr || $_POST["mode"] == "return") { // ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 95 95 foreach($objPage->arrForm as $key => $val) { 96 96 $objPage->$key = $val; … … 99 99 } else { 100 100 101 //-- 確認101 //--¡¡³Îǧ 102 102 if ($_POST["mode"] == "confirm") { 103 103 foreach($objPage->arrForm as $key => $val) { 104 104 if ($key != "mode" && $key != "subm") $objPage->list_data[ $key ] = $val; 105 105 } 106 // パスワード表示106 //¥Ñ¥¹¥ï¡¼¥Éɽ¼¨ 107 107 $passlen = strlen($objPage->arrForm['password']); 108 108 $objPage->passlen = lfPassLen($passlen); … … 110 110 $objPage->tpl_css = '/css/layout/entry/confirm.css'; 111 111 $objPage->tpl_mainpage = 'entry/confirm.tpl'; 112 $objPage->tpl_title = ' 会員登録(確認ページ)';112 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(³Îǧ¥Ú¡¼¥¸)'; 113 113 114 114 } 115 115 116 //-- 仮登録と完了画面116 //--¡¡²¾ÅÐÏ¿¤È´°Î»²èÌÌ 117 117 if ($_POST["mode"] == "complete") { 118 118 $objPage->uniqid = lfRegistData ($objPage->arrForm, $arrRegistColumn, $arrRejectRegistColumn); … … 124 124 $objPage->tpl_css = '/css/layout/entry/complete.css'; 125 125 $objPage->tpl_mainpage = 'entry/complete.tpl'; 126 $objPage->tpl_title = ' 会員登録(完了ページ)';126 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(´°Î»¥Ú¡¼¥¸)'; 127 127 128 128 129 // 仮登録完了メール送信129 //¡¡²¾ÅÐÏ¿´°Î»¥á¡¼¥ëÁ÷¿® 130 130 $objPage->CONF = $CONF; 131 131 $objPage->to_name01 = $_POST['name01']; … … 133 133 $objMailText = new SC_SiteView(); 134 134 $objMailText->assignobj($objPage); 135 $subject = sfMakesubject(' 会員登録のご確認');135 $subject = sfMakesubject('²ñ°÷ÅÐÏ¿¤Î¤´³Îǧ'); 136 136 $toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl"); 137 137 $objMail = new GC_SendMail(); 138 138 $objMail->setItem( 139 '' // 宛先140 , $subject // サブジェクト141 , $toCustomerMail // 本文142 , $CONF["email03"] // 配送元アドレス143 , $CONF["shop_name"] // 配送元 名前144 , $CONF["email03"] // reply_to145 , $CONF["email04"] // return_path139 '' //¡¡°¸Àè 140 , $subject //¡¡¥µ¥Ö¥¸¥§¥¯¥È 141 , $toCustomerMail //¡¡ËÜʸ 142 , $CONF["email03"] //¡¡ÇÛÁ÷¸µ¥¢¥É¥ì¥¹ 143 , $CONF["shop_name"] //¡¡ÇÛÁ÷¸µ¡¡Ì¾Á° 144 , $CONF["email03"] //¡¡reply_to 145 , $CONF["email04"] //¡¡return_path 146 146 , $CONF["email04"] // Errors_to 147 147 , $CONF["email01"] // Bcc 148 148 ); 149 // 宛先の設定150 $name = $_POST["name01"] . $_POST["name02"] ." 様";149 // °¸Àè¤ÎÀßÄê 150 $name = $_POST["name01"] . $_POST["name02"] ." ÍÍ"; 151 151 $objMail->setTo($_POST["email"], $name); 152 152 $objMail->sendMail(); 153 153 154 // キャンペーン受注情報を登録154 // ¥¥ã¥ó¥Ú¡¼¥ó¼õÃí¾ðÊó¤òÅÐÏ¿ 155 155 lfRegistCampaignOrder($objPage->uniqid); 156 156 157 // 完了ページに移動させる。157 // ´°Î»¥Ú¡¼¥¸¤Ë°Üư¤µ¤»¤ë¡£ 158 158 header("Location: ./complete.php"); 159 159 exit; … … 166 166 } 167 167 168 //---- ページ表示168 //----¡¡¥Ú¡¼¥¸É½¼¨ 169 169 $objView->assignobj($objPage); 170 // フレームを選択(キャンペーンページから遷移なら変更)170 // ¥Õ¥ì¡¼¥à¤òÁªÂò(¥¥ã¥ó¥Ú¡¼¥ó¥Ú¡¼¥¸¤«¤éÁ«°Ü¤Ê¤éÊѹ¹) 171 171 $objCampaignSess->pageView($objView); 172 172 173 173 //---------------------------------------------------------------------------------------------------------------------- 174 174 175 //---- function 群175 //---- function·² 176 176 function lfRegistData ($array, $arrRegistColumn, $arrRejectRegistColumn) { 177 177 global $objConn; 178 178 179 // 仮登録179 // ²¾ÅÐÏ¿ 180 180 foreach ($arrRegistColumn as $data) { 181 181 if (strlen($array[ $data["column"] ]) > 0 && ! in_array($data["column"], $arrRejectRegistColumn)) { … … 184 184 } 185 185 186 // 誕生日が入力されている場合186 // ÃÂÀ¸Æü¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ë¾ì¹ç 187 187 if (strlen($array["year"]) > 0 ) { 188 188 $arrRegist["birth"] = $array["year"] ."/". $array["month"] ."/". $array["day"] ." 00:00:00"; 189 189 } 190 190 191 // パスワードの暗号化191 // ¥Ñ¥¹¥ï¡¼¥É¤Î°Å¹æ²½ 192 192 $arrRegist["password"] = sha1($arrRegist["password"] . ":" . AUTH_MAGIC); 193 193 … … 198 198 } 199 199 200 $arrRegist["secret_key"] = $uniqid; // 仮登録ID発行201 $arrRegist["create_date"] = "now()"; // 作成日202 $arrRegist["update_date"] = "now()"; // 更新日203 $arrRegist["first_buy_date"] = ""; // 最初の購入日204 205 //-- 仮登録実行200 $arrRegist["secret_key"] = $uniqid; // ²¾ÅÐÏ¿IDȯ¹Ô 201 $arrRegist["create_date"] = "now()"; // ºîÀ®Æü 202 $arrRegist["update_date"] = "now()"; // ¹¹¿·Æü 203 $arrRegist["first_buy_date"] = ""; // ºÇ½é¤Î¹ØÆþÆü 204 205 //-- ²¾ÅÐÏ¿¼Â¹Ô 206 206 $objConn->query("BEGIN"); 207 207 … … 209 209 $objQuery->insert("dtb_customer", $arrRegist); 210 210 211 //-- 非会員でメルマガ登録しているかの判定211 //--¡¡Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¤«¤ÎȽÄê 212 212 $sql = "SELECT count(*) FROM dtb_customer_mail WHERE email = ?"; 213 213 $mailResult = $objConn->getOne($sql, array($arrRegist["email"])); 214 214 215 //-- メルマガ仮登録実行215 //--¡¡¥á¥ë¥Þ¥¬²¾ÅÐÏ¿¼Â¹Ô 216 216 $arrRegistMail["email"] = $arrRegist["email"]; 217 217 if ($array["mail_flag"] == 1) { … … 224 224 $arrRegistMail["update_date"] = "now()"; 225 225 226 // 非会員でメルマガ登録している場合226 // Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¾ì¹ç 227 227 if ($mailResult == 1) { 228 228 $objQuery->update("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($arrRegistMail["email"]). "'"); 229 } else { // 新規登録の場合229 } else { //¡¡¿·µ¬ÅÐÏ¿¤Î¾ì¹ç 230 230 $arrRegistMail["create_date"] = "now()"; 231 231 $objQuery->insert("dtb_customer_mail", $arrRegistMail); … … 236 236 } 237 237 238 //---- 取得文字列の変換238 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 239 239 function lfConvertParam($array, $arrRegistColumn) { 240 240 /* 241 * 文字列の変換242 * K : 「半角(ハンカク)片仮名」を「全角片仮名」に変換243 * C : 「全角ひら仮名」を「全角かた仮名」に変換244 * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します245 * n : 「全角」数字を「半角(ハンカク)」に変換246 * a : 全角英数字を半角英数字に変換する241 * ʸ»úÎó¤ÎÊÑ´¹ 242 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ 243 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ 244 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 245 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹ 246 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë 247 247 */ 248 // カラム名とコンバート情報248 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó 249 249 foreach ($arrRegistColumn as $data) { 250 250 $arrConvList[ $data["column"] ] = $data["convert"]; 251 251 } 252 // 文字変換252 // ʸ»úÊÑ´¹ 253 253 foreach ($arrConvList as $key => $val) { 254 // POST されてきた値のみ変換する。254 // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£ 255 255 if(strlen(($array[$key])) > 0) { 256 256 $array[$key] = mb_convert_kana($array[$key] ,$val); … … 260 260 } 261 261 262 //---- 入力エラーチェック262 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 263 263 function lfErrorCheck($array) { 264 264 … … 266 266 $objErr = new SC_CheckError($array); 267 267 268 $objErr->doFunc(array(" お名前(姓)", 'name01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK"));269 $objErr->doFunc(array(" お名前(名)", 'name02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK"));270 $objErr->doFunc(array(" フリガナ(セイ)", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK"));271 $objErr->doFunc(array(" フリガナ(メイ)", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK"));272 $objErr->doFunc(array(" 郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK"));273 $objErr->doFunc(array(" 郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK"));274 $objErr->doFunc(array(" 郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK"));275 $objErr->doFunc(array(" 都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK"));276 $objErr->doFunc(array(" ご住所1", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK"));277 $objErr->doFunc(array(" ご住所2", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK"));278 $objErr->doFunc(array(' メールアドレス', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));279 $objErr->doFunc(array(' メールアドレス(確認)', "email02", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));280 $objErr->doFunc(array(' メールアドレス', 'メールアドレス(確認)', "email", "email02") ,array("EQUAL_CHECK"));281 282 // 現会員の判定 → 現会員もしくは仮登録中は、メアド一意が前提になってるので同じメアドで登録不可268 $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 269 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 270 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 271 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 272 $objErr->doFunc(array("Í¹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 273 $objErr->doFunc(array("Í¹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 274 $objErr->doFunc(array("Í¹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 275 $objErr->doFunc(array("ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 276 $objErr->doFunc(array("¤´½»½ê1", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 277 $objErr->doFunc(array("¤´½»½ê2", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 278 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 279 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹(³Îǧ)', "email02", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK","SPTAB_CHECK" , "EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK")); 280 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', '¥á¡¼¥ë¥¢¥É¥ì¥¹(³Îǧ)', "email", "email02") ,array("EQUAL_CHECK")); 281 282 //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä 283 283 if (strlen($array["email"]) > 0) { 284 284 $objQuery = new SC_Query(); … … 287 287 if(count($arrRet) > 0) { 288 288 if($arrRet[0]['del_flg'] != '1') { 289 // 会員である場合290 $objErr->arrErr["email"] .= " ※ すでに会員登録で使用されているメールアドレスです。<br />";289 // ²ñ°÷¤Ç¤¢¤ë¾ì¹ç 290 $objErr->arrErr["email"] .= "¢¨ ¤¹¤Ç¤Ë²ñ°÷ÅÐÏ¿¤Ç»ÈÍѤµ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Ç¤¹¡£<br />"; 291 291 } else { 292 // 退会した会員である場合292 // Âà²ñ¤·¤¿²ñ°÷¤Ç¤¢¤ë¾ì¹ç 293 293 $leave_time = sfDBDatetoTime($arrRet[0]['update_date']); 294 294 $now_time = time(); 295 295 $pass_time = $now_time - $leave_time; 296 // 退会から何時間-経過しているか判定する。296 // Âà²ñ¤«¤é²¿»þ´Ö-·Ð²á¤·¤Æ¤¤¤ë¤«È½Äꤹ¤ë¡£ 297 297 $limit_time = ENTRY_LIMIT_HOUR * 3600; 298 298 if($pass_time < $limit_time) { 299 $objErr->arrErr["email"] .= " ※ 退会から一定期間の間は、同じメールアドレスを使用することはできません。<br />";299 $objErr->arrErr["email"] .= "¢¨ Âà²ñ¤«¤é°ìÄê´ü´Ö¤Î´Ö¤Ï¡¢Æ±¤¸¥á¡¼¥ë¥¢¥É¥ì¥¹¤ò»ÈÍѤ¹¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£<br />"; 300 300 } 301 301 } … … 303 303 } 304 304 305 $objErr->doFunc(array(" お電話番号1", 'tel01'), array("EXIST_CHECK","SPTAB_CHECK" ));306 $objErr->doFunc(array(" お電話番号2", 'tel02'), array("EXIST_CHECK","SPTAB_CHECK" ));307 $objErr->doFunc(array(" お電話番号3", 'tel03'), array("EXIST_CHECK","SPTAB_CHECK" ));308 $objErr->doFunc(array(" お電話番号", "tel01", "tel02", "tel03",TEL_ITEM_LEN) ,array("TEL_CHECK"));309 $objErr->doFunc(array("FAX 番号1", 'fax01'), array("SPTAB_CHECK"));310 $objErr->doFunc(array("FAX 番号2", 'fax02'), array("SPTAB_CHECK"));311 $objErr->doFunc(array("FAX 番号3", 'fax03'), array("SPTAB_CHECK"));312 $objErr->doFunc(array("FAX 番号", "fax01", "fax02", "fax03", TEL_ITEM_LEN) ,array("TEL_CHECK"));313 $objErr->doFunc(array(" ご性別", "sex") ,array("SELECT_CHECK", "NUM_CHECK"));314 $objErr->doFunc(array(" パスワード", 'password', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK", "NUM_RANGE_CHECK"));315 $objErr->doFunc(array(" パスワード(確認)", 'password02', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK", "NUM_RANGE_CHECK"));316 $objErr->doFunc(array(' パスワード', 'パスワード(確認)', "password", "password02") ,array("EQUAL_CHECK"));317 $objErr->doFunc(array(" パスワードを忘れたときのヒント 質問", "reminder") ,array("SELECT_CHECK", "NUM_CHECK"));318 $objErr->doFunc(array(" パスワードを忘れたときのヒント 答え", "reminder_answer", STEXT_LEN) ,array("EXIST_CHECK","SPTAB_CHECK" , "MAX_LENGTH_CHECK"));319 $objErr->doFunc(array(" メールマガジン", "mail_flag") ,array("SELECT_CHECK", "NUM_CHECK"));320 321 $objErr->doFunc(array(" 生年月日", "year", "month", "day"), array("CHECK_DATE"));322 $objErr->doFunc(array(" メールマガジン", 'mail_flag'), array("SELECT_CHECK"));305 $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK","SPTAB_CHECK" )); 306 $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","SPTAB_CHECK" )); 307 $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","SPTAB_CHECK" )); 308 $objErr->doFunc(array("¤ªÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03",TEL_ITEM_LEN) ,array("TEL_CHECK")); 309 $objErr->doFunc(array("FAXÈÖ¹æ1", 'fax01'), array("SPTAB_CHECK")); 310 $objErr->doFunc(array("FAXÈÖ¹æ2", 'fax02'), array("SPTAB_CHECK")); 311 $objErr->doFunc(array("FAXÈÖ¹æ3", 'fax03'), array("SPTAB_CHECK")); 312 $objErr->doFunc(array("FAXÈÖ¹æ", "fax01", "fax02", "fax03", TEL_ITEM_LEN) ,array("TEL_CHECK")); 313 $objErr->doFunc(array("¤´ÀÊÌ", "sex") ,array("SELECT_CHECK", "NUM_CHECK")); 314 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É", 'password', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK", "NUM_RANGE_CHECK")); 315 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É(³Îǧ)", 'password02', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK", "NUM_RANGE_CHECK")); 316 $objErr->doFunc(array('¥Ñ¥¹¥ï¡¼¥É', '¥Ñ¥¹¥ï¡¼¥É(³Îǧ)', "password", "password02") ,array("EQUAL_CHECK")); 317 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿¤È¤¤Î¥Ò¥ó¥È ¼ÁÌä", "reminder") ,array("SELECT_CHECK", "NUM_CHECK")); 318 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É¤ò˺¤ì¤¿¤È¤¤Î¥Ò¥ó¥È Åú¤¨", "reminder_answer", STEXT_LEN) ,array("EXIST_CHECK","SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 319 $objErr->doFunc(array("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mail_flag") ,array("SELECT_CHECK", "NUM_CHECK")); 320 321 $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE")); 322 $objErr->doFunc(array("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", 'mail_flag'), array("SELECT_CHECK")); 323 323 324 324 return $objErr->arrErr; 325 325 } 326 326 327 // キャンペーン受注テーブルへ登録327 // ¥¥ã¥ó¥Ú¡¼¥ó¼õÃí¥Æ¡¼¥Ö¥ë¤ØÅÐÏ¿ 328 328 function lfRegistCampaignOrder($uniqid) { 329 329 … … 332 332 $campaign_id = $objCampaignSess->getCampaignId(); 333 333 334 // 受注データを取得334 // ¼õÃí¥Ç¡¼¥¿¤ò¼èÆÀ 335 335 $cols = " 336 336 customer_id, … … 365 365 $sqlval['create_date'] = 'now()'; 366 366 367 // INSERT の実行367 // INSERT¤Î¼Â¹Ô 368 368 $objQuery->insert("dtb_campaign_order", $sqlval); 369 369 370 // 申し込み数の更新370 // ¿½¤·¹þ¤ß¿ô¤Î¹¹¿· 371 371 $total_count = $objQuery->get("dtb_campaign", "total_count", "campaign_id = ?", array($campaign_id)); 372 372 $arrCampaign['total_count'] = $total_count += 1; … … 374 374 } 375 375 376 // 確認ページ用パスワード表示用376 //³Îǧ¥Ú¡¼¥¸Íѥѥ¹¥ï¡¼¥Éɽ¼¨ÍÑ 377 377 378 378 function lfPassLen($passlen){
Note: See TracChangeset
for help on using the changeset viewer.
