Moved all SQL statements from PHP files into relevant *_db.inc files.

[fa-stable.git] / gl / includes / db / gl_db_currencies.inc

diff --git a/gl/includes/db/gl_db_currencies.inc b/gl/includes/db/gl_db_currencies.inc
index eee35e1cf06cf3a170a2b605870ff92c5e21704e..e13a91443b5a048d1b7e848b0fa59cd028be4397 100644 (file)
--- a/gl/includes/db/gl_db_currencies.inc
+++ b/gl/includes/db/gl_db_currencies.inc
@@ -70,4 +70,35 @@ function get_currencies($all=false)
 
 //---------------------------------------------------------------------------------------------
 
+function currency_in_debtors($curr)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE curr_code = $curr";
+       $result = db_query($sql);
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
+function currency_in_suppliers($curr)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."suppliers WHERE curr_code = $curr";
+       $result = db_query($sql);
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
+function currency_in_bank_accounts($curr)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_accounts WHERE bank_curr_code = $curr";
+       $result = db_query($sql);
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
+function currency_in_company($curr)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."company WHERE curr_default = $curr";
+       $result = db_query($sql);
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
 ?>
\ No newline at end of file