| Server IP : 20.75.53.88 / Your IP : 216.73.217.138 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/juridico/quixada/modulos/financeiro/ |
Upload File : |
<?php
ini_set('display_errors', 'off');
session_start("3b71c625dfc95ca336cac7f27b3c2b0b");
$direito = $_SESSION['admin'];
if ($direito <> 1){
$a = new aviso();
$a->avisoErro('index.php', 'Você não tem permissão para acessar este módulo', 'Acesso negado');
exit;
}
//$conn = conexao::getInstance();
if (isset($_POST['mes']) && $_POST['mes']<>'' && isset($_POST['ano']) && $_POST['ano']<>'') {
$mes = $_POST['mes'];
$ano = $_POST['ano'];
$conta = $conn->query("SELECT * FROM v_lista_contas_pagar where situacao=0 and MONTH(vencimento)='$mes' AND YEAR(vencimento)='$ano'");
$contp = $conn->query("SELECT * FROM v_lista_contas_pagar where situacao=1 and MONTH(vencimento)='$mes' AND YEAR(vencimento)='$ano'");
} else {
$conta = $conn->query("SELECT * FROM v_lista_contas_pagar where situacao=0 and MONTH(vencimento)=MONTH(now()) AND YEAR(vencimento)=YEAR(now())");
$contp = $conn->query("SELECT * FROM v_lista_contas_pagar where situacao=1 and MONTH(vencimento)=MONTH(now()) AND YEAR(vencimento)=YEAR(now())");
}
?>
<head>
</head>
<div id='id_grid' class='container'>
<p style='font-size: 20px;'>Contas a pagar | Listagem
<!--verifica se usuário tem permissão de administrador-->
<?php
if ($direito=="1") {
echo("
<button type='submit' name='bt_cad_prod' class='btn btn-primary btn-xs'
onclick=location.href='?page=financeiro/contap_cad'><span class='fa fa-plus-square'></span> Novo
</button>
");
}
?>
</p>
<div class='container'>
<form method="post" name="f_periodo" id="f_periodo" action="">
<div class="panel panel-heading panel-body">
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<select id="mes" name="mes" autofocus class="form-control">
<option value="01">Janeiro</option>
<option value="02">Fevereiro</option>
<option value="03">Março</option>
<option value="04">Abril</option>
<option value="05">Maio</option>
<option value="06">Junho</option>
<option value="07">Julho</option>
<option value="08">Agosto</option>
<option value="09">Setembro</option>
<option value="10">Outubro</option>
<option value="11">Novembro</option>
<option value="12">Dezembro</option>
</select>
</div>
<div class='col-xs-12 col-sm-2 col-md-2 col-lg-2'>
<select id="ano" name="ano" autofocus class="form-control">
<option value="2016">2016</option>
<option value="2017">2017</option>
</select>
</div>
<div class='col-xs-12 col-sm-1 col-md-1 col-lg-1'>
<button type="submit" name="bt_novo" class="btn btn-primary form-control"><i class="fa fa-search"></i></button>
</div>
</div>
</form>
<div class="">
<div class="panel panel-heading with-nav-tabs panel-primary">
<ul class="nav nav-tabs">
<li class="active"><a href="#tab1primary" data-toggle="tab"><i class='fa fa-usd'></i> Contas a pagar</a></li>
<li><a href="#tab2primary" data-toggle="tab"><i class='fa fa-check-circle'></i> Contas pagas</a></li>
</ul>
<div class="panel-body">
<div class="tab-content">
<div class="tab-pane fade in active" id="tab1primary">
<div class="panel panel-primary active" style="font-size: 17px;" align="center">
<span>Contas a pagar</span>
<!-- <a href="#" target='_blank'><i class='fa fa-file-pdf-o' title='gerar PDF'></i></a>-->
</div>
<div id="action">
<form id='frm_pesq' method='post' class="search-form">
<table class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Fornecedor</th>
<th>Descrição</th>
<th>Número</th>
<th>Vencimento</th>
<th>Valor</th>
<th width="2%"></th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($a = $conta->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $a->codigo . "</td>";
echo "<td>" . $a->fornecedor . "</td>";
echo "<td>" . $a->descricao . "</td>";
echo "<td>" . $a->numero . "</td>";
echo "<td>" . date('d/m/Y', strtotime($a->vencimento)) . "</td>";
echo "<td>" . number_format($a->valor, 2, ',', '.') . "</td>";
$id = $a->codigo;
//if($direito == "1") {
echo "<td><a class='j55' href='index2.php?page=financeiro/contap_edt&id=$id'><i aling='center' class='fa fa-pencil' title='Editar registro'></i></a></td>";
echo "<td><a class='j55' href='index2.php?page=financeiro/contap_pag&id=$id'><i aling='center' class='fa fa-usd' title='pagar conta'></i></a></td>";
//}
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
</div>
<div class="tab-pane fade" id="tab2primary">
<div class="panel panel-primary active" style="font-size: 17px;" align="center">
<span>Contas pagas</span>
<!-- <a href="#" target='_blank'><i class='fa fa-file-pdf-o' title='gerar PDF'></i></a>-->
</div>
<div id="action">
<form id='frm_pesq' method='post' class="search-form">
<table id="tabela1" class='table dtabelas table-striped table-hover dt-responsive' cellspacing='0' width='100%' border='0'>
<thead>
<tr class="success">
<th width="2%">ID</th>
<th>Fornecedor</th>
<th>Descrição</th>
<th>Número</th>
<th>Pagamento</th>
<th>Valor pago</th>
<th width="2%"></th>
</tr>
</thead>
<tbody>
<?php
while ($d = $contp->fetch(PDO::FETCH_OBJ)) {
echo "<tr>";
echo "<td>" . $d->codigo . "</td>";
echo "<td>" . $d->fornecedor . "</td>";
echo "<td>" . $d->descricao . "</td>";
echo "<td>" . $d->numero . "</td>";
echo "<td>" . date('d/m/Y', strtotime($d->data_pag)) . "</td>";
echo "<td>" . number_format($d->valor_pago, 2, ',', '.') . "</td>";
$id = $d->codigo;
//if($direito == "1") {
echo "<td><a class='j55' href='index2.php?page=financeiro/contap_edt&id=$id&var=ver'><i aling='center' class='fa fa-eye' title='visualizar registro'></i></a></td>";
//}
echo "</tr>";
}
?>
</tbody>
</table>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>