@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">
    <link href="{{ asset('css/bootstrap-datepicker.css') }}" rel="stylesheet">
    

    <link href="{{ asset('css/jquery-ui.min.css') }}" rel="stylesheet">
    <link href="{{ asset('css/jquery.dataTables.yadcf.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-list"></span> {{__('texte.nap_arr.cancelled_sales.cancelled_sales')}} 
                        <div class="pull-right"></div>
                    </h3><br />    
                    
                    <form id='cancelled_sales' method="POST" action="{{ route('post_cancelled_sales') }}" role="form" class="form-inline">
                        {{ csrf_field() }}

                        <div class="form-group">
                            <div class="input-group">
                                <select class="form-control" id="contragent" name="contragent">
                                    <option value="">--- {{__('texte.nap_arr.cancelled_sales.contragent')}} ---</option>
                                    @foreach ($contragents as $contragent)
                                        <option value="{{ $contragent->id }}" {{isset($input['contragent']) && $input['contragent'] == $contragent->id ? "selected" : ''}}>{{ $contragent->company_name ?? $contragent->user->name }}</option>
                                    @endforeach
                                </select>
                                <div class="errorBox"></div>
                            </div>
                        </div>

                        <div class="form-group">
                            <div class="input-group">
                                <select id="object" name="object" data-name="{{__('texte.nap_arr.cancelled_sales.object')}}">
                                    @foreach($objects as $object)
                                        <option value="{{$object->id}}">{{ $object->name }}</option>
                                    @endforeach
                                </select>
                                <div class="errorBox"></div>
                            </div>                            
                        </div>
                        
                        <div class="form-group">
                            <div class="input-group">
                                <select id="user" name="user" data-name="{{__('texte.nap_arr.cancelled_sales.user')}}">
                                    <option value="">--- {{__('texte.nap_arr.cancelled_sales.user')}} ---</option>
                                    @foreach($users as $user)
                                        <option value="{{$user->id}}" {{isset($input['user']) && $input['user']==$user->id ? "selected" : ""}}>{{ $user->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        
                        <div class="form-group">
                            <div class="input-group">
                                <select id="product" name="product" data-name="{{__('texte.nap_arr.cancelled_sales.product')}}">
                                    <option value="">--- {{__('texte.nap_arr.cancelled_sales.product')}} ---</option>
                                    @foreach($products as $product)
                                        <option value="{{$product->id}}" {{isset($input['product']) && $input['product']==$product->id ? "selected" : ""}}>{{ $product->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                        </div>
                        
                        <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.nap_arr.cancelled_sales.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.nap_arr.cancelled_sales.date_to')}}"/>
                                    </div>
                                </div>                                    
                            </div>  
                        </div>
                       
                        <button class='btn btn-warning dark_bordered_warning' type="submit" title='{{__('texte.nap_arr.cancelled_sales.search')}}'>{{__('texte.nap_arr.cancelled_sales.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>
                    </form>
                </div>

                <div class="panel-body">    
                    @if(isset($order_products))
                    <table id="myTable" class="table table-striped table-bordered table-hover dataTables-example dataTable" width="100%">
                        <thead>
                            <tr>
                                <th>{{__('texte.nap_arr.cancelled_sales.sale_number')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.system_sale_number')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.product_code')}}</th> 
                                <th>{{__('texte.nap_arr.cancelled_sales.product_name')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.quantity')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.single_price')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.discount')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.vat_rate')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.vat_amount')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.total_amount')}}</th> 
                                <th>{{__('texte.nap_arr.cancelled_sales.sale_opening_date')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.sale_opening_time')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.sale_cancelling_date')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.sale_cancelling_time')}}</th>
                                <th>{{__('texte.nap_arr.cancelled_sales.user_id')}}</th>
                            </tr>
                        </thead>

                        <tbody>
                            @foreach($order_products as $order_product)
                            <tr>
                                <td>{{$order_product->usn}}</td>
                                <td>{{$order_product->order}}</td>
                                <td>{{$order_product->product}}</td>
                                <td>{{$order_product->produkt->name}}</td>
                                <td>{{$order_product->status==7 ? $order_product->quantity_ordered : $order_product->quantity_ordered-$order_product->quantity_processed }}</td>
                                <td>{{number_format($order_product->single_price,5,'.','')}}</td>
                                <td>{{number_format($order_product->gift==0 ? $order_product->super_discount : $order_product->single_price,5,'.','')}}</td>
                                <td>20%</td>
                                <td>{{number_format($order_product->single_price*0.2,5,'.','')}}</td>
                                <td>{{$order_product->gift==0 ? number_format(($order_product->single_price-$order_product->super_discount)*1.2*($order_product->parent_order->status==7 ? $order_product->quantity_ordered : $order_product->quantity_ordered-$order_product->quantity_processed),5,'.','') : '0.00000'}}</td>
                                <td>{{date("d.m.Y",strtotime($order_product->parent_order->created_at))}}</td>
                                <td>{{date("H:i:s",strtotime($order_product->parent_order->created_at))}}</td>
                                <td>{{date("d.m.Y",strtotime($order_product->parent_order->status==7 ? $order_product->parent_order->updated_at : $order_product->parent_order->documents->where('doc_type',20)[0]->created_at))}}</td>
                                <td>{{date("H:i:s",strtotime($order_product->parent_order->status==7 ? $order_product->parent_order->updated_at : $order_product->parent_order->documents->where('doc_type',20)[0]->created_at))}}</td>
                                <td>{{$order_product->parent_order->user_id}}</td>
                            </tr>
                            @endforeach
                        </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/datatables.min.js') }}"></script>
<script src="{{ asset('js/jquery.dataTables.yadcf.js') }}"></script>

<script type="text/javascript" charset="utf-8">
    
    $('#user,#contragent,#object,#product').chosen();
    
    var object = {!! isset($input['object']) ? $input['object'] : '0' !!};
    
    table = $('.dataTables-example').DataTable({
        pageLength: 100,
        responsive: true,
        ordering: 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="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_country'>tip",

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

    $("#date_to").datepicker();
    
    jQuery.extend( jQuery.fn.dataTableExt.oSort, {
        "date-uk-pre": function ( a ) {
            if(a){
                var ukDatea = a.split('.');
                return (ukDatea[2] + ukDatea[1] + ukDatea[0]) * 1;
            }
            else{
                return ' ';
            }
        },

        "date-uk-asc": function ( a, b ) {
            return ((a < b) ? -1 : ((a > b) ? 1 : 0));
        },

        "date-uk-desc": function ( a, b ) {
            return ((a < b) ? 1 : ((a > b) ? -1 : 0));
        }
    });
    
    $('#contragent').on('change', function(){

        <!--Get objects associated with a client on change-->
        var client = $('#contragent option:selected').val();
        $.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=""> --- Обект --- </option>';
                        $('#object').find('option').remove().end();
                        if(response.length>0){
                            for (var i in response){
                                options += '<option value="' + response[i].id + '" ' + (response[i].id==object ? "selected" : "") + '>' +  response[i].name  + '</option>';
                            }
                        }
                        $('#object').html(options);
                        $('#object').trigger("chosen:updated");
                    }
        });
    }).change(); 
                                
</script>
@endsection