From: <tim...@us...> - 2010-03-17 09:34:10
|
Revision: 3391 http://web-erp.svn.sourceforge.net/web-erp/?rev=3391&view=rev Author: tim_schofield Date: 2010-03-17 09:33:57 +0000 (Wed, 17 Mar 2010) Log Message: ----------- Tim: Various layout improvements to top items report Modified Paths: -------------- trunk/PDFTopItems.php trunk/TopItems.php trunk/doc/Change.log.html trunk/includes/PDFTopItemsHeader.inc Modified: trunk/PDFTopItems.php =================================================================== --- trunk/PDFTopItems.php 2010-03-16 15:02:10 UTC (rev 3390) +++ trunk/PDFTopItems.php 2010-03-17 09:33:57 UTC (rev 3391) @@ -1,165 +1,127 @@ <?php /* $Revision: 1.2 $ */ /* $Id$*/ - $PageSecurity = 2; -include('includes/session.inc'); - - -include('includes/PDFStarter.php'); - -$FontSize=10; -$pdf->addinfo('Title', _('Top Items Search Result') ); - -$PageNumber=1; -$line_height=12; - - -include('includes/PDFTopItemsHeader.inc'); - -$FontSize =10; - -//the situation if the location and customer type selected "All" - if(($_GET["location"]=="All")and($_GET["customers"]=="All")){ - $SQL=" - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, - SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, - stockmaster.description, - stockmaster.units - - - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster +include ('includes/session.inc'); +include ('includes/PDFStarter.php'); +$FontSize = 10; +$pdf->addinfo('Title', _('Top Items Search Result')); +$PageNumber = 1; +$line_height = 12; +include ('includes/PDFTopItemsHeader.inc'); +$FontSize = 10; +//the situation if the location and customer type selected "All" +if (($_GET["location"] == "All") and ($_GET["customers"] == "All")) { + $SQL = "SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, + stockmaster.description, + stockmaster.units + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + WHERE salesorderdetails.orderno = salesorders.orderno + AND salesorderdetails.stkcode = stockmaster.stockid + AND salesorders.debtorno = debtorsmaster.debtorno + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_GET["numberofdays"] . " DAY) + GROUP BY salesorderdetails.stkcode + ORDER BY " . $_GET['order'] . " DESC + LIMIT 0," . $_GET['NumberOfTopItems'] . ""; +} else { //the situation if only location type selected "All" + if ($_GET["location"] == "All") { + $SQL = "SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, + stockmaster.description, + stockmaster.units + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL ".$_GET["numberofdays"]." DAY) - GROUP BY salesorderdetails.stkcode - ORDER BY ".$_GET['order']." DESC - LIMIT 0,".$_GET['NumberOfTopItems'].""; - } - else{ //the situation if only location type selected "All" - if($_GET["location"]=="All"){ - $SQL=" - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + AND debtorsmaster.typeid = '" . $_GET["customers"] . "' + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_GET["numberofdays"] . " DAY) + GROUP BY salesorderdetails.stkcode + ORDER BY " . $_GET['order'] . " DESC + LIMIT 0," . $_GET['NumberOfTopItems'] . ""; + } else { + //the situation if the customer type selected "All" + if ($_GET["customers"] == "All") { + $SQL = " + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, stockmaster.units - - - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster - WHERE salesorderdetails.orderno = salesorders.orderno + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno - AND debtorsmaster.typeid = '".$_GET["customers"]."' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL ".$_GET["numberofdays"]." DAY) - GROUP BY salesorderdetails.stkcode - ORDER BY ".$_GET['order']." DESC - LIMIT 0,".$_GET['NumberOfTopItems'].""; - } - else { - //the situation if the customer type selected "All" - if($_GET["customers"]=="All"){ - $SQL=" - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + AND salesorders.fromstkloc = '" . $_GET["location"] . "' + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_GET["numberofdays"] . " DAY) + GROUP BY salesorderdetails.stkcode + ORDER BY " . $_GET['order'] . " DESC + LIMIT 0," . $_GET['NumberOfTopItems'] . ""; + } else { + //the situation if the location and customer type not selected "All" + $SQL = " + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, stockmaster.units - - - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno - AND salesorders.fromstkloc = '".$_GET["location"]."' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL ".$_GET["numberofdays"]." DAY) - GROUP BY salesorderdetails.stkcode - ORDER BY ".$_GET['order']." DESC - LIMIT 0,".$_GET['NumberOfTopItems'].""; - - } - else{ - //the situation if the location and customer type not selected "All" - $SQL=" - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, - SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, - stockmaster.description, - stockmaster.units - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster - WHERE salesorderdetails.orderno = salesorders.orderno - AND salesorderdetails.stkcode = stockmaster.stockid - AND salesorders.debtorno = debtorsmaster.debtorno - AND salesorders.fromstkloc = '".$_GET["location"]."' - AND debtorsmaster.typeid = '".$_GET["customers"]."' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL ".$_GET["numberofdays"]." DAY) - GROUP BY salesorderdetails.stkcode - ORDER BY ".$_GET['order']." DESC - LIMIT 0,".$_GET['NumberOfTopItems'].""; - - } - } + AND salesorders.fromstkloc = '" . $_GET["location"] . "' + AND debtorsmaster.typeid = '" . $_GET["customers"] . "' + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_GET["numberofdays"] . " DAY) + GROUP BY salesorderdetails.stkcode + ORDER BY " . $_GET['order'] . " DESC + LIMIT 0," . $_GET['NumberOfTopItems'] . ""; } - -$result = DB_query($SQL,$db); - -$YPos=$YPos-6; -while ($myrow=DB_fetch_array($result)) { - - //find the quantity onhand item - $sqloh="SELECT sum(quantity)as qty - FROM `locstock` + } +} +$result = DB_query($SQL, $db); +$YPos = $YPos - 6; +while ($myrow = DB_fetch_array($result)) { + //find the quantity onhand item + $sqloh = "SELECT sum(quantity)as qty + FROM `locstock` WHERE stockid='" . $myrow['0'] . "'"; - $oh = db_query($sqloh,$db,$ErrMsg); - $ohRow = db_fetch_row($oh); - $OnHand=$ohRow[0]; - - $ValueSales=number_format($myrow['2'],2); - - - $Code=$myrow['0'];//stkcode - $Desc=$myrow['3'];//desc - $TotalInvoice=$myrow['1'];//total invoice here - $Unit=$myrow['4'];//unit - - - $LeftOvers = $pdf->addTextWrap($Left_Margin+1,$YPos,300-$Left_Margin,$FontSize, $Code); - $LeftOvers = $pdf->addTextWrap($Left_Margin+100,$YPos,270-$Left_Margin,$FontSize, $Desc); - $LeftOvers = $pdf->addTextWrap($Left_Margin+370,$YPos,30-$Left_Margin,$FontSize, $TotalInvoice, 'right'); - $LeftOvers = $pdf->addTextWrap($Left_Margin+370,$YPos,300-$Left_Margin,$FontSize, $Unit, 'left'); - $LeftOvers = $pdf->addTextWrap($Left_Margin+400,$YPos,70,$FontSize, $ValueSales, 'right'); - $LeftOvers = $pdf->addTextWrap($Left_Margin+490,$YPos,30,$FontSize, $OnHand, 'right'); - - if (strlen($LeftOvers)>1){ - $LeftOvers = $pdf->addTextWrap($Left_Margin+1+94,$YPos-$line_height,270,$FontSize,$LeftOvers, 'left'); - $YPos-=$line_height; - } - - if ($YPos-$line_height <= $Bottom_Margin){ - /* We reached the end of the page so finish off the page and start a newy */ - $PageNumber++; - - include ('includes/PDFTopItemsHeader.inc'); - $FontSize=10; - } //end if need a new page headed up - - /*increment a line down for the next line item */ - $YPos -= $line_height; - - + $oh = db_query($sqloh, $db); + $ohRow = db_fetch_row($oh); + $OnHand = $ohRow[0]; + $ValueSales = number_format($myrow['2'], 2); + $Code = $myrow['0']; //stkcode + $Desc = $myrow['3']; //desc + $TotalInvoice = $myrow['1']; //total invoice here + $Unit = $myrow['4']; //unit + $LeftOvers = $pdf->addTextWrap($Left_Margin + 1, $YPos, 300 - $Left_Margin, $FontSize, $Code); + $LeftOvers = $pdf->addTextWrap($Left_Margin + 100, $YPos, 270 - $Left_Margin, $FontSize, $Desc); + $LeftOvers = $pdf->addTextWrap($Left_Margin + 330, $YPos, 30, $FontSize, $TotalInvoice, 'right'); + $LeftOvers = $pdf->addTextWrap($Left_Margin + 370, $YPos, 300 - $Left_Margin, $FontSize, $Unit, 'left'); + $LeftOvers = $pdf->addTextWrap($Left_Margin + 400, $YPos, 70, $FontSize, $ValueSales, 'right'); + $LeftOvers = $pdf->addTextWrap($Left_Margin + 490, $YPos, 30, $FontSize, $OnHand, 'right'); + if (strlen($LeftOvers) > 1) { + $LeftOvers = $pdf->addTextWrap($Left_Margin + 1 + 94, $YPos - $line_height, 270, $FontSize, $LeftOvers, 'left'); + $YPos-= $line_height; + } + if ($YPos - $line_height <= $Bottom_Margin) { + /* We reached the end of the page so finish off the page and start a newy */ + $PageNumber++; + include ('includes/PDFTopItemsHeader.inc'); + $FontSize = 10; + } //end if need a new page headed up + /*increment a line down for the next line item */ + $YPos-= $line_height; } - $pdfcode = $pdf->output(); $len = strlen($pdfcode); - -if (DB_num_rows($result)==0){ +if (DB_num_rows($result) == 0) { $title = _('Print Price List Error'); - include('includes/header.inc'); - prnMsg(_('There were no records returned '),'warn'); - echo '<br><a href="'.$rootpath.'/index.php?' . SID . '">'. _('Back to the menu').'</a>'; - include('includes/footer.inc'); + include ('includes/header.inc'); + prnMsg(_('There were no records returned '), 'warn'); + echo '<br><a href="' . $rootpath . '/index.php?' . SID . '">' . _('Back to the menu') . '</a>'; + include ('includes/footer.inc'); exit; } else { header('Content-type: application/pdf'); @@ -168,10 +130,7 @@ header('Expires: 0'); header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); header('Pragma: public'); - $pdf->Output('TopItems.pdf', 'I'); } - - - /*end of else not PrintPDF */ +/*end of else not PrintPDF */ ?> \ No newline at end of file Modified: trunk/TopItems.php =================================================================== --- trunk/TopItems.php 2010-03-16 15:02:10 UTC (rev 3390) +++ trunk/TopItems.php 2010-03-17 09:33:57 UTC (rev 3391) @@ -14,7 +14,7 @@ //to view store location echo '<tr><td width="150">' . _('Select Location') . ' </td><td>:</td><td><select name=Location>'; $sql = 'SELECT loccode, - locationname + locationname FROM `locations`'; $result = DB_query($sql, $db); echo "<option value='All'>" . _('All'); @@ -25,7 +25,7 @@ //to view list of customer echo '<tr><td width="150">' . _('Select Customer Type') . ' </td><td>:</td><td><select name=Customers>'; $sql = 'SELECT typename, - typeid + typeid FROM debtortype'; $result = DB_query($sql, $db); echo "<option value='All'>" . _('All'); @@ -44,12 +44,12 @@ </tr>'; //View number of days echo '<tr><td>' . _('Number Of Days') . ' </td><td>:</td> - <td><input class="number" tabindex="3" type="Text" name=NumberOfDays size="8" maxlength="8"></td> + <td><input class="number" tabindex="3" type="Text" name=NumberOfDays size="8" maxlength="8" value=0></td> </tr>'; //view number of NumberOfTopItems items echo '<tr> <td>' . _('Number Of Top Items') . ' </td><td>:</td> - <td><input class="number" tabindex="4" type="Text" name=NumberOfTopItems size="8" maxlength="8"></td> + <td><input class="number" tabindex="4" type="Text" name=NumberOfTopItems size="8" maxlength="8" value=1></td> </tr> <tr> <td></td> @@ -62,70 +62,70 @@ //the situation if the location and customer type selected "All" if (($_POST['Location'] == "All") and ($_POST['Customers'] == "All")) { $SQL = " - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, stockmaster.units - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) - GROUP BY salesorderdetails.stkcode + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) + GROUP BY salesorderdetails.stkcode ORDER BY " . $_POST["order"] . " DESC LIMIT 0," . $_POST['NumberOfTopItems'] . ""; } else { //the situation if only location type selected "All" if ($_POST['Location'] == "All") { $SQL = " - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, stockmaster.units - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno AND debtorsmaster.typeid = '" . $_POST["Customers"] . "' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) - GROUP BY salesorderdetails.stkcode + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) + GROUP BY salesorderdetails.stkcode ORDER BY " . $_POST["order"] . " DESC LIMIT 0," . $_POST[NumberOfTopItems] . ""; } else { //the situation if the customer type selected "All" if ($_POST['Customers'] == "All") { $SQL = " - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, stockmaster.units - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno AND salesorders.fromstkloc = '" . $_POST["Location"] . "' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) - GROUP BY salesorderdetails.stkcode + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) + GROUP BY salesorderdetails.stkcode ORDER BY " . $_POST["order"] . " DESC LIMIT 0," . $_POST[NumberOfTopItems] . ""; } else { //the situation if the location and customer type not selected "All" $SQL = " - SELECT salesorderdetails.stkcode, - SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, + SELECT salesorderdetails.stkcode, + SUM(salesorderdetails.qtyinvoiced) TotalInvoiced, SUM(salesorderdetails.qtyinvoiced * salesorderdetails.unitprice ) AS ValueSales, stockmaster.description, - stockmaster.units - FROM salesorderdetails, salesorders, debtorsmaster,stockmaster + stockmaster.units + FROM salesorderdetails, salesorders, debtorsmaster,stockmaster WHERE salesorderdetails.orderno = salesorders.orderno AND salesorderdetails.stkcode = stockmaster.stockid AND salesorders.debtorno = debtorsmaster.debtorno AND salesorders.fromstkloc = '" . $_POST["Location"] . "' AND debtorsmaster.typeid = '" . $_POST['Customers'] . "' - AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) - GROUP BY salesorderdetails.stkcode + AND salesorderdetails.ActualDispatchDate >= DATE_SUB(CURDATE(), INTERVAL " . $_POST['NumberOfDays'] . " DAY) + GROUP BY salesorderdetails.stkcode ORDER BY " . $_POST["order"] . " DESC LIMIT 0," . $_POST[NumberOfTopItems] . ""; } @@ -137,12 +137,12 @@ $TableHeader = '<tr><th><strong>' . _('#') . '</strong></th> <th><strong>' . _('Code') . '</strong></th> <th><strong>' . _('Description') . '</strong></th> - <th><strong>' . _('Total Invoiced') . '</strong></th> + <th><strong>' . _('Total Invoiced') . '</strong></th> <th><strong>' . _('Units') . '</strong></th> <th><strong>' . _('Value Sales') . '</strong></th> <th><strong>' . _('On Hand') . '</strong></th>'; echo $TableHeader; - echo ' + echo ' <input type="hidden" value=' . $_POST["Location"] . ' name=location /> <input type="hidden" value=' . $_POST["order"] . ' name=order /> <input type="hidden" value=' . $_POST["NumberOfDays"] . ' name=numberofdays /> @@ -153,10 +153,10 @@ $i = 1; while ($myrow = DB_fetch_array($result)) { //find the quantity onhand item - $sqloh = "SELECT sum(quantity)as qty - FROM `locstock` + $sqloh = "SELECT sum(quantity)as qty + FROM `locstock` WHERE stockid='" . $myrow['0'] . "'"; - $oh = db_query($sqloh, $db, $ErrMsg); + $oh = db_query($sqloh, $db); $ohRow = db_fetch_row($oh); if ($k == 1) { echo '<tr class="EvenTableRows">'; @@ -185,7 +185,7 @@ echo '<div class="centre"><input type=Submit Name="PrintPDF" Value="' . _('Print To PDF') . '"></div>'; echo '</form>'; //end of the else statement - + } include ('includes/footer.inc'); ?> \ No newline at end of file Modified: trunk/doc/Change.log.html =================================================================== --- trunk/doc/Change.log.html 2010-03-16 15:02:10 UTC (rev 3390) +++ trunk/doc/Change.log.html 2010-03-17 09:33:57 UTC (rev 3391) @@ -1,5 +1,6 @@ <p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p> <p></p> +<p>17/03/10 Tim: Various layout improvements to top items report</p> <p>16/03/10 Tim: PO_SelecOSPurchOrder.php - Various layout changes for consistency and to stick to coding guidelines</p> <p>16/03/10 Anand: DateFunctions.inc - When getting the period number compare the same date formats</p> <p>16/03/10 Tim: PO_SelecOSPurchOrder.php - Correctly position link to create a new order</p> Modified: trunk/includes/PDFTopItemsHeader.inc =================================================================== --- trunk/includes/PDFTopItemsHeader.inc 2010-03-16 15:02:10 UTC (rev 3390) +++ trunk/includes/PDFTopItemsHeader.inc 2010-03-17 09:33:57 UTC (rev 3391) @@ -10,11 +10,11 @@ $XPos=0; $pdf->addJpegFromFile('companies/' . $_SESSION['DatabaseName'] . '/logo.jpg',$XPos+20,$YPos-50,0,60); -if ($_GET["customers"]!=All){ -$SQL="SELECT typename - FROM `debtortype` +if ($_GET["customers"]!='All'){ +$SQL="SELECT typename + FROM `debtortype` WHERE typeid=".$_GET["customers"].""; - + $result = DB_query($SQL,$db); $myrow=DB_fetch_array($result); $Customers=$myrow["0"]; @@ -46,12 +46,8 @@ $YPos -=(2*$line_height); /*Draw a rectangle to put the headings in */ +$pdf->Rectangle($Left_Margin, $YPos+$line_height,$Page_Width-$Left_Margin-$Right_Margin,$line_height*2); -$pdf->line($Left_Margin, $YPos+$line_height,$Page_Width-$Right_Margin, $YPos+$line_height); -$pdf->line($Left_Margin, $YPos+$line_height,$Left_Margin, $YPos- $line_height); -$pdf->line($Left_Margin, $YPos- $line_height,$Page_Width-$Right_Margin, $YPos- $line_height); -$pdf->line($Page_Width-$Right_Margin, $YPos+$line_height,$Page_Width-$Right_Margin, $YPos- $line_height); - /*set up the headings */ $Xpos = $Left_Margin+1; @@ -64,6 +60,7 @@ $FontSize=8; +$pdf->Rectangle($Left_Margin, $YPos-$line_height,$Page_Width-$Left_Margin-$Right_Margin,$YPos-$Bottom_Margin); $YPos -= (1.5 * $line_height); //$PageNumber++; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |