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; }