File Manager

Editing File: /home/cienp/public_html/portal/includes/principal-olds.php

<div class="container body">
    <div class="main_container">
        <div class="right_col" role="main">
          
            
            <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>

<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>

Back to Directory File Manager