$js .= get_js_open_window(900, 500);
if ($use_date_picker)
$js .= get_js_date_picker();
-page(_("Customer Transactions"), false, false, "", $js);
+page(_($help_context = "Customer Transactions"), false, false, "", $js);
if (isset($_GET['customer_id']))
submit_cells('RefreshInquiry', _("Search"),'',_('Refresh Inquiry'), 'default');
end_row();
end_table();
-end_form();
+
set_global_customer($_POST['customer_id']);
//------------------------------------------------------------------------------------------------
debtor.name,
branch.br_name,
debtor.curr_code,
+ @bal := @bal+trans.ov_amount,
(trans.ov_amount + trans.ov_gst + trans.ov_freight
+ trans.ov_freight_tax + trans.ov_discount) AS TotalAmount,
trans.alloc AS Allocated,
AND trans.branch_code = branch.branch_code";
if ($_POST['customer_id'] != ALL_TEXT)
- $sql .= " AND trans.debtor_no = '" . $_POST['customer_id'] . "'";
+ $sql .= " AND trans.debtor_no = ".db_escape($_POST['customer_id']);
if ($_POST['filterType'] != ALL_TEXT)
{
}
//------------------------------------------------------------------------------------------------
+db_query("set @bal:=0");
$cols = array(
_("Type") => array('fun'=>'systype_name', 'ord'=>''),
_("Customer") => array('ord'=>''),
_("Branch") => array('ord'=>''),
_("Currency") => array('align'=>'center'),
+ _("RB"),
_("Debit") => array('align'=>'right', 'fun'=>'fmt_debit'),
_("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'),
array('insert'=>true, 'fun'=>'gl_view'),
$table->width = "85%";
-start_form();
display_db_pager($table);
end_form();