Changeset 12436
- Timestamp:
- 2007/05/10 12:01:47 (17 years ago)
- File:
-
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/mobile/nonmember/entry_index.php
r12428 r12436 9 9 10 10 class LC_Page { 11 12 $this->tpl_mainpage = 'nonmember/index.tpl';// ¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È13 $this->tpl_title .= '¤ªµÒÍ;ðÊóÆþÎÏ(1/3)';//¡¡¥Ú¡¼¥¸¥¿¥¤¥È¥ë14 11 function LC_Page() { 12 $this->tpl_mainpage = 'entry/index.tpl'; // ¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È 13 $this->tpl_title .= '²ñ°÷ÅÐÏ¿(1/3)'; //¡¡¥Ú¡¼¥¸¥¿¥¤¥È¥ë 14 } 15 15 } 16 16 17 17 //---- ¥Ú¡¼¥¸½é´üÀßÄê 18 $CONF = sf_getBasisData(); 18 $CONF = sf_getBasisData(); // ŹÊÞ´ðËܾðÊó 19 19 $objConn = new SC_DbConn(); 20 20 $objPage = new LC_Page(); … … 24 24 $objPage->arrJob = $arrJob; 25 25 $objPage->arrReminder = $arrReminder; 26 $objPage->arrYear = $objDate->getYear('', 1950); 26 $objPage->arrYear = $objDate->getYear('', 1950); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê 27 27 $objPage->arrMonth = $objDate->getMonth(); 28 28 $objPage->arrDay = $objDate->getDay(); 29 29 30 // ¶õ¥á¡¼¥ë 31 if (isset($_SESSION['mobile']['kara_mail_from'])) { 32 $objPage->tpl_kara_mail_from = $_POST['email'] = $_SESSION['mobile']['kara_mail_from']; 33 } elseif (MOBILE_USE_KARA_MAIL) { 34 $token = gfPrepareKaraMail('entry/index.php'); 35 if ($token !== false) { 36 $objPage->tpl_mainpage = 'entry/mail.tpl'; 37 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(¶õ¥á¡¼¥ë)'; 38 $objPage->tpl_kara_mail_to = MOBILE_KARA_MAIL_ADDRESS_USER . MOBILE_KARA_MAIL_ADDRESS_DELIMITER . 'entry_' . $token . '@' . MOBILE_KARA_MAIL_ADDRESS_DOMAIN; 39 $objPage->tpl_from_address = $CONF['email03']; 40 } 41 } 42 30 43 //SSLURLȽÄê 31 44 if (SSLURL_CHECK == 1){ 32 33 34 35 45 $ssl_url= sfRmDupSlash(MOBILE_SSL_URL.$_SERVER['REQUEST_URI']); 46 if (!ereg("^https://", $non_ssl_url)){ 47 sfDispSiteError(URL_ERROR, "", false, "", true); 48 } 36 49 } 37 50 … … 41 54 //---- ÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó 42 55 $arrRegistColumn = array( 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 56 array( "column" => "name01", "convert" => "aKV" ), 57 array( "column" => "name02", "convert" => "aKV" ), 58 array( "column" => "kana01", "convert" => "CKV" ), 59 array( "column" => "kana02", "convert" => "CKV" ), 60 array( "column" => "zip01", "convert" => "n" ), 61 array( "column" => "zip02", "convert" => "n" ), 62 array( "column" => "pref", "convert" => "n" ), 63 array( "column" => "addr01", "convert" => "aKV" ), 64 array( "column" => "addr02", "convert" => "aKV" ), 65 array( "column" => "email", "convert" => "a" ), 66 array( "column" => "email2", "convert" => "a" ), 67 array( "column" => "email_mobile", "convert" => "a" ), 68 array( "column" => "email_mobile2", "convert" => "a" ), 69 array( "column" => "tel01", "convert" => "n" ), 70 array( "column" => "tel02", "convert" => "n" ), 71 array( "column" => "tel03", "convert" => "n" ), 72 array( "column" => "fax01", "convert" => "n" ), 73 array( "column" => "fax02", "convert" => "n" ), 74 array( "column" => "fax03", "convert" => "n" ), 75 array( "column" => "sex", "convert" => "n" ), 76 array( "column" => "job", "convert" => "n" ), 77 array( "column" => "birth", "convert" => "n" ), 78 array( "column" => "reminder", "convert" => "n" ), 79 array( "column" => "reminder_answer", "convert" => "aKV"), 80 array( "column" => "password", "convert" => "a" ), 81 array( "column" => "password02", "convert" => "a" ), 82 array( "column" => "mailmaga_flg", "convert" => "n" ), 83 ); 71 84 72 85 //---- ÅÐÏ¿½ü³°ÍÑ¥«¥é¥àÇÛÎó 73 $arrRejectRegistColumn = array("year", "month", "day", "email02", "email_mobile02", "password","password02","reminder","reminder_answer");86 $arrRejectRegistColumn = array("year", "month", "day", "email02", "email_mobile02", "password02"); 74 87 75 88 if ($_SERVER["REQUEST_METHOD"] == "POST") { 76 89 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 } 90 //-- POST¥Ç¡¼¥¿¤Î°ú¤·Ñ¤® 91 $objPage->arrForm = $_POST; 92 93 if($objPage->arrForm['year'] == '----') { 94 $objPage->arrForm['year'] = ''; 95 } 96 97 $objPage->arrForm['email'] = strtolower($objPage->arrForm['email']); // email¤Ï¤¹¤Ù¤Æ¾®Ê¸»ú¤Ç½èÍý 98 99 //-- ÆþÎϥǡ¼¥¿¤ÎÊÑ´¹ 100 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); 101 102 // Ìá¤ë¥Ü¥¿¥óÍѽèÍý 103 if (!empty($_POST["return"])) { 104 switch ($_POST["mode"]) { 105 case "complete": 106 $_POST["mode"] = "set3"; 107 break; 108 case "confirm": 109 $_POST["mode"] = "set2"; 110 break; 111 default: 112 $_POST["mode"] = "set1"; 113 break; 114 } 115 } 116 117 //--¡¡ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ 118 if ($_POST["mode"] == "set1") { 119 $objPage->arrErr = lfErrorCheck1($objPage->arrForm); 120 $objPage->tpl_mainpage = 'entry/index.tpl'; 121 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(1/3)'; 122 } elseif ($_POST["mode"] == "set2") { 123 $objPage->arrErr = lfErrorCheck2($objPage->arrForm); 124 $objPage->tpl_mainpage = 'entry/set1.tpl'; 125 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(2/3)'; 126 } else { 127 $objPage->arrErr = lfErrorCheck3($objPage->arrForm); 128 $objPage->tpl_mainpage = 'entry/set2.tpl'; 129 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(3/3)'; 130 } 131 132 foreach($objPage->arrForm as $key => $val) { 133 $objPage->$key = $val; 134 } 135 136 if ($objPage->arrErr || !empty($_POST["return"])) { // ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ 137 138 //-- ¥Ç¡¼¥¿¤ÎÀßÄê 139 if ($_POST["mode"] == "set1") { 140 $checkVal = array("email", "password", "reminder", "reminder_answer", "name01", "name02", "kana01", "kana02"); 141 } elseif ($_POST["mode"] == "set2") { 142 $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); 143 } else { 144 $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); 145 } 146 147 foreach($objPage->arrForm as $key => $val) { 148 if ($key != "mode" && $key != "submit" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) 149 $objPage->list_data[ $key ] = $val; 150 } 151 152 153 154 } else { 155 156 //--¡¡¥Æ¥ó¥×¥ì¡¼¥ÈÀßÄê 157 if ($_POST["mode"] == "set1") { 158 $objPage->tpl_mainpage = 'entry/set1.tpl'; 159 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(2/3)'; 160 } elseif ($_POST["mode"] == "set2") { 161 $objPage->tpl_mainpage = 'entry/set2.tpl'; 162 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(3/3)'; 163 164 if (@$objPage->arrForm['pref'] == "" && @$objPage->arrForm['addr01'] == "" && @$objPage->arrForm['addr02'] == "") { 165 $address = lfGetAddress($_REQUEST['zip01'].$_REQUEST['zip02']); 166 $objPage->pref = @$address[0]['state']; 167 $objPage->addr01 = @$address[0]['city'] . @$address[0]['town']; 168 } 169 } elseif ($_POST["mode"] == "confirm") { 170 //¥Ñ¥¹¥ï¡¼¥Éɽ¼¨ 171 $passlen = strlen($objPage->arrForm['password']); 172 $objPage->passlen = lfPassLen($passlen); 173 174 //¥á¡¼¥ë¼õ¤±¼è¤ê 175 if (strtolower($objPage->arrForm['mail_flag']) == "on") { 176 $objPage->arrForm['mail_flag'] = "2"; 177 } else { 178 $objPage->arrForm['mail_flag'] = "3"; 179 } 180 181 $objPage->tpl_mainpage = 'entry/confirm.tpl'; 182 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(³Îǧ¥Ú¡¼¥¸)'; 183 184 } 185 186 //-- ¥Ç¡¼¥¿ÀßÄê 187 unset($objPage->list_data); 188 if ($_POST["mode"] == "set1") { 189 $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); 190 } elseif ($_POST["mode"] == "set2") { 191 $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); 192 } else { 193 $checkVal = array(); 194 } 195 196 foreach($objPage->arrForm as $key => $val) { 197 if ($key != "mode" && $key != "submit" && $key != "confirm" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) { 198 $objPage->list_data[ $key ] = $val; 199 } 200 } 201 202 203 //--¡¡²¾ÅÐÏ¿¤È´°Î»²èÌÌ 204 if ($_POST["mode"] == "complete") { 205 $objPage->uniqid = lfRegistData ($objPage->arrForm, $arrRegistColumn, $arrRejectRegistColumn); 206 207 // ¶õ¥á¡¼¥ë¤ò¼õ¿®ºÑ¤ß¤Î¾ì¹ç¤Ï¤¹¤°¤ËËÜÅÐÏ¿´°Î»¤Ë¤¹¤ë¡£ 208 if (isset($_SESSION['mobile']['kara_mail_from'])) { 209 header("Location:" . gfAddSessionId(MOBILE_URL_DIR . "regist/index.php?mode=regist&id=" . $objPage->uniqid)); 210 exit; 211 } 212 213 $objPage->tpl_mainpage = 'entry/complete.tpl'; 214 $objPage->tpl_title = '²ñ°÷ÅÐÏ¿(´°Î»¥Ú¡¼¥¸)'; 215 216 sfMobileSetExtSessionId('id', $objPage->uniqid, 'regist/index.php'); 217 218 //¡¡²¾ÅÐÏ¿´°Î»¥á¡¼¥ëÁ÷¿® 219 $objPage->CONF = $CONF; 220 $objPage->to_name01 = $_POST['name01']; 221 $objPage->to_name02 = $_POST['name02']; 222 $objMailText = new SC_MobileView(); 223 $objMailText->assignobj($objPage); 224 $subject = sfMakesubject('²ñ°÷ÅÐÏ¿¤Î¤´³Îǧ'); 225 $toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl"); 226 $objMail = new GC_SendMail(); 227 $objMail->setItem( 228 '' //¡¡°¸Àè 229 , $subject //¡¡¥µ¥Ö¥¸¥§¥¯¥È 230 , $toCustomerMail //¡¡ËÜʸ 231 , $CONF["email03"] //¡¡ÇÛÁ÷¸µ¥¢¥É¥ì¥¹ 232 , $CONF["shop_name"] //¡¡ÇÛÁ÷¸µ¡¡Ì¾Á° 233 , $CONF["email03"] //¡¡reply_to 234 , $CONF["email04"] //¡¡return_path 235 , $CONF["email04"] // Errors_to 236 , $CONF["email01"] // Bcc 237 ); 238 // °¸Àè¤ÎÀßÄê 239 $name = $_POST["name01"] . $_POST["name02"] ." ÍÍ"; 240 $objMail->setTo($_POST["email"], $name); 241 $objMail->sendMail(); 242 243 // ´°Î»¥Ú¡¼¥¸¤Ë°ÜÆ°¤µ¤»¤ë¡£ 244 header("Location:" . gfAddSessionId("./complete.php")); 245 exit; 246 } 247 } 243 248 } 244 249 … … 251 256 //---- function·² 252 257 function lfRegistData ($array, $arrRegistColumn, $arrRejectRegistColumn) { 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 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 295 296 297 298 299 300 258 global $objConn; 259 260 // ²¾ÅÐÏ¿ 261 foreach ($arrRegistColumn as $data) { 262 if (strlen($array[ $data["column"] ]) > 0 && ! in_array($data["column"], $arrRejectRegistColumn)) { 263 $arrRegist[ $data["column"] ] = $array[ $data["column"] ]; 264 } 265 } 266 267 // ÃÂÀ¸Æü¤¬ÆþÎϤµ¤ì¤Æ¤¤¤ë¾ì¹ç 268 if (strlen($array["year"]) > 0 ) { 269 $arrRegist["birth"] = $array["year"] ."/". $array["month"] ."/". $array["day"] ." 00:00:00"; 270 } 271 272 // ¥Ñ¥¹¥ï¡¼¥É¤Î°Å¹æ²½ 273 $arrRegist["password"] = sha1($arrRegist["password"] . ":" . AUTH_MAGIC); 274 275 $count = 1; 276 while ($count != 0) { 277 $uniqid = sfGetUniqRandomId("t"); 278 $count = $objConn->getOne("SELECT COUNT(*) FROM dtb_customer WHERE secret_key = ?", array($uniqid)); 279 } 280 281 switch($array["mailmaga_flg"]) { 282 case 1: 283 $arrRegist["mailmaga_flg"] = 4; 284 break; 285 case 2: 286 $arrRegist["mailmaga_flg"] = 5; 287 break; 288 default: 289 $arrRegist["mailmaga_flg"] = 6; 290 break; 291 } 292 293 $arrRegist["secret_key"] = $uniqid; // ²¾ÅÐÏ¿IDȯ¹Ô 294 $arrRegist["create_date"] = "now()"; // ºîÀ®Æü 295 $arrRegist["update_date"] = "now()"; // ¹¹¿·Æü 296 $arrRegist["first_buy_date"] = ""; // ºÇ½é¤Î¹ØÆþÆü 297 298 // ·ÈÂӥ᡼¥ë¥¢¥É¥ì¥¹ 299 $arrRegist['email_mobile'] = $arrRegist['email']; 300 301 //-- ²¾ÅÐÏ¿¼Â¹Ô 302 $objConn->query("BEGIN"); 303 304 $objQuery = new SC_Query(); 305 $objQuery->insert("dtb_customer", $arrRegist); 301 306 302 307 /* ¥á¥ë¥Þ¥¬²ñ°÷µ¡Ç½¤Ï¸½ºßÄä»ßÃæ¡¡2007/03/07 303 304 305 306 307 308 $arrRegistMail["email"] = $arrRegist["email"]; 309 310 311 312 313 314 315 316 317 318 319 if ($mailResult == 1) { 320 $objQuery->update("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($arrRegistMail["email"]). "'"); 321 } else {//¡¡¿·µ¬ÅÐÏ¿¤Î¾ì¹ç322 323 $objQuery->insert("dtb_customer_mail", $arrRegistMail); 324 308 //--¡¡Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¤«¤ÎȽÄê 309 $sql = "SELECT count(*) FROM dtb_customer_mail WHERE email = ?"; 310 $mailResult = $objConn->getOne($sql, array($arrRegist["email"])); 311 312 //--¡¡¥á¥ë¥Þ¥¬²¾ÅÐÏ¿¼Â¹Ô 313 $arrRegistMail["email"] = $arrRegist["email"]; 314 if ($array["mailmaga_flg"] == 1) { 315 $arrRegistMail["mailmaga_flg"] = 4; 316 } elseif ($array["mailmaga_flg"] == 2) { 317 $arrRegistMail["mailmaga_flg"] = 5; 318 } else { 319 $arrRegistMail["mailmaga_flg"] = 6; 320 } 321 $arrRegistMail["update_date"] = "now()"; 322 323 // Èó²ñ°÷¤Ç¥á¥ë¥Þ¥¬ÅÐÏ¿¤·¤Æ¤¤¤ë¾ì¹ç 324 if ($mailResult == 1) { 325 $objQuery->update("dtb_customer_mail", $arrRegistMail, "email = '" .addslashes($arrRegistMail["email"]). "'"); 326 } else { //¡¡¿·µ¬ÅÐÏ¿¤Î¾ì¹ç 327 $arrRegistMail["create_date"] = "now()"; 328 $objQuery->insert("dtb_customer_mail", $arrRegistMail); 329 } 325 330 */ 326 327 328 331 $objConn->query("COMMIT"); 332 333 return $uniqid; 329 334 } 330 335 331 336 //----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ 332 337 function lfConvertParam($array, $arrRegistColumn) { 333 334 *ʸ»úÎó¤ÎÊÑ´¹335 *K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹336 *C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹337 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 338 *n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹339 340 341 342 343 344 345 346 347 348 349 350 351 352 338 /* 339 * ʸ»úÎó¤ÎÊÑ´¹ 340 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹ 341 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹ 342 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 343 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹ 344 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë 345 */ 346 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó 347 foreach ($arrRegistColumn as $data) { 348 $arrConvList[ $data["column"] ] = $data["convert"]; 349 } 350 // ʸ»úÊÑ´¹ 351 foreach ($arrConvList as $key => $val) { 352 // POST¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£ 353 if(strlen(($array[$key])) > 0) { 354 $array[$key] = mb_convert_kana($array[$key] ,$val); 355 } 356 } 357 return $array; 353 358 } 354 359 … … 356 361 function lfErrorCheck1($array) { 357 362 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; 363 global $objConn; 364 $objErr = new SC_CheckError($array); 365 366 $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 367 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 368 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 369 $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); 370 $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); 371 372 //¸½²ñ°÷¤ÎȽÄê ¢ª¡¡¸½²ñ°÷¤â¤·¤¯¤Ï²¾ÅÐÏ¿Ãæ¤Ï¡¢¥á¥¢¥É°ì°Õ¤¬Á°Äó¤Ë¤Ê¤Ã¤Æ¤ë¤Î¤ÇƱ¤¸¥á¥¢¥É¤ÇÅÐÏ¿ÉÔ²Ä 373 if (strlen($array["email"]) > 0) { 374 $objQuery = new SC_Query(); 375 $arrRet = $objQuery->select("email, update_date, del_flg", "dtb_customer","email ILIKE ? OR email_mobile ILIKE ? ORDER BY del_flg", array($array["email"], $array["email"])); 376 377 if(count($arrRet) > 0) { 378 if($arrRet[0]['del_flg'] != '1') { 379 // ²ñ°÷¤Ç¤¢¤ë¾ì¹ç 380 $objErr->arrErr["email"] .= "¢¨ ¤¹¤Ç¤Ë²ñ°÷ÅÐÏ¿¤Ç»ÈÍѤµ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Ç¤¹¡£<br />"; 381 } else { 382 // Âà²ñ¤·¤¿²ñ°÷¤Ç¤¢¤ë¾ì¹ç 383 $leave_time = sfDBDatetoTime($arrRet[0]['update_date']); 384 $now_time = time(); 385 $pass_time = $now_time - $leave_time; 386 // Âà²ñ¤«¤é²¿»þ´Ö-·Ð²á¤·¤Æ¤¤¤ë¤«È½Äꤹ¤ë¡£ 387 $limit_time = ENTRY_LIMIT_HOUR * 3600; 388 if($pass_time < $limit_time) { 389 $objErr->arrErr["email"] .= "¢¨ Âà²ñ¤«¤é°ìÄê´ü´Ö¤Î´Ö¤Ï¡¢Æ±¤¸¥á¡¼¥ë¥¢¥É¥ì¥¹¤ò»ÈÍѤ¹¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£<br />"; 390 } 391 } 392 } 393 } 394 395 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É", 'password', PASSWORD_LEN1, PASSWORD_LEN2), array("EXIST_CHECK", "SPTAB_CHECK" ,"ALNUM_CHECK", "NUM_RANGE_CHECK")); 396 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É³ÎǧÍѤμÁÌä", "reminder") ,array("SELECT_CHECK", "NUM_CHECK")); 397 $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É³ÎǧÍѤμÁÌä¤ÎÅú¤¨", "reminder_answer", STEXT_LEN) ,array("EXIST_CHECK","SPTAB_CHECK" , "MAX_LENGTH_CHECK")); 398 399 return $objErr->arrErr; 370 400 } 371 401 … … 373 403 function lfErrorCheck2($array) { 374 404 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 405 global $objConn, $objDate; 406 $objErr = new SC_CheckError($array); 407 408 $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 409 $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); 410 $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 411 412 $objErr->doFunc(array("ÀÊÌ", "sex") ,array("SELECT_CHECK", "NUM_CHECK")); 413 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", 4), array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 414 if (!isset($objErr->arrErr['year'])) { 415 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", $objDate->getStartYear()), array("MIN_CHECK")); 416 $objErr->doFunc(array("À¸Ç¯·îÆü (ǯ)", "year", $objDate->getEndYear()), array("MAX_CHECK")); 417 } 418 $objErr->doFunc(array("À¸Ç¯·îÆü (·îÆü)", "month", "day"), array("SELECT_CHECK")); 419 if (!isset($objErr->arrErr['year']) && !isset($objErr->arrErr['month']) && !isset($objErr->arrErr['day'])) { 420 $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE")); 421 } 422 423 return $objErr->arrErr; 394 424 } 395 425 … … 397 427 function lfErrorCheck3($array) { 398 428 399 400 401 402 403 404 405 406 407 408 409 410 429 global $objConn; 430 $objErr = new SC_CheckError($array); 431 432 $objErr->doFunc(array("ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 433 $objErr->doFunc(array("»Ô¶èĮ¼", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 434 $objErr->doFunc(array("ÈÖÃÏ", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); 435 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK","SPTAB_CHECK" )); 436 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","SPTAB_CHECK" )); 437 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","SPTAB_CHECK" )); 438 $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03",TEL_ITEM_LEN) ,array("TEL_CHECK")); 439 440 return $objErr->arrErr; 411 441 } 412 442 … … 414 444 415 445 function lfPassLen($passlen){ 416 417 418 419 420 421 446 $ret = ""; 447 for ($i=0;$i<$passlen;true){ 448 $ret.="*"; 449 $i++; 450 } 451 return $ret; 422 452 } 423 453 … … 425 455 // ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ 426 456 function lfGetAddress($zipcode) { 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤ÇÂкö¤¹¤ë¡£443 444 445 446 447 448 449 450 451 452 457 global $arrPref; 458 459 $conn = new SC_DBconn(ZIP_DSN); 460 461 // ͹ÊØÈֹ渡º÷ʸºîÀ® 462 $zipcode = mb_convert_kana($zipcode ,"n"); 463 $sqlse = "SELECT state, city, town FROM mtb_zip WHERE zipcode = ?"; 464 465 $data_list = $conn->getAll($sqlse, array($zipcode)); 466 467 // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤ÈÃͤòȿž¤µ¤»¤ë¡£ 468 $arrREV_PREF = array_flip($arrPref); 469 470 /* 471 Áí̳¾Ê¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È 472 °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç Âкö¤¹¤ë¡£ 473 ¡¦¡Ê£±¡¦£±£¹ÃúÌÜ¡Ë 474 ¡¦°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç 475 */ 476 $town = $data_list[0]['town']; 477 $town = ereg_replace("¡Ê.*¡Ë$","",$town); 478 $town = ereg_replace("°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç","",$town); 479 $data_list[0]['town'] = $town; 480 $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; 481 482 return $data_list; 453 483 } 454 484
Note: See TracChangeset
for help on using the changeset viewer.