Example usage for org.joda.time LocalDate toDate

Introduction

In this page you can find the example usage for org.joda.time LocalDate toDate.

Prototype

@SuppressWarnings("deprecation")
public Date toDate() 

Source Link

Document

Get the date time as a java.util.Date.

Usage

From source file:org.kuali.kpme.core.accrualcategory.dao.AccrualCategoryDaoOjbImpl.java

License:Educational Community License

@Override
// KPME-1011/*from   ww  w  . j a v  a 2  s  .c o m*/
public List<AccrualCategory> getActiveAccrualCategories(LocalDate asOfDate) {
    List<AccrualCategory> accrualCategories = new ArrayList<AccrualCategory>();
    Criteria root = new Criteria();
    Criteria timestampSubCrit = new Criteria();

    timestampSubCrit.addEqualToField("accrualCategory", Criteria.PARENT_QUERY_PREFIX + "accrualCategory");
    ReportQueryByCriteria timestampSubQuery = QueryFactory.newReportQuery(AccrualCategory.class,
            timestampSubCrit);
    timestampSubQuery.setAttributes(new String[] { "max(timestamp)" });

    root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());
    root.addEqualTo("timestamp", timestampSubQuery);
    root.addEqualTo("active", true);

    Query query = QueryFactory.newQuery(AccrualCategory.class, root);

    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null) {
        accrualCategories.addAll(c);
    }

    return accrualCategories;
}

---

From source file:org.kuali.kpme.core.accrualcategory.dao.AccrualCategoryDaoOjbImpl.java

License:Educational Community License

@Override
@SuppressWarnings("unchecked")
public List<AccrualCategory> getAccrualCategories(String accrualCategory, String descr, String leavePlan,
        String accrualEarnInterval, String unitOfTime, String minPercentWorked, LocalDate fromEffdt,
        LocalDate toEffdt, String active, String showHistory) {

    List<AccrualCategory> results = new ArrayList<AccrualCategory>();

    Criteria root = new Criteria();

    if (StringUtils.isNotBlank(accrualCategory)) {
        root.addLike("accrualCategory", accrualCategory);
    }/*from  www  .  j av  a 2s. c o  m*/

    if (StringUtils.isNotBlank(descr)) {
        root.addLike("descr", descr);
    }

    if (StringUtils.isNotBlank(leavePlan)) {
        root.addLike("leavePlan", leavePlan);
    }

    if (StringUtils.isNotBlank(accrualEarnInterval)) {
        root.addLike("accrualEarnInterval", accrualEarnInterval);
    }

    if (StringUtils.isNotBlank(unitOfTime)) {
        root.addLike("unitOfTime", unitOfTime);
    }

    if (StringUtils.isNotBlank(minPercentWorked)) {
        root.addLike("minPercentWorked", minPercentWorked);
    }

    Criteria effectiveDateFilter = new Criteria();
    if (fromEffdt != null) {
        effectiveDateFilter.addGreaterOrEqualThan("effectiveDate", fromEffdt.toDate());
    }
    if (toEffdt != null) {
        effectiveDateFilter.addLessOrEqualThan("effectiveDate", toEffdt.toDate());
    }
    if (fromEffdt == null && toEffdt == null) {
        effectiveDateFilter.addLessOrEqualThan("effectiveDate", LocalDate.now().toDate());
    }
    root.addAndCriteria(effectiveDateFilter);

    if (StringUtils.isNotBlank(active)) {
        Criteria activeFilter = new Criteria();
        if (StringUtils.equals(active, "Y")) {
            activeFilter.addEqualTo("active", true);
        } else if (StringUtils.equals(active, "N")) {
            activeFilter.addEqualTo("active", false);
        }
        root.addAndCriteria(activeFilter);
    }

    if (StringUtils.equals(showHistory, "N")) {
        root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQueryWithFilter(
                AccrualCategory.class, effectiveDateFilter, AccrualCategory.EQUAL_TO_FIELDS, false));
        root.addEqualTo("timestamp", OjbSubQueryUtil.getTimestampSubQuery(AccrualCategory.class,
                AccrualCategory.EQUAL_TO_FIELDS, false));
    }

    Query query = QueryFactory.newQuery(AccrualCategory.class, root);
    results.addAll(getPersistenceBrokerTemplate().getCollectionByQuery(query));

    return results;
}

---

From source file:org.kuali.kpme.core.accrualcategory.dao.AccrualCategoryDaoOjbImpl.java

License:Educational Community License

@Override
public List<AccrualCategory> getActiveLeaveAccrualCategoriesForLeavePlan(String leavePlan, LocalDate asOfDate) {
    Criteria root = new Criteria();
    root.addEqualTo("leavePlan", leavePlan);
    root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());
    root.addNotEqualTo("accrualEarnInterval", "N");
    root.addEqualTo("active", true);

    Query query = QueryFactory.newQuery(AccrualCategory.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    List<AccrualCategory> accrualCategories = new ArrayList<AccrualCategory>();

    if (c != null) {
        accrualCategories.addAll(c);//from w  w  w  . j a v a  2 s  .  c  o m
    }
    return accrualCategories;
}

---

From source file:org.kuali.kpme.core.accrualcategory.dao.AccrualCategoryDaoOjbImpl.java

License:Educational Community License

@Override
public List<AccrualCategory> getInActiveLeaveAccrualCategoriesForLeavePlan(String leavePlan,
        LocalDate asOfDate) {
    Criteria root = new Criteria();
    root.addEqualTo("leavePlan", leavePlan);
    root.addNotEqualTo("accrualEarnInterval", "N");
    root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());
    root.addEqualTo("active", false);
    Query query = QueryFactory.newQuery(AccrualCategory.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    List<AccrualCategory> accrualCategories = new ArrayList<AccrualCategory>();

    if (c != null) {
        accrualCategories.addAll(c);//  ww  w . j ava 2  s  .com
    }
    return accrualCategories;
}

---

From source file:org.kuali.kpme.core.assignment.dao.AssignmentDaoOjbImpl.java

License:Educational Community License

@SuppressWarnings({ "unchecked", "rawtypes" })
@Override/*from ww w  .  j  av a2  s  .  c om*/
public List<Assignment> findAssignmentsWithinPeriod(String principalId, LocalDate startDate,
        LocalDate endDate) {
    List<Assignment> assignments = new ArrayList<Assignment>();
    Criteria root = new Criteria();

    root.addGreaterOrEqualThan("effectiveDate", startDate.toDate());
    root.addLessOrEqualThan("effectiveDate", endDate.toDate());
    root.addEqualTo("principalId", principalId);
    root.addEqualTo("active", true);

    Query query = QueryFactory.newQuery(Assignment.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null) {
        assignments.addAll(c);
    }

    return assignments;
}

---

From source file:org.kuali.kpme.core.assignment.dao.AssignmentDaoOjbImpl.java

License:Educational Community License

public List<Assignment> getActiveAssignments(LocalDate asOfDate) {
    List<Assignment> assignments = new ArrayList<Assignment>();

    Criteria root = new Criteria();
    root.addLessOrEqualThan("effectiveDate", asOfDate.toDate());

    root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQuery(Assignment.class, asOfDate,
            Assignment.EQUAL_TO_FIELDS, true));
    root.addEqualTo("timestamp",
            OjbSubQueryUtil.getTimestampSubQuery(Assignment.class, Assignment.EQUAL_TO_FIELDS, true));

    Criteria activeFilter = new Criteria();
    activeFilter.addEqualTo("active", true);
    root.addAndCriteria(activeFilter);/*w w  w  .ja  v  a  2 s .  c o  m*/

    Query query = QueryFactory.newQuery(Assignment.class, root);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);

    if (c != null) {
        assignments.addAll(c);
    }

    return assignments;
}

---

From source file:org.kuali.kpme.core.assignment.dao.AssignmentDaoOjbImpl.java

License:Educational Community License

@Override
@SuppressWarnings("unchecked")
public List<Assignment> searchAssignments(LocalDate fromEffdt, LocalDate toEffdt, String principalId,
        String jobNumber, String dept, String workArea, String active, String showHistory) {

    List<Assignment> results = new ArrayList<Assignment>();

    Criteria root = new Criteria();

    Criteria effectiveDateFilter = new Criteria();
    if (fromEffdt != null) {
        effectiveDateFilter.addGreaterOrEqualThan("effectiveDate", fromEffdt.toDate());
    }/*w w w . j  a  va2  s  .  c  o m*/
    if (toEffdt != null) {
        effectiveDateFilter.addLessOrEqualThan("effectiveDate", toEffdt.toDate());
    }
    if (fromEffdt == null && toEffdt == null) {
        effectiveDateFilter.addLessOrEqualThan("effectiveDate", LocalDate.now().toDate());
    }
    root.addAndCriteria(effectiveDateFilter);

    if (StringUtils.isNotBlank(principalId)) {
        root.addLike("principalId", principalId);
    }

    if (StringUtils.isNotBlank(jobNumber)) {
        root.addLike("jobNumber", jobNumber);
    }

    if (StringUtils.isNotBlank(dept)) {
        Criteria workAreaCriteria = new Criteria();
        LocalDate asOfDate = toEffdt != null ? toEffdt : LocalDate.now();
        Collection<WorkArea> workAreasForDept = HrServiceLocator.getWorkAreaService().getWorkAreas(dept,
                asOfDate);
        if (CollectionUtils.isNotEmpty(workAreasForDept)) {
            List<Long> longWorkAreas = new ArrayList<Long>();
            for (WorkArea cwa : workAreasForDept) {
                longWorkAreas.add(cwa.getWorkArea());
            }
            workAreaCriteria.addIn("workArea", longWorkAreas);
        }
        root.addAndCriteria(workAreaCriteria);
    }

    if (StringUtils.isNotBlank(workArea)) {
        OjbSubQueryUtil.addNumericCriteria(root, "workArea", workArea);
    }

    if (StringUtils.isNotBlank(active)) {
        Criteria activeFilter = new Criteria();
        if (StringUtils.equals(active, "Y")) {
            activeFilter.addEqualTo("active", true);
        } else if (StringUtils.equals(active, "N")) {
            activeFilter.addEqualTo("active", false);
        }
        root.addAndCriteria(activeFilter);
    }

    if (StringUtils.equals(showHistory, "N")) {
        root.addEqualTo("effectiveDate", OjbSubQueryUtil.getEffectiveDateSubQueryWithFilter(Assignment.class,
                effectiveDateFilter, Assignment.EQUAL_TO_FIELDS, false));
        root.addEqualTo("timestamp",
                OjbSubQueryUtil.getTimestampSubQuery(Assignment.class, Assignment.EQUAL_TO_FIELDS, false));
    }

    Query query = QueryFactory.newQuery(Assignment.class, root);
    results.addAll(getPersistenceBrokerTemplate().getCollectionByQuery(query));

    return results;
}

---

From source file:org.kuali.kpme.core.assignment.dao.AssignmentDaoOjbImpl.java

License:Educational Community License

public List<Assignment> getAssignments(List<String> workAreaList, LocalDate effdt, LocalDate startDate,
        LocalDate endDate) {// w ww .j  av  a  2  s .  c  om
    List<Assignment> results = new ArrayList<Assignment>();

    Criteria activeRoot = new Criteria();
    Criteria inactiveRoot = new Criteria();

    ReportQueryByCriteria effdtSubQuery = OjbSubQueryUtil
            .getEffectiveDateSubQueryWithoutFilter(Assignment.class, Assignment.EQUAL_TO_FIELDS, false);
    ReportQueryByCriteria activeEffdtSubQuery = OjbSubQueryUtil.getEffectiveDateSubQuery(Assignment.class,
            effdt, Assignment.EQUAL_TO_FIELDS, false);
    ReportQueryByCriteria timestampSubQuery = OjbSubQueryUtil.getTimestampSubQuery(Assignment.class,
            Assignment.EQUAL_TO_FIELDS, false);

    inactiveRoot.addEqualTo("active", "N");
    inactiveRoot.addIn("workArea", workAreaList);
    inactiveRoot.addGreaterOrEqualThan("effectiveDate", startDate.toDate());
    inactiveRoot.addLessOrEqualThan("effectiveDate", endDate.toDate());
    inactiveRoot.addEqualTo("effectiveDate", effdtSubQuery);
    inactiveRoot.addEqualTo("timestamp", timestampSubQuery);

    activeRoot.addIn("workArea", workAreaList);
    activeRoot.addEqualTo("active", "Y");
    activeRoot.addEqualTo("effectiveDate", activeEffdtSubQuery);
    activeRoot.addEqualTo("timestamp", timestampSubQuery);
    activeRoot.addOrCriteria(inactiveRoot);

    Query query = QueryFactory.newQuery(Assignment.class, activeRoot);
    Collection c = this.getPersistenceBrokerTemplate().getCollectionByQuery(query);
    if (c != null) {
        results.addAll(c);
    }

    return results;
}

---

From source file:org.kuali.kpme.core.bo.dao.KpmeHrBusinessObjectLookupDaoOjbImpl.java

License:Educational Community License

@SuppressWarnings({ "rawtypes", "unchecked" })
private void injectSubQueries(Criteria root, Class<? extends HrBusinessObjectContract> hrBOClass,
        Map formProps) {/*  w ww  .j  av a  2s  . c om*/
    // create the effective date filter criteria
    Criteria effectiveDateFilter = new Criteria();
    LocalDate fromEffdt = TKUtils
            .formatDateString(TKUtils.getFromDateString((String) formProps.get(EFFECTIVE_DATE)));
    LocalDate toEffdt = TKUtils
            .formatDateString(TKUtils.getToDateString((String) formProps.get(EFFECTIVE_DATE)));
    if (fromEffdt != null) {
        effectiveDateFilter.addGreaterOrEqualThan(EFFECTIVE_DATE, fromEffdt.toDate());
    }
    if (toEffdt != null) {
        effectiveDateFilter.addLessOrEqualThan(EFFECTIVE_DATE, toEffdt.toDate());
    }
    if (fromEffdt == null && toEffdt == null) {
        effectiveDateFilter.addLessOrEqualThan(EFFECTIVE_DATE, LocalDate.now().toDate());
    }

    List<String> businessKeys = new ArrayList<String>();
    try {
        businessKeys = (List<String>) hrBOClass.getDeclaredField(BUSINESS_KEYS_VAR_NAME).get(hrBOClass);
    } catch (NoSuchFieldException e) {
        LOG.warn(hrBOClass.getName() + DOES_NOT_CONTAIN_BUSINESS_KEYS_MESSAGE);
    } catch (IllegalAccessException e) {
        LOG.warn(hrBOClass.getName() + DOES_NOT_CONTAIN_BUSINESS_KEYS_MESSAGE);
    }

    // inject the subqueries
    root.addEqualTo(EFFECTIVE_DATE, OjbSubQueryUtil.getEffectiveDateSubQueryWithFilter(hrBOClass,
            effectiveDateFilter, businessKeys, false));
    root.addEqualTo(TIMESTAMP, OjbSubQueryUtil.getTimestampSubQuery(hrBOClass, businessKeys, false));
}

---

From source file:org.kuali.kpme.core.bo.HrBusinessObject.java

License:Educational Community License

public void setEffectiveLocalDate(LocalDate effectiveLocalDate) {
    this.effectiveDate = effectiveLocalDate != null ? effectiveLocalDate.toDate() : null;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »