{
global $page_nested;
- $str = '';
if ($page_nested)
return '';
trans_editor_link($row['type'], $row['trans_no']);
}
+function copy_link($row)
+{
+ global $page_nested;
+
+ if ($page_nested)
+ return '';
+ if ($row['type'] == ST_CUSTDELIVERY)
+ return pager_link(_("Copy Delivery"), "/sales/sales_order_entry.php?NewDelivery="
+ .$row['order_'], ICON_DOC);
+ elseif ($row['type'] == ST_SALESINVOICE)
+ return pager_link(_("Copy Invoice"), "/sales/sales_order_entry.php?NewInvoice="
+ . $row['order_'], ICON_DOC);
+}
+
function prt_link($row)
{
if ($row['type'] == ST_CUSTPAYMENT || $row['type'] == ST_BANKDEPOSIT)
{
$past1 = get_company_pref('past_due_days');
$past2 = 2 * $past1;
- if ($customer_record["dissallow_invoices"] != 0)
+ if ($customer_record && $customer_record["dissallow_invoices"] != 0)
{
echo "<center><font color=red size=4><b>" . _("CUSTOMER ACCOUNT IS ON HOLD") . "</font></b></center>";
}
$th = array(_("Currency"), _("Terms"), _("Current"), $nowdue,
$pastdue1, $pastdue2, _("Total Balance"));
table_header($th);
-
- start_row();
- label_cell($customer_record["curr_code"]);
- label_cell($customer_record["terms"]);
- amount_cell($customer_record["Balance"] - $customer_record["Due"]);
- amount_cell($customer_record["Due"] - $customer_record["Overdue1"]);
- amount_cell($customer_record["Overdue1"] - $customer_record["Overdue2"]);
- amount_cell($customer_record["Overdue2"]);
- amount_cell($customer_record["Balance"]);
- end_row();
+ if ($customer_record != false)
+ {
+ start_row();
+ label_cell($customer_record["curr_code"]);
+ label_cell($customer_record["terms"]);
+ amount_cell($customer_record["Balance"] - $customer_record["Due"]);
+ amount_cell($customer_record["Due"] - $customer_record["Overdue1"]);
+ amount_cell($customer_record["Overdue1"] - $customer_record["Overdue2"]);
+ amount_cell($customer_record["Overdue2"]);
+ amount_cell($customer_record["Balance"]);
+ end_row();
+ }
end_table();
}
start_table(TABLESTYLE_NOBORDER);
start_row();
+ref_cells(_("Reference:"), 'Ref', '', NULL, _('Enter reference fragment or leave empty'));
+
if (!$page_nested)
customer_list_cells(_("Select a customer: "), 'customer_id', null, true, true, false, true);
}
//------------------------------------------------------------------------------------------------
$sql = get_sql_for_customer_inquiry(get_post('TransAfterDate'), get_post('TransToDate'),
- get_post('customer_id'), get_post('filterType'), check_value('show_voided'));
+ get_post('customer_id'), get_post('filterType'), check_value('show_voided'), get_post('Ref'));
//------------------------------------------------------------------------------------------------
//db_query("set @bal:=0");
_("Balance") => array('align'=>'right', 'type'=>'amount'),
array('insert'=>true, 'fun'=>'gl_view'),
array('insert'=>true, 'fun'=>'edit_link'),
+ array('insert'=>true, 'fun'=>'copy_link'),
array('insert'=>true, 'fun'=>'credit_link'),
array('insert'=>true, 'fun'=>'prt_link')
);