com.liferay.commerce.pricing.service.persistence.impl.CommercePriceModifierRelFinderImpl Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of com.liferay.commerce.pricing.service
Show all versions of com.liferay.commerce.pricing.service
Liferay Commerce Pricing Service
/**
* SPDX-FileCopyrightText: (c) 2000 Liferay, Inc. https://liferay.com
* SPDX-License-Identifier: LGPL-2.1-or-later OR LicenseRef-Liferay-DXP-EULA-2.0.0-2023-06
*/
package com.liferay.commerce.pricing.service.persistence.impl;
import com.liferay.asset.kernel.model.AssetCategory;
import com.liferay.commerce.price.list.model.CommercePriceList;
import com.liferay.commerce.pricing.model.CommercePriceModifierRel;
import com.liferay.commerce.pricing.model.CommercePricingClass;
import com.liferay.commerce.pricing.model.impl.CommercePriceModifierRelImpl;
import com.liferay.commerce.pricing.service.persistence.CommercePriceModifierRelFinder;
import com.liferay.commerce.product.model.CPDefinition;
import com.liferay.petra.string.StringPool;
import com.liferay.portal.dao.orm.custom.sql.CustomSQL;
import com.liferay.portal.kernel.dao.orm.QueryPos;
import com.liferay.portal.kernel.dao.orm.QueryUtil;
import com.liferay.portal.kernel.dao.orm.SQLQuery;
import com.liferay.portal.kernel.dao.orm.Session;
import com.liferay.portal.kernel.dao.orm.Type;
import com.liferay.portal.kernel.exception.SystemException;
import com.liferay.portal.kernel.security.permission.InlineSQLHelper;
import com.liferay.portal.kernel.util.Portal;
import com.liferay.portal.kernel.util.StringUtil;
import com.liferay.portal.kernel.util.Validator;
import java.util.Iterator;
import java.util.List;
import org.osgi.service.component.annotations.Component;
import org.osgi.service.component.annotations.Reference;
/**
* @author Riccardo Alberti
*/
@Component(service = CommercePriceModifierRelFinder.class)
public class CommercePriceModifierRelFinderImpl
extends CommercePriceModifierRelFinderBaseImpl
implements CommercePriceModifierRelFinder {
public static final String COUNT_CATEGORIES_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".countCategoriesByCommercePriceModifierId";
public static final String
COUNT_CP_DEFINITIONS_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".countCPDefinitionsByCommercePriceModifierId";
public static final String
COUNT_PRICING_CLASSES_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".countPricingClassesByCommercePriceModifierId";
public static final String FIND_CATEGORIES_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".findCategoriesByCommercePriceModifierId";
public static final String
FIND_CP_DEFINITIONS_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".findCPDefinitionsByCommercePriceModifierId";
public static final String
FIND_PRICING_CLASSES_BY_COMMERCE_PRICE_MODIFIER_ID =
CommercePriceModifierRelFinder.class.getName() +
".findPricingClassesByCommercePriceModifierId";
@Override
public int countCategoriesByCommercePriceModifierId(
long commercePriceModifierId, String name) {
return countCategoriesByCommercePriceModifierId(
commercePriceModifierId, name, false);
}
@Override
public int countCategoriesByCommercePriceModifierId(
long commercePriceModifierId, String name, boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String sql = _customSQL.get(
getClass(), COUNT_CATEGORIES_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
String[] keywords = _customSQL.keywords(name, true);
if (Validator.isNotNull(name)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(AssetCategory.name)", StringPool.LIKE, true,
keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(AssetCategory.name) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(commercePriceModifierId);
queryPos.add(_portal.getClassNameId(AssetCategory.class.getName()));
if (Validator.isNotNull(name)) {
queryPos.add(keywords, 2);
}
Iterator iterator = sqlQuery.iterate();
if (iterator.hasNext()) {
Long count = iterator.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Override
public int countCPDefinitionsByCommercePriceModifierId(
long commercePriceModifierId, String name, String languageId) {
return countCPDefinitionsByCommercePriceModifierId(
commercePriceModifierId, name, languageId, false);
}
@Override
public int countCPDefinitionsByCommercePriceModifierId(
long commercePriceModifierId, String name, String languageId,
boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String sql = _customSQL.get(
getClass(), COUNT_CP_DEFINITIONS_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
String[] keywords = _customSQL.keywords(name, true);
if (Validator.isNotNull(name)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(CPDefinitionLocalization.name)",
StringPool.LIKE, true, keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(CPDefinitionLocalization.name) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(languageId);
queryPos.add(commercePriceModifierId);
queryPos.add(_portal.getClassNameId(CPDefinition.class.getName()));
if (Validator.isNotNull(name)) {
queryPos.add(keywords, 2);
}
Iterator iterator = sqlQuery.iterate();
if (iterator.hasNext()) {
Long count = iterator.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Override
public int countPricingClassesByCommercePriceModifierId(
long commercePriceModifierId, String title) {
return countPricingClassesByCommercePriceModifierId(
commercePriceModifierId, title, false);
}
@Override
public int countPricingClassesByCommercePriceModifierId(
long commercePriceModifierId, String title, boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String sql = _customSQL.get(
getClass(),
COUNT_PRICING_CLASSES_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
String[] keywords = _customSQL.keywords(title, true);
if (Validator.isNotNull(title)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(CommercePricingClass.title)", StringPool.LIKE,
true, keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(CommercePricingClass.title) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(commercePriceModifierId);
queryPos.add(
_portal.getClassNameId(CommercePricingClass.class.getName()));
if (Validator.isNotNull(title)) {
queryPos.add(keywords, 2);
}
Iterator iterator = sqlQuery.iterate();
if (iterator.hasNext()) {
Long count = iterator.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Override
public List
findCategoriesByCommercePriceModifierId(
long commercePriceModifierId, String name, int start, int end) {
return findCategoriesByCommercePriceModifierId(
commercePriceModifierId, name, start, end, false);
}
@Override
public List
findCategoriesByCommercePriceModifierId(
long commercePriceModifierId, String name, int start, int end,
boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String[] keywords = _customSQL.keywords(name, true);
String sql = _customSQL.get(
getClass(), FIND_CATEGORIES_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
if (Validator.isNotNull(name)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(AssetCategory.name)", StringPool.LIKE, true,
keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(AssetCategory.name) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addEntity(
CommercePriceModifierRelImpl.TABLE_NAME,
CommercePriceModifierRelImpl.class);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(commercePriceModifierId);
queryPos.add(_portal.getClassNameId(AssetCategory.class.getName()));
if (Validator.isNotNull(name)) {
queryPos.add(keywords, 2);
}
return (List)QueryUtil.list(
sqlQuery, getDialect(), start, end);
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Override
public List
findCPDefinitionsByCommercePriceModifierId(
long commercePriceModifierId, String name, String languageId,
int start, int end) {
return findCPDefinitionsByCommercePriceModifierId(
commercePriceModifierId, name, languageId, start, end, false);
}
@Override
public List
findCPDefinitionsByCommercePriceModifierId(
long commercePriceModifierId, String name, String languageId,
int start, int end, boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String[] keywords = _customSQL.keywords(name, true);
String sql = _customSQL.get(
getClass(), FIND_CP_DEFINITIONS_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
if (Validator.isNotNull(name)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(CPDefinitionLocalization.name)",
StringPool.LIKE, true, keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(CPDefinitionLocalization.name) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addEntity(
CommercePriceModifierRelImpl.TABLE_NAME,
CommercePriceModifierRelImpl.class);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(languageId);
queryPos.add(commercePriceModifierId);
queryPos.add(_portal.getClassNameId(CPDefinition.class.getName()));
if (Validator.isNotNull(name)) {
queryPos.add(keywords, 2);
}
return (List)QueryUtil.list(
sqlQuery, getDialect(), start, end);
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Override
public List
findPricingClassesByCommercePriceModifierId(
long commercePriceModifierId, String title, int start, int end) {
return findPricingClassesByCommercePriceModifierId(
commercePriceModifierId, title, start, end, false);
}
@Override
public List
findPricingClassesByCommercePriceModifierId(
long commercePriceModifierId, String title, int start, int end,
boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String[] keywords = _customSQL.keywords(title, true);
String sql = _customSQL.get(
getClass(), FIND_PRICING_CLASSES_BY_COMMERCE_PRICE_MODIFIER_ID);
if (inlineSQLHelper) {
sql = _inlineSQLHelper.replacePermissionCheck(
sql, CommercePriceList.class.getName(),
"CommercePriceModifier.commercePriceListId", null, null,
new long[] {0}, null);
}
if (Validator.isNotNull(title)) {
sql = _customSQL.replaceKeywords(
sql, "(LOWER(CommercePricingClass.title)", StringPool.LIKE,
true, keywords);
sql = _customSQL.replaceAndOperator(sql, false);
}
else {
sql = StringUtil.removeSubstring(
sql,
" AND (LOWER(CommercePricingClass.title) LIKE ? " +
"[$AND_OR_NULL_CHECK$])");
}
SQLQuery sqlQuery = session.createSynchronizedSQLQuery(sql);
sqlQuery.addEntity(
CommercePriceModifierRelImpl.TABLE_NAME,
CommercePriceModifierRelImpl.class);
QueryPos queryPos = QueryPos.getInstance(sqlQuery);
queryPos.add(commercePriceModifierId);
queryPos.add(
_portal.getClassNameId(CommercePricingClass.class.getName()));
if (Validator.isNotNull(title)) {
queryPos.add(keywords, 2);
}
return (List)QueryUtil.list(
sqlQuery, getDialect(), start, end);
}
catch (Exception exception) {
throw new SystemException(exception);
}
finally {
closeSession(session);
}
}
@Reference
private CustomSQL _customSQL;
@Reference
private InlineSQLHelper _inlineSQLHelper;
@Reference
private Portal _portal;
} © 2015 - 2025 Weber Informatics LLC | Privacy Policy