@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')
{{--    @if(session('role') != 4 && session('role') != 5 && session('role') != 8)--}}
{{--        {{exit("<h1>Unauthorized access</h1>")}}--}}
{{--    @endif--}}
    <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;">Stock Balance 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-8">

                        <!-- /.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">
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Date from</b></span>
                                                        <input id="date_from" class="form-control" type="date"
                                                               name="date_from"
                                                               value="@if(!empty($date_from)){{$date_from}}@endif"
                                                               placeholder="Date From"></div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Date to</b></span>
                                                        <input id="date_to" class="form-control" type="date"
                                                               name="date_to"
                                                               value="@if(!empty($date_to)){{$date_to}}@endif"
                                                               placeholder="Date To">
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Locations</b></span>
                                                        <select id="stock-location-select" name="stock-location-select"
                                                                multiple></select>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <span class="text-muted text-sm"><b>Items</b></span>
                                                        <select name="items_select" multiple id="items_select">
                                                            @foreach($warehouseItems as $item)
                                                                <option value="{{ $item->ID }}">{{ $item->NAME_EN }}</option>
                                                            @endforeach
                                                        </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-success">
                                                <i class="fas fa-search"></i> Search
                                            </button>
                                        </div>
                                    </div>

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

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

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

                                <table id="stock-table" class="table table-bordered table-striped">
                                    <thead>
                                    <tr>
                                        <th>ID</th>
                                        <th>Location</th>
                                        <th>Quantity</th>
                                    </tr>
                                    </thead>
                                    <tbody>

                                    @foreach($transactionItems as $item)
                                        @foreach($item as $transaction)
                                            <tr>
                                                <td>{{$item[0]->location->text}} {{ count($transaction->location->getParentsNames()) > 0 ? '-' : '' }} {{ $transaction->location->getParentsNames()->implode(' - ') }}
                                                    ({{$item->sum('TOTAL_QTY')}})
                                                </td>
                                                @if($transaction->ITEM->HAS_LINE_ITEM)
                                                    <td><a href="#" class="line-items"
                                                           location_id="{{ $transaction->location->id }}"
                                                           item_id="{{ $transaction->ITEM->ID }}" title="{{$item[0]->location->text}}{{ count($transaction->location->getParentsNames()) > 0 ? '-' : '' }} {{ $transaction->location->getParentsNames()->implode(' - ') }}">{{ $transaction->ITEM->NAME_EN }}</a>
                                                    </td>
                                                @else
                                                    <td>{{$transaction->ITEM->NAME_EN}}</td>
                                                @endif
                                                <td>{{ $transaction->TOTAL_QTY }}</td>
                                            </tr>
                                        @endforeach
                                    @endforeach

                                    </tbody>
                                </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 () {

            $.ajax({
                type: "GET",
                url: "/operations/warehouse/stock-balance-locations",
            }).done(function (data) {
                $("#stock-location-select").select2ToTree({
                    treeData: {expandAll: true, dataArr: data},
                    maximumSelectionLength: 10
                });
            });

            $("#items_select").select2();

            var stock_locations = [];


            $('#stock-location-select').on("change", function (e) {
                stock_locations = $(this).val();
            });

            /*let stockTable = $("#stock-balance-table").DataTable({
                "responsive": true,
                "autoWidth": false,
                "destroy": true,
                "searching": false,
                sorting: false,
                "bInfo": false,
                serverSide: true,
                cache: false,
                "processing": true,
                ajax: {
                    "url": "/operations/warehouse/stock-items",
                    data: function (d) {
                        d.locations = stock_locations;
                    }
                },
                "order": [[0, "desc"]],
                columns: [
                    {data: "ID", title: "Id",},
                    {data: "ITEM.NAME_EN", title: "Item",},
                    {data: "LOCATION_ID", title: "Location",},
                ]
            });*/

            $("#stock-table").DataTable({
                dom: 'Bfrtip',
                "buttons": [
                    'copy', 'csv', 'excel', 'pdf', 'print'
                ],
                "pageLength" : 10,
                lengthMenu: [
                    [10, 25, 50, 100],
                    [10, 25, 50, 100],
                ],
                cache: false,
                rowGroup: {
                    dataSrc: 0
                },
                columnDefs: [{
                    targets: [0],
                    visible: false
                }, {
                    targets: [0, 1, 2],
                    orderable: false
                }],
                "searching": true,
                "ordering": true,
                "info": true,
                "autoWidth": false,
                "responsive": false,
            });


            $('#stock-location-select').on("change", function (e) {
                stock_locations = $(this).val();
            });

            $('#submit-stock-form').on('click', function (e) {
                $(this).css('display', 'none');
                $('#loading_button').css('display', 'initial')
                e.preventDefault();
                let date_from = $('#date_from').val();
                let date_to = $('#date_to').val();
                let items = $('#items_select').val();
                $.ajax({
                    url: '/operations/warehouse/stock-balance-data',
                    type: 'get',
                    data: {
                        locations: stock_locations,
                        date_from: date_from,
                        date_to: date_to,
                        items: items
                    },
                    success: function (data) {
                        $('#stock-table-data').html("")
                        $('#stock-table-data').html(data.html)
                        $('#submit-stock-form').css('display', 'initial');
                        $('#loading_button').css('display', 'none')
                    }
                });
            })

            $(document).on('click', '.line-items', function (e) {
                e.preventDefault();
                let location_id = $(this).attr('location_id');
                let item_id = $(this).attr('item_id');
                let title = $(this).attr('title');
                $.ajax({
                    url: '/operations/warehouse/line-items',
                    type: 'get',
                    data: {
                        location_id: location_id,
                        item_id: item_id,
                    },
                    success: function (data) {
                        $('#lines-modal-body').html('');
                        $('#lines-modal-body').html(data.html);
                        $('#lines-modal-title').text(title)
                        $('#lines-modal').modal('show');
                    }
                });
            })
        });


    </script>
@endsection