X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Finquiry%2Fsales_orders_view.php;h=e0d2f957981c87e09ecbdac3439d48c4a7eaaa40;hb=ddadb47f2620ce6902ad4694ce6512568862ba05;hp=5dde39a833e77e363ad6a984376a6181ce449618;hpb=b1167086b19280eb898396e3af6470975ff74571;p=fa-stable.git

diff --git a/sales/inquiry/sales_orders_view.php b/sales/inquiry/sales_orders_view.php
index 5dde39a8..e0d2f957 100644
--- a/sales/inquiry/sales_orders_view.php
+++ b/sales/inquiry/sales_orders_view.php
@@ -1,7 +1,16 @@
 <?php
-
-$page_security = 2;
-$path_to_root="../..";
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+	Released under the terms of the GNU General Public License, GPL, 
+	as published by the Free Software Foundation, either version 3 
+	of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
+$page_security = 'SA_STEMPLATE';
+$path_to_root = "../..";
 
 include($path_to_root . "/includes/db_pager.inc");
 include($path_to_root . "/includes/session.inc");
@@ -14,27 +23,40 @@ if ($use_popup_windows)
 if ($use_date_picker)
 	$js .= get_js_date_picker();
 
-if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
-{
-	$_POST['order_view_mode'] = 'OutstandingOnly';
-	$_SESSION['page_title'] = _("Search Outstanding Sales Orders");
-}
-elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true))
-{
-	$_POST['order_view_mode'] = 'InvoiceTemplates';
-	$_SESSION['page_title'] = _("Search Template for Invoicing");
-}
-elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true))
+if (get_post('type'))
+	$trans_type = $_POST['type'];
+elseif (isset($_GET['type']) && $_GET['type'] == ST_SALESQUOTE)
+	$trans_type = ST_SALESQUOTE;
+else
+	$trans_type = ST_SALESORDER;
+if ($trans_type == ST_SALESORDER)
 {
-	$_POST['order_view_mode'] = 'DeliveryTemplates';
-	$_SESSION['page_title'] = _("Select Template for Delivery");
+	if (isset($_GET['OutstandingOnly']) && ($_GET['OutstandingOnly'] == true))
+	{
+		$_POST['order_view_mode'] = 'OutstandingOnly';
+		$_SESSION['page_title'] = _("Search Outstanding Sales Orders");
+	}
+	elseif (isset($_GET['InvoiceTemplates']) && ($_GET['InvoiceTemplates'] == true))
+	{
+		$_POST['order_view_mode'] = 'InvoiceTemplates';
+		$_SESSION['page_title'] = _("Search Template for Invoicing");
+	}
+	elseif (isset($_GET['DeliveryTemplates']) && ($_GET['DeliveryTemplates'] == true))
+	{
+		$_POST['order_view_mode'] = 'DeliveryTemplates';
+		$_SESSION['page_title'] = _("Select Template for Delivery");
+	}
+	elseif (!isset($_POST['order_view_mode']))
+	{
+		$_POST['order_view_mode'] = false;
+		$_SESSION['page_title'] = _("Search All Sales Orders");
+	}
 }
-elseif (!isset($_POST['order_view_mode']))
+else
 {
-	$_POST['order_view_mode'] = false;
-	$_SESSION['page_title'] = _("Search All Sales Orders");
+	$_POST['order_view_mode'] = "Quotations";
+	$_SESSION['page_title'] = _("Search All Sales Quotations");
 }
-
 page($_SESSION['page_title'], false, false, "", $js);
 
 if (isset($_GET['selected_customer']))
@@ -51,7 +73,7 @@ else
 //---------------------------------------------------------------------------------------------
 
 if (isset($_POST['SelectStockFromList']) && ($_POST['SelectStockFromList'] != "") &&
-	($_POST['SelectStockFromList'] != reserved_words::get_all()))
+	($_POST['SelectStockFromList'] != ALL_TEXT))
 {
  	$selected_stock_item = $_POST['SelectStockFromList'];
 }
