."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'),
_("Order") => array('type'=>'spec', 'fun'=>'order_link'),
_("Date") => array('type'=>'date', 'ord'=>'asc'),
_("Due Date") => array('type'=>'spec', 'fun'=>'due_date'),
- _("Customer"),
- _("Currency"),
+ _("Customer") => 'text',
+ _("Currency") => 'text',
_("Debit") => array('type'=>'spec', 'fun'=>'fmt_debit'),
_("Credit") => array('type'=>'insert', 'fun'=>'fmt_credit'),
_("Allocated") => 'amount',
);
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);
if(get_post('RefreshInquiry'))
{
$table->set_sql($sql);
+ $table->set_columns($cols);
$Ajax->activate('doc_tbl');
}