@extends('admin.layout.app')
@section('title','Workshop Profit 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">Workshop Profit 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' ,'id' => 'branch_id']  ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="customer_id">Customer</label>
                                        {!! Form::select("customer_id", [''=>'Select Customer']+$customers, old("customer_id"), ['class'=>'form-control', 'id'=>'customer_id'] ) !!}
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="contact_no">Contact No.</label>
                                        <input type="text" name="contact_no" id="contact_no"
                                               class="form-control">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="plate_no">Plate No.</label>
                                        <input type="text" name="plate_no" id="plate_no"
                                               class="form-control">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="vin_no">VIN No.</label>
                                        <input type="text" name="vin_no" id="vin_no"
                                               class="form-control">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="job_card_no">JOB Card No.</label>
                                        <input type="text" name="job_card_no" id="job_card_no"
                                               class="form-control">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="invoice_no">Invoice No.</label>
                                        <input type="text" name="invoice_no" id="invoice_no"
                                               class="form-control">
                                    </div>
                                    <div class="form-group col-sm-3 col-12">
                                        <label for="job_category">Job Type</label>
                                        {!! Form::select("job_category", [''=>'Select ','regular'=>'Regular', 'insurance'=>'Insurance', 'warranty'=>'Warranty'], old("job_category"), ['class'=>'form-control', 'id'=>'job_category'] ) !!}
                                        <div class="text-danger">{{$errors->first('job_category')}}</div>
                                    </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>Type</th>
                                                    <th>Customer Name</th>
                                                    <th>Contact No.</th>
                                                    <th>VIN No.</th>
                                                    <th>Brand</th>
                                                    <th>Model</th>
                                                    <th>Plate No.</th>
                                                    <th>Emirates</th>
                                                    <th>Invoice No.</th>
                                                    <th>Invoice Date</th>
                                                    <th>Total Cost</th>
                                                    <th>Total Sale</th>
                                                    <th>Profit</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,#customer_id,#contact_no,#plate_no,#vin_no,#job_card_no,#invoice_no,#job_category').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('jobCardReport.getData') }}',
                    data: function (d) {
                        d.from_date = $('#from_date').val();
                        d.to_date = $('#to_date').val();
                        d.branch_id = $('#branch_id').val();
                        d.customer_id = $('#customer_id').val();
                        d.contact_no = $('#contact_no').val();
                        d.plate_no = $('#plate_no').val();
                        d.vin_no = $('#vin_no').val();
                        d.job_card_no = $('#job_card_no').val();
                        d.invoice_no = $('#invoice_no').val();
                        d.job_category = $('#job_category').val();
                    },
                },
                columns: [
                    {data: 'DT_RowIndex', name: 'DT_RowIndex', searchable: false},
                    {data: 'job_card_number', name: 'job_card_number'},
                    {data: 'date', name: 'date'},
                    {data: 'job_category', name: 'job_category'},
                    {data: 'c_name', name: 'c_name'},
                    {data: 'contact_number', name: 'contact_number'},
                    {data: 'vin_number', name: 'vin_number'},
                    {data: 'vehicle_brand', name: 'vehicle_brand'},
                    {data: 'vehicle_model', name: 'vehicle_model'},
                    {data: 'plate_number', name: 'plate_number'},
                    {data: 'emirates', name: 'emirates'},
                    {data: 'bill_no', name: 'bill_no'},
                    {data: 'bill_date', name: 'bill_date'},
                    {data: 'total_cost', name: 'total_cost'},
                    {data: 'total_sale', name: 'total_sale'},
                    {data: 'profit', name: 'profit'},
                ]
            });
        });

        function exportsExcel() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var customer_id = $('#customer_id').val();
            var contact_no = $('#contact_no').val();
            var plate_no = $('#plate_no').val();
            var vin_no = $('#vin_no').val();
            var job_card_no = $('#job_card_no').val();
            var invoice_no = $('#invoice_no').val();
            var job_category = $('#job_category').val();
            window.location.href = "{{route('jobCardReport.exportExcel')}}?from_date=" + from_date + "&to_date=" + to_date + "&branch_id=" + branch_id+ "&customer_id=" + customer_id + "&contact_no=" + contact_no+ "&plate_no=" + plate_no + "&vin_no=" + vin_no+ "&job_card_no=" + job_card_no + "&invoice_no=" + invoice_no+ "&job_category=" + job_category;
        }
        function exportsPdf() {
            var from_date = $('#from_date').val();
            var to_date = $('#to_date').val();
            var branch_id = $('#branch_id').val();
            var customer_id = $('#customer_id').val();
            var contact_no = $('#contact_no').val();
            var plate_no = $('#plate_no').val();
            var vin_no = $('#vin_no').val();
            var job_card_no = $('#job_card_no').val();
            var invoice_no = $('#invoice_no').val();
            var job_category = $('#job_category').val();
            window.location.href = "{{route('jobCardReport.exportPdf')}}?from_date=" + from_date + "&to_date=" + to_date + "&branch_id=" + branch_id+ "&customer_id=" + customer_id + "&contact_no=" + contact_no+ "&plate_no=" + plate_no + "&vin_no=" + vin_no+ "&job_card_no=" + job_card_no + "&invoice_no=" + invoice_no+ "&job_category=" + job_category;
        }
    </script>
@endpush