@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">
@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-tent"></span> {{__('texte.differences_arr.index.differences')}}
                        <div class="pull-right"></div>
                    </h3><br />
                    
                    <form id='differences_print' method="POST" action="{{ route('differences.print') }}" role="form" class="form-inline">
                        {{ csrf_field() }} 
                        
                        <input type='hidden' id='print' name='print' value='0'/>
                        <input type='hidden' id='hidden_category' name='hidden_category' value='0'/>
                        <input type='hidden' id='hidden_product' name='hidden_product' value='0'/>
                        <input type='hidden' id='hidden_storage' name='hidden_storage' value='0'/>

                        <div class="form-inline">
                            @permission('difference-form-balance-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select class="form-control" id="balance" name="balance">
                                            <option value="0">--- {{__('texte.differences_arr.index.all')}} ---</option>
                                            <option value="1"> {{__('texte.differences_arr.index.balanced')}} </option>
                                            <option value="2"> {{__('texte.differences_arr.index.surplus')}} </option>
                                            <option value="3"> {{__('texte.differences_arr.index.shortage')}} </option>
                                        </select>
                                    </div>
                                </div>
                            @endpermission
                            @permission('difference-form-category-read')
                            <div class="form-group">
                                <div class="input-group">
                                    <select class="form-control" id="filter_category" name="filter_category">
                                        <option value="">--- {{__('texte.differences_arr.index.category')}} ---</option>
                                        @foreach($categories as $current_category)
                                            <option data-level="1" value='{{','.$current_category->id.','}}'>{{$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->name}}" value='{{','.$current_sub_category->id.','}}'>&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->name}}" data-parent="{{$current_sub_category->name}}" value='{{','.$current_sub_sub_category->id.','}}'>&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>
                            @endpermission

                            @permission('difference-form-producer-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select id="producer" name="producer" data-name="{{__('texte.differences_arr.prices.producer')}}">
                                            <option value="">--- {{__('texte.differences_arr.index.producer')}} ---</option>
                                            @foreach($producers as $producer)
                                                <option value="{{$producer->id}}">{{ $producer->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            @permission('difference-form-mark-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select id="mark" name="mark" data-name="{{__('texte.differences_arr.prices.mark')}}">
                                            <option value="">--- {{__('texte.differences_arr.index.mark')}} ---</option>
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            @permission('difference-form-package-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select id="package" name="package" data-name="{{__('texte.differences_arr.prices.package')}}">
                                            <option value="">--- {{__('texte.differences_arr.index.package')}} ---</option>
                                            @foreach($packages as $package)
                                                <option value="{{$package->id}}">{{ $package->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            @permission('difference-form-material-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select class="form-control" id="material" name="material">
                                            <option value="">--- {{__('texte.differences_arr.index.material')}} ---</option>
                                            @foreach ($materials as $material)
                                                <option value="{{ $material->id}}">{{ $material->name }}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            @permission('difference-form-size-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select class="form-control" id="size" name="size">
                                            <option value="">--- {{__('texte.differences_arr.index.size')}} ---</option>
                                            @foreach ($sizes as $size)
                                                <option value="{{ $size->id}}">{{ $size->value }} {{$size->unit==1 ? __('texte.differences_arr.index.kg') : __('texte.differences_arr.index.l')}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            @permission('difference-form-product-read')
                                <div class="form-group">
                                    <div class="input-group">
                                        <select class="form-control" id="product" name="product[]" multiple>
                                            @foreach($products as $product)
                                                <option value="{{$product->name}}" data-id='{{$product->id}}'>{{$product->name}}</option>
                                            @endforeach
                                        </select>
                                    </div>
                                </div>
                            @endpermission

                            <div class="form-group">
                                <div class="input-group">
                                    <button class='btn  btn-warning dark_bordered_warning' type="button" onclick="reset_filters();" title='{{Lang::get('texte.differences_arr.index.reset_filters')}}' data-toggle='tooltip'>{{Lang::get('texte.differences_arr.index.reset_filters')}}</button>
                                    <button type='button' class="btn btn-success dark_bordered_warning" id='print_btn'>{{__('texte.differences_arr.index.print')}}</button>
                                </div>
                            </div>

                        </div>
                    </form>
                </div>

                <div class="panel-body">
                    <table class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                        <thead>
                            <tr>
                                <th>{{strtoupper(__('texte.differences_arr.index.id'))}}</th>
                                <th>{{__('texte.differences_arr.index.product')}}</th>
                                <th>{{__('texte.differences_arr.index.stock_quantity')}}</th>
                                <th>{{__('texte.differences_arr.index.invoice_quantity')}}</th>
                                <th>{{__('texte.differences_arr.index.difference')}}</th>
                                <th>{{__('texte.differences_arr.index.actions')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.parent_parent_category')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.parent_category')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.category')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.producer')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.mark')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.package')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.material')}}</th>
                                <th hidden>{{__('texte.differences_arr.index.size')}}</th>
                            </tr>
                        </thead>
                        <tbody>
                        </tbody>
                    </table>
                </div>
                @permission('difference-form-category-read')
                    <div class="form-group" hidden>
                        <div class="input-group">
                            <select class="form-control" id="parent_parent_category" name="parent_parent_category">
                                <option value="">--- {{__('texte.differences_arr.index.category')}} ---</option>
                                @foreach($categories as $current_category)
                                    <option value='{{','.$current_category->id.','}}'>{{$current_category->name}}</option>                                            
                                @endforeach
                            </select>
                        </div>
                    </div>
                @endpermission
                @permission('difference-form-category-read')
                    <div class="form-group" hidden>
                        <div class="input-group">
                            <select class="form-control" id="parent_category" name="parent_category">
                                <option value="">--- {{__('texte.differences_arr.index.category')}} ---</option>
                                @foreach($categories as $current_category)
                                    <option value='{{','.$current_category->id.','}}'>{{$current_category->name}}</option>
                                    @if(count($current_category->children)>0)
                                        @foreach($current_category->children as $current_sub_category)
                                            <option value='{{','.$current_sub_category->id.','}}'>&nbsp;&nbsp;&nbsp;&nbsp;{{$current_sub_category->name}}</option>
                                        @endforeach
                                    @endif
                                @endforeach
                            </select>
                        </div>
                    </div>
                @endpermission
            </div>
        </div>
    </div>
</div>

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

<script type="text/javascript" charset="utf-8">

$(document).ready(function(){ 
    $('#filter_category,#mark,#package,#material,#producer,#size,#balance').chosen();
    
    $('#product').chosen({placeholder_text_multiple: '--- Продукт ---'});
    
    $('#filter_category_chosen .chosen-drop').css({"width": "400px"});   
    
    $('#print_btn').on('click', function(e){
        e.preventDefault();
        var my_form = $('#differences_print');
        $(my_form).prop('target','_blank');
        $('#hidden_category').val($('#filter_category').val().replace(/^,|,$/g,''));
        $('#hidden_storage').val($('#storage option:selected').attr('data-id'));
        
        var hidden_products='';
        
        $('#product option:selected').each(function(){
            hidden_products+=","+$(this).attr('data-id');
        });        
        $('#hidden_product').val(hidden_products+",");
        $('#print').val(1);
        my_form.submit();
    });
    
 
        var table = $('.dataTables-example').DataTable({
            pageLength: 100,
            responsive: true,
            "server-side": true,

            "ajax": {
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    url: '/get_differences',
                    type: 'POST'
            },
            "deferRender": true,
            columns: [
                        { data: 'id', name: 'id'},
                        { data: 'name', name: 'Продукт',
                          "defaultContent": ""},
                        { data: 'stock_quantity', name: 'Стокова наличност',
                          "defaultContent": 0 },
                        { data: 'invoice_quantity', name: 'Фактурна наличност',
                          "defaultContent": 0 },
                        { data: 'difference', name: 'Разлика',
                            render: function ( data, type, row, meta ) {
                                   return row.stock_quantity-row.invoice_quantity;
                              },
                          "defaultContent": 0 },
                        { data: 'id', name:'Действия',
                          "orderable" : false,
                          "fnCreatedCell": function (nTd, sData, oData, iRow, iCol){
                                $(nTd).html("<div class='btn-group btn-group-sm'><a class='btn btn-info' href='/differences/"+sData+"/show' title='Покажи разбивка' data-toggle='tooltip' @nonepermission('difference-route-list') disabled @endnonepermission><i class='glyphicon glyphicon-eye-open'></i></a></div>");
                          }
                        },
                        { data: 'parent_parent_category', name: 'Прародителска категория',
                          "defaultContent": "",
                          render: function ( data, type, row, meta ) {
                                return data!=null ? ','+data+',' : '';
                          },                          
                          "visible" : false
                        },
                        { data: 'parent_category', name: 'Родителска категория',
                          "defaultContent": "",
                          render: function ( data, type, row, meta ) {
                                return data!=null ? ','+data+',' : '';
                          },
                          "visible" : false
                        },
                        { data: 'category', name: 'Категория',
                          "defaultContent": "",
                          render: function ( data, type, row, meta ) {
                                return data!=null ? ','+data+',' : '';
                          },
                          "visible" : false},                  
                        { data: 'producer_id', name: 'Производител',
                          "defaultContent": "",
                          "visible" : false},
                        { data: 'mark_id', name: 'Марка',
                          "defaultContent": "",
                          "visible" : false},
                        { data: 'package_id',name: 'Пакетаж',
                          "defaultContent": "",
                          "visible" : false
                        },
                        { data: 'material_id', name: 'Материал',
                          "defaultContent": "",
                          "visible" : false
                        },
                        { data: 'size_id', name: 'Количество',
                          "defaultContent": "",
                          "visible" : false
                        },
                    ],

                    "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="DataTables_Table_0_length"]').chosen();
                        $('.input-sm').attr('placeholder','Търсене');
                        $('div.dataTables_filter input').css({ marginLeft : "0px"});
                        this_table = $('.dataTables-example').dataTable();
                    },
                    "dom" : "fltip",

        });
    
    
        $('#producer').on('change', function(){
            if($(this).val()!=''){
                table.columns('Производител:name').search("^" + $(this).val() + "$", true, false).draw();
            }
            else{
                table.columns('Производител:name').search('').draw();
            }
            
            var producer = $('#producer option:selected').val();
            $.ajax({
                headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                url: '/get_marks',
                type: 'POST',
                data: {'producer' : producer},
                success: function(response){
                            $('#mark').find('option').remove().end();
                            var options='<option value=""> --- Марка --- </option>';
                            if(response.length>0){
                                 for (var i in response){
                                       options += '<option value="' + response[i].id + '" name="'+ response[i].name + '">' + response[i].name + '</option>';
                                 }
                            }
                            $('#mark').html(options).trigger("chosen:updated").change();
                        }
            });           
        });
        $('#mark').on('change', function(){
            if($(this).val()!=''){
                table.columns('Марка:name').search("^" + $(this).val() + "$", true, false).draw();
            }
            else{
                table.columns('Марка:name').search('').draw();
            }
        });
        $('#package').on('change', function(){
            if($(this).val()!=''){
                table.columns('Пакетаж:name').search("^" + $(this).val() + "$", true, false).draw();
            }
            else{
                table.columns('Пакетаж:name').search('').draw();
            }
        });
        $('#material').on('change', function(){

            if($(this).val()!=''){
                table.columns('Материал:name').search("^" + $(this).val() + "$", true, false).draw();
            }
            else{
                table.columns('Материал:name').search('').draw();
            }
        });
        $('#size').on('change', function(){
            if($(this).val()!=''){
                table.columns('Количество:name').search("^" + $(this).val() + "$", true, false).draw();
            }
            else{
                table.columns('Количество:name').search('').draw();
            }
        });

        $('#product').on('change', function(){
            if($(this).val()!=''){
                var value = $(this).val().join('$|^');
                table.columns('Продукт:name').search("^" + value + "$", true, false).draw();
            }
            else{
                table.columns('Продукт:name').search('').draw();
            }
        });


        $('#balance').on('change',function(){
                if($(this).val()=='1'){
                    table.columns('Разлика:name').search("^0$", true, false).draw();
                    }
                else if($(this).val()=='2'){
                    table.columns('Разлика:name').search("-", true, false).draw();
                }
                else if($(this).val()=='3'){
                    table.columns('Разлика:name').search("^[1-9][0-9]*$", true, false).draw();
                }
                else{
                    table.columns('Разлика:name').search('').draw();
                }
        });

        var filter1 = createFilter(table, [6,7,8]);
        var filter2 = createFilter2(table, [6,8]);
        var filter3 = createFilter3(table, [7,8]);

        filter1.appendTo("body");
        filter2.appendTo("body");
        filter3.appendTo("body");


        $('#filter_category,#producer,#mark,#material,#package,#size').on('change',function(){
            var category = $('#filter_category').val();
            var producer = $('#producer').val();
            var mark = $('#mark').val();
            var material = $('#material').val();
            var package = $('#package').val();
            var size = $('#size').val();


            $.ajax({
                    headers: {
                            'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    url: '/get_filtered_products',
                    type: 'POST',
                    data: {'category' : category,
                           'producer' : producer,
                           'mark' : mark,
                           'material' : material,
                           'package' : package,
                           'size' : size},
                    success: function(response){
                                if(response.length>0){
                                    $('#product').find('option').remove().end();
                                    var options='<option value=""> --- Продукт --- </option>';
                                     for (var i in response){
                                           options += '<option value="' + response[i].name + '" name="'+ response[i].name + '">' + response[i].name + '</option>';
                                     }
                                     $('#product').html(options);
                                     $('#product').attr('disabled',false).trigger("chosen:updated");
                                 }
                                 else{
                                     alert('Не са намерени продукти по зададените критерии');
                                     $('#product').attr('disabled',true).trigger("chosen:updated");
                                 }
                            }
            });
        });
});
    
    
    function reset_filters(){
        $('#filter_category,#mark,#package,#material,#producer,#size,#product').val('').trigger("chosen:updated").change();
    }
    
    function createFilter(table, columns) {        
        var input = $('#filter_category').on('change', function(){
            table.draw();
            if($('#filter_category option:selected').data('level')==3){
                $('#parent_parent_category').val($('#category option:selected').data('parent_parent')).change();
                $('#parent_category').val($('#category option:selected').data('parent')).change();
            }

            else if($('#filter_category option:selected').data('level')==2){
                $('#parent_parent_category').val($('#category option:selected').data('parent')).change();
                $('#parent_category').val($('#category option:selected').val()).change();
            }

            else if($('#filter_category option:selected').data('level')==1){
                    $('#parent_category').val('').change();
                    $('#parent_parent_category').val($('#category option:selected').val()).change(); 
            }
            else{       
                $('#parent_parent_category').val('').change();
                $('#parent_category').val('').change();
            }
      });

      $.fn.dataTable.ext.search.push(function(
        settings,
        searchData,
        index,
        rowData,
        counter
      ) {
        var val = input.val().toLowerCase();

        for (var i = 0, ien = columns.length; i < ien; i++) {  
          if (searchData[columns[i]].toLowerCase().indexOf(val) !== -1) {
            return true;
          }
        }

        return false;
      });

      return input;
    }

function createFilter2(table, columns) {
        var input = $('#parent_parent_category').on('change', function(){
        table.draw();
        
  });
  $('#parent_parent_category').hide();
  $.fn.dataTable.ext.search.push(function(
    settings,
    searchData,
    index,
    rowData,
    counter
  ) {
    var val = input.val().toLowerCase();

    for (var i = 0, ien = columns.length; i < ien; i++) {
      if (searchData[columns[i]].toLowerCase().indexOf(val) !== -1) {
        return true;
      }
    }

    return false;
  });

  return input;
}

function createFilter3(table, columns) {
        var input = $('#parent_category').on('change', function(){
        table.draw();
        
  });

   $('#parent_category').hide();
   
  $.fn.dataTable.ext.search.push(function(
    settings,
    searchData,
    index,
    rowData,
    counter
  ) {
    var val = input.val().toLowerCase();

    for (var i = 0, ien = columns.length; i < ien; i++) {
      if (searchData[columns[i]].toLowerCase().indexOf(val) !== -1) {
        return true;
      }
    }

    return false;
  });

  return input;
}
    

</script>
@endsection