73 lines
2.7 KiB
PHP
Executable File
73 lines
2.7 KiB
PHP
Executable File
<?php
|
|
require_once('../../../fixed/config/go_con.php');
|
|
|
|
$tretment_id = mysqli_real_escape_string($db, $_POST['tretment_id']);
|
|
$num = mysqli_real_escape_string($db, $_POST['num']);
|
|
|
|
$today = date("Y-m-d");
|
|
if (!empty($_GET['date'])) {
|
|
$today = $_GET['date'];
|
|
if (DateTime::createFromFormat('Y-m-d', $today) == false) {
|
|
$today = date("Y-m-d");
|
|
}
|
|
}
|
|
|
|
if (!empty($tretment_id) && !empty($num)) {
|
|
$get_my_books_sql = mysqli_query($db,
|
|
"SELECT
|
|
`bd`.`id`,
|
|
`bd`.`day_date`,
|
|
`bd`.`day_time`,
|
|
RIGHT(`bd`.`number`,2) AS `last_2_num`
|
|
FROM `books_for_table` AS `bd`
|
|
WHERE `bd`.`emplyee_id`='$admin_emp_id'
|
|
AND `bd`.`status_id` IN (6, 8)
|
|
AND `bd`.`day_date` > '2024-04-30'
|
|
AND `bd`.`day_date` <= '$today'
|
|
GROUP BY `bd`.`day_time`
|
|
ORDER BY `bd`.`day_time` ASC, `bd`.`date_time`
|
|
LIMIT 1
|
|
");
|
|
|
|
$get_my_books = mysqli_fetch_assoc($get_my_books_sql);
|
|
|
|
if ($get_my_books['last_2_num'] == $num) {
|
|
$get_my_books_id = $get_my_books['id'];
|
|
$get_day_date = $get_my_books['day_date'];
|
|
$get_day_time = $get_my_books['day_time'];
|
|
if ((strtotime($date_time) + (3600*2)) > strtotime($get_day_date .' '. $get_day_time)) {
|
|
mysqli_query(
|
|
$db,
|
|
"INSERT INTO `book_details`(`day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `notes`, `status_id`, `user_id`, `activation_id`, `date_time`, `book_id`)
|
|
SELECT `day_date`, `day_time`, `services_id`, `branch_id`, `emplyee_id`, `notes`, '14', '$admin_id', '2', '$date_time', `book_id`
|
|
FROM `book_details`
|
|
WHERE `id` = $get_my_books_id
|
|
");
|
|
echo "
|
|
<script>
|
|
window.location.href = '../my_work'
|
|
</script>
|
|
";
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('تنبية', 'لم يتم خدمة العميل في الوقت المحدد', 'warning');
|
|
</script>
|
|
";
|
|
}
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('حدث خطأ', 'آخر رقمين غير مطابق', 'error');
|
|
</script>
|
|
";
|
|
}
|
|
} else {
|
|
echo "
|
|
<script>
|
|
swalfun('حدث خطأ', 'يرجى التحقق من تعبئة الحقول', 'error');
|
|
</script>
|
|
";
|
|
}
|
|
?>
|