private function empGrpByDeptWithManday(Request $request, $id)
{
//$depts = $this->empGrpByDept(); // get array of dept w/ emp grouped by department e.g. dining, kitchen
$depts = $this->employees->byDepartment($request);
for ($h = 0; $h < count($depts); $h++) {
$arr = $depts[$h]['employees']->toArray();
// extract emp on each dept
for ($i = 0; $i < count($arr); $i++) {
$mandtl = Mandtl::where('employeeid', $depts[$h]['employees'][$i]->id)->where('mandayid', $id)->get()->first();
$depts[$h]['employees'][$i]['manskeddtl'] = count($mandtl) > 0 ? ['daytype' => $mandtl->daytype, 'timestart' => $mandtl->timestart, 'breakstart' => $mandtl->breakstart, 'breakend' => $mandtl->breakend, 'timeend' => $mandtl->timeend, 'workhrs' => $mandtl->workhrs, 'breakhrs' => $mandtl->breakhrs, 'loading' => $mandtl->loading, 'id' => $mandtl->id] : ['daytype' => 0, 'timestart' => 'off', 'breakstart' => '', 'breakend' => '', 'timeend' => '', 'workhrs' => '', 'breakhrs' => '', 'loading' => '', 'id' => ''];
}
}
return $depts;
}
public function makeEditView(Request $request, $param1)
{
$manday = Manday::find($param1);
//return $manday;
if (count($manday) > 0) {
// check if the $id
$depts = $this->empGrpByDept();
// get array of dept w/ emp grouped by department e.g. dining, kitchen
for ($h = 0; $h < count($depts); $h++) {
$arr = $depts[$h]['employees']->toArray();
// extract emp on each dept
for ($i = 0; $i < count($arr); $i++) {
$mandtl = Mandtl::where('employeeid', $depts[$h]['employees'][$i]->id)->where('mandayid', $param1)->get()->first();
$depts[$h]['employees'][$i]['manskeddtl'] = count($mandtl) > 0 ? ['daytype' => $mandtl->daytype, 'timestart' => $mandtl->timestart, 'breakstart' => $mandtl->breakstart, 'breakend' => $mandtl->breakend, 'timeend' => $mandtl->timeend, 'workhrs' => $mandtl->workhrs, 'breakhrs' => $mandtl->breakhrs, 'loading' => $mandtl->loading, 'id' => $mandtl->id] : ['daytype' => '0', 'starttime' => 'off', 'id' => ''];
}
}
} else {
return redirect(URL::previous());
}
//return $depts;
return view('branch.manday.edit')->with('depts', $depts)->with('manday', $manday);
}
public function makeViewWeek($request, $year, $weekno)
{
//$this->employees->pushFilters(new ByBranch($request));
//$this->employees->pushFilters(new Regular());
//$this->employees->pushFilters(new Male());
//return $this->employees->all(['code', 'firstname', 'positionid']);
//return $this->employees->paginate('5', ['code', 'firstname', 'positionid']);
$depts = $this->employees->byDepartment($request);
$mansked = Mansked::with('manskeddays')->where('weekno', $weekno)->where('year', $year)->where('branchid', $request->user()->branchid)->first();
//return $mansked;
if (count($mansked) <= 0) {
return redirect('/task/mansked');
}
$days = $mansked->manskeddays;
$manskeddays = [];
for ($h = 0; $h < count($depts); $h++) {
$arr = $depts[$h]['employees']->toArray();
// extract emp on each dept
for ($i = 0; $i < count($arr); $i++) {
for ($j = 0; $j < count($days); $j++) {
$manskeddays[$j]['date'] = $days[$j]->date;
$manskeddays[$j]['id'] = strtolower($days[$j]->id);
$mandtl = Mandtl::where('employeeid', $depts[$h]['employees'][$i]->id)->where('mandayid', $days[$j]->id)->get()->first();
$manskeddays[$j]['mandtl'] = count($mandtl) > 0 ? $mandtl : ['timestart' => 0, 'timeend' => 0, 'loading' => 0];
}
$depts[$h]['employees'][$i]['manskeddays'] = $manskeddays;
}
}
//return $depts;
return view('task.mansked.week2')->with('depts', $depts)->with('mansked', $mansked);
//$manday = Mansked::getManskedday('2015', $weekno);
//$mansked = Mansked::whereWeekno($weekno)->get()->first();
//return view('task.mansked.week')->with('manday', $manday)->with('mansked', $mansked);
}
