public function generate()
{
//get Revenue Model object
$revenueReportModel = RevenueReportUtils::getRevenueModel($this->revenueReportFile);
//get Dw, WMS, Suplizer data from Db
$dbData = $this->getDbData(array_keys($revenueReportModel->getOrders()));
//get Cybersource data for each order
$csTxnInfoArray = Transaction::getCyberSourceTxnSummary($revenueReportModel);
$reportDataArray = ConsolidatedReportOrders2Array::getReportDataInArray($dbData, $revenueReportModel, $csTxnInfoArray);
$this->logger->debug("reportData" . print_r($reportDataArray, true));
$reportFile = $this->getReportFile();
//$reportFile = $this->reportsFilename;
$this->logger->debug("Report file = " . $reportFile);
$consolidateReportFile = (new OfficeExcelFactory())->createDocument($this->templateReportSheet, $reportFile, "0", $reportDataArray, "A3");
$this->logger->debug("Report file generated " . $reportFile);
$this->emailReport($reportFile);
}
function setUp($argv, $argc)
{
$logger = QCLogger::getInstance();
$logger->info("BEGIN " . __METHOD__);
$revenueReportFile = RevenueReportUtils::getReportFileName($argv);
if (!$argv) {
$revenueReportFile = "/tmp/ck-daily-sales.csv";
}
Registry::getInstance()->add('revenueReportFile', $revenueReportFile);
if (!file_exists($revenueReportFile)) {
$exception = new Exception("Revenue Report file " . $revenueReportFile . " is not found");
$this->handleSetupError($exception);
throw $exception;
}
$revenueReport = new RevenueCSV($revenueReportFile);
$csvRecords = $revenueReport->getCsvRecords()->setOffset(1)->fetchAll();
Registry::getInstance()->add('csvRecords', $csvRecords);
$revenueReportModel = RevenueCSV2Model::transform($csvRecords);
if ($revenueReportModel) {
$revenueReportModel->setRevenueReportFile($revenueReportFile);
}
Registry::getInstance()->add('revReportModel', $revenueReportModel);
$logger->info("END " . __METHOD__);
}