'.$branch_id;
}
$data = array();
$get_book_details_sql = mysqli_query($db,
"SELECT count(`invoices`.`id`) AS `total` FROM `invoices` WHERE `invoices`.`id` IN (SELECT
`invoices`.`id`
FROM `invoices_discount_details_has_db_tables`
INNER JOIN `invoices_discount_details` ON `invoices_discount_details_has_db_tables`.`invoices_discount_details_id` = `invoices_discount_details`.`id`
INNER JOIN `invoices_discount` ON `invoices_discount`.`id` = `invoices_discount_details`.`invoices_discount_id`
INNER JOIN `invoices_details` ON `invoices_details`.`id` = `invoices_discount`.`invoices_details_id`
INNER JOIN `invoices` ON `invoices_details`.`invoices_id` = `invoices`.`id`
INNER JOIN `invoices_has_book` ON `invoices_has_book`.`invoices_id` = `invoices_details`.`invoices_id`
INNER JOIN `book` ON `invoices_has_book`.`book_id` = `book`.`id`
INNER JOIN `tretment` ON `book`.`tretment_id` = `tretment`.`id`
WHERE `invoices_discount_details_has_db_tables`.`db_tables_id` = 2 AND `invoices_discount_details_has_db_tables`.`db_tables_id_to_id` IN (12,13,14)
AND `invoices`.`date_time` LIKE '$today%'
AND `invoices_details`.`branch_id` $branch_sql
GROUP BY `invoices`.`id`)
");
$get_book_details = mysqli_fetch_assoc($get_book_details_sql);
$data['all'] = $get_book_details['total'];
$get_book_has_how_to_hear_sql = mysqli_query($db,
"SELECT `how_to_hear`.`id`, `how_to_hear`.`name`, COUNT(`book_has_how_to_hear`.`book_id`) AS `total`
FROM `book_has_how_to_hear`
INNER JOIN `book_details` AS `dd` ON `book_has_how_to_hear`.`book_id` = `dd`.`book_id`
INNER JOIN `how_to_hear` ON `book_has_how_to_hear`.`how_to_hear_id` = `how_to_hear`.`id`
WHERE `book_has_how_to_hear`.`date_time` LIKE '$today%'
AND `dd`.`id` IN (SELECT MAX(`book_details`.`id`) FROM `book_details` WHERE `book_details`.`book_id` = `dd`.`book_id` GROUP BY `book_details`.`book_id`)
AND `dd`.`branch_id` $branch_sql
AND `book_has_how_to_hear`.`book_id` IN (SELECT
`book`.`id`
FROM `invoices_discount_details_has_db_tables`
INNER JOIN `invoices_discount_details` ON `invoices_discount_details_has_db_tables`.`invoices_discount_details_id` = `invoices_discount_details`.`id`
INNER JOIN `invoices_discount` ON `invoices_discount`.`id` = `invoices_discount_details`.`invoices_discount_id`
INNER JOIN `invoices_details` ON `invoices_details`.`id` = `invoices_discount`.`invoices_details_id`
INNER JOIN `invoices` ON `invoices_details`.`invoices_id` = `invoices`.`id`
INNER JOIN `invoices_has_book` ON `invoices_has_book`.`invoices_id` = `invoices_details`.`invoices_id`
INNER JOIN `book` ON `invoices_has_book`.`book_id` = `book`.`id`
INNER JOIN `tretment` ON `book`.`tretment_id` = `tretment`.`id`
WHERE `invoices_discount_details_has_db_tables`.`db_tables_id` = 2 AND `invoices_discount_details_has_db_tables`.`db_tables_id_to_id` IN (12,13,14)
AND `invoices`.`date_time` LIKE '$today%'
AND `invoices_details`.`branch_id` $branch_sql
GROUP BY `book`.`id`)
GROUP BY `how_to_hear`.`id`
");
while ($get_book_has_how_to_hear = mysqli_fetch_assoc($get_book_has_how_to_hear_sql)) {
$data['how_to_hear'][$get_book_has_how_to_hear['id']] = $get_book_has_how_to_hear['total'];
}
?>