' . $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;
}
$error = 0;
$data = array();
$get_invoices_sql = mysqli_query(
$db,
"SELECT
`add_free_services`.`reason`,
`user_emp`.`name` AS `emp_name`,
`tretment`.`name` AS `tr_name`,
`tretment`.`number`,
`fromwho`.`name` AS `who_name`,
`services`.`name` AS `serv_name`,
`add_free_services_has_services`.`how_many`,
`services`.`price`
FROM `add_free_services`
INNER JOIN `tretment` ON `tretment`.`id` = `add_free_services`.`tretment_id`
INNER JOIN `emplyee` AS `fromwho` ON `fromwho`.`id` = `add_free_services`.`from_emplyee_id`
INNER JOIN `add_free_services_has_services` ON `add_free_services_has_services`.`add_free_services_id` = `add_free_services`.`id`
INNER JOIN `services` ON `services`.`id` = `add_free_services_has_services`.`services_id`
INNER JOIN `tretment_has_free_service` ON `tretment_has_free_service`.`done_id` IN (1,2,5) AND `tretment_has_free_service`.`table_id` = `add_free_services`.`id`
INNER JOIN `user` AS `u` ON `u`.`id` = `add_free_services`.`user_id`
INNER JOIN `emplyee` AS `user_emp` ON `user_emp`.`id` = `u`.`emplyee_id`
WHERE `tretment_has_free_service`.`date_time` LIKE '$today%'
GROUP BY `add_free_services`.`reason`, `serv_name`
"
);
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
array_push($data, $get_invoices);
}
}
?>
| # |
اسم العميل |
رقم العميل |
نوع الخدمة المجانية |
الكمية |
القيمة |
مقدم الطلب (الموظف) |
بتوجية ؟ |
السبب |
$value) {
?>
|
|
|
|
|
|
|
|
|
| المجاميع |
|
|
|
|
|