X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fsales_deliveries_view.php;h=98d17a7490b51efce0f4fcec9d66a4bfb859e2e2;hb=5bdc773f0bb3f962a0a37ecc4647dc4e0d2e64e8;hp=7ae41594f0df146f585d83a2f691841f6fc83d35;hpb=d67d5295b9342c011697ce4df325197e29898588;p=fa-stable.git

diff --git a/sales/inquiry/sales_deliveries_view.php b/sales/inquiry/sales_deliveries_view.php
index 7ae41594..98d17a74 100644
--- a/sales/inquiry/sales_deliveries_view.php
+++ b/sales/inquiry/sales_deliveries_view.php
@@ -75,6 +75,28 @@ if (isset($_POST['BatchInvoice']))
 		meta_forward($path_to_root . '/sales/customer_invoice.php','BatchInvoice=Yes');
     }
 }
+
+//-----------------------------------------------------------------------------------
+if (get_post('SearchOrders')) 
+{
+	$Ajax->activate('deliveries_tbl');
+} elseif (get_post('_DeliveryNumber_changed')) 
+{
+	$disable = get_post('DeliveryNumber') !== '';
+
+	$Ajax->addDisable(true, 'DeliveryAfterDate', $disable);
+	$Ajax->addDisable(true, 'DeliveryToDate', $disable);
+	$Ajax->addDisable(true, 'StockLocation', $disable);
+	$Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
+	$Ajax->addDisable(true, 'SelectStockFromList', $disable);
+	// if search is not empty rewrite table
+	if ($disable) {
+		$Ajax->addFocus(true, 'DeliveryNumber');
+	} else
+		$Ajax->addFocus(true, 'DeliveryAfterDate');
+	$Ajax->activate('deliveries_tbl');
+}
+
 //-----------------------------------------------------------------------------------
 print_hidden_script(13);
 
@@ -82,7 +104,7 @@ start_form(false, false, $_SERVER['PHP_SELF'] ."?OutstandingOnly=" . $_POST['Out
 
 start_table("class='tablestyle_noborder'");
 start_row();
-ref_cells(_("#:"), 'DeliveryNumber');
+ref_cells(_("#:"), 'DeliveryNumber', '',null, '', true);
 date_cells(_("from:"), 'DeliveryAfterDate', '', null, -30);
 date_cells(_("to:"), 'DeliveryToDate', '', null, 1);
 
@@ -90,7 +112,7 @@ locations_list_cells(_("Location:"), 'StockLocation', null, true);
 
 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
 
-submit_cells('SearchOrders', _("Search"));
+submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
 
 hidden('OutstandingOnly', $_POST['OutstandingOnly']);
 
@@ -126,9 +148,6 @@ $sql .= " Sum(".TB_PREF."debtor_trans_details.quantity-"
 
 $sql .= " Sum(".TB_PREF."debtor_trans_details.qty_done) AS Done, ";
 
-//$sql .= " Sum(".TB_PREF."debtor_trans_details.unit_price*"
-// .TB_PREF."debtor_trans_details.quantity*(1-"
-// .TB_PREF."debtor_trans_details.discount_percent)) AS DeliveryValue";
 $sql .= "(ov_amount+ov_gst+ov_freight+ov_freight_tax) AS DeliveryValue";
 $sql .=" FROM "
 	 .TB_PREF."sales_orders, "
@@ -145,10 +164,16 @@ $sql .=" FROM "
 			AND ".TB_PREF."debtor_trans.branch_code = ".TB_PREF."cust_branch.branch_code
 			AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."cust_branch.debtor_no ";
 
+	if ($_POST['OutstandingOnly'] == true) {
+	 $sql .= " AND ".TB_PREF."debtor_trans_details.qty_done < ".TB_PREF."debtor_trans_details.quantity ";
+	}
+
 //figure out the sql required from the inputs available
 if (isset($_POST['DeliveryNumber']) && $_POST['DeliveryNumber'] != "")
 {
-	$sql .= " AND ".TB_PREF."debtor_trans.trans_no LIKE '%". $_POST['DeliveryNumber'] ."' GROUP BY ".TB_PREF."debtor_trans.trans_no";
+// if ($_POST['DeliveryNumber'] != '*') // TODO paged table
+	$sql .= " AND ".TB_PREF."debtor_trans.trans_no LIKE '%". $_POST['DeliveryNumber'] ."'";
+ $sql .= " GROUP BY ".TB_PREF."debtor_trans.trans_no";
 }
 else
 {
@@ -168,15 +193,7 @@ else
 	if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 		$sql .= " AND ".TB_PREF."sales_orders.from_stk_loc = '". $_POST['StockLocation'] . "' ";
 
-	if ($_POST['OutstandingOnly'] == true) {
-	 $sql .= " AND ".TB_PREF."debtor_trans_details.qty_done < ".TB_PREF."debtor_trans_details.quantity ";
-	}
-
 	$sql .= " GROUP BY ".TB_PREF."debtor_trans.trans_no ";
-//	.TB_PREF."debtor_trans.debtor_no, "
-//	.TB_PREF."debtor_trans.branch_code, "
-//		".TB_PREF."sales_orders.customer_ref, "
-//		.TB_PREF."debtor_trans.tran_date";
 
 } //end no delivery number selected
 
@@ -193,6 +210,8 @@ if ($result)
 {
 	/*show a table of the deliveries returned by the sql */
 
+	div_start('deliveries_tbl');
+
 	start_table("$table_style colspan=7 width=95%");
 	$th = array(_("Delivery #"), _("Customer"), _("Branch"), _("Reference"), _("Delivery Date"),
 		_("Due By"), _("Delivery Total"), _("Currency"), submit('BatchInvoice','Batch Inv', false),
@@ -268,6 +287,7 @@ if ($result)
 
    if ($overdue_items)
    		display_note(_("Marked items are overdue."), 0, 1, "class='overduefg'");
+div_end();
 }
 
 echo "<br>";