public function getTkIndex(Request $request) { if (isset($_SERVER['HTTP_X_FORWARDED_FOR']) && $_SERVER['HTTP_X_FORWARDED_FOR'] === '127.0.0.1') { $timelogs = Timelog::with('employee.branch')->orderBy('datetime', 'DESC')->take(20)->get(); } else { $timelogs = Timelog::with(['employee' => function ($query) { $query->with(['branch' => function ($query) { $query->select('code', 'descriptor', 'id'); }, 'position' => function ($query) { $query->select('code', 'descriptor', 'id'); }])->select('code', 'lastname', 'firstname', 'branchid', 'positionid', 'id'); }])->select('timelog.*')->join('hr.employee', function ($join) { $join->on('timelog.employeeid', '=', 'employee.id')->where('employee.branchid', '=', $this->_branchid); })->orderBy('datetime', 'DESC')->take(20)->get(); } //return $timelogs; //if(count($timelogs) <= 0) // return redirect()->route('auth.getlogin'); $response = new Response(view('tk.index', compact('timelogs'))); //->with('timelogs', $timelogs)); $response->withCookie(cookie('branchid', $this->_branchid, 45000)); $response->withCookie(cookie('code', session('user.branchcode'), 45000)); return $response; //return view('tk.index', compact($timelogs));//->with('timelogs', $timelogs); }
public function getIndex() { $timelogs = Timelog::with('employee.branch')->orderBy('datetime', 'DESC')->get(); return view('tk.index')->with('timelogs', $timelogs); }