From: <vv...@us...> - 2012-04-28 19:41:52
|
Revision: 5293 http://web-erp.svn.sourceforge.net/web-erp/?rev=5293&view=rev Author: vvs2012 Date: 2012-04-28 19:41:43 +0000 (Sat, 28 Apr 2012) Log Message: ----------- xhtml Modified Paths: -------------- trunk/SuppLoginSetup.php trunk/SuppPaymentRun.php trunk/SuppPriceList.php trunk/SuppShiptChgs.php trunk/SuppTransGLAnalysis.php trunk/SupplierTenderCreate.php trunk/SupplierTransInquiry.php trunk/SupplierTypes.php trunk/Suppliers.php trunk/SystemParameters.php trunk/Tax.php trunk/TaxAuthorities.php trunk/TaxAuthorityRates.php trunk/TaxCategories.php trunk/TaxGroups.php trunk/TaxProvinces.php trunk/TopItems.php trunk/UnitsOfMeasure.php trunk/UpgradeDatabase.php trunk/UserSettings.php trunk/WOSerialNos.php trunk/WWW_Access.php trunk/WWW_Users.php trunk/WhereUsedInquiry.php trunk/WorkCentres.php trunk/WorkOrderCosting.php trunk/WorkOrderEntry.php trunk/WorkOrderIssue.php trunk/WorkOrderStatus.php trunk/includes/MainMenuLinksArray.php Modified: trunk/SuppLoginSetup.php =================================================================== --- trunk/SuppLoginSetup.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SuppLoginSetup.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -109,6 +109,7 @@ } echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '">'; +echo '<div>'; echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; @@ -133,7 +134,7 @@ } echo '<tr> <td>' . _('Password') . ':</td> - <td><input type="password" name="Password" size="22" maxlength="20" value="' . $_POST['Password'] . '" /> + <td><input type="password" name="Password" size="22" maxlength="20" value="' . $_POST['Password'] . '" /></td> </tr> <tr> <td>' . _('Full Name') . ':</td> @@ -178,8 +179,10 @@ } if (!$FoundTheSupplierRole){ + echo '</table> + </div> + </form>'; prnMsg(_('The supplier login role is expected to contain just one token - number 9. There is no such role currently defined - so a supplier login cannot be set up until this role is defined'),'error'); - echo '</table>'; include('includes/footer.inc'); exit; } @@ -292,6 +295,7 @@ <div class="centre"> <input type="submit" name="submit" value="' . _('Enter Information') . '" /> </div> + </div> </form>'; echo '<script type="text/javascript">defaultControl(document.forms[0].UserID);</script>'; Modified: trunk/SuppPaymentRun.php =================================================================== --- trunk/SuppPaymentRun.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SuppPaymentRun.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -246,9 +246,10 @@ /* show form to allow input */ - echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post"> - <table class="selection">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post">'; + echo '<div>'; + echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + echo '<table class="selection">'; if (!isset($_POST['FromCriteria']) or mb_strlen($_POST['FromCriteria'])<1){ $DefaultFromCriteria = '1'; @@ -384,7 +385,8 @@ <input type="submit" name="PrintPDF" value="' . _('Print PDF Only') . '" /> <input type="submit" name="PrintPDFAndProcess" value="' . _('Print and Process Payments') . '" /> </div>'; - + echo '</div> + </form>'; include ('includes/footer.inc'); } /*end of else not PrintPDF */ ?> \ No newline at end of file Modified: trunk/SuppPriceList.php =================================================================== --- trunk/SuppPriceList.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SuppPriceList.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -203,9 +203,9 @@ echo '<div class="page_help_text">' . _('View the Price List from supplier') . '</div><br />'; echo '<br/> - <form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post"> - <table>'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + <form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post">'; + echo '<div>'; + echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; $sql = "SELECT supplierid,suppname FROM `suppliers`"; $result = DB_query($sql,$db); @@ -255,6 +255,8 @@ <input type="submit" name="PrintPDF" value="' . _('Print PDF') . '" /> </div>'; + echo '</div> + </form>'; include('includes/footer.inc'); } /*end of else not PrintPDF */ Modified: trunk/SuppShiptChgs.php =================================================================== --- trunk/SuppShiptChgs.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SuppShiptChgs.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -94,13 +94,14 @@ } echo '<tr> - <td class="number"><font size="2" color=navy>' . _('Total') . ':</font></td> - <td class="number"><font size="2" color=navy><U>' . locale_number_format($TotalShiptValue,2) . '</U></font></td> + <td class="number">' . _('Total') . ':</td> + <td class="number">' . locale_number_format($TotalShiptValue,2) . '</td> </tr> </table><br />'; /*Set up a form to allow input of new Shipment charges */ 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 (!isset($_POST['ShiptRef'])) { @@ -152,6 +153,7 @@ <div class="centre"> <input type="submit" name="AddShiptChgToInvoice" value="' . _('Enter Shipment Charge') . '" /> </div> + </div> </form>'; include('includes/footer.inc'); Modified: trunk/SuppTransGLAnalysis.php =================================================================== --- trunk/SuppTransGLAnalysis.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SuppTransGLAnalysis.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -131,8 +131,8 @@ } echo '<tr> - <td colspan="2" class="number"><font size="4" color="blue">' . _('Total') . ':</font></td> - <td class="number"><font size="2" color="navy"><u>' . locale_number_format($TotalGLValue,$_SESSION['SuppTrans']->CurrDecimalPlaces) . '</u></font></td> + <td colspan="2" class="number">' . _('Total') . ':</td> + <td class="number">' . locale_number_format($TotalGLValue,$_SESSION['SuppTrans']->CurrDecimalPlaces) . '</td> </tr> </table>'; @@ -150,6 +150,7 @@ /*Set up a form to allow input of new GL entries */ echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '" method="post">'; +echo '<div>'; echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; echo '<br /> @@ -159,8 +160,8 @@ } echo '<tr> <td>' . _('Account Code') . ':</td> - <td><input type="text" name="GLCode" size="12" maxlength="11" value="' . $_POST['GLCode'] . '" /></td> - <input type="hidden" name="JobRef" value="" /> + <td><input type="text" name="GLCode" size="12" maxlength="11" value="' . $_POST['GLCode'] . '" /> + <input type="hidden" name="JobRef" value="" /></td> </tr>'; echo '<tr> <td>' . _('Account Selection') . ': @@ -178,7 +179,7 @@ } else { echo '<option value="'; } - echo $myrow['accountcode'] . '">' . $myrow['accountcode'] . ' - ' . $myrow['accountname'] . '</option>'; + echo $myrow['accountcode'] . '">' . $myrow['accountcode'] . ' - ' . htmlspecialchars($myrow['accountname'], ENT_QUOTES, 'UTF-8', false) . '</option>'; } echo '</select> @@ -206,6 +207,7 @@ <input type="submit" name="AddGLCodeToTrans" value="' . _('Enter GL Line') . '" /> </div>'; -echo '</form>'; +echo '</div> + </form>'; include('includes/footer.inc'); ?> \ No newline at end of file Modified: trunk/SupplierTenderCreate.php =================================================================== --- trunk/SupplierTenderCreate.php 2012-04-28 13:20:43 UTC (rev 5292) +++ trunk/SupplierTenderCreate.php 2012-04-28 19:41:43 UTC (rev 5293) @@ -1,865 +1,875 @@ -<?php -/* $Id: SupplierTenderCreate.php 4821 2012-01-20 13:48:53Z tim_schofield $ */ - -include('includes/DefineTenderClass.php'); -include('includes/SQL_CommonFunctions.inc'); -include('includes/session.inc'); - -if (empty($_GET['identifier'])) { - /*unique session identifier to ensure that there is no conflict with other supplier tender sessions on the same machine */ - $identifier=date('U'); -} else { - $identifier=$_GET['identifier']; -} - -if (isset($_GET['New']) and isset($_SESSION['tender'.$identifier])) { - unset($_SESSION['tender'.$identifier]); -} - -if (isset($_GET['New']) and $_SESSION['CanCreateTender']==0) { - $title = _('Authorisation Problem'); - include('includes/header.inc'); - echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . $title . '" alt="" /> '.$title . '</p>'; - prnMsg( _('You do not have authority to create supplier tenders for this company.') . '<br />' . - _('Please see your system administrator'), 'warn'); - include('includes/footer.inc'); - exit; -} - -if (isset($_GET['Edit']) and $_SESSION['CanCreateTender']==0) { - $title = _('Authorisation Problem'); - include('includes/header.inc'); - echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . $title . '" alt="" /> '.$title . '</p>'; - prnMsg( _('You do not have authority to amend supplier tenders for this company.') . '<br />' . - _('Please see your system administrator'), 'warn'); - include('includes/footer.inc'); - exit; -} - -$ShowTender = 0; - -if (isset($_GET['ID'])) { - $sql="SELECT tenderid, - location, - address1, - address2, - address3, - address4, - address5, - address6, - telephone - FROM tenders - WHERE tenderid='" . $_GET['ID'] . "'"; - $result=DB_query($sql, $db); - $myrow=DB_fetch_array($result); - if (isset($_SESSION['tender'.$identifier])) { - unset($_SESSION['tender'.$identifier]); - } - $_SESSION['tender'.$identifier] = new Tender(); - $_SESSION['tender'.$identifier]->TenderId = $myrow['tenderid']; - $_SESSION['tender'.$identifier]->Location = $myrow['location']; - $_SESSION['tender'.$identifier]->DelAdd1 = $myrow['address1']; - $_SESSION['tender'.$identifier]->DelAdd2 = $myrow['address2']; - $_SESSION['tender'.$identifier]->DelAdd3 = $myrow['address3']; - $_SESSION['tender'.$identifier]->DelAdd4 = $myrow['address4']; - $_SESSION['tender'.$identifier]->DelAdd5 = $myrow['address5']; - $_SESSION['tender'.$identifier]->DelAdd6 = $myrow['address6']; - - $sql="SELECT tenderid, - tendersuppliers.supplierid, - suppliers.suppname, - tendersuppliers.email - FROM tendersuppliers - LEFT JOIN suppliers - ON tendersuppliers.supplierid=suppliers.supplierid - WHERE tenderid='" . $_GET['ID'] . "'"; - $result=DB_query($sql, $db); - while ($myrow=DB_fetch_array($result)) { - $_SESSION['tender'.$identifier]->add_supplier_to_tender($myrow['supplierid'], - $myrow['suppname'], - $myrow['email']); - } - - $sql="SELECT tenderid, - tenderitems.stockid, - tenderitems.quantity, - stockmaster.description, - tenderitems.units, - stockmaster.decimalplaces - FROM tenderitems - LEFT JOIN stockmaster - ON tenderitems.stockid=stockmaster.stockid - WHERE tenderid='" . $_GET['ID'] . "'"; - $result=DB_query($sql, $db); - while ($myrow=DB_fetch_array($result)) { - $_SESSION['tender'.$identifier]->add_item_to_tender($_SESSION['tender'.$identifier]->LinesOnTender, - $myrow['stockid'], - $myrow['quantity'], - $myrow['description'], - $myrow['units'], - $myrow['decimalplaces'], - DateAdd(date($_SESSION['DefaultDateFormat']),'m',3)); - } - $ShowTender = 1; -} - -if (isset($_GET['Edit'])) { - $title = _('Edit an Existing Supplier Tender Request'); - include('includes/header.inc'); - echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; - $sql="SELECT tenderid, - location, - address1, - address2, - address3, - address4, - address5, - address6, - telephone - FROM tenders - WHERE closed=0"; - $result=DB_query($sql, $db); - echo '<table class="selection">'; - echo '<tr> - <th>' . _('Tender ID') . '</th> - <th>' . _('Location') . '</th> - <th>' . _('Address 1') . '</th> - <th>' . _('Address 2') . '</th> - <th>' . _('Address 3') . '</th> - <th>' . _('Address 4') . '</th> - <th>' . _('Address 5') . '</th> - <th>' . _('Address 6') . '</th> - <th>' . _('Telephone') . '</th> - </tr>'; - while ($myrow=DB_fetch_array($result)) { - echo '<tr> - <td>' . $myrow['tenderid'] . '</td> - <td>' . $myrow['location'] . '</td> - <td>' . $myrow['address1'] . '</td> - <td>' . $myrow['address2'] . '</td> - <td>' . $myrow['address3'] . '</td> - <td>' . $myrow['address4'] . '</td> - <td>' . $myrow['address5'] . '</td> - <td>' . $myrow['address6'] . '</td> - <td>' . $myrow['telephone'] . '</td> - <td><a href="'.htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?identifier='.$identifier.'&ID='.$myrow['tenderid'].'">'. _('Edit') .'</a></td> - </tr>'; - } - echo '</table>'; - include('includes/footer.inc'); - exit; -} else if (isset($_GET['ID']) or (isset($_SESSION['tender'.$identifier]->TenderId))) { - $title = _('Edit an Existing Supplier Tender Request'); - include('includes/header.inc'); - echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; -} else { - $title = _('Create a New Supplier Tender Request'); - include('includes/header.inc'); - echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; -} - -if (isset($_POST['Save'])) { - $_SESSION['tender'.$identifier]->RequiredByDate=$_POST['RequiredByDate']; - $_SESSION['tender'.$identifier]->save($db); - $_SESSION['tender'.$identifier]->EmailSuppliers(); - prnMsg( _('The tender has been successfully saved'), 'success'); - include('includes/footer.inc'); - exit; -} - -if (isset($_GET['DeleteSupplier'])) { - $_SESSION['tender'.$identifier]->remove_supplier_from_tender($_GET['DeleteSupplier']); - $ShowTender = 1; -} - -if (isset($_GET['DeleteItem'])) { - $_SESSION['tender'.$identifier]->remove_item_from_tender($_GET['DeleteItem']); - $ShowTender = 1; -} - -if (isset($_POST['SelectedSupplier'])) { - $sql = "SELECT suppname, - email - FROM suppliers - WHERE supplierid='" . $_POST['SelectedSupplier'] . "'"; - $result = DB_query($sql, $db); - $myrow = DB_fetch_array($result); - if (mb_strlen($myrow['email'])>0) { - $_SESSION['tender'.$identifier]->add_supplier_to_tender($_POST['SelectedSupplier'], - $myrow['suppname'], - $myrow['email']); - } else { - prnMsg( _('The supplier must have an email set up or they cannot be part of a tender'), 'warn'); - } - $ShowTender = 1; -} - -if (isset($_POST['NewItem']) and !isset($_POST['Refresh'])) { - foreach ($_POST as $key => $value) { - if (mb_substr($key,0,7)=='StockID') { - $Index = mb_substr($key,7,mb_strlen($key)-7); - $StockID = $value; - $Quantity = filter_number_format($_POST['Qty'.$Index]); - $UOM = $_POST['UOM'.$Index]; - $sql="SELECT description, decimalplaces FROM stockmaster WHERE stockid='".$StockID."'"; - $result=DB_query($sql, $db); - $myrow=DB_fetch_array($result); - $_SESSION['tender'.$identifier]->add_item_to_tender($_SESSION['tender'.$identifier]->LinesOnTender, - $StockID, - $Quantity, - $myrow['description'], - $UOM, - $myrow['decimalplaces'], - DateAdd(date($_SESSION['DefaultDateFormat']),'m',3)); - unset($UOM); - } - } - $ShowTender = 1; -} - -if (!isset($_SESSION['tender'.$identifier]) - or isset($_POST['LookupDeliveryAddress']) - or $ShowTender==1) { - - /* Show Tender header screen */ - if (!isset($_SESSION['tender'.$identifier])) { - $_SESSION['tender'.$identifier]=new Tender(); - } - echo '<form name="form1" action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?identifier='.$identifier . '" method="post">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; - echo '<table class="selection">'; - echo '<tr> - <th colspan="4"><font size="3" color="#616161">' . _('Tender header details') . '</font></th> - </tr>'; - echo '<tr> - <td>' . _('Delivery Must Be Made Before') . '</td> - <td><input type="text" class="date" alt="' .$_SESSION['DefaultDateFormat'] . '" name="RequiredByDate" size="11" value="' . date($_SESSION['DefaultDateFormat']) . '" /></td> - </tr>'; - - if (!isset($_POST['StkLocation']) or $_POST['StkLocation']==''){ - /* If this is the first time - * the form loaded set up defaults */ - - $_POST['StkLocation'] = $_SESSION['UserStockLocation']; - - $sql = "SELECT deladd1, - deladd2, - deladd3, - deladd4, - deladd5, - deladd6, - tel, - contact - FROM locations - WHERE loccode='" . $_POST['StkLocation'] . "'"; - - $LocnAddrResult = DB_query($sql,$db); - if (DB_num_rows($LocnAddrResult)==1){ - $LocnRow = DB_fetch_array($LocnAddrResult); - $_POST['DelAdd1'] = $LocnRow['deladd1']; - $_POST['DelAdd2'] = $LocnRow['deladd2']; - $_POST['DelAdd3'] = $LocnRow['deladd3']; - $_POST['DelAdd4'] = $LocnRow['deladd4']; - $_POST['DelAdd5'] = $LocnRow['deladd5']; - $_POST['DelAdd6'] = $LocnRow['deladd6']; - $_POST['Tel'] = $LocnRow['tel']; - $_POST['Contact'] = $LocnRow['contact']; - - $_SESSION['tender'.$identifier]->Location= $_POST['StkLocation']; - $_SESSION['tender'.$identifier]->DelAdd1 = $_POST['DelAdd1']; - $_SESSION['tender'.$identifier]->DelAdd2 = $_POST['DelAdd2']; - $_SESSION['tender'.$identifier]->DelAdd3 = $_POST['DelAdd3']; - $_SESSION['tender'.$identifier]->DelAdd4 = $_POST['DelAdd4']; - $_SESSION['tender'.$identifier]->DelAdd5 = $_POST['DelAdd5']; - $_SESSION['tender'.$identifier]->DelAdd6 = $_POST['DelAdd6']; - $_SESSION['tender'.$identifier]->Telephone = $_POST['Tel']; - $_SESSION['tender'.$identifier]->Contact = $_POST['Contact']; - - } else { - /*The default location of the user is crook */ - prnMsg(_('The default stock location set up for this user is not a currently defined stock location') . - '. ' . _('Your system administrator needs to amend your user record'),'error'); - } - - - } elseif (isset($_POST['LookupDeliveryAddress'])){ - - $sql = "SELECT deladd1, - deladd2, - deladd3, - deladd4, - deladd5, - deladd6, - tel, - contact - FROM locations - WHERE loccode='" . $_POST['StkLocation'] . "'"; - - $LocnAddrResult = DB_query($sql,$db); - if (DB_num_rows($LocnAddrResult)==1){ - $LocnRow = DB_fetch_array($LocnAddrResult); - $_POST['DelAdd1'] = $LocnRow['deladd1']; - $_POST['DelAdd2'] = $LocnRow['deladd2']; - $_POST['DelAdd3'] = $LocnRow['deladd3']; - $_POST['DelAdd4'] = $LocnRow['deladd4']; - $_POST['DelAdd5'] = $LocnRow['deladd5']; - $_POST['DelAdd6'] = $LocnRow['deladd6']; - $_POST['Tel'] = $LocnRow['tel']; - $_POST['Contact'] = $LocnRow['contact']; - - $_SESSION['tender'.$identifier]->Location= $_POST['StkLocation']; - $_SESSION['tender'.$identifier]->DelAdd1 = $_POST['DelAdd1']; - $_SESSION['tender'.$identifier]->DelAdd2 = $_POST['DelAdd2']; - $_SESSION['tender'.$identifier]->DelAdd3 = $_POST['DelAdd3']; - $_SESSION['tender'.$identifier]->DelAdd4 = $_POST['DelAdd4']; - $_SESSION['tender'.$identifier]->DelAdd5 = $_POST['DelAdd5']; - $_SESSION['tender'.$identifier]->DelAdd6 = $_POST['DelAdd6']; - $_SESSION['tender'.$identifier]->Telephone = $_POST['Tel']; - $_SESSION['tender'.$identifier]->Contact = $_POST['Contact']; - } - } - echo '<tr> - <td>' . _('Warehouse') . ':</td> - <td><select name="StkLocation" onchange="ReloadForm(form1.LookupDeliveryAddress)">'; - - $sql = "SELECT loccode, - locationname - FROM locations"; - $LocnResult = DB_query($sql,$db); - - while ($LocnRow=DB_fetch_array($LocnResult)){ - if ((isset($_SESSION['tender'.$identifier]->Location) and $_SESSION['tender'.$identifier]->Location == $LocnRow['loccode'])){ - echo '<option selected="selected" value="' . $LocnRow['loccode'] . '">' . $LocnRow['locationname'] . '</option>'; - } else { - echo '<option value="' . $LocnRow['loccode'] . '">' . $LocnRow['locationname'] . '</option>'; - } - } - - echo '</select> - <input type="submit" name="LookupDeliveryAddress" value="' ._('Select') . '" /></td> - </tr>'; - - /* Display the details of the delivery location - */ - echo '<tr> - <td>' . _('Delivery Contact') . ':</td> - <td><input type="text" name="Contact" size="41" value="' . $_SESSION['tender'.$identifier]->Contact . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 1 :</td> - <td><input type="text" name="DelAdd1" size="41" maxlength="40" value="' . $_POST['DelAdd1'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 2 :</td> - <td><input type="text" name="DelAdd2" size="41" maxlength="40" value="' . $_POST['DelAdd2'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 3 :</td> - <td><input type="text" name="DelAdd3" size="41" maxlength="40" value="' . $_POST['DelAdd3'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 4 :</td> - <td><input type="text" name="DelAdd4" size="21" maxlength="20" value="' . $_POST['DelAdd4'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 5 :</td> - <td><input type="text" name="DelAdd5" size="16" maxlength="15" value="' . $_POST['DelAdd5'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Address') . ' 6 :</td> - <td><input type="text" name="DelAdd6" size="16" maxlength="15" value="' . $_POST['DelAdd6'] . '" /></td> - </tr>'; - echo '<tr> - <td>' . _('Phone') . ':</td> - <td><input type="text" name="Tel" size="31" maxlength="30" value="' . $_SESSION['tender'.$identifier]->Telephone . '" /></td> - </tr>'; - echo '</table><br />'; - - /* Display the supplier/item details - */ - echo '<table>'; - - /* Supplier Details - */ - echo '<tr> - <td valign="top"> - <table class="selection">'; - echo '<tr> - <th colspan="4"><font size="3" color="#616161">' . _('Suppliers To Send Tender') . '</font></th> - </tr>'; - echo '<tr> - <th>'. _('Supplier Code') . '</th> - <th>' ._('Supplier Name') . '</th> - <th>' ._('Email Address') . '</th> - </tr>'; - foreach ($_SESSION['tender'.$identifier]->Suppliers as $Supplier) { - echo '<tr> - <td>' . $Supplier->SupplierCode . '</td> - <td>' . $Supplier->SupplierName . '</td> - <td>' . $Supplier->EmailAddress . '</td> - <td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES,'UTF-8') . '&DeleteSupplier=' . $Supplier->SupplierCode . '">' . _('Delete') . '</a></td> - </tr>'; - } - echo '</table></td>'; - /* Item Details - */ - echo '<td valign="top"><table class="selection">'; - echo '<tr><th colspan="6"><font size="3" color="#616161">' . _('Items in Tender') . '</font></th></tr>'; - echo '<tr> - <th>'._('Stock ID').'</th> - <th>'._('Description').'</th> - <th>'._('Quantity').'</th> - <th>'._('UOM').'</th> - </tr>'; - $k=0; - foreach ($_SESSION['tender'.$identifier]->LineItems as $LineItems) { - if ($LineItems->Deleted==False) { - if ($k==1){ - echo '<tr class="EvenTableRows">'; - $k=0; - } else { - echo '<tr class="OddTableRows">'; - $k=1; - } - echo '<td>'.$LineItems->StockID.'</td> - <td>'.$LineItems->ItemDescription.'</td> - <td class="number">' . locale_number_format($LineItems->Quantity,$LineItems->DecimalPlaces).'</td> - <td>'.$LineItems->Units.'</td> - <td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier,ENT_QUOTES,'UTF-8') . '&DeleteItem=' . $LineItems->LineNo . '">' . _('Delete') . '</a></td> - </tr>'; - echo '</tr>'; - } - } - echo '</table></td></tr></table><br />'; - - echo '<div class="centre"> - <input type="submit" name="Suppliers" value="' . _('Select Suppliers') . '" /> - <input type="submit" name="Items" value="' . _('Select Item Details') . '" /> - </div> - <br />'; - if ($_SESSION['tender'.$identifier]->LinesOnTender > 0 - and $_SESSION['tender'.$identifier]->SuppliersOnTender > 0) { - - echo '<div class="centre"> - <input type="submit" name="Save" value="' . _('Save Tender') . '" /> - </div>'; - } - echo '</form>'; - include('includes/footer.inc'); - exit; -} - -if (isset($_POST['SearchSupplier']) or isset($_POST['Go']) - or isset($_POST['Next']) or isset($_POST['Previous'])) { - - if (mb_strlen($_POST['Keywords']) > 0 and mb_strlen($_POST['SupplierCode']) > 0) { - prnMsg( '<br />' . _('Supplier name keywords have been used in preference to the Supplier code extract entered'), 'info' ); - } - if ($_POST['Keywords'] == '' and $_POST['SupplierCode'] == '') { - $SQL = "SELECT supplierid, - suppname, - currcode, - address1, - address2, - address3, - address4 - FROM suppliers - ORDER BY suppname"; - } else { - if (mb_strlen($_POST['Keywords']) > 0) { - $_POST['Keywords'] = mb_strtoupper($_POST['Keywords']); - //insert wildcard characters in spaces - $SearchString = '%' . str_replace(' ', '%', $_POST['Keywords']) . '%'; - $SQL = "SELECT supplierid, - suppname, - currcode, - address1, - address2, - address3, - address4 - FROM suppliers - WHERE suppname " . LIKE . " '$SearchString' - ORDER BY suppname"; - } elseif (mb_strlen($_POST['SupplierCode']) > 0) { - $_POST['SupplierCode'] = mb_strtoupper($_POST['SupplierCode']); - $SQL = "SELECT supplierid, - suppname, - currcode, - address1, - address2, - address3, - address4 - FROM suppliers - WHERE supplierid " . LIKE . " '%" . $_POST['SupplierCode'] . "%' - ORDER BY supplierid"; - } - } //one of keywords or SupplierCode was more than a zero length string - $result = DB_query($SQL, $db); - if (DB_num_rows($result) == 1) { - $myrow = DB_fetch_array($result); - $SingleSupplierReturned = $myrow['supplierid']; - } -} //end of if search -if (isset($SingleSupplierReturned)) { /*there was only one supplier returned */ - $_SESSION['SupplierID'] = $SingleSupplierReturned; - unset($_POST['Keywords']); - unset($_POST['SupplierCode']); -} - -if (!isset($_POST['PageOffset'])) { - $_POST['PageOffset'] = 1; -} else { - if ($_POST['PageOffset'] == 0) { - $_POST['PageOffset'] = 1; - } -} - -if (isset($_POST['Suppliers'])) { - echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES,'UTF-8') . '" method="post">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; - echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/magnifier.png" title="' . _('Search') . '" alt="" />' . ' ' . _('Search for Suppliers') . '</p> - <table cellpadding="3" class="selection"> - <tr> - <td>' . _('Enter a partial Name') . ':</td> - <td>'; - if (isset($_POST['Keywords'])) { - echo '<input type="text" name="Keywords" value="' . $_POST['Keywords'] . '" size="20" maxlength="25" />'; - } else { - echo '<input type="text" name="Keywords" size="20" maxlength="25" />'; - } - echo '</td><td><b>' . _('OR') . '</b></font></td><td>' . _('Enter a partial Code') . ':</font></td><td>'; - if (isset($_POST['SupplierCode'])) { - echo '<input type="text" name="SupplierCode" value="' . $_POST['SupplierCode'] . '" size="15" maxlength="18" />'; - } else { - echo '<input type="text" name="SupplierCode" size="15" maxlength="18" />'; - } - echo '</td></tr></table><br /><div class="centre"><input type="submit" name="SearchSupplier" value="' . _('Search Now') . '" /></div>'; - echo '</form>'; -} - -if (isset($_POST['SearchSupplier'])) { - echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES, 'UTF-8') . '" method="post">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; - $ListCount = DB_num_rows($result); - $ListPageMax = ceil($ListCount / $_SESSION['DisplayRecordsMax']); - if (isset($_POST['Next'])) { - if ($_POST['PageOffset'] < $ListPageMax) { - $_POST['PageOffset'] = $_POST['PageOffset'] + 1; - } - } - if (isset($_POST['Previous'])) { - if ($_POST['PageOffset'] > 1) { - $_POST['PageOffset'] = $_POST['PageOffset'] - 1; - } - } - if ($ListPageMax > 1) { - echo '<br /> ' . $_POST['PageOffset'] . ' ' . _('of') . ' ' . $ListPageMax . ' ' . _('pages') . '. ' . _('Go to Page') . ': '; - echo '<select name="PageOffset">'; - $ListPage = 1; - while ($ListPage <= $ListPageMax) { - if ($ListPage == $_POST['PageOffset']) { - echo '<option value="' . $ListPage . '" selected="selected">' . $ListPage . '</option>'; - } else { - echo '<option value="' . $ListPage . '">' . $ListPage . '</option>'; - } - $ListPage++; - } - echo '</select> - <input type="submit" name="Go" value="' . _('Go') . '" /> - <input type="submit" name="Previous" value="' . _('Previous') . '" /> - <input type="submit" name="Next" value="' . _('Next') . '" />'; - echo '<br />'; - } - echo '<input type="hidden" name="Search" value="' . _('Search Now') . '" />'; - echo '<br /> - <br /> - <br /> - <table cellpadding="2">'; - echo '<tr> - <th>' . _('Code') . '</th> - <th>' . _('Supplier Name') . '</th> - <th>' . _('Currency') . '</th> - <th>' . _('Address 1') . '</th> - <th>' . _('Address 2') . '</th> - <th>' . _('Address 3') . '</th> - <th>' . _('Address 4') . '</th> - </tr>'; - $j = 1; - $k = 0; //row counter to determine background colour - $RowIndex = 0; - if (DB_num_rows($result) <> 0) { - DB_data_seek($result, ($_POST['PageOffset'] - 1) * $_SESSION['DisplayRecordsMax']); - } - while (($myrow = DB_fetch_array($result)) and ($RowIndex <> $_SESSION['DisplayRecordsMax'])) { - if ($k == 1) { - echo '<tr class="EvenTableRows">'; - $k = 0; - } else { - echo '<tr class="OddTableRows">'; - $k = 1; - } - echo '<td><input type="submit" name="SelectedSupplier" value="'.$myrow['supplierid'].'" /></td> - <td>'.$myrow['suppname'].'</td> - <td>'.$myrow['currcode'].'</td> - <td>'.$myrow['address1'].'</td> - <td>'.$myrow['address2'].'</td> - <td>'.$myrow['address3'].'</td> - <td>'.$myrow['address4'].'</td> - </tr>'; - $RowIndex = $RowIndex + 1; - //end of page full new headings if - } - //end of while loop - echo '</table>'; -} - -/*The supplier has chosen option 2 - */ -if (isset($_POST['Items'])) { - echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES, 'UTF-8') . '" method="post">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; - echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/magnifier.png" title="' . _('Search') . '" alt="" />' . ' ' . _('Search for Inventory Items') . '</p>'; - $sql = "SELECT categoryid, - categorydescription - FROM stockcategory - ORDER BY categorydescription"; - $result = DB_query($sql, $db); - if (DB_num_rows($result) == 0) { - echo '<br /><font size="4" color="red">' . _('Problem Report') . ':</font><br />' . - _('There are no stock categories currently defined please use the link below to set them up'); - echo '<br /><a href="' . $rootpath . '/StockCategories.php">' . _('Define Stock Categories') . '</a>'; - exit; - } - echo '<table class="selection"> - <tr> - <td>' . _('In Stock Category') . ':<select name="StockCat">'; - if (!isset($_POST['StockCat'])) { - $_POST['StockCat'] = ''; - } - if ($_POST['StockCat'] == 'All') { - echo '<option selected="selected" value="All">' . _('All') . '</option>'; - } else { - echo '<option value="All">' . _('All') . '</option>'; - } - while ($myrow1 = DB_fetch_array($result)) { - if ($myrow1['categoryid'] == $_POST['StockCat']) { - echo '<option selected="selected" value="' . $myrow1['categoryid'] . '">' . $myrow1['categorydescription'] . '</option>'; - } else { - echo '<option value="' . $myrow1['categoryid'] . '">' . $myrow1['categorydescription'] . '</option>'; - } - } - echo '</select></td> - <td>' . _('Enter partial') . '<b> ' . _('Description') . '</b>:</td> - <td>'; - if (isset($_POST['Keywords'])) { - echo '<input type="text" name="Keywords" value="' . $_POST['Keywords'] . '" size="20" maxlength="25" />'; - } else { - echo '<input type="text" name="Keywords" size="20" maxlength="25" />'; - } - echo '</td> - </tr> - <tr> - <td></td> - <td><font size="3"><b>' . _('OR') . ' ' . '</b></font>' . _('Enter partial') . ' <b>' . _('Stock Code') . '</b>:</td> - <td>'; - if (isset($_POST['StockCode'])) { - echo '<input type="text" name="StockCode" value="' . $_POST['StockCode'] . '" size="15" maxlength="18" />'; - } else { - echo '<input type="text" name="StockCode" size="15" maxlength="18" />'; - } - echo '</td></tr> - </table> - <br /> - <div class="centre"> - <input type="submit" name="Search" value="' . _('Search Now') . '" /> - </div> - <br /> - </form>'; - echo '<script type="text/javascript">defaultControl(document.forms[0].StockCode);</script>'; -} - -if (isset($_POST['Search'])){ /*ie seach for stock items */ - echo '<form method="post" action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier,ENT_QUOTES,'UTF-8') .'">'; - echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; - echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/supplier.png" title="' . _('Tenders') . '" alt="" />' . ' ' . _('Select items required on this tender').'</p>'; - - if ($_POST['Keywords'] and $_POST['StockCode']) { - prnMsg( _('Stock description keywords have been used in preference to the Stock code extract entered'), 'info' ); - } - if ($_POST['Keywords']) { - //insert wildcard characters in spaces - $SearchString = '%' . str_replace(' ', '%', $_POST['Keywords']) . '%'; - - if ($_POST['StockCat']=='All'){ - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - AND stockmaster.description " . LIKE . " '$SearchString' - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } else { - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - AND stockmaster.description " . LIKE . " '$SearchString' - AND stockmaster.categoryid='" . $_POST['StockCat'] . "' - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } - - } elseif ($_POST['StockCode']){ - - $_POST['StockCode'] = '%' . $_POST['StockCode'] . '%'; - - if ($_POST['StockCat']=='All'){ - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - AND stockmaster.stockid " . LIKE . " '" . $_POST['StockCode'] . "' - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } else { - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - AND stockmaster.stockid " . LIKE . " '" . $_POST['StockCode'] . "' - AND stockmaster.categoryid='" . $_POST['StockCat'] . "' - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } - - } else { - if ($_POST['StockCat']=='All'){ - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } else { - $sql = "SELECT stockmaster.stockid, - stockmaster.description, - stockmaster.units - FROM stockmaster INNER JOIN stockcategory - ON stockmaster.categoryid=stockcategory.categoryid - WHERE stockmaster.mbflag!='D' - AND stockmaster.mbflag!='A' - AND stockmaster.mbflag!='K' - AND stockmaster.mbflag!='G' - AND stockmaster.discontinued!=1 - AND stockmaster.categoryid='" . $_POST['StockCat'] . "' - ORDER BY stockmaster.stockid - LIMIT " . $_SESSION['DisplayRecordsMax']; - } - } - - $ErrMsg = _('There is a problem selecting the part records to display because'); - $DbgMsg = _('The SQL statement that failed was'); - $SearchResult = DB_query($sql,$db,$ErrMsg,$DbgMsg); - - if (DB_num_rows($SearchResult)==0 and $debug==1){ - prnMsg( _('There are no products to display matching the criteria provided'),'warn'); - } - if (DB_num_rows($SearchResult)==1){ - - $myrow=DB_fetch_array($SearchResult); - $_GET['NewItem'] = $myrow['stockid']; - DB_data_seek($SearchResult,0); - } - - if (isset($SearchResult)) { - - echo '<table cellpadding="1">'; - echo '<tr> - <th>' . _('Code') . '</th> - <th>' . _('Description') . '</th> - <th>' . _('Units') . '</th> - <th>' . _('Image') . '</th> - <th>' . _('Quantity') . '</th> - </tr>'; - - $i = 0; - $k = 0; //row colour counter - $PartsDisplayed=0; - while ($myrow=DB_fetch_array($SearchResult)) { - - if ($k==1){ - echo '<tr class="EvenTableRows">'; - $k=0; - } else { - echo '<tr class="OddTableRows">'; - $k=1; - } - - $FileName = $myrow['stockid'] . '.jpg'; - if (file_exists( $_SESSION['part_pics_dir'] . '/' . $FileName) ) { - - $ImageSource = '<img src="'.$rootpath . '/' . $_SESSION['part_pics_dir'] . '/' . $FileName . '" width="50" height="50" />'; - - } else { - $ImageSource = '<i>'._('No Image').'</i>'; - } - - echo '<td>'.$myrow['stockid'].'</td> - <td>'.$myrow['description'].'</td> - <td>'.$myrow['units'].'</td> - <td>'.$ImageSource.'</td> - <td><input class="number" type="text" size="6" value="0" name="Qty'.$i.'" /></td> - <input type="hidden" value="'.$myrow['units'].'" name="UOM'.$i.'" /> - <input type="hidden" value="'.$myrow['stockid'].'" name="StockID'.$i.'" /> - </tr>'; - - $i++; -#end of page full new headings if - } -#end of while loop - echo '</table>'; - - echo '<a name="end"></a> - <br /> - <div class="centre"> - <input type="submit" name="NewItem" value="' . _('Add to Tender') . '" /> - </div>'; - }#end if SearchResults to show - - echo '</form>'; - -} //end of if search - -include('includes/footer.inc'); - +<?php +/* $Id: SupplierTenderCreate.php 4821 2012-01-20 13:48:53Z tim_schofield $ */ + +include('includes/DefineTenderClass.php'); +include('includes/SQL_CommonFunctions.inc'); +include('includes/session.inc'); + +if (empty($_GET['identifier'])) { + /*unique session identifier to ensure that there is no conflict with other supplier tender sessions on the same machine */ + $identifier=date('U'); +} else { + $identifier=$_GET['identifier']; +} + +if (isset($_GET['New']) and isset($_SESSION['tender'.$identifier])) { + unset($_SESSION['tender'.$identifier]); +} + +if (isset($_GET['New']) and $_SESSION['CanCreateTender']==0) { + $title = _('Authorisation Problem'); + include('includes/header.inc'); + echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . $title . '" alt="" /> '.$title . '</p>'; + prnMsg( _('You do not have authority to create supplier tenders for this company.') . '<br />' . + _('Please see your system administrator'), 'warn'); + include('includes/footer.inc'); + exit; +} + +if (isset($_GET['Edit']) and $_SESSION['CanCreateTender']==0) { + $title = _('Authorisation Problem'); + include('includes/header.inc'); + echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . $title . '" alt="" /> '.$title . '</p>'; + prnMsg( _('You do not have authority to amend supplier tenders for this company.') . '<br />' . + _('Please see your system administrator'), 'warn'); + include('includes/footer.inc'); + exit; +} + +$ShowTender = 0; + +if (isset($_GET['ID'])) { + $sql="SELECT tenderid, + location, + address1, + address2, + address3, + address4, + address5, + address6, + telephone + FROM tenders + WHERE tenderid='" . $_GET['ID'] . "'"; + $result=DB_query($sql, $db); + $myrow=DB_fetch_array($result); + if (isset($_SESSION['tender'.$identifier])) { + unset($_SESSION['tender'.$identifier]); + } + $_SESSION['tender'.$identifier] = new Tender(); + $_SESSION['tender'.$identifier]->TenderId = $myrow['tenderid']; + $_SESSION['tender'.$identifier]->Location = $myrow['location']; + $_SESSION['tender'.$identifier]->DelAdd1 = $myrow['address1']; + $_SESSION['tender'.$identifier]->DelAdd2 = $myrow['address2']; + $_SESSION['tender'.$identifier]->DelAdd3 = $myrow['address3']; + $_SESSION['tender'.$identifier]->DelAdd4 = $myrow['address4']; + $_SESSION['tender'.$identifier]->DelAdd5 = $myrow['address5']; + $_SESSION['tender'.$identifier]->DelAdd6 = $myrow['address6']; + + $sql="SELECT tenderid, + tendersuppliers.supplierid, + suppliers.suppname, + tendersuppliers.email + FROM tendersuppliers + LEFT JOIN suppliers + ON tendersuppliers.supplierid=suppliers.supplierid + WHERE tenderid='" . $_GET['ID'] . "'"; + $result=DB_query($sql, $db); + while ($myrow=DB_fetch_array($result)) { + $_SESSION['tender'.$identifier]->add_supplier_to_tender($myrow['supplierid'], + $myrow['suppname'], + $myrow['email']); + } + + $sql="SELECT tenderid, + tenderitems.stockid, + tenderitems.quantity, + stockmaster.description, + tenderitems.units, + stockmaster.decimalplaces + FROM tenderitems + LEFT JOIN stockmaster + ON tenderitems.stockid=stockmaster.stockid + WHERE tenderid='" . $_GET['ID'] . "'"; + $result=DB_query($sql, $db); + while ($myrow=DB_fetch_array($result)) { + $_SESSION['tender'.$identifier]->add_item_to_tender($_SESSION['tender'.$identifier]->LinesOnTender, + $myrow['stockid'], + $myrow['quantity'], + $myrow['description'], + $myrow['units'], + $myrow['decimalplaces'], + DateAdd(date($_SESSION['DefaultDateFormat']),'m',3)); + } + $ShowTender = 1; +} + +if (isset($_GET['Edit'])) { + $title = _('Edit an Existing Supplier Tender Request'); + include('includes/header.inc'); + echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; + $sql="SELECT tenderid, + location, + address1, + address2, + address3, + address4, + address5, + address6, + telephone + FROM tenders + WHERE closed=0"; + $result=DB_query($sql, $db); + echo '<table class="selection">'; + echo '<tr> + <th>' . _('Tender ID') . '</th> + <th>' . _('Location') . '</th> + <th>' . _('Address 1') . '</th> + <th>' . _('Address 2') . '</th> + <th>' . _('Address 3') . '</th> + <th>' . _('Address 4') . '</th> + <th>' . _('Address 5') . '</th> + <th>' . _('Address 6') . '</th> + <th>' . _('Telephone') . '</th> + </tr>'; + while ($myrow=DB_fetch_array($result)) { + echo '<tr> + <td>' . $myrow['tenderid'] . '</td> + <td>' . $myrow['location'] . '</td> + <td>' . $myrow['address1'] . '</td> + <td>' . $myrow['address2'] . '</td> + <td>' . $myrow['address3'] . '</td> + <td>' . $myrow['address4'] . '</td> + <td>' . $myrow['address5'] . '</td> + <td>' . $myrow['address6'] . '</td> + <td>' . $myrow['telephone'] . '</td> + <td><a href="'.htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?identifier='.$identifier.'&ID='.$myrow['tenderid'].'">'. _('Edit') .'</a></td> + </tr>'; + } + echo '</table>'; + include('includes/footer.inc'); + exit; +} else if (isset($_GET['ID']) or (isset($_SESSION['tender'.$identifier]->TenderId))) { + $title = _('Edit an Existing Supplier Tender Request'); + include('includes/header.inc'); + echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; +} else { + $title = _('Create a New Supplier Tender Request'); + include('includes/header.inc'); + echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' . _('Purchase Order Tendering') . '" alt="" /> '.$title . '</p>'; +} + +if (isset($_POST['Save'])) { + $_SESSION['tender'.$identifier]->RequiredByDate=$_POST['RequiredByDate']; + $_SESSION['tender'.$identifier]->save($db); + $_SESSION['tender'.$identifier]->EmailSuppliers(); + prnMsg( _('The tender has been successfully saved'), 'success'); + include('includes/footer.inc'); + exit; +} + +if (isset($_GET['DeleteSupplier'])) { + $_SESSION['tender'.$identifier]->remove_supplier_from_tender($_GET['DeleteSupplier']); + $ShowTender = 1; +} + +if (isset($_GET['DeleteItem'])) { + $_SESSION['tender'.$identifier]->remove_item_from_tender($_GET['DeleteItem']); + $ShowTender = 1; +} + +if (isset($_POST['SelectedSupplier'])) { + $sql = "SELECT suppname, + email + FROM suppliers + WHERE supplierid='" . $_POST['SelectedSupplier'] . "'"; + $result = DB_query($sql, $db); + $myrow = DB_fetch_array($result); + if (mb_strlen($myrow['email'])>0) { + $_SESSION['tender'.$identifier]->add_supplier_to_tender($_POST['SelectedSupplier'], + $myrow['suppname'], + $myrow['email']); + } else { + prnMsg( _('The supplier must have an email set up or they cannot be part of a tender'), 'warn'); + } + $ShowTender = 1; +} + +if (isset($_POST['NewItem']) and !isset($_POST['Refresh'])) { + foreach ($_POST as $key => $value) { + if (mb_substr($key,0,7)=='StockID') { + $Index = mb_substr($key,7,mb_strlen($key)-7); + $StockID = $value; + $Quantity = filter_number_format($_POST['Qty'.$Index]); + $UOM = $_POST['UOM'.$Index]; + $sql="SELECT description, decimalplaces FROM stockmaster WHERE stockid='".$StockID."'"; + $result=DB_query($sql, $db); + $myrow=DB_fetch_array($result); + $_SESSION['tender'.$identifier]->add_item_to_tender($_SESSION['tender'.$identifier]->LinesOnTender, + $StockID, + $Quantity, + $myrow['description'], + $UOM, + $myrow['decimalplaces'], + DateAdd(date($_SESSION['DefaultDateFormat']),'m',3)); + unset($UOM); + } + } + $ShowTender = 1; +} + +if (!isset($_SESSION['tender'.$identifier]) + or isset($_POST['LookupDeliveryAddress']) + or $ShowTender==1) { + + /* Show Tender header screen */ + if (!isset($_SESSION['tender'.$identifier])) { + $_SESSION['tender'.$identifier]=new Tender(); + } + echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,'UTF-8') . '?identifier='.$identifier . '" method="post">'; + echo '<div>'; + echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + echo '<table class="selection">'; + echo '<tr> + <th colspan="4"><h3>' . _('Tender header details') . '</h3></th> + </tr>'; + echo '<tr> + <td>' . _('Delivery Must Be Made Before') . '</td> + <td><input type="text" class="date" alt="' .$_SESSION['DefaultDateFormat'] . '" name="RequiredByDate" size="11" value="' . date($_SESSION['DefaultDateFormat']) . '" /></td> + </tr>'; + + if (!isset($_POST['StkLocation']) or $_POST['StkLocation']==''){ + /* If this is the first time + * the form loaded set up defaults */ + + $_POST['StkLocation'] = $_SESSION['UserStockLocation']; + + $sql = "SELECT deladd1, + deladd2, + deladd3, + deladd4, + deladd5, + deladd6, + tel, + contact + FROM locations + WHERE loccode='" . $_POST['StkLocation'] . "'"; + + $LocnAddrResult = DB_query($sql,$db); + if (DB_num_rows($LocnAddrResult)==1){ + $LocnRow = DB_fetch_array($LocnAddrResult); + $_POST['DelAdd1'] = $LocnRow['deladd1']; + $_POST['DelAdd2'] = $LocnRow['deladd2']; + $_POST['DelAdd3'] = $LocnRow['deladd3']; + $_POST['DelAdd4'] = $LocnRow['deladd4']; + $_POST['DelAdd5'] = $LocnRow['deladd5']; + $_POST['DelAdd6'] = $LocnRow['deladd6']; + $_POST['Tel'] = $LocnRow['tel']; + $_POST['Contact'] = $LocnRow['contact']; + + $_SESSION['tender'.$identifier]->Location= $_POST['StkLocation']; + $_SESSION['tender'.$identifier]->DelAdd1 = $_POST['DelAdd1']; + $_SESSION['tender'.$identifier]->DelAdd2 = $_POST['DelAdd2']; + $_SESSION['tender'.$identifier]->DelAdd3 = $_POST['DelAdd3']; + $_SESSION['tender'.$identifier]->DelAdd4 = $_POST['DelAdd4']; + $_SESSION['tender'.$identifier]->DelAdd5 = $_POST['DelAdd5']; + $_SESSION['tender'.$identifier]->DelAdd6 = $_POST['DelAdd6']; + $_SESSION['tender'.$identifier]->Telephone = $_POST['Tel']; + $_SESSION['tender'.$identifier]->Contact = $_POST['Contact']; + + } else { + /*The default location of the user is crook */ + prnMsg(_('The default stock location set up for this user is not a currently defined stock location') . + '. ' . _('Your system administrator needs to amend your user record'),'error'); + } + + + } elseif (isset($_POST['LookupDeliveryAddress'])){ + + $sql = "SELECT deladd1, + deladd2, + deladd3, + deladd4, + deladd5, + deladd6, + tel, + contact + FROM locations + WHERE loccode='" . $_POST['StkLocation'] . "'"; + + $LocnAddrResult = DB_query($sql,$db); + if (DB_num_rows($LocnAddrResult)==1){ + $LocnRow = DB_fetch_array($LocnAddrResult); + $_POST['DelAdd1'] = $LocnRow['deladd1']; + $_POST['DelAdd2'] = $LocnRow['deladd2']; + $_POST['DelAdd3'] = $LocnRow['deladd3']; + $_POST['DelAdd4'] = $LocnRow['deladd4']; + $_POST['DelAdd5'] = $LocnRow['deladd5']; + $_POST['DelAdd6'] = $LocnRow['deladd6']; + $_POST['Tel'] = $LocnRow['tel']; + $_POST['Contact'] = $LocnRow['contact']; + + $_SESSION['tender'.$identifier]->Location= $_POST['StkLocation']; + $_SESSION['tender'.$identifier]->DelAdd1 = $_POST['DelAdd1']; + $_SESSION['tender'.$identifier]->DelAdd2 = $_POST['DelAdd2']; + $_SESSION['tender'.$identifier]->DelAdd3 = $_POST['DelAdd3']; + $_SESSION['tender'.$identifier]->DelAdd4 = $_POST['DelAdd4']; + $_SESSION['tender'.$identifier]->DelAdd5 = $_POST['DelAdd5']; + $_SESSION['tender'.$identifier]->DelAdd6 = $_POST['DelAdd6']; + $_SESSION['tender'.$identifier]->Telephone = $_POST['Tel']; + $_SESSION['tender'.$identifier]->Contact = $_POST['Contact']; + } + } + echo '<tr> + <td>' . _('Warehouse') . ':</td> + <td><select name="StkLocation" onchange="ReloadForm(form1.LookupDeliveryAddress)">'; + + $sql = "SELECT loccode, + locationname + FROM locations"; + $LocnResult = DB_query($sql,$db); + + while ($LocnRow=DB_fetch_array($LocnResult)){ + if ((isset($_SESSION['tender'.$identifier]->Location) and $_SESSION['tender'.$identifier]->Location == $LocnRow['loccode'])){ + echo '<option selected="selected" value="' . $LocnRow['loccode'] . '">' . $LocnRow['locationname'] . '</option>'; + } else { + echo '<option value="' . $LocnRow['loccode'] . '">' . $LocnRow['locationname'] . '</option>'; + } + } + + echo '</select> + <input type="submit" name="LookupDeliveryAddress" value="' ._('Select') . '" /></td> + </tr>'; + + /* Display the details of the delivery location + */ + echo '<tr> + <td>' . _('Delivery Contact') . ':</td> + <td><input type="text" name="Contact" size="41" value="' . $_SESSION['tender'.$identifier]->Contact . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 1 :</td> + <td><input type="text" name="DelAdd1" size="41" maxlength="40" value="' . $_POST['DelAdd1'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 2 :</td> + <td><input type="text" name="DelAdd2" size="41" maxlength="40" value="' . $_POST['DelAdd2'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 3 :</td> + <td><input type="text" name="DelAdd3" size="41" maxlength="40" value="' . $_POST['DelAdd3'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 4 :</td> + <td><input type="text" name="DelAdd4" size="21" maxlength="20" value="' . $_POST['DelAdd4'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 5 :</td> + <td><input type="text" name="DelAdd5" size="16" maxlength="15" value="' . $_POST['DelAdd5'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Address') . ' 6 :</td> + <td><input type="text" name="DelAdd6" size="16" maxlength="15" value="' . $_POST['DelAdd6'] . '" /></td> + </tr>'; + echo '<tr> + <td>' . _('Phone') . ':</td> + <td><input type="text" name="Tel" size="31" maxlength="30" value="' . $_SESSION['tender'.$identifier]->Telephone . '" /></td> + </tr>'; + echo '</table><br />'; + + /* Display the supplier/item details + */ + echo '<table>'; + + /* Supplier Details + */ + echo '<tr> + <td valign="top"> + <table class="selection">'; + echo '<tr> + <th colspan="4"><h3>' . _('Suppliers To Send Tender') . '</h3></th> + </tr>'; + echo '<tr> + <th>'. _('Supplier Code') . '</th> + <th>' ._('Supplier Name') . '</th> + <th>' ._('Email Address') . '</th> + </tr>'; + foreach ($_SESSION['tender'.$identifier]->Suppliers as $Supplier) { + echo '<tr> + <td>' . $Supplier->SupplierCode . '</td> + <td>' . $Supplier->SupplierName . '</td> + <td>' . $Supplier->EmailAddress . '</td> + <td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES,'UTF-8') . '&DeleteSupplier=' . $Supplier->SupplierCode . '">' . _('Delete') . '</a></td> + </tr>'; + } + echo '</table></td>'; + /* Item Details + */ + echo '<td valign="top"><table class="selection">'; + echo '<tr><th colspan="6"><h3>' . _('Items in Tender') . '</h3></th></tr>'; + echo '<tr> + <th>'._('Stock ID').'</th> + <th>'._('Description').'</th> + <th>'._('Quantity').'</th> + <th>'._('UOM').'</th> + </tr>'; + $k=0; + foreach ($_SESSION['tender'.$identifier]->LineItems as $LineItems) { + if ($LineItems->Deleted==False) { + if ($k==1){ + echo '<tr class="EvenTableRows">'; + $k=0; + } else { + echo '<tr class="OddTableRows">'; + $k=1; + } + echo '<td>'.$LineItems->StockID.'</td> + <td>'.$LineItems->ItemDescription.'</td> + <td class="number">' . locale_number_format($LineItems->Quantity,$LineItems->DecimalPlaces).'</td> + <td>'.$LineItems->Units.'</td> + <td><a href="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier,ENT_QUOTES,'UTF-8') . '&DeleteItem=' . $LineItems->LineNo . '">' . _('Delete') . '</a></td> + </tr>'; + } + } + echo '</table></td></tr></table><br />'; + + echo '<div class="centre"> + <input type="submit" name="Suppliers" value="' . _('Select Suppliers') . '" /> + <input type="submit" name="Items" value="' . _('Select Item Details') . '" /> + </div> + <br />'; + if ($_SESSION['tender'.$identifier]->LinesOnTender > 0 + and $_SESSION['tender'.$identifier]->SuppliersOnTender > 0) { + + echo '<div class="centre"> + <input type="submit" name="Save" value="' . _('Save Tender') . '" /> + </div>'; + } + echo '</div> + </form>'; + include('includes/footer.inc'); + exit; +} + +if (isset($_POST['SearchSupplier']) or isset($_POST['Go']) + or isset($_POST['Next']) or isset($_POST['Previous'])) { + + if (mb_strlen($_POST['Keywords']) > 0 and mb_strlen($_POST['SupplierCode']) > 0) { + prnMsg( '<br />' . _('Supplier name keywords have been used in preference to the Supplier code extract entered'), 'info' ); + } + if ($_POST['Keywords'] == '' and $_POST['SupplierCode'] == '') { + $SQL = "SELECT supplierid, + suppname, + currcode, + address1, + address2, + address3, + address4 + FROM suppliers + ORDER BY suppname"; + } else { + if (mb_strlen($_POST['Keywords']) > 0) { + $_POST['Keywords'] = mb_strtoupper($_POST['Keywords']); + //insert wildcard characters in spaces + $SearchString = '%' . str_replace(' ', '%', $_POST['Keywords']) . '%'; + $SQL = "SELECT supplierid, + suppname, + currcode, + address1, + address2, + address3, + address4 + FROM suppliers + WHERE suppname " . LIKE . " '$SearchString' + ORDER BY suppname"; + } elseif (mb_strlen($_POST['SupplierCode']) > 0) { + $_POST['SupplierCode'] = mb_strtoupper($_POST['SupplierCode']); + $SQL = "SELECT supplierid, + suppname, + currcode, + address1, + address2, + address3, + address4 + FROM suppliers + WHERE supplierid " . LIKE . " '%" . $_POST['SupplierCode'] . "%' + ORDER BY supplierid"; + } + } //one of keywords or SupplierCode was more than a zero length string + $result = DB_query($SQL, $db); + if (DB_num_rows($result) == 1) { + $myrow = DB_fetch_array($result); + $SingleSupplierReturned = $myrow['supplierid']; + } +} //end of if search +if (isset($SingleSupplierReturned)) { /*there was only one supplier returned */ + $_SESSION['SupplierID'] = $SingleSupplierReturned; + unset($_POST['Keywords']); + unset($_POST['SupplierCode']); +} + +if (!isset($_POST['PageOffset'])) { + $_POST['PageOffset'] = 1; +} else { + if ($_POST['PageOffset'] == 0) { + $_POST['PageOffset'] = 1; + } +} + +if (isset($_POST['Suppliers'])) { + echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES,'UTF-8') . '" method="post">'; + echo '<div>'; + echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + echo '<p class="page_title_text"><img src="' . $rootpath . '/css/' . $theme . '/images/magnifier.png" title="' . _('Search') . '" alt="" />' . ' ' . _('Search for Suppliers') . '</p> + <table cellpadding="3" class="selection"> + <tr> + <td>' . _('Enter a partial Name') . ':</td> + <td>'; + if (isset($_POST['Keywords'])) { + echo '<input type="text" name="Keywords" value="' . $_POST['Keywords'] . '" size="20" maxlength="25" />'; + } else { + echo '<input type="text" name="Keywords" size="20" maxlength="25" />'; + } + echo '</td><td><b>' . _('OR') . '</b></td><td>' . _('Enter a partial Code') . ':</td><td>'; + if (isset($_POST['SupplierCode'])) { + echo '<input type="text" name="SupplierCode" value="' . $_POST['SupplierCode'] . '" size="15" maxlength="18" />'; + } else { + echo '<input type="text" name="SupplierCode" size="15" maxlength="18" />'; + } + echo '</td></tr></table><br /><div class="centre"><input type="submit" name="SearchSupplier" value="' . _('Search Now') . '" /></div>'; + echo '</div> + </form>'; +} + +if (isset($_POST['SearchSupplier'])) { + echo '<form action="' . htmlspecialchars($_SERVER['PHP_SELF'].'?identifier='.$identifier, ENT_QUOTES, 'UTF-8') . '" method="post">'; + echo '<div>'; + echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; + $ListCount = DB_num_rows($result); + $ListPageMax = ceil($ListCount / $_SESSION['DisplayRecordsMax']); + if (isset($_POST['Next'])) { + if ($_POST['PageOffset'] < $ListPageMax) { + $_POST['PageOffset'] = $_POST['PageOffset'] + 1; + } + } + if (isset($_POST['Previous'])) { + if ($_POST['PageOffset'] > 1) {... [truncated message content] |