static function createResrvationByAdmin()
{
$today = date("Y-m-d");
$hours_id = $_POST['hours_id'];
$name = $_POST['name'];
$tel = $_POST['telefon'];
$date = $_POST['date'];
$directionID = $_POST['directionID'];
$email = $_POST['email'];
$adminReserve = $_POST['adminReserve'];
$reserve_type = $_POST['reserve_type'];
$instructor_id = $_POST['instructor_id'];
$choosen_places = $_POST['choosen_places'];
$language = $_POST['language'];
$directionField = "directions_" . $_POST['language'] . "_id";
Dispatcher::$mysqli->query("insert into person(`name`, telefone, password, email, `permission`) " . "values('{$name}', '{$tel}', 'admin', '{$email}', 'client')");
$client_id = Dispatcher::$mysqli->insert_id;
Dispatcher::$mysqli->query("insert into reservation(`date`, `Person_id`) values ('{$today}', {$client_id})");
$reservation_id = Dispatcher::$mysqli->insert_id;
$hoursCursor = Dispatcher::$mysqli->query("select *, reservation_has_hours.{$directionField} as dirID " . "from hours_to_display join reservation_has_hours " . "on hours_to_display.id=reservation_has_hours.hours_id where hours_to_display.id={$hours_id}");
print_r(Dispatcher::$mysqli->error);
$hoursRow[0] = $hoursCursor->fetch_assoc();
$hoursRow[0]['choosen_places'] = $choosen_places;
$hoursRow[0]['dirID'] = $directionID;
$hoursRow[0]['hours_id'] = $hours_id;
MainController::booking_create_reservation_summary($reservation_id, $client_id, $date, $hoursRow, $reserve_type);
if ($reserve_type == "tourists") {
MainController::send_email_to_toursit_client($reservation_id, 0);
} else {
if ($reserve_type == "slevomat") {
MainController::send_email_to_client($reservation_id, 1);
}
}
}
