@extends('admin.layout.app')
@section('title', ' Job Insurance Report ')
@push('headerscript')
    <link href="{{ asset('theme/plugins/bootstrap-datepicker/css/bootstrap-datepicker.min.css') }}" rel="stylesheet">
    <link href="{{ asset('theme/plugins/datatables/responsive.bootstrap.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ asset('theme/plugins/datatables/dataTables.bootstrap.min.css') }}" rel="stylesheet" type="text/css" />
    <link href="{{ asset('theme/css/custom.css') }}" rel="stylesheet" type="text/css" />
@endpush
@section('content')
    <div class="content">
        <div class="container">
            <div class="row">
                <div class="col-xs-12">
                    <div class="page-title-box">
                        <h4 class="page-title"> Job Insurance Report </h4>
                        <div class="pull-right">
                            <a href="{{ url()->previous() }}"
                                class="btn btn-custom btn-rounded waves-effect waves-light m-b-2 m-r-15"><i
                                    class=" mdi mdi-keyboard-backspace"></i> Back</a>
                            <button type="button" onclick="exportsExcel()" class="btn btn-success btn-sm pull-right"
                                title="Export in Excel">
                                <i class="fa fa-file-excel-o"></i>
                            </button>
                            <button type="button" onclick="exportsPdf()" class="btn btn-danger btn-sm pull-right m-r-10"
                                title="Export in Pdf">
                                <i class="fa fa-file-pdf-o"></i>
                            </button>
                        </div>
                        <div class="clearfix"></div>
                    </div>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <div class="card-box">
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="row">
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="from_date">From Date</label>
                                        <input type="text" name="from_date" id="from_date" value="{{ date('01-m-Y') }}"
                                            class="form-control datepicker" autocomplete="off">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="to_date">To Date</label>
                                        <input type="text" name="to_date" id="to_date" value="{{ date('d-m-Y') }}"
                                            class="form-control datepicker" autocomplete="off">
                                    </div>
                                 

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="branch_id">Branch</label>
                                        {!! Form::select('branch_id', \App\Http\Helpers\Helper::getBranchData(), old('branch_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'branch_id',
                                        ]) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="insurance_id">Insurance Company</label>
                                        {!! Form::select('insurance_id', ['' => 'Select '] + $insurance, old('insurance_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'insurance_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="job_card_id">Job Card No.</label>
                                        {!! Form::select('job_card_id', ['' => 'Select'] + $jobcardNo, old('job_card_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'job_card_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="customer_id">Customer</label>
                                        {!! Form::select('customer_id', ['' => 'Select'] + $customer, old('customer_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'customer_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="plate_id">Plate No.</label>
                                        {!! Form::select('plate_id', ['' => 'Select'] + $plateNo, old('plate_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'plate_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="vin_id">VIN No.</label>
                                        {!! Form::select('vin_id', ['' => 'Select'] + $vinNo, old('vin_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'vin_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="claim_id">Claim No.</label>
                                        {!! Form::select('claim_id', ['' => 'Select'] + $claimNo, old('claim_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'claim_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="accident_id">Accident No.</label>
                                        {!! Form::select('accident_id', ['' => 'Select'] + $accidentNo, old('accident_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'accident_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="policy_id">Policy No.</label>
                                        {!! Form::select('policy_id', ['' => 'Select'] + $policyNo, old('policy_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'policy_id',
                                        ]) !!}
                                    </div>

                                    <div class="form-group col-sm-3 col-12">
                                        <label for="vehicle_brand_id">Brand</label>
                                        {!! Form::select('vehicle_brand_id', ['' => 'Select'] + $brand, old('vehicle_brand_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'vehicle_brand_id',
                                        ]) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="vehicle_model_id">Model</label>
                                        {!! Form::select('vehicle_model_id', ['' => 'Select'] + $model, old('vehicle_model_id'), [
                                            'class' => 'form-control select2',
                                            'id' => 'vehicle_model_id',
                                        ]) !!}
                                    </div>


                                </div>
                                <div class="row">
                                    <div class="col-sm-12 col-12">
                                        <div class="table-responsive">
                                            <table class="table table-bordered " id="datatables">
                                                <thead>
                                                    <tr>
                                                        <th>S.No.</th>
                                                        <th>Job Card No.</th>
                                                        <th>Date</th>
                                                        <th>Customer Name</th>
                                                        <th>Contact No.</th>
                                                        <th>Brand</th>
                                                        <th>Model</th>
                                                        <th>Plate No.</th>
                                                        <th>Insurance Company Name</th>
                                                        <th>Claim No</th>
                                                        <th>Excess Amount</th>
                                                        <th>Accident No</th>
                                                        <th>Policy No</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>
@endsection
@push('footerscript')
    <script src="{{ asset('theme/plugins/moment/moment.js') }}"></script>
    <script src="{{ asset('theme/plugins/bootstrap-datepicker/js/bootstrap-datepicker.min.js') }}"></script>
    <script src="{{ asset('theme/plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('theme/plugins/datatables/dataTables.bootstrap.js') }}"></script>
    {{--    <script src="{{asset('theme/plugins/datatables/responsive.bootstrap.min.js')}}"></script> --}}
    <script>
        $(".datepicker").datepicker({
            format: 'dd-mm-yyyy',
            autoclose: true,
            endDate: "today"
        });

        $('#from_date, #to_date, #branch_id,#insurance_id,#job_card_id,#customer_id,#plate_id,#vin_id,#claim_id,#accident_id,#policy_id,#vehicle_brand_id,#vehicle_model_id')
            .on('change', function() {
                $('#datatables').DataTable().draw(false);
            });
        $(function() {
            $('#datatables').DataTable({
                processing: true,
                serverSide: true,
                stateSave: true,
                responsive: true,
                oLanguage: {
                    "sSearch": "master search"
                },
                ajax: {
                    url: '{{ route('jobInsuranceReport.getData') }}',
                    data: function(d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                        d.branch_id = $('#branch_id').val();
                        d.insurance_id = $('#insurance_id').val();

                        d.job_card_id = $('#job_card_id').val();
                        d.customer_id = $('#customer_id').val();
                        d.plate_id = $('#plate_id').val();
                        d.vin_id = $('#vin_id').val();
                        d.claim_id = $('#claim_id').val();
                        d.accident_id = $('#accident_id').val();
                        d.policy_id = $('#policy_id').val();
                        d.vehicle_brand_id = $('#vehicle_brand_id').val();
                        d.vehicle_model_id = $('#vehicle_model_id').val();
                    },
                },
                columns: [{
                        data: 'DT_RowIndex',
                        name: 'DT_RowIndex',
                        searchable: false
                    },
                    {
                        data: 'job_card_number',
                        name: 'job_card_number'
                    },
                    {
                        data: 'date',
                        name: 'date'
                    },
                    {
                        data: 'c_name',
                        name: 'c_name'
                    },
                    {
                        data: 'contact_number',
                        name: 'contact_number'
                    },
                    {
                        data: 'vehicle_brand',
                        name: 'vehicle_brand'
                    },
                    {
                        data: 'vehicle_model',
                        name: 'vehicle_model'
                    },
                    {
                        data: 'plate_number',
                        name: 'plate_number'
                    },
                    {
                        data: 'company_name',
                        name: 'company_name'
                    },
                    {
                        data: 'claim_no',
                        name: 'claim_no'
                    },
                    {
                        data: 'excess_amount',
                        name: 'excess_amount'
                    },
                    {
                        data: 'accident_no',
                        name: 'accident_no'
                    },
                    {
                        data: 'policy_no',
                        name: 'policy_no'
                    },
                ]
            });
        });

        function exportsExcel() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var insurance_id = $('#insurance_id').val();


            var job_card_id = $('#job_card_id').val();
            var customer_id = $('#customer_id').val();
            var plate_id = $('#plate_id').val();
            var vin_id = $('#vin_id').val();
            var claim_id = $('#claim_id').val();
            var accident_id = $('#accident_id').val();
            var policy_id = $('#policy_id').val();
            var vehicle_brand_id = $('#vehicle_brand_id').val();
            var vehicle_model_id = $('#vehicle_model_id').val();
            window.location.href = "{{ route('jobInsuranceReport.exportExcel') }}?from_date=" + from_date + "&to_date=" +
                to_date + "&branch_id=" + branch_id + "&insurance_id=" + insurance_id +
                "&job_card_id=" + job_card_id + "&customer_id=" + customer_id + "&plate_id=" + plate_id + "&vin_id=" +
                vin_id + "&claim_id=" + claim_id +
                "&accident_id=" + accident_id + "&policy_id=" + policy_id + "&vehicle_brand_id=" + vehicle_brand_id +
                "&vehicle_model_id=" + vehicle_model_id;
        }

        function exportsPdf() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var insurance_id = $('#insurance_id').val();


            var job_card_id = $('#job_card_id').val();
            var customer_id = $('#customer_id').val();
            var plate_id = $('#plate_id').val();
            var vin_id = $('#vin_id').val();
            var claim_id = $('#claim_id').val();
            var accident_id = $('#accident_id').val();
            var policy_id = $('#policy_id').val();
            var vehicle_brand_id = $('#vehicle_brand_id').val();
            var vehicle_model_id = $('#vehicle_model_id').val();
            window.location.href = "{{ route('jobInsuranceReport.exportPdf') }}?from_date=" + from_date + "&to_date=" +
                to_date + "&branch_id=" + branch_id + "&insurance_id=" + insurance_id +
                "&job_card_id=" + job_card_id + "&customer_id=" + customer_id + "&plate_id=" + plate_id + "&vin_id=" +
                vin_id + "&claim_id=" + claim_id +
                "&accident_id=" + accident_id + "&policy_id=" + policy_id + "&vehicle_brand_id=" + vehicle_brand_id +
                "&vehicle_model_id=" + vehicle_model_id;
        }
    </script>
@endpush