protected function getScalarValueFromQuery($query)
{
$result = $this->upgradeUtility->executeSql($query);
$row = mysqli_fetch_row($result);
$logMessage = print_r($row, true);
UpgradeLogger::writeLogMessage($logMessage);
$value = $row[0];
UpgradeLogger::writeLogMessage('value = ' . $value . ' value + 1 = ' . ($value + 1));
return $value + 1;
}
public function executeSql($query)
{
$result = mysqli_query($this->dbConnection, $query);
UpgradeLogger::writeLogMessage('Executing SQL:' . $query);
if (!$result) {
$logMessage = 'MySQL Error: ' . mysqli_error($this->dbConnection) . ". \nQuery: {$query}\n";
UpgradeLogger::writeErrorMessage($logMessage, true);
}
return $result;
}
public function execute($request)
{
$dbInfo = $this->getUser()->getAttribute('dbInfo');
$taskNo = $request->getParameter('task');
UpgradeLogger::writeLogMessage('Task:' . $taskNo);
$currentTask = "SchemaIncrementTask{$taskNo}";
UpgradeLogger::writeLogMessage("Running task class: {$currentTask}");
$task = new $currentTask($dbInfo);
try {
$task->execute();
} catch (Exception $e) {
UpgradeLogger::writeErrorMessage("Error when running task: " . $e->getMessage() . ', stacktrace = ' . $e->getTraceAsString());
}
$progeress = $task->getProgress();
$arr = array('progress' => $progeress);
echo json_encode($arr);
}
protected function getLeavePeriodList()
{
if (is_null($this->leavePeriodList)) {
$leavePeriods = array();
$result = $this->upgradeUtility->executeSql('select * from ohrm_leave_period_history order by created_at, id');
if (!$result) {
throw new Exception("query failed");
}
while ($row = mysqli_fetch_array($result)) {
$leavePeriods[] = $row;
}
$this->leavePeriodList = $this->getGeneratedLeavePeriodList($leavePeriods);
UpgradeLogger::writeLogMessage("Leave Period List: " . print_r($this->leavePeriodList, true));
}
return $this->leavePeriodList;
}
