From: <ex...@us...> - 2015-04-01 11:24:55
|
Revision: 7256 http://sourceforge.net/p/web-erp/reponame/7256 Author: exsonqu Date: 2015-04-01 11:24:48 +0000 (Wed, 01 Apr 2015) Log Message: ----------- 01/04/15 Exson: Remove comma from item description and suppliername to make csv file correctly. Modified Paths: -------------- trunk/POReport.php Modified: trunk/POReport.php =================================================================== --- trunk/POReport.php 2015-04-01 10:32:19 UTC (rev 7255) +++ trunk/POReport.php 2015-04-01 11:24:48 UTC (rev 7256) @@ -1333,15 +1333,15 @@ $myrow['itemcode'], ConvertSQLDate($myrow['orddate']), $myrow['supplierno'], - $myrow['suppname'], - locale_number_format($myrow['quantityord'],$myrow['decimalplaces']), - locale_number_format($myrow['quantityrecd'],$myrow['decimalplaces']), - locale_number_format($myrow['extcost'],2), - locale_number_format($myrow['extprice'],2), - locale_number_format($myrow['qtyinvoiced'],$myrow['decimalplaces']), + str_replace(',',' ',$myrow['suppname']), + round($myrow['quantityord'],$myrow['decimalplaces']), + round($myrow['quantityrecd'],$myrow['decimalplaces']), + round($myrow['extcost'],2), + round($myrow['extprice'],2), + round($myrow['qtyinvoiced'],$myrow['decimalplaces']), $myrow['linestatus'], ConvertSQLDate($myrow['deliverydate']), - $myrow['description']); + str_replace(',',' ',$myrow['description'])); $LastDecimalPlaces = $myrow['decimalplaces']; $TotalQty += $myrow['quantityord']; $TotalExtCost += $myrow['extcost']; @@ -1387,7 +1387,7 @@ $myrow['itemcode'], ConvertSQLDate($myrow['orddate']), $myrow['supplierno'], - $myrow['suppname'], + str_replace(',',' ',$myrow['suppname']), round($myrow['quantityrecd'],$myrow['decimalplaces']), round($myrow['quantityord'],$myrow['decimalplaces']), round($myrow['extcost'],2), @@ -1395,7 +1395,7 @@ round($myrow['qtyinvoiced'],$myrow['decimalplaces']), $myrow['linestatus'], ConvertSQLDate($myrow['deliverydate']), - $myrow['description']); + str_replace(',',' ',$myrow['description'])); $LastDecimalPlaces = $myrow['decimalplaces']; $TotalQty += $myrow['quantityord']; $TotalExtCost += $myrow['extcost']; |