@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_three') }}">
                    <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">
                                    <input type="hidden" value="{{ $outlet_id }}" id="outlet_id" name="outlet_id">
                                    <label for="challan_no">Challan No</label>

                                    <select id="challan_no" name="challan_no"
                                        class="form-control form-control-sm select2" value=""
                                        style="width: 100%;">
                                        <option value="">Select Challan</option>

                                        @foreach ($challanNo as $v)
                                        <option data-br="{{ $v->outlet_id }}" value="{{ $v->invoiceno }}">
                                            {{ $v->invoiceno }}
                                        </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_three') }}" 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.3 (Tax Challan)</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">
                                        <div class="row" style="text-align:center">
                                            <div class="col-md-2"></div>
                                            <div class="col-md-8">
                                                <h3>গণপ্রজাতন্ত্রী বাংলাদেশ সরকার</h3>
                                                <h3>জাতীয় রাজস্ব বোর্ড</h3>
                                                <h3>কর চালানপত্র </h3>
                                                <p> [বিধি ৪০ এর উপ-বিধি (১) এর দফা (গ) ও দফা (চ) দ্রষ্টব্য] </p>
                                            </div>
                                            <div class="col-md-2 p-5">
                                                <span style="border: 1px solid;padding: 3px 0;display: inherit;width: 90px;">মূসক ৬.৩</span>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-12">
                                                <p>নিবন্ধিত ব্যক্তির নামঃ {{ $companyInfo->company_name }}</p>
                                                <p>নিবন্ধিত ব্যক্তির বিআইএনঃ {{ $companyInfo->bin_no ?? 0 }}</p>
                                                <p>{{ $companyInfo->address }}</p>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-4"></div>
                                            <div class="col-md-8">
                                                <p>চালানপত্র নম্বরঃ {{ $challan_no }} </p>
                                                <p>ইস্যুর তারিখঃ
                                                    {{ isset($challanInfo->created_at) ? date('d-m-Y', strtotime($challanInfo->created_at)) : '' }}
                                                </p>
                                                <p>ইস্যুর সময়ঃ
                                                    {{ isset($challanInfo->created_at) ? date('H:i:s', strtotime($challanInfo->created_at)) : '' }}
                                                </p>
                                            </div>
                                        </div>
                                    </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>
                                </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>
                                </tr>
                                <tbody>

                                    @php
                                    $sl = 1;

                                    $total_col_6 = 0;
                                    $total_col_7 = 0;
                                    $total_col_8 = 0;
                                    $total_col_9 = 0;
                                    $total_col_10 = 0;
                                    $total_col_11 = 0;


                                    @endphp

                                    @foreach ($siXPointOneData as $v)
                                    @php

                                    $totalAmt = $v->amount;

                                    $vatcal = Helper::vatCal($v->vat_persent, $v->sd_persent, 0, $totalAmt);

                                    $col_2 = $v->product_name;
                                    $col_3 = $v->unit_name;
                                    $col_4 = $v->quantity;

                                    $col_5 = $vatcal['withhout_vat_sd'] / $v->quantity;
                                    $col_5 = number_format($col_5, 3, '.', '');

                                    $col_6 = $vatcal['withhout_vat_sd'];
                                    $col_7 = $v->sd_persent;
                                    $col_8 = $vatcal['sdAmt'];
                                    $col_9 = $v->vat_persent;
                                    $col_10 = $vatcal['vatAmt'];
                                    $col_11 = $col_6 + $col_8 + $col_10;


                                    $total_col_6 = $total_col_6 + $col_6;
                                    $total_col_7 = $total_col_7 + $col_7;
                                    $total_col_8 = $total_col_8 + $col_8;
                                    $total_col_9 = $total_col_9 + $col_9;
                                    $total_col_10 = $total_col_10 + $col_10;
                                    $total_col_11 = $total_col_11 + $col_11;



                                    @endphp

                                    <tr>
                                        <td>{{ $sl++ }}</td>
                                        <td>{{ $col_2 }}</td>
                                        <td>{{ $col_3 }}</td>
                                        <td style="text-align: right;">{{ $col_4 }}</td>
                                        <td style="text-align: right;">{{ $col_5 }}</td>
                                        <td style="text-align: right;">{{ $col_6 }}</td>
                                        <td style="text-align: right;">{{ $col_7 }}</td>
                                        <td style="text-align: right;">{{ $col_8 }}</td>
                                        <td style="text-align: right;">{{ $col_9 }}</td>
                                        <td style="text-align: right;">{{ $col_10 }}</td>
                                        <td style="text-align: right;">{{ $col_11 }}</td>
                                    </tr>
                                    @endforeach


                                    <tr>
                                        <td style="text-align: right;" colspan="5">Total:</td>

                                        <td style="text-align: right;">{{ $total_col_6 }}</td>
                                        <td></td>
                                        <td style="text-align: right;">{{ $total_col_8 }}</td>
                                        <td></td>
                                        <td style="text-align: right;">{{ $total_col_10 }}</td>
                                        <td style="text-align: right;">{{ $total_col_11 }}</td>
                                    </tr>

                                </tbody>
                            </table>
                            <div class="col-md-12">
                                <p>প্রতিষ্ঠান কর্তৃপক্ষের দায়িত্বপ্রাপ্ত ব্যক্তির নামঃ</p>
                                <p>পদবিঃ</p>
                                <p>স্বাক্ষরঃ </p>
                                <p>সি
                            </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_three",
            filename: "mushak_six_point_three",
            fileext: ".xls"
        });
    });


    $(function() {



        $("#challan_no").change(function() {

            var challan_no = $(this).find(':selected').data('br');

            if (challan_no) {

                $("#outlet_id").val(challan_no);

            } else {

                $("#outlet_id").val('');

            }

        });



        $('#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: 'Tax_Challan'
                },
                {
                    extend: 'pdf',
                    title: 'Tax_Challan'
                },
                {
                    extend: 'print',
                    title: 'Tax_Challan'
                },
                '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