d8d-vite-starter/src/server/modules/users/user.entity.ts

import { Entity, PrimaryGeneratedColumn, Column, ManyToMany, JoinTable, CreateDateColumn, UpdateDateColumn, OneToMany } from 'typeorm';
import { Role, RoleSchema } from './role.entity';
import { z } from '@hono/zod-openapi';
import { DeleteStatus, DisabledStatus } from '@/share/types';
import { FollowEntity } from '../follows/follow.entity';

@Entity({ name: 'users' })
export class UserEntity {
  @PrimaryGeneratedColumn({ unsigned: true, comment: '用户ID' })
  id!: number;

  @Column({ name: 'username', type: 'varchar', length: 255, unique: true, comment: '用户名' })
  username!: string;

  @Column({ name: 'password', type: 'varchar', length: 255, comment: '密码' })
  password!: string;

  @Column({ name: 'phone', type: 'varchar', length: 255, nullable: true, comment: '手机号' })
  phone!: string | null;

  @Column({ name: 'email', type: 'varchar', length: 255, nullable: true, comment: '邮箱' })
  email!: string | null;

  @Column({ name: 'nickname', type: 'varchar', length: 255, nullable: true, comment: '昵称' })
  nickname!: string | null;

  @Column({ name: 'name', type: 'varchar', length: 255, nullable: true, comment: '真实姓名' })
  name!: string | null;

  @Column({ name: 'avatar', type: 'varchar', length: 255, nullable: true, comment: '头像' })
  avatar!: string | null;

  @Column({ name: 'bio', type: 'text', nullable: true, comment: '个人简介' })
  bio!: string | null;

  @Column({ name: 'location', type: 'varchar', length: 255, nullable: true, comment: '位置' })
  location!: string | null;

  @Column({ name: 'website', type: 'varchar', length: 255, nullable: true, comment: '个人网站' })
  website!: string | null;

  @Column({ name: 'is_disabled', type: 'int', default: DisabledStatus.ENABLED, comment: '是否禁用(0:启用,1:禁用)' })
  isDisabled!: DisabledStatus;

  @Column({ name: 'is_deleted', type: 'int', default: DeleteStatus.NOT_DELETED, comment: '是否删除(0:未删除,1:已删除)' })
  isDeleted!: DeleteStatus;

  @ManyToMany(() => Role)
  @JoinTable()
  roles!: Role[];

  @OneToMany(() => FollowEntity, follow => follow.follower)
  following!: FollowEntity[];

  @OneToMany(() => FollowEntity, follow => follow.following)
  followers!: FollowEntity[];

  @CreateDateColumn({ name: 'created_at', type: 'timestamp' })
  createdAt!: Date;

  @UpdateDateColumn({ name: 'updated_at', type: 'timestamp' })
  updatedAt!: Date;

  constructor(partial?: Partial<UserEntity>) {
    Object.assign(this, partial);
  }

  get followerCount(): number {
    return this.followers?.length || 0;
  }

  get followingCount(): number {
    return this.following?.length || 0;
  }
}

export const UserSchema = z.object({
  id: z.number().int().positive().openapi({ description: '用户ID' }),
  username: z.string().min(3).max(255).openapi({
    example: 'admin',
    description: '用户名，3-255个字符'
  }),
  password: z.string().min(6).max(255).openapi({
    example: 'password123',
    description: '密码，最少6位'
  }),
  phone: z.string().max(255).nullable().openapi({
    example: '13800138000',
    description: '手机号'
  }),
  email: z.string().email().max(255).nullable().openapi({
    example: 'user@example.com',
    description: '邮箱'
  }),
  nickname: z.string().max(255).nullable().openapi({
    example: '昵称',
    description: '用户昵称'
  }),
  name: z.string().max(255).nullable().openapi({
    example: '张三',
    description: '真实姓名'
  }),
  avatar: z.string().max(255).nullable().openapi({
    example: 'https://example.com/avatar.jpg',
    description: '用户头像'
  }),
  bio: z.string().nullable().openapi({
    example: '热爱技术的开发者',
    description: '个人简介'
  }),
  location: z.string().max(255).nullable().openapi({
    example: '北京',
    description: '位置'
  }),
  website: z.string().url().nullable().openapi({
    example: 'https://example.com',
    description: '个人网站'
  }),
  isDisabled: z.number().int().min(0).max(1).default(DisabledStatus.ENABLED).openapi({
    example: DisabledStatus.ENABLED,
    description: '是否禁用(0:启用,1:禁用)'
  }),
  isDeleted: z.number().int().min(0).max(1).default(DeleteStatus.NOT_DELETED).openapi({
    example: DeleteStatus.NOT_DELETED,
    description: '是否删除(0:未删除,1:已删除)'
  }),
  roles: z.array(RoleSchema).optional().openapi({
    example: [
      { id: 1, name: 'admin',description:'管理员', permissions: ['user:create'] ,createdAt: new Date(), updatedAt: new Date() }
    ],
    description: '用户角色列表'
  }),
  followerCount: z.number().int().nonnegative().openapi({
    description: '关注者数量',
    example: 100
  }),
  followingCount: z.number().int().nonnegative().openapi({
    description: '关注的用户数量',
    example: 50
  }),
  createdAt: z.date().openapi({ description: '创建时间' }),
  updatedAt: z.date().openapi({ description: '更新时间' })
});