<?php
-
+/**********************************************************************
+ Copyright (C) FrontAccounting, LLC.
+ Released under the terms of the GNU General Public License, GPL,
+ as published by the Free Software Foundation, either version 3
+ of the License, or (at your option) any later version.
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
include_once($path_to_root . "/includes/ui.inc");
//--------------------------------------------------------------------------------------
-function display_dimension_payments($id)
+function display_dimension_balance($id, $from, $to)
{
global $path_to_root, $table_style;
- $result = get_bank_trans(null, null, payment_person_types::dimension(), $id);
-
- echo "<br>";
+ $from = date2sql($from);
+ $to = date2sql($to);
+ $sql = "SELECT account, ".TB_PREF."chart_master.account_name, sum(amount) AS amt FROM
+ ".TB_PREF."gl_trans,".TB_PREF."chart_master WHERE
+ ".TB_PREF."gl_trans.account = ".TB_PREF."chart_master.account_code AND
+ (dimension_id = $id OR dimension2_id = $id) AND
+ tran_date >= '$from' AND tran_date <= '$to' GROUP BY account";
+ $result = db_query($sql, "Transactions could not be calculated");
if (db_num_rows($result) == 0)
{
- echo _("There are no transactions for this dimension.") . "<br>";
- }
- else
+ display_note(_("There are no transactions for this dimension for the selected period."));
+ }
+ else
{
- display_heading2(_("Transactions for this Dimension"));
+ display_heading2(_("Balance for this Dimension"));
+ br();
start_table($table_style);
- $th = array(_("Type"), _("#"), _("Reference"),
- _("Date"), _("Debit"), _("Credit"));
- table_header($th);
+ $th = array(_("Account"), _("Debit"), _("Credit"));
+ table_header($th);
$total = $k = 0;
-
- while ($myrow = db_fetch($result))
+ while ($myrow = db_fetch($result))
{
-
alt_table_row_color($k);
- // projects are always in home currency...get the home equivalent of the banktrans
- // from it's gl postings
- $home_value = get_gl_trans_value($myrow["bank_act"], $myrow["type"], $myrow["trans_no"]);
-
- label_cell(systypes::name($myrow["type"]));
- label_cell(get_trans_view_str($myrow["type"], $myrow["trans_no"]));
- label_cell($myrow["ref"]);
- label_cell(sql2date($myrow["trans_date"]));
- display_debit_or_credit_cells($home_value);
-
- $total += $home_value;
-
+ label_cell($myrow["account"]." ".$myrow['account_name']);
+ display_debit_or_credit_cells($myrow["amt"]);
+ $total += $myrow["amt"];
end_row();
}
-
start_row();
- label_cell(_("Total"), "colspan=4");
- display_debit_or_credit_cells($total);
+ label_cell("<b>"._("Balance")."</b>");
+ if ($total >= 0)
+ {
+ amount_cell($total, true);
+ label_cell("");
+ }
+ else
+ {
+ label_cell("");
+ amount_cell(abs($total), true);
+ }
end_row();
end_table();