/* * * 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.jpcontentworkflow.aps.system.services.content; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Collection; import java.util.List; import com.agiletec.aps.system.common.entity.model.EntitySearchFilter; import com.agiletec.plugins.jpcontentworkflow.aps.system.services.workflow.model.WorkflowSearchFilter; /** * @author E.Santoboni */ public class ContentSearcherDAO extends com.agiletec.plugins.jacms.aps.system.services.content.WorkContentSearcherDAO implements IContentSearcherDAO { @Override public List<String> loadContentsId(List<WorkflowSearchFilter> workflowFilters, String[] categories, EntitySearchFilter[] filters, Collection<String> userGroupCodes) { List<String> contentsId = new ArrayList<String>(); if (workflowFilters.isEmpty() || userGroupCodes == null || userGroupCodes.size()==0) { return contentsId; } Connection conn = null; PreparedStatement stat = null; ResultSet result = null; try { conn = this.getConnection(); stat = this.buildStatement(workflowFilters, filters, categories, userGroupCodes, conn); result = stat.executeQuery(); this.flowResult(contentsId, filters, result); } catch (Throwable t) { processDaoException(t, "Errore in caricamento lista id contenuti", "loadContentsId"); } finally { closeDaoResources(result, stat, conn); } return contentsId; } private PreparedStatement buildStatement(List<WorkflowSearchFilter> workflowFilters, EntitySearchFilter[] filters, String[] categories, Collection<String> userGroupCodes, Connection conn) { Collection<String> groupsForSelect = this.getGroupsForSelect(userGroupCodes); String query = this.createQueryString(workflowFilters, filters, categories, groupsForSelect); PreparedStatement stat = null; try { stat = conn.prepareStatement(query); int index = 0; index = super.addAttributeFilterStatementBlock(filters, index, stat); index = this.addMetadataFieldFilterStatementBlock(filters, index, stat); if (groupsForSelect != null) { index = this.addGroupStatementBlock(groupsForSelect, index, stat); } if (categories != null) { for (int i=0; i<categories.length; i++) { stat.setString(++index, categories[i]); } } if (null != workflowFilters) { for (int i = 0; i < workflowFilters.size(); i++) { WorkflowSearchFilter filter = workflowFilters.get(i); stat.setString(++index, filter.getTypeCode()); for (int j = 0; j < filter.getAllowedSteps().size(); j++) { String step = filter.getAllowedSteps().get(j); stat.setString(++index, step); } } } } catch (Throwable t) { processDaoException(t, "Errore in fase di creazione statement", "buildStatement"); } return stat; } private String createQueryString(List<WorkflowSearchFilter> workflowFilters, EntitySearchFilter[] filters, String[] categories, Collection<String> groupsForSelect) { StringBuffer query = this.createBaseQueryBlock(filters, false); boolean hasAppendWhereClause = this.appendFullAttributeFilterQueryBlocks(filters, query, false); hasAppendWhereClause = this.appendMetadataFieldFilterQueryBlocks(filters, query, hasAppendWhereClause); if (groupsForSelect != null && !groupsForSelect.isEmpty()) { hasAppendWhereClause = this.verifyWhereClauseAppend(query, hasAppendWhereClause); this.addGroupsQueryBlock(query, groupsForSelect); } if (categories != null) { hasAppendWhereClause = this.verifyWhereClauseAppend(query, hasAppendWhereClause); for (int i=0; i<categories.length; i++) { if (i>0) query.append(" AND "); query.append(" contents.contentid IN (SELECT contentid FROM ") .append(this.getContentRelationsTableName()).append(" WHERE ") .append(this.getContentRelationsTableName()).append(".refcategory = ? ) "); } } hasAppendWhereClause = this.verifyWhereClauseAppend(query, hasAppendWhereClause); query.append(" ( "); int i = 0; for (WorkflowSearchFilter filter : workflowFilters) { if (i++>0) query.append(" OR "); query.append("( contents.contenttype = ? AND contents.status IN ( "); int steps = filter.getAllowedSteps().size(); if (steps-- > 0) { query.append("? "); } while (steps-- > 0) { query.append(", ?"); } query.append(" )) "); } query.append(") "); appendOrderQueryBlocks(filters, query, false); return query.toString(); } }