'.$branch_id;
}
$data = array();
$get_invoices_sql = mysqli_query($db,
"SELECT
COUNT(`invoices`.`id`) AS `count`,
SUM(`invoices`.`price`) AS `total`,
SUM(`invoices`.`price_cut`) AS `total_cut`,
DATE(`invoices`.`date_time`) AS `date`
FROM `invoices`
LEFT JOIN `invoices_details` AS `dd` ON `dd`.`invoices_id` = `invoices`.`id`
LEFT JOIN `branch` ON `dd`.`branch_id` = `branch`.`id`
WHERE `branch`.`id` $branch_sql
AND `invoices`.`date_time` LIKE '$today%'
AND `dd`.`id` IN (SELECT MIN(`id`) FROM `invoices_details` WHERE `invoices_id` = `dd`.`invoices_id`)
GROUP BY `date`
ORDER BY `date` ASC
");
$toooot6 = 0;
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
$toooot6 += round($get_invoices['total'],2);
}
$data['total'] = $toooot6;
$get_invoices_sql = mysqli_query($db,
"SELECT
`services`.`id`,
`services`.`name`,
COUNT(`services`.`id`) AS `count`,
`services`.`price`
FROM `services`
INNER JOIN `book_details` AS `bb` ON `bb`.`services_id` = `services`.`id`
INNER JOIN `book` ON `bb`.`book_id` = `book`.`id`
WHERE `bb`.`id` IN (SELECT MAX(`id`) FROM `book_details` WHERE `book_id` = `bb`.`book_id`)
AND `bb`.`status_id` IN (6,8,14,15,16)
AND `bb`.`branch_id` $branch_sql
AND `bb`.`day_date` LIKE '$today%'
GROUP BY `services`.`id`
");
$toooot1 = 0;
$total_price_deq = 0;
$total_count_deq = 0;
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
if ($get_invoices['id'] != 0) {
$data['serv'][$get_invoices['id']] = array(
'name' => $get_invoices['name'],
'count' => $get_invoices['count'],
'price' => $get_invoices['price'],
'Max_price' => round($get_invoices['price']+ (($get_invoices['price']*$vat)/100),2) * $get_invoices['count'],
);
$total_price_deq += $get_invoices['price'];
$total_count_deq += $get_invoices['count'];
}
}
$html = '';
$serv = $data['serv'];
$count = 1;
$total_show_non_vat = 0;
$total_show_vat = 0;
$return_values = array();
foreach ($serv as $key => $value) {
$data['serv'][$key]['price_deq'] = $serv[$key]['price'] / $total_price_deq;
$data['serv'][$key]['count_deq'] = $serv[$key]['count'] / $total_count_deq;
$data['serv'][$key]['total_deq'] = ($data['serv'][$key]['price_deq'] + $data['serv'][$key]['count_deq']) / 2;
$data['serv'][$key]['deq'] = $data['serv'][$key]['total_deq'] * $data['total'];
//if ($data['serv'][$key]['Max_price'] < $data['serv'][$key]['deq']) {
// $temp1 = $data['serv'][$key]['Max_price'] / $data['total'];
// $temp2 = $data['serv'][$key]['total_deq'];
// $return_values['total'] += $temp2 - $temp1;
// $return_values[$key] = $temp2 - $temp1;
// $data['serv'][$key]['deq'] = $data['serv'][$key]['Max_price'];
//}
$html .= '
| '.$count.' |
'.$data['serv'][$key]['name'].' |
'.round($data['serv'][$key]['deq']/1.15,2).' |
'.round($data['serv'][$key]['deq'],2).' |
';
//'.$data['serv'][$key]['count'].' |
//'.$data['serv'][$key]['Max_price'].' |
$total_show_non_vat += round($data['serv'][$key]['deq']/1.15,2);
$total_show_vat += $data['serv'][$key]['deq'];
$count++;
}
print_r($return_values);
?>
| # |
اسم الخدمة |
بدون الضريبة |
شامل الضريبة |
| المجموع |
|
|