Viewing File: /home/cienp/public_html/portal/includes/principal-olds.php
<div class="container body">
<div class="main_container">
<div class="right_col" role="main">
<!-- top tiles -->
<div class="row tile_count ests_mobl">
<?php
$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_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 > 5 ";
$sqlss .= "AND c.dt_cads LIKE '$nu_mess%' ";
$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)) {
switch ($linhass[id_sitc]) {
case '6':
$nu_conc = $linhass[nu_cont];
break;
case '7':
$nu_canc = $linhass[nu_cont];
break;
}
}
}
?>
<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-close"></i> Cancelada</span>
<div class="count"><?php echo $nu_canc;?></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 -->
<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",
"#46BFBD",
"#FDB45C",
"#949FB1",
"#4D5360",
],
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
?>
<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.nu_oc, t.de_tipo, s.de_sitc, u.nm_user, ";
$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, ".$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 .= "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 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['nm_user'] ?>
</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
}
?>
</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_user(xb) {
document.acidente.action = "index1.php?pg=alt_user";
document.acidente.id_user.value = xb;
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="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_user">
<input name="passa" type="hidden" id="passa" value="yes">
</form>
Back to Directory
File Manager