1, 1, 0)
FROM `book_details` AS `ff5`
LEFT JOIN `book` ON `ff5`.`book_id` = `book`.`id`
WHERE `ff5`.`emplyee_id` = `rmp1`.`id`
AND `book`.`tretment_id` = `ss`.`tretment_id`
AND `ff5`.`status_id` IN (6,8,12,13,14,15)
AND `ff5`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `ff5`.`book_id` GROUP BY `book_details`.`book_id`)
)) AS `repet`
FROM `book_details` AS `ff1`
LEFT JOIN `book` AS `ss` ON `ff1`.`book_id` = `ss`.`id`
WHERE `ff1`.`day_date` LIKE '$today%'
AND `ff1`.`emplyee_id` = `rmp1`.`id`
AND `ff1`.`status_id` IN (6,8,12,13,14,15)
AND `ss`.`tretment_id` IN (SELECT `t`.`id` FROM `tretment` AS `t` WHERE ((`t`.`create_time` BETWEEN '$today-01 03:00:00' AND '$Next-01 02:59:59')))
AND `ff1`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `ff1`.`book_id` GROUP BY `book_details`.`book_id`)
) AS `count`,
(((SELECT
SUM((SELECT
IF(COUNT(`book`.`id`) > 1, 1, 0)
FROM `book_details` AS `ff5`
LEFT JOIN `book` ON `ff5`.`book_id` = `book`.`id`
WHERE `ff5`.`emplyee_id` = `rmp1`.`id`
AND `book`.`tretment_id` = `ss`.`tretment_id`
AND `ff5`.`status_id` IN (6,8,12,13,14,15)
AND `ff5`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `ff5`.`book_id` GROUP BY `book_details`.`book_id`)
AND `book`.`tretment_id` IN (SELECT `t`.`id` FROM `tretment` AS `t` WHERE ((`t`.`create_time` BETWEEN '$today-01 03:00:00' AND '$Next-01 02:59:59')))
)) AS `repet`
FROM `book_details` AS `ff1`
LEFT JOIN `book` AS `ss` ON `ff1`.`book_id` = `ss`.`id`
WHERE `ff1`.`day_date` LIKE '$today%'
AND `ff1`.`emplyee_id` = `rmp1`.`id`
AND `ff1`.`status_id` IN (6,8,12,13,14,15)
AND `ff1`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `ff1`.`book_id` GROUP BY `book_details`.`book_id`)
)/(SELECT
COUNT(`bo2`.`id`) AS `count`
FROM `book_details` AS `ff`
LEFT JOIN `book` AS `bo2` ON `ff`.`book_id` = `bo2`.`id`
WHERE `ff`.`day_date` LIKE '$today%'
AND `ff`.`emplyee_id` = `rmp1`.`id`
AND `ff`.`status_id` IN (6,8,12,13,14,15)
AND `bo2`.`tretment_id` IN (SELECT `t`.`id` FROM `tretment` AS `t` WHERE ((`t`.`create_time` BETWEEN '$today-01 03:00:00' AND '$Next-01 02:59:59')))
AND `ff`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `ff`.`book_id` GROUP BY `book_details`.`book_id`)
))*100) AS `deg`
FROM `book_details` AS `bd`
LEFT JOIN `book` AS `bo1` ON `bd`.`book_id` = `bo1`.`id`
LEFT JOIN `services` ON `bd`.`services_id` = `services`.`id`
LEFT JOIN `emplyee` AS `rmp1` ON `bd`.`emplyee_id` = `rmp1`.`id`
LEFT JOIN `branch` ON `rmp1`.`branch_id` = `branch`.`id`
WHERE `bd`.`day_date` LIKE '$today%'
AND `rmp1`.`occupation_id` = 2
AND `branch`.`commercial_register_id` = 2
AND `bd`.`branch_id` <> 1
AND `bd`.`status_id` IN (6,8,12,13,14,15)
AND `bd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` GROUP BY `book_details`.`book_id`)
AND `bo1`.`tretment_id` IN (SELECT `t`.`id` FROM `tretment` AS `t` WHERE ((`t`.`create_time` BETWEEN '$today-01 03:00:00' AND '$Next-01 02:59:59')))
GROUP BY `rmp1`.`id`
ORDER BY `deg` DESC");
$count = 1;
while ($get_book_details = mysqli_fetch_assoc($get_book_details_sql)) {
?>