source: branches/dev/html/admin/order/edit.php @ 13708

Revision 13708, 12.3 KB checked in by matsumoto, 19 years ago (diff)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9class LC_Page {
10    function LC_Page() {
11        $this->tpl_mainpage = 'order/edit.tpl';
12        $this->tpl_subnavi = 'order/subnavi.tpl';
13        $this->tpl_mainno = 'order';       
14        $this->tpl_subno = 'index';
15        $this->tpl_subtitle = '¼õÃí´ÉÍý';
16        global $arrPref;
17        $this->arrPref = $arrPref;
18        global $arrORDERSTATUS;
19        $this->arrORDERSTATUS = $arrORDERSTATUS;
20    }
21}
22
23$conn = new SC_DBConn();
24$objPage = new LC_Page();
25$objView = new SC_AdminView();
26$objSess = new SC_Session();
27$objSiteInfo = new SC_SiteInfo();
28$arrInfo = $objSiteInfo->data;
29
30// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
31$objFormParam = new SC_FormParam();
32
33// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
34lfInitParam();
35
36// ǧ¾Ú²ÄÈݤÎȽÄê
37sfIsSuccess($objSess);
38
39// ¸¡º÷¥Ñ¥é¥á¡¼¥¿¤Î°ú¤­·Ñ¤®
40foreach ($_POST as $key => $val) {
41    if (ereg("^search_", $key)) {
42        $objPage->arrSearchHidden[$key] = $val;
43    }
44}
45
46// ɽ¼¨¥â¡¼¥ÉȽÄê
47if(sfIsInt($_GET['order_id'])) {
48    $objPage->disp_mode = true;
49    $order_id = $_GET['order_id'];
50} else {
51    $order_id = $_POST['order_id'];
52}
53$objPage->tpl_order_id = $order_id;
54
55// DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
56lfGetOrderData($order_id);
57
58switch($_POST['mode']) {
59case 'pre_edit':
60    $str = "¤¢¤¤¤¦";
61    print_r($str);
62    break;
63case 'order_id':
64    break;
65case 'edit':
66    // POST¾ðÊó¤Ç¾å½ñ¤­
67    $objFormParam->setParam($_POST);
68   
69    // ÆþÎÏÃͤÎÊÑ´¹
70    $objFormParam->convParam();
71    $objPage->arrErr = lfCheckError($arrRet);
72    if(count($objPage->arrErr) == 0) {
73        $objPage->arrErr = lfCheek($arrInfo);
74        if(count($objPage->arrErr) == 0) {
75            lfRegistData($_POST['order_id']);
76            // DB¤«¤é¼õÃí¾ðÊó¤òºÆÆɹþ
77            lfGetOrderData($order_id);
78            $objPage->tpl_onload = "window.alert('¼õÃíÍúÎò¤òÊÔ½¸¤·¤Þ¤·¤¿¡£');";
79        }
80    }
81    break;
82// ºÆ·×»»
83case 'cheek':
84    // POST¾ðÊó¤Ç¾å½ñ¤­
85    $objFormParam->setParam($_POST);
86    // ÆþÎÏÃͤÎÊÑ´¹
87    $objFormParam->convParam();
88    $objPage->arrErr = lfCheckError($arrRet);
89    if(count($objPage->arrErr) == 0) {
90        $objPage->arrErr = lfCheek($arrInfo);
91    }
92    break;
93default:
94    break;
95}
96
97// »Ùʧ¤¤ÊýË¡¤Î¼èÆÀ
98$objPage->arrPayment = sfGetIDValueList("dtb_payment", "payment_id", "payment_method");
99// ÇÛÁ÷»þ´Ö¤Î¼èÆÀ
100$arrRet = sfGetDelivTime($objFormParam->getValue('payment_id'));
101$objPage->arrDelivTime = sfArrKeyValue($arrRet, 'time_id', 'deliv_time');
102
103$objPage->arrForm = $objFormParam->getFormParamList();
104
105$objPage->arrInfo = $arrInfo;
106
107$objView->assignobj($objPage);
108// ɽ¼¨¥â¡¼¥ÉȽÄê
109if(!$objPage->disp_mode) {
110    $objView->display(MAIN_FRAME);
111} else {
112    $objView->display('order/disp.tpl');
113}
114//-----------------------------------------------------------------------------------------------------------------------------------
115/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
116function lfInitParam() {
117    global $objFormParam;
118    // ÇÛÁ÷Àè¾ðÊó
119    $objFormParam->addParam("¤ªÌ¾Á°1", "deliv_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
120    $objFormParam->addParam("¤ªÌ¾Á°2", "deliv_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
121    $objFormParam->addParam("¥Õ¥ê¥¬¥Ê1", "deliv_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
122    $objFormParam->addParam("¥Õ¥ê¥¬¥Ê2", "deliv_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
123    $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
124    $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
125    $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
126    $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
127    $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
128    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
129    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
130    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
131    // ¼õÃí¾¦ÉʾðÊó
132    $objFormParam->addParam("ÃÍ°ú¤­", "discount", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
133    $objFormParam->addParam("Á÷ÎÁ", "deliv_fee", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
134    $objFormParam->addParam("¼ê¿ôÎÁ", "charge", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
135    $objFormParam->addParam("ÍøÍѥݥ¤¥ó¥È", "use_point", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
136    $objFormParam->addParam("¤ª»Ùʧ¤¤ÊýË¡", "payment_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
137    $objFormParam->addParam("ÇÛÁ÷»þ´ÖID", "deliv_time_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
138    $objFormParam->addParam("Âбþ¾õ¶·", "status", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
139    $objFormParam->addParam("ÇÛãÆü", "deliv_date", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
140    $objFormParam->addParam("¤ª»ÙʧÊýˡ̾¾Î", "payment_method");
141    $objFormParam->addParam("ÇÛÁ÷»þ´Ö", "deliv_time");
142   
143    // ¼õÃí¾ÜºÙ¾ðÊó
144    $objFormParam->addParam("ñ²Á", "price", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
145    $objFormParam->addParam("¸Ä¿ô", "quantity", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
146    $objFormParam->addParam("¾¦ÉÊID", "product_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
147    $objFormParam->addParam("¥Ý¥¤¥ó¥ÈÉÕͿΨ", "point_rate");
148    $objFormParam->addParam("¾¦ÉÊ¥³¡¼¥É", "product_code");
149    $objFormParam->addParam("¾¦ÉÊ̾", "product_name");
150    $objFormParam->addParam("µ¬³Ê1", "classcategory_id1");
151    $objFormParam->addParam("µ¬³Ê2", "classcategory_id2");
152    $objFormParam->addParam("µ¬³Ê̾1", "classcategory_name1");
153    $objFormParam->addParam("µ¬³Ê̾2", "classcategory_name2");
154    $objFormParam->addParam("¥á¥â", "note", MTEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
155    // DBÆɹþÍÑ
156    $objFormParam->addParam("¾®·×", "subtotal");
157    $objFormParam->addParam("¹ç·×", "total");
158    $objFormParam->addParam("»Ùʧ¤¤¹ç·×", "payment_total");
159    $objFormParam->addParam("²Ã»»¥Ý¥¤¥ó¥È", "add_point");
160    $objFormParam->addParam("¤ªÃÂÀ¸Æü¥Ý¥¤¥ó¥È", "birth_point");
161    $objFormParam->addParam("¾ÃÈñÀǹç·×", "tax");
162    $objFormParam->addParam("ºÇ½ªÊÝ»ý¥Ý¥¤¥ó¥È", "total_point");
163    $objFormParam->addParam("¸ÜµÒID", "customer_id");
164    $objFormParam->addParam("¸½ºß¤Î¥Ý¥¤¥ó¥È", "point");
165}
166
167function lfGetOrderData($order_id) {
168    global $objFormParam;
169    global $objPage;
170    if(sfIsInt($order_id)) {
171        // DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
172        $objQuery = new SC_Query();
173        $where = "order_id = ?";
174        $arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id));
175        $objFormParam->setParam($arrRet[0]);
176        list($point, $total_point) = sfGetCustomerPoint($order_id, $arrRet[0]['use_point'], $arrRet[0]['add_point']);
177        $objFormParam->setValue('total_point', $total_point);
178        $objFormParam->setValue('point', $point);
179        $objPage->arrDisp = $arrRet[0];
180        // ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
181        $arrRet = lfGetOrderDetail($order_id);
182        $arrRet = sfSwapArray($arrRet);
183        $objPage->arrDisp = array_merge($objPage->arrDisp, $arrRet);
184        $objFormParam->setParam($arrRet);
185       
186        // ¤½¤Î¾»Ùʧ¤¤¾ðÊó¤òɽ¼¨
187        if($objPage->arrDisp["memo02"] != "") $objPage->arrDisp["payment_info"] = unserialize($objPage->arrDisp["memo02"]);
188        if($objPage->arrDisp["memo01"] == PAYMENT_CREDIT_ID){
189            $objPage->arrDisp["payment_type"] = "¥¯¥ì¥¸¥Ã¥È·èºÑ";
190        }elseif($objPage->arrDisp["memo01"] == PAYMENT_CONVENIENCE_ID){
191            $objPage->arrDisp["payment_type"] = "¥³¥ó¥Ó¥Ë·èºÑ";
192        }else{
193            $objPage->arrDisp["payment_type"] = "¤ª»Ùʧ¤¤";
194        }
195    }
196}
197
198// ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
199function lfGetOrderDetail($order_id) {
200    $objQuery = new SC_Query();
201    $col = "product_id, classcategory_id1, classcategory_id2, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
202    $where = "order_id = ?";
203    $objQuery->setorder("classcategory_id1, classcategory_id2");
204    $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id));
205    return $arrRet;
206}
207
208/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
209function lfCheckError() {
210    global $objFormParam;
211    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
212    $arrRet =  $objFormParam->getHashArray();
213    $objErr = new SC_CheckError($arrRet);
214    $objErr->arrErr = $objFormParam->checkError();
215   
216    return $objErr->arrErr;
217}
218
219/* ·×»»½èÍý */
220function lfCheek($arrInfo) {
221    global $objFormParam;
222       
223    $arrVal = $objFormParam->getHashArray();
224           
225    // ¾¦ÉʤμïÎà¿ô
226    $max = count($arrVal['quantity']);
227    $subtotal = 0;
228    $totalpoint = 0;
229    $totaltax = 0;
230    for($i = 0; $i < $max; $i++) {
231        // ¾®·×¤Î·×»»
232        $subtotal += sfPreTax($arrVal['price'][$i], $arrInfo['tax'], $arrInfo['tax_rule']) * $arrVal['quantity'][$i];
233        // ¾®·×¤Î·×»»
234        $totaltax += sfTax($arrVal['price'][$i], $arrInfo['tax'], $arrInfo['tax_rule']) * $arrVal['quantity'][$i];
235        // ²Ã»»¥Ý¥¤¥ó¥È¤Î·×»»
236        $totalpoint += sfPrePoint($arrVal['price'][$i], $arrVal['point_rate'][$i]) * $arrVal['quantity'][$i];
237    }
238   
239    // ¾ÃÈñÀÇ
240    $arrVal['tax'] = $totaltax;
241    // ¾®·×
242    $arrVal['subtotal'] = $subtotal;
243    // ¹ç·×
244    $arrVal['total'] = $subtotal - $arrVal['discount'] + $arrVal['deliv_fee'] + $arrVal['charge'];
245    // ¤ª»Ùʧ¤¤¹ç·×
246    $arrVal['payment_total'] = $arrVal['total'] - ($arrVal['use_point'] * POINT_VALUE);
247   
248    // ²Ã»»¥Ý¥¤¥ó¥È
249    $arrVal['add_point'] = sfGetAddPoint($totalpoint, $arrVal['use_point'], $arrInfo);
250       
251    list($arrVal['point'], $arrVal['total_point']) = sfGetCustomerPoint($_POST['order_id'], $arrVal['use_point'], $arrVal['add_point']);
252       
253    if($arrVal['total'] < 0) {
254        $arrErr['total'] = '¹ç·×³Û¤¬¥Þ¥¤¥Ê¥¹É½¼¨¤Ë¤Ê¤é¤Ê¤¤¤è¤¦¤ËÄ´À°¤·¤Æ²¼¤µ¤¤¡£<br />';
255    }
256   
257    if($arrVal['payment_total'] < 0) {
258        $arrErr['payment_total'] = '¤ª»Ùʧ¤¤¹ç·×³Û¤¬¥Þ¥¤¥Ê¥¹É½¼¨¤Ë¤Ê¤é¤Ê¤¤¤è¤¦¤ËÄ´À°¤·¤Æ²¼¤µ¤¤¡£<br />';
259    }
260
261    if($arrVal['total_point'] < 0) {
262        $arrErr['total_point'] = 'ºÇ½ªÊÝ»ý¥Ý¥¤¥ó¥È¤¬¥Þ¥¤¥Ê¥¹É½¼¨¤Ë¤Ê¤é¤Ê¤¤¤è¤¦¤ËÄ´À°¤·¤Æ²¼¤µ¤¤¡£<br />';
263    }
264
265    $objFormParam->setParam($arrVal);
266    return $arrErr;
267}
268
269/* DBÅÐÏ¿½èÍý */
270function lfRegistData($order_id) {
271    global $objFormParam;
272    $objQuery = new SC_Query();
273   
274    $objQuery->begin();
275
276    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
277    $arrRet =  $objFormParam->getHashArray();
278   
279    foreach($arrRet as $key => $val) {
280        // ÇÛÎó¤ÏÅÐÏ¿¤·¤Ê¤¤
281        if(!is_array($val)) {
282            $sqlval[$key] = $val;
283        }
284    }
285   
286    unset($sqlval['total_point']);
287    unset($sqlval['point']);
288           
289    $where = "order_id = ?";
290   
291    // ¼õÃí¥¹¥Æ¡¼¥¿¥¹¤ÎȽÄê
292    if ($sqlval['status'] == ODERSTATUS_COMMIT) {
293        // ¼õÃí¥Æ¡¼¥Ö¥ë¤ÎȯÁ÷ºÑ¤ßÆü¤ò¹¹¿·¤¹¤ë
294        $addcol['commit_date'] = "Now()";
295    }
296   
297    // ¼õÃí¥Æ¡¼¥Ö¥ë¤Î¹¹¿·
298    $objQuery->update("dtb_order", $sqlval, $where, array($order_id), $addcol);
299
300    $sql = "";
301    $sql .= " UPDATE";
302    $sql .= "     dtb_order";
303    $sql .= " SET";
304    $sql .= "     payment_method = (SELECT payment_method FROM dtb_payment WHERE payment_id = ?)";
305    $sql .= "     ,deliv_time = (SELECT deliv_time FROM dtb_delivtime WHERE time_id = ? AND deliv_id = (SELECT deliv_id FROM dtb_payment WHERE payment_id = ? ))";
306    $sql .= " WHERE order_id = ?";
307   
308    if ($arrRet['deliv_time_id'] == "") {
309        $deliv_time_id = 0;
310    }else{
311        $deliv_time_id = $arrRet['deliv_time_id'];
312    }
313    $arrUpdData = array($arrRet['payment_id'], $deliv_time_id, $arrRet['payment_id'], $order_id);
314    $objQuery->query($sql, $arrUpdData);
315
316    // ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¹¹¿·
317    $arrDetail = $objFormParam->getSwapArray(array("product_id", "product_code", "product_name", "price", "quantity", "point_rate", "classcategory_id1", "classcategory_id2", "classcategory_name1", "classcategory_name2"));
318    $objQuery->delete("dtb_order_detail", $where, array($order_id));
319   
320    $max = count($arrDetail);
321    for($i = 0; $i < $max; $i++) {
322        $sqlval = array();
323        $sqlval['order_id'] = $order_id;
324        $sqlval['product_id']  = $arrDetail[$i]['product_id'];
325        $sqlval['product_code']  = $arrDetail[$i]['product_code'];
326        $sqlval['product_name']  = $arrDetail[$i]['product_name'];
327        $sqlval['price']  = $arrDetail[$i]['price'];
328        $sqlval['quantity']  = $arrDetail[$i]['quantity'];
329        $sqlval['point_rate']  = $arrDetail[$i]['point_rate'];
330        $sqlval['classcategory_id1'] = $arrDetail[$i]['classcategory_id1'];
331        $sqlval['classcategory_id2'] = $arrDetail[$i]['classcategory_id2'];
332        $sqlval['classcategory_name1'] = $arrDetail[$i]['classcategory_name1'];
333        $sqlval['classcategory_name2'] = $arrDetail[$i]['classcategory_name2'];     
334        $objQuery->insert("dtb_order_detail", $sqlval);
335    }
336    $objQuery->commit();
337}
338?>
Note: See TracBrowser for help on using the repository browser.