/**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index($id)
 {
     $site = Site::find($id);
     $zones = Zone::all();
     $data = array('page' => 'sites', 'tab' => 'manage', 'site' => $site, 'zones' => $zones);
     return View::make('site_zone.index', $data);
 }
 public function zones()
 {
     $zones = Zone::all()->toJson();
     return $zones;
     // Response::json($zones);
 }
 public function updatePermissions()
 {
     $user = User::find(Input::get('rfid'));
     $sites = Site::all();
     foreach ($sites as $key => $value) {
         $selected_site = Input::get('selected_site_' . $value->id);
         if ($selected_site) {
             $site = Site::find($selected_site);
             if ($site->GivesAccessToUser($user->rfid) == 'Denied') {
                 DB::table('site_user')->insert(array('site_id' => $value->id, 'user_id' => $user->rfid));
             } else {
                 DB::table('site_user')->where('user_id', '=', $user->rfid)->where('site_id', '=', $value->id)->delete();
             }
         }
     }
     $zones = Zone::all();
     foreach ($zones as $key => $value) {
         $selected_zone = Input::get('selected_zone_' . $value->id);
         if ($selected_zone) {
             if ($value->GivesAccessToUser($user->rfid) == 'Denied') {
                 DB::table('user_zone')->insert(array('zone_id' => $value->id, 'user_id' => $user->rfid));
                 foreach ($sites as $site) {
                     if ($value->ContainsSite($site->id)) {
                         DB::table('site_user')->insert(array('site_id' => $site->id, 'user_id' => $user->rfid));
                     }
                 }
             } else {
                 DB::table('user_zone')->where('user_id', '=', $user->rfid)->where('zone_id', '=', $value->id)->delete();
                 foreach ($sites as $site) {
                     if ($value->ContainsSite($site->id)) {
                         DB::table('site_user')->where('user_id', '=', $user->rfid)->where('site_id', '=', $site->id)->delete();
                     }
                 }
             }
         }
     }
     return Redirect::to('user/' . $user->id);
 }