.
***********************************************************************/
$page_security = 'SA_BANKTRANSVIEW';
$path_to_root = "../..";
include($path_to_root . "/includes/session.inc");
page(_($help_context = "View Bank Deposit"), true);
include_once($path_to_root . "/includes/date_functions.inc");
include_once($path_to_root . "/includes/ui.inc");
include_once($path_to_root . "/gl/includes/gl_db.inc");
if (isset($_GET["trans_no"]))
{
$trans_no = $_GET["trans_no"];
}
// get the pay-to bank payment info
$result = get_bank_trans(ST_BANKDEPOSIT, $trans_no);
if (db_num_rows($result) != 1)
display_db_error("duplicate payment bank transaction found", "");
$to_trans = db_fetch($result);
$company_currency = get_company_currency();
$show_currencies = false;
if ($to_trans['bank_curr_code'] != $to_trans['settle_curr'])
{
$show_currencies = true;
}
echo "
";
display_heading(_("GL Deposit") . " #$trans_no");
echo "
";
start_table(TABLESTYLE, "width=80%");
if ($show_currencies)
{
$colspan1 = 1;
$colspan2 = 7;
}
else
{
$colspan1 = 3;
$colspan2 = 5;
}
start_row();
label_cells(_("To Bank Account"), $to_trans['bank_account_name'], "class='tableheader2'");
if ($show_currencies)
label_cells(_("Currency"), $to_trans['bank_curr_code'], "class='tableheader2'");
label_cells(_("Amount"), number_format2($to_trans['amount'], user_price_dec()), "class='tableheader2'", "align=right");
label_cells(_("Date"), sql2date($to_trans['trans_date']), "class='tableheader2'");
end_row();
start_row();
label_cells(_("From"), get_counterparty_name(BT_BANKDEPOSIT, $to_trans['trans_no']), "class='tableheader2'", "colspan=$colspan1");
if ($show_currencies)
{
label_cells(_("Settle currency"), $to_trans['settle_curr'], "class='tableheader2'");
label_cells(_("Settled amount"), number_format2($to_trans['settled_amount'], user_price_dec()), "class='tableheader2'");
}
label_cells(_("Deposit Type"), $bank_transfer_types[$to_trans['account_type']], "class='tableheader2'");
end_row();
start_row();
label_cells(_("Reference"), $to_trans['ref'], "class='tableheader2'", "colspan=$colspan2");
end_row();
comments_display_row(ST_BANKDEPOSIT, $trans_no);
end_table(1);
is_voided_display(ST_BANKDEPOSIT, $trans_no, _("This deposit has been voided."));
$items = get_gl_trans(ST_BANKDEPOSIT, $trans_no);
if (db_num_rows($items) == 0)
{
display_note(_("There are no items for this deposit."));
}
else
{
display_heading2(_("Items for this Deposit"));
if ($show_currencies)
display_heading2(_("Item Amounts are Shown in:") . " " . $company_currency);
start_table(TABLESTYLE, "width=80%");
$dim = get_company_pref('use_dimension');
if ($dim == 2)
$th = array(_("Account Code"), _("Account Description"), _("Dimension")." 1", _("Dimension")." 2",
_("Amount"), _("Memo"));
else if ($dim == 1)
$th = array(_("Account Code"), _("Account Description"), _("Dimension"),
_("Amount"), _("Memo"));
else
$th = array(_("Account Code"), _("Account Description"),
_("Amount"), _("Memo"));
table_header($th);
$k = 0; //row colour counter
$total_amount = 0;
while ($item = db_fetch($items))
{
if ($item["account"] != $to_trans["account_code"])
{
alt_table_row_color($k);
label_cell($item["account"]);
label_cell($item["account_name"]);
if ($dim >= 1)
label_cell(get_dimension_string($item['dimension_id'], true));
if ($dim > 1)
label_cell(get_dimension_string($item['dimension2_id'], true));
amount_cell(-$item["amount"]);
label_cell($item["memo_"]);
end_row();
$total_amount += $item["amount"];
}
}
label_row(_("Total"), number_format2(-$total_amount, user_price_dec()),"colspan=".(2+$dim)." align=right", "align=right");
end_table(1);
display_allocations_from($to_trans['person_type_id'], $to_trans['person_id'], 2, $trans_no, $to_trans['settled_amount']);
}
end_page(true, false, false, ST_BANKDEPOSIT, $trans_no);