X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fcustomer_inquiry.php;h=2e7f0117d087415987514fab07412507416f9c4b;hb=refs%2Fremotes%2Fgithub%2Fmaster;hp=b14882f2951e8396897347e82c34cbd820326078;hpb=3037922976bb62055d32e0bc88d20b6601bd7d14;p=fa-stable.git

diff --git a/sales/inquiry/customer_inquiry.php b/sales/inquiry/customer_inquiry.php
index b14882f2..2e7f0117 100644
--- a/sales/inquiry/customer_inquiry.php
+++ b/sales/inquiry/customer_inquiry.php
@@ -84,7 +84,6 @@ function edit_link($row)
 {
 	global $page_nested;
 
-	$str = '';
 	if ($page_nested)
 		return '';
 
@@ -92,6 +91,20 @@ function edit_link($row)
 			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) 
@@ -113,7 +126,7 @@ function display_customer_summary($customer_record)
 {
 	$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>";
     }
@@ -126,16 +139,18 @@ function display_customer_summary($customer_record)
     $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();
 }
@@ -155,6 +170,8 @@ if (!isset($_POST['customer_id']))
 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);
 
@@ -190,7 +207,7 @@ if (get_post('RefreshInquiry') || list_updated('filterType'))
 }
 //------------------------------------------------------------------------------------------------
 $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");
@@ -209,6 +226,7 @@ $cols = array(
 	_("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')
 	);