@extends('operations.layout.mainlayout')

<style>
    table.dataTable tr.dtrg-group.dtrg-level-0 td {
        background-color: white;
        border-bottom: 1px solid #e7e7e7 !important;
    }
</style>
@section('content')
    <link href="/css/select2totree.css" rel="stylesheet">
    <!-- Content Wrapper. Contains page content -->
    <div class="content-wrapper">
        <!-- Content Header (Page header) -->
        <div class="content-header">
            <div class="container-fluid card">
                <div class="row mb-2">
                    <div class="col-sm-6 card-body">
                        <h1 class="m-0 text-dark" style="color: #e35a80!important;">Consumption Report</h1>
                    </div><!-- /.col -->
                    <div class="col-sm-6">

                    </div><!-- /.col -->
                </div><!-- /.row -->
            </div><!-- /.container-fluid -->
        </div>
        <!-- /.content-header -->

        <!-- Main content -->
        <section class="content">
            <div class="container-fluid">
                <div class="row">
                    {{--<div class="col-12">--}}
                    <div class="mx-auto col-md-10">

                        <!-- /.card -->
                        <div class="col-12 col-sm-12 col-md-12">
                            <br/>
                            <div class="card bg-light">
                                <div class="card-header text-muted border-bottom-0">
                                </div>
                                <form method="get" action="" style="width:100%;">
                                    <div class="card-body pt-0">
                                        <div class="row">
                                            <div class="col-12">
                                                <div class="row form-group" style="justify-content: center;">
                                                    <div class="col-md-4" style="text-align: center">
                                                        <label for="startYear"> Select Year</label>
                                                        <input type="text" name="year" id="year" class="form-control"/>
                                                    </div>
                                                    <div class="col-md-4" style="text-align: center">
                                                        <label for="startYear">Select Items</label>
                                                        <select name="select_items" multiple class="form-control"
                                                                id="select_items">
                                                            @if(count($consumptionTransactions) > 0)
                                                                @foreach ($consumptionTransactions as $key => $transaction)
                                                                    <option value="{{$transaction['ITEM_ID']}}">{{$key}}</option>
                                                                @endforeach
                                                            @endif
                                                        </select>

                                                    </div>
                                                </div>

                                            </div>
                                        </div>
                                    </div>
                                    <div class="card-footer">
                                        <div class="text-right">
                                            <button class="btn btn-sm btn-info" id="loading_button" type="button"
                                                    disabled style="display: none">
                                                <span class="spinner-border spinner-border-sm" role="status"
                                                      aria-hidden="true"></span>
                                                Loading...
                                            </button>
                                            {{--<button id="submit-stock-form" type="submit" class="btn btn-sm btn-info">
                                                <i class="fas fa-search"></i> Submit
                                            </button>--}}
                                        </div>
                                    </div>

                                </form>
                            </div>
                        </div>
                        <div class="card">

                            <!-- /.card-header -->
                            <div class="card-body" id="consumption-table-data">

                                {{--<table id="stock-balance-table" class="table table-bordered table-striped"></table>--}}

                                <table id="consumption-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>Item</th>
                                        <th>Jan</th>
                                        <th>Feb</th>
                                        <th>Mar</th>
                                        <th>Apr</th>
                                        <th>May</th>
                                        <th>Jun</th>
                                        <th>Jul</th>
                                        <th>Aug</th>
                                        <th>Sep</th>
                                        <th>Oct</th>
                                        <th>Nov</th>
                                        <th>Dec</th>
                                        <th style="text-align: center">Total Consumption</th>
                                        <th style="text-align: center">Stock Balance</th>
                                        <th style="text-align: center">Expected Consumption</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @if(count($consumptionTransactions) > 0)
                                        @foreach ($consumptionTransactions as $key => $transaction)
                                            <tr>
                                                <td>{{ $key }}</td>
                                                <td>{{$transaction['Jan']}}</td>
                                                <td>{{$transaction['Feb']}}</td>
                                                <td>{{$transaction['Mar']}}</td>
                                                <td>{{$transaction['Apr']}}</td>
                                                <td>{{$transaction['May']}}</td>
                                                <td>{{$transaction['Jun']}}</td>
                                                <td>{{$transaction['Jul']}}</td>
                                                <td>{{$transaction['Aug']}}</td>
                                                <td>{{$transaction['Sep']}}</td>
                                                <td>{{$transaction['Oct']}}</td>
                                                <td>{{$transaction['Nov']}}</td>
                                                <td>{{$transaction['Dec']}}</td>
                                                <td style="text-align: center; font-weight: 400">0</td>
                                                <td style="text-align: center; font-weight: 400">{{ $transaction['STOCK_BALANCE'] }}</td>
                                                <td style="text-align: center; font-weight: 400">0</td>
                                            </tr>
                                        @endforeach
                                    @endif
                                    </tbody>
                                    <tfoot style="background: darkgray;">
                                    <tr>
                                        <th>Totals</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th>0</th>
                                        <th style="text-align: center">0</th>
                                        <th style="text-align: center">0</th>
                                        <th style="text-align: center">0</th>
                                    </tr>
                                    </tfoot>
                                </table>

                            </div>
                            <!-- /.card-body -->
                        </div>
                        <!-- /.card -->
                    </div>
                    <!-- /.col -->
                </div>
                <!-- /.row -->
            </div>
            <!-- /.container-fluid -->
        </section>
        <!-- /.content -->
    </div>
    <!-- /.content-wrapper -->

    <div class="modal fade" id="lines-modal">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h4 class="modal-title" id="lines-modal-title" style="font-size: 16px; font-weight: bold;"></h4>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-12" id="lines-modal-body" style="height: 350px;overflow: auto;"></div>
                    </div>
                </div>
                <div class="modal-footer justify-content-between">
                    <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                </div>
            </div>
        </div>
    </div>

