Method getChannelsPaginated

server/modules/channelModule.js:1051–1144

* Retrieve channels in a paginated format with optional filtering/sorting * @param {Object} options - Pagination and filtering options * @param {number|string} [options.page=1] - Page number (1-indexed) * @param {number|string} [options.pageSize=50] - Number of items per page * @param {s

({
    page = 1,
    pageSize = 50,
    searchTerm = '',
    sortBy = 'name',
    sortOrder = 'asc',
    subFolder = null,
  } = {})

   * @returns {Promise<{channels: Array, total: number, page: number, pageSize: number, totalPages: number}>}
   */
  async getChannelsPaginated({
    page = 1,
    pageSize = 50,
    searchTerm = '',
    sortBy = 'name',
    sortOrder = 'asc',
    subFolder = null,
  } = {}) {
    const parsedPage = parseInt(page, 10);
    const parsedPageSize = parseInt(pageSize, 10);
    const safePage = Number.isFinite(parsedPage) && parsedPage > 0 ? parsedPage : 1;
    const safePageSize = Number.isFinite(parsedPageSize)
      ? Math.min(Math.max(parsedPageSize, 1), 100)
      : 50;
    const offset = (safePage - 1) * safePageSize;

    const whereClause = { enabled: true };
    const normalizedSearch = typeof searchTerm === 'string' ? searchTerm.trim().toLowerCase() : '';
    if (normalizedSearch) {
      const escapedSearch = normalizedSearch.replace(/[\\%_]/g, '\\$&');
      const likeValue = `%${escapedSearch}%`;
      whereClause[Op.or] = [
        where(fn('LOWER', col('uploader')), { [Op.like]: likeValue }),
        where(fn('LOWER', col('url')), { [Op.like]: likeValue }),
      ];
    }

    const normalizedSubFolder = typeof subFolder === 'string' ? subFolder.trim() : '';
    if (normalizedSubFolder) {
      if (normalizedSubFolder === SUB_FOLDER_DEFAULT_KEY) {
        whereClause.sub_folder = {
          [Op.or]: [null, ''],
        };
      } else {
        whereClause.sub_folder = normalizedSubFolder;
      }
    }

    const sortMap = {
      name: 'uploader',
      uploader: 'uploader',
      createdat: 'createdAt',
    };
    const normalizedSortKey = typeof sortBy === 'string' ? sortBy.toLowerCase() : 'name';
    const sortColumn = sortMap[normalizedSortKey] || 'uploader';
    const direction = typeof sortOrder === 'string' && sortOrder.toLowerCase() === 'desc' ? 'DESC' : 'ASC';

    try {
      const { rows, count } = await Channel.findAndCountAll({
        where: whereClause,
        limit: safePageSize,
        offset,
        order: [[sortColumn, direction]],
      });

      const distinctSubFolders = await Channel.findAll({
        attributes: [[fn('DISTINCT', col('sub_folder')), 'sub_folder']],
        where: { enabled: true },