@@ -64,57 +86,81 @@ else
 //
 function check_overdue($row)
 {
-	return ($row['type'] == 0
-		&& date1_greater_date2(Today(), sql2date($row['ord_date']))
-		&& ($row['TotDelivered'] < $row['TotQuantity']));
+	global $trans_type;
+	if ($trans_type == ST_SALESQUOTE)
+		return (date1_greater_date2(Today(), sql2date($row['delivery_date'])));
+	else
+		return ($row['type'] == 0
+			&& date1_greater_date2(Today(), sql2date($row['ord_date']))
+			&& ($row['TotDelivered'] < $row['TotQuantity']));
 }
 
 function view_link($dummy, $order_no)
 {
-	return  get_customer_trans_view_str(systypes::sales_order(), $order_no);
+	global $trans_type;
+	return  get_customer_trans_view_str($trans_type, $order_no);
 }
 
 function prt_link($row)
 {
-	return print_document_link($row['order_no'], _("Print"), true, 30);
+	global $trans_type;
+	return print_document_link($row['order_no'], _("Print"), true, $trans_type, ICON_PRINT);
 }
 
 function edit_link($row) 
 {
+	global $trans_type;
+	$modify = ($trans_type == ST_SALESORDER ? "ModifyOrderNumber" : "ModifyQuotationNumber");
   return pager_link( _("Edit"),
-    "/sales/sales_order_entry.php?" . SID . "ModifyOrderNumber=" . $row['order_no']);
+    "/sales/sales_order_entry.php?$modify=" . $row['order_no'], ICON_EDIT);
 }
 
 function dispatch_link($row)
 {
-  return pager_link( _("Dispatch"),
-	"/sales/customer_delivery.php?" . SID . "OrderNumber=" .$row['order_no']);
+	global $trans_type;
+	if ($trans_type == ST_SALESORDER)
+  		return pager_link( _("Dispatch"),
+			"/sales/customer_delivery.php?OrderNumber=" .$row['order_no'], ICON_DOC);
+	else		
+  		return pager_link( _("Sales Order"),
+			"/sales/sales_order_entry.php?OrderNumber=" .$row['order_no'], ICON_DOC);
 }
 
 function invoice_link($row)
 {
-  return pager_link( _("Invoice"),
-	"/sales/sales_order_entry.php?" . SID . "NewInvoice=" .$row["order_no"]);
+	global $trans_type;
+	if ($trans_type == ST_SALESORDER)
+  		return pager_link( _("Invoice"),
+			"/sales/sales_order_entry.php?NewInvoice=" .$row["order_no"], ICON_DOC);
+	else
+		return '';
 }
 
 function delivery_link($row)
 {
   return pager_link( _("Delivery"),
-	"/sales/sales_order_entry.php?" . SID . "NewDelivery=" .$row['order_no']);
+	"/sales/sales_order_entry.php?NewDelivery=" .$row['order_no'], ICON_DOC);
+}
+
+function order_link($row)
+{
+  return pager_link( _("Sales Order"),
+	"/sales/sales_order_entry.php?NewQuoteToSalesOrder=" .$row['order_no'], ICON_DOC);
 }
 
 function tmpl_checkbox($row)
 {
+	global $trans_type;
+	if ($trans_type == ST_SALESQUOTE)
+		return '';
 	$name = "chgtpl" .$row['order_no'];
-	$value = $row['type'] ? ' checked' : '';
-
- return "<input $value type='checkbox' name='$name' value='1'"
-     ." onclick='JsHttpRequest.request(\"_{$name}_update\", this.form);'"
-     ." title='"._('Set this order as a template for direct deliveries/invoices')
-     ."' >"
-// add also old checkbox name+value for check after 'Update'
-	 ."<input name='last[".$row['order_no']."]' type='hidden' value='"
-	 .($row['type'] ? 1 : 0)."'>\n";
+	$value = $row['type'] ? 1:0;
+
+// save also in hidden field for testing during 'Update'
+
+ return checkbox(null, $name, $value, true,
+ 	_('Set this order as a template for direct deliveries/invoices'))
+	. hidden('last['.$row['order_no'].']', $value, false);
 }
 //---------------------------------------------------------------------------------------------
 // Update db record if respective checkbox value has changed.
@@ -133,7 +179,7 @@ $id = find_submit('_chgtpl');
 if ($id != -1)
 	change_tpl_flag($id);
 
