70 lines
2.1 KiB
PHP
Executable File
70 lines
2.1 KiB
PHP
Executable File
<?php
|
|
require_once('fixed/config/go_con.php');
|
|
access(39);
|
|
|
|
$google_translate = true;
|
|
|
|
$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");
|
|
}
|
|
}
|
|
|
|
$get_my_books_sql = mysqli_query($db,
|
|
"SELECT
|
|
`bd`.`day_date`,
|
|
`bd`.`day_time`,
|
|
`bd`.`emplyee_id`,
|
|
`bd`.`status_id`,
|
|
`bd`.`date_time`,
|
|
`bd`.`book_id`,
|
|
`bd`.`name`,
|
|
`bd`.`tr_name`,
|
|
`services`.`minimum`,
|
|
`bd`.`tretment_id`
|
|
FROM `books_for_table` AS `bd`
|
|
INNER JOIN `book_details` ON `book_details`.`id` = `bd`.`id`
|
|
INNER JOIN `services` ON `book_details`.`services_id` = `services`.`id`
|
|
WHERE `bd`.`emplyee_id`='$admin_emp_id'
|
|
AND `bd`.`status_id` IN (14)
|
|
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
|
|
");
|
|
if (mysqli_num_rows($get_my_books_sql) > 0) {
|
|
$get_my_books = mysqli_fetch_assoc($get_my_books_sql);
|
|
require_once('work/files/my_work/step_2/1.php');
|
|
} else {
|
|
$get_my_books_sql = mysqli_query($db,
|
|
"SELECT
|
|
`bd`.`day_date`,
|
|
`bd`.`day_time`,
|
|
`bd`.`emplyee_id`,
|
|
`bd`.`status_id`,
|
|
`bd`.`date_time`,
|
|
`bd`.`book_id`,
|
|
`bd`.`name`,
|
|
`bd`.`tr_name`,
|
|
`bd`.`tretment_id`
|
|
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);
|
|
require_once('work/files/my_work/step_1/1.php');
|
|
}
|
|
|
|
|
|
|
|
?>
|