@endsection


@section('warehouse_scripts')

    <script src="/js/select2totree.js"></script>

    <script>
        $(document).ready(function () {

            $('#year').datepicker({
                autoclose: true,
                format: "yyyy",
                weekStart: 1,
                orientation: "bottom",
                keyboardNavigation: false,
                viewMode: "years",
                minViewMode: "years"
            });


            $('#year').on('change', function (e) {

                e.preventDefault();
                //$("#select_items").val('').trigger('change')

                $.ajax({
                    url: '/operations/warehouse/reports/monthly-consumption-data',
                    type: 'get',
                    data: {
                        year: $(this).val(),
                        items: $('#select_items').val()
                    },
                    success: function (data) {
                        $('#consumption-table').html(data)
                        consumptionTable()
                        calculateTotalConsumption()
                    }
                });
            })


            $('#select_items').select2({
                placeholder: 'Select Items'
            })

            $('#select_items').on('change', function (e) {
                e.preventDefault();
                $.ajax({
                    url: '/operations/warehouse/reports/monthly-consumption-data',
                    type: 'get',
                    data: {
                        items: $(this).val(),
                        year: $('#year').val()
                    },
                    success: function (data) {
                        $('#consumption-table').html(data)
                        consumptionTable()
                        calculateTotalConsumption()
                    }
                });

            })

            /*function Clear() {
                $('#consumption-table tr').show();
            }

            function Search(word) {
                Clear();
                $('#consumption-table tr > td:first-child').each(function () {
                    if (jQuery.inArray($(this).html(), word) === -1) {
                        $(this).parent().hide();

                    }
                });
                $('#consumption-table').DataTable().draw(false)
            }*/

            function calculateTotalConsumption() {
                let totalConsumption = 0;
                $('#consumption-table tbody tr').each(function () {
                    var row = $(this);
                    var rowTotal = 0;
                    $(this).find('td').not("td:eq(14), td:eq(15)").each(function () {
                        var th = $(this);
                        if ($.isNumeric(th.text())) {
                            rowTotal += parseFloat(th.text());
                        }
                    });
                    row.find('td:eq(13)').text(rowTotal);
                    totalConsumption += rowTotal;

                });
                $('tfoot').find('th:eq(13)').html(totalConsumption)

                $('#consumption-table').DataTable().rows().invalidate()
            }

            function consumptionTable() {
                $("#consumption-table").DataTable({
                    dom: 'Bfrtip',
                    "buttons": [
                        /*'copy', 'csv', 'excel', 'pdf', 'print',*/
                        {extend: 'copy', footer: true},
                        {extend: 'csv', footer: true},
                        {extend: 'excel', footer: true},
                        {extend: 'pdf', footer: true},
                        {extend: 'print', footer: true},
                    ],
                    "paging": false,
                    cache: false,
                    destroy: true,
                    "lengthChange": false,
                    "searching": true,
                    columnDefs: [{
                        'targets': [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12],
                        'orderable': false
                    }],
                    "ordering": true,
                    "info": true,
                    "autoWidth": false,
                    "responsive": false,
                    "footerCallback": function (row, data, start, end, display) {

                        var api = this.api();
                        var intVal = function (i) {
                            return typeof i === 'string' ? i.replace(/[\$,]/g, '') * 1 : typeof i === 'number' ? i : 0;
                        };

                        totalJan = api
                            .column(1, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalFeb = api
                            .column(2, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalMar = api
                            .column(3, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalApr = api
                            .column(4, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalMay = api
                            .column(5, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalJun = api
                            .column(6, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);

                        totalJul = api
                            .column(7, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalAug = api
                            .column(8, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalSep = api
                            .column(9, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalOct = api
                            .column(10, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalNov = api
                            .column(11, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);
                        totalDec = api
                            .column(12, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);

                        totalStockBalance = api
                            .column(14, {search: 'applied'})
                            .data()
                            .reduce(function (a, b) {
                                return intVal(a) + intVal(b);
                            }, 0);

                        $(api.column(1).footer()).html(totalJan);
                        $(api.column(2).footer()).html(totalFeb);
                        $(api.column(3).footer()).html(totalMar);
                        $(api.column(4).footer()).html(totalApr);
                        $(api.column(5).footer()).html(totalMay);
                        $(api.column(6).footer()).html(totalJun);
                        $(api.column(7).footer()).html(totalJul);
                        $(api.column(8).footer()).html(totalAug);
                        $(api.column(9).footer()).html(totalSep);
                        $(api.column(10).footer()).html(totalOct);
                        $(api.column(11).footer()).html(totalNov);
                        $(api.column(12).footer()).html(totalDec);
                        $(api.column(14).footer()).html(totalStockBalance);
                    },
                });

            }

            consumptionTable()
            calculateTotalConsumption()

        });


    </script>
@endsection