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(); }