import type { Context } from 'koa'
import type { IUserModel } from '../model/user'
import { User } from '../model'
import { Paging } from '../dto/base'

export const createOne = async (newOne: IUserModel): Promise<User> => {
  const one = await User.findOne({ where: { username: newOne.username } })
  if (one) {
    global.UnifyResponse.parameterException(10409)
  }
  return await User.create(newOne)
}

export const updateOne = async (newOne: IUserModel): Promise<User> => {
  const one = await User.findByPk(newOne.id)
  if (!one) {
    global.UnifyResponse.notFoundException(10404)
  }
  return await one!.update(newOne)
}

export const getById = async (id: number): Promise<User> => {
  const one = await User.findByPk(id)
  if (!one) {
    global.UnifyResponse.notFoundException(10404)
  }
  return one!
}

export const deleteById = async (id: number): Promise<boolean> => {
  const numDeleted = await User.destroy({ where: { id } })
  return !!numDeleted
}

export const getList = async (): Promise<User[]> => {
  return await User.findAll()
}

export const getPage = async (ctx: Context): Promise<Paging<User>> => {
  const { start, limit } = ctx.validatedQuery
  const offset = (start - 1) * limit
  const pageRel = await User.findAll({ offset, limit })
  const totalRel = (await User.findAll()).length

  return new Paging(pageRel, totalRel, start, limit)
}