@extends(isset($input['print']) && $input['print']==1 ? 'layouts.general' : '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/jquery-ui.min.css') }}" rel="stylesheet">
    <link href="{{ asset('css/jquery.dataTables.yadcf.css') }}" rel="stylesheet">
    @if(isset($input) && (!isset($input['print']) || $input['print']==1))
        <link href="{{ asset('css/print_style.css') }}" rel="stylesheet">
    @endif
@endsection

@section('style')
<style>
    
    .btn-submit{
        margin-bottom:6px;
    }
    
    .errorBox{
        max-width:195px;
    }
    
    .form-inline .form-group {
         vertical-align: text-top;
    }
</style>
@endsection

@section('content')
@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.references_arr.earnings.earnings_by_client')}}
                    <div class="pull-right">
                        @if(!isset($input['print']) || $input['print']!=1)
                        <a class="btn btn-success" href="{{route('references')}}">{{__('texte.references_arr.earnings.references')}}</a>
                        @endif
                    </div>
                </h3>
                <br />

                <form id='reference_create' method="POST" action="{{ route('references.post_earnings_by_client') }}" role="form" class="form-inline">
                    {{ csrf_field() }}                        

                    <input type='hidden' id='print' name='print' value='{{$input['print'] ?? 0}}'/>
                    <input type='hidden' id='excel' name='excel' value='{{$input['excel'] ?? 0}}'/>

                    <div class="form-inline panel panel-default">    
                        <h3 class="panel-title">{{__('texte.references_arr.earnings.general_filters')}}</h3>                        

                        <div class="form-group">
                            <div class="input-group">
                                <input type="text" class="yadcf-filter-range-date" id="date_from" name="date_from" value="{{isset($input['date_from']) ? $input['date_from'] : ''}}" placeholder="{{__('texte.references_arr.earnings.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.references_arr.earnings.date_to')}}"/>
                                <div class="errorBox"></div>
                            </div>  
                        </div>

                        @if(!isset($input['print']) || $input['print']!=1)
                        <div class="form-group">
                            <div class="input-group">
                                <button type='button' class='btn btn-warning dark_bordered_warning' onclick="reset_general_filters();" title='{{__('texte.references_arr.earnings.reset_filters')}}' data-toggle='tooltip'>{{__('texte.references_arr.earnings.reset_filters')}}</button>
                            </div>
                        </div>
                        @endif
                    </div>    

                    @include('references.filters.object_filters')

                    @if(!isset($input['print']) || $input['print']!=1)
                    <div class="form-group">
                        <div class="input-group">
                            <button id="search_btn" type='submit' class="btn btn-primary btn-submit dark_bordered_warning">{{__('texte.references_arr.filters.search')}}</button> 
                            <button type='button' class="btn btn-success dark_bordered_warning" id='print_btn'>{{__('texte.references_arr.filters.print')}}</button>
                            <button type='button' class="btn btn-alt dark_bordered_warning" id='excel_btn'>{{__('texte.references_arr.filters.excel')}}</button>
                        </div>
                    </div>
                    @endif
                </form>                    
            </div>

            <div class="panel-body">
                @if(isset($doc_rows) && count($doc_rows) > 0)

                <table id="myTable" class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                    <thead>
                        <tr>
                            <th>{{__('texte.references_arr.earnings.client')}}</th>
                            <th>{{__('texte.references_arr.earnings.object')}}</th>
                            <th>{{__('texte.references_arr.earnings.count_articles')}}</th>
                            <th>{{__('texte.references_arr.earnings.quantity')}}</th>
                            <th>{{__('texte.references_arr.earnings.sales_value')}}</th>
                            <th>{{__('texte.references_arr.earnings.delivery_value')}}</th>
                            <th>{{__('texte.references_arr.earnings.earning')}}</th>   
                            <th>{{__('texte.references_arr.earnings.surcharge')}}</th>
                            <th>{{__('texte.references_arr.earnings.discount')}}</th>
                            <th>{{__('texte.references_arr.earnings.sales_price')}}</th>
                            <th>{{__('texte.references_arr.earnings.delivery_price')}}</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($doc_rows as $index=>$doc_row)
                            @if($index==0 || ($index>0 && $doc_rows[$index]->object_name!=$doc_rows[$index-1]->object_name))
                            <tr>
                                <td>{{$doc_row->client_name}}</td>
                                <td>{{$doc_row->object_name}}</td>
                                <td>{{count($doc_rows->where('client_name',$doc_row->client_name))}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sold_quantity'),3,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value'),3,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value'),3,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')>=0 ? $doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value') - $doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value') : $doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value') + $doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value'),3,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value')!=0 ? ($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value') - $doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value'))*100/($doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value')) : 100*($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')>=0 ? 1 : -1),2,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')!=0 ? ($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value') - $doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value'))*100/($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')) : 100*($doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')>=0 ? 1 : -1),2,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sold_quantity')!=0 ? $doc_rows->where('object_name',$doc_row->object_name)->sum('sales_value')/$doc_rows->where('object_name',$doc_row->object_name)->sum('sold_quantity') : 0,5,'.','')}}</td>
                                <td>{{number_format($doc_rows->where('object_name',$doc_row->object_name)->sum('sold_quantity')!=0 ? $doc_rows->where('object_name',$doc_row->object_name)->sum('delivery_value')/$doc_rows->where('object_name',$doc_row->object_name)->sum('sold_quantity') : 0,5,'.','')}}</td>
                            </tr>  
                            @endif
                        @endforeach
                    </tbody>
                    <tfoot>
                        <tr>
                            <th colspan='2' style="text-align:right">{{__('texte.references_arr.earnings.total')}}:</th>
                            <th>{{count($doc_rows)}}</th>
                            <th>{{number_format($doc_rows->sum('sold_quantity'),3,'.','')}}</th>
                            <th>{{number_format($doc_rows->sum('sales_value'),3,'.','')}}</th>
                            <th>{{number_format($doc_rows->sum('delivery_value'),3,'.','')}}</th>                                
                            <th>{{number_format($doc_rows->sum('sales_value')>=0 ? $doc_rows->sum('sales_value') - $doc_rows->sum('delivery_value') : $doc_rows->sum('sales_value') + $doc_rows->sum('delivery_value'),3,'.','')}}</th>
                            <th>{{number_format($doc_rows->sum('delivery_value')!=0 ? ($doc_rows->sum('sales_value') - $doc_rows->sum('delivery_value'))*100/($doc_rows->sum('delivery_value')) : 100*($doc_rows->sum('sales_value')>=0 ? 1 : -1),2,'.','')}}</th>
                            <th>{{number_format($doc_rows->sum('sales_value')!=0 ? ($doc_rows->sum('sales_value') - $doc_rows->sum('delivery_value'))*100/($doc_rows->sum('sales_value')) : 100*($doc_rows->sum('sales_value')>=0 ? 1 : -1),2,'.','')}}</th>
                            <th></th>
                            <th></th>
                        </tr>
                    </tfoot>
                </table>
                @endif
             </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/jquery.validate.js') }}"></script>
