@extends("backend.layout-sticky.master")

@section("title")
    Statistik product - Sistem Klinik
@endsection

@push('css')
<link href="{{asset('sb-admin2/css/sb-admin-2.min.css')}}" rel="stylesheet">

<link rel="stylesheet" href="{{asset('adminlte/plugins/datatables-bs4/css/dataTables.bootstrap4.min.css')}}">
<link rel="stylesheet" href="{{asset('adminlte/plugins/datatables-responsive/css/responsive.bootstrap4.min.css')}}">
<link rel="stylesheet" href="{{asset('adminlte/plugins/datatables-buttons/css/buttons.bootstrap4.min.css')}}">
<style>
.header-clear-medium {
  padding-top: calc(70px + (env(safe-area-inset-top))*0.8) !important;
}
</style>
@endpush

@section ('back')
<a href="#" data-back-button="" class="header-icon header-icon-1"><i class="fas fa-arrow-left"></i></a>
<!-- <a href="{{route('dashboard')}}" class="header-icon header-icon-1"><i class="fas fa-arrow-left"></i></a> -->
@endsection

@section ('content')

<div class="container-fluid">

  <section class="content-header">
    <div class="container-fluid breadcrumb-container">
      <div class="row mb-2">
          <div class="col-md-3 mb-2">
              <div class="card border-left-success shadow h-10 py-2">
                  <div class="card-body" style="padding-top: 1px; padding-bottom: 1px;">
                      <div class="row no-gutters align-items-center">
                          <div class="col mr-2">
                              <div class="text-xs font-weight-bold text-success text-uppercase mb-1">
                                  Jumlah Pembayaran</div>
                              <div class="h6 mb-0 font-weight-bold text-gray-800" id="total_selesai">0</div>
                          </div>
                          <div class="col-auto">
                              <i class="fas fa-fw fa-tachometer-alt fa-2x text-gray-300"></i>
                          </div>
                      </div>
                  </div>
              </div>
          </div>
      </div>
    </div><!-- /.container-fluid -->
  </section>

  <!-- Page Heading -->

  <!-- DataTales Example -->
  <div class="card shadow mb-4">
      <div class="card-header py-3">
        <div class="row" style="margin-bottom: 0px;">
          <div class="col-8">
            <h6 class="m-0 font-weight-bold text-primary w-75 p-2">Statistik product</h6>

          </div>
        </div>
      </div>
        <div class="card-body">
          <div class="row mb-2">

            <div class="col-3">
              <input type="date" value="" class="form-control rounded-round" name="filterstartdate" id="filterstartdate" placeholder="Start Date"/>
            </div>
            <div class="col-3">
              <input type="date" value="" class="form-control rounded-round" name="filterenddate" id="filterenddate" placeholder="End Date"/>
            </div>
            <div class="col-3">
              <select class="form-control" name="filterproduct_id" id="filterproduct_id">
                <option value="0">-- Pilih Product --</option>
                @foreach ($product as $value)
                  <option value="{{$value->id}}" @if (isset($product_id) && $product_id == $value->nama) selected @endif>{{$value->nama}}</option>
                @endforeach

              </select>
            </div>
            <!-- <div class="col-3">
              <select class="form-control" name="filterklinik" id="filterklinik">
                <option value="0" >Pilih Klinik</option>
                @foreach ($klinik as $key => $value)
                  <option value="{{$value->id}}" {{ $klinik_id == $value->id ? "selected" : "" }} >{{$value->nama}}</option>
                @endforeach
              </select>
            </div> -->

          </div>
            <div class="table-responsive">
                <table class="table table-bordered" id="table-index" width="100%" cellspacing="0">
                    <thead>
                        <tr>
                          <th>#</th>
                          <th>Tanggal</th>
                          <th>Nama</th>
                          <th>No RM</th>
                          <th>Product</th>
                          <th>Jumlah</th>
                          <th>Harga Satuan</th>
                          <th>Total Harga</th>
                        </tr>
                    </thead>
                    <tbody>

                    </tbody>
                </table>
            </div>
        </div>
    </div>

</div>

@endsection

