@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-flag"></span> {{__('texte.balances_arr.index.balances')}}
                    </h3><br />

                    <div class="panel-group" id="accordion">

                        <div id="search" class="form-inline panel panel-default">
                            <div class="panel-heading" id="headingOne">                                
                                <a data-toggle="collapse" data-parent="#accordion" href="#collapseOne"><h4 class="panel-title">{{Lang::get('texte.documents_arr.index.search')}}</h4></a>                              
                            </div>
                            <div id="collapseOne" class="panel-collapse collapse in">
                                <div class="panel-body">
                                    @permission('balances-form-contragent-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select class="form-control" id="search_contragents" name="contragent">
                                                    <option value="">--- {{Lang::get('texte.balances_arr.index.contragent')}} ---</option>
                                                    @foreach ($clients as $contragent)
                                                        <option value="{{ $contragent->id }}" data-id="{{$contragent->id}}">{{ $contragent->company_name ?? $contragent->user->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission

                                    @permission('balances-form-object-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select id="search_objects" name="objects[]" data-name="{{Lang::get('texte.balances_arr.index.obect')}}" multiple>
                                                    @foreach($clients_objects as $object)
                                                        <option value="{{$object->id}}" data-id="{{$object->contragent_id}}">{{ $object->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission

                                    @permission('balances-form-party-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select class="form-control" id="search_party" name="party" multiple>
                                                    <option value="is_supplier">{{Lang::get('texte.balances_arr.index.supplier')}}</option>
                                                    <option value="is_client">{{Lang::get('texte.balances_arr.index.client')}}</option>
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission
                                    
                                    <div class="form-group">
                                        <div class="input-group">
                                            <select class="form-control" id="search_allocation_contragents" name="allocation_contragents">
                                                <option value="">--- {{Lang::get('texte.balances_arr.index.allocation_contragents')}} ---</option>
                                                <option value="0">{{Lang::get('texte.balances_arr.index.no')}}</option>
                                                <option value="1">{{Lang::get('texte.balances_arr.index.yes')}}</option>
                                            </select>
                                        </div>
                                    </div>
                                    
                                    <div class="form-group">
                                        <div class="input-group">
                                            <select class="form-control" id="search_allocation_objects" name="allocation_objects">
                                                <option value="">--- {{Lang::get('texte.balances_arr.index.allocation_objects')}} ---</option>
                                                <option value="0">{{Lang::get('texte.balances_arr.index.no')}}</option>
                                                <option value="1">{{Lang::get('texte.balances_arr.index.yes')}}</option>
                                            </select>
                                        </div>
                                    </div>
                                    
                                    <button class='btn  btn-warning dark_bordered_warning' type="button" onclick="search_balances();" title='{{Lang::get('texte.balances_arr.index.search_balances')}}' data-toggle='tooltip'>{{Lang::get('texte.balances_arr.index.search_balances')}}</button>
                                </div>
                            </div>
                        </div>      
                        
                        <div id="filters" class="form-inline panel panel-default">
                            <div class="panel-heading" id="headingTwo">                                
                                <a data-toggle="collapse" data-parent="#accordion" href="#collapseTwo"><h4 class="panel-title">{{Lang::get('texte.documents_arr.index.filters')}}</h4></a>
                            </div>
                            <div id="collapseTwo" class="panel-collapse collapse">
                                <div class="panel-body">
                                    @permission('balances-form-contragent-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select class="form-control" id="contragents" name="contragent">
                                                    <option value="">--- {{Lang::get('texte.balances_arr.index.contragent')}} ---</option>
                                                    @foreach ($clients as $contragent)
                                                        <option value="{{ $contragent->company_name ?? $contragent->user->name }}" data-id="{{$contragent->id}}">{{ $contragent->company_name ?? $contragent->user->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission

                                    @permission('balances-form-object-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select id="objects" name="objects[]" data-name="{{Lang::get('texte.balances_arr.index.obect')}}" multiple>
                                                    @foreach($clients_objects as $object)
                                                        <option value="{{$object->contragent_id}}" data-id="{{$object->contragent_id}}">{{ $object->name }}</option>
                                                    @endforeach
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission

                                    @permission('balances-form-party-read')
                                        <div class="form-group">
                                            <div class="input-group">
                                                <select class="form-control" id="party" name="party" multiple>
                                                    <option value="{{Lang::get('texte.balances_arr.index.supplier')}}">{{Lang::get('texte.balances_arr.index.supplier')}}</option>
                                                    <option value="{{Lang::get('texte.balances_arr.index.client')}}">{{Lang::get('texte.balances_arr.index.client')}}</option>
                                                </select>
                                            </div>
                                        </div>
                                    @endpermission
                                    
                                    <div class="form-group">
                                        <div class="input-group">
                                            <select class="form-control" id="allocation" name="allocation">
                                                <option value="">--- {{Lang::get('texte.balances_arr.index.allocation')}} ---</option>
                                                <option value="0">{{Lang::get('texte.balances_arr.index.no')}}</option>
                                                <option value="1">{{Lang::get('texte.balances_arr.index.yes')}}</option>
                                            </select>
                                        </div>
                                    </div>
                                    
                                    <button class='btn  btn-warning dark_bordered_warning' type="button" onclick="reset_filters();" title='{{Lang::get('texte.balances_arr.index.reset_filters')}}' data-toggle='tooltip'>{{Lang::get('texte.balances_arr.index.reset_filters')}}</button>
                                </div>
                            </div>
                        </div>   
                    </div>
                </div>
                
                <div class="panel-body">
                   <table class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                        <thead>
                            <tr>
                                <th>{{strtoupper(__('texte.balances_arr.index.id'))}}</th>
                                <th>{{__('texte.balances_arr.index.contragent')}}</th>
                                <th>{{__('texte.balances_arr.index.type')}}</th>
                                <th>{{__('texte.balances_arr.index.amount')}}</th>
                                <th>{{__('texte.balances_arr.index.wrappage')}}</th>
                                <th>{{__('texte.balances_arr.index.actions')}}</th>
                                <th>{{__('texte.balances_arr.index.objects')}}</th>
                                <th>{{__('texte.balances_arr.index.objects_amount')}}</th>
                                <th>{{__('texte.balances_arr.index.objects_wrappage')}}</th>
                                <th>{{__('texte.balances_arr.index.total_amounts')}}</th>
                                <th>{{__('texte.balances_arr.index.total_wrappage')}}</th>
                                <th>{{__('texte.balances_arr.index.interception')}}</th>
                                <th hidden>{{__('texte.balances_arr.index.contragent_id')}}</th>
                                <th hidden>{{__('texte.balances_arr.index.allocation')}}</th>
                            </tr>
                        </thead>
                        <tbody>
                        
                        </tbody>
                    </table>
                </div>
            </div>
	</div>
    </div>
</div>

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

        $('#contragents,#search_contragents,#allocation,#search_allocation_contragents,#search_allocation_objects').chosen();
        $('#objects,#search_objects').chosen({placeholder_text_multiple: '--- Обект ---'});
        $('#party,#search_party').chosen({placeholder_text_multiple: '--- Тип ---'});
        $('.chosen-container').addClass('width-400');
    
    function search_balances(){    
        reset_filters();
        var input = {};
        input['contragent'] = $('#search_contragents').val();
        input['object'] = $('#search_objects').val();
        input['party'] = $('#search_party').val();
        input['allocation_contragents'] = $('#search_allocation_contragents').val();
        input['allocation_objects'] = $('#search_allocation_objects').val();

        var table = $('.dataTables-example').DataTable({
            pageLength: 100,
            responsive: true,
            "server-side": true,
            "bDestroy": true,
            "ajax": {
                    headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    data: { 'input' : input},
                    url: '/get_balances',
                    type: 'POST'
            },
            "deferRender": true,
            columns: [
                        { data: 'id', name: 'Номер'},
                        { data: 'company_name', name: 'Контрагент'},
                        { data: 'is_client', name: 'Тип',
                            render: function ( data, type, row, meta ) {
                               var value='';
                               if(data==1){
                                   value+= 'Клиент <br />';
                               }
                               if(row.is_supplier==1){
                                  value+=  'Доставчик';
                               }
                               return value;
                            },
                        },
                        { data: 'paid_amount', name: 'Сума',
                           render: function ( data, type, row, meta ) {
                               return (data-row.due_amount).toFixed(2);
                            },
                        },
                        { data: 'wrappage_paid_amount', name: 'Амбалаж',
                           render: function ( data, type, row, meta ) {
                               return (data-row.wrappage_due_amount).toFixed(2);
                            },
                        },
                        { data: 'id', name: 'Действия',
                          "fnCreatedCell": function (nTd, sData, oData, iRow, iCol){
                              var html="<div class='btn-group btn-group-xs'><a href='balances/" + sData + "/show' class='btn " + (oData.due_amount!=0 && oData.paid_amount!=0 ? 'btn-danger': 'btn-success') + "' title='Суми' @nonepermission('balances-route-list') disabled @endnonepermission><i class='glyphicon glyphicon-eye-open'></i></a>";
                              
                              if(oData.is_supplier==1){
                                html+="<a href='balances/"+sData+"/supplier_wrappage_balance' class='btn btn-success' title='Амбалаж' @nonepermission('balances-route-create') disabled @endnonepermission><i class='glyphicon glyphicon-eye-open'></i></a></div>";
                              }
                              $(nTd).html(html);
                          }
                        },                         
                        { data: 'id', name: 'Обекти',
                          "fnCreatedCell": function (nTd, sData, oData, iRow, iCol){
                              if(oData.contragent_paid_amount!=0){
                                  var html = "<h3>Сума платена от контрагента: " + parseFloat(oData.contragent_paid_amount).toFixed(2) + "</h3>";
                              }
                              else{
                                  var html = '';
                              }
                              
                              if(oData.objects_short.length>0){       

                                html+="<table class='table table-bordered table-striped table-hover'><tr><th>Име</th><th>Сума</th><th>Амбалаж</th><th>Действия</th></tr>";
                                for(var i=0; i<oData.objects_short.length; i++){ 
                                    var j=0;
                                    
                                    if($('#search_objects').val()==0 || $.inArray(oData.objects_short[i].id,$('#search_objects').val())!==-1){                                        
                                        var due_amount = 0;
                                        var paid_amount = 0;
                                        var wrappage_due_amount = 0;
                                        var wrappage_paid_amount = 0;

                                        for(var j=0; j<oData.objects_short[i].documents_short.length;j++){
                                            if($.inArray( oData.objects_short[i].documents_short[j].doc_type, ['12','21','23','24','25','27','33','40','45'])!==-1){
                                                due_amount += parseFloat(oData.objects_short[i].documents_short[j].total-oData.objects_short[i].documents_short[j].paid);                                            
                                            }
                                            if($.inArray( oData.objects_short[i].documents_short[j].doc_type, ['10','11','13','14','15','16','18','22','39','46','63','65'])!==-1){
                                                paid_amount += parseFloat(oData.objects_short[i].documents_short[j].total-oData.objects_short[i].documents_short[j].paid);
                                            }
                                            if($.inArray( oData.objects_short[i].documents_short[j].doc_type, ['26','32'])!==-1){
                                                wrappage_due_amount += parseFloat(oData.objects_short[i].documents_short[j].total-oData.objects_short[i].documents_short[j].paid);
                                            }
                                            if($.inArray( oData.objects_short[i].documents_short[j].doc_type, ['17','19'])!==-1){
                                                wrappage_paid_amount += parseFloat(oData.objects_short[i].documents_short[j].total-oData.objects_short[i].documents_short[j].paid);
                                            }
                                        }
                                        
                                        if($('#search_allocation_objects').val()=="" || ($('#search_allocation_objects').val()==0 && (due_amount==0 || paid_amount==0)) || ($('#search_allocation_objects').val()==1 && (due_amount!=0 && paid_amount!=0)) ){
                                           
                                            html+="<tr class='object'><td>"+oData.objects_short[i].user.name+"</td><td>"; 
                                            html += (due_amount-paid_amount).toFixed(2) + "</td><td>";

                                            html+= (wrappage_due_amount-wrappage_paid_amount).toFixed(2) + "</td><td><div class='btn-group btn-group-xs'><a class='btn " + (due_amount!=0 && paid_amount!=0 ? 'btn-danger' : 'btn-success') + "' href='object_balances/"+oData.objects_short[i].id+"/show' type='button' title='Суми' @nonepermission('balances-route-list') disabled @endnonepermission><i class='glyphicon glyphicon-eye-open'></i></a> <a class='btn btn-success' href='balances/"+oData.objects_short[i].id+"/wrappage_balance' type='button' title='Амбалаж' @nonepermission('balances-route-create') disabled @endnonepermission><i class='glyphicon glyphicon-eye-open'></i></a></div></td></tr>";
                                        }
                                    }
                                }
                                html+= "</table>";
                              }
                              else{
                                var html='';
                              }
                              $(nTd).html(html);
                          }  
                        },  
                        { data: 'total_objects_balance', name:'Сума обекти',
                            render: function ( data, type, row, meta ) {
                               return parseFloat(data).toFixed(2);
                            },
                        },
                        { data: 'total_objects_wrappage_balance' , name: 'Амбалаж обекти',
                            render: function ( data, type, row, meta ) {
                               return parseFloat(data).toFixed(2);
                            },
                        },        
                        { data: 'paid_amount' , name: 'Общо суми',
                           render: function ( data, type, row, meta ) {
                               return (data-row.due_amount+parseFloat(row.total_objects_balance)).toFixed(2);
                            },
                        },  
                        { data: 'wrappage_paid_amount' , name: 'Общо амбалаж',
                            render: function ( data, type, row, meta ) {
                               return (data-row.wrappage_due_amount+parseFloat(row.total_objects_wrappage_balance)).toFixed(2);
                            },
                        },  
                        { data: 'id' , name: 'Прихващане',
                          "fnCreatedCell": function (nTd, sData, oData, iRow, iCol){
                            var html="<a class='fancy-var1 btn btn-warning' href='balances/"+sData+"/offset_finances' target='_parent' @nonepermission('balances-route-create') disabled @endnonepermission>Прихващане</a>";
                            $(nTd).html(html);
                          }  
                        },  
                        { data: 'id' , name: 'Контрагент ID',
                          "visible":false,
                        },
                        { data: 'id', name: 'За разпределяне',
                            render: function ( data, type, row, meta ) {
                               return row.due_amount!=0 && row.paid_amount!=0 ? 1 : 0;
                            },
                            "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();
                        $("a").each(function(){
                            if($(this).attr('disabled')=='disabled'){
                                $(this).addClass('not-active');
                            }
                        });  
                    },
                    "dom" : "fl<'#add_document'>tip",

        });
    
        $('#contragents').on('change', function(){
            if($(this).val()!=''){
                table.columns('Контрагент:name').search("^" + $(this).val() + "$", true, false).draw();  
            }
            else{
               table.columns('Контрагент:name').search('').draw(); 
            }
        });
            
            
        
        $(document).on('change','#objects', function(){
            if($(this).val()!=''){
                var value = $(this).val().join('$|^');
                table.columns('Контрагент ID:name').search("^" + value + "$", true, true).draw();
            }
            else{
                table.columns('Контрагент ID:name').search('').draw();
            }
        }); 
        
        $(document).on('change','#party', function(){
            if($(this).val()!=''){
                var value = $(this).val().join(' ');
                table.columns('Тип:name').search(value).draw(); 
            }
            else{
               table.columns('Тип:name').search('').draw(); 
            }
        });
        
        $('#allocation').on('change', function(){
            if($(this).val()!=''){
                table.columns('За разпределяне:name').search($(this).val()).draw();  
            }
            else{
               table.columns('За разпределяне:name').search('').draw(); 
            }
        });
    }       
    
    $('#contragents').on('change', function(){
        <!--Get objects associated with a client on change-->
        var client = $('#contragents option:selected').attr('data-id')!=undefined ? $('#contragents option:selected').attr('data-id') : '';
        $.ajax({
            headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    url: '/get_filtered_objects',
                    type: 'POST',
            data: { 'client' : client},
            success: function(response){
                        var options='<option value="0"> --- Обект --- </option>';
                        $('#objects').find('option').remove().end();
                        if(response.length>0){
                            for (var i in response){
                                   options += '<option value="' + response[i].id + '" data-id="'+response[i].contragent_id+'">' +  response[i].name  + '</option>';
                            }
                        }
                        $('#objects').html(options);
                        $('#objects').trigger("chosen:updated");
                    }
        });
    });
    
    $('#search_contragents').on('change', function(){
        <!--Get objects associated with a client on change-->
        var client = $('#search_contragents option:selected').attr('data-id')!=undefined ? $('#search_contragents option:selected').attr('data-id') : '';
        $.ajax({
            headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                    },
                    url: '/get_filtered_objects',
                    type: 'POST',
            data: { 'client' : client},
            success: function(response){
                        var options='<option value="0"> --- Обект --- </option>';
                        $('#search_objects').find('option').remove().end();
                        if(response.length>0){
                            for (var i in response){
                                   options += '<option value="' + response[i].id + '" data-id="'+response[i].contragent_id+'">' +  response[i].name  + '</option>';
                            }
                        }
                        $('#search_objects').html(options);
                        $('#search_objects').trigger("chosen:updated");
                    }
        });
    });
    
    function reset_filters(){
        $('#contragents,#objects,#party,#allocation').val('').trigger('chosen:updated').change();
    }
    </script>
@endsection