404

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

namespace App\cpgre\Models;

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

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

    private $Resultado;
    private $PageId;
    private $PesqTransf;
    private $PesqFilial;
    public function PesqTransf($PesqTransf = null, $PesqFilial = null)
    {
        $this->PesqTransf = (string) $PesqTransf;
        $this->PesqFilial = (int) $PesqFilial;
         
        $listarTransf = new \App\adms\Models\helper\AdmsRead();
        $listarTransf->fullRead("SELECT  resid.id,
                                            resid.gre_filial_id filial_id,
                                            resid.nome resid_nome, 
		                            resid.cpf resid_cpf, 
					    sit.nome nome_sit, 
  					    cr.cor cor_cr
                                       FROM gre_residente resid
                                 
                                 INNER JOIN adms_sits sit ON sit.id=resid.adms_sit_id
                                 INNER JOIN adms_cors cr  ON cr.id=sit.adms_cor_id
                                WHERE resid.nome LIKE  '%' :nome '%' 
                                   and resid.gre_filial_id = :filial_id
                                   and resid.gre_empr_princ_id = :empr_id
                                   and resid.adms_sit_id = 1
                                   ORDER BY resid.nome ","nome=" . $this->PesqTransf . "&empr_id={$_SESSION['id_user']}" . "&filial_id={$this->PesqFilial}" );
        $this->Resultado = $listarTransf->getResultado();
      
        return $this->Resultado;
    }

}