@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')
<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.references_arr.realisation.title4')}}
                        <div class="pull-right">
                            @if(!isset($input['print']) || $input['print']!=1)
                            <a class="btn btn-success" href="{{route('references.index')}}">{{__('texte.references_arr.realisation.references')}}</a>
                            @endif
                        </div>
                    </h3>
                    <br />
                
                    <form id='reference_create' method="POST" action="{{ route('references.post_agent_realisations_by_product') }}" 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.realisation.general_filters')}}</h3>                        

                            <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.references_arr.realisation.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.realisation.date_to')}}"/>
                                        </div>
                                    </div>  
                                    <div class="errorBox"></div>
                                </div>  
                            </div>
                            
                            <div class="form-group">
                                <div class="input-group">
                                    <select class="form-control" id="source" name="source[]" data-name="{{__('texte.references_arr.realisation.source')}}" multiple="">
                                        @foreach(Lang::get('texte.source_type_arr_text') as $key=>$val)
                                        <option value="{{$key}}" {{isset($input['source']) && in_array($key,$input['source']) ? "selected" : ""}}>{{$val}}</option>
                                        @endforeach
                                    </select>
                                </div>
                            </div>
                            
                            <div class="form-group">
                                <div class="input-group">
                                    <select class="form-control" id="user" name="user[]" data-name="{{__('texte.references_arr.realisation.representative')}}" multiple>
                                        @foreach($users as $user)
                                        <option value="{{$user->id}}" {{isset($input['user']) && in_array($user->id,$input['user']) ? "selected" : ""}}>{{$user->name}}</option>
                                        @endforeach
                                    </select>
                                </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.realisation.reset_filters')}}' data-toggle='tooltip'>{{__('texte.references_arr.realisation.reset_filters')}}</button>
                                </div>
                            </div>
                            @endif
                        </div>
                        
                        @include('references.filters.object_filters')
                        
                        @include('references.filters.product_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.realisation.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>
                            </div>
                        </div>
                        @endif
                    </form>                    
                </div>
                
                <div class="panel-body">
                    @if(isset($agent_realisations) && count($agent_realisations) > 0)

                    <table id="myTable" class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                        <thead>
                            <tr>
                                <th>{{__('texte.references_arr.realisation.client')}}</th>
                                <th>{{__('texte.references_arr.realisation.object')}}</th>
                                <th>{{__('texte.references_arr.realisation.date')}}</th>
                                <th>{{__('texte.references_arr.realisation.in_tons')}}</th>   
                                <th>{{__('texte.references_arr.realisation.total_amount')}}</th>
                                <th>{{__('texte.references_arr.realisation.count_orders')}}</th>
                                <th>{{__('texte.references_arr.realisation.visitations')}}</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($agent_realisations as $index=>$agent_realisation)                                
                                @if($index==0 || ($index>0 && $agent_realisations[$index-1]->source!=$agent_realisation->source))
                                    <tr><td colspan="7"><strong><h3>{{__('texte.source_type_arr_text')[$agent_realisation->source]}}</h3></strong></td></tr> 
                                @endif       
                                @if($index==0 || ($index>0 && $agent_realisations[$index-1]->user_id!=$agent_realisation->user_id))
                                    <tr><td colspan="7" style='padding-left:25%;'><strong><h4>{{$agent_realisation->user_name}}</h4></strong></td></tr> 
                                @endif
                                
                                @if($index==0 || ($index>0 && $agent_realisations[$index-1]->order_id!=$agent_realisation->order_id))
                                <tr>                                    
                                    <td>{{$agent_realisation->contragent_name ?? $agent_realisation->contragent_name}}</td>
                                    <td>{{$agent_realisation->object_name}}</td>
                                    <td>{{date('d.m.Y',strtotime($agent_realisation->delivery_date))}}</td>
                                    <td>{{number_format($agent_realisations->where('order_id',$agent_realisation->order_id)->sum('total_weight'),3,'.','')}}</td>
                                    <td>{{number_format($agent_realisations->where('order_id',$agent_realisation->order_id)->sum('total_wrappage_amount'),2,'.','')}}</td>
                                    <td></td>
                                    <td></td>
                                </tr>
                                <tr>
                                    <td colspan='9'>
                                        <table class='table table-bordered'>
                                            <tbody>
                                                <tr>
                                                    <th style="width:15%">{{__('texte.references_arr.realisation.code')}}</th>
                                                    <th style="width:35%">{{__('texte.references_arr.realisation.article')}}</th>
                                                    <th style="width:10%">{{__('texte.references_arr.realisation.quantity')}}</th>
                                                    <th style="width:10%">{{__('texte.references_arr.realisation.measure')}}</th>
                                                    <th style="width:10%">{{__('texte.references_arr.realisation.in_tons')}}</th>
                                                    <th style="width:5%">{{__('texte.references_arr.realisation.amount')}}</th>
                                                    <th style="width:15%">{{__('texte.references_arr.realisation.average_price')}}</th>
                                                </tr>
                                @endif
                                                <tr>
                                                    <td>{{$agent_realisation->product_id}}</td>
                                                    <td>{{$agent_realisation->product_name}}</td>
                                                    <td>{{$agent_realisation->package==1 ? $agent_realisation->quantity_processed : $agent_realisation->quantity_processed/$agent_realisation->package_count}}</td>
                                                    <td>{{$agent_realisation->package_name}}</td>
                                                    <td>{{number_format($agent_realisation->total_weight,3)}}</td>
                                                    <td>{{number_format($agent_realisation->total_amount,2,'.','')}}</td>
                                                    <td>{{number_format($agent_realisation->total_amount/$agent_realisation->quantity_processed,5,'.','')}}</td>
						</tr>
                                                @if($agent_realisation->wrappage_piece_name!=null)
                                                <tr>
                                                    <td>{{$agent_realisation->wrappage_piece_id}}</td>
                                                    <td>{{$agent_realisation->wrappage_piece_name}}</td>
                                                    <td>{{$agent_realisation->quantity_processed}}</td>
                                                    <td>брой</td>
                                                    <td>0,00</td>
                                                    <td>{{number_format($agent_realisation->quantity_processed*$agent_realisation->wrappage_piece_price,2,'.','')}}</td>
                                                    <td>{{number_format($agent_realisation->wrappage_piece_price,5,'.','')}}</td>
						</tr>
                                                @endif
                                                
                                                @if($agent_realisation->wrappage_package_name!=null)
                                                <tr>
                                                    <td>{{$agent_realisation->wrappage_package_id}}</td>
                                                    <td>{{$agent_realisation->wrappage_package_name}}</td>
                                                    <td>{{$agent_realisation->quantity_processed/$agent_realisation->package_count}}</td>
                                                    <td>брой</td>
                                                    <td>0,00</td>
                                                    <td>{{number_format($agent_realisation->quantity_processed*$agent_realisation->wrappage_package_price/$agent_realisation->quantity_processed,2,'.','')}}</td>
                                                    <td>{{number_format($agent_realisation->wrappage_package_price,5,'.','')}}</td>
						</tr>
                                                @endif
                                
                                @if(!isset($agent_realisations[$index+1]) || ($agent_realisations[$index+1]->order_id!=$agent_realisations[$index]->order_id))
                                            </tbody>
                                        </table>
                                    </td>
                                </tr>
                                @endif
                                
                                @if($index==count($agent_realisations)-1 || $agent_realisations[$index+1]->object!=$agent_realisation->object)
                                    <tr>
                                        <td colspan="3" style='text-align:right;padding-right:5px;'><strong><h4>{{__('texte.references_arr.realisation.total_for')}} {{$agent_realisation->object_name}}</h4></strong></td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->where('object',$agent_realisation->object)->sum('total_weight'),3,'.','')}}</td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->where('object',$agent_realisation->object)->sum('total_wrappage_amount'),2,'.','')}}</td>
                                        <td>{{count($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->where('object',$agent_realisation->object)->unique('order_id'))}}</td>
                                        <td>{{$agent_realisations->where('source',$agent_realisation->source)->where('object',$agent_realisation->object)->unique('object')->sum('total_visitations')}}</td>
                                    </tr> 
                                @endif
                                @if($index==count($agent_realisations)-1 || $agent_realisations[$index+1]->user_id!=$agent_realisation->user_id)
                                    <tr>
                                        <td colspan="3" style='text-align:right;padding-right:50px;'><strong><h4>{{__('texte.references_arr.realisation.total_for')}} {{$agent_realisation->user_name}}</h4></strong></td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->sum('total_weight'),3,'.','')}}</td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->sum('total_wrappage_amount'),2,'.','')}}</td>
                                        <td>{{count($agent_realisations->where('source',$agent_realisation->source)->where('user_id',$agent_realisation->user_id)->unique('order_id'))}}</td>
                                        <td>{{$agent_realisations->where('source',$agent_realisation->source)->where('object',$agent_realisation->object)->unique('object')->sum('total_visitations')}}</td>
                                    </tr> 
                                @endif
                                @if($index==count($agent_realisations)-1 || $agent_realisations[$index+1]->source!=$agent_realisation->source)
                                    <tr>
                                        <td colspan="3" style='padding-left:5%;'><strong><h4>{{__('texte.references_arr.realisation.total_for')}} {{__('texte.source_type_arr_text')[$agent_realisation->source]}}</h4></strong></td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->sum('total_weight'),3,'.','')}}</td>
                                        <td>{{number_format($agent_realisations->where('source',$agent_realisation->source)->sum('total_wrappage_amount'),2,'.','')}}</td>
                                        <td>{{count($agent_realisations->where('source',$agent_realisation->source)->unique('order_id'))}}</td>
                                        <td>{{$agent_realisations->where('source',$agent_realisation->source)->unique('object')->sum('total_visitations')}}</td>
                                    </tr> 
                                @endif
                                                                      
                            @endforeach                            
                        </tbody>
                        <tfoot>
                            <tr>
                                <th colspan="3" style='text-align: right;padding-right: 2px;'>{{__('texte.references_arr.realisation.total')}}: </th>
                                <th style='font-weight: bold;'>{{number_format($agent_realisations->sum('total_weight'),3,'.','')}}</th>
                                <th style='font-weight: bold;'>{{number_format($agent_realisations->sum('total_wrappage_amount'),2,'.','')}}</th>
                                <th style='font-weight: bold;'>{{count($agent_realisations->unique('order_id'))}}</th>
                                <th style='font-weight: bold;'>{{$agent_realisations->unique('object')->sum('total_visitations')}}</th>
                            </tr>  
                        </tfoot>
                    </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/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.document_filters.js')}}"></script>
<script src="{{asset('js/references.object_filters.js')}}"></script>
<script src="{{asset('js/references.product_filters.js')}}"></script>
@endif

<script type="text/javascript" charset="utf-8">
    
    if($('#print').val()!=='1'){
        $('#source,#user').each(function(){
            var select_element = $(this);
            select_element.chosen({placeholder_text_multiple: '--- '+ select_element.attr('data-name') + ' ---'});
        });

        $('#results').chosen();

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

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



        function reset_general_filters(){
            $('#source,#user,#results').val('').trigger("chosen:updated").change();
            $('#date_from,#date_to').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