public function striperefundAction(Request $request)
{
$session = $request->getSession();
if ($session->get('refund') == '') {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$username = $session->get('user');
$refund = $session->get('refund');
if (empty($username)) {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$lan = $session->get('language');
$em = $this->container->get('doctrine')->getManager();
$bookingtransaction = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingTransaction p WHERE p.booking='" . $refund['refund_booking_id'] . "'")->getArrayResult();
$booking = $em->createQuery("SELECT d,IDENTITY(d.hostal) AS hostal,IDENTITY(d.room) AS room FROM MytripAdminBundle:Booking d WHERE d.bookingId=" . $refund['refund_booking_id'])->getArrayResult();
if ($booking[0][0]['status'] != "Confirmed") {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking already cancelled or payment not proceed. Please check it.'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
$paymentArray['amount'] = $refund['cancelamount'];
//$paymentArray['refundType']='Partial';
$paymentArray['transactionID'] = $bookingtransaction[0]['transactionId'];
//$paymentArray['currency']=$bookingtransaction[0]['transactionCurrency'];
$result = $this->StripeRefund($paymentArray);
$ack = strtoupper($result["ACK"]);
if ($ack == "SUCCESS") {
$cancel = new \Mytrip\AdminBundle\Entity\BookingCancel();
$cancel->setBooking($this->getDoctrine()->getRepository('MytripAdminBundle:Booking')->find($refund['refund_booking_id']));
$cancel->setCancelPercentage($refund['cancel_percentage']);
$cancel->setCancelDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundReferenceno($result['REFUNDTRANSACTIONID']);
$cancel->setRefundAmount($refund['cancelamount']);
$cancel->setRefundDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundCurrency($bookingtransaction[0]['transactionCurrency']);
$cancel->setStatus('Refund');
$em->persist($cancel);
$em->flush();
$em->createQuery("UPDATE MytripAdminBundle:Booking p SET p.status='Cancelled' WHERE p.bookingId='" . $refund['refund_booking_id'] . "'")->execute();
$bookingid = $refund['refund_booking_id'];
$booking = $em->createQuery("SELECT d,IDENTITY(d.hostal) AS hostal,IDENTITY(d.room) AS room FROM MytripAdminBundle:Booking d WHERE d.bookingId=" . $bookingid)->getArrayResult();
$booking_info = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingInfo d WHERE d.booking=" . $bookingid)->getArrayResult();
$this->mailsend("Mytrip Cuba", "*****@*****.**", $booking_info[0]['email'], $this->get('translator')->trans('Reservation Cancel Details'), '', '');
$session->remove('refund');
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking cancelled successfully'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
} else {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans($result['message']));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
}
public function beanstreamrefundAction(Request $request)
{
$session = $request->getSession();
if ($session->get('refund') == '') {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$username = $session->get('user');
$refund = $session->get('refund');
if (empty($username)) {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$lan = $session->get('language');
$em = $this->container->get('doctrine')->getManager();
$bookingtransaction = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingTransaction p WHERE p.booking='" . $refund['refund_booking_id'] . "'")->getArrayResult();
$booking = $em->createQuery("SELECT p FROM MytripAdminBundle:Booking p WHERE p.bookingId='" . $refund['refund_booking_id'] . "'")->getArrayResult();
if ($booking[0]['status'] != "Confirmed") {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking already cancelled or payment not proceed. Please check it.'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
$paymentArray['amount'] = $refund['cancelamount'];
$paymentArray['transactionID'] = $bookingtransaction[0]['transactionId'];
$paymentArray['orderno'] = "venacuba-" . $refund['refund_booking_id'] * 1024;
$paymentArray['currency'] = $bookingtransaction[0]['transactionCurrency'];
$result = $this->BeanstreamRefund($paymentArray);
if ($result['trnApproved'] == "1") {
$cancel = new \Mytrip\AdminBundle\Entity\BookingCancel();
$cancel->setBooking($this->getDoctrine()->getRepository('MytripAdminBundle:Booking')->find($refund['refund_booking_id']));
$cancel->setCancelPercentage($refund['cancel_percentage']);
$cancel->setCancelDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundReferenceno($result['trnId']);
$cancel->setRefundAmount($refund['cancelamount']);
$cancel->setRefundDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundCurrency($bookingtransaction[0]['transactionCurrency']);
$cancel->setStatus('Refund');
$em->persist($cancel);
$em->flush();
$em->createQuery("UPDATE MytripAdminBundle:Booking p SET p.status='Cancelled' WHERE p.bookingId='" . $refund['refund_booking_id'] . "'")->execute();
$bookingid = $refund['refund_booking_id'];
$booking = $em->createQuery("SELECT d,IDENTITY(d.hostal) AS hostal,IDENTITY(d.room) AS room FROM MytripAdminBundle:Booking d WHERE d.bookingId=" . $bookingid)->getArrayResult();
$booking_info = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingInfo d WHERE d.booking=" . $bookingid)->getArrayResult();
$this->mailsend("Mytrip Cuba", "*****@*****.**", $booking_info[0]['email'], $this->get('translator')->trans('Reservation Cancel Details'), '', '');
$login = $this->container->get('mytrip_admin.helper.sms')->getOption('smsusername');
$password = $this->container->get('mytrip_admin.helper.sms')->getOption('smspassword');
$prefix = $booking_info[0]['cmcode'];
$number = $booking_info[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear Customer, Your booking cancelled successfully for the reference no is') . ' ' . ("venacuba-" . $bookingid * 1024) . $this->get('translator')->trans('Refund amount is') . ' ' . $refund['cancelamount'] . $bookingtransaction[0]['transactionCurrency'] . ' ' . $this->get('translator')->trans('Refund transaction id is') . ' ' . $result['trnId']);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
$session->remove('refund');
$bookingcancel = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingCancel p WHERE p.booking='" . $booking[0][0]['bookingId'] . "'")->getArrayResult();
$hostal_query = $em->createQuery("SELECT h FROM MytripAdminBundle:Hostal h WHERE h.status='Active' AND h.hostalId='" . $booking[0]['hostal'] . "'");
$hostals = $hostal_query->getArrayResult();
if (empty($hostals)) {
return $this->redirect($this->generateUrl('mytrip_user_destination'));
}
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='{$lan}' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
if (empty($hostal_content)) {
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='en' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
}
$hostal_room = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalRooms d WHERE d.hostal=" . $hostals[0]['hostalId'])->getArrayResult();
$bookingprice = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingPrice d WHERE d.booking=" . $bookingid)->getArrayResult();
$booking_transaction = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingTransaction d WHERE d.booking=" . $bookingid)->getArrayResult();
$buser = $session->get('user');
$uid = $buser['userId'];
/**Booking send to the hostal owner email id***/
$setting = $em->createQuery("SELECT p FROM MytripAdminBundle:Settings p")->getArrayResult();
$busers = $em->createQuery("SELECT p FROM MytripAdminBundle:User p WHERE p.userId='" . $uid . "'")->getArrayResult();
if ($busers[0]['province'] != '') {
$province = $em->createQuery("SELECT d FROM MytripAdminBundle:States d WHERE d.sid=" . $busers[0]['province'])->getArrayResult();
}
if ($busers[0]['country'] != '') {
$country = $em->createQuery("SELECT d FROM MytripAdminBundle:Country d WHERE d.cid=" . $busers[0]['country'])->getArrayResult();
}
$user_name = $busers[0]['firstname'] . ' ' . $busers[0]['lastname'];
$address = $busers[0]['address'] . " , " . $busers[0]['city'] . ', ' . ($busers[0]['province'] != '' ? $province[0]['state'] . ', ' : '') . ($busers[0]['country'] != '' ? $country[0]['country'] : '');
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '12'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => $lan));
if (!empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => 'en'));
}
$from_date = $booking[0][0]['fromDate'];
$to_date = $booking[0][0]['toDate'];
if ($hostals[0]['ownerEmail'] != '') {
$message = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'] . ' CAD', number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'] . ' CAD', number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $hostals[0]['ownerEmail'], $subject, $message, '', 0, '', 'email');
}
if ($hostals[0]['cmcode'] != '' && $hostals[0]['mobile'] != '') {
/**Booking send to the hostal owner mobile***/
$prefix = $hostals[0]['cmcode'];
$number = $hostals[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $hostal_content[0]['ownerName'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
/**Booking send to the Site Admin email id***/
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '13'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '13', 'lan' => $lan));
if (!empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '13', 'lan' => 'en'));
}
$admin = $em->createQuery("SELECT p FROM MytripAdminBundle:Admin p WHERE p.adminId='1'")->getArrayResult();
$message = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'] . ' CAD', number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'] . ' CAD', number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $admin[0]['email'], $subject, $message, '', 0, '', 'email');
if ($admin[0]['cmcode'] != '' && $admin[0]['mobile'] != '') {
/**Booking send to the site admin mobile***/
$prefix = $admin[0]['cmcode'];
$number = $admin[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $admin[0]['name'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking cancelled successfully'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
} else {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, Transaction has some problem. Please try again later or contact admin'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
}
public function cancelbookingAction(Request $request)
{
$response = $this->checkUser($request->getSession());
if ($response) {
return $response;
}
/****Check language session*******/
$session = $request->getSession();
$this->langsession($session);
$lan = $session->get('language');
$request->setLocale($lan);
$usersession = $session->get('user');
$bookingid = $request->get('bookingId') / 1024;
$em = $this->container->get('doctrine')->getManager();
$booking = $em->createQuery("SELECT b,IDENTITY(b.hostal) AS hostal FROM MytripAdminBundle:Booking b WHERE b.bookingId='" . $bookingid . "' AND b.user='******'userId'] . "' AND b.status='Confirmed' AND b.fromDate>='" . date('Y-m-d H:i:s') . "'")->getArrayResult();
$user = $em->createQuery("SELECT p FROM MytripAdminBundle:User p WHERE p.userId='" . $usersession['userId'] . "'")->getArrayResult();
if (empty($booking)) {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, Your booking id is wrong. Please check once again'));
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
if ($booking[0][0]['status'] == "Pending" || $booking[0][0]['status'] == "Cancelled") {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, Your booking id is wrong. Please check once again'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
$startdate = date('Y-m-d');
$enddate = $booking[0][0]['fromDate']->format('Y-m-d');
$betweendays = $this->noofdays($startdate, $enddate);
$bookingprice = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingPrice p WHERE p.booking='" . $booking[0][0]['bookingId'] . "'")->getArrayResult();
$bookingtransaction = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingTransaction p WHERE p.booking='" . $booking[0][0]['bookingId'] . "'")->getArrayResult();
if ($request->getMethod() == "POST") {
$hostal_cancel = $em->createQuery("SELECT p FROM MytripAdminBundle:HostalCancelDetails p WHERE p.hostal='" . $booking[0]['hostal'] . "' AND p.days <='" . $betweendays . "' ORDER BY p.days DESC")->setMaxResults('1')->getArrayResult();
if (!empty($hostal_cancel)) {
$tamount = $bookingprice[0]['reservationTotalPrice'] - $bookingprice[0]['reservationCharge'];
$cancelamount = $tamount * ($hostal_cancel[0]['percentage'] / 100);
$cancel_percentage = $hostal_cancel[0]['percentage'];
} else {
$cancelamount = 0;
$cancel_percentage = 0;
}
$refunds = array('refund_booking_id' => $bookingid, 'cancelamount' => $cancelamount, 'cancel_percentage' => $cancel_percentage, 'currency' => $bookingprice[0]['conversionCurrency']);
$session->set('refund', $refunds);
if ($cancelamount == 0) {
$cancel = new \Mytrip\AdminBundle\Entity\BookingCancel();
$cancel->setBooking($this->getDoctrine()->getRepository('MytripAdminBundle:Booking')->find($bookingid));
$cancel->setCancelPercentage($cancel_percentage);
$cancel->setCancelDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundAmount($cancelamount);
$cancel->setRefundDate(new \DateTime(date('Y-m-d')));
$cancel->setCreatedDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundCurrency($bookingprice[0]['conversionCurrency']);
$cancel->setStatus('Refund');
$em->persist($cancel);
$em->flush();
$em->createQuery("UPDATE MytripAdminBundle:Booking p SET p.status='Cancelled' WHERE p.bookingId='" . $bookingid . "'")->execute();
$bookingid = $refunds['refund_booking_id'];
$booking = $em->createQuery("SELECT d,IDENTITY(d.hostal) AS hostal FROM MytripAdminBundle:Booking d WHERE d.bookingId=" . $bookingid)->getArrayResult();
$booking_info = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingInfo d WHERE d.booking=" . $bookingid)->getArrayResult();
$this->mailsend("Mytrip Cuba", "*****@*****.**", $booking_info[0]['email'], $this->get('translator')->trans('Reservation Cancel Details'), '', '', '0', '', 'refund');
$login = $this->container->get('mytrip_admin.helper.sms')->getOption('smsusername');
$password = $this->container->get('mytrip_admin.helper.sms')->getOption('smspassword');
$prefix = $booking_info[0]['cmcode'];
$number = $booking_info[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear Customer, Your booking cancelled successfully for the reference no is') . ' ' . ("venacuba-" . $bookingid * 1024) . $this->get('translator')->trans('Refund amount is') . ' ' . $refunds['cancelamount'] . $refunds['currency']);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
$session->remove('refund');
$bookingcancel = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingCancel p WHERE p.booking='" . $booking[0][0]['bookingId'] . "'")->getArrayResult();
$hostal_query = $em->createQuery("SELECT h FROM MytripAdminBundle:Hostal h WHERE h.status='Active' AND h.hostalId='" . $booking[0]['hostal'] . "'");
$hostals = $hostal_query->getArrayResult();
if (empty($hostals)) {
return $this->redirect($this->generateUrl('mytrip_user_destination'));
}
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='{$lan}' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
if (empty($hostal_content)) {
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='en' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
}
$hostal_room = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalRooms d WHERE d.hostal=" . $hostals[0]['hostalId'])->getArrayResult();
$booking_price = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingPrice d WHERE d.booking=" . $bookingid)->getArrayResult();
$booking_transaction = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingTransaction d WHERE d.booking=" . $bookingid)->getArrayResult();
$buser = $session->get('user');
$uid = $buser['userId'];
/**Booking send to the hostal owner email id***/
$setting = $em->createQuery("SELECT p FROM MytripAdminBundle:Settings p")->getArrayResult();
$busers = $em->createQuery("SELECT p FROM MytripAdminBundle:User p WHERE p.userId='" . $uid . "'")->getArrayResult();
if ($busers[0]['province'] != '') {
$province = $em->createQuery("SELECT d FROM MytripAdminBundle:States d WHERE d.sid=" . $busers[0]['province'])->getArrayResult();
}
if ($busers[0]['country'] != '') {
$country = $em->createQuery("SELECT d FROM MytripAdminBundle:Country d WHERE d.cid=" . $busers[0]['country'])->getArrayResult();
}
$user_name = $busers[0]['firstname'] . ' ' . $busers[0]['lastname'];
$address = $busers[0]['address'] . ', ' . $busers[0]['city'] . ', ' . ($busers[0]['province'] != '' ? $province[0]['state'] . ', ' : '') . ($busers[0]['country'] != '' ? $country[0]['country'] : '');
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '12'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => $lan));
if (empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => 'en'));
}
$fromdate = $booking[0][0]['fromDate'];
$todate = $booking[0][0]['toDate'];
if ($hostals[0]['ownerEmail'] != '') {
$message = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $fromdate->format('Y-m-d H:i:s'), $todate->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'], number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $fromdate->format('Y-m-d H:i:s'), $todate->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'], number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $hostals[0]['ownerEmail'], $subject, $message, '');
}
if ($hostals[0]['cmcode'] != '' && $hostals[0]['mobile'] != '') {
/**Booking send to the hostal owner mobile***/
$prefix = $hostals[0]['cmcode'];
$number = $hostals[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $hostal_content[0]['ownerName'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
/**Booking send to the Site Admin email id***/
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '11'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '11', 'lan' => $lan));
if (!empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '11', 'lan' => 'en'));
}
$admin = $em->createQuery("SELECT p FROM MytripAdminBundle:Admin p WHERE p.adminId='1'")->getArrayResult();
$message = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $fromdate->format('Y-m-d H:i:s'), $todate->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'], number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{room_type}', '{rooms}', '{nights}', '{room_details}', '{username}', '{address}', '{room_price}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $fromdate->format('Y-m-d H:i:s'), $todate->format('Y-m-d H:i:s'), $hostal_room[0]['roomtype'], $booking[0][0]['noOfRooms'], $booking[0][0]['noOfDays'], 'Guests:' . $hostal_room[0]['guests'] . ',Adults:' . $hostal_room[0]['adults'] . ',Child:' . $hostal_room[0]['child'], $user_name, $address, $hostal_room[0]['price'], number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $admin[0]['email'], $subject, $message, '');
if ($admin[0]['cmcode'] != '' && $admin[0]['mobile'] != '') {
/**Booking send to the site admin mobile***/
$prefix = $admin[0]['cmcode'];
$number = $admin[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $admin[0]['name'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking was cancelled successfully'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
} else {
if ($bookingtransaction[0]['paymentType'] == "Paypal") {
return $this->redirect($this->generateUrl('mytrip_user_paypal_refund'));
} elseif ($bookingtransaction[0]['paymentType'] == "Stripe") {
return $this->redirect($this->generateUrl('mytrip_user_stripe_refund'));
} elseif ($bookingtransaction[0]['paymentType'] == "Skrill") {
return $this->redirect($this->generateUrl('mytrip_user_skrill_refund'));
} elseif ($bookingtransaction[0]['paymentType'] == "Beanstream") {
return $this->redirect($this->generateUrl('mytrip_user_beanstream_refund'));
} elseif ($bookingtransaction[0]['paymentType'] == "Globalone") {
return $this->redirect($this->generateUrl('mytrip_user_globalone_refund'));
}
}
}
$seo['title'] = "venacuba-" . $bookingid * 1024 . $request->get('bookingid') . " - Details, " . $user[0]['firstname'] . " " . $user[0]['lastname'];
$seo['metadescription'] = "venacuba-" . $bookingid * 1024 . $request->get('bookingid') . " - Details, " . $user[0]['firstname'] . " " . $user[0]['lastname'];
$seo['metakeywords'] = "venacuba-" . $bookingid * 1024 . $request->get('bookingid') . " - Details, " . $user[0]['firstname'] . " " . $user[0]['lastname'];
return $this->render('MytripUserBundle:Default:cancelbooking.html.php', array('seo' => $seo, 'betweendays' => $betweendays, 'booking' => $booking, 'user' => $user, 'language' => $this->language(), 'soacillink' => $this->getsociallink()));
}
public function globalonerefundAction(Request $request)
{
$session = $request->getSession();
if ($session->get('refund') == '') {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$username = $session->get('user');
$refunds = $session->get('refund');
if (empty($username)) {
return $this->redirect($this->generateUrl('mytrip_user_homepage'));
}
$lan = $session->get('language');
$request->setLocale($lan);
$em = $this->container->get('doctrine')->getManager();
$bookingtransaction = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingTransaction p WHERE p.booking='" . $refunds['refund_booking_id'] . "'")->getArrayResult();
$booking = $em->createQuery("SELECT p FROM MytripAdminBundle:Booking p WHERE p.bookingId='" . $refunds['refund_booking_id'] . "'")->getArrayResult();
if ($booking[0]['status'] != "Confirmed") {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking already cancelled or payment not proceed. Please check it.'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
$paymentArray['amount'] = $refunds['cancelamount'];
$paymentArray['transactionID'] = $bookingtransaction[0]['transactionId'];
$paymentArray['orderno'] = "venacuba-" . $refunds['refund_booking_id'] * 1024;
$paymentArray['currency'] = $bookingtransaction[0]['transactionCurrency'];
$terminalid = $this->container->get('mytrip_admin.helper.globalone')->getOption('terminalid');
$secret = $this->container->get('mytrip_admin.helper.globalone')->getOption('secret');
$multicur = $this->container->get('mytrip_admin.helper.globalone')->getOption('multicurrency');
$testAccount = $this->container->get('mytrip_admin.helper.globalone')->getOption('testaccount');
$gateway = 'globalone';
$autoready = '';
$amount = $paymentArray['amount'];
# Set up the refund object
$refund = new \XmlRefundRequest($terminalid, $paymentArray['orderno'], $paymentArray['amount'], 'User', 'Cancel the ticket');
$refund->SetUniqueRef($paymentArray['transactionID']);
if ($autoready) {
$refund->SetAutoReady($autoready);
}
# Perform the refund and read in the result
$response = $refund->ProcessRequestToGateway($secret, $testAccount, $gateway);
//$expectedResponseHash = md5($terminalId . $response->UniqueRef() . ($multicur == true ? $currency : '') . $amount . $response->DateTime() . $response->ResponseCode() . $response->ResponseText() . $secret);
if ($response->IsError()) {
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, Transaction has some problem. Please try again later or contact admin'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
} else {
//elseif($expectedResponseHash == $response->Hash()) {
switch ($response->ResponseCode()) {
case "A":
# -- If using local database, update order as (partially) Refunded.
$responseText = $response->ResponseText();
$UniqueRef = $response->UniqueRef();
$cancel = new \Mytrip\AdminBundle\Entity\BookingCancel();
$cancel->setBooking($this->getDoctrine()->getRepository('MytripAdminBundle:Booking')->find($refunds['refund_booking_id']));
$cancel->setCancelPercentage($refunds['cancel_percentage']);
$cancel->setCancelDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundReferenceno($UniqueRef);
$cancel->setRefundAmount($refunds['cancelamount']);
$cancel->setRefundDate(new \DateTime(date('Y-m-d')));
$cancel->setCreatedDate(new \DateTime(date('Y-m-d')));
$cancel->setRefundCurrency($bookingtransaction[0]['transactionCurrency']);
$cancel->setStatus('Refund');
$em->persist($cancel);
$em->flush();
$em->createQuery("UPDATE MytripAdminBundle:Booking p SET p.status='Cancelled' WHERE p.bookingId='" . $refunds['refund_booking_id'] . "'")->execute();
$bookingid = $refunds['refund_booking_id'];
//,IDENTITY(d.rooms) AS
$booking = $em->createQuery("SELECT d,IDENTITY(d.hostal) AS hostal FROM MytripAdminBundle:Booking d WHERE d.bookingId=" . $bookingid)->getArrayResult();
$booking_info = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingInfo d WHERE d.booking=" . $bookingid)->getArrayResult();
$this->mailsend("Mytrip Cuba", "*****@*****.**", $booking_info[0]['email'], $this->get('translator')->trans('Reservation Cancel Details'), '');
$login = $this->container->get('mytrip_admin.helper.sms')->getOption('smsusername');
$password = $this->container->get('mytrip_admin.helper.sms')->getOption('smspassword');
$prefix = $booking_info[0]['cmcode'];
$number = $booking_info[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear Customer, Your booking cancelled successfully for the reference no is') . ' ' . ("venacuba-" . $bookingid * 1024) . $this->get('translator')->trans('Refund amount is') . ' ' . $refunds['cancelamount'] . $bookingtransaction[0]['transactionCurrency'] . ' ' . $this->get('translator')->trans('Refund transaction id is') . ' ' . $result['trnId']);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
$session->remove('refund');
$bookingcancel = $em->createQuery("SELECT p FROM MytripAdminBundle:BookingCancel p WHERE p.booking='" . $booking[0][0]['bookingId'] . "'")->getArrayResult();
$hostal_query = $em->createQuery("SELECT h FROM MytripAdminBundle:Hostal h WHERE h.status='Active' AND h.hostalId='" . $booking[0]['hostal'] . "'");
$hostals = $hostal_query->getArrayResult();
if (empty($hostals)) {
return $this->redirect($this->generateUrl('mytrip_user_destination'));
}
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='{$lan}' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
if (empty($hostal_content)) {
$hostal_content_query = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalContent d WHERE d.lan='en' AND d.hostal=" . $hostals[0]['hostalId']);
$hostal_content = $hostal_content_query->getArrayResult();
}
/*
if($hostal_content[0]['province']!=''){
$province=$em->createQuery("SELECT d FROM MytripAdminBundle:States d WHERE d.sid=".$hostal_content[0]['province'])->getArrayResult();
}
if($hostal_content[0]['country']!=''){
$country=$em->createQuery("SELECT d FROM MytripAdminBundle:Country d WHERE d.cid=".$hostal_content[0]['country'])->getArrayResult();
}
*/
$address = $hostal_content[0]['address'] . ', ' . $hostal_content[0]['city'] . ', ' . ($hostal_content[0]['province'] != '' ? $province[0]['state'] . ', ' : '') . ($hostal_content[0]['country'] != '' ? $country[0]['country'] : '');
// booking rooms data.
$rooms_data = '| ';
foreach ($booking[0][0]['rooms'] as $room) {
$rooms_data .= $room['roomtype'] . ' | ';
}
//$hostal_room = $em->createQuery("SELECT d FROM MytripAdminBundle:HostalRooms d WHERE d.hostal=".$hostals[0]['hostalId'])->getArrayResult();
$bookingprice = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingPrice d WHERE d.booking=" . $bookingid)->getArrayResult();
$booking_transaction = $em->createQuery("SELECT d FROM MytripAdminBundle:BookingTransaction d WHERE d.booking=" . $bookingid)->getArrayResult();
$buser = $session->get('user');
$uid = $buser['userId'];
/**Booking send to the hostal owner email id***/
$setting = $em->createQuery("SELECT p FROM MytripAdminBundle:Settings p")->getArrayResult();
$busers = $em->createQuery("SELECT p FROM MytripAdminBundle:User p WHERE p.userId='" . $uid . "'")->getArrayResult();
//if($busers[0]['province']!=''){
// $province=$em->createQuery("SELECT d FROM MytripAdminBundle:States d WHERE d.sid=".$busers[0]['province'])->getArrayResult();
//}
//if($busers[0]['country']!=''){
// $country=$em->createQuery("SELECT d FROM MytripAdminBundle:Country d WHERE d.cid=".$busers[0]['country'])->getArrayResult();
//}
$user_name = $busers[0]['firstname'] . ' ' . $busers[0]['lastname'];
//$address=$busers[0]['address']." ".$busers[0]['address1'].', '.$busers[0]['city'].', '.($busers[0]['province']!=''?$province[0]['state'].', ':'').($busers[0]['country']!=''?$country[0]['country']:'');
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '12'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => $lan));
if (empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '12', 'lan' => 'en'));
}
$from_date = $booking[0][0]['fromDate'];
$to_date = $booking[0][0]['toDate'];
if ($hostals[0]['ownerEmail'] != '') {
$message = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{rooms}', '{nights}', '{username}', '{address}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $rooms_data, $booking[0][0]['noOfDays'], $user_name, $address, number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{rooms}', '{nights}', '{username}', '{address}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $rooms_data, $booking[0][0]['noOfDays'], $user_name, $address, number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $hostals[0]['ownerEmail'], $subject, $message, '', 0, '', 'email');
}
if ($hostals[0]['cmcode'] != '' && $hostals[0]['mobile'] != '') {
/**Booking send to the hostal owner mobile***/
$prefix = $hostals[0]['cmcode'];
$number = $hostals[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $hostal_content[0]['ownerName'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
/**Booking send to the Site Admin email id***/
$emaillist = $em->getRepository('MytripAdminBundle:EmailList')->findOneBy(array('emailListId' => '13'));
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '13', 'lan' => $lan));
if (empty($emailcontent)) {
$emailcontent = $em->getRepository('MytripAdminBundle:EmailContent')->findOneBy(array('emailList' => '13', 'lan' => 'en'));
}
$admin = $em->createQuery("SELECT p FROM MytripAdminBundle:Admin p WHERE p.adminId='1'")->getArrayResult();
$message = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{rooms}', '{nights}', '{username}', '{address}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $rooms_data, $booking[0][0]['noOfDays'], $user_name, $address, number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getEmailContent());
$subject = str_replace(array('{admin_name}', '{owner_name}', '{hostal_name}', '{check_in}', '{check_out}', '{rooms}', '{nights}', '{username}', '{address}', '{accommodation_cost}', '{reservation_charge}', '{total_cost}', '{ref_no}', '{paid_amount}', '{balance_amount}', '{refund_amount}'), array($admin[0]['name'], $hostal_content[0]['ownerName'], $hostal_content[0]['name'], $from_date->format('Y-m-d H:i:s'), $to_date->format('Y-m-d H:i:s'), $rooms_data, $booking[0][0]['noOfDays'], $user_name, $address, number_format($bookingprice[0]['totalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format($bookingprice[0]['reservationCharge'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], "venacuba-" . $bookingid * 1024, number_format($bookingprice[0]['reservationTotalPrice'] * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], number_format(($bookingprice[0]['totalPrice'] + $bookingprice[0]['reservationCharge'] - $bookingprice[0]['reservationTotalPrice']) * $bookingprice[0]['conversionRate'], 2) . ' ' . $bookingprice[0]['conversionCurrency'], $bookingcancel[0]['refundAmount'] . ' ' . $bookingcancel[0]['refundCurrency']), $emailcontent->getSubject());
$this->mailsend($emaillist->getFromname(), $emaillist->getFromemail(), $hostals[0]['ownerEmail'], $subject, $message, '', 0, '', 'email');
if ($admin[0]['cmcode'] != '' && $admin[0]['mobile'] != '') {
/**Booking send to the site admin mobile***/
$prefix = $admin[0]['cmcode'];
$number = $admin[0]['mobile'];
$msg = urlencode($this->get('translator')->trans('Dear ' . $admin[0]['name'] . ', ' . $user_name . ' has cancelled room in the ' . $hostal_content[0]['name'] . '. Reference no is') . ' ' . "venacuba-" . $bookingid * 1024);
$URL = "http://api.smsacuba.com/api10allcountries.php?";
$URL .= "login="******"&password="******"&prefix=" . $prefix . "&number=" . $number . "&sender=Mytriptocuba" . "&msg=" . $msg;
$r = @file($URL);
$succmsg = $r[0];
}
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Your booking was cancelled successfully'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
break;
case "R":
case "D":
case "C":
case "S":
default:
# -- If using local database, update order as declined/failed --
$this->get('session')->getFlashBag()->add('success', $this->get('translator')->trans('Sorry, Transaction has some problem. Please try again later or contact admin'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}
}
/*} else {
$this->get('session')->getFlashBag()->add('success',$this->get('translator')->trans('Sorry, Transaction has some problem. Please try again later or contact admin'));
return $this->redirect($this->generateUrl('mytrip_user_bookinghistory'));
}*/
}
