/* * The Kuali Financial System, a comprehensive financial management system for higher education. * * Copyright 2005-2014 The Kuali Foundation * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU Affero General Public License as * published by the Free Software Foundation, either version 3 of the * License, or (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Affero General Public License for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package org.kuali.kfs.module.cab.batch; import java.sql.Timestamp; import java.util.Date; import org.apache.log4j.Logger; import org.kuali.kfs.module.cab.batch.service.BatchExtractReportService; import org.kuali.kfs.module.cab.batch.service.BatchExtractService; import org.kuali.kfs.sys.batch.AbstractStep; import org.kuali.rice.core.api.datetime.DateTimeService; public class ExtractStep extends AbstractStep { private static final Logger LOG = Logger.getLogger(ExtractStep.class); private BatchExtractService batchExtractService; private DateTimeService dateTimeService; private BatchExtractReportService batchExtractReportService; /** * CAB Extract Steps * <li>Find all GL transactions created after last extract time matching CAB filter parameters</li> * <li>For each GL line perform the following steps</li> * <li>Check GL lines belongs to a PO or Not</li> * <li>If not PO related, then check for duplicate in CB_GL_ENTRY_T, if not duplicate insert into CB_GL_ENTRY_T</li> * <li>If PO related, check against PURAP Account Line Revision History for respective PREQ or CM document</li> * <li>If sum of amounts matches grouped by fields "univ_fiscal_yr, fin_coa_cd, account_nbr, sub_acct_nbr, fin_object_cd, * fin_sub_obj_cd, univ_fiscal_prd_cd, fdoc_nbr, fdoc_ref_nbr" then it is a valid one, else ignore the GL lines for the document * and write to the reconciliation report </li> * <li>If CB_PUR_DOC entry doesn't exist, insert new record else update active indicator</li> * <li>Insert into CB_PUR_ITM_AST_T when record not exists or inactive, if active exact match found then skip</li> * <li>Insert one/multiple entries into CB_PUR_LN_AST_ACCT_T, amount should match exact from account line history</li> * * @see org.kuali.kfs.batch.Step#execute(java.lang.String, java.util.Date) */ @Override public boolean execute(String jobName, Date jobRunDate) throws InterruptedException { ExtractProcessLog processLog = new ExtractProcessLog(); try { Timestamp startTs = dateTimeService.getCurrentTimestamp(); if (LOG.isDebugEnabled()) { LOG.debug("CAB extract started at " + startTs); } processLog.setStartTime(startTs); batchExtractService.performExtract(processLog); processLog.setFinishTime(dateTimeService.getCurrentTimestamp()); } catch (Throwable e) { processLog.setSuccess(false); processLog.setErrorMessage("Unexpected error occured while performing CAB Extract. " + e.toString()); LOG.error("Unexpected error occured while performing CAB Extract.", e); throw new RuntimeException(e); } finally { batchExtractReportService.generateStatusReportPDF(processLog); // create mismatch report if necessary if (processLog.getMismatchedGLEntries() != null && !processLog.getMismatchedGLEntries().isEmpty()) { batchExtractReportService.generateMismatchReportPDF(processLog); } LOG.info("Batch status report is generated successfully."); } return true; } /** * Gets the batchExtractService attribute. * * @return Returns the batchExtractService. */ public BatchExtractService getBatchExtractService() { return batchExtractService; } /** * Sets the batchExtractService attribute value. * * @param batchExtractService The batchExtractService to set. */ public void setBatchExtractService(BatchExtractService batchExtractService) { this.batchExtractService = batchExtractService; } /** * Gets the dateTimeService attribute. * * @return Returns the dateTimeService. */ @Override public DateTimeService getDateTimeService() { return dateTimeService; } /** * Sets the dateTimeService attribute value. * * @param dateTimeService The dateTimeService to set. */ @Override public void setDateTimeService(DateTimeService dateTimeService) { this.dateTimeService = dateTimeService; } /** * Gets the batchExtractReportService attribute. * * @return Returns the batchExtractReportService. */ public BatchExtractReportService getBatchExtractReportService() { return batchExtractReportService; } /** * Sets the batchExtractReportService attribute value. * * @param batchExtractReportService The batchExtractReportService to set. */ public void setBatchExtractReportService(BatchExtractReportService batchExtractReportService) { this.batchExtractReportService = batchExtractReportService; } }