- Timestamp:
- 2007/07/20 15:58:59 (17 years ago)
- Location:
- branches/feature-module-update
- Files:
-
- 1 edited
- 2 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update
-
Property
svn:ignore
set to
.cache
.settings
.projectOptions
-
Property
svn:ignore
set to
-
branches/feature-module-update/html/mobile/shopping/deliv_addr.php
r12157 r15078 6 6 * http://www.lockon.co.jp/ 7 7 * 8 * ÇÛÁ÷Àè¤ÎÄɲÃ8 * 配送先の追加 9 9 */ 10 10 require_once("../require.php"); … … 13 13 function LC_Page(){ 14 14 $this->tpl_mainpage = 'shopping/deliv_addr.tpl'; 15 $this->tpl_title = " ¿·¤·¤¤¤ªÆϤ±Àè¤ÎÄɲÃ";15 $this->tpl_title = "新しいお届け先の追加"; 16 16 } 17 17 } … … 25 25 $objCartSess = new SC_CartSession(); 26 26 27 // ¥í¥°¥¤¥óȽÄê27 //ログイン判定 28 28 if (!$objCustomer->isLoginSuccess()){ 29 29 sfDispSiteError(CUSTOMER_ERROR, "", false, "", true); … … 32 32 $objPage->arrForm = $_POST; 33 33 $objPage->arrPref = $arrPref; 34 //-- ¥Ç¡¼¥¿ÀßÄê34 //-- データ設定 35 35 foreach($_POST as $key => $val) { 36 36 if ($key != "mode" && $key != "return" && $key != "submit" && $key != session_name()) { … … 38 38 } 39 39 } 40 // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ¤ò¥Á¥§¥Ã¥¯40 // ユーザユニークIDの取得と購入状態の正当性をチェック 41 41 $uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); 42 42 43 // Ê̤ΤªÆϤ±Àè£Ä£ÂÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó43 //別のお届け先DB登録用カラム配列 44 44 $arrRegistColumn = array( 45 45 array( "column" => "name01", "convert" => "aKV" ), … … 57 57 ); 58 58 59 // Ìá¤ë¥Ü¥¿¥óÍѽèÍý59 // 戻るボタン用処理 60 60 if (!empty($_POST["return"])) { 61 61 switch ($_POST["mode"]) { … … 83 83 } 84 84 85 // ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ85 // 郵便番号から住所の取得 86 86 if (@$objPage->arrForm['pref'] == "" && @$objPage->arrForm['addr01'] == "" && @$objPage->arrForm['addr02'] == "") { 87 87 $address = lfGetAddress($_REQUEST['zip01'].$_REQUEST['zip02']); … … 113 113 $objPage->arrErr = lfErrorCheck($objPage->arrForm); 114 114 if (count($objPage->arrErr) == 0) { 115 // ÅÐÏ¿115 // 登録 116 116 $other_deliv_id = lfRegistData($_POST,$arrRegistColumn); 117 117 118 // ÅÐÏ¿ºÑ¤ß¤ÎÊ̤ΤªÆϤ±Àè¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Ë½ñ¤¹þ¤à118 // 登録済みの別のお届け先を受注一時テーブルに書き込む 119 119 lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id); 120 120 121 // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµÏ¿¤·¤Æ¤ª¤¯121 // 正常に登録されたことを記録しておく 122 122 $objSiteSess->setRegistFlag(); 123 // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ°123 // お支払い方法選択ページへ移動 124 124 header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); 125 125 exit; … … 131 131 $deliv_count = $objQuery->count("dtb_other_deliv", "customer_id=?", array($objCustomer->getValue('customer_id'))); 132 132 if ($deliv_count >= DELIV_ADDR_MAX){ 133 sfDispSiteError(FREE_ERROR_MSG, "", false, " ºÇÂçÅÐÏ¿·ï¿ô¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£");133 sfDispSiteError(FREE_ERROR_MSG, "", false, "最大登録件数を超えています。"); 134 134 } 135 135 } … … 140 140 //------------------------------------------------------------------------------------------------------------- 141 141 142 /* ¥¨¥é¡¼¥Á¥§¥Ã¥¯*/142 /* エラーチェック */ 143 143 function lfErrorCheck() { 144 144 $objErr = new SC_CheckError(); 145 145 146 $objErr->doFunc(array(" ¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));147 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK"));148 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));149 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));150 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));151 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));152 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK"));153 $objErr->doFunc(array(" ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK"));154 $objErr->doFunc(array(" »Ô¶èĮ¼", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));155 $objErr->doFunc(array(" ÈÖÃÏ", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));156 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK","NUM_CHECK"));157 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","NUM_CHECK"));158 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","NUM_CHECK"));159 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK"));146 $objErr->doFunc(array("お名前(姓)", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 147 $objErr->doFunc(array("お名前(名)", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK")); 148 $objErr->doFunc(array("お名前(カナ/姓)", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 149 $objErr->doFunc(array("お名前(カナ/名)", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 150 $objErr->doFunc(array("郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 151 $objErr->doFunc(array("郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 152 $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 153 $objErr->doFunc(array("都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 154 $objErr->doFunc(array("市区町村", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 155 $objErr->doFunc(array("番地", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 156 $objErr->doFunc(array("電話番号1", 'tel01'), array("EXIST_CHECK","NUM_CHECK")); 157 $objErr->doFunc(array("電話番号2", 'tel02'), array("EXIST_CHECK","NUM_CHECK")); 158 $objErr->doFunc(array("電話番号3", 'tel03'), array("EXIST_CHECK","NUM_CHECK")); 159 $objErr->doFunc(array("電話番号", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK")); 160 160 return $objErr->arrErr; 161 161 162 162 } 163 163 164 /* ¥¨¥é¡¼¥Á¥§¥Ã¥¯*/164 /* エラーチェック */ 165 165 function lfErrorCheck1() { 166 166 $objErr = new SC_CheckError(); 167 167 168 $objErr->doFunc(array(" ¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));169 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK"));170 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));171 $objErr->doFunc(array(" ¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK"));172 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));173 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));174 $objErr->doFunc(array(" ͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK"));168 $objErr->doFunc(array("お名前(姓)", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 169 $objErr->doFunc(array("お名前(名)", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK")); 170 $objErr->doFunc(array("お名前(カナ/姓)", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 171 $objErr->doFunc(array("お名前(カナ/名)", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); 172 $objErr->doFunc(array("郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 173 $objErr->doFunc(array("郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); 174 $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK")); 175 175 return $objErr->arrErr; 176 176 177 177 } 178 178 179 /* ¥¨¥é¡¼¥Á¥§¥Ã¥¯*/179 /* エラーチェック */ 180 180 function lfErrorCheck2() { 181 181 $objErr = new SC_CheckError(); 182 182 183 $objErr->doFunc(array(" ÅÔÆ»Éܸ©", 'pref'), array("SELECT_CHECK","NUM_CHECK"));184 $objErr->doFunc(array(" »Ô¶èĮ¼", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));185 $objErr->doFunc(array(" ÈÖÃÏ", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));186 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ1", 'tel01'), array("EXIST_CHECK","NUM_CHECK"));187 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","NUM_CHECK"));188 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","NUM_CHECK"));189 $objErr->doFunc(array(" ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK"));183 $objErr->doFunc(array("都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK")); 184 $objErr->doFunc(array("市区町村", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 185 $objErr->doFunc(array("番地", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); 186 $objErr->doFunc(array("電話番号1", 'tel01'), array("EXIST_CHECK","NUM_CHECK")); 187 $objErr->doFunc(array("電話番号2", 'tel02'), array("EXIST_CHECK","NUM_CHECK")); 188 $objErr->doFunc(array("電話番号3", 'tel03'), array("EXIST_CHECK","NUM_CHECK")); 189 $objErr->doFunc(array("電話番号", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK")); 190 190 return $objErr->arrErr; 191 191 … … 194 194 195 195 196 /* ÅÐÏ¿¼Â¹Ô*/196 /* 登録実行 */ 197 197 function lfRegistData($array, $arrRegistColumn) { 198 198 global $objConn; … … 207 207 $arrRegist['customer_id'] = $objCustomer->getvalue('customer_id'); 208 208 209 //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô209 //-- 編集登録実行 210 210 $objConn->query("BEGIN"); 211 211 if ($array['other_deliv_id'] != ""){ … … 223 223 } 224 224 225 //---- ¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹225 //---- 取得文字列の変換 226 226 function lfConvertParam($array, $arrRegistColumn) { 227 227 /* 228 * ʸ»úÎó¤ÎÊÑ´¹229 * K : ¡ÖȾ³Ñ(Êݶ¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹230 * C : ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹231 * V : ÂùÅÀÉÕ¤¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹232 * n : ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(Êݶ¸)¡×¤ËÊÑ´¹233 * a : Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë228 * 文字列の変換 229 * K : 「半角(ハンカク)片仮名」を「全角片仮名」に変換 230 * C : 「全角ひら仮名」を「全角かた仮名」に変換 231 * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します 232 * n : 「全角」数字を「半角(ハンカク)」に変換 233 * a : 全角英数字を半角英数字に変換する 234 234 */ 235 // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó235 // カラム名とコンバート情報 236 236 foreach ($arrRegistColumn as $data) { 237 237 $arrConvList[ $data["column"] ] = $data["convert"]; 238 238 } 239 239 240 // ʸ»úÊÑ´¹240 // 文字変換 241 241 foreach ($arrConvList as $key => $val) { 242 // POST ¤µ¤ì¤Æ¤¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£242 // POSTされてきた値のみ変換する。 243 243 if(strlen(($array[$key])) > 0) { 244 244 $array[$key] = mb_convert_kana($array[$key] ,$val); … … 248 248 } 249 249 250 // ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ250 // 郵便番号から住所の取得 251 251 function lfGetAddress($zipcode) { 252 252 global $arrPref; … … 254 254 $conn = new SC_DBconn(ZIP_DSN); 255 255 256 // ͹ÊØÈֹ渡º÷ʸºîÀ®256 // 郵便番号検索文作成 257 257 $zipcode = mb_convert_kana($zipcode ,"n"); 258 258 $sqlse = "SELECT state, city, town FROM mtb_zip WHERE zipcode = ?"; … … 260 260 $data_list = $conn->getAll($sqlse, array($zipcode)); 261 261 262 // ¥¤¥ó¥Ç¥Ã¥¯¥¹¤ÈÃͤòȿž¤µ¤»¤ë¡£262 // インデックスと値を反転させる。 263 263 $arrREV_PREF = array_flip($arrPref); 264 264 265 265 /* 266 Áí̳¾Ê¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È267 °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç Âкö¤¹¤ë¡£268 ¡¦¡Ê£±¡¦£±£¹ÃúÌÜ¡Ë269 ¡¦°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç266 総務省からダウンロードしたデータをそのままインポートすると 267 以下のような文字列が入っているので 対策する。 268 ・(1・19丁目) 269 ・以下に掲載がない場合 270 270 */ 271 271 $town = $data_list[0]['town']; 272 $town = ereg_replace(" ¡Ê.*¡Ë$","",$town);273 $town = ereg_replace(" °Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç","",$town);272 $town = ereg_replace("(.*)$","",$town); 273 $town = ereg_replace("以下に掲載がない場合","",$town); 274 274 $data_list[0]['town'] = $town; 275 275 $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; … … 278 278 } 279 279 280 /* Ê̤ΤªÆϤ±Àè½»½ê¤ò°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤Ø*/280 /* 別のお届け先住所を一時受注テーブルへ */ 281 281 function lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id) { 282 // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ®282 // 登録データの作成 283 283 $sqlval['order_temp_id'] = $uniqid; 284 284 $sqlval['update_date'] = 'Now()';
Note: See TracChangeset
for help on using the changeset viewer.