?? ????:

??? ?? ?? ??:

• ???? ?? ????: https://your-url?sort[first_name]=desc&sort[last_name]=asc
• ???? ?? ???? ??: https://your-url?sort[first_name]=ascending&sort[last_name]=descending
• 1 ?? -1 ??: https://your-url?sort[first_name]=1&sort[last_name]=-1

? ??? sortBy ? sortOrder ??? ??? ??? ?????. https://your-url?sortOrder=desc&sortBy=last_name

TypeScript ??:

type ISortOrder = "asc" | "desc" | "ascending" | "descending" | 1 | -1;

export interface IPaginationFields {
    page?: number;
    limit?: number;
    sortBy?: string | string[];
    sortOrder?: ISortOrder | ISortOrder[];
    sort?: Record<string, ISortOrder>;
}

export interface IFormatedPagination {
    skip: number;
    page: number;
    limit: number;
    sort: { [key: string]: 1 | -1 };
}

export const formatPagination = (pagination: IPaginationFields): IFormatedPagination => {
    const { limit = 10, page = 1, sortBy, sortOrder, sort } = pagination;

    const formattedSort: { [key: string]: 1 | -1 } = {};

    const normalizeOrder = (order: string | number): 1 | -1 => {
        const numOrder = Number(order);
        if (!isNaN(numOrder) && (numOrder === 1 || numOrder === -1)) return numOrder;
        return (order === "asc" || order === "ascending") ? 1 : -1;
    };

    if (sortBy) {
        const sortByArray = Array.isArray(sortBy) ? sortBy : [sortBy];
        const sortOrderArray = Array.isArray(sortOrder) ? sortOrder : [sortOrder];
        sortByArray.forEach((field, index) => {
            formattedSort[field] = normalizeOrder(sortOrderArray[index]);
        });
    }

    if (sort && typeof sort === 'object' && !Array.isArray(sort)) {
        Object.entries(sort).forEach(([field, order]) => {
            formattedSort[field] = normalizeOrder(order);
        });
    }

    if (!formattedSort.createdAt) {
        formattedSort.createdAt = -1;
    }

    return {
        skip: (page - 1) * limit,
        limit: limit,
        page: page,
        sort: formattedSort,
    };
};

?????? ??:

const formatPagination = (pagination) => {
    const { limit = 10, page = 1, sortBy, sortOrder, sort } = pagination;

    const formattedSort = {};

    const normalizeOrder = (order) => {
        const numOrder = Number(order);
        if (!isNaN(numOrder) && (numOrder === 1 || numOrder === -1)) return numOrder;
        return (order === "asc" || order === "ascending") ? 1 : -1;
    };

    if (sortBy) {
        const sortByArray = Array.isArray(sortBy) ? sortBy : [sortBy];
        const sortOrderArray = Array.isArray(sortOrder) ? sortOrder : [sortOrder];
        sortByArray.forEach((field, index) => {
            formattedSort[field] = normalizeOrder(sortOrderArray[index]);
        });
    }

    if (sort && typeof sort === 'object' && !Array.isArray(sort)) {
        Object.entries(sort).forEach(([field, order]) => {
            formattedSort[field] = normalizeOrder(order);
        });
    }

    if (!formattedSort.createdAt) {
        formattedSort.createdAt = -1;
    }

    return {
        skip: (page - 1) * limit,
        limit: limit,
        page: page,
        sort: formattedSort,
    };
};

??

? ??? ??? ? ?? ??? ?? ??????? ??? ??? ??? ?????? ?? ?? ?? ??? ?? ??? ??? ??? ????? ?? ???? ??? ?????. ? ????? ??? ? ?? ????? ????? ? ??? ???.

?? ??

?????

ISortOrder: ?? ??? ???? ??? ?: "asc", "desc", "ascending", "descending", 1, -1.

IPaginationFields: ??? ? ??? ???? ?? ??: page(?? ??), limit(?? ??), sortBy(?? ??), sortOrder(?? ??), sort(?? ??).

IFormatedPagination: ???? ??? ??? ?? ??? ?????: skip, page, limit, sort.

formatPagination ??

??? ??? ??? ??? ???? ???? ???? ???? ?????.

????

• pagination: IPaginationFields ?????? ???? ?????.

??

• ???: limit(10), page(1)? ???? ?????. ??? ??? ?? ??? ????? ? ?? formattedSort? ??????.

• ??? ??: normalizeOrder: ??? ?? ??(?)? ?? ??(1 ?? -1)?? ?????.

• ? sortBy ? sortOrder? ?????. sortBy ? sortOrder? ?? ?? ?? ?? ??? ???? ?? ??? ????(?? ??? ?? ??) normalizeOrder? ?????. formattedSort

• ? sort ??? ????? : sort? ??(?? ??)? ?? ?? ?? ???? normalizeOrder? ???? ? ?? ?? ?? ??? ?????. formattedSort? ?????.

• ?? ?? ??: formattedSort? createdAt ??? ??? ?? ???? ?? ??? ????(-1)?? ?????.

• ?? ??: skip, limit, page, sort ??? ?????? ??? ?????.

type ISortOrder = "asc" | "desc" | "ascending" | "descending" | 1 | -1;

export interface IPaginationFields {
    page?: number;
    limit?: number;
    sortBy?: string | string[];
    sortOrder?: ISortOrder | ISortOrder[];
    sort?: Record<string, ISortOrder>;
}

export interface IFormatedPagination {
    skip: number;
    page: number;
    limit: number;
    sort: { [key: string]: 1 | -1 };
}

export const formatPagination = (pagination: IPaginationFields): IFormatedPagination => {
    const { limit = 10, page = 1, sortBy, sortOrder, sort } = pagination;

    const formattedSort: { [key: string]: 1 | -1 } = {};

    const normalizeOrder = (order: string | number): 1 | -1 => {
        const numOrder = Number(order);
        if (!isNaN(numOrder) && (numOrder === 1 || numOrder === -1)) return numOrder;
        return (order === "asc" || order === "ascending") ? 1 : -1;
    };

    if (sortBy) {
        const sortByArray = Array.isArray(sortBy) ? sortBy : [sortBy];
        const sortOrderArray = Array.isArray(sortOrder) ? sortOrder : [sortOrder];
        sortByArray.forEach((field, index) => {
            formattedSort[field] = normalizeOrder(sortOrderArray[index]);
        });
    }

    if (sort && typeof sort === 'object' && !Array.isArray(sort)) {
        Object.entries(sort).forEach(([field, order]) => {
            formattedSort[field] = normalizeOrder(order);
        });
    }

    if (!formattedSort.createdAt) {
        formattedSort.createdAt = -1;
    }

    return {
        skip: (page - 1) * limit,
        limit: limit,
        page: page,
        sort: formattedSort,
    };
};

?? ??

• ??? ??: sortBy ? sortOrder? ?? ? ?? ?? ?????.
• ???: ??? ???? ???? ??? ??? ??? ????? ???.
• ?? ??: ?? ?? ??? ?????(createdAt).
• ??? ?? ??: sort ??? ???? ??? ?? ????? ?????. ? ????? REST API ?? ?????? ??? ?? ???? ??? ? ??? ??? ??????? ??????.

? ??? ??? ? ??? ??? ??? ?? ???? ???? ???? ??? ???? ???? ??????.

? ??? ??? ???? ?? ?? ?? ??? ?? ?? ?? ??(API ??? ??)? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!