public function getUsuario($user) { $sql = 'SELECT TOP 1 * FROM usuarios_h2h WHERE usuario = "' . $user . '"'; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosUsuario = array(); $arrayUsuarios = $this->_db->fetchAll($datos); foreach ($arrayUsuarios as $objDB) { $objUser = new usuarioDTO(); $objUser->setUsuario(trim($objDB['usuario'])); $objUser->setClave(trim($objDB['clave'])); $objUser->setNombre(trim($objDB['nombre'])); $objUser->setIdAgen(trim($objDB['id_agen'])); $objetosUsuario[] = $objUser; } return $objetosUsuario; } else { return false; } }
public function getUsuarios($usuario) { $sql = 'SELECT *, (case when fecpass < getdate() then "1" else "0" end) as cambio_pass FROM usuarios U JOIN agenc_na AN ON (AN.id=U.id_agen) WHERE U.clave="' . $usuario . '"'; //echo $sql; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $userArray = $this->_db->fetchAll($datos); $objetosUser = array(); $userObj = new usuarioDTO(); foreach ($userArray as $usdb) { $userObj->setClave(trim($usdb['clave'])); $userObj->setPassword(trim($usdb['pasword'])); $userObj->setCambioPass(trim($usdb['cambio_pass'])); $userObj->setNombre(trim($usdb['nombre'])); $userObj->setCodigo(trim($usdb['codigo'])); $userObj->setDoctoD(trim($usdb['dctod'])); $userObj->setDoctoH(trim($usdb['dctoh'])); $userObj->setAgencia(trim($usdb['agencia'])); $userObj->setIdAgen(trim($usdb['id_agen'])); $userObj->setMarkup(trim($usdb['markup'])); $userObj->setFechaPass(trim($usdb['fecpass'])); $userObj->setDepto(trim($usdb['depto'])); $userObj->setAtipoa(trim($usdb['atipoa'])); $userObj->setRut(trim($usdb['rut'])); $userObj->setEmail(trim($usdb['email'])); $userObj->setEmailOpera(trim($usdb['email_opera'])); $objetosUser[] = $userObj; } return $objetosUser; } else { return false; } }