@extends('layouts.app')

@php

$moduleName             = __('lang.rebate_payment');
$createItemName         = __('lang.bulk_upload') . $moduleName;
$breadcrumbCurrentName  = __('lang.bulk_upload');
$breadcrumbMainName     = $moduleName;
$breadcrumbMainIcon     = 'account_balance_wallet';
$breadcrumbCurrentIcon  = 'add_box';

@endphp

@section('title') 
    {{ $moduleName }}->{{ $createItemName }} 
@stop

@section('top-bar') 
    @include('includes.top-bar') 
@stop 

@section('left-sidebar') 
    @include('includes.left-sidebar') 
@stop 

@section('content')
    <section class="content">
        <div class="container-fluid">
            <div class="card">
                <br>
                <div class="body">
                    <div class="" style="background-color: #24576A; height:40px">
                        <h4 class="text-center" style="color:#fff; padding:10px;font-weight: 100">{{ __('lang.instructions_for_bulk_upload') }} {{ $moduleName }}</h4>
                    </div>
                    <br>
                    <ul>
                        <li>{{ __('lang.registration_entered_in_excel_file_should_be_exist_in_system') }}</li>
                        <li>{{ __('lang.make_sure_the_attributes_entered_in_excel_file_should_be_exist_in_system') }}</li>
                        <li>{{ __('lang.date_format_entered_in_excel_file_should_be_like_01_feb_2021') }}</li>
                        <li>{{ __('lang.check_sample_excel_file_format_mentioned_below_and_put_your_data_accordingly') }}</li>
                    </ul>
                    <br>
                </div>
            </div>
            <br>
            <div class="card">
                <br>
                <div class="body">
                    <div class="" style="background-color: #24576A; height:40px">
                        <h4 class="text-center" style="color:#fff; padding:10px;font-weight: 100">{{ __('lang.bulk_import_rebate_payment') }}</h4>
                    </div>
                    <br>
                    <form name="excel-import" action="{{ route('rebate_pv_bulk_import') }}" id="frmFileUpload" method="POST" enctype="multipart/form-data">
                        @csrf
                        <div class="dz-message text-center">
                            <input onchange="checkfile(this);" accept=".xlsx, .xls" required name="file" type="file" class="form-control">
                            <br>
                            <button type="submit" class="btn btn-primary">{{ __('lang.proceed') }}</button>
                        </div>
                    </form>
                    <hr>
                    <p class="text-center">{{ __('lang.please_check_sample_file') }} <a href="{{url('/downloads/sample-rebate-pv.xlsx')}}" target="_self" download>{{ __('lang.download') }}</a> </p>
                    <hr>
                </div>
            </div>

            <div class="row">
                <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                    @if (count($data ?? []) > 0)
                    <div class="card">
                        <form name="data-import" class="actionForm" action="{{ route('rebate_pv_excel_store') }}" method="POST">
                            <div class="row body">
                                <div class="margin-bottom-0 col-md-2 col-lg-2 col-sm-2">
                                    <div class="form-group">
                                        <input class="btn btn-sm btn-info waves-effect" type="submit" style="margin-top: 12px" value="{{ __('lang.create_selected_vouchers') }}" id="confirmButton" name="ApplyButtom">
                                    </div>
                                </div>
                            </div>
                            <div class="body table-responsive" style="overflow-x: scroll;">
                                {{ csrf_field() }}
                                <table class="table table-hover table-bordered table-sm ">
                                    <thead>
                                        <tr>
                                            <th class="checkbox_custom_style text-center">
                                                <input name="selectTop" type="checkbox" id="md_checkbox_p" class="chk-col-cyan" />
                                                <label for="md_checkbox_p"></label>
                                            </th>
                                            <th>{{ __('lang.project') }}</th>
                                            <th>{{ __('lang.mode_of_payment') }}</th>
                                            <th>{{ __('lang.bank_cash_account') }}</th>
                                            <th>{{ __('lang.cheque_no') }}</th>
                                            <th>{{ __('lang.cheque_date') }}</th>
                                            <th>{{ __('lang.voucher_date') }}</th>
                                            <th>{{ __('lang.payee_name') }}</th>
                                            <th>{{ __('lang.reference_no') }} 1</th>
                                            <th>{{ __('lang.reference_no') }} 2</th>
                                            <th>{{ __('lang.registration_no') }}</th>
                                            <th>{{ __('lang.dealer_type') }}</th>
                                            <th>{{ __('lang.dealer_name') }}</th>
                                            <th>{{ __('lang.amount') }}</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @php  unset($data[0]) @endphp
                                        @foreach ($data as $item)
                                            @php
                                                $branch_name        = $item[0];
                                                $mode_of_payment    = $item[1];
                                                $bank_account       = $item[2];
                                                $cheque_no          = $item[3];
                                                $cheque_date        = $item[4];
                                                $voucher_date       = $item[5];
                                                $payee_name         = $item[6];
                                                $reference_no_1     = $item[7];
                                                $reference_no_2     = $item[8];
                                                $registration_no    = $item[9];
                                                $dealer_type        = $item[10];
                                                $dealer_name        = $item[11];
                                                $amount             = $item[12];

                                                $references         = [$reference_no_1, $reference_no_2];
                                                
                                                $data_arr = [
                                                    'row'               => $loop->iteration + 1,
                                                    'branch_name'       => $branch_name,
                                                    'mode_of_payment'   => $mode_of_payment,
                                                    'bank_account'      => $bank_account,
                                                    'cheque_no'         => $cheque_no,
                                                    'cheque_date'       => $cheque_date,
                                                    'voucher_date'      => $voucher_date,
                                                    'payee_name'        => $payee_name,
                                                    'registration_no'   => $registration_no,
                                                    'dealer_type'       => $dealer_type,
                                                    'dealer_name'       => $dealer_name,
                                                    'amount'            => $amount,
                                                    'references'        => $references,
                                                ];
                                            @endphp
                                            <tr>
                                                <th class="text-center">
                                                    <input name="items[]"  type="checkbox" value="{{ json_encode($data_arr)}}" class="chk-col-cyan selects " id="md_checkbox_{{ $loop->iteration }}" />
                                                    <label for="md_checkbox_{{ $loop->iteration }}"></label>
                                                </th>
                                                <td> {{ $branch_name }} </td>
                                                <td> {{ $mode_of_payment }} </td>
                                                <td> {{ $bank_account }} </td>
                                                <td> {{ $cheque_no }} </td>
                                                <td> {{ $cheque_date }} </td>
                                                <td> {{ $voucher_date }} </td>
                                                <td> {{ $payee_name }} </td>
                                                <td> {{ $reference_no_1 }} </td>
                                                <td> {{ $reference_no_2 }} </td>
                                                <td> {{ $registration_no }} </td>
                                                <td> {{ $dealer_type }} </td>
                                                <td> {{ $dealer_name }} </td>
                                                <td> {{ $amount }} </td>
                                            </tr>
                                        @endforeach
                                        
                                        <thead>
                                            <tr>
                                                <th class="checkbox_custom_style text-center">
                                                    <input name="selectBottom" type="checkbox" id="md_checkbox_footer" class="chk-col-cyan" />
                                                    <label for="md_checkbox_footer"></label>
                                                </th>
                                                <th>{{ __('lang.project') }}</th>
                                                <th>{{ __('lang.mode_of_payment') }}</th>
                                                <th>{{ __('lang.bank_cash_account') }}</th>
                                                <th>{{ __('lang.cheque_no') }}</th>
                                                <th>{{ __('lang.cheque_date') }}</th>
                                                <th>{{ __('lang.voucher_date') }}</th>
                                                <th>{{ __('lang.payee_name') }}</th>
                                                <th>{{ __('lang.reference_no') }} 1</th>
                                                <th>{{ __('lang.reference_no') }} 2</th>
                                                <th>{{ __('lang.registration_no') }}</th>
                                                <th>{{ __('lang.dealer_type') }}</th>
                                                <th>{{ __('lang.dealer_name') }}</th>
                                                <th>{{ __('lang.amount') }}</th>
                                            </tr>
                                        </thead>
                                    </tbody>
                                </table>
                                
                            </div>
                        </form>
                    </div>
                    @endif
                </div>
            </div>
        </div>
    </section>

    @include('layouts.components.error_modal' , ['erro_heading' => __('lang.bulk_import_rebate_payment')])
