@extends('admin.index')
@section('content')
@php
use App\Models\Stores;
use App\Models\ProductsQty;
use App\Models\CompanyData;
$Def=CompanyData::orderBy('id','desc')->first();
$title=trans('admin.StoresBalances');
@endphp

<title> {{trans('admin.StoresBalances')}}</title>
<main id="js-page-content" role="main" class="page-content ">
    <ol class="breadcrumb page-breadcrumb no-print">
        <li class="breadcrumb-item"><a href="javascript:void(0);"> {{trans('admin.Reports')}}</a></li>
        <li class="breadcrumb-item active"> {{trans('admin.StoresBalances')}} </li>
        <li class="position-absolute pos-top pos-right d-none d-sm-block"><span class="js-get-date"></span></li>
    </ol>
    <!-- Data -->

    <!-- Head Of Print -->
    @include('admin.layouts.PrintHeader')


    <div class="row hide-table">
        <div class="col-xl-12">
            <div id="panel-1" class="panel second-color">
                <div class="panel-hdr">
                    <h2>
                        {{trans('admin.StoresBalances')}}


                    </h2>
                    <div class="panel-toolbar">
                        <button class="btn btn-primary btn-sm" data-toggle="dropdown">Table
                            Style</button>

                        <form action="{{url('StoresBalancesNewPrint')}}" method="get">
                            @honeypot
                            <div class="row" style="display: none">
                                @if(!empty($store))


                                @for($i=0 ; $i < count($store) ; $i++) <input type="hidden" id="Store" name="Store[]" value="{{$store[$i]}}">
                                    @endfor

                                    @else
                                    <input type="hidden" id="Store" name="Store" value=" ">
                                    @endif





                                    @if(!empty($group))

                                    @for($i=0 ; $i < count($group) ; $i++) <input type="hidden" name="Group[]" value="{{$group[$i]}}">
                                        @endfor

                                        @else
                                        <input type="hidden" name="Group" value=" ">
                                        @endif
                                        @if(!empty($brand))

                                        @for($i=0 ; $i < count($brand) ; $i++) <input type="hidden" name="Brand[]" value="{{$brand[$i]}}">
                                            @endfor

                                            @else
                                            <input type="hidden" name="Brand" value=" ">
                                            @endif



                                            <input type="hidden" id="Branch" name="Branch" value="{{$branch}}">
                                            <input type="hidden" id="Product_Name" name="Product_Name" value="{{$product_Name}}">
                                            <input type="hidden" id="Product_Code" name="Product_Code" value="{{$product_Code}}">
                                            <input type="hidden" name="Zero" id="Zero" value="{{$zeros}}">


                            </div>

                            <button type="submit" class="btn btn-primary btn-sm" style="display: none">
                                <i class="fal fa-print">{{trans('admin.Print')}}</i>
                            </button>
                        </form>

                        <form action="{{url('ExportStoresBalancesNew')}}" method="get">
                            @honeypot
                            <div class="row" style="display: none">
                                @if(!empty($store))


                                @for($i=0 ; $i < count($store) ; $i++) <input type="hidden" id="Store" name="Store[]" value="{{$store[$i]}}">
                                    @endfor

                                    @else
                                    <input type="hidden" id="Store" name="Store" value=" ">
                                    @endif





                                    @if(!empty($group))

                                    @for($i=0 ; $i < count($group) ; $i++) <input type="hidden" name="Group[]" value="{{$group[$i]}}">
                                        @endfor

                                        @else
                                        <input type="hidden" name="Group" value=" ">
                                        @endif
                                        @if(!empty($brand))

                                        @for($i=0 ; $i < count($brand) ; $i++) <input type="hidden" name="Brand[]" value="{{$brand[$i]}}">
                                            @endfor

                                            @else
                                            <input type="hidden" name="Brand" value=" ">
                                            @endif



                                            <input type="hidden" id="Branch" name="Branch" value="{{$branch}}">
                                            <input type="hidden" id="Product_Name" name="Product_Name" value="{{$product_Name}}">
                                            <input type="hidden" id="Product_Code" name="Product_Code" value="{{$product_Code}}">
                                            <input type="hidden" name="Zero" id="Zero" value="{{$zeros}}">


                            </div>

                            <button type="submit" class="btn btn-success btn-sm">
                                <i class="fal fa-excel">Excel All Data</i>
                            </button>
                        </form>

                        @include('admin.layouts.toolbar')
                    </div>
                </div>
                <div class="panel-container show">
                    <span id="ex"> @include('admin.layouts.messages')</span>
                    <div class="panel-content">
                        <!-- datatable start -->
                        <div class="over-flow" style="overflow:auto;">
                            <table id="X" class="table table-bordered table-hover w-100 table-striped ">
                                <thead class="bg-highlight">
                                    <tr>
                                        <th>{{trans('admin.Code')}} </th>
                                        <th>{{trans('admin.Name')}} </th>
                                        <th>{{trans('admin.Unit')}} </th>
                                        <th>{{trans('admin.Stores_Qty')}} </th>

                                        @for($i=0 ; $i < count($store) ; $i++) @php $S=Stores::find($store[$i]); @endphp <th>{{$S->Name}} </th>
                                            @endfor
                                            <th>{{trans('admin.Total_Balance')}}</th>
                                    </tr>
                                </thead>

                                <tbody>
                                    @foreach($items as $item)
                                    @php
                                    $AllQty=ProductsQty::where('Product',$item->Product)->get()->sum('Qty');
                                    $AllBalance=0;
                                    @endphp


                                    <tr>
                                        <td>{{$item->P_Code}}</td>
                                        <td>

                                            {{app()->getLocale() == 'ar' ?$item->P_Ar_Name :$item->P_En_Name}}
                                        </td>
                                        <td>

                                            {{app()->getLocale() == 'ar' ?$item->Unit()->first()->Name :$item->Unit()->first()->NameEn}}
                                        </td>
                                        <td>{{$AllQty}}</td>
                                        @for($i=0 ; $i < count($store) ; $i++) @php $StoreQty=ProductsQty::where('Product',$item->Product)->where('Store',$store[$i])->get()->sum('Qty'); @endphp
                                            <td>{{$StoreQty}} </td>
                                            @php $AllBalance += $StoreQty ; @endphp
                                            @endfor
                                            <td>{{$AllBalance}}</td>
                                    </tr>


                                    @php
                                    $AllBalance=0;

                                    @endphp



                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                        {{$items->Links()}}


                    </div>
                    <div class="panel-content">
                        <div id="mobile-overflow">
                            <table class="table table-bordered table-hover table-striped w-100 mt-4 mobile-width">
                                <tbody>
                                    <tr>
                                        <td> {{trans('admin.Products_Num')}} </td>
                                        <td id="PRONUMS">{{$Products_Num}}</td>
                                        <td> {{trans('admin.Total_Qty')}}</td>
                                        <td id="TOTALQTY">{{$Total_Qty}}</td>

                                    </tr>
                                    <tr>


                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


