+ $date = sql2date($work_order['date_']);
+
+ $result = get_work_order_productions($woid); // check the produced quantity
+ $qty = 0;
+ while ($row = db_fetch($result))
+ {
+ void_work_order_produce($row['id']);
+
+ //Post voided entry if not prevoided explicitly
+ $void_entry = get_voided_entry(ST_MANURECEIVE, $row['id']);
+ if ($void_entry)
+ continue;
+ $memo_ = _("Voiding Work Order Trans # ").$woid;
+ add_audit_trail(ST_MANURECEIVE, $row['id'], today(), _("Voided.")."\n".$memo_);
+ add_voided_entry(ST_MANURECEIVE, $row['id'], today(), $memo_);
+ }
+
+ $result = get_work_order_issues($woid);
+ $cost = 0;
+ $issue_no = 0;
+ while ($row = db_fetch($result))
+ {
+ void_work_order_issue($row['issue_no']);
+
+ //Post voided entry if not prevoided explicitly
+ $void_entry = get_voided_entry(ST_MANUISSUE, $row['issue_no']);
+ if ($void_entry)
+ continue;
+ $memo_ = _("Voiding Work Order Trans # ").$woid;
+ add_audit_trail(ST_MANUISSUE, $row['issue_no'], today(), _("Voided.")."\n".$memo_);
+ add_voided_entry(ST_MANUISSUE, $row['issue_no'], today(), $memo_);
+ }
+
+ //Adust avg labour cost
+ $cost = get_gl_wo_cost($woid, WO_LABOUR);
+ if ($cost != 0)
+ add_labour_cost($work_order['stock_id'], 1, $date, -$cost, true);
+
+ //Adust avg overhead cost
+ $cost = get_gl_wo_cost($woid, WO_OVERHEAD);
+ if ($cost != 0)
+ add_overhead_cost($work_order['stock_id'], 1, $date, -$cost, true);
+
+ $sql = "UPDATE ".TB_PREF."workorders SET closed=1,units_reqd=0,units_issued=0 WHERE id = "
+ .db_escape($woid);
+ db_query($sql, "The work order couldn't be voided");
+
+ // void all related stock moves
+ void_stock_move(ST_WORKORDER, $woid);
+
+ // void any related bank/gl trans
+ void_bank_trans(ST_WORKORDER, $woid, true);
+
+ // clear the requirements units received
+ void_wo_requirements($woid);
+ }
+ commit_transaction();
+}
+
+function get_sql_for_work_orders($outstanding_only, $all_items)
+{
+ $sql = "SELECT
+ workorder.id,
+ workorder.wo_ref,
+ workorder.type,
+ location.location_name,
+ item.description,
+ workorder.units_reqd,
+ workorder.units_issued,
+ workorder.date_,
+ workorder.required_by,
+ workorder.released_date,
+ workorder.closed,
+ workorder.released,
+ workorder.stock_id,
+ unit.decimals
+ FROM ".TB_PREF."workorders as workorder,"
+ .TB_PREF."stock_master as item,"
+ .TB_PREF."item_units as unit,"
+ .TB_PREF."locations as location
+ WHERE workorder.stock_id=item.stock_id
+ AND workorder.loc_code=location.loc_code
+ AND item.units=unit.abbr";
+
+ if (check_value('OpenOnly') || $outstanding_only != 0)
+ {
+ $sql .= " AND workorder.closed=0";
+ }
+
+ if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != $all_items)
+ {
+ $sql .= " AND workorder.loc_code=".db_escape($_POST['StockLocation']);
+ }
+
+ if (isset($_POST['OrderId']) && $_POST['OrderId'] != "")
+ {
+ $sql .= " AND workorder.id LIKE ".db_escape('%'.$_POST['OrderId'].'%');