404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Ruptura /
Filename : VieRupCompradorListar.php
back
<?php
if (!defined('URL')) {
    header("Location: /");
    exit();
}
//var_dump($this->Dados['select'][0]);
?>
<style type="text/css"> 
tr.something {
  td {
    width: 190px;
  }
}
</style>
<div class="content p-1">
    <div class="list-group-item">
        
        <div class="d-flex">
            <div class="mr-auto p-2">
                <h2 class="display-4 titulo">Ruptura Compradores</h2>
            </div>
             <div class="p-2">
                <a href="<?php echo URLADM . 'con-rup-comprador/listar' ?>" class="btn btn-outline-info btn-sm">Voltar</a>

            </div>
         <?php
             if (!empty($this->Dados['select'])) {   
            ?>             
        <!--    <div class="p-2">
                <a target="_blank" href="<?php echo URLADM . 'con-rup-comprador-imprime/' ?>" class="btn btn-outline-success btn-sm">Imprimir</a>
                 </div>
   -->
           <?php
             }
              
            ?>
           
        
           
        </div>
        <?php
        if (empty($this->Dados['select'])) {
            ?>
            <div class="alert alert-danger" role="alert">
               Nenhum Comprador encontrado!
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
  
                </button>     
                </button>
            </div>
            <?php
        }
        if (isset($_SESSION['msg'])) {
            echo $_SESSION['msg'];
            unset($_SESSION['msg']);
        }
        
        ?>
      <div class="row">
            <div class="col-sm-12">
     <!--           <table align="left"  class="datatable-idoso-gre stripe " cellspacing="0"> -->
  <font size="2">
                 <table align="left"  class="table table-bordered table-hover">
                <thead>
            <?php
                if (!empty($this->Dados['select'])) {
            ?>        
                <tr>  
                        <td align='center' colspan="15">Data:<b><?php echo ' '.$this->Dados['select'][0]['datav']; ?></b></td>
                    </tr> 
                     
                    
            <?php
                }
            $tven_a = 0;
            $tven_b = 0;
            $tven_c = 0;
            $tven_d = 0;
            $tven_t = 0;
            $trup_a = 0;
            $trup_b = 0;
            $trup_c = 0;
            $trup_d = 0;
            $trup_t = 0;
            $trup_pbm_t = 0;
            $fdia = 0;
            $fmes = 0;
            $test_dia_ant = 0;
            $test_dia_atu = 0;
            $test_dia_dif = 0;
            ?>                    
            <tr>
                <td  class="table-info" align="center" ><b><font color="blue">Comprador</b></td>

                <td class="table-info" align="center" title="clique aqui para ver Produtos"><b><font color="blue">A</b></td>  
                <td class="table-info" align="center" title="Meta Mês"><b><font color="blue">Meta</b></td>  
                <td class="table-info" align="center" title="clique aqui para ver Produtos"><b><font color="blue">B</b></td>         
                <td class="table-info" align="center" title="Meta Mês"><b><font color="blue">Meta</b></td>
                <td class="table-info" align="center" title="clique aqui para ver Produtos"><b><font color="blue">C</b></td>         
                <td class="table-info" align="center" title="Meta Mês"><b><font color="blue">Meta</b></td>
                <td class="table-info" align="center" title="clique aqui para ver Produtos"><b><font color="blue">D</b></td>         
		<td class="table-info" align="center" title="clique aqui para ver Produtos"><b><font color="blue">TOTAL</b></td> 
		<td class="table-info" align="center" ><b><font color="blue">Falta Dia</b></td> 
                <td class="table-info" align="center" ><b><font color="blue">Falta PBM</b></td> 
                <td class="table-info" align="center" title="Falta Acumulada até a Data"><b><font color="blue">Falta Mes</b></td> 
                <td class="table-info" align="center" ><b><font color="blue">Estoque dia Ant</b></td>
                <td class="table-info" align="center" ><b><font color="blue">Estoque dia Atu</b></td>   
                <td class="table-info" align="center" ><b><font color="blue">Diferença</td>           
            </tr>
                </thead>
                <tbody>
                    <?php
                    
                 if (!empty($this->Dados['select'])) {    
                    foreach ($this->Dados['select'] as $lactos) {
                        extract($lactos);
                        
                        ?>
                        <tr>
                           <td >  
                         <?php     
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-tendencia/listar/?comp_id=$comp_id&data_sel=$data_sel'>$nome</a>";
                             ?>
                             </td> 
                             <td>
                            <?php
                            $perc_a_m = number_format(round($perc_a,1),1,',','.');
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=A&comp=$comp_id&data=$data_sel'>$perc_a_m%</a>";
                             ?>
                            <?php
                            if ($perc_a >$meta_a){
                            ?>
                             <td><font color="red"><b><?php echo number_format($meta_a,0,',','.').'%'?></font></b></td>
                             <td>
                            <?php
                            }else{
                            ?>
                             <td><font color="green"><b><?php echo number_format($meta_a,0,',','.').'%'?></font></b></td>
                             <td>    
                            <?php
                            }
                            ?>     
                            <?php  
                            $perc_b_m = number_format(round($perc_b,1),1,',','.');
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=B&comp=$comp_id&data=$data_sel'>$perc_b_m%</a>";
                             ?>
                            </td>
                           
                            <?php
                            if ($perc_b >$meta_b){
                            ?>
                             <td><font color="red"><b><?php echo number_format($meta_b,0,',','.').'%'?></font></b></td>
                           
                            <?php
                            }else{
                            ?>
                             <td><font color="green"><b><?php echo number_format($meta_b,0,',','.').'%'?></font></b></td>
                            <?php
                            }
                            ?> 
                            
                            <td  align="center">
                            <?php  
                            $perc_c_m = number_format(round($perc_c,1),1,',','.');
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=C&comp=$comp_id&data=$data_sel'>$perc_c_m%</a>";
                             ?>
                             </td> 
                              <?php
                            if ($perc_c >$meta_c){
                            ?>
                             <td><font color="red"><b><?php echo number_format($meta_c,0,',','.').'%'?></font></b></td>
                           
                            <?php
                            }else{
                            ?>
                             <td><font color="green"><b><?php echo number_format($meta_c,0,',','.').'%'?></font></b></td>
                            <?php
                            }
                            ?> 
                            <td  align="center">
                            <?php    
                             $perc_d_m = number_format(round($perc_d,1),1,',','.');
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=D&comp=$comp_id&data=$data_sel'>$perc_d_m%</a>";
                             ?>
                             </td>
                            <td  align="center"> 
			    <?php     
                             $perc_t_m = number_format(round($perc_t,1),1,',','.');
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=T&comp=$comp_id&data=$data_sel'><b>$perc_t_m%</b></a>";
                             ?>
                             </td>
                             <td align="right"><?php echo number_format($rup_t,0,',','.') ?></td>
                             <td align="right"><?php echo number_format($rup_pbm_t,0,',','.') ?></td>
                             <td align="right"><?php echo number_format($rup_acum,0,',','.') ?></td>
                             <td align="right"><?php echo number_format($est_dia_ant,0,',','.') ?></td>
                             <td  align="right"><?php echo number_format($est_dia_atu,0,',','.') ?></td>
                             <td  align="right"><?php echo number_format($est_dife,0,',','.') ?></td>
                        </tr>
                 <?php
                        $tven_a = $tven_a+ $ven_a;
                        $tven_b = $tven_b+ $ven_b;
                        $tven_c = $tven_c+ $ven_c;
                        $tven_d = $tven_d+ $ven_d;
                        $tven_t = $tven_t+ $ven_t;
                        $trup_a = $trup_a+ $rup_a;
                        $trup_b = $trup_b+ $rup_b;
                        $trup_c = $trup_c+ $rup_c;
                        $trup_d = $trup_d+ $rup_d;
                        $trup_t = $trup_t+ $rup_t;
                        $trup_pbm_t = $trup_pbm_t + $rup_pbm_t;
                        $fmes = $fmes+ $rup_acum; 
                        $test_dia_ant = $test_dia_ant + $est_dia_ant;
                        $test_dia_atu = $test_dia_atu + $est_dia_atu;
                        $test_dia_dif = $test_dia_dif + $est_dife;                        
                    }
                 }
                
                    ?>

                </tbody>
                <tfoot>
                <td class="table-info">
                    <?php   
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-tendencia/listar/?comp_id=0&data_sel=$data_sel><font color='blue'><b>TOTAL</b></a>";
                    ?>  
                </td>
                <td class="table-info" align='right'>
                    <?php     
                        $perc_tt = number_format(round((($trup_a*100)/$tven_a),1),1,',','.');
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=A&comp=0&data=$data_sel'><b><font color='blue'>$perc_tt%</font></b></a>";
                    ?>
                </td>
                <td class="table-info" align='center'></td>
                <td class="table-info" align='right'>
                    <?php     
                        $perc_tt = number_format(round((($trup_b*100)/$tven_b),1),1,',','.');
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=B&comp=0&data=$data_sel'><b><font color='blue'>$perc_tt%</font></b></a>";
                    ?>
                </td>
                 <td class="table-info" align='center'></td>
                <td class="table-info" align='right'>
                    <?php     
                        $perc_tt = number_format(round((($trup_c*100)/$tven_c),1),1,',','.');
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=C&comp=0&data=$data_sel'><b><font color='blue'>$perc_tt%</font></b></a>";
                    ?>
                </td>
                <td class="table-info" align='center'></td>
                <td class="table-info" align='right'>
                    <?php     
                        $perc_tt = number_format(round((($trup_d*100)/$tven_d),1),1,',','.');
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=D&comp=0&data=$data_sel'><b><font color='blue'>$perc_tt%</font></b></a>";
                    ?>
                </td>

                <td class="table-info" align='right'>
                    <?php     
                        $perc_tt = number_format(round((($trup_t*100)/$tven_t),1),1,',','.');
                        echo "<a class='dropdown-item ' href=  " . URLADM . "con-rup-comp-prod/listar/?curva=T&comp=0&data=$data_sel'><b><font color='blue'>$perc_tt%</font></b></a>";
                    ?>
                </td>         
            <!--    <td class="table-info" align='center'><b><font color="blue"><?php echo number_format(round((($trup_t*100)/$tven_t),2),2,',','.').'%' ?></b></td> -->
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($trup_t,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($trup_pbm_t,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($fmes,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($test_dia_ant,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($test_dia_atu,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($test_dia_dif,0,',','.') ?></b></td>
                </tfoot>
            </table>
  </font>
             </div>
           </div>  
           
         
</div>
        </div>