| Server IP : 54.94.228.101 / Your IP : 172.28.20.13 Web Server : Apache System : Linux ip-172-28-29-189 6.5.0-1014-aws #14~22.04.1-Ubuntu SMP Thu Feb 15 15:27:06 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 7.2.34-43+ubuntu22.04.1+deb.sury.org+1 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/vinumday2_0/app/Modules/PlanoFinanceiro/Views/admin/ |
Upload File : |
@extends($current_template)
@section('content')
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Planos Financeiros
<small>Balancete</small>
</h1>
<ol class="breadcrumb">
<li><a href="{{ url('admin') }}"><i class="fa fa-dashboard"></i> Dashboard</a></li>
<li><a href="{{ url('admin/plano-financeiro') }}"> Planos Financeiros</a></li>
<li class="active">Balancete</li>
</ol>
</section>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header no-print">
<form id="form-fluxo-caixa" method="POST" action="<?php echo url('admin/plano-financeiro/balancete'); ?>">
<div class="row">
<div class="col-md-3">
<div class="row">
<div class="col-md-12">
<h5>Empresa:</h5>
<select id="empresa_id" class="form-control select2" name="empresa_id">
<option value="">Todas</option>
<?php foreach ($empresas as $empresa): ?>
<option <?php echo (isset($empresa_id) && $empresa_id == $empresa->id) ? 'selected' : ''; ?> value="<?php echo $empresa->id; ?>"><?php echo $empresa->nome; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
</div>
<div class="col-md-3">
<div class="row">
<div class="col-md-12">
<h5>Plano Financeiro:</h5>
<select id="id_plano_financeiro" required class="form-control select2" name="id_plano_financeiro">
<option value="">Selecione o plano</option>
<?php foreach ($planos as $plano): ?>
<option <?php echo (isset($id_plano_financeiro) && $id_plano_financeiro == $plano->id) ? 'selected' : ''; ?> value="<?php echo $plano->id; ?>"><?php echo $plano->nome; ?></option>
<?php endforeach; ?>
</select>
</div>
</div>
</div>
<div class="col-md-3">
<div class="row">
<div class="col-md-12">
<h5>Tipo Conta Lcto.:</h5>
<select id="tipo_id" class="form-control" name="tipo_id">
<option value="">Todos</option>
@foreach($tipos as $item)
<option value="{{ $item->id }}" <?php echo (isset($tipo_id) && $tipo_id == $item->id ? 'selected="selected"' : ''); ?>>{{ $item->nome }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="col-md-1">
<div class="row">
<div class="col-md-12">
<button type="button" id="btn-gerar-fluxo" class="btn btn-block btn-primary" style="margin-top:35px;">Gerar</button>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-3">
<div class="row">
<div class="col-md-12">
<h5>Visualização:</h5>
<select id="periodicidade" class="form-control" name="periodicidade">
<option value="M" <?php echo (isset($periodicidade) && $periodicidade == 'M' ? 'selected="selected"' : ''); ?>>Mensal</option>
<option value="Y" <?php echo (isset($periodicidade) && $periodicidade == 'Y' ? 'selected="selected"' : ''); ?>>Anual</option>
</select>
</div>
</div>
</div>
<div class="col-md-6">
<div class="row">
<div class="col-md-3">
<h5>Período Inicial:</h5>
<select id="mes_inicial" class="form-control" name="mes_inicial" <?php echo ($periodicidade == 'Y' ? 'disabled="disabled" required' : '');?>>
@foreach($months as $m => $month)
<?php $selected = (isset($mes_inicial) && $mes_inicial == $m ? 'selected="selected"' : ''); ?>
<option value="{{ $m }}" <?php echo $selected; ?>>
{{ $month }}
</option>
@endforeach
</select>
</div>
<div class="col-md-3">
<h5> </h5>
<select id="ano_inicial" required class="form-control" name="ano_inicial">
@for($year=2019;$year<=date('Y');$year++):
<?php $selected = (isset($ano_inicial) && $ano_inicial == $year ? 'selected="selected"' : ''); ?>
<option value="{{ $year }}" {{ $selected }}>{{ $year }}</option>
@endfor
</select>
</div>
<div class="col-md-3">
<h5>Período Final:</h5>
<select id="mes_final" class="form-control" name="mes_final" <?php echo ($periodicidade == 'Y' ? 'disabled="disabled" required' : '');?>>
@foreach($months as $m => $month)
<?php $selected = (isset($mes_final) && $mes_final == $m ? 'selected="selected"' : ''); ?>
<option value="{{ $m }}" <?php echo $selected; ?>>
{{ $month }}
</option>
@endforeach
</select>
</div>
<div class="col-md-3">
<h5> </h5>
<select id="ano_final" required class="form-control" name="ano_final">
@for($year=2019;$year<=date('Y');$year++):
<?php $selected = (isset($ano_final) && $ano_final == $year ? 'selected="selected"' : ''); ?>
<option value="{{ $year }}" {{ $selected }}>{{ $year }}</option>
@endfor
</select>
</div>
</div>
</div>
</div>
</form>
</div>
<!-- /.box-header -->
<div class="box-body">
<?php if(isset($receitas)): ?>
<h5>DRE - <?php echo ($periodicidade == 'M' ? 'Mensal' : 'Anual'); ?></h5>
<p>
Empresas: <?php echo $empresaNome; ?> |
Última atualização: <?php echo (!empty($plano_financeiro->ultima_atualizacao) ? date('d/m/Y H:i', strtotime($plano_financeiro->ultima_atualizacao)) : '')?> |
Período:
<?php if($periodicidade == 'M'): ?>
{{ $meses[( (int) $mes_start)] }}/{{ $ano }} a {{ $meses[( (int) $mes_end)] }}/{{ $ano }}
<?php else: ?>
{{ $ano_inicial }} a {{ $ano_final }}
<?php endif; ?>
</p>
<div class="row" id="row-table-fluxo">
<div style="overflow: auto;">
<table class="table table-bordered" style="width: auto;" id="table-fluxo-caixa">
<tbody>
<tr>
<td></td>
<?php
foreach ($aliases as $alias):
if($periodicidade == 'Y'){
$header = $alias->ano;
}else{
$mes = (int) $alias->mes;
$header = $meses[$mes] . '/' . substr($alias->ano, 2, 2);
}
?>
<td class="text-center"><strong><?php echo $header; ?></strong></td>
<?php endforeach; ?>
</tr>
<tr>
<td colspan="<?php echo (2 + count($aliases)); ?>">
<i class="ver-detalhes-conta fa fa-plus-circle" data-tipo='R'></i>
<strong>Receitas</strong>
</td>
</tr>
<tr>
<td><strong>Total Receitas</strong></td>
<?php
foreach ($aliases as $alias):
$alias = $alias->alias;
?>
<td class="text-right">
<?php $valor = (isset($totais['receitas'][$alias]) ? $totais['receitas'][$alias] : 0); ?>
<strong><?php echo number_format($valor, 2, ',', '.'); ?></strong>
</td>
<?php endforeach; ?>
</tr>
<tr>
<td colspan="<?php echo (2 + count($aliases)); ?>"> </td>
</tr>
<tr>
<td colspan="<?php echo (2 + count($aliases)); ?>">
<i class="ver-detalhes-conta fa fa-plus-circle" data-tipo='D'></i>
<strong>Despesas</strong>
</td>
</tr>
<tr>
<td><strong>Total Despesas</strong></td>
<?php
foreach ($aliases as $alias):
$alias = $alias->alias;
?>
<td class="text-right">
<?php $valor = (isset($totais['despesas'][$alias]) ? $totais['despesas'][$alias] : 0); ?>
<strong><?php echo number_format($valor, 2, ',', '.'); ?></strong>
</td>
<?php endforeach; ?>
</tr>
<tr>
<td colspan="<?php echo (2 + count($aliases)); ?>"> </td>
</tr>
<tr>
<td><strong>Resultado</strong></td>
<?php
foreach ($aliases as $alias):
$alias = $alias->alias;
$valor = (isset($resultados[$alias]) ? $resultados[$alias]['resultado'] : 0);
?>
<td class="text-right {{ ($valor < 0 ? 'color-red' : '') }}">
<strong><?php echo number_format($valor, 2, ',', '.'); ?></strong>
</td>
<?php endforeach; ?>
</tr>
<tr>
<td></td>
<?php
foreach ($aliases as $alias):
if($periodicidade == 'Y'){
$header = $alias->ano;
}else{
$mes = (int) $alias->mes;
$header = $meses[$mes] . '/' . substr($alias->ano, 2, 2);
}
?>
<td class="text-center"><strong><?php echo $header; ?></strong></td>
<?php endforeach; ?>
</tr>
</tbody>
</table>
</div>
</div>
<?php endif; ?>
</div>
<!-- /.box-body -->
<div class="box-footer">
</div>
</div>
<!-- /.box -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<div id="modal-evento" class="modal fade">
<form method="/" id="formEvento" type="POST">
<div class="modal-dialog" style="width: 75%">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 id="time-label"></h4>
</div>
<div class="modal-body" id="conteudo-modal-evento"></div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">Fechar</button>
</div>
</div>
</div>
</form>
</div>
<script type="text/javascript">
$(document).ready(function(){
$('.select2').select2();
$(document).on('click', '.ver-detalhes-conta', function(){
var icon = $(this);
var tr = icon.closest('tr');
var tipo = icon.data('tipo');
$.ajax({
url:'/admin/plano-financeiro/filtrar-lancamentos-dre',
type:'POST',
data:{
receita_despesa : tipo,
periodicidade : $('#periodicidade').val(),
ano_inicial : $('#ano_inicial').val(),
ano_final : $('#ano_final').val(),
mes_inicial : $('#mes_inicial').val(),
mes_final : $('#mes_final').val(),
empresa_id : $('#empresa_id').val(),
tipo_id : $('#tipo_id').val(),
id_plano_financeiro : $('#id_plano_financeiro').val(),
},
success:function(data){
if(data.status){
tr.after(data.html);
icon.removeClass('fa-plus-circle');
icon.removeClass('ver-detalhes-conta');
icon.addClass('esconder-detalhes-conta');
icon.addClass('fa-minus-circle');
}else{
alertUtil.alertError(data.message);
}
}
});
});
$(document).on('click', '.esconder-detalhes-conta', function(){
var next = $(this).closest('tr').next();
while(next.hasClass('detalhes-conta')){
var aux = next.next();
next.remove();
next = aux;
}
$(this).removeClass('esconder-detalhes-conta');
$(this).addClass('ver-detalhes-conta');
$(this).addClass('fa-plus-circle');
$(this).removeClass('fa-minus-circle');
});
$('#btn-gerar-fluxo').click(function(){
var plano_financeiro = $('#id_plano_financeiro').val();
if(plano_financeiro == ''){
alertUtil.alertWarning('Plano Financeiro não informado!');
}else{
$('#form-fluxo-caixa').submit();
}
});
$('#periodicidade').change(function(){
var visualizacao = $(this).val();
console.log(visualizacao);
if(visualizacao == 'M'){
$('#mes_inicial, #mes_final').prop('disabled', false);
}else{
$('#mes_inicial, #mes_final').prop('disabled', true);
}
});
<?php if(isset($id_plano_financeiro)): ?>
var content = $('.content-header').width();
var table_fluxo = $('#table-fluxo-caixa').width();
console.log(content);
console.log(table_fluxo);
if(table_fluxo > content){
$('#row-table-fluxo').css('width', content - parseInt(100) + 'px');
}
<?php endif; ?>
});
</script>
@endsection