Software: Apache/2.4.41 (Ubuntu). PHP/8.0.30 

uname -a: Linux apirnd 5.4.0-204-generic #224-Ubuntu SMP Thu Dec 5 13:38:28 UTC 2024 x86_64 

uid=33(www-data) gid=33(www-data) groups=33(www-data) 

Safe-mode: OFF (not secure)

/usr/local/lib/node_modules/strapi/node_modules/strapi-database/lib/queries/   drwxr-xr-x
Free 13.17 GB of 57.97 GB (22.71%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Self remove    Logout    

Viewing file:     paginated-queries.js (1.33 KB)      -rw-r--r--

'use strict';

const _ = require('lodash');

const createPaginatedQuery = ({ fetch, count }) => async (queryParams, ...args) => {
  const params = _.omit(queryParams, ['page', 'pageSize']);
  const pagination = await getPaginationInfos(queryParams, count);

  Object.assign(params, paginationToQueryParams(pagination));

  const results = await fetch(params, ...args);

  return { results, pagination };
};

const createSearchPageQuery = ({ search, countSearch }) =>
  createPaginatedQuery({ fetch: search, count: countSearch });

const createFindPageQuery = ({ find, count }) => createPaginatedQuery({ fetch: find, count });

const getPaginationInfos = async (queryParams, count) => {
  const { page, pageSize, ...params } = withDefaultPagination(queryParams);

  const total = await count(params);

  return {
    page,
    pageSize,
    pageCount: Math.ceil(total / pageSize),
    total,
  };
};

const withDefaultPagination = params => {
  const { page = 1, pageSize = 100, ...rest } = params;

  return {
    page: parseInt(page),
    pageSize: parseInt(pageSize),
    ...rest,
  };
};

const paginationToQueryParams = ({ page, pageSize }) => ({
  _start: Math.max(page - 1, 0) * pageSize,
  _limit: pageSize,
});

module.exports = {
  getPaginationInfos,
  withDefaultPagination,
  createPaginatedQuery,
  createFindPageQuery,
  createSearchPageQuery,
};