<?php
    require_once('fixed/config/go_con.php');
    access(30);

    $today = date("Y-m-d");
    if (!empty($_GET['date'])) {
        $today = $_GET['date'];
        if (DateTime::createFromFormat('Y-m-d', $today) == false) {
            $today = date("Y-m-d");
        }
    }
    
    
    $branch_id = $_SESSION['branch'];
    if (!empty($_GET['branch'])) {
        $branch_id = $_GET['branch'];
        if (!is_numeric($branch_id)) {
            $branch_id = $_SESSION['branch'];
        }
    }
    $branch_sql = '`branch_id`='.$branch_id;
    if ($branch_id == 1) {
        $branch_sql = '`branch_id`<>'.$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'))
        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'))
        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;
            }
        }
    }
?>
<!DOCTYPE html>
<html lang="en" dir="rtl">
  <?php require_once('fixed/head/go.php'); ?>
    <body class="rtl">
        <style>
            tr {
                border-color: #bfbbbb !important;
            }
            .table-bordered td, .table-bordered th {
                border-color: #bfbbbb !important;
            }
        </style>
        <link rel="stylesheet" href="//cdn.jsdelivr.net/npm/@mdi/font@6.5.95/css/materialdesignicons.min.css">
        <?php require_once('fixed/loader/go.php'); ?>
        <!-- page-wrapper Start-->
        <div class="page-wrapper" id="pageWrapper">
            <?php require_once('fixed/header/go.php'); ?>
            <!-- Page Body Start-->
            <div class="page-body-wrapper">
                <?php require_once('fixed/sidebar/go.php'); ?>
                <div class="page-body">
                    <div class="container-fluid">
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-body new-user order-list text-center">
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-3 col-lg-4 col-xl-4">
                                            </div>
                                            <div class="page-title mb-3 col-12 col-sm-12 col-md-6 col-lg-4 col-xl-4">
                                                <i class="mdi mdi-monitor mr-2">
                                                </i>
                                                <h4>
                                                    إيرادات يوم
                                                    <?= Day_ar() ?>
                                                    <br />
                                                    <?= Today_ar() ?>
                                                </h4>
                                            </div>
                                            <div class="col-12 col-sm-12 col-md-3 col-lg-4 col-xl-4">
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-12 col-sm-12 col-md-2 col-lg-3 col-xl-3">
                                            </div>
                                            <div class="col-2 col-sm-2 col-md-1 col-lg-1 col-xl-1">
                                                <a class="btn btn-danger btn-round waves-effect waves-light col-12" href="daily_user.php?date=<?= $Previous ?>&branch=<?= $branch_id ?>" style="padding: 0.375rem 0.75rem;">-</a>
                                            </div>
                                            <div class="col-8 col-sm-8 col-md-6 col-lg-4 col-xl-4">
                                                <input id="Select-date" class="form-control" type="date" value="" style="text-align: center !important;">
                                            </div>
                                            <div class="col-2 col-sm-2 col-md-1 col-lg-1 col-xl-1">
                                                <a class="btn btn-primary btn-round waves-effect waves-light col-12" href="daily_user.php?date=<?= $Next ?>&branch=<?= $branch_id ?>" style="padding: 0.375rem 0.75rem;">+</a>
                                            </div>
                                            <div class="col-12 col-sm-12 col-md-2 col-lg-3 col-xl-3">
                                            </div>
                                        </div>
                                    </div>
                                    
                                    <div class="tab-content">
                                        <div class="tab-pane p-3 active" id="tab<?=$tabs?>" role="tabpanel">
                                            <div class="card-body new-user order-list">
                                                <div class="table-responsive">
                                                    <table class="table table-bordered text-center" style="vertical-align: middle;">
                                                        <thead class="table-primary" style="vertical-align: middle;">
                                                            <tr>
                                                                <th rowspan="2" scope="col">#</th>
                                                                <th rowspan="2" scope="col">اسم الموظف</th>
                                                                <th rowspan="2" scope="col">الفرع</th>
                                                                <th rowspan="2" scope="col">بيان</th>
                                                                <th rowspan="2" scope="col">عدد العمليات</th>
                                                                <th colspan="4" scope="col">المتحصلات اليومية</th>
                                                                <th colspan="4" scope="col">الإيرادات  - الفواتير</th>
                                                                <th rowspan="2" scope="col">ايداعات نقدية عن طريق  الموظف</th>
                                                                <th rowspan="2" scope="col">العجز / الزيادة</th>
                                                                <th rowspan="2" scope="col">ملاحظات</th>
                                                            </tr>
                                                            <tr>
                                                                <th scope="col">كاش</th>
                                                                <th scope="col">شبكة</th>
                                                                <th scope="col">تحويل</th>
                                                                <th scope="col">إجمالي المتحصلات</th>
                                                                <th scope="col">عن فواتير / كاش / شبكة </th>
                                                                <th scope="col">عن فواتير/ محول من ارصدة دائنة للعملاء</th>
                                                                <th scope="col">إيرادات مرتجعة ( فاتورة مرتجعات )</th>
                                                                <th scope="col">إجمالي الإيرادات</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <?php
                                                                $count = 1;
                                                                foreach ($data as $key => $value) {
                                                            ?>
                                                            <tr>
                                                                <th rowspan="<?=count($data[$key]['branchs'])*4?>" scope="row"><?=$count?></th>
                                                                <td rowspan="<?=count($data[$key]['branchs'])*4?>"><a href="daily_user_d?u=<?=$key?>&d=<?=$today?>"><?=$data[$key]['info']['name']?></a></td>
                                                            <?php
                                                                    foreach ($data[$key]['branchs'] as $key2 => $value2) {
                                                            ?>
                                                                <td rowspan="4"><?=$data[$key]['branchs'][$key2]['info']['name']?></td>
                                                                <td>فواتير</td>
                                                                <td><?=$data[$key]['branchs'][$key2]['inv']['count']?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['inv']['cash'],2)?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['inv']['card'],2)?></td>
                                                                <td><?=round(0,2)?></td>
                                                                <td style="background:#e9f0ee;"><b><?=round($data[$key]['branchs'][$key2]['inv']['cash'] + $data[$key]['branchs'][$key2]['inv']['card'],2)?></b></td>
                                                                <td rowspan="4"><?=round($data[$key]['branchs'][$key2]['inv']['cash'] + $data[$key]['branchs'][$key2]['inv']['card'],2)?></td>
                                                                <td rowspan="4"><?=round($data[$key]['branchs'][$key2]['inv']['stuck'],2)?></td>
                                                                <td rowspan="4"><?=round(-($data[$key]['branchs'][$key2]['inv_back']['cash']+$data[$key]['branchs'][$key2]['inv_back']['card']+$data[$key]['branchs'][$key2]['inv_back']['stuck']),2)?></td>
                                                                <td style="background:#e9f0ee;" rowspan="4"><?=round(($data[$key]['branchs'][$key2]['inv']['cash'] + $data[$key]['branchs'][$key2]['inv']['card']) + $data[$key]['branchs'][$key2]['inv']['stuck'] - ($data[$key]['branchs'][$key2]['inv_back']['cash']+$data[$key]['branchs'][$key2]['inv_back']['card']+$data[$key]['branchs'][$key2]['inv_back']['stuck']),2)?></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                            </tr>
                                                            <tr>
                                                                <td>أرصدة دائنة للعملاء</td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['bonds']['count'])?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['bonds']['cash'],2)?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['bonds']['card'],2)?></td>
                                                                <td><?=round(0,2)?></td>
                                                                <td style="background:#e9f0ee;"><b><?=round($data[$key]['branchs'][$key2]['bonds']['cash'] + $data[$key]['branchs'][$key2]['bonds']['card'],2)?></b></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                            </tr>
                                                            <tr>
                                                                <td>إيرادات مرتجعة</td>
                                                                <td><?=($data[$key]['branchs'][$key2]['inv_back']['count']) + ($data[$key]['branchs'][$key2]['bonds_back']['count'])?></td>
                                                                <td><?=round(-(($data[$key]['branchs'][$key2]['inv_back']['cash']) + ($data[$key]['branchs'][$key2]['bonds_back']['cash'])),2)?></td>
                                                                <td><?=round(0,2)?></td>
                                                                <td><?=round(0,2)?></td>
                                                                <td style="background:#e9f0ee;"><b><?=round(-(($data[$key]['branchs'][$key2]['inv_back']['cash']+$data[$key]['branchs'][$key2]['inv_back']['card']) + ($data[$key]['branchs'][$key2]['bonds_back']['cash']+$data[$key]['branchs'][$key2]['bonds_back']['card'])),2)?></b></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                            </tr>
                                                            <tr style="background:#e9f0ee; font-weight: bold;">
                                                                <td>مجموع</td>
                                                                <td><?=$data[$key]['branchs'][$key2]['inv']['count'] + $data[$key]['branchs'][$key2]['bonds']['count'] + ($data[$key]['branchs'][$key2]['inv_back']['count']) + ($data[$key]['branchs'][$key2]['bonds_back']['count'])?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['inv']['cash'] + $data[$key]['branchs'][$key2]['bonds']['cash'] - ($data[$key]['branchs'][$key2]['inv_back']['cash']) + ($data[$key]['branchs'][$key2]['bonds_back']['cash']),2)?></td>
                                                                <td><?=round($data[$key]['branchs'][$key2]['inv']['card'] + $data[$key]['branchs'][$key2]['bonds']['card'],2)?></td>
                                                                <td><?=round(0,2)?></td>
                                                                <td style="background:#e9f0ee;"><b><?=round(($data[$key]['branchs'][$key2]['inv']['cash'] + $data[$key]['branchs'][$key2]['inv']['card']) + ($data[$key]['branchs'][$key2]['bonds']['cash'] + $data[$key]['branchs'][$key2]['bonds']['card']) - ($data[$key]['branchs'][$key2]['inv_back']['cash']) + ($data[$key]['branchs'][$key2]['bonds_back']['cash']),2)?></b></td>
                                                                <td></td>
                                                                <td></td>
                                                                <td></td>
                                                            </tr>
                                                            <?php
                                                                    }
                                                            ?>

                                                            <?php
                                                                    $count++;
                                                                }
                                                            ?>
                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <?php require_once('fixed/footer/go.php'); ?>
            </div>
        </div>
        <?php require_once('fixed/js/go.php'); ?>
        <script>
            $("#Select-date").change(function() {
                var SelectedDate = $(this).val();
                window.location = 'daily_user.php?branch=<?= $branch_id ?>&date=' + SelectedDate
            });
        </script>
    </body>
</html>