X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdata_checks.inc;h=67768b937df6d1f3eff7662b8258b76fa71e7ece;hb=b52ca51128e33a2d051d8e36a7dcc2c22e816020;hp=ef33acfdfd4d329412a7461586c07488f20b526a;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git

diff --git a/includes/data_checks.inc b/includes/data_checks.inc
index ef33acfd..67768b93 100644
--- a/includes/data_checks.inc
+++ b/includes/data_checks.inc
@@ -1,5 +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");
@@ -32,6 +41,19 @@ function check_db_has_currencies($msg)
     }	
 }
 
+function db_has_currency_rates($currency, $date_, $msg=false)
+{
+	$date = date2sql($date_);
+	
+	if (is_company_currency($currency))
+		return 1;
+	$ret = check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."exchange_rates WHERE curr_code = '$currency' && date_ <= '$date'");
+	if ($ret == 0 && $msg)
+		display_error(sprintf(_("Cannot retrieve exchange rate for currency %s as of %s. Please add exchange rate manually on Exchange Rates page."),
+					 $currency, $date_), true);
+	return $ret;				 
+}
+
 function db_has_sales_types()
 {
 	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."sales_types");
@@ -112,30 +134,16 @@ 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");
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch "
+		."WHERE debtor_no=".db_escape($customer_id));
 }
 
 function db_has_customer_branches()
 {
-	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."cust_branch");
+	return check_empty_result("SELECT COUNT(*) FROM "
+		.TB_PREF."cust_branch WHERE !inactive");
 }
 
 function check_db_has_customer_branches($msg)
@@ -274,7 +282,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)
@@ -306,7 +314,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)
@@ -322,7 +330,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)
@@ -392,6 +400,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);
@@ -400,6 +409,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");
@@ -421,12 +436,67 @@ 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 db_has_tags($type)
+{
+	return check_empty_result("SELECT COUNT(*) FROM ".TB_PREF."tags WHERE type=".db_escape($type));
+}
+
+function check_db_has_tags($type, $msg)
+{
+	global $path_to_root;
+    if (!db_has_tags($type)) 
+    {
+    	display_error($msg, true);
+    	end_page();
+    	exit;	
+    }	
+}
+
 function check_empty_result($sql)
 {
 	$result = db_query($sql, "could not do check empty query");	
 	
 	$myrow = db_fetch_row($result);
-	return $myrow[0] > 0;	 	
+	return $myrow[0] > 0;
+}
+//
+//	Integer input check 
+//	Return 1 if number has proper form and is within <min, max> range
+//
+function check_int($postname, $min=null, $max=null) {
+	if(!isset($_POST[$postname]))
+	  return 0;
+    $num = input_num($postname);
+    if(!is_int($num)) 
+	  return 0;
+    if (isset($min) && ($num<$min)) 
+	  return 0;
+    if (isset($max) && ($num>$max)) 
+	  return 0;
+    return 1;
+}
+//
+//	Numeric input check.
+//	Return 1 if number has proper form and is within <min, max> range
+//	Empty/not defined fields are defaulted to $dflt value.
+//
+function check_num($postname, $min=null, $max=null, $dflt=0) {
+	if(!isset($_POST[$postname]))
+	  return 0;
+    $num = input_num($postname, $dflt);
+    if ($num === false || $num === null) 
+	  return 0;
+    if (isset($min) && ($num<$min)) 
+	  return 0;
+    if (isset($max) && ($num>$max)) 
+	  return 0;
+    return 1;
 }
 
+
 ?>
\ No newline at end of file