X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdata_checks.inc;h=0b461636ed6c7a7f638b2b411ebbe6b7419be412;hb=9b413697aa4ca30f7f336dbf5fd04bf8caf2bc43;hp=b79bf3d2357d7c5cc3981331cf06cf82728ccccd;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git

diff --git a/includes/data_checks.inc b/includes/data_checks.inc
index b79bf3d2..0b461636 100644
--- a/includes/data_checks.inc
+++ b/includes/data_checks.inc
@@ -1,4 +1,14 @@
 <?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>.
+***********************************************************************/
 function db_has_customers()
 {
 	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."debtors_master");
@@ -111,22 +121,6 @@ function check_db_has_movement_types($msg)
     }	
 }
 
-function db_has_bank_trans_types()
-{
-	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_trans_types");
-}
-
-function check_db_has_bank_trans_types($msg)
-{
-	global $path_to_root;
-    if (!db_has_bank_trans_types()) 
-    {
-    	display_error($msg, true);
-    	end_page();
-    	exit;	
-    }	
-}
-
 function db_customer_has_branches($customer_id)
 {
 	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE debtor_no='$customer_id'");
@@ -273,7 +267,7 @@ function check_db_has_stock_items($msg)
 
 function db_has_bom_stock_items()
 {
-	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag='M' OR mb_flag='K')");
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag='M'");
 }
 
 function check_db_has_bom_stock_items($msg)
@@ -305,7 +299,7 @@ function check_db_has_manufacturable_items($msg)
 
 function db_has_purchasable_items()
 {
-	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='M' AND mb_flag!='K')");
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='M'");
 }
 
 function check_db_has_purchasable_items($msg)
@@ -321,7 +315,7 @@ function check_db_has_purchasable_items($msg)
 
 function db_has_costable_items()
 {
-	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE (mb_flag!='D' AND mb_flag!='K')");
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."stock_master WHERE mb_flag!='D'");
 }
 
 function check_db_has_costable_items($msg)
@@ -391,6 +385,7 @@ function db_has_bank_accounts()
 function check_db_has_bank_accounts($msg)
 {
 	global $path_to_root;
+
     if (!db_has_bank_accounts()) 
     {
     	display_error($msg, true);
@@ -399,6 +394,12 @@ function check_db_has_bank_accounts($msg)
     }	
 }
 
+function db_has_cash_accounts()
+{
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."bank_accounts
+		WHERE account_type=3");
+}
+
 function db_has_gl_accounts()
 {
 	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."chart_master");
@@ -420,6 +421,11 @@ function check_db_has_gl_account_groups($msg)
     }	
 }
 
+function db_has_quick_entries()
+{
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."quick_entries");
+}
+
 function check_empty_result($sql)
 {
 	$result = db_query($sql, "could not do check empty query");