X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_allocation_inquiry.php;h=6d6d656f94ef68e70ea1a35b6b6285e9c2ab8e4c;hb=e39d77850382a1184502c596aae74f353de38774;hp=c16cb253405f87e918fbb0797a4304a903ebcc38;hpb=348062667e6a96e9849bf25de0f2a426b4f0b9c6;p=fa-stable.git diff --git a/sales/inquiry/customer_allocation_inquiry.php b/sales/inquiry/customer_allocation_inquiry.php index c16cb253..6d6d656f 100644 --- a/sales/inquiry/customer_allocation_inquiry.php +++ b/sales/inquiry/customer_allocation_inquiry.php @@ -188,17 +188,8 @@ function fmt_credit($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'), @@ -206,8 +197,8 @@ $cols = array( _("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', @@ -216,7 +207,8 @@ $cols = array( ); 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); @@ -226,6 +218,7 @@ $table->set_marker('check_overdue', _("Marked items are overdue.")); if(get_post('RefreshInquiry')) { $table->set_sql($sql); + $table->set_columns($cols); $Ajax->activate('doc_tbl'); }