<script src="{{ asset('js/validation.js') }}"></script>

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

@if(!isset($input['print']) || $input['print']!=1)
<script src="{{asset('js/references.object_filters.js')}}"></script>
@endif

<script type="text/javascript" charset="utf-8">
    
    if($('#print').val()!=='1'){
        table = $('.dataTables-example').DataTable({
            pageLength: 100,
            responsive: true,
            deferRender:    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": "Предишна страница",
                                  },

            },

            /*"footerCallback": function ( row, data, start, end, display ) {
                var api = this.api(), data;

                // Remove the formatting to get integer data for summation
                var intVal = function ( i ) {
                    return typeof i === 'string' ?
                        i.replace(/[\$,]/g, '')*1 :
                        typeof i === 'number' ?
                            i : 0;
                };

                // Total over all pages
                total_2 = api
                    .column( 2 )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );

                total_3 = api
                    .column( 3 )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );

                total_4 = api
                    .column( 4 )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );   

                total_5 = api
                    .column( 5 )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );  

                total_6 = api
                    .column( 6 )
                    .data()
                    .reduce( function (a, b) {
                        return intVal(a) + intVal(b);
                    }, 0 );

                // Update footer

                $( api.column( 2 ).footer() ).html(
                   parseFloat(total_2)
                );
                $( api.column( 3 ).footer() ).html(
                   parseFloat(total_3).toFixed(3)
                );
                $( api.column( 4 ).footer() ).html(
                   parseFloat(total_4).toFixed(3)
                );
                $( api.column( 5 ).footer() ).html(
                   parseFloat(total_5).toFixed(3)
                );
                $( api.column( 6 ).footer() ).html(
                   parseFloat(total_6).toFixed(3)
                );
            },*/

            "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_storage'>tip",

        });

        $('#storage').each(function(){
            var select_element = $(this);
            select_element.chosen({placeholder_text_multiple: '--- '+ select_element.attr('data-name') + ' ---'});
        });

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

        $("#date_to").datepicker(); 



        function reset_general_filters(){
            $('#storage').val('').trigger("chosen:updated").change();
            $('#date').val('');
        }
        
        $('#print_btn').on('click', function(){
            var my_form = $('#reference_create');
            $(my_form).prop('target','_blank');
            $('#print').val(1);
            $('#excel').val(0);
            my_form.submit();
        });

        $('#search_btn').on('click', function(e){
            e.preventDefault();
            var my_form = $('#reference_create');
            $(my_form).prop('target','_self');
            $('#print').val(0);
            $('#excel').val(0);
            my_form.submit();
        });
        
        $('#excel_btn').on('click', function(e){
            e.preventDefault();
            var my_form = $('#reference_create');
            $(my_form).prop('target','_self');
            $('#print').val(0);
            $('#excel').val(1);
            my_form.submit();
        });
    }
    else{
        $('select.form-control').each(function(){
            var select_element = $(this);
            select_element.chosen({placeholder_text_multiple: '--- '+ select_element.attr('data-name') + ' ---'});
        });

        $('.filter-multiple').each(function(){
            var select_element = $(this);
            select_element.on('chosen:ready', function(event, data){$(this).next('.chosen-container-multi').addClass('chosen-narrow')}).chosen({placeholder_text_multiple: '--- '+ select_element.attr('data-name') +' ---'});
        });

        $('#object_payment_type,.filter').chosen();
    }
    
    
</script>
@endsection