404

D7net
:/ var / www / html / rosario / adm / app / gre / Views / Trade /
Filename : VieTradeRebateApuraListar.php
back
<?php
if (!defined('URL')) {
    header("Location: /");
    exit();
}
//echo '<pre>';
//var_dump($this->Dados['select'][0]);
//echo '</pre>';
?>
<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">TRADE - Lista Rebate Apurado</h2>
            </div>
            <?php
            if ($this->Dados['botao']['vol_rebate']) {
            ?>
                <a href="<?php echo URLADM . 'con-trade-rebate-apura/listar'; ?>">
                    <div class="p-2">
                        <button class="btn btn-outline-primary btn-sm">
                            Voltar
                        </button>
                    </div>
                </a>
            <?php
            }
            ?>
        </div>
        <?php
            if (empty($this->Dados['select'])) {
        ?>
            <div class="alert alert-danger" role="alert">
                Nenhuma Contrato de Rebate encontrado!
                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <?php
            }
            if (isset($_SESSION['msg'])) {
                echo $_SESSION['msg'];
                unset($_SESSION['msg']);
             }
            ?>
        <div class="table-responsive">
            <font size='2' >    
            <table id="example-crm" class="datatable-idoso-gre stripe " cellspacing="0"
  width="100%" >
                <thead>
            <?php
                if(isset($this->Dados['select'][0]['contratante_sel'])) {
            ?>
                  <tr>
                        <th colspan='11'><?php echo 'Mês/Ano: '.$this->Dados['select'][0]['anomes_m'] ?></th>
                    </tr>
                    <tr>
                        <th>Fornecedor</th>
                        <th>Bruto</th>
                        <th >S.T.</th>
                        <th>Devol.</th>
                        <th>Compra Liquida</th>
                        <th>Descarte</th>
                        <th>Ajuste</th>
                        <th>Base Rebate</th>
                        <th>Perc Rebate</th>
                        <th>Valor Rebate</th>
                        <th>Perc s/Compras</th> 
                    </tr>    
            <?php
                }else{

                    if ($this->Dados['select'][0]['tipo_contratante'] <> 0) {
                ?>    
                    <tr>
                        <th colspan='11'><?php echo $this->Dados['select'][0]['distr_nome'] ?></th>
                    </tr>
                <?php
                    }
                ?>       
                    <tr>
                    <?php
                        if ($this->Dados['select'][0]['tipo_contratante'] == 0) {
                    ?>
                        <th>#ID</th>
                        <th>Contratante</th>
			<th>Data Início</th>
                        <th>Data Fim</th>
                        <th>Tipo Pagamento</th>
                        <th>Total da Meta</th>
                        <th>Status</th>
                        <th class="text-center">Ações</th>
                    <?php
                        }else{
                    ?>    
                         <th>Mes/Ano</th>
                        <th>Bruto</th>
                        <th >S.T.</th>
                        <th>Devol.</th>
                        <th>Compra Liquida</th>
                        <th>Descarte</th>
                        <th>Ajuste</th>
                        <th>Base Rebate</th>
                        <th>Perc Rebate</th>
                        <th>Valor Rebate</th>
                        <th>Perc s/Compras</th> 
                    <?php
                    
                        
                    }
                }
                    $a_valor_bruto_i =0;
                    $a_valor_st_i =0;
                    $a_valor_liquido_i =0;
                    $a_valor_devolucao_i =0;
                    $a_valor_descarte_i = 0;
                    $a_valor_ajuste_i =0;
                    $a_base_rebate_i =0;
                    $a_valor_rebate_i=0;
                ?>     
                    </tr>
                </thead>
                <tbody>
                    <?php
                    foreach ($this->Dados['select'] as $meta) {
                        extract($meta);
                    ?>
                    <tr>
                    <?php
                        if ($tipo_contratante == 0) { 
                    ?>    
                            <th><?php echo $id; ?></th>
                            <td><?php echo $marca_nome;?></td>
                            <td><?php echo $data_inicio_m;?></td>
                            <td><?php echo $data_fim_m;?></td>
                            <td><?php echo $tipo_nome;?></td>
                            <td><?php echo 'R$ '.$valor;?></td>
			    <td class="d-none d-lg-table-cell">
                                <span class="badge badge-<?php echo $cor_cr; ?>"><?php echo $nome_stat; ?></span>
                            </td>
                    <?php
                    }else{ 
                            if(!isset($contratante_sel)){
                    ?>
                            <td align='center'>
                             <?php     
                             echo "<a class='dropdown-item ' href=  " . URLADM . "con-trade-rebate-apura/listar/?tipo=C&anomes=$anomes&fornecedor_id=$fornecedor_id&tipo_contratante=$tipo_contratante&status_id=$status_id'><font color='blue' style='text-decoration: underline;'><b>$anomes_m</font></b></a>";
                             ?>
                            </td>  
                        <?php
                            }else{
                        ?>
                            <td align='left'><?php echo $distr_nome;?></td>
                        <?php
                            }
                        ?>    
                             <td align='right'><?php echo $valor_bruto;?></td>
                            <td align='right'><?php echo $valor_st;?></td>
                            <td align='right'><?php echo $valor_devolucao;?></td>
                            <td align='right'><?php echo $valor_liquido;?></td>
                            <td align='right'><?php echo $valor_descarte;?></td>
                            <td align='right'><?php echo $valor_ajuste;?></td>
                            <td align='right'><?php echo $base_rebate;?></td>
                            <td align='right'><?php echo $perc_rebate.'%';?></td>
                            <td align='right'><?php echo $valor_rebate;?></td>
                            <td align='right'><?php echo $perc_venda.'%';?></td>
                    <?php
                       $a_valor_bruto_i += $valor_bruto_i;
                        $a_valor_st_i += $valor_st_i;
                        $a_valor_liquido_i += $valor_liquido_i;
                        $a_valor_devolucao_i += $valor_devolucao_i;
                        $a_valor_descarte_i += $valor_descarte_i;
                        $a_valor_ajuste_i += $valor_ajuste_i;
                        $a_base_rebate_i += $base_rebate_i;
                        $a_valor_rebate_i += $valor_rebate_i;
                    }
                    ?>    
                    </tr>
                <?php
                }
                ?>
                </tbody>
                <?php
                    if ($tipo_contratante > 0) { 
                ?> 
                    <tfoot>
                        <td align='right' colspan="1"><b>Totais</td>
                        <td align='right'><b><?php echo number_format($a_valor_bruto_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_st_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_devolucao_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_liquido_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_descarte_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_ajuste_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo number_format($a_base_rebate_i ,0,',','.') ?></td>
                        <td align='right'><b><?php echo  number_format(($a_valor_rebate_i *100) /$a_base_rebate_i ,2,',','.').'%' ?></td>
                        <td align='right'><b><?php echo number_format($a_valor_rebate_i ,2,',','.') ?></td>
                        <td align='right'><b><?php echo  number_format(($a_valor_rebate_i *100) /$a_valor_bruto_i ,2,',','.').'%' ?></td>
                    </tfoot>
                <?php
                }
                ?> 
            </table>
            </font>
        </div>
    </div>
</div>
 <!-- Modal -->
<div class="modal fade" id="visuRebateModal" 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">Dados do Contrato</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="visu_Rebate"></span>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Fechar</button>
        </div>
    </div>
  </div>
</div>