Index: branches/dev/html/mobile/nonmember/nonmember/index.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/index.php (revision 13346) +++ branches/dev/html/mobile/nonmember/nonmember/index.php (revision 13346) @@ -0,0 +1,528 @@ +tpl_mainpage = 'nonmember/index.tpl'; + global $arrPref; + $this->arrPref = $arrPref; + global $arrSex; + $this->arrSex = $arrSex; + global $arrJob; + $this->arrJob = $arrJob; + $this->tpl_onload = 'fnCheckInputDeliv();'; + + /* + session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç + ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ + private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ + */ + session_cache_limiter('private-no-expire'); + } +} + +$conn = new SC_DBConn(); +$objPage = new LC_Page(); +$objView = new SC_MobileView(); +$objSiteSess = new SC_SiteSession(); +$objCartSess = new SC_CartSession(); +$objCustomer = new SC_Customer(); +$objCookie = new SC_Cookie(); +$objFormParam = new SC_FormParam(); // ¥Õ¥©¡¼¥àÍÑ +lfInitParam(); // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ +$objFormParam->setParam($_POST); // POSTÃͤμèÆÀ + +//-------------------------------------¢§NONMEMBER---------------------------------------------- +//---- ¥Ú¡¼¥¸½é´üÀßÄê + +$CONF = sf_getBasisData(); // ŹÊÞ´ðËܾðÊó +$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); + +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); + +$objPage->tpl_uniqid = $uniqid; + +switch($_POST['mode']) { +case 'nonmember_confirm': + $objPage = lfSetNonMember($objPage); + // ¢¨break¤Ê¤· +case 'confirm': + // ÆþÎÏÃͤÎÊÑ´¹ + $objFormParam->convParam(); + $objFormParam->toLower('order_mail'); + $objFormParam->toLower('order_mail_check'); + $objPage->arrErr = lfCheckError(); + // ÆþÎÏ¥¨¥é¡¼¤Ê¤· + if(count($objPage->arrErr) == 0) { + // DB¤Ø¤Î¥Ç¡¼¥¿ÅÐÏ¿ + lfRegistData($uniqid); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); + exit; + } + + break; +// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë +case 'return': + // ³Îǧ¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId(MOBILE_URL_CART_TOP)); + exit; + break; +case 'nonmember': + $objPage = lfSetNonMember($objPage); + // ¢¨break¤Ê¤· +default: + if($_GET['from'] == 'nonmember') { + $objPage = lfSetNonMember($objPage); + } + // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ + $uniqid = $objSiteSess->getUniqId(); + $objQuery = new SC_Query(); + $where = "order_temp_id = ?"; + $arrRet = $objQuery->select("*", "dtb_order_temp", $where, array($uniqid)); + // DBÃͤμèÆÀ + $objFormParam->setParam($arrRet[0]); + $objFormParam->setValue('order_email_check', $arrRet[0]['order_email']); + $objFormParam->setDBDate($arrRet[0]['order_birth']); + break; +} + +// ¥¯¥Ã¥­¡¼È½Äê +$objPage->tpl_login_email = $objCookie->getCookie('login_email'); +if($objPage->tpl_login_email != "") { + $objPage->tpl_login_memory = "1"; +} + +// ÁªÂòÍÑÆüÉդμèÆÀ +$objDate = new SC_Date(START_BIRTH_YEAR); +$objPage->arrYear = $objDate->getYear('', 1950); //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê +$objPage->arrMonth = $objDate->getMonth(); +$objPage->arrDay = $objDate->getDay(); + +// ÆþÎÏÃͤμèÆÀ +$objPage->arrForm = $objFormParam->getFormParamList(); + +//objPage¤Î¾ðÊó¤òobjView¤Ë³ÊǼ +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); + +//-------------------------------------------------------------------------------------------------------------------------- +/* Èó²ñ°÷ÆþÎÏ¥Ú¡¼¥¸¤Î¥»¥Ã¥È */ +function lfSetNonMember($objPage) { + + $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", "email02", "email_mobile02", "password02"); + + $objPage->tpl_mainpage = 'nonmember/nonmember_set1.tpl'; + $objPage->tpl_css = array(); + $objPage->tpl_css[] = '/css/layout/login/nonmember.css'; + + //-- 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); + + // Ìá¤ë¥Ü¥¿¥óÍѽèÍý + //return¤ÎÃæ¤Ë¸µ¤Î¥Ú¡¼¥¸¤Î̾Á°¤¬Æþ¤Ã¤Æ¤¤¤ë + if (!empty($_POST["return"])) { + switch ($_POST["mode2"]) { + case "deliv_date": + + break; + case "deliv": + $_POST["mode2"] = "set3"; + break; + case "set3": + $_POST["mode2"] = "set2"; + break; + default: + $_POST["mode2"] = "set1"; + break; + } + } + + //--¡¡ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ + if (!empty($_POST["mode2"])) { + if ($_POST["mode2"] == "set2") { + $objPage->arrErr = lfErrorCheck1($objPage->arrForm); + $objPage->tpl_mainpage = 'nonmember/nonmember_set1.tpl'; + $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(1/3)'; + } elseif ($_POST["mode2"] == "set3") { + + $objPage->arrErr = lfErrorCheck2($objPage->arrForm); + $objPage->tpl_mainpage = 'nonmember/nonmember_set2.tpl'; + $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(2/3)'; + } elseif ($_POST["mode2"] == "deliv"){ + $objPage->arrErr = lfErrorCheck3($objPage->arrForm); + $objPage->tpl_mainpage = 'nonmember/nonmember_set3.tpl'; + $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(3/3)'; + } + + //¥Õ¥©¡¼¥à¤ÎÃͤò$objPage¤Î¥­¡¼¤È¤·¤ÆÂåÆþ¤·¤Æ¤¤¤¯ + foreach($objPage->arrForm as $key => $val) { + $objPage->$key = $val; + } + } + + // ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ + if ($objPage->arrErr || !empty($_POST["return"])) { + + //-- ¥Ç¡¼¥¿¤ÎÀßÄê + if ($_POST["mode2"] == "set2") { + $checkVal = array("email", "name01", "name02", "kana01", "kana02"); + } elseif ($_POST["mode2"] == "set3") { + $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 != "mode2" && $key != "submit" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) + $objPage->list_data[ $key ] = $val; + } + + } else { + + //--¡¡¥Æ¥ó¥×¥ì¡¼¥ÈÀßÄê + if ($_POST["mode2"] == "set2") { + + $objPage->tpl_mainpage = 'nonmember/nonmember_set2.tpl'; + $objPage->tpl_title = '¤ªµÒÍ;ðÊóÆþÎÏ(2/3)'; + } elseif ($_POST["mode2"] == "set3") { + $objPage->tpl_mainpage = 'nonmember/nonmember_set3.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']; + } + } + + //-- ¥Ç¡¼¥¿ÀßÄê + unset($objPage->list_data); + if ($_POST["mode2"] == "set2") { + $checkVal = array("sex", "year", "month", "day", "zip01", "zip02"); + } elseif ($_POST["mode2"] == "set3") { + $checkVal = array("pref", "addr01", "addr02", "tel01", "tel02", "tel03", "mail_flag"); + } else { + $checkVal = array(); + } + + //$objPage->arrForm¥Õ¥©¡¼¥à¤ÎÃͤòlist¤Ë³ÊǼ + foreach($objPage->arrForm as $key => $val) { + if ($key != "mode2" && $key != "submit" && $key != "confirm" && $key != "return" && $key != session_name() && !in_array($key, $checkVal)) { + $objPage->list_data[ $key ] = $val; + } + } + + //header("Location:" . gfAddSessionId("./deliv.php")); + + } + return $objPage; +} + + +/** + * regist data function + * + * @param string $uniqid this parameter is unique ID of user. + * + * + */ + //¥Ç¡¼¥¿¤ÎÅÐÏ¿¤ò¹Ô¤¦ +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'; + $sqlval['order_name01'] = $objPage->arrAddr[0]['name01']; + + // ´û¸¥Ç¡¼¥¿¤Î¥Á¥§¥Ã¥¯ + $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 lfInitParam() { + global $objFormParam; + $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "order_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "order_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "order_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "order_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ1", "order_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ2", "order_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("ÅÔÆ»Éܸ©", "order_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("½»½ê1", "order_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("½»½ê2", "order_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "order_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "order_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "order_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ1", "order_fax01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ2", "order_fax02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ3", "order_fax03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "order_email", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ê³Îǧ¡Ë", "order_email_check", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK"), "", false); + $objFormParam->addParam("ǯ", "year", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("·î", "month", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("Æü", "day", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("À­ÊÌ", "order_sex", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¿¦¶È", "order_job", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("Ê̤ΤªÆϤ±Àè", "deliv_check", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "deliv_name01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "deliv_name02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "deliv_kana01", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "deliv_kana02", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mail_flag", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"), 1); +} + +/* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */ + +/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */ +function lfCheckError() { + global $objFormParam; + // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ + $arrRet = $objFormParam->getHashArray(); + $objErr = new SC_CheckError($arrRet); + $objErr->arrErr = $objFormParam->checkError(); + + // Ê̤ΤªÆϤ±Àè¥Á¥§¥Ã¥¯ + if($_POST['deliv_check'] == "1") { + $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", "deliv_name01"), array("EXIST_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", "deliv_name02"), array("EXIST_CHECK")); + $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "deliv_kana01"), array("EXIST_CHECK")); + $objErr->doFunc(array("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "deliv_kana02"), array("EXIST_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "deliv_zip01"), array("EXIST_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "deliv_zip02"), array("EXIST_CHECK")); + $objErr->doFunc(array("ÅÔÆ»Éܸ©", "deliv_pref"), array("EXIST_CHECK")); + $objErr->doFunc(array("½»½ê1", "deliv_addr01"), array("EXIST_CHECK")); + $objErr->doFunc(array("½»½ê2", "deliv_addr02"), array("EXIST_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ1", "deliv_tel01"), array("EXIST_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", "deliv_tel02"), array("EXIST_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", "deliv_tel03"), array("EXIST_CHECK")); + } + + // Ê£¿ô¹àÌÜ¥Á¥§¥Ã¥¯ + $objErr->doFunc(array("TEL", "order_tel01", "order_tel02", "order_tel03", TEL_ITEM_LEN), array("TEL_CHECK")); + $objErr->doFunc(array("FAX", "order_fax01", "order_fax02", "order_fax03", TEL_ITEM_LEN), array("TEL_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ", "order_zip01", "order_zip02"), array("ALL_EXIST_CHECK")); + $objErr->doFunc(array("TEL", "deliv_tel01", "deliv_tel02", "deliv_tel03", TEL_ITEM_LEN), array("TEL_CHECK")); + $objErr->doFunc(array("FAX", "deliv_fax01", "deliv_fax02", "deliv_fax03", TEL_ITEM_LEN), array("TEL_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ", "deliv_zip01", "deliv_zip02"), array("ALL_EXIST_CHECK")); + $objErr->doFunc(array("À¸Ç¯·îÆü", "year", "month", "day"), array("CHECK_DATE")); + $objErr->doFunc(array("¥á¡¼¥ë¥¢¥É¥ì¥¹", "¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ê³Îǧ¡Ë", "order_email", "order_email_check"), array("EQUAL_CHECK")); + + // ¤¹¤Ç¤Ë¥á¥ë¥Þ¥¬¥Æ¡¼¥Ö¥ë¤Ë²ñ°÷¤È¤·¤Æ¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¾ì¹ç + if(sfCheckCustomerMailMaga($arrRet['order_email'])) { + $objErr->arrErr['order_email'] = "¤³¤Î¥á¡¼¥ë¥¢¥É¥ì¥¹¤Ï¤¹¤Ç¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤Þ¤¹¡£
"; + } + + return $objErr->arrErr; +} + + +//-----------------------------NONMEMBER´Ø¿ô·²¢§------------------------------------------------------------------ +//----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ +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 lfErrorCheck1($array) { + + global $objConn; + $objErr = new SC_CheckError($array); + + $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" , "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK", "NO_SPTAB", "SPTAB_CHECK" ,"MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "email", MTEXT_LEN) ,array("NO_SPTAB", "EXIST_CHECK", "EMAIL_CHECK", "SPTAB_CHECK" ,"EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK", "MOBILE_EMAIL_CHECK")); + + return $objErr->arrErr; +} + +//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯ +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); + + /* + Áí̳¾Ê¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È + °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç Âкö¤¹¤ë¡£ + ¡¦¡Ê£±¡¦£±£¹ÃúÌÜ¡Ë + ¡¦°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç + */ + $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; +} +//NONMEMBER_´Ø¿ô·²--------------------------------------------------------------------------------------- +?> Index: branches/dev/html/mobile/nonmember/nonmember/complete.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/complete.php (revision 14767) +++ branches/dev/html/mobile/nonmember/nonmember/complete.php (revision 14767) @@ -0,0 +1,510 @@ +tpl_mainpage = 'shopping/complete.tpl'; + $this->tpl_css = '/css/layout/shopping/complete.css'; + $this->tpl_title = "¤´Ãíʸ´°Î»"; + global $arrCONVENIENCE; + $this->arrCONVENIENCE = $arrCONVENIENCE; + global $arrCONVENIMESSAGE; + $this->arrCONVENIMESSAGE = $arrCONVENIMESSAGE; + global $arrCONVENIENCE; + global $arrCONVENIMESSAGE; + $objPage->arrCONVENIENCE = $arrCONVENIENCE; + $objPage->arrCONVENIMESSAGE = $arrCONVENIMESSAGE; + /* + session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç + ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ + private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ + */ + session_cache_limiter('private-no-expire'); + + } +} + +$conn = new SC_DBConn(); +$objPage = new LC_Page(); +$objView = new SC_MobileView(); +$objSiteSess = new SC_SiteSession(); +$objCartSess = new SC_CartSession(); +$objSiteInfo = $objView->objSiteInfo; +$arrInfo = $objSiteInfo->data; +$objCustomer = new SC_Customer(); + +// Á°¤Î¥Ú¡¼¥¸¤ÇÀµ¤·¤¯ÅÐÏ¿¼ê³¤­¤¬¹Ô¤ï¤ì¤¿¤«È½Äê +sfIsPrePage($objSiteSess, true); +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); +if ($uniqid != "") { + + // ´°Î»½èÍý + $objQuery = new SC_Query(); + $objQuery->begin(); + $order_id = lfDoComplete($objQuery, $uniqid); + $objQuery->commit(); + + // ¥»¥Ã¥·¥ç¥ó¤ËÊݴɤµ¤ì¤Æ¤¤¤ë¾ðÊó¤ò¹¹¿·¤¹¤ë + $objCustomer->updateSession(); + + // ´°Î»¥á¡¼¥ëÁ÷¿® 4¤Ï·ÈÂÓÈÇ + if($order_id != "") { + $order_email = $objQuery->select("order_email", "dtb_order", "order_id = ?", array($order_id)); + + //ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤¬·ÈÂÓ¤«PC¤«¤Ë±þ¤¸¤ÆÃíʸ´°Î»¥á¡¼¥ë¤Î¥Æ¥ó¥×¥ì¡¼¥È¤òÊѤ¨¤ë + if(ereg("(ezweb.ne.jp$|docomo.ne.jp$|softbank.ne.jp$|vodafone.ne.jp$)",$order_email[0]['order_email'])){ + sfSendOrderMail($order_id, '1',"",""); + }else{ + sfSendOrderMail($order_id, '0',"",""); + } + } + //¤½¤Î¾¾ðÊó¤Î¼èÆÀ + $other_data = $objQuery->get("dtb_order", "memo02", "order_id = ? ", array($order_id)); + if($other_data != "") { + $arrOther = unserialize($other_data); + + // ¥Ç¡¼¥¿¤òÊÔ½¸ + foreach($arrOther as $key => $val){ + // URL¤Î¾ì¹ç¤Ë¤Ï¥ê¥ó¥¯¤Ä¤­¤Çɽ¼¨¤µ¤»¤ë + if (preg_match('/^(https?|ftp)(:\/\/[-_.!~*\'()a-zA-Z0-9;\/?:\@&=+\$,%#]+)$/', $val["value"])) { + $arrOther[$key]["value"] = "" . $val["value"] .""; + } + } + + $objPage->arrOther = $arrOther; + + } + + // ¥¢¥Õ¥£¥ê¥¨¥¤¥ÈÍÑ¥³¥ó¥Ð¡¼¥¸¥ç¥ó¥¿¥°¤ÎÀßÄê + $objPage->tpl_conv_page = AFF_SHOPPING_COMPLETE; + $objPage->tpl_aff_option = "order_id=$order_id"; + //¹ç·×²Á³Ê¤Î¼èÆÀ + $total = $objQuery->get("dtb_order", "total", "order_id = ? ", array($order_id)); + if($total != "") { + $objPage->tpl_aff_option.= "|total=$total"; + } +} + +$objPage->arrInfo = $arrInfo; + +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); +//-------------------------------------------------------------------------------------------------------------------------- +// ¥¨¥Ó¥¹¥¿¥°°úÅϤ·Íѥǡ¼¥¿¤òÀ¸À®¤¹¤ë +function lfGetEbisData($order_id) { + $objQuery = new SC_Query(); + $col = "customer_id, total, order_sex, order_job, to_number(to_char(age(current_timestamp, order_birth), 'YYY'), 999) AS order_age"; + $arrRet = $objQuery->select($col, "dtb_order", "order_id = ?", array($order_id)); + + if($arrRet[0]['customer_id'] > 0) { + // ²ñ°÷ÈÖ¹æ + $arrEbis['m1id'] = $arrRet[0]['customer_id']; + // Èó²ñ°÷or²ñ°÷ + $arrEbis['o5id'] = '1'; + } else { + // ²ñ°÷ÈÖ¹æ + $arrEbis['m1id'] = ''; + // Èó²ñ°÷or²ñ°÷ + $arrEbis['o5id'] = '2'; + } + + // ¹ØÆþ¶â³Û + $arrEbis['a1id'] = $arrRet[0]['total']; + // À­ÊÌ + $arrEbis['o2id'] = $arrRet[0]['order_sex']; + // ǯÎð + $arrEbis['o3id'] = $arrRet[0]['order_age']; + // ¿¦¶È + $arrEbis['o4id'] = $arrRet[0]['order_job']; + + $objQuery->setgroupby("product_id"); + $arrRet = $objQuery->select("product_id", "dtb_order_detail", "order_id = ?", array($order_id)); + $arrProducts = sfSwapArray($arrRet); + + $line = ""; + // ¾¦ÉÊID¤ò¥¢¥ó¥À¡¼¥Ð¡¼¤ÇÀܳ¤¹¤ë¡£ + foreach($arrProducts['product_id'] as $val) { + if($line != "") { + $line .= "_$val"; + } else { + $line .= "$val"; + } + } + + // ¾¦ÉÊID + $arrEbis['o1id'] = $line; + + return $arrEbis; +} + +// ´°Î»½èÍý +function lfDoComplete($objQuery, $uniqid) { + global $objCartSess; + global $objSiteSess; + global $objCustomer; + global $arrInfo; + + // °ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤ÎÆɹþ + $arrData = sfGetOrderTemp($uniqid); + + // ²ñ°÷¾ðÊóÅÐÏ¿½èÍý + if ($objCustomer->isLoginSuccess()) { + // ¿·¤ªÆϤ±Àè¤ÎÅÐÏ¿ + lfSetNewAddr($uniqid, $objCustomer->getValue('customer_id')); + // ¹ØÆþ½¸·×¤ò¸ÜµÒ¥Æ¡¼¥Ö¥ë¤ËÈ¿±Ç + lfSetCustomerPurchase($objCustomer->getValue('customer_id'), $arrData, $objQuery); + } else { + //¹ØÆþ»þ¶¯À©²ñ°÷ÅÐÏ¿ + switch(PURCHASE_CUSTOMER_REGIST) { + //̵¸ú + case '0': + // ¹ØÆþ»þ²ñ°÷ÅÐÏ¿ + if($arrData['member_check'] == '1') { + // ²¾²ñ°÷ÅÐÏ¿ + $customer_id = lfRegistPreCustomer($arrData, $arrInfo); + // ¹ØÆþ½¸·×¤ò¸ÜµÒ¥Æ¡¼¥Ö¥ë¤ËÈ¿±Ç + lfSetCustomerPurchase($customer_id, $arrData, $objQuery); + } + break; + //Í­¸ú + case '1': + // ²¾²ñ°÷ÅÐÏ¿ + $customer_id = lfRegistPreCustomer($arrData, $arrInfo); + // ¹ØÆþ½¸·×¤ò¸ÜµÒ¥Æ¡¼¥Ö¥ë¤ËÈ¿±Ç + lfSetCustomerPurchase($customer_id, $arrData, $objQuery); + break; + } + + } + // °ì»þ¥Æ¡¼¥Ö¥ë¤ò¼õÃí¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤¹¤ë + $order_id = lfRegistOrder($objQuery, $arrData); + // ¥«¡¼¥È¾¦Éʤò¼õÃí¾ÜºÙ¥Æ¡¼¥Ö¥ë¤Ë³ÊǼ¤¹¤ë + lfRegistOrderDetail($objQuery, $order_id, $objCartSess); + // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î¾ðÊó¤òºï½ü¤¹¤ë¡£ + lfDeleteTempOrder($objQuery, $uniqid); + + // ¥»¥Ã¥·¥ç¥ó¥«¡¼¥ÈÆâ¤Î¾¦Éʤòºï½ü¤¹¤ë¡£ + $objCartSess->delAllProducts(); + // Ãíʸ°ì»þID¤ò²ò½ü¤¹¤ë¡£ + $objSiteSess->unsetUniqId(); + + return $order_id; +} + +// ²ñ°÷ÅÐÏ¿¡Ê²¾ÅÐÏ¿¡Ë +function lfRegistPreCustomer($arrData, $arrInfo) { + // ¹ØÆþ»þ¤Î²ñ°÷ÅÐÏ¿ + $sqlval['name01'] = $arrData['order_name01']; + $sqlval['name02'] = $arrData['order_name02']; + $sqlval['kana01'] = $arrData['order_kana01']; + $sqlval['kana02'] = $arrData['order_kana02']; + $sqlval['zip01'] = $arrData['order_zip01']; + $sqlval['zip02'] = $arrData['order_zip02']; + $sqlval['pref'] = $arrData['order_pref']; + $sqlval['addr01'] = $arrData['order_addr01']; + $sqlval['addr02'] = $arrData['order_addr02']; + $sqlval['email'] = $arrData['order_email']; + $sqlval['tel01'] = $arrData['order_tel01']; + $sqlval['tel02'] = $arrData['order_tel02']; + $sqlval['tel03'] = $arrData['order_tel03']; + $sqlval['fax01'] = $arrData['order_fax01']; + $sqlval['fax02'] = $arrData['order_fax02']; + $sqlval['fax03'] = $arrData['order_fax03']; + $sqlval['sex'] = $arrData['order_sex']; + $sqlval['password'] = $arrData['password']; + $sqlval['reminder'] = $arrData['reminder']; + $sqlval['reminder_answer'] = $arrData['reminder_answer']; + + // ¥á¥ë¥Þ¥¬ÇÛ¿®Íѥե饰¤ÎȽÄê + switch($arrData['mail_flag']) { + case '1': // HTML¥á¡¼¥ë + $mail_flag = 4; + break; + case '2': // TEXT¥á¡¼¥ë + $mail_flag = 5; + break; + case '3': // ´õ˾¤Ê¤· + $mail_flag = 6; + break; + default: + $mail_flag = 6; + break; + } + $sqlval['mailmaga_flg'] = $mail_flag; + + // ²ñ°÷²¾ÅÐÏ¿ + $sqlval['status'] = 1; + // URLȽÄêÍÑ¥­¡¼ + $sqlval['secret_key'] = sfGetUniqRandomId("t"); + + $objQuery = new SC_Query(); + $sqlval['create_date'] = "now()"; + $sqlval['update_date'] = "now()"; + $objQuery->insert("dtb_customer", $sqlval); + + // ¸ÜµÒID¤Î¼èÆÀ + $arrRet = $objQuery->select("customer_id", "dtb_customer", "secret_key = ?", array($sqlval['secret_key'])); + $customer_id = $arrRet[0]['customer_id']; + + //¡¡²¾ÅÐÏ¿´°Î»¥á¡¼¥ëÁ÷¿® + $objMailPage = new LC_Page(); + $objMailPage->to_name01 = $arrData['order_name01']; + $objMailPage->to_name02 = $arrData['order_name02']; + $objMailPage->CONF = $arrInfo; + $objMailPage->uniqid = $sqlval['secret_key']; + $objMailView = new SC_SiteView(); + $objMailView->assignobj($objMailPage); + $body = $objMailView->fetch("mail_templates/customer_mail.tpl"); + + $objMail = new GC_SendMail(); + $objMail->setItem( + '' //¡¡°¸Àè + , sfMakeSubject("²ñ°÷ÅÐÏ¿¤Î¤´³Îǧ") //¡¡¥µ¥Ö¥¸¥§¥¯¥È + , $body //¡¡ËÜʸ + , $arrInfo['email03'] //¡¡ÇÛÁ÷¸µ¥¢¥É¥ì¥¹ + , $arrInfo['shop_name'] //¡¡ÇÛÁ÷¸µ¡¡Ì¾Á° + , $arrInfo["email03"] //¡¡reply_to + , $arrInfo["email04"] //¡¡return_path + , $arrInfo["email04"] // Errors_to + , $arrInfo["email01"] // Bcc + ); + // °¸Àè¤ÎÀßÄê + $name = $arrData['order_name01'] . $arrData['order_name02'] ." ÍÍ"; + $objMail->setTo($arrData['order_email'], $name); + $objMail->sendMail(); + + return $customer_id; +} + +// ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î¤ªÆϤ±Àè¤ò¥³¥Ô¡¼¤¹¤ë +function lfCopyDeliv($uniqid, $arrData) { + $objQuery = new SC_Query(); + + // Ê̤ΤªÆϤ±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ + if($arrData["deliv_check"] != "1") { + $sqlval['deliv_name01'] = $arrData['order_name01']; + $sqlval['deliv_name02'] = $arrData['order_name02']; + $sqlval['deliv_kana01'] = $arrData['order_kana01']; + $sqlval['deliv_kana02'] = $arrData['order_kana02']; + $sqlval['deliv_pref'] = $arrData['order_pref']; + $sqlval['deliv_zip01'] = $arrData['order_zip01']; + $sqlval['deliv_zip02'] = $arrData['order_zip02']; + $sqlval['deliv_addr01'] = $arrData['order_addr01']; + $sqlval['deliv_addr02'] = $arrData['order_addr02']; + $sqlval['deliv_tel01'] = $arrData['order_tel01']; + $sqlval['deliv_tel02'] = $arrData['order_tel02']; + $sqlval['deliv_tel03'] = $arrData['order_tel03']; + $where = "order_temp_id = ?"; + $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid)); + } +} + +// ¼õÃí¥Æ¡¼¥Ö¥ë¤ØÅÐÏ¿ +function lfRegistOrder($objQuery, $arrData) { + $sqlval = $arrData; + + // ¼õÃí¥Æ¡¼¥Ö¥ë¤Ë½ñ¤­¹þ¤Þ¤Ê¤¤Îó¤ò½üµî + unset($sqlval['mail_flag']); // ¥á¥ë¥Þ¥¬¥Á¥§¥Ã¥¯ + unset($sqlval['deliv_check']); // Ê̤ΤªÆϤ±Àè¥Á¥§¥Ã¥¯ + unset($sqlval['point_check']); // ¥Ý¥¤¥ó¥ÈÍøÍÑ¥Á¥§¥Ã¥¯ + unset($sqlval['member_check']); // ¹ØÆþ»þ²ñ°÷¥Á¥§¥Ã¥¯ + unset($sqlval['password']); // ¥í¥°¥¤¥ó¥Ñ¥¹¥ï¡¼¥É + unset($sqlval['reminder']); // ¥ê¥Þ¥¤¥ó¥À¡¼¼ÁÌä + unset($sqlval['reminder_answer']); // ¥ê¥Þ¥¤¥ó¥À¡¼Åú¤¨ + + // Ãíʸ¥¹¥Æ¡¼¥¿¥¹:»ØÄ̵꤬¤±¤ì¤Ð¿·µ¬¼õÉÕ¤ËÀßÄê + if($sqlval["status"] == ""){ + $sqlval['status'] = '1'; + } + + // Ê̤ΤªÆϤ±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ + if($arrData["deliv_check"] != "1") { + $sqlval['deliv_name01'] = $arrData['order_name01']; + $sqlval['deliv_name02'] = $arrData['order_name02']; + $sqlval['deliv_kana01'] = $arrData['order_kana01']; + $sqlval['deliv_kana02'] = $arrData['order_kana02']; + $sqlval['deliv_pref'] = $arrData['order_pref']; + $sqlval['deliv_zip01'] = $arrData['order_zip01']; + $sqlval['deliv_zip02'] = $arrData['order_zip02']; + $sqlval['deliv_addr01'] = $arrData['order_addr01']; + $sqlval['deliv_addr02'] = $arrData['order_addr02']; + $sqlval['deliv_tel01'] = $arrData['order_tel01']; + $sqlval['deliv_tel02'] = $arrData['order_tel02']; + $sqlval['deliv_tel03'] = $arrData['order_tel03']; + } + + $order_id = $arrData['order_id']; // ¥ª¡¼¥À¡¼ID + $sqlval['create_date'] = 'now()'; // ¼õÃíÆü + + // ¥²¥Ã¥È¤ÎÃͤò¥¤¥ó¥µ¡¼¥È + //$sqlval = lfGetInsParam($sqlval); + + // INSERT¤Î¼Â¹Ô + $objQuery->insert("dtb_order", $sqlval); + + return $order_id; +} + +// ¼õÃí¾ÜºÙ¥Æ¡¼¥Ö¥ë¤ØÅÐÏ¿ +function lfRegistOrderDetail($objQuery, $order_id, $objCartSess) { + // ¥«¡¼¥ÈÆâ¾ðÊó¤Î¼èÆÀ + $arrCart = $objCartSess->getCartList(); + $max = count($arrCart); + + // ´û¤Ë¸ºß¤¹¤ë¾ÜºÙ¥ì¥³¡¼¥É¤ò¾Ã¤·¤Æ¤ª¤¯¡£ + $objQuery->delete("dtb_order_detail", "order_id = $order_id"); + + // µ¬³Ê̾°ìÍ÷ + $arrClassName = sfGetIDValueList("dtb_class", "class_id", "name"); + // µ¬³ÊʬÎà̾°ìÍ÷ + $arrClassCatName = sfGetIDValueList("dtb_classcategory", "classcategory_id", "name"); + + for ($i = 0; $i < $max; $i++) { + // ¾¦Éʵ¬³Ê¾ðÊó¤Î¼èÆÀ + $arrData = sfGetProductsClass($arrCart[$i]['id']); + + // ¸ºß¤¹¤ë¾¦ÉʤΤßɽ¼¨¤¹¤ë¡£ + if($arrData != "") { + $sqlval['order_id'] = $order_id; + $sqlval['product_id'] = $arrCart[$i]['id'][0]; + $sqlval['classcategory_id1'] = $arrCart[$i]['id'][1]; + $sqlval['classcategory_id2'] = $arrCart[$i]['id'][2]; + $sqlval['product_name'] = $arrData['name']; + $sqlval['product_code'] = $arrData['product_code']; + $sqlval['classcategory_name1'] = $arrClassCatName[$arrData['classcategory_id1']]; + $sqlval['classcategory_name2'] = $arrClassCatName[$arrData['classcategory_id2']]; + $sqlval['point_rate'] = $arrCart[$i]['point_rate']; + $sqlval['price'] = $arrCart[$i]['price']; + $sqlval['quantity'] = $arrCart[$i]['quantity']; + lfReduceStock($objQuery, $arrCart[$i]['id'], $arrCart[$i]['quantity']); + // INSERT¤Î¼Â¹Ô + $objQuery->insert("dtb_order_detail", $sqlval); + } else { + sfDispSiteError(CART_NOT_FOUND, "", false, "", true); + } + } +} + +/* ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Îºï½ü */ +function lfDeleteTempOrder($objQuery, $uniqid) { + $where = "order_temp_id = ?"; + $sqlval['del_flg'] = 1; + $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid)); + // $objQuery->delete("dtb_order_temp", $where, array($uniqid)); +} + +// ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î½»½ê¤¬ÅÐÏ¿ºÑ¤ß¥Æ¡¼¥Ö¥ë¤È°Û¤Ê¤ë¾ì¹ç¤Ï¡¢Ê̤ΤªÆϤ±Àè¤ËÄɲ乤ë +function lfSetNewAddr($uniqid, $customer_id) { + $objQuery = new SC_Query(); + $diff = false; + $find_same = false; + + $col = "deliv_name01,deliv_name02,deliv_kana01,deliv_kana02,deliv_tel01,deliv_tel02,deliv_tel03,deliv_zip01,deliv_zip02,deliv_pref,deliv_addr01,deliv_addr02"; + $where = "order_temp_id = ?"; + $arrRet = $objQuery->select($col, "dtb_order_temp", $where, array($uniqid)); + + // Í×ÁÇ̾¤Îdeliv_¤òºï½ü¤¹¤ë¡£ + foreach($arrRet[0] as $key => $val) { + $keyname = ereg_replace("^deliv_", "", $key); + $arrNew[$keyname] = $val; + } + + // ²ñ°÷¾ðÊó¥Æ¡¼¥Ö¥ë¤È¤ÎÈæ³Ó + $col = "name01,name02,kana01,kana02,tel01,tel02,tel03,zip01,zip02,pref,addr01,addr02"; + $where = "customer_id = ?"; + $arrCustomerAddr = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); + + // ²ñ°÷¾ðÊó¤Î½»½ê¤È°Û¤Ê¤ë¾ì¹ç + if($arrNew != $arrCustomerAddr[0]) { + // Ê̤ΤªÆϤ±Àè¥Æ¡¼¥Ö¥ë¤Î½»½ê¤ÈÈæ³Ó¤¹¤ë + $col = "name01,name02,kana01,kana02,tel01,tel02,tel03,zip01,zip02,pref,addr01,addr02"; + $where = "customer_id = ?"; + $arrOtherAddr = $objQuery->select($col, "dtb_other_deliv", $where, array($customer_id)); + + foreach($arrOtherAddr as $arrval) { + if($arrNew == $arrval) { + // ¤¹¤Ç¤ËƱ¤¸½»½ê¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë + $find_same = true; + } + } + + if(!$find_same) { + $diff = true; + } + } + + // ¿·¤·¤¤¤ªÆϤ±À褬ÅÐÏ¿ºÑ¤ß¤Î¤â¤Î¤È°Û¤Ê¤ë¾ì¹ç¤ÏÊ̤ΤªÆϤ±Àè¥Æ¡¼¥Ö¥ë¤ËÅÐÏ¿¤¹¤ë + if($diff) { + $sqlval = $arrNew; + $sqlval['customer_id'] = $customer_id; + $objQuery->insert("dtb_other_deliv", $sqlval); + } +} + +/* ¹ØÆþ¾ðÊó¤ò²ñ°÷¥Æ¡¼¥Ö¥ë¤ËÅÐÏ¿¤¹¤ë */ +function lfSetCustomerPurchase($customer_id, $arrData, $objQuery) { + $col = "first_buy_date, last_buy_date, buy_times, buy_total, point"; + $where = "customer_id = ?"; + $arrRet = $objQuery->select($col, "dtb_customer", $where, array($customer_id)); + $sqlval = $arrRet[0]; + + if($sqlval['first_buy_date'] == "") { + $sqlval['first_buy_date'] = "Now()"; + } + $sqlval['last_buy_date'] = "Now()"; + $sqlval['buy_times']++; + $sqlval['buy_total']+= $arrData['total']; + $sqlval['point'] = ($sqlval['point'] + $arrData['add_point'] - $arrData['use_point']); + + // ¥Ý¥¤¥ó¥È¤¬ÉÔ­¤·¤Æ¤¤¤ë¾ì¹ç + if($sqlval['point'] < 0) { + $objQuery->rollback(); + sfDispSiteError(LACK_POINT); + } + + $objQuery->update("dtb_customer", $sqlval, $where, array($customer_id)); +} + +// ºß¸Ë¤ò¸º¤é¤¹½èÍý +function lfReduceStock($objQuery, $arrID, $quantity) { + $where = "product_id = ? AND classcategory_id1 = ? AND classcategory_id2 = ?"; + $arrRet = $objQuery->select("stock, stock_unlimited", "dtb_products_class", $where, $arrID); + + // Çä¤êÀڤ쥨¥é¡¼ + if(($arrRet[0]['stock_unlimited'] != '1' && $arrRet[0]['stock'] < $quantity) || $quantity == 0) { + $objQuery->rollback(); + sfDispSiteError(SOLD_OUT, "", true); + // ̵À©¸Â¤Î¾ì¹ç¡¢ºß¸Ë¤ÏNULL + } elseif($arrRet[0]['stock_unlimited'] == '1') { + $sqlval['stock'] = null; + $objQuery->update("dtb_products_class", $sqlval, $where, $arrID); + // ºß¸Ë¤ò¸º¤é¤¹ + } else { + $sqlval['stock'] = ($arrRet[0]['stock'] - $quantity); + if($sqlval['stock'] == "") { + $sqlval['stock'] = '0'; + } + $objQuery->update("dtb_products_class", $sqlval, $where, $arrID); + } +} + +// GET¤ÎÃͤò¥¤¥ó¥µ¡¼¥ÈÍѤËÀ°¤¨¤ë +function lfGetInsParam($sqlVal){ + + foreach($_GET as $key => $val){ + // ¥«¥é¥à¤Î¸ºß¥Á¥§¥Ã¥¯ + if(sfColumnExists("dtb_order", $key)) $sqlVal[$key] = $val; + } + + return $sqlVal; +} + +?> Index: branches/dev/html/mobile/nonmember/nonmember/confirm.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/confirm.php (revision 12833) +++ branches/dev/html/mobile/nonmember/nonmember/confirm.php (revision 12833) @@ -0,0 +1,123 @@ +tpl_mainpage = 'nonmember/confirm.tpl'; + $this->tpl_css = '/css/layout/shopping/confirm.css'; + $this->tpl_title = "¤´ÆþÎÏÆâÍƤΤ´³Îǧ"; + global $arrPref; + $this->arrPref = $arrPref; + global $arrSex; + $this->arrSex = $arrSex; + global $arrMAILMAGATYPE; + $this->arrMAILMAGATYPE = $arrMAILMAGATYPE; + global $arrReminder; + $this->arrReminder = $arrReminder; + /* + session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç + ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ + private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ + */ + session_cache_limiter('private-no-expire'); + + } +} + +$objPage = new LC_Page(); +$objView = new SC_MobileView(); +$objCartSess = new SC_CartSession(); +$objSiteInfo = $objView->objSiteInfo; +$objSiteSess = new SC_SiteSession(); +$objCustomer = new SC_Customer(); +$arrInfo = $objSiteInfo->data; +$objQuery = new SC_Query(); + +// Á°¤Î¥Ú¡¼¥¸¤ÇÀµ¤·¤¯ÅÐÏ¿¼ê³¤­¤¬¹Ô¤ï¤ì¤¿µ­Ï¿¤¬¤¢¤ë¤«È½Äê +sfIsPrePage($objSiteSess, true); + +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); +$objPage->tpl_uniqid = $uniqid; + +// ¥«¡¼¥È½¸·×½èÍý +$objPage = sfTotalCart($objPage, $objCartSess, $arrInfo); +// °ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤ÎÆɹþ +$arrData = sfGetOrderTemp($uniqid); +// ¥«¡¼¥È½¸·×¤ò¸µ¤ËºÇ½ª·×»» +$arrData = sfTotalConfirm($arrData, $objPage, $objCartSess, $arrInfo, $objCustomer); + +// ¥«¡¼ÅÔÆâ¤Î¾¦ÉʤÎÇä¤êÀÚ¤ì¥Á¥§¥Ã¥¯ +$objCartSess->chkSoldOut($objCartSess->getCartList()); + +// ²ñ°÷¥í¥°¥¤¥ó¥Á¥§¥Ã¥¯ +if($objCustomer->isLoginSuccess()) { + $objPage->tpl_login = '1'; + $objPage->tpl_user_point = $objCustomer->getValue('point'); +} + +// ·èºÑ¶èʬ¤ò¼èÆÀ¤¹¤ë +$payment_type = ""; +if(sfColumnExists("dtb_payment", "memo01")){ + // MEMO03¤ËÃͤ¬Æþ¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥â¥¸¥å¡¼¥ëÄɲ䵤줿¤â¤Î¤È¤ß¤Ê¤¹ + $sql = "SELECT memo03 FROM dtb_payment WHERE payment_id = ?"; + $arrPayment = $objQuery->getall($sql, array($arrData['payment_id'])); + $payment_type = $arrPayment[0]["memo03"]; +} +$objPage->payment_type = $payment_type; + + +switch($_POST['mode']) { +// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë +case 'return': + // Àµ¾ï¤Ê¿ä°Ü¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + //header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); + header("Location: " . gfAddSessionId('nonmember/payment.php')); + exit; + break; +case 'confirm': + // ¤³¤Î»þÅÀ¤Ç¥ª¡¼¥À¡¼ID¤ò³ÎÊݤ·¤Æ¤ª¤¯¡Ê¥¯¥ì¥¸¥Ã¥È¡¢¥³¥ó¥Ó¥Ë·èºÑ¤ÇɬÍפʤ¿¤á¡Ë + // postgresql¤Èmysql¤È¤Ç½èÍý¤òʬ¤±¤ë + if (DB_TYPE == "pgsql") { + $order_id = $objQuery->nextval("dtb_order","order_id"); + }elseif (DB_TYPE == "mysql") { + $order_id = $objQuery->get_auto_increment("dtb_order"); + } + $arrData["order_id"] = $order_id; + + // ½¸·×·ë²Ì¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤ËÈ¿±Ç + sfRegistTempOrder($uniqid, $arrData); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + + // ·èºÑÊýË¡¤Ë¤è¤ê²èÌÌÀÚÂØ + if($payment_type != "") { + $_SESSION["payment_id"] = $arrData['payment_id']; + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_MODULE)); + }else{ + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_COMPLETE)); + } + break; +default: + break; +} + + +$objPage->arrData = $arrData; +$objPage->arrInfo = $arrInfo; +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); +//-------------------------------------------------------------------------------------------------------------------------- +?> Index: branches/dev/html/mobile/nonmember/nonmember/deliv_addr.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/deliv_addr.php (revision 14764) +++ branches/dev/html/mobile/nonmember/nonmember/deliv_addr.php (revision 14764) @@ -0,0 +1,320 @@ +tpl_mainpage = 'nonmember/deliv_addr.tpl'; + $this->tpl_title = "¾¤Î¤ªÆϤ±Àè¤ÎÅÐÏ¿"; + } +} + +$objPage = new LC_Page(); +$objView = new SC_MobileView(false); +$objQuery = new SC_Query(); +$objCustomer = new SC_Customer(); +$objConn = new SC_DBConn(); +$objSiteSess = new SC_SiteSession(); +$objCartSess = new SC_CartSession(); + +$objPage->arrForm = $_POST; +$objPage->arrPref = $arrPref; + +//Ê̤ΤªÆϤ±Àè£Ä£ÂÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó +$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" => "tel01", "convert" => "n" ), + array( "column" => "tel02", "convert" => "n" ), + array( "column" => "tel03", "convert" => "n" ), + ); + +//-- ¥Ç¡¼¥¿ÀßÄê +foreach($_POST as $key => $val) { + if ($key != "mode" && $key != "return" && $key != "submit" && $key != session_name()) { + $objPage->list_data[ $key ] = $val; + } +} + +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); + + + //-- ÆþÎϥǡ¼¥¿¤ÎÊÑ´¹ + $objPage->arrForm = lfConvertParam($objPage->arrForm, $arrRegistColumn); +sfprintr($_POST); +// Ìá¤ë¥Ü¥¿¥óÍѽèÍý +if (!empty($_POST["return"])) { + switch ($_POST["mode"]) { + case 'complete': + $_POST["mode"] = "set2"; + break; + case 'set2': + $_POST["mode"] = "set1"; + break; + default: + header("Location: " . gfAddSessionId('index.php')); + exit; + + } +}else{ + $_POST["mode"] = "set1"; +} + +switch ($_POST['mode']){ + case 'set1': + $objPage->arrErr = lfErrorCheck1($objPage->arrForm); + if (count($objPage->arrErr) == 0 && empty($_POST["return"])) { + $objPage->tpl_mainpage = 'nonmember/set1.tpl'; + + $checkVal = array("pref", "addr01", "addr02", "addr03", "tel01", "tel02", "tel03"); + foreach($checkVal as $key) { + unset($objPage->list_data[$key]); + } + + // ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ + if (@$objPage->arrForm['pref'] == "" && @$objPage->arrForm['addr01'] == "" && @$objPage->arrForm['addr02'] == "") { + $address = lfGetAddress($_REQUEST['zip01'].$_REQUEST['zip02']); + + $objPage->arrForm['pref'] = @$address[0]['state']; + $objPage->arrForm['addr01'] = @$address[0]['city'] . @$address[0]['town']; + } + } else { + $checkVal = array("name01", "name02", "kana01", "kana02", "zip01", "zip02"); + foreach($checkVal as $key) { + unset($objPage->list_data[$key]); + } + } + break; + case 'set2': + $objPage->arrErr = lfErrorCheck2($objPage->arrForm); + if (count($objPage->arrErr) == 0 && empty($_POST["return"])) { + $objPage->tpl_mainpage = 'nonmember/set2.tpl'; + } else { + $objPage->tpl_mainpage = 'nonmember/set1.tpl'; + + $checkVal = array("pref", "addr01", "addr02", "addr03", "tel01", "tel02", "tel03"); + foreach($checkVal as $key) { + unset($objPage->list_data[$key]); + } + } + break; + case 'complete': + $objPage->arrErr = lfErrorCheck($objPage->arrForm); + if (count($objPage->arrErr) == 0) { + // ÅÐÏ¿ + $other_deliv_id = lfRegistData($_POST,$arrRegistColumn,$uniqid); + + // ÅÐÏ¿ºÑ¤ß¤ÎÊ̤ΤªÆϤ±Àè¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Ë½ñ¤­¹þ¤à + lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id); + + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId('./payment.php')); + exit; + } else { + sfDispSiteError(CUSTOMER_ERROR, "", false, "", true); + } + break; + default: + $deliv_count = $objQuery->count("dtb_other_deliv", "customer_id=?", array($objCustomer->getValue('customer_id'))); + if ($deliv_count >= DELIV_ADDR_MAX){ + sfDispSiteError(FREE_ERROR_MSG, "", false, "ºÇÂçÅÐÏ¿·ï¿ô¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£"); + } +} + +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); + +//------------------------------------------------------------------------------------------------------------- + +//----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹ +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 lfErrorCheck() { + $objErr = new SC_CheckError(); + + $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK")); + $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","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK")); + return $objErr->arrErr; + +} + +/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */ +function lfErrorCheck1() { + $objErr = new SC_CheckError(); + + $objErr->doFunc(array("¤ªÌ¾Á°¡ÊÀ«¡Ë", 'name01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê̾¡Ë", 'name02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/À«¡Ë", 'kana01', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("¤ªÌ¾Á°¡Ê¥«¥Ê/̾¡Ë", 'kana02', STEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK", "MAX_LENGTH_CHECK", "KANA_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ1", "zip01", ZIP01_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ2", "zip02", ZIP02_LEN ) ,array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objErr->doFunc(array("͹ÊØÈÖ¹æ", "zip01", "zip02"), array("ALL_EXIST_CHECK")); + return $objErr->arrErr; + +} + +/* ¥¨¥é¡¼¥Á¥§¥Ã¥¯ */ +function lfErrorCheck2() { + $objErr = new SC_CheckError(); + + $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","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ2", 'tel02'), array("EXIST_CHECK","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ3", 'tel03'), array("EXIST_CHECK","NUM_CHECK")); + $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "tel01", "tel02", "tel03", TEL_LEN) ,array("TEL_CHECK")); + return $objErr->arrErr; + +} + + + +/* ÅÐÏ¿¼Â¹Ô Èó²ñ°÷¹ØÆþ¤Ç¤¢¤ë¤¿¤á¤Ë¹±µ×Ū¤ÊÅÐÏ¿¤Ï¤·¤Ê¤¤*/ +function lfRegistData($array, $arrRegistColumn,$uniqid) { + global $objConn; + global $objCustomer; + + $objQuery = new SC_Query(); + + $sqlse = "SELECT customer_id FROM dtb_order_temp WHERE order_temp_id = ?"; + $arrRegist['customer_id'] = $objConn->getOne($sqlse, array($uniqid)); + + foreach ($arrRegistColumn as $data) { + if (strlen($array[ $data["column"] ]) > 0) { + $arrRegist[ $data["column"] ] = $array[ $data["column"] ]; + } + } + + //$arrRegist['customer_id'] = $objCustomer->getvalue('customer_id'); + + //-- ÊÔ½¸ÅÐÏ¿¼Â¹Ô + $objConn->query("BEGIN"); + if ($array['other_deliv_id'] != ""){ + $objConn->autoExecute("dtb_other_deliv", $arrRegist, "other_deliv_id='" .addslashes($array["other_deliv_id"]). "'"); + }else{ + $objConn->autoExecute("dtb_other_deliv", $arrRegist); + + $sqlse = "SELECT max(other_deliv_id) FROM dtb_other_deliv WHERE customer_id = ?"; + $array['other_deliv_id'] = $objConn->getOne($sqlse, array($arrRegist['customer_id'])); + } + + $objConn->query("COMMIT"); + + return $array['other_deliv_id']; +} + + + +// ͹ÊØÈֹ椫¤é½»½ê¤Î¼èÆÀ +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); + + /* + Áí̳¾Ê¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ¥¤¥ó¥Ý¡¼¥È¤¹¤ë¤È + °Ê²¼¤Î¤è¤¦¤Êʸ»úÎó¤¬Æþ¤Ã¤Æ¤¤¤ë¤Î¤Ç Âкö¤¹¤ë¡£ + ¡¦¡Ê£±¡¦£±£¹ÃúÌÜ¡Ë + ¡¦°Ê²¼¤Ë·ÇºÜ¤¬¤Ê¤¤¾ì¹ç + */ + $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; +} + +/* Ê̤ΤªÆϤ±Àè½»½ê¤ò°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤Ø */ +function lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id) { + // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® + $sqlval['order_temp_id'] = $uniqid; + $sqlval['update_date'] = 'Now()'; + $sqlval['customer_id'] = '0'; + //$sqlval['customer_id'] = $objCustomer->getValue('customer_id'); + $sqlval['order_birth'] = $objCustomer->getValue('birth'); + + $objQuery = new SC_Query(); + $where = "other_deliv_id = ?"; + $arrRet = $objQuery->select("*", "dtb_other_deliv", $where, array($other_deliv_id)); + + $sqlval['deliv_check'] = '1'; + $sqlval['deliv_name01'] = $arrRet[0]['name01']; + $sqlval['deliv_name02'] = $arrRet[0]['name02']; + $sqlval['deliv_kana01'] = $arrRet[0]['kana01']; + $sqlval['deliv_kana02'] = $arrRet[0]['kana02']; + $sqlval['deliv_zip01'] = $arrRet[0]['zip01']; + $sqlval['deliv_zip02'] = $arrRet[0]['zip02']; + $sqlval['deliv_pref'] = $arrRet[0]['pref']; + $sqlval['deliv_addr01'] = $arrRet[0]['addr01']; + $sqlval['deliv_addr02'] = $arrRet[0]['addr02']; + $sqlval['deliv_tel01'] = $arrRet[0]['tel01']; + $sqlval['deliv_tel02'] = $arrRet[0]['tel02']; + $sqlval['deliv_tel03'] = $arrRet[0]['tel03']; + sfRegistTempOrder($uniqid, $sqlval); +} + +?> Index: branches/dev/html/mobile/nonmember/nonmember/payment.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/payment.php (revision 14771) +++ branches/dev/html/mobile/nonmember/nonmember/payment.php (revision 14771) @@ -0,0 +1,374 @@ +tpl_css = '/css/layout/shopping/pay.css'; + $this->tpl_mainpage = 'nonmember/payment.tpl'; + $this->tpl_onload = 'fnCheckInputPoint();'; + $this->tpl_title = "¤ª»ÙʧÊýË¡¤Î»ØÄê"; + /* + session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç + ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ + private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ + */ + session_cache_limiter('private-no-expire'); + } +} + +$objPage = new LC_Page(); +$objView = new SC_MobileView(); +$objSiteSess = new SC_SiteSession(); +$objCartSess = new SC_CartSession(); +$objCustomer = new SC_Customer(); +$objSiteInfo = $objView->objSiteInfo; +$arrInfo = $objSiteInfo->data; + +// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ +$objFormParam = new SC_FormParam(); +// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ +lfInitParam(); +// POSTÃͤμèÆÀ +$objFormParam->setParam($_POST); +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); +// ¥æ¥Ë¡¼¥¯ID¤ò°ú¤­·Ñ¤° +$objPage->tpl_uniqid = $uniqid; + +// ²ñ°÷¥í¥°¥¤¥ó¥Á¥§¥Ã¥¯ +if($objCustomer->isLoginSuccess()) { + $objPage->tpl_login = '1'; + $objPage->tpl_user_point = $objCustomer->getValue('point'); +} + +// ¶â³Û¤Î¼èÆÀ (¹ØÆþÅÓÃæ¤ÇÇä¤êÀڤ줿¾ì¹ç¤Ë¤Ï¤³¤Î´Ø¿ôÆâ¤Ë¤Æ¤½¤Î¾¦ÉʤθĿô¤¬£°¤Ë¤Ê¤ë) +$objPage = sfTotalCart($objPage, $objCartSess, $arrInfo); +$objPage->arrData = sfTotalConfirm($arrData, $objPage, $objCartSess, $arrInfo); + +// ¥«¡¼ÅÔÆâ¤Î¾¦ÉʤÎÇä¤êÀÚ¤ì¥Á¥§¥Ã¥¯ +$objCartSess->chkSoldOut($objCartSess->getCartList(), true); + +// Ìá¤ë¥Ü¥¿¥ó¤Î½èÍý +if (!empty($_POST['return'])) { + switch ($_POST['mode']) { + case 'confirm': + $_POST['mode'] = 'payment'; + break; + default: + // Àµ¾ï¤Ê¿ä°Ü¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + //header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_TOP)); + header("Location: " . gfAddSessionId('../nonmember/deliv.php')); + exit; +// $_POST['mode'] = "deliv_date"; + } +} + +switch($_POST['mode']) { +// »Ùʧ¤¤ÊýË¡»ØÄê ¢ª ÇÛãÆü»þ»ØÄê +case 'deliv_date': + + // ÆþÎÏÃͤÎÊÑ´¹ + $objFormParam->convParam(); + $objPage->arrErr = lfCheckError($objPage->arrData); + if (!isset($objPage->arrErr['payment_id'])) { + // »Ùʧ¤¤ÊýË¡¤ÎÆþÎÏ¥¨¥é¡¼¤Ê¤· + $objPage->tpl_mainpage = 'nonmember/deliv_date.tpl'; + $objPage->tpl_title = "ÇÛãÆü»þ»ØÄê"; + break; + } else { + // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ + $uniqid = $objSiteSess->getUniqId(); + // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ + lfSetOrderTempData($uniqid); + } + break; +case 'confirm': + // ÆþÎÏÃͤÎÊÑ´¹ + $objFormParam->convParam(); + $objPage->arrErr = lfCheckError($objPage->arrData ); + // ÆþÎÏ¥¨¥é¡¼¤Ê¤· + if(count($objPage->arrErr) == 0) { + // DB¤Ø¤Î¥Ç¡¼¥¿ÅÐÏ¿ + lfRegistData($uniqid); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ³Îǧ¥Ú¡¼¥¸¤Ø°ÜÆ° + //header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_CONFIRM)); + header("Location: " . gfAddSessionId('./confirm.php')); + exit; + }else{ + // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ + $uniqid = $objSiteSess->getUniqId(); + // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ + lfSetOrderTempData($uniqid); + if (!isset($objPage->arrErr['payment_id'])) { + // »Ùʧ¤¤ÊýË¡¤ÎÆþÎÏ¥¨¥é¡¼¤Ê¤· + $objPage->tpl_mainpage = 'nonmember/deliv_date.tpl'; + $objPage->tpl_title = "ÇÛãÆü»þ»ØÄê"; + } + } + break; +// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë +case 'return': + // Èó²ñ°÷¤Î¾ì¹ç + // Àµ¾ï¤Ê¿ä°Ü¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + header("Location: " . gfAddSessionId('../shopping/index.php')); + exit; + break; +// »Ùʧ¤¤ÊýË¡¤¬Êѹ¹¤µ¤ì¤¿¾ì¹ç +case 'payment': + // ¤³¤³¤Îbreak¤Ï¡¢°ÕÌ£¤¬¤¢¤ë¤Î¤Ç³°¤µ¤Ê¤¤¤Ç²¼¤µ¤¤¡£ + break; +default: + // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ + lfSetOrderTempData($uniqid); + break; +} + +// ŹÊÞ¾ðÊó¤Î¼èÆÀ +$arrInfo = $objSiteInfo->data; +// ¹ØÆþ¶â³Û¤Î¼èÆÀÆÀ +$total_pretax = $objCartSess->getAllProductsTotal($arrInfo); +// »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ +$objPage->arrPayment = lfGetPayment($total_pretax); +// ÇÛÁ÷»þ´Ö¤Î¼èÆÀ +$arrRet = sfGetDelivTime($objFormParam->getValue('payment_id')); +$objPage->arrDelivTime = sfArrKeyValue($arrRet, 'time_id', 'deliv_time'); +$objPage->objCustomer = $objCustomer; +//¡¡ÇÛÁ÷Æü°ìÍ÷¤Î¼èÆÀ +$objPage->arrDelivDate = lfGetDelivDate(); + +$objPage->arrForm = $objFormParam->getFormParamList(); + +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); +//-------------------------------------------------------------------------------------------------------------------------- +/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ +function lfInitParam() { + global $objFormParam; + $objFormParam->addParam("¤ª»Ùʧ¤¤ÊýË¡", "payment_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¥Ý¥¤¥ó¥È", "use_point", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK", "ZERO_START")); + $objFormParam->addParam("ÇÛã»þ´Ö", "deliv_time_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¤´¼ÁÌä", "message", LTEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Ý¥¤¥ó¥È¤ò»ÈÍѤ¹¤ë", "point_check", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"), '2'); + $objFormParam->addParam("ÇÛãÆü", "deliv_date", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); +} + +function lfGetPayment($total_pretax) { + $objQuery = new SC_Query(); + $objQuery->setorder("rank DESC"); + //ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤»ÙʧÊýË¡¤ò¼èÆÀ + $arrRet = $objQuery->select("payment_id, payment_method, rule, upper_rule, note, payment_image", "dtb_payment", "del_flg = 0 AND deliv_id IN (SELECT deliv_id FROM dtb_deliv WHERE del_flg = 0) "); + //ÍøÍѾò·ï¤«¤é»Ùʧ²ÄǽÊýË¡¤òȽÄê + foreach($arrRet as $data) { + //²¼¸Â¤È¾å¸Â¤¬ÀßÄꤵ¤ì¤Æ¤¤¤ë + if($data['rule'] > 0 && $data['upper_rule'] > 0) { + if($data['rule'] <= $total_pretax && $data['upper_rule'] >= $total_pretax) { + $arrPayment[] = $data; + } + //²¼¸Â¤Î¤ßÀßÄꤵ¤ì¤Æ¤¤¤ë + } elseif($data['rule'] > 0) { + if($data['rule'] <= $total_pretax) { + $arrPayment[] = $data; + } + //¾å¸Â¤Î¤ßÀßÄꤵ¤ì¤Æ¤¤¤ë + } elseif($data['upper_rule'] > 0) { + if($data['upper_rule'] >= $total_pretax) { + $arrPayment[] = $data; + } + //ÀßÄê¤Ê¤· + } else { + $arrPayment[] = $data; + } + } + return $arrPayment; +} + +/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */ +function lfCheckError($arrData) { + global $objFormParam; + global $objCustomer; + // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ + $arrRet = $objFormParam->getHashArray(); + $objErr = new SC_CheckError($arrRet); + $objErr->arrErr = $objFormParam->checkError(); + + if($_POST['point_check'] == '1') { + $objErr->doFunc(array("¥Ý¥¤¥ó¥È¤ò»ÈÍѤ¹¤ë", "point_check"), array("EXIST_CHECK")); + $objErr->doFunc(array("¥Ý¥¤¥ó¥È", "use_point"), array("EXIST_CHECK")); + $max_point = $objCustomer->getValue('point'); + if($max_point == "") { + $max_point = 0; + } + if($arrRet['use_point'] > $max_point) { + $objErr->arrErr['use_point'] = "¢¨ ¤´ÍøÍѥݥ¤¥ó¥È¤¬½ê»ý¥Ý¥¤¥ó¥È¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£
"; + } + if(($arrRet['use_point'] * POINT_VALUE) > $arrData['subtotal']) { + $objErr->arrErr['use_point'] = "¢¨ ¤´ÍøÍѥݥ¤¥ó¥È¤¬¤´¹ØÆþ¶â³Û¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£
"; + } + } + return $objErr->arrErr; +} + +/* »Ùʧ¤¤Êýˡʸ»úÎó¤Î¼èÆÀ */ +function lfGetPaymentInfo($payment_id) { + $objQuery = new SC_Query(); + $where = "payment_id = ?"; + $arrRet = $objQuery->select("payment_method, charge", "dtb_payment", $where, array($payment_id)); + return (array($arrRet[0]['payment_method'], $arrRet[0]['charge'])); +} + +/* ÇÛÁ÷»þ´Öʸ»úÎó¤Î¼èÆÀ */ +function lfGetDelivTimeInfo($time_id) { + $objQuery = new SC_Query(); + $where = "time_id = ?"; + $arrRet = $objQuery->select("deliv_id, deliv_time", "dtb_delivtime", $where, array($time_id)); + return (array($arrRet[0]['deliv_id'], $arrRet[0]['deliv_time'])); +} + +/* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */ +function lfRegistData($uniqid) { + global $objFormParam; + $arrRet = $objFormParam->getHashArray(); + $sqlval = $objFormParam->getDbArray(); + // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® + $sqlval['order_temp_id'] = $uniqid; + $sqlval['update_date'] = 'Now()'; + + if($sqlval['payment_id'] != "") { + list($sqlval['payment_method'], $sqlval['charge']) = lfGetPaymentInfo($sqlval['payment_id']); + } else { + $sqlval['payment_id'] = '0'; + $sqlval['payment_method'] = ""; + } + + if($sqlval['deliv_time_id'] != "") { + list($sqlval['deliv_id'], $sqlval['deliv_time']) = lfGetDelivTimeInfo($sqlval['deliv_time_id']); + } else { + $sqlval['deliv_time_id'] = '0'; + $sqlval['deliv_id'] = '0'; + $sqlval['deliv_time'] = ""; + } + + // »ÈÍѥݥ¤¥ó¥È¤ÎÀßÄê + if($sqlval['point_check'] != '1') { + $sqlval['use_point'] = 0; + } + + sfRegistTempOrder($uniqid, $sqlval); +} + +/* ÇÛãÆü°ìÍ÷¤ò¼èÆÀ¤¹¤ë */ +function lfGetDelivDate() { + $objCartSess = new SC_CartSession(); + $objQuery = new SC_Query(); + // ¾¦ÉÊID¤Î¼èÆÀ + $max = $objCartSess->getMax(); + for($i = 1; $i <= $max; $i++) { + if($_SESSION[$objCartSess->key][$i]['id'][0] != "") { + $arrID['product_id'][$i] = $_SESSION[$objCartSess->key][$i]['id'][0]; + } + } + if(count($arrID['product_id']) > 0) { + $id = implode(",", $arrID['product_id']); + //¾¦Éʤ«¤éȯÁ÷Ìܰ¤μèÆÀ + $deliv_date = $objQuery->get("dtb_products", "MAX(deliv_date_id)", "product_id IN (".$id.")"); + //ȯÁ÷ÌÜ°Â + switch($deliv_date) { + //¨ÆüȯÁ÷ + case '1': + $start_day = 1; + break; + //1-2Æü¸å + case '2': + $start_day = 3; + break; + //3-4Æü¸å + case '3': + $start_day = 5; + break; + //1½µ´Ö°ÊÆâ + case '4': + $start_day = 8; + break; + //2½µ´Ö°ÊÆâ + case '5': + $start_day = 15; + break; + //3½µ´Ö°ÊÆâ + case '6': + $start_day = 22; + break; + //1¥ö·î°ÊÆâ + case '7': + $start_day = 32; + break; + //2¥ö·î°Ê¹ß + case '8': + $start_day = 62; + break; + //¤ª¼è¤ê´ó¤»(¾¦ÉÊÆþ²Ù¸å) + case '9': + $start_day = ""; + break; + default: + //¤ªÆϤ±Æü¤¬ÀßÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç + $start_day = ""; + break; + } + //ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ«¤é¡¢ÇÛãÆü¤ÎÇÛÎó¤ò¼èÆÀ¤¹¤ë + $arrDelivDate = lfGetDateArray($start_day, DELIV_DATE_END_MAX); + } + return $arrDelivDate; +} + +//ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ«¤é¡¢ÇÛãÆü¤ÎÇÛÎó¤ò¼èÆÀ¤¹¤ë +function lfGetDateArray($start_day, $end_day) { + global $arrWDAY; + //ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ¬¥»¥Ã¥È¤µ¤ì¤Æ¤¤¤ì¤Ð + if($start_day >= 1) { + $now_time = time(); + $max_day = $start_day + $end_day; + // ½¸·× + for ($i = $start_day; $i < $max_day; $i++) { + // ´ðËÜ»þ´Ö¤«¤éÆü¿ô¤òÄɲ䷤Ƥ¤¤¯ + $tmp_time = $now_time + ($i * 24 * 3600); + list($y, $m, $d, $w) = split(" ", date("y m d w", $tmp_time)); + $val = sprintf("%02d/%02d/%02d(%s)", $y, $m, $d, $arrWDAY[$w]); + $arrDate[$val] = $val; + } + } else { + $arrDate = false; + } + return $arrDate; +} + +//°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ¤¹¤ë +function lfSetOrderTempData($uniqid) { + global $objQuery; + global $objFormParam; + + $objQuery = new SC_Query(); + $col = "payment_id, use_point, deliv_time_id, message, point_check, deliv_date"; + $from = "dtb_order_temp"; + $where = "order_temp_id = ?"; + $arrRet = $objQuery->select($col, $from, $where, array($uniqid)); + // DBÃͤμèÆÀ + $objFormParam->setParam($arrRet[0]); + return $objFormParam; +} + + +?> Index: branches/dev/html/mobile/nonmember/nonmember/load_payment_module.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/load_payment_module.php (revision 12263) +++ branches/dev/html/mobile/nonmember/nonmember/load_payment_module.php (revision 12263) @@ -0,0 +1,44 @@ +getall($sql, array($payment_id)); +} + +if(count($arrPayment) > 0) { + $path = $arrPayment[0]['module_path']; + if(file_exists($path)) { + require_once($path); + exit; + } else { + sfDispSiteError(FREE_ERROR_MSG, "", true, "¥â¥¸¥å¡¼¥ë¥Õ¥¡¥¤¥ë¤Î¼èÆÀ¤Ë¼ºÇÔ¤·¤Þ¤·¤¿¡£
¤³¤Î¼ê³¤­¤Ï̵¸ú¤È¤Ê¤ê¤Þ¤·¤¿¡£", true); + } +} + +?> Index: branches/dev/html/mobile/nonmember/nonmember/deliv.php =================================================================== --- branches/dev/html/mobile/nonmember/nonmember/deliv.php (revision 13278) +++ branches/dev/html/mobile/nonmember/nonmember/deliv.php (revision 13278) @@ -0,0 +1,217 @@ +tpl_mainpage = 'nonmember/index.tpl'; + global $arrPref; + $this->arrPref = $arrPref; + global $arrSex; + $this->arrSex = $arrSex; + global $arrJob; + $this->arrJob = $arrJob; + $this->tpl_onload = 'fnCheckInputDeliv();'; + + /* + session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç + ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£ + private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£ + */ + session_cache_limiter('private-no-expire'); + } +} + +$conn = new SC_DBConn(); +$objPage = new LC_Page(); +$objView = new SC_MobileView(); +$objSiteSess = new SC_SiteSession(); +$objCartSess = new SC_CartSession(); +$objCustomer = new SC_Customer(); +$objCookie = new SC_Cookie(); +$objFormParam = new SC_FormParam(); // ¥Õ¥©¡¼¥àÍÑ +lfInitParam(); // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ +$objFormParam->setParam($_POST); // POSTÃͤμèÆÀ + +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); + +// ¥æ¥Ë¡¼¥¯ID¤ò°ú¤­·Ñ¤° +$objPage->tpl_uniqid = $uniqid; + +if(!empty($_POST["mode2"]) ){ + if ($_POST["mode2"] == "deliv") { + + $objFormParam = new SC_FormParam(); + // ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ + + // POSTÃͤμèÆÀ + $objFormParam->setParam($_POST); + $arrRet = $objFormParam->getHashArray(); + $sqlval = $objFormParam->getDbArray(); + + // ÆþÎÏÃͤμèÆÀ + $objPage->arrForm = $objFormParam->getFormParamList(); + $objPage->arrErr = $arrErr; + + foreach($_POST as $key => $value){ + $objPage->arrAddr[0][$key] = $value; + } + + //¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î°ì»þÊݸÍѥơ¼¥Ö¥ëdtb_order_temp¤Ë¥Ç¡¼¥¿¤ò³ÊǼ¤¹¤ë + lfRegistDataTemp($objPage->arrAddr[0]['uniqid'],$objPage->arrAddr[0]); + + lfCopyDeliv($objPage->tpl_uniqid, $_POST); + + $objPage->tpl_mainpage = 'nonmember/nonmember_deliv.tpl'; + $objPage->tpl_title = '¤ªÆϤ±Àè¾ðÊó'; + //objPage¤Î¾ðÊó¤òobjView¤Ë³ÊǼ + $objView->assignobj($objPage); + $objView->display(SITE_FRAME); + } + + if ($_POST["mode2"] == "customer_addr") { + //print_r($_POST); + if ($_POST['deli'] != "") { + header("Location:" . gfAddSessionId("./payment.php")); + exit; + }else{ + // ¥¨¥é¡¼¤òÊÖ¤¹ + $arrErr['deli'] = '¢¨ ¤ªÆϤ±Àè¤òÁªÂò¤·¤Æ¤¯¤À¤µ¤¤¡£'; + } + } +//Ìá¤ë¥Ü¥¿¥óÍѽèÍý +}elseif(!empty($_POST["mode"]) && $_POST["mode"]=="deliv_date"){ + //uniqid¤«¤é¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¡¼¥¿¤òÆɤ߹þ¤ßɽ¼¨¤¹¤ë + $objQuery = new SC_Query(); + $where = "order_temp_id = ?"; + $arrRet = $objQuery->select("*", "dtb_order_temp", $where, array($objPage->tpl_uniqid)); + $objFormParam->setParam($arrRet[0]); + $objPage->arrForm = $objFormParam->getFormParamList(); + + foreach($objPage->arrForm as $key => $value){ + $objPage->arrAddr[0][str_replace("order_","",$key)] = $value['value']; + } + $objPage->tpl_mainpage = 'nonmember/nonmember_deliv.tpl'; + $objPage->tpl_title = '¤ªÆϤ±Àè¾ðÊó'; + $objView->assignobj($objPage); + $objView->display(SITE_FRAME); +} + +/** + *ÆþÎϤµ¤ì¤¿¾ðÊó¤ò¥Ç¡¼¥¿¥Ù¡¼¥¹dtb_order_temp¤Ë³ÊǼ¤¹¤ë + * + * @param string $uniqid unique id + * @param array $array + * +*/ +function lfRegistDataTemp($uniqid,$array) { + 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'; + + $sqlval['order_name01'] = $array['name01']; + $sqlval['order_name02'] = $array['name02']; + $sqlval['order_kana01'] = $array['kana01']; + $sqlval['order_kana02'] = $array['kana02']; + $sqlval['order_zip01'] = $array['zip01']; + $sqlval['order_zip02'] = $array['zip02']; + $sqlval['order_pref'] = $array['pref']; + $sqlval['order_addr01'] = $array['addr01']; + $sqlval['order_addr02'] = $array['addr02']; + $sqlval['order_tel01'] = $array['tel01']; + $sqlval['order_tel02'] = $array['tel02']; + $sqlval['order_tel03'] = $array['tel03']; + $sqlval['order_email'] = $array['email']; + $sqlval['order_sex'] = $array['sex']; + + // ´û¸¥Ç¡¼¥¿¤Î¥Á¥§¥Ã¥¯ + $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 lfInitParam() { + global $objFormParam; + $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "order_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "order_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "order_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "order_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ1", "order_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ2", "order_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("ÅÔÆ»Éܸ©", "order_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("½»½ê1", "order_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("½»½ê2", "order_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "order_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "order_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "order_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ1", "order_fax01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ2", "order_fax02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("FAXÈÖ¹æ3", "order_fax03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "order_email", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹¡Ê³Îǧ¡Ë", "order_email_check", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "NO_SPTAB", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK"), "", false); + $objFormParam->addParam("ǯ", "year", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("·î", "month", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("Æü", "day", INT_LEN, "n", array("MAX_LENGTH_CHECK"), "", false); + $objFormParam->addParam("À­ÊÌ", "order_sex", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¿¦¶È", "order_job", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("Ê̤ΤªÆϤ±Àè", "deliv_check", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡ÊÀ«¡Ë", "deliv_name01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°¡Ê̾¡Ë", "deliv_name02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥»¥¤¡Ë", "deliv_kana01", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê¡Ê¥á¥¤¡Ë", "deliv_kana02", STEXT_LEN, "KVCa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("¥á¡¼¥ë¥Þ¥¬¥¸¥ó", "mail_flag", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"), 1); +} + +/* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */ + + +// ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Î¤ªÆϤ±Àè¤ò¥³¥Ô¡¼¤¹¤ë +function lfCopyDeliv($uniqid, $arrData) { + $objQuery = new SC_Query(); + + // Ê̤ΤªÆϤ±Àè¤ò»ØÄꤷ¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢ÇÛÁ÷Àè¤ËÅÐÏ¿½»½ê¤ò¥³¥Ô¡¼¤¹¤ë¡£ + if($arrData["deliv_check"] != "1") { + $sqlval['deliv_name01'] = $arrData['order_name01']; + $sqlval['deliv_name02'] = $arrData['order_name02']; + $sqlval['deliv_kana01'] = $arrData['order_kana01']; + $sqlval['deliv_kana02'] = $arrData['order_kana02']; + $sqlval['deliv_pref'] = $arrData['order_pref']; + $sqlval['deliv_zip01'] = $arrData['order_zip01']; + $sqlval['deliv_zip02'] = $arrData['order_zip02']; + $sqlval['deliv_addr01'] = $arrData['order_addr01']; + $sqlval['deliv_addr02'] = $arrData['order_addr02']; + $sqlval['deliv_tel01'] = $arrData['order_tel01']; + $sqlval['deliv_tel02'] = $arrData['order_tel02']; + $sqlval['deliv_tel03'] = $arrData['order_tel03']; + $where = "order_temp_id = ?"; + $objQuery->update("dtb_order_temp", $sqlval, $where, array($uniqid)); + } +} + +?>