[wiaflos-devel] COMMIT - r253 - in trunk: soap soap/Plugins wiaflos/server

[svn at linuxrulz.org]

Author: nkukard
Date: 2008-11-08 06:37:33 +0000 (Sat, 08 Nov 2008)
New Revision: 253

Modified:
   trunk/soap/Plugins/GL.pm
   trunk/soap/Plugins/Reporting.pm
   trunk/soap/wiaflos.conf
   trunk/wiaflos/server/GL.pm
   trunk/wiaflos/server/Inventory.pm
Log:
* EndDate must include the date we're ending on for best accounting practise


Modified: trunk/soap/Plugins/GL.pm
===================================================================
--- trunk/soap/Plugins/GL.pm	2008-11-08 06:30:23 UTC (rev 252)
+++ trunk/soap/Plugins/GL.pm	2008-11-08 06:37:33 UTC (rev 253)
@@ -295,8 +295,8 @@
 #
 # @param data Parameter hash ref
 # @li AccountNumber Supplier code
-# @li StartDate Start date, INCLUDING
-# @li EndDate End date, NOT INCLUDING
+# @li StartDate Start date
+# @li EndDate End date
 # @li BalanceBroughtForward Flag to indicate if we must generate a BBF
 #
 # @returns Array ref of hash refs

Modified: trunk/soap/Plugins/Reporting.pm
===================================================================
--- trunk/soap/Plugins/Reporting.pm	2008-11-08 06:30:23 UTC (rev 252)
+++ trunk/soap/Plugins/Reporting.pm	2008-11-08 06:37:33 UTC (rev 253)
@@ -55,8 +55,8 @@
 # Function to return the chart of accounts with balances
 #
 # @param detail Parameter hash ref
-# @li StartDate Optional statement start date, INCLUDING
-# @li EndDate Optional statement end date, NOT INCLUDING
+# @li StartDate Optional statement start date
+# @li EndDate Optional statement end date
 # @li Levels Optional depth to go into on each parent account
 #
 # @returns Array ref of hash refs containing the accounts and their balances

Modified: trunk/soap/wiaflos.conf
===================================================================
--- trunk/soap/wiaflos.conf	2008-11-08 06:30:23 UTC (rev 252)
+++ trunk/soap/wiaflos.conf	2008-11-08 06:37:33 UTC (rev 253)
@@ -20,8 +20,8 @@
 
 
 [database]
-DSN=DBI:SQLite:dbname=wiaflos.sqlite
-#DSN=DBI:mysql:database=wiaflos;host=localhost
+#DSN=DBI:SQLite:dbname=wiaflos.sqlite
+DSN=DBI:mysql:database=wiaflos;host=localhost
 Username=root
 Password=
 

Modified: trunk/wiaflos/server/GL.pm
===================================================================
--- trunk/wiaflos/server/GL.pm	2008-11-08 06:30:23 UTC (rev 252)
+++ trunk/wiaflos/server/GL.pm	2008-11-08 06:37:33 UTC (rev 253)
@@ -1069,8 +1069,8 @@
 # @param data Parameter hash ref
 # @li AccountID Optional account ID
 # @li AccountNumber Optional account number
-# @li StartDate	Optional start date, INCLUDING
-# @li EndDate Optional end date, NOT INCLUDING
+# @li StartDate	Optional start date
+# @li EndDate Optional end date
 # @li BalanceBroughtForward Optional flag to indicate if we must generate a balance brought forward entry
 #
 # @returns Array ref of hash refs
@@ -1164,7 +1164,7 @@
 
 	# Check if we must use an end date
 	if (defined($data->{'EndDate'}) && $data->{'EndDate'} ne "") {
-		$extraSQL .= " AND gl_transactions.TransactionDate < ".DBQuote($data->{'EndDate'});
+		$extraSQL .= " AND gl_transactions.TransactionDate <= ".DBQuote($data->{'EndDate'});
 	}
 
 	# Return list of transaction entries
@@ -1216,8 +1216,8 @@
 # @param data Parameter hash ref
 # @li AccountID - Optional account ID
 # @li AccountNumber - Optional account number
-# @li StartDate	- Optional start date, INCLUDING
-# @li EndDate - Optional end date, NOT INCLUDING
+# @li StartDate	- Optional start date
+# @li EndDate - Optional end date
 #
 # @returns Hash of account balances
 # @li CreditBalance - Credit balance
@@ -1261,7 +1261,7 @@
 
 	# Check if we must use an end date
 	if (defined($data->{'EndDate'}) && $data->{'EndDate'} ne "") {
-		$extraSQL .= " AND gl_transactions.TransactionDate < ".DBQuote($data->{'EndDate'});
+		$extraSQL .= " AND gl_transactions.TransactionDate <= ".DBQuote($data->{'EndDate'});
 	}
 
 	# Return list of transaction entries

Modified: trunk/wiaflos/server/Inventory.pm
===================================================================
--- trunk/wiaflos/server/Inventory.pm	2008-11-08 06:30:23 UTC (rev 252)
+++ trunk/wiaflos/server/Inventory.pm	2008-11-08 06:37:33 UTC (rev 253)
@@ -1495,7 +1495,7 @@
 # Function to get the balances of inventory on hand, qty & price
 #
 # @param detail Parameter hash ref
-# @li EndDate - Optional date to pull the balance up until
+# @li EndDate - Optional end date
 #
 # @returns RES_OK on success, < 0 otherwise
 sub getInventoryStockBalance
@@ -1506,7 +1506,7 @@
 	# Check if we must use an end date
 	my $extraSQL = "";
 	if (defined($detail->{'EndDate'}) && $detail->{'EndDate'} ne "") {
-		$extraSQL .= " AND gl_transactions.TransactionDate < ".DBQuote($detail->{'EndDate'});
+		$extraSQL .= " AND gl_transactions.TransactionDate <= ".DBQuote($detail->{'EndDate'});
 	}
 
 	# Grab free inventory item list