public static function getManskedday($year, $weekno)
{
$mansked = Manskedhdr::with('manskeddays')->select('id')->where('weekno', $weekno)->where('branchid', Auth::user()->branchid)->get()->first();
$days = isset($mansked) ? $mansked->manskeddays->keyBy('date')->toArray() : [];
$arr_days = [];
for ($day = 0; $day <= 7; $day++) {
if (!$day == 0) {
$currday = date('Y-m-d', strtotime($year . "W" . $weekno . $day));
$arr_days[$day]['date'] = $currday;
$arr_days[$day][0] = $currday;
if (array_key_exists($currday, $days)) {
$arr_days[$day]['created'] = 'true';
$arr_days[$day][1] = 'true';
$x = 2;
foreach ($days[$currday] as $key => $value) {
if ($key == 'date') {
continue;
}
$arr_days[$day][$key] = $value;
$arr_days[$day][$x] = $value;
$x++;
}
} else {
// no data from database
$arr_days[$day]['created'] = 'false';
$arr_days[$day][1] = 'false';
$arr_days[$day][2] = '-';
$arr_days[$day][3] = '-';
$arr_days[$day][4] = '-';
$arr_days[$day][5] = '-';
$arr_days[$day][6] = '-';
$arr_days[$day][7] = 'Create Header';
}
$arr_days[$day][7] = $arr_days[$day][1];
} else {
$arr_days[0]['created'] = '';
$arr_days[0][0] = '<i class="fa fa-calendar"></i> Date';
$arr_days[0][1] = 'created';
$arr_days[0][2] = '';
$arr_days[0][3] = '<span class="glyphicon glyphicon-user"></span> Customers';
$arr_days[0][4] = '<i class="fa fa-line-chart"></i> Ave Spending';
$arr_days[0][5] = '<i class="fa fa-users"></i> Crew on Duty';
$arr_days[0][6] = '';
$arr_days[0][7] = '';
}
}
return $arr_days;
}
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);
}
/**
* Get all the DTR of all employee of a branch on a certain date
*
* @param User $user
* @return Collection
*/
public function byBranchWithMandays(Request $request)
{
$this->manskedhdrs = Mansked::with('manskeddays')->where('branchid', $request->user()->branchid)->orderBy('year', 'DESC')->orderBy('weekno', 'DESC');
return $this->manskedhdrs;
}
