he426100/hyperf-user-relation

hyperf上下级关系组件

3.1.0 2023-12-01 08:04 UTC

Requires

• php: >=8.1
• hyperf/config: ~3.1.0
• hyperf/database: ~3.1.0
• hyperf/db-connection: ~3.1.0

Requires (Dev)

• friendsofphp/php-cs-fixer: ^3.8
• phpstan/phpstan: ^1.9

MIT

• he426100

• hyperf

README

受jtar-hyperf-user-node启发，把自己常用的用户关系实现发出来

Installation

• Request

composer require he426100/hyperf-user-relation

• Publish

php bin/hyperf.php vendor:publish he426100/hyperf-user-relation

用户关系表参考

CREATE TABLE `user_relation`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级ID',
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员ID',
  `level` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '关系等级',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `parent_user_index`(`parent_id`, `user_id`) USING BTREE,
  UNIQUE INDEX `user_level_index`(`user_id`, `level`) USING BTREE,
  INDEX `rds_idx_0`(`user_id`, `parent_id`, `level`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = COMPACT;