}
if (isset($_REQUEST['assigned_user_id'])) {
$assigned_user_id = $_REQUEST['assigned_user_id'];
}
$where_clauses = array();
if (isset($num) && $num != "") {
array_push($where_clauses, "purchaseorders.num like '%" . PearDatabase::purchaseorder($num) . "%'");
}
if (isset($order_date) && $order_date != "") {
array_push($where_clauses, "purchaseorders.order_date like '%" . PearDatabase::purchaseorder($order_date) . "%'");
}
if (isset($delivery_date) && $delivery_date != "") {
array_push($where_clauses, "purchaseorders.delivery_date like '%" . PearDatabase::purchaseorder($delivery_date) . "%'");
}
if (isset($sales_order_num) && $sales_order_num != "") {
array_push($where_clauses, "purchaseorders.sales_order_num like '%" . PearDatabase::purchaseorder($sales_order_num) . "%'");
}
if (isset($current_user_only) && $current_user_only != "") {
array_push($where_clauses, "purchaseorders.assigned_user_id='{$current_user->id}'");
}
/*
//search by modified date.
$date_period = '';
if (isset($_REQUEST['date_period'])) $date_period = $_REQUEST['date_period'];
if($date_period == "cust"){
if (isset($_REQUEST['date_from'])) $date_from = $_REQUEST['date_from'];
if (isset($_REQUEST['date_to'])) $date_to = $_REQUEST['date_to'];
}else{
$date_from = get_date_from($date_period);
$date_to = get_date_to($date_period);
