- if ($myrow['OverDue'] == 1)
- {
- start_row("class='overduebg'");
- $over_due = true;
- }
- else
- alt_table_row_color($k);
-
- $edit_page='';
- $due_date_str = '';
- $credit_me_str = '';
-
- switch($myrow['type']) {
- case 10:
- $due_date_str = sql2date($myrow["due_date"]);
- /*Show a link to allow an invoice to be credited */
- // only allow crediting if it's not been totally allocated
- if ($myrow["TotalAmount"] - $myrow["Allocated"] > 0)
- $credit_me_str = "<a href='$path_to_root/sales/customer_credit_invoice.php?InvoiceNumber=" . $myrow["trans_no"] . "'>" . _("Credit This") . "</a>";
- $edit_page= $path_to_root.'/sales/customer_invoice.php?ModifyInvoice='
- . $myrow['trans_no'];
- break;
- case 13:
- $edit_page= $path_to_root.'/sales/customer_delivery.php?ModifyDelivery='
- . $myrow['trans_no']; break;
- }
-
- $date = sql2date($myrow["tran_date"]);
-
- if ($myrow["order_"] > 0)
- $preview_order_str = get_customer_trans_view_str(systypes::sales_order(), $myrow["order_"]);
- else
- $preview_order_str = "";
-
- $gl_trans_str = get_gl_view_str_cell($myrow["type"], $myrow["trans_no"]);
-
-// $print_str = "<a href='$path_to_root/reporting/print_invoice.php?InvoiceNumber=" . $myrow["trans_no"] . "'>" . _("Print") . "</a>";
-
-
- $branch_name = "";
- if ($myrow["branch_code"] > 0)
- {
- $branch_name = get_branch_name($myrow["branch_code"]);
- }
-
- $preview_trans_str = get_trans_view_str($myrow["type"], $myrow["trans_no"]);
-
- label_cell(systypes::name($myrow["type"]));
-
- label_cell($preview_trans_str);
- label_cell($preview_order_str);
- label_cell($myrow["reference"]);
- label_cell($date, "nowrap");
- label_cell($due_date_str, "nowrap");
- if ($_POST['customer_id'] == reserved_words::get_all())
- label_cell($myrow["CustName"]);
- label_cell($branch_name);
- if ($_POST['customer_id'] == reserved_words::get_all())
- label_cell($myrow["CustCurrCode"]);
- display_debit_or_credit_cells($myrow["TotalAmount"]);
- echo $gl_trans_str;
-
- label_cell($edit_page=='' ? '' : "<a href='$edit_page'>" . _('Edit') . '</a>');
-
- if ($credit_me_str != "")
- label_cell($credit_me_str, "nowrap");
- else
- label_cell('');
-
-// if ($myrow["type"] == 10)
-// label_cell($print_str, 'nowrap');
-// else
-// label_cell('');
-
- end_row();
+//------------------------------------------------------------------------------------------------
+//db_query("set @bal:=0");
+
+$cols = array(
+ _("Type") => array('fun'=>'systype_name', 'ord'=>''),
+ _("#") => array('fun'=>'trans_view', 'ord'=>'', 'align'=>'right'),
+ _("Order") => array('fun'=>'order_view', 'align'=>'right'),
+ _("Reference"),
+ _("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'desc'),
+ _("Due Date") => array('type'=>'date', 'fun'=>'due_date'),
+ _("Customer") => array('ord'=>''),
+ _("Branch") => array('ord'=>''),
+ _("Currency") => array('align'=>'center'),
+ _("Amount") => array('align'=>'right', 'fun'=>'fmt_amount'),
+ _("Balance") => array('align'=>'right', 'type'=>'amount'),
+ array('insert'=>true, 'fun'=>'gl_view'),
+ array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'credit_link'),
+ array('insert'=>true, 'fun'=>'prt_link')
+ );
+
+
+if ($_POST['customer_id'] != ALL_TEXT) {
+ $cols[_("Customer")] = 'skip';
+ $cols[_("Currency")] = 'skip';
+}
+if ($_POST['filterType'] != '2')
+ $cols[_("Balance")] = 'skip';