@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.accounting.accounting_turnover_reference')}}
                        <div class="pull-right">
                            @if(!isset($input['print']) || $input['print']!=1)
                            <a class="btn btn-success" href="{{route('references.index')}}">{{__('texte.references_arr.accounting.references')}}</a>
                            @endif
                        </div>
                    </h3><br />
                
                    <form id='reference_create' method="POST" action="{{ route('references.post_accounting_turnover') }}" 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-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.accounting.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.accounting.date_to')}}"/>
                                    </div>
                                </div>    
                                <div class="errorBox"></div>                                
                            </div>  
                        </div>
                        
                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="product" name="storage" data-name="{{__('texte.references_arr.accounting.storage')}}" multiple>
                                        @foreach ($storages as $storage)
                                            <option value="{{ $storage->id}}" {{isset($input['storage']) && $storage->id==$input['storage'] ? "selected" : ""}}>{{ $storage->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_filters();" title='{{__('texte.references_arr.accounting.reset_filters')}}' data-toggle='tooltip'>{{__('texte.references_arr.accounting.reset_filters')}}</button>
                            </div>
                        </div> 
                        @endif
                        
                        @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.purchases.search')}}</button> 
                                <button type='button' class="btn btn-success dark_bordered_warning" id='print_btn'>{{__('texte.references_arr.purchases.print')}}</button>
                                <button type='button' class="btn btn-alt dark_bordered_warning" id='excel_btn'>{{__('texte.references_arr.purchases.excel')}}</button>
                            </div>
                        </div>
                        @endif
                    </form>
                    
                </div>
                <div class="panel-body">
                    
                    @if(isset($rows) && count($rows) > 0)

                    <table class="table table-bordered">
                        <thead>
                            <tr>
                                <th rowspan="2">{{strtoupper(__('texte.references_arr.accounting.id'))}}</th>                            
                                <th rowspan="2">{{__('texte.references_arr.accounting.name')}}</th>
                                <th rowspan="2">{{__('texte.references_arr.accounting.measure')}}</th>
                                <th colspan='2' style='text-align:center;'>{{__('texte.references_arr.accounting.start_result')}}</th>
                                <th colspan='2' style='text-align:center;'>{{__('texte.references_arr.accounting.income')}}</th>
                                <th colspan='2' style='text-align:center;'>{{__('texte.references_arr.accounting.outcome')}}</th>
                                <th colspan='2' style='text-align:center;'>{{__('texte.references_arr.accounting.result')}}</th>
                            </tr>
                            <tr>
                                <th>{{__('texte.references_arr.accounting.quantity')}}</th>
                                <th>{{__('texte.references_arr.accounting.value')}}</th>
                                <th>{{__('texte.references_arr.accounting.quantity')}}</th>
                                <th>{{__('texte.references_arr.accounting.value')}}</th>
                                <th>{{__('texte.references_arr.accounting.quantity')}}</th>
                                <th>{{__('texte.references_arr.accounting.value')}}</th>
                                <th>{{__('texte.references_arr.accounting.quantity')}}</th>
                                <th>{{__('texte.references_arr.accounting.value')}}</th>
                            </tr>
                        </thead>
                        <tbody>        
                            
                            @foreach($rows as $index=>$row)
                                @if($index==0 || ($index>0 && $rows[$index]->storage_name!=$rows[$index-1]->storage_name))
                                <tr>
                                    <td colspan='11' style='text-align:center;'><h3><strong>{{$row->storage_name}}</strong></h3></td>
                                </tr>
                                @endif
                                @if($index==0 || ($index>0 && $rows[$index]->producer_name!=$rows[$index-1]->producer_name))
                                <tr>
                                    <td colspan='11'><h5><strong>{{$row->producer_name ?? 'N/A'}}</strong></h5></td>
                                </tr>
                                @endif
                                @if($index==0 || ($index>0 && $rows[$index]->producer_name!=$rows[$index-1]->producer_name) || ($index>0 && $rows[$index]->category!=$rows[$index-1]->category))
                                <tr>
                                    <td></td>
                                    <td colspan='10'><h5><strong>{{$row->category}}</strong></h5></td>
                                </tr>
                                @endif
                                <tr>
                                    <td>{{$row->id}}</td>
                                    <td>{{ $row->name }}</td>
                                    <td>{{ $row->package_name }}</td>
                                                         
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>195</b><br />
<br />
<b>Notice</b>:  Trying to get property 'start_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>195</b><br />
                                    <td>{{number_format($initial_quantity,3,'.','')}}</td>
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>203</b><br />
<br />
<b>Notice</b>:  Trying to get property 'start_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>203</b><br />
                                    <td>{{number_format($initial_value,2,'.','')}}</td>
                                    
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>212</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>212</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>213</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>213</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>214</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>214</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>215</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>215</b><br />
                                    <td>{{ $row->purchased_quantity}}</td>
                                    
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>220</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>220</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>221</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>221</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>222</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>222</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>223</b><br />
<br />
<b>Notice</b>:  Trying to get property 'purchased_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>223</b><br />
                                    <td>{{ number_format($row->purchased_value,2,'.','')}}</td>                                    
                                    <td>{{ $row->sold_quantity}}</td>                                   
                                    
                                    <td>{{ $row_value_sold_during_period = number_format($row->sold_value,2,'.','')}}</td>
                                    <br />
<b>Notice</b>:  Undefined variable: row_value_sold_during_period in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>230</b><br />
<br />
<b>Notice</b>:  Undefined variable: row_value_sold_during_period in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>231</b><br />
<br />
<b>Notice</b>:  Undefined variable: row_value_sold_during_period in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>232</b><br />
<br />
<b>Notice</b>:  Undefined variable: row_value_sold_during_period in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>233</b><br />
                                    
                                    <td>{{number_format($row->final_quantity,3,'.','')}}</td>
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>238</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>239</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>239</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>240</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>240</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>241</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_quantity' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>241</b><br />
                                    
                                    <td>{{number_format($row->final_value,2,'.','')}}</td>  
                                    <br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>246</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>246</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>247</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>247</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>248</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>248</b><br />
<br />
<b>Notice</b>:  Undefined variable: row in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>249</b><br />
<br />
<b>Notice</b>:  Trying to get property 'final_value' of non-object in <b>D:\dev\sklad\resources\views\references\accounting_turnover.blade.php</b> on line <b>249</b><br />
                                </tr>
                                @if($index==count($rows)-1 || ($index < count($rows)-1 && $rows[$index]->storage_name!=$rows[$index+1]->storage_name) || ($index < count($rows)-1 && $rows[$index]->category!=$rows[$index+1]->category) || ($index < count($rows)-1 && $rows[$index]->producer_name!=$rows[$index+1]->producer_name))
                                    <tr style="background: #ededf0;">
                                        <td colspan="4" style="text-align:right;padding-right:5px;"><strong>{{__('texte.references_arr.accounting.total_for')}} {{$row->category}}:</strong></td>
                                        <td>{{ number_format($category_initial_value,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($category_value_purchased_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($category_value_sold_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{number_format($category_value_final,2,'.','')}}</td>  
                                    </tr>
                                                                    @endif
                                @if($index==count($rows)-1 || ($index < count($rows)-1 && $rows[$index]->storage_name!=$rows[$index+1]->storage_name) || ($index < count($rows)-1 && $rows[$index]->producer_name!=$rows[$index+1]->producer_name))
                                    <tr style="background: #f5f5f5;">
                                        <td colspan="4" style="text-align:right;padding-right:50px;"><strong>{{__('texte.references_arr.accounting.total_for')}} {{$row->producer_name}}:</strong></td>
                                        <td>{{ number_format($producer_initial_value,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($producer_value_purchased_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($producer_value_sold_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{number_format($producer_value_final,2,'.','')}}</td>  
                                    </tr>
                                                                    @endif
                                @if($index==count($rows)-1 || ($index < count($rows)-1 && $rows[$index]->storage_name!=$rows[$index+1]->storage_name))
                                    <tr style="background: #e7e7e7;">
                                        <td colspan="4" style="text-align:center;"><strong>{{__('texte.references_arr.accounting.total_for')}} {{$row->storage_name}}:</strong></td>
                                        <td>{{ number_format($storage_initial_value,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($storage_value_purchased_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{ number_format($storage_value_sold_during_period,2,'.','')}}</td>
                                        <td></td>
                                        <td>{{number_format($storage_value_final,2,'.','')}}</td>  
                                    </tr>
                                                                    @endif
                            @endforeach
                            
                            <tr style="background: #b2b8bf;">
                                <td colspan="4"><strong>{{__('texte.references_arr.accounting.total_for_company')}}:</strong></td>
                                <td>{{ number_format($total_initial_value,2,'.','')}}</td>
                                <td></td>
                                <td>{{ number_format($total_value_purchased_during_period,2,'.','')}}</td>
                                <td></td>
                                <td>{{ number_format($total_value_sold_during_period,2,'.','')}}</td>
                                <td></td>
                                <td>{{number_format($total_value_final,2,'.','')}}</td> 
                            </tr>
                                
                        </tbody>
                    </table>
                    @endif                        
                </div>               
            </div>
        </div>
    </div>
</div>


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

<script src="{{ asset('js/chosen.js') }}"></script>
<script src="{{ asset('js/jquery.validate.js') }}"></script>
<script src="{{ asset('js/validation.js') }}"></script>

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

<script type="text/javascript">
    
    $('#storage').chosen();
    
    if($('#print').val()!=='1'){
        
        $('#creation_type').chosen();
        
        $('#contragents,#objects,#creator,#doc_type,#payment_type').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();
        
        $('#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();
        });
        
        $('#contragents').on('change', function(){
            var client = $('#contragents').val();
            var objects = $('#objects').val();

            $.ajax({
                headers: {
                        'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                        },
                        url: '/get_contragents_objects',
                        type: 'POST',
                data: { 'client' : client},
                success: function(response){
                            var options='<option value="0"> --- Обект --- </option>';
                            $('#objects').find('option').remove().end();

                            for (var i in response){
                                   options += '<option value="' + response[i].id + '" name="'+ response[i].name + '" '+ ($.inArray(String(response[i].id), objects)!== -1 ? "selected" : "")  +'>' +  response[i].name  + '</option>';
                            }

                            $('#objects').html(options);
                            $('#objects').trigger("chosen:updated");
                        }
            });
        }).change();
        
        function reset_filters(){
            $('#contragents,#objects,#creator,#doc_type,#storage').val('').trigger("chosen:updated").change();
            $('#date_from,#date_to').val('');
        }
    }
    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