X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_orders_db.inc;h=3ed8126da9e2e80b703aa6546655de289dad7e48;hb=17b390efcf904072b02ec866b2a427490471a260;hp=eb31056809b6c4f81d88bc4b8b9faacfbce5ed2c;hpb=264c09696d65efe4532c197f317162daf8c24f32;p=fa-stable.git

diff --git a/manufacturing/includes/db/work_orders_db.inc b/manufacturing/includes/db/work_orders_db.inc
index eb310568..3ed8126d 100644
--- a/manufacturing/includes/db/work_orders_db.inc
+++ b/manufacturing/includes/db/work_orders_db.inc
@@ -53,7 +53,7 @@ function add_work_order($wo_ref, $loc_code, $units_reqd, $stock_id,
 //--------------------------------------------------------------------------------------
 
 function update_work_order($woid, $loc_code, $units_reqd, $stock_id,
-					$date_, $required_by, $memo_)
+					$date_, $required_by, $memo_, $old_stock_id, $old_qty)
 {
 	begin_transaction();
 	$args = func_get_args();
@@ -61,7 +61,7 @@ function update_work_order($woid, $loc_code, $units_reqd, $stock_id,
 		'date_', 'required_by', 'memo_'), $args);
 	hook_db_prewrite($args, ST_WORKORDER);
 
-	add_material_cost($_POST['old_stk_id'], -$_POST['old_qty'], $date_);
+	add_material_cost($old_stock_id, -$old_qty, $date_);
 	add_material_cost($stock_id, $units_reqd, $date_);
 
 	$date = date2sql($date_);
@@ -82,12 +82,12 @@ function update_work_order($woid, $loc_code, $units_reqd, $stock_id,
 	commit_transaction();
 }
 
-function delete_work_order($woid)
+function delete_work_order($woid, $stock_id, $qty, $date)
 {
 	begin_transaction();
 	hook_db_prevoid(ST_WORKORDER, $woid);
 
-	add_material_cost($_POST['stock_id'], -$_POST['quantity'], $_POST['date_']);
+	add_material_cost($stock_id, -$qty, $date);
 
 	// delete the work order requirements
 	delete_wo_requirements($woid);
@@ -97,7 +97,7 @@ function delete_work_order($woid)
 	db_query($sql,"The work order could not be deleted");
 
 	delete_comments(ST_WORKORDER, $woid);
-	add_audit_trail(ST_WORKORDER, $woid, $_POST['date_'], _("Canceled."));
+	add_audit_trail(ST_WORKORDER, $woid, $date, _("Canceled."));
 
 	commit_transaction();
 }
@@ -252,7 +252,7 @@ function void_work_order($woid)
 			// clear the production record
 			$sql = "UPDATE ".TB_PREF."wo_manufacture SET quantity=0 WHERE id=".$$row['id'];
 			db_query($sql, "Cannot void a wo production");
-			
+
 			void_stock_move(ST_MANURECEIVE, $row['id']); // and void the stock moves; 
 		}
 		$result = get_additional_issues($woid); // check the issued quantities
@@ -297,7 +297,7 @@ function void_work_order($woid)
 	commit_transaction();
 }
 
-function get_sql_for_work_orders($outstanding_only, $all_items)
+function get_sql_for_work_orders($outstanding_only, $stock_id, $location = ALL_TEXT, $oredr_no='', $order_ref = '', $overdue = false)
 {
 	$sql = "SELECT
 		workorder.id,
@@ -327,22 +327,27 @@ function get_sql_for_work_orders($outstanding_only, $all_items)
 		$sql .= " AND workorder.closed=0";
 	}
 
-	if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items)
+	if ($location != ALL_TEXT)
 	{
-		$sql .= " AND workorder.loc_code=".db_escape($_POST['StockLocation']);
+		$sql .= " AND workorder.loc_code=".db_escape($location);
 	}
 
-	if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "")
+	if ($order_no != '')
 	{
-		$sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$_POST['OrderNumber'].'%');
+		$sql .= " AND workorder.id LIKE ".db_escape('%'.$order_no.'%');
 	}
 
-	if (isset($_POST['SelectedStockItem']) && $_POST['SelectedStockItem'] != $all_items)
+	if ($order_ref != '')
 	{
-		$sql .= " AND workorder.stock_id=".db_escape($_POST['SelectedStockItem']);
+		$sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$order_ref.'%');
 	}
 
-	if (check_value('OverdueOnly'))
+	if ($stock_id != ALL_TEXT)
+	{
+		$sql .= " AND workorder.stock_id=".db_escape($stock_id);
+	}
+
+	if ($overdue)
 	{
 		$Today = date2sql(Today());
 
@@ -351,7 +356,7 @@ function get_sql_for_work_orders($outstanding_only, $all_items)
 	return $sql;
 }
 
-function get_sql_for_where_used()
+function get_sql_for_where_used($stock_id)
 {
 	$sql = "SELECT 
 			bom.parent,
@@ -366,8 +371,8 @@ function get_sql_for_where_used()
 			WHERE bom.parent = parent.stock_id 
 				AND bom.workcentre_added = workcentre.id
 				AND bom.loc_code = location.loc_code
-				AND bom.component=".db_escape($_POST['stock_id']);
-	return $sql;			
+				AND bom.component=".db_escape($stock_id);
+	return $sql;
 }
 //--------------------------------------------------------------------------------------
 function get_gl_wo_cost($woid, $cost_type)
@@ -379,4 +384,3 @@ function get_gl_wo_cost($woid, $cost_type)
 	return $cost;	
 }
 
-?>
\ No newline at end of file