@push('js')
<!-- Page level custom scripts -->
<script src="{{asset('adminlte/plugins/datatables/jquery.dataTables.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-responsive/js/dataTables.responsive.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-responsive/js/responsive.bootstrap4.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-buttons/js/dataTables.buttons.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-buttons/js/buttons.bootstrap4.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/jszip/jszip.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/pdfmake/pdfmake.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/pdfmake/vfs_fonts.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-buttons/js/buttons.html5.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-buttons/js/buttons.print.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/datatables-buttons/js/buttons.colVis.min.js')}}"></script>
<script src="{{asset('adminlte/plugins/toastr/toastr.min.js')}}"></script>
<script src="{{url('https://cdnjs.cloudflare.com/ajax/libs/bootstrap-daterangepicker/3.0.5/daterangepicker.min.js')}}"></script>
<script src="{{url('https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.29.4/moment.min.js')}}"></script>

<script>

      var patientID = "";
      var noRM = "";

      var table = null;

      var today = new Date();

      var startdate = $("#filterstartdate").val()
      var enddate = $("#filterenddate").val()
      var product_id = $("#filterproduct_id").val()
      var klinik_id = $("#filterklinik").val()

      var dd = String(today.getDate()).padStart(2, '0');
      var mm = String(today.getMonth() + 1).padStart(2, '0'); //January is 0!
      var yyyy = today.getFullYear();

      today = yyyy + '-' + mm + '-' + dd;

      $(document).ready(function(){
        table = $('#table-index').DataTable({
          processing: true,
          serverSide: true,
          lengthChange: false,
          searching : true,
          paging: true,
          ordering: false,
          language: {
              search: '<span>Search:</span> _INPUT_',
              lengthMenu: '<span>Show:</span> _MENU_',
              paginate: { 'first': 'First', 'last': 'Last', 'next': '→', 'previous': '←' }
          },
          dom: 'Bfrtip',
          buttons: [
            'excelHtml5',
            'csvHtml5',
            'pdfHtml5'
          ],
          ajax: {
              url: "{{ route('dashboard.statistik.productLists') }}",
              data: function (d) {
                  return $.extend({}, d, {
                    startdate: $("#filterstartdate").val(),
                    enddate: $("#filterenddate").val(),
                    product_id: $("#filterproduct_id").val(),
                    klinik_id: $("#filterklinik").val(),
                  });
              },
          },

          columns: [
              {data: 'DT_RowIndex', name: 'DT_RowIndex'},
              {data: 'tanggal', name: 'tanggal'},
              {data: 'pasien', name: 'pasien'},
              {data: 'no_rm', name: 'no_rm'},
              {data: 'nama_product', name: 'nama_product'},
              {data: 'jumlah', name: 'jumlah'},
              {data: 'harga_satuan', name: 'harga_satuan'},
              {data: 'total_harga', name: 'total_harga'},
          ],
        });
      });

      $('#filterstartdate').change(function(){
          table.draw();
          startdate = $("#filterstartdate").val()
          updateTotal(startdate, enddate, product_id, klinik_id)
      });

      $('#filterenddate').change(function(){
          table.draw();
          enddate = $("#filterenddate").val()
          updateTotal(startdate, enddate, product_id, klinik_id)
      });

      $('#filterproduct_id').change(function(){
          table.draw();
          product_id = $("#filterproduct_id").val()
          updateTotal(startdate, enddate, product_id, klinik_id)
      });

      $('#filterklinik').change(function(){
          table.draw();
          klinik_id = $("#filterklinik").val()
          updateTotal(startdate, enddate, product_id, klinik_id)
      });

      updateTotal(startdate, enddate, product_id, klinik_id)
      function updateTotal(startdate, enddate, product_id, klinik_id){

        $.ajax({
            url:"{{ route('dashboard.statistik.product.getTotal') }}",
            method:"GET",
            data:{startdate: startdate, enddate: enddate, product_id: product_id, klinik_id:klinik_id},
            success:function(res){
              console.log(res);
              $("#total_selesai").text("Rp. "+addCommas(res.data))
            }
          })
      }

      function addCommas(nStr)
        {
            nStr += '';
            x = nStr.split('.');
            x1 = x[0];
            x2 = x.length > 1 ? '.' + x[1] : '';
            var rgx = /(\d+)(\d{3})/;
            while (rgx.test(x1)) {
                x1 = x1.replace(rgx, '$1' + ',' + '$2');
            }
            return x1 + x2;
        }


  $(function () {
    $("#example1").DataTable({
      "responsive": true, "lengthChange": false, "autoWidth": false,
      "buttons": ["copy", "csv", "excel", "pdf", "print", "colvis"]
    }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');
    $('#example2').DataTable({
      "paging": true,
      "lengthChange": false,
      "searching": false,
      "ordering": true,
      "info": true,
      "autoWidth": false,
      "responsive": true,
    });
  });
</script>
@endpush