/**
* 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();
}
