Rol.class.php

Ir a la documentación de este archivo.

<?php

class Rol{

        //Administración de Usuarios
        const LISTAR_USUARIOS=1;
        const CREAR_USUARIOS=2;
        const EDITAR_USUARIOS=4;
        const ELIMINAR_USUARIOS=8;

        //Administración de Roles
        const LISTAR_ROLES=16;
        const CREAR_ROLES=32;
        const EDITAR_ROLES=64;
        const ELIMINAR_ROLES=128;

        //Administración de Roles
        const LISTAR_EVALUACIONES=256;
        const CREAR_EVALUACIONES=512;
        const EDITAR_EVALUACIONES=1024;
        const ELIMINAR_EVALUACIONES=2048;

        const LISTAR_INVENTARIOS=4096;
        const CREAR_INVENTARIOS=8192;
        const EDITAR_INVENTARIOS=16384;
        const ELIMINAR_INVENTARIOS=32768;

        //Tipos de Estatus
        const ESTATUS_ACTIVO=1;
        const ESTATUS_INACTIVO=2;

        protected $rol_id;
        protected $rol_nombre;
        protected $rol_descripcion;
        protected $rol_status = 1;
        protected $rol_permisos = 0;

        function __construct( $id=NULL ){

                if( $id != NULL )
                        $this->getRol( array( 
                                'where' => 'rol_id = :id',
                                'data'=> array(
                                        ':id'=>$id
                                )
                        ));

        }

        private function limpiar(  ){
                foreach( get_object_vars($this) as $name => $value )
                        switch( $name ){
                                case 'rol_usu_status': $this->{$name} = 1; break;
                                case 'rol_usu_permisos': $this->{$name} = 0; break;
                                default: $this->{$name} = NULL; break;
                        }
        }

        public function getRol( $data ){

                $this->limpiar();

                try{

                        $db = Database::getInstance(  );

                        $attr  = get_object_vars($this);

                        $query = 'SELECT '.implode( array_keys( $attr ), ', ' ).' FROM roles 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;

                        return true;
                }catch( PDOException $e ){
                        unset($consulta);
                        throw new Exception( $e->getMessage(  ) , $e->getCode(  ) );
                }
        }

        public function getRolPorId( $id ){
                return $this->getRol( array( 
                        'where' => 'rol_id = :id',
                        'data'=> array(
                                ':id'=>$id
                        )
                ));
        }

        public function getRolPorNombre( $nombre ){
                return $this->getRol( array( 
                        'where' => 'rol_nombre = :nombre',
                        'data'=> array(
                                ':nombre'=>$nombre
                        )
                ));
        }

        public function guardar(  ){

                $data = array(  );

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

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

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

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

                }else{

                        foreach( get_object_vars($this) as $name => $val )
                                if( !is_null( $val ) && $name != 'rol_id' ){
                                        array_push( $field,"{$name}=:{$name}" );
                                        $data[':'.$name]=$val;
                                }

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

                        $query = 'UPDATE roles SET '.implode( $field, ', ' ).' WHERE rol_id = :rol_id';

                }

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

                if( !$this->getId(  ) ) $this->getRolPorId( Database::lastInsertId( 'roles_seq' ) );
        }

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

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

                $this->limpiar(  );

                return $rt ? $rt : 0;
        }

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

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

        public function setNombre( $val ){ $this->rol_nombre = $val; }
        
        public function getNombre(  ){ return $this->rol_nombre; }

        public function setDescripcion( $val ){ $this->rol_descripcion = $val; }

        public function getDescripcion(  ){ return $this->rol_descripcion; }

        public function setPermisos( $val ){ $this->rol_permisos = $val; }

        public function getPermisos(  ){ return $this->rol_permisos; }

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

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

}