function get_gl_accounts_all($balance=-1)
{
+ global $use_new_account_types;
+
if ($balance == 1)
$where ="WHERE ctype>0 AND ctype<".CL_INCOME;
elseif ($balance == 0)
LEFT JOIN ".TB_PREF."chart_master ON ".TB_PREF."chart_master.account_type=".TB_PREF."chart_types.id ";
if ($balance != -1)
$sql .= $where;
- $sql .= " ORDER BY ".TB_PREF."chart_class.cid, IF(parent > 0,parent,".TB_PREF."chart_types.id),
- IF(parent > 0,".TB_PREF."chart_types.id, parent), ".TB_PREF."chart_master.account_code";
+ if (isset($use_new_account_types) && $use_new_account_types == 1)
+ $sql .= " ORDER BY ".TB_PREF."chart_class.cid, ".TB_PREF."chart_types.id, parent, ".TB_PREF."chart_master.account_code";
+ else
+ $sql .= " ORDER BY ".TB_PREF."chart_class.cid, IF(parent > 0,parent,".TB_PREF."chart_types.id),
+ IF(parent > 0,".TB_PREF."chart_types.id, parent), ".TB_PREF."chart_master.account_code";
return db_query($sql, "could not get gl accounts");
}
display_db_error("could not retreive the account name for $code", $sql, true);
}
-function gl_account_in_transactions($acc)
-{
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."gl_trans WHERE account=$acc";
- $result = db_query($sql,"Couldn't test for existing transactions");
-
- $myrow = db_fetch_row($result);
- return ($myrow[0] > 0);
-}
-
function gl_account_in_company_defaults($acc)
{
$sql= "SELECT COUNT(*) FROM ".TB_PREF."company WHERE debtors_act=$acc
return ($myrow[0] > 0);
}
-function gl_account_in_bank_accounts($acc)
-{
- $sql= "SELECT COUNT(*) FROM ".TB_PREF."bank_accounts WHERE account_code=$acc";
- $result = db_query($sql,"Couldn't test for bank accounts");
-
- $myrow = db_fetch_row($result);
- return ($myrow[0] > 0);
-}
-
function gl_account_in_stock_category($acc)
{
$sql= "SELECT COUNT(*) FROM ".TB_PREF."stock_category WHERE