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'; @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: '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[]; @CreateDateColumn({ name: 'created_at', type: 'timestamp' }) createdAt!: Date; @UpdateDateColumn({ name: 'updated_at', type: 'timestamp' }) updatedAt!: Date; constructor(partial?: Partial) { Object.assign(this, partial); } } 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: '用户头像' }), 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: '用户角色列表' }), createdAt: z.date().openapi({ description: '创建时间' }), updatedAt: z.date().openapi({ description: '更新时间' }) });