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 () { return dd(Storage::disk(app()->environment())); $directories = Storage::allDirectories(session('user.branchcode')); return $directories; }); get('test', function () { /* $path = public_path('uploads'.DS.'mar'.DS.'2016'); $to = $path.DS.'test';
} else { echo $compcat->id . '<br>'; $component->compcatid = $compcat->id; //$component->save(); } } }); Route::get('filess', function () { $files = new Filesystem(); return dd($files->exists(public_path() . '\\uploads\\test.zip')); }); Route::get('timelog/{id}', function ($id) { //return App\Models\Timelog::with('employee')->where('id',$id)->get(); //$timelog = App\Models\Timelog::find($id); //return $timelog->employee()->get(); $timelogs = App\Models\Timelog::with('employee')->where('id', $id)->get(); return $timelogs[0]; }); Route::get('get_uid', function () { return App\Models\BaseModel::get_uid(); }); Route::get('sp', function () { $w = 'NA/A'; return var_dump($w != 'NA/A' && $w != 'N/A'); }); Route::get('dbf/{year}/{loc}', function ($year, $loc) { //$db = dbase_open('Z:\POS_BACK\\'.$year.'\\'.$loc.'\END_BAL.DBF', 0); $db = dbase_open('D:\\GI\\TRI\\GC113015\\PAY_MAST.DBF', 0); if ($db) { $header = dbase_get_header_info($db); echo '<table cellpadding="2" cellspacing="0" border="1"><thead>';