/** * Get all the DTR of all employee of a branch on a certain date * * @param User $user * @return Collection */ public function branchByDate(User $user, $date) { return Dtr::with(['employee' => function ($query) { $query->select('lastname', 'firstname', 'id'); }])->select('dtr.*')->leftJoin('employee', function ($join) { $join->on('dtr.employeeid', '=', 'employee.id'); })->where('employee.branchid', '=', $user->branchid)->where('dtr.date', '=', $date)->orderBy('employee.lastname', 'ASC')->orderBy('employee.firstname', 'ASC')->get(); }
private function dtrExistOrCreate($employeeid, $date) { $dtr = Dtr::employeeid($employeeid)->date($date)->first(); if (is_null($dtr)) { $n = new Dtr(); $n->date = $date; $n->employeeid = $employeeid; $n->id = $n->get_uid(); return $n; } return $dtr; }
public function byEmployeeDate($employeeid, $date) { return Dtr::where('employeeid', $employeeid)->where('date', $date)->first(); }