Example usage for com.liferay.portal.kernel.dao.search SearchContainer setOrderByCol

List of usage examples for com.liferay.portal.kernel.dao.search SearchContainer setOrderByCol

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.search.*
  5. SearchContainer
  6. setOrderByCol

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.search SearchContainer setOrderByCol.

Prototype

public void setOrderByCol(String orderByCol)

Source Link

Usage

From source file:com.liferay.layout.set.prototype.web.internal.display.context.LayoutSetPrototypeDisplayContext.java

License:Open Source License

public SearchContainer getSearchContainer() {
    ThemeDisplay themeDisplay = (ThemeDisplay) _request.getAttribute(WebKeys.THEME_DISPLAY);

    SearchContainer searchContainer = new SearchContainer(_renderRequest, _renderResponse.createRenderURL(),
            null, "there-are-no-site-templates");

    if (isShowAddButton()) {
        searchContainer.setEmptyResultsMessage("there-are-no-site-templates.-you-can-add-a-site-template-by-"
                + "clicking-the-plus-button-on-the-bottom-right-corner");
        searchContainer.setEmptyResultsMessageCssClass("taglib-empty-result-message-header-has-plus-btn");
    }/*w  w w.  j  a v  a  2s.c o  m*/

    searchContainer.setId("layoutSetPrototype");
    searchContainer.setRowChecker(new EmptyOnClickRowChecker(_renderResponse));

    boolean orderByAsc = false;

    if (getOrderByType().equals("asc")) {
        orderByAsc = true;
    }

    OrderByComparator<LayoutSetPrototype> orderByComparator = new LayoutSetPrototypeCreateDateComparator(
            orderByAsc);

    searchContainer.setOrderByCol(getOrderByCol());
    searchContainer.setOrderByComparator(orderByComparator);
    searchContainer.setOrderByType(getOrderByType());

    searchContainer.setTotal(getTotal());

    List results = LayoutSetPrototypeLocalServiceUtil.search(themeDisplay.getCompanyId(), getActive(),
            searchContainer.getStart(), searchContainer.getEnd(), searchContainer.getOrderByComparator());

    searchContainer.setResults(results);

    return searchContainer;
}

From source file:com.liferay.mobile.device.rules.web.internal.display.context.MDRActionDisplayContext.java

License:Open Source License

public SearchContainer getActionSearchContainer() {
    if (_ruleActionSearchContainer != null) {
        return _ruleActionSearchContainer;
    }/*from  w  w  w .ja  v  a 2s .co m*/

    long ruleGroupInstanceId = getGroupInstanceId();

    SearchContainer ruleActionSearchContainer = new SearchContainer(_request, getPortletURL(), null,
            "no-actions-are-configured-for-this-device-family");

    ruleActionSearchContainer.setOrderByCol(getOrderByCol());

    String orderByType = getOrderByType();

    boolean orderByAsc = orderByType.equals("asc");

    OrderByComparator<MDRAction> orderByComparator = new ActionCreateDateComparator(orderByAsc);

    ruleActionSearchContainer.setOrderByComparator(orderByComparator);

    ruleActionSearchContainer.setOrderByType(orderByType);

    ruleActionSearchContainer.setRowChecker(new EmptyOnClickRowChecker(_response));

    ruleActionSearchContainer.setTotal(MDRActionLocalServiceUtil.getActionsCount(ruleGroupInstanceId));

    ruleActionSearchContainer.setResults(MDRActionLocalServiceUtil.getActions(ruleGroupInstanceId,
            ruleActionSearchContainer.getStart(), ruleActionSearchContainer.getEnd(), orderByComparator));

    _ruleActionSearchContainer = ruleActionSearchContainer;

    return _ruleActionSearchContainer;
}

From source file:com.liferay.site.navigation.admin.web.internal.display.context.SiteNavigationAdminDisplayContext.java

License:Open Source License

public SearchContainer getSearchContainer() throws Exception {
    if (_searchContainer != null) {
        return _searchContainer;
    }//  ww w. jav  a  2s . co m

    ThemeDisplay themeDisplay = (ThemeDisplay) _request.getAttribute(WebKeys.THEME_DISPLAY);

    SearchContainer searchContainer = new SearchContainer(_liferayPortletRequest, getPortletURL(), null,
            "there-are-no-navigation-menus");

    if (Validator.isNull(getKeywords())) {
        if (isShowAddButton()) {
            searchContainer
                    .setEmptyResultsMessageCssClass("there-are-no-navigation-menus-you-can-add-a-menu-by-"
                            + "clicking-the-plus-button-on-the-bottom-right-corner");
            searchContainer.setEmptyResultsMessageCssClass("taglib-empty-result-message-header-has-plus-btn");
        }
    } else {
        searchContainer.setSearch(true);
    }

    OrderByComparator<SiteNavigationMenu> orderByComparator = SiteNavigationMenuPortletUtil
            .getOrderByComparator(getOrderByCol(), getOrderByType());

    searchContainer.setOrderByCol(getOrderByCol());
    searchContainer.setOrderByComparator(orderByComparator);
    searchContainer.setOrderByType(getOrderByType());

    EmptyOnClickRowChecker emptyOnClickRowChecker = new EmptyOnClickRowChecker(_liferayPortletResponse);

    searchContainer.setRowChecker(emptyOnClickRowChecker);

    List<SiteNavigationMenu> menus = null;
    int menusCount = 0;

    if (Validator.isNotNull(getKeywords())) {
        menus = SiteNavigationMenuServiceUtil.getSiteNavigationMenus(themeDisplay.getScopeGroupId(),
                getKeywords(), searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

        menusCount = SiteNavigationMenuServiceUtil.getSiteNavigationMenusCount(themeDisplay.getScopeGroupId(),
                getKeywords());
    } else {
        menus = SiteNavigationMenuServiceUtil.getSiteNavigationMenus(themeDisplay.getScopeGroupId(),
                searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

        menusCount = SiteNavigationMenuServiceUtil.getSiteNavigationMenusCount(themeDisplay.getScopeGroupId());
    }

    searchContainer.setResults(menus);
    searchContainer.setTotal(menusCount);

    _searchContainer = searchContainer;

    return _searchContainer;
}

From source file:com.liferay.site.navigation.item.selector.web.internal.display.context.SiteNavigationItemSelectorViewDisplayContext.java

License:Open Source License

public SearchContainer getSearchContainer() throws Exception {
    if (_searchContainer != null) {
        return _searchContainer;
    }// www  .  j av a2 s  . c o  m

    ThemeDisplay themeDisplay = (ThemeDisplay) _request.getAttribute(WebKeys.THEME_DISPLAY);

    SearchContainer searchContainer = new SearchContainer(_getPortletRequest(), getPortletURL(), null,
            "there-are-no-navigation-menus");

    if (Validator.isNotNull(getKeywords())) {
        searchContainer.setSearch(true);
    }

    OrderByComparator<SiteNavigationMenu> orderByComparator = _getOrderByComparator(getOrderByCol(),
            getOrderByType());

    searchContainer.setOrderByCol(getOrderByCol());
    searchContainer.setOrderByComparator(orderByComparator);
    searchContainer.setOrderByType(getOrderByType());

    EmptyOnClickRowChecker emptyOnClickRowChecker = new EmptyOnClickRowChecker(_getPortletResponse());

    searchContainer.setRowChecker(emptyOnClickRowChecker);

    List<SiteNavigationMenu> menus = null;
    int menusCount = 0;

    if (Validator.isNotNull(getKeywords())) {
        menus = SiteNavigationMenuServiceUtil.getSiteNavigationMenus(themeDisplay.getScopeGroupId(),
                getKeywords(), searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

        menusCount = SiteNavigationMenuServiceUtil.getSiteNavigationMenusCount(themeDisplay.getScopeGroupId(),
                getKeywords());
    } else {
        menus = SiteNavigationMenuServiceUtil.getSiteNavigationMenus(themeDisplay.getScopeGroupId(),
                searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

        menusCount = SiteNavigationMenuServiceUtil.getSiteNavigationMenusCount(themeDisplay.getScopeGroupId());
    }

    searchContainer.setResults(menus);
    searchContainer.setTotal(menusCount);

    _searchContainer = searchContainer;

    return _searchContainer;
}

From source file:org.lsug.quota.portlet.ServerQuotaPortlet.java

License:Open Source License

private void listServerQuotas(RenderRequest renderRequest, RenderResponse renderResponse)
        throws SystemException {

    int cur = ParamUtil.getInteger(renderRequest, "cur", 0);
    int paramDelta = ParamUtil.getInteger(renderRequest, "delta", SearchContainer.DEFAULT_DELTA);
    PortletURL portletURL = renderResponse.createRenderURL();

    // OrderByComparator

    final String orderByCol = ParamUtil.getString(renderRequest, "orderByCol", "quotaUsed");
    final String orderByType = ParamUtil.getString(renderRequest, "orderByType", "desc");
    final OrderByComparator orderByComparator = QuotaUtil.getQuotaOrderByComparator(orderByCol, orderByType);

    SearchContainer<Quota> searchContainer = new SearchContainer<Quota>(renderRequest, null, null,
            SearchContainer.DEFAULT_CUR_PARAM, cur, paramDelta, portletURL, null, null);
    searchContainer.setDelta(paramDelta);
    searchContainer.setDeltaConfigurable(false);
    searchContainer.setOrderByCol(orderByCol);
    searchContainer.setOrderByType(orderByType);
    searchContainer.setOrderByComparator(orderByComparator);

    long classNameId = PortalUtil.getClassNameId(Company.class.getName());
    long listQuotasCount = QuotaLocalServiceUtil.countByClassNameId(classNameId);

    List<Quota> listCompanyQuota = QuotaLocalServiceUtil.getQuotaByClassNameId(classNameId,
            searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

    renderRequest.setAttribute("searchContainer", searchContainer);
    renderRequest.setAttribute("list", listCompanyQuota);
    renderRequest.setAttribute("count", listQuotasCount);
}

From source file:org.lsug.quota.portlet.SitesQuotaPortlet.java

License:Open Source License

@Override
public void doView(RenderRequest renderRequest, RenderResponse renderResponse)
        throws IOException, PortletException {

    // Parametro para identificar la pestaa en la que estamos
    final String tabs2 = ParamUtil.getString(renderRequest, "tabs2", "sites");

    final int cur = ParamUtil.getInteger(renderRequest, "cur", 0);
    final int paramDelta = ParamUtil.getInteger(renderRequest, "delta", SearchContainer.DEFAULT_DELTA);

    // Url del searchContainer
    final PortletURL portletURL = renderResponse.createRenderURL();
    portletURL.setParameter("tabs2", tabs2);

    // OrderByComparator
    final String orderByCol = ParamUtil.getString(renderRequest, "orderByCol", "quotaUsed");
    final String orderByType = ParamUtil.getString(renderRequest, "orderByType", "desc");
    final OrderByComparator orderByComparator = QuotaUtil.getQuotaOrderByComparator(orderByCol, orderByType);

    // Crear searchContainer
    SearchContainer<Quota> searchContainer = new SearchContainer<Quota>(renderRequest, null, null,
            SearchContainer.DEFAULT_CUR_PARAM, cur, paramDelta, portletURL, null, null);
    searchContainer.setDelta(paramDelta);
    searchContainer.setDeltaConfigurable(false);
    searchContainer.setOrderByCol(orderByCol);
    searchContainer.setOrderByType(orderByType);

    try {/* www  . ja v  a 2  s .com*/

        // Identificador instancia de Liferay
        final long companyId = PortalUtil.getCompanyId(renderRequest);

        // Si la pestaa es sites obtenemos los sitios web de una instancia
        if (tabs2.equalsIgnoreCase("sites")) {
            final List<Quota> results = QuotaUtil.getSitesQuotas(companyId, searchContainer.getStart(),
                    searchContainer.getEnd(), orderByComparator);
            final int total = QuotaUtil.getSitesQuotasCount(companyId);

            searchContainer.setResults(results);
            searchContainer.setTotal(total);

        } else if (tabs2.equalsIgnoreCase("user-sites")) {

            // Obtenemos los sitios de usuario de una instancia
            final List<Quota> results = QuotaUtil.getSitesUsersQuotas(companyId, searchContainer.getStart(),
                    searchContainer.getEnd(), orderByComparator);
            final int total = QuotaUtil.getSitesUsersQuotasCount(companyId);

            searchContainer.setResults(results);
            searchContainer.setTotal(total);
        }

    } catch (SystemException e) {
        LOGGER.error(e);
        throw new PortletException(e);
    } catch (PortalException e) {
        LOGGER.error(e);
        throw new PortletException(e);
    }

    renderRequest.setAttribute("tabs2", tabs2);
    renderRequest.setAttribute("searchContainer", searchContainer);

    super.doView(renderRequest, renderResponse);
}

From source file:org.lsug.quota.web.internal.portlet.ServerQuotaWebPortlet.java

License:Open Source License

private void listServerQuotas(RenderRequest renderRequest, RenderResponse renderResponse)
        throws SystemException {

    int cur = ParamUtil.getInteger(renderRequest, "cur", 0);
    int paramDelta = ParamUtil.getInteger(renderRequest, "delta", SearchContainer.DEFAULT_DELTA);
    PortletURL portletURL = renderResponse.createRenderURL();

    // OrderByComparator

    final String orderByCol = ParamUtil.getString(renderRequest, "orderByCol", "quotaUsed");
    final String orderByType = ParamUtil.getString(renderRequest, "orderByType", "desc");
    final OrderByComparator<Quota> orderByComparator = QuotaUtil.getQuotaOrderByComparator(orderByCol,
            orderByType);/*from  ww w  . j a va2  s .  c  om*/

    SearchContainer<Quota> searchContainer = new SearchContainer<Quota>(renderRequest, null, null,
            SearchContainer.DEFAULT_CUR_PARAM, cur, paramDelta, portletURL, null, null);
    searchContainer.setDelta(paramDelta);
    searchContainer.setDeltaConfigurable(false);
    searchContainer.setOrderByCol(orderByCol);
    searchContainer.setOrderByType(orderByType);
    searchContainer.setOrderByComparator(orderByComparator);

    long classNameId = PortalUtil.getClassNameId(Company.class.getName());
    long listQuotasCount = _quotaLocalService.countByClassNameId(classNameId);

    List<Quota> listCompanyQuota = _quotaLocalService.getQuotaByClassNameId(classNameId,
            searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);

    renderRequest.setAttribute("searchContainer", searchContainer);
    renderRequest.setAttribute("list", listCompanyQuota);
    renderRequest.setAttribute("count", listQuotasCount);
}

From source file:org.lsug.quota.web.internal.portlet.SitesQuotaWebPortlet.java

License:Open Source License

@Override
public void doView(RenderRequest renderRequest, RenderResponse renderResponse)
        throws IOException, PortletException {

    // Parametro para identificar la pestaa en la que estamos

    final String tabs2 = ParamUtil.getString(renderRequest, "tabs2", "sites");

    final int cur = ParamUtil.getInteger(renderRequest, "cur", 0);
    final int paramDelta = ParamUtil.getInteger(renderRequest, "delta", SearchContainer.DEFAULT_DELTA);

    // Url del searchContainer

    final PortletURL portletURL = renderResponse.createRenderURL();
    portletURL.setParameter("tabs2", tabs2);

    // OrderByComparator

    final String orderByCol = ParamUtil.getString(renderRequest, "orderByCol", "quotaUsed");
    final String orderByType = ParamUtil.getString(renderRequest, "orderByType", "desc");
    final OrderByComparator<Quota> orderByComparator = QuotaUtil.getQuotaOrderByComparator(orderByCol,
            orderByType);//from   w  w  w .jav a2 s  .c o  m

    // Crear searchContainer

    SearchContainer<Quota> searchContainer = new SearchContainer<Quota>(renderRequest, null, null,
            SearchContainer.DEFAULT_CUR_PARAM, cur, paramDelta, portletURL, null, null);
    searchContainer.setDelta(paramDelta);
    searchContainer.setDeltaConfigurable(false);
    searchContainer.setOrderByCol(orderByCol);
    searchContainer.setOrderByType(orderByType);

    try {

        // Identificador instancia de Liferay

        final long companyId = PortalUtil.getCompanyId(renderRequest);

        int total = 0;
        List<Quota> results = null;

        long[] classNameIds = null;

        // Si la pestaa es sites obtenemos los sitios web de una instancia

        if (tabs2.equalsIgnoreCase("sites")) {
            classNameIds = new long[] { PortalUtil.getClassNameId(Group.class.getName()),
                    PortalUtil.getClassNameId(Organization.class.getName()) };

        } else if (tabs2.equalsIgnoreCase("user-sites")) {
            classNameIds = new long[] { PortalUtil.getClassNameId(User.class.getName()) };
        }

        results = _quotaLocalService.getQuotaByCompanyIdClassNameIds(companyId, classNameIds,
                searchContainer.getStart(), searchContainer.getEnd(), orderByComparator);
        total = _quotaLocalService.countByCompanyIdClassNameIds(companyId, classNameIds);

        searchContainer.setResults(results);
        searchContainer.setTotal(total);

    } catch (SystemException e) {
        LOGGER.error(e);
        throw new PortletException(e);
    }

    renderRequest.setAttribute("tabs2", tabs2);
    renderRequest.setAttribute("searchContainer", searchContainer);

    super.doView(renderRequest, renderResponse);
}