<?php
require_once('fixed/config/go_con.php');
access(31);
$page_link = 'custom_reports?s=22&';
$today = date("Y-m");
if (!empty($_GET['date'])) {
    $today = $_GET['date'];
    if (DateTime::createFromFormat('Y-m', $today) == false) {
        $today = date("Y-m");
    }
}

$Next = date('Y-m', strtotime('+1 month', strtotime($today)));
$Previous = date('Y-m', strtotime('-1 month', strtotime($today)));

$frist_day = date('Y-m-d', strtotime($today));
$last_day = date("Y-m-t", strtotime($frist_day));

$c_r_id = $_GET['c'];
if (!empty($_GET['c'])) {
    $c_r_id = $_GET['c'];
    if (!is_numeric($c_r_id)) {
        $c_r_id = 1;
    }
} else {
    $c_r_id = 1;
}
$c_r_id_sql = '=' . $c_r_id;
if ($c_r_id == 1) {
    $c_r_id_sql = '<>' . $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;
}

$error = 0;

$data = array(
    'totals' => array(
        'inv' => 0,
        'bonds' => 0,
    )
);

$get_invoices_sql = mysqli_query($db, 
      "SELECT `r_month_user_invoices`.`filter`, `r_month_user_invoices`.`total`, `r_month_user_invoices`.`invoices_status_id`, `r_month_user_invoices`.`how_pay_id`, DATE_FORMAT(`r_month_user_invoices`.`filter`, '%Y-%m') AS `ddss` FROM `r_month_user_invoices` 
      INNER JOIN `branch` ON `branch`.`id` = `r_month_user_invoices`.`branch_id`
      WHERE DATE_FORMAT(`r_month_user_invoices`.`filter`, '%Y-%m') <= '$today'
      AND `r_month_user_invoices`.`branch_id` $branch_sql
      AND `branch`.`commercial_register_id` $c_r_id_sql
      AND `branch`.`commercial_register_id` <> 5
  ");
  
  if (mysqli_num_rows($get_invoices_sql) > 0) {
      while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
          switch ($get_invoices['invoices_status_id']) {
              case '1': case '2':
                  switch ($get_invoices['how_pay_id']) {
                      case '3': case '4':
                        if($get_invoices['ddss'] < $today) {
                            $data['totals']['inv'] += $get_invoices['total'];
                        } else {
                            $data['inv'][$get_invoices['filter']]['stuck'] += $get_invoices['total'];
                        }
                          break;
                  }
                  break;
              case '3':
                  switch ($get_invoices['how_pay_id']) {
                      case '3': case '4':
                        if($get_invoices['ddss'] < $today) {
                            $data['totals']['bonds'] += $get_invoices['total'];
                        } else {
                          $data['bonds'][$get_invoices['filter']]['plus'] += $get_invoices['total'];
                        }
                          break;
                  }
                  break;
              default:
                  $error++;
                  break;
          }
      }
  }

  $get_invoices_sql = mysqli_query($db, 
      "SELECT `r_month_user_bonds`.`filter`, `r_month_user_bonds`.`total`, `r_month_user_bonds`.`bonds_status_id`, `r_month_user_bonds`.`how_pay_id`, DATE_FORMAT(`r_month_user_bonds`.`filter`, '%Y-%m') AS `ddss` FROM `r_month_user_bonds` 
      INNER JOIN `branch` ON `branch`.`id` = `r_month_user_bonds`.`branch_id`
      WHERE DATE_FORMAT(`r_month_user_bonds`.`filter`, '%Y-%m') <= '$today'
      AND `r_month_user_bonds`.`branch_id` $branch_sql
      AND `branch`.`commercial_register_id` $c_r_id_sql
      AND `branch`.`commercial_register_id` <> 5
  ");

  if (mysqli_num_rows($get_invoices_sql) > 0) {
      while ($get_invoices = mysqli_fetch_assoc($get_invoices_sql)) {
          switch ($get_invoices['bonds_status_id']) {
              case '1': case '2':
                  switch ($get_invoices['how_pay_id']) {
                      case '1': case '2': case '3': case '4': case '6': case '7': case '8': case '9': case '10':
                        if($get_invoices['ddss'] < $today) {
                            $data['totals']['bonds'] += $get_invoices['total'];
                        } else {
                          $data['bonds'][$get_invoices['filter']]['plus'] += $get_invoices['total'];
                        }
                          break;
                  }
                  break;
              case '3':
                  switch ($get_invoices['how_pay_id']) {
                      case '1': case '2': case '5':
                        if($get_invoices['ddss'] < $today) {
                            $data['totals']['inv'] += $get_invoices['total'];
                        } else {
                          $data['inv'][$get_invoices['filter']]['stuck'] += $get_invoices['total'];
                        }
                          break;
                  }
                  break;
              default:
                  $error++;
                  break;
          }
      }
  }


$totals = ($data['totals']['bonds'] - $data['totals']['inv']);
?>
<!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 col-sm-12 col-md-12 col-lg-2 col-xl-2">
                            <div class="card">
                                <div class="card-body new-user order-list profile-nav">
                                    <div class="nav flex-column nav-pills" id="profile-tab" aria-orientation="vertical">
                                        <?php
                                        $commercial_register_sql = mysqli_query($db, "SELECT `branch`.`branch_name`, `branch`.`id` 
                                        FROM `commercial_register`
                                        LEFT JOIN `branch` ON `commercial_register`.`id` = `branch`.`commercial_register_id`
                                        ");
                                        while ($commercial_register = mysqli_fetch_assoc($commercial_register_sql)) {
                                            ?>
                                            <a class="nav-link mb-0 <?php if ($branch_id == $commercial_register['id']) {
                                                echo 'active';
                                            } ?>"
                                                data-toggle="pill" href="#branch-<?= $commercial_register['id'] ?>"
                                                aria-selected="false"
                                                onclick="window.location='<?= $page_link ?>date=<?= $today ?>&b=<?= $commercial_register['id'] ?>'">
                                                <?= $commercial_register['branch_name'] ?>
                                            </a>
                                            <?php
                                        }
                                        ?>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-12 col-sm-12 col-md-12 col-lg-10 col-xl-10">
                            <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>
                                                إيرادات شهر
                                                <br />
                                                <?= $today ?>
                                            </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="<?= $page_link ?>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="<?= $page_link ?>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 id="refrish" class="form-control"
                                                style="background-color: #086367; color:white; text-align:center; cursor: pointer;">
                                                طلب التقرير</div>
                                        </div>
                                    </div>
                                </div>
                                <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 colspan="3" scope="col">رصيد العملاء</th>
                                                    <th scope="col">
                                                        <?= round($totals, 2) ?>
                                                    </th>
                                                </tr>
                                                <tr>
                                                    <th scope="col">التاريخ</th>
                                                    <th scope="col">وارد</th>
                                                    <th scope="col">صادر</th>
                                                    <th scope="col">الرصيد</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php
                                                while ($frist_day <= $last_day) {
                                                    $t1_temp = round($data['bonds'][$frist_day]['plus'], 2);
                                                    $t2_temp = round($data['inv'][$frist_day]['stuck'], 2);
                                                    $t3_temp = round(($totals + $t1_temp) - $t2_temp, 2);
                                                    ?>
                                                    <tr>
                                                        <th scope="row" style="white-space: nowrap;">
                                                            <?= $frist_day ?>
                                                        </th>
                                                        <td>
                                                            <?= $t1_temp ?>
                                                        </td>
                                                        <td>
                                                            <?= $t2_temp ?>
                                                        </td>
                                                        <td>
                                                            <?= $t3_temp ?>
                                                        </td>
                                                    </tr>
                                                    <?php
                                                    $totals = $t3_temp;
                                                    $frist_day = date('Y-m-d', strtotime('+1 day', strtotime($frist_day)));
                                                }
                                                ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <?php require_once('fixed/footer/go.php'); ?>
        </div>
    </div>
    <div id="get_data"></div>
    <?php require_once('fixed/js/go.php'); ?>
    <script>
        $("#Select-date").change(function () {
            var SelectedDate = $(this).val();
            window.location = '<?= $page_link ?>branch=<?= $branch_id ?>&date=' + SelectedDate
        });
    </script>
    <script>
        // for limit clicks
        click = 0;

        // refrish
        $(function () {
            $("#refrish").click(function () {
                refrish();
            });
        });

        function refrish() {
            date = <?= json_encode($today) ?>;
            if (click == 0) {
                click++;
                $.post("work/order/ajax/r_bonds_int_dec_ajax.php", {
                    date
                }, function (get_tretment) {
                    $("#get_data").html(get_tretment);
                })
            } else {
                swalfun("يرجى الانتظار", "", "warning");
            }
        }
    </script>
</body>

</html>