</main>
@endsection
@push('js')
<link rel="stylesheet" media="screen, print" href="{{asset('Admin/css/datagrid/datatables/datatables.bundle.css')}}">
<link rel="stylesheet" media="screen, print" href="{{asset('Admin/css/formplugins/summernote/summernote.css')}}">
<link rel="stylesheet" media="screen, print" href="{{asset('Admin/css/formplugins/select2/select2.bundle.css')}}">

<script src="{{asset('Admin/js/datagrid/datatables/datatables.export.js')}}"></script>
<script src="{{asset('Admin/js/datagrid/datatables/datatables.bundle.js')}}"></script>
<script src="{{asset('Admin/js/formplugins/summernote/summernote.js')}}"></script>
<script src="{{asset('Admin/js/formplugins/select2/select2.bundle.js')}}"></script>
<script>
    //_fnFeatureHtmlLength();
    $(document).ready(function() {
        // Setup - add a text input to each footer cell
        $('#dt-basic-example thead tr').clone(true).appendTo('#dt-basic-example thead');
        $('#dt-basic-example thead tr:eq(1) th').each(function(i) {
            var title = $(this).text();
            $(this).html('<input type="text" class="form-control form-control-sm" placeholder="Search ' + '" />');

            $('input', this).on('keyup change', function() {
                if (table.column(i).search() !== this.value) {
                    table
                        .column(i)
                        .search(this.value)
                        .draw();
                }
            });
        });
        var table = $('#dt-basic-example').DataTable({
            // responsive: true,
            orderCellsTop: true,
            fixedHeader: true,
            lengthChange: true,

            dom: "<'row mb-3'<'col-sm-12 col-md-3 d-flex align-items-center justify-content-start'f><'col-sm-12 col-md-9 d-flex align-items-center justify-content-end'B>>" +
                "<'row'<'col-sm-12'tr>>" +
                "<'row'<'col-sm-12 col-md-5'i><'col-sm-12 col-md-7'p>>",

            buttons: [{
                    extend: 'pageLength',
                    className: 'btn-outline-default'
                },
                {
                    extend: 'colvis',
                    text: 'Column Visibility',
                    titleAttr: 'Col visibility',
                    className: 'btn-outline-default'
                },
                {
                    extend: 'pdfHtml5',
                    text: 'PDF',
                    titleAttr: 'Generate PDF',
                    className: 'btn-outline-danger btn-sm mr-1'
                },
                {
                    extend: 'excelHtml5',
                    text: 'Excel',
                    titleAttr: 'Generate Excel',
                    className: 'btn-outline-success btn-sm mr-1'
                },
                {
                    extend: 'csvHtml5',
                    text: 'CSV',
                    titleAttr: 'Generate CSV',
                    className: 'btn-outline-primary btn-sm mr-1'
                },
                {
                    extend: 'copyHtml5',
                    text: 'Copy',
                    titleAttr: 'Copy to clipboard',
                    className: 'btn-outline-primary btn-sm mr-1'
                },
                {
                    extend: 'print',
                    text: 'Print',
                    titleAttr: 'Print Table',
                    className: 'btn-outline-primary btn-sm'
                }
            ],
        });
        $('.js-thead-colors a').on('click', function() {
            var theadColor = $(this).attr("data-bg");
            console.log(theadColor);
            $('#dt-basic-example thead').removeClassPrefix('bg-').addClass(theadColor);
        });

        $('.js-tbody-colors a').on('click', function() {
            var theadColor = $(this).attr("data-bg");
            console.log(theadColor);
            $('#dt-basic-example').removeClassPrefix('bg-').addClass(theadColor);
        });

    });