-if (isset($_POST['Update'])) {
+if (isset($_POST['Update']) && isset($_POST['last'])) {
 	foreach($_POST['last'] as $id => $value)
 		if ($value != check_value('chgtpl'.$id))
 			change_tpl_flag($id);
@@ -163,7 +209,7 @@ if (get_post('_OrderNumber_changed')) // enable/disable selection controls
 	$Ajax->activate('orders_tbl');
 }
 
-start_form(false, false, $_SERVER['PHP_SELF'] .SID);
+start_form();
 
 start_table("class='tablestyle_noborder'");
 start_row();
@@ -177,20 +223,23 @@ locations_list_cells(_("Location:"), 'StockLocation', null, true);
 
 stock_items_list_cells(_("Item:"), 'SelectStockFromList', null, true);
 
-submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
+if ($trans_type == ST_SALESQUOTE)
+	check_cells(_("Show All:"), 'show_all');
+submit_cells('SearchOrders', _("Search"),'',_('Select documents'), 'default');
 
 hidden('order_view_mode', $_POST['order_view_mode']);
+hidden('type', $trans_type);
 
 end_row();
 
 end_table(1);
 end_form();
-
 //---------------------------------------------------------------------------------------------
 //	Orders inquiry table
 //
 $sql = "SELECT 
 		sorder.order_no,
+		sorder.reference,
 		debtor.name,
 		branch.br_name,"
 		.($_POST['order_view_mode']=='InvoiceTemplates' 
@@ -209,6 +258,8 @@ $sql = "SELECT
 		.TB_PREF."debtors_master as debtor, "
 		.TB_PREF."cust_branch as branch
 		WHERE sorder.order_no = line.order_no
+		AND sorder.trans_type = line.trans_type
+		AND sorder.trans_type = $trans_type
 		AND sorder.debtor_no = debtor.debtor_no
 		AND sorder.branch_code = branch.branch_code
 		AND debtor.debtor_no = branch.debtor_no";
@@ -229,13 +280,15 @@ else	// ... or select inquiry constraints
 		$sql .=  " AND sorder.ord_date >= '$date_after'"
 				." AND sorder.ord_date <= '$date_before'";
   	}
+  	if ($trans_type == 32 && !check_value('show_all'))
+  		$sql .= " AND sorder.delivery_date >= '".date2sql(Today())."'";
 	if ($selected_customer != -1)
 		$sql .= " AND sorder.debtor_no='" . $selected_customer . "'";
 
 	if (isset($selected_stock_item))
 		$sql .= " AND line.stk_code='". $selected_stock_item ."'";
 
-	if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
+	if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != ALL_TEXT)
 		$sql .= " AND sorder.from_stk_loc = '". $_POST['StockLocation'] . "' ";
 
 	if ($_POST['order_view_mode']=='OutstandingOnly')
@@ -251,21 +304,36 @@ else	// ... or select inquiry constraints
 				sorder.deliver_to";
 }
 
-$cols = array(
-	_("Order #") => array('fun'=>'view_link'),
-	_("Customer"),
-	_("Branch"), 
-	_("Comments"),
-	_("Order Date") => 'date',
-	_("Required By") =>array('type'=>'date', 'ord'=>''),
-	_("Delivery To"), 
-	_("Order Total") => array('type'=>'amount', 'ord'=>''),
-	'Type' => 'skip',
-	_("Currency") => array('align'=>'center')
-);
-
+if ($trans_type == ST_SALESORDER)
+	$cols = array(
+		_("Order #") => array('fun'=>'view_link'),
+		_("Ref"),
+		_("Customer"),
+		_("Branch"), 
+		_("Cust Order Ref"),
+		_("Order Date") => 'date',
+		_("Required By") =>array('type'=>'date', 'ord'=>''),
+		_("Delivery To"), 
+		_("Order Total") => array('type'=>'amount', 'ord'=>''),
+		'Type' => 'skip',
+		_("Currency") => array('align'=>'center')
+	);
+else
+	$cols = array(
+		_("Quote #") => array('fun'=>'view_link'),
+		_("Ref"),
+		_("Customer"),
+		_("Branch"), 
+		_("Cust Order Ref"),
+		_("Quote Date") => 'date',
+		_("Valid until") =>array('type'=>'date', 'ord'=>''),
+		_("Delivery To"), 
+		_("Quote Total") => array('type'=>'amount', 'ord'=>''),
+		'Type' => 'skip',
+		_("Currency") => array('align'=>'center')
+	);
 if ($_POST['order_view_mode'] == 'OutstandingOnly') {
-	array_replace($cols, 3, 1, _("Cust Order Ref"));
+	//array_replace($cols, 3, 1, _("Cust Order Ref"));
 	array_append($cols, array(array('insert'=>true, 'fun'=>'dispatch_link')));
 
 } elseif ($_POST['order_view_mode'] == 'InvoiceTemplates') {
@@ -278,7 +346,12 @@ if ($_POST['order_view_mode'] == 'OutstandingOnly') {
 			array('insert'=>true, 'fun'=>'delivery_link'))
 	);
 
-} else {
+} elseif ($trans_type == ST_SALESQUOTE) {
+	 array_append($cols,array(
+					array('insert'=>true, 'fun'=>'edit_link'),
+					array('insert'=>true, 'fun'=>'order_link'),
+					array('insert'=>true, 'fun'=>'prt_link')));
+} elseif ($trans_type == ST_SALESORDER) {
 	 array_append($cols,array(
 			_("Tmpl") => array('insert'=>true, 'fun'=>'tmpl_checkbox'),
 					array('insert'=>true, 'fun'=>'edit_link'),
@@ -289,6 +362,11 @@ if ($_POST['order_view_mode'] == 'OutstandingOnly') {
 $table =& new_db_pager('orders_tbl', $sql, $cols);
 $table->set_marker('check_overdue', _("Marked items are overdue."));
 
+if (get_post('SearchOrders')) {
+	$table->set_sql($sql);
+	$table->set_columns($cols);
+}
+$table->width = "80%";
 start_form();
 
 display_db_pager($table);