@extends('main')
@section('content')
<div class="row clearfix">
    <div class="col-sm-12">
        <div class="card">
            <div class="card-header">
                <h4><strong>Apply Filter</strong></h4>
            </div>
            <div class="card-body">
             <form method="GET" action="{{ action('CarpetController@areawiseTagging') }}">
                <div class="row">

                    <div class="col-sm-3">
                        {!! Form::select('idUser', [''=>'Select User'] + $ausers, request('idUser'), ['class'=>'form-control']) !!}
                    </div>

                    <div class="col-sm-3">
                        {!! Form::select('status', [
                            ''=>'Select Status',
                            'qrcode'=>'QR Code Assigned',
                            'physical-test'=>'Physical Test Complete',
                            'lab-test'=>'Lab Test Complete',
                            'not-certified'=>'Yet to Certified',
                            'Certified'=>'Certified',
                            'Rejected'=>'Rejected'
                        ], request('status'), ['class'=>'form-control']) !!}
                    </div>

                    <div class="col-sm-3">
                        {!! Form::select('type', [''=>'Select Craft'] + crafts(), request('type'), ['class'=>'form-control']) !!}
                    </div>

                    <div class="col-sm-3">
                        {!! Form::select('district', [''=>'Select District'] + $district, request('district'), ['class'=>'form-control']) !!}
                    </div>

                    <div class="col-sm-3 mt-2">
                        {!! Form::select('area', [''=>'Select Area'] + $area, request('area'), ['class'=>'form-control']) !!}
                    </div>

                    <div class="col-sm-3 mt-2">
                        <input type="text" class="form-control datepicker-default" name="fromDate"
                            placeholder="From Date" >
                    </div>

                    <div class="col-sm-3 mt-2">
                        <input type="text" class="form-control datepicker-default" name="toDate"
                            placeholder="To Date" >
                    </div>

                    <div class="col-sm-3 mt-2">
                        <button class="btn btn-primary w-100">Apply Filters</button>
                    </div>

                </div>
            </form>
            </div>
        </div>
    </div>
</div>

<div class="row clearfix">
    <div class="col-sm-12">
        <div class="card">
            <div class="card-header">
                <h4 class="card-title">User List</h4>
            </div>
            <div class="card-body">
                <div class="table-responsive">
                    <table id="usertable" class="display" style="min-width: 845px">
                        <thead>
                            <tr>
                                <th></th>
                                <th>User/Organisation Name</th>
                                <th>Registration or Authorised</th>
                                <th>Contact Details</th>
                                <th>Date of Registration</th>
                                <th>Address</th>
                                @foreach($craftType as $value)
                                <th>{{$value->name}}</th>
                                @endforeach
                            </tr>
                        </thead>
                        <tbody>
                                                        @foreach($users as $value)
                            <tr>
                                <th scope="row">{{$i}}</th>
                                <td>{{$value->name}}</td>
                                <td>{{$value->gis_no}}</td>
				                <td>{{$value->mobile}}</td>
                                <td>{{\Carbon\Carbon::parse($value->created_at)->format('d-m-Y')}}</td>
                                <td>@if($value->district != "") {{$value->district}}  @endif @if($value->area != "") {{$value->area}} @endif {{$value->pincode}}</td>
                                @php $userCarpet = \App\Carpet::select(DB::raw('COUNT(*) as total'),'type','idUser')->where('idUser', $value->id)->groupBy('type')->get()->pluck('total', 'type')->toArray();                                @endphp

                                @foreach($craftType as $value)
                                <td>@if(array_key_exists($value->name,$userCarpet)) {{$userCarpet[$value->name]}} @endif </td>
                                @endforeach
                            </tr>
                                                        @endforeach
                        </tbody>
                    </table>
                </div>
            </div>
            </section>
        </div>
    </div>
</div>
@stop
@section('script')
<script>
    $(document).ready(function () {
        $('#usertable').DataTable({
            "order": [[0, "asc"]],
            dom: 'Bfrtip',
            buttons: [
                'excel'
            ]
           
        });
    });</script>
<script>
@stop