'.$branch_id;
}
$data = array();
$get_book_details_sql = mysqli_query($db,
"SELECT
`emplyee`.`id`,
`emplyee`.`name`,
`bd`.`status_id`,
`book`.`id` AS `book_id`,
`services`.`id` AS `count`,
`services`.`id` AS `services_id`,
`book`.`tretment_id` AS `tretment_id`
FROM `book_details` AS `bd`
LEFT JOIN `book` ON `bd`.`book_id` = `book`.`id`
LEFT JOIN `services` ON `bd`.`services_id` = `services`.`id`
LEFT JOIN `emplyee` ON `bd`.`emplyee_id` = `emplyee`.`id`
WHERE DATE_FORMAT(`bd`.`day_date`, '%Y-%m') = '$today'
AND `bd`.`branch_id` $branch_sql
AND `bd`.`branch_id` $branch_sql
AND `emplyee`.`occupation_id` = 2
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`)
");
$count = 1;
while ($get_book_details = mysqli_fetch_assoc($get_book_details_sql)) {
if (!array_key_exists($get_book_details['id'],$data)){
$data[$get_book_details['id']]['info'] = array(
"name" => $get_book_details['name'],
);
$data[$get_book_details['id']]['tretment'] = [];
$data[$get_book_details['id']][1] = 0;
$data[$get_book_details['id']][2] = 0;
$data[$get_book_details['id']][3] = 0;
$data[$get_book_details['id']][4] = 0;
$data[$get_book_details['id']]['else'] = 0;
}
$data[$get_book_details['id']]['tretment'][$get_book_details['tretment_id']] += 1;
switch ($get_book_details['services_id']) {
case 1: case 183:
$data[$get_book_details['id']][1] += 1;
break;
case 2: case 184:
$data[$get_book_details['id']][2] += 1;
break;
case 3: case 185:
$data[$get_book_details['id']][3] += 1;
break;
case 4: case 186:
$data[$get_book_details['id']][4] += 1;
break;
default:
$data[$get_book_details['id']]['else'] += 1;
break;
}
}
?>
عدد الخدمات المقدمة من كل مدلك مع نسبة لكل خدمة بالشهر