activate('balance_tbl'); } function gl_inquiry_controls() { start_form(); start_table("class='tablestyle_noborder'"); date_cells(_("From:"), 'TransFromDate', '', null, -30); date_cells(_("To:"), 'TransToDate'); check_cells(_("No zero values"), 'NoZero', null); submit_cells('Show',_("Show"),'','', true); end_table(); end_form(); } //---------------------------------------------------------------------------------------------------- function get_balance($account, $from, $to, $from_incl=true, $to_incl=true) { $sql = "SELECT SUM(amount) As TransactionSum FROM ".TB_PREF."gl_trans WHERE account='$account'"; if ($from) { $from_date = date2sql($from); if ($from_incl) $sql .= " AND tran_date >= '$from_date'"; else $sql .= " AND tran_date > '$from_date'"; } if ($to) { $to_date = date2sql($to); if ($to_incl) $sql .= " AND tran_date <= '$to_date' "; else $sql .= " AND tran_date < '$to_date' "; } $result = db_query($sql,"No general ledger accounts were returned"); $row = db_fetch_row($result); return $row[0]; } //---------------------------------------------------------------------------------------------------- function display_trial_balance() { global $table_style, $path_to_root; div_start('balance_tbl'); start_table($table_style); $tableheader = "