import {} from 'express'
import Config from './config'

const env = Config.getEnv()

interface IListOutput<Type> {
    items: Type[], // eslint-disable-line @typescript-eslint/no-explicit-any
    totalItems: number,
    page: number,
    pageSize: number,
    totalPages: number,
    nextURL: string | null
}

interface IPgeInfo {
    page: number,
    pageSize: number
}

class DataQuery {
    private DataModel:any // eslint-disable-line @typescript-eslint/no-explicit-any

    constructor(DataModel:any) { // eslint-disable-line @typescript-eslint/no-explicit-any
        this.DataModel = DataModel
    }

    public static getPageInfoQuery(queries:any):IPgeInfo { // eslint-disable-line @typescript-eslint/no-explicit-any
        return {
            page: queries.page? parseInt(queries.page, 10): 1,
            pageSize: queries.pageSize? parseInt(queries.pageSize, 10): env.DafaultPagination
        }
    }

    public async getItem<Type>(query:any = {}):Promise<Type> { // eslint-disable-line @typescript-eslint/no-explicit-any
        const item = await this.DataModel.findOne(query)
        return item
    }

    public async getItems<Type>(query:any = {}, project:any = {}, options:any = {}):Promise<IListOutput<Type>> { // eslint-disable-line @typescript-eslint/no-explicit-any
        const output:IListOutput<Type> = {
            items: [],
            totalItems: 0,
            page: 0,
            pageSize: 0,
            totalPages: 0,
            nextURL: null
        }

        output.items = await this.DataModel.find(query, project, options)
        output.totalItems = await this.DataModel.find(query).count()

        return output
    }

    public async getItemsByPage<Type>(query:any, project:any, options:any, pageOptions:IPgeInfo):Promise<IListOutput<Type>> { // eslint-disable-line @typescript-eslint/no-explicit-any
        options.skip = (pageOptions.page - 1) * pageOptions.pageSize
        options.limit = pageOptions.pageSize

        const output = await this.getItems<Type>(query, project, options)

        // output.items is already populated correctly
        // output.totalItems is already populated correctly
        output.page = pageOptions.page
        output.pageSize = pageOptions.pageSize
        output.totalPages = Math.ceil(output.totalItems / output.pageSize)
        output.nextURL = output.page < output.totalPages? `page=${ output.page + 1 }&pageSize=${ output.pageSize }`: null

        return output
    }

    public async createItem<Type>(doc:Type):Promise<Type> { // eslint-disable-line @typescript-eslint/no-explicit-any
        const resp = await this.DataModel.create(doc)
        return resp
    }

    public async updateItem<Type>(query:any, doc:any):Promise<Type> { // eslint-disable-line @typescript-eslint/no-explicit-any
        const resp = await this.DataModel.findOneAndUpdate(query, doc, { new: true })
        return resp
    }

    public async deleteItem<Type>(query:any):Promise<Type> { // eslint-disable-line @typescript-eslint/no-explicit-any
        const resp = await this.DataModel.findOneAndDelete(query)
        return resp
    }
}

export {
    IListOutput,
    IPgeInfo
}
export default DataQuery