/* Name: - DateAttributeCondition Description: - Requires: - Provides: - Part of: ProcessPuzzle Framework, Domain and Business Model Ready Architecture. Provides content, workflow and social networking functionality. http://www.processpuzzle.com ProcessPuzzle - Content and Workflow Management Integration Business Platform Author(s): - Zsolt Zsuffa Copyright: (C) 2011 This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program 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 General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <http://www.gnu.org/licenses/>. */ package com.processpuzzle.persistence.query.domain; import java.util.Calendar; import java.util.Date; import java.util.GregorianCalendar; import com.processpuzzle.commons.persistence.query.ConditionElementType; import com.processpuzzle.fundamental_types.domain.OpAssertion; public class DateAttributeCondition extends DefaultAttributeCondition { private String sql_date_pattern = "YYYY-MM-DD HH:MI:SS"; /* public DateAttributeCondition( String attributeName, QueryVariable variable, ComparisonOperators operator ) { super(attributeName, variable, operator); }*/ public DateAttributeCondition( String attributeName, Date value, ComparisonOperators operator ) { super(attributeName, value, operator); } public DateAttributeCondition( String attributeName, ComparisonOperators operator ) { super( attributeName, null, operator ); OpAssertion.ppAssert(((operator == ComparisonOperators.IS_NULL) || (operator == ComparisonOperators.IS_NOT_NULL )), "AttributeCondition without attribute value can use only: 'is null, is not null' operators."); } @Override public String toString() { StringBuffer textualRepresentation = new StringBuffer(); textualRepresentation.append( attributeName ).append( " " ).append( operator.getHqlVariant() ) ; if( value != null ) { Calendar calendar = new GregorianCalendar(); calendar.setTime( (Date)value ); textualRepresentation.append( " to_date('" ) .append( calendar.get(Calendar.YEAR) ).append("-") .append( calendar.get(Calendar.MONTH) ).append("-") .append( calendar.get(Calendar.DAY_OF_WEEK) ).append(" ") .append( calendar.get(Calendar.HOUR_OF_DAY)).append(":") .append( calendar.get(Calendar.MINUTE) ).append(":") .append( calendar.get(Calendar.SECOND) ) .append("', '") .append(sql_date_pattern) .append("')"); } return textualRepresentation.toString(); } @Override public ConditionElementType getType() { // TODO Auto-generated method stub return null; } }