404

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

namespace App\gre\Models;

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

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

    private $Resultado;
    private $PageId;
  
    
   
    public function listResidEstLanc( $Dados = null)
    {
             $this->Dados = filter_input_array(INPUT_GET, FILTER_DEFAULT);
        $listResidListEstLanc = new \App\adms\Models\helper\AdmsRead();
        $listResidListEstLanc->fullRead("SELECT	mov.id id,
                                                resid.id resid_id,
                                                resid.nome resid_nome,
						resid.gre_filial_id filial_id,
                                                DATE_FORMAT(mov.data,'%d/%m/%Y')  data,
						DATE_FORMAT(mov.data,'%H:%i:%s')  hora,
						mov.descricao,
						
						FORMAT(abs(mov.qtde), 0, 'de_DE') qtde,
						FORMAT(mov.valor_total, 2, 'de_DE') valor_total,
                                                usu.usuario
                                                   FROM gre_serv_mov_residente mov
                                                   join gre_residente resid
                                                     on resid.id = mov.gre_residente_id
                                                   
                                                   
                                                   join adms_usuarios usu
                                                     on usu.id = mov.gre_usuario_id
                                                   
                                                  WHERE mov.gre_residente_id = :resid_id
                                                    and mov.gre_status_id = 1
                                                  order by mov.data DESC", "&resid_id={$this->Dados['id']}");
        $this->Resultado = $listResidListEstLanc->getResultado();
        return $this->Resultado;
    }
}