EventsOfDayTagDAO.java

/*
*
* Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved.
*
* This file is part of Entando software. 
* Entando is a free software; 
* You can redistribute it and/or modify it
* under the terms of the GNU General Public License (GPL) as published by the Free Software Foundation; version 2.
* 
* See the file License for the specific language governing permissions   
* and limitations under the License
* 
* 
* 
* Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved.
*
*/
package com.agiletec.plugins.jpcalendar.aps.system.services.calendar;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

import com.agiletec.aps.system.common.AbstractDAO;
import com.agiletec.aps.system.exception.ApsSystemException;
import com.agiletec.aps.system.services.group.Group;
import com.agiletec.plugins.jpcalendar.aps.system.services.calendar.util.EventsOfDayDataBean;
import com.agiletec.plugins.jpcalendar.aps.system.services.calendar.util.SmallEventOfDay;

/**
 * Classe DAO specifica per la gestione del tag EventsOfDay
 * @author E.Santoboni
 */
public class EventsOfDayTagDAO extends AbstractDAO implements IEventsOfDayTagDAO {
	
	public List<SmallEventOfDay> loadSmallEventsOfDay(EventsOfDayDataBean bean) 
			throws ApsSystemException {
		List<SmallEventOfDay> smallEvents = new ArrayList<SmallEventOfDay>();
		PreparedStatement stat = null;
		ResultSet result = null;
		Connection conn = this.getConnection();
		try {
			stat = conn.prepareStatement(this.createQueryString(bean));
			int index = 0;
			stat.setString(++index, bean.getContentType());
			stat.setString(++index, bean.getAttributeNameStart());
			stat.setString(++index, bean.getAttributeNameEnd());
			if (bean.getAllowedGroups() != null 
					&& bean.getAllowedGroups().size()>0
					&& !bean.getAllowedGroups().contains(Group.ADMINS_GROUP_NAME)) {
				Iterator<String> groupIter = bean.getAllowedGroups().iterator();
				while (groupIter.hasNext()) {
					String groupName = (String) groupIter.next();
					stat.setString(++index, groupName);
				}
			}
			result = stat.executeQuery();
			smallEvents = this.loadSmallDateContents(result, 
					bean.getAttributeNameStart(), bean.getAttributeNameEnd());
			
		} catch (Throwable t) {
			processDaoException(t, "Errore in caricamento lista id smallEvents", "loadContentsId");
		} finally {
			closeDaoResources(result, stat, conn);
		}
		return smallEvents;
	}
	
	private String createQueryString(EventsOfDayDataBean bean) {
		String query = this.LOAD_DATE_CONTENTS;
		if (bean.getAllowedGroups() != null 
				&& bean.getAllowedGroups().size()>0
				&& !bean.getAllowedGroups().contains(Group.ADMINS_GROUP_NAME)) {
			query += APPEND_STRING_GROUP_SEARCH_START;
			int size = bean.getAllowedGroups().size();
			for (int i=0; i<size; i++) {
				if (i!=0) query += APPEND_STRING_OR;
				query += APPEND_STRING_GROUP_SEARCH;
			}
			query += APPEND_STRING_GROUP_SEARCH_END;
			return query;
		}
		query += ORDER_BLOCK;
		return query;
	}
	
	private List<SmallEventOfDay> loadSmallDateContents(ResultSet result, 
			String attributeNameStart, String attributeNameEnd) throws SQLException {
    	List<SmallEventOfDay> smallEvents = new ArrayList<SmallEventOfDay>();
    	SmallEventOfDay smallEvent = null;
    	String prevId = null;
    	while (result.next()) {
    		String id = result.getString(1);
    		if (!id.equals(prevId)) {
    			if (smallEvent != null) {
    				smallEvents.add(smallEvent);
    			}
    			smallEvent = new SmallEventOfDay();
    		}
    		smallEvent.setId(id);
    		String attrName = result.getString(2);
    		if (attrName.equals(attributeNameStart)) {
    			Date dataInizio = this.dateFromSQL(result.getDate(4));
    			smallEvent.setStart(dataInizio);
    		} else if (attrName.equals(attributeNameEnd)) {
    			Date endDate = this.dateFromSQL(result.getDate(4));
    			smallEvent.setEnd(endDate);
    		}
    		prevId = id;
    	}
    	if (smallEvent != null) {
			smallEvents.add(smallEvent);
		}
    	return smallEvents;
    }
	
	private Date dateFromSQL(java.sql.Date sqlDate){
		Date date = null;
		if(sqlDate != null){
			date = new Date(sqlDate.getTime());
		}
		return date;
	}
	
	private final String LOAD_DATE_CONTENTS = 
		"SELECT contentsearch.contentid, contentsearch.attrname, " +
		"contentsearch.textvalue, contentsearch.datevalue, contentrelations.refcategory " +
		"FROM (contents INNER JOIN contentrelations " +
		"ON contents.contentid = contentrelations.contentid) " +
		"INNER JOIN contentsearch ON contents.contentid = contentsearch.contentid " +
		"WHERE contents.contenttype = ? " +
		"AND (contentsearch.attrname = ? OR contentsearch.attrname = ? ) ";
	
	private final String APPEND_STRING_GROUP_SEARCH_START = "AND ( ";
	private final String APPEND_STRING_GROUP_SEARCH = "contentrelations.refgroup = ? ";
	private final String APPEND_STRING_OR = "OR ";
	private final String APPEND_STRING_GROUP_SEARCH_END = ") ";
		
	private final String ORDER_BLOCK = 
		"ORDER BY contentsearch.contentid ";
	
}