@endsection

@push('include-css')
    <!-- Wait Me Css -->
    <link href="{{ loadAsset('asset/plugins/waitme/waitMe.css') }}" rel="stylesheet" />

    <!-- Colorpicker Css -->
    <link href="{{ loadAsset('asset/plugins/bootstrap-colorpicker/css/bootstrap-colorpicker.css') }}" rel="stylesheet" />

    <!-- Dropzone Css -->
    <link href="{{ loadAsset('asset/plugins/dropzone/dropzone.css') }}" rel="stylesheet">

    <!-- Multi Select Css -->
    <link href="{{ loadAsset('asset/plugins/multi-select/css/multi-select.css') }}" rel="stylesheet">

    <!-- Bootstrap Spinner Css -->
    <link href="{{ loadAsset('asset/plugins/jquery-spinner/css/bootstrap-spinner.css') }}" rel="stylesheet">

    <!-- Bootstrap Tagsinput Css -->
    <link href="{{ loadAsset('asset/plugins/bootstrap-tagsinput/bootstrap-tagsinput.css') }}" rel="stylesheet">

    <!-- Bootstrap Select Css -->
    <link href="{{ loadAsset('asset/plugins/bootstrap-select/css/bootstrap-select.css') }}" rel="stylesheet" /> 
@endpush 

