404

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

namespace App\gre\Models;

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

/**
 * Description of GrsListarFamiliar
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class GreListarFamiliar
{

    private $Dados;
   
    public function listarFamiliar( $Dados = null)
    {
        $this->Dados =  $Dados;
        if(isset($this->Dados['filial_sel'])) {
        if($this->Dados['fam_sel'] == '' AND $this->Dados['resid_sel'] == ''){
            $this->pesquisarFamiliarTodos();
        }else{
            if($this->Dados['fam_sel'] <> '' AND $this->Dados['resid_sel'] <> ''){
                $this->pesquisarFamiliarComp();
        }elseif($this->Dados['fam_sel'] <> ''){
            $this->pesquisarFamiliarName();
        }elseif($this->Dados['resid_sel'] <> ''){
            $this->pesquisarFamiliarResid();
        }}
        return $this->Resultado;
        }
    }
  private function pesquisarFamiliarTodos()
    {
        $listarFamiliar = new \App\adms\Models\helper\AdmsRead();
        $listarFamiliar->fullRead("SELECT fami.id, fami.nome, resid.nome resid_nome,
                :filial_sel filial_sel,
                '' resid_sel,
                '' fam_sel,
                sit.nome nome_sit,
                cr.cor cor_cr
                FROM gre_familiar fami
		INNER JOIN gre_residente resid ON resid.id=fami.gre_residente_id
                INNER JOIN gre_filial filial ON filial.id= resid.gre_filial_id
                inner join gre_empresa empr on empr.id = filial.gre_empr_princ_id
                INNER JOIN adms_sits sit ON sit.id=fami.adms_sit_id
                INNER JOIN adms_cors cr
                  ON cr.id=sit.adms_cor_id
                where empr.id = :empr_id
                  and filial.id =:filial_sel
                  and resid.adms_sit_id = 1
                ORDER BY id" , "filial_sel={$this->Dados['filial_sel']}&empr_id={$_SESSION['id_user']}");
        $this->Resultado = $listarFamiliar->getResultado();

    }   
    private function pesquisarFamiliarComp()
    {
        $listarFamiliar = new \App\adms\Models\helper\AdmsRead();
        $listarFamiliar->fullRead("SELECT fami.id, fami.nome, resid.nome resid_nome,
                :filial_sel filial_sel,
                :resid_sel resid_sel,
                :fam_sel fam_sel,
                sit.nome nome_sit,
                cr.cor cor_cr
                FROM gre_familiar fami
		INNER JOIN gre_residente resid ON resid.id=fami.gre_residente_id
                INNER JOIN adms_sits sit ON sit.id = fami.adms_sit_id
                INNER JOIN adms_cors cr ON cr.id=sit.adms_cor_id
                INNER JOIN gre_filial filial ON filial.id= resid.gre_filial_id
                inner join gre_empresa empr on empr.id = filial.gre_empr_princ_id
                where empr.id = :empr_id
                and filial.id =:filial_sel
                AND (fami.nome LIKE '%' :fam_sel '%' and resid.nome LIKE '%' :resid_sel '%')
                ORDER BY fami.nome", 
                "resid_sel={$this->Dados['resid_sel']}&filial_sel={$this->Dados['filial_sel']}&fam_sel={$this->Dados['fam_sel']}&empr_id={$_SESSION['id_user']}");
        $this->Resultado = $listarFamiliar->getResultado();
       
    }
    
    private function pesquisarFamiliarName()
    {
        $listarFamiliar = new \App\adms\Models\helper\AdmsRead();
        $listarFamiliar->fullRead("SELECT fami.id, fami.nome, resid.nome resid_nome,
                :filial_sel filial_sel,
                :fam_sel fam_sel,
                '' resid_sel,
                sit.nome nome_sit,
                cr.cor cor_cr
                FROM gre_familiar fami
		INNER JOIN gre_residente resid ON resid.id=fami.gre_residente_id
                INNER JOIN gre_filial filial ON filial.id= resid.gre_filial_id
                inner join gre_empresa empr on empr.id = filial.gre_empr_princ_id
                INNER JOIN adms_sits sit ON sit.id=fami.adms_sit_id
                INNER JOIN adms_cors cr ON cr.id=sit.adms_cor_id
                where empr.id = :empr_id
                 and filial.id =:filial_sel
                AND   fami.nome LIKE '%' :fam_sel '%'
                ORDER BY fami.id", "fam_sel={$this->Dados['fam_sel']}&empr_id={$_SESSION['id_user']}&filial_sel={$this->Dados['filial_sel']}");
        $this->Resultado = $listarFamiliar->getResultado();
    
    }
    
    private function pesquisarFamiliarResid()
    {
        $listarFamiliar = new \App\adms\Models\helper\AdmsRead();
        $listarFamiliar->fullRead("SELECT fami.id, fami.nome,resid.nome resid_nome,
                            :filial_sel filial_sel,
                            :resid_sel resid_sel,
                            '' fam_sel,
                            sit.nome nome_sit,
                            cr.cor cor_cr
                FROM gre_familiar fami
 		INNER JOIN gre_residente resid ON resid.id=fami.gre_residente_id
                INNER JOIN gre_filial filial ON filial.id= resid.gre_filial_id
                inner join gre_empresa empr on empr.id = filial.gre_empr_princ_id        
                INNER JOIN adms_sits sit ON sit.id=fami.adms_sit_id
                INNER JOIN adms_cors cr ON cr.id=sit.adms_cor_id
                where empr.id = :empr_id
                  and filial.id =:filial_sel
                AND resid.nome LIKE '%' :resid_sel '%'
                ORDER BY id", "resid_sel={$this->Dados['resid_sel']}&filial_sel={$this->Dados['filial_sel']}&empr_id={$_SESSION['id_user']}");
        $this->Resultado = $listarFamiliar->getResultado();
        
    }
public function listarCadastrar() { 
           $listar = new \App\adms\Models\helper\AdmsRead();  
           if( $_SESSION['filial']==0){

            $listar->fullRead("SELECT filial.id id_filial, 
                                  filial.nome_fantasia nome_filial
                                  FROM gre_filial filial
                                 
                                  where filial.gre_empr_princ_id =". $_SESSION['id_user'] . " ORDER BY filial.id");
           }else{
               
            $listar->fullRead("SELECT filial.id id_filial, 
                                  filial.nome_fantasia nome_filial
                                  FROM gre_filial filial
                                  where filial.gre_empr_princ_id =". $_SESSION['id_user'] . " AND filial.id = ".  $_SESSION['filial']);
            
           }
        $registro['filial'] = $listar->getResultado();          

        
        $this->Resultado = ['filial' => $registro['filial']];
        
        return $this->Resultado;    
        
}
}