404

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

<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">Rupturas</h2>
            </div>
             <div class="p-2">
                <a href="<?php echo URLADM . 'con-ruptura-filial/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-ruptura-filial/listar/?filial_id=' . $this->Dados['select'][0]['filial_id'] . '&data=' . $this->Dados['select'][0]['data_s'] . '&filial_nome=' . $this->Dados['select'][0]['filial_nome'] .'&secao_id=' . $this->Dados['select'][0]['secao_id'] . '&secao_nome=' . $this->Dados['select'][0]['secao_nome'].'&opcao=I'; ?>" 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">
               Nenhuma Curva ABC encontrada!
                <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-4">
             
 <table align="left"  class="table table-bordered table-hover">
                <thead>
            <?php
                if (!empty($this->Dados['select'])) {
            ?>        
                <tr>  
                        <td align='left' colspan="5">Filial:<b><?php echo ' '.$this->Dados['select'][0]['filial_nome']; ?></b></td>
                </tr> 
                    <tr>  
                        <td align='left' colspan="5">Seção:<b><?php echo ' '. 
                         utf8_encode($this->Dados['select'][0]['secao_nome']) ?>
                              </td>
                     </tr> 
                     <tr>  
                        <td align='left' colspan="3">Grupo:<b><?php echo ' '. 
                         utf8_encode($this->Dados['select'][0]['grupo_nome']) ?>
                              </td>
                   
                        <td align='center' colspan="2"><b><?php echo ' '. 
                         utf8_encode($this->Dados['select'][0]['data']) ?>
                              </td>
                    </tr>
                    
                    
            <?php
                }
            ?>                    
            <tr>
                <td class="table-info" align="center" ><b><font color="blue">Curva</b></td> 
                <td class="table-info" align="center" ><b><font color="blue">Itens Total</b></td>         
                <td class="table-info" align="center"><b><font color="blue">Itens Ruptura</b></td> 
                <td class="table-info" align="center"> <b><font color="blue">% Ruptura</b></td> 
                <td  class="table-info" align="center"><b><font color="blue">Perda Projetada</b></td> 
            </tr>
                </thead>
                <tbody>
                    <?php
                    $total_perdas = 0;
                    $total_itens = 0;
                    $total_itens_rup = 0;
                 if (!empty($this->Dados['select'])) {    
                    foreach ($this->Dados['select'] as $lactos) {
                        extract($lactos);
                        
                        ?>
                        <tr>
                            <td align="center" <font color='blue'>
                           <?php     
                             echo "<a class='dropdown-item ' href='" . URLADM . "con-ruptura-produto/listar/?grupo_id=$grupo_id&secao_id=$secao_id&data=$data_s&curva=$curva&filial_id=$filial_id'><font color='blue'><u>$curva</u></font></a>";
                             ?>
                            </td>
                            <td align='right'><?php echo number_format($itens_total,0,',','.'); ?></td>
                            <td align='right'><?php echo number_format($itens_rup,0,',','.'); ?></td>
                            <td align='right'><?php echo number_format($perc_rup,1,',','.').'%'; ?></td>
                            <td align='right'><?php echo 'R$ '.number_format($perda_estimada,0,',','.'); ?></td>
                        </tr>
                        <?php
                      $total_perdas += $perda_estimada;
                      $total_itens +=  $itens_total;
                      $total_itens_rup +=  $itens_rup;
                    }
                 }
                    ?>

                </tbody>
                <tfoot>
                <td class="table-info" align='right'><b><font color="blue">Total</b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($total_itens,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($total_itens_rup,0,',','.') ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format(round(($total_itens_rup*100)/$total_itens,2),1,',','.').'%' ?></b></td>
                <td class="table-info" align='right'><b><font color="blue"><?php echo number_format($total_perdas,0,',','.') ?></b></td>
                </tfoot>
 </table>   
                 <span class="text-danger">* Não considera Desativados ou Compras Suspensas</span>
          </div>
           <div  class="col-sm-0"></div>
          <div  class="col-sm-7">
              
<?php
//var_dump($this->Dados['grafico']);
foreach ( $this->Dados['grafico']as $row){
    $array[$row['Data']] = array(
        'A' => $row['A'],
        'B' => $row['B'],
        'C' => $row['C'],
        'D' => $row['D'],
 );
}

?>
              
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);

      function drawChart() {
          var data = new google.visualization.DataTable();
                data.addColumn('string', 'Data');
                data.addColumn('number', 'A');
                data.addColumn('number', 'B');
                data.addColumn('number', 'C');
                data.addColumn('number', 'D');
      
        <?php 
			foreach($array as $label => $values ) {
				printf( "data.addRow(['{$label}', %s ]);" , implode(',', $values) ) ;
		 	}
		?>
        var options = {
          title:  '<?php echo " $nome / $secao" ?>' ,
          curveType: 'function',
            
          legend: { position: 'bottom' }
        };

        var chart = new google.visualization.LineChart(document.getElementById('area_grafico'));

        chart.draw(data, options);
      }
    </script>
 	<div id="area_grafico"></div>
    </div>
</div>