//--------------------------------------------------------------------------------
start_form();
- /* show all outstanding receipts and credits to be allocated */
+/* show all outstanding receipts and credits to be allocated */
- if (!isset($_POST['customer_id']))
- $_POST['customer_id'] = get_global_customer();
+if (!isset($_POST['customer_id']))
+ $_POST['customer_id'] = get_global_customer();
- echo "<center>" . _("Select a customer: ") . " ";
- echo customer_list('customer_id', $_POST['customer_id'], true, true);
- echo "<br>";
- check(_("Show Settled Items:"), 'ShowSettled', null, true);
- echo "</center><br><br>";
+echo "<center>" . _("Select a customer: ") . " ";
+echo customer_list('customer_id', $_POST['customer_id'], true, true);
+echo "<br>";
- set_global_customer($_POST['customer_id']);
+check(_("Show Settled Items:"), 'ShowSettled', null, true);
+echo "</center><br><br>";
- if (isset($_POST['customer_id']) && ($_POST['customer_id'] == ALL_TEXT))
- {
- unset($_POST['customer_id']);
- }
+set_global_customer($_POST['customer_id']);
- /*if (isset($_POST['customer_id'])) {
- $custCurr = get_customer_currency($_POST['customer_id']);
- if (!is_company_currency($custCurr))
- echo _("Customer Currency:") . $custCurr;
- }*/
+if (isset($_POST['customer_id']) && ($_POST['customer_id'] == ALL_TEXT))
+{
+ unset($_POST['customer_id']);
+}
- $settled = false;
- if (check_value('ShowSettled'))
- $settled = true;
+$settled = false;
+if (check_value('ShowSettled'))
+ $settled = true;
- $customer_id = null;
- if (isset($_POST['customer_id']))
- $customer_id = $_POST['customer_id'];
+$customer_id = null;
+if (isset($_POST['customer_id']))
+ $customer_id = $_POST['customer_id'];
//--------------------------------------------------------------------------------
function systype_name($dummy, $type)
function alloc_link($row)
{
+ global $all_settled;
+
return pager_link(_("Allocate"),
"/sales/allocations/customer_allocate.php?trans_no="
.$row["trans_no"] . "&trans_type=" . $row["type"]. "&debtor_no=" . $row["debtor_no"], ICON_ALLOC);
}
+function amount_total($row)
+{
+ return price_format($row['type'] == ST_JOURNAL && $row["Total"] < 0 ? -$row["Total"] : $row["Total"]);
+}
+
function amount_left($row)
{
- return price_format($row["Total"]-$row["alloc"]);
+ return price_format(($row['type'] == ST_JOURNAL && $row["Total"] < 0 ? -$row["Total"] : $row["Total"])-$row["alloc"]);
}
function check_settled($row)
return $row['settled'] == 1;
}
+$all_settled = !db_num_rows(get_allocatable_to_cust_transactions($customer_id));
+
+if ($all_settled)
+ display_note('<b>'.
+ ($customer_id ? _("There is no unsettled transactions for this customer.")
+ :_("There is no unsettled transactions.")).'</b><p>');
$sql = get_allocatable_from_cust_sql($customer_id, $settled);
$cols = array(
_("Transaction Type") => array('fun'=>'systype_name'),
- _("#") => array('fun'=>'trans_view'),
+ _("#") => array('fun'=>'trans_view', 'align'=>'right'),
_("Reference"),
_("Date") => array('name'=>'tran_date', 'type'=>'date', 'ord'=>'asc'),
_("Customer") => array('ord'=>''),
_("Currency") => array('align'=>'center'),
- _("Total") => 'amount',
+ _("Total") => array('align'=>'right','fun'=>'amount_total'),
_("Left to Allocate") => array('align'=>'right','insert'=>true, 'fun'=>'amount_left'),
array('insert'=>true, 'fun'=>'alloc_link')
);