File Manager

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

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

Back to Directory File Manager