<?php

class Log_Model_LogBeneficiariosArquivosStatus extends Agro_Db_Table_Abstract
{
    protected $_name = 'log_beneficiarios_arquivos_status';
    protected $_schema = 'log';
    protected $_primary = 'id';

    public function getDados(int $idBeneficiario)
    {
        $select = $this->select()->setIntegrityCheck(false);
        $select->from(['lbas' => "{$this->_schema}.{$this->_name}"], ['id_usuario_criacao', "to_char(lbas.dt_criacao, 'DD/MM/YYYY HH24:MI:SS') as data_criacao"]);
        $select->join(['u' => 'sistema.usuarios'], 'lbas.id_usuario_criacao = u.id', ['ds_nome_usuario']);
        $select->join(['s' => 'sistema.status'], 'lbas.id_status = s.id', ['cd_status', 'ds_status']);
        $select->where("lbas.id_beneficiario = {$idBeneficiario}");
        $select->order('lbas.dt_criacao desc');

        return $this->fetchAll($select);
    }

    public function save(array $values)
    {
        $Row = $this->createRow();

        $Row->id_beneficiario = $values['id_beneficiario'];
        $Row->id_status = $values['id_status'];

        return $Row->save();
    }
}