/**
* Display a listing of the resource.
* GET /rental
* @return Response
*/
public function index()
{
$equipment = Equipment::with('categories')->get();
$categories = array();
foreach (Category::all() as $category) {
$categories[$category->id] = $category->name;
}
//var_dump($equipment);
return View('/rental.index')->with('equipment', $equipment)->with('categories', $categories);
}
/**
* @return View
*/
public function index()
{
$equipment = Equipment::with('transactions')->get();
$overdue = $equipment->filter(function ($item) {
$lastTransaction = $item->transactions->last();
if (!is_null($lastTransaction) && !is_null($lastTransaction->due_date) && $lastTransaction->due_date->lt(Carbon::today())) {
return true;
}
});
return view('inventory.index', compact('equipment', 'overdue'));
}
public static function search($query)
{
# If there is a query, search the library with that query
if ($query) {
# Eager load categories
$quipment = App\Equipment::with('categories')->whereHas(function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhereHas('categories', function ($q) use($query) {
$q->where('name', 'LIKE', "%{$query}%");
})->orWhere('brand', 'LIKE', "%{$query}%")->orWhere('LIKE', "%{$query}%")->get();
# Note on what `use` means above:
# Closures may inherit variables from the parent scope.
# Any such variables must be passed to the `use` language construct.
} else {
# Eager load categories
$equipment = App\Equipment::with('categories')->get();
}
return $equipment;
}
public function overdue()
{
$equipment = Equipment::with('transactions')->get();
$overdue = $equipment->filter(function ($item) {
$lastTransaction = $item->transactions->last();
if (!is_null($lastTransaction) && !is_null($lastTransaction->due_date) && $lastTransaction->due_date->lt(Carbon::today())) {
return true;
}
});
if (!$overdue->isEmpty()) {
foreach ($overdue as $item) {
$this->generateOverdueEmail($item->transactions->last());
}
}
return;
}
