@extends('layouts.layout')

@section('title', 'Stats')
<!-- @section('content') -->
@section('content')

<!--maintainance code -->
<section class="dashboard-inner mb-5">
  <div class="permission-block">
    <div class="dashboard-header">
      <h3>Stats</h3>
        <div class="user-select-group select-auto align-items-start flex-wrap">
          <div class="form-wrap  floating-label">
            <select class="form-select ml-3 floating-select" id="terms" name="terms" onchange="getstatsfilterdata(this.value)">
                <option value="">Terms</option>
                @if($terms)
                        @foreach($terms as $term)
                        <option value="{{ $term->id }}" {{(($searchterms == $term->id) ? "selected" : "")}} >{{ $term->term_name}}</option>
                        @endforeach
                @endif
            </select>
            <label class="floating-text">Terms</label>
          </div>
           @if (!empty($searchterms))
                    <div >
                        <button onclick="clear_filter()" class="btn">Clear</button>
                    </div>
                @endif
        </div>
    </div>
    
    <div class=" table-wrap-stats with-mark ">
      <table id="example1" class="table table-bordered table-striped">
        <thead>
            <tr class="custom-pdf-row">
                <th colspan="3"></th>
                <th colspan="2">
                    <span class="thead-text">Number Of Bookings</span>
                </th>
                <th colspan="{{count($classdetails)}}">
                <span class="thead-text">Available Places</span>
                </th>
                <th colspan="{{count($classdetails)}}">
                <span class="thead-text">New Students</span>
                </th>
                <th colspan="4"></th>
            </tr>
          <tr>
            <th>Franchise</th>
            <th>Customers</th>
            <th>Renewals Not Booked</th>
            <th>This Term</th>
            <th>Last Term</th>
             @foreach($classdetails as $classdetail)
            <th class="age-txt">{!! $classdetail->class_age_from !!}-{!! $classdetail->class_age_to !!}</th>
            <!-- <th  class="age-txt">5-6</th> -->
            @endforeach
            <!-- <th>Main Sch</th> -->
            @foreach($classdetails as $classdetail)
            <th class="age-txt">{!! $classdetail->class_age_from !!}-{!! $classdetail->class_age_to !!}</th>
            <!-- <th  class="age-txt">5-6</th> -->
            @endforeach
            <!-- <th  class="age-txt">3-4</th>
            <th  class="age-txt">5-6</th>
            <th>Main Sch</th> -->
            <th>Cancel</th>
            <th>Invoiced</th>
            <th>Renewing Ct</th>
            <th>Renewing %</th>
          </tr>
        </thead>
        <tbody>
          @foreach($data as $franchisesdata)
          <tr>
            <td>{!! $franchisesdata['name'] !!}</td>
            <td>{!! $franchisesdata['booking_details_count'] !!}</td>
            <td>0</td>
            <td>{!! $franchisesdata['thistermscount'] !!}</td>
            <td>{!! $franchisesdata['lasttermscount'] !!}</td>
            @foreach($franchisesdata['total_available'] as $total_available)
              <td>{{(!empty($total_available['totalbooking_available']))?$total_available['totalbooking_available']:'0'}}</td>
            @endforeach
            @foreach($classdetails as $classdetail)
            <td>0</td>
            @endforeach
            <td>{!! $franchisesdata['renewcancelbooking_details_count'] !!}</td>
            <td>{!! (!empty($franchisesdata['totalamount']))? $franchisesdata['totalamount'] : '0' !!}</td>
            <td>{!! (!empty($franchisesdata['renewalbooking']))? $franchisesdata['renewalbooking'] : '0' !!}</td>
            <td>{!! round($franchisesdata['renewing_per'], 2) !!}</td>
            <!-- <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td> -->
          </tr>
          @endforeach
          <!--  <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
          <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
          <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
          <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
          <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
          <tr>
            <td>Jigsaw Arts Balham</td>
            <td>2</td>
            <td>2</td>
            <td>126</td>
            <td>119</td>
            <td>0</td>
            <td>-6</td>
            <td>-2</td>
            <td>8</td>
            <td>0</td>
            <td>1</td>
            <td>3</td>
            <td>10908.2</td>
            <td>116</td>
            <td>98</td>
          </tr>
           -->
        </tbody>
      </table>
    </div>
  </div>
  </div>
</section>
<script type="text/javascript">
  function getstatsfilterdata(value){
     $('#clear').show();
       $('.table-wrap-customer .table').DataTable().ajax.reload();
  }
  function clear_filter(){
        location.href = "{{url('stats')}}";
    }

</script>
<script type="text/javascript">    
    $(function () {
         var table = $(".table-wrap-stats .table").DataTable({
            processing: true,
        language: {
            searchPlaceholder: "Search",
        },
         dom: '<"custom-table-info"<"custom-table-left"B><"custom-table-right"frlp>><"custom-table"t>p',

        language: {
            searchPlaceholder: "Search",
            "lengthMenu": '<select class="form-select">'+
            '<option value="50">Show: 50</option>'+
            '<option value="75">Show: 75</option>'+
            '<option value="100">Show: 100</option>'+
            '<option value="150">Show: 150</option>'+
            '<option value="300">Show: 300</option>'+
            '<option value="-1">Show: All</option>'+
            '</select> '
        },
        
        ordering: true,
         order: [],
         pageLength: 50,
        buttons: [{
                extend: "excelHtml5",
                orientation: "landscape",
                pageSize: "LEGAL",
            },
            {
                extend: "pdfHtml5",
                orientation: "landscape",
                pageSize: "LEGAL",
            },
            {
                extend: "print",
                customize: function (win) {
                    $(win.document.body).css("font-size", "10pt");

                    $(win.document.body)
                        .find("table")
                        .addClass("compact")
                        .css("font-size", "inherit");
                },
            },
            ],
       
        "fnDrawCallback": function (oSettings, json) {
           // console.log($('.table-custom-wrap').find(".dataTables_paginate").eq(0).find('span').find("a").length);
              $("html, body").animate(
                {
                    scrollTop: $(".table-wrap-stats").offset().top,
                },
                "slow"
            );

            if($('.table-wrap-stats').find(".dataTables_paginate").eq(0).find('span').find("a").length > 1){

                $('.table-wrap-stats').find(".dataTables_paginate").show();
            }else{
                 $('.table-wrap-stats').find(".dataTables_paginate").hide();
            }
        }
        
    });
    });
</script>
@endsection