/** * This function loads the 'My Events in Progress' page for Customer * * * @return progress 'Events Submitted By Me' page with Event Tasks/Quote Requests table data */ public function CustomerEvents() { $user_id = \Auth::user()->id; $iEventID = array(); $iEventTasks = array(); $mytasks = array(); $myeventids = Quote_Requests::select('id')->where('UserID', $user_id)->get(); foreach ($myeventids as $x) { $iEventID[] = $x->id; } foreach ($iEventID as $y) { $mytasks[] = Event_Tasks::distinct()->select('EventID')->where('EventID', $y)->first(); } return view('progress_customer.myevents')->with('result', $mytasks); //echo $myeventids[0]->id; //echo $mytasks->EventID; }
/** * This function Handles the post event of the Assign Tasks page * * * @return if successful All Events To Be Assigned page */ public function AssignPOST() { $input = Request::all(); //create arrays to store post data $iTaskdesc = array(); $iTeamMem = array(); $dbData = array(); //take inputs to variables $iName = $input['EventID']; //store input data in corresponding arrays foreach ($input['desc'] as $x) { $iTaskdesc[] = $x; } foreach ($input['teammember'] as $y) { $iTeamMem[] = $y; } foreach ($input['desc'] as $z => $value) { Event_Tasks::insert([['EventID' => $iName, 'MemberID' => $iTeamMem[$z], 'Description' => $iTaskdesc[$z]]]); } $mem = Event_Tasks::distinct()->select('MemberID')->where('EventID', $iName)->get(); $evedata = Quote_Requests::select('*')->where('id', $iName)->first(); //return dd($mem); foreach ($mem as $memb) { $time = Carbon::now(); $em = Users::select('*')->where('id', $memb->MemberID)->first(); $mailData = ['EventID' => $iName, 'MemName' => $em->Name, 'DueDate' => $evedata->EventDate, 'FirstName' => $evedata->FirstName, 'LastName' => $evedata->LastName]; Mail::send('emails.member-tasks', $mailData, function ($message) use($em) { $message->to($em->email, 'Test')->subject('Tasks Assgined for Event'); }); } /* */ $team = Users::distinct()->select('*')->where('role', 'team-member')->get(); $quote = Quote_Requests::select('*')->get(); return view('assign_task.assign-tasks')->with(array('team' => $team, 'quote' => $quote, 'message' => 'yes')); }