PHP User::whereIn方法代码示例

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy(Project $project, User $user)
 {
     $admin = JWTAuth::parseToken()->authenticate();
     $audience = User::whereIn('id', explode(',', $request->get('audience')))->get();
     $this->dispatch(new RemoveUserFromProject($admin, $project, $user, $audience));
     return response()->json(['success' => true, 'message' => 'User Left Project.']);
 }

 public function index()
 {
     $classes = StudyClass::all();
     $teacher_ids = array();
     $assist_ids = array();
     foreach ($classes as $class) {
         if ($class->teach != null) {
             $teacher_ids[] = $class->teach->id;
         }
         if ($class->assist != null) {
             $assist_ids[] = $class->assist->id;
         }
     }
     $teachers = User::whereIn('id', $teacher_ids)->get();
     foreach ($teachers as &$teacher) {
         $class_ids = array();
         foreach ($teacher->teach as $t) {
             $class_ids[] = $t->id;
         }
         $teacher->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->count();
         $teacher->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_teacher', '>', -1)->avg('rating_teacher');
     }
     $assistants = User::whereIn('id', $assist_ids)->get();
     foreach ($assistants as &$assistant) {
         $class_ids = array();
         foreach ($assistant->assist as $t) {
             $class_ids[] = $t->id;
         }
         $assistant->rating_number = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->count();
         $assistant->rating_avg = Register::whereIn('class_id', $class_ids)->where('rating_ta', '>', -1)->avg('rating_ta');
     }
     $this->data['teachers'] = $teachers;
     $this->data['assistants'] = $assistants;
     return view('manage.personal_rating.all', $this->data);
 }

 /**
  * Store a newly created resource in storage.
  *
  * @return Response
  */
 public function store(Project $project, Request $request)
 {
     $user = JWTAuth::parseToken()->authenticate();
     $audience = User::whereIn('id', explode(',', $request->get('audience')))->get();
     $forum = $this->dispatch(new PostForum($user, $project, $request->all(), $audience));
     return response()->json(['success' => true, 'message' => 'Forum Posted.', 'forum' => $forum]);
 }

 public function refresh()
 {
     if (!\Session::get('user')->is_admin()) {
         abort(401);
     }
     $group_id = config('gapper.group_id');
     $members = Client::getMembers($group_id);
     if (count($members)) {
         $deleted_users = User::all()->lists('gapper_id', 'id')->toArray();
         foreach ($members as $member) {
             $id = $member['id'];
             $user = User::where('gapper_id', $id)->first();
             if (!$user) {
                 $user = new \App\User();
                 $user->gapper_id = $member['id'];
                 $user->name = $member['name'];
                 $user->icon = $member['icon'];
             } else {
                 $user->name = $member['name'];
                 $user->icon = $member['icon'];
                 //从 deleted_users 中删除当前 gapper_id 对应的用户
                 //最后剩下的, 就是 User 中不包含 gapper_id 的用户
                 if (array_key_exists($member['id'], $deleted_users)) {
                     unset($deleted_users[$id]);
                 }
             }
             $user->save();
         }
         //发现有需要删除的 User
         if (count($deleted_users)) {
             $to_deleted_users = User::whereIn('id', array_values($deleted_users))->delete();
         }
     }
     return redirect()->to('users')->with('message_content', '同步成功!')->with('message_type', 'info');
 }

 public function postGroupList(Request $request)
 {
     //新增职务
     if ($request->has('new_cp_group_name')) {
         $new_cp_group_name = $request->input('new_cp_group_name');
         if (in_array($new_cp_group_name, array('系统管理员', '超级管理员')) || AdminGroup::where('cp_group_name', '=', $new_cp_group_name)->first()) {
             return redirect($this->redirectPath('/user/groups'))->withErrors([Lang::get('access.addNewCpGroupFailed')]);
         }
         $adminGroup = new AdminGroup();
         $adminGroup->cp_group_name = strip_tags($new_cp_group_name);
         $adminGroup->save();
     }
     //更新职务
     if ($request->has('name')) {
         foreach ($request->input('name') as $cp_group_id => $cp_group_name) {
             $adminGroup = AdminGroup::find($cp_group_id);
             $adminGroup->cp_group_name = $cp_group_name;
             $adminGroup->save();
         }
     }
     //删除职务
     if ($request->has('delete')) {
         AdminAccess::destroy($request->input('delete'));
         User::whereIn('cp_group_id', $request->input('delete'))->delete();
         AdminGroup::destroy($request->input('delete'));
     }
     return redirect($this->redirectPath('/user/groups'))->with($this->statusVar, Lang::get('access.updateCpGroupSuccess'));
 }

 /**
  * Execute the job.
  *
  * @return void
  */
 public function handle(Mailer $mail)
 {
     $group = $this->ticket->group_id;
     $customers = Group::where('id', $group)->first()->customers()->get();
     $_customers = [];
     foreach ($customers as $customer) {
         $_customers[] = $customer->id;
     }
     $sys_name = Settings::where('name', 'sys_name')->first();
     $user = User::whereIn('customer_id', $_customers)->get();
     foreach ($user as $_user) {
         $mail->send('emails.updateticket', ['user' => $_user, 'ticket' => $this->ticket, 'response' => $this->response, 'sys_name' => $sys_name], function ($m) use($_user) {
             $m->to($_user->email, $_user->first_name . ' ' . $_user->last_name)->subject('Ticket updated - ' . $this->ticket->track_id . ' [' . $this->ticket->status->name . ']');
             if (count($this->response->attachments()->get()) > 0) {
                 foreach ($this->response->attachments as $attachment) {
                     $m->attach(storage_path() . '/attachments/' . $this->ticket->id . '/' . $attachment->name);
                 }
             }
         });
     }
     // Cleanup variables
     unset($this->ticket);
     unset($this->response);
     unset($group);
     unset($customers);
     unset($user);
     unset($sys_name);
     unset($_customers);
 }

 public static function notify($idArr = array(), $body, $type, $to_all = 0, $is_system = 0)
 {
     $currentId = auth()->id();
     if (!$currentId) {
         return;
     }
     $data = $notifiedUidArr = [];
     $now = \Carbon\Carbon::now();
     if ($to_all) {
         $data = ['user_id' => 0, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now];
     } elseif (!empty($idArr)) {
         $idArr = array_unique($idArr);
         foreach ($idArr as $id) {
             if ($id == $currentId) {
                 return;
             }
             $data[] = ['user_id' => $id, 'body' => $body, 'type' => $type, 'to_all' => $to_all, 'is_system' => $is_system, 'created_at' => $now, 'updated_at' => $now];
             $notifiedUidArr[] = $id;
         }
     }
     if (!empty($data)) {
         Notify::insert($data);
         if ($to_all) {
             \DB::table('users')->increment('notice_count');
         } elseif ($notifiedUidArr) {
             User::whereIn('id', $notifiedUidArr)->increment('notice_count');
         }
     }
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $projectdetails = ['name' => 'shitzu', 'description' => 'frickzena oah auhsdoh vgos'];
     $taskdetails = ['name' => 'joozie', 'description' => 'ahioihd poaiy7u ascihogyfcd pouaou'];
     $taskdetails2 = ['name' => 'ambroze', 'description' => 'shitzu prickzen la frickzen'];
     $statusdetails = ['message' => 'hello wazzup?'];
     DB::table('projects')->delete();
     DB::table('users_projects')->delete();
     DB::table('stories')->delete();
     DB::table('sprints')->delete();
     DB::table('backlogs')->delete();
     // optional
     DB::table('comments')->delete();
     DB::table('statuses')->delete();
     $user1 = User::firstOrFail();
     $user2 = User::all()->last();
     $project = Bus::dispatch(new CreateProject($user1, $projectdetails));
     Bus::dispatch(new AddUserToProject($user1, $project, $user2, 'developer'));
     $users = User::whereIn('id', [$user1->id, $user2->id])->get();
     $backlog = App\Backlog::create(['name' => 'Release Elixir']);
     $user1->backlogs()->save($backlog);
     $project->backlogs()->save($backlog);
     $sprint = App\Sprint::create(['name' => 'Sprint Shikku']);
     $project->sprints()->save($sprint);
     $backlog->sprints()->save($sprint);
     $user1->sprints()->save($sprint);
     $datas = [['name' => 'Refactoring Iceblocks', 'description' => 'Cool tasks are always cool. So do this !!', 'priority' => 1, 'work_hours' => '7'], ['name' => 'Streaming section', 'description' => 'This is one of the besttask ever i ve seen in my life time => )', 'priority' => 0, 'work_hours' => '2'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Smooth UI Design', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 2, 'work_hours' => '4'], ['name' => 'Refactoring Iceblocks', 'description' => 'Major refactor needed in the sublimentory section of zylanfuzku Masked version.Its all about the stuffs and stone of the rechard steven.', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Smooth UI Design', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 2, 'work_hours' => '4'], ['name' => 'Refactoring Iceblocks', 'description' => 'Major refactor needed in the sublimentory section of zylanfuzku Masked version.Its all about the stuffs and stone of the rechard steven.', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Urgent Completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '8'], ['name' => 'Elangent Model shift', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 2, 'work_hours' => '5'], ['name' => 'Bug trakking system', 'description' => 'This task is for powerful people.. Yeah you..! ', 'priority' => 1, 'work_hours' => '2'], ['name' => 'Featured blog completion', 'description' => 'This is a urgent task . U should make the system flow for ever', 'priority' => 3, 'work_hours' => '6'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2'], ['name' => 'Quick finish', 'description' => 'Super awesome task you will love it i know it, can you just finish this.. ? sothat we can move On..', 'priority' => 0, 'work_hours' => '7'], ['name' => 'Trapped module refactoring', 'description' => 'Super awesome task you will love it i know ...!!', 'priority' => 3, 'work_hours' => '2']];
     foreach ($datas as $data) {
         $story = App\Story::create($data);
         $project->stories()->save($story);
         $user1->createdStories()->save($story);
     }
 }

 public function parse($body)
 {
     $this->body_original = $body;
     $this->usernames = $this->getMentionedUsername();
     count($this->usernames) > 0 && ($this->users = User::whereIn('name', $this->usernames)->get());
     $this->replace();
     return $this->body_parsed;
 }

 public static function dependentsOkay($dependentIDList)
 {
     $accountID = Auth::user()->id;
     $matchCount = User::whereIn('id', $dependentIDList)->where(function ($query) use($accountID) {
         $query->where('accountId', '=', $accountID)->where('approved', '<>', 'false');
     })->count();
     return $matchCount == sizeof($dependentIDList);
 }

 public static function getUsersString($id)
 {
     $result = "";
     $_users = ConversationUser::where(['conversation_id' => $id])->get(['user_id']);
     $users = User::whereIn('id', $_users)->get();
     foreach ($users as $user) {
         if ($user->id != Auth::id()) {
             $result = $result . $user->name . " " . $user->surname . ", ";
         }
     }
     return rtrim($result, ", ");
 }

 /**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index()
 {
     $images = Picture::where('user_id', '=', Auth::user()->id)->where('isDish', '=', false)->orderBy('id', 'desc')->take(5)->get();
     $profile = User::find(Auth::user()->id);
     $favoriteDish = explode(';', $profile->favoriteDish);
     $time = explode("-", $profile->dateOfBirth);
     $dt = Carbon::createFromDate($time[0], $time[1], $time[2], 'Europe/Brussels');
     $now = Carbon::today();
     $age = $now->diffInYears($dt);
     $profile->age = $age;
     foreach ($favoriteDish as $key => $value) {
         if ($value == "") {
             unset($favoriteDish[$key]);
         }
     }
     $profile->favoriteDishArray = $favoriteDish;
     $friends = User::where('id', '=', Auth::user()->id)->first()->friends()->get();
     $friendRequests = Friend::where('friend_id', '=', Auth::user()->id)->where('accepted', '=', false)->get();
     $mayLike = array();
     foreach ($profile->tastes as $taste) {
         $othersTaste = $taste->users()->where('user_id', '<>', Auth::user()->id)->where('taste_id', $taste->id)->get();
         foreach ($othersTaste as $user) {
             $mayLike[] = $user->id;
         }
     }
     //count how many times an id apears in array
     $CountMayLikes = array_count_values($mayLike);
     //sort from high to low
     arsort($CountMayLikes);
     //var_dump($CountMayLikes);
     $sortedArray = [];
     foreach ($CountMayLikes as $id => $value) {
         $sortedArray[] = $id;
     }
     //var_dump($sortedArray);
     //give te first 10z
     $pYML = array_slice($sortedArray, 0, 10);
     $people = User::whereIn('id', $pYML)->select('id', 'name', 'surname', 'country', 'city', 'dateOfBirth')->get();
     foreach ($people as $person) {
         // var_dump($person->id);
         $picture_url = Picture::where('user_id', $person->id)->select('picture_url')->first();
         // echo '<pre>';
         // var_dump($picture_url['picture_url']);
         $person->picture_url = $picture_url['picture_url'];
     }
     $smaken = Taste::select('id', 'tastes')->get();
     $tasts = array();
     foreach ($smaken as $smaak) {
         $tasts[$smaak->id] = $smaak->tastes;
     }
     $data = ['profile' => $profile, 'friends' => $friends, 'friendRequests' => $friendRequests, 'images' => $images, 'tasts' => $tasts, 'peoples' => $people];
     return View('dashboard')->with($data);
 }

 public function index(Request $request)
 {
     // 获取排序条件
     $orderColumn = $request->get('sort_up', $request->get('sort_down', 'created_at'));
     $direction = $request->get('sort_up') ? 'asc' : 'desc';
     $members = User::whereIn('level', ['003', '002'])->whereHas('roles', function ($query) {
         $query->where('slug', 'member');
     })->orderBy($orderColumn, $direction)->paginate(8);
     $nonMembers = User::where('level', '001')->whereHas('roles', function ($query) {
         $query->where('slug', 'member');
     })->orderBy($orderColumn, $direction)->paginate(8);
     return view('admin.user.list', compact('members', 'nonMembers', 'query'));
 }

 function getTask()
 {
     $user = \Auth::user();
     $events = Event::all();
     $event = Event::latest('id')->first();
     $tasks = Task::all();
     $categories = array('Pending', 'In-progress', 'Delayed', 'Finished');
     //Array of head->id of user
     $heads_comm = Head::where('event_id', $event->id)->where('user_id', $user->id)->get(array('comm_id'))->toArray();
     //members of committee
     $mem = Member::whereIn('comm_id', $heads_comm)->get(array('user_id'))->toArray();
     $members = User::whereIn('id', $mem)->get();
     //committees where user is head
     $committees = Committee::whereIn('id', $heads_comm)->get();
     return view('pages/task', compact('user', 'members', 'events', 'event', 'committees', 'tasks', 'categories'));
 }

 public function addMember(AddMemberToProjectRequest $request)
 {
     $owner = Auth::user();
     $users_id = $request->users;
     // 傳進來的資料再做一次搜尋，確定傳進來的資料在資料庫都存在
     $users = User::whereIn('id', $users_id)->get();
     $projectId = $request->project_id;
     $project = $owner->projects()->find($projectId);
     $relationshipData = [];
     foreach ($users as $user) {
         $relationshipData[] = $user->id;
     }
     // 為project加入關聯
     $project->users()->attach($relationshipData, ['role' => $request->role]);
     return $project->users()->whereIn('id', $users_id)->get();
 }