alert('حدث خطا')";
}
} else {
echo "";
}
$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;
}
$error = 0;
$data = array();
$get_invoices_sql = mysqli_query($db,
"SELECT
`user`.`name`,
`branch`.`branch_name`
FROM `user`
INNER JOIN `emplyee` ON `user`.`emplyee_id` = `emplyee`.`id`
INNER JOIN `branch` ON `emplyee`.`branch_id` = `branch`.`id`
WHERE `user`.`id` = $user_id
");
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
$data['info']['name'] = $get_invoices['name'];
$data['info']['branch'] = $get_invoices['branch_name'];
}
$get_invoices_sql = mysqli_query($db,
"SELECT
`branch`.`id`,
`branch`.`branch_name`
FROM `branch` WHERE `branch`.`id` <> 1
");
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
$data['branchs'][$get_invoices['id']] = array(
'branch_name' => $get_invoices['branch_name'],
'inv_d' => array(),
'bond_d' => array(),
'back_d' => array(),
'bond_back_d' => array(),
);
}
foreach ($data['branchs'] as $key => $value) {
$get_invoices_sql = mysqli_query($db,
"SELECT
`invoices`.`number_style`, `invoices_details_has_how_pay`.`pay`, `invoices_details_has_how_pay`.`how_pay_id`
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`
WHERE (`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` = $key
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
switch ($get_invoices['how_pay_id']) {
case '1':
$data['branchs'][$key]['inv_d'][$get_invoices['number_style']]['cash'] = $get_invoices['pay'];
$data['totals']['inv_total'] += $get_invoices['pay'];
break;
case '2':
$data['branchs'][$key]['inv_d'][$get_invoices['number_style']]['card'] = $get_invoices['pay'];
$data['totals']['inv_total'] += $get_invoices['pay'];
break;
case '3':
$data['branchs'][$key]['inv_d'][$get_invoices['number_style']]['stuck'] = $get_invoices['pay'];
break;
default:
$error++;
break;
}
}
}
$get_invoices_sql = mysqli_query($db,
"SELECT
`bonds`.`number_style`, `bonds_details_has_how_pay`.`pay`, `bonds_details_has_how_pay`.`how_pay_id`
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`
WHERE (`bonds_details`.`bonds_status_id` = 1 OR `bonds_details`.`bonds_status_id` = 2)
AND `bonds_details_has_how_pay`.`user_id` = $user_id
AND ((`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 `bonds_details`.`branch_id` = $key
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
switch ($get_invoices['how_pay_id']) {
case '1':
$data['branchs'][$key]['bond_d'][$get_invoices['number_style']]['cash'] = $get_invoices['pay'];
$data['totals']['bond_total'] += $get_invoices['pay'];
break;
case '2':
$data['branchs'][$key]['bond_d'][$get_invoices['number_style']]['card'] = $get_invoices['pay'];
$data['totals']['bond_total'] += $get_invoices['pay'];
break;
case '3':
$data['branchs'][$key]['bond_d'][$get_invoices['number_style']]['stuck'] = $get_invoices['pay'];
break;
default:
$error++;
break;
}
}
}
$get_invoices_sql = mysqli_query($db,
"SELECT
`invoices`.`number_style`, `invoices_details_has_how_pay`.`pay`, `invoices_details_has_how_pay`.`how_pay_id`
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`
WHERE (`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` = $key
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
switch ($get_invoices['how_pay_id']) {
case '1':
$data['branchs'][$key]['back_d'][$get_invoices['number_style']]['cash'] = $get_invoices['pay'];
$data['totals']['inv_total'] -= $get_invoices['pay'];
break;
case '2':
$data['branchs'][$key]['back_d'][$get_invoices['number_style']]['card'] = $get_invoices['pay'];
$data['totals']['inv_total'] -= $get_invoices['pay'];
break;
case '3':
$data['branchs'][$key]['back_d'][$get_invoices['number_style']]['stuck'] = $get_invoices['pay'];
break;
default:
$error++;
break;
}
}
}
$get_invoices_sql = mysqli_query($db,
"SELECT
`bonds`.`number_style`, `bonds_details_has_how_pay`.`pay`, `bonds_details_has_how_pay`.`how_pay_id`
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`
WHERE (`bonds_details`.`bonds_status_id` = 3)
AND `bonds_details_has_how_pay`.`user_id` = $user_id
AND ((`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 `bonds_details`.`branch_id` = $key
");
if (mysqli_num_rows($get_invoices_sql) > 0) {
while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
switch ($get_invoices['how_pay_id']) {
case '1':
$data['branchs'][$key]['bond_back_d'][$get_invoices['number_style']]['cash'] = $get_invoices['pay'];
$data['totals']['bond_total'] -= $get_invoices['pay'];
break;
case '2':
$data['branchs'][$key]['bond_back_d'][$get_invoices['number_style']]['card'] = $get_invoices['pay'];
$data['totals']['bond_total'] -= $get_invoices['pay'];
break;
case '3':
$data['branchs'][$key]['bond_back_d'][$get_invoices['number_style']]['stuck'] = $get_invoices['pay'];
break;
default:
$error++;
break;
}
}
}
}
?>
| معلومات الموظف |
| رقم الموظف |
الاسم |
الفرع الاساسي |
الفواتير |
أرصدة دائنة - عملاء |
اجمالي الايراد |
|
|
|
|
|
|
|
$value) {
if(!empty($data['branchs'][$key]['inv_d']) || !empty($data['branchs'][$key]['bond_d']) || !empty($data['branchs'][$key]['back_d']) || !empty($data['branchs'][$key]['bond_back_d'])) {
?>
|
| الفواتير |
|
| رقم الفاتورة |
الصادر |
الاجمالي |
| كاش |
شبكة |
تحويل |
رصيد |
$value2) {
?>
|
|
|
|
|
|
| المجموع |
|
|
|
|
|
| الباقات |
|
| رقم السند |
الصادر |
الاجمالي |
| كاش |
شبكة |
تحويل |
$value2) {
?>
|
|
|
|
|
| المجموع |
|
|
|
|
| مرتجعات |
|
| رقم الفاتورة |
المرتجع |
الاجمالي |
$value2) {
?>
|
|
|
| المجموع |
|
|
| مرتجعات سندات |
|
| رقم السند |
المرتجع |
الاجمالي |
$value2) {
?>
|
|
|
| المجموع |
|
|