@extends('layouts.app')

@section('link')
    <link href="{{ asset('css/theme.default.css') }}" rel="stylesheet">
    <link href="{{ asset('css/chosen.min.css') }}" rel="stylesheet">
    <link href="{{ asset('css/datatables.min.css') }}" rel="stylesheet">
    <link href="{{ asset('css/style.css') }}" rel="stylesheet">
    
    <link href="{{ asset('css/admin_filters.css') }}" rel="stylesheet">
    <link href="{{ asset('css/bootstrap-datepicker.css') }}" rel="stylesheet">
    

    <link href="{{ asset('css/jquery-ui.min.css') }}" rel="stylesheet">
    <link href="{{ asset('css/jquery.dataTables.yadcf.css') }}" rel="stylesheet">
@endsection

@section('content')
<div class="container">
@include('shared.messages')
    <div class="row">
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="panel panel-default">
                <div class="panel-heading">
                    <h3 class="panel-title">
                        <span class="glyphicon glyphicon-list"></span> {{__('texte.nap_arr.product_movements.product_movements')}} 
                        <div class="pull-right"></div>
                    </h3><br />    
                    
                    <form id='product_movements' method="POST" action="{{ route('post_product_movements') }}" role="form" class="form-inline">
                        {{ csrf_field() }}
                        
                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="category" name="category[]" data-name="{{__('texte.references_arr.filters.category')}}" multiple>
                                    @foreach($categories as $current_category)
                                    <option data-level="1" value='{{$current_category->id}}' {{isset($input['category']) && in_array($current_category->id,$input['category']) ? "selected" : ""}}>{{$current_category->name}}</option>
                                        @if(count($current_category->children)>0)
                                            @foreach($current_category->children as $current_sub_category)
                                                <option data-level="{{count($current_sub_category->children)>0 ? '2' : '3'}}" data-parent="{{$current_category->id}}" value='{{$current_sub_category->id}}' {{isset($input['category']) && in_array($current_sub_category->id,$input['category']) ? "selected" : ""}}>&nbsp;&nbsp;&nbsp;&nbsp;{{$current_category->name."\\ ".$current_sub_category->name}}</option>
                                                @if(count($current_sub_category->children)>0)
                                                    @foreach($current_sub_category->children as $current_sub_sub_category)
                                                        <option data-level="3" data-parent_parent="{{$current_category->id}}" data-parent="{{$current_sub_category->id}}" value='{{$current_sub_sub_category->id}}' {{isset($input['category']) && in_array($current_sub_sub_category->id,$input['category']) ? "selected" : ""}}>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{{$current_category->name."\\ ".$current_sub_category->name."\\ ".$current_sub_sub_category->name}}</option>
                                                    @endforeach
                                                @endif
                                            @endforeach
                                        @endif
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="producer" name="producer[]" data-name="{{__('texte.references_arr.filters.producer')}}" multiple>
                                    @foreach ($producers as $producer)
                                        <option value="{{ $producer->id }}" {{isset($input['producer']) && in_array($producer->id,$input['producer']) ? "selected" : ""}}>{{ $producer->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="mark" name="mark[]" data-name="{{__('texte.references_arr.filters.mark')}}" multiple>
                                    @foreach ($marks as $mark)
                                        <option value="{{$mark->id}}" {{isset($input['mark']) && in_array($mark->id,$input['mark']) ? "selected" : ""}}>{{ $mark->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control wrappage" id="package" name="package[]" data-name="{{__('texte.references_arr.filters.package')}}" multiple>
                                    @foreach ($packages as $package)
                                        <option value="{{ $package->id }}" {{isset($input['package']) && in_array($package->id,$input['package']) ? "selected" : ""}}>{{ mb_ucfirst($package->name) }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control wrappage" id="material" name="material[]" data-name="{{__('texte.references_arr.filters.material')}}" multiple>
                                        @foreach ($materials as $material)
                                                <option value="{{ $material->id }}" {{isset($input['material']) && in_array($material->id,$input['material']) ? "selected" : ""}}>{{ mb_ucfirst($material->name) }}</option>
                                        @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="size" name="size[]" data-name="{{__('texte.references_arr.filters.quantity')}}" multiple>
                                        @foreach ($sizes as $size)
                                            <option value="{{ $size->id}}" {{isset($input['size']) && in_array($size->id,$input['size']) ? "selected" : ""}}>{{ $size->value.' '.App\Size::SHORT_TYPES[$size->unit]}}</option>
                                        @endforeach
                                </select>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="product" name="product[]" data-name="{{__('texte.references_arr.filters.product')}}" multiple>
                                        @foreach ($products as $product)
                                            <option value="{{ $product->id}}" {{isset($input['product']) && in_array($product->id,$input['product']) ? "selected" : ""}}>{{ $product->name}}</option>
                                        @endforeach
                                </select>
                            </div>
                        </div>
                        
                        <div class="form-group">
                            <div class="input-group">
                                <div style="display: inline-block; height:40px;margin-left:2px;">
                                    <div class='yadcf-filter-wrapper-inner'>
                                        <input type="text" class="yadcf-filter-range-date" id="date_from" name="date_from" value="{{isset($input['date_from']) ? $input['date_from'] : ''}}" placeholder="{{__('texte.nap_arr.product_movements.date_from')}}"/>
                                        <input type="text" class="yadcf-filter-range-date" id="date_to" name="date_to" value="{{isset($input['date_to']) ? $input['date_to'] : ''}}" placeholder="{{__('texte.nap_arr.product_movements.date_to')}}"/>
                                    </div>
                                </div>                                    
                            </div>  
                        </div>
                       
                        <button class='btn btn-warning dark_bordered_warning' type="submit" title='{{__('texte.nap_arr.product_movements.search')}}'>{{__('texte.nap_arr.product_movements.search')}}</button>
                        <button type='button' class="btn btn-success dark_bordered_warning" id='print_btn'>{{__('texte.references_arr.realisation.print')}}</button>
                        <button type='button' class="btn btn-alt dark_bordered_warning" id='excel_btn'>{{__('texte.references_arr.realisation.excel')}}</button>
                    </form>
                </div>

                <div class="panel-body">    
                    @if(isset($reference_products))
                    <table id="myTable" class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                        <thead>
                            <tr>
                                <th>{{__('texte.nap_arr.product_movements.product_code')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.product_name')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.start_quantity')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.start_value')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.debit_quantity')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.debit_value')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.credit_quantity')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.credit_value')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.end_quantity')}}</th>
                                <th>{{__('texte.nap_arr.product_movements.end_value')}}</th>
                            </tr>
                        </thead>

                        <tbody>
                            @foreach($reference_products as $reference_product)
                            <tr>
                                <td>{{$reference_product->id}}</td>
                                <td>{{$reference_product->name}}</td>
                                <td>{{$reference_product->start_quantity}}</td>
                                <td>{{number_format($reference_product->start_value,2,'.','')}}</td>
                                <td>{{$reference_product->debit_quantity}}</td>
                                <td>{{number_format($reference_product->debit_value,2,'.','')}}</td>
                                <td>{{$reference_product->credit_quantity}}</td>
                                <td>{{number_format($reference_product->credit_value,2,'.','')}}</td>
                                <td>{{$reference_product->start_quantity-$reference_product->debit_quantity+$reference_product->credit_quantity}}</td>
                                <td>{{number_format($reference_product->start_value-$reference_product->debit_value+$reference_product->credit_value,2,'.','')}}</td>
                            @endforeach
                        </tbody>
                    </table>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>


<script src="{{ asset('js/jquery-ui.min.js') }}"></script>
<script src="{{ asset('js/datepicker-bg.js') }}"></script>
<script src="{{ asset('js/jquery.query-object.js') }}"></script>


<script src="{{ asset('js/chosen.js') }}"></script>
<script src="{{ asset('js/datatables.min.js') }}"></script>
<script src="{{ asset('js/jquery.dataTables.yadcf.js') }}"></script>

<script type="text/javascript" charset="utf-8">
    
    $('#category,#mark,#package,#material,#producer,#size,#product').each(function(){
        var select_element = $(this);
        select_element.chosen({placeholder_text_multiple: '--- '+ select_element.attr('data-name') + ' ---'});
    });

    $('#category_chosen .chosen-drop').css({"width": "400px"});
    
    $('#producer').on('change', function(){
        var producers = $('#producer').val();
        var marks = $('#mark').val();

        $.ajax({
            headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            },
            url: '/get_producers_marks',
            type: 'POST',
            data: {'producers' : producers},
            success: function(response){                        
                        var options='<option value="0"> --- Марка --- </option>';
                        $('#mark').find('option').remove().end();
                        
                        for (var i in response){
                              options += '<option value="' + response[i].id + '" name="'+ response[i].name + '" '+ ($.inArray(String(response[i].id), marks)!== -1 ? "selected" : "") + '>' + response[i].name + '</option>';
                        }
                        
                        $('#mark').html(options).trigger("chosen:updated").change();
                    }
        });           
    }).change();
    
    table = $('.dataTables-example').DataTable({
        pageLength: 100,
        responsive: true,
        "oLanguage": {
            "sSearch": "",
            "sLengthMenu": "_MENU_  <span style='vertical-align:-moz-middle-with-baseline;margin-left:5px;'>Резултата на страница</span>",  
            "sInfo": "Показване на записи от _START_ до _END_ от общо _TOTAL_ записа",
            "sZeroRecords": "Не са намерени записи по зададените параметри",
            "sInfoEmpty": "Не са намерени записи по зададените параметри",
            "sInfoFiltered" : "- филтрирани от _MAX_ записа",
            "sLoadingRecords" : "Резултатите се зареждат, моля изчакайте...",
            "oPaginate": {
                                    "sNext": "Следваща страница",
                                    "sPrevious": "Предишна страница",
                              },

        },

        "initComplete":function(settings, json) {
            $('select[name="myTable_length"]').chosen();
            $('.input-sm').attr('placeholder','Търсене');
            $('div.dataTables_filter input').css({ marginLeft : "0px"});
            this_table = $('.dataTables-example').dataTable();
            $("a").each(function(){
                if($(this).attr('disabled')=='disabled'){
                    $(this).addClass('not-active');
                }
            });  
        },
        "dom" : "fl<'#add_country'>tip",

    });
            
    $("#date_from").datepicker({   
        onSelect: function(dateText, inst){
           $("#date_to").datepicker("option","minDate",
           $("#date_from").datepicker("getDate"));
        }
    });

    $("#date_to").datepicker();
    
    jQuery.extend( jQuery.fn.dataTableExt.oSort, {
        "date-uk-pre": function ( a ) {
            if(a){
                var ukDatea = a.split('.');
                return (ukDatea[2] + ukDatea[1] + ukDatea[0]) * 1;
            }
            else{
                return ' ';
            }
        },

        "date-uk-asc": function ( a, b ) {
            return ((a < b) ? -1 : ((a > b) ? 1 : 0));
        },

        "date-uk-desc": function ( a, b ) {
            return ((a < b) ? 1 : ((a > b) ? -1 : 0));
        }
    });
                                
</script>
@endsection