source: branches/comu-euc/html/admin/pdf.d/index.php @ 17249

Revision 17249, 15.1 KB checked in by homan, 18 years ago (diff)

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