This is a mod to the PDF Price List and selection screen.


Adds a selection dialog to PDFPriceList.php to choose to display "In Stock Items Only".

Now you can choose to display a price list for either all stock items, or just items that are in stock currently.

diff PDFPriceList.php.orig PDFPriceList.php
53c53,54
<                       custbranch.brname
---
>                       custbranch.brname,
>                       locstock.quantity
55a57
>                               locstock,
64a67,68
>                       AND locstock.stockid=stockmaster.stockid
>                       AND locstock.quantity > 0
69c73,105
<       } else { /* the sales type list only */
---
>       } else  /*  this is for Items in Stock only*/
>
>       if ($_POST['InStock']==_('In Stock Only')){
>
>                       $SQL = "SELECT sales_type FROM salestypes WHERE typeabbrev='" . $_POST['SalesType'] . "'";
>               $SalesTypeResult = DB_query($SQL,$db);
>               $SalesTypeRow = DB_fetch_row($SalesTypeResult);
>               $SalesTypeName = $SalesTypeRow[0];
>
>               $SQL = "SELECT prices.typeabbrev,
>                               prices.stockid,
>                               stockmaster.description,
>                               prices.currabrev,
>                               prices.price,
>                               stockmaster.materialcost+stockmaster.labourcost+stockmaster.overheadcost as standardcost,
>                               stockmaster.categoryid,
>                               stockcategory.categorydescription,
>                               locstock.quantity
>                       FROM prices,
>                               stockmaster,
>                               stockcategory,
>                               locstock
>                       WHERE stockmaster.stockid=prices.stockid
>                       AND stockmaster.categoryid=stockcategory.categoryid
>                       AND stockmaster.categoryid >= '" . $_POST['FromCriteria'] . "'
>                       AND stockmaster.categoryid <= '" . $_POST['ToCriteria'] . "'
>                       AND prices.typeabbrev='" . $_POST['SalesType'] . "'
>                       AND prices.debtorno=''
>                       AND locstock.stockid=stockmaster.stockid
>                       AND locstock.quantity > 0
>                       ORDER BY prices.currabrev,
>                               stockmaster.categoryid,
>                               stockmaster.stockid";
70a107
> } else { /* the sales type list only */
121c158,160
<                       $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,300-$Left_Margin,$FontSize, $PriceList['currabrev'] . ' ' . _('Prices'));
---
>                       $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,450-$Left_Margin,$FontSize, $PriceList['currabrev'] . ' ' . _('Prices, All prices are ex-warehouse only.  Limited stock at-hand, call to confirm.'));
>                       $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos-10,450-$Left_Margin,$FontSize, _('Prices subject to change without notice.'));
>                       $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos-20,450-$Left_Margin,$FontSize, _('Prices valid for 30 days, or until sold out.  Call for custom work pricing.'));
140c179
<               $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,60,$FontSize,$PriceList['stockid']);                                  $LeftOvers = $pdf->addTextWrap(120,$YPos,260,$FontSize,$PriceList['description']);
---
>               $LeftOvers = $pdf->addTextWrap($Left_Margin,$YPos,100,$FontSize,$PriceList['stockid']);                                 $LeftOvers = $pdf->addTextWrap(170,$YPos,260,$FontSize,$PriceList['description']);
152c191
<               $DisplayUnitPrice = number_format($PriceList['price'],2);
---
>               $DisplayUnitPrice = "$" . number_format($PriceList['price'],2) . " ex tax";
158a198
>               $LeftOvers = $pdf->addTextWrap(480,$YPos,60,$FontSize,$DisplayUnitPrice, 'right');
160,161c200,204
<
<               $LeftOvers = $pdf->addTextWrap(440,$YPos,60,$FontSize,$DisplayUnitPrice, 'right');
---
> if ($_POST['InStock']=='In Stock Only'){
>               //print stock status
>               $InStock = number_format($PriceList['quantity'],2) . " m2";
>               $LeftOvers = $pdf->addTextWrap(350,$YPos,60,$FontSize,$InStock, 'right');
>               }
244a288,291
>               echo '<TR><TD>' . _('In Stock Items Only'). ':</TD><TD><SELECT name="InStock">';
>               echo '<OPTION  Value="In Stock Only">'. _('In Stock Only');
>               echo '<OPTION SELECTED Value="All Stock Items">'. _('All Stock Items');
>               echo '</SELECT></TD></TR>';
250c297
< ?>
\ No newline at end of file
---
> ?>
Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads