404

D7net
:/ var / www / html / rosario / adm / app / gre / Models /
Filename : ModRupFilialListar.php
back
<?php

namespace App\gre\Models;

if (!defined('URL')) {
    header("Location: /");
    exit();
}

/**
 * Description of ModRupFilialListar
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class ModRupFilialListar
{
    private $Resultado;
    private $Dados;
    private $DadoG;
    private $diase;
    
    public function listFilial()
    { 
         $this->Dados = filter_input_array(INPUT_POST, FILTER_DEFAULT);
         $this->DadosG = filter_input_array(INPUT_GET, FILTER_DEFAULT);
        // var_dump($this->DadosG);
         if(isset($this->DadosG['data'])){
           
             $this->Dados['data'] = $this->DadosG['data'];
         }
       // var_dump($this->Dados);
       $this->Dados['filial_id'] = 0;  
       $lerFilial = new \App\adms\Models\helper\AdmsRead();
            if ($this->Dados['filial_id']== 0) {           
                $lerFilial->fullRead("select f.nome, i.*,
                                         (select round((sum(y.rup_t) * 100)/ sum(y.ven_t), 2)
                                            from ro_rup_indice_filial y 
                                            where y.data = :data) perc_total,
                                        (select sum(w.rup_t)
                                            from ro_rup_indice_filial w 
                                            where w.filial_id = i.filial_id
                                            and w.data between concat(date_format(:data, '%Y-%m-'), '01') and :data) 
                                        rup_acum,
                                        date_format(i.data, '%d/%m/%Y') datav
                                     from ro_rup_indice_filial i
                                        inner join ro_filial f
                                        on f.id = i.filial_id
                                        
                                       where i.data = :data
                                       and f.situacao_id = 1
                                       order by perc_t desc",
                                       "data=".$this->Dados['data']);
            }else{
                 $lerFilial->fullRead("select f.nome filial_nome,i.*,
                                        (select sum(w.rup_t)
                                            from ro_rup_indice_filial w 
                                            where w.filial_id = i.filial_id
                                            and w.data between concat(date_format(:data, '%Y-%m-'), '01') and :data) 
                                        rup_acum,
                                        date_format(i.data, '%d/%m/%Y') datav
                                     from ro_rup_indice_filial i
                                        inner join ro_filial f
                                        on f.id = i.filial_id
                                       
                                       where i.data = :data
                                         and f.situacao_id = 1
                                         and i.filial_id = :filial_id
                                       order by perc_t desc",
                                       "data=".$this->Dados['data']."&filial_id=".$this->Dados['filial_id']);
            }    
       
        $this->Resultado=  $lerFilial->getResultado();
        if(!empty($this->Resultado)) {
            $this->Resultado[0]['filial_sel'] = $this->Dados['filial_id'];
            $this->Resultado[0]['filial_sel'] =$this->Dados['filial_id'];
        }
        //var_dump($this->Resultado);
        return $this->Resultado;
    }
}