<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 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);
}
}
public function store()
{
$getid = Events::select('EventID')->get();
if (!$getid->isEmpty()) {
$getid = Events::select('EventID')->orderBy('EventID', 'desc')->first()->get();
foreach ($getid as $key) {
$id = (int) $key->EventID + 1;
}
} else {
$id = 1;
}
$result = Request::all();
$quoteID = $result['quoteid'];
$eventType = $result['eventType'];
$downpayment = $result['downpayment'];
$userID = Auth::user()->id;
$addedDate = date('Y-m-d H:i:s');
try {
/*
* Insert the new Quote to Database Table 'quote_requests'
*/
$events = new Events();
$events->EventID = $id;
$events->QuoteID = $quoteID;
$events->UserID = $userID;
$events->EventType = $eventType;
$events->AddedDate = $addedDate;
$events->save();
Quote_Requests::where('id', $quoteID)->update(['Status' => 'Paid']);
} catch (QueryException $e) {
}
// ### Address
// Base Address object used as shipping or billing
// address in a payment. [Optional]
$addr = Paypalpayment::address();
$addr->setLine1("22/1, Nagavihara Road");
$addr->setLine2("Pitakotte");
$addr->setCity("Pitakotte");
$addr->setState("");
$addr->setPostalCode("10100");
$addr->setCountryCode("SL");
$addr->setPhone("0094773685526");
// ### CreditCard
$card = Paypalpayment::creditCard();
$card->setType("visa")->setNumber("4758411877817150")->setExpireMonth("05")->setExpireYear("2019")->setCvv2("456")->setFirstName("Hasitha")->setLastName("Jayasinghe");
// ### FundingInstrument
// A resource representing a Payer's funding instrument.
// Use a Payer ID (A unique identifier of the payer generated
// and provided by the facilitator. This is required when
// creating or using a tokenized funding instrument)
// and the `CreditCardDetails`
$fi = Paypalpayment::fundingInstrument();
$fi->setCreditCard($card);
// ### Payer
// A resource representing a Payer that funds a payment
// Use the List of `FundingInstrument` and the Payment Method
// as 'credit_card'
$payer = new Payer();
$payer->setPaymentMethod('paypal');
$item_1 = new Item();
$item_1->setName('Quote ID: ' . $quoteID)->setCurrency('USD')->setQuantity(1)->setPrice($downpayment);
// unit price
// add item to list
$item_list = new ItemList();
$item_list->setItems(array($item_1));
$amount = new Amount();
$amount->setCurrency('USD')->setTotal($downpayment);
$transaction = new Transaction();
$transaction->setAmount($amount)->setItemList($item_list)->setDescription('Your transaction description');
// ### Payment
// A Payment Resource; create one using
// the above types and intent as 'sale'
$redirect_urls = new RedirectUrls();
$redirect_urls->setReturnUrl(URL::route('payment-status'))->setCancelUrl(URL::route('payment-status'));
$payment = new Payment();
$payment->setIntent('order')->setPayer($payer)->setRedirectUrls($redirect_urls)->setTransactions(array($transaction));
try {
// ### Create Payment
// Create a payment by posting to the APIService
// using a valid ApiContext
// The return object contains the status;
$payment->create($this->_apiContext);
} catch (\PPConnectionException $ex) {
return "Exception: " . $ex->getMessage() . PHP_EOL;
exit(1);
}
foreach ($payment->getLinks() as $link) {
if ($link->getRel() == 'approval_url') {
$redirect_url = $link->getHref();
break;
}
}
// add payment ID to session
Session::put('paypal_payment_id', $payment->getId());
if (isset($redirect_url)) {
// redirect to paypal
return Redirect::away($redirect_url);
}
return Redirect::route('original-route')->with('error', 'Unknown error occurred');
dd($payment);
}
/**
* 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 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'));
}