'.$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;
}
$Next = date('Y-m-d', strtotime('+1 day', strtotime($today)));
$Previous = date('Y-m-d', strtotime('-1 day', strtotime($today)));
$Day = date('D', strtotime($today));
function Day_ar()
{
global $Day;
$find = array("Sat", "Sun", "Mon", "Tue", "Wed", "Thu", "Fri");
$replace = array("السبت", "الأحد", "الإثنين", "الثلاثاء", "الأربعاء", "الخميس", "الجمعة");
$ar_day_format = $Day;
$Day_ar = str_replace($find, $replace, $ar_day_format);
return $Day_ar;
}
function Today_ar()
{
global $today;
$Today_ar = date('d-m-Y', strtotime($today));
return $Today_ar;
}
$data = array();
$get_invoices_sql = mysqli_query($db,
"SELECT
`user`.`name`, `branch`.`branch_name`, `invoices_details`.`invoices_status_id`, `invoices_details_has_how_pay`.`user_id`, `invoices_details`.`branch_id`, `invoices_details_has_how_pay`.`how_pay_id`, SUM(`invoices_details_has_how_pay`.`pay`) AS `pay`, COUNT(`invoices`.`id`) AS `count`
FROM `invoices_details_has_how_pay`
INNER JOIN `invoices_details` ON `invoices_details_has_how_pay`.`invoices_details_id` = `invoices_details`.`id`
INNER JOIN `invoices` ON `invoices_details`.`invoices_id` = `invoices`.`id`
INNER JOIN `user` ON `invoices_details_has_how_pay`.`user_id` = `user`.`id`
INNER JOIN `branch` ON `invoices_details`.`branch_id` = `branch`.`id`
WHERE ((`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 `branch`.`id` $branch_sql
AND `branch`.`commercial_register_id` $c_r_id_sql
GROUP BY `invoices_details_has_how_pay`.`user_id`,
`invoices_details`.`branch_id`,
`invoices_details`.`invoices_status_id`,
`invoices_details_has_how_pay`.`how_pay_id`
ORDER BY `invoices_details`.`branch_id`
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
$data[$get_invoices['user_id']]['info']['name'] = $get_invoices['name'];
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['info']['name'] = $get_invoices['branch_name'];
switch ($get_invoices['invoices_status_id']) {
case '1': case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['count'] += $get_invoices['count'];
switch ($get_invoices['how_pay_id']) {
case '1':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['cash'] += $get_invoices['pay'];
break;
case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['card'] += $get_invoices['pay'];
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['stuck'] += $get_invoices['pay'];
break;
default:
$error++;
break;
}
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['count'] += $get_invoices['count'];
switch ($get_invoices['how_pay_id']) {
case '1':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['cash'] += $get_invoices['pay'];
break;
case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['card'] += $get_invoices['pay'];
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['stuck'] += $get_invoices['pay'];
break;
default:
$error++;
break;
}
break;
default:
$error++;
break;
}
}
}
$get_invoices_sql = mysqli_query($db,
"SELECT
`user`.`name`, `branch`.`branch_name`, `bonds_details`.`bonds_status_id`, `bonds_details_has_how_pay`.`user_id`, `bonds_details`.`branch_id`, `bonds_details_has_how_pay`.`how_pay_id`, SUM(`bonds_details_has_how_pay`.`pay`) AS `pay`, COUNT(`bonds`.`id`) AS `count`
FROM `bonds_details_has_how_pay`
INNER JOIN `bonds_details` ON `bonds_details_has_how_pay`.`bonds_details_id` = `bonds_details`.`id`
INNER JOIN `bonds` ON `bonds_details`.`bonds_id` = `bonds`.`id`
INNER JOIN `user` ON `bonds_details_has_how_pay`.`user_id` = `user`.`id`
INNER JOIN `branch` ON `bonds_details`.`branch_id` = `branch`.`id`
WHERE ((`bonds_details_has_how_pay`.`date_time` LIKE '$today%' AND `bonds_details_has_how_pay`.`date_time` >= '$today 03:00:00') OR (`bonds_details_has_how_pay`.`date_time` LIKE '$Next%' AND `bonds_details_has_how_pay`.`date_time` < '$Next 03:00:00'))
AND `branch`.`id` $branch_sql
AND `branch`.`commercial_register_id` $c_r_id_sql
GROUP BY `bonds_details_has_how_pay`.`user_id`,
`bonds_details`.`branch_id`,
`bonds_details`.`bonds_status_id`,
`bonds_details_has_how_pay`.`how_pay_id`
ORDER BY `bonds_details`.`branch_id`
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
$data[$get_invoices['user_id']]['info']['name'] = $get_invoices['name'];
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['info']['name'] = $get_invoices['branch_name'];
switch ($get_invoices['bonds_status_id']) {
case '1': case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['count'] += $get_invoices['count'];
switch ($get_invoices['how_pay_id']) {
case '1':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['cash'] += $get_invoices['pay'];
break;
case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['card'] += $get_invoices['pay'];
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['stuck'] += $get_invoices['pay'];
break;
default:
$error++;
break;
}
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['count'] += $get_invoices['count'];
switch ($get_invoices['how_pay_id']) {
case '1':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['cash'] += $get_invoices['pay'];
break;
case '2':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['card'] += $get_invoices['pay'];
break;
case '3':
$data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['stuck'] += $get_invoices['pay'];
break;
default:
$error++;
break;
}
break;
default:
$error++;
break;
}
}
}
?>
| # |
اسم الموظف |
الفرع |
بيان |
عدد العمليات |
المتحصلات اليومية |
الإيرادات - الفواتير |
ايداعات نقدية عن طريق الموظف |
العجز / الزيادة |
ملاحظات |
| كاش |
شبكة |
تحويل |
إجمالي المتحصلات |
عن فواتير / كاش / شبكة |
عن فواتير/ محول من ارصدة دائنة للعملاء |
إيرادات مرتجعة ( فاتورة مرتجعات ) |
إجمالي الإيرادات |
$value) {
?>
|
|
$value2) {
?>
|
فواتير |
|
|
|
|
|
|
|
|
|
|
|
|
| إيرادات مرتجعة |
|
|
|
|
|
|
|
|
| أرصدة دائنة للعملاء |
|
|
|
|
|
|
|
|
| مرتجع أرصدة دائنة |
|
|
|
|
|
|
|
|
| مجموع |
|
|
|
|
|
|
|
|
| المجموع الكلي |
| فواتير |
|
|
|
|
|
|
|
- |
|
|
|
|
| إيرادات مرتجعة |
|
- |
- |
- |
- |
|
|
|
| أرصدة دائنة للعملاء |
|
|
|
|
|
|
|
|
| مرتجع أرصدة دائنة |
|
- |
- |
- |
- |
|
|
|
| مجموع |
|
|
|
|
|
|
|
|