function delete_po($po)
{
+ global $Refs;
+
+ begin_transaction();
hook_db_prevoid($po, ST_PURCHORDER);
$sql = "DELETE FROM ".TB_PREF."purch_orders WHERE order_no=".db_escape($po);
db_query($sql, "The order header could not be deleted");
$sql = "DELETE FROM ".TB_PREF."purch_order_details WHERE order_no =".db_escape($po);
db_query($sql, "The order detail lines could not be deleted");
+
+ $Refs->restore_last(ST_PURCHORDER, $po);
+ commit_transaction();
}
//----------------------------------------------------------------------------------------
foreach ($po_obj->line_items as $po_line)
{
$sql = "INSERT INTO ".TB_PREF."purch_order_details (po_detail_item, order_no, item_code,
- description, delivery_date, unit_price, quantity_ordered) VALUES ("
+ description, delivery_date, unit_price, quantity_ordered, quantity_received) VALUES ("
.db_escape($po_line->po_detail_rec ? $po_line->po_detail_rec : 0). ","
.$po_obj->order_no . ","
.db_escape($po_line->stock_id). ","
.db_escape($po_line->item_description). ",'"
.date2sql($po_line->req_del_date) . "',"
.db_escape($po_line->price) . ", "
- .db_escape($po_line->quantity) . ")";
+ .db_escape($po_line->quantity) . ", "
+ .db_escape($po_line->qty_received) . ")";
db_query($sql, "One of the purchase order detail records could not be updated");
}
$order->credit = get_current_supp_credit($order->supplier_id);
$order->orig_order_date = sql2date($myrow["ord_date"]);
- $order->Comments = $myrow["comments"];
+ $order->Comments = nl2br($myrow["comments"]);
$order->Location = $myrow["into_stock_location"];
$order->supp_ref = $myrow["requisition_no"];
$order->reference = $myrow["reference"];
return db_query($sql,"The stock details for " . $stock_id . " could not be retrieved");
}
-function get_sql_for_po_search_completed()
+function get_sql_for_po_search_completed($supplier_id=ALL_TEXT)
{
global $order_number, $selected_stock_item;;
AND porder.supplier_id = supplier.supplier_id
AND location.loc_code = porder.into_stock_location ";
+ if (isset($_GET['supplier_id']))
+ $sql .= "AND supplier.supplier_id=".@$_GET['supplier_id']." ";
if (isset($order_number) && $order_number != "")
{
$sql .= "AND porder.reference LIKE ".db_escape('%'. $order_number . '%');
{
$sql .= " AND line.item_code=".db_escape($selected_stock_item);
}
-
+ if ($supplier_id != ALL_TEXT)
+ $sql .= " AND supplier.supplier_id=".db_escape($supplier_id);
+
} //end not order number selected
$sql .= " GROUP BY porder.order_no";
return $sql;
}
-function get_sql_for_po_search()
+function get_sql_for_po_search($supplier_id=ALL_TEXT)
{
global $all_items, $order_number, $selected_stock_item;;
{
$sql .= " AND line.item_code=".db_escape($selected_stock_item);
}
+ if ($supplier_id != ALL_TEXT)
+ $sql .= " AND supplier.supplier_id=".db_escape($supplier_id);
} //end not order number selected
$sql .= " GROUP BY porder.order_no";