Menu
▾
▴
web-erp-svn
|
From: <dai...@us...> - 2014-04-06 02:47:53
|
Revision: 6673
http://sourceforge.net/p/web-erp/reponame/6673
Author: daintree
Date: 2014-04-06 02:47:50 +0000 (Sun, 06 Apr 2014)
Log Message:
-----------
Andrew Galuski mods
Added Paths:
-----------
trunk/PDFWOPrint.php
Added: trunk/PDFWOPrint.php
===================================================================
--- trunk/PDFWOPrint.php (rev 0)
+++ trunk/PDFWOPrint.php 2014-04-06 02:47:50 UTC (rev 6673)
@@ -0,0 +1,712 @@
+<?php
+
+/* $Id: PDFWOPrint.php 6146 $*/
+
+include('includes/session.inc');
+include('includes/SQL_CommonFunctions.inc');
+if (isset($_GET['WO'])) {
+ $SelectedWO = $_GET['WO'];
+} elseif (isset($_POST['WO'])){
+ $SelectedWO = $_POST['WO'];
+} else {
+ unset($SelectedWO);
+}
+if (isset($_GET['StockID'])) {
+ $StockID = $_GET['StockID'];
+} elseif (isset($_POST['StockID'])){
+ $StockID = $_POST['StockID'];
+} else {
+ unset($StockID);
+}
+
+if (isset($_GET['PrintLabels'])) {
+ $PrintLabels = $_GET['PrintLabels'];
+} elseif (isset($_POST['PrintLabels'])){
+ $PrintLabels = $_POST['LabelItem'];
+} else {
+ unset($LabelItem);
+}
+
+if (isset($_GET['LabelItem'])) {
+ $LabelItem = $_GET['LabelItem'];
+} elseif (isset($_POST['LabelItem'])){
+ $LabelItem = $_POST['LabelItem'];
+} else {
+ unset($LabelItem);
+}
+if (isset($_GET['LabelDesc'])) {
+ $LabelDesc = $_GET['LabelDesc'];
+} elseif (isset($_POST['LabelDesc'])){
+ $LabelDesc = $_POST['LabelDesc'];
+} else {
+ unset($LabelDesc);
+}
+if (isset($_GET['LabelLot'])) {
+ $LabelLot = $_GET['LabelLot'];
+} elseif (isset($_POST['LabelLot'])){
+ $LabelLot = $_POST['LabelLot'];
+} else {
+ unset($LabelLot);
+}
+if (isset($_GET['NoOfBoxes'])) {
+ $NoOfBoxes = $_GET['NoOfBoxes'];
+} elseif (isset($_POST['NoOfBoxes'])){
+ $NoOfBoxes = $_POST['NoOfBoxes'];
+} else {
+ unset($NoOfBoxes);
+}
+if (isset($_GET['LabelsPerBox'])) {
+ $LabelsPerBox = $_GET['LabelsPerBox'];
+} elseif (isset($_POST['LabelsPerBox'])){
+ $LabelsPerBox = $_POST['LabelsPerBox'];
+} else {
+ unset($LabelsPerBox);
+}
+if (isset($_GET['QtyPerBox'])) {
+ $QtyPerBox = $_GET['QtyPerBox'];
+} elseif (isset($_POST['QtyPerBox'])){
+ $QtyPerBox = $_POST['QtyPerBox'];
+} else {
+ unset($QtyPerBox);
+}
+if (isset($_GET['LeftOverQty'])) {
+ $LeftOverQty = $_GET['LeftOverQty'];
+} elseif (isset($_POST['LeftOverQty'])){
+ $LeftOverQty = $_POST['LeftOverQty'];
+} else {
+ unset($LeftOverQty);
+}
+if (isset($_GET['PrintLabels'])) {
+ $PrintLabels = $_GET['PrintLabels'];
+} elseif (isset($_POST['PrintLabels'])){
+ $PrintLabels = $_POST['PrintLabels'];
+} else {
+ $PrintLabels="Yes";
+}
+
+
+if (!isset($_GET['WO']) AND !isset($_POST['WO'])) {
+ $Title = _('Select a Work Order');
+ include('includes/header.inc');
+ echo '<div class="centre"><br /><br /><br />';
+ prnMsg(_('Select a Work Order Number to Print before calling this page'), 'error');
+ echo '<br />
+ <br />
+ <br />
+ <table class="table_index">
+ <tr><td class="menu_group_item">
+ <li><a href="' . $RootPath . '/SelectWorkOrder.php">' . _('Select Work Order') . '</a></li>
+ </td>
+ </tr></table>
+ </div>
+ <br />
+ <br />
+ <br />';
+ include('includes/footer.inc');
+ exit();
+
+ echo '<div class="centre"><br /><br /><br />' . _('This page must be called with a Work order number to print');
+ echo '<br /><a href="' . $RootPath . '/index.php">' . _('Back to the menu') . '</a></div>';
+ exit;
+}
+if (isset($_GET['WO'])) {
+ $SelectedWO = $_GET['WO'];
+}
+elseif (isset($_POST['WO'])) {
+ $SelectedWO = $_POST['WO'];
+}
+$Title = _('Print Work Order Number') . ' ' . $SelectedWO;
+if (isset($_POST['PrintOrEmail']) AND isset($_POST['EmailTo'])) {
+ if ($_POST['PrintOrEmail'] == 'Email' AND !IsEmailAddress($_POST['EmailTo'])) {
+ include('includes/header.inc');
+ prnMsg(_('The email address entered does not appear to be valid. No emails have been sent.'), 'warn');
+ include('includes/footer.inc');
+ exit;
+ }
+}
+
+/* If we are previewing the order then we dont want to email it */
+if ($SelectedWO == 'Preview') { //WO is set to 'Preview' when just looking at the format of the printed order
+ $_POST['PrintOrEmail'] = 'Print';
+ $MakePDFThenDisplayIt = True;
+} //$SelectedWO == 'Preview'
+
+if (isset($_POST['DoIt']) AND ($_POST['PrintOrEmail'] == 'Print' OR $ViewingOnly == 1)) {
+ $MakePDFThenDisplayIt = True;
+ $MakePDFThenEmailIt = False;
+} elseif (isset($_POST['DoIt']) AND $_POST['PrintOrEmail'] == 'Email' AND isset($_POST['EmailTo'])) {
+ $MakePDFThenEmailIt = True;
+ $MakePDFThenDisplayIt = False;
+}
+
+if (isset($SelectedWO) AND $SelectedWO != '' AND $SelectedWO > 0 AND $SelectedWO != 'Preview') {
+ /*retrieve the order details from the database to print */
+ $ErrMsg = _('There was a problem retrieving the Work order header details for Order Number') . ' ' . $SelectedWO . ' ' . _('from the database');
+ $sql = "SELECT workorders.wo,
+ workorders.loccode,
+ locations.locationname,
+ locations.deladd1,
+ locations.deladd2,
+ locations.deladd3,
+ locations.deladd4,
+ locations.deladd5,
+ locations.deladd6,
+ workorders.requiredby,
+ workorders.startdate,
+ workorders.closed,
+ stockmaster.description,
+ stockmaster.decimalplaces,
+ stockmaster.units,
+ stockmaster.controlled,
+ woitems.stockid,
+ woitems.qtyreqd,
+ woitems.qtyrecd,
+ woitems.comments,
+ woitems.nextlotsnref
+ FROM workorders INNER JOIN locations
+ ON workorders.loccode=locations.loccode
+ INNER JOIN woitems
+ ON workorders.wo=woitems.wo
+ INNER JOIN stockmaster
+ ON woitems.stockid=stockmaster.stockid
+ WHERE woitems.stockid='" . $StockID . "'
+ AND woitems.wo ='" . $SelectedWO . "'";
+ $result = DB_query($sql, $db, $ErrMsg);
+ if (DB_num_rows($result) == 0) {
+ /*There is no order header returned */
+ $Title = _('Print Work Order Error');
+ include('includes/header.inc');
+ echo '<div class="centre"><br /><br /><br />';
+ prnMsg(_('Unable to Locate Work Order Number') . ' : ' . $SelectedWO . ' ', 'error');
+ echo '<br />
+ <br />
+ <br />
+ <table class="table_index">
+ <tr><td class="menu_group_item">
+ <li><a href="' . $RootPath . '/SelectWorkOrder.php">' . _('Select Work Order') . '</a></li>
+ </td>
+ </tr>
+ </table>
+ </div><br /><br /><br />';
+ include('includes/footer.inc');
+ exit();
+ } elseif (DB_num_rows($result) == 1) {
+ /*There is only one order header returned (as it should be!)*/
+ $WOHeader = DB_fetch_array($result);
+ if ($WOHeader['controlled']==1) {
+ $sql = "SELECT serialno
+ FROM woserialnos
+ WHERE woserialnos.stockid='" . $StockID . "'
+ AND woserialnos.wo ='" . $SelectedWO . "'";
+ $result = DB_query($sql, $db, $ErrMsg);
+ if (DB_num_rows($result) > 0) {
+ $SerialNoArray=DB_fetch_array($result);
+ $SerialNo=$SerialNoArray[0];
+ }
+ else {
+ $SerialNo=$WOHeader['nextlotsnref'];
+ }
+ } //controlled
+ $PackQty=0;
+ $sql = "SELECT value
+ FROM stockitemproperties
+ INNER JOIN stockcatproperties
+ ON stockcatproperties.stkcatpropid=stockitemproperties.stkcatpropid
+ WHERE stockid='" . $StockID . "'
+ AND label='PackQty'";
+ $result = DB_query($sql, $db, $ErrMsg);
+ $PackQtyArray=DB_fetch_array($result);
+ $PackQty=$PackQtyArray['value'];
+ if ($PackQty==0) {
+ $PackQty=1;
+ }
+ } // 1 valid record
+} //if there is a valid order number
+else if ($SelectedWO == 'Preview') { // We are previewing the order
+
+ /* Fill the order header details with dummy data */
+ $WOHeader['comments'] = str_pad('', 1050, 'x');
+ $WOHeader['locationname'] = str_pad('', 35, 'y');
+ $SerialNo="XXXXXXXXXX";
+ $PackQty='999999999';
+ $WOHeader['requiredby'] = date('m/d/Y');
+ $WOHeader['startdate'] = date('m/d/Y');
+ $WOHeader['qtyreqd'] = '999999999';
+ $WOHeader['qtyrecd'] = '999999999';
+ $WOHeader['deladd1'] = str_pad('', 40, 'x');
+ $WOHeader['deladd2'] = str_pad('', 40, 'x');
+ $WOHeader['deladd3'] = str_pad('', 40, 'x');
+ $WOHeader['deladd4'] = str_pad('', 40, 'x');
+ $WOHeader['deladd5'] = str_pad('', 20, 'x');
+ $WOHeader['deladd6'] = str_pad('', 15, 'x');
+ $WOHeader['stockid'] = str_pad('', 15, 'x');
+ $WOHeader['description'] = str_pad('', 50, 'x');
+
+} // end of If we are previewing the order
+
+/* Load the relevant xml file */
+if (isset($MakePDFThenDisplayIt) or isset($MakePDFThenEmailIt)) {
+ if ($SelectedWO == 'Preview') {
+ $FormDesign = simplexml_load_file(sys_get_temp_dir() . '/WOPaperwork.xml');
+ } else {
+ $FormDesign = simplexml_load_file($PathPrefix . 'companies/' . $_SESSION['DatabaseName'] . '/FormDesigns/WOPaperwork.xml');
+ }
+ // Set the paper size/orintation
+ $PaperSize = $FormDesign->PaperSize;
+ include('includes/PDFStarter.php');
+ $pdf->addInfo('Title', _('Work Order'));
+ $pdf->addInfo('Subject', _('Work Order Number') . ' ' . $SelectedWO);
+ $line_height = $FormDesign->LineHeight;
+ $PageNumber = 1;
+
+ if ($SelectedWO != 'Preview') { // It is a real order
+ $ErrMsg = _('There was a problem retrieving the line details for order number') . ' ' . $SelectedWO . ' ' . _('from the database');
+ $RequirmentsResult = DB_query("SELECT worequirements.stockid,
+ stockmaster.description,
+ stockmaster.decimalplaces,
+ autoissue,
+ qtypu,
+ controlled
+ FROM worequirements INNER JOIN stockmaster
+ ON worequirements.stockid=stockmaster.stockid
+ WHERE wo='" . $SelectedWO . "'
+ AND worequirements.parentstockid='" . $StockID . "'",
+ $db);
+ $IssuedAlreadyResult = DB_query("SELECT stockid,
+ SUM(-qty) AS total
+ FROM stockmoves
+ WHERE stockmoves.type=28
+ AND reference='".$SelectedWO."'
+ GROUP BY stockid",$db);
+ while ($IssuedRow = DB_fetch_array($IssuedAlreadyResult)){
+ $IssuedAlreadyRow[$IssuedRow['stockid']] = $IssuedRow['total'];
+ }
+ $i=0;
+ $WOLine=array();
+ while ($RequirementsRow = DB_fetch_array($RequirmentsResult)){
+ if ($RequirementsRow['autoissue']==0){
+ $WOLine[$i][action]='Manual Issue';
+ } else {
+ $WOLine[$i][action]='Auto Issue';
+ }
+ if (isset($IssuedAlreadyRow[$RequirementsRow['stockid']])){
+ $Issued = $IssuedAlreadyRow[$RequirementsRow['stockid']];
+ unset($IssuedAlreadyRow[$RequirementsRow['stockid']]);
+ }else{
+ $Issued = 0;
+ }
+ $WOLine[$i]['item'] = $RequirementsRow['stockid'];
+ $WOLine[$i]['description'] = $RequirementsRow['description'];
+ $WOLine[$i]['controlled'] = $RequirementsRow['controlled'];
+ $WOLine[$i]['qtyreqd'] = $WOHeader['qtyreqd']*$RequirementsRow['qtypu'];
+ $WOLine[$i]['issued'] = $Issued ;
+ $WOLine[$i]['decimalplaces'] = $RequirementsRow['decimalplaces'];
+ $i+=1;
+ }
+ /* Now do any additional issues of items not in the BOM */
+ if(count($IssuedAlreadyRow)>0){
+ $AdditionalStocks = implode("','",array_keys($IssuedAlreadyRow));
+ $RequirementsSQL = "SELECT stockid,
+ description,
+ decimalplaces,
+ controlled
+ FROM stockmaster WHERE stockid IN ('".$AdditionalStocks."')";
+ $RequirementsResult = DB_query($RequirementsSQL,$db);
+ $AdditionalStocks = array();
+ while($myrow = DB_fetch_array($RequirementsResult)){
+ $WOLine[$i]['action']='Additional Issue';
+ $WOLine[$i]['item'] = $myrow['stockid'];
+ $WOLine[$i]['description'] = $myrow['description'];
+ $WOLine[$i]['controlled'] = $myrow['controlled'];
+ $WOLine[$i]['qtyreqd'] = 0;
+ $WOLine[$i]['issued'] = $IssuedAlreadyRow[$myrow['stockid']];
+ $WOLine[$i]['decimalplaces'] = $RequirementsRow['decimalplaces'];
+ $i+=1;
+ }
+ }
+
+ }
+ if ($SelectedWO == 'Preview' or $i > 0) {
+ /*Yes there are line items to start the ball rolling with a page header */
+ include('includes/PDFWOPageHeader.inc');
+ $YPos = $Page_Height - $FormDesign->Data->y;
+ $i=0;
+ while ((isset($SelectedWO) AND $SelectedWO == 'Preview') OR (count($WOLine) > $i )) {
+ if ($SelectedWO == 'Preview') {
+ $WOLine[$i]['action'] = str_pad('', 20, 'x');
+ $WOLine[$i]['item'] = str_pad('', 10, 'x');
+ $WOLine[$i]['description'] = str_pad('', 50, 'x');
+ $WOLine[$i]['qtyreqd'] = 9999999.99;
+ $WOLine[$i]['issued'] = 9999999.99;
+ $WOLine[$i]['decimalplaces'] = 2;
+ }
+ if ($WOLine['decimalplaces'] != NULL) {
+ $DecimalPlaces = $WOLine[$i]['decimalplaces'];
+ }
+ else {
+ $DecimalPlaces = 2;
+ }
+ //echo $WOLine[$i]['item'] . ' ' . $WOLine[$i]['controlled'] . '<br>';
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column1->x, $YPos, $FormDesign->Data->Column1->Length, $FormDesign->Data->Column1->FontSize, $WOLine[$i]['action'], 'left');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column2->x, $YPos, $FormDesign->Data->Column2->Length, $FormDesign->Data->Column2->FontSize, $WOLine[$i]['item'], 'left');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $WOLine[$i]['description'], 'left');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column4->x, $YPos, $FormDesign->Data->Column4->Length, $FormDesign->Data->Column4->FontSize, locale_number_format($WOLine[$i]['qtyreqd'],$WOLine[$i]['decimalplaces']), 'right');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column5->x, $YPos, $FormDesign->Data->Column5->Length, $FormDesign->Data->Column5->FontSize, locale_number_format($WOLine[$i]['issued'],$WOLine[$i]['decimalplaces']), 'right');
+
+ $YPos -= $line_height;
+ if ($YPos - (2*$line_height) <= $Page_Height - $FormDesign->Comments->y) {
+ $PageNumber++;
+ $YPos = $Page_Height - $FormDesign->Data->y;
+ include('includes/PDFWOPageHeader.inc');
+ }
+
+ /*display already issued and available qty and lots where applicable*/
+
+ $IssuedAlreadyDetail = DB_query("SELECT stockmoves.stockid,
+ SUM(qty) as qty,
+ stockserialmoves.serialno,
+ sum(stockserialmoves.moveqty) as moveqty,
+ locations.locationname
+ FROM stockmoves LEFT OUTER JOIN stockserialmoves
+ ON stockmoves.stkmoveno= stockserialmoves.stockmoveno
+ INNER JOIN locations
+ ON stockmoves.loccode=locations.loccode
+ WHERE stockmoves.type=28
+ AND stockmoves.stockid = '".$WOLine[$i]['item']."'
+ AND reference='".$SelectedWO."'
+ GROUP BY stockserialmoves.serialno",$db);
+ while ($IssuedRow = DB_fetch_array($IssuedAlreadyDetail)){
+ if ($WOLine[$i]['controlled']) {
+ $CurLot=$IssuedRow['serialno'];
+ $CurQty=-$IssuedRow['moveqty'];
+ }
+ else {
+ $CurLot=$IssuedRow['locationname'];
+ $CurQty=-$IssuedRow['qty'];
+ }
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $CurLot, 'left');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column5->x, $YPos, $FormDesign->Data->Column5->Length, $FormDesign->Data->Column5->FontSize, $CurQty, 'right');
+ $YPos -= $line_height;
+ if ($YPos - (2*$line_height) <= $Page_Height - $FormDesign->Comments->y) {
+ $PageNumber++;
+ $YPos = $Page_Height - $FormDesign->Data->y;
+ include('includes/PDFWOPageHeader.inc');
+ }
+ }
+
+ if ($WOLine[$i]['issued'] <= $WOLine[$i]['qtyreqd']) {
+ $AvailQty = DB_query("SELECT locstock.loccode,
+ locstock.bin,
+ locstock.quantity,
+ serialno,
+ stockserialitems.quantity as qty
+ FROM locstock LEFT OUTER JOIN stockserialitems
+ ON locstock.loccode=stockserialitems.loccode AND locstock.stockid = stockserialitems.stockid
+ WHERE locstock.loccode='".$WOHeader['loccode']."'
+ AND locstock.stockid='".$WOLine[$i]['item']."'",$db);
+ while ($ToIssue = DB_fetch_array($AvailQty)){
+ if ($WOLine[$i]['controlled']) {
+ $CurLot=$ToIssue['serialno'];
+ $CurQty=$ToIssue['qty'];
+ }
+ else {
+ $CurLot=substr($WOHeader['locationname'] . ' ' . $ToIssue['bin'],0,34);
+ $CurQty=$ToIssue['quantity'];
+ }
+ if ($CurQty > 0) {
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $CurLot, 'left');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $CurQty, 'right');
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column5->x, $YPos, $FormDesign->Data->Column5->Length, $FormDesign->Data->Column5->FontSize, '________', 'right');
+ $YPos -= $line_height;
+ if ($YPos - (2*$line_height) <= $Page_Height - $FormDesign->Comments->y) {
+ $PageNumber++;
+ $YPos = $Page_Height - $FormDesign->Data->y;
+ include('includes/PDFWOPageHeader.inc');
+ }
+ //echo $CurLot . ' ' . $CurQty . '<br>';
+ }
+ }
+ } //not all issued
+ if ($SelectedWO == 'Preview') {
+ $SelectedWO = 'Preview_WorkOrder';
+ } //$SelectedWO == 'Preview'
+ $i+=1;
+ $YPos -= $line_height; /*extra line*/
+ if ($YPos - (2*$line_height) <= $Page_Height - $FormDesign->Comments->y) {
+ $PageNumber++;
+ $YPos = $Page_Height - $FormDesign->Data->y;
+ include('includes/PDFWOPageHeader.inc');
+ }
+ } //end while there are line items to print out
+
+ if ($YPos - (2*$line_height) <= $Page_Height - $FormDesign->Comments->y) { // need to ensure space for totals
+ $PageNumber++;
+ include('includes/PDFWOPageHeader.inc');
+ } //end if need a new page headed up
+ } /*end if there are order details to show on the order - or its a preview*/
+ if($FooterPrintedInPage == 0){
+ $LeftOvers = $pdf->addText($FormDesign->SignedDate->x,$Page_Height-$FormDesign->SignedDate->y,$FormDesign->SignedDate->FontSize, _('Date : ') . '______________');
+ $LeftOvers = $pdf->addText($FormDesign->SignedBy->x,$Page_Height-$FormDesign->SignedBy->y,$FormDesign->SignedBy->FontSize, _('Signed for: ').'____________________________________');
+ $FooterPrintedInPage= 1;
+ }
+
+ $PrintingComments=true;
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Comments->x, $Page_Height - $FormDesign->Comments->y,$FormDesign->Comments->Length,$FormDesign->Comments->FontSize, $WOHeader['comments'], 'left');
+ $YPos=$Page_Height - $FormDesign->Comments->y;
+ while (mb_strlen($LeftOvers) > 1) {
+ $YPos -= $line_height;
+ if ($YPos - $line_height <= $Bottom_Margin) {
+ $PageNumber++;
+ $YPos = $Page_Height - $FormDesign->Headings->Column1->y;
+ include('includes/PDFWOPageHeader.inc');
+ }
+ $LeftOvers = $pdf->addTextWrap($FormDesign->Comments->x, $YPos,$FormDesign->Comments->Length,$FormDesign->Comments->FontSize, $LeftOvers, 'left');
+ }
+
+ $Success = 1; //assume the best and email goes - has to be set to 1 to allow update status
+ if ($MakePDFThenDisplayIt) {
+ $pdf->OutputD($_SESSION['DatabaseName'] . '_WorkOrder_' . $SelectedWO . '_' . date('Y-m-d') . '.pdf');
+ $pdf->__destruct();
+ } else {
+ $PdfFileName = $_SESSION['DatabaseName'] . '_WorkOrder_' . $SelectedWO . '_' . date('Y-m-d') . '.pdf';
+ $pdf->Output($_SESSION['reports_dir'] . '/' . $PdfFileName, 'F');
+ $pdf->__destruct();
+ include('includes/htmlMimeMail.php');
+ $mail = new htmlMimeMail();
+ $attachment = $mail->getFile($_SESSION['reports_dir'] . '/' . $PdfFileName);
+ $mail->setText(_('Please Process this Work order number') . ' ' . $SelectedWO);
+ $mail->setSubject(_('Work Order Number') . ' ' . $SelectedWO);
+ $mail->addAttachment($attachment, $PdfFileName, 'application/pdf');
+ //since sometime the mail server required to verify the users, so must set this information.
+ if($_SESSION['SmtpSetting'] == 0){//use the mail service provice by the server.
+ $mail->setFrom($_SESSION['CompanyRecord']['coyname'] . '<' . $_SESSION['CompanyRecord']['email'] . '>');
+ $Success = $mail->send(array($_POST['EmailTo']));
+ }else if($_SESSION['SmtpSetting'] == 1) {
+ $Success = SendmailBySmtp($mail,array($_POST['EmailTo']));
+
+ }else{
+ prnMsg(_('The SMTP settings are wrong, please ask administrator for help'),'error');
+ exit;
+ include('includes/footer.inc');
+ }
+
+ if ($Success == 1) {
+ $Title = _('Email a Work Order');
+ include('includes/header.inc');
+ echo '<div class="centre"><br /><br /><br />';
+ prnMsg(_('Work Order') . ' ' . $SelectedWO . ' ' . _('has been emailed to') . ' ' . $_POST['EmailTo'] . ' ' . _('as directed'), 'success');
+
+ } else { //email failed
+ $Title = _('Email a Work Order');
+ include('includes/header.inc');
+ echo '<div class="centre"><br /><br /><br />';
+ prnMsg(_('Emailing Work order') . ' ' . $SelectedWO . ' ' . _('to') . ' ' . $_POST['EmailTo'] . ' ' . _('failed'), 'error');
+ }
+ }
+ include('includes/footer.inc');
+} //isset($MakePDFThenDisplayIt) OR isset($MakePDFThenEmailIt)
+
+/* There was enough info to either print or email the Work order */
+else {
+ /**
+ /*the user has just gone into the page need to ask the question whether to print the order or email it */
+ include('includes/header.inc');
+
+ if (!isset($LabelItem)) {
+ $sql = "SELECT workorders.wo,
+ stockmaster.description,
+ stockmaster.decimalplaces,
+ stockmaster.units,
+ stockmaster.controlled,
+ woitems.stockid,
+ woitems.qtyreqd,
+ woitems.nextlotsnref
+ FROM workorders INNER JOIN woitems
+ ON workorders.wo=woitems.wo
+ INNER JOIN stockmaster
+ ON woitems.stockid=stockmaster.stockid
+ WHERE woitems.stockid='" . $StockID . "'
+ AND woitems.wo ='" . $SelectedWO . "'";
+
+ $result = DB_query($sql, $db, $ErrMsg);
+ $Labels = DB_fetch_array($result);
+ $LabelItem=$Labels['stockid'];
+ $LabelDesc=$Labels['description'];
+ $QtyPerBox=0;
+ $sql = "SELECT value
+ FROM stockitemproperties
+ INNER JOIN stockcatproperties
+ ON stockcatproperties.stkcatpropid=stockitemproperties.stkcatpropid
+ WHERE stockid='" . $StockID . "'
+ AND label='PackQty'";
+ $result = DB_query($sql, $db, $ErrMsg);
+ $PackQtyArray=DB_fetch_array($result);
+ $QtyPerBox=$PackQtyArray['value'];
+ if ($QtyPerBox==0) {
+ $QtyPerBox=1;
+ }
+ $NoOfBoxes=(int)($Labels['qtyreqd'] / $QtyPerBox);
+ $LeftOverQty=$Labels['qtyreqd'] % $QtyPerBox;
+ $LabelsPerBox=1;
+ $QtyPerBox=locale_number_format($QtyPerBox, $Labels['decimalplaces']);
+ $LeftOverQty=locale_number_format($LeftOverQty, $Labels['decimalplaces']);
+ if ($Labels['controlled']==1) {
+ $sql = "SELECT serialno
+ FROM woserialnos
+ WHERE woserialnos.stockid='" . $StockID . "'
+ AND woserialnos.wo ='" . $SelectedWO . "'";
+ $result = DB_query($sql, $db, $ErrMsg);
+ if (DB_num_rows($result) > 0) {
+ $SerialNoArray=DB_fetch_array($result);
+ $LabelLot=$SerialNoArray[0];
+ }
+ else {
+ $LabelLot=$WOHeader['nextlotsnref'];
+ }
+ } //controlled
+ } //not set yet
+ echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8') . '" method="post">';
+ echo '<div>';
+ echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
+ if ($ViewingOnly == 1) {
+ echo '<input type="hidden" name="ViewingOnly" value="1" />';
+ } //$ViewingOnly == 1
+ echo '<br /><br />';
+ echo '<input type="hidden" name="WO" value="' . $SelectedWO . '" />';
+ echo '<input type="hidden" name="StockID" value="' . $StockID . '" />';
+ echo '<table>
+ <tr>
+ <td>' . _('Print or Email the Order') . '</td>
+ <td><select name="PrintOrEmail">';
+
+ if (!isset($_POST['PrintOrEmail'])) {
+ $_POST['PrintOrEmail'] = 'Print';
+ }
+ if ($ViewingOnly != 0) {
+ echo '<option selected="selected" value="Print">' . _('Print') . '</option>';
+ }
+ else {
+ if ($_POST['PrintOrEmail'] == 'Print') {
+ echo '<option selected="selected" value="Print">' . _('Print') . '</option>';
+ echo '<option value="Email">' . _('Email') . '</option>';
+ } else {
+ echo '<option value="Print">' . _('Print') . '</option>';
+ echo '<option selected="selected" value="Email">' . _('Email') . '</option>';
+ }
+ }
+ echo '</select></td></tr>';
+ echo '<tr><td>' . _('Print Labels') . ':</td><td><select name="PrintLabels" >';
+ if ($PrintLabels=="Yes") {
+ echo '<option value="Yes" selected>' . _('Yes') . '</option>';
+ echo '<option value="No">' . _('No') . '</option>';
+ }
+ else {
+ echo '<option value="Yes" >' . _('Yes') . '</option>';
+ echo '<option value="No" selected>' . _('No') . '</option>';
+ }
+ echo '</select>';
+
+ if ($_POST['PrintOrEmail'] == 'Email') {
+ $ErrMsg = _('There was a problem retrieving the contact details for the location');
+
+ $SQL = "SELECT workorders.wo,
+ workorders.loccode,
+ locations.email
+ FROM workorders INNER JOIN locations
+ ON workorders.loccode=locations.loccode
+ INNER JOIN woitems
+ ON workorders.wo=woitems.wo
+ WHERE woitems.stockid='" . $StockID . "'
+ AND woitems.wo ='" . $SelectedWO . "'";
+ $ContactsResult = DB_query($SQL, $db, $ErrMsg);
+ if (DB_num_rows($ContactsResult) > 0) {
+ echo '<tr><td>' . _('Email to') . ':</td><td><input name="EmailTo" value="';
+ while ($ContactDetails = DB_fetch_array($ContactsResult)) {
+ if (mb_strlen($ContactDetails['email']) > 2 AND mb_strpos($ContactDetails['email'], '@') > 0) {
+ echo $ContactDetails['email'];
+ }
+ }
+ echo '"/></td></tr></table>';
+ }
+
+ } else {
+ echo '</table>';
+ }
+ echo '<br />
+ <div class="centre">
+ <input type="submit" name="DoIt" value="' . _('Paperwork') . '" />
+ </div>
+ </div>
+ </form>';
+
+ if ($PrintLabels=="Yes") {
+ echo '<form action="PDFFGLabel.php" method="post">';
+ echo '<div>';
+ echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />';
+ if ($ViewingOnly == 1) {
+ echo '<input type="hidden" name="ViewingOnly" value="1" />';
+ } //$ViewingOnly == 1
+ echo '<br /><br />';
+ echo '<input type="hidden" name="WO" value="' . $SelectedWO . '" />';
+ echo '<input type="hidden" name="StockID" value="' . $StockID . '" />';
+ echo '<input type="hidden" name="EmailTo" value="' . $EmailTo . '" />';
+ echo '<input type="hidden" name="PrintOrEmail" value="' . $_POST['PrintOrEmail'] . '" />';
+ echo '<table><tr><td>' . _('Label Item') . ':</td><td><input name="LabelItem" value="' .$LabelItem.'"/></td></tr>';
+ echo '<tr><td>' . _('Label Description') . ':</td><td><input name="LabelDesc" value="' .$LabelDesc.'"/></td></tr>';
+ echo '<tr><td>' . _('Label Lot') . ':</td><td><input name="LabelLot" value="' .$LabelLot.'"/></td></tr>';
+ echo '<tr><td>' . _('No of Full Packages') . ':</td><td><input name="NoOfBoxes" class="integer" value="' .$NoOfBoxes.'"/></td></tr>';
+ echo '<tr><td>' . _('Labels/Package') . ':</td><td><input name="LabelsPerBox" class="integer" value="' .$LabelsPerBox.'"/></td></tr>';
+ echo '<tr><td>' . _('Weight/Package') . ':</td><td><input name="QtyPerBox" class="number" value="' .$QtyPerBox. '"/></td></tr>';
+ echo '<tr><td>' . _('LeftOver Qty') . ':</td><td><input name="LeftOverQty" class="number" value="' .$LeftOverQty.'"/></td></tr>';
+ echo '<tr>
+ <td>' . _('Print or Email the Order') . '</td>
+ <td><select name="PrintOrEmail">';
+
+ if (!isset($_POST['PrintOrEmail'])) {
+ $_POST['PrintOrEmail'] = 'Print';
+ }
+ if ($ViewingOnly != 0) {
+ echo '<option selected="selected" value="Print">' . _('Print') . '</option>';
+ }
+ else {
+ if ($_POST['PrintOrEmail'] == 'Print') {
+ echo '<option selected="selected" value="Print">' . _('Print') . '</option>';
+ echo '<option value="Email">' . _('Email') . '</option>';
+ } else {
+ echo '<option value="Print">' . _('Print') . '</option>';
+ echo '<option selected="selected" value="Email">' . _('Email') . '</option>';
+ }
+ }
+ echo '</select></td></tr>';
+ $SQL = "SELECT workorders.wo,
+ workorders.loccode,
+ locations.email
+ FROM workorders INNER JOIN locations
+ ON workorders.loccode=locations.loccode
+ INNER JOIN woitems
+ ON workorders.wo=woitems.wo
+ WHERE woitems.stockid='" . $StockID . "'
+ AND woitems.wo ='" . $SelectedWO . "'";
+ $ContactsResult = DB_query($SQL, $db, $ErrMsg);
+ if (DB_num_rows($ContactsResult) > 0) {
+ echo '<tr><td>' . _('Email to') . ':</td><td><input name="EmailTo" value="';
+ while ($ContactDetails = DB_fetch_array($ContactsResult)) {
+ if (mb_strlen($ContactDetails['email']) > 2 AND mb_strpos($ContactDetails['email'], '@') > 0) {
+ echo $ContactDetails['email'];
+ }
+ }
+ echo '"/></td></tr></table>';
+ }
+ else {
+ echo '</table>';
+ }
+ echo '<br />
+ <div class="centre">
+ <input type="submit" name="DoIt" value="' . _('Labels') . '" />
+ </div>
+ </div>
+ </form>';
+ }
+ include('includes/footer.inc');
+}
+?>
|
|
From: <ex...@us...> - 2015-11-26 07:13:51
|
Revision: 7400
http://sourceforge.net/p/web-erp/reponame/7400
Author: exsonqu
Date: 2015-11-26 07:13:48 +0000 (Thu, 26 Nov 2015)
Log Message:
-----------
26/11/15 Exson: Fixed the rounding error caused extra lines on WO pdf file and 2 number display without locale format in PDFWOPrint.php.
Modified Paths:
--------------
trunk/PDFWOPrint.php
Modified: trunk/PDFWOPrint.php
===================================================================
--- trunk/PDFWOPrint.php 2015-11-26 01:03:48 UTC (rev 7399)
+++ trunk/PDFWOPrint.php 2015-11-26 07:13:48 UTC (rev 7400)
@@ -340,7 +340,7 @@
$WOLine[$i]['issued'] = 9999999.99;
$WOLine[$i]['decimalplaces'] = 2;
}
- if ($WOLine['decimalplaces'] != NULL) {
+ if ($WOLine[$i]['decimalplaces'] != NULL) {
$DecimalPlaces = $WOLine[$i]['decimalplaces'];
}
else {
@@ -407,13 +407,15 @@
while ($ToIssue = DB_fetch_array($AvailQty)){
if ($WOLine[$i]['controlled']) {
$CurLot=$ToIssue['serialno'];
- $CurQty=$ToIssue['qty'];
+ $CurQty=locale_number_format($ToIssue['qty'],$DecimalPlaces);
}
else {
$CurLot=substr($WOHeader['locationname'] . ' ' . $ToIssue['bin'],0,34);
- $CurQty=$ToIssue['quantity'];
+ $CurQty=locale_number_format($ToIssue['quantity'],$DecimalPlaces);
}
- if ($CurQty > 0) {
+ //remove display of very small number raised due to rounding error
+ $MinalQtyAllowed = 1/pow(10,$DecimalPlaces)/10;
+ if ($CurQty > $MinalQtyAllowed) {
$LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $CurLot, 'left');
$LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column3->x, $YPos, $FormDesign->Data->Column3->Length, $FormDesign->Data->Column3->FontSize, $CurQty, 'right');
$LeftOvers = $pdf->addTextWrap($FormDesign->Data->Column5->x, $YPos, $FormDesign->Data->Column5->Length, $FormDesign->Data->Column5->FontSize, '________', 'right');
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X