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; }