Usuario.class.php

Ir a la documentación de este archivo.

<?php

class Usuario{

        protected $usu_id;
        protected $usu_nombres;
        protected $usu_apellidos;
        protected $usu_correo_electronico;
        protected $usu_clave;
        protected $usu_rol_id;
        protected $usu_status = 1;

        private $rol_obj;

        function __construct( $id = NULL ){

                $this->rol_obj = new stdClass( );
                $this->rol_obj->nombre = '';
                $this->rol_obj->descripcion = '';
                $this->rol_obj->permisos = 0;
                $this->rol_obj->status = 0;

                if( $id != NULL )
                        $this->getUsuarioPorId( $id );

        }

        private function limpiar(  ){
                foreach( get_object_vars($this) as $name => $value )
                        switch( $name ){
                                case 'rol_obj': 
                                        $this->{$name}->nombre = '';
                                        $this->{$name}->descripcion = '';
                                        $this->{$name}->permisos = 0;
                                        $this->{$name}->status = 0;
                                        break;
                                case 'usu_status': $this->{$name} = 1; break;
                                default: $this->{$name} = NULL; break;
                        }
        }

        public function getUsuario( $data ){

                $this->limpiar(  );

                try{

                        $db = Database::getInstance(  );

                        $attr  = array(  );

                        foreach( get_object_vars($this) as $name => $val )
                                switch( $name ){
                                        case 'rol_obj': break;
                                        default:
                                                array_push( $attr, $name );
                                }

                        $query = 'SELECT '.implode( $attr, ', ' ).' FROM usuarios WHERE '.$data['where'];
                        
                        $consulta = $db->prepare( $query );
                        $consulta->execute( $data['data'] );

                        $resultado = $consulta->fetch( PDO::FETCH_ASSOC );
                        unset( $consulta );

                        
                        if( !$resultado )
                                return false;
                        else
                                foreach( $resultado as $name => $value )
                                        $this->{$name} = $value;

                        $query = 'SELECT rol_nombre, rol_descripcion, rol_permisos, rol_status FROM roles WHERE rol_id = :id';

                        $consulta = $db->prepare( $query );
                        $consulta->execute( array( ':id' => $this->usu_rol_id ) );

                        $resultado = $consulta->fetch( PDO::FETCH_ASSOC );
                        unset( $consulta );

                        if( $resultado ){
                                $this->rol_obj->id = $this->usu_rol_id;
                                $this->rol_obj->nombre = $resultado['rol_nombre'];
                                $this->rol_obj->descripcion = $resultado['rol_descripcion'];
                                $this->rol_obj->permisos = $resultado['rol_permisos'];
                                $this->rol_obj->status = $resultado['rol_status'];
                        }

                        return true;

                }catch( PDOException $e ){ unset($consulta); throw $e; }
        }

        public function getUsuarioPorId( $id ){
                return $this->getUsuario( array( 
                        'where' => 'usu_id = :id',
                        'data'=> array(
                                ':id'=>$id
                        )
                ));
        }

        public function getUsuarioPorCorreoElectronico( $correo ){
                return $this->getUsuario( array( 
                        'where' => 'usu_correo_electronico = :correo',
                        'data'=> array(
                                ':correo'=>$correo
                        )
                ));
        }

        public function getUsuarioPorCredenciales( $correo, $clave ){
                return $this->getUsuario(
                        array(
                                'where' => 'usu_correo_electronico = :correo AND usu_clave = :clave ',
                                'data'  => array(
                                ':correo' => $correo,
                                ':clave' => $clave
                                )
                        )
                );
        }

        public function guardar(  ){

                $data = array(  );

                $field = array(  );
                $value = array(  );

                if( !$this->getId(  ) ){

                        foreach( get_object_vars($this) as $name => $val )
                                if( !is_null( $val ) )
                                        switch( $name ){
                                                case 'usu_id':
                                                case 'rol_obj': break;
                                                default:
                                                        array_push( $field, $name );
                                                        array_push( $value, ':'.$name );
                                                        $data[':'.$name]=$val;
                                        }

                        $query = 'INSERT INTO usuarios ( '.implode( $field, ', ' ).' )VALUES( '.implode( $value, ', ' ).' )';

                }else{

                        foreach( get_object_vars($this) as $name => $val )
                                if( !is_null( $val ) )
                                        switch( $name ){
                                                case 'usu_id':
                                                case 'rol_obj': break;
                                                default:
                                                        array_push( $field,"{$name}=:{$name}" );
                                                        $data[':'.$name]=$val;
                                        }

                        $data[':usu_id']=$this->usu_id;

                        $query = 'UPDATE usuarios SET '.implode( $field, ', ' ).' WHERE usu_id = :usu_id';

                }

                $db = Database::getInstance(  );
                $consulta = $db->prepare( $query );
                $consulta->execute( $data );

                if( !$this->getId(  ) ) $this->getUsuarioPorId( Database::lastInsertId( 'usuarios_seq' ) );

        }

        public function getNombreCompleto(  ){

                $Nombres = $this->usu_nombres;
                $Apellidos = $this->usu_apellidos ? ', '.$this->usu_apellidos : '' ;

                return ucwords( strtolower( "{$Nombres}{$Apellidos}" ) );
        }

        public function eliminar(  ){
                if( !$this->getId(  ) )
                        return 0;

                $db = Database::getInstance(  );
                $rt = $db->exec( 'DELETE FROM usuarios WHERE usu_id = '.$this->getId(  ) );

                $this->limpiar(  );

                return $rt ? $rt : 0;
        }

        public function getId(  ){ return $this->usu_id ? $this->usu_id : NULL; }

        public function setNombres( $val ){ $this->usu_nombres = $val; }

        public function getNombres(  ){ return $this->usu_nombres; }

        public function setApellidos( $val ){ $this->usu_apellidos = $val; }

        public function getApellidos(  ){ return $this->usu_apellidos; }

        public function setCorreoElectronico( $val ){ $this->usu_correo_electronico = $val; }

        public function getCorreoElectronico(  ){ return $this->usu_correo_electronico; }

        public function setRolId( $val ){ $this->usu_rol_id = $val; }

        public function getRolId(  ){ return $this->usu_rol_id; }

        public function getRol(  ){ return $this->rol_obj; }

        public function permite( $val ){ return ( $this->rol_obj->permisos & $val ) == 0 ? false : true ; }

        public function setClave( $val ){ $this->usu_clave = $val; }


        public function cambiarClave( $val ){

                if( !$this->getId(  ) )
                        return false;

                $db = Database::getInstance(  );

                $consulta = $db->prepare( 'UPDATE usuarios SET usu_clave = :clave WHERE usu_id = :id'  );

                $consulta->execute( array( ':id'=>$this->getId(  ), ':clave'=>$val ) );

                if( $consulta->rowCount(  ) == 0 ){
                        unset($consulta);
                        return false;
                }else
                        unset($consulta);
                        return true;

        }

        public function setStatus( $val ){ $this->usu_status = $val; }

        public function getStatus(  ){ return $this->usu_status; }

        public function getTipoDeCuenta(  ){ return 'U'; }

}