PHP Activity::find方法代码示例

 public function performIntuitiveAssignment()
 {
     //Grab all the activities
     $activities = Activity::all();
     //pr0duce a tally 0f h0w many succesful applicati0ns each activity has received,
     //in the f0rm 0f an ass0ciative array f0r th0se activities which have received
     //m0re than 0 applicati0ns
     $activityApplicationTally = array();
     foreach ($activities as $activity) {
         //get a c0unt 0f the number 0f succesful applicants f0r this activity
         $numSuccesfulApplicants = $activity->getSuccessfulApplications->count();
         if ($numSuccesfulApplicants > 0) {
             $activityApplicationTally[$activity->id] = $numSuccesfulApplicants;
         }
     }
     //fr0m http://www.w3schools.com/php/func_array_asort.asp
     asort($activityApplicationTally, SORT_NUMERIC);
     foreach ($activityApplicationTally as $activityID => $numSuccesfulApplicants) {
         $numTutorsRequired = Activity::find($activityID)->quant_ppl_needed;
         echo $numTutorsRequired;
         //var_dump($activity);
     }
     //return $activityApplicationTally;
     //return Activity::with('activityRequests');
 }

 public function update($id, Request $request)
 {
     if ($this->inputIsValid($request)) {
         $agenda = Agenda::findOrFail($id);
         $agenda->update($request->except('attendees', 'activities'));
         // Remove all old attendees.
         $agenda->users()->detach();
         // Add attendees to agenda_user table as many-to-many relationship.
         foreach ($request->input('attendees') as $attendeeId) {
             $agenda->users()->attach(1, ['agenda_id' => $agenda->id, 'user_id' => $attendeeId]);
         }
         // Remove this agenda_id from all its activities.
         foreach ($agenda->activities() as $activity) {
             $activity = Activity::find($activityId);
             $activity->agenda_id = 0;
             $activity->save();
         }
         // Add agenda_id to a_activities table.
         foreach ($request->input('activities') as $activityId) {
             $activity = Activity::find($activityId);
             $activity->agenda_id = $agenda->id;
             $activity->save();
         }
         return response()->json(['header' => 'Your agenda was successfully updated!', 'info' => 'Both your agenda here on Meeter and you Google
               Calendar event were updated with your changes.'], 200);
     } else {
         return response()->json('', 400);
     }
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $item = Activity::find($id);
     $item->status = 'deleted';
     $item->save();
     Log::create(array("user_id" => Auth::user()->id, "action" => "Delete Activities named " . $item->name));
 }

 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Requests\SpacificationEditRequesyt $request, $id)
 {
     $especificacion = Spacification::find($id);
     $especificacion->fill($request->all());
     $especificacion->save();
     $actividad = Activity::find($especificacion->activity_id);
     return response()->json(['valid', $especificacion, $actividad]);
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Requests\Prospect $request)
 {
     $activity = Activity::find($request->get('activity_id'));
     $prospect = new Prospect($request->all());
     $activity->prospects()->save($prospect);
     if ($request->has('links')) {
         foreach ($request->get('links') as $link) {
             $type = LinkType::findOrFail($link['type_id']);
             $link = new Link(['url' => $link['url']]);
             $link->prospect()->associate($prospect);
             $link->type()->associate($type);
             $link->save();
         }
     }
     return response()->json($prospect);
 }

 public function performIntuitiveAssignment()
 {
     $activities = Activity::all();
     //create an ass0ciative array representing the am0unt 0f succesful applicatins
     //there has been f0r each supp0rt activity, where the key is the activity's primary key
     //in the database, and the value is the number 0f succesful applicati0ns.
     $activityApplicationTally = array();
     foreach ($activities as $activity) {
         //c0unt the number 0f succesful applicati0ns f0r the activity
         $numSuccesfulApplicants = $activity->getSuccessfulApplications->count();
         //it is imp0ssible t0 intuitively assign phd students t0 the activity
         //if the activity has had n0 succesful applicants, theref0re 0nly activities
         //which have at least 1 succesful applicati0n will be added t0 the ass0ciative array
         if ($numSuccesfulApplicants > 0) {
             $activityApplicationTally[$activity->id] = $numSuccesfulApplicants;
         }
     }
     //fr0m http://www.w3schools.com/php/func_array_asort.asp
     //s0rt the ass0ciative array s0 that the activities with the fewest number 0f sucessful
     //applicants will be pr0cessed first.
     asort($activityApplicationTally, SORT_NUMERIC);
     //pr0cess the activties in the assci0ative array 1 by 1.
     $assignmentsMade = array();
     //Ass0ciative array where key is the PHD student's ID in the database and
     //the value is the id 0f the activity t0 which they were assigned
     foreach ($activityApplicationTally as $activityID => $numSuccesfulApplicants) {
         $numTutorsRequired = Activity::find($activityID)->quant_ppl_needed;
         if ($numSuccesfulApplicants == $numTutorsRequired) {
             $activity = Activity::find($activityID);
             $successfulApplications = $activity->getSuccessfulApplications;
             //assign the succesful applicants t0 all sessi0ns f0r the activity
             foreach ($successfulApplications as $successfulApplication) {
                 $phdStudent = User::find($successfulApplication->user_id);
                 //line bel0w fr0m here https://laravel.com/docs/master/collections#method-pluck, why d0es this w0rk?
                 $phdStudentSessions = $phdStudent->sessions()->attach($activity->sessions->pluck('id')->all());
                 $assignmentsMade[$phdStudent->name] = $activity->title;
             }
         }
     }
     //foreach($assignments as $assignment) {
     //var_dump($assignment);
     //}
     return view('intuitiveAssignmentResults')->with('assignmentsMade', $assignmentsMade);
     //var_dump( $assignments);
     //var_dump($phdStudentSessions);
     //return  $phdStudentSessions;
 }

 public function showActivityEventPlannerView()
 {
     $activitiesIds = session('activities');
     $activities = [];
     foreach ($activitiesIds as $id) {
         array_push($activities, Activity::find($id));
     }
     $eventPatternIds = session('eventPatterns');
     $eventPatterns = [];
     foreach ($eventPatternIds as $id) {
         array_push($eventPatterns, EventPattern::find($id));
     }
     $groupId = session('group');
     $group = Group::find($groupId);
     $groups = Group::all();
     $events2 = EventOccurrence::with('activities')->get();
     $events = $events2->filter(function ($item) use($groupId) {
         return $item->group->id === $groupId;
     });
     return view('ActivityPlanning/activityEventPlanner', compact('activities', 'eventPatterns', 'groups', 'group', 'events', 'groupId'));
 }

 public function testManyActivitiesCanBeAddedToUsers()
 {
     factory(App\Group::class, 4)->create()->each(function ($g) {
         for ($i = 0; $i < 5; $i++) {
             $g->users()->save(factory(App\User::class)->make(), ['role' => 'member']);
         }
         $g->users()->save(factory(App\User::class)->make(), ['role' => 'leader']);
     });
     factory(App\Activity::class, 5)->create();
     $group = Group::find(1);
     $activity = Activity::find(1);
     $stuff = array('activityId' => $activity->id, 'group' => $group->id);
     foreach ($group->users as $user) {
         $stuff[$user->id] = 'true';
     }
     $request = Request::create('/', 'POST', $stuff);
     $this->controller->addMany($request);
     foreach ($group->users as $user) {
         $this->seeInDatabase('activity_user', ['activity_id' => $activity->id, 'user_id' => $user->id]);
     }
 }

 /**
  * Display the Guest attendance of the Activity.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function showGuestAttendance($id)
 {
     if (Gate::denies('show', Activity::class)) {
         abort(403);
     }
     $record = Activity::find($id);
     $data = array('title' => 'Activities', 'id' => $id, 'date_of_activity' => $record->date_of_activity, 'barangay' => $record->barangay, 'title_id' => $record->subtitle->title->title, 'subtitle_id' => $record->subtitle->subtitle, 'day_of_activity' => $record->day_of_activity, 'venue_of_activity' => $record->venue_of_activity, 'conducted_by' => $record->conducted_by, 'remarks' => $record->remarks);
     return view('activity.guestattendance')->with($data);
 }

 public function recordActivity($event)
 {
     $model = strtolower(class_basename($this));
     if ($event == "created") {
         $activity = new Activity();
         $activity->subject_id = $this->id;
         $activity->subject_type = get_class($this);
         $activity->name = $this->getActivityName($this, $event);
         $activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
         if ($model == "category") {
             $activity->old_value = $this->name;
         } elseif ($model == "information") {
             $activity->old_value = $this->value;
         } elseif ($model == "field") {
             $activity->old_value = $this->category_label;
         } elseif ($model == "devicelog") {
             $activity->old_value = $this->action;
         } elseif ($model == "owner") {
             $activity->old_value = $this->fullName();
         } else {
             $activity->old_value = $this->name;
         }
         $activity->save();
     } elseif ($event == "updates") {
         if ($model == "category") {
             $activity = new Activity();
             $activity->subject_id = $this->id;
             $activity->subject_type = get_class($this);
             $activity->name = $this->getActivityName($this, $event);
             $activity->old_value = $this->name;
             $activity->new_value = Input::get('name');
             $activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
             $activity->save();
             $this->name = Input::get('name');
             $this->save();
         } elseif ($model == "device") {
             $activity = new Activity();
             $activity->subject_id = $this->id;
             $activity->subject_type = get_class($this);
             $activity->name = $this->getActivityName($this, $event);
             $activity->old_value = $this->name;
             $activity->new_value = Input::get('phone_number');
             $activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
             $activity->save();
             $this->phone_number = Input::get('name');
             $this->save();
         } elseif ($model == "information") {
             foreach (Input::all() as $key => $value) {
                 if (strpos($key, 'info') !== false) {
                     $key = explode('-', $key);
                     $info_id = $key[1];
                     $activity = new Activity();
                     $information = Information::find($info_id);
                     $activity->subject_id = $information->id;
                     $activity->subject_type = get_class($information);
                     $activity->name = $information->getActivityName($information, $event);
                     $activity->old_value = $information->value;
                     $activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
                     $activity->save();
                     $information->value = $value;
                     $information->save();
                     $act = Activity::find($activity->id);
                     $act->new_value = $information->value;
                     $act->save();
                 }
             }
         }
     } elseif ($event == "deleted") {
         $activity = new Activity();
         $activity->subject_id = $this->id;
         $activity->subject_type = get_class($this);
         $activity->name = $this->getActivityName($this, $event);
         $activity->user_id = Auth::guest() ? 0 : Auth::user()->id;
         if ($model == "field") {
             $activity->old_value = $this->category_label;
         } elseif ($model == "information") {
             $activity->old_value = $this->value;
         } else {
             $activity->old_value = $this->name;
         }
         $activity->save();
     }
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     if ($id == null) {
         return null;
     }
     $activity = Activity::find($id);
     $activity->activityType()->detach();
     $activity->user()->detach();
     $activity->delete();
     return response("success", 200);
 }

 public function getA2Attribute($value)
 {
     return Activity::find($value);
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function destroy($id)
 {
     $activity = Activity::find($id);
     $activity->delete();
     return Redirect::to('activity');
 }

 /**
  * Handles the checking to prevent user from applying from activities from the same time period of another activity.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return  JSON  array with Status
  */
 public function checkActivityApplication(Request $request)
 {
     if ($request->get('volunteer_id') == null || $request->get('activity_id') == null) {
         $status = ["Missing parameter"];
         return response()->json(compact('status'));
     } else {
         $userID = $request->get('volunteer_id');
         $actID = $request->get('activity_id');
         $withdrawnTask = Task::where('volunteer_id', $userID)->where('activity_id', $actID)->where('approval', '=', 'withdrawn')->lists('activity_id');
         $applyingActivity = Activity::findOrFail($actID);
         if ($applyingActivity == null) {
             $status = ["do not exist"];
             return response()->json(compact('status'));
         } else {
             $activityStartTime = $applyingActivity->datetime_start;
             $activityDuration = $applyingActivity->expected_duration_minutes;
             $activityEndTime = $applyingActivity->datetime_start->addMinutes($activityDuration);
             $activityFullDayStart = $applyingActivity->datetime_start->startOfDay()->toDateTimeString();
             $activityFullDayEnd = $applyingActivity->datetime_start->endOfDay()->toDateTimeString();
             $activitiesOnSameDay = Activity::whereBetween('datetime_start', [$activityFullDayStart, $activityFullDayEnd])->where('activity_id', '<>', $actID)->lists('activity_id');
             $status = ['rejected'];
             $taskofUserOnSameDay = Task::where('volunteer_id', $userID)->whereIn('activity_id', $activitiesOnSameDay)->whereNotIn('approval', $status)->lists('activity_id');
             $check = false;
             foreach ($taskofUserOnSameDay as $activityID) {
                 $activity = Activity::find($activityID);
                 $bStartTime = $activity->datetime_start;
                 $bDuration = $activity->expected_duration_minutes;
                 $bEndTime = $activity->datetime_start->addMinutes($bDuration);
                 if ($activityStartTime->lte($bStartTime) && $bStartTime->lte($activityEndTime) && $activityEndTime->lte($bEndTime)) {
                     $check = true;
                 }
                 if ($bStartTime->lte($activityStartTime) && $activityStartTime->lte($bEndTime) && $bEndTime->lte($activityEndTime)) {
                     $check = true;
                 }
                 if ($activityStartTime->lte($bStartTime) && $bStartTime->lte($activityEndTime) && $bEndTime->lte($activityEndTime)) {
                     $check = true;
                 }
                 if ($bStartTime->lte($activityStartTime) && $activityStartTime->lte($bEndTime) && $activityEndTime->lte($bEndTime)) {
                     $check = true;
                 }
                 if ($activityStartTime->eq($bStartTime) && $activityEndTime->eq($bEndTime)) {
                     $check = true;
                 }
             }
             if (!$check) {
                 $status = ["do not exist"];
                 return response()->json(compact('status'));
             } else {
                 $status = ["exist"];
                 return response()->json(compact('status'));
             }
         }
     }
 }

 public function postDel(Request $request, $activity_id)
 {
     $res = ['response' => 'YES', 'status' => 0];
     $activity = Activity::findOrFail($activity_id);
     $img = $activity->Img_icon()->first();
     if ($img) {
         $img->update(['img_active' => $img->img_active - 1 >= 0 ? $img->img_active - 1 : 0]);
     }
     $img = $activity->Img_bg()->first();
     if ($img) {
         $img->update(['img_active' => $img->img_active - 1 >= 0 ? $img->img_active - 1 : 0]);
     }
     $activity->delete();
     if (!Activity::find($activity_id)) {
         $res['status'] = 1;
     } else {
         $res['msgError'] = '出错了...';
     }
     return response()->json($res);
 }