@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.four_point_three_coefficient') }}">
                        <div class="card-body">
                            <div class="row">
                                <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-3">
                                    <button type="submit" style="margin-top: 30px;"
                                        class="btn btn-sm btn-primary btn_mt">Search</button>
                                    <a href="{{ route('mushak.four_point_three_coefficient') }}" style="margin-top: 30px;"
                                        class="btn btn-sm btn-secondary btn_mt">Refresh</a>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </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">Mushak 4.3 (Input Output Coefficient)</h3>
                    </div>
                    <!-- /.card-header -->
                    <div class="card-body">
                        <div class="row mb-2">
                            <div class="col-sm-12">


                                <button id="save_history" type="button" data-pid="{{ $recipe_id }}" class="btn btn-secondary btn-sm save_history float-right" >Save To History</button>

                                <button id="excelExport" type="button"  class="btn btn-success btn-sm pro_excel float-right" style="margin-right: 6px;">Excel</button>


                            </div>
                        </div>
                        <div id="table2excel" class="table-responsive">
                            <table class="table table-sm 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>উপকরণ-উৎপাদ সহগ (Input Output Coefficient) ঘোষণা</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">
                                                <h5>প্রতিষ্ঠানের নাম : {{ $companyInfo->company_name }}</h5>
                                                <p>ঠিকানা : {{ $companyInfo->address }}</p>
                                                <p>বিন : {{ $companyInfo->bin_no }}</p>
                                                <p>দাখিলের তারিখ : {{ isset($recipeData->recipe_date)?Helper::dateFormate($recipeData->recipe_date):'' }}</p>
                                            </div>
                                        </div>
                                        <div class="row">
                                            <div class="col-md-12">
                                                <p>Print Date: {{ $printDate }}</p>
                                            </div>
                                        </div>
                                    </th>
                                </tr>
                                <tr style="text-align:center">
                                    <th rowspan="2">ক্রমিক সংখ্যা</th>
                                    <th rowspan="2">পণ্যের এইচ এস কোড/সেবা কোড</th>
                                    <th rowspan="2">সরবরাহতব্য পণ্য/সেবার নাম ও বর্ণনা (প্রযোজ্য ক্ষেত্রে ব্র্যান্ড নাম
                                        সহ)</th>
                                    <th rowspan="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>
                                </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>
                                </tr>
                                @if (isset($recipeData))
                                    @php
                                        $sl = 1;
                                    @endphp

                                    <tbody>
                                        @php
                                            $totalQty = 0;
                                            $totalRate = 0;
                                            $totalWastage = 0;
                                            $ttexpAmt = 0;
                                            $totalAmt = 0;
                                        @endphp
                                        @foreach ($ingredientData as $k => $i)
                                            @php

                                                if($i->pur_price > 0){

                                                    $rate = $i->pur_price;

                                                }else{

                                                    $rate = $i->rate;
                                                }


                                                $wastage = number_format($i->wstage_qty, 3, '.', '');
                                                $ing_unit_name = $i->ing_unit_name;

                                                $rate = number_format($rate, 3, '.', '');


                                                $quantity = number_format($i->quantity, 3, '.', '');


                                                $amount = $rate * $quantity;

                                                $parcent = number_format(($wastage / $quantity) * 100, 3, '.', '');

                                                $totalQty = number_format($totalQty + $quantity, 3, '.', '');
                                                $totalRate = number_format($totalRate + $rate, 3, '.', '');
                                                $totalWastage = number_format($totalWastage + $wastage, 3, '.', '');


                                                if(isset($expense[$k]->description)){

                                                     $expens = $expense[$k]->description;

                                                }else{

                                                     $expens = '';
                                                }


                                                if(isset($expense[$k]->total)){

                                                     $expens_amt = $expense[$k]->total;

                                                     $ttexpAmt = $ttexpAmt + $expens_amt;

                                                }else{
                                                    
                                                     $expens_amt = '';
                                                }


                                                if(count($ingredientData) >= count($expense)){

                                                     $rowspan = count($ingredientData);

                                                }else{

                                                     $rowspan = count($expense);
                                                }

                                                $totalAmt = $totalAmt + $amount;

                                            @endphp

                                            <tr>


                                                <td>{{ $sl++ }}</td>


                                                @if($sl == 2)


                                                <td style="vertical-align: middle;" rowspan="{{ $rowspan }}">{{ $recipeData->hscode }}</td>
                                                <td style="vertical-align: middle;" rowspan="{{ $rowspan }}">{{ $recipeData->product_name }}</td>
                                                <td style="vertical-align: middle;" rowspan="{{ $rowspan }}">{{ $recipeData->unit_name }}</td>

                                                @endif

                                                <td>{{ $i->product_name }}</td>
                                                <td>{{ $quantity }} {{ $ing_unit_name }}</td>
                                                <td>{{ $amount }}</td>
                                                <td>{{ $wastage }} {{ $ing_unit_name }}</td>
                                                <td>{{ $parcent }} %</td>
                                                <td>{{$expens}}</td>
                                                <td>{{$expens_amt}}</td>
                                                <td></td>
                                            </tr>

                                        @endforeach

                                        @if(isset($ingredientData) && count($expense) > count($ingredientData))


                                        @foreach($expense as $k => $e)


                                        @if($k > (count($ingredientData)-1))

                                        @php

                                            $expens = $e->description;
                                            $expens_amt = $e->total;

                                             $ttexpAmt = $ttexpAmt + $expens_amt;

                                        @endphp


                                            <tr>
                                                <td></td>

                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td></td>
                                                <td>{{$expens}}</td>
                                                <td>{{$expens_amt}}</td>
                                                <td></td>
                                            </tr>

                                            @endif

                                        @endforeach

                                        @endif

                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td colspan="5" style="text-align: right"><b>Total</b></td>
                                            <td><b>{{ $totalQty }} </b></td>
                                            <td><b>{{ $totalAmt }}</b></td>
                                            <td><b>{{ $totalWastage }} </b></td>
                                            <td></td>
                                            <td></td>
                                            <td>{{$ttexpAmt}}</td>
                                            <td></td>
                                        </tr>
                                    </tfoot>
                                @endif
                            </table>
                            <div class="col-md-12">
                                <p>প্রতিষ্ঠান কর্তৃপক্ষের দায়িত্বপ্রাপ্ত ব্যক্তির নামঃ</p>
                                <p>পদবিঃ</p>
                                <p>স্বাক্ষরঃ </p>
                                <p>সিলঃ</p>
                            </div>
                        </div>
                    </div>
                    <!-- /.card-body -->
                </div>
                <!-- /.card -->
            </div>
            <!--/.col (left) -->
            <!-- right column -->
            <div class="col-md-6">

            </div>
            <!--/.col (right) -->
        </div>
        <!-- /.row -->
    </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: "four_point_three_coefficient",
                filename: "four_point_three_coefficient",
                fileext: ".xls"
            });
        });

        $(function() {

            $("#save_history").click(function(){

                if($(this).data("pid")){

                    if (confirm("Are you sure you want to save this to history?")) {

                        let recipe_id = $(this).data("pid");

                        let url = "{{ route('reci.copyrecipe') }}";

                        $.get( url, { recipe_id: recipe_id} )
                        .done(function( data ) {

                            alert( "Recipe successfully save this to history!" );

                        });

                     

                    } 

                }


            });


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