author: christian osterrieder alpstein-austria
*/
//header einfuegen:
include_once $root . "/backoffice/templates/header.inc.php";
include_once $root . "/include/mietobjektFunctions.inc.php";
include_once $root . "/include/vermieterFunctions.inc.php";
include_once $root . "/include/datumFunctions.inc.php";
include_once $root . "/include/reservierungFunctions.inc.php";
include_once $root . "/templates/constants.inc.php";
include_once $root . "/backoffice/reservierung/tagesuebersicht.php";
include_once $root . "/include/oeffnungszeitenFunktions.inc.php";
include_once $root . "/include/buchungseinschraenkung.inc.php";
//soll eine reservierung entfernt werden?
if (isset($_POST["doDeleteReservierung"]) && isset($_POST["reservierung_id"])) {
$reservierung_id = $_POST["reservierung_id"];
deleteReservation($reservierung_id);
}
//muss die reservierung veraendert werden?
if (isset($_POST["doChangeReservation"])) {
$reservierung_id = $_POST["reservierung_id"];
$bisMinute = $_POST["bisMinute"];
$vonMinute = $_POST["vonMinute"];
$vonStunde = $_POST["vonStunde"];
$bisStunde = $_POST["bisStunde"];
$tisch_id = $_POST["table_id"];
$raum_id = $_POST["raum_id"];
$datumVon = $_POST["datumVon"];
$tag = getTagFromDatePicker($datumVon);
$monat = getMonatFromDatePicker($datumVon);
$jahr = getJahrFromDatePicker($datumVon);
changeReservationTime($reservierung_id, $tisch_id, $vonMinute, $vonStunde, $bisMinute, $bisStunde, $tag, $monat, $jahr);
/**
* @author coster
* deletes all reservation before the current date minus $xDays
* @param $xDays
* @param $state the state of the reservation
*/
function deleteReservationsBeforeXDays($xDays, $state)
{
global $link;
//db link
$date = mktime(0, 0, 0, date("m"), date("d") - $xDays, date("Y"));
//generate mysql timestamp format:
$date = date("Y-m-d H:i:s", $date);
$res = getReservationsBefore($date, $state);
while ($d = mysqli_fetch_array($res)) {
$id = $d["PK_ID"];
deleteReservation($id, $link);
}
}
}
include_once "include_globalVars.php";
include_once "inschrijving_methods.php";
setlocale(LC_TIME, 'nl_NL');
$bisdblink = mysql_connect($database_host, $database_user, $database_pass);
if (!mysql_select_db($database, $bisdblink)) {
echo "Fout: database niet gevonden.<br>";
exit;
}
if (isset($_GET['del'])) {
$id = $_GET['id'];
$date = $_GET['date'];
$start_time = $_GET['start_time'];
$cat_to_show = $_GET['cat_to_show'];
$grade_to_show = $_GET['grade_to_show'];
$result = deleteReservation($id);
echo json_encode($result);
}
if (isset($_GET['make'])) {
$id = $_GET['id'];
$boat_id = $_GET['boat_id'];
$pname = $_GET['pname'];
$name = $_GET['name'];
$email = $_GET['email'];
$mpb = $_GET['mpb'];
$date = $_GET['date'];
$start_time_hrs = $_GET['start_time_hrs'];
$start_time_mins = $_GET['start_time_mins'];
$end_time_hrs = $_GET['end_time_hrs'];
$end_time_mins = $_GET['end_time_mins'];
$ergo_lo = $_GET['ergo_lo'];
// ONLY dd-mm-yyyy OR mm/dd/yyyy are recognized correctly
$lastday = date('z', strtotime('1-10-' . $year) - 1);
} else {
$firstday = date('z', strtotime('01-06-' . $year));
$lastday = date('z', strtotime('1-10-' . $year));
}
$today = date('z') - $firstday;
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
$username = "******";
$password = "******";
$hostname = "localhost";
$dbhandle = mysqli_connect($hostname, $username, $password) or die("Impossibile connettersi al server. Contatta il webmaster (Codice C1))");
$selected = mysqli_select_db($dbhandle, "6786_prenotazioni") or die("Errore di connessione al server. Contatta il webmaster (Codice D1)");
try {
if (isset($_POST['delbooking'])) {
deleteReservation($dbhandle, (int) $_POST['prenid']);
} else {
if (isset($_POST['newbooking'])) {
$last_prenid = makeReservation($dbhandle, $year);
$open = 1;
} else {
updateReservation($dbhandle, (int) $_POST['prenid'], $year);
$last_prenid = (int) $_POST['prenid'];
}
}
} catch (Exception $e) {
$error = true;
$error_message = $e->getMessage();
}
}
// *************** MAKE RESERVATION *******************************
if (checkPass($benutzername, $passwort, $unterkunft_id, $link)) {
?>
<p class="standardSchriftBold"><?php
echo getUebersetzung("Reservierungsanfragen von Gästen löschen", $sprache, $link);
?>
</p>
<?php
$gast_id = "";
$vonDatum = "";
$bisDatum = "";
foreach ($reservierungen as $res_id) {
$vonDatum = getDatumVon($res_id, $link);
$bisDatum = getDatumBis($res_id, $link);
$gast_id = getGastID($res_id, $link);
$zimmer_id = getZimmerID($res_id, $link);
deleteReservation($res_id, $link);
//wenn room child rooms hat auch diese löschen:
$resu = getChildRooms($zimmer_id);
if (!empty($resu)) {
while ($d = mysqli_fetch_array($resu)) {
$child = $d['PK_ID'];
deleteReservationWithDate($child, $vonDatum, $bisDatum, $link);
}
}
}
if ($gastEntfernen == "true") {
//gast soll auch gelöscht werden:
$query = "SELECT\n\t\t\t\t\t\t\tFK_Gast_ID\n\t\t\t\t\t\t FROM\t\n\t\t\t\t\t \t\tRezervi_Reservierung\n\t\t\t\t\t \t\tWHERE\n\t\t\t\t\t \t\tFK_Gast_ID = '{$gast_id}'\n\t\t\t\t\t \t ";
$res = mysqli_query($link, $query);
if (!$res) {
echo "die Anfrage {$query} scheitert";
function handleDeleteRequest($data)
{
$res_id = $data['res_id'];
$response = deleteReservation($res_id);
sendResponse(200, json_encode($response), 'application/json');
}
define('_MEXEC', 'OK');
require_once "../../system/load.php";
$action = $_REQUEST['action'];
switch ($action) {
case "viewReservations":
viewReservations();
break;
case "addReservation":
addReservation();
break;
case "updateCategory":
updateCategory();
break;
case "deleteReservation":
deleteReservation();
break;
case "onlinePayment":
onlinePayment();
break;
}
function viewReservations()
{
$reservation = new Reservations();
$data = $reservation->getAllReservationsPaginated($_REQUEST['page']);
$count = $reservation->getAllReservationsCount();
viewTable($data, $count[0]['count']);
}
function addReservation()
{
$reservation = new Reservations();
*/
if (isset($_GET['resid'])) {
$resid = $_GET['resid'];
} else {
if (isset($_POST['resid'])) {
$resid = $_POST['resid'];
if (isset($_POST['action'])) {
$action = $_POST['action'];
if ($action == "checkout") {
checkOutReservation($resid);
} else {
if ($action == "checkin") {
checkInReservation($resid);
} else {
if ($action == "delete") {
deleteReservation($resid);
} else {
if ($action == "update") {
updateReservationStatus($resid, $_POST['status']);
}
}
}
}
}
}
}
/*
Get the information of this reseravtion, the user, and the equipment involved.
*/
$page = "";
if (isset($_POST['action']) && $_POST['action'] != "delete" || !isset($_POST['action'])) {
