@extends('dashboard.layout.layout')

@section('content')
  <!-- BEGIN: 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>
      <div class="content-body">
        <section class="app-user-list">
          <div class="card">
            <div class="card-header">
              <h4 class="card-title mb-3">{{ $title }}
                <br>
                <span class="badge bg-success">გაფილტრული ტრანზაქციების ჯამი: {{ number_format($sum, 2) }} ₾</span>
              </h4>
              @can('reports.store')
                <button type="button" class="btn btn-success waves-effect mb-3" data-bs-toggle="modal"
                  data-bs-target="#addTransaction">
                  <i data-feather='plus'></i> ტრანზაქციის დამატება
                </button>
              @endcan
            </div>
            <div class="container">
              <!-- Filter Form -->
              <form method="GET" action="{{ route('reports.show', 1) }}" class="row pe-2 ps-2" id="filterForm">
                <div class="from-group col-md-3 mb-2">
                  <input type="text" name="account_number"
                    @if (request()->has('account_number')) value="{{ request('account_number') }}" @endif
                    placeholder="აბონენტის ნომერი" class="form-control">
                </div>
                <div class="from-group col-md-3 mb-2">
                  <select name='user_status' class="form-control">
                    <option value="">აბონენტის სტატუსი</option>
                    <option value="on" {{ request('user_status') == 'on' ? 'selected' : '' }}>ჩართული</option>
                    <option value="off" {{ request('user_status') == 'off' ? 'selected' : '' }}>გამორთული</option>
                  </select>
                </div>
                <div class="from-group col-md-3 mb-2">
                  <select name="provider_id" class="form-select select2" data-placeholder="პროვაიდერი">
                    <option value="">პროვაიდერი</option>
                    @foreach ($providers as $provider)
                      <option @if (request()->has('provider_id') && request('provider_id') == $provider->id) selected @endif value="{{ $provider->id }}">
                        {{ $provider->name }}</option>
                    @endforeach
                  </select>
                </div>
                <div class="from-group col-md-3 mb-2">
                  <select name="service_id" class="form-select select2" data-placeholder="სერვისი">
                    <option value="">სერვისი</option>
                    @foreach ($services as $service)
                      <option @if (request()->has('service_id') && request('service_id') == $service->id) selected @endif value="{{ $service->id }}">
                        {{ $service->name }}</option>
                    @endforeach
                  </select>
                </div>
                <div class="from-group col-md-3 mb-2">
                  <select name="block_id" class="form-select select2" data-placeholder="კორპუსი">
                    <option value="">კორპუსი</option>
                    @foreach ($blocks as $block)
                      <option @if (request()->has('block_id') && request('block_id') == $block->id) selected @endif value="{{ $block->id }}">
                        {{ $block->name }}</option>
                    @endforeach
                  </select>
                </div>
                <div class="from-group col-md-3 mb-2">
                  <input type="text" name="date_from" class="bg-white form-control flatpickr-basic flatpickr-input"
                    @if (request()->has('date_from')) value="{{ request('date_from') }}" @endif
                    placeholder="თარიღი დან" />
                </div>
                <div class="from-group col-md-3 mb-2">
                  <input type="text" name="date_to" class="bg-white form-control flatpickr-basic flatpickr-input"
                    @if (request()->has('date_to')) value="{{ request('date_to') }}" @endif placeholder="თარიღი მდე" />
                </div>
                <div class="from-group col-md-3 mb-2">
                  <button class="btn btn-success w-100" type="submit"><i data-feather='search'></i> გაფილტვრა</button>
                </div>
              </form>
            </div>
            <div class="card-body">
              <div class="alert alert-info p-1 mb-2">
                ერთი გადახდა შეიძლება დაიყოს რამდენიმე ტიპად (მაგ. ტელეფონი + ძირითადი), ამიტომ ერთი და იგივე ტრანზაქციის ID
                შესაძლოა რამდენიმე სტრიქონად გამოჩნდეს.
              </div>
              <!-- Custom Export Buttons -->
              <div class="mb-2">
                <button class="btn btn-success me-1" id="exportExcel">
                  <i data-feather="file-text"></i> Excel (სრული შედეგი)
                </button>
                <button class="btn btn-info me-1" id="exportCsv">
                  <i data-feather="download"></i> CSV (სრული შედეგი)
                </button>
              </div>

              <div class="card-datatable table-responsive p-1">
                <table class="table table-striped" id="reportsTable">
                  <thead>
                    <tr>
                      <th>სახელი, გვარი</th>
                      <th>აბონენტის ნომერი</th>
                      <th>კორპუსი</th>
                      <th>თანხა</th>
                      <th>ბანკი</th>
                      <th>სტატუსი</th>
                      <th>სერვისი</th>
                      <th>ტრანაქციის ID</th>
                      <th>ტრანზაქციის ტიპი</th>
                      <th>კომენტარი</th>
                      <th>თარიღი</th>
                      <th>დრო</th>
                    </tr>
                  </thead>
                  <tbody>
                    <!-- DataTables will populate this -->
                  </tbody>
                  <tfoot>
                    <tr>
                      <th>სახელი, გვარი</th>
                      <th>აბონენტის ნომერი</th>
                      <th>კორპუსი</th>
                      <th>ჯამი: {{ number_format($sum, 2) }} ₾</th>
                      <th>ბანკი</th>
                      <th>სტატუსი</th>
                      <th>სერვისი</th>
                      <th>ტრანაქციის ID</th>
                      <th>ტრანზაქციის ტიპი</th>
                      <th>კომენტარი</th>
                      <th>თარიღი</th>
                      <th>დრო</th>
                    </tr>
                  </tfoot>
                </table>
              </div>
            </div>
          </div>
        </section>
      </div>
    </div>
  </div>
  <!-- END: Content-->

  @can('reports.store')
    <!-- Add Transaction Modal -->
    <div class="modal fade text-start modal-success" id="addTransaction" tabindex="-1" aria-labelledby="addTransaction"
      aria-hidden="true">
      <div class="modal-dialog modal-dialog-centered">
        <form class="modal-content" method="POST" action="{{ route('reports.store') }}">
          @csrf
          <div class="modal-header">
            <h5 class="modal-title">ტრანსაქციის დამატება</h5>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
          </div>
          <div class="modal-body">
            <div class="row justify-content-between">
              <div class="form-group col-6">
                <label for="account_number">აბონენტის ნომერი</label>
                <input type="text" name="account_number" class="form-control" id="account_number"
                  placeholder="აბონენტის ნომერი" required>
              </div>
              <div class="form-group col-6">
                <label for="amount">თანხა</label>
                <input type="text" name="amount" class="form-control" id="amount" placeholder="თანხა" required>
              </div>
              <div class="form-group col-12 mt-3">
                <label for="datetime">თარიღი (ამ ფორმატით: {{ \Carbon\Carbon::now() }})</label>
                <input type="text" name="datetime" class="form-control" id="datetime"
                  placeholder="{{ \Carbon\Carbon::now() }}">
              </div>
            </div>
          </div>
          <div class="modal-footer">
            <button type="submit" class="btn btn-success">დამატება</button>
          </div>
        </form>
      </div>
    </div>
    <!-- Edit Comment Modal -->
    <div class="modal fade text-start modal-success" id="editComment" tabindex="-1" aria-labelledby="editComment"
      aria-hidden="true">
      <div class="modal-dialog modal-dialog-centered">
        <div class="modal-content" id="commentSubmit">
          <div class="modal-header">
            <h5 class="modal-title">კომენტარის რედაქტირება</h5>
            <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
          </div>
          <div class="modal-body">
            <div class="row justify-content-between">
              <input type="hidden" name="_token" id="CSRFtoken" value="{{ csrf_token() }}" />
              <input id="transactionId" value="" hidden />
              <div class="form-group col-12">
                <label for="commentInput">კომენტარი</label>
                <textarea name="commentInput" rows="5" class="form-control" id="commentInput" placeholder="კომენტარი"></textarea>
              </div>
            </div>
          </div>
          <div class="modal-footer">
            <button type="submit" id="saveComment" class="btn btn-success">შენახვა</button>
          </div>
        </div>
      </div>
    </div>
  @endcan
