-//------------------------------------------------------------------------------------------------
-
-start_table("$table_style width='80%'");
-
-if ($_POST['customer_id'] == reserved_words::get_all())
- $th = array(_("Type"), _("Number"), _("Reference"), _("Order"), _("Date"), _("Due Date"),
- _("Customer"), _("Currency"), _("Debit"), _("Credit"), _("Allocated"), _("Balance"), "");
-else
- $th = array(_("Type"), _("Number"), _("Reference"), _("Order"), _("Date"), _("Due Date"),
- _("Debit"), _("Credit"), _("Allocated"), _("Balance"), "");
-
-table_header($th);
-
-
-$j = 1;
-$k = 0; //row colour counter
-$over_due = false;
-while ($myrow = db_fetch($result))
-{
-
- if ($myrow['OverDue'] == 1 && (abs($myrow["TotalAmount"]) - $myrow["Allocated"] != 0))
- {
- start_row("class='overduebg'");
- $over_due = true;
- }
- else
- alt_table_row_color($k);
-
- $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 = "";
-
- $allocations_str = "";
-
- $allocations = "<a href='$path_to_root/sales/allocations/customer_allocate.php?trans_no=" . $myrow["trans_no"] ."&trans_type=" . $myrow["type"] ."'>" . _("Allocation") . "</a>";
-
- $due_date_str = "";
-
- if ($myrow["type"] == 10)
- $due_date_str = sql2date($myrow["due_date"]);
- elseif ($myrow["type"] == 11 && $myrow['TotalAmount'] > 0)
- {
- /*its a credit note which could have an allocation */
- $allocations_str = $allocations;
-
- }
- elseif ($myrow["type"] == systypes::cust_payment() &&
- ($myrow['TotalAmount'] + $myrow['Allocated']) > 0)
- {
- /*its a receipt which could have an allocation*/
- $allocations_str = $allocations;