X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_account_types.inc;fp=gl%2Fincludes%2Fdb%2Fgl_db_account_types.inc;h=4eb22d3e6b5dd36de8a13b0253effbec2ba77080;hb=0bf933423b9645bcb57390c478d4fdaf0c895049;hp=1c25db71a5a7e8fc140ee655fac052f72c84aae6;hpb=4221bf69f713a2fb0bb4c4cae6f8f4f819c3ec31;p=fa-stable.git diff --git a/gl/includes/db/gl_db_account_types.inc b/gl/includes/db/gl_db_account_types.inc index 1c25db71..4eb22d3e 100644 --- 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