public function process(Vtiger_Request $request)
{
global $current_user;
global $root_directory;
$baflayps = "adb";
${"GLOBALS"}["luuhjzd"] = "result";
$hnrergoqncb = "workflowID";
${"GLOBALS"}["swtsotcec"] = "qualifiedModuleName";
${$baflayps} = PearDatabase::getInstance();
${"GLOBALS"}["qpgwks"] = "sql";
${${"GLOBALS"}["hxnhbexxth"]} = $request->getModule();
$hrnudh = "sql";
${"GLOBALS"}["dgvcsdbd"] = "viewer";
${${"GLOBALS"}["swtsotcec"]} = $request->getModule(false);
$ylrvxdxw = "errors";
${${"GLOBALS"}["dgvcsdbd"]} = $this->getViewer(${${"GLOBALS"}["vndwqun"]});
${$hnrergoqncb} = (int) $request->get("workflow_id");
${${"GLOBALS"}["qpgwks"]} = "SELECT * FROM vtiger_wf_errorlog WHERE workflow_id = " . ${${"GLOBALS"}["iixbxxmrvuvd"]};
${${"GLOBALS"}["ftihtoot"]} = $adb->query(${$hrnudh});
$viewer->assign("workflow_id", ${${"GLOBALS"}["iixbxxmrvuvd"]});
${${"GLOBALS"}["twlpnmw"]} = array();
while (${${"GLOBALS"}["poxjutxofp"]} = $adb->fetchByAssoc(${${"GLOBALS"}["luuhjzd"]})) {
$neerouqdsox = "row";
${"GLOBALS"}["cnptdybl"] = "row";
${${"GLOBALS"}["cnptdybl"]}["datum_eintrag"] = VtUtils::formatUserDate(${${"GLOBALS"}["poxjutxofp"]}["datum_eintrag"]);
${${"GLOBALS"}["twlpnmw"]}[] = ${$neerouqdsox};
}
$viewer->assign("errors", ${$ylrvxdxw});
echo $viewer->view("ErrorLog.tpl", ${${"GLOBALS"}["glixorebwvtb"]}, true);
}
public function showStatistikForm($viewer)
{
global $adb;
$class = CRMEntity::getInstance($this->getModuleName());
$fieldname = $class->list_link_field;
$sql = "SELECT columnname, tablename FROM vtiger_field WHERE tabid = " . getTabId($this->getModuleName()) . " AND fieldname = ?";
$result = $adb->pquery($sql, array($fieldname));
$columnName = $adb->query_result($result, 0, "columnname");
$tableName = $adb->query_result($result, 0, "tablename");
$sql = "SELECT vtiger_wf_queue.*, recordTBL." . $columnName . " as title\n FROM vtiger_wf_queue\n LEFT JOIN " . $tableName . " as recordTBL ON (recordTBL." . $class->table_index . " = vtiger_wf_queue.crmid)\n WHERE block_id = " . $this->_taskID;
$result = $adb->query($sql, true);
$waiting = array();
while ($row = $adb->fetch_array($result)) {
$row["timestamp"] = VtUtils::formatUserDate(VtUtils::convertToUserTZ($row["timestamp"]));
$row["nextsteptime"] = VtUtils::formatUserDate(VtUtils::convertToUserTZ($row["nextsteptime"]));
$waiting[] = $row;
}
$viewer->assign("waiting", $waiting);
}
${"GLOBALS"}["lyiupor"] = "errors";
${"GLOBALS"}["hgxcxmxrb"] = "theme";
${"GLOBALS"}["zanpkuubb"] = "current_language";
${"GLOBALS"}["vrepvdlfosem"] = "app_strings";
${"GLOBALS"}["lvfvlsd"] = "result";
$jyqetpzizi = "smarty";
${"GLOBALS"}["zjdmtrdi"] = "workflowID";
$tlmeurdvn = "row";
${"GLOBALS"}["kcsrqqgkgw"] = "sql";
${"GLOBALS"}["nymnjtnulvk"] = "workflowID";
${"GLOBALS"}["dbvilhykkv"] = "sql";
require_once "autoload_wf.php";
${${"GLOBALS"}["nymnjtnulvk"]} = intval($_GET["workflow_id"]);
${${"GLOBALS"}["kcsrqqgkgw"]} = "SELECT * FROM vtiger_wf_errorlog WHERE workflow_id = " . ${${"GLOBALS"}["zjdmtrdi"]};
${${"GLOBALS"}["lvfvlsd"]} = $adb->query(${${"GLOBALS"}["dbvilhykkv"]});
require_once "Smarty_setup.php";
${$jyqetpzizi} = new vtigerCRM_Smarty();
$smarty->assign("APP", ${${"GLOBALS"}["vrepvdlfosem"]});
$smarty->assign("MOD", return_module_language(${${"GLOBALS"}["zanpkuubb"]}, "Workflow2"));
$smarty->assign("THEME", ${${"GLOBALS"}["hgxcxmxrb"]});
${"GLOBALS"}["boknedqy"] = "workflowID";
$smarty->assign("IMAGE_PATH", "themes/{$theme}/images/");
$smarty->assign("workflow_id", ${${"GLOBALS"}["boknedqy"]});
${${"GLOBALS"}["lyiupor"]} = array();
while (${$tlmeurdvn} = $adb->fetchByAssoc(${${"GLOBALS"}["lvfvlsd"]})) {
$gvelerrodep = "row";
${${"GLOBALS"}["egkhjjkd"]}["datum_eintrag"] = VtUtils::formatUserDate(${$gvelerrodep}["datum_eintrag"]);
${${"GLOBALS"}["lyiupor"]}[] = ${${"GLOBALS"}["egkhjjkd"]};
}
$smarty->assign("errors", ${${"GLOBALS"}["lyiupor"]});
$smarty->display(vtlib_getModuleTemplate("Workflow2", "ErrorLog.tpl"));
