$values[] = Utils::truncate(Utils::insertStrip($flight), 255);
// doesn't have seconds
$values[] = $depart . ":00";
$values[] = $arrive . ":00";
$values[] = $suggested_time_datetime->getString();
$values[] = $payment_methods_id;
$values[] = $statii_id;
$types = "sssssssssssii";
$insertResult = $db->insert("bookings", $keys, $values, $types);
$submitSuccess = $insertResult;
if ($insertResult === false) {
$error = "Could not request booking";
} else {
$message = "Your booking has been requested. Please check your email ({$email}) for confirmation.";
$iid = $db->insertID();
$emailConfirmResult = BookingsHelper::sendConfirmationEmails($db, $iid, $email);
$message .= !$emailConfirmResult ? " Could not send confirmation email - please email " . Constants::EMAIL_INFO . " with your booking id: {$iid}." : "";
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$values[] = Utils::truncate(Utils::insertStrip($colour), 255);
$values[] = Utils::truncate(Utils::insertStrip($flight), 255);
// doesn't have seconds
$values[] = $depart . ":00";
$values[] = $arrive . ":00";
$values[] = substr($depart, 0, strpos($depart, ' ') + 1) . $suggested_time . ":00";
$values[] = $payment_methods_id;
$values[] = $statii_id;
$values[] = Utils::truncate(Utils::insertStrip($parking_points), 8);
$types = "sssssssssssssiis";
if ($clone) {
$insertResult = $db->insert("bookings", $keys, $values, $types);
if ($insertResult === false) {
$error = "Could not insert cloned booking. The server said: " . $db->error();
} else {
$emailConfirmResult = BookingsHelper::sendConfirmationEmails($db, $db->insertID(), $email);
if ($emailConfirmResult === false) {
$error = "Edited successfully but could not send confirmation emails.";
} else {
header("Location: report_time.php");
}
header("Location: report_search.php");
}
} else {
$updateResult = $db->update("bookings_id", $bid, "i", "bookings", $keys, $values, $types);
if ($updateResult === false) {
$error = "Could not update booking. The server said: " . $db->error();
} else {
header("Location: report_time.php");
}
}