@push('include-js')
    <script src="{{ loadAsset('asset/plugins/autosize/autosize.js') }}"></script>

    <!-- Moment Plugin Js -->
    <script src="{{ loadAsset('asset/plugins/momentjs/moment.js') }}"></script>

    <!-- Bootstrap Material Datetime Picker Plugin Js -->
    <script src="{{ loadAsset('asset/plugins/bootstrap-material-datetimepicker/js/bootstrap-material-datetimepicker.js') }}"></script>

    <script src="{{ loadAsset('asset/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js') }}"></script>

    <script src="{{ loadAsset('asset/js/pages/forms/basic-form-elements.js') }}"></script>
    <!-- Autosize Plugin Js -->

    <script src="{{ loadAsset('asset/js/dataTable.js')  }}"></script>

    <script>
        toastr.options = {
            "closeButton": true,
            "debug": false,
            "newestOnTop": false,
            "progressBar": false,
            "positionClass": "toast-top-right",
            "preventDuplicates": false,
            "onclick": null,
            "showDuration": "300",
            "hideDuration": "1000",
            "timeOut": 0,
            "extendedTimeOut": 0,
            "showEasing": "swing",
            "hideEasing": "linear",
            "showMethod": "fadeIn",
            "hideMethod": "fadeOut",
            "tapToDismiss": false
        }

        @if(Session::has('success'))
            toastr.success('{{ Session::get('success') }}')
        @endif

    </script>

    <script>
        let action =  "{{$action}}";

        function checkfile(sender) {
            var validExts = new Array(".xlsx", ".xls", ".csv");
            var fileExt = sender.value;
            fileExt = fileExt.substring(fileExt.lastIndexOf('.'));
            if (validExts.indexOf(fileExt) < 0) {
                alert("Invalid file selected, valid files are of " +
                    validExts.toString() + " types.");
                return false;
            } else return true;
        }
        $(document).ready(function() {
            var boxes = $('.chk-col-cyan');
            boxes.on('change', function() {
                $('#confirmButton').prop('disabled', !boxes.filter(':checked').length);
            }).trigger('change');

            $('.dropdown-submenu a.test').on("click", function(e) {
                $(this).next('ul').toggle();
                e.stopPropagation();
                e.preventDefault();
            });
        });
    </script>
   
    <script>
        BaseController.init();
    </script>
@endpush