001    /**
002     * Copyright 2004-2013 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.principal.dao;
017    
018    import java.util.Date;
019    import java.util.List;
020    
021    import org.kuali.hr.time.principal.PrincipalHRAttributes;
022    
023    public interface PrincipalHRAttributesDao {
024            public void saveOrUpdate(PrincipalHRAttributes principalCalendar);
025    
026            public void saveOrUpdate(List<PrincipalHRAttributes> lstPrincipalCalendar);
027    
028            public PrincipalHRAttributes getPrincipalCalendar(String principalId, Date asOfDate);
029            
030            public List<PrincipalHRAttributes> getActiveEmployeesForPayCalendar(String payCalendarName, Date asOfDate);
031    
032            public List<PrincipalHRAttributes> getActiveEmployeesForLeaveCalendar(String leaveCalendarName, Date asOfDate);
033            
034            public List<String> getActiveEmployeesIdForLeaveCalendarAndIdList(String leaveCalendarName, List<String> pidList, Date asOfDate);
035            
036        public List<String> getActiveEmployeesIdForTimeCalendarAndIdList(String timeCalendarName, List<String> pidList, Date asOfDate);
037    
038            /**
039             * KPME-1250 Kagata
040             * Get a list of active employees based on leave plan and as of a particular date 
041             * @param leavePlan
042             * @param asOfDate
043             * @return
044             */
045            public List<PrincipalHRAttributes> getActiveEmployeesForLeavePlan(String leavePlan, Date asOfDate);
046            
047    // this method is not needed anymore since we changed the primary key of
048    //      PrincipalHRAttributes table from principalId to hrPrincipalAttributeId
049    //      use getPrincipalCalendar(String principalId, Date asOfDate) instead
050    //      public PrincipalHRAttributes getPrincipalHRAttributes(String principalId);
051            
052            public PrincipalHRAttributes getInactivePrincipalHRAttributes(String principalId, Date asOfDate);
053            
054            public PrincipalHRAttributes getPrincipalHRAttributes(String hrPrincipalAttributeId);
055            
056            public List<PrincipalHRAttributes> getAllActivePrincipalHrAttributesForPrincipalId(String principalId, Date asOfDate);
057            
058            public List<PrincipalHRAttributes> getAllInActivePrincipalHrAttributesForPrincipalId(String principalId, Date asOfDate);
059            
060            public PrincipalHRAttributes getMaxTimeStampPrincipalHRAttributes(String principalId);
061            
062            public List<PrincipalHRAttributes> getActivePrincipalHrAttributesForRange(String principalId, Date startDate, Date endDate);
063             
064            public List<PrincipalHRAttributes> getInactivePrincipalHRAttributesForRange(String principalId, Date startDate, Date endDate);
065    
066        public List<String> getUniqueLeavePayGroupsForPrincipalIds(List<String> principalIds);
067        
068        public List<PrincipalHRAttributes> getPrincipalHrAtributes(String principalId, String leavePlan, java.sql.Date fromEffdt, java.sql.Date toEffdt, String active, String showHistory);
069        
070        public List<String> getUniqueTimePayGroups();
071        
072    }