@extends('template')

@section('content')
     <div class="page-content">
        <div class="container-fluid">
            <div class="page-content-inner">
                <div class="row">
                    <div class="col-md-12">

                        <div class="portlet light">
                            <div class="portlet-body">
                                 <div class="row">
                                    <div class="col-md-12">
                                        <span class="font-blue-madison title"><i class="fa fa-refresh"></i> Relatório de Gestão de Recargas</span></span>
                                        <hr>
                                    </div>
                                </div>
                                <div class="portlet box blue-madison">
                                    <div class="portlet-title">
                                        <div class="caption">
                                            <i class="icon-eye"></i>Filtros
                                        </div>
                                    </div>
                                    <div class="portlet-body">
                                        <div class="panel-group">
                                            {!! Form::open(['route' => $action->route, 'method' => $action->method]) !!}
                                                <div class="row">
                                                    <div class="col-md-4">
                                                        <div class="form-group form-md-line-input has-personalizado form-md-floating-label">
                                                            <div class="input-group left-addon">
                                                                <span class="input-group-addon has-personalizado">
                                                                    <i class="fa fa-user"></i>
                                                                </span>
                                                                {!! Form::select('user_id',$customers, '', ['id'=>'customer', 'class'=>'form-control select2','data-rule-min'=>'1' , 'data-msg-min'=>"Selecione um cliente!"]) !!}
                                                                {!! Form::label('layout', 'Cliente', ['class' => 'control-label']) !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <div class="form-group form-md-line-input has-personalizado form-md-floating-label">
                                                            {!! Form::select('tipo',[''=>'','plano' => 'Crédito de Mensalidade','recarga' => 'Recarga de Crédito'],'',['id'=>'tipo', 'class'=>'form-control']) !!}
                                                            {!! Form::label('', 'Tipo:') !!}
                                                        </div>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <div class="form-group form-md-line-input has-personalizado form-md-floating-label">
                                                            <div class="input-group left-addon">
                                                                <span class="input-group-addon has-personalizado">
                                                                    <i class="fa fa-calendar"></i>
                                                                </span>
                                                                {!! Form::text('dt_ger_ini', '', ['class' => 'form-control', 'placeholder' => '', 'autocomplete' => 'off', 'id' => 'dt_ger_ini']) !!}
                                                                {!! Form::label('', 'Data Inicial') !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <div class="form-group form-md-line-input has-personalizado form-md-floating-label">
                                                            <div class="input-group left-addon">
                                                                <span class="input-group-addon has-personalizado">
                                                                    <i class="fa fa-calendar"></i>
                                                                </span>
                                                                {!! Form::text('dt_ger_fim', '', ['class' => 'form-control',  'autocomplete' => 'off', 'id' => 'dt_ger_fim']) !!}
                                                                {!! Form::label('', 'Data Final') !!}
                                                            </div>
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="row">
                                                    <div class="col-md-1 right">
                                                        {!! Form::label('', ' ') !!}
                                                        <button type="submit" name="relatorio" value='relatorio' class="btn blue-madison popovers"  data-container="body" data-trigger="hover" data-placement="top" data-content="Gerar Novo relatório com base nos filtros ao lado">
                                                            <i class="glyphicon glyphicon-search"></i> Filtrar
                                                        </button>
                                                    </div> 
                                                    <div class="col-md-1 right">
                                                        {!! Form::label('', ' ') !!}
                                                        <button type="submit" name="excel" value='excel' class="btn blue-madison popovers"  data-container="body" data-trigger="hover" data-placement="top" data-content="Gerar Novo relatório e exportar em Excel com base nos filtros ao lado">
                                                            <i class="fa fa-file-excel-o"></i> Excel
                                                        </button>
                                                    </div>
                                                    
                                                </div>
                                                {!! Form::hidden('periodo', 'r.created_at') !!}
                                            {!! Form::close() !!}
                                        </div>
                                    </div>
                                </div>
                                 <table class="table table-striped table-hover table-light">
                                    <thead>
                                        <tr class="uppercase bg-blue-madison">
                                            <th class="col-md-4 font-white orderby" onclick="orderby('cliente','{{$order->act}}','{{$order->url}}');"><span class="{{$order->seta}}" /> Cliente</th>
                                            <th class="col-md-2 font-white orderby" onclick="orderby('vlr_recarga','{{$order->act}}','{{$order->url}}');"><span class="{{$order->seta}}" /> Vlr.Recarga</th>
                                            <th class="col-md-2 font-white orderby" onclick="orderby('created_at','{{$order->act}}','{{$order->url}}');"><span class="{{$order->seta}}" /> Dt.Recarga</th>
                                            <th class="col-md-2 font-white orderby" onclick="orderby('expira_em','{{$order->act}}','{{$order->url}}');"><span class="{{$order->seta}}" /> Validade</th>
                                            <th class="col-md-3 font-white orderby" onclick="orderby('tipo','{{$order->act}}','{{$order->url}}');"><span class="{{$order->seta}}" /> Tipo</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @if(!empty($recargas))
                                            @foreach($recargas as $recarga)
                                                <tr>
                                                    <td>{!! $recarga->cliente !!}</td>
                                                    <td>{!! financialPrice($recarga->vlr_recarga) !!}</td>
                                                    <td>{!! $recarga->recarga_dia !!}  </td>
                                                    <td>
                                                        @if($recarga->tipo == 'plano')
                                                            {!! $recarga->recarga_expira !!}
                                                        @else
                                                            Não Expira
                                                        @endif
                                                    </td>
                                                    <td>{!! $recarga->alias_tipo !!}</td>
                                                </tr>
                                            @endforeach
                                            @else
                                                <tr>
                                                    <td colspan="7"><center><h4>Nenhum registro encontrado.</h4></center></td>
                                                </tr> 
                                        @endif                                      
                                    </tbody>
                                    <tfoot>
                                        <tr>
                                            <td colspan="8" align="center">
                                                {!! $paginacao !!}
                                            </td>
                                        </tr>
                                    </tfoot>
                                </table>                        
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@stop()

@section('js-admin-report-credits')
   <script src="{{ asset('/assets/global/scripts/app.min.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/plugins/select2/js/select2.full.min.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/pages/scripts/components-select2.min.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/plugins/fancybox/source/jquery.fancybox.js?v=2.1.5') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/plugins/bootstrap-summernote/summernote.min.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/plugins/jquery-ui/jquery-ui.1.10.3.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/plugins/jquery-ui/jquery-ui.1.10.3.js') }}" type="text/javascript"></script>
    <script src="{{ asset('/assets/global/scripts/app.min.js') }}" type="text/javascript"></script>    
    <script src="{{ asset('/assets/global/plugins/fancybox/source/jquery.fancybox.js?v=2.1.5') }}" type="text/javascript"></script>
    <link rel="stylesheet" type="text/css" href="{{ asset('/assets/global/plugins/fancybox/source/jquery.fancybox.css?v=2.1.5') }}" media="screen" />

    <script type="text/javascript">
        $(document).ready(function() {
            $('.fancybox').fancybox();
            $.datepicker.regional['pt-BR'] = {
                closeText: 'Fechar',
                prevText: '&#x3c;Anterior',
                nextText: 'Pr&oacute;ximo&#x3e;',
                currentText: 'Hoje',
                monthNames: ['Janeiro','Fevereiro','Mar&ccedil;o','Abril','Maio','Junho',
                'Julho','Agosto','Setembro','Outubro','Novembro','Dezembro'],
                monthNamesShort: ['Jan','Fev','Mar','Abr','Mai','Jun',
                'Jul','Ago','Set','Out','Nov','Dez'],
                dayNames: ['Domingo','Segunda-feira','Ter&ccedil;a-feira','Quarta-feira','Quinta-feira','Sexta-feira','Sabado'],
                dayNamesShort: ['Dom','Seg','Ter','Qua','Qui','Sex','Sab'],
                dayNamesMin: ['Dom','Seg','Ter','Qua','Qui','Sex','Sab'],
                weekHeader: 'Sm',
                dateFormat: 'dd/mm/yy',
                firstDay: 0,
                isRTL: false,
                showMonthAfterYear: false,
                yearSuffix: ''
            };

            $.datepicker.setDefaults($.datepicker.regional['pt-BR']);

            $("#dt_ger_ini").datepicker();
            $("#dt_ger_fim").datepicker();
        });
    </script>
@stop()