404

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

<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">Análise do Mix Genérico</h2>
            </div>
       <?php
       // var_dump($this->Dados['botao']);
             if ($this->Dados['botao']['vol_mix']) {
                ?>
                <a href="<?php echo URLADM . 'con-mix-generico/listar'; ?>">
                    <div class="p-2">
                        <button class="btn btn-outline-primary btn-sm">
                            Voltar
                        </button>
                    </div>
                </a>
        <?php
            }
        ?>
        <?php
       //var_dump($this->Dados['botao']);
             if ($this->Dados['botao']['exc_mix']) {
                ?>
            <div class="p-2">
                 <a target="_blank" href="<?php echo URLADM . 'con-mix-generico/listar/?dcb_id=' . $this->Dados['select'][0]['dcb_id'] . '&apres_nome='.$this->Dados['select'][0]['apres']. '&tipo='.$this->Dados['select'][0]['tipo'].'&opcao=E'; ?>" class="btn btn-outline-success btn-sm">Gera Excel</a>
            </div>     
        <?php
            }
        ?>    
        </div>
 <font size="2">        
        <?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']);
        }
        $mb_media_m = $this->Dados['select'][0]['mb_media'];
        $mb_media_m = number_format($mb_media_m,2,',','.');
        
        ?>
       
            <div class="row">
             <div class="col-sm">
             
                
                 <table cellspacing="0"> 
                    <thead>
                        <tr>  
                            <td align='center' >DCB:<b><?php echo ' '. $this->Dados['select'][0]['dcb_nome']; ?></td>
                           <td> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</td> 
                        <?php
                          if ($this->Dados['select'][0]['apres'] == 0) {
                        ?>
                             <td align='center' >Apres.:<b><?php echo ' TODAS'; ?></td>
                        <?php }else{ ?>
                             <td align='center' >Apres:<b><?php echo ' '. $this->Dados['select'][0]['apres']; ?></td>
                        <?php } ?>  
                             <td> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</td> 
                            <td align='center' >Dias de Venda: <b><?php echo ' '. $this->Dados['select'][0]['dias'] ?></td>
                            <td> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</td>
                            <td align='center' >Margem Média: <b><?php echo ' '. $mb_media_m.'%' ?></td>
                        </tr>  
                    </thead>
                 </table>
             </div>     
                 <table align="left"  class="datatable-idoso-gre stripe " cellspacing="0"> 
                    <thead> 
                    <tr>    
                        <td class="table-info" align="center" ><b><font color="blue">Produto</font></b></td>
                        <td class="table-info" align="center" ><b><font color="blue">Marca</font></b></td>
                        <td class="table-info" align="center" ><b><font color="blue">Mes/Ano Inc.</font></b></td>
                        <td class="table-info" align="center" ><b><font color="blue">Qtde Filiais</font></b></td>
                        <td class="table-info" align="right"> <b><font color="blue">Est. Total</font></b></td> 
                        <td class="table-info" align="right"> <b><font color="blue">Qtde Venda</font></b></td>
                        <td class="table-info" align="right"> <b><font color="blue">Venda (Dia)</font></b></td>
                        <td class="table-info" align="right"> <b><font color="blue">Part. Venda</font></b></td>
                        <td  class="table-info" align="right"><b><font color="blue">Custo Total</font></b></td> 
                        <td  class="table-info" align="right"><b><font color="blue">Venda Total</font></b></td> 
                        <td  class="table-info" align="right"><b><font color="blue">MB</font></b></td> 
                        <td  class="table-info" align="right"><b><font color="blue">Preço Fabr</font></b></td>
                        <td  class="table-info" align="right"><b><font color="blue">Preço Max</font></b></td>
                        <td  class="table-info" align="right"><b><font color="blue">Desc. Médio</font></b></td> 
                        <td  class="table-info" align="right"><b><font color="blue">Preço Médio</font></b></td> 
                        </tr>
                    </thead>
                    <tbody>
                             <?php
                            if (!empty($this->Dados['select'])) {    
                                 $part_acum = 0;   
                               foreach ($this->Dados['select'] as $lactos) {
                                   extract($lactos);
                                    ?>
                                    <tr>    
                                       <td  align='left'><?php echo $produto_id.'-'.$produto_nome; ?></td>
                                       <td  align='left'><?php echo $marca_nome; ?></td>
                                       <td align='center'><?php echo $data_inclusao; ?></td>
                                         <?php 
                                                echo "<td align='center' <font color='blue'>";                                           
                                                echo "<a class='dropdown-item ' href='" . URLADM . "con-mix-generico-filial/listar/?prod_id=$produto_id&dcb_id=$dcb_id&apres=$apres&tipo=$tipo'><font color='blue'><u>$qtde_filiais</u></font></a>";
                                                echo "</td>";
                                         
                                        ?> 
                                       
                                       <td align='right'><?php echo number_format($estoque,0,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($qtde_venda,0,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($qtde_dia,4,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($part_venda_unid,2,',','.').'%'; ?></td>
                                       <td align='right'><?php echo number_format($custo_total,2,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($venda_total,2,',','.'); ?></td>
                                    <?php
                                       if ($lb_i < $mb_media) {
                                    ?>
                                            <td align='right'><font color='red'><b><?php echo $lb.'%'; ?></b></font></td>
                                    <?php
                                       }else{
                                    ?>   
                                            <td align='right'><font color='black'><?php echo $lb.'%'; ?></font></td>
                                    <?php
                                       }
                                    ?>      
                                       <td align='right'><?php echo number_format($preco_fabr,2,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($preco_max,2,',','.'); ?></td>
                                       <td align='right'><?php echo number_format($desconto,2,',','.').'%'; ?></td>
                                       <td align='right'><?php echo number_format($preco_de_venda_medio,2,',','.'); ?></td>
                                    </tr>                                        
                            <?php
                               }
                            } 
                            ?>
                                
                    </tbody>
                </table>
             
        </div>            
</font>
    </div>
                
</div>