404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Analise_Mix /
Filename : VieAnaliseMixListar.php
back
<?php
if (!defined('URL')) {
    header("Location: /");
    exit();
}
//var_dump($this->Dados['select']);
?>

<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">Analise do Mix</h2>
            </div>
            <?php
             if ($this->Dados['botao']['vol_ana_mix']) {
                ?>
                <a href="<?php echo URLADM . 'con-analise-mix/listar'; ?>">
                    <div class="p-2">
                        <button class="btn btn-outline-primary btn-sm">
                            Voltar
                        </button>
                    </div>
                </a>
              <?php
            }
            
             ?>
            <?php
             if ($this->Dados['botao']['exc_ana_mix']) {
                ?>
                <a href="<?php echo URLADM . 'con-analise-mix/listar/?opcao=E&perc_corte='.$this->Dados['select'][0]['perc_corte']; ?>">
                    <div class="p-2">
                        <button class="btn btn-outline-success btn-sm">
                            Excel
                        </button>
                    </div>
                </a>
              <?php
            }
            
             ?>  
        </div>
        <?php
        if (empty($this->Dados['select'])) {
            ?>
            <div class="alert alert-danger" role="alert">
               Nenhum Produto encontrado!
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
  
                </button>     
           </div>
            <?php
        }
        if (isset($_SESSION['msg'])) {
            echo $_SESSION['msg'];
            unset($_SESSION['msg']);
        }
        
        ?>
       
            <div class="row">
             <div class="col-sm">
             
                
                 <table cellspacing="0"> 
                    <thead>
                    <?php
                        if (!empty($this->Dados['select'])) {
                            $perc_corte = $this->Dados['select'][0]['perc_corte'];
                    ?> 
                         <tr>  
                             <td align='left' >Filial/Cluster:<b><?php echo ' '. utf8_encode($this->Dados['select'][0]['filial_nome']); ?></td>
                             </tr>      
                      
                        <tr>  
                             <td align='left' >Seção:<b><?php echo ' '. utf8_encode($this->Dados['select'][0]['secao_nome']); ?></td>
                                
                             
                             <td align='left' >Grupo:<b><?php echo ' '. utf8_encode($this->Dados['select'][0]['grupo_nome']); ?></td>
                                
                             
                               <td align='left' >SubGrupo:<b><?php echo ' '.$this->Dados['select'][0]['subgrupo_nome']; ?></b></td>
                             
                               <td align='left' >Classe:<b><?php echo ' '.$this->Dados['select'][0]['classe_nome']; ?></b></td>
                            </tr>  
                        <tr>
                           
                    <?php
                        }
                    
                    ?> 
                             </thead>
                 </table>
                 <font size ='2'>
                     <table align="left"  class="datatable-idoso-gre stripe " cellspacing="0"> 
                    <thead> 
                   
                            <td class="table-info" align="center" ><b><font color="blue">Produto</b></td>
                            <td class="table-info" align="center" ><b><font color="blue">Inclusao</b></td>
                            <td class="table-info" align="right"> <b><font color="blue">Qtde Total</b></td> 
                            <td class="table-info" align="right"> <b><font color="blue">Qtde Dia</b></td>
                            <td class="table-info" align="right"> <b><font color="blue">Valor Estoque</b></td>
                            <td class="table-info" align="right"> <b><font color="blue">Dias Estoque</b></td>
                             <td  class="table-info" align="right"><b><font color="blue">Custo Médio</b></td> 
                            <td  class="table-info" align="right"><b><font color="blue">% MB</b></td> 
                             <td  class="table-info" align="right"><b><font color="blue">% Part</b></td>
                             <td  class="table-info" align="right"><b><font color="blue">% Part Acum</b></td> 
                             <td  class="table-info" align="center"><b><font color="blue">Ações</b></td> 
                        </tr>
                    </thead>
                    <tbody>
                             <?php
                            if (!empty($this->Dados['select'])) {
                                $perc_corta =  $this->Dados['select'][0]['perc_corte'];
                             //    $partic_acum = 0;   
                               foreach ($this->Dados['select'] as $lactos) {
                                   extract($lactos);
                                //$partic_acum = $partic_acum + $part;    
                              //       if($part_acum >= $perc_corte) {
                                    ?>
                        <tr>    
                            
                                       <td  align='left'><?php echo $produto_id.'-'.$prod_nome; ?></td>
                                       <td align='center'><?php echo $inclusao; ?></td>
                                       <td align='right'><?php echo number_format($qtde_total,0,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($qtde_dia,4,',','.'); ?></td>
                                        
                                     
                                       <td align='right'><?php echo number_format($valor_estoque,2,',','.'); ?></td>
                                      
                                       <td align='right'><?php echo number_format($dias_estoque,0,',','.'); ?></td>
                                        <td align='right'><?php echo number_format($cus_total,2,',','.'); ?></td>
                                        <td align='right'><?php echo number_format($perc_mb,2,',','.'); ?></td>
                                        <td align='right'><?php echo number_format($part,2,',','.'); ?></td>
                                        <?php
                                        if ($part_acum > 100.00) {$part_acum = 100.00;}
                                        if ($part_acum >= $perc_corta) {
                                        ?>
                                            <td bgcolor='#F4FA58' align='right'><b><?php echo number_format($part_acum,2,',','.'); ?></b></td>
                                        <?php
                                        }else{
                                        ?>
                                            <td align='right'><?php echo number_format($part_acum,2,',','.'); ?></td>
                                        <?php
                                        }
                                        ?>
                                        <td class="text-center">
                                <span class="d-none d-md-block">
                                    <?php
                                      if ($this->Dados['botao']['ver_ana_mix']) {
                                      echo "<button type='button'  class='btn btn-outline-primary btn-sm view_datam' id='".$produto_id."'>Detalhes</button> ";
                                    }
                                    ?>
                                </span>
                                <div class="dropdown d-block d-md-none">
                                    <button class="btn btn-primary dropdown-toggle btn-sm" type="button" id="acoesListar" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                        Ações
                                    </button>
                                    <div class="dropdown-menu dropdown-menu-right" aria-labelledby="acoesListar">
                                        <?php
					if ($this->Dados['botao']['ver_ana_mix']) {
                                            echo "<a class='dropdown-item' href='" . URLADM . "con-analise-mix/listar'>Detalhes</a>";
                                        }
                                       
                                        ?>


                                    </div>
                                </div>
                            </td>
                        </tr>                                        
                            <?php
                               }
                            } 
                            ?>
                                
                    </tbody>
                </table>
                 </font>
             
        </div>            
   </div>
</div>
   <span id="conteudo_mix"></span>
</div>
<!-- Modal -->
<div class="modal fade" id="visuMixModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Detalhes  do Produto</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
          <span id="visul_Mix"></span>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fechar</button>
        </div>
    </div>
  </div>
</div>