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