<th>Customer Name</th>
<th>Email</th>
<th>Phone</th>
<th>Update Progress</th>
</tr>
</thead>
<tbody>
<?php
//GET data passed from controller and display information
use App\Models\Quote_Requests;
if ($result == '[]') {
echo '<tr><td>No Events In Progress</td><td></td><td></td><td></td><td></td><td></td><td></td></tr>';
} else {
foreach ($result as $item) {
$evedetails = Quote_Requests::select('*')->where('id', $item->EventID)->first();
echo '<tr>';
echo '<td>' . $evedetails->id . '</td>';
echo '<td>' . $evedetails->EventDate . '</td>';
echo '<td>' . $evedetails->EventType . '</td>';
echo '<td>' . $evedetails->FirstName . ' ' . $evedetails->LastName . '</td>';
echo '<td>' . $evedetails->Email . '</td>';
echo '<td>' . $evedetails->Phone . '</td>';
echo '<td><a href ="progress?EventID=' . $evedetails->id . '" ><i class="fa fa-edit"></i></td>';
?>
<?php
echo '</tr>';
}
}
/**
* This function loads the 'Events Progress' page for Customer
*
*
* @return progress 'Events Progress' page with Event Tasks/Quote Requests table data
*/
public function ProgressCustomer()
{
$input = Request::all();
$iName = $input['EventID'];
$user_id = \Auth::user()->id;
//$customereventid = Quote_Requests::select('*')->where('id',$iName)->first();
$memtasks = Event_Tasks::select('*')->where('EventID', $iName)->get();
$teammem = Users::select('*')->where('role', 'team-member')->get();
$evedetails = Quote_Requests::select('*')->where('id', $iName)->first();
$data = array('memtasks' => $memtasks, 'teammem' => $teammem, 'eveID' => $iName, 'evedetails' => $evedetails, 'result' => 'null');
return view('progress_customer.progress')->with($data);
}
/**
* This function used to send the rejected details of a quote made by a customer
*
* @param string POST Data
*
* @return success or fail message using $result variable
*/
public function SendRejectQuoteAdmin()
{
$id = Request::all();
$quoteID = $id['eventid'];
$reason = $id['selectReason'];
$message = $id['rejectMessage'];
$addedDate = date('Y-m-d');
try {
/*
*
*/
$rejectedQuote = new Rejected_Quotes();
$rejectedQuote->QuoteID = $quoteID;
$rejectedQuote->Reason = $reason;
$rejectedQuote->Message = $message;
$rejectedQuote->RejectedDate = $addedDate;
$rejectedQuote->save();
Quote_Requests::where('id', $quoteID)->update(['Status' => 'Rejected']);
$result = array('eventID' => $quoteID, 'message' => 'success');
$user = Quote_Requests::select('Username', 'Email')->where('id', $quoteID)->get();
foreach ($user as $key) {
$username = $key->Username;
$emailuser = $key->Email;
}
$email = new EmailController();
$email->quoteRejectedEmail($username, $emailuser, $quoteID, $reason, $message);
return redirect('dashboard/quote-requests/reject-quote')->with('result', $result);
} catch (QueryException $e) {
$result = array('eventID' => $quoteID, 'message' => 'fail');
return redirect('dashboard/quote-requests/reject-quote')->with('result', $result);
}
}
/**
* 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'));
}