Changeset 12435
- Timestamp:
- 2007/05/10 12:01:30 (17 years ago)
- File:
-
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/mobile/nonmember/shopping_index.php
r12428 r12435 1 1 <?php 2 /* 3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved. 2 /** 3 * 4 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved. 4 5 * 5 6 * http://www.lockon.co.jp/ 7 * 6 8 */ 7 9 … … 9 11 10 12 class LC_Page { 11 function LC_Page() { 12 $this->tpl_mainpage = 'nonmember/index.tpl'; // ¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È 13 $this->tpl_title .= '¤ªµÒÍ;ðÊóÆþÎÏ(1/3)'; //¡¡¥Ú¡¼¥¸¥¿¥¤¥È¥ë 14 } 15 } 16 17 //---- ¥Ú¡¼¥¸½é´üÀßÄê 18 $CONF = sf_getBasisData(); // ŹÊÞ´ðËܾðÊó 19 $objConn = new SC_DbConn(); 13 var $arrSession; 14 var $tpl_mode; 15 var $tpl_login_email; 16 function LC_Page() { 17 $this->tpl_mainpage = 'shopping/nonmember.tpl'; 18 global $arrPref; 19 $this->arrPref = $arrPref; 20 global $arrSex; 21 $this->arrSex = $arrSex; 22 global $arrJob; 23 $this->arrJob = $arrJob; 24 $this->tpl_onload = 'fnCheckInputDeliv();'; 25 26 /* 27 session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç 28 ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤Î͸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ 29 private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ 30 */ 31 session_cache_limiter('private-no-expire'); 32 } 33 } 34 35 $conn = new SC_DBConn(); 20 36 $objPage = new LC_Page(); 21 37 $objView = new SC_MobileView(); 22 $objDate = new SC_Date(START_BIRTH_YEAR, date("Y",strtotime("now"))); 23 $objPage->arrPref = $arrPref; 24 $objPage->arrJob = $arrJob; 25 $objPage->arrReminder = $arrReminder; 26 $objPage->arrYear = $objDate->getYear('', 1950); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 38 $objSiteSess = new SC_SiteSession(); 39 $objCartSess = new SC_CartSession(); 40 $objCustomer = new SC_Customer(); 41 $objCookie = new SC_Cookie(); 42 $objFormParam = new SC_FormParam(); // ¥Õ¥©¡¼¥àÍÑ 43 lfInitParam(); // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ 44 $objFormParam->setParam($_POST); // POSTÃͤμèÆÀ 45 46 // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ¤ò¥Á¥§¥Ã¥¯ 47 $uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); 48 49 $objPage->tpl_uniqid = $uniqid; 50 51 // ¥í¥°¥¤¥ó¥Á¥§¥Ã¥¯ 52 if($objCustomer->isLoginSuccess()) { 53 // ¤¹¤Ç¤Ë¥í¥°¥¤¥ó¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¡¢¤ªÆϤ±ÀèÀßÄê²èÌ̤ËžÁ÷ 54 header("Location: " . gfAddSessionId('deliv.php')); 55 exit; 56 } 57 58 // ·ÈÂÓüËöID¤¬°ìÃפ¹¤ë²ñ°÷¤¬Â¸ºß¤¹¤ë¤«¤É¤¦¤«¤ò¥Á¥§¥Ã¥¯¤¹¤ë¡£ 59 $objPage->tpl_valid_phone_id = $objCustomer->checkMobilePhoneId(); 60 61 switch($_POST['mode']) { 62 case 'nonmember_confirm': 63 $objPage = lfSetNonMember($objPage); 64 // ¢¨break¤Ê¤· 65 case 'confirm': 66 // ÆþÎÏÃͤÎÊÑ´¹ 67 $objFormParam->convParam(); 68 $objFormParam->toLower('order_mail'); 69 $objFormParam->toLower('order_mail_check'); 70 71 $objPage->arrErr = lfCheckError(); 72 73 // ÆþÎÏ¥¨¥é¡¼¤Ê¤· 74 if(count($objPage->arrErr) == 0) { 75 // DB¤Ø¤Î¥Ç¡¼¥¿ÅÐÏ¿ 76 lfRegistData($uniqid); 77 // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµÏ¿¤·¤Æ¤ª¤¯ 78 $objSiteSess->setRegistFlag(); 79 // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° 80 header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); 81 exit; 82 } 83 84 break; 85 // Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë 86 case 'return': 87 // ³Îǧ¥Ú¡¼¥¸¤Ø°ÜÆ° 88 header("Location: " . gfAddSessionId(MOBILE_URL_CART_TOP)); 89 exit; 90 break; 91 case 'nonmember': 92 $objPage = lfSetNonMember($objPage); 93 // ¢¨break¤Ê¤· 94 default: 95 if($_GET['from'] == 'nonmember') { 96 $objPage = lfSetNonMember($objPage); 97 } 98 // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ 99 $uniqid = $objSiteSess->getUniqId(); 100 $objQuery = new SC_Query(); 101 $where = "order_temp_id = ?"; 102 $arrRet = $objQuery->select("*", "dtb_order_temp", $where, array($uniqid)); 103 // DBÃͤμèÆÀ 104 $objFormParam->setParam($arrRet[0]); 105 $objFormParam->setValue('order_email_check', $arrRet[0]['order_email']); 106 $objFormParam->setDBDate($arrRet[0]['order_birth']); 107 break; 108 } 109 110 // ¥¯¥Ã¥¡¼È½Äê 111 $objPage->tpl_login_email = $objCookie->getCookie('login_email'); 112 if($objPage->tpl_login_email != "") { 113 $objPage->tpl_login_memory = "1"; 114 } 115 116 // ÁªÂòÍÑÆüÉդμèÆÀ 117 $objDate = new SC_Date(START_BIRTH_YEAR); 118 $objPage->arrYear = $objDate->getYear('', 1950); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 27 119 $objPage->arrMonth = $objDate->getMonth(); 28 120 $objPage->arrDay = $objDate->getDay(); 29 121 30 //SSLURLȽÄê 31 if (SSLURL_CHECK == 1){ 32 $ssl_url= sfRmDupSlash(MOBILE_SSL_URL.$_SERVER['REQUEST_URI']); 33 if (!ereg("^https://", $non_ssl_url)){ 34 sfDispSiteError(URL_ERROR, "", false, "", true); 35 } 36 } 37 38 // ¥ì¥¤¥¢¥¦¥È¥Ç¥¶¥¤¥ó¤ò¼èÆÀ 39 $objPage = sfGetPageLayout($objPage, false, DEF_LAYOUT); 40 41 //---- ÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó 42 $arrRegistColumn = array( 43 array( "column" => "name01", "convert" => "aKV" ), 44 array( "column" => "name02", "convert" => "aKV" ), 45 array( "column" => "kana01", "convert" => "CKV" ), 46 array( "column" => "kana02", "convert" => "CKV" ), 47 array( "column" => "zip01", "convert" => "n" ), 48 array( "column" => "zip02", "convert" => "n" ), 49 array( "column" => "pref", "convert" => "n" ), 50 array( "column" => "addr01", "convert" => "aKV" ), 51 array( "column" => "addr02", "convert" => "aKV" ), 52 array( "column" => "email", "convert" => "a" ), 53 array( "column" => "email2", "convert" => "a" ), 54 array( "column" => "email_mobile", "convert" => "a" ), 55 array( "column" => "email_mobile2", "convert" => "a" ), 56 array( "column" => "tel01", "convert" => "n" ), 57 array( "column" => "tel02", "convert" => "n" ), 58 array( "column" => "tel03", "convert" => "n" ), 59 array( "column" => "fax01", "convert" => "n" ), 60 array( "column" => "fax02", "convert" => "n" ), 61 array( "column" => "fax03", "convert" => "n" ), 62 array( "column" => "sex", "convert" => "n" ), 63 array( "column" => "job", "convert" => "n" ), 64 array( "column" => "birth", "convert" => "n" ), 65 array( "column" => "reminder", "convert" => "n" ), 66 array( "column" => "reminder_answer", "convert" => "aKV"), 67 array( "column" => "password", "convert" => "a" ), 68 array( "column" => "password02", "convert" => "a" ), 69 array( "column" => "mailmaga_flg", "convert" => "n" ), 70 ); 71 72 //---- ÅÐÏ¿½ü³°ÍÑ¥«¥é¥àÇÛÎó 73 $arrRejectRegistColumn = array("year", "month", "day", "email02", "email_mobile02","password","password02","reminder","reminder_answer"); 74 75 if ($_SERVER["REQUEST_METHOD"] == "POST") { 76 77 //-- POST¥Ç¡¼¥¿¤Î°ú¤·Ñ¤® 78 $objPage->arrForm = $_POST; 79 80 if($objPage->arrForm['year'] == '----') { 81 $objPage->arrForm['year'] = ''; 82 } 83 84 $objPage->arrForm['email'] = strtolower($objPage->arrForm['email']); // email¤Ï¤¹¤Ù¤Æ¾®Ê¸»ú¤Ç½èÍý 85 86 //-- ÆþÎϥǡ¼¥¿¤ÎÊÑ´¹ 87 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); 88 89 // Ìá¤ë¥Ü¥¿¥óÍѽèÍý 90 if (!empty($_POST["return"])) { 91 switch ($_POST["mode"]) { 92 case "complete": 93 $_POST["mode"] = "set3"; 94 break; 95 case "confirm": 96 $_POST["mode"] = "set2"; 97 break; 98 default: 99 $_POST["mode"] = "set1"; 100 break; 101 } 102 } 103 104 //--¡¡ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 105 if (!empty($_POST["mode"])) { 106 if ($_POST["mode"] == "set1") { 107 $objPage->arrErr = lfErrorCheck1($objPage->arrForm); 108 $objPage->tpl_mainpage = 'nonmember/index.tpl'; 109 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(1/3)'; 110 } elseif ($_POST["mode"] == "set2") { 111 $objPage->arrErr = lfErrorCheck2($objPage->arrForm); 112 $objPage->tpl_mainpage = 'nonmember/set1.tpl'; 113 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(2/3)'; 114 } else { 115 $objPage->arrErr = lfErrorCheck3($objPage->arrForm); 116 $objPage->tpl_mainpage = 'nonmember/set2.tpl'; 117 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(3/3)'; 118 } 119 120 121 foreach($objPage->arrForm as $key => $val) { 122 $objPage->$key = $val; 123 } 124 } 125 126 127 if ($objPage->arrErr || !empty($_POST["return"])) { // ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 128 129 //-- ¥Ç¡¼¥¿¤ÎÀßÄê 130 if ($_POST["mode"] == "set1") { 131 $checkVal = array("email", "name01", "name02", "kana01", "kana02"); 132 } elseif ($_POST["mode"] == "set2") { 133 $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); 134 } else { 135 $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); 136 } 137 138 foreach($objPage->arrForm as $key => $val) { 139 if ($key != "mode" && $key != "submit" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) 140 $objPage->list_data[ $key ] = $val; 141 } 142 143 144 145 } else { 146 147 //--¡¡¥Æ¥ó¥×¥ì¡¼¥ÈÀßÄê 148 if ($_POST["mode"] == "set1") { 149 $objPage->tpl_mainpage = 'nonmember/set1.tpl'; 150 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(2/3)'; 151 } elseif ($_POST["mode"] == "set2") { 152 $objPage->tpl_mainpage = 'nonmember/set2.tpl'; 153 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(3/3)'; 154 155 if (@$objPage->arrForm['pref'] == "" && @$objPage->arrForm['addr01'] == "" && @$objPage->arrForm['addr02'] == "") { 156 $address = lfGetAddress($_REQUEST['zip01'].$_REQUEST['zip02']); 157 $objPage->pref = @$address[0]['state']; 158 $objPage->addr01 = @$address[0]['city'] . @$address[0]['town']; 159 } 160 } elseif ($_POST["mode"] == "confirm") { 161 //¥Ñ¥¹¥ï¡¼¥Éɽ¼¨ 162 163 //¥á¡¼¥ë¼õ¤±¼è¤ê 164 if (strtolower($objPage->arrForm['mail_flag']) == "on") { 165 $objPage->arrForm['mail_flag'] = "2"; 166 } else { 167 $objPage->arrForm['mail_flag'] = "3"; 168 } 169 170 $objPage->tpl_mainpage = 'nonmember/confirm.tpl'; 171 $objPage->tpl_title = '¤ªµÒÍ;ðÊó(³Îǧ¥Ú¡¼¥¸)'; 172 173 } 174 175 //-- ¥Ç¡¼¥¿ÀßÄê 176 unset($objPage->list_data); 177 if ($_POST["mode"] == "set1") { 178 $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); 179 } elseif ($_POST["mode"] == "set2") { 180 $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); 181 } else { 182 $checkVal = array(); 183 } 184 185 foreach($objPage->arrForm as $key => $val) { 186 if ($key != "mode" && $key != "submit" && $key != "confirm" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) { 187 $objPage->list_data[ $key ] = $val; 188 } 189 } 190 191 if ($_POST["mode"] == "deliv") { 192 193 194 $objPage->tpl_mainpage = 'nonmember/deliv.tpl'; 195 $objPage->tpl_title = '¤ªÆϤ±Àè¾ðÊó'; 196 } 197 198 //--¡¡²¾ÅÐÏ¿¤È´°Î»²èÌÌ 199 if ($_POST["mode"] == "complete") { 200 //$objPage->uniqid = lfRegistData ($objPage->arrForm, $arrRegistColumn, $arrRejectRegistColumn); 201 202 // ¶õ¥á¡¼¥ë¤ò¼õ¿®ºÑ¤ß¤Î¾ì¹ç¤Ï¤¹¤°¤ËËÜÅÐÏ¿´°Î»¤Ë¤¹¤ë¡£ 203 if (isset($_SESSION['mobile']['kara_mail_from'])) { 204 header("Location:" . gfAddSessionId(MOBILE_URL_DIR . "regist/index.php?mode=regist&id=" . $objPage->uniqid)); 205 exit; 206 } 207 208 $objPage->tpl_mainpage = 'nonmember/complete.tpl'; 209 $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(´°Î»¥Ú¡¼¥¸)'; 210 211 /*sfMobileSetExtSessionId('id', $objPage->uniqid, 'regist/index.php'); 212 213 //¡¡²¾ÅÐÏ¿´°Î»¥á¡¼¥ëÁ÷¿® 214 $objPage->CONF = $CONF; 215 $objPage->to_name01 = $_POST['name01']; 216 $objPage->to_name02 = $_POST['name02']; 217 $objMailText = new SC_MobileView(); 218 $objMailText->assignobj($objPage); 219 $subject = sfMakesubject('¤ªµÒÍ;ðÊó¤Î¤´³Îǧ'); 220 $toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl"); 221 $objMail = new GC_SendMail(); 222 $objMail->setItem( 223 '' //¡¡°¸Àè 224 , $subject //¡¡¥µ¥Ö¥¸¥§¥¯¥È 225 , $toCustomerMail //¡¡ËÜʸ 226 , $CONF["email03"] //¡¡ÇÛÁ÷¸µ¥¢¥É¥ì¥¹ 227 , $CONF["shop_name"] //¡¡ÇÛÁ÷¸µ¡¡Ì¾Á° 228 , $CONF["email03"] //¡¡reply_to 229 , $CONF["email04"] //¡¡return_path 230 , $CONF["email04"] // Errors_to 231 , $CONF["email01"] // Bcc 232 ); 233 // °¸Àè¤ÎÀßÄê 234 $name = $_POST["name01"] . $_POST["name02"] ." ÍÍ"; 235 $objMail->setTo($_POST["email"], $name); 236 $objMail->sendMail(); 237 */ 238 // ´°Î»¥Ú¡¼¥¸¤Ë°ÜÆ°¤µ¤»¤ë¡£ 239 header("Location:" . gfAddSessionId("./complete.php")); 240 exit; 241 } 242 } 243 } 244 245 //----¡¡¥Ú¡¼¥¸É½¼¨ 122 if($objPage->year == '') { 123 $objPage->year = '----'; 124 } 125 126 // ÆþÎÏÃͤμèÆÀ 127 $objPage->arrForm = $objFormParam->getFormParamList(); 128 129 if($objPage->arrForm['year']['value'] == ""){ 130 $objPage->arrForm['year']['value'] = '----'; 131 } 132 246 133 $objView->assignobj($objPage); 247 134 $objView->display(SITE_FRAME); 248 249 //---------------------------------------------------------------------------------------------------------------------- 250 251 //---- function·² 252 function lfRegistData ($array, $arrRegistColumn, $arrRejectRegistColumn) { 253 global $objConn; 254 255 // ²¾ÅÐÏ¿ 256 foreach ($arrRegistColumn as $data) { 257 if (strlen($array[ $data["column"] ]) > 0 && ! in_array($data["column"], $arrRejectRegistColumn)) { 258 $arrRegist[ $data["column"] ] = $array[ $data["column"] ]; 259 } 260 } 261 262 // ÃÂÀ¸Æü¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ë¾ì¹ç 263 if (strlen($array["year"]) > 0 ) { 264 $arrRegist["birth"] = $array["year"] ."/". $array["month"] ."/". $array["day"] ." 00:00:00"; 265 } 266 267 // ¥Ñ¥¹¥ï¡¼¥É¤Î°Å¹æ²½ 268 $arrRegist["password"] = sha1($arrRegist["password"] . ":" . AUTH_MAGIC); 269 270 $count = 1; 271 while ($count != 0) { 272 $uniqid = sfGetUniqRandomId("t"); 273 $count = $objConn->getOne("SELECT COUNT(*) FROM dtb_customer WHERE secret_key = ?", array($uniqid)); 274 } 275 276 switch($array["mailmaga_flg"]) { 277 case 1: 278 $arrRegist["mailmaga_flg"] = 4; 279 break; 280 case 2: 281 $arrRegist["mailmaga_flg"] = 5; 282 break; 283 default: 284 $arrRegist["mailmaga_flg"] = 6; 285 break; 286 } 287 288 $arrRegist["secret_key"] = $uniqid; // ²¾ÅÐÏ¿IDȯ¹Ô 289 $arrRegist["create_date"] = "now()"; // ºîÀ®Æü 290 $arrRegist["update_date"] = "now()"; // ¹¹¿·Æü 291 $arrRegist["first_buy_date"] = ""; // ºÇ½é¤Î¹ØÆþÆü 292 293 // ·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹ 294 $arrRegist['email_mobile'] = $arrRegist['email']; 295 296 //-- ²¾ÅÐÏ¿¼Â¹Ô 297 $objConn->query("BEGIN"); 298 299 $objQuery = new SC_Query(); 300 $objQuery->insert("dtb_customer", $arrRegist); 301 302 /* ¥á¥ë¥Þ¥¬²ñ°÷µ¡Ç½¤Ï¸½ºßÄä»ßÃæ¡¡2007/03/07 303 //--¡¡Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¤«¤ÎȽÄê 304 $sql = "SELECT count(*) FROM dtb_customer_mail WHERE email = ?"; 305 $mailResult = $objConn->getOne($sql, array($arrRegist["email"])); 306 307 //--¡¡¥á¥ë¥Þ¥¬²¾ÅÐÏ¿¼Â¹Ô 308 $arrRegistMail["email"] = $arrRegist["email"]; 309 if ($array["mailmaga_flg"] == 1) { 310 $arrRegistMail["mailmaga_flg"] = 4; 311 } elseif ($array["mailmaga_flg"] == 2) { 312 $arrRegistMail["mailmaga_flg"] = 5; 313 } else { 314 $arrRegistMail["mailmaga_flg"] = 6; 315 } 316 $arrRegistMail["update_date"] = "now()"; 317 318 // Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¾ì¹ç 319 if ($mailResult == 1) { 320 $objQuery->update("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($arrRegistMail["email"]). "'"); 321 } else { //¡¡¿·µ¬ÅÐÏ¿¤Î¾ì¹ç 322 $arrRegistMail["create_date"] = "now()"; 323 $objQuery->insert("dtb_customer_mail", $arrRegistMail); 324 } 325 */ 326 $objConn->query("COMMIT"); 327 328 return $uniqid; 329 } 330 331 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 332 function lfConvertParam($array, $arrRegistColumn) { 333 /* 334 * ʸ»úÎó¤ÎÊÑ´¹ 335 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ 336 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ 337 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 338 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹ 339 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë 340 */ 341 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó 342 foreach ($arrRegistColumn as $data) { 343 $arrConvList[ $data["column"] ] = $data["convert"]; 344 } 345 // ʸ»úÊÑ´¹ 346 foreach ($arrConvList as $key => $val) { 347 // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£ 348 if(strlen(($array[$key])) > 0) { 349 $array[$key] = mb_convert_kana($array[$key] ,$val); 350 } 351 } 352 return $array; 353 } 354 355 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 356 function lfErrorCheck1($array) { 357 358 global $objConn; 359 $objErr = new SC_CheckError($array); 360 361 $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 362 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 363 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 364 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 365 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); 366 367 //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä 368 369 return $objErr->arrErr; 370 } 371 372 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 373 function lfErrorCheck2($array) { 374 375 global $objConn, $objDate; 376 $objErr = new SC_CheckError($array); 377 378 $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 379 $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 380 $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 381 382 $objErr->doFunc(array("ÀÊÌ", "sex") ,array("SELECT_CHECK", "NUM_CHECK")); 383 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", 4), array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 384 if (!isset($objErr->arrErr['year'])) { 385 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", $objDate->getStartYear()), array("MIN_CHECK")); 386 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", $objDate->getEndYear()), array("MAX_CHECK")); 387 } 388 $objErr->doFunc(array("À¸Ç¯·îÆü (·îÆü)", "month", "day"), array("SELECT_CHECK")); 389 if (!isset($objErr->arrErr['year']) && !isset($objErr->arrErr['month']) && !isset($objErr->arrErr['day'])) { 390 $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE")); 391 } 392 393 return $objErr->arrErr; 394 } 395 396 //---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 397 function lfErrorCheck3($array) { 398 399 global $objConn; 400 $objErr = new SC_CheckError($array); 401 402 $objErr->doFunc(array("ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 403 $objErr->doFunc(array("»Ô¶èĮ¼", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 404 $objErr->doFunc(array("ÈÖÃÏ", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 405 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK","SPTAB_CHECK" )); 406 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","SPTAB_CHECK" )); 407 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","SPTAB_CHECK" )); 408 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03",TEL_ITEM_LEN) ,array("TEL_CHECK")); 409 410 return $objErr->arrErr; 411 } 412 413 //³Îǧ¥Ú¡¼¥¸Íѥѥ¹¥ï¡¼¥Éɽ¼¨ÍÑ 414 415 function lfPassLen($passlen){ 416 $ret = ""; 417 for ($i=0;$i<$passlen;true){ 418 $ret.="*"; 419 $i++; 420 } 421 return $ret; 422 } 423 424 425 // ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ 426 function lfGetAddress($zipcode) { 427 global $arrPref; 428 429 $conn = new SC_DBconn(ZIP_DSN); 430 431 // ͹ÊØÈֹ渡º÷ʸºîÀ® 432 $zipcode = mb_convert_kana($zipcode ,"n"); 433 $sqlse = "SELECT state, city, town FROM mtb_zip WHERE zipcode = ?"; 434 435 $data_list = $conn->getAll($sqlse, array($zipcode)); 436 437 // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤ÈÃͤòȿž¤µ¤»¤ë¡£ 438 $arrREV_PREF = array_flip($arrPref); 439 440 /* 441 Áí̳¾Ê¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È 442 °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç Âкö¤¹¤ë¡£ 443 ¡¦¡Ê£±¡¦£±£¹ÃúÌÜ¡Ë 444 ¡¦°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç 445 */ 446 $town = $data_list[0]['town']; 447 $town = ereg_replace("¡Ê.*¡Ë$","",$town); 448 $town = ereg_replace("°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç","",$town); 449 $data_list[0]['town'] = $town; 450 $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; 451 452 return $data_list; 453 } 454 455 //----------------------------------------------------------------------------------------------------------------------------------- 135 //-------------------------------------------------------------------------------------------------------------------------- 136 /* Èó²ñ°÷ÆþÎÏ¥Ú¡¼¥¸¤Î¥»¥Ã¥È */ 137 function lfSetNonMember($objPage) { 138 $objPage->tpl_mainpage = 'nonmember/nonmember_input.tpl'; 139 $objPage->tpl_css = array(); 140 $objPage->tpl_css[] = '/css/layout/login/nonmember.css'; 141 return $objPage; 142 } 143 144 /* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ 145 function lfInitParam() { 146 global $objFormParam; 147 $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "order_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 148 $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "order_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 149 $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "order_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 150 $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "order_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 151 $objFormParam->addParam("͹ÊØÈÖ¹æ1", "order_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 152 $objFormParam->addParam("͹ÊØÈÖ¹æ2", "order_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 153 $objFormParam->addParam("ÅÔÆ»Éܸ©", "order_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 154 $objFormParam->addParam("½»½ê1", "order_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 155 $objFormParam->addParam("½»½ê2", "order_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); 156 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "order_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); 157 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "order_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); 158 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "order_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); 159 $objFormParam->addParam("FAXÈÖ¹æ1", "order_fax01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 160 $objFormParam->addParam("FAXÈÖ¹æ2", "order_fax02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 161 $objFormParam->addParam("FAXÈÖ¹æ3", "order_fax03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 162 $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "order_email", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK")); 163 $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ê³Îǧ¡Ë", "order_email_check", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK"), "", false); 164 $objFormParam->addParam("ǯ", "year", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); 165 $objFormParam->addParam("·î", "month", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); 166 $objFormParam->addParam("Æü", "day", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); 167 $objFormParam->addParam("ÀÊÌ", "order_sex", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); 168 $objFormParam->addParam("¿¦¶È", "order_job", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 169 $objFormParam->addParam("Ê̤ΤªÆϤ±Àè", "deliv_check", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 170 $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "deliv_name01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 171 $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "deliv_name02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 172 $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "deliv_kana01", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 173 $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "deliv_kana02", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 174 $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); 175 $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); 176 $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); 177 $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 178 $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); 179 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 180 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 181 $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); 182 $objFormParam->addParam("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mail_flag", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"), 1); 183 } 184 185 /* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */ 186 function lfRegistData($uniqid) { 187 global $objFormParam; 188 $arrRet = $objFormParam->getHashArray(); 189 $sqlval = $objFormParam->getDbArray(); 190 // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® 191 $sqlval['order_temp_id'] = $uniqid; 192 $sqlval['order_birth'] = sfGetTimestamp($arrRet['year'], $arrRet['month'], $arrRet['day']); 193 $sqlval['update_date'] = 'Now()'; 194 $sqlval['customer_id'] = '0'; 195 196 // ´û¸¥Ç¡¼¥¿¤Î¥Á¥§¥Ã¥¯ 197 $objQuery = new SC_Query(); 198 $where = "order_temp_id = ?"; 199 $cnt = $objQuery->count("dtb_order_temp", $where, array($uniqid)); 200 // ´û¸¥Ç¡¼¥¿¤¬¤Ê¤¤¾ì¹ç 201 if ($cnt == 0) { 202 $sqlval['create_date'] = 'Now()'; 203 $objQuery->insert("dtb_order_temp", $sqlval); 204 } else { 205 $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid)); 206 } 207 } 208 209 /* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */ 210 function lfCheckError() { 211 global $objFormParam; 212 // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ 213 $arrRet = $objFormParam->getHashArray(); 214 $objErr = new SC_CheckError($arrRet); 215 $objErr->arrErr = $objFormParam->checkError(); 216 217 // Ê̤ΤªÆϤ±Àè¥Á¥§¥Ã¥¯ 218 if($_POST['deliv_check'] == "1") { 219 $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", "deliv_name01"), array("EXIST_CHECK")); 220 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", "deliv_name02"), array("EXIST_CHECK")); 221 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "deliv_kana01"), array("EXIST_CHECK")); 222 $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "deliv_kana02"), array("EXIST_CHECK")); 223 $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "deliv_zip01"), array("EXIST_CHECK")); 224 $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "deliv_zip02"), array("EXIST_CHECK")); 225 $objErr->doFunc(array("ÅÔÆ»Éܸ©", "deliv_pref"), array("EXIST_CHECK")); 226 $objErr->doFunc(array("½»½ê1", "deliv_addr01"), array("EXIST_CHECK")); 227 $objErr->doFunc(array("½»½ê2", "deliv_addr02"), array("EXIST_CHECK")); 228 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ1", "deliv_tel01"), array("EXIST_CHECK")); 229 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", "deliv_tel02"), array("EXIST_CHECK")); 230 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", "deliv_tel03"), array("EXIST_CHECK")); 231 } 232 233 // Ê£¿ô¹àÌÜ¥Á¥§¥Ã¥¯ 234 $objErr->doFunc(array("TEL", "order_tel01", "order_tel02", "order_tel03", TEL_ITEM_LEN), array("TEL_CHECK")); 235 $objErr->doFunc(array("FAX", "order_fax01", "order_fax02", "order_fax03", TEL_ITEM_LEN), array("TEL_CHECK")); 236 $objErr->doFunc(array("͹ÊØÈÖ¹æ", "order_zip01", "order_zip02"), array("ALL_EXIST_CHECK")); 237 $objErr->doFunc(array("TEL", "deliv_tel01", "deliv_tel02", "deliv_tel03", TEL_ITEM_LEN), array("TEL_CHECK")); 238 $objErr->doFunc(array("FAX", "deliv_fax01", "deliv_fax02", "deliv_fax03", TEL_ITEM_LEN), array("TEL_CHECK")); 239 $objErr->doFunc(array("͹ÊØÈÖ¹æ", "deliv_zip01", "deliv_zip02"), array("ALL_EXIST_CHECK")); 240 $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE")); 241 $objErr->doFunc(array("¥á¡¼¥ë¥¢¥É¥ì¥¹", "¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ê³Îǧ¡Ë", "order_email", "order_email_check"), array("EQUAL_CHECK")); 242 243 // ¤¹¤Ç¤Ë¥á¥ë¥Þ¥¬¥Æ¡¼¥Ö¥ë¤Ë²ñ°÷¤È¤·¤Æ¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¾ì¹ç 244 if(sfCheckCustomerMailMaga($arrRet['order_email'])) { 245 $objErr->arrErr['order_email'] = "¤³¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤Ï¤¹¤Ç¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤¹¡£<br>"; 246 } 247 248 return $objErr->arrErr; 249 } 456 250 ?>
Note: See TracChangeset
for help on using the changeset viewer.