/*
* 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;
}
}