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

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

diff --git a/gl/includes/db/gl_db_account_types.inc b/gl/includes/db/gl_db_account_types.inc
index 1c25db71a5a7e8fc140ee655fac052f72c84aae6..4eb22d3e6b5dd36de8a13b0253effbec2ba77080 100644 (file)
--- a/gl/includes/db/gl_db_account_types.inc
+++ b/gl/includes/db/gl_db_account_types.inc
@@ -113,4 +113,30 @@ function delete_account_class($id)
        db_query($sql, "could not delete account type");
 }
 
+function account_class_in_account_types($id)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types
+               WHERE class_id=".db_escape($id);
+       $result = db_query($sql, "could not query chart master");
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
+function account_type_in_chart_master($type)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_master
+               WHERE account_type=$type";
+       $result = db_query($sql, "could not query chart master");
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
+
+function account_type_in_parent($type)
+{
+       $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types
+               WHERE parent=$type";
+       $result = db_query($sql, "could not query chart types");
+       $myrow = db_fetch_row($result);
+       return ($myrow[0] > 0); 
+}
 ?>
\ No newline at end of file