Viewing File: /home/cienp/public_html/portal/includes/principal.php
<div class="container body">
<!--teste commix soluções digitais-->
<div class="main_container">
<div class="right_col" role="main">
<!-- top tiles -->
<div class="row tile_count ests_mobl">
<?php
if ($linhau[fl_extr] == 'N') {
$nu_agrd = $nu_aprv = $nu_revs = $nu_apro = 0;
$sqlst = "SELECT c.id_sitc, COUNT(c.id_comp) as nu_cont ";
$sqlst .= "FROM ".$pref_tabl."comp c ";
$sqlst .= "WHERE c.id_sitc IN (2,3,4,5) ";
$sqlst .= "GROUP BY c.id_sitc ";
#echo $sqlst.'<br>';
$resst = mysqli_query($conn, $sqlst);
if (mysqli_num_rows($resst) > 0) {
while ($linhast = mysqli_fetch_array($resst)) {
switch ($linhast[id_sitc]) {
case '2':
$nu_agrd = $linhast[nu_cont];
break;
case '3':
$nu_aprv = $linhast[nu_cont];
break;
case '4':
$nu_revs = $linhast[nu_cont];
break;
case '5':
$nu_apro = $linhast[nu_cont];
break;
}
}
}
$nu_anos = date('Y');
$nu_mess = date('Y-m');
$nu_conc = $nu_canc = 0;
$sqlss = "SELECT c.id_sitc, COUNT(c.id_comp) as nu_cont ";
$sqlss .= "FROM ".$pref_tabl."comp c ";
$sqlss .= "WHERE c.id_sitc = 6 ";
$sqlss .= "AND c.dt_cads LIKE '$nu_anos%' ";
$sqlss .= "GROUP BY c.id_sitc ";
#echo $sqlss.'<br>';
$resss = mysqli_query($conn, $sqlss);
if (mysqli_num_rows($resss) > 0) {
while ($linhass = mysqli_fetch_array($resss)) {
$nu_conc = $linhass[nu_cont];
}
}
$sqlsr = "SELECT c.id_sitc, COUNT(c.id_comp) as nu_cont ";
$sqlsr .= "FROM ".$pref_tabl."comp c ";
$sqlsr .= "WHERE c.id_sitc = 8 ";
$sqlsr .= "GROUP BY c.id_sitc ";
#echo $sqlsr.'<br>';
$ressr = mysqli_query($conn, $sqlsr);
if (mysqli_num_rows($ressr) > 0) {
while ($linhasr = mysqli_fetch_array($ressr)) {
$nu_recb = $linhasr[nu_cont];
}
}
?>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top"><i class="fa fa-clock-o"></i> Aguardando</span>
<div class="count"><?php echo $nu_agrd;?></div>
</div>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top"><i class="fa fa-gavel"></i> Aprovação</span>
<div class="count"><?php echo $nu_aprv;?></div>
</div>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top"><i class="fa fa-refresh"></i> Em Revisão</span>
<div class="count"><?php echo $nu_revs;?></div>
</div>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top"><i class="fa fa-spinner"></i> Aguardando Recebimento</span>
<div class="count"><?php echo $nu_recb;?></div>
</div>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top green"><i class="fa fa-check-square-o"></i> Aprovada</span>
<div class="count green"><?php echo $nu_apro;?></div>
</div>
<div class="col-md-2 col-xs-6 tile_stats_count">
<span class="count_top"><i class="fa fa-check"></i> Concluída</span>
<div class="count"><?php echo $nu_conc;?></div>
</div>
</div>
<!-- /top tiles -->
<?php
if (($nu_agrd > 0)
|| ($nu_aprv > 0)
|| ($nu_revs > 0)
|| ($nu_apro > 0)) {
?>
<div class="row">
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="x_panel tile fixed_height_320">
<div class="x_title">
<h2>N° de Solicitações</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<h4>Mês</h4>
<?php
$nu_maxm = 0;
for ($i = 0; $i<5; $i++) {
$nu_atua = date('Y-m', mktime(0,0,0,date("m")-$i, date("d"), date("Y")));
$sqlsg = "SELECT COUNT(c.id_comp) as nu_cont ";
$sqlsg .= "FROM ".$pref_tabl."comp c ";
$sqlsg .= "WHERE c.dt_cads LIKE '$nu_atua%' ";
#echo $s$sqlsgqlss.'<br>';
$ressg = mysqli_query($conn, $sqlsg);
if (mysqli_num_rows($ressg) > 0) {
while ($linhasg = mysqli_fetch_array($ressg)) {
if ($nu_maxm < $linhasg[nu_cont]) {
$nu_maxm = $linhasg[nu_cont];
}
if ($nu_atua == $nu_mess) {
$nu_nows = $linhasg[nu_cont];
}
}
}
}
for ($i = 0; $i<5; $i++) {
$nu_atua = date('Y-m', mktime(0,0,0,date("m")-$i, date("d"), date("Y")));
$nu_mese = date('m', mktime(0,0,0,date("m")-$i, date("d"), date("Y")));
#echo $nu_atua.'<br>';
$sqlsg = "SELECT COUNT(c.id_comp) as nu_cont ";
$sqlsg .= "FROM ".$pref_tabl."comp c ";
$sqlsg .= "WHERE c.dt_cads LIKE '$nu_atua%' ";
#echo $s$sqlsgqlss.'<br>';
$ressg = mysqli_query($conn, $sqlsg);
if (mysqli_num_rows($ressg) > 0) {
while ($linhasg = mysqli_fetch_array($ressg)) {
switch ($nu_mese) {
case '01':
$de_mess = 'Janeiro';
break;
case '02':
$de_mess = 'Fevereiro';
break;
case '03':
$de_mess = 'Março';
break;
case '04':
$de_mess = 'Abril';
break;
case '05':
$de_mess = 'Maio';
break;
case '06':
$de_mess = 'Junho';
break;
case '07':
$de_mess = 'Julho';
break;
case '08':
$de_mess = 'Agosto';
break;
case '09':
$de_mess = 'Setembro';
break;
case '10':
$de_mess = 'Outubro';
break;
case '11':
$de_mess = 'Novembro';
break;
case '12':
$de_mess = 'Dezembro';
break;
}
$vl_perc = $linhasg[nu_cont] * 100 / $nu_maxm;
$nu_perc = intval($vl_perc);
?>
<div class="widget_summary">
<div class="w_left w_25">
<span><?php echo $de_mess;?></span>
</div>
<div class="w_center w_55">
<div class="progress">
<div class="progress-bar bg-green" role="progressbar" aria-valuenow="<?php echo $nu_perc;?>" aria-valuemin="0" aria-valuemax="100" style="width: <?php echo $nu_perc;?>%;">
<span class="sr-only"><?php echo $nu_perc;?>% Complete</span>
</div>
</div>
</div>
<div class="w_right w_20">
<span><?php echo $linhasg[nu_cont];?></span>
</div>
<div class="clearfix"></div>
</div>
<?
}
}
}
?>
</div>
</div>
</div>
<div class="col-md-6 col-sm-6 col-xs-12">
<div class="x_panel tile fixed_height_320 overflow_hidden">
<div class="x_title">
<h2>Tipo de Solicitação</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<?php
$nu_atua = date('Y-m');
$sqltp = "SELECT id_tipo, de_tipo ";
$sqltp .= "FROM ".$pref_tabl."solc_tipo ";
$sqltp .= "WHERE fl_atvo = 'S' ";
#echo $sqltp.'<br>';
$restp = mysqli_query($conn, $sqltp);
if (mysqli_num_rows($restp) > 0) {
$cont = 0;
while ($linhatp = mysqli_fetch_array($restp)) {
$cont++;
$sqlnt = "SELECT COUNT(c.id_comp) as nu_cont ";
$sqlnt .= "FROM ".$pref_tabl."comp c ";
$sqlnt .= "WHERE c.dt_cads LIKE '$nu_atua%' ";
$sqlnt .= "AND c.id_tipo = $linhatp[id_tipo] ";
#echo $sqlnt.'<br>';
$resnt = mysqli_query($conn, $sqlnt);
if (mysqli_num_rows($resnt) > 0) {
while ($linhant = mysqli_fetch_array($resnt)) {
$nu_tipo[$cont] = $linhant[nu_cont];
$de_tipo[$cont] = $linhatp[de_tipo];
$vl_porc = $linhant[nu_cont] * 100 / $nu_nows;
$nu_porc[$cont] = intval($vl_porc);
}
}
}
}
?>
<script>
var config = {
type: 'doughnut',
data: {
datasets: [{
data: [
<?php echo $nu_tipo[1];?>,
<?php echo $nu_tipo[2];?>,
<?php echo $nu_tipo[3];?>,
<?php echo $nu_tipo[4];?>,
<?php echo $nu_tipo[5];?>
],
backgroundColor: [
"#3498db",
"#1abb9c",
"#9b59b6",
"#9cc2cb",
"#e74c3c",
],
label: 'Dataset 1'
}],
labels: [
"<?php echo $de_tipo[1];?>",
"<?php echo $de_tipo[2];?>",
"<?php echo $de_tipo[3];?>",
"<?php echo $de_tipo[4];?>",
"<?php echo $de_tipo[5];?>"
]
},
options: {
responsive: true,
legend: {
position: 'top',
},
animation: {
animateScale: true,
animateRotate: true
}
}
};
window.onload = function() {
var ctx = document.getElementById("chart-area1").getContext("2d");
window.myDoughnut = new Chart(ctx, config);
};
</script>
<table class="" style="width:100%">
<tr>
<th style="width:37%;">
<p>Top 5</p>
</th>
<th>
<div class="col-lg-7 col-md-7 col-sm-7 col-xs-7">
<p class="">Tipo</p>
</div>
<div class="col-lg-5 col-md-5 col-sm-5 col-xs-5 hidden-xs">
<p class="pull-right">Qtde</p>
</div>
</th>
</tr>
<tr>
<td>
<canvas id="chart-area1"></canvas>
</td>
<td>
<table class="tile_info">
<tr>
<td>
<p><i class="fa fa-square blue"></i><?php echo $de_tipo[1];?> </p>
</td>
<td class="pull-right hidden-xs"><?php echo $nu_porc[1];?>%</td>
</tr>
<tr>
<td>
<p><i class="fa fa-square green"></i><?php echo $de_tipo[2];?> </p>
</td>
<td class="pull-right hidden-xs"><?php echo $nu_porc[2];?>%</td>
</tr>
<tr>
<td>
<p><i class="fa fa-square purple"></i><?php echo $de_tipo[3];?> </p>
</td>
<td class="pull-right hidden-xs"><?php echo $nu_porc[3];?>%</td>
</tr>
<tr>
<td>
<p><i class="fa fa-square aero"></i><?php echo $de_tipo[4];?> </p>
</td>
<td class="pull-right hidden-xs"><?php echo $nu_porc[4];?>%</td>
</tr>
<tr>
<td>
<p><i class="fa fa-square red"></i><?php echo $de_tipo[5];?> </p>
</td>
<td class="pull-right hidden-xs"><?php echo $nu_porc[5];?>%</td>
</tr>
</table>
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
<?php
}
if (($linhau[fl_solc] == 'P') // Compras
|| ($linhau[fl_solc] == 'D')) { // Direção
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Solicitações em atraso</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<?php
// calculando 3 dias úteis para tras
$nu_acho = $nu_cont = $nu_dias = 0;
while ($nu_acho == 0) {
$dd_atua = date('Y-m-d', mktime(0,0,0,date("m"), date("d")-$nu_cont, date("Y")));
$ww_atua = date('w', mktime(0,0,0,date("m"), date("d")-$nu_cont, date("Y")));
$nu_cont++;
if (($ww_atua != 0)
&& ($ww_atua != 6)) {
$nu_dias++;
}
if ($nu_dias == 4) {
$nu_acho = 1;
}
}
$sqlfp = "SELECT c.id_comp, c.id_sitc, c.nu_oc, t.de_tipo, s.de_sitc, u.nm_user, ";
$sqlfp .= "DATE_FORMAT(c.dt_cads, '%d/%m/%Y') as dt_cad2, ";
$sqlfp .= "DATE_FORMAT(c.dt_entr_prev, '%d/%m/%Y') as dt_entr_pre2, ";
$sqlfp .= "DATE_FORMAT(c.dt_aprv, '%d/%m/%Y') as dt_apr2 ";
$sqlfp .= "FROM ".$pref_tabl."comp c, ".$pref_tabl."solc_tipo t, ".$pref_tabl."sitc s, ".$pref_tabl."user u ";
$sqlfp .= "WHERE c.id_tipo = t.id_tipo ";
$sqlfp .= "AND c.id_sitc = s.id_sitc ";
$sqlfp .= "AND c.id_cads = u.id_user ";
$sqlfp .= "AND ((c.id_sitc = 2 ";
$sqlfp .= "AND c.dt_cads < '$dd_atua') ";
$sqlfp .= "OR (c.id_sitc = 5 ";
$sqlfp .= "AND c.dt_aprv < '$dd_atua') ";
$sqlfp .= "OR (c.id_sitc = 8 ";
$sqlfp .= "AND c.dt_entr_prev < '$dd_atua')) ";
$sqlfp .= "ORDER BY c.id_comp ";
#echo $sqlfp.'<br>';
$resfp = mysqli_query($conn, $sqlfp);
if (mysqli_num_rows($resfp) > 0) {
?>
<div class="table-responsive">
<table class="table table-striped jambo_table bulk_action">
<thead>
<tr class="headings">
<th>OC/OS N°</th>
<th>Tipo de Solicitação</th>
<th>Solicitante</th>
<th>Situação</th>
<th class="text-center">Data</th>
<th class="text-center">Data Entrega Prevista</th>
<th width="10%" class="text-center">Alterar</th>
</tr>
</thead>
<tbody>
<?php
while ($linhafp = mysqli_fetch_array($resfp)) {
if ($linhafp[id_sitc] == 5) {
$linhafp['dt_cad2'] = $linhafp['dt_apr2'];
}
?>
<tr class="even pointer">
<td>
<a href="javascript:alt_solc('<?php echo $linhafp['id_comp'] ?>')">
<?php echo $linhafp['nu_oc'] ?>
</a>
</td>
<td>
<?php echo $linhafp['de_tipo'] ?>
</td>
<td>
<?php echo $linhafp['nm_user'] ?>
</td>
<td>
<?php echo $linhafp['de_sitc'] ?>
</td>
<td class="text-center">
<?php echo $linhafp['dt_cad2'] ?>
</td>
<td class="text-center">
<?php echo $linhafp['dt_entr_pre2'] ?>
</td>
<td class="text-center">
<a href="javascript:alt_solc('<?php echo $linhafp['id_comp'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} else {
?>
<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alerta!</strong> Nenhuma Solicitação em atraso foi encontrada!
</div>
<?php
}
?>
</div>
</div>
</div>
<?php
}
}
if ($linhau[fl_solc] == 'C') {
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Solicitações do Usuário</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<?php
$sqlfp = "SELECT c.id_comp, c.nu_oc, t.de_tipo, s.de_sitc, ";
$sqlfp .= "DATE_FORMAT(c.dt_cads, '%d/%m/%Y') as dt_cad2 ";
$sqlfp .= "FROM ".$pref_tabl."comp c, ".$pref_tabl."solc_tipo t, ".$pref_tabl."sitc s ";
$sqlfp .= "WHERE c.id_tipo = t.id_tipo ";
$sqlfp .= "AND c.id_sitc = s.id_sitc ";
if ($linhau[fl_extr] == 'N') {
$sqlfp .= "AND c.id_sitc NOT IN (1,6,7) ";
}
$sqlfp .= "AND c.id_cads = $linhau[id_user] ";
$sqlfp .= "ORDER BY c.id_comp DESC ";
if ($linhau[fl_extr] == 'N') {
$sqlfp .= "LIMIT 20 ";
}
#echo $sqlfp.'<br>';
$resfp = mysqli_query($conn, $sqlfp);
if (mysqli_num_rows($resfp) > 0) {
?>
<div class="table-responsive">
<table class="table table-striped jambo_table bulk_action">
<thead>
<tr class="headings">
<th>OC/OS N°</th>
<th>Tipo de Solicitação</th>
<th>Situação</th>
<th class="text-center">Data</th>
<th width="10%" class="text-center">Alterar</th>
</tr>
</thead>
<tbody>
<?php
while ($linhafp = mysqli_fetch_array($resfp)) {
?>
<tr class="even pointer">
<td>
<a href="javascript:alt_solc('<?php echo $linhafp['id_comp'] ?>')">
<?php echo $linhafp['nu_oc'] ?>
</a>
</td>
<td>
<?php echo $linhafp['de_tipo'] ?>
</td>
<td>
<?php echo $linhafp['de_sitc'] ?>
</td>
<td class="text-center">
<?php echo $linhafp['dt_cad2'] ?>
</td>
<td class="text-center">
<a href="javascript:alt_solc('<?php echo $linhafp['id_comp'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
} else {
?>
<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alerta!</strong> Nenhuma Solicitação em atraso foi encontrada!
</div>
<?php
}
?>
</div>
</div>
</div>
<?php
} else {
$sql = "SELECT c.id_comp, c.nu_oc, c.fl_ocos, t.de_tipo, s.de_sitc, u.nm_user, c.id_forn, ";
$sql .= "DATE_FORMAT(c.dt_cads, '%d/%m/%Y') as dt_cad2 ";
$sql .= "FROM ".$pref_tabl."comp c, ".$pref_tabl."solc_tipo t, ".$pref_tabl."sitc s, ".$pref_tabl."user u ";
$sql .= "WHERE c.id_tipo = t.id_tipo ";
$sql .= "AND c.id_sitc = s.id_sitc ";
$sql .= "AND c.id_sitc NOT IN (1,6,7) ";
$sql .= "AND c.id_cads = u.id_user ";
$sql .= "ORDER BY c.id_comp DESC ";
#echo $sql.'<br>';
$res = mysqli_query($conn, $sql);
if (mysqli_num_rows($res) > 0) {
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Solicitações em Andamento</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<table id="datatable" class="table table-striped table-bordered">
<thead>
<tr>
<th>OC/OS N°</th>
<th>Tipo de Solicitação</th>
<th>Solicitante</th>
<th class="text-center">Situação</th>
<th class="text-center">Fornecedor</th>
<th width="10%" class="text-center">Alterar</th>
</tr>
</thead>
<tbody>
<?php
while ($linha = mysqli_fetch_array($res)) {
$linhafr[nm_forn] = '';
if ($linha[id_forn] != '') {
$sqlfr = "SELECT nm_forn ";
$sqlfr .= "FROM ".$pref_tabl."forn ";
$sqlfr .= "WHERE id_forn = $linha[id_forn] ";
$sqlfr .= "LIMIT 1 ";
#echo $sqlre.'<br>';
$resfr = mysqli_query($conn, $sqlfr);
if (mysqli_num_rows($resfr) > 0) {
$linhafr = mysqli_fetch_array($resfr);
}
}
?>
<tr>
<td>
<a href="javascript:alt_solc('<?php echo $linha['id_comp'] ?>')">
<?php echo $linha['nu_oc'] ?>
</a>
</td>
<td>
<?php echo $linha['de_tipo'] ?>
</td>
<td>
<?php echo $linha['nm_user'] ?>
</td>
<td class="text-center">
<?php echo $linha['de_sitc'] ?>
</td>
<td class="text-center">
<?php echo $linhafr['nm_forn'] ?>
</td>
<td class="text-center">
<a href="javascript:alt_solc('<?php echo $linha['id_comp'] ?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Alterar
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php
}
}
?>
<?php
if ($linhau[fl_extr] == 'N') {
$sqlp = $sqlpe . "AND id_tela IN (39) ";
$resp = mysqli_query($conn, $sqlp);
if (mysqli_num_rows($resp) > 0) {
$dd_atua = date("d");
$mm_atua = date("m");
$aa_atua = date("Y");
$dt_atua = date("d/m/Y");
$dt_pesq = date("Y-m-d", mktime(0,0,0,$mm_atua,$dd_atua + 20,$aa_atua));
$sql = "SELECT t.id_tipo_pagm, t.de_tipo_pagm, a.id_agnd_pagm, a.de_titl, a.vl_agnd, c.id_comp, c.nu_oc, f.nm_forn, ";
$sql .= "DATE_FORMAT(a.dt_agnd, '%d/%m/%Y') as dt_agn2 ";
$sql .= "FROM ".$pref_tabl."tipo_pagm t, ".$pref_tabl."agnd_pagm a, ".$pref_tabl."comp c, ".$pref_tabl."forn f ";
$sql .= "WHERE a.id_tipo_pagm = t.id_tipo_pagm ";
$sql .= "AND a.id_comp = c.id_comp ";
$sql .= "AND c.id_forn = f.id_forn ";
$sql .= "AND (a.dt_pagm IS NULL ";
$sql .= "OR a.dt_pagm = '0000-00-00') ";
$sql .= "AND a.dt_agnd < '$dt_pesq' ";
$sql .= "AND c.id_sitc NOT IN ('6','7') "; // Situação Concluída e Cancelada
$sql .= "ORDER BY a.dt_agnd DESC ";
$res = mysqli_query($conn, $sql);
#echo $sql;
if (mysqli_num_rows($res) > 0) {
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Agenda de Pagamento - Próximos Vencimentos</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<table id="datatable" class="table table-striped jambo_table bulk_action">
<thead>
<tr>
<th>OC/OS N°</th>
<th>Fornecedor</th>
<th>Título</th>
<th>Tipo de Pagamento</th>
<th class="text-center">Data Prevista</th>
<th class="text-right">Valor</th>
</tr>
</thead>
<tbody>
<?php
$cont = 1;
while ($linha = mysqli_fetch_array($res)) {
unset($fundo);
if (($cont % 2) == 0)
$fundo = 'class="dif"';
$cont++;
$totl++;
?>
<tr>
<td>
<a href="javascript:alt_agnd_pagm('<?php echo $linha['id_comp'] ?>','<?php echo $linha['nu_oc'] ?>')">
<?php echo $linha['nu_oc'] ?>
</a>
</td>
<td>
<?php echo $linha['nm_forn'] ?>
</td>
<td>
<?php echo $linha['de_titl'] ?>
</td>
<td>
<?php echo $linha['de_tipo_pagm'] ?>
</td>
<td class="text-center">
<?php echo $linha['dt_agn2'] ?>
</td>
<td class="text-right">
R$ <?php echo moeda ($linha['vl_agnd']); ?>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php
} else {
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Resultado da Busca de Agenda de Pagamento<small>Gerenciador de Agenda de Pagamento</small></h2>
<div class="clearfix"></div>
</div>
<div class='alert alert-danger alert-dismissible fade in' role='alert' style='margin-top:30px;'>
<button type='button' class='close' data-dismiss='alert' aria-label='Close'><span aria-hidden='true'>×</span></button>
<strong>Alerta!</strong> Nenhum pagamento com estas caracteristicas foi encontrado!
</div>
</div>
</div>
</div>
<?php
}
}
}
if ($linhau[fl_anim] == 'C') {
$selanim = "AND s.id_cads = '$linhau[id_user]'";
}
if ($linhau[fl_anim] == 'D') {
$selanim = "AND s.id_sitc = '2' ";
}
$sqlaa = "SELECT s.id_solc, s.nu_ceua, e.id_estd, e.nu_estd, e.de_titl, st.de_sitc, s.id_colb, s.id_estd, sc.nm_colb, ";
$sqlaa .= "DATE_FORMAT(s.dt_inic, '%d/%m/%Y') as dt_ini2, ";
$sqlaa .= "DATE_FORMAT(s.dt_finl, '%d/%m/%Y') as dt_fin2 ";
$sqlaa .= "FROM ".$pref_tabl."anim_estd e, ".$pref_tabl."anim_solc s, ".$pref_tabl."anim_sitc st, ".$pref_tabl."colb sc ";
$sqlaa .= "WHERE s.id_estd = e.id_estd ";
$sqlaa .= "AND s.id_sitc = st.id_sitc ";
$sqlaa .= "AND s.id_resp = sc.id_colb ";
$sqlaa .= "AND s.id_sitc NOT IN (5,6) ";
$sqlaa .= "$selanim ";
$sqlaa .= "ORDER BY s.id_solc DESC ";
$resaa = mysqli_query($conn, $sqlaa);
#echo $sqlaa;
if (mysqli_num_rows($resaa) > 0) {
?>
<div class="row">
<div class="col-md-12 col-sm-12 col-xs-12">
<div class="x_panel">
<div class="x_title">
<h2>Solicitações de Animais</h2>
<div class="clearfix"></div>
</div>
<div class="x_content">
<div class="table-responsive">
<table class="table table-striped jambo_table bulk_action">
<!-- <table id="datatable" class="table table-striped jambo_table bulk_action"> -->
<thead>
<tr>
<th width="7%" class="text-center">N° SA</th>
<th width="20%">Estudo</th>
<th width="15%">Linhagem</th>
<th>De Responsável</th>
<th width="8%" class="text-center">Data Início</th>
<th width="8%" class="text-center">Data Final</th>
<th width="15%" class="text-center">Situação</th>
<th width="8%" class="text-center">Visualizar</th>
</tr>
</thead>
<tbody>
<?php
while ($linhaaa = mysqli_fetch_array($resaa)) {
$nm_linh = '';
$sqlln = "SELECT l.nm_linh ";
$sqlln .= "FROM ".$pref_tabl."anim_linh l, ".$pref_tabl."anim_anim a ";
$sqlln .= "WHERE a.id_linh = l.id_linh ";
$sqlln .= "AND a.id_solc = '$linhaaa[id_solc]' ";
$sqlln .= "ORDER BY l.nm_linh ";
$resln = mysqli_query($conn, $sqlln);
#echo $sqlln;
if (mysqli_num_rows($resln) > 0) {
while ($linhaln = mysqli_fetch_array($resln)) {
$nm_linh .= $linhaln['nm_linh'].', ';
}
$nm_linh = substr($nm_linh,0,-2);
}
?>
<tr>
<td>
<div align='center'>
<a href="javascript:alt_anim_solc('<?php echo $linhaaa['id_solc'];?>','<?php echo $linhaaa['id_estd'];?>','<?php echo $linhaaa['id_colb'];?>')">
<?php echo $linhaaa['id_solc']; ?>
</a>
</div>
</td>
<td>
<?php echo $linhaaa['nu_estd']; ?> - <?php echo $linhaaa['de_titl']; ?>
</td>
<td>
<?php echo $nm_linh; ?>
</td>
<td>
<?php echo $linhaaa['nm_colb']; ?>
</td>
<td align='center'>
<?php echo $linhaaa['dt_ini2']; ?>
</td>
<td align='center'>
<?php echo $linhaaa['dt_fin2']; ?>
</td>
<td align='center'>
<?php echo $linhaaa['de_sitc']; ?>
</td>
<td class="text-center">
<a href="javascript:alt_anim_solc('<?php echo $linhaaa['id_solc'];?>','<?php echo $linhaaa['id_estd'];?>','<?php echo $linhaaa['id_colb'];?>')" class="btn btn-info btn-xs">
<i class="fa fa-pencil" aria-hidden="true"></i> Visualizar
</a>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
</div>
<script>
function alt_solc(xb) {
document.acidente.action = "index1.php?pg=alt_solc";
document.acidente.id_comp.value = xb;
document.acidente.submit();
}
function alt_anim_solc(xb,xx,bb) {
document.acidente.action = "index1.php?pg=ver_anim_solc";
document.acidente.id_solc.value = xb;
document.acidente.v_id_estd.value = xx;
document.acidente.v_id_colb.value = bb;
document.acidente.submit();
}
function alt_user(xb) {
document.acidente.action = "index1.php?pg=alt_user";
document.acidente.id_user.value = xb;
document.acidente.submit();
}
function alt_agnd_pagm(xb,oc){
document.acidente.action = "index1.php?pg=alt_solc#dv_pagm";
document.acidente.id_comp.value = xb;
document.acidente.v_nu_oc.value = oc;
document.acidente.submit();
}
</script>
<form name="acidente" method="post" action="" style="margin:0px;">
<input type="hidden" name="opc">
<input type="hidden" name="id_comp">
<input type="hidden" name="id_solc">
<input type="hidden" name="v_nu_oc">
<input type="hidden" name="v_id_estd">
<input type="hidden" name="v_id_colb">
<input type="hidden" name="nu_oc" id="nu_oc" value="<?=$_POST[nu_oc]?>">
<input type="hidden" name="id_tipo" id="id_tipo" value="<?=$_POST[id_tipo]?>">
<input type="hidden" name="id_sitc" id="id_sitc" value="<?=$_POST[id_sitc]?>">
<input type="hidden" name="id_agnd_pagm" id="id_agnd_pagm" value="<?=$_POST[id_agnd_pagm]?>">
<input type="hidden" name="id_user">
<input name="passa" type="hidden" id="passa" value="yes">
</form>
Back to Directory
File Manager