404

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

namespace App\gre\Models;

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

/**
 * Description of GreLerFatura
 *
 * @copyright (c) year, Carlos Marques - CM
 */
class GreLerFamiliar
{
    private $Resultado;
    private $Dados;
    
    public function lerFam($Resid = null)
    { 
       $this->Dados = $Resid;
     //   var_dump($this->Dados);
       
         $verFami = new \App\adms\Models\helper\AdmsRead();
        $verFami->fullRead("SELECT fami.nome fami_nome,
                                   MASK(LPAD(fami.telefone_residencial,10,0), '(##) ####-####') fami_telefone_residencial,
                                   MASK(LPAD(fami.telefone_comercial,10,0), '(##) ####-####') fami_telefone_comercial,
                                   MASK(lpad(fami.celular,11,0), '(##) #.####-####') fami_celular, 
                                   fami.email fami_email,
                                   parent.nome fami_parent_nome,
                                   sexo.nome fami_sexo_nome,
                                   sit.nome nome_sit,
                                   cr.cor cor_cr
                                FROM gre_familiar fami
                                 inner join gre_residente r
                                    on r.id = fami.gre_residente_id
				INNER JOIN gre_parentesco parent 
                                   ON parent.id= fami.gre_parentesco_id
                                INNER JOIN gre_sexo sexo 
                                   ON sexo.id= fami.gre_sexo_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 fami.gre_residente_id = :resid_id ",
                           "resid_id=".$this->Dados);
        $this->Resultado=  $verFami->getResultado();
        return $this->Resultado;
    }
}