Example #1
0
 public function getGearmaintenececommon()
 {
     $query = "SELECT id, code from nfr_station_master";
     $data = DB::select(DB::raw($query));
     $result['stations'] = $data;
     $result['gear_type'] = GearType::all();
     $query = "SELECT DISTINCT(designation) as name from nfr_supervisors order by order_id asc";
     $data = DB::select(DB::raw($query));
     $result['designation'] = $data;
     $query = "SELECT * from nfr_supervisors order by order_id asc";
     $data = DB::select(DB::raw($query));
     $result['supervisor'] = $data;
     return Response::json($result);
 }
Example #2
0
 public function getAllgearcode()
 {
     $gears = GearType::all();
     return Response::json($gears);
 }