001 /**
002 * Copyright 2004-2012 The Kuali Foundation
003 *
004 * Licensed under the Educational Community License, Version 2.0 (the "License");
005 * you may not use this file except in compliance with the License.
006 * You may obtain a copy of the License at
007 *
008 * http://www.opensource.org/licenses/ecl2.php
009 *
010 * Unless required by applicable law or agreed to in writing, software
011 * distributed under the License is distributed on an "AS IS" BASIS,
012 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
013 * See the License for the specific language governing permissions and
014 * limitations under the License.
015 */
016 package org.kuali.hr.time.dept.lunch.dao;
017
018 import java.sql.Date;
019
020 import org.apache.ojb.broker.query.Criteria;
021 import org.apache.ojb.broker.query.Query;
022 import org.apache.ojb.broker.query.QueryFactory;
023 import org.apache.ojb.broker.query.ReportQueryByCriteria;
024 import org.kuali.hr.time.dept.lunch.DeptLunchRule;
025 import org.kuali.rice.core.framework.persistence.ojb.dao.PlatformAwareDaoBaseOjb;
026
027 public class DepartmentLunchRuleDaoImpl extends PlatformAwareDaoBaseOjb implements DepartmentLunchRuleDao {
028
029 @Override
030 public DeptLunchRule getDepartmentLunchRule(String dept, Long workArea, String principalId,
031 Long jobNumber, Date asOfDate) {
032 Criteria root = new Criteria();
033 Criteria effdt = new Criteria();
034 Criteria timestamp = new Criteria();
035
036 effdt.addEqualToField("dept", Criteria.PARENT_QUERY_PREFIX + "dept");
037 effdt.addEqualToField("workArea", Criteria.PARENT_QUERY_PREFIX + "workArea");
038 effdt.addEqualToField("principalId", Criteria.PARENT_QUERY_PREFIX + "principalId");
039 effdt.addEqualToField("jobNumber", Criteria.PARENT_QUERY_PREFIX + "jobNumber");
040 effdt.addLessOrEqualThan("effectiveDate", asOfDate);
041 // effdt.addEqualTo("active", true);
042 ReportQueryByCriteria effdtSubQuery = QueryFactory.newReportQuery(DeptLunchRule.class, effdt);
043 effdtSubQuery.setAttributes(new String[] { "max(effdt)" });
044
045 timestamp.addEqualToField("dept", Criteria.PARENT_QUERY_PREFIX + "dept");
046 timestamp.addEqualToField("workArea", Criteria.PARENT_QUERY_PREFIX + "workArea");
047 timestamp.addEqualToField("principalId", Criteria.PARENT_QUERY_PREFIX + "principalId");
048 timestamp.addEqualToField("jobNumber", Criteria.PARENT_QUERY_PREFIX + "jobNumber");
049 timestamp.addEqualToField("effectiveDate", Criteria.PARENT_QUERY_PREFIX + "effectiveDate");
050 // timestamp.addEqualTo("active", true);
051 ReportQueryByCriteria timestampSubQuery = QueryFactory.newReportQuery(DeptLunchRule.class, timestamp);
052 timestampSubQuery.setAttributes(new String[] { "max(timestamp)" });
053
054 root.addEqualTo("dept", dept);
055 root.addEqualTo("workArea", workArea);
056 root.addEqualTo("principalId", principalId);
057 root.addEqualTo("jobNumber", jobNumber);
058 root.addEqualTo("effectiveDate", effdtSubQuery);
059 root.addEqualTo("timestamp", timestampSubQuery);
060 // root.addEqualTo("active", true);
061
062 Criteria activeFilter = new Criteria(); // Inner Join For Activity
063 activeFilter.addEqualTo("active", true);
064 root.addAndCriteria(activeFilter);
065
066
067 Query query = QueryFactory.newQuery(DeptLunchRule.class, root);
068 return (DeptLunchRule)this.getPersistenceBrokerTemplate().getObjectByQuery(query);
069
070
071 }
072
073 @Override
074 public DeptLunchRule getDepartmentLunchRule(String tkDeptLunchRuleId) {
075 Criteria crit = new Criteria();
076 crit.addEqualTo("tkDeptLunchRuleId", tkDeptLunchRuleId);
077
078 Query query = QueryFactory.newQuery(DeptLunchRule.class, crit);
079 return (DeptLunchRule)this.getPersistenceBrokerTemplate().getObjectByQuery(query);
080 }
081
082 }