From 0f9aef0c69fb64acc03916ffc1254b6aa7e39cff Mon Sep 17 00:00:00 2001
From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Fri, 13 Mar 2009 22:37:32 +0000
Subject: [PATCH] Removed non used file

---
 CHANGELOG.txt            |  2 ++
 admin/db/v_banktrans.inc | 51 ----------------------------------------
 2 files changed, 2 insertions(+), 51 deletions(-)
 delete mode 100644 admin/db/v_banktrans.inc

diff --git a/CHANGELOG.txt b/CHANGELOG.txt
index 39c6036a..f50ce0b5 100644
--- a/CHANGELOG.txt
+++ b/CHANGELOG.txt
@@ -27,6 +27,8 @@ $ /gl/includes/ui/gl_bank_ui.inc
 # Random syntax error + new menu item :).
 $ /manufacturing/inquiry/bom_cost_inquiry.php
   /applications/manufacturing.php
+- Removed non used file
+$ /admin/db/v_banktrans.inc (removed)
 
 11-Mar-2009 Joe Hunt
 # Several errors related to new bank account id in /gl/includes/db/gl_db_banking.inc
diff --git a/admin/db/v_banktrans.inc b/admin/db/v_banktrans.inc
deleted file mode 100644
index 0cdd5a20..00000000
--- a/admin/db/v_banktrans.inc
+++ /dev/null
@@ -1,51 +0,0 @@
-<?php
-/**********************************************************************
-    Copyright (C) FrontAccounting, LLC.
-	Released under the terms of the GNU General Public License, GPL, 
-	as published by the Free Software Foundation, either version 3 
-	of the License, or (at your option) any later version.
-    This program is distributed in the hope that it will be useful,
-    but WITHOUT ANY WARRANTY; without even the implied warranty of
-    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
-    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
-***********************************************************************/
-include_once($path_to_root . "/gl/includes/gl_db.inc");
-
-function validate_bank_trans()
-{
-	dump_msg("<b>Checking bank transactions.........</b>");
-
-	// check that the account in the trans is actually a P/L account
-	$sql = "SELECT * FROM ".TB_PREF."bank_trans,".TB_PREF."chart_master, ".TB_PREF."chart_types
-		WHERE ".TB_PREF."bank_trans.bank_act=".TB_PREF."chart_master.account_code
-		AND  ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id
-		AND (".TB_PREF."chart_types.class_id = 1 OR ".TB_PREF."chart_types.class_id = 2)";
-
-	$result = db_query($sql);
-	if (db_num_rows($result) > 0) 
-	{
-		dump_msg("There are bank transactions with accounts that are not Profit&Loss");
-	}
-
-	$sql = "SELECT * FROM ".TB_PREF."bank_trans";
-	$result = db_query($sql);
-	while ($banktrans = db_fetch($result)) 
-	{
-		// make sure bank_act is valid
-		$get = get_gl_account($banktrans["bank_act"]);
-		if ($get == null)
-			dump_msg("Invalid Bank Account for bank trans " . $banktrans["id"]);
-
-		// make sure the type is valid
-		$get = get_bank_trans_type($banktrans["bank_trans_type_id"]);
-		if ($get == null)
-			dump_msg("Invalid bank_trans_type_id (" . $banktrans["bank_trans_type_id"] . ") for bank_trans " . $banktrans["id"]);
-
-		if ($banktrans["type"] != 1 && $banktrans["type"] != 2 && $banktrans["type"] != 4
-			&& $banktrans["type"] != 22 && $banktrans["type"] != 12)
-			dump_msg("Invalid type for bank_trans " . $banktrans["id"]);
-	}
-}
-
-
-?>
\ No newline at end of file
-- 
2.30.2