38 lines
1.1 KiB
PHP
Executable File
38 lines
1.1 KiB
PHP
Executable File
<?php
|
|
$get_tretment_details_sql_state2 = mysqli_query($db,
|
|
"SELECT
|
|
`bd`.`day_date`,
|
|
`bd`.`day_time`,
|
|
`bd`.`branch_id`,
|
|
`bd`.`emplyee_id`,
|
|
`bd`.`status_id`,
|
|
`bd`.`date_time`,
|
|
`bd`.`book_id`,
|
|
`services`.`name`,
|
|
`book`.`id` AS `mom`,
|
|
`book`.`tretment_id`,
|
|
`book`.`notes`,
|
|
`book`.`date_time` AS `user_date`,
|
|
`user`.`name` AS `user_book`,
|
|
`tretment`.`name` AS `tr_name`,
|
|
`tretment`.`number`
|
|
|
|
FROM `book_details` AS `bd`
|
|
|
|
LEFT JOIN `book` ON `bd`.`book_id` = `book`.`id`
|
|
LEFT JOIN `tretment` ON `book`.`tretment_id` = `tretment`.`id`
|
|
LEFT JOIN `user` ON `book`.`user_id` = `user`.`id`
|
|
LEFT JOIN `services` ON `bd`.`services_id` = `services`.`id`
|
|
LEFT JOIN `emplyee` ON `bd`.`emplyee_id` = `emplyee`.`id`
|
|
|
|
WHERE `emplyee`.`activation_id`=2
|
|
AND `bd`.`day_date` = '$Next'
|
|
AND `bd`.`day_time` <= '$how_many_left'
|
|
AND `bd`.`emplyee_id`='$emp_id'
|
|
AND `bd`.$branch_sql
|
|
AND `bd`.`status_id` NOT IN (25,26)
|
|
AND `bd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` GROUP BY `book_details`.`book_id`)
|
|
GROUP BY `bd`.`day_time`
|
|
ORDER BY `bd`.`day_time`, `bd`.`date_time`
|
|
");
|
|
?>
|