@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_eight') }}">
                        <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="voucher_no">Voucher No</label>

                                        <select id="voucher_no" name="voucher_no"
                                            class="form-control form-control-sm select2" value=""
                                            style="width: 100%;">

                                            <option value="">Select Voucher</option>

                                            @foreach ($voucher as $v)
                                                <option value="{{ $v->referenceNo }}">{{ $v->purNo }}</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_eight') }}" 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.8 (Debit Note)</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="12">
                                            <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-6">
                                                    <p>নিবন্ধিত ব্যক্তির নামঃ {{ $companyInfo->company_name }}</p>
                                                    <p>নিবন্ধিত ব্যক্তির বিআইএনঃ {{ $companyInfo->bin_no }}</p>
                                                    <p>নিবন্ধিত ব্যক্তির ঠিকানাঃ {{ $companyInfo->address }}</p><br />

                                                    <p>ক্রেতা বা গ্রহীতার নামঃ
                                                        {{ isset($sup_info->supplier_name) ? $sup_info->supplier_name : '' }}
                                                    </p>
                                                    <p>ক্রেতা বা গ্রহীতার বিআইএনঃ
                                                        {{ isset($sup_info->bin_nid) ? $sup_info->bin_nid : '' }} </p>
                                                    <p>ঠিকানাঃ {{ isset($sup_info->address) ? $sup_info->address : '' }}
                                                    </p>
                                                    <p>যানবাহনের প্রকৃতি ও নম্বরঃ </p>
                                                </div>
                                                <div class="col-md-6">
                                                    <p>ডেবিট নোট নম্বরঃ
                                                        {{ isset($voucher_info->referenceNo) ? $voucher_info->referenceNo : '' }}
                                                    </p>
                                                    <p>ইস্যুর তারিখঃ
                                                        {{ isset($voucher_info->purReturnDate) ? Helper::dateFormate($voucher_info->purReturnDate) : '' }}
                                                    </p>
                                                    <p>ইস্যুর সময়ঃ
                                                        {{ isset($voucher_info->created_at) ? date('H:s:s', strtotime($voucher_info->created_at)) : '' }}
                                                    </p>
                                                </div>
                                            </div>
                                        </th>
                                    </tr>
                                    <tr style="text-align:center">
                                        <th rowspan="2">ক্রমিক নং</th>
                                        <th rowspan="2">কর চালানপত্রের নম্বর ও তারিখ</th>
                                        <th rowspan="2">ডেবিট নোট ইস্যুর কারণ</th>
                                        <th colspan="4">চালানপত্রে উল্লেখিত সরবরাহ</th>
                                        <th colspan="4">বৃদ্ধিকারী সমন্বয়ের সাথে সংশ্লিষ্ট
                                        </th>
                                    </tr>

                                    <tr style="text-align:center">
                                        <th>মূল্য</th>
                                        <th>পরিমান</th>
                                        <th>মূল্য সংযোজন করের পরিমান</th>
                                        <th>সম্পূরক শুল্কের পরিমান</th>
                                        <th>মূল্য</th>
                                        <th>পরিমান</th>
                                        <th>মূল্য সংযোজন করের পরিমান</th>
                                        <th>সরবরাহযোগ্য সম্পূরক শুল্কের পরিমান</th>
                                    </tr>

                                    <tbody>
                                        <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>


                                        @php

                                            $sl = 1;

                                        @endphp

                                        @foreach ($sixp8 as $v)
                                            @php

                                            @endphp

                                            <tr style="text-align:center">
                                                <td>{{ $sl++ }}</td>

                                                <td>

<a href="" data-id="{{$v['purId']}}" data-toggle="modal" data-target="#modal-lg" class="view_item">{{$v['purNo']}}</a>


                                                  <br>  {{$v['purDate']}}



                                                  </td>

                                                <td>{{ $v['col_3'] }}</td>
                                                <td>{{ $v['col_4'] }}</td>
                                                <td>{{ $v['col_5'] }}</td>
                                                <td>{{ $v['col_6'] }}</td>
                                                <td>{{ $v['col_7'] }}</td>
                                                <td>{{ $v['col_8'] }}</td>
                                                <td>{{ $v['col_9'] }}</td>
                                                <td>{{ $v['col_10'] }}</td>
                                                <td>{{ $v['col_11'] }}</td>
                                            </tr>
                                        @endforeach

                                    </tbody>
                                </table>
                                <div class="col-md-12">
                                    <p>প্রতিষ্ঠান কর্তৃপক্ষের দায়িত্বপ্রাপ্ত ব্যক্তির নামঃ</p>
                                    <p>পদবিঃ</p>
                                    <p>স্বাক্ষরঃ </p>
                                    <p>সিলঃ</p>
                            </div>
                            </div>
                        </div>
                        <!-- /.card-body -->
                    </div>
                    <!-- /.card -->
                </div>
            </div>
            <!-- /.row -->
        </div><!-- /.container-fluid -->
    </section>
    <!-- /.content -->


    <!-- /.modal -->

    <div class="modal fade" id="modal-lg">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title">Purchase Details</h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body" id="print_ariea">
                    <div class="row invoice-info">
                        <table style="width: 100%">
                            <tr>
                                <td>
                                    <div style="margin-left: 10px" id="company_info">

                                    </div>
                                </td>
                                <td>
                                    <div></div>
                                </td>
                                <td>
                                    <div id="bill_Info">

                                    </div>
                                </td>
                            </tr>
                        </table>
                    </div>
                    <div class="row" id="vendor_info">

                    </div>
                    <table class="table table-head-fixed text-nowrap">
                        <thead>
                            <tr>
                                <th>SL</th>
                                <th>Product</th>
                                <th>Qty</th>
                                <th>Unit</th>
                                <th>Price</th>
                                <th>Tax Rate</th>
                                <th>Tax Amt</th>
                                <th>Total</th>
                            </tr>
                        </thead>
                        <tbody id="purchase_info">


                        </tbody>
                    </table>
                </div>
                <div class="modal-footer justify-content-between">
                    <button type="button" class="btn btn-sm btn-danger" data-dismiss="modal">Close</button>
                    <a href="#" rel="noopener" target="_blank" id="print_div"
                        class="btn btn-sm btn-primary float-right mr-2"><i class="fas fa-print"></i>Print</a>
                </div>
            </div>
            <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
    </div>

    <!-- /.modal -->



@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_eight",
                filename: "mushak_six_point_eight",
                fileext: ".xls"
            });
        });

        $(function() {


            $(".view_item").click(function() {

                var pur_id = $(this).data("id");

                $("#company_info").html('');
                $("#bill_Info").html('');
                $("#vendor_info").html('');
                $("#purchase_info").html('');

                var url = '{{ route('purd.show', ':id') }}';
                url = url.replace(':id', pur_id);

                var jqxhr = $.get(url, function(data) {
                        if (!data) {
                            alert('No supplier found!');
                        }
                    })
                    .done(function(data) {

                        var comInfo = data.comInfo;
                        var billInfo = data.billInfo;
                        var vendorInfo = data.vendorInfo;
                        var purchaseInfo = data.purchaseInfo;

                        $("#company_info").html(comInfo);
                        $("#bill_Info").html(billInfo);
                        $("#vendor_info").html(vendorInfo);

                        $("#purchase_info").html(purchaseInfo);


                    })
                    .fail(function() {

                    })
                    .always(function() {

                    });

                jqxhr.always(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_eight'
                    },
                    {
                        extend: 'pdf',
                        title: 'Mushak_six_point_eight'
                    },
                    {
                        extend: 'print',
                        title: 'Mushak_six_point_eight'
                    },
                    '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