Changeset 12436 for branches/dev/html/mobile
- Timestamp:
- 2007/05/10 12:01:47 (19 years ago)
- File:
-
- 1 copied
-
branches/dev/html/mobile/nonmember/entry_index.php (copied) (copied from branches/dev/html/mobile/nonmember/index.php) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/mobile/nonmember/entry_index.php
r12428 r12436 9 9 10 10 class LC_Page { 11 function LC_Page() {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 $ssl_url= sfRmDupSlash(MOBILE_SSL_URL.$_SERVER['REQUEST_URI']);33 if (!ereg("^https://", $non_ssl_url)){34 sfDispSiteError(URL_ERROR, "", false, "", true);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 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 );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 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);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 $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 }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 $objConn->query("COMMIT");327 328 return $uniqid;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 * 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;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 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;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 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;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 $ret = "";417 for ($i=0;$i<$passlen;true){418 $ret.="*";419 $i++;420 }421 return $ret;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 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;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.
