static function send_email_to_toursit_client($reservation_id, $vouchers_state) { $reservation = self::get_reservation_by_id($reservation_id); $our_email = '*****@*****.**'; $to = $reservation['client_email']; $subject = "SEGWAY reservation"; $body = ""; $body .= '<div style="width: 500px; border: 1px solid; padding: 30px;"> <table style="width: 100%;"> <tr><th style="width: 400px;">Name: </th><td style="width: 400px;">' . $reservation['client_name'] . '</td></tr> <tr><th style="width: 400px;">Email:</th><td style="width: 400px;"> ' . $reservation['client_email'] . '</td></tr> <tr><th style="width: 400px;">Phone: </th><td style="width: 400px;">' . $reservation['client_telefon'] . '</td></tr> <tr><th style="width: 400px;">Date of reservation: </th><td style="width: 400px;">' . $reservation['reservation_date'] . '</td></tr> </table> <br><br>'; $body .= '<div class="events_wrapper">'; for ($j = 0; $j < count($reservation['event']); $j++) { $body .= '<div style="border: 1px solid; padding: 10px; margin-bottom: 15px;"> <table style="width: 100%;"> <tr><th style="width: 400px;">Event date: </th><td style="width: 400px;">' . $reservation['event'][$j]['date'] . '</td></tr> <tr><th style="wid th: 400px;">Direction: </th><td style="width: 400px;">' . $reservation['event'][$j]['direction'] . '</td></tr> <tr><th style="width: 400px;">Time: </th><td style="width: 400px;">' . $reservation['event'][$j]['hours'] . '</td></tr> <tr><th style="width: 400px;">Places: </th><td style="width: 400px;">' . $reservation['event'][$j]['choosen_places'] . '</td></tr> </table></div>'; } $body .= '</div> </div>'; Dispatcher::send_email($to, $subject, $body); $instructors_array = instructorController::getInstructors(); $to = $instructors_array[0]['email']; $subject = "SEGWAY tourist reservation"; $body = ""; $body .= '<div style="width: 500px; border: 1px solid; padding: 30px;"> <table style="width: 100%;"> <tr><th style="width: 400px;">Name: </th><td style="width: 400px;">' . $reservation['client_name'] . '</td></tr> <tr><th style="width: 400px;">Email:</th><td style="width: 400px;"> ' . $reservation['client_email'] . '</td></tr> <tr><th style="width: 400px;">Phone: </th><td style="width: 400px;">' . $reservation['client_telefon'] . '</td></tr> <tr><th style="width: 400px;">Reservation date: </th><td style="width: 400px;">' . $reservation['reservation_date'] . '</td></tr> </table> <br><br>'; $body .= '<div class="events_wrapper">'; for ($j = 0; $j < count($reservation['event']); $j++) { $body .= '<div style="border: 1px solid; padding: 10px; margin-bottom: 15px;"> <table style="width: 100%;"> <tr><th style="width: 400px;">Event date: </th><td style="width: 400px;">' . $reservation['event'][$j]['date'] . '</td></tr> <tr><th style="wid th: 400px;">Direction: </th><td style="width: 400px;">' . $reservation['event'][$j]['direction'] . '</td></tr> <tr><th style="width: 400px;">Time: </th><td style="width: 400px;">' . $reservation['event'][$j]['hours'] . '</td></tr> <tr><th style="width: 400px;">Choosen places: </th><td style="width: 400px;">' . $reservation['event'][$j]['choosen_places'] . '</td></tr> </table></div>'; } $body .= '</div> </div>'; // Dispatcher::send_email($to, $subject, $body); // Dispatcher::send_email("*****@*****.**", $subject, $body); }
static function changeInstructor() { $instructor_id = $_POST['instructor_id']; $prev_instructor_id = $_POST['prev_instructor_id']; $hour_id = $_POST['hour_id']; $hour_create_type = $_POST['hour_create_type']; $clicked_create_type = $_POST['clicked_create_type']; $date = $_POST['date']; if ($hour_create_type == "Date") { Dispatcher::$mysqli->query("update instructor_has_hours set " . "instructor_id={$instructor_id} where " . "instructor_id={$prev_instructor_id} and hours_id={$hour_id}"); } else { if ($hour_create_type == "Default") { $cursor = Dispatcher::$mysqli->query("select * from custom_intsructor where " . "create_type='Default' and date='{$date}' and hours_id={$hour_id} and instructor_id={$prev_instructor_id}"); if ($cursor->num_rows > 0) { Dispatcher::$mysqli->query("update custom_intsructor set " . "instructor_id={$instructor_id} where " . "instructor_id={$prev_instructor_id} " . "and hours_id={$hour_id} and create_type='Default' and date='{$date}'"); } else { Dispatcher::$mysqli->query("insert into custom_intsructor(instructor_id, hours_id, create_type, date) " . "values ({$instructor_id}, {$hour_id}, 'Default', '{$date}')"); } print_r(Dispatcher::$mysqli->error); } else { if ($hour_create_type == "Weekday") { echo '<br><br>' . $date . " " . $hour_id . " " . $prev_instructor_id . " in dateHours<br><br>"; $cursor = Dispatcher::$mysqli->query("select * from custom_intsructor where " . "date='{$date}' and hours_id={$hour_id} and instructor_id={$prev_instructor_id}"); if ($cursor->num_rows > 0) { Dispatcher::$mysqli->query("update custom_intsructor set " . "instructor_id={$instructor_id} where " . "instructor_id={$prev_instructor_id} " . "and hours_id={$hour_id} and date='{$date}'"); } else { Dispatcher::$mysqli->query("insert into custom_intsructor(instructor_id, hours_id, create_type, date) " . "values ({$instructor_id}, {$hour_id}, '', '{$date}')"); } } } } print_r(Dispatcher::$mysqli->error); $hoursInfo = HoursController::getHoursById($hour_id); $instructorInfo = instructorController::getInstructorByID($instructor_id); $prevInsrtuctorInfo = instructorController::getInstructorByID($prev_instructor_id); $reservationsInfo = reservationController::getResevationsByDateHour($date, $hoursInfo); $calendarEventController = new InstructorCalendarEvents(); $calendarEventController->addInstructorCalendarEvent($reservationsInfo, $instructorInfo, $prevInsrtuctorInfo, $hoursInfo); }
clientsTable(CalendarController::getDateHoursReservations()); } if ($action == 'booking_add_instructor') { instructorController::addInstructor(); } if ($action == 'booking_edit_instructor') { instructorController::editInstructor(); } if ($action == 'booking_remove_instructor') { instructorController::removeInstructor(); } if ($action == 'booking_change_instructor') { instructorController::changeInstructor(); } if ($action == 'booking_change_instructor_color') { instructorController::changeColor(); } if ($action == 'addVoucherInfo') { $name = $_POST['name']; $variant = $_POST['variant']; $variant_api = $_POST['variant_api']; $price_czk = $_POST['price_czk']; $price_eur = $_POST['price_eur']; $places = $_POST['places']; $reserve_type = $_POST['reserve_type']; voucherController::addVoucherInfo($name, $variant, $variant_api, $price_czk, $price_eur, $places, $reserve_type); } if ($action == "booking_check_voucher") { $voucherCode = $_POST['voucherCode']; $voucher_index = $_POST['voucherCount']; $voucherController = new voucherController();
<?php require_once "../core/core.inc"; require_once "../core/view.php"; //$days_array = Dispatcher::get_days_info(); $instructors_array = instructorController::getInstructors(); ?> <div class="modal fade" id="add-instructors-modal" tabindex="-1" role="dialog" aria-labelledby="instructors-modal" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content timetable-modal-content"> <div class="modal-header timetable-modal-header"> <button type="button" class="global-close" data-dismiss="modal" aria-hidden="true">×</button> <!--<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>--> <div class="modal-title" id="myModalLabel">Instructors</div> </div> <div class="modal-body timetable-modal-body"> <button id="add-instructor-btn" class="add-instructor-btn popover-dismiss" data-placement="bottom"> <span class="add_instructor_plus"></span><span class="add-instructor-label">Add instuctor</span> </button> <!-- <button id="add-instructor-btn" type="button" data-placement="bottom" class="add-instructor-btn popover-dismiss btn btn-default btn-lg"> <span class="glyphicon glyphicon-plus-sign"></span> Add instuctor </button>--> <!--<input type="text" name='instructor-name' value=""/>--> <table class="list-of-instructors"> <?php get_instructors_view($instructors_array); ?>
function booking_hours_table_view($date, $result, $type, $action, $default_hours, $type_index, $create_type) { $vouchers_info_array = Dispatcher::booking_get_booking_info("slevomat", ""); $booking_info_array = Dispatcher::booking_get_booking_info("tourists", ""); $instructor_info_array = instructorController::getInstructors(); $directions_info = MainController::getDirInfo(); // MainController::printArray($result); if ($type == "morning") { ?> <td class="tours_wrapper_table_left_td"> <?php } if ($type == "evening") { ?> <td class="tours_wrapper_table_right_td"> <?php } ?> <table class="<?php echo $type; ?> _tours"> <tbody> <?php $lang = "en"; for ($i = 0; $i < count($result); $i++) { if ($result[$i]['display'] == 1) { if ($result[$i]['reserve_type'] == "" || $result[$i]['reserve_type'] == "tourists") { $slevomat_checked = ""; $tourists_checked = "checked"; } else { $slevomat_checked = "checked"; $tourists_checked = ""; } if ($result[$i]['create_type'] == 'default') { $default_hours = true; } else { $default_hours = false; } ?> <tr id="row_<?php echo $result[$i]['hourID']; ?> "> <td> <?php if ($result[$i]['create_type'] == "Date" || $result[$i]['has_changes'] == 1) { ?> <div class="day-contents-has-changes"></div> <?php } ?> </td> <?php if ($create_type == "Date") { ?> <td width="5px"></td> <td class="hours_td"><?php echo $result[$i]['free_places']; ?> </td> <?php } ?> <td width="5px"></td> <td class="reserve-admin-plus"> <?php if ($create_type == "Date" && $result[$i]['choosen_places'] < $result[$i]['max_places'] && Date($date) >= Date("Y-m-d")) { ?> <button onclick="get_free_places_qty()" id="add-<?php echo $type; ?> -reserve-plus-<?php echo $result[$i]['hourID']; ?> " class="create_reserve_plus morning_class popover-dismiss" data-placement="bottom" data-title="Create reservation" data-date="" data-weekday="" data-action="create_reserve" data-content="<?php get_create_reserve_btn_view($result, $type, $i, $directions_info, $booking_info_array, $action, $tourists_checked, $slevomat_checked, $type_index); ?> "> </button> <?php } ?> </td> <td width="5px"></td> <td class="reserve-type-label"> <?php if ($result[$i]['reserve_type'] == "" || $result[$i]['reserve_type'] == "tourists") { ?> <span class="reserve-type-label-inner label label-warning" data-toggle="tooltip" data-placement="top" title="Tourists">T</span> <?php } else { ?> <span class="reserve-type-label-inner label label-info" data-toggle="tooltip" data-placement="top" title="Slevomat">S</span> <?php } ?> </td> <td> <span class="label label-during-type" data-toggle="tooltip" data-placement="top" title="Voucher type"><?php echo $result[$i]['variant']; ?> </span> </td> <td width="5px"></td> <?php $disabled = ""; if ($result[$i]['reserve_type'] == "slevomat") { } if (($result[$i]['create_type'] == 'Default' || $result[$i]['create_type'] == "Weekday") && $create_type == "Date" || $result[$i]['create_type'] == "Default" && $create_type == "Weekday") { $act = "default"; $disabled = "disabled"; } else { if ($result[$i]['create_type'] == 'Default' && $create_type == "Default") { $act = "default"; $disabled = ""; } else { $act = "date"; } } ?> <?php if ($result[$i]['state'] == 0) { ?> <td> <input id="<?php echo $type; ?> _tours_checkbox_<?php echo $i; ?> " type="checkbox" onchange="change_hour_state(this, '<?php echo $type; ?> ', '<?php echo $result[$i]['hourID']; ?> ', '<?php echo $lang; ?> ', '<?php echo $i; ?> ', '<?php echo $create_type; ?> ', '<?php echo $result[$i]['create_type']; ?> ');"> </td> <?php } else { if ($result[$i]['state'] == 1) { ?> <td> <input id="<?php echo $type; ?> _tours_checkbox_<?php echo $i; ?> " type="checkbox" checked="on" onchange="change_hour_state(this, '<?php echo $type; ?> ', '<?php echo $result[$i]['hourID']; ?> ', '<?php echo $lang; ?> ', '<?php echo $i; ?> ', '<?php echo $create_type; ?> ', '<?php echo $result[$i]['create_type']; ?> ');"> </td> <?php } } ?> <td width="10px"></td> <?php if ($result[$i]['state'] == 1) { ?> <td id="<?php echo $type; ?> -hours-id-<?php echo $i; ?> " class="hours_td"> <?php echo $result[$i]["hours"]; ?> </td> <?php // echo $result[$i]['hourState'] . '<br>'; } else { if ($result[$i]['state'] == 0) { ?> <td id="<?php echo $type; ?> -hours-id-<?php echo $i; ?> " class="hours_td inactive"> <?php echo $result[$i]["hours"]; ?> </td> <?php } } ?> <td> <button id="choose-instructor-<?php echo $type; ?> -tours-hour-btn-<?php echo $i; ?> " class="btn btn-xs label-during-type choose-instructor-tours-hour-btn" data-placement="bottom" title="Choose instructor" data-reserve-type="<?php echo $result[$i]['reserve_type']; ?> " data-create-type="<?php echo $result[$i]['create_type']; ?> " data-action="<?php echo $action; ?> " data-hour-type="<?php echo $type; ?> " data-date="<?php echo $date; ?> " data-weekday="<?php echo $result[$i]['weekday']; ?> " data-content="<?php get_choose_instructor_btn_view($result, $type, $i, $instructor_info_array, $create_type); ?> " style="cursor: pointer; background-color: <?php echo $result[$i]['color']; ?> ; color: <?php echo $result[$i]['color']; ?> ;"> </button> <button id="edit-<?php echo $type; ?> -tours-hour-btn-<?php echo $i; ?> " type="button" class="btn btn-default btn-xs edit-tours-hour-btn popover-dismiss" data-placement="bottom" data-title="Edit hours" data-toggle="tooltip" data-reserve-type="<?php echo $result[$i]['reserve_type']; ?> " title="Edit" data-create-type="<?php echo $result[$i]['create_type']; ?> " data-action="<?php echo $action; ?> " data-hour-type="<?php echo $type; ?> " data-date="<?php echo $date; ?> " data-weekday="<?php echo $result[$i]['weekday']; ?> " data-content="<?php get_edit_hour_btn_view($result, $type, $i, $vouchers_info_array, $booking_info_array, $action, $tourists_checked, $slevomat_checked, $type_index, $directions_info); ?> "> <span class="glyphicon glyphicon-pencil"></span> </button> <button onclick="remove_hours('<?php echo $date; ?> ', '<?php echo $result[$i]['weekday']; ?> ', '<?php echo $type; ?> ', <?php echo $result[$i]['hourID']; ?> , 'en', '<?php echo $result[$i]['create_type']; ?> ');" type="button" class="btn btn-default btn-xs remove-tours-hour-btn" data-toggle="tooltip" <?php echo $disabled; ?> title="Remove" data-weekday="<?php echo $result[$i]['weekday']; ?> "> <span class="glyphicon glyphicon-trash"></span> </button> </td> </tr> <!--</td><td width="40px"></td></tr>--> <?php } } ?> </tbody> </table> <div id="current-date" style="display: none;"><?php echo $date; ?> </div> <!-- <div class='add-hours-reserve-type'> <div class='slevomat-radio-input'><input type='radio' name='slevomat'/>Slevomat</div> <div class='tourists-radio-input'><input name='toutists' type='radio'/>Tourists</div> </div>--> </td> <script> $(document).ready(function () { popupInitialize(); }); </script> <?php }
static function changeInstructor() { $instructor_id = $_POST['instructor_id']; $prev_instructor_id = $_POST['prev_instructor_id']; $hour_id = $_POST['hour_id']; $hour_create_type = $_POST['hour_create_type']; $clicked_create_type = $_POST['clicked_create_type']; $weekday = $_POST['weekday']; $modul = $_POST['modul']; if ($clicked_create_type == $hour_create_type) { Dispatcher::$mysqli->query("update instructor_has_hours set " . "instructor_id={$instructor_id} where " . "instructor_id={$prev_instructor_id} and hours_id={$hour_id}"); } if ($clicked_create_type == "Default") { $cursor = Dispatcher::$mysqli->query("select * from custom_intsructor where " . "weekday='{$weekday}' and hours_id={$hour_id} and instructor_id={$prev_instructor_id}"); if ($cursor->num_rows > 0) { Dispatcher::$mysqli->query("update custom_intsructor set " . "instructor_id={$instructor_id} where " . "instructor_id={$prev_instructor_id} and hours_id={$hour_id}"); } else { Dispatcher::$mysqli->query("insert into custom_intsructor(instructor_id, hours_id, weekday) " . "values ({$instructor_id}, {$hour_id}, '{$weekday}')"); } print_r(Dispatcher::$mysqli->error); } $weekdayDates = $_POST['weekdayDates']; $hoursInfo = HoursController::getHoursById($hour_id); $instructorInfo = instructorController::getInstructorByID($instructor_id); $previnstructorInfo = instructorController::getInstructorByID($prev_instructor_id); for ($i = 0; $i < count($weekdayDates); $i++) { // $_POST['date'] = $weekdayDates[$i]; $reservationsInfo = reservationController::getResevationsByDateHour($weekdayDates[$i], $hoursInfo); // MainController::printArray($reservationsInfo); $calendarEventController = new InstructorCalendarEvents(); $calendarEventController->addInstructorCalendarEvent($reservationsInfo, $instructorInfo, $previnstructorInfo, $hoursInfo); } print_r(Dispatcher::$mysqli->error); }