source: temp/trunk/html/shopping/payment.php @ 6663

Revision 6663, 9.3 KB checked in by kakinaka, 20 years ago (diff)

* empty log message *

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