//Route::get('/movies', function () { //$Movies = \App\Movie::where('title','=','shuga')->get(); //$Movies = \App\movie::where('rating','>'2)->get(); //select * from movies where rating > 2 //return $movies; //$movie= new \App\Movie(); //$Movie->title='Akirachix'; //$movie->genre='awesome'; //$movie->rating=5; //$movie->save(); // $movie= \App\Movie::find(5); // $movie->genre='Horror'; // $movie->rating=4; // $movie->save(); // return $movie; //return \App\Movie::all(); Route::get('/students', function () { //$Students = \App\Students::where('lastname','=','Maich')->get(); //return $Students; $students = new \App\Students(); $students->id = '6'; $students->firstname = 'Cate'; $students->lastname = 'Mwai'; $students->save(); // $movie= \App\Movie::find(5); // $movie->genre='Horror'; // $movie->rating=4; // $movie->save(); // return $movie; return \App\Students::all(); Route::get('/movies', 'studentsController@index'); });
//for exam schedule $users = Input::get('option'); //return $users; $items = App\Subject::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $users)->lists('subject_name', 'id'); return Response::make($items); }); Route::get('api/dropdown/section', function () { $user = Input::get('option'); //return $user; $items = App\Section::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $user)->lists('section_name', 'section_id'); return Response::make($items); }); Route::get('api/dropdown/invoice', function () { $user = Input::get('option'); //return $user; $items = App\Students::where('institute_code', '=', Auth::user()->institute_id)->where('class', '=', $user)->lists('name', 'st_id'); return Response::make($items); }); Route::get('api/dropdown/invoice/section', function () { $user = Input::get('option'); //return $user; $items = App\Section::where('institute_code', '=', Auth::user()->institute_id)->where('class_id', '=', $user)->lists('section_name', 'section_id'); return Response::make($items); }); //class info add Route::get('Addclass', 'InstituteController@getaddclass'); Route::post('Addclass', 'InstituteController@postaddclass'); Route::get('class/edit/{clid}', 'InstituteController@geteditclass'); Route::post('class/edit/{clid}', 'InstituteController@postupdateclass'); Route::get('class/delete/{clid}', 'InstituteController@deleteclass'); //Class section Add