return $employee->previous();
});
get('t/maskedhdr/{id}', function ($id) {
return App\Models\Manskedhdr::with(['branch' => function ($query) {
$query->select('code', 'addr1', 'id');
}, 'manager' => function ($query) {
$query->select('code', 'lastname', 'firstname', 'id');
}, 'manskeddays.manskeddtls'])->where('id', $id)->get();
});
get('t/religion/{id}', function ($id) {
$religion = App\Models\Religion::find($id);
return dd($religion);
});
get('t/week', function () {
//echo date("W", mktime(0,0,0,12,28,2015));
$weeks = App\Models\Manskedhdr::select('weekno')->where(DB::raw('YEAR(date)'), '=', '2015')->get();
$w = $weeks->pluck('weekno')->toArray();
// array of week
for ($week_ctr = 1; $week_ctr <= date("W", mktime(0, 0, 0, 12, 28, 2015)); $week_ctr++) {
$s = in_array($week_ctr, $w) ? 'yes' : 'no';
$mon_no = date('F n', strtotime('1 Jan +' . $week_ctr . ' weeks'));
echo $mon_no . ' = ' . $week_ctr . ' = ' . $s . '<br>';
}
});
get('t/list-week', function () {
$lastday = new App\Models\Manskedhdr();
return dd($lastday->getDaysByWeekNo('01', '2016'));
$week_number = '01';
$year = '2015';
for ($day = 1; $day <= 7; $day++) {
echo date('m/d/Y', strtotime($year . "W" . $week_number . $day)) . "<br>";