@endsection

@push('scripts')
  <!-- DataTables and RowGroup scripts -->
  <script src="https://cdn.datatables.net/buttons/2.3.2/js/dataTables.buttons.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.2/moment.min.js"></script>
  <script src="https://cdn.datatables.net/datetime/1.2.0/js/dataTables.dateTime.min.js"></script>
  <script src="https://cdn.datatables.net/rowgroup/1.1.5/js/dataTables.rowGroup.min.js"></script>


  <script>
    function editComment(value) {
      $('#commentSubmit').attr('action', '/reports/' + value);
      $.get("/reports/" + value + "/edit", function(data) {
        $('#commentInput').val(data.comment)
        $('#transactionId').val(value)
      });
    }

    // Save comment functionality
    $('#saveComment').click(function(e) {
      e.preventDefault();
      let commentInput = $('#commentInput').val();
      let id = $('#transactionId').val();

      $.ajax({
        url: '/reports/' + id,
        type: 'PUT',
        data: {
          "_token": "{{ csrf_token() }}",
          comment: commentInput
        },
        success: function(res) {
          if (res.success === 1) {
            $('#editComment').modal('hide');

            new Notify({
              title: 'Success',
              text: 'კომენტარი განახლდა',
              status: 'success',
              autoclose: true,
              effect: 'slide',
              type: 2,
              autotimeout: 3500
            });
            $('#reportsTable').DataTable().ajax.reload();
          }
        }
      });
    });

    // Function to get current filter parameters
    function getFilterParams() {
      return {
        account_number: $('input[name=account_number]').val() || '',
        user_status: $('select[name=user_status]').val() || '',
        provider_id: $('select[name=provider_id]').val() || '',
        service_id: $('select[name=service_id]').val() || '',
        block_id: $('select[name=block_id]').val() || '',
        date_from: $('input[name=date_from]').val() || '',
        date_to: $('input[name=date_to]').val() || ''
      };
    }

    // Export Excel button click handler
    $(document).on('click', '#exportExcel', function() {
      let params = new URLSearchParams(getFilterParams());
      params.append('format', 'excel');
      window.location.href = "{{ route('reports.export') }}?" + params.toString();
    });

    // Export CSV button click handler
    $(document).on('click', '#exportCsv', function() {
      let params = new URLSearchParams(getFilterParams());
      params.append('format', 'csv');
      window.location.href = "{{ route('reports.export') }}?" + params.toString();
    });

    $(function() {
      const colors = {
        '2023-10-01': 'rgba(200, 230, 201, 0.3)',
        '2023-10-02': 'rgba(179, 229, 252, 0.3)',
        // Additional dates and colors as needed
      };

      $('#reportsTable').DataTable({
        dom: 'lfrtip',
        lengthMenu: [
          [25, 50, 75, 100],
          ['25 ჩანაწერი', '50 ჩანაწერი', '75 ჩანაწერი', '100 ჩანაწერი']
        ],
        processing: true,
        serverSide: true,
        ajax: {
          url: "{{ route('reports.show', 1) }}",
          data: function(d) {
            d.account_number = $('input[name=account_number]').val();
            d.user_status = $('select[name=user_status]').val();
            d.provider_id = $('select[name=provider_id]').val();
            d.service_id = $('select[name=service_id]').val();
            d.block_id = $('select[name=block_id]').val();
            d.date_from = $('input[name=date_from]').val();
            d.date_to = $('input[name=date_to]').val();
          },
          dataSrc: function(json) {
            // Update the sum dynamically
            if (json.sum !== undefined) {
              $('table tfoot th:contains("ჯამი")').html(`ჯამი: ${json.sum.toFixed(2)} ₾`);
              $('.badge.bg-success').text(`გაფილტრული ტრანზაქციების ჯამი: ${json.sum.toFixed(2)} ₾`);
            }
            return json.data; // Continue with the normal data
          }
        },
        columns: [{
            data: 'name',
            name: 'name'
          },
          {
            data: 'account',
            name: 'account'
          },
          {
            data: 'block',
            name: 'block'
          },
          {
            data: 'amount',
            name: 'amount'
          },
          {
            data: 'provider',
            name: 'provider'
          },
          {
            data: 'status',
            name: 'status'
          },
          {
            data: 'service',
            name: 'service'
          },
          {
            data: 'tnx_id',
            name: 'tnx_id'
          },
          {
            data: 'tnx_type',
            name: 'tnx_type'
          },
          {
            data: 'comment',
            name: 'comment',
            className: 'text-center'
          },
          {
            data: 'paid_at',
            name: 'paid_at'
          },
          {
            data: 'time',
            name: 'time'
          }
        ],
        rowGroup: {
          dataSrc: 'created_at',
          startRender: function(rows, group) {
            var formattedDate = moment(group, 'YYYY-MM-DD HH:mm:ss').format('DD MMMM YYYY HH:mm:ss');
            var transactionCount = rows.count();

            return formattedDate;
          }
        },
        rowCallback: function(row, data, index) {
          let date = data.paid_at;
          let color = colors[date] || 'rgba(225, 225, 225, 0.3)'; // Default color if date not in colors map
          $(row).css('background-color', color);
        },
        drawCallback: function(settings) {
          feather.replace();
        },
        language: {
          url: '/app-assets/data/locales/ka.json'
        }
      });

      $('.select2').each(function() {
        $(this).select2({
          dropdownParent: $('body')
        });
      });

      $('.flatpickr-basic').flatpickr({
        dateFormat: "Y-m-d"
      });

      $('#filterForm').on('submit', function(e) {
        e.preventDefault();
        $('#reportsTable').DataTable().ajax.reload();
      });
    });
  </script>
@endpush