. ***********************************************************************/ $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'] != $company_currency) { $show_currencies = true; } echo ""; display_heading(_("GL Deposit") . " #$trans_no"); echo "
"; start_table(TABLESTYLE, "width=80%"); if ($show_currencies) { $colspan1 = 5; $colspan2 = 8; } else { $colspan1 = 3; $colspan2 = 6; } 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(ST_BANKDEPOSIT, $trans_no), "class='tableheader2'", "colspan=$colspan1"); 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['amount']); } end_page(true, false, false, ST_BANKDEPOSIT, $trans_no); ?>