</script>
<script>
    var autoSave = $('#autoSave');
    var interval;
    var timer = function() {
        interval = setInterval(function() {
            //start slide...
            if (autoSave.prop('checked'))
                saveToLocal();

            clearInterval(interval);
        }, 3000);
    };

    //save
    var saveToLocal = function() {
        localStorage.setItem('summernoteData', $('#saveToLocal').summernote("code"));
        console.log("saved");
    }

    //delete
    var removeFromLocal = function() {
        localStorage.removeItem("summernoteData");
        $('#saveToLocal').summernote('reset');
    }

    $(document).ready(function() {
        //init default
        $('.js-summernote').summernote({
            height: 200,
            tabsize: 2,
            placeholder: "Type here...",
            dialogsFade: true,
            toolbar: [
                ['style', ['style']],
                ['font', ['strikethrough', 'superscript', 'subscript']],
                ['font', ['bold', 'italic', 'underline', 'clear']],
                ['fontsize', ['fontsize']],
                ['fontname', ['fontname']],
                ['color', ['color']],
                ['para', ['ul', 'ol', 'paragraph']],
                ['height', ['height']]
                ['table', ['table']],
                ['insert', ['link', 'picture', 'video']],
                ['view', ['fullscreen', 'codeview', 'help']]
            ],
            callbacks: {
                //restore from localStorage
                onInit: function(e) {
                    $('.js-summernote').summernote("code", localStorage.getItem("summernoteData"));
                },
                onChange: function(contents, $editable) {
                    clearInterval(interval);
                    timer();
                }
            }
        });

        //load emojis
        $.ajax({
            url: 'https://api.github.com/emojis',
            async: false
        }).then(function(data) {
            window.emojis = Object.keys(data);
            window.emojiUrls = data;
        });

        //init emoji example
        $(".js-hint2emoji").summernote({
            height: 100,
            toolbar: false,
            placeholder: 'type starting with : and any alphabet',
            hint: {
                match: /:([\-+\w]+)$/,
                search: function(keyword, callback) {
                    callback($.grep(emojis, function(item) {
                        return item.indexOf(keyword) === 0;
                    }));
                },
                template: function(item) {
                    var content = emojiUrls[item];
                    return '<img src="' + content + '" width="20" /> :' + item + ':';
                },
                content: function(item) {
                    var url = emojiUrls[item];
                    if (url) {
                        return $('<img />').attr('src', url).css('width', 20)[0];
                    }
                    return '';
                }
            }
        });

        //init mentions example
        $(".js-hint2mention").summernote({
            height: 100,
            toolbar: false,
            placeholder: "type starting with @",
            hint: {
                mentions: ['jayden', 'sam', 'alvin', 'david'],
                match: /\B@(\w*)$/,
                search: function(keyword, callback) {
                    callback($.grep(this.mentions, function(item) {
                        return item.indexOf(keyword) == 0;
                    }));
                },
                content: function(item) {
                    return '@' + item;
                }
            }
        });

    });

</script>

<script type="text/javascript">
    $(".show-table").click(function() {
        $(".hide-table").show();
    });

</script>
<style>
    @media print {

        /*body * {*/
        /*	visibility: hidden;*/
        /*}*/
        .modal-content * {
            visibility: visible;
            overflow: visible;
        }

        .main-page {
            display: none !important;
        }

        .modal {
            position: absolute;
            left: 0;
            top: -130px;
            right: 0;
            margin: 0;
            padding: 0;
            /*min-height: 550px;*/
            /*visibility: visible;*/
            overflow: visible !important;
            /* Remove scrollbar for printing. */
            font-size: 20px !important;
        }

        .modal-dialog {
            /*visibility: visible !important;*/
            overflow: visible !important;
            /* Remove scrollbar for printing. */
        }

        body {
            position: relative;
        }
    }

</style>
<!-- Search Selecet -->
<script>
    $(document).ready(function() {
        $(function() {
            $(".select2").select2();

            $(".select2-placeholder-multiple").select2({
                placeholder: "Select State",
            });
            $(".js-hide-search").select2({
                minimumResultsForSearch: 1 / 0,
            });
            $(".js-max-length").select2({
                maximumSelectionLength: 2,
                placeholder: "Select maximum 2 items",
            });
            $(".select2-placeholder").select2({
                placeholder: "Select a state",
                allowClear: true,
            });

            $(".js-select2-icons").select2({
                minimumResultsForSearch: 1 / 0,
                templateResult: icon,
                templateSelection: icon,
                escapeMarkup: function(elm) {
                    return elm;
                },
            });

            function icon(elm) {
                elm.element;
                return elm.id ? "<i class='" + $(elm.element).data("icon") + " mr-2'></i>" + elm.text : elm.text;
            }

            $("#Emp").select2({
                placeholder: "select...",
                ajax: {
                    type: "GET",
                    dataType: "json",
                    url: "AllEmps",
                    processResults: function(data) {
                        return {
                            results: $.map(data, function(obj, index) {
                                return {
                                    id: index,
                                    text: obj
                                };
                            }),
                        };

                        console.log(data);
                    },
                    data: function(params) {
                        var query = {
                            search: params.term,
                        };
                        if (params.term == "*") query.items = [];
                        return {
                            json: JSON.stringify(query)
                        };
                    },
                },
            });

            $("#Emp").on("select2:select", function(e) {
                console.log("select done", e.params.data);
            });
        });
    });

</script>

<script>
    var table = $('#X').DataTable({

        retrieve: true,
        responsive: true,
        orderCellsTop: true,
        fixedHeader: false,
        lengthChange: true,
        pageLength: 10,
        dom: 'Bfrtip',

        buttons: [{
                extend: 'pageLength',
                className: 'btn-outline-default'
            },
            {
                extend: 'colvis',
                text: 'Column Visibility',
                titleAttr: 'Col visibility',
                className: 'btn-outline-default'
            },

            {
                extend: 'excelHtml5',
                exportOptions: {
                    format: {
                        body: function ( inner, rowidx, colidx, node ) {
                            if ($(node).children("select").length > 0) {
                                // we are in a cell containing a "select" drop-down - so, get it:
                                var selectNode = node.firstElementChild;
                                var txt = selectNode.options[selectNode.selectedIndex].text;
                                //var txt = selectNode.options[selectNode.selectedIndex].text;
                                return txt;
                            } else {

                                if ($(node).children("input").length > 0) {
                                    return $(node).children("input").first().val();
                                } else {
                                    return inner;
                                }


                            }
                        }
                    }
                },

                text: 'Excel',
                titleAttr: 'Generate Excel',
                exportOptions: {
                    modifier: {
                        page: 'all',
                        search: 'none'
                    }
                },
                className: 'btn-outline-success btn-sm mr-1'
            },


            {
                extend: 'print',
                text: 'Print',
                titleAttr: 'Print Table',
                exportOptions: {
                    modifier: {
                        page: 'all',
                        search: 'none'
                    },
                },
                className: 'btn-outline-primary btn-sm'
            }
        ],
    });

</script>

@endpush
