$values[] = $_POST['flight'];
$values[] = $_POST['parking_points'];
$values[] = $_POST['discount_type'];
$types = 'ssssssssssssssiissi';
if ($db->insert('bookings', $keys, $values, $types)) {
$error = "Booking added successfully!";
} else {
$error = "Booking added unsuccessfully - Query failed!";
}
$_POST['payment_type'] = 'Frontdesk payment';
$data = array('firstname' => $_POST['firstname'], 'lastname' => $_POST['lastname'], 'email' => $_POST['email_address'], 'telephone' => $_POST['telephone'], 'departDate' => $_POST['departDate'], 'departTime' => $_POST['departTime'], 'arriveDate' => $_POST['arrivaDate'], 'arriveTime' => $_POST['arriveTime'], 'model' => $_POST['vehicleModel'], 'color' => $_POST['vehicleColor'], 'registration' => $_POST['vehicleRegistration'], 'discountType' => $_POST['discountType'], 'discount' => $_POST['discountPercent'], 'payment_type' => $_POST['payment_type'], 'meetup_time' => $_POST['meet'], 'points' => $_POST['parking_points'], 'flight' => $_POST['code'], 'cost' => $_POST['cost']);
if ($_POST['discountType'] == 'Voucher') {
$db->delete('vouchers', 'code = "' . $_POST['code'] . '"');
}
//$emailer->bookingInternalEmail($data);
echo json_encode($emailer->frontdeskEmail($data));
break;
case 'payment_success':
//update booking as as paid and get data for email
$keys = array();
$keys[] = "statii_id";
$values = array();
$values[] = '3';
$row = $db->getRowsByQuery('SELECT * FROM bookings WHERE bookings_id = ' . $_POST['booking_id']);
//if it is an online payment
if ($row["payment_methods_id"] == 3) {
$data = array('firstname' => $row['first_name'], 'lastname' => $row['last_name'], 'email' => $row['email'], 'telephone' => $row['phone'], 'departDate' => $row['depart'], 'arriveDate' => $row['arrive'], 'model' => $row['make'], 'color' => $row['colour'], 'discountType' => $_POST['discount_type'], 'discount' => $_POST['discount_percent'], 'registration' => $row['reg'], 'payment_type' => 'Online Credit Card', 'meetup_time' => $row['meet'], 'points' => $_POST['parking_points'], 'flight' => $_POST['flight'], 'discount' => $_POST['discount_type'], 'cost' => $row['amount']);
$db->update('bookings_id', $_POST['booking_id'], 'i', 'bookings', $keys, $values, 'i');
//confirmation email
$emailer->OnlinePaymentEmail($data);
}
