source: branches/comu/html/shopping/payment.php @ 2

Revision 2, 9.6 KB checked in by root, 17 years ago (diff)

new import
Line 
1<?php
2/*
3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7
8require_once("../require.php");
9
10class LC_Page {
11    var $arrSession;
12    var $tpl_mode;
13    function LC_Page() {
14        $this->tpl_css = URL_DIR.'css/layout/shopping/pay.css';
15        $this->tpl_mainpage = 'shopping/payment.tpl';
16        $this->tpl_onload = 'fnCheckInputPoint();';
17        $this->tpl_title = "¤ª»ÙʧÊýË¡¡¦¤ªÆϤ±»þ´ÖÅù¤Î»ØÄê";
18        /*
19         session_start»þ¤Îno-cache¥Ø¥Ã¥À¡¼¤òÍÞÀ©¤¹¤ë¤³¤È¤Ç
20         ¡ÖÌá¤ë¡×¥Ü¥¿¥ó»ÈÍÑ»þ¤ÎÍ­¸ú´ü¸ÂÀÚ¤ìɽ¼¨¤òÍÞÀ©¤¹¤ë¡£
21         private-no-expire:¥¯¥é¥¤¥¢¥ó¥È¤Î¥­¥ã¥Ã¥·¥å¤òµö²Ä¤¹¤ë¡£
22        */
23        session_cache_limiter('private-no-expire');     
24    }
25}
26
27$objPage = new LC_Page();
28$objView = new SC_SiteView();
29$objSiteSess = new SC_SiteSession();
30$objCartSess = new SC_CartSession();
31$objCampaignSess = new SC_CampaignSession();
32$objCustomer = new SC_Customer();
33$objSiteInfo = $objView->objSiteInfo;
34$arrInfo = $objSiteInfo->data;
35
36// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
37$objFormParam = new SC_FormParam();
38// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
39lfInitParam();
40// POSTÃͤμèÆÀ
41$objFormParam->setParam($_POST);
42
43// ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ¤È¹ØÆþ¾õÂÖ¤ÎÀµÅöÀ­¤ò¥Á¥§¥Ã¥¯
44$uniqid = sfCheckNormalAccess($objSiteSess, $objCartSess);
45// ¥æ¥Ë¡¼¥¯ID¤ò°ú¤­·Ñ¤°
46$objPage->tpl_uniqid = $uniqid;
47
48// ²ñ°÷¥í¥°¥¤¥ó¥Á¥§¥Ã¥¯
49if($objCustomer->isLoginSuccess()) {
50    $objPage->tpl_login = '1';
51    $objPage->tpl_user_point = $objCustomer->getValue('point');
52}
53
54// ¶â³Û¤Î¼èÆÀ (¹ØÆþÅÓÃæ¤ÇÇä¤êÀڤ줿¾ì¹ç¤Ë¤Ï¤³¤Î´Ø¿ôÆâ¤Ë¤Æ¤½¤Î¾¦ÉʤθĿô¤¬£°¤Ë¤Ê¤ë)
55$objPage = sfTotalCart($objPage, $objCartSess, $arrInfo);
56$objPage->arrData = sfTotalConfirm($arrData, $objPage, $objCartSess, $arrInfo);
57
58// ¥«¡¼ÅÔÆâ¤Î¾¦ÉʤÎÇä¤êÀÚ¤ì¥Á¥§¥Ã¥¯
59$objCartSess->chkSoldOut($objCartSess->getCartList());
60
61switch($_POST['mode']) {
62case 'confirm':
63    // ÆþÎÏÃͤÎÊÑ´¹
64    $objFormParam->convParam();
65    $objPage->arrErr = lfCheckError($objPage->arrData );
66    // ÆþÎÏ¥¨¥é¡¼¤Ê¤·
67    if(count($objPage->arrErr) == 0) {
68        // DB¤Ø¤Î¥Ç¡¼¥¿ÅÐÏ¿
69        lfRegistData($uniqid);
70        // Àµ¾ï¤ËÅÐÏ¿¤µ¤ì¤¿¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯
71        $objSiteSess->setRegistFlag();
72        // ³Îǧ¥Ú¡¼¥¸¤Ø°ÜÆ°
73        header("Location: " . URL_SHOP_CONFIRM);
74        exit;
75    }else{
76        // ¥æ¡¼¥¶¥æ¥Ë¡¼¥¯ID¤Î¼èÆÀ
77        $uniqid = $objSiteSess->getUniqId();
78        // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ
79        lfSetOrderTempData($uniqid);
80    }
81    break;
82// Á°¤Î¥Ú¡¼¥¸¤ËÌá¤ë
83case 'return':
84    // Èó²ñ°÷¤Î¾ì¹ç
85    // Àµ¾ï¤Ê¿ä°Ü¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤·¤Æ¤ª¤¯
86    $objSiteSess->setRegistFlag();
87    header("Location: " . URL_SHOP_TOP);
88    exit;
89    break;
90// »Ùʧ¤¤ÊýË¡¤¬Êѹ¹¤µ¤ì¤¿¾ì¹ç
91case 'payment':
92    // ¤³¤³¤Îbreak¤Ï¡¢°ÕÌ£¤¬¤¢¤ë¤Î¤Ç³°¤µ¤Ê¤¤¤Ç²¼¤µ¤¤¡£
93    break;
94default:
95    // ¼õÃí°ì»þ¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ
96    lfSetOrderTempData($uniqid);
97    break;
98}
99
100// ŹÊÞ¾ðÊó¤Î¼èÆÀ
101$arrInfo = $objSiteInfo->data;
102// ¹ØÆþ¶â³Û¤Î¼èÆÀÆÀ
103$total_pretax = $objCartSess->getAllProductsTotal($arrInfo);
104// »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ
105$objPage->arrPayment = lfGetPayment($total_pretax);
106// ÇÛÁ÷»þ´Ö¤Î¼èÆÀ
107$arrRet = sfGetDelivTime($objFormParam->getValue('payment_id'));
108$objPage->arrDelivTime = sfArrKeyValue($arrRet, 'time_id', 'deliv_time');
109$objPage->objCustomer = $objCustomer;
110//¡¡ÇÛÁ÷Æü°ìÍ÷¤Î¼èÆÀ
111$objPage->arrDelivDate = lfGetDelivDate();
112
113$objPage->arrForm = $objFormParam->getFormParamList();
114
115$objView->assignobj($objPage);
116// ¥Õ¥ì¡¼¥à¤òÁªÂò(¥­¥ã¥ó¥Ú¡¼¥ó¥Ú¡¼¥¸¤«¤éÁ«°Ü¤Ê¤éÊѹ¹)
117$objCampaignSess->pageView($objView);
118//--------------------------------------------------------------------------------------------------------------------------
119/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
120function lfInitParam() {
121    global $objFormParam;
122    $objFormParam->addParam("¤ª»Ùʧ¤¤ÊýË¡", "payment_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
123    $objFormParam->addParam("¥Ý¥¤¥ó¥È", "use_point", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK", "ZERO_START"));
124    $objFormParam->addParam("ÇÛã»þ´Ö", "deliv_time_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
125    $objFormParam->addParam("¤´¼ÁÌä", "message", LTEXT_LEN, "KVa", array("SPTAB_CHECK", "MAX_LENGTH_CHECK"));
126    $objFormParam->addParam("¥Ý¥¤¥ó¥È¤ò»ÈÍѤ¹¤ë", "point_check", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"), '2');
127    $objFormParam->addParam("ÇÛãÆü", "deliv_date", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
128}
129
130function lfGetPayment($total_pretax) {
131    $objQuery = new SC_Query();
132    $objQuery->setorder("rank DESC");
133    //ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤»ÙʧÊýË¡¤ò¼èÆÀ
134    $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) ");
135    //ÍøÍѾò·ï¤«¤é»Ùʧ²ÄǽÊýË¡¤òȽÄê
136    foreach($arrRet as $data) {
137        //²¼¸Â¤È¾å¸Â¤¬ÀßÄꤵ¤ì¤Æ¤¤¤ë
138        if($data['rule'] > 0 && $data['upper_rule'] > 0) {
139            if($data['rule'] <= $total_pretax && $data['upper_rule'] >= $total_pretax) {
140                $arrPayment[] = $data;
141            }
142        //²¼¸Â¤Î¤ßÀßÄꤵ¤ì¤Æ¤¤¤ë
143        } elseif($data['rule'] > 0) {   
144            if($data['rule'] <= $total_pretax) {
145                $arrPayment[] = $data;
146            }
147        //¾å¸Â¤Î¤ßÀßÄꤵ¤ì¤Æ¤¤¤ë
148        } elseif($data['upper_rule'] > 0) {
149            if($data['upper_rule'] >= $total_pretax) {
150                $arrPayment[] = $data;
151            }
152        //ÀßÄê¤Ê¤·
153        } else {
154            $arrPayment[] = $data;
155        }   
156    }
157    return $arrPayment;
158}
159
160/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
161function lfCheckError($arrData) {
162    global $objFormParam;
163    global $objCustomer;
164    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
165    $arrRet =  $objFormParam->getHashArray();
166    $objErr = new SC_CheckError($arrRet);
167    $objErr->arrErr = $objFormParam->checkError();
168   
169    if($_POST['point_check'] == '1') {
170        $objErr->doFunc(array("¥Ý¥¤¥ó¥È¤ò»ÈÍѤ¹¤ë", "point_check"), array("EXIST_CHECK"));
171        $objErr->doFunc(array("¥Ý¥¤¥ó¥È", "use_point"), array("EXIST_CHECK"));
172        $max_point = $objCustomer->getValue('point');
173        if($max_point == "") {
174            $max_point = 0;
175        }
176        if($arrRet['use_point'] > $max_point) {
177            $objErr->arrErr['use_point'] = "¢¨ ¤´ÍøÍѥݥ¤¥ó¥È¤¬½ê»ý¥Ý¥¤¥ó¥È¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£<br />";
178        }
179        if(($arrRet['use_point'] * POINT_VALUE) > $arrData['subtotal']) {
180            $objErr->arrErr['use_point'] = "¢¨ ¤´ÍøÍѥݥ¤¥ó¥È¤¬¤´¹ØÆþ¶â³Û¤òĶ¤¨¤Æ¤¤¤Þ¤¹¡£<br />";
181        }
182    }
183    return $objErr->arrErr;
184}
185
186/* »Ùʧ¤¤Êýˡʸ»úÎó¤Î¼èÆÀ */
187function lfGetPaymentInfo($payment_id) {
188    $objQuery = new SC_Query();
189    $where = "payment_id = ?";
190    $arrRet = $objQuery->select("payment_method, charge", "dtb_payment", $where, array($payment_id));
191    return (array($arrRet[0]['payment_method'], $arrRet[0]['charge']));
192}
193
194/* ÇÛÁ÷»þ´Öʸ»úÎó¤Î¼èÆÀ */
195function lfGetDelivTimeInfo($time_id) {
196    $objQuery = new SC_Query();
197    $where = "time_id = ?";
198    $arrRet = $objQuery->select("deliv_id, deliv_time", "dtb_delivtime", $where, array($time_id));
199    return (array($arrRet[0]['deliv_id'], $arrRet[0]['deliv_time']));
200}
201
202/* DB¤Ø¥Ç¡¼¥¿¤ÎÅÐÏ¿ */
203function lfRegistData($uniqid) {
204    global $objFormParam;
205    $arrRet = $objFormParam->getHashArray();
206    $sqlval = $objFormParam->getDbArray();
207    // ÅÐÏ¿¥Ç¡¼¥¿¤ÎºîÀ®
208    $sqlval['order_temp_id'] = $uniqid;
209    $sqlval['update_date'] = 'Now()';
210   
211    if($sqlval['payment_id'] != "") {
212        list($sqlval['payment_method'], $sqlval['charge']) = lfGetPaymentInfo($sqlval['payment_id']);
213    } else {
214        $sqlval['payment_id'] = '0';
215        $sqlval['payment_method'] = "";
216    }
217   
218    if($sqlval['deliv_time_id'] != "") {
219        list($sqlval['deliv_id'], $sqlval['deliv_time']) = lfGetDelivTimeInfo($sqlval['deliv_time_id']);
220    } else {
221        $sqlval['deliv_time_id'] = '0';
222        $sqlval['deliv_id'] = '0';
223        $sqlval['deliv_time'] = "";
224    }
225   
226    // »ÈÍѥݥ¤¥ó¥È¤ÎÀßÄê
227    if($sqlval['point_check'] != '1') {
228        $sqlval['use_point'] = 0;
229    }
230   
231    sfRegistTempOrder($uniqid, $sqlval);
232}
233
234/* ÇÛãÆü°ìÍ÷¤ò¼èÆÀ¤¹¤ë */
235function lfGetDelivDate() {
236    $objCartSess = new SC_CartSession();
237    $objQuery = new SC_Query();
238    // ¾¦ÉÊID¤Î¼èÆÀ
239    $max = $objCartSess->getMax();
240    for($i = 1; $i <= $max; $i++) {
241        if($_SESSION[$objCartSess->key][$i]['id'][0] != "") {
242            $arrID['product_id'][$i] = $_SESSION[$objCartSess->key][$i]['id'][0];
243        }
244    }
245    if(count($arrID['product_id']) > 0) {
246        $id = implode(",", $arrID['product_id']);
247        //¾¦Éʤ«¤éȯÁ÷Ìܰ¤μèÆÀ
248        $deliv_date = $objQuery->get("dtb_products", "MAX(deliv_date_id)", "product_id IN (".$id.")");
249        //ȯÁ÷ÌÜ°Â
250        switch($deliv_date) {
251        //¨ÆüȯÁ÷
252        case '1':
253            $start_day = 1;
254            break;
255        //1-2Æü¸å
256        case '2':
257            $start_day = 3;
258            break;
259        //3-4Æü¸å
260        case '3':
261            $start_day = 5;
262            break;
263        //1½µ´Ö°ÊÆâ
264        case '4':
265            $start_day = 8;
266            break;
267        //2½µ´Ö°ÊÆâ
268        case '5':
269            $start_day = 15;
270            break;
271        //3½µ´Ö°ÊÆâ
272        case '6':
273            $start_day = 22;
274            break;
275        //1¥ö·î°ÊÆâ
276        case '7':
277            $start_day = 32;
278            break;
279        //2¥ö·î°Ê¹ß
280        case '8':
281            $start_day = 62;           
282            break;
283        //¤ª¼è¤ê´ó¤»(¾¦ÉÊÆþ²Ù¸å)
284        case '9':
285            $start_day = "";
286            break;
287        default:
288            //¤ªÆϤ±Æü¤¬ÀßÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç
289            $start_day = "";
290            break;
291        }
292        //ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ«¤é¡¢ÇÛãÆü¤ÎÇÛÎó¤ò¼èÆÀ¤¹¤ë
293        $arrDelivDate = lfGetDateArray($start_day, DELIV_DATE_END_MAX);
294    }
295    return $arrDelivDate;
296}
297
298//ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ«¤é¡¢ÇÛãÆü¤ÎÇÛÎó¤ò¼èÆÀ¤¹¤ë
299function lfGetDateArray($start_day, $end_day) {
300    global $arrWDAY;
301    //ÇÛã²ÄǽÆü¤Î¥¹¥¿¡¼¥ÈÃͤ¬¥»¥Ã¥È¤µ¤ì¤Æ¤¤¤ì¤Ð
302    if($start_day >= 1) {
303        $now_time = time();
304        $max_day = $start_day + $end_day;
305        // ½¸·×
306        for ($i = $start_day; $i < $max_day; $i++) {
307            // ´ðËÜ»þ´Ö¤«¤éÆü¿ô¤òÄɲ䷤Ƥ¤¤¯
308            $tmp_time = $now_time + ($i * 24 * 3600);
309            list($y, $m, $d, $w) = split(" ", date("y m d w", $tmp_time)); 
310            $val = sprintf("%02d/%02d/%02d(%s)", $y, $m, $d, $arrWDAY[$w]);
311            $arrDate[$val] = $val;
312        }
313    } else {
314        $arrDate = false;
315    }
316    return $arrDate;
317}
318
319//°ì»þ¼õÃí¥Æ¡¼¥Ö¥ë¤«¤é¤Î¾ðÊó¤ò³ÊǼ¤¹¤ë
320function lfSetOrderTempData($uniqid) {
321    global $objQuery;
322    global $objFormParam;
323   
324    $objQuery = new SC_Query();
325    $col = "payment_id, use_point, deliv_time_id, message, point_check, deliv_date";
326    $from = "dtb_order_temp";
327    $where = "order_temp_id = ?";
328    $arrRet = $objQuery->select($col, $from, $where, array($uniqid));
329    // DBÃͤμèÆÀ
330    $objFormParam->setParam($arrRet[0]);
331    return $objFormParam;
332}
333
334
335?>
Note: See TracBrowser for help on using the repository browser.