@extends('layouts.admin')

@push('styles')
    <link rel="stylesheet" href="{{ asset('plugins/datatables-bs4/css/dataTables.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-responsive/css/responsive.bootstrap4.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/datatables-buttons/css/buttons.bootstrap4.min.css') }}">

    <link rel="stylesheet" href="{{ asset('plugins/select2/css/select2.min.css') }}">
    <link rel="stylesheet" href="{{ asset('plugins/select2-bootstrap4-theme/select2-bootstrap4.min.css') }}">

    <link rel="stylesheet" href="{{ asset('plugins/icheck-bootstrap/icheck-bootstrap.min.css') }}">

    <style type="text/css">
        .btn_mt {
            margin-top: 31px;
        }

        .table-responsive {
            height: 800px;
            overflow-x: scroll;
            overflow-y: scroll;
        }
    </style>
@endpush

@section('content')
    <!-- Main content -->
    <section class="content">
        <div class="container-fluid pt-2">

            <div class="col-md-12">
                <!-- general form elements -->
                <div class="card card-info">

                    <!-- form start -->
                    <form method="GET" action="{{ route('mushak.six_point_two') }}">
                        <div class="card-body">
                            <div class="row">

                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="formdate">From Date</label>
                                        <div class="input-group date" id="formdate" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#formdate" name="formdate" id="formdate"
                                                value="{{ $formdate }}" placeholder="Enter From Date" required />
                                            <div class="input-group-append" data-target="#formdate"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="todate">To Date</label>
                                        <div class="input-group date" id="todate" data-target-input="nearest">
                                            <input type="text" class="form-control form-control-sm datetimepicker-input"
                                                data-target="#todate" name="todate" id="todate"
                                                value="{{ $todate }}" placeholder="Enter To Date" required />
                                            <div class="input-group-append" data-target="#todate"
                                                data-toggle="datetimepicker">
                                                <div class="input-group-text"><i class="fa fa-calendar"></i></div>
                                            </div>
                                        </div>

                                    </div>
                                </div>

                                <div class="col-sm-3">
                                    <div class="form-group">
                                        <label for="product_id">Product</label>

                                        <select id="product_id" name="product_id"
                                            class="form-control form-control-sm select2" value=""
                                            style="width: 100%;">
                                            <option value="">Select Product</option>
                                            @foreach ($products as $v)
                                                <option value="{{ $v->id }}"
                                                    {{ isset($product_id) && $product_id == $v->id ? 'selected' : '' }}>
                                                    {{ $v->product_name }} </option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>

                                <div class="col-sm-2">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('mushak.six_point_two') }}" style="margin-top: 30px;"
                                        class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- /.card -->

            <div class="row">
                <!-- left column -->
                <div class="col-md-12">

                    <div class="card card-info">
                        <div class="card-header">
                            <h3 class="card-title">Mushok 6.2 (Sales Book)</h3>
                        </div>
                        <!-- /.card-header -->
                        <div class="card-body">
                            <div class="row mb-2">
                                <div class="col-sm-12">
                                    <button id="excelExport" type="button"
                                        class="btn btn-success btn-sm pro_excel float-right">Excel</button>
                                </div>
                            </div>
                            <div id="table2excel" class="table-responsive">
                                <table class="table table-bordered table-hover">
                                    <tr>
                                        <th colspan="21" style="text-align:center">
                                            <div class="row">
                                                <div class="col-md-2"></div>
                                                <div class="col-md-8">
                                                    <h2>{{ $comInfo->company_name }}</h2>
                                                    <h4>Address : {{ $comInfo->address }}</h4>
                                                    <h4>Bin : {{ $comInfo->bin_no }}</h4>
                                                    <h4> <b> বিক্রয় হিসাব পুস্তক </b> </h4>
                                                    <p>[ বিধি ৪০ এর উপ-বিধি(১) এর দফা (খ ) এবং বিধি ৪১ এর দফা (ক ) দ্রষ্টব্য
                                                        ]</p>
                                                    <p style="text-align: right;">Print Date: {{ $printDate }}</p>
                                                </div>
                                                <div class="col-md-2 p-5">
                                                    <span
                                                        style="border: 1px solid;padding: 3px 0;display: inherit;width: 90px;">মূসক-৬.২</span>
                                                </div>
                                            </div>
                                        </th>
                                    </tr>
                                    <tr style="text-align:center">
                                        <th colspan="21" style="text-align:center;">পণ্য/সেবার বিক্রয়</th>
                                    </tr>
                                    <tr style="text-align:center">
                                        <th rowspan="2">ক্রমিক নং</th>
                                        <th rowspan="2">তারিখ</th>
                                        <th colspan="2">উৎপাদিত পণ্য/সেবার প্রারম্ভিক জের</th>
                                        <th colspan="2">উৎপাদন</th>
                                        <th colspan="2">মোট উৎপাদিত পণ্য/সেবা</th>
                                        <th colspan="3">ক্রেতা/সরবরাহ গ্রহীতা</th>
                                        <th colspan="2">চালান পত্রের বিবরণ</th>
                                        <th colspan="5">বিক্রিত/সরবরাহকৃত পণ্যের বিবরণ</th>
                                        <th colspan="2">পণ্যের প্রান্তিক জের</th>
                                        <th rowspan="2">মন্তব্য</th>
                                    </tr>

                                    <tr style="text-align:center">
                                        <th>পরিমান (একক)</th>
                                        <th>মূল্য (সকল প্রকার কর ব্যতীত)</th>
                                        <th>পরিমাণ (একক)</th>
                                        <th>মূল্য (সকল প্রকার কর ব্যতীত)</th>
                                        <th>পরিমাণ (একক)</th>
                                        <th>মূল্য (সকল প্রকার কর ব্যতীত)</th>
                                        <th>নাম</th>
                                        <th>ঠিকানা</th>
                                        <th>নিবন্ধন / তালিকাভূক্তি/ জাতীয় পরিচয় পত্র নং</th>
                                        <th>নম্বর</th>
                                        <th>তারিখ</th>
                                        <th>বিবরণ</th>
                                        <th>পরিমাণ</th>
                                        <th>করযোগ্যমূল্য</th>
                                        <th>সম্পূরক শুল্ক (যদি থাকে)</th>
                                        <th>মূসক</th>
                                        <th>পরিমাণ (একক)</th>
                                        <th>মূল্য (সকল প্রকার কর ব্যতীত)</th>
                                    </tr>

                                    <tbody>

                                        <tr style="text-align:center">
                                            <td>(১)</td>
                                            <td>(২)</td>
                                            <td>(৩)</td>
                                            <td>(৪)</td>
                                            <td>(৫)</td>
                                            <td>(৬)</td>
                                            <td>(৭)</td>
                                            <td>(৮)</td>
                                            <td>(৯)</td>
                                            <td>(১০)</td>
                                            <td>(১১)</td>
                                            <td>(১২)</td>
                                            <td>(১৩)</td>
                                            <td>(১৪)</td>
                                            <td>(১৫)</td>
                                            <td>(১৬)</td>
                                            <td>(১৭)</td>
                                            <td>(১৮)</td>
                                            <td>(১৯)</td>
                                            <td>(২০)</td>
                                            <td>(২১)</td>
                                        </tr>

                                        @if ($sixPdata)
                                            @php

                                                $sl = 1;

                                                $total_5 = 0;
                                                $total_6 = 0;
                                                $total_7 = 0;
                                                $total_8 = 0;
                                                $total_9 = 0;
                                                $total_10 = 0;
                                                $total_15 = 0;
                                                $total_16 = 0;
                                                $total_17 = 0;
                                                $total_18 = 0;

                                            @endphp

                                            @foreach ($sixPdata as $k => $items)
                                                @php
                                                    $prebData = [];
                                                @endphp

                                                @foreach ($items as $kk => $v)
                                                    @php

                                                        if ($kk == 0) {
                                                            $unit_name = $v->unit_name;
                                                            $product_name = $v->product_name;
                                                            $price = $v->price;
                                                            $vat_rate = $v->vat_rate;
                                                            $sd_rate = $v->sd_rate;

                                                            $col_2 = $v->col_2;
                                                            $col_3 = $v->col_3;

                                                            $tamt = $price * $col_3;
                                                            $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);
                                                            $col_4 = $vatCal['withhout_vat_sd'];
                                                            $col_5 = $v->col_5;
                                                            $col_6 = $v->col_6;
                                                            $col_7 = $v->col_7;
                                                            $col_8 = $v->col_8;
                                                            $col_9 = $v->col_9;
                                                            $col_10 = $v->col_10;
                                                            $col_11 = $v->col_11;
                                                            $col_12 = $v->col_12;
                                                            $col_13 = $v->col_13;
                                                            $col_14 = $product_name;
                                                            $col_15 = $v->col_15;
                                                            $col_16 = $v->col_16;
                                                            $col_17 = $v->col_17;
                                                            $col_18 = $v->col_18;
                                                            $col_19 = $v->col_19;
                                                            $col_20 =  number_format($v->col_20, 3, '.', '');
                                                            $col_21 =  $v->col_21;
                                                            $col_21 = $v->col_21;

                                                            $prebData[$kk] = [
                                                                'unit_name' => $v->unit_name,
                                                                'product_name' => $v->product_name,
                                                                'price' => $v->price,
                                                                'vat_rate' => $v->vat_rate,
                                                                'sd_rate' => $v->sd_rate,

                                                                'col_2' => $v->col_2,
                                                                'col_3' => $v->col_3,
                                                                'col_4' => number_format($v->col_4, 3, '.', ''),
                                                                'col_5' => $v->col_5,
                                                                'col_6' => $v->col_6,
                                                                'col_7' => $v->col_7,
                                                                'col_8' => $v->col_8,
                                                                'col_9' => $v->col_9,
                                                                'col_10' => $v->col_10,
                                                                'col_11' => $v->col_11,
                                                                'col_12' => $v->col_12,
                                                                'col_13' => $v->col_13,
                                                                'col_14' => $product_name,
                                                                'col_15' => $v->col_15,
                                                                'col_16' => $v->col_16,
                                                                'col_17' => $v->col_17,
                                                                'col_18' => $v->col_18,
                                                                'col_19' => $v->col_19,
                                                                'col_20' =>  number_format($v->col_20, 3, '.', ''),
                                                                'col_21' => $v->col_21,
                                                            ];
                                                        } else {
                                                            //5 production
                                                            //6 sale
                                                            //7 wastage
                                                            //8 return

                                                            $key = $kk - 1;
                                                            $prevData = $prebData[$key];

                                                            if ($v->col_21 == 5) {
                                                                $outlet_name = $v->outlet_name;
                                                                $outlet_address = $v->outlet_address;
                                                                $vat_reg_no_new = $v->vat_reg_no_new;
                                                                $unit_name = $v->unit_name;
                                                                $product_name = $v->product_name;
                                                                $price = $v->price;
                                                                $vat_rate = $v->vat_rate;
                                                                $sd_rate = $v->sd_rate;

                                                                $col_2 = $v->col_2;
                                                                $col_3 = $prevData['col_19'];
                                                                $col_4 = $prevData['col_20'];
                                                                $col_5 = $v->col_5;

                                                                $tamt = $price * $col_5;
                                                                $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);
                                                                $col_6 = $vatCal['withhout_vat_sd'];

                                                                $col_7 = $col_3 + $col_5;
                                                                $col_8 =  number_format($col_4 + $col_6, 3, '.', '');
                                                                $col_9 = '';
                                                                $col_10 = '';
                                                                $col_11 = '';
                                                                $col_12 = '';
                                                                $col_13 = '';
                                                                $col_14 = $product_name;
                                                                $col_15 = '';
                                                                $col_16 = '';
                                                                $col_17 = 0;
                                                                $col_18 = 0;
                                                                $col_19 = $col_7;
                                                                $col_20 = $col_8;
                                                                $col_21 = $v->col_21;
                                                            }

                                                            if ($v->col_21 == 6) {
                                                                $outlet_name = $v->outlet_name;
                                                                $outlet_address = $v->outlet_address;
                                                                $vat_reg = $v->vat_reg_no_new;
                                                                $unit_name = $v->unit_name;
                                                                $product_name = $v->product_name;
                                                                $price = $v->price;
                                                                $vat_rate = $v->vat_rate;
                                                                $sd_rate = $v->sd_rate;
                                                                $req_inv = str_pad($v->unique_id, 6, '0', STR_PAD_LEFT);
                                                                $col_2 = $v->col_2;
                                                                $col_3 = $prevData['col_19'];
                                                                $col_4 = $prevData['col_20'];
                                                                $col_5 = 0;
                                                                $col_6 = 0;
                                                                $col_7 = $col_3;
                                                                $col_8 =  number_format($col_4, 3, '.', '');
                                                                $col_9 = $outlet_name;
                                                                $col_10 = $outlet_address;
                                                                $col_11 = $vat_reg;
                                                                $col_12 = $req_inv;
                                                                $col_13 = $v->col_13;
                                                                $col_14 = $product_name;
                                                                $col_15 = $v->col_15;

                                                                $tamt = number_format($v->col_16, 3, '.', '');
                                                                $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);
                                                                $col_16 = $vatCal['withhout_vat_sd'];
                                                                $col_17 = $vatCal['sdAmt'];
                                                                $col_18 = $vatCal['vatAmt'];
                                                                $col_19 = $col_7 - $col_15;
                                                                $col_20 = $col_8 - $col_16;
                                                                $col_20 = number_format($col_20, 3, '.', '');

                                                                $col_21 = $v->col_21;
                                                            }

                                                            if ($v->col_21 == 7) {
                                                                $outlet_name = $v->outlet_name;
                                                                $outlet_address = $v->outlet_address;
                                                                $vat_reg = $v->vat_reg_no_new;
                                                                $unit_name = $v->unit_name;
                                                                $product_name = $v->product_name;
                                                                $price = $v->price;
                                                                $vat_rate = $v->vat_rate;
                                                                $sd_rate = $v->sd_rate;

                                                                if (isset($v->req_id)) {
                                                                    $req_inv = str_pad(
                                                                        $v->req_id,
                                                                        6,
                                                                        '0',
                                                                        STR_PAD_LEFT,
                                                                    );
                                                                } else {
                                                                    $req_inv = '';
                                                                }

                                                                $col_2 = $v->col_2;
                                                                $col_3 = $prevData['col_19'];
                                                                $col_4 = $prevData['col_20'];
                                                                $col_5 = 0;
                                                                $col_6 = 0;

                                                                $col_7 = $col_3;

                                                                $tamt = number_format($v->col_16, 3, '.', '');
                                                                $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);

                                                                $col_8 = number_format($col_4, 3, '.', '');
                                                                $col_9 = $outlet_name;
                                                                $col_10 = $outlet_address;
                                                                $col_11 = $vat_reg;
                                                                $col_12 = '';
                                                                $col_13 = $v->col_13;
                                                                $col_14 = $product_name;
                                                                $col_15 = $v->col_15;

                                                                $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);
                                                                $col_16 = $vatCal['withhout_vat_sd'];
                                                                $col_17 = $vatCal['sdAmt'];
                                                                $col_18 = $vatCal['vatAmt'];
                                                                $col_19 = $col_7 - $col_15;
                                                                $col_20 = $col_8 - $col_16;
                                                                $col_20 = $col_20 = number_format($col_20, 3, '.', '');
                                                                $col_21 = $v->col_21;
                                                            }


                                                            if ($v->col_21 == 8) {
                                                                $outlet_name = $v->outlet_name;
                                                                $outlet_address = $v->outlet_address;
                                                                $vat_reg_no_new = $v->vat_reg_no_new;
                                                                $unit_name = $v->unit_name;
                                                                $product_name = $v->product_name;
                                                                $price = $v->price;
                                                                $vat_rate = $v->vat_rate;
                                                                $sd_rate = $v->sd_rate;

                                                                $col_2 = $v->col_2;
                                                                $col_3 = $prevData['col_19'];
                                                                $col_4 = $prevData['col_20'];
                                                                $col_5 = $v->col_5;

                                                                $tamt = $price * $col_5;
                                                                $vatCal = Helper::vatCal($vat_rate, $sd_rate, $tamt);
                                                                $col_6 = $vatCal['withhout_vat_sd'];

                                                                $col_7 = $col_3 + $col_5;
                                                                $col_8 = number_format($col_4 + $col_6, 3, '.', '');
                                                                $col_9 = '';
                                                                $col_10 = '';
                                                                $col_11 = '';
                                                                $col_12 = '';
                                                                $col_13 = '';
                                                                $col_14 = $product_name;
                                                                $col_15 = '';
                                                                $col_16 = '';
                                                                $col_17 = 0;
                                                                $col_18 = 0;
                                                                $col_19 = $col_7;
                                                                $col_20 = $col_8;
                                                                $col_21 = $v->col_21;
                                                            }





                                                            $prebData[$kk] = [
                                                                'col_2' => $col_2,
                                                                'col_3' => $col_3,
                                                                'col_4' => number_format($col_4, 3, '.', ''),
                                                                'col_5' => $col_5,
                                                                'col_6' => $col_6,
                                                                'col_7' => $col_7,
                                                                'col_8' => $col_8,
                                                                'col_9' => $col_9,
                                                                'col_10' => $col_10,
                                                                'col_11' => $col_11,
                                                                'col_12' => $col_12,
                                                                'col_13' => $col_13,
                                                                'col_14' => $col_14,
                                                                'col_15' => $col_15,
                                                                'col_16' => $col_16,
                                                                'col_17' => $col_17,
                                                                'col_18' => $col_18,
                                                                'col_19' => $col_19,
                                                                'col_20' => $col_20,
                                                                'col_21' => $col_21,
                                                            ];
                                                        }

                                                        if ($col_21 == '5') {
                                                            $col_21 = 'উৎপাদন';
                                                        } elseif ($col_21 == '6') {
                                                            $col_21 = 'বিক্রয়';
                                                        } elseif ($col_21 == '7') {
                                                            $col_21 = 'অপচয়';
                                                        } elseif ($col_21 == '1') {
                                                            $col_21 = 'প্রারম্ভিক উপকরণ';
                                                        }elseif ($col_21 == '8') {
                                                            $col_21 = 'বিক্রয় ফেরত';
                                                        }

                                                        $col_2 = Helper::dateFormate($col_2);

                                                        $total_5 = $total_5 + (float) $col_5;
                                                        $total_6 = $total_6 + (float) $col_6;
                                                        $total_7 = $total_7 + (float) $col_7;
                                                        $total_8 = $total_8 + (float) $col_8;
                                                        $total_9 = $total_9 + (float) $col_9;
                                                        $total_10 = $total_10 + (float) $col_10;
                                                        $total_15 = $total_15 + (float) $col_15;
                                                        $total_16 = $total_16 + (float) $col_16;
                                                        $total_17 = $total_17 + (float) $col_17;
                                                        $total_18 = $total_18 + (float) $col_18;

                                                    @endphp
                                                    <tr style="text-align:center">
                                                        <td>{{ $sl++ }}</td>
                                                        <td>{{ $col_2 }}</td>
                                                        <td>{{ $col_3 }} {{ $unit_name }}</td>
                                                        <td>{{ number_format($col_4, 3, '.', '') }}</td>
                                                        <td>{{ $col_5 }} {{ $unit_name }}</td>
                                                        <td>{{ $col_6 }}</td>
                                                        <td>{{ $col_7 }}</td>
                                                        <td>{{ $col_8 }}</td>
                                                        <td>{{ $col_9 }}</td>
                                                        <td>{{ $col_10 }}</td>
                                                        <td>{{ $col_11 }}</td>
                                                        <td>{{ $col_12 }}</td>
                                                        <td>{{ $col_13 }}</td>
                                                        <td>{{ $col_14 }}</td>
                                                        <td>{{ $col_15 }}</td>
                                                        <td>{{ $col_16 }}</td>
                                                        <td>{{ $col_17 }}</td>
                                                        <td>{{ $col_18 }}</td>
                                                        <td>{{ $col_19 }} {{ $unit_name }}</td>
                                                        <td>{{  (number_format($col_20, 3, '.', '') < 0)?0:number_format($col_20, 3, '.', '') }}</td>
                                                        <td>{{ $col_21 }}</td>
                                                    </tr>
                                                @endforeach

                                                <!--        <tr>
                                                                    <td colspan="21"></td>
                                                                </tr> -->
                                            @endforeach


                                            <tr style="text-align:center">
                                                <td colspan="4"><b>Total : </b></td>
                                                <td><b>{{ $total_5 }}</b></td>
                                                <td><b>{{ $total_6 }}</b></td>
                                                <td><b>{{ $total_7 }}</b></td>
                                                <td><b>{{ $total_8 }}</b></td>
                                                <td><b>{{ $total_9 }}</b></td>
                                                <td><b>{{ $total_10 }}</b></td>
                                                <td><b></b></td>
                                                <td><b></b></td>
                                                <td><b></b></td>
                                                <td><b></b></td>

                                                <td><b>{{ $total_15 }}</b></td>
                                                <td><b>{{ $total_16 }}</b></td>
                                                <td><b>{{ $total_17 }}</b></td>
                                                <td><b>{{ $total_18 }}</b></td>
                                                <td><b></b></td>
                                                <td><b></b></td>
                                                <td><b></b></td>
                                            </tr>
                                        @endif

                                    </tbody>

                                </table>
                            </div>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
            </div>
            <!-- /.row -->
        </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->
@endsection

@push('scripts')
    <script src="{{ asset('plugins/datatables/jquery.dataTables.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-bs4/js/dataTables.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-responsive/js/dataTables.responsive.min.js') }}"></script>

    <script src="{{ asset('plugins/datatables-responsive/js/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ asset('plugins/jszip/jszip.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/pdfmake.min.js') }}"></script>
    <script src="{{ asset('plugins/pdfmake/vfs_fonts.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.html5.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.print.min.js') }}"></script>
    <script src="{{ asset('plugins/datatables-buttons/js/buttons.colVis.min.js') }}"></script>
    <script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
    <script src="{{ asset('plugins/moment/moment.min.js') }}"></script>
    <script src="{{ asset('plugins/inputmask/jquery.inputmask.min.js') }}"></script>

    <script src="{{ asset('plugins/select2/js/select2.full.min.js') }}"></script>
    <script src="{{ asset('js/jquery.table2excel.js') }}"></script>

    <script>
        $("#excelExport").click(function() {
            $("#table2excel").table2excel({
                exclude: ".noExl",
                name: "mushak_six_point_two",
                filename: "mushak_six_point_two",
                fileext: ".xls"
            });
        });


        $(function() {


            $('#formdate').datetimepicker({
                format: 'DD-MM-YYYY'
            });

            $('#todate').datetimepicker({
                format: 'DD-MM-YYYY'
            });

            $('.select2').select2();

            $('.select2bs4').select2({
                theme: 'bootstrap4'
            });


            $("#example1").DataTable({
                "responsive": true,
                "lengthChange": false,
                "autoWidth": false,
                buttons: [{
                        extend: 'excel',
                        title: 'Mushak_six_point_two'
                    },
                    {
                        extend: 'pdf',
                        title: 'Mushak_six_point_two'
                    },
                    {
                        extend: 'print',
                        title: 'Mushak_six_point_two'
                    },
                    'colvis'
                ]

            }).buttons().container().appendTo('#example1_wrapper .col-md-6:eq(0)');

            $('#example2').DataTable({
                "paging": true,
                "lengthChange": false,
                "searching": false,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": true,
            });

        });
    </script>
@endpush