get('flush-sessions', function () { Session::flush(); return redirect('sessions'); }); get('test-event', ['uses' => 'UploadController@test']); get('manday-count', function () { //$manday = App\Models\Manskedday::with('countMandtls')->where('date', '2015-11-13')->first(); $manday = App\Models\Manskedday::with('countMandtls')->where('date', '2015-11-13')->first(); return $manday; }); get('folder/{f}', function ($f) { $f = '.'; return '/' . trim(str_replace('..', '', $f), '/'); }); get('mandtl-scope/{employeeid}/{date}', function ($employeeid, $date) { $branch = App\Models\Manskeddtl::with('employee')->whereEmployeeid($employeeid)->date($date)->get(); //$branch = App\Models\Manskeddtl::whereEmployeeid($employeeid)->first()->manskedday()->where('date', '2015-11-13')->first(); return $branch; }); get('timelogs/{employeeid}/{date}', function ($employeeid, $date) { //$timelogs = App\Models\Timelog::employeeid($employeeid)->date($date)->get(); //$branch = App\Models\Manskeddtl::whereEmployeeid($employeeid)->first()->manskedday()->where('date', '2015-11-13')->first(); $date = Carbon\Carbon::parse($date); $timelogs = App\Models\Timelog::employeeid($employeeid)->whereBetween('datetime', [$date, $date->copy()->addDay()->format('Y-m-d') . ' 06:00:00'])->orderBy('txncode', 'ASC')->orderBy('datetime', 'ASC')->get(); return $timelogs; }); get('holidate/{date}', function ($date) { $h = App\Models\Holidate::with('holiday.holidaydtls')->date($date)->first(); return $h; }); get('files', function () {