' . $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; } $data = array(); $Next = date('Y-m', strtotime('+1 month', strtotime($today))); $Previous = date('Y-m', strtotime('-1 month', strtotime($today))); $startDate = new DateTime($today . '-01'); $endDate = clone $startDate; $endDate->modify('last day of this month'); while ($startDate <= $endDate) { $startDate->format('Y-m-d'); $today_temp = $startDate->format('Y-m-d'); $Next_temp = date('Y-m-d', strtotime('+1 day', strtotime($today_temp))); $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_temp%' AND `invoices_details_has_how_pay`.`date_time` >= '$today_temp 03:00:00') OR (`invoices_details_has_how_pay`.`date_time` LIKE '$Next_temp%' AND `invoices_details_has_how_pay`.`date_time` < '$Next_temp 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': case '4': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['stuck'] += $get_invoices['pay']; break; case '6': case '7': case '8': case '9': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['trans'] += $get_invoices['pay']; break; default: $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv']['else'] += $get_invoices['pay']; $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': case '4': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['stuck'] += $get_invoices['pay']; break; case '5': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['trans'] += $get_invoices['pay']; break; default: $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['inv_back']['else'] += $get_invoices['pay']; $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_temp%' AND `bonds_details_has_how_pay`.`date_time` >= '$today_temp 03:00:00') OR (`bonds_details_has_how_pay`.`date_time` LIKE '$Next_temp%' AND `bonds_details_has_how_pay`.`date_time` < '$Next_temp 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': case '4': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['stuck'] += $get_invoices['pay']; break; case '6': case '7': case '8': case '9': case '10': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['trans'] += $get_invoices['pay']; break; default: $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds']['else'] += $get_invoices['pay']; $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': case '4': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['stuck'] += $get_invoices['pay']; break; case '5': $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['trans'] += $get_invoices['pay']; break; default: $data[$get_invoices['user_id']]['branchs'][$get_invoices['branch_id']]['bonds_back']['else'] += $get_invoices['pay']; $error++; break; } break; default: $error++; break; } } } $startDate->modify('+1 day'); } ?>

إيرادات شهر

-
+
تفاصيل التقرير
  1. التقرير لا يظهر في عمود إيرادات مرتجعة
    1. التحويل
    2. مرتجع ل رصيد
  2. التقرير لا يظهر في عمود مرتجع أرصدة دائنة
    1. التحويل
    2. مرتجع ل رصيد
  3. المقصود ب اخرى هي عمليات الدفع التي لم يتم تعريفها في التقرير
  4. تنبية : عند وجود اي خطأ في (عدد الاخطاء) يرجى اشعار القسم التقني
عدد الأخطاء $value) { ?> $value2) { // every 5 is not add in total $t1_1_temp = round($data[$key]['branchs'][$key2]['inv']['count']); $t1_2_temp = round($data[$key]['branchs'][$key2]['inv']['cash'], 2); $t1_3_temp = round($data[$key]['branchs'][$key2]['inv']['card'], 2); $t1_4_temp = round($data[$key]['branchs'][$key2]['inv']['trans'], 2); $t1_5_temp = round($data[$key]['branchs'][$key2]['inv']['else'], 2); $t2_4_total = $t1_2_temp + $t1_3_temp + $t1_4_temp; $inv_stuck = round($data[$key]['branchs'][$key2]['inv']['stuck'], 2); ////////////////////////////////////////////////////////////////////// $t2_1_temp = round(($data[$key]['branchs'][$key2]['inv_back']['count'])); $t2_2_temp = round((($data[$key]['branchs'][$key2]['inv_back']['cash'])), 2); $t2_3_temp = round((($data[$key]['branchs'][$key2]['inv_back']['card'])), 2); $t2_4_temp = round((($data[$key]['branchs'][$key2]['inv_back']['trans'])), 2); $t2_5_temp = round((($data[$key]['branchs'][$key2]['inv_back']['else'])), 2); // مرتجع لرصيد $inv_back_stuck = round((($data[$key]['branchs'][$key2]['inv_back']['stuck'])), 2); // التحويل لا يتم خصمة من المتحصلات $t6_7_total = $t2_2_temp + $t2_3_temp; ////////////////////////////////////////////////////////////////////// $t3_1_temp = round($data[$key]['branchs'][$key2]['bonds']['count']); $t3_2_temp = round($data[$key]['branchs'][$key2]['bonds']['cash'], 2); $t3_3_temp = round($data[$key]['branchs'][$key2]['bonds']['card'], 2); $t3_4_temp = round($data[$key]['branchs'][$key2]['bonds']['trans'], 2); $t3_5_temp = round($data[$key]['branchs'][$key2]['bonds']['else'], 2); $t10_12_total = $t3_2_temp + $t3_3_temp + $t3_4_temp; $bonds_stuck = round($data[$key]['branchs'][$key2]['bonds']['stuck'], 2); ////////////////////////////////////////////////////////////////////// $t4_1_temp = round($data[$key]['branchs'][$key2]['bonds_back']['count']); $t4_2_temp = round($data[$key]['branchs'][$key2]['bonds_back']['cash'], 2); $t4_3_temp = round($data[$key]['branchs'][$key2]['bonds_back']['card'], 2); $t4_4_temp = round($data[$key]['branchs'][$key2]['bonds_back']['trans'], 2); $t4_5_temp = round($data[$key]['branchs'][$key2]['bonds_back']['else'], 2); // مرتجع لرصيد $bonds_back_stuck = round($data[$key]['branchs'][$key2]['bonds_back']['stuck'], 2); // التحويل لا يتم خصمة من المتحصلات $t14_15_total = $t4_2_temp + $t4_3_temp; ////////////////////////////////////////////////////////////////////// $t5_1_temp = $t1_1_temp + $t2_1_temp + $t3_1_temp + $t4_1_temp; $t5_2_temp = ($t1_2_temp - $t2_2_temp) + ($t3_2_temp - $t4_2_temp); $t5_3_temp = ($t1_3_temp - $t2_3_temp) + ($t3_3_temp - $t4_3_temp); $t5_4_temp = $t1_4_temp + $t3_4_temp; $t5_5_temp = ($t1_5_temp - $t2_5_temp) + ($t3_5_temp - $t4_5_temp); $t18_20_total = $t5_2_temp + $t5_3_temp + $t5_4_temp; ////////////////////////////////////////////////////////////////////// $s1_temp = $t2_4_total; $s2_temp = $inv_stuck; $s3_temp = $t2_2_temp + $t2_3_temp + $t2_4_temp + $inv_back_stuck; $s4_temp = ($s1_temp + $s2_temp) - $s3_temp; ?>
# اسم الموظف الفرع بيان عدد العمليات المتحصلات اليومية الإيرادات - الفواتير ايداعات نقدية عن طريق الموظف العجز / الزيادة ملاحظات
كاش شبكة تحويل اخرى إجمالي المتحصلات عن فواتير / كاش / شبكة عن فواتير/ محول من ارصدة دائنة للعملاء إيرادات مرتجعة ( فاتورة مرتجعات ) إجمالي الإيرادات
فواتير -
إيرادات مرتجعة - - - - -
أرصدة دائنة للعملاء
مرتجع أرصدة دائنة - - - - -
مجموع
المجموع الكلي
فواتير -
إيرادات مرتجعة - - - - -
أرصدة دائنة للعملاء
مرتجع أرصدة دائنة - - - - -
مجموع