@extends('dashboard.layout.layout')

@section('content')
  <div class="app-content content">
    <div class="content-overlay"></div>
    <div class="header-navbar-shadow"></div>
    <div class="content-wrapper container-xxl p-0">
      <div class="content-header row">
        <div class="col-12">
          <form id="filter-form" class="row g-3 mb-4" method="GET" action="{{ route('reports.sms-service-billing') }}">
            <div class="col-md-4">
              <label for="dateFrom" class="form-label">Date From</label>
              <input type="date" id="dateFrom" name="date_from" class="form-control" value="{{ $dateFrom }}">
            </div>
            <div class="col-md-4">
              <label for="dateTo" class="form-label">Date To</label>
              <input type="date" id="dateTo" name="date_to" class="form-control" value="{{ $dateTo }}">
            </div>
            <div class="col-md-4 align-self-end">
              <button type="submit" class="btn btn-primary">Filter</button>
              <a href="{{ route('reports.sms-service-billing') }}" class="btn btn-secondary">Reset</a>
            </div>
          </form>
        </div>
      </div>

      <div class="content-body">
        <div class="row mb-4">
          <div class="col-lg-3 col-sm-6">
            <div class="card">
              <div class="card-body d-flex align-items-center justify-content-between">
                <div>
                  <h3 class="fw-bolder mb-75">
                    {{ number_format($totalTransactionsAmount, 2) }} GEL
                  </h3>
                  <span>ამ თვეში შემოსული თანხა</span>
                </div>
              </div>
            </div>
          </div>

          <div class="col-lg-3 col-sm-6">
            <div class="card">
              <div class="card-body d-flex align-items-center justify-content-between">
                <div>
                  <h3 class="fw-bolder mb-75">
                    {{ number_format($sumOfSmsServiceDebt, 2) }} GEL
                  </h3>
                  <span>SMS სერვისის მიმდინარე დავალიანება</span>
                </div>
              </div>
            </div>
          </div>
        </div>

        <div class="mb-2">
          <a href="{{ route('reports.sms-service-billing.monthlyFile', [
              'date_from' => $dateFrom,
              'date_to' => $dateTo,
          ]) }}"
            class="btn btn-success">
            <i data-feather="file"></i> ყოველთვიური ანგარიში
          </a>
        </div>

        <div class="mb-2">
          <a href="{{ route('reports.sms-service-billing.export', [
              'date_from' => $dateFrom,
              'date_to' => $dateTo,
          ]) }}"
            class="btn btn-success">
            <i data-feather="file"></i> შემოსული თანხის ექსელი
          </a>
        </div>

        <div class="card mb-4">
          <div class="card-header">
            <h4 class="card-title mb-0">SMS სერვისის დავალიანებები</h4>
          </div>
          <div class="card-datatable table-responsive pt-0">
            <table class="sms-service-charges-table table p-2">
              <thead class="table-light">
                <tr>
                  <th>სახელი, გვარი</th>
                  <th>აბონენტის ნომერი</th>
                  <th>თანხა</th>
                  <th>თარიღი</th>
                </tr>
              </thead>
            </table>
          </div>
        </div>

        <div class="card">
          <div class="card-header">
            <h4 class="card-title mb-0">SMS სერვისის გადარიცხვები</h4>
          </div>
          <div class="card-datatable table-responsive pt-0">
            <table class="sms-service-transfers-table table">
              <thead class="table-light">
                <tr>
                  <th>მომხმარებელი</th>
                  <th>აბონენტის ნომერი</th>
                  <th>თანხა</th>
                  <th>გადარიცხვის თარიღი</th>
                </tr>
              </thead>
            </table>
          </div>
        </div>
      </div>
    </div>
  </div>
@endsection

@push('scripts')
  <script>
    $(document).ready(function() {
      feather.replace();
      const commonOptions = {
        processing: true,
        serverSide: true,
        dom: '<"d-flex justify-content-between align-items-center mx-0 row"' +
          '<"col-sm-12 col-md-6"l>' +
          '<"col-sm-12 col-md-6"f>>' +
          't' +
          '<"d-flex justify-content-between mx-0 row"' +
          '<"col-sm-12 col-md-6"i>' +
          '<"col-sm-12 col-md-6"p>>',
        lengthMenu: [
          [10, 25, 50, 75, 100, -1],
          ['10 ჩანაწერი', '25 ჩანაწერი', '50 ჩანაწერი', '75 ჩანაწერი', '100 ჩანაწერი', 'ყველას ჩვენება']
        ],
        pageLength: 25,
        language: {
          url: '/app-assets/data/locales/ka.json'
        }
      };

      $('.sms-service-charges-table').DataTable({
        ...commonOptions,
        ajax: {
          url: "{{ route('reports.sms-service-billing') }}",
          data: function(d) {
            d.table = 'sms_service_charges';
            d.date_from = "{{ $dateFrom }}";
            d.date_to = "{{ $dateTo }}";
          }
        },
        columns: [{
            data: 'user_name',
            name: 'user_name'
          },
          {
            data: 'account_number',
            name: 'user.account_number'
          },
          {
            data: 'amount',
            name: 'amount'
          },
          {
            data: 'created_at_formatted',
            name: 'created_at_formatted'
          },
        ]
      });

      $('.sms-service-transfers-table').DataTable({
        ...commonOptions,
        ajax: {
          url: "{{ route('reports.sms-service-billing') }}",
          data: function(d) {
            d.table = 'sms_service_transfers';
            d.date_from = "{{ $dateFrom }}";
            d.date_to = "{{ $dateTo }}";
          }
        },
        columns: [{
            data: 'user_name',
            name: 'user_name'
          },
          {
            data: 'account_number',
            name: 'user.account_number'
          },
          {
            data: 'amount',
            name: 'amount'
          },
          {
            data: 'created_at_formatted',
            name: 'created_at_formatted'
          },
        ]
      });
    });
  </script>
@endpush