public function repExemploCSV()
{
$usuario = new models\Usuario();
$this->data->result = $usuario->listExemploCSV()->asQuery()->getResult();
if ($this->data->result) {
$this->renderWindow();
} else {
$this->renderPrompt('error', 'Nenhum registro encontrado.');
}
}
public function lookupUsuario()
{
$model = new models\Usuario();
$filter->login = $this->data->filter0;
$filter->idUsuario = $this->data->filter1;
$this->data->options = $model->listAll()->asQuery()->chunkResult();
$this->data->query = $model->listByFilter($filter)->asQuery();
$this->render();
}
public function sql()
{
// consultas usando SQL
$usuario = new models\Usuario();
// consulta usando select
$usuario->query();
// comandos DML
$usuario->command();
$this->render();
}
public function ajaxGrid()
{
$object = new models\Usuario();
$this->data->query = $object->listBySetor($this->data->id)->asQuery();
$this->render();
}
