§Úªºweberp¹ê¾Ô¤â¥U¡]¤T¡^¡A weberp ¥Î¨ÓºÞ²z¼Ë«~¡A¥Xsamples order
¦bhtdocs©³¤U·s¶}¤@ӥؿýsamples,·íµMDatabase¤]n·s¼W¡CµM«á¦AZ_index.phpùر·s¼W¤@Ó¤½¥qSamples..¤£µMn¤W¶Ç²£«~¹Ï¤ùªº®Éԥؿý·|¿ù»~¡C
³o¦¸ªº¥Øªº¬O§âWebERP¨ÓºÞ²z¼Ë«~¡APO§ï¦¨¼Ë«~ªº»Ý¨D³æ¡APOªºcode§ï¦¨Brand¡C¦b¿é¤Jitemªº®ÉÔ¡A§â«~µP¦WºÙ¿é¤Jitem category,,,±µ¤U¨Ó´N¬On¶}©lקï¤F¡C
1¡G¥´¶}PO_PDFPurchOrder.php
§â130¡A131¦æªºPurchase Order §ï¦¨ Samples Order ¡A¦p¤U
$pdf->addinfo('Title', _('Samples Order') );
$pdf->addinfo('Subject', _('Samples Ordert Number').' ' . $_GET['OrderNo']);
µM«á©O¡C¦p¦ó§âPO¤Wªºcodeªº¤º®e§ï¦¨category¡]´N¬O»«¬ªºµP¤l¡^©O¡H³oÓ¦³ÂI½ÆÂø¡AÃö«Y¨ì¤TÓªí: purchorderdetails , stockmaster, stockcategory.«ç»ò±qpurchorderdetailsªºitemcode¡A³sµ²¨ìstockmasterªºcategoryid,µM«á¤~¨ìstockcategory±Ncategorydescription¤º®e¨ú¥X¨Ó¡Cµª®×¬O¡C¡C¡CLEFT JOIN
¦b140¦æ,Select ³Ì«á¡A¥[¤Wcategorydescription,µM«á§âstockcategory ,LEFT JOIN¨ì stockmaster,,,ק粒«á¦p¤U¡G
$sql = "SELECT itemcode,
deliverydate,
itemdescription,
unitprice,
units,
quantityord,
decimalplaces,
categorydescription
FROM purchorderdetails LEFT JOIN stockmaster
ON (purchorderdetails.itemcode=stockmaster.stockid)
LEFT JOIN stockcategory
ON (stockmaster.categoryid=stockcategory.categoryid)
WHERE orderno =" . $OrderNo;
2¡G§ó§ïÄæ¦ì¦WºÙ
¥´¶}includes/PO_PDFOrderPageHeader.inc
¦A142¦æ±N code§ï¦¨ Brand.
µ²½×¡G§âPO§ï¦¨¼Ë«~»Ý¨D³æ¡A¥i¥H¤è«K®w¦sºÞ²z.¥X¼Ë«~µ¹«È¤Hªº®ÉÔ¡A¤]¦³Ó°O¿ý¡C
·d¤F¤@Ó¤U¤È¡A¡A¥Í·N³£¨S°µ¨ì¡C¡C¡C |