'.$branch_id;
}
$data = array();
$inv_sql = '';
$get_bonds_sql = mysqli_query($db,
"SELECT
`bd`.`day_date`,
`tretment`.`name` AS `tr_name`,
`tretment`.`number` AS `tr_number`,
`emplyee`.`name` AS `emp_name`,
`branch`.`branch_name`,
`services`.`name` AS `serv_name`,
`invoices`.`number_style`,
`invoices_details`.`invoices_status_id`,
`invoices_details_has_how_pay`.`pay`,
`how_pay`.`name` AS `how_pay`,
`drivers`.`name` AS `dr_name`
FROM
`book_has_driver_for_points`
INNER JOIN
`invoices_has_book` ON `book_has_driver_for_points`.`book_id` = `invoices_has_book`.`book_id`
INNER JOIN
`invoices` ON `invoices_has_book`.`invoices_id` = `invoices`.`id`
INNER JOIN
`invoices_details` ON `invoices_details`.`invoices_id` = `invoices`.`id`
INNER JOIN
`invoices_details_has_how_pay` ON `invoices_details_has_how_pay`.`invoices_details_id` = `invoices_details`.`id`
INNER JOIN
`how_pay` ON `how_pay`.`id` = `invoices_details_has_how_pay`.`how_pay_id`
INNER JOIN
`emplyee` AS `drivers` ON `drivers`.`id` = `book_has_driver_for_points`.`emplyee_id`
INNER JOIN
`book` ON `book`.`id` = `invoices_has_book`.`book_id`
INNER JOIN
`tretment` ON `tretment`.`id` = `book`.`tretment_id`
INNER JOIN
`book_details` AS `bd` 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
`emplyee` ON `bd`.`emplyee_id` = `emplyee`.`id`
INNER JOIN
`branch` ON `bd`.`branch_id` = `branch`.`id`
INNER JOIN
`services` ON `bd`.`services_id` = `services`.`id`
WHERE `invoices`.`date_time` LIKE '$today%'
AND `invoices_details`.`branch_id` $branch_sql
ORDER BY `invoices`.`number_style` ASC
");
$data = array();
if (mysqli_num_rows($get_bonds_sql) > 0) {
while ($get_bonds = mysqli_fetch_assoc($get_bonds_sql)) {
array_push($data , $get_bonds);
}
}
?>
عدد الاخطاء
| # |
تاريخ الحجز |
اسم العميل |
رقم الجوال |
المدلك |
الفرع |
نوع الجلسة |
المبلغ |
الدفع |
السائق |
$value) {
if($data[$key-1]['number_style'] == $data[$key]['number_style']) {
$data[$key]['pay'] = 0;
$data[$key]['how_pay'] = null;
$data[$key]['dr_name'] = null;
}
?>
|
|
|
|
|
|
|
|
|
|