alert('حدث خطا');
window.location.href = 'index.php';
";
}
$get_book_sql = mysqli_query($db, "SELECT
`bd`.`day_date`,
`bd`.`day_time`,
`tretment`.`name` AS `tr_name`,
`tretment`.`number`,
`services`.`id` AS `serv_id`,
`emplyee`.`id`,
`emplyee`.`name`,
`book`.`notes`,
`branch`.`branch_name`,
`bd`.`status_id`
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`
LEFT JOIN `branch` ON `bd`.`emplyee_id` = `branch`.`id`
WHERE `book`.`id`='$booking_id'
AND `bd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id`='$booking_id' GROUP BY `book_details`.`book_id`)
LIMIT 1"
);
$get_emplyee_sql = mysqli_query($db, "SELECT `branch`.`id` AS `br_id`, `branch`.`branch_name` AS `br_name`, `emplyee`.`id`,`emplyee`.`name` FROM `occupation`
LEFT JOIN `emplyee` ON `emplyee`.`occupation_id` = `occupation`.`id`
LEFT JOIN `branch` ON `emplyee`.`branch_id` = `branch`.`id`
WHERE `occupation`.`show_in_table_id` = 2
AND `branch`.`commercial_register_id` = $commercial_register_id
AND `emplyee`.`activation_id` = 2
ORDER BY `branch`.`id`, `emplyee`.`name`");
$get_book = mysqli_fetch_assoc($get_book_sql);
$go_out = array(1,2,3,12,13,14,15,16,17,18,19,20,21,22,23,24,25);
if (mysqli_num_rows($get_book_sql) != 1 || in_array($get_book['status_id'], $go_out)) {
echo "
";
}
if ((strtotime($today)) > strtotime($get_book['day_date'])) {
echo "
";
}
?>