@extends('layouts.app')

@section('content')
    <section class="section">
        <div class="section-header">
            <h3 class="page__heading">Dashboard</h3>
            <div class="section-header-breadcrumb">
                <a href="{{ url('cekPembayaranSiswa')}}" class="btn btn-primary form-btn">Sinkron Data</a>
            </div>
        </div>
        <div class="section-body">
          <p>
            Tahun Ajaran : <b>{{ $tahunAjaran->tahun }}</b>
            <br>Bulan : <b>{{ $bulan }}</b>
          </p>
            <div class="row">
                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                  <div class="card card-statistic-1 pb-3">
                   {{--  <div class="card-icon bg-primary">
                      <i class="far fa-user"></i>
                    </div> --}}
                    <div class="card-wrap">
                      <div class="card-header">
                        <h4>Jumlah Siswa Bayar</h4>
                      </div>
                      <div class="card-body">
                        {{ $jumlahSiswaBayar }}
                      </div>
                    </div>
                  </div>
                </div>
                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                  <div class="card card-statistic-1 pb-3">
                    {{-- <div class="card-icon bg-danger">
                      <i class="far fa-newspaper"></i>
                    </div> --}}
                    <div class="card-wrap">
                      <div class="card-header">
                        <h4>Jumlah Siswa Nunggak</h4>
                      </div>
                      <div class="card-body">
                        0
                      </div>
                    </div>
                  </div>
                </div>
                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                  <div class="card card-statistic-1 pb-3">
                    {{-- <div class="card-icon bg-warning">
                      <i class="far fa-file"></i>
                    </div> --}}
                    <div class="card-wrap">
                      <div class="card-header">
                        <h4>Total Pemasukkan</h4>
                      </div>
                      <div class="card-body">
                        Rp {{ number_format($debit, 0,',','.') }}
                      </div>
                    </div>
                  </div>
                </div>
                <div class="col-lg-3 col-md-6 col-sm-6 col-12">
                  <div class="card card-statistic-1 pb-3">
                    {{-- <div class="card-icon bg-success">
                      <i class="fas fa-circle"></i>
                    </div> --}}
                    <div class="card-wrap">
                      <div class="card-header">
                        <h4>Total Pengeluaran</h4>
                      </div>
                      <div class="card-body">
                        Rp {{ number_format($kredit, 0,',','.') }}
                      </div>
                    </div>
                  </div>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-8 col-md-12 col-12 col-sm-12">
                    <div class="card">
                        <div class="card-header">
                          <h4>Statistics</h4>
                          {{-- <div class="card-header-action">
                            <div class="btn-group">
                              <a href="#" class="btn btn-primary">Week</a>
                              <a href="#" class="btn">Month</a>
                            </div>
                          </div> --}}
                        </div>
                        <div class="card-body">
                            <div class="chartjs-size-monitor" style="position: absolute; inset: 0px; overflow: hidden; pointer-events: none; visibility: hidden; z-index: -1;"><div class="chartjs-size-monitor-expand" style="position:absolute;left:0;top:0;right:0;bottom:0;overflow:hidden;pointer-events:none;visibility:hidden;z-index:-1;"><div style="position:absolute;width:1000000px;height:1000000px;left:0;top:0"></div></div><div class="chartjs-size-monitor-shrink" style="position:absolute;left:0;top:0;right:0;bottom:0;overflow:hidden;pointer-events:none;visibility:hidden;z-index:-1;"><div style="position:absolute;width:200%;height:200%;left:0; top:0"></div></div>
                            </div>
                          <canvas id="myChart" height="700" width="1154" class="chartjs-render-monitor" style="display: block; height: 350px; width: 577px;"></canvas>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
@endsection
@section('scripts')
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.9.4/Chart.min.js"></script>
<script type="text/javascript">
var statistics_chart = document.getElementById("myChart").getContext('2d');

var myChart = new Chart(statistics_chart, {
  type: 'line',
  data: {
    labels: [
      @if(count($dateArr) != 0)
      @foreach($dateArr as $date)
      "{{ date('d M, Y', strtotime($date)) }}",
      @endforeach
      @endif
    ],
    datasets: [{
      label: 'Statistics',
      data: [
        @if(count($dateArr) != 0)
        @foreach($dateArr as $date)
        @php
        $table = DB::table('transaction')
            ->join('pembayaran', 'transaction.id_pembayaran', '=', 'pembayaran.id')
            ->join('jenis_pembayaran', 'pembayaran.id_jenis_pembayaran', '=', 'jenis_pembayaran.id')
            ->whereDate('transaction.created_at', $date)
            ->sum('tarif');
        @endphp
        "{{ $table }}",
        @endforeach
        @endif
      ],
      borderWidth: 5,
      borderColor: '#6777ef',
      backgroundColor: 'transparent',
      pointBackgroundColor: '#fff',
      pointBorderColor: '#6777ef',
      pointRadius: 4
    }]
  },
  options: {
    legend: {
      display: false
    },
    scales: {
      yAxes: [{
        gridLines: {
          display: false,
          drawBorder: false,
        },
        ticks: {
          stepSize: 0
        }
      }],
      xAxes: [{
        gridLines: {
          color: '#fbfbfb',
          lineWidth: 2
        }
      }]
    },
  }
});
</script>
@endsection