public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$nombre = request::getInstance()->getPost(credencialTableClass::getNameField(credencialTableClass::NOMBRE, true));
// $fields = array(
// credencialTableClass::NOMBRE
// );
// $objCreden = credencialTableClass::getAll($fields);
$data = array(credencialTableClass::NOMBRE => $nombre);
credencialTableClass::insert($data);
credencialTableClass::validatCreate($nombre);
session::getInstance()->setSuccess(i18n::__('succesCreate', null, 'default'));
log::register(i18n::__('create'), credencialTableClass::getNameTable());
routing::getInstance()->redirect('usuario', 'indexCredencial');
} else {
log::register(i18n::__('create'), credencialTableClass::getNameTable(), i18n::__('errorCreateBitacora'));
session::getInstance()->setError(i18n::__('errorCreate', null, 'default'));
routing::getInstance()->redirect('usuario', 'indexCredencial');
}
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public static function getNameCredencial($id)
{
try {
$sql = 'SELECT ' . credencialTableClass::NOMBRE . ' AS credencial ' . 'FROM ' . credencialTableClass::getNameTable() . ' ' . 'WHERE ' . credencialTableClass::ID . ' = :1';
$params = array(':id' => $id);
$answer = model::getInstance()->prepare($sql);
$answer->execute($params);
$answer = $answer->fetchAll(PDO::FETCH_OBJ);
return $answer[0]->credencial;
} catch (PDOException $exc) {
throw $exc;
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST') and request::getInstance()->isAjaxRequest()) {
$id = request::getInstance()->getPost(credencialTableClass::getNameField(credencialTableClass::ID, true));
$ids = array(credencialTableClass::ID => $id);
credencialTableClass::delete($ids, true);
$this->arrayAjax = array('code' => 11, 'msg' => 'La eliminacion del registro ha sido exitosa');
$this->defineView('delete', 'credencial', session::getInstance()->getFormatOutput());
log::register(i18n::__('delete'), usuarioTableClass::getNameTable());
session::getInstance()->setSuccess(i18n::__('succesDelete', null, 'animal'));
} else {
log::register(i18n::__('delete'), credencialTableClass::getNameTable(), i18n::__('errorDeleteBitacora'));
session::getInstance()->setError(i18n::__('errorDelete', null, 'animal'));
routing::getInstance()->redirect('usuario', 'indexCredencial');
}
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public static function verifyUser($usuario, $password)
{
try {
$sql = 'SELECT ' . credencialTableClass::getNameField(credencialTableClass::NOMBRE) . ' as credencial,
' . usuarioTableClass::getNameField(usuarioTableClass::USER) . ' as usuario,
' . usuarioTableClass::getNameField(usuarioTableClass::ID) . ' as id_usuario
FROM ' . usuarioTableClass::getNameTable() . ' LEFT JOIN ' . usuarioCredencialTableClass::getNameTable() . ' ON ' . usuarioTableClass::getNameField(usuarioTableClass::ID) . ' = ' . usuarioCredencialTableClass::getNameField(usuarioCredencialTableClass::USUARIO_ID) . '
LEFT JOIN ' . credencialTableClass::getNameTable() . ' ON ' . credencialTableClass::getNameField(credencialTableClass::ID) . ' = ' . usuarioCredencialTableClass::getNameField(usuarioCredencialTableClass::CREDENCIAL_ID) . '
WHERE ' . usuarioTableClass::getNameField(usuarioTableClass::ACTIVED) . ' = :actived
AND ' . usuarioTableClass::getNameField(usuarioTableClass::DELETED_AT) . ' IS NULL
AND ' . credencialTableClass::getNameField(credencialTableClass::DELETED_AT) . ' IS NULL
AND ' . usuarioTableClass::getNameField(usuarioTableClass::USER) . ' = :user
AND ' . usuarioTableClass::getNameField(usuarioTableClass::PASSWORD) . ' = :pass';
$params = array(':user' => $usuario, ':pass' => md5($password), ':actived' => config::getDbDriver() === 'mysql' ? 1 : 't');
$answer = model::getInstance()->prepare($sql);
$answer->execute($params);
$answer = $answer->fetchAll(PDO::FETCH_OBJ);
return count($answer) > 0 ? $answer : false;
} catch (PDOException $exc) {
throw $exc;
}
}
public function execute()
{
try {
if (request::getInstance()->isMethod('POST')) {
$idsToDelete = request::getInstance()->getPost('chk');
foreach ($idsToDelete as $id) {
$ids = array(credencialTableClass::ID => $id);
credencialTableClass::delete($ids, true);
}
log::register(i18n::__('delete'), credencialTableClass::getNameTable());
session::getInstance()->setSuccess(i18n::__('succesDelete'));
routing::getInstance()->redirect('usuario', 'indexCredencial');
} else {
log::register(i18n::__('errorDelete'), credencialTableClass::getNameTable());
session::getInstance()->setError(i18n::__('errorDeleteMasivo'));
routing::getInstance()->redirect('usuario', 'indexCredencial');
}
} catch (PDOException $exc) {
session::getInstance()->setFlash('exc', $exc);
routing::getInstance()->forward('shfSecurity', 'exception');
}
}
public static function getUserAndPassword($ip_address, $hash)
{
try {
$sql = 'SELECT ' . usuarioTableClass::getNameField(usuarioTableClass::ID) . ' AS id_usuario,
' . usuarioTableClass::getNameField(usuarioTableClass::USER) . ' AS usuario,
' . credencialTableClass::getNameField(credencialTableClass::NOMBRE) . ' AS credencial
FROM ' . usuarioTableClass::getNameTable() . ' INNER JOIN ' . recordarMeTableClass::getNameTable() . ' ON ' . usuarioTableClass::getNameField(usuarioTableClass::ID) . ' = ' . recordarMeTableClass::getNameField(recordarMeTableClass::USUARIO_ID) . '
INNER JOIN ' . usuarioCredencialTableClass::getNameTable() . ' ON ' . usuarioTableClass::getNameField(usuarioTableClass::ID) . ' = ' . usuarioCredencialTableClass::getNameField(usuarioCredencialTableClass::USUARIO_ID) . '
INNER JOIN ' . credencialTableClass::getNameTable() . ' ON ' . credencialTableClass::getNameField(credencialTableClass::ID) . ' = ' . usuarioCredencialTableClass::getNameField(usuarioCredencialTableClass::CREDENCIAL_ID) . '
WHERE ' . recordarMeBaseTableClass::getNameField(recordarMeTableClass::IP_ADDRESS) . ' = :ip_address
AND ' . recordarMeBaseTableClass::getNameField(recordarMeTableClass::HASH_COOKIE) . ' = :hash
AND ' . usuarioBaseTableClass::getNameField(usuarioBaseTableClass::DELETED_AT) . ' IS NULL
AND ' . usuarioBaseTableClass::getNameField(usuarioBaseTableClass::ACTIVED) . ' = :actived
AND ' . credencialTableClass::getNameField(credencialTableClass::DELETED_AT) . ' IS NULL';
$params = array(':ip_address' => $ip_address, ':hash' => $hash, ':actived' => config::getDbDriver() === 'mysql' ? 1 : 't');
$answer = model::getInstance()->prepare($sql);
$answer->execute($params);
$answer = $answer->fetchAll(PDO::FETCH_OBJ);
return count($answer) > 0 ? $answer : false;
} catch (PDOException $exc) {
throw $exc;
}
}
