Index: /branches/dev/html/mobile/nonmember/load_payment_module.php =================================================================== --- /branches/dev/html/mobile/nonmember/load_payment_module.php (revision 12263) +++ /branches/dev/html/mobile/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/deliv.php =================================================================== --- /branches/dev/html/mobile/nonmember/deliv.php (revision 12263) +++ /branches/dev/html/mobile/nonmember/deliv.php (revision 12263) @@ -0,0 +1,317 @@ +tpl_mainpage = 'shopping/deliv.tpl'; + $this->tpl_css = '/css/layout/shopping/index.css'; + global $arrPref; + $this->arrPref = $arrPref; + $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(); +// ¥¯¥Ã¥­¡¼´ÉÍý¥¯¥é¥¹ +$objCookie = new SC_Cookie(COOKIE_EXPIRE); +// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ +$objFormParam = new SC_FormParam(); +// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ +lfInitParam(); +// POSTÃͤμèÆÀ +$objFormParam->setParam($_POST); + +$objLoginFormParam = new SC_FormParam(); // ¥í¥°¥¤¥ó¥Õ¥©¡¼¥àÍÑ +lfInitLoginFormParam(); // ½é´üÀßÄê +$objLoginFormParam->setParam($_POST); // POSTÃͤμèÆÀ + +// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯ +$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess); +$objPage->tpl_uniqid = $uniqid; + +// ¥í¥°¥¤¥ó¥Á¥§¥Ã¥¯ +if($_POST['mode'] != 'login' && !$objCustomer->isLoginSuccess()) { + // ÉÔÀµ¥¢¥¯¥»¥¹¤È¤ß¤Ê¤¹ + sfDispSiteError(CUSTOMER_ERROR, "", false, "", true); +} + +switch($_POST['mode']) { +case 'login': + $objLoginFormParam->toLower('login_email'); + $objPage->arrErr = $objLoginFormParam->checkError(); + $arrForm = $objLoginFormParam->getHashArray(); + // ¥¯¥Ã¥­¡¼ÊݸȽÄê + if($arrForm['login_memory'] == "1" && $arrForm['login_email'] != "") { + $objCookie->setCookie('login_email', $_POST['login_email']); + } else { + $objCookie->setCookie('login_email', ''); + } + + if(count($objPage->arrErr) == 0) { + // ¥í¥°¥¤¥óȽÄê + if(!$objCustomer->getCustomerDataFromMobilePhoneIdPass($arrForm['login_pass']) && + !$objCustomer->getCustomerDataFromEmailPass($arrForm['login_pass'], $arrForm['login_email'], true)) { + // ²¾ÅÐÏ¿¤ÎȽÄê + $objQuery = new SC_Query; + $where = "email = ? AND status = 1 AND del_flg = 0"; + $ret = $objQuery->count("dtb_customer", $where, array($arrForm['login_email'])); + + if($ret > 0) { + sfDispSiteError(TEMP_LOGIN_ERROR, "", false, "", true); + } else { + sfDispSiteError(SITE_LOGIN_ERROR, "", false, "", true); + } + } + } else { + // ¥í¥°¥¤¥ó¥Ú¡¼¥¸¤ËÌá¤ë + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_TOP)); + exit; + } + + // ¥í¥°¥¤¥ó¤¬À®¸ù¤·¤¿¾ì¹ç¤Ï·ÈÂÓüËöID¤òÊݸ¤¹¤ë¡£ + $objCustomer->updateMobilePhoneId(); + + // ·ÈÂӤΥ᡼¥ë¥¢¥É¥ì¥¹¤ò¥³¥Ô¡¼¤¹¤ë¡£ + $objCustomer->updateEmailMobile(); + + // ·ÈÂӤΥ᡼¥ë¥¢¥É¥ì¥¹¤¬ÅÐÏ¿¤µ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç + if (!$objCustomer->hasValue('email_mobile')) { + header('Location: ' . gfAddSessionId('../entry/email_mobile.php')); + exit; + } + break; +// ºï½ü +case 'delete': + if (sfIsInt($_POST['other_deliv_id'])) { + $objQuery = new SC_Query(); + $where = "other_deliv_id = ?"; + $arrRet = $objQuery->delete("dtb_other_deliv", $where, array($_POST['other_deliv_id'])); + $objFormParam->setValue('select_addr_id', ''); + } + break; +// ²ñ°÷ÅÐÏ¿½»½ê¤ËÁ÷¤ë +case 'customer_addr': + // ¤ªÆϤ±À褬¥Á¥§¥Ã¥¯¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¹¹¿·½èÍý¤ò¹Ô¤¦ + if ($_POST['deli'] != "") { + // ²ñ°÷¾ðÊó¤Î½»½ê¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Ë½ñ¤­¹þ¤à + lfRegistDelivData($uniqid, $objCustomer); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); + exit; + }else{ + // ¥¨¥é¡¼¤òÊÖ¤¹ + $arrErr['deli'] = '¢¨ ¤ªÆϤ±Àè¤òÁªÂò¤·¤Æ¤¯¤À¤µ¤¤¡£'; + } + break; + +// ÅÐÏ¿ºÑ¤ß¤ÎÊ̤ΤªÆϤ±Àè¤ËÁ÷¤ë +case 'other_addr': + // ¤ªÆϤ±À褬¥Á¥§¥Ã¥¯¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¹¹¿·½èÍý¤ò¹Ô¤¦ + if ($_POST['deli'] != "") { + if (sfIsInt($_POST['other_deliv_id'])) { + // ÅÐÏ¿ºÑ¤ß¤ÎÊ̤ΤªÆϤ±Àè¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Ë½ñ¤­¹þ¤à + lfRegistOtherDelivData($uniqid, $objCustomer, $_POST['other_deliv_id']); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); + exit; + } + }else{ + // ¥¨¥é¡¼¤òÊÖ¤¹ + $arrErr['deli'] = '¢¨ ¤ªÆϤ±Àè¤òÁªÂò¤·¤Æ¤¯¤À¤µ¤¤¡£'; + } + break; + +/* +// Ê̤ΤªÆϤ±Àè¤ò»ØÄê +case 'new_addr': + // ÆþÎÏÃͤÎÊÑ´¹ + $objFormParam->convParam(); + $objPage->arrErr = lfCheckError($arrRet); + // ÆþÎÏ¥¨¥é¡¼¤Ê¤· + if(count($objPage->arrErr) == 0) { + // DB¤Ø¤ªÆϤ±Àè¤òÅÐÏ¿ + lfRegistNewAddrData($uniqid, $objCustomer); + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . URL_SHOP_PAYMENT); + exit; + } + break; +*/ + +// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë +case 'return': + // ³Îǧ¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . MOBILE_URL_CART_TOP); + exit; + break; +default: + $objQuery = new SC_Query(); + $where = "order_temp_id = ?"; + $arrRet = $objQuery->select("*", "dtb_order_temp", $where, array($uniqid)); + $objFormParam->setParam($arrRet[0]); + break; +} + +/** ɽ¼¨½èÍý **/ + +// ²ñ°÷ÅÐÏ¿½»½ê¤Î¼èÆÀ +$col = "name01, name02, pref, addr01, addr02, zip01, zip02"; +$where = "customer_id = ?"; +$objQuery = new SC_Query(); +$arrCustomerAddr = $objQuery->select($col, "dtb_customer", $where, array($_SESSION['customer']['customer_id'])); +// Ê̤ΤªÆϤ±Àè½»½ê¤Î¼èÆÀ +$col = "other_deliv_id, name01, name02, pref, addr01, addr02, zip01, zip02"; +$objQuery->setorder("other_deliv_id DESC"); +$objOtherAddr = $objQuery->select($col, "dtb_other_deliv", $where, array($_SESSION['customer']['customer_id'])); +$objPage->arrAddr = $arrCustomerAddr; +$cnt = 1; +foreach($objOtherAddr as $val) { + $objPage->arrAddr[$cnt] = $val; + $cnt++; +} + +// ÆþÎÏÃͤμèÆÀ +$objPage->arrForm = $objFormParam->getFormParamList(); +$objPage->arrErr = $arrErr; +$objView->assignobj($objPage); +$objView->display(SITE_FRAME); +//-------------------------------------------------------------------------------------------------------------------------- +/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ +function lfInitParam() { + global $objFormParam; + $objFormParam->addParam("¤ªÌ¾Á°1", "deliv_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¤ªÌ¾Á°2", "deliv_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê1", "deliv_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Õ¥ê¥¬¥Ê2", "deliv_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK")); + $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); + $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK")); +} + +function lfInitLoginFormParam() { + global $objLoginFormParam; + $objLoginFormParam->addParam("µ­²±¤¹¤ë", "login_memory", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK")); + $objLoginFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "login_email", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $objLoginFormParam->addParam("¥Ñ¥¹¥ï¡¼¥É", "login_pass", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); +} + +/* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */ +function lfRegistNewAddrData($uniqid, $objCustomer) { + global $objFormParam; + $arrRet = $objFormParam->getHashArray(); + $sqlval = $objFormParam->getDbArray(); + // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® + $sqlval['deliv_check'] = '1'; + $sqlval['order_temp_id'] = $uniqid; + $sqlval['update_date'] = 'Now()'; + $sqlval['customer_id'] = $objCustomer->getValue('customer_id'); + $sqlval['order_birth'] = $objCustomer->getValue('birth'); + + sfRegistTempOrder($uniqid, $sqlval); +} + +/* ²ñ°÷¾ðÊó¤Î½»½ê¤ò°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤Ø */ +function lfRegistDelivData($uniqid, $objCustomer) { + // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® + $sqlval['order_temp_id'] = $uniqid; + $sqlval['update_date'] = 'Now()'; + $sqlval['customer_id'] = $objCustomer->getValue('customer_id'); + $sqlval['deliv_check'] = '1'; + $sqlval['deliv_name01'] = $objCustomer->getValue('name01'); + $sqlval['deliv_name02'] = $objCustomer->getValue('name02'); + $sqlval['deliv_kana01'] = $objCustomer->getValue('kana01'); + $sqlval['deliv_kana02'] = $objCustomer->getValue('kana02'); + $sqlval['deliv_zip01'] = $objCustomer->getValue('zip01'); + $sqlval['deliv_zip02'] = $objCustomer->getValue('zip02'); + $sqlval['deliv_pref'] = $objCustomer->getValue('pref'); + $sqlval['deliv_addr01'] = $objCustomer->getValue('addr01'); + $sqlval['deliv_addr02'] = $objCustomer->getValue('addr02'); + $sqlval['deliv_tel01'] = $objCustomer->getValue('tel01'); + $sqlval['deliv_tel02'] = $objCustomer->getValue('tel02'); + $sqlval['deliv_tel03'] = $objCustomer->getValue('tel03'); + + $sqlval['deliv_fax01'] = $objCustomer->getValue('fax01'); + $sqlval['deliv_fax02'] = $objCustomer->getValue('fax02'); + $sqlval['deliv_fax03'] = $objCustomer->getValue('fax03'); + + sfRegistTempOrder($uniqid, $sqlval); +} + +/* Ê̤ΤªÆϤ±Àè½»½ê¤ò°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤Ø */ +function lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id) { + // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ® + $sqlval['order_temp_id'] = $uniqid; + $sqlval['update_date'] = 'Now()'; + $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); +} + +/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */ +function lfCheckError() { + global $objFormParam; + // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£ + $arrRet = $objFormParam->getHashArray(); + $objErr = new SC_CheckError($arrRet); + $objErr->arrErr = $objFormParam->checkError(); + // Ê£¿ô¹àÌÜ¥Á¥§¥Ã¥¯ + if ($_POST['mode'] == 'login'){ + $objErr->doFunc(array("¥á¡¼¥ë¥¢¥É¥ì¥¹", "login_email", STEXT_LEN), array("EXIST_CHECK")); + $objErr->doFunc(array("¥Ñ¥¹¥ï¡¼¥É", "login_pass", STEXT_LEN), array("EXIST_CHECK")); + } + $objErr->doFunc(array("TEL", "deliv_tel01", "deliv_tel02", "deliv_tel03", TEL_ITEM_LEN), array("TEL_CHECK")); + return $objErr->arrErr; +} +?> Index: /branches/dev/html/mobile/nonmember/complete.php =================================================================== --- /branches/dev/html/mobile/nonmember/complete.php (revision 12263) +++ /branches/dev/html/mobile/nonmember/complete.php (revision 12263) @@ -0,0 +1,504 @@ +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(); + + // ´°Î»¥á¡¼¥ëÁ÷¿® + if($order_id != "") { + sfSendOrderMail($order_id, '1'); + } + + //¤½¤Î¾¾ðÊó¤Î¼èÆÀ + $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/confirm.php =================================================================== --- /branches/dev/html/mobile/nonmember/confirm.php (revision 12263) +++ /branches/dev/html/mobile/nonmember/confirm.php (revision 12263) @@ -0,0 +1,122 @@ +tpl_mainpage = 'shopping/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)); + 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/deliv_addr.php =================================================================== --- /branches/dev/html/mobile/nonmember/deliv_addr.php (revision 12263) +++ /branches/dev/html/mobile/nonmember/deliv_addr.php (revision 12263) @@ -0,0 +1,308 @@ +tpl_mainpage = 'shopping/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(); + +//¥í¥°¥¤¥óȽÄê +if (!$objCustomer->isLoginSuccess()){ + sfDispSiteError(CUSTOMER_ERROR, "", false, "", true); +} + +$objPage->arrForm = $_POST; +$objPage->arrPref = $arrPref; +//-- ¥Ç¡¼¥¿ÀßÄê +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); + +//Ê̤ΤªÆϤ±Àè£Ä£ÂÅÐÏ¿ÍÑ¥«¥é¥àÇÛÎó +$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" ), + ); + +// Ìá¤ë¥Ü¥¿¥óÍѽèÍý +if (!empty($_POST["return"])) { + switch ($_POST["mode"]) { + case 'complete': + $_POST["mode"] = "set2"; + break; + case 'set2': + $_POST["mode"] = "set1"; + break; + default: + header("Location: " . gfAddSessionId('deliv.php')); + exit; + } +} + +switch ($_POST['mode']){ + case 'set1': + $objPage->arrErr = lfErrorCheck1($objPage->arrForm); + if (count($objPage->arrErr) == 0 && empty($_POST["return"])) { + $objPage->tpl_mainpage = 'shopping/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 = 'shopping/set2.tpl'; + } else { + $objPage->tpl_mainpage = 'shopping/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); + + // ÅÐÏ¿ºÑ¤ß¤ÎÊ̤ΤªÆϤ±Àè¤ò¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤Ë½ñ¤­¹þ¤à + lfRegistOtherDelivData($uniqid, $objCustomer, $other_deliv_id); + + // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + // ¤ª»Ùʧ¤¤ÊýË¡ÁªÂò¥Ú¡¼¥¸¤Ø°ÜÆ° + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_PAYMENT)); + 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 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) { + global $objConn; + global $objCustomer; + + 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 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 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'] = $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/payment.php =================================================================== --- /branches/dev/html/mobile/nonmember/payment.php (revision 12263) +++ /branches/dev/html/mobile/nonmember/payment.php (revision 12263) @@ -0,0 +1,371 @@ +tpl_css = '/css/layout/shopping/pay.css'; + $this->tpl_mainpage = 'shopping/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)); + exit; + } +} + +switch($_POST['mode']) { +// »Ùʧ¤¤ÊýË¡»ØÄê ¢ª ÇÛãÆü»þ»ØÄê +case 'deliv_date': + // ÆþÎÏÃͤÎÊÑ´¹ + $objFormParam->convParam(); + $objPage->arrErr = lfCheckError($objPage->arrData); + if (!isset($objPage->arrErr['payment_id'])) { + // »Ùʧ¤¤ÊýË¡¤ÎÆþÎÏ¥¨¥é¡¼¤Ê¤· + $objPage->tpl_mainpage = 'shopping/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)); + exit; + }else{ + // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ + $uniqid = $objSiteSess->getUniqId(); + // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ + lfSetOrderTempData($uniqid); + if (!isset($objPage->arrErr['payment_id'])) { + // »Ùʧ¤¤ÊýË¡¤ÎÆþÎÏ¥¨¥é¡¼¤Ê¤· + $objPage->tpl_mainpage = 'shopping/deliv_date.tpl'; + $objPage->tpl_title = "ÇÛãÆü»þ»ØÄê"; + } + } + break; +// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë +case 'return': + // Èó²ñ°÷¤Î¾ì¹ç + // Àµ¾ï¤Ê¿ä°Ü¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯ + $objSiteSess->setRegistFlag(); + header("Location: " . gfAddSessionId(MOBILE_URL_SHOP_TOP)); + 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; +} + + +?>