Java QueryByCriteria.CRITERIA_SELECT_ALL属性代码示例

public void createChartForNextBudgetCycle() {
    // first we have to remove what's there
    // (the documentation says deleteByQuery (1) ignores object references and (2) does
    //  not synchronize the cache.  so, we clear the cache before and after.)
    getPersistenceBrokerTemplate().clearCache();
    Criteria criteriaID = QueryByCriteria.CRITERIA_SELECT_ALL;
    QueryByCriteria killAcctQuery = new QueryByCriteria(BudgetConstructionAccountReports.class);
    killAcctQuery.setCriteria(criteriaID);
    getPersistenceBrokerTemplate().deleteByQuery(killAcctQuery);
    QueryByCriteria killOrgQuery = new QueryByCriteria(BudgetConstructionOrganizationReports.class);
    killOrgQuery.setCriteria(criteriaID);
    getPersistenceBrokerTemplate().deleteByQuery(killOrgQuery);
    getPersistenceBrokerTemplate().clearCache();
    // build the organization table  
    buildNewOrganizationReportsTo();
    // build the account table
    buildNewAccountReportsTo();
}
 

protected void clearPBGL() {
    // the order here is mandated by referential integrity
    QueryByCriteria mnQueryId = new QueryByCriteria(BudgetConstructionMonthly.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(mnQueryId);
    QueryByCriteria queryId = new QueryByCriteria(PendingBudgetConstructionGeneralLedger.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void buildNewAccountReportsTo() {

        //  All active accounts are loaded into the budget accounting table

        Integer sqlChartOfAccountsCode = 0;
        Integer sqlAccountNumber = 1;
        Integer sqlReportsToChartofAccountsCode = 0;
        Integer sqlOrganizationCode = 2;

        Long accountsAdded = new Long(0);

        Criteria criteriaID = new Criteria();
        /*  current IU genesis does NOT check for closed accounts--it loads all accounts
         *  it is possible that an account which has been closed still has base budget 
         */
        criteriaID = QueryByCriteria.CRITERIA_SELECT_ALL;
        String[] queryAttr = { KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, KFSPropertyConstants.ACCOUNT_NUMBER, KFSPropertyConstants.ORGANIZATION_CODE };
        ReportQueryByCriteria queryID = new ReportQueryByCriteria(Account.class, queryAttr, criteriaID, true);
        Iterator Results = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(queryID);
        while (Results.hasNext()) {
            Object[] ReturnList = (Object[]) Results.next();
            // just save this stuff, one at a time
            // it isn't needed for anything else, so we don't need to store it in memory in a map
            BudgetConstructionAccountReports acctRpts = new BudgetConstructionAccountReports();
            acctRpts.setChartOfAccountsCode((String) ReturnList[sqlChartOfAccountsCode]);
            acctRpts.setAccountNumber((String) ReturnList[sqlAccountNumber]);
            acctRpts.setReportsToChartOfAccountsCode((String) ReturnList[sqlReportsToChartofAccountsCode]);
            acctRpts.setReportsToOrganizationCode((String) ReturnList[sqlOrganizationCode]);
            acctRpts.setVersionNumber(DEFAULT_VERSION_NUMBER);
            getPersistenceBrokerTemplate().store(acctRpts);
            accountsAdded = accountsAdded + 1;
        }
        LOG.info(String.format("\nAccount reporting lines added to budget construction %d", accountsAdded));
    }
 

protected void buildNewOrganizationReportsTo() {

        //  all active organizations are loaded into the budget construction
        //  organization table

        Integer sqlChartOfAccountsCode = 0;
        Integer sqlOrganizationCode = 1;
        Integer sqlReportsToChartOfAccountsCode = 2;
        Integer sqlReportsToOrganizationCode = 3;
        Integer sqlResponsibilityCenterCode = 4;

        Long organizationsAdded = new Long(0);

        Criteria criteriaID = new Criteria();
        /*
         *  IU genesis takes all organizations, not just active ones
         *  the reason is that a closed account which still has a base budget
         *  might report to one of these organizations 
         */
        criteriaID = QueryByCriteria.CRITERIA_SELECT_ALL;
        String[] queryAttr = { KFSPropertyConstants.CHART_OF_ACCOUNTS_CODE, KFSPropertyConstants.ORGANIZATION_CODE, KFSPropertyConstants.REPORTS_TO_CHART_OF_ACCOUNTS_CODE, KFSPropertyConstants.REPORTS_TO_ORGANIZATION_CODE, KFSPropertyConstants.RESPONSIBILITY_CENTER_CODE };
        ReportQueryByCriteria queryID = new ReportQueryByCriteria(Organization.class, queryAttr, criteriaID, true);
        Iterator Results = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(queryID);
        while (Results.hasNext()) {
            Object[] ReturnList = (Object[]) Results.next();
            // just save this stuff, one at a time
            // it isn't needed for anything else
            BudgetConstructionOrganizationReports orgRpts = new BudgetConstructionOrganizationReports();
            orgRpts.setChartOfAccountsCode((String) ReturnList[sqlChartOfAccountsCode]);
            orgRpts.setOrganizationCode((String) ReturnList[sqlOrganizationCode]);
            orgRpts.setReportsToChartOfAccountsCode((String) ReturnList[sqlReportsToChartOfAccountsCode]);
            orgRpts.setReportsToOrganizationCode((String) ReturnList[sqlReportsToOrganizationCode]);
            orgRpts.setResponsibilityCenterCode((String) ReturnList[sqlResponsibilityCenterCode]);
            orgRpts.setVersionNumber(DEFAULT_VERSION_NUMBER);
            getPersistenceBrokerTemplate().store(orgRpts);
            organizationsAdded = organizationsAdded + 1;
        }
        LOG.info(String.format("\nOrganization reporting lines added to budget construction %d", organizationsAdded));
    }
 

public void setControlFlagsAtTheStartOfGenesis(Integer BaseYear) {
    Integer RequestYear = BaseYear + 1;
    //
    // first we have to eliminate anything for the new year that's there now
    getPersistenceBrokerTemplate().clearCache();
    Criteria criteriaID = new Criteria();
    criteriaID.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, RequestYear);
    QueryByCriteria queryID = new QueryByCriteria(FiscalYearFunctionControl.class, criteriaID);
    getPersistenceBrokerTemplate().deleteByQuery(queryID);
    getPersistenceBrokerTemplate().clearCache();
    // 
    //  the default values (except for the BUDGET_CONSTRUCTION_GENESIS_RUNNING flag)
    //  come from the function control code table
    FiscalYearFunctionControl SLF;
    criteriaID = QueryByCriteria.CRITERIA_SELECT_ALL;
    String[] attrQ = { KFSPropertyConstants.FINANCIAL_SYSTEM_FUNCTION_CONTROL_CODE, KFSPropertyConstants.FINANCIAL_SYSTEM_FUNCTION_DEFAULT_INDICATOR };
    ReportQueryByCriteria rptQueryID = new ReportQueryByCriteria(FunctionControlCode.class, attrQ, criteriaID);
    Integer sqlFunctionControlCode = 0;
    Integer sqlFunctionActiveIndicator = 1;
    // run the query
    Iterator Results = getPersistenceBrokerTemplate().getReportQueryIteratorByQuery(rptQueryID);
    while (Results.hasNext()) {
        SLF = new FiscalYearFunctionControl();
        Object[] resultFields = (Object[]) Results.next();
        String flagTag = (String) resultFields[sqlFunctionControlCode];
        //          String flagDefault = (String) resultFields[sqlFunctionActiveIndicator];
        //  apparently OJB is smart enough to bring this in as a boolean
        boolean flagDefault = (Boolean) resultFields[sqlFunctionActiveIndicator];
        SLF.setUniversityFiscalYear(RequestYear);
        LOG.debug("\nfiscal year has been set");
        SLF.setFinancialSystemFunctionControlCode(flagTag);
        LOG.debug("\nfunction code has been set");
        SLF.setVersionNumber(DEFAULT_VERSION_NUMBER);
        LOG.debug(String.format("\nversion number set to %d", SLF.getVersionNumber()));
        if (flagTag.equals(BudgetConstructionConstants.BUDGET_CONSTRUCTION_GENESIS_RUNNING)) {
            SLF.setFinancialSystemFunctionActiveIndicator(true);
        }
        else {
            //               SLF.setFinancialSystemFunctionActiveIndicator(
            //                       ((flagDefault == KFSConstants.ParameterValues.YES)? true : false));
            SLF.setFinancialSystemFunctionActiveIndicator(flagDefault);
        }
        LOG.debug("\nabout to store the result");
        getPersistenceBrokerTemplate().store(SLF);
    }
}
 

protected void clearBudgetConstructionAdministrativePost() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionAdministrativePost.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearBudgetConstructionAppointmentFundingReason() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionAppointmentFundingReason.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearBCSF() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionCalculatedSalaryFoundationTracker.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearBudgetConstructionIntendedIncumbent() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionIntendedIncumbent.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearBCPosition() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionPosition.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearHeaders() {
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionHeader.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

protected void clearPendingApptFunding() {
    QueryByCriteria queryId = new QueryByCriteria(PendingBudgetConstructionAppointmentFunding.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}
 

public void clearHangingBCLocks(Integer BaseYear) {
    // this routine cleans out any locks that might remain from people leaving
    // the application abnormally (for example, Fire! Fire! Leave your computer and get out now!).  it assumes that
    // people are shut out of the application during a batch run, and that all
    // work prior to the batch run has either been committed, or lost because the connection was broken before a save.
    BudgetConstructionHeader lockedDocuments;
    //
    Integer RequestYear = BaseYear + 1;
    Criteria criteriaID = new Criteria();
    criteriaID.addEqualTo(KFSPropertyConstants.UNIVERSITY_FISCAL_YEAR, RequestYear);
    Criteria lockID = new Criteria();
    Criteria tranLockID = new Criteria();
    if (BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS == null) {
        //  make sure that a NULL test is used in case = NULL is not supported
        //  by the database
        lockID.addNotNull(BCPropertyConstants.BUDGET_LOCK_USER_IDENTIFIER);
        tranLockID.addNotNull(BCPropertyConstants.BUDGET_TRANSACTION_LOCK_USER_IDENTIFIER);
    }
    else {
        lockID.addNotEqualTo(BCPropertyConstants.BUDGET_LOCK_USER_IDENTIFIER, BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS);
        tranLockID.addNotEqualTo(BCPropertyConstants.BUDGET_TRANSACTION_LOCK_USER_IDENTIFIER, BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS);
    }
    ;
    lockID.addOrCriteria(tranLockID);
    criteriaID.addAndCriteria(lockID);
    //
    QueryByCriteria queryID = new QueryByCriteria(BudgetConstructionHeader.class, criteriaID);
    Iterator Results = getPersistenceBrokerTemplate().getIteratorByQuery(queryID);
    //  now just loop through and change the locks
    while (Results.hasNext()) {
        lockedDocuments = (BudgetConstructionHeader) Results.next();
        lockedDocuments.setBudgetLockUserIdentifier(BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS);
        lockedDocuments.setBudgetTransactionLockUserIdentifier(BCConstants.DEFAULT_BUDGET_HEADER_LOCK_IDS);
        getPersistenceBrokerTemplate().store(lockedDocuments);
    }
    //   we need to clear the position and funding locks as well
    clearHangingPositionLocks(RequestYear);
    QueryByCriteria queryId = new QueryByCriteria(BudgetConstructionFundingLock.class, QueryByCriteria.CRITERIA_SELECT_ALL);
    getPersistenceBrokerTemplate().deleteByQuery(queryId);
    getPersistenceBrokerTemplate().clearCache();
}