From: <dai...@us...> - 2012-06-02 06:08:57
|
Revision: 5408 http://web-erp.svn.sourceforge.net/web-erp/?rev=5408&view=rev Author: daintree Date: 2012-06-02 06:08:51 +0000 (Sat, 02 Jun 2012) Log Message: ----------- Modified Paths: -------------- trunk/CounterSales.php trunk/Z_ImportStocks.php Modified: trunk/CounterSales.php =================================================================== --- trunk/CounterSales.php 2012-05-30 09:03:21 UTC (rev 5407) +++ trunk/CounterSales.php 2012-06-02 06:08:51 UTC (rev 5408) @@ -1278,7 +1278,8 @@ rate, invtext, shipvia, - alloc ) + alloc, + settled ) VALUES ( '". $InvoiceNo . "', 10, @@ -1295,7 +1296,8 @@ '" . $ExRate . "', '" . $_SESSION['Items'.$identifier]->Comments . "', '" . $_SESSION['Items'.$identifier]->ShipVia . "', - '" . ($_SESSION['Items'.$identifier]->total + filter_number_format($_POST['TaxTotal'])) . "')"; + '" . ($_SESSION['Items'.$identifier]->total + filter_number_format($_POST['TaxTotal'])) . "', + '1')"; $ErrMsg =_('CRITICAL ERROR') . '! ' . _('NOTE DOWN THIS ERROR AND SEEK ASSISTANCE') . ': ' . _('The debtor transaction record could not be inserted because'); $DbgMsg = _('The following SQL to insert the debtor transaction record was used'); @@ -1934,7 +1936,8 @@ rate, ovamount, alloc, - invtext) + invtext, + settled) VALUES ('" . $ReceiptNumber . "', 12, '" . $_SESSION['Items'.$identifier]->DebtorNo . "', @@ -1945,7 +1948,8 @@ '" . $ExRate . "', '" . -filter_number_format($_POST['AmountPaid']) . "', '" . -filter_number_format($_POST['AmountPaid']) . "', - '" . $_SESSION['Items'.$identifier]->LocationName . ' ' . _('Counter Sale') ."')"; + '" . $_SESSION['Items'.$identifier]->LocationName . ' ' . _('Counter Sale') ."', + '1')"; $DbgMsg = _('The SQL that failed to insert the customer receipt transaction was'); $ErrMsg = _('Cannot insert a receipt transaction against the customer because') ; Modified: trunk/Z_ImportStocks.php =================================================================== --- trunk/Z_ImportStocks.php 2012-05-30 09:03:21 UTC (rev 5407) +++ trunk/Z_ImportStocks.php 2012-06-02 06:08:51 UTC (rev 5408) @@ -33,17 +33,17 @@ if ($_FILES['userfile']['name']) { //start file processing //initialize - $allowType='text/csv'; + $AllowType='text/csv'; $fieldTarget = 18; $InputError = 0; //check file info - $fileName = $_FILES['userfile']['name']; + $FileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; - if ($fileType != $allowType) { - prnMsg (_('File has type '. $fileType. ', but only '. $allowType. ' is allowed.'),'error'); + if ($fileType != $AllowType) { + prnMsg (_('File has type '. $fileType. ', but only '. $AllowType. ' is allowed.'),'error'); include('includes/footer.inc'); exit; } @@ -273,7 +273,7 @@ DB_Txn_Rollback($db); } else { //all good so commit data transaction DB_Txn_Commit($db); - prnMsg( _('Batch Import of') .' ' . $fileName . ' '. _('has been completed. All transactions committed to the database.'),'success'); + prnMsg( _('Batch Import of') .' ' . $FileName . ' '. _('has been completed. All transactions committed to the database.'),'success'); } fclose($handle); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |