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 () {
}
});
get('t/get-week', ['uses' => 'ManskedController@testWeeks']);
get('t/mansked/week/{weekno}', function ($weekno) {
$mansked = App\Models\Manskedhdr::with('manskeddays')->select('id')->where('weekno', $weekno)->get()->first();
return $mansked->manskeddays->keyBy('date');
$manday = new App\Models\Manskedday();
return $manday->where('id', 'B0092A7B666611E596ECDA40B3C0AA12')->get();
});
get('t/manday-dtl', function () {
$manday = new App\Models\Manskedday();
$manday->date = '20015-10-07';
$manday->manskedid = 'A7AECDD2666611E596ECDA40B3C0AA12';
$manday->id = $manday->get_uid();
$manday->save();
$x = new App\Models\Manskeddtl();
$x->daytype = 0;
$x->id = $x->get_uid();
$manday->manskeddtls()->save($x);
return dd($manday);
});
/*************************************************************************************/
/******************** Data Manipulation for Migrations *****************************/
/*************************************************************************************/
get('compcat-expense', function () {
$compcats = App\Models\Compcat::all();
foreach ($compcats as $compcat) {
$expense = App\Models\Expense::where('code', 'LIKE', '%' . $compcat->code . '%')->get()->first();
if (empty($expense)) {
echo 'empty<br>';
} else {
