end_row();
end_table();
end_form();
-
//------------------------------------------------------------------------------------------------
function check_overdue($row)
{
function due_date($row)
{
- return $row["type"] == 10 ? sql2date($row["due_date"]) : '';
+ return $row["type"] == 10 ? $row["due_date"] : '';
}
function fmt_balance($row)
{
- return price_format($row["TotalAmount"] - $row["Allocated"]);
+ return $row["TotalAmount"] - $row["Allocated"];
}
function alloc_link($row)
."trans.ov_freight + trans.ov_freight_tax + "
."trans.ov_discount) - trans.alloc,6) != 0) ";
}
-
-// $sql .= " ORDER BY trans.tran_date";
-
-/*
-if (db_num_rows($result) == 0)
-{
- display_note(_("The selected customer has no transactions for the given dates."), 1, 1);
-} else {
-*/
-// start_table("$table_style width='80%'");
//------------------------------------------------------------------------------------------------
+
$cols = array(
- _("Type") => array('type'=>'spec', 'fun'=>'systype_name'),
- _("Number") => array('type'=>'spec', 'fun'=>'view_link'),
+ _("Type") => array('fun'=>'systype_name'),
+ _("Number") => array('fun'=>'view_link'),
_("Reference"),
- _("Order") => array('type'=>'spec', 'fun'=>'order_link'),
+ _("Order") => array('fun'=>'order_link'),
_("Date") => array('type'=>'date', 'ord'=>'asc'),
- _("Due Date") => array('type'=>'spec', 'fun'=>'due_date'),
+ _("Due Date") => array('type'=>'date', 'fun'=>'due_date'),
_("Customer"),
- _("Currency"),
- _("Debit") => array('type'=>'spec', 'fun'=>'fmt_debit'),
- _("Credit") => array('type'=>'insert', 'fun'=>'fmt_credit'),
+ _("Currency") => array('align'=>'center'),
+ _("Debit") => array('align'=>'right','fun'=>'fmt_debit'),
+ _("Credit") => array('align'=>'right','insert'=>true, 'fun'=>'fmt_credit'),
_("Allocated") => 'amount',
- _("Balance") => array('type'=>'insert', 'fun'=>'fmt_balance'),
- array('type'=>'insert', 'fun'=>'alloc_link')
+ _("Balance") => array('type'=>'amount', 'insert'=>true, 'fun'=>'fmt_balance'),
+ array('insert'=>true, 'fun'=>'alloc_link')
);
if ($_POST['customer_id'] != reserved_words::get_all()) {
- array_remove($cols, 6, 2);
+ $cols[_("Customer")] = 'skip';
+ $cols[_("Currency")] = 'skip';
}
$table =& new_db_pager('doc_tbl', $sql, $cols);
$table->set_marker('check_overdue', _("Marked items are overdue."));
-
-if(get_post('RefreshInquiry'))
-{
+if (get_post('RefreshInquiry')) {
$table->set_sql($sql);
- $Ajax->activate('doc_tbl');
+ $table->set_columns($cols);
}
+start_form();
- start_form();
- display_db_pager($table);
- end_form();
-end_page();
-
+display_db_pager($table);
+end_form();
+end_page();
?>