Index: branches/version-2/data/class/SC_Fpdf.php =================================================================== --- branches/version-2/data/class/SC_Fpdf.php (revision 17232) +++ branches/version-2/data/class/SC_Fpdf.php (revision 17232) @@ -0,0 +1,341 @@ +arrData = $arrData; + // デフォルトの設定 + $this->tpl_pdf = PDF_TEMPLATE_DIR . $tpl_pdf; // テンプレートファイル + $this->pdf_download = $arrData[download]; // PDFのダウンロード形式（0:表示、1:ダウンロード） + $this->tpl_title = $arrData['title']; + $this->tpl_dispmode = "real"; // 表示モード + $masterData = new SC_DB_MasterData_Ex(); + $this->arrPref = $masterData->getMasterData("mtb_pref", array("pref_id", "pref_name", "rank")); + $this->width_cell = array(110.3,12,21.7,24.5); + + $this->label_cell[] = $this->sjis_conv("商品名 / 商品コード / [ 規格 ]"); + $this->label_cell[] = $this->sjis_conv("数量"); + $this->label_cell[] = $this->sjis_conv("単価"); + $this->label_cell[] = $this->sjis_conv("金額(税込)"); + + $this->arrMessage = array( + 'このたびはお買上げいただきありがとうございます。', + '下記の内容にて納品させていただきます。', + 'ご確認いただきますよう、お願いいたします。' + ); + + $this->pdf = new PDF_Japanese(); + + // SJISフォント + $this->pdf->AddSJISFont(); + + //ページ総数取得 + $this->pdf->AliasNbPages(); + + // マージン設定 + $this->pdf->SetMargins(15, 20); + + // PDFを読み込んでページ数を取得 + $pageno = $this->pdf->setSourceFile($this->tpl_pdf); + + // ページ番号よりIDを取得 + $tplidx = $this->pdf->ImportPage(1); + + // ページを追加（新規） + $this->pdf->AddPage(); + + //表示倍率(100%) + $this->pdf->SetDisplayMode($this->tpl_dispmode); + + if(SC_Utils_Ex::sfIsInt($arrData['order_id'])) { + $this->disp_mode = true; + $order_id = $arrData['order_id']; + } + + // テンプレート内容の位置、幅を調整 ※useTemplateに引数を与えなければ100%表示がデフォルト + $this->pdf->useTemplate($tplidx); + + $this->setShopData(); + $this->setMessageData(); + $this->setOrderData(); + $this->setEtcData(); + + //ロゴ画像 + $this->pdf->Image(PDF_IMG_DIR. 'logo.png', 124, 46, 60); + + $this->createPdf(); + } + + function setShopData() { + // ショップ情報 + + $objInfo = new SC_SiteInfo(); + $arrInfo = $objInfo->data; + + $this->lfText(125, 60, $arrInfo['shop_name'], 8, 'B'); //ショップ名 + $this->lfText(125, 63, $arrInfo['law_url'], 8); //URL + $this->lfText(125, 68, $arrInfo['law_company'], 8); //会社名 + $text = "〒 ".$arrInfo['zip01']." - ".$arrInfo['zip02']; + $this->lfText(125, 71, $text, 8); //郵便番号 + $text = $this->arrPref[$arrInfo['pref']].$arrInfo['addr01']; + $this->lfText(125, 74, $text, 8); //都道府県+住所1 + $this->lfText(125, 77, $arrInfo['addr02'], 8); //住所2 + $text = "TEL: ".$arrInfo['tel01']."-".$arrInfo['tel02']."-".$arrInfo['tel03']."　"."FAX: ".$arrInfo['fax01']."-".$arrInfo['fax02']."-".$arrInfo['fax03']; + $this->lfText(125, 80, $text, 8); //TEL・FAX + $text = "Email: ".$arrInfo['law_email']; + $this->lfText(125, 83, $text, 8); //Email + } + + function setMessageData() { + // メッセージ + $this->lfText(27, 70, $this->arrData['msg1'], 8); //メッセージ1 + $this->lfText(27, 74, $this->arrData['msg2'], 8); //メッセージ2 + $this->lfText(27, 78, $this->arrData['msg3'], 8); //メッセージ3 + $text = "作成日: ".$this->arrData['year']."年".$this->arrData['month']."月".$this->arrData['day']."日"; + $this->lfText(158, 288, $text, 8); //作成日 + } + + function setOrderData() { + // DBから受注情報を読み込む + $this->lfGetOrderData($this->arrData['order_id']); + + // 購入者情報 + $text = "〒 ".$this->arrDisp['order_zip01']." - ".$this->arrDisp['order_zip02']; + $this->lfText(23, 43, $text, 10); //購入者郵便番号 + $text = $this->arrPref[$this->arrDisp['order_pref']] . $this->arrDisp['order_addr01']; + $this->lfText(27, 47, $text, 10); //購入者都道府県+住所1 + $this->lfText(27, 51, $this->arrDisp['order_addr02'], 10); //購入者住所2 + $text = $this->arrDisp['order_name01']."　".$this->arrDisp['order_name02']."　様"; + $this->lfText(27, 59, $text, 11); //購入者氏名 + + // お届け先情報 + $this->pdf->SetFont('SJIS', '', 10); + $text = "〒 ".$this->arrDisp['deliv_zip01']." - ".$this->arrDisp['deliv_zip02']; + $this->lfText(22, 128, $text, 10); //お届け先郵便番号 + $text = $this->arrPref[$this->arrDisp['deliv_pref']] . $this->arrDisp['deliv_addr01']; + $this->lfText(26, 132, $text, 10); //お届け先都道府県+住所1 + $this->lfText(26, 136, $this->arrDisp['deliv_addr02'], 10); //お届け先住所2 + $text = $this->arrDisp['deliv_name01']."　".$this->arrDisp['deliv_name02']."　様"; + $this->lfText(26, 140, $text, 10); //お届け先氏名 + + $this->lfText(144, 121, SC_Utils_Ex::sfDispDBDate($this->arrDisp['create_date']), 10); //ご注文日 + $this->lfText(144, 131, $this->arrDisp['order_id'], 10); //注文番号 + + $this->pdf->SetFont('SJIS', 'B', 15); + $this->pdf->Cell(0, 10, $this->sjis_conv($this->tpl_title), 0, 2, 'C', 0, ''); //文書タイトル（納品書・請求書） + $this->pdf->Cell(0, 66, '', 0, 2, 'R', 0, ''); + $this->pdf->Cell(5, 0, '', 0, 0, 'R', 0, ''); + $this->pdf->Cell(67, 8, $this->sjis_conv(number_format($this->arrDisp['payment_total'])." 円"), 0, 2, 'R', 0, ''); + $this->pdf->Cell(0, 45, '', 0, 2, '', 0, ''); + + $this->pdf->SetFont('SJIS', '', 9); + + $monetary_unit = $this->sjis_conv("円"); + $point_unit = $this->sjis_conv("pt"); + + // 購入商品情報 + for ($i = 0; $i < count($this->arrDisp['quantity']); $i++) { + + // 購入数量 + $data[0] = $this->arrDisp['quantity'][$i]; + + // 税込金額（単価） + $data[1] = SC_Utils_Ex::sfPreTax($this->arrDisp['price'][$i], $arrInfo['tax'], $arrInfo['tax_rule']); + + // 小計（商品毎） + $data[2] = $data[0] * $data[1]; + + $arrOrder[$i][0] = $this->sjis_conv($this->arrDisp['product_name'][$i]." / "); + $arrOrder[$i][0] .= $this->sjis_conv($this->arrDisp['product_code'][$i]." / "); + if($this->arrDisp['classcategory_name1'][$i]) { + $arrOrder[$i][0] .= $this->sjis_conv(" [ ".$this->arrDisp['classcategory_name1'][$i]); + if($this->arrDisp['classcategory_name2'][$i] == "") { + $arrOrder[$i][0] .= " ]"; + } else { + $arrOrder[$i][0] .= $this->sjis_conv(" * ".$this->arrDisp['classcategory_name2'][$i]." ]"); + } + } + $arrOrder[$i][1] = number_format($data[0]); + $arrOrder[$i][2] = number_format($data[1]).$monetary_unit; + $arrOrder[$i][3] = number_format($data[2]).$monetary_unit; + + } + + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = ""; + $arrOrder[$i][3] = ""; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("商品合計"); + $arrOrder[$i][3] = number_format($this->arrDisp['subtotal']).$monetary_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("送料"); + $arrOrder[$i][3] = number_format($this->arrDisp['deliv_fee']).$monetary_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("手数料"); + $arrOrder[$i][3] = number_format($this->arrDisp['charge']).$monetary_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("値引き"); + $arrOrder[$i][3] = "- ".number_format($this->arrDisp['use_point'] + $this->arrDisp['discount']).$monetary_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("請求金額"); + $arrOrder[$i][3] = number_format($this->arrDisp['payment_total']).$monetary_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = ""; + $arrOrder[$i][3] = ""; + + // ポイント表記 + if ($this->arrData['disp_point'] && $this->arrDisp['customer_id']) { + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("利用ポイント"); + $arrOrder[$i][3] = number_format($this->arrDisp['use_point']).$point_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("加算ポイント"); + $arrOrder[$i][3] = number_format($this->arrDisp['add_point']).$point_unit; + + $i++; + $arrOrder[$i][0] = ""; + $arrOrder[$i][1] = ""; + $arrOrder[$i][2] = $this->sjis_conv("所有ポイント"); + $arrOrder[$i][3] = number_format($this->arrDisp['point']).$point_unit; + } + + $this->pdf->FancyTable($this->label_cell, $arrOrder, $this->width_cell); + } + + function setEtcData() { + $this->pdf->Cell(0, 10, '', 0, 1, 'C', 0, ''); + $this->pdf->SetFont('SJIS', '', 9); + $this->pdf->MultiCell(0, 6, $this->sjis_conv("＜ 備 考 ＞"), 'T', 2, 'L', 0, ''); //備考 + $this->pdf->Ln(); + $this->pdf->SetFont('SJIS', '', 8); + $this->pdf->MultiCell(0, 4, $this->sjis_conv($this->arrData['etc1']."\n".$this->arrData['etc2']."\n".$this->arrData['etc3']), '', 2, 'L', 0, ''); //備考 + } + + function createPdf() { + // PDFをブラウザに送信 +ob_clean(); + if($this->pdf_download == 1) { + $filename = "nouhinsyo-No".$this->arrData['order_id'].".pdf"; + $this->pdf->Output($this->sjis_conv($filename), D); + } else { + $this->pdf->Output(); + } + + // 入力してPDFファイルを閉じる + $this->pdf->Close(); + } + + // PDF_Japanese::Text へのパーサー + function lfText($x, $y, $text, $size, $style = '') { + $text = mb_convert_encoding($text, "SJIS", CHAR_CODE); + + $this->pdf->SetFont('SJIS', $style, $size); + $this->pdf->Text($x, $y, $text); + } + + + // 受注データの取得 + function lfGetOrderData($order_id) { + if(SC_Utils_Ex::sfIsInt($order_id)) { + // DBから受注情報を読み込む + $objQuery = new SC_Query(); + $where = "order_id = ?"; + $arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id)); + #$objFormParam->setParam($arrRet[0]); + list($point, $total_point) = SC_Helper_DB_Ex::sfGetCustomerPoint($order_id, $arrRet[0]['use_point'], $arrRet[0]['add_point']); + #$objFormParam->setValue('total_point', $total_point); + #$objFormParam->setValue('point', $point); + $arrRet[0]['total_point'] = $total_point; + $arrRet[0]['point'] = $point; + $this->arrDisp = $arrRet[0]; + + // 受注詳細データの取得 + $arrRet = $this->lfGetOrderDetail($order_id); + $arrRet = SC_Utils_Ex::sfSwapArray($arrRet); + $this->arrDisp = array_merge($this->arrDisp, $arrRet); + #$objFormParam->setParam($arrRet); + + // その他支払い情報を表示 + if($this->arrDisp["memo02"] != "") $this->arrDisp["payment_info"] = unserialize($this->arrDisp["memo02"]); + if($this->arrDisp["memo01"] == PAYMENT_CREDIT_ID){ + $this->arrDisp["payment_type"] = "クレジット決済"; + } elseif ($this->arrDisp["memo01"] == PAYMENT_CONVENIENCE_ID) { + $this->arrDisp["payment_type"] = "コンビニ決済"; + } else { + $this->arrDisp["payment_type"] = "お支払い"; + } + } + } + + // 受注詳細データの取得 + function lfGetOrderDetail($order_id) { + $objQuery = new SC_Query(); + $col = "product_id, classcategory_id1, classcategory_id2, product_code, product_name, classcategory_name1, classcategory_name2, price, quantity, point_rate"; + $where = "order_id = ?"; + $objQuery->setorder("classcategory_id1, classcategory_id2"); + $arrRet = $objQuery->select($col, "dtb_order_detail", $where, array($order_id)); + return $arrRet; + } + + // 文字コードSJIS変換 -> japanese.phpで使用出来る文字コードはSJISのみ + function sjis_conv($conv_str) { + return (mb_convert_encoding($conv_str, "SJIS", CHAR_CODE)); + } + + +} +?> Index: branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php =================================================================== --- branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php (revision 17232) +++ branches/version-2/data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php (revision 17232) @@ -0,0 +1,177 @@ +tpl_mainpage = 'order/pdf_input.tpl'; + $this->tpl_subnavi = 'order/subnavi.tpl'; + $this->tpl_mainno = 'order'; + $this->tpl_subno = 'pdf'; + $this->tpl_subtitle = '帳票出力'; + + $this->SHORTTEXT_MAX = STEXT_LEN; + $this->MIDDLETEXT_MAX = MTEXT_LEN; + $this->LONGTEXT_MAX = LTEXT_LEN; + + $this->arrType[0] = "納品書"; + + $this->arrDownload[0] = "ブラウザに開く"; + $this->arrDownload[1] = "ファイルに保存"; + } + + /** + * Page のプロセス. + * + * @return void + */ + function process() { + $conn = new SC_DBConn(); + $objView = new SC_AdminView(); + $objDb = new SC_Helper_DB_Ex(); + $objSess = new SC_Session(); + + $objDate = new SC_Date(1901); + $objDate->setStartYear(RELEASE_YEAR); + $this->arrYear = $objDate->getYear(); + $this->arrMonth = $objDate->getMonth(); + $this->arrDay = $objDate->getDay(); + + // 認証可否の判定 + SC_Utils_Ex::sfIsSuccess($objSess); + + // 画面遷移の正当性チェック用にuniqidを埋め込む + $objPage->tpl_uniqid = $objSess->getUniqId(); + + // パラメータ管理クラス + $this->objFormParam = new SC_FormParam(); + // パラメータ情報の初期化 + $this->lfInitParam(); + $this->objFormParam->setParam($_POST); + + if (!isset($_POST['mode'])) $_POST['mode'] = ""; + if (!isset($arrRet)) $arrRet = array(); + + switch($_POST['mode']) { + case "confirm": + // 入力値の変換 + $this->objFormParam->convParam(); + $this->arrErr = $this->lfCheckError($arrRet); + $arrRet = $this->objFormParam->getHashArray(); + $this->arrForm = $arrRet; + // エラー入力なし + if (count($this->arrErr) == 0) { + $objFpdf = new SC_Fpdf($arrRet); + } + break; + default: + // タイトルをセット + $arrForm['title'] = "お買上げ明細書(納品書)"; + + // 今日の日付をセット + $arrForm['year'] = date("Y"); + $arrForm['month'] = date("m"); + $arrForm['day'] = date("d"); + + // メッセージ + $arrForm['msg1'] = 'このたびはお買上げいただきありがとうございます。'; + $arrForm['msg2'] = '下記の内容にて納品させていただきます。'; + $arrForm['msg3'] = 'ご確認いただきますよう、お願いいたします。'; + + // 受注番号があったら、セットする + if(SC_Utils_Ex::sfIsInt($_GET['order_id'])) { + $arrForm['order_id'] = $_GET['order_id']; + } + + $this->arrForm = $arrForm; + break; + } + + $objView->assignobj($this); + $objView->display($this->tpl_mainpage); + } + + /** + * デストラクタ. + * + * @return void + */ + function destroy() { + parent::destroy(); + } + + /* パラメータ情報の初期化 */ + function lfInitParam() { + $this->objFormParam->addParam("受注番号", "order_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("発行日", "year", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("発行日", "month", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("発行日", "day", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("帳票の種類", "type", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("ダウンロード方法", "download", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $this->objFormParam->addParam("帳票タイトル", "title", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("帳票メッセージ1行目", "msg1", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("帳票メッセージ2行目", "msg2", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("帳票メッセージ3行目", "msg3", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("備考1行目", "etc1", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("備考2行目", "etc2", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("備考3行目", "etc3", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK")); + $this->objFormParam->addParam("ポイント表記", "disp_point", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + } + + /* 入力内容のチェック */ + function lfCheckError() { + // 入力データを渡す。 + $arrRet = $this->objFormParam->getHashArray(); + $objErr = new SC_CheckError($arrRet); + $objErr->arrErr = $this->objFormParam->checkError(); + + // 特殊項目チェック + $objErr->doFunc(array("発行日", "year", "month", "day"), array("CHECK_DATE")); + + return $objErr->arrErr; + } + + +} + +?>