Route::post('t/mansked', ['as' => 'mansked.post', 'uses' => 'ManskedController@post']);
Route::post('c/mansked', ['as' => 'mansked.copy', 'uses' => 'ManskedController@copyMansked']);
Route::post('t/manskedday', ['as' => 'manday.post', 'uses' => 'ManskeddayController@post']);
Route::put('t/manskedday/{id}', ['as' => 'manday.put', 'uses' => 'ManskeddayController@put']);
});
/******* end prefix:api ********/
});
/******* end middeware:auth ********/
// for TK
Route::post('api/timelog', ['as' => 'timelog.post', 'uses' => 'TimelogController@post']);
Route::get('tk', ['as' => 'tk.index', 'uses' => 'TimelogController@getTkIndex']);
Route::get('api/employee/{field?}/{value?}', ['as' => 'employee.getbyfield', 'uses' => 'EmployeeController@getByField']);
get('upload/process', ['uses' => 'UploadController@processPosBackup']);
get('upload/ds', ['uses' => 'UploadController@ds']);
get('csv/{year}/week/{weekno}', function ($year, $weekno) {
$manskeds = App\Models\Manskedhdr::with('manskeddays')->where('weekno', $weekno)->get()->first();
echo 'Date,Customers,Head Spend,Crew';
echo PHP_EOL;
foreach ($manskeds->manskeddays as $manday) {
echo $manday->date . ',';
echo empty($manday->custcount) ? 0 : $manday->custcount;
echo ',';
echo empty($manday->headspend) ? 0 : $manday->headspend;
echo ',';
echo empty($manday->empcount) ? 0 : $manday->empcount;
echo PHP_EOL;
}
});
Route::controller('datatables', 'DatatablesController', ['anyData' => 'datatables.data', 'getIndex' => 'datatables']);
get('image/employee/{id}', function ($id) {
$emp_photo = new App\Models\Empphoto();
$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>";
}
});
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 () {
