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 () {