<?php
/* * *****************************************************************************
* Instancia a classe usuarios
* ***************************************************************************** */
$usuarios = new Usuarios_model();
$usuarios_alterar = new Usuarios_model();
$banco = new Query_model();
/* * *****************************************************************************
* Preenche os SELETS PADRÃO
* ***************************************************************************** */
$dados = $usuarios->PadraoSelect();
/* * *****************************************************************************
* Verifica se é insert ou update de acordo com e parametro da URL
* ***************************************************************************** */
if ($this->uri->segment(3) == '') {
$dados['bt'] = 'Adicionar';
} else {
//Botão
$dados['bt'] = 'Alterar';
//Prepara a consulta
$banco->SetCampos("*");
$banco->SetTabelas("usuarios");
$banco->SetCondicao("id = '" . $this->uri->segment(3) . "' ");
$banco->SetTipoRetorno('1');
$consulta = $banco->get();
//Seta os valores de tetorno
$usuarios->SetCampo('nome', $consulta->nome);
$usuarios->SetCampo('email', $consulta->email);
$usuarios->SetCampo('cpf', $consulta->cpf);
$usuarios->SetCampo('status', $consulta->status);
$banco->SetCondicao(" id = '" . $this->uri->segment(3) . "' ");
$banco->SetTipoRetorno(1);
$result = $banco->get();
$dados['form']['nome'] = $result->nome;
$dados['form']['email'] = $result->email;
$dados['form']['status'] = $result->status;
}
/* * **************************************************************************
* ****************************************************************************
* ************************************************************************** */
$post = $this->input->post();
if ($post) {
/*
* Passo todos os dados para o modelo
*/
$usu = new Usuarios_model();
$usu->setNome($post['nome']);
$usu->setEmail($post['email']);
$usu->setSatus($post['status']);
$inserir = $usu->insert();
$alterar = $usu->alterar($this->uri->segment(3));
/*
* SE TIVER ID È ALTERA OS VALORES DO BANCO DE DADOS SE APENAS INSERE
*/
if ($this->uri->segment(3) == '') {
$banco = new Query_model();
$banco->exe_tupla($inserir);
} else {
$banco->exe_tupla($alterar);
}
redirect($this->uri->segment(1) . '/todos');
<?php
$banco = new Query_model();
$banco->SetTabelas("usuarios");
$banco->SetCampos("*");
$banco->SetCondicao("");
$banco->SetTipoRetorno(0);
$dados['resultados'] = $banco->get();
if ($this->uri->segment(3) != '' && $this->uri->segment(4) == 'excluir' && $this->uri->segment(5) == '1') {
$usu = new Usuarios_model();
$apagar = $usu->deletar_linha($this->uri->segment(3));
$banco->exe_tupla($apagar);
redirect($this->uri->segment(1) . '/' . $this->uri->segment(2));
}
