@extends('layouts.dashboard')

@section('title', 'Relatório de Recorrências')

@section('title-dashboard')
<label onclick="$('#div_recorrencia').css('display','block');$('#div_recorrencia_cancelar').css('display','none');">Relatório de Recorrência</label>
@endsection

@section('pg-home')
@endsection

@section('content')
@parent

<div id="div_recorrencia" style="@if(!$exibir_cancelados) {{'display: block;'}} @else {{'display: none;'}} @endif">
    <div class="clearboth">
        <div class="row">
            <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12">
                <div class="dashboard-stat2 ">
                    <div class="display">
                        <div class="number">
                            <h3 class="font-green-meadow">
                                <small class="font-green-meadow"></small>
                                <span data-counter="counterup" data-value="{{$ativos[0]->qtd}}">0</span>
                            </h3>
                            <small>ATIVOS</small>
                        </div>
                        <div class="icon">
                            <i class="fa fa-list"></i>
                        </div>
                    </div>
                    <div class="progress-info">
                        <div class="progress">
                            <span style="width: 100%;" class="progress-bar progress-bar-success green-meadow">
                                <span class="sr-only">Plano Ativos</span>
                            </span>
                        </div>
                        <div class="status">
                            <div class="status-number"></div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12" onclick="$('#div_recorrencia').css('display','none');$('#div_recorrencia_cancelar').css('display','block');">
                <div class="dashboard-stat2 ">
                    <div class="display">
                        <div class="number">
                            <h3 class="font-red-mint">
                                <small class="font-red-mint"></small>
                                <span data-counter="counterup" data-value="{{$cancelados[0]->qtd}}">0</span>
                            </h3>
                            <small>CANCELADOS</small>
                        </div>
                        <div class="icon">
                            <i class="fa fa-list"></i>
                        </div>
                    </div>
                    <div class="progress-info">
                        <div class="progress">
                            <span style="width: 100%;" class="progress-bar progress-bar-success red-mint">
                                <span class="sr-only">Planos Cancelados</span>
                            </span>
                        </div>
                        <div class="status">
                            <div class="status-number"></div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-lg-4 col-md-4 col-sm-6 col-xs-12">
                <div class="dashboard-stat2 ">
                    <div class="display">
                        <div class="number">
                            <h3 class="font-blue">
                                <small class="font-blue"></small>
                                <span data-counter="counterup" data-value="{{$aguardando[0]->qtd}}">0</span>
                            </h3>
                            <small>AGUARDANDO</small>
                        </div>
                        <div class="icon">
                            <i class="fa fa-list"></i>
                        </div>
                    </div>
                    <div class="progress-info">
                        <div class="progress">
                            <span style="width: 100%;" class="progress-bar progress-bar-success blue">
                                <span class="sr-only">Plano Aguardando</span>
                            </span>
                        </div>
                        <div class="status">
                            <div class="status-number"></div>
                        </div>
                    </div>
                </div>
            </div>         
        </div>
    </div>

    <!-- Lista -->

    <div class="row">
        <div class="col-md-12">        
            <!-- BEGIN SAMPLE TABLE PORTLET-->
            <div class="portlet box blue-steel">
                <div class="portlet-title">
                    <div class="caption">
                        <i class="fa fa-file-pdf-o"></i> Relatório de Recorrências
                    </div>
                </div>
                <div class="portlet-body form">
                    {!! Form::open(['route' => 'relatorio-recorrenciasPdf', 'class' => 'horizontal-form', 'target'=>'_blank','files' => true]) !!}
                    <div class="form-body">
                        <div>
                            <div class="floatleft col-md-6">
                                <h3 class="form-section">Dados do Relatório</h3>
                            </div>                        
                        </div>
                        <div class="col-md-2 clearboth input-group margin-left15px date date-picker floatleft" data-date-format="dd/mm/yyyy">
                            <input type="text" class="form-control" name="data_de" id="data_de" required="true" style="text-align: center!important;" readonly name="order_date_from" value="" placeholder="De:">
                            <span class="input-group-btn">
                                <button class="btn btn default" type="button">
                                    <i class="fa fa-calendar"></i>
                                </button>
                            </span>
                        </div>
                        <div class="col-md-2 input-group date date-picker floatleft margin-left15px" data-date-format="dd/mm/yyyy">
                            <input type="text" class="form-control" name="data_ate" id="data_ate" required="true" style="text-align: center!important;" readonly name="order_date_from" value="" placeholder="Até:">
                            <span class="input-group-btn">
                                <button class="btn btn default" type="button">
                                    <i class="fa fa-calendar"></i>
                                </button>
                            </span>
                        </div>
                        <div class="col-md-5 margin-top5px clearboth">
                            {!! Form::label('clientes_recorrencia_id', 'CLIENTES RECORRÊNCIAS', ['class' => 'control-label']) !!}                        
                            <div class="form-group {{ $errors->has('clientes_recorrencia_id') ? 'has-error' : ''}}">
                                <select class="form-control select2" name="clientes_recorrencia_id" id="clientes_recorrencia_id">
                                    <option value="">TODOS OS CLIENTES DE RECORRÊNCIAS</option>
                                    @foreach($clientes as $list)
                                    <option value="{{$list->recorrencia_id}}">{{$list->rsocial_nome}}</option>
                                    @endforeach
                                </select>
                                {!! $errors->first('clientes_recorrencia_id', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                        <div class="col-md-3 margin-top5px">
                            {!! Form::label('funcionario_id', trans('relatorios.funcionario_id'), ['class' => 'control-label']) !!}
                            <div class="form-group {{ $errors->has('funcionario_id') ? 'has-error' : ''}}">
                                {!! Form::select('funcionario_id', $funcionarios, null, ['class' => 'form-control select2','id' => 'funcionario_id', 'placeholder' => 'TODOS OS FUNCIONÁRIOS']) !!}
                                {!! $errors->first('funcionario_id', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                        <div class="col-md-2 margin-top5px">
                            {!! Form::label('situacao', trans('relatorios.situacao'), ['class' => 'control-label']) !!}
                            <div class="form-group {{ $errors->has('situacao') ? 'has-error' : ''}}">
                                {!! Form::select('situacao', array('todos'=>'Todos','ativos'=>'Ativos','cancelados'=>'Cancelados','aguardando'=>'Aguardando'), null, ['class' => 'form-control select2','id' => 'situacao']) !!}
                                {!! $errors->first('situacao', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                        <div class="col-md-2 margin-top5px">
                            {!! Form::label('tipo', 'Tipo', ['class' => 'control-label']) !!}
                            <div class="form-group {{ $errors->has('plano_id') ? 'has-error' : ''}}">
                                {!! Form::select('tipo', array('todos'=>'Todos','Normal'=>'Normal','Voucher'=>'Voucher'), null, ['class' => 'form-control select2','id' => 'tipo']) !!}
                                {!! $errors->first('tipo', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                        <div class="col-md-2 margin-top5px">
                            {!! Form::label('tipo_plano', 'Tipo de Plano', ['class' => 'control-label']) !!}
                            <div class="form-group {{ $errors->has('plano_id') ? 'has-error' : ''}}">
                                {!! Form::select('tipo_plano', array('todos'=>'Todos','Light'=>'Light','Plus'=>'Plus','Promocional'=>'Promocional'), null, ['class' => 'form-control select2','id' => 'tipo_plano']) !!}
                                {!! $errors->first('tipo_plano', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                    </div>
                    <div class="form-actions clearboth right">                                                            
                        <button type="submit" class="btn blue-steel"><i class="fa fa-search"></i>{{trans('padrao.visualizar')}}</button>
                    </div>
                    {!! Form::close() !!}
                </div>
            </div>
        </div>
    </div>
</div>

{!! Form::open(['url' => 'pdfdivconteudo','id'=>'form_pdfdivconteudo','target'=>'_blank',  'class' => 'horizontal-form', 'files' => true]) !!}
    <div class="col-md-12">
        <div class="form-group {{ $errors->has('conteudo') ? 'has-error' : ''}}">
            {!! Form::hidden('titulo', 'CANCELAMENTOS', ['class' => 'form-control','id'=>'titulo','placeholder'=>'Titualo']) !!}
            {!! Form::hidden('conteudo', null, ['class' => 'form-control','id'=>'conteudo','placeholder'=>'Conteudo']) !!}
            {!! $errors->first('conteudo', '<p class="help-block">:message</p>') !!}
        </div>
    </div>
{!! Form::close() !!}
<div class="row" id="div_recorrencia_cancelar" style="@if(!$exibir_cancelados) {{'display: none;'}} @else {{'display:block;'}} @endif">
    <div class="col-md-12">        
        <!-- BEGIN SAMPLE TABLE PORTLET-->
        <div class="portlet box blue-steel" id="">
            <div class="portlet-title">
                <div class="caption">
                    <i class="fa fa-file-pdf-o"></i> Recorrências Canceladas
                </div>
            </div>
            <div class="portlet-body form">
                <div class="form-actions clearboth">
                    <div class="col-md-12">
                    {!! Form::open(['route' => 'relatorio-recorrencias-listarPdf', 'class' => 'horizontal-form','onsubmit'=>'getModalAguarde();', 'files' => true]) !!}
                        <div class="col-md-2 clearboth input-group margin-left15px date date-picker floatleft" data-date-format="dd/mm/yyyy">
                            <input type="text" class="form-control" name="data_de" id="data_de" required style="text-align: center!important;" readonly name="order_date_from" value="{{$data_de}}" placeholder="De:">
                            <span class="input-group-btn">
                                <button class="btn btn default" type="button">
                                    <i class="fa fa-calendar"></i>
                                </button>
                            </span>
                        </div>
                        <div class="col-md-2 input-group date date-picker floatleft margin-left15px" data-date-format="dd/mm/yyyy">
                            <input type="text" class="form-control" name="data_ate" id="data_ate" required style="text-align: center!important;" readonly name="order_date_from" value="{{$data_ate}}" placeholder="Até:">
                            <span class="input-group-btn">
                                <button class="btn btn default" type="button">
                                    <i class="fa fa-calendar"></i>
                                </button>
                            </span>
                        </div>
                        <div class="col-md-3">
                            <div class="form-group {{ $errors->has('empresa_id') ? 'has-error' : ''}}">
                                <select class="form-control select2" name="empresa_id" id="empresa_id">
                                    <option modulo="" value="%%">TODAS AS ACADEMIAS</option>
                                    @foreach($empresas as $list)
                                    <option  value="{{$list->id}}" @if($empresa_id == $list->id){{'selected'}} @endif>{{$list->nome_fantasia}}</option>
                                    @endforeach
                                </select>
                                {!! $errors->first('empresa_id', '<p class="help-block">:message</p>') !!}
                            </div>
                        </div>
                        
                        <button type="submit" class="btn blue-steel" style="margin-left: 20px;"><i class="fa fa-search"></i> Buscar</button>
                    {!! Form::close() !!}
                    </div>
                </div>
                <div class="portlet-body">
                    <div class="col-md-12" id="divConteudo">
                        <div class="col-md-6">
                            <table class="table table-bordered table-striped table-condensed flip-content" style="margin-top: 10px;">
                                <thead class="flip-content">
                                    <tr>
                                        <th class="col-sm-8" style="text-align: left;">DESCRIÇÃO</th>
                                        <th class="col-sm-4 text-aligncenter">QTD</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    <br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Undefined variable: itens_cancelados in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>253</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: Invalid argument supplied for foreach() in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>253</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
                                    <tr><td><strong style="font-style: italic;"> TOTAL</strong></td><td style="text-align: right;"><strong>{{array_sum($qtd)}}</strong></td></tr>

                                </tbody>
                            </table>
                            
                            <strong>Total de Pagamentos: {{$itens_pagos[0]->qtd}}</strong>
                            <br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Undefined variable: itens_pagos in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>270</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Trying to get property of non-object in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>270</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: Creating default object from empty value in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>271</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
                            <h3><strong>Taxa de Cancelamento: {{number_format($total,2) }}%</strong></h3>
                        </div>
                        <div class="col-md-6">
                            <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
                            <script type="text/javascript">

                              // Load the Visualization API and the corechart package.
                              google.charts.load('current', {'packages':['corechart']});

                              // Set a callback to run when the Google Visualization API is loaded.
                              google.charts.setOnLoadCallback(drawChart);

                              // Callback that creates and populates a data table,
                              // instantiates the pie chart, passes in the data and
                              // draws it.
                              function drawChart() {

                                // Create the data table.
                                var data = new google.visualization.DataTable();
                                data.addColumn('string', 'Descrição');
                                data.addColumn('number', 'Qtd');
                                data.addRows([
                                  <br />
<font size='1'><table class='xdebug-error xe-notice' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Notice: Undefined variable: itens_cancelados in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>302</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
<br />
<font size='1'><table class='xdebug-error xe-warning' dir='ltr' border='1' cellspacing='0' cellpadding='1'>
<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> Warning: Invalid argument supplied for foreach() in /home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php on line <i>302</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Memory</th><th align='left' bgcolor='#eeeeec'>Function</th><th align='left' bgcolor='#eeeeec'>Location</th></tr>
<tr><td bgcolor='#eeeeec' align='center'>1</td><td bgcolor='#eeeeec' align='center'>0.0022</td><td bgcolor='#eeeeec' align='right'>239592</td><td bgcolor='#eeeeec'>{main}(  )</td><td title='/home/radicalf/public_html/grupofrota/resources/views/relatorios/relatorio_recorrencias.blade.php' bgcolor='#eeeeec'>.../relatorio_recorrencias.blade.php<b>:</b>0</td></tr>
</table></font>
                                ]);

                                // Set chart options
                                var options = {'title':'Cancelamentos',
                                               'width':500,
                                               'height':400};

                                // Instantiate and draw our chart, passing in some options.
                                var chart = new google.visualization.PieChart(document.getElementById('chart_div'));
                                chart.draw(data, options);
                              }
                            </script>
                            <div id="chart_div"></div>
                        </div>
                    </div>
                </div>
                <div class="form-actions clearboth right">                                                            
                    <button type="button" onclick="pdfDivFormBody();" target="_blank" class="btn blue-steel"><i class="fa fa-file-pdf-o"></i> Imprimir</button>
                </div>
                
            </div>
        </div>
    </div>
</div>
<script>
    function pdfDivFormBody(){
        var conteudo = $("#divConteudo").html();
        $("#conteudo").val(conteudo);
        
        $("#form_pdfdivconteudo").submit();
    }
</script>
@endsection