/**
* @see interface_admin_systemtask::executeTask()
* @return string
*/
public function executeTask()
{
if (!class_module_system_module::getModuleByName("system")->rightRight2()) {
return $this->getLang("commons_error_permissions");
}
$intI = 0;
$strReturn = "";
$objWorker = new class_module_system_worker();
//chec 1.level nodes
$arrCorruptedRecords = $objWorker->checkFirstLevelNodeConsistency();
//create the output tables
if (count($arrCorruptedRecords) > 0) {
//ohoh. errors found. create tow tables
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_firstlevel_error"), getImageAdmin("icon_disabled"), "", ++$intI);
foreach ($arrCorruptedRecords as $arrRow) {
$objRecord = class_objectfactory::getInstance()->getObject($arrRow["system_id"]);
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $arrRow["system_id"] . " (" . uniStrTrim($objRecord != null ? $objRecord->getStrDisplayName() : $arrRow["system_comment"], 20) . ")", "", "", $intI);
}
$strReturn .= $this->objToolkit->listFooter();
} else {
//no errors found
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_firstlevel_ok"), getImageAdmin("icon_enabled"), "", ++$intI);
$strReturn .= $this->objToolkit->listFooter();
}
//Check system_prev_id => system_id relations
$arrCorruptedRecords = $objWorker->checkSystemTableCurPrevRelations();
//create the output tables
if (count($arrCorruptedRecords) > 0) {
//ohoh. errors found. create tow tables
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_curprev_error"), getImageAdmin("icon_disabled"), "", ++$intI);
foreach ($arrCorruptedRecords as $strID => $strComment) {
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $strID . " (" . $strComment . ")", "", "", $intI);
}
$strReturn .= $this->objToolkit->listFooter();
} else {
//no errors found
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_curprev_ok"), getImageAdmin("icon_enabled"), "", ++$intI);
$strReturn .= $this->objToolkit->listFooter();
}
//check if every right-record has a system-record
$arrCorruptedRecords = $objWorker->chekRightSystemRelations();
//create the output tables
if (count($arrCorruptedRecords) > 0) {
//ohoh. errors found. create tow tables
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_right_error"), getImageAdmin("icon_disabled"), "", ++$intI);
foreach ($arrCorruptedRecords as $arrOneRecords) {
$objRecord = class_objectfactory::getInstance()->getObject($arrOneRecords["system_id"]);
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $arrOneRecords["right_id"] . " (" . uniStrTrim($objRecord != null ? $objRecord->getStrDisplayName() : $arrOneRecords["system_comment"], 20) . ")", "", "", $intI);
}
$strReturn .= $this->objToolkit->listFooter();
} else {
//no errors found
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_right_ok"), getImageAdmin("icon_enabled"), "", ++$intI);
$strReturn .= $this->objToolkit->listFooter();
}
//check if every date-record has a system-record
$arrCorruptedRecords = $objWorker->checkDateSystemRelations();
//create the output tables
if (count($arrCorruptedRecords) > 0) {
//ohoh. errors found. create tow tables
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_date_error"), getImageAdmin("icon_disabled"), "", ++$intI);
foreach ($arrCorruptedRecords as $arrOneRecords) {
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $arrOneRecords["system_date_id"], "", "", $intI);
}
$strReturn .= $this->objToolkit->listFooter();
} else {
//no errors found
$strReturn .= $this->objToolkit->listHeader();
$strReturn .= $this->objToolkit->genericAdminList(generateSystemid(), $this->getLang("systemtask_dbconsistency_date_ok"), getImageAdmin("icon_enabled"), "", ++$intI);
$strReturn .= $this->objToolkit->listFooter();
}
return $strReturn;
}