public function indexAction()
{
//
$form = new Application_Form_index();
$form->submit->SetLabel('Login');
$this->view->form = $form;
if ($this->getRequest()->isPost()) {
$formData = $this->getRequest()->getPost();
if ($form->isValid($formData)) {
// $usuario = $form->getValue('usuario');
$password = $form->getValue('password');
$u = new Application_Model_DbTable_Usuario();
$u->login($form->getValue('usuario'), $password);
//IMPORTANT!!!!
//should not always redirect
if ($u) {
if ($u->perfil === 1) {
$this->_helper->redirector('profesor');
} else {
$this->_helper->redirector('estudiante');
}
} else {
echo 'usuario o contraseña incorrecta';
}
} else {
$form->populate($formData);
}
}
}
/**
* Informa o Adaptador Atual
* @param string $username Nome do Usuário
* @param string $password Senha
* @return Zend_Auth_Adapter_Interface Adaptador de Conexão
*/
protected function _getAdapter($username, $password)
{
// Conexão com Banco
$table = new Application_Model_DbTable_Usuario();
// Construção do Adaptador
$adapter = new Zend_Auth_Adapter_DbTable($table->getAdapter());
$adapter->setIdentityColumn('identidade')->setCredentialColumn('credencial')->setTableName($table->getTableName())->setCredentialTreatment('MD5(?)');
// Somente Usuários Ativos
$adapter->getDbSelect()->where('ativado = ?', true);
// Valores
$adapter->setIdentity($username)->setCredential($password);
// Resultado da Construção
return $adapter;
}
public function delete($idUsuario)
{
$dbTableUsuario = new Application_Model_DbTable_Usuario();
$dadosUsuario = array('tu_deletado' => TRUE);
$whereUsuario = $dbTableUsuario->getAdapter()->quoteInto('"tu_id" = ?', $idUsuario);
$dbTableUsuario->update($dadosUsuario, $whereUsuario);
}
public function updateDadosConfidenciaisAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
header('Cache-Control: no-cache');
header('Content-type: application/json; charset="utf-8" ', true);
$request = $this->getRequest();
if ($request->isPost()) {
try {
$user = new Application_Model_DbTable_Usuario();
$usuarioSession = Zend_Auth::getInstance()->getIdentity();
$where = $user->getAdapter()->quoteInto('id_usuario = ?', (int) $usuarioSession->getId());
if ($request->getParam('email', false)) {
if ((int) $request->getParam('email') == 1) {
$conf = 0;
} else {
$conf = 1;
}
$data = array('email_confidencial' => $conf);
$user->update($data, $where);
echo "1";
} elseif ($request->getParam('endereco', false)) {
if ((int) $request->getParam('endereco') == 1) {
$conf = 0;
} else {
$conf = 1;
}
$data = array('endereco_confidencial' => $conf);
$user->update($data, $where);
echo "1";
} elseif ($request->getParam('tel', false)) {
if ((int) $request->getParam('tel') == 1) {
$conf = 0;
} else {
$conf = 1;
}
$data = array('telefone_confidencial' => $conf);
$user->update($data, $where);
echo "1";
} else {
echo "0";
}
} catch (Exception $e) {
echo $e->getMessage();
}
} else {
echo "0";
}
}
public function newOngAction()
{
$this->_helper->layout->disableLayout();
$this->_helper->viewRenderer->setNoRender();
header('Cache-Control: no-cache');
header('Content-type: application/json; charset="utf-8"', true);
$request = $this->getRequest();
if ($request->isPost()) {
try {
/*
* Array usuario
* Insere um novo usuario
*/
$user = new Application_Model_DbTable_Usuario();
$userLogin = new Application_Model_DbTable_UsuarioLogin();
$usuarioOng = new Application_Model_DbTable_UsuarioOng();
if ($userLogin->checkEmail($request->getParam('email'))) {
if ($userLogin->checkUnique('login', $request->getParam('login'))) {
//if($user->checkUnique('cpf_cnpj', $request->getParam('cnpj'))){
$data = array('nome' => $request->getParam('nome'), 'sobrenome' => $request->getParam('sobrenome'), 'cpf_cnpj' => NULL, 'tipo' => '1', 'status' => '1', 'create_at' => date("Y-m-d H:i:s"), 'endereco_confidencial' => '1', 'email_confidencial' => '1', 'telefone_confidencial' => '1', 'notificacoes_email' => '1');
$userId = $user->insert($data);
$data = array('id_usuario' => $userId, 'login' => $request->getParam('login'), 'email' => $request->getParam('email'), 'senha' => sha1($request->getParam('senha')));
$userLogin->insert($data);
$data = array('id_usuario' => $userId, 'nome_fantasia' => $request->getParam('fantasia'), 'razo_social' => $request->getParam('razao'), 'desc_ong' => NULL, 'site' => NULL, 'endereco' => NULL, 'complemento' => NULL, 'bairro' => NULL, 'cep' => NULL, 'id_cidade' => $request->getParam('cidade'), 'id_pais' => '76');
$usuarioOng->insert($data);
$login = $request->getParam('login');
$senha = $request->getParam('senha');
try {
Application_Model_Auth::login($login, $senha);
} catch (Exception $e) {
echo $e->getMessage();
}
echo $this->view->json(2);
/*}
else{
echo $this->view->json(5);
}*/
} else {
echo $this->view->json(4);
}
//fim login
} else {
echo $this->view->json(3);
}
} catch (Exception $e) {
echo $e->getMessage();
}
}
}
public function getUsuariosProdutor()
{
$usuario = new Application_Model_DbTable_Usuario();
return $usuario->getAdapter()->fetchPairs($usuario->select()->from('usuario', array('id_usuario', 'nome'))->where('fk_perfil =2')->order('nome'));
}
public function deleteAction()
{
$this->logger->log('Mensagem debug', Zend_Log::DEBUG);
$dbUsuario = new Application_Model_DbTable_Usuario();
$this->view->lista = $dbUsuario->fetchAll();
}
