protected function rawFilter($input)
{
//dd($input);
// Build a query based on filter $input
$query = InboundOrderDetail::orderBy('objectID');
if (isset($input['Order_Number']) && strlen($input['Order_Number']) > 3) {
$query = $query->where('Order_Number', 'like', $input['Order_Number'] . '%');
}
if (isset($input['SKU']) && strlen($input['SKU']) > 3) {
$query = $query->where('SKU', 'like', $input['SKU'] . '%');
}
if (isset($input['Expected_Qty']) && strlen($input['Expected_Qty']) > 0) {
$query = $query->where('Expected_Qty', 'like', $input['Expected_Qty'] . '%');
}
if (isset($input['Actual_Qty']) && strlen($input['Actual_Qty']) > 0) {
$query = $query->where('Actual_Qty', 'like', $input['Actual_Qty'] . '%');
}
if (isset($input['Status']) && strlen($input['Status']) > 1) {
$query = $query->where('Status', 'like', $input['Status'] . '%');
}
if (isset($input['UPC']) && strlen($input['UPC']) > 3) {
$query = $query->where('UPC', 'like', $input['UPC'] . '%');
}
if (isset($input['UOM']) && strlen($input['UOM']) > 3) {
$query = $query->where('UOM', 'like', $input['UOM'] . '%');
}
return $query;
}
/**
* Implement getAll()
*/
public function getAll($limit = 10)
{
if ($limit == 1) {
return $this->findAdditional(InboundOrderDetail::orderBy('Order_Number', 'desc')->first());
} else {
if ($limit == 0) {
$purchaseOrderDetails = InboundOrderDetail::orderBy('Order_Number', 'desc')->get();
} else {
// using the Eloquent model
$purchaseOrderDetails = InboundOrderDetail::orderBy('Order_Number', 'desc')->limit($limit)->get();
}
}
foreach ($purchaseOrderDetails as $purchaseOrderDetail) {
$this->findAdditional($purchaseOrderDetail);
}
return $purchaseOrderDetails;
}
