' . $c_r_id;
}
$branch_id = $_GET['b'];
if (!empty($_GET['b'])) {
$branch_id = $_GET['b'];
if (!is_numeric($branch_id)) {
$branch_id = 1;
}
} else {
$branch_id = 1;
}
if (!empty($_GET['f'])) {
if (is_numeric($c_r_id) && $_GET['f'] == 1) {
$branch_id = 1;
}
}
$branch_sql = '=' . $branch_id;
if ($branch_id == 1) {
$branch_sql = '<>' . $branch_id;
}
$data = array();
$error = 0;
$get_invoices_sql = mysqli_query(
$db,
"SELECT
`tretment`.`name`,
`tretment`.`number`,
`day_date`,
`count`
FROM `tretment`
INNER JOIN (SELECT DATE(`bd`.`day_date`) AS `day_date`, `book`.`tretment_id`, COUNT(`book`.`id`) AS `count`
FROM `book_details` AS `bd`
INNER JOIN `book` ON `bd`.`book_id` = `book`.`id`
JOIN (
SELECT `book_id`, MAX(`id`) AS `max_id`
FROM `book_details`
GROUP BY `book_id`
) `t1_max`
ON `bd`.`book_id` = `t1_max`.`book_id` AND `bd`.`id` = `t1_max`.`max_id`
INNER JOIN `branch` ON `bd`.`branch_id` = `branch`.`id`
WHERE `bd`.`status_id` IN (6,8,12,13,14,15)
AND $sql_date_req = '$today'
AND `bd`.`branch_id` $branch_sql
AND `branch`.`commercial_register_id` $c_r_id_sql
AND `branch`.`commercial_register_id` <> 5
GROUP BY DATE(`bd`.`day_date`),`book`.`tretment_id`) AS `all_count` ON `tretment`.`id` = `all_count`.`tretment_id`
HAVING `count` > 1
ORDER BY `day_date`
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
array_push($data, $get_invoices);
}
}
?>
عدد الأخطاء
| # |
الاسم |
الرقم |
تاريخ الزيارة |
العدد |
$value) {
?>
|
|
|
|
|