From: <dai...@us...> - 2011-05-03 10:05:14
|
Revision: 4561 http://web-erp.svn.sourceforge.net/web-erp/?rev=4561&view=rev Author: daintree Date: 2011-05-03 10:05:05 +0000 (Tue, 03 May 2011) Log Message: ----------- quoting and locations fix Modified Paths: -------------- trunk/Credit_Invoice.php trunk/Currencies.php trunk/Locations.php Added Paths: ----------- trunk/doc/Change.log Removed Paths: ------------- trunk/doc/Change.log.html Modified: trunk/Credit_Invoice.php =================================================================== --- trunk/Credit_Invoice.php 2011-05-02 10:33:55 UTC (rev 4560) +++ trunk/Credit_Invoice.php 2011-05-03 10:05:05 UTC (rev 4561) @@ -47,7 +47,8 @@ custbranch.defaultlocation, custbranch.taxgroupid, stockmoves.loccode, - locations.taxprovinceid + locations.taxprovinceid, + currencies.decimalplaces FROM debtortrans INNER JOIN debtorsmaster ON debtortrans.debtorno = debtorsmaster.debtorno INNER JOIN custbranch ON @@ -59,6 +60,8 @@ stockmoves.transno=debtortrans.transno INNER JOIN locations ON stockmoves.loccode = locations.loccode + INNER JOIN currencies ON + debtorsmaster.currcode=currencies.currabrev WHERE debtortrans.transno = '" . $_GET['InvoiceNumber'] . "' AND debtortrans.type=10 AND stockmoves.type=10"; @@ -89,12 +92,12 @@ $_SESSION['CreditItems']->FreightCost = $myrow['ovfreight']; $_SESSION['CreditItems']->DispatchTaxProvince = $myrow['taxprovinceid']; $_SESSION['CreditItems']->GetFreightTaxes(); + $_SESSION['CreditItems']->CurrDecimalPlaces = $myrow['decimalplaces']; DB_free_result($GetInvHdrResult); /*now populate the line items array with the stock movement records for the invoice*/ - $LineItemsSQL = "SELECT stockmoves.stkmoveno, stockmoves.stockid, stockmaster.description, @@ -187,7 +190,7 @@ } //end of checks on returned data set DB_free_result($LineItemsResult); } else { - prnMsg( _('This invoice can not be credited using the automatic facility') . '<br>' . _('CRITICAL ERROR') . ': ' . _('Please report that a duplicate DebtorTrans header record was found for invoice') . ' ' . $SESSION['ProcessingCredit'],'warn'); + prnMsg( _('This invoice can not be credited using the automatic facility') . '<br />' . _('CRITICAL ERROR') . ': ' . _('Please report that a duplicate DebtorTrans header record was found for invoice') . ' ' . $SESSION['ProcessingCredit'],'warn'); include('includes/footer.inc'); exit; } //valid invoice record returned from the entered invoice number @@ -314,20 +317,20 @@ if ($LnItm->Controlled==1){ - echo "<td><input type=hidden name='Quantity_" . $LnItm->LineNumber ."' value=" . $LnItm->QtyDispatched . "><a href='$rootpath/CreditItemsControlled.php?" . SID . "&LineNo=" . $LnItm->LineNumber . "&CreditInvoice=Yes'>" . $LnItm->QtyDispatched . "</a></td>"; + echo '<td><input type=hidden name="Quantity_' . $LnItm->LineNumber .'" value=' . $LnItm->QtyDispatched . '><a href="' . $rootpath . '/CreditItemsControlled.php?LineNo=' . $LnItm->LineNumber . '&CreditInvoice=Yes">' . $LnItm->QtyDispatched . '</a></td>'; } else { - echo "<td><input tabindex=".$j." type=text class=number name='Quantity_" . $LnItm->LineNumber ."' maxlength=6 size=6 value=" . $LnItm->QtyDispatched . "></td>"; + echo '<td><input tabindex=' . $j . ' type="text" class="number" name="Quantity_' . $LnItm->LineNumber .'" maxlength=6 size=6 value=' . $LnItm->QtyDispatched . '></td>'; } - $DisplayLineTotal = number_format($LineTotal,2); + $DisplayLineTotal = number_format($LineTotal,$_SESSION['CreditItems']->CurrDecimalPlaces); $j++; - echo "<td><input tabindex=".$j." type=text class=number name='Price_" . $LnItm->LineNumber . "' maxlength=12 size=6 VALUE=" . $LnItm->Price . "></td> - <td><input tabindex=".$j." type=text class=number name='Discount_" . $LnItm->LineNumber . "' maxlength=3 size=3 VALUE=" . ($LnItm->DiscountPercent * 100) . "></td> - <td class=number>$DisplayLineTotal</td>"; + echo '<td><input tabindex=' . $j . ' type=text class=number name="Price_' . $LnItm->LineNumber . '" maxlength=12 size=6 value=' . $LnItm->Price . '></td> + <td><input tabindex=' . $j . ' type=text class="number" name="Discount_' . $LnItm->LineNumber . '" maxlength=3 size=3 value=' . ($LnItm->DiscountPercent * 100) . '></td> + <td class=number>' . $DisplayLineTotal . '</td>'; /*Need to list the taxes applicable to this line */ echo '<td>'; @@ -335,14 +338,14 @@ if (is_array($_SESSION['CreditItems']->LineItems[$LnItm->LineNumber]->Taxes) ){ foreach ($_SESSION['CreditItems']->LineItems[$LnItm->LineNumber]->Taxes AS $Tax) { if ($i>0){ - echo '<br>'; + echo '<br />'; } echo $Tax->TaxAuthDescription; $i++; } } echo '</td>'; - echo '<td class=number>'; + echo '<td class="number">'; } $i=0; // initialise the number of taxes iterated through @@ -353,10 +356,10 @@ } foreach ($LnItm->Taxes as $Tax) { if ($i>0){ - echo '<br>'; + echo '<br />'; } if (!isset($_POST['ProcessCredit'])) { - echo '<input type=text class=number name="' . $LnItm->LineNumber . $Tax->TaxCalculationOrder . + echo '<input type=text class="number" name="' . $LnItm->LineNumber . $Tax->TaxCalculationOrder . '_TaxRate" maxlength=4 size=4 value="' . $Tax->TaxRate*100 . '">'; } $i++; @@ -372,17 +375,17 @@ } $TaxTotal += $TaxLineTotal; - $DisplayTaxAmount = number_format($TaxLineTotal ,2); - $DisplayGrossLineTotal = number_format($LineTotal+ $TaxLineTotal,2); + $DisplayTaxAmount = number_format($TaxLineTotal ,$_SESSION['CreditItems']->CurrDecimalPlaces); + $DisplayGrossLineTotal = number_format($LineTotal+ $TaxLineTotal,$_SESSION['CreditItems']->CurrDecimalPlaces); if (!isset($_POST['ProcessCredit'])) { echo '</td>'; echo '<td class=number>' . $DisplayTaxAmount . '</td> - <td class=number>' . $DisplayGrossLineTotal . "</td> - <td><a href='". $_SERVER['PHP_SELF'] . "?" . SID . "&Delete=" . $LnItm->LineNumber . "'>" . _('Delete') . '</a></td></tr>'; + <td class=number>' . $DisplayGrossLineTotal . '</td> + <td><a href="' . $_SERVER['PHP_SELF'] . '?Delete=' . $LnItm->LineNumber . '">' . _('Delete') . '</a></td></tr>'; - echo '<tr'.$RowStarter . "><td colspan=12><TEXTAREA tabindex=".$j." name='Narrative_" . $LnItm->LineNumber . "' cols=100% rows=1>" . $LnItm->Narrative . "</TEXTAREa><br><hr></td></tr>"; + echo '<tr' . $RowStarter . '><td colspan=12><textarea tabindex=' . $j .' name="Narrative_' . $LnItm->LineNumber . '" cols=100% rows=1>' . $LnItm->Narrative . '</textarea><br /><hr></td></tr>'; $j++; } } /*end foreach loop displaying the invoice lines to credit */ @@ -405,7 +408,7 @@ $i=0; // initialise the number of taxes iterated through foreach ($_SESSION['CreditItems']->FreightTaxes as $FreightTaxLine) { if ($i>0){ - echo '<br>'; + echo '<br />'; } echo $FreightTaxLine->TaxAuthDescription; $i++; @@ -416,7 +419,7 @@ $i=0; foreach ($_SESSION['CreditItems']->FreightTaxes as $FreightTaxLine) { if ($i>0){ - echo '<br>'; + echo '<br />'; } if (!isset($_POST['ProcessCredit'])) { @@ -435,13 +438,13 @@ if (!isset($_POST['ProcessCredit'])) { echo '</td>'; - echo '<td class="number">' . number_format($FreightTaxTotal,2) . '</td> - <td class="number">' . number_format($FreightTaxTotal+ $_SESSION['CreditItems']->FreightCost,2) . '</td> + echo '<td class="number">' . number_format($FreightTaxTotal,$_SESSION['CreditItems']->CurrDecimalPlaces) . '</td> + <td class="number">' . number_format($FreightTaxTotal+ $_SESSION['CreditItems']->FreightCost,$_SESSION['CreditItems']->CurrDecimalPlaces) . '</td> </tr>'; } $TaxTotal += $FreightTaxTotal; -$DisplayTotal = number_format($_SESSION['CreditItems']->total + $_SESSION['CreditItems']->FreightCost,2); +$DisplayTotal = number_format($_SESSION['CreditItems']->total + $_SESSION['CreditItems']->FreightCost,$_SESSION['CreditItems']->CurrDecimalPlaces); if (!isset($_POST['ProcessCredit'])) { echo '<tr> @@ -449,7 +452,7 @@ <td class=number><hr><b>' . $DisplayTotal . '</b><hr></td> <td colspan=2></td> <td class=number><hr><b>' . number_format($TaxTotal,2) . '<hr></td> - <td class=number><hr><b>' . number_format($TaxTotal+($_SESSION['CreditItems']->total + $_SESSION['CreditItems']->FreightCost),2) . '</b><hr></td> + <td class=number><hr><b>' . number_format($TaxTotal+($_SESSION['CreditItems']->total + $_SESSION['CreditItems']->FreightCost),$_SESSION['CreditItems']->CurrDecimalPlaces) . '</b><hr></td> </tr></table>'; } $DefaultDispatchDate = Date($_SESSION['DefaultDateFormat']); @@ -504,7 +507,6 @@ $Result = DB_query($SQL,$db); $myrow = DB_fetch_row($Result); - /*Do some rounding */ $_SESSION['CreditItems']->total = round($_SESSION['CreditItems']->total,2); @@ -1442,9 +1444,9 @@ echo '<div class="centre">'._('Credit Note number') . ' ' . $CreditNo . ' ' . _('has been processed'); if ($_SESSION['InvoicePortraitFormat']==0){ - echo "<br /><a href='". $rootpath . "/PrintCustTrans.php?" . SID . "&FromTransNo=" . $CreditNo . "&InvOrCredit=Credit&PrintPDF=True'>" . _('Print this credit note') . '</a>'; + echo '<br /><a href="' . $rootpath . '/PrintCustTrans.php?FromTransNo=' . $CreditNo . '&InvOrCredit=Credit&PrintPDF=True">' . _('Print this credit note') . '</a>'; } else { - echo "<br /><a href='". $rootpath . "/PrintCustTransPortrait.php?" . SID . "&FromTransNo=" . $CreditNo . "&InvOrCredit=Credit&PrintPDF=True'>" . _('Print this credit note') . '</a>'; + echo '<br /><a href="' . $rootpath . '/PrintCustTransPortrait.php?FromTransNo=' . $CreditNo . '&InvOrCredit=Credit&PrintPDF=True">' . _('Print this credit note') . '</a>'; } echo '</div>'; /*end of process credit note */ @@ -1452,21 +1454,22 @@ } else { /*Process Credit NOT set so allow inputs to set up the credit note */ - echo "<br><table class=selection>"; + echo '<br /><table class=selection>'; - echo '<tr><td>' . _('Credit Note Type') . "</td><td><select tabindex=".$j." name=CreditType>"; + echo '<tr><td>' . _('Credit Note Type') . '</td> + <td><select tabindex=' . $j .' name="CreditType">'; - if (!isset($_POST['CreditType']) OR $_POST['CreditType']=="Return"){ + if (!isset($_POST['CreditType']) OR $_POST['CreditType']=='Return'){ echo '<option selected value="Return">' . _('Goods returned to store') . '</option>'; - echo '<option VALUE="WriteOff">' . _('Goods written off') . '</option>'; - echo '<option VALUE="ReverseOverCharge">' . _('Reverse overcharge') . '</option>'; + echo '<option value="WriteOff">' . _('Goods written off') . '</option>'; + echo '<option value="ReverseOverCharge">' . _('Reverse overcharge') . '</option>'; } elseif($_POST['CreditType']=='WriteOff') { echo '<option selected value="WriteOff">' . _('Goods written off') . '</option>'; - echo '<option VALUE="Return">' . _('Goods returned to store') . '</option>'; - echo '<option VALUE="ReverseOverCharge">' . _('Reverse overcharge') . '</option>'; + echo '<option value="Return">' . _('Goods returned to store') . '</option>'; + echo '<option value="ReverseOverCharge">' . _('Reverse overcharge') . '</option>'; } else { - echo '<option VALUE="WriteOff">' . _('Goods written off') . '</option>'; - echo '<option VALUE="Return">' . _('Goods returned to store') . '</option>'; + echo '<option value="WriteOff">' . _('Goods written off') . '</option>'; + echo '<option value="Return">' . _('Goods returned to store') . '</option>'; echo '<option selected value="ReverseOverCharge">' . _('Reverse overcharge') . '</option>'; } echo '</select></td></tr>'; @@ -1478,7 +1481,7 @@ echo '<tr><td>' . _('Goods returned to location') . '</td><td><select tabindex='.$j.' name=Location>'; - $SQL='SELECT loccode, locationname FROM locations'; + $SQL="SELECT loccode, locationname FROM locations"; $Result = DB_query($SQL,$db); if (!isset($_POST['Location'])){ @@ -1487,24 +1490,24 @@ while ($myrow = DB_fetch_array($Result)) { if ($_POST['Location']==$myrow['loccode']){ - echo "<option selected VALUE='" . $myrow['loccode'] . "'>" . $myrow['locationname']; + echo '<option selected value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; } else { - echo "<option VALUE='" . $myrow['loccode'] . "'>" . $myrow['locationname']; + echo '<option value="' . $myrow['loccode'] . '">' . $myrow['locationname'] . '</option>'; } } - echo "</select></td></tr>"; + echo '</select></td></tr>'; $j++; } elseif($_POST['CreditType']=='WriteOff') { /* the goods are to be written off to somewhere */ - echo '<tr><td>' . _('Write off the cost of the goods to') . '</td><td><select TABINDEX='.$j.' name="WriteOffGLCode">'; + echo '<tr><td>' . _('Write off the cost of the goods to') . '</td><td><select tabindex=' . $j .' name="WriteOffGLCode">'; - $SQL='SELECT accountcode, + $SQL="SELECT accountcode, accountname - FROM chartmaster, accountgroups - WHERE chartmaster.group_=accountgroups.groupname - AND ccountgroups.pandl=1 ORDER BY chartmaster.accountcode'; - + FROM chartmaster, accountgroups + WHERE chartmaster.group_=accountgroups.groupname + AND ccountgroups.pandl=1 ORDER BY chartmaster.accountcode"; + $Result = DB_query($SQL,$db); while ($myrow = DB_fetch_array($Result)) { @@ -1521,8 +1524,8 @@ $_POST['CreditText'] = ''; } $j++; - echo '<tr><td>' . _('Credit note text') . '</td><td><textarea tabindex='.$j.' name=CreditText cols=31 rows=5>' . $_POST['CreditText'] . '</textarea></td></tr>'; - echo '</table><br><div class="centre"><input TABINDEX='.$j.' type=submit name=Update Value=' . _('Update') . '><p>'; + echo '<tr><td>' . _('Credit note text') . '</td><td><textarea tabindex=' . $j . ' name=CreditText cols=31 rows=5>' . $_POST['CreditText'] . '</textarea></td></tr>'; + echo '</table><br /><div class="centre"><input tabindex=' . $j . ' type=submit name=Update Value=' . _('Update') . '><p>'; $j++; echo '<input type="submit" tabindex='.$j++.' name="ProcessCredit" Value="' . _('Process Credit') .'"></div>'; } Modified: trunk/Currencies.php =================================================================== --- trunk/Currencies.php 2011-05-02 10:33:55 UTC (rev 4560) +++ trunk/Currencies.php 2011-05-03 10:05:05 UTC (rev 4561) @@ -1,7 +1,6 @@ <?php -/* $Revision: 1.20 $ */ + /* $Id$*/ -//$PageSecurity = 9; include('includes/session.inc'); $title = _('Currencies Maintenance'); @@ -141,7 +140,7 @@ if ($myrow[0] > 0) { prnMsg(_('Cannot delete this currency because customer accounts have been created referring to this currency') . - '<br>' . _('There are') . ' ' . $myrow[0] . ' ' . _('customer accounts that refer to this currency'),'warn'); + '<br />' . _('There are') . ' ' . $myrow[0] . ' ' . _('customer accounts that refer to this currency'),'warn'); } else { $sql= "SELECT COUNT(*) FROM suppliers WHERE suppliers.currcode = '".$SelectedCurrency."'"; $result = DB_query($sql,$db); @@ -149,14 +148,14 @@ if ($myrow[0] > 0) { prnMsg(_('Cannot delete this currency because supplier accounts have been created referring to this currency') - . '<br>' . _('There are') . ' ' . $myrow[0] . ' ' . _('supplier accounts that refer to this currency'),'warn'); + . '<br />' . _('There are') . ' ' . $myrow[0] . ' ' . _('supplier accounts that refer to this currency'),'warn'); } else { $sql= "SELECT COUNT(*) FROM banktrans WHERE banktrans.currcode = '" . $SelectedCurrency . "'"; $result = DB_query($sql,$db); $myrow = DB_fetch_row($result); if ($myrow[0] > 0){ prnMsg(_('Cannot delete this currency because there are bank transactions that use this currency') . - '<br>' . ' ' . _('There are') . ' ' . $myrow[0] . ' ' . _('bank transactions that refer to this currency'),'warn'); + '<br />' . ' ' . _('There are') . ' ' . $myrow[0] . ' ' . _('bank transactions that refer to this currency'),'warn'); } elseif ($FunctionalCurrency==$SelectedCurrency){ prnMsg(_('Cannot delete this currency because it is the functional currency of the company'),'warn'); } else { @@ -216,17 +215,17 @@ } if ($myrow[1]!=$FunctionalCurrency){ - printf("<td><img src=\"%s\"></td> + printf('<td><img src="%s"></td> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> <td class=number>%s</td> <td class=number>%s</td> - <td><a href=\"%s&SelectedCurrency=%s\">%s</a></td> - <td><a href=\"%s&SelectedCurrency=%s&delete=1\">%s</a></td> - <td><a href=\"%s/ExchangeRateTrend.php?%s\">" . _('Graph') . "</a></td> - </tr>", + <td><a href="%s&SelectedCurrency=%s">%s</a></td> + <td><a href="%s&SelectedCurrency=%s&delete=1">%s</a></td> + <td><a href="%s/ExchangeRateTrend.php?%s">' . _('Graph') . '</a></td> + </tr>', $ImageFile, $myrow[1], $myrow[0], @@ -234,23 +233,23 @@ $myrow[3], number_format($myrow[4],5), number_format(GetCurrencyRate($myrow[1],$CurrencyRatesArray),5), - $_SERVER['PHP_SELF'] . '?' . SID, + $_SERVER['PHP_SELF'] . '?', $myrow[1], _('Edit'), - $_SERVER['PHP_SELF'] . '?' . SID, + $_SERVER['PHP_SELF'] . '?', $myrow[1], _('Delete'), $rootpath, - SID . '&CurrencyToShow=' . $myrow[1]); + '&CurrencyToShow=' . $myrow[1]); } else { - printf("<td><img src=\"%s\"></td> + printf('<td><img src="%s"></td> <td>%s</td> <td>%s</td> <td>%s</td> <td>%s</td> <td class=number>%s</td> <td colspan=4>%s</td> - </tr>", + </tr>', $ImageFile, $myrow[1], $myrow[0], @@ -261,19 +260,19 @@ } } //END WHILE LIST LOOP - echo '</table><br>'; + echo '</table><br />'; } //end of ifs and buts! if (isset($SelectedCurrency)) { - echo '<div class="centre"><a href=' .$_SERVER['PHP_SELF'] . '?' . SID. '>'._('Show all currency definitions').'</a></div>'; + echo '<div class="centre"><a href="' .$_SERVER['PHP_SELF'] . '">'._('Show all currency definitions').'</a></div>'; } -echo '<br>'; +echo '<br />'; if (!isset($_GET['delete'])) { - echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>'; + echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '">'; echo '<input type="hidden" name="FormID" value="' . $_SESSION['FormID'] . '" />'; if (isset($SelectedCurrency) AND $SelectedCurrency!='') { @@ -300,12 +299,11 @@ - echo '<input type="hidden" name="SelectedCurrency" VALUE="' . $SelectedCurrency . '">'; - echo '<input type="hidden" name="Abbreviation" VALUE="' . $_POST['Abbreviation'] . '">'; + echo '<input type="hidden" name="SelectedCurrency" value="' . $SelectedCurrency . '">'; + echo '<input type="hidden" name="Abbreviation" value="' . $_POST['Abbreviation'] . '">'; echo '<table class=selection><tr> <td>' . _('ISO 4217 Currency Code').':</td> - <td>'; - echo $_POST['Abbreviation'] . '</td></tr>'; + <td>' . $_POST['Abbreviation'] . '</td></tr>'; } else { //end of if $SelectedCurrency only do the else when a new record is being entered if (!isset($_POST['Abbreviation'])) {$_POST['Abbreviation']='';} @@ -316,27 +314,35 @@ echo '<tr><td>'._('Currency Name').':</td>'; echo '<td>'; - if (!isset($_POST['CurrencyName'])) {$_POST['CurrencyName']='';} + if (!isset($_POST['CurrencyName'])) { + $_POST['CurrencyName']=''; + } echo '<input ' . (in_array('CurrencyName',$Errors) ? 'class="inputerror"' : '' ) .' type="text" name="CurrencyName" size=20 maxlength=20 VALUE="' . $_POST['CurrencyName'] . '">'; echo '</td></tr>'; echo '<tr><td>'._('Country').':</td>'; echo '<td>'; - if (!isset($_POST['Country'])) {$_POST['Country']='';} + if (!isset($_POST['Country'])) { + $_POST['Country']=''; + } echo '<input ' . (in_array('Country',$Errors) ? 'class="inputerror"' : '' ) .' type="text" name="Country" size=30 maxlength=50 VALUE="' . $_POST['Country'] . '">'; echo '</td></tr>'; echo '<tr><td>'._('Hundredths Name').':</td>'; echo '<td>'; - if (!isset($_POST['HundredsName'])) {$_POST['HundredsName']='';} - echo '<input ' . (in_array('HundredsName',$Errors) ? 'class="inputerror"' : '' ) .' type="text" name="HundredsName" size=10 maxlength=15 VALUE="'. $_POST['HundredsName'].'">'; + if (!isset($_POST['HundredsName'])) { + $_POST['HundredsName']=''; + } + echo '<input ' . (in_array('HundredsName',$Errors) ? 'class="inputerror"' : '' ) .' type="text" name="HundredsName" size=10 maxlength=15 value="'. $_POST['HundredsName'].'">'; echo '</td></tr>'; echo '<tr><td>'._('Exchange Rate').':</td>'; echo '<td>'; - if (!isset($_POST['ExchangeRate'])) {$_POST['ExchangeRate']='';} - echo '<input ' . (in_array('ExchangeRate',$Errors) ? 'class="inputerror"' : '' ) .' type="text" class=number name="ExchangeRate" size=10 maxlength=9 VALUE='. $_POST['ExchangeRate'].'>'; + if (!isset($_POST['ExchangeRate'])) { + $_POST['ExchangeRate']=''; + } + echo '<input ' . (in_array('ExchangeRate',$Errors) ? 'class="inputerror"' : '' ) .' type="text" class=number name="ExchangeRate" size=10 maxlength=9 value='. $_POST['ExchangeRate'].'>'; echo '</td></tr>'; echo '</table>'; - echo '<br><div class="centre"><input type="Submit" name="submit" value='._('Enter Information').'></div>'; + echo '<br /><div class="centre"><input type="Submit" name="submit" value='._('Enter Information').'></div>'; echo '</form>'; Modified: trunk/Locations.php =================================================================== --- trunk/Locations.php 2011-05-02 10:33:55 UTC (rev 4560) +++ trunk/Locations.php 2011-05-03 10:05:05 UTC (rev 4561) @@ -374,7 +374,6 @@ printf('<td>%s</td> <td>%s</td> <td>%s</td> - <td>%s</td> <td><a href="%sSelectedLocation=%s">' . _('Edit') . '</td> <td><a href="%sSelectedLocation=%s&delete=1">' . _('Delete') . '</td> </tr>', @@ -449,8 +448,8 @@ $_POST['Managed'] = $myrow['managed']; - echo '<input type="hidden" name="SelectedLocation" value="' . $SelectedLocation . '>'; - echo '<input type="hidden" name="LocCode" value="' . $_POST['LocCode'] . '>'; + echo '<input type="hidden" name="SelectedLocation" value="' . $SelectedLocation . '">'; + echo '<input type="hidden" name="LocCode" value="' . $_POST['LocCode'] . '">'; echo '<table class="selection">'; echo '<tr><th colspan=2><font size=3 color=blue>'._('Amend Location details').'</font></th></tr>'; echo '<tr><td>' . _('Location Code') . ':</td><td>'; Added: trunk/doc/Change.log =================================================================== --- trunk/doc/Change.log (rev 0) +++ trunk/doc/Change.log 2011-05-03 10:05:05 UTC (rev 4561) @@ -0,0 +1,3271 @@ +webERP Change Log + +3/5/11 Locations.php fix table hidden POST variable quotes mismatch - also mismatch between number of parameters in printf output +2/5/11 Make order entry show the currency decimal places for amounts and totals also in invoicing SelectOrderItems.php and ConfirmDispatch_Invoice.php +2/5/11 Fix PO_PDFPurchOrder.php to allow emailing but email option not to appear on printed/emailed orders +1/5/11 Tim PageSecurity.php fix bug that prevented updates to Security Token for a particular script. +1/5/11 Many scripts quoting changes single quotes for strings double quotes for xhtml variables +1/5/11 SecuirtyTokens allow deletion of tokens if no scripts using it +28/4/11 Tim - add facility to select an account group to limit GL acccounts returned as options to post payments to +28/4/11 Tim - new SecurityTokens script +28/4/11 Fix Secunia reported vulnerability by checking for dodgy characters in CompanyNameField - then matched to a real directory on the web-server + +18/4/11 - Version 4.03.8 Release + +18/4/11 Phil: Update zh_HK.utf8, pt_BR.utf8, fa_IR.utf8 from launchpad translations +18/4/11 Phil: Changed PurchData.php back to now have free form text entry of unit of measure - as suggested by Brian May - think it works better this way +18/4/11 Phil: Removed redundant fields that are not used anywhere from DefinePOClass and the various function to add lines to purchase orders and to update purhcase order lines - netweight, cuft, kgs, itemno, total_quantity etc. all this data can be retrieved without duplication in purchorderdetails +16/4/11 Phil: Tim's changes in launchpad fork to 4663 - xhtml syntax fixes +15/4/11 Phil: Copy Exson's traditional Chinese back to zh_HK.utf8 +11/4/11 Ricard: new pcAuthorizeExpenses.php that shows the current balance of the tab to the authorizer. Before the authorizer did not see this information. +11/4/11 Tim: StockLocTransfer.php added $_POST['LinesCounter'] -= 10; +11/4/11 Tim/Phil: Use PHP 5 specific scandir to sort languages into alphabetic order for UserSettings and WWW_Users language selection +10/4/11 Tim: AddCustomerContacts.php use single field rather than * in SQL> +10/4/11 Tim: GLAccountInquiry.php show None if no tag selected +10/4/11 Tim : PDFPrintLabel.php javascript fix +10/4/11 Tim: Add perishable to StockTransfer.php and PDFStockTransfer +10/4/11 Tim: PDFPeriodStockTransListing - new report to print off stock transactions of a specified type for a selected period>/p> +10/4/11 Tim: PDFStockTransListing.php option to print off transactions by inventory location +10/4/11 Tim: Stocks.php - more logical use of $New and $_POST['New'] +10/4/11 Tim: Payments.php PaymentMethods.php Add new field userpreprintedstationery to payment methods to determine whether to print cheques +5/4/11 Tim: includes/LanguageSetup.php - discovered solution to Turkish character set problem!! +5/4/11 Phil: couple of is_date functions left over from experiment to see if changing fixed Turkish - now removed from SupplierInvoice.php and PDFOrdersInvoiced.php +5/4/11 Phil: SuppCreditGRNs was not showing old GRNs and no way to input an older date +31/3/11 Phil:Fix link to create purchase order from purchasing data link on SelectProduct.php - thanks Brian May for pointing out the bug +31/3/11 Phil: Updated all tranlations from the launchpad site +31/3/11 Tim: Fix to make languages display immediately on change - session.inc moved includes/LanguageSetup.php down +30/3/11 Tim: New ReprintGRN.php script takes a purchase order and allows any line received to have GRN(s) reprinted +29/3/11 Phil: checking for unquoted SQL and for SQL where literals quoted with double quotes rather than single - double quotes are not ANSI compatible - so making the SQL more ANSI compatible by doing this as suggested by Tim. Many many scripts involved will take a week or so +<p /> +27/3/11 - Version 4.03.5 Release + +27/3/11: Phil fixed SQL upgrade script to add the Z_ChangeSupplierCode.php script is added to the scripts table +27/3/11: Phil fixed some SQL for ansi compatibility I had changed in error - would affect users running strict mode ansi +27/3/11: Phil at Brian May's suggestion added conversion factor to item look up in PO_Items.php - also ensured quantity entry no longer trapped for commas and commas removed from numbers before committing. Also trapped for committing purchase orders with no lines + +26/3/11 - Version 4.03 Release + +26/3/11: Phil added some error trapping to codes of pcTabTypes +24/3/11: Phil rework PDFStockTransfer.php remove a few round trips to DB and added facility to be able to select a transfer number to reprint - added to main menu +24/3/11: James wer...@ya... Added snall image in middle of SelectProduct.php +19/3/11: Phil added country to packing slips +18/3/11: Marcos Garcia Trejo Added Z_ChangeSupplierCode.php +18/3/11: Ricard add orderby transdate to DailyBankTransactions.php +18/3/11: Phil check for Customers.php CustomerBranches.php and Stocks.php now traps codes containing spaces - as well as other illegal characters +15/3/11: Phil PricesByCost.php - made it update prices where there is already a price starting on today's date +15/3/11: Phil SelectOrderItems.php customer selection now done using a hidden $_POST rather than parsing debtorno hyphen branchcode. +15/3/11: Phil Locations.php new field for CounterSales branch code - instead of parsing it from a single field with a hyphen in it. CounterSales.php now uses the new field for customer branch +14/3/11: Phil SelectSalesOrder.php now lists with sales order value denominated in functional currency with total of listed outstadning sales orders (or quotations) shown at the bottom of the listing +12/3/11: Tim Now allow space in codes +12/3/11: SelectSalesOrder.php now allows any number of sales orders to be selected and purchase orders placed for the aggregate of items on the selected sales orders +12/3/11: SuppPriceList.php removed a round trip to DB to get currency - fixed function to get pdf to new TCPDF Output +12/3/11: Exson fix all htmlentities to use ENTQUOTES, 'UTF-8' option so other character sets work with it +10/3/11: Phil fix pagination of PrintCustOrder_generic.php - second copy was not restarting page numbers +10/3/11: Tims launchpad fixes brought in MRP.php fix for table charset utf8 so joins work correctly; typeo in PO_Header preventing purchasing data being retrieved ($result not $Result); correct sql on searching for customer in SelectCreditItems.php; StockStatus.php pricing history bug resolved (4450); StockQuantityByDate.php now allowed to show for all categories - enclosed 'All' in gettext +8/3/11: Tim/Phil PO_Items.php in committing an order detail the assetid of 'Not an Asset' was being inserted to an integer field. Modified $_POST['AssetID'] to = 0 if it was 'Not an Asset' as advised by Tim +8/3/11: Phil fix SalesAnalysis reports for TCPDF as reported by Joe Zhou +5/3/11: Kovács Attila fix to Stocks.php to use ANSI GROUP BY for aggregate functions SQL +5/3/11: Kovács Attila fix to LanguageSetup.php to use utf-8 not ISO-8859-1. Phil hardcoded UTF-8 now as no dynamic changing of character set required all translations are utf-8 +3/3/11: Exson/Baran/Phil fix to customer login to ensure that other customers orders are not displayed when searching by customer ref or order no +3/3/11: Tim launchpad mods to revision 4441 including change to allow supplier currency to be changed if there are no transactions already against the supplier. Ensure credit note session variable is unset before attempting to create a new credit note from the supplier form. Tim's work to add perisable expiry dates to the serial items logic - affects quite a few scripts. Headings to stock check script even if no quantity is shown. Portrait quotations. Not included change to default delivery date to the date the customer requested - left to be the current day's date. Not included Tim's unit pricing work .. yet launchpad revisions 4442-4447 inclusive +27/2/11: Phil/Tim/Peter launchpad added category option for MRPShortages.php links with matching quotes in WorkOrderEntry +27/2/11: Phil StockUsage.php now totals usage each month even in months where there was none - average now includes months with no usage +27/2/11: Phil fix units deletion issue reported by Exson in UnitsOfMeasure.php script - checked for none existant units field in contracts table - removed the check +22/2/11: Phil fix PDFTopItems.php for changed variable names - now using CamelCase tried to rework to conform +22/2/11: Phil remove options for PDFLanguage that are not unique in WWW_Users.php - make it default to the users settings in the SESSION for UserSettings.php +18/2/11: Phil/Don Change PageSecurity array variable name to PageSecurityArray - caused problems with conflict with PageSecurity variable where register_globals = on; +18/2/11: PO_Items.php make number_format variables turn back into numbers for > 1000 +16/2/11: FixedAssetItems.php now checks for location before allowing additions +16/2/11: Company preferences - changed wording of stock integration at cost removed the word standard as suggested by Exson +16/2/11: SelectCreditItems.php formating/conventions lower case html and CreditInvoice.php +15/2/11: Phil Make invoicing warn the user when no taxes are defined for a tax group - i.e. there is a configuration error with taxes +<p /> +15/2/11 Release 4.03RC2 +<p /> +15/2/11: Phil UpgradeDatabase.php fix to upgrade from 4.01RC1 !! +15/2/11: Phil PrintCustTrans.php and PrintCustTransPortrait.php htmlspecialchars_decode($narrative) - conversion at the time of committing to DB needs to be unconverted. Also in ConfirmDispatch_Invoice.php +15/2/11: Phil SelectCustomer.php removed showing blank message when $msg was empty +<p /> +13/2/11 Release 4.03RC1 +<p /> +13/2/11:Phil GoodsReceivedControlled InputSerialItems and friends - now uses session identifier to ensure uniqueness is several people entering stock receipts +13/2/11:Phil Contracts.php SelectOrderItems.php customer selection mechanism reworked - was causing issues in Contracts as noted by DK Shukla +8/2/11: Tim Rework CounterSales.php so that it is now possible to sell items that have sales/purchasing tax +8/2/11: Phil Fix InventoryPlanning and InventoryPlanningPrefSupplier to only show sales order demand - excluding quotations. Also fixed for conversionfactor as now all purchase order quantities are in our normal stock units +8/2/11: Phil Fix incorrect layout of narrative on multiple lines of PDFQuotation.php as reported by Ricard Andreu +8/2/11: Tim/Ricard StockLocTransfer.php can now transfer the same amount as on hand in the location - previously checked to see that the transfer was less than the quantity on hand (when checking for negative stock) +8/2/11: Tim Payments.php and javascripts/MiscFunctions.js corrections to javascript +8/2/11: Phil PDFGrn.php turns out preview is used from the form modification script doh! Over simplificaton reversed to reinstate preview mode +6/2/11: Otandeka Removed debug prnMsg in FixedAssetDepreciation +5/2/11: Phil SystemParameters.php new option to AutoAuthorisePO when the user has authority to do so +5/2/11: Phil PO_Items.php fixed non-existant variables on Enter nominal line. Added option to automatically authorise when user is an authoriser as well as a creator +5/2/11: Phil PDFGrn.php rewrote - preview never used - simplified +4/2/11: Tim CostUpdate.php allow cost update with appropriate permissions token 10 hard coded +4/2/11: Phil SelectCustomer.php rejig selection options in more logical way. Used non-specific SQL to search by any part of the address +2/2/11: Phil PDFTopItems.php and TopItems.php removed mysql specific SQL +30/1/11: Phil GoodsReceived.php rework for supplier units and conversion factor etc now in PO class +30/1/11: Phil PDFGrn.php rework for supplier units and conversion factor etc now in PO class +30/1/11:Exson changed PDFLowGP report remove % from gettext string +29/1/11:Tim fix reportwriter with tcpdf using parent::__construct rather than $this->Cpdf( +24/1/11:Phil Depreciation fixes - SelectAsset by description fix +23/1/11:Peter Otandeka: PDFTopItems.php SQL quoting fixes +23/1/11: Phil Fix Depreciation posting and dates of end of periods +23/1/11:Phil changed back references throughout several MRP scripts from is_date to Is_Date - as Is_Date is used throughout the code and much bigger job to change all references to is_date +20/1/11: Tim changed back addinfo calls to addInfo on PDF reports - Zhigio originally thought to be an issue with Turkish utf-8 pdfs but turned out to be a red herring. class.pdf call changed back to addInfo too - most of calls had not been changed to lower case info +20/1/11: Tim changed PricesBasedOnMarkUp to have end date day before new prices effective from +20/1/11: Phil FixedAssetRegister.php FixedAssetDepreciation.php fixes +19/1/11: Phil modified GLBudgets.php to allow entry of last years budget too +17/1/11: Phil More purchasing work removing redundant queries rationalising code - new layout with supplier units +15/1/11: Tim removed MX record check from IsEmail function in includes/MiscFunctions.php +15/1/11: Tim/Peter Otandeka SQL quoting a whole bunch of scripts - changing single quotes to doubles - didn't apply ones where no variables required quoting +14/1/11: Phil install scripts modified to copy over FormDesigns under the new company directory created +14/1/11: Phil Updates to manual for security and supplier invoice entry +13/1/11:Phil PO_Items.php remove redundant code, setup entry of lines in supplier units +13/1/11:Tim Z_ChangeCustomerCode.php now has foreign key checks defeated when deleting the old customer record and custbranch record +13/1/11:Phil SupplierInvoice.php and SupplierCredit.php now check to ensure the total of contracts fixed asset charges goods received charges, shipment charges and GL charges are at least equal to the amount of the invoice or credit. It was possible when GL interface turned off to get strange results +12/1/11:Phil DailyBankTransactions.php made it so a range of dates can be selected but defaults to just today +11/1/11:Phil Fix choice of portrait or landscape invoices - fix landscape default form layout. Fix portrait invoice logo position +11/1/11:Phil Fix customer transaction inquiries to show correct links where user is not authorised for credit notes or GL inquiries +11/1/11:Phil SupplierCredit.php and SupplierInvoice.php recalculate price variance to post differences on fixed asset additions correctly +11/1/11:Phil PO_PDFPurchOrder.php - fixed for coding conventions removed uneccessary sql calls +11/1/11: Murray Collingwood: Emailing invoices was writing the pdf file twice - once with fwrite and once with the TCPDF output function with the option 'F' +8/1/11 Ricard Andreu: Z_ChangeCustomerCode.php added typeid field that made change customer code fail. Also corrected typo for foreign key checking side stepping for Z_ChangeBranchCode.php +5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts +4/1/11 Paul T: Bug# 3151192 - insert underscore for superglobal. +5/1/11 Phil: Bug fixes AssetLocationTransfer and Supplier Contacts +4/1/11 Phil: Start rework of purchase order scripts ... again. +4/1/11 Phil: Select Purchase orders now defaults to just pending and authorised/printed - other statii are options +1/1/11 Phil: Upgrade script make capable of upgrades from any earlier version - and email a backup to the user. Deleted DBUpgradeNumber config variable now use the VersionNumber already there +31/12/10 Tim: Tidy up of CounterSales.php - CamelCasing, quoting SQL, closing slashes in xhtml tags +29/12/10 Phil: Reverted to single SQL upgrade file per release - but retaining Tim's upgrade mechanism if the DBUpgradeNumber is out of date. Removed pseudo SQL language required for upgrade script and the 52 update files - just applies plain vanilla SQL from the scripts required +29/12/10 Tim: DB upgrade mechanism with separate pseudo SQL for each database change in a separate file + 52 files of updates since 3.11.4 +21/12/10 Phil : Reworked PDFPrintLabels.php to conform to standards and corrected SQL for prices +21/12/10 Ricard Andreu: PDFPrintLabels.php was not checking for end date of prices - fixed +19/12/10 Phil: SelectOrderItems.php ConfirmDispatch_Invoice.php add code to handle asset disposals. +14/12/10 Phil: modify purchasing scripts for coding conventions/readability +11/12/10 Phil: Have populated the new field stockcheckdate in stockcheckfreeze and modified PDFStockCheckComparison to use this field when posting the GL - stockmoves need to be on the current day otherwise historical balances will all need to be updated. But narrative shows the date of the stock check for which the adjustment is being made +9/12/10 James Murray: highlighted a bug in SupplierInvoice.php (and also in SupplierCredit.php) where the due date of the invoice/credit was not calculated correctly based on the terms - it was picking up the current date rather than the invoice/credit date. Now fixed +8/12/10 James Murray: fixed bug in SuppPaymentRun.php - was not showing anything as the test to see if there was anything to see was using a non-existant result set! +3/12/10 Matt Elbrecht : Estonian translation +30/11/10 Phil: Changed table structure of new fixedassettrans and modified upgrade script - those who already ran that bit will need to change the table again. Modified fixed asset scripts again. New fixed assets manual +28/11/10 Exson: CreditStatus.php - Fix bug in sql statement +28/11/10 Tim: OutstandingGRNs.php - Only show when the invoiced qty is less than the GRN qty +28/11/10 Phil: All fixed asset scripts SupplierInvoice.php SupplierCredit.php SuppFixedAssetChgs.php - adding fixed assets directly from invoice charges - and reversing additions with credit notes. Also FixedAssetRegister.php report to print PDF or export CSV of fixed assets now includes date range depreciation and b/fwd cost b/fwd accum depn and c/fwd cost and accum depn - and NBV +28/11/10 James Murray: unset session in ConnectDB_mysqli.inc and ConnectDB_mysql.inc when the login fails +27/11/10 Phil: install/index.php check for critical requirements before allowing install to proceed +27/11/10 Phil: includes/DefinePOClass.php change variable to camel case also PO_Header.php PO_Items.php PO_ReadInOrder.inc GoodsReceived.php - scope for error needs lots of testing please +27/11/10 Phil: PurchData - fix MinOrderQty error trapping with appropriate text and default to 1 +27/11/10 Phil: SupplierInvoice.php removed check on weighted average costing to reverse GRN suspense posting and set cost to zero - this was defeating the price variance calculation and the proper valuation of stock. Also took out of the calculations the conversionfactor - will need to alter goods received code to ensure only our units recorded in quantity received. +26/11/10 Tim: upgrade3.11.1-4.00.sql - Add default date for stockcheckdate field in stockcheckfreeze table +26/11/10 Otandeka: CounterSales.php - Fix bug in counter sales script. +24/11/10 Phil: GoodsReceived.php - modified to insert fixedassettrans and to post nominal POs to fixed asset cost account from fixedassetcategories.costact +23/11/10 Pak Ricard: MRP.php and MRPShortages.php fixed temporary tables to use utf-8 - code failed without probably depends on mysql server settings +21/11/10 Phil:Rewritten FixedAssetJournal.php - renamed FixedAssetDepreciation.php +20/11/10 Phil: Rewritten FixedAssetItems.php FixedAssetCategories.php and modified FixedAssetLocations.php to use the new structure +18/11/10 Tim: upgrade3.11.1-4.00.sql - Fix sql syntax errors brought in on recent changes. +14/11/10 Phil: SelectAsset.php script reworked SelectAssetType.php script now deleted +08/11/10 Exson: Z_ImportStocks.php - Bug fixes. +06/11/10 Phil: ShiptChgs.php - made a check to ensure a shipment reference entered manully actually exists before it is added - otherwise a nasty error occurs on commital of the invoice +06/11/10 Paul T: InputSerialItemsSequential.php - Bug# 3080130 - Add new FormID to form. (and minor cleanup) +06/11/10 Tim: ReorderLevelLocation.php - Remove fixed assets from selections +06/11/10 Tim: ReorderLevel.php - Remove fixed assets from selections +06/11/10 Tim: InventoryQuantities.php - Remove fixed assets from selections +06/11/10 Tim: Selectproduct.php - Remove fixed assets from selections +06/11/10 Tim: InventoryValuation.php - Ensure fixed assets dont get shown in valuation report +06/11/10 Tim: FixedAssetItems.php - Fixed typo preventing Item code being shown +06/11/10 Phil: StockCategory.php FixedAssetCategory.php attempt to add validation to depreciation rates by extending the stock category property logic with new fields for numericvalue, minimumvalue and maximumvalue. Then adding the depreciation rate percentage property to expect numeric values with a minimum of 0 and maximum of 100. +05/11/10 Tim: PurchData.php. Converted field name to lower case for consistency +05/11/10 Tim: SelectProduct.php. Change the standard order quantities to agree with Minimum order qty +05/11/10 Tim: PurchData.php. Make the Minimum order quantity field numeric only +05/11/10 Poul Bjerre-Jensen: SelectProduct.php,PurchData.php. Add in Minimum order quantity to Purchasing data +02/11/10 Tim: SelectCustomer.php. Correction to work with debtors that have a - in the code +31/10/10 Tim: SuppTransGLAnalysis.php. Minor bug fixes +31/10/10 Tim: SuppTransGLAnalysis.php. Force the user to select a GL account code instaed of defaulting to first on the list +31/10/10 Tim: CustomerReceipt.php. Force the user to select a GL account code and a Bank Account instaed of defaulting to first on the list +29/10/10 Tim: index.php. If CustomerReceipt selected from the GL menu then go to GL receipts else customer receipts +29/10/10 Tim: Payments.php. Force the user to select a GL account code and a Bank Account instaed of defaulting to first on the list +29/10/10 Tim: GLJournal.php. Force the user to select a GL account code instaed of defaulting to first on the list +28/10/10 Tim: Fix bug # 3017709. When bulk transfers are received for controlled items serial numbers are required +28/10/10 Tim: PcExpensesTypeTab.php - SQL quoting corrections and layout changes and improvements +28/10/10 Tim: PcTabs.php - SQL quoting corrections and layout changes and improvements +28/10/10 Tim: PcTypeTabs.php - SQL quoting corrections and layout changes and improvements +27/10/10 Tim: PcReportTab.php - SQL quoting corrections and layout changes and improvements +27/10/10 Tim: PcClaimExpensesFromTab.php - SQL quoting corrections and layout changes and improvements +27/10/10 Tim: class.pdf.php - Fix bug in html_entity_decode() function call +27/10/10 d.k shukla: ManualPurchaseOrdering.html - Improvements to purchase ordering manual +27/10/10 Tim: WorkOrderEntry.php - When the quantities are changed, then the correct quantities are updated, and the date picker chooses the correct date. +27/10/10 Tim: header.inc - Correct for non ascii characters +27/10/10 Tim: Corrections to display multi line invoice narratives correctly +26/10/10 Tim: Discountmatrix.php - Fix discount category bug +26/10/10 Tim: Discountmatrix.php - Increase the number of decimal places that can be entered +26/10/10 Tim: StockLocTransfer.php - Check there is sufficient stock for the transfer +25/10/10 Marcos Garcia Trejo: New labelprinting functionality +25/10/10 ChenJohn: class.pdf.php - correctly display some html encoded special characters, to make them human readeable in pdf file. +23/10/10 Phil: PurchData.php - search by name failed concatenation of SQL stuffed now repaired. + +Version 4.0RC1 +22 October 2010 + +20/10/10 Paul: MiscFunctions.js - Bug #3060329. Correct condition check. [allows the calendar to start with the textbox's date] +18/10/10 Paul: WorkOrderReceive.php - Bug #3023776. Applied anonymous contribution. +16/10/10 Phil: SupplierInvocie.php fixed for mix up with commits - now shipment charges added correctly and contract charges also +14/10/10 Tim: MiscFunctions.php - Fix bug preventing download of ECB rates +13/10/10 Tim: WWW_Users.php - Show the last visit date correctly. Fixes bug 3085860 +09/10/10 Phil: Added xmlrpc_GetStockCategoryList api method +04/10/10 Matt Taylor: upgrade3.11.1-3.12.sql - Update tables to utf8 +03/10/10 Gabriel Olowo: ManualPurchaseOrdering.php - Manual for purchase ordering system +02/10/10 Tim: AuditTrail.php - Bug fixes and layout changes +02/10/10 Tim: DailySalesInquiry.php - Bug fixes and layout changes +02/10/10 Tim: session.inc - Corrections to sql quoting. Resolves bug 3023782 +02/10/10 Tim: ppdf_tpl.php - Make php 5.3 compatible +02/10/10 Tim: GLJournal.php - Fix to create a reversing journal even when non english language is used. +02/10/10 Tim: PDFGrnHeader.php - Show correct column headings. Fixes bug 3072507 +30/09/10 Tim: Add form verification to prevent form spoofing +30/09/10 Tim: WWW_Users.php - SQL quoting corrections and layout changes and improvements +30/09/10 Tim: WWW_Access.php - SQL quoting corrections and layout changes and improvements +29/09/10 Tim: WOSerialNos.php - SQL quoting corrections +29/09/10 Tim: WorkOrderStatus.php - SQL quoting corrections and layout changes and improvements +29/09/10 Tim: WorkOrderReceive.php - SQL quoting corrections and layout changes and improvements +29/09/10 Tim: WorkOrderIssue.php - SQL quoting corrections and layout changes and improvements +29/09/10 Tim: WorkOrderEntry.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: WorkOrderCosting.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: WorkCentres.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: WhereUsedInquiry.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: UserSettings.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: UnitsOfMeasure.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TopItems.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TaxProvinces.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TaxGroups.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TaxCategories.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TaxAuthorityRates.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: TaxAuthorities.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: Tax.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: SystemParameters.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: SuppTransGLAnalysis.php - SQL quoting corrections and layout changes and improvements +28/09/10 Tim: SuppShiptCharges.php - Layout changes and improvements +28/09/10 Tim: SuppPriceList.php - Layout changes and improvements +27/09/10 Paul Thursby: Various default.css files -- Minor CSS corrections. +27/09/10 Tim: SuppPaymentRun.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SuppLoginSetup.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierTypes.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierTransInquiry.php - New script to show detail supplier transactions +27/09/10 Tim: SupplierTenders.php - SQL quoting corrections +27/09/10 Tim: Suppliers.php - SQL quoting corrections +27/09/10 Tim: SupplierInvoice.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierInquiry.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierCredit.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierContacts.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SupplierBalsAtPeriodEnd.php - Layout changes and improvements +27/09/10 Tim: SupplierAllocations.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SuppInvGRNs.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: SuppCreditGRNs.php - SQL quoting corrections and layout changes and improvements +27/09/10 Tim: StockUsage.php - Layout changes and improvements +26/09/10 Tim: StockTransfers.php - Layout changes and improvements +26/09/10 Tim: StockSerialItemResearch.php - Layout changes and improvements +26/09/10 Tim: StockReorderLevel.php - SQL quoting corrections and layout changes and improvements +26/09/10 Tim: StockQuantityByDate.php - SQL quoting corrections and layout changes and improvements +26/09/10 Tim: StockQties_csv.php - Layout changes and improvements +26/09/10 Tim: StockMovements.php - Layout changes and improvements +26/09/10 Tim: StockLocStatus.php - SQL quoting corrections and layout changes and improvements and bug fixes +26/09/10 Tim: StockDispatch.php - SQL quoting corrections and layout changes and improvements and bug fixes +26/09/10 Tim: StockCounts.php - SQL quoting corrections and layout changes and improvements and bug fixes +26/09/10 Tim: StockCostUpdate.php - SQL quoting corrections and layout changes and improvements and bug fixes +26/09/10 Tim: StockCategories.php - SQL quoting corrections and layout changes and improvements and bug fixes +26/09/10 Tim: SpecialOrder.php - SQL quoting corrections +25/09/10 Tim: SMTPServer.php - SQL quoting corrections +25/09/10 Tim: ShiptsList.php - Add script to show list of open shipments for selected supplier +25/09/10 Tim: Shipt_Select.php - SQL quoting corrections and layout changes and improvements and bug fixes +25/09/10 Tim: Shippers.php - SQL quoting corrections and layout changes and improvements and bug fixes +25/09/10 Tim: Shipments.php - SQL quoting corrections and layout changes and improvements and bug fixes +25/09/10 Tim: ShipmentCosting.php - SQL quoting corrections and layout changes and improvements and bug fixes +25/09/10 Tim: SelectWorkOrder.php - SQL quoting corrections and layout changes and improvements and bug fixes +24/09/10 Tim: SelectSalesOrder.php - Layout changes and improvements and bug fixes +24/09/10 Tim: SelectRecurringSalesOrder.php - Layout changes and improvements and bug fixes +24/09/10 Tim: SelectProduct.php - SQL quoting corrections +24/09/10 Tim: SelectOrderItems.php - SQL quoting corrections +24/09/10 Tim: SelectGLAccount.php - SQL quoting corrections and layout changes and improvements and bug fixes +24/09/10 Tim: SelectCustomer.php - Layout changes and improvements and bug fixes +24/09/10 Tim: SelectCreditItems.php - SQL quoting corrections and layout changes and improvements and bug fixes +23/09/10 Tim: SelectAssetType.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesTypes.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesPeople.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesGraph.php - Fix deprecated use of assigning by reference +23/09/10 Tim: SalesGLPostings.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesCategories.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesAnalRepts.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: SalesAnalReptCols.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: ReverseGRN.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: ReorderLevelLocation.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: ReorderLevel.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: RecurringSalesOrdersProcess.php - SQL quoting corrections +23/09/10 Tim: RecurringSalesOrders.php - SQL quoting corrections and layout changes and improvements +23/09/10 Tim: DateFunctions.inc - mktime() function without paramaeters is now deprecated, replaced with time() +20/09/10 Pak Ricard: PricesByCost.php - Restrict price changes to those stock items not discontinued +14/09/10 Tim: PurchData.php - SQL quoting corrections and layout changes and improvements +14/09/10 Tim: PrintSalesOrder_generic.php - SQL quoting corrections +14/09/10 Tim: PrintCustTransPortrait.php - SQL quoting corrections and layout changes and improvements +13/09/10 Tim: PrintCustTrans.php - SQL quoting corrections and layout changes and improvements +13/09/10 Tim: PrintStatements.php - Small bug fixes +13/09/10 Tim: PrintCustOrder_Generic.php - Correct the sql quoting +13/09/10 Tim: PrintCustOrder.php - Correct the sql quoting +13/09/10 Tim: PricesBasedOnMarkup.php - Correct the sql quoting, and various layout improvements and bug fixes +13/09/10 Tim: Prices_Customer.php - Correct the sql quoting, and various layout improvements and bug fixes +13/09/10 Tim: Prices.php - Correct the sql quoting, and various layout improvements and bug fixes +13/09/10 Tim: POReport.php - Format correctly for screen and add in option to export as a csv file +11/09/10 Tim: PO_SelectPurchOrder.php - Correct the sql quoting, and various layout improvements +11/09/10 Tim: PO_SelectOSPurchOrder.php - Correct the sql quoting +11/09/10 Tim: PO_PDFPurchOrder.php - Correct the sql quoting +11/09/10 Otandeka: PDFPriceList.php - Corrected undefined offset error +11/09/10 Phil: Manual changes - for utf-8 - language and PDFlanguage selection, also the installer and the new CounterSales.php script +10/09/10 Tim: PO_OrderDetails.php - Layout improvements, links to SelectSuppliers.php and sql quoting corrections +10/09/10 Tim: PO_Items.php - Layout improvements, and sql quoting corrections +10/09/10 Tim: PO_Header.php - Layout improvements, and sql quoting corrections +10/09/10 Tim: PO_AuthoriseMyOrders.php - Layout improvements, and sql quoting corrections +10/09/10 Tim: PO_AuthorisationLevels.php - Layout improvements, and sql quoting corrections +10/09/10 Tim: PeriodsInquiry.php - Layout improvements +10/09/10 ChenJohn: ConnectDB_mysql.inc ConnectDB_mysqli.inc fix utf-8 data being encoded/stored incorrectly in db server +08/09/10 Tim: PDFTopItems.php - Correct the sql quoting +08/09/10 Tim: PDFSuppTransListing.php - Screen layout improvements. Correct the sql quoting +08/09/10 Tim: PDFStockTransfer.php - Correct the sql quoting +08/09/10 Tim: PDFStockNegatives.php - Fix missing sql error message and correct the default date format in the heading +08/09/10 Tim: PDFStockCheckComparison.php - Screen layout improvements. Correct the sql quoting +07/09/10 Tim: PDFRemittanceAdvice.php - Correct the sql quoting +07/09/10 Tim: PDFReceipt.php - Correct the sql quoting +07/09/10 Tim: PDFQuotation.php - Correct the sql quoting +07/09/10 Tim: PDFPickingList.php - Correct the sql quoting +07/09/10 Tim: PDFOrderStatus.php - Improve report layout for readability +07/09/10 Tim: PDFOrderInvoiced.php - Improve report layout for readability +06/09/10 Tim: PO_Header.php - Move dummy status array from DefinePOClass.php +06/09/10 Tim: upgrade3.11.1-3.12.sql - Change syntax to work in both windows and linux +06/09/10 Tim: SupplierInvoice.php - Correct the roundings so that the double entry balances +05/09/10 Tim: PO_AuthoriseMyOrders.php - Update correct status when language not English +05/09/10 Tim: PcAssignCashToTab.php - Show authorised, notes, and receipt fields correctly. Changed to use DB_fetch_array() rather than DB_fetch_row(). +05/09/10 Tim: PDFStockTransListing.php - List stock transactions by transaction type. +05/09/10 Ricard: upgrade3.11.1-3.12.sql - Database changes required for changes to report writer. +31/08/10 Tim: StockLocTransfer.php - Change quantity input field to have more than 5 digits +28/08/10 Marcos Garcia Trejo: Fix ConfirmDispatchInvoice.php assembly components new qty on hand +27/08/10 Tim: Add in requisition number into purchase order prints. +21/08/10 Phil: Fix bugs introduced by Paul's patch prnMsg= should be prnMsg() BOMs.php also did in Contracts.php +21/08/10 Phil: Contract closing changes all the contracts scripts +20/08/10 Paul Thursby: More $msg cleanup. Unused eliminated; Others replaced with prnMsg(). +15/08/10 Phil: Decided to have contracts as part of orders module since not really enough links to warrant a new module changes to index.php WWW_Users.php and sql upgrade. +15/08/10 Phil: New script for ContractCosting.php comparison of contract costs budgeted vs incurred. Lot of work on contracts +13/08/10 Phil: DefineSuppTransClass.php SupplierInvoice.php and SupplierCredit.php now allow entry of contract charges. New script for SuppContractChgs.php +13/08/10 Phil: Fixes to show creditors transactions correctly in GLTransInquiry.php signs mixed up and period not shown previously +10/08/10 Russell (Regal Prods): Fix SelectOrderItems.php width of narrative box was making screen unusable!! +18/08/10 Pak Ricard: Revised report writer with the ability for more fields +07/08/10 Paul Thursby: PO_Items.php - Eliminate query; Moves the ONE field into a query above this point. +07/08/10 Paul Thursby: SelectProduct.php - Variable $msg will never print. Elimnate to use function prnMsg() instead. +08/08/10 Phil: Contracts.php SelectContracts.php DeliveryDetails.php - more work to convert Contracts to quotations and on conversion of contract quotations to orders to create contract work order to issue materials to +07/08/10 Tim: PDFLowGP.php - Sql quoting correction, layout changes, and assorted minor bug corrections +07/08/10 Tim: PO_Items.php - Sql quoting correction, layout changes, and assorted minor bug corrections +07/08/10 Tim: SelectCustomer.php - Unset $result variable once used as it was ca... [truncated message content] |