Java tutorial
/** * 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.calendar.service.persistence.impl; import com.liferay.calendar.model.CalendarBooking; import com.liferay.calendar.model.impl.CalendarBookingImpl; import com.liferay.calendar.service.persistence.CalendarBookingFinder; 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.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.portal.kernel.util.Validator; import com.liferay.portal.security.permission.InlineSQLHelperUtil; import com.liferay.portal.service.persistence.impl.BasePersistenceImpl; import com.liferay.util.dao.orm.CustomSQLUtil; import java.util.Iterator; import java.util.List; /** * @author Eduardo Lundgren * @author Fabio Pezzutto */ public class CalendarBookingFinderImpl extends BasePersistenceImpl<CalendarBooking> implements CalendarBookingFinder { public static final String COUNT_BY_C_G_C_C_P_T_D_L_S_E_S = CalendarBookingFinder.class.getName() + ".countByC_G_C_C_P_T_D_L_S_E_S"; public static final String FIND_BY_FUTURE_REMINDERS = CalendarBookingFinder.class.getName() + ".findByFutureReminders"; public static final String FIND_BY_C_G_C_C_P_T_D_L_S_E_S = CalendarBookingFinder.class.getName() + ".findByC_G_C_C_P_T_D_L_S_E_S"; @Override public int countByKeywords(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String keywords, long startTime, long endTime, int[] statuses) { String[] titles = null; String[] descriptions = null; String[] locations = null; boolean andOperator = false; if (Validator.isNotNull(keywords)) { titles = CustomSQLUtil.keywords(keywords); descriptions = CustomSQLUtil.keywords(keywords, false); locations = CustomSQLUtil.keywords(keywords); } else { andOperator = true; } return countByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator); } @Override public int countByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String title, String description, String location, long startTime, long endTime, int[] statuses, boolean andOperator) { String[] titles = CustomSQLUtil.keywords(title); String[] descriptions = CustomSQLUtil.keywords(description, false); String[] locations = CustomSQLUtil.keywords(location); return countByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator); } @Override public int countByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, int[] statuses, boolean andOperator) { return doCountByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator, false); } @Override public int filterCountByKeywords(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String keywords, long startTime, long endTime, int[] statuses) { String[] titles = null; String[] descriptions = null; String[] locations = null; boolean andOperator = false; if (Validator.isNotNull(keywords)) { titles = CustomSQLUtil.keywords(keywords); descriptions = CustomSQLUtil.keywords(keywords, false); locations = CustomSQLUtil.keywords(keywords); } else { andOperator = true; } return filterCountByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator); } @Override public int filterCountByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String title, String description, String location, long startTime, long endTime, int[] statuses, boolean andOperator) { String[] titles = CustomSQLUtil.keywords(title); String[] descriptions = CustomSQLUtil.keywords(description, false); String[] locations = CustomSQLUtil.keywords(location); return filterCountByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator); } @Override public int filterCountByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, int[] statuses, boolean andOperator) { return doCountByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, statuses, andOperator, true); } @Override public List<CalendarBooking> filterFindByKeywords(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String keywords, long startTime, long endTime, boolean recurring, int[] statuses, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { String[] titles = null; String[] descriptions = null; String[] locations = null; boolean andOperator = false; if (Validator.isNotNull(keywords)) { titles = CustomSQLUtil.keywords(keywords); descriptions = CustomSQLUtil.keywords(keywords, false); locations = CustomSQLUtil.keywords(keywords); } else { andOperator = true; } return filterFindByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator); } @Override public List<CalendarBooking> filterFindByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String title, String description, String location, long startTime, long endTime, boolean recurring, int[] statuses, boolean andOperator, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { String[] titles = CustomSQLUtil.keywords(title); String[] descriptions = CustomSQLUtil.keywords(description, false); String[] locations = CustomSQLUtil.keywords(location); return filterFindByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator); } @Override public List<CalendarBooking> filterFindByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, boolean recurring, int[] statuses, boolean andOperator, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { return doFindByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator, true); } @Override public List<CalendarBooking> findByFutureReminders(long startTime) { Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_FUTURE_REMINDERS); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity("CalendarBooking", CalendarBookingImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(startTime); return q.list(true); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } } @Override public List<CalendarBooking> findByKeywords(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String keywords, long startTime, long endTime, boolean recurring, int[] statuses, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { String[] titles = null; String[] descriptions = null; String[] locations = null; boolean andOperator = false; if (Validator.isNotNull(keywords)) { titles = CustomSQLUtil.keywords(keywords); descriptions = CustomSQLUtil.keywords(keywords, false); locations = CustomSQLUtil.keywords(keywords); } else { andOperator = true; } return findByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator); } @Override public List<CalendarBooking> findByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String title, String description, String location, long startTime, long endTime, boolean recurring, int[] statuses, boolean andOperator, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { String[] titles = CustomSQLUtil.keywords(title); String[] descriptions = CustomSQLUtil.keywords(description, false); String[] locations = CustomSQLUtil.keywords(location); return findByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator); } @Override public List<CalendarBooking> findByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, boolean recurring, int[] statuses, boolean andOperator, int start, int end, OrderByComparator<CalendarBooking> orderByComparator) { return doFindByC_G_C_C_P_T_D_L_S_E_S(companyId, groupIds, calendarIds, calendarResourceIds, parentCalendarBookingId, titles, descriptions, locations, startTime, endTime, recurring, statuses, andOperator, start, end, orderByComparator, false); } protected int doCountByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, int[] statuses, boolean andOperator, boolean inlineSQLHelper) { titles = CustomSQLUtil.keywords(titles); descriptions = CustomSQLUtil.keywords(descriptions, false); locations = CustomSQLUtil.keywords(locations); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_C_P_T_D_L_S_E_S); if (inlineSQLHelper) { sql = InlineSQLHelperUtil.replacePermissionCheck(sql, CalendarBooking.class.getName(), "CalendarBooking.calendarBookingId", groupIds); } sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds)); sql = StringUtil.replace(sql, "[$CALENDAR_ID$]", getCalendarIds(calendarIds)); sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds)); sql = StringUtil.replace(sql, "[$STATUS$]", getStatuses(statuses)); if (parentCalendarBookingId < 0) { sql = StringUtil.replace(sql, "(parentCalendarBookingId = ?) AND", StringPool.BLANK); } sql = CustomSQLUtil.replaceKeywords(sql, "lower(title)", StringPool.LIKE, false, titles); sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions); sql = CustomSQLUtil.replaceKeywords(sql, "lower(location)", StringPool.LIKE, true, locations); sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addScalar(COUNT_COLUMN_NAME, Type.LONG); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); qPos.add(groupIds); if (ArrayUtil.isNotEmpty(calendarIds)) { qPos.add(calendarIds); } if (ArrayUtil.isNotEmpty(calendarResourceIds)) { qPos.add(calendarResourceIds); } if (parentCalendarBookingId >= 0) { qPos.add(parentCalendarBookingId); } qPos.add(titles, 2); qPos.add(descriptions, 2); qPos.add(locations, 2); qPos.add(startTime); qPos.add(endTime); qPos.add(startTime); qPos.add(endTime); qPos.add(startTime); qPos.add(endTime); qPos.add(endTime); qPos.add(startTime); qPos.add(startTime); qPos.add(endTime); if (ArrayUtil.isNotEmpty(statuses)) { qPos.add(statuses); } 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 List<CalendarBooking> doFindByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds, long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions, String[] locations, long startTime, long endTime, boolean recurring, int[] statuses, boolean andOperator, int start, int end, OrderByComparator<CalendarBooking> orderByComparator, boolean inlineSQLHelper) { titles = CustomSQLUtil.keywords(titles); descriptions = CustomSQLUtil.keywords(descriptions, false); locations = CustomSQLUtil.keywords(locations); Session session = null; try { session = openSession(); String sql = CustomSQLUtil.get(FIND_BY_C_G_C_C_P_T_D_L_S_E_S); if (inlineSQLHelper) { sql = InlineSQLHelperUtil.replacePermissionCheck(sql, CalendarBooking.class.getName(), "CalendarBooking.calendarBookingId", groupIds); } sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds)); sql = StringUtil.replace(sql, "[$CALENDAR_ID$]", getCalendarIds(calendarIds)); sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds)); sql = StringUtil.replace(sql, "[$RECURRENCE$]", getRecurrence(recurring)); sql = StringUtil.replace(sql, "[$STATUS$]", getStatuses(statuses)); if (parentCalendarBookingId < 0) { sql = StringUtil.replace(sql, "(parentCalendarBookingId = ?) AND", StringPool.BLANK); } sql = CustomSQLUtil.replaceKeywords(sql, "lower(title)", StringPool.LIKE, false, titles); sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions); sql = CustomSQLUtil.replaceKeywords(sql, "lower(location)", StringPool.LIKE, true, locations); sql = CustomSQLUtil.replaceAndOperator(sql, andOperator); StringBundler sb = new StringBundler(); if (orderByComparator != null) { appendOrderByComparator(sb, "CalendarBooking.", orderByComparator); } sql = StringUtil.replace(sql, "[$ORDER_BY$]", sb.toString()); SQLQuery q = session.createSynchronizedSQLQuery(sql); q.addEntity("CalendarBooking", CalendarBookingImpl.class); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); if (ArrayUtil.isNotEmpty(groupIds)) { qPos.add(groupIds); } if (ArrayUtil.isNotEmpty(calendarIds)) { qPos.add(calendarIds); } if (ArrayUtil.isNotEmpty(calendarResourceIds)) { qPos.add(calendarResourceIds); } if (parentCalendarBookingId >= 0) { qPos.add(parentCalendarBookingId); } qPos.add(titles, 2); qPos.add(descriptions, 2); qPos.add(locations, 2); qPos.add(startTime); qPos.add(endTime); qPos.add(startTime); qPos.add(endTime); qPos.add(startTime); qPos.add(endTime); qPos.add(endTime); qPos.add(startTime); qPos.add(startTime); qPos.add(endTime); if (ArrayUtil.isNotEmpty(statuses)) { qPos.add(statuses); } return (List<CalendarBooking>) QueryUtil.list(q, getDialect(), start, end); } catch (Exception e) { throw new SystemException(e); } finally { closeSession(session); } } protected String getCalendarIds(long[] calendarIds) { if (ArrayUtil.isEmpty(calendarIds)) { return StringPool.BLANK; } StringBundler sb = new StringBundler(calendarIds.length * 2 + 1); sb.append(" ("); for (int i = 0; i < calendarIds.length; i++) { sb.append("calendarId = ? "); if ((i + 1) != calendarIds.length) { sb.append("OR "); } } sb.append(") AND"); return sb.toString(); } protected String getCalendarResourceIds(long[] calendarResourceIds) { if (ArrayUtil.isEmpty(calendarResourceIds)) { return StringPool.BLANK; } StringBundler sb = new StringBundler(calendarResourceIds.length * 2 + 1); sb.append(" ("); for (int i = 0; i < calendarResourceIds.length; i++) { sb.append("calendarResourceId = ? "); if ((i + 1) != calendarResourceIds.length) { sb.append("OR "); } } sb.append(") AND"); return sb.toString(); } protected String getGroupIds(long[] groupIds) { if (ArrayUtil.isEmpty(groupIds)) { return StringPool.BLANK; } StringBundler sb = new StringBundler(groupIds.length * 2); sb.append("("); for (int i = 0; i < groupIds.length; i++) { sb.append("groupId = ?"); if ((i + 1) < groupIds.length) { sb.append(" OR "); } } sb.append(") AND"); return sb.toString(); } protected String getRecurrence(boolean recurring) { if (recurring) { return "OR ((recurrence IS NOT NULL AND recurrence != ''))"; } return StringPool.BLANK; } protected String getStatuses(int[] statuses) { if (ArrayUtil.isEmpty(statuses)) { return StringPool.BLANK; } StringBundler sb = new StringBundler(statuses.length * 2 + 1); sb.append("AND ("); for (int i = 0; i < statuses.length; i++) { sb.append("status = ? "); if ((i + 1) != statuses.length) { sb.append("OR "); } } sb.append(") "); return sb.toString(); } }