@extends('Admin/layout')
@section('title','Sales Data')
@section('content')
@if(has_permission('Sales Data','View'))
<div class="container-fluid">
    <div class="row">
        <div class="col-lg-12">
            <div class="card">
                <div class="card-header align-items-center d-flex">
                    <h4 class="card-title mb-0 flex-grow-1">Sales Data</h4>
                    <div class="flex-shrink-0">
                           <div class="form-check form-switch form-switch-right form-switch-md">
                            <a href="{{route('visitportal.salesDataImport')}}"><button type="button" class="btn btn-primary">Import Sales Data</button></a>
                           </div>
                     </div>
                </div>
                <div class="card-header align-items-center d-flex">
                   
                <form action="{{route('visitportal.saleDataList')}}" class="g-3" method="post" style="width:100%;">
                        {{csrf_field()}}
                        <div class="row" >

                        <div class="col-md-2" >
                                <label for="validationDefault01" class="form-label">Year</label>
                                <select id="ddlstatus" data-choices name="year" class="form-control" >
                                    <option value="">Select Year</option>
                                    
                                        @for($i = $start_year;  $i <= $end_year; $i++ )
                                            <option value="{{$i}}" {{$year == $i ? 'selected' : '' }}>{{$i}}</option>
                                        @endfor
                                    

                                </select>
                            </div>

                            <div class="col-md-2" >
                                <label for="validationDefault01" class="form-label">Month</label>
                                <select id="ddlstatus" data-choices name="month" class="form-control" >
                                    <option value="">Select Month</option>
                                    @if($months)
                                        @foreach($months as $key => $value)
                                            <option value="{{$key + 1}}" {{$month == ($key + 1) ? 'selected' : '' }}>{{$value}}</option>
                                        @endforeach
                                    @endif

                                </select>
                            </div>
                            

                            <div class="col-md-1">
                                <div class="form-group" style="margin-top: 6px;">
                                    <input id="btnsearch" type="submit" name="submitbtn" class="form-control btn btn-primary"  style="margin-top: 20px;width:100%" value="Filter">
                                </div>
                            </div>
                           
                        </div>
                        </form>
                </div>
            </div>
        </div>
        <div class="col-xl-12">
            <div class="card">
              

                <div class="card-body">
                    <div class="live-preview" style="padding: 20px;">
                        <div class="table-responsive table-card mb-1">
                            <table class="table table-sm align-middle table-nowrap mb-0" id="example" style="width:100%">
                                <thead class="table-dark">
                                    <tr>

                                        <th scope="col">Year</th>
                                        <th scope="col">Month</th>

                                        <th scope="col">Associate Name</th>
                                        <th scope="col">Sum of Area</th>
                                        <th scope="col">Rera Number</th>
                                        <th scope="col">Pin </th>
                                        <th scope="col">Upline Name</th>

                                        <th scope="col">Date</th>
                                        <th scope="col">File Name</th>
                                        <th scope="col">Entry By</th>


                                    </tr>
                                </thead>
                                <tbody>
                                    @php
                                    $months = array('January','February','March','April','May','June','July ','August','September','October','November','December');
                                    @endphp
                                    @if(!empty($lists))
                                        @foreach($lists as $key => $value)
                                        <tr>
                                            <!-- <td>{{$value->id}}</td> -->
                                            <td>{{$value->year}}</td>
                                            <td>{{$months[$value->month - 1]}}</td>

                                            <td>{{$value->associatename}}</td>
                                            <td>{{$value->sum_of_areas}}</td>
                                            <td>{{$value->rera_no}}</td>
                                            <td>{{$value->pin}}</td>
                                            <td>{{$value->upliner}}</td>

                                            <td>{{$value->created_at}}</td>
                                            <td>{{$value->filename}}</td>
                                            <td>{{$value->fullname}} </td>
                                        
                                        </tr>
                                        @endforeach
                                    @endif
                                </tbody>
                                
                            </table>
                            <!-- end table -->
                        </div>
                        <!-- end table responsive -->
                    </div>
                    
                </div><!-- end card-body -->
            </div><!-- end card -->
        </div><!-- end col -->
    </div>
</div>



<link href="https://cdn.datatables.net/2.0.8/css/dataTables.dataTables.css" rel="stylesheet" type="text/css" />
<script src="{{ URL::asset('assets/js/jquery.min.js') }}"></script>
<script src="https://cdn.datatables.net/2.0.8/js/dataTables.js"></script>

<script>
//    new DataTable('#example');
   $('#example').dataTable({
    // "pageLength": -1,  //display all records
    "order": [[ 0, "desc" ]] // Sort by first column descending
});


</script>
@endif
@endsection