If account code2 is used in the accounts the report Chart of Accounts gave a bad...

[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 39af247fb8b078085c9ae40da8e27aaab8b3d0a4..ae6011cd1a9052c33f2d3b89e25bcac6ca1b4708 100644 (file)
--- a/gl/includes/db/gl_db_account_types.inc
+++ b/gl/includes/db/gl_db_account_types.inc
@@ -51,20 +51,6 @@ function get_account_type_name($id)
        return $row[0];
 }
 
-
-function get_account_types_all($balance=-1)
-{
-       $sql = "SELECT ".TB_PREF."chart_types.name AS AccountTypeName,".TB_PREF."chart_types.parent,".TB_PREF."chart_types.id AS AccountType,
-               ".TB_PREF."chart_class.class_name AS AccountClassName
-               FROM ".TB_PREF."chart_types, ".TB_PREF."chart_class
-               WHERE ".TB_PREF."chart_types.class_id=".TB_PREF."chart_class.cid";
-       if ($balance != -1)
-               $sql .= " AND ".TB_PREF."chart_class.balance_sheet=$balance";
-       $sql .= " ORDER BY ".TB_PREF."chart_class.cid, IF(parent > -1,parent,".TB_PREF."chart_types.id), parent";
-
-       return db_query($sql, "could not get gl types");
-}
-
 function delete_account_type($id)
 {
        $sql = "DELETE FROM ".TB_PREF."chart_types WHERE id = $id";
@@ -114,7 +100,6 @@ function get_account_class_name($id)
        return $row[0];
 }
 
-
 function delete_account_class($id)
 {
        $sql = "DELETE FROM ".TB_PREF."chart_class WHERE cid = $id";