source: branches/version-1/html/admin/pdf.d/index.php @ 17235

Revision 17235, 15.1 KB checked in by satou, 16 years ago (diff)

納品書発行機能 by homan (merge r17113)
Line 
1<?php
2/*
3 * Copyright(c) 2000-2008 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7
8/**
9 * ĢɼºîÀ®¥â¥¸¥å¡¼¥ë.
10 */
11
12// ³Æ¼ï¥â¥¸¥å¡¼¥ë¸Æ¤Ó½Ð¤·
13require('japanese.php');
14require_once("../require.php");
15
16class LC_Page {
17    function LC_Page() {
18        global $arrPref;
19        // ¥Ç¥Õ¥©¥ë¥È¤ÎÀßÄê
20        $this->pdf_download = 0;            // PDF¤Î¥À¥¦¥ó¥í¡¼¥É·Á¼°¡Ê0:ɽ¼¨¡¢1:¥À¥¦¥ó¥í¡¼¥É¡Ë
21        $this->tpl_title = "¤ªÇã¾å¤²ÌÀºÙ½ñ";        // ¥¿¥¤¥È¥ë
22        $this->tpl_char = "EUC-JP, UTF-8";      // ʸ»ú¥³¡¼¥É   
23        $this->tpl_pdf = "template_nouhin01.pdf";   // ¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë
24        $this->tpl_dispmode = "real";           // ɽ¼¨¥â¡¼¥É
25        $this->arrPref = $arrPref;
26        $this->width_cell = array(110.3,12,21.7,24.5);
27        $this->arrMessage = array(
28            '¤³¤Î¤¿¤Ó¤Ï¤ªÇã¾å¤²¤¤¤¿¤À¤­¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
29            '²¼µ­¤ÎÆâÍƤˤÆǼÉʤµ¤»¤Æ¤¤¤¿¤À¤­¤Þ¤¹¡£',
30            '¤´³Îǧ¤¤¤¿¤À¤­¤Þ¤¹¤è¤¦¡¢¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£'
31        );
32    }
33}
34
35
36
37// ǧ¾Ú²ÄÈݤÎȽÄê
38$objSess = new SC_Session();
39sfIsSuccess($objSess);
40
41$pdf  = new PDF_Japanese();
42$conn = new SC_DbConn();
43$objPage = new LC_Page();
44$objInfo = new SC_SiteInfo();
45$arrInfo = $objInfo->data;
46// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
47$objFormParam = new SC_FormParam();
48// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
49lfInitParam();
50
51// SJIS¥Õ¥©¥ó¥È
52$pdf->AddSJISFont();
53
54//¥Ú¡¼¥¸Áí¿ô¼èÆÀ
55$pdf->AliasNbPages();
56
57// ¥Þ¡¼¥¸¥óÀßÄê
58$pdf->SetMargins(15, 20);
59
60// PDF¤òÆɤ߹þ¤ó¤Ç¥Ú¡¼¥¸¿ô¤ò¼èÆÀ
61$pageno = $pdf->setSourceFile($objPage->tpl_pdf);
62
63// ¥Ú¡¼¥¸ÈÖ¹æ¤è¤êID¤ò¼èÆÀ
64$tplidx = $pdf->ImportPage(1);
65
66// ¥Ú¡¼¥¸¤òÄɲáʿ·µ¬¡Ë
67$pdf->AddPage();
68
69//ɽ¼¨ÇÜΨ(100%)
70$pdf->SetDisplayMode($objPage->tpl_dispmode);
71
72if(sfIsInt($_POST['order_id'])) {
73    $objPage->disp_mode = true;
74    $order_id = $_POST['order_id'];
75}
76$objPage->tpl_order_id = $order_id;
77
78
79// ¥¿¥¤¥È¥ë¤¬ÀßÄꤵ¤ì¤Æ¤¤¤¿¤éÊѹ¹
80if($_POST['chohyo_title']) {
81    $objPage->tpl_title = $_POST['chohyo_title'];
82}
83
84// ¥À¥¦¥ó¥í¡¼¥ÉÊý¼°
85if($_POST['download']) {
86    $objPage->pdf_download = $_POST['download'];
87}
88
89// ¥á¥Ã¥»¡¼¥¸
90if($_POST['chohyo_msg1']) {
91    $objPage->arrMessage[0] = $_POST['chohyo_msg1'];
92}
93
94if($_POST['chohyo_msg2']) {
95    $objPage->arrMessage[1] = $_POST['chohyo_msg2'];
96}
97
98if($_POST['chohyo_msg3']) {
99    $objPage->arrMessage[2] = $_POST['chohyo_msg3'];
100}
101
102// È÷¹Í
103if ($_POST['chohyo_etc1']) {
104  if($_POST['chohyo_etc1']) {
105    $objPage->arrEtc[0] = $_POST['chohyo_etc1'];
106  }
107
108  if($_POST['chohyo_etc2']) {
109    $objPage->arrEtc[1] = $_POST['chohyo_etc2'];
110  }
111
112  if($_POST['chohyo_etc3']) {
113    $objPage->arrEtc[2] = $_POST['chohyo_etc3'];
114  }
115}
116
117
118// ¥Æ¥ó¥×¥ì¡¼¥ÈÆâÍƤΰÌÃÖ¡¢Éý¤òÄ´À° ¢¨useTemplate¤Ë°ú¿ô¤òÍ¿¤¨¤Ê¤±¤ì¤Ð100%ɽ¼¨¤¬¥Ç¥Õ¥©¥ë¥È
119$pdf->useTemplate($tplidx);
120
121/**
122 * PDF ½ñ¤­¹þ¤ß³«»Ï
123 *
124 * PDF½ñ¹þ¤ß ¢¨$pdf->Text(xºÂɸ, yºÂɸ, ¥Æ¥­¥¹¥È);
125 * ¥Õ¥©¥ó¥È¤Î¥»¥Ã¥È $pdf->SetFont('SJIS', '', 8); ¢¨SJIS(MSPGothic)¤Ç¥Õ¥©¥ó¥È¥µ¥¤¥º8
126 */
127
128// ¥é¥Ù¥ë¾ðÊó
129$label_cell[] = sjis_conv("¾¦ÉÊ̾ / ¾¦ÉÊ¥³¡¼¥É / [ µ¬³Ê ]");
130$label_cell[] = sjis_conv("¿ôÎÌ");
131$label_cell[] = sjis_conv("ñ²Á");
132$label_cell[] = sjis_conv("¶â³Û(Àǹþ)");
133$objPage->label_cell = $label;
134
135// ¥·¥ç¥Ã¥×¾ðÊó
136$pdf->SetFont('SJIS', 'B', 8);
137$pdf->Text(125, 60, sjis_conv($arrInfo['shop_name']));                  //¥·¥ç¥Ã¥×̾
138$pdf->SetFont('SJIS', '', 8);
139$pdf->Text(125, 63, sjis_conv($arrInfo['law_url']));                    //URL
140$pdf->Text(125, 68, sjis_conv($arrInfo['law_company']));                //²ñ¼Ò̾
141$pdf->Text(125, 71, sjis_conv("¢© ".$arrInfo['zip01']." - ".$arrInfo['zip02']));    //͹ÊØÈÖ¹æ
142$pdf->Text(125, 74, sjis_conv($objPage->arrPref[$arrInfo['pref']].$arrInfo['addr01'])); //ÅÔÆ»Éܸ©+½»½ê1
143$pdf->Text(125, 77, sjis_conv($arrInfo['addr02']));                 //½»½ê2
144$pdf->Text(125, 80, sjis_conv("TEL: ".$arrInfo['tel01']."-".$arrInfo['tel02']."-".$arrInfo['tel03']."¡¡"."FAX: ".$arrInfo['fax01']."-".$arrInfo['fax02']."-".$arrInfo['fax03']));   //TEL¡¦FAX
145$pdf->Text(125, 83, sjis_conv("Email: ".$arrInfo['law_email']));            //Email
146
147
148// ¥á¥Ã¥»¡¼¥¸
149$pdf->SetFont('SJIS', '', 8);
150$pdf->Text(27, 70, sjis_conv($objPage->arrMessage[0]));  //¥á¥Ã¥»¡¼¥¸1
151$pdf->Text(27, 74, sjis_conv($objPage->arrMessage[1]));  //¥á¥Ã¥»¡¼¥¸2
152$pdf->Text(27, 78, sjis_conv($objPage->arrMessage[2]));  //¥á¥Ã¥»¡¼¥¸3
153$pdf->Text(158, 288, sjis_conv("ºîÀ®Æü: ".$_POST['year']."ǯ".$_POST['month']."·î".$_POST['day']."Æü"));  //ºîÀ®Æü
154
155
156// DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
157lfGetOrderData($order_id);
158
159// ¹ØÆþ¼Ô¾ðÊó
160$pdf->SetFont('SJIS', '', 10);
161$pdf->Text(23, 43, sjis_conv("¢© ".$objPage->arrDisp['order_zip01']." - ".$objPage->arrDisp['order_zip02']));           //¹ØÆþ¼Ô͹ÊØÈÖ¹æ
162$pdf->Text(27, 47, sjis_conv($objPage->arrPref[$objPage->arrDisp['order_pref']] . $objPage->arrDisp['order_addr01']));  //¹ØÆþ¼ÔÅÔÆ»Éܸ©+½»½ê1
163$pdf->Text(27, 51, sjis_conv($objPage->arrDisp['order_addr02']));                           //¹ØÆþ¼Ô½»½ê2
164$pdf->SetFont('SJIS', '', 11);
165$pdf->Text(27, 59, sjis_conv($objPage->arrDisp['order_name01']."¡¡".$objPage->arrDisp['order_name02']."¡¡ÍÍ"));     //¹ØÆþ¼Ô»á̾
166
167// ¤ªÆϤ±Àè¾ðÊó
168$pdf->SetFont('SJIS', '', 10);
169$pdf->Text(22, 128, sjis_conv("¢© ".$objPage->arrDisp['deliv_zip01']." - ".$objPage->arrDisp['deliv_zip02']));      //¤ªÆϤ±Àè͹ÊØÈÖ¹æ
170$pdf->Text(26, 132, sjis_conv($objPage->arrPref[$objPage->arrDisp['deliv_pref']] . $objPage->arrDisp['deliv_addr01'])); //¤ªÆϤ±ÀèÅÔÆ»Éܸ©+½»½ê1
171$pdf->Text(26, 136, sjis_conv($objPage->arrDisp['deliv_addr02']));                          //¤ªÆϤ±Àè½»½ê2
172$pdf->Text(26, 140, sjis_conv($objPage->arrDisp['deliv_name01']."¡¡".$objPage->arrDisp['deliv_name02']."¡¡ÍÍ"));    //¤ªÆϤ±Àè»á̾
173
174$pdf->Text(144, 121, sjis_conv($objPage->arrDisp['create_date']));    //¤´ÃíʸÆü
175$pdf->Text(144, 131, sjis_conv($objPage->arrDisp['order_disp_id']));  //ÃíʸÈÖ¹æ
176
177$pdf->SetFont('SJIS', 'B', 15);
178$pdf->Cell(0, 10, sjis_conv($objPage->tpl_title), 0, 2, 'C', 0, '');  //ʸ½ñ¥¿¥¤¥È¥ë¡ÊǼÉʽñ¡¦ÀÁµá½ñ¡Ë
179$pdf->Cell(0, 66, '', 0, 2, 'R', 0, '');
180$pdf->Cell(5, 0, '', 0, 0, 'R', 0, '');
181$pdf->Cell(67, 8, sjis_conv(number_format($objPage->arrDisp['payment_total'])." ±ß"), 0, 2, 'R', 0, '');
182$pdf->Cell(0, 45, '', 0, 2, '', 0, '');
183
184$pdf->SetFont('SJIS', '', 9);
185
186//¥í¥´²èÁü
187$pdf->Image('logo.png', 124, 46, 60);
188
189$monetary_unit = sjis_conv("±ß");
190$point_unit = sjis_conv("ŽÎŽßŽ²ŽÝŽÄ");
191
192// ¹ØÆþ¾¦ÉʾðÊó
193for ($i = 0; $i < count($objPage->arrDisp['quantity']); $i++) {
194
195    // ¹ØÆþ¿ôÎÌ
196    $data[0] = $objPage->arrDisp['quantity'][$i];
197
198    // Àǹþ¶â³Û¡Êñ²Á¡Ë
199    $data[1] = sfPreTax($objPage->arrDisp['price'][$i], $arrInfo['tax'], $arrInfo['tax_rule']);
200
201    // ¾®·×¡Ê¾¦ÉÊËè¡Ë
202    $data[2] = $data[0] * $data[1];
203
204    $arrOrder[$i][0]  = sjis_conv($objPage->arrDisp['product_name'][$i]." / ");
205    $arrOrder[$i][0] .= sjis_conv($objPage->arrDisp['product_code'][$i]." / ");
206    if($objPage->arrDisp['classcategory_name1'][$i]) {
207        $arrOrder[$i][0] .= sjis_conv(" [ ".$objPage->arrDisp['classcategory_name1'][$i]);
208        if($objPage->arrDisp['classcategory_name2'][$i] == "") {
209            $arrOrder[$i][0] .= " ]";
210        } else {
211            $arrOrder[$i][0] .= sjis_conv(" * ".$objPage->arrDisp['classcategory_name2'][$i]." ]");
212        }
213    }
214    $arrOrder[$i][1]  = number_format($data[0]);
215    $arrOrder[$i][2]  = number_format($data[1]).$monetary_unit;
216    $arrOrder[$i][3]  = number_format($data[2]).$monetary_unit;
217
218}
219
220$arrOrder[$i][0] = "";
221$arrOrder[$i][1] = "";
222$arrOrder[$i][2] = "";
223$arrOrder[$i][3] = "";
224
225$i++;
226$arrOrder[$i][0] = "";
227$arrOrder[$i][1] = "";
228$arrOrder[$i][2] = sjis_conv("¾¦Éʹç·×");
229$arrOrder[$i][3] = number_format($objPage->arrDisp['subtotal']).$monetary_unit;
230
231$i++;
232$arrOrder[$i][0] = "";
233$arrOrder[$i][1] = "";
234$arrOrder[$i][2] = sjis_conv("Á÷ÎÁ");
235$arrOrder[$i][3] = number_format($objPage->arrDisp['deliv_fee']).$monetary_unit;
236
237$i++;
238$arrOrder[$i][0] = "";
239$arrOrder[$i][1] = "";
240$arrOrder[$i][2] = sjis_conv("¼ê¿ôÎÁ");
241$arrOrder[$i][3] = number_format($objPage->arrDisp['charge']).$monetary_unit;
242
243$i++;
244$arrOrder[$i][0] = "";
245$arrOrder[$i][1] = "";
246$arrOrder[$i][2] = sjis_conv("ÃÍ°ú¤­");
247$arrOrder[$i][3] = "- ".number_format($objPage->arrDisp['use_point'] + $objPage->arrDisp['discount']).$monetary_unit;
248
249$i++;
250$arrOrder[$i][0] = "";
251$arrOrder[$i][1] = "";
252$arrOrder[$i][2] = sjis_conv("ÀÁµá¶â³Û");
253$arrOrder[$i][3] = number_format($objPage->arrDisp['payment_total']).$monetary_unit;
254
255$i++;
256$arrOrder[$i][0] = "";
257$arrOrder[$i][1] = "";
258$arrOrder[$i][2] = "";
259$arrOrder[$i][3] = "";
260
261// ¥Ý¥¤¥ó¥Èɽµ­
262if ($_POST['disp_point'] && $objPage->arrDisp['customer_id']) {
263  $i++;
264  $arrOrder[$i][0] = "";
265  $arrOrder[$i][1] = "";
266  $arrOrder[$i][2] = sjis_conv("ÍøÍюΎߎ²ŽÝŽÄ");
267  $arrOrder[$i][3] = number_format($objPage->arrDisp['use_point']).$point_unit;
268
269  $i++;
270  $arrOrder[$i][0] = "";
271  $arrOrder[$i][1] = "";
272  $arrOrder[$i][2] = sjis_conv("²Ã»»ŽÎŽßŽ²ŽÝŽÄ");
273  $arrOrder[$i][3] = number_format($objPage->arrDisp['add_point']).$point_unit;
274
275  $i++;
276  $arrOrder[$i][0] = "";
277  $arrOrder[$i][1] = "";
278  $arrOrder[$i][2] = sjis_conv("½êÍ­ŽÎŽßŽ²ŽÝŽÄ");
279  $arrOrder[$i][3] = number_format($objPage->arrDisp['point']).$point_unit;
280}
281
282$pdf->FancyTable($objPage->label_cell, $arrOrder, $objPage->width_cell);
283
284if ($objPage->arrEtc[0]) {
285  $pdf->Cell(0, 10, '', 0, 1, 'C', 0, '');
286  $pdf->SetFont('SJIS', '', 9);
287  $pdf->MultiCell(0, 6, sjis_conv("¡ã È÷ ¹Í ¡ä"), 'T', 2, 'L', 0, '');  //È÷¹Í
288  $pdf->Ln();
289  $pdf->SetFont('SJIS', '', 8);
290  $pdf->MultiCell(0, 4, sjis_conv($objPage->arrEtc[0]."\n".$objPage->arrEtc[1]."\n".$objPage->arrEtc[2]), '', 2, 'L', 0, '');  //È÷¹Í
291}
292
293// PDF¤ò¥Ö¥é¥¦¥¶¤ËÁ÷¿®
294if($objPage->pdf_download == 1) {
295    $pdf->Output(sjis_conv("nouhinsyo-No".$objPage->tpl_order_id.".pdf"), D);
296} else {
297    $pdf->Output();
298}
299
300// ÆþÎϤ·¤ÆPDF¥Õ¥¡¥¤¥ë¤òÊĤ¸¤ë
301$pdf->Close();
302
303
304//-----------------------------------------------------------------------------------------------------------------------------------
305// ʸ»ú¥³¡¼¥ÉSJISÊÑ´¹ -> japanese.php¤Ç»ÈÍѽÐÍè¤ëʸ»ú¥³¡¼¥É¤ÏSJIS¤Î¤ß
306function sjis_conv($conv_str) {
307    global $objPage;
308    $str = mb_convert_encoding($conv_str, "SJIS", $objPage->tpl_char);
309    return $str;
310}
311
312/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
313function lfInitParam() {
314    global $objFormParam;
315
316    // ÇÛÁ÷Àè¾ðÊó
317    $objFormParam->addParam("¤ªÌ¾Á°1", "deliv_name01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
318    $objFormParam->addParam("¤ªÌ¾Á°2", "deliv_name02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
319    $objFormParam->addParam("¥Õ¥ê¥¬¥Ê1", "deliv_kana01", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
320    $objFormParam->addParam("¥Õ¥ê¥¬¥Ê2", "deliv_kana02", STEXT_LEN, "KVCa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
321    $objFormParam->addParam("͹ÊØÈÖ¹æ1", "deliv_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
322    $objFormParam->addParam("͹ÊØÈÖ¹æ2", "deliv_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
323    $objFormParam->addParam("ÅÔÆ»Éܸ©", "deliv_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
324    $objFormParam->addParam("½»½ê1", "deliv_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
325    $objFormParam->addParam("½»½ê2", "deliv_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
326    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "deliv_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
327    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "deliv_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
328    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "deliv_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
329
330    // ¼õÃí¾¦ÉʾðÊó
331    $objFormParam->addParam("ÃÍ°ú¤­", "discount", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
332    $objFormParam->addParam("Á÷ÎÁ", "deliv_fee", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
333    $objFormParam->addParam("¼ê¿ôÎÁ", "charge", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
334    $objFormParam->addParam("ÍøÍѥݥ¤¥ó¥È", "use_point", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
335    $objFormParam->addParam("¤ª»Ùʧ¤¤ÊýË¡", "payment_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
336    $objFormParam->addParam("ÇÛÁ÷»þ´ÖID", "deliv_time_id", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
337    $objFormParam->addParam("Âбþ¾õ¶·", "status", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
338    $objFormParam->addParam("ÇÛãÆü", "deliv_date", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
339    $objFormParam->addParam("¤ª»ÙʧÊýˡ̾¾Î", "payment_method");
340    $objFormParam->addParam("ÇÛÁ÷»þ´Ö", "deliv_time");
341   
342    // ¼õÃí¾ÜºÙ¾ðÊó
343    $objFormParam->addParam("ñ²Á", "price", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
344    $objFormParam->addParam("¸Ä¿ô", "quantity", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
345    $objFormParam->addParam("¾¦ÉÊID", "product_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"), '0');
346    $objFormParam->addParam("¥Ý¥¤¥ó¥ÈÉÕͿΨ", "point_rate");
347    $objFormParam->addParam("¾¦ÉÊ¥³¡¼¥É", "product_code");
348    $objFormParam->addParam("¾¦ÉÊ̾", "product_name");
349    $objFormParam->addParam("µ¬³Ê1", "classcategory_id1");
350    $objFormParam->addParam("µ¬³Ê2", "classcategory_id2");
351    $objFormParam->addParam("µ¬³Ê̾1", "classcategory_name1");
352    $objFormParam->addParam("µ¬³Ê̾2", "classcategory_name2");
353    $objFormParam->addParam("¥á¥â", "note", MTEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
354
355    // DBÆɹþÍÑ
356    $objFormParam->addParam("¾®·×", "subtotal");
357    $objFormParam->addParam("¹ç·×", "total");
358    $objFormParam->addParam("»Ùʧ¤¤¹ç·×", "payment_total");
359    $objFormParam->addParam("²Ã»»¥Ý¥¤¥ó¥È", "add_point");
360    $objFormParam->addParam("¤ªÃÂÀ¸Æü¥Ý¥¤¥ó¥È", "birth_point");
361    $objFormParam->addParam("¾ÃÈñÀǹç·×", "tax");
362    $objFormParam->addParam("ºÇ½ªÊÝ»ý¥Ý¥¤¥ó¥È", "total_point");
363    $objFormParam->addParam("¸ÜµÒID", "customer_id");
364    $objFormParam->addParam("¸½ºß¤Î¥Ý¥¤¥ó¥È", "point");
365}
366
367// ¼õÃí¥Ç¡¼¥¿¤Î¼èÆÀ
368function lfGetOrderData($order_id) {
369    global $objFormParam;
370    global $objPage;
371    if(sfIsInt($order_id)) {
372
373        // DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
374        $objQuery = new SC_Query();
375        $where = "order_id = ?";
376        $arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id));
377        $objFormParam->setParam($arrRet[0]);
378        list($point, $total_point) = sfGetCustomerPoint($order_id, $arrRet[0]['use_point'], $arrRet[0]['add_point']);
379        $objFormParam->setValue('total_point', $total_point);
380        $objFormParam->setValue('point', $point);
381        $arrRet[0]['total_point'] = $total_point;
382        $arrRet[0]['point'] = $point;
383        $objPage->arrDisp = $arrRet[0];
384
385        // ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
386        $arrRet = lfGetOrderDetail($order_id);
387        $arrRet = sfSwapArray($arrRet);
388        $objPage->arrDisp = array_merge($objPage->arrDisp, $arrRet);
389        $objFormParam->setParam($arrRet);
390
391        // ¤½¤Î¾»Ùʧ¤¤¾ðÊó¤òɽ¼¨
392        if($objPage->arrDisp["memo02"] != "") $objPage->arrDisp["payment_info"] = unserialize($objPage->arrDisp["memo02"]);
393        if($objPage->arrDisp["memo01"] == PAYMENT_CREDIT_ID){
394            $objPage->arrDisp["payment_type"] = "¥¯¥ì¥¸¥Ã¥È·èºÑ";
395        }elseif($objPage->arrDisp["memo01"] == PAYMENT_CONVENIENCE_ID){
396            $objPage->arrDisp["payment_type"] = "¥³¥ó¥Ó¥Ë·èºÑ";
397        }else{
398            $objPage->arrDisp["payment_type"] = "¤ª»Ùʧ¤¤";
399        }
400    }
401}
402
403// ¼õÃí¾ÜºÙ¥Ç¡¼¥¿¤Î¼èÆÀ
404function lfGetOrderDetail($order_id) {
405    $objQuery = new SC_Query();
406    $col = "product_id, classcategory_id1, classcategory_id2, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate";
407    $where = "order_id = ?";
408    $objQuery->setorder("classcategory_id1, classcategory_id2");
409    $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id));
410    return $arrRet;
411}
412?>
413
Note: See TracBrowser for help on using the repository browser.