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"));