PHP Event::whereIn方法代码示例

 /**
  * Display a listing of my going events.
  *
  * @return Response
  */
 public function goingEvents()
 {
     $events = Event::whereIn('id', function ($query) {
         $query->select('event_id')->from('event_user')->where('user_id', \Auth::id());
     })->where('date_start', '>=', new \DateTime('today'))->orderBy('date_start')->select(array('id', 'name'))->paginate();
     $tittle = 'Going';
     return view('events', compact('events', 'tittle'));
 }

 public function registeredevents()
 {
     $user = Auth::user();
     $eventid = Register::where('userid', $user->id)->lists('eventid');
     $events = Event::whereIn('id', $eventid)->get();
     $festid = Event::whereIn('id', $events->toArray())->lists('festid');
     $fests = Fest::whereIn('id', $festid);
     return view('user.regevents', ['user' => Auth::user(), 'fests' => $fests, 'events' => $events]);
 }

 /**
  * Execute the job.
  *
  * @return void
  */
 public function handle()
 {
     if ($this->user->unsubscribed_email != "no") {
         $soc_ids = DB::table('subscriptions')->where('user_id', $this->user->id)->lists('society_id');
         // All Events, in user subscribed society, next week.
         $events = Event::whereIn('society_id', $soc_ids)->where('time', '>', date('Y-m-d H:i:s'))->where('time', '<', date('Y-m-d H:i:s', time() + 604800));
         $allEvents = $this->events->toArray();
         if (count($allEvents)) {
             $random_event = $allEvents[array_rand($allEvents, 1)];
             $data = ['user' => $this->user, 'events' => $events, 'random_event' => $random_event];
             Mail::send('emails.weekly', $data, function ($message) {
                 $message->from('lowdown@netsoc.co', 'Lowdown');
                 $message->subject('Your Weekly Society Lowdown');
                 $message->to($this->user->email);
             });
         }
     }
 }

 private function manageableRolesForUser()
 {
     $roles = $this->roleResultToList(Role::with('perms')->get());
     if (Entrust::can(PermissionNames::ManageGlobalPermissions())) {
         return $roles;
     }
     //Filter out global permissions
     $roles = array_filter($roles, function ($r) {
         $globalPerms = PermissionNames::AllGlobalPermissions();
         foreach ($r->perms as $p) {
             if (in_array($p->name, $globalPerms)) {
                 return false;
             }
         }
         return true;
     });
     $confPermNamePart = PermissionNames::normalizePermissionName(PermissionNames::ConferencePermissionManagement(1));
     $evtPermNamePart = PermissionNames::normalizePermissionName(PermissionNames::EventPermissionManagement(1));
     //Get the permissions this user has which are permissions management
     //permissions
     $currentPermManagement = Permission::whereHas("roles", function ($query) {
         $query->whereHas("users", function ($query) {
             //on Account table
             $query->where("id", Auth::user()->id);
         });
     })->where(function ($query) use($confPermNamePart, $evtPermNamePart) {
         $query->where('name', 'like', $confPermNamePart . '%');
         $query->orWhere('name', 'like', $evtPermNamePart . '%');
     })->get();
     $conferences = [];
     $events = [];
     foreach ($currentPermManagement as $perm) {
         if (PermissionNames::isConferencePermission($perm->name)) {
             $conferences[] = PermissionNames::extractPermissionData($perm->name)->idPart;
         } else {
             $events[] = PermissionNames::extractPermissionData($perm->name)->idPart;
         }
     }
     $ownedEvents = Event::whereIn('conferenceID', $conferences)->select('id')->get();
     $ownedEvents = array_map(function ($e) {
         return $e['id'];
     }, $ownedEvents->toArray());
     $events = array_merge($events, $ownedEvents);
     //Filter out permissions not associated with the conferences/events
     //this user can control.
     $roles = array_filter($roles, function ($r) use($events, $conferences) {
         foreach ($r->perms as $p) {
             if (PermissionNames::isConferencePermission($p->name)) {
                 $confId = PermissionNames::extractPermissionData($p->name)->idPart;
                 if (!in_array($confId, $conferences)) {
                     return false;
                 }
             } else {
                 if (PermissionNames::isEventPermission($p->name)) {
                     $evtId = PermissionNames::extractPermissionData($p->name)->idPart;
                     if (!in_array($evtId, $events)) {
                         return false;
                     }
                 }
             }
             return true;
         }
     });
     return $roles;
 }

 private function dopublish(Request $request, $value)
 {
     $event = Event::whereIn('id', $request->ids)->update(array('is_published' => $value));
     $response = ['model_type' => 'Event', 'ids' => $request->ids, 'action_type' => $value == 1 ? "Publish" : "Unpublish"];
     return json_encode($response);
 }