Пример #1
0
Route::get('import-dbf', ['uses' => 'EmployeeController@importDBF']);
Route::post('postfile', ['as' => 'upload.postfile', 'uses' => 'UploadController@postfile']);
Route::get('login', ['as' => 'auth.getlogin', 'uses' => 'Auth\\AuthController@getLogin']);
Route::post('login', ['as' => 'auth.postlogin', 'uses' => 'Auth\\AuthController@postLogin']);
Route::get('logout', ['as' => 'auth.getlogout', 'uses' => 'Auth\\AuthController@getLogout']);
/*************************************************************************************/
/************************* Testing Url for Devs **************************************/
/*************************************************************************************/
get('t/employees', function () {
    return App\Models\Employee::with(['branch' => function ($query) {
        $query->select('code', 'descriptor', 'id');
        //dd($query);
    }])->get();
});
get('t/employee/branch/{id}', function ($id) {
    return App\Models\Employee::branchid($id)->with(['branch' => function ($query) {
        $query->select('code', 'descriptor', 'id');
    }])->get();
});
get('employee/{id}', function ($id) {
    //return App\Models\Timelog::with('employee')->where('id',$id)->get();
    //$timelog = App\Models\Timelog::find($id);
    //return $timelog->employee()->get();
    $employee = App\Models\Employee::with('branch')->where('id', $id)->get()->first();
    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');