ember-table-route.js

import Mixin from '@ember/object/mixin';
import { kebabCase } from 'open-event-frontend/utils/text';

export default Mixin.create({
  queryParams: {
    page: {
      refreshModel: true
    },
    per_page: {
      refreshModel: true
    },
    search: {
      refreshModel: true
    },
    sort_dir: {
      refreshModel: true
    },
    sort_by: {
      refreshModel: true
    }
  },
  per_page: 10,

  applySearchFilters(options, params, searchFields) {
    if (!Array.isArray(searchFields)) {
      searchFields = [searchFields];
    }
    let filters = options;
    if (searchFields.length > 1) {
      filters = [];
      options.pushObject({ or: filters });
    }
    for (let searchField of searchFields) {
      searchField = kebabCase(searchField);
      if (params.search) {
        filters.pushObject({
          name : searchField,
          op   : 'ilike',
          val  : `%${params.search}%`
        });
      } else {
        filters.removeObject({
          name : searchField,
          op   : 'ilike',
          val  : `%${params.search}%`
        });
      }
    }
    return options;
  },

  applySortFilters(query, params) {
    if (params.sort_by) {
      query.sort = (params.sort_dir === 'DSC' ? '-' : '') + params.sort_by;
    } else {
      delete query.sort;
    }
    return query;
  },

  /**
   * Convert the given ArrayProxy or Promise<ArrayProxy> to a native Array.
   *
   * @param promise
   * @return {Promise<Array>}
   */
  async asArray(promise) {
    const resolved = await promise;
    if (resolved.toArray) {
      return {
        data : resolved.toArray(),
        meta : resolved.meta
      };
    }
    return resolved;
  },

  applySearchFiltersExtend(options, params, searchFields) {
    if (!Array.isArray(searchFields)) {
      searchFields = [searchFields];
    }
    let filters = options;
    if (searchFields.length > 1) {
      filters = [];
      options.pushObject({ or: filters });
    }
    for (let searchField of searchFields) {
      const findIndex = searchField.includes('__');
      if (!findIndex) {
        searchField = kebabCase(searchField);
        if (params.search) {
          filters.pushObject({
            name : searchField,
            op   : 'ilike',
            val  : `%${params.search}%`
          });
        } else {
          filters.removeObject({
            name : searchField,
            op   : 'ilike',
            val  : `%${params.search}%`
          });
        }
      } else {
        const splitField = searchField.split('__');
        let condition = 'ilike';
        let value = `%${params.search}%`;
        const specialField = ['price'];
        if (specialField.indexOf(splitField[1]) !== -1) {
          if (isNaN(params.search)) {
            continue;
          }
          condition = params.search && Number(params.search) !== 0 ? 'eq' : 'is_';
          value = params.search && Number(params.search) !== 0 ? params.search : null;
        }
        const filter = {
          name : splitField[0],
          op   : 'has',
          val  : {
            name : splitField[1],
            op   : condition,
            val  : value
          }
        };
        if (params.search) {
          filters.pushObject(filter);
        } else {
          filters.removeObject(filter);
        }
      }
    }
    return options;
  }
});