tpl_mainpage = 'shopping/nonmember.tpl'; // メインテンプレート $this->tpl_title .= 'お客様情報入力(1/3)'; // ページタイトル } } //---- ページ初期設定 $CONF = sf_getBasisData(); // 店舗基本情報 $objConn = new SC_DbConn(); $objPage = new LC_Page(); $objView = new SC_MobileView(); $objDate = new SC_Date(START_BIRTH_YEAR, date("Y",strtotime("now"))); $objPage->arrPref = $arrPref; $objPage->arrJob = $arrJob; $objPage->arrReminder = $arrReminder; $objPage->arrYear = $objDate->getYear('', 1950); // 日付プルダウン設定 $objPage->arrMonth = $objDate->getMonth(); $objPage->arrDay = $objDate->getDay(); //SSLURL判定 if (SSLURL_CHECK == 1){ $ssl_url= sfRmDupSlash(MOBILE_SSL_URL.$_SERVER['REQUEST_URI']); if (!ereg("^https://", $non_ssl_url)){ sfDispSiteError(URL_ERROR, "", false, "", true); } } // レイアウトデザインを取得 $objPage = sfGetPageLayout($objPage, false, DEF_LAYOUT); //---- 登録用カラム配列 $arrRegistColumn = array( array( "column" => "name01", "convert" => "aKV" ), array( "column" => "name02", "convert" => "aKV" ), array( "column" => "kana01", "convert" => "CKV" ), array( "column" => "kana02", "convert" => "CKV" ), array( "column" => "zip01", "convert" => "n" ), array( "column" => "zip02", "convert" => "n" ), array( "column" => "pref", "convert" => "n" ), array( "column" => "addr01", "convert" => "aKV" ), array( "column" => "addr02", "convert" => "aKV" ), array( "column" => "email", "convert" => "a" ), array( "column" => "email2", "convert" => "a" ), array( "column" => "email_mobile", "convert" => "a" ), array( "column" => "email_mobile2", "convert" => "a" ), array( "column" => "tel01", "convert" => "n" ), array( "column" => "tel02", "convert" => "n" ), array( "column" => "tel03", "convert" => "n" ), array( "column" => "fax01", "convert" => "n" ), array( "column" => "fax02", "convert" => "n" ), array( "column" => "fax03", "convert" => "n" ), array( "column" => "sex", "convert" => "n" ), array( "column" => "job", "convert" => "n" ), array( "column" => "birth", "convert" => "n" ), array( "column" => "reminder", "convert" => "n" ), array( "column" => "reminder_answer", "convert" => "aKV"), array( "column" => "password", "convert" => "a" ), array( "column" => "password02", "convert" => "a" ), array( "column" => "mailmaga_flg", "convert" => "n" ), ); //---- 登録除外用カラム配列 //$arrRejectRegistColumn = array("year", "month", "day", "email02", "email_mobile02","password","password02","reminder","reminder_answer"); $arrRejectRegistColumn = array("year", "month", "day"); if ($_SERVER["REQUEST_METHOD"] == "POST") { //-- POSTデータの引き継ぎ $objPage->arrForm = $_POST; if($objPage->arrForm['year'] == '----') { $objPage->arrForm['year'] = ''; } //$objPage->arrForm['email'] = strtolower($objPage->arrForm['email']); // emailはすべて小文字で処理 //-- 入力データの変換 $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); // 戻るボタン用処理 if (!empty($_POST["return"])) { switch ($_POST["mode"]) { case "complete": $_POST["mode"] = "set3"; break; case "confirm": $_POST["mode"] = "set2"; break; default: $_POST["mode"] = "set1"; break; } } //-- 入力エラーチェック if (!empty($_POST["mode"])) { if ($_POST["mode"] == "set1") { $objPage->arrErr = lfErrorCheck1($objPage->arrForm); $objPage->tpl_mainpage = 'shopping/nonmember.tpl'; $objPage->tpl_title = 'お客様情報入力(1/3)'; } elseif ($_POST["mode"] == "set2") { $objPage->arrErr = lfErrorCheck2($objPage->arrForm); $objPage->tpl_mainpage = 'shopping/nonmember_set1.tpl'; $objPage->tpl_title = 'お客様情報入力(2/3)'; } elseif ($_POST["mode"] == "deliv"){ $objPage->arrErr = lfErrorCheck3($objPage->arrForm); $objPage->tpl_mainpage = 'shopping/nonmember_set2.tpl'; $objPage->tpl_title = 'お客様情報入力(3/3)'; } foreach($objPage->arrForm as $key => $val) { $objPage->$key = $val; } } if ($objPage->arrErr || !empty($_POST["return"])) { // 入力エラーのチェック //-- データの設定 if ($_POST["mode"] == "set1") { $checkVal = array("email", "name01", "name02", "kana01", "kana02"); } elseif ($_POST["mode"] == "set2") { $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); } else { $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); } foreach($objPage->arrForm as $key => $val) { if ($key != "mode" && $key != "submit" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) $objPage->list_data[ $key ] = $val; } } else { //-- テンプレート設定 if ($_POST["mode"] == "set1") { $objPage->tpl_mainpage = 'shopping/nonmember_set1.tpl'; $objPage->tpl_title = 'お客様情報入力(2/3)'; } elseif ($_POST["mode"] == "set2") { $objPage->tpl_mainpage = 'shopping/nonmember_set2.tpl'; $objPage->tpl_title = 'お客様情報入力(3/3)'; if (@$objPage->arrForm['pref'] == "" && @$objPage->arrForm['addr01'] == "" && @$objPage->arrForm['addr02'] == "") { $address = lfGetAddress($_REQUEST['zip01'].$_REQUEST['zip02']); $objPage->pref = @$address[0]['state']; $objPage->addr01 = @$address[0]['city'] . @$address[0]['town']; } } /*elseif ($_POST["mode"] == "deliv") { //パスワード表示 //メール受け取り if (strtolower($objPage->arrForm['mail_flag']) == "on") { $objPage->arrForm['mail_flag'] = "2"; } else { $objPage->arrForm['mail_flag'] = "3"; } $objPage->tpl_mainpage = 'shopping/deliv.tpl'; $objPage->tpl_title = 'お客様情報(確認ページ)'; }*/ //-- データ設定 unset($objPage->list_data); if ($_POST["mode"] == "set1") { $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); } elseif ($_POST["mode"] == "set2") { $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); } else { $checkVal = array(); } foreach($objPage->arrForm as $key => $val) { if ($key != "mode" && $key != "submit" && $key != "confirm" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) { $objPage->list_data[ $key ] = $val; } } // if ($_POST["mode"] == "deliv") { // // $objFormParam = new SC_FormParam(); // // パラメータ情報の初期化 // // // POST値の取得 // $objFormParam->setParam($_POST); // // // 入力値の取得 // $objPage->arrForm = $objFormParam->getFormParamList(); // $objPage->arrErr = $arrErr; // //// $cnt = 1; //// foreach($objOtherAddr as $val) { //// $objPage->arrAddr[$cnt] = $val; //// $cnt++; //// } // // $objPage->arrAddr[0]['zip01'] = $objPage->zip01; // $objPage->arrAddr[0]['zip02'] = $objPage->zip02; // $objPage->arrAddr[0]['pref'] = $objPage->pref; // $objPage->arrAddr[0]['addr01'] = $objPage->addr01; // $objPage->arrAddr[0]['addr02'] = $objPage->addr02; // // $objPage->tpl_mainpage = 'shopping/deliv.tpl'; // $objPage->tpl_title = 'お届け先情報'; // } if ($_POST["mode"] == "customer_addr") { lfRegistData ($uniqid); header("Location:" . gfAddSessionId("./payment.php")); print($_POST); } //-- 仮登録と完了画面 if ($_POST["mode"] == "complete") { $objPage->uniqid = lfRegistData ($objPage->arrForm, $arrRegistColumn, $arrRejectRegistColumn); // 空メールを受信済みの場合はすぐに本登録完了にする。 // if (isset($_SESSION['mobile']['kara_mail_from'])) { // header("Location:" . gfAddSessionId(MOBILE_URL_DIR . "regist/index.php?mode=regist&id=" . $objPage->uniqid)); // exit; // } $objPage->tpl_mainpage = 'shopping/complete.tpl'; $objPage->tpl_title = 'お客様情報入力(完了ページ)'; /*sfMobileSetExtSessionId('id', $objPage->uniqid, 'regist/index.php'); // 仮登録完了メール送信 $objPage->CONF = $CONF; $objPage->to_name01 = $_POST['name01']; $objPage->to_name02 = $_POST['name02']; $objMailText = new SC_MobileView(); $objMailText->assignobj($objPage); $subject = sfMakesubject('お客様情報のご確認'); $toCustomerMail = $objMailText->fetch("mail_templates/customer_mail.tpl"); $objMail = new GC_SendMail(); $objMail->setItem( '' // 宛先 , $subject // サブジェクト , $toCustomerMail // 本文 , $CONF["email03"] // 配送元アドレス , $CONF["shop_name"] // 配送元 名前 , $CONF["email03"] // reply_to , $CONF["email04"] // return_path , $CONF["email04"] // Errors_to , $CONF["email01"] // Bcc ); // 宛先の設定 $name = $_POST["name01"] . $_POST["name02"] ." 様"; $objMail->setTo($_POST["email"], $name); $objMail->sendMail(); */ // 完了ページに移動させる。 header("Location:" . gfAddSessionId("./complete.php")); exit; } } } //---- ページ表示 $objView->assignobj($objPage); $objView->display(SITE_FRAME); //---------------------------------------------------------------------------------------------------------------------- //---- function群 function lfRegistData($uniqid) { global $objFormParam; $arrRet = $objFormParam->getHashArray(); $sqlval = $objFormParam->getDbArray(); // 登録データの作成 $sqlval['order_temp_id'] = $uniqid; $sqlval['order_birth'] = sfGetTimestamp($arrRet['year'], $arrRet['month'], $arrRet['day']); $sqlval['update_date'] = 'Now()'; $sqlval['customer_id'] = '0'; // 既存データのチェック $objQuery = new SC_Query(); $where = "order_temp_id = ?"; $cnt = $objQuery->count("dtb_order_temp", $where, array($uniqid)); // 既存データがない場合 if ($cnt == 0) { $sqlval['create_date'] = 'Now()'; $objQuery->insert("dtb_order_temp", $sqlval); } else { $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid)); } } //---- 取得文字列の変換 function lfConvertParam($array, $arrRegistColumn) { /* * 文字列の変換 * K : 「半角(ハンカク)片仮名」を「全角片仮名」に変換 * C : 「全角ひら仮名」を「全角かた仮名」に変換 * V : 濁点付きの文字を一文字に変換。"K","H"と共に使用します * n : 「全角」数字を「半角(ハンカク)」に変換 * a : 全角英数字を半角英数字に変換する */ // カラム名とコンバート情報 foreach ($arrRegistColumn as $data) { $arrConvList[ $data["column"] ] = $data["convert"]; } // 文字変換 foreach ($arrConvList as $key => $val) { // POSTされてきた値のみ変換する。 if(strlen(($array[$key])) > 0) { $array[$key] = mb_convert_kana($array[$key] ,$val); } } return $array; } //---- 入力エラーチェック function lfErrorCheck2($array) { global $objConn, $objDate; $objErr = new SC_CheckError($array); $objErr->doFunc(array("郵便番号1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); $objErr->doFunc(array("郵便番号2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "SPTAB_CHECK" ,"NUM_CHECK", "NUM_COUNT_CHECK")); $objErr->doFunc(array("郵便番号", "zip01", "zip02"), array("ALL_EXIST_CHECK")); $objErr->doFunc(array("性別", "sex") ,array("SELECT_CHECK", "NUM_CHECK")); $objErr->doFunc(array("生年月日 (年)", "year", 4), array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); if (!isset($objErr->arrErr['year'])) { $objErr->doFunc(array("生年月日 (年)", "year", $objDate->getStartYear()), array("MIN_CHECK")); $objErr->doFunc(array("生年月日 (年)", "year", $objDate->getEndYear()), array("MAX_CHECK")); } $objErr->doFunc(array("生年月日 (月日)", "month", "day"), array("SELECT_CHECK")); if (!isset($objErr->arrErr['year']) && !isset($objErr->arrErr['month']) && !isset($objErr->arrErr['day'])) { $objErr->doFunc(array("生年月日", "year", "month", "day"), array("CHECK_DATE")); } return $objErr->arrErr; } //---- 入力エラーチェック function lfErrorCheck3($array) { global $objConn; $objErr = new SC_CheckError($array); $objErr->doFunc(array("都道府県", 'pref'), array("SELECT_CHECK","NUM_CHECK")); $objErr->doFunc(array("市区町村", "addr01", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); $objErr->doFunc(array("番地", "addr02", MTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); $objErr->doFunc(array("電話番号1", 'tel01'), array("EXIST_CHECK","SPTAB_CHECK" )); $objErr->doFunc(array("電話番号2", 'tel02'), array("EXIST_CHECK","SPTAB_CHECK" )); $objErr->doFunc(array("電話番号3", 'tel03'), array("EXIST_CHECK","SPTAB_CHECK" )); $objErr->doFunc(array("電話番号", "tel01", "tel02", "tel03",TEL_ITEM_LEN) ,array("TEL_CHECK")); return $objErr->arrErr; } // 郵便番号から住所の取得 function lfGetAddress($zipcode) { global $arrPref; $conn = new SC_DBconn(ZIP_DSN); // 郵便番号検索文作成 $zipcode = mb_convert_kana($zipcode ,"n"); $sqlse = "SELECT state, city, town FROM mtb_zip WHERE zipcode = ?"; $data_list = $conn->getAll($sqlse, array($zipcode)); // インデックスと値を反転させる。 $arrREV_PREF = array_flip($arrPref); /* 総務省からダウンロードしたデータをそのままインポートすると 以下のような文字列が入っているので 対策する。 ・(1・19丁目) ・以下に掲載がない場合 */ $town = $data_list[0]['town']; $town = ereg_replace("(.*)$","",$town); $town = ereg_replace("以下に掲載がない場合","",$town); $data_list[0]['town'] = $town; $data_list[0]['state'] = $arrREV_PREF[$data_list[0]['state']]; return $data_list; } //----------------------------------------------------------------------------------------------------------------------------------- ?>