$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";