protected void clearBaseYearBudgetConstructionAppointmentFundingReason(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionAppointmentFundingReason.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
private Query getFKQuery(AbstractDomainObject obj, ClassDescriptor cld, CollectionDescriptor cod) { if (cod.isMtoNRelation()) { // each of the following arrays have one element only Object[] thisClassFks = cod.getFksToThisClass(); Object[] itemClassFks = cod.getFksToItemClass(); String table = cod.getIndirectionTable(); Criteria criteria = new Criteria(); criteria.addColumnEqualTo(table + "." + thisClassFks[0], obj.getOid()); criteria.addColumnEqualToField(table + "." + itemClassFks[0], "OID"); ClassDescriptor refCld = getClassDescriptor(cod.getItemClass()); return QueryFactory.newQuery(refCld.getClassOfObject(), table, criteria); } else { ClassDescriptor refCld = getClassDescriptor(cod.getItemClass()); // the following array will have only one element FieldDescriptor[] fields = cod.getForeignKeyFieldDescriptors(refCld); Criteria criteria = new Criteria(); criteria.addEqualTo(fields[0].getAttributeName(), obj.getOid()); return QueryFactory.newQuery(refCld.getClassOfObject(), criteria); } }
criteriaID.addColumnEqualTo(KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, problemChart); criteriaID.addEqualTo(KFSPropertyConstants.FINANCIAL_OBJECT_CODE, problemObject); ReportQueryByCriteria queryID = new ReportQueryByCriteria(ObjectCode.class, criteriaID);
protected void clearBaseYearBCSF(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionCalculatedSalaryFoundationTracker.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBaseYearBCPosition(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionPosition.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }
protected void clearBaseYearPendingApptFunding(Integer BaseYear) { Criteria criteriaId = new Criteria(); criteriaId.addColumnEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, BaseYear); QueryByCriteria queryId = new QueryByCriteria(PendingBudgetConstructionAppointmentFunding.class, criteriaId); getPersistenceBrokerTemplate().deleteByQuery(queryId); getPersistenceBrokerTemplate().clearCache(); }