/**
* Copyright (c) 2000-present Liferay, Inc. All rights reserved.
*
* This library is free software; you can redistribute it and/or modify it under
* the terms of the GNU Lesser General Public License as published by the Free
* Software Foundation; either version 2.1 of the License, or (at your option)
* any later version.
*
* This library is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
* details.
*/
package com.liferay.shopping.service.persistence.impl;
import com.liferay.portal.dao.orm.custom.sql.CustomSQLUtil;
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.InlineSQLHelperUtil;
import com.liferay.portal.kernel.util.ArrayUtil;
import com.liferay.portal.kernel.util.OrderByComparator;
import com.liferay.portal.kernel.util.StringBundler;
import com.liferay.portal.kernel.util.StringPool;
import com.liferay.portal.kernel.util.StringUtil;
import com.liferay.shopping.model.ShoppingItem;
import com.liferay.shopping.model.impl.ShoppingItemImpl;
import com.liferay.shopping.service.persistence.ShoppingItemFinder;
import java.util.Iterator;
import java.util.List;
/**
* @author Brian Wing Shun Chan
*/
public class ShoppingItemFinderImpl
extends ShoppingItemFinderBaseImpl implements ShoppingItemFinder {
public static final String COUNT_BY_G_C =
ShoppingItemFinder.class.getName() + ".countByG_C";
@Override
public int countByFeatured(long groupId, long[] categoryIds) {
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT COUNT(*) AS COUNT_VALUE FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("ShoppingItem.featured = ? AND ");
query.append("ShoppingItem.smallImage = ?");
SQLQuery q = session.createSynchronizedSQLQuery(query.toString());
q.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(true);
qPos.add(true);
Iterator<Long> itr = q.iterate();
if (itr.hasNext()) {
Long count = itr.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
@Override
public int countByKeywords(
long groupId, long[] categoryIds, String keywords) {
return countByKeywords(groupId, categoryIds, keywords, null);
}
@Override
public int countByKeywords(
long groupId, long[] categoryIds, String keywords,
OrderByComparator<ShoppingItem> obc) {
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT COUNT(*) AS COUNT_VALUE FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("(ShoppingItem.name LIKE ? OR ");
query.append("ShoppingItem.description LIKE ? OR ");
query.append("ShoppingItem.properties LIKE ?))");
String sql = CustomSQLUtil.replaceOrderBy(query.toString(), obc);
keywords = '%' + keywords + '%';
SQLQuery q = session.createSynchronizedSQLQuery(sql);
q.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(keywords);
qPos.add(keywords);
qPos.add(keywords);
Iterator<Long> itr = q.iterate();
if (itr.hasNext()) {
Long count = itr.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
@Override
public int countBySale(long groupId, long[] categoryIds) {
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT COUNT(*) AS COUNT_VALUE FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("ShoppingItem.sale = ? AND ");
query.append("ShoppingItem.smallImage = ?");
SQLQuery q = session.createSynchronizedSQLQuery(query.toString());
q.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(true);
qPos.add(true);
Iterator<Long> itr = q.iterate();
if (itr.hasNext()) {
Long count = itr.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
@Override
public int countByG_C(long groupId, List<Long> categoryIds) {
return doCountByG_C(groupId, categoryIds, false);
}
@Override
public int filterCountByG_C(long groupId, List<Long> categoryIds) {
return doCountByG_C(groupId, categoryIds, true);
}
@Override
public List<ShoppingItem> findByFeatured(
long groupId, long[] categoryIds, int numOfItems) {
int countByFeatured = countByFeatured(groupId, categoryIds);
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT {ShoppingItem.*} FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("ShoppingItem.featured = ? AND ");
query.append("ShoppingItem.smallImage = ?");
SQLQuery q = session.createSynchronizedSQLQuery(query.toString());
q.addEntity("ShoppingItem", ShoppingItemImpl.class);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(true);
qPos.add(true);
return (List<ShoppingItem>)QueryUtil.randomList(
q, getDialect(), countByFeatured, numOfItems);
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
@Override
public List<ShoppingItem> findByKeywords(
long groupId, long[] categoryIds, String keywords, int start, int end) {
return findByKeywords(groupId, categoryIds, keywords, start, end, null);
}
@Override
public List<ShoppingItem> findByKeywords(
long groupId, long[] categoryIds, String keywords, int start, int end,
OrderByComparator<ShoppingItem> obc) {
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT {ShoppingItem.*} FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("(ShoppingItem.name LIKE ? OR ");
query.append("ShoppingItem.description LIKE ? OR ");
query.append("ShoppingItem.properties LIKE ?))");
String sql = CustomSQLUtil.replaceOrderBy(query.toString(), obc);
keywords = '%' + keywords + '%';
SQLQuery q = session.createSynchronizedSQLQuery(sql);
q.addEntity("ShoppingItem", ShoppingItemImpl.class);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(keywords);
qPos.add(keywords);
qPos.add(keywords);
return (List<ShoppingItem>)QueryUtil.list(
q, getDialect(), start, end);
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
@Override
public List<ShoppingItem> findBySale(
long groupId, long[] categoryIds, int numOfItems) {
int countBySale = countBySale(groupId, categoryIds);
Session session = null;
try {
session = openSession();
StringBundler query = new StringBundler();
query.append("SELECT {ShoppingItem.*} FROM ShoppingItem ");
query.append("WHERE ");
query.append("ShoppingItem.groupId = ? AND (");
if (ArrayUtil.isNotEmpty(categoryIds)) {
query.append(StringPool.OPEN_PARENTHESIS);
for (int i = 0; i < categoryIds.length; i++) {
query.append("ShoppingItem.categoryId = ? ");
if ((i + 1) < categoryIds.length) {
query.append("OR ");
}
}
query.append(") AND ");
}
query.append("ShoppingItem.sale = ? AND ");
query.append("ShoppingItem.smallImage = ?");
SQLQuery q = session.createSynchronizedSQLQuery(query.toString());
q.addEntity("ShoppingItem", ShoppingItemImpl.class);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
if (ArrayUtil.isNotEmpty(categoryIds)) {
for (long categoryId : categoryIds) {
qPos.add(categoryId);
}
}
qPos.add(true);
qPos.add(true);
return (List<ShoppingItem>)QueryUtil.randomList(
q, getDialect(), countBySale, numOfItems);
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
protected int doCountByG_C(
long groupId, List<Long> categoryIds, boolean inlineSQLHelper) {
Session session = null;
try {
session = openSession();
String sql = CustomSQLUtil.get(getClass(), COUNT_BY_G_C);
if (inlineSQLHelper) {
sql = InlineSQLHelperUtil.replacePermissionCheck(
sql, ShoppingItem.class.getName(), "ShoppingItem.itemId",
groupId);
}
sql = StringUtil.replace(
sql, "[$CATEGORY_ID$]", getCategoryIds(categoryIds));
SQLQuery q = session.createSynchronizedSQLQuery(sql);
q.addScalar(COUNT_COLUMN_NAME, Type.LONG);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
for (int i = 0; i < categoryIds.size(); i++) {
Long categoryId = categoryIds.get(i);
qPos.add(categoryId);
}
Iterator<Long> itr = q.iterate();
if (itr.hasNext()) {
Long count = itr.next();
if (count != null) {
return count.intValue();
}
}
return 0;
}
catch (Exception e) {
throw new SystemException(e);
}
finally {
closeSession(session);
}
}
protected String getCategoryIds(List<Long> categoryIds) {
if (categoryIds.isEmpty()) {
return StringPool.BLANK;
}
StringBundler sb = new StringBundler(categoryIds.size() * 2 - 1);
for (int i = 0; i < categoryIds.size(); i++) {
sb.append("categoryId = ? ");
if ((i + 1) != categoryIds.size()) {
sb.append("OR ");
}
}
return sb.toString();
}
}