= '$today 03:00:00') OR (`invoices_details_has_how_pay`.`date_time` LIKE '$Next%' AND `invoices_details_has_how_pay`.`date_time` < '$Next 03:00:00'))
AND `invoices_details`.`branch_id` = $branch_id
GROUP BY `how_pay_id`
)
, 0) AS `cash`,
IFNULL(
(SELECT
SUM(`invoices_details_has_how_pay`.`pay`)
FROM `invoices_details_has_how_pay`
INNER JOIN `invoices_details` ON `invoices_details_has_how_pay`.`invoices_details_id` = `invoices_details`.`id`
WHERE `invoices_details_has_how_pay`.`how_pay_id` = 2
AND (`invoices_details`.`invoices_status_id` = 1 OR `invoices_details`.`invoices_status_id` = 2)
AND `invoices_details_has_how_pay`.`user_id` = `user`.`id`
AND ((`invoices_details_has_how_pay`.`date_time` LIKE '$today%' AND `invoices_details_has_how_pay`.`date_time` >= '$today 03:00:00') OR (`invoices_details_has_how_pay`.`date_time` LIKE '$Next%' AND `invoices_details_has_how_pay`.`date_time` < '$Next 03:00:00'))
AND `invoices_details`.`branch_id` = $branch_id
GROUP BY `how_pay_id`
)
, 0) AS `card`,
IFNULL(
(SELECT
SUM(`invoices_details_has_how_pay`.`pay`)
FROM `invoices_details_has_how_pay`
INNER JOIN `invoices_details` ON `invoices_details_has_how_pay`.`invoices_details_id` = `invoices_details`.`id`
WHERE `invoices_details_has_how_pay`.`how_pay_id` = 3
AND (`invoices_details`.`invoices_status_id` = 1 OR `invoices_details`.`invoices_status_id` = 2)
AND `invoices_details_has_how_pay`.`user_id` = `user`.`id`
-- AND `invoices_details_has_how_pay`.`date_time` LIKE '$today%'
AND ((`invoices_details_has_how_pay`.`date_time` LIKE '$today%' AND `invoices_details_has_how_pay`.`date_time` >= '$today 03:00:00') OR (`invoices_details_has_how_pay`.`date_time` LIKE '$Next%' AND `invoices_details_has_how_pay`.`date_time` < '$Next 03:00:00'))
AND `invoices_details`.`branch_id` = $branch_id
GROUP BY `how_pay_id`
)
, 0) AS `stuck`,
IFNULL(
(SELECT
SUM(`invoices_details_has_how_pay`.`pay`)
FROM `invoices_details_has_how_pay`
INNER JOIN `invoices_details` ON `invoices_details_has_how_pay`.`invoices_details_id` = `invoices_details`.`id`
WHERE `invoices_details_has_how_pay`.`how_pay_id` = 1
AND (`invoices_details`.`invoices_status_id` = 3)
AND `invoices_details_has_how_pay`.`user_id` = `user`.`id`
AND ((`invoices_details_has_how_pay`.`date_time` LIKE '$today%' AND `invoices_details_has_how_pay`.`date_time` >= '$today 03:00:00') OR (`invoices_details_has_how_pay`.`date_time` LIKE '$Next%' AND `invoices_details_has_how_pay`.`date_time` < '$Next 03:00:00'))
AND `invoices_details`.`branch_id` = $branch_id
GROUP BY `how_pay_id`
)
, 0) AS `cash_back`,
FROM `user`
LEFT JOIN `emplyee` ON `user`.`emplyee_id` = `emplyee`.`id`
LEFT JOIN `branch` ON `emplyee`.`branch_id` = `branch`.`id`
HAVING (`count` <> 0 OR `bond_count` <> 0) AND (`cash` OR `card` OR `stuck` OR `cash_back` OR `bond_cash` OR `bond_card`)
");
$count = 1;
$toooot1 = 0;
$toooot3 = 0;
$toooot4 = 0;
$toooot5 = 0;
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
?>