public function process(Vtiger_Request $request) { ${"GLOBALS"}["kntwfslol"] = "adb"; ${"GLOBALS"}["cqcqlnrkx"] = "response"; ${${"GLOBALS"}["kntwfslol"]} = PearDatabase::getInstance(); ${${"GLOBALS"}["cqcqlnrkx"]} = new Vtiger_Response(); try { $wtjgzysvem = "sql"; $oeptxvdvox = "execID"; $zwwfbo = "result"; ${$oeptxvdvox} = preg_replace("/[^a-zA-Z0-9]/", "", $request->get("execID")); ${"GLOBALS"}["yhkcnorwnk"] = "result"; ${$wtjgzysvem} = "SELECT * FROM vtiger_wf_log WHERE execID = ?"; ${$zwwfbo} = $adb->pquery(${${"GLOBALS"}["cxjkyjhyclpd"]}, array(${${"GLOBALS"}["pbqqoiw"]})); ${${"GLOBALS"}["ezmcfbv"]} = array(); while (${${"GLOBALS"}["lndkyrocpr"]} = $adb->fetch_array(${${"GLOBALS"}["yhkcnorwnk"]})) { $vjmvxw = "row"; $mroetkdbdx = "row"; $lmqbvml = "row"; ${${"GLOBALS"}["ezmcfbv"]}[] = array(${$lmqbvml}["blockid"], ${$mroetkdbdx}["lastblockid"], ${${"GLOBALS"}["lndkyrocpr"]}["lastblockoutput"], "timestamp" => \Workflow\VtUtils::formatUserDate(${$vjmvxw}["timestamp"])); } $response->setResult(array("success" => true, "execID" => ${${"GLOBALS"}["pbqqoiw"]}, "data" => ${${"GLOBALS"}["ezmcfbv"]})); } catch (Exception $exp) { $response->setResult(array("success" => false, "error" => $exp->getMessage())); } $response->emit(); }
public function process(Vtiger_Request $request) { ${"GLOBALS"}["fhroilgzonyy"] = "page"; $mlhumypv = "adb"; ${$mlhumypv} = PearDatabase::getInstance(); ${${"GLOBALS"}["hqudficgecd"]} = new Vtiger_Response(); ${${"GLOBALS"}["lolccjqn"]} = 10; ${${"GLOBALS"}["ebuqkxmsj"]} = $request->get("page"); if (empty(${${"GLOBALS"}["fhroilgzonyy"]})) { $moizev = "page"; ${$moizev} = 1; } try { ${"GLOBALS"}["hsitlbs"] = "sql2"; $heqfgpoydpcn = "source"; $zkntfoshn = "sourceParts"; ${$heqfgpoydpcn} = $request->get("source"); ${${"GLOBALS"}["xrwbikdvfh"]} = $request->get("destination"); $cfjdvntdrre = "startDate"; $imxrfvdjfn = "result"; $oypicnzev = "page"; $yadbqslg = "resultLimit"; ${"GLOBALS"}["kckljssu"] = "sourceParts"; ${${"GLOBALS"}["sfjciicw"]} = date("Y-m-d", strtotime($request->get("startDate"))); ${${"GLOBALS"}["npplbckxxrk"]} = date("Y-m-d", strtotime($request->get("endDate"))); ${${"GLOBALS"}["kcklyqteqi"]} = $request->get("module_name"); ${${"GLOBALS"}["kixsuliubye"]} = explode("__", ${${"GLOBALS"}["rujvorudc"]}); ${${"GLOBALS"}["zrqwcwjukd"]} = explode("__", ${${"GLOBALS"}["xrwbikdvfh"]}); $utpusbb = "sql"; ${"GLOBALS"}["mflbymktjc"] = "recordsPerPage"; $xfvvvlyflsvh = "endDate"; ${$utpusbb} = "SELECT SQL_CALC_FOUND_ROWS vtiger_crmentity.label as link_field, vtiger_wf_log.crmid, vtiger_wf_log.timestamp, vtiger_wf_log.execID\n FROM vtiger_wf_log\n LEFT JOIN vtiger_crmentity ON (vtiger_crmentity.crmid = vtiger_wf_log.crmid)\n WHERE lastBlockId = " . ${${"GLOBALS"}["kckljssu"]}[1] . " AND lastBlockOutput = '" . ${$zkntfoshn}[2] . "' AND blockID = '" . ${${"GLOBALS"}["zrqwcwjukd"]}[1] . "' AND timestamp >= '" . ${$cfjdvntdrre} . " 00:00:00' AND timestamp <= '" . ${$xfvvvlyflsvh} . " 23:59:00' ORDER BY timestamp DESC LIMIT " . (${$oypicnzev} - 1) * ${${"GLOBALS"}["lolccjqn"]} . ", " . ${${"GLOBALS"}["lolccjqn"]}; ${"GLOBALS"}["tcccbbpfstfn"] = "page"; ${$imxrfvdjfn} = $adb->query(${${"GLOBALS"}["qnnyqmyvf"]}, true); ${${"GLOBALS"}["hsitlbs"]} = "SELECT FOUND_ROWS() as num"; ${$yadbqslg} = $adb->query(${${"GLOBALS"}["xtupcus"]}); ${${"GLOBALS"}["suhtsvbd"]} = $adb->query_result(${${"GLOBALS"}["rezcfzhix"]}, 0, "num"); ${${"GLOBALS"}["lmivvvbjgld"]} = array(); while (${${"GLOBALS"}["fnofpor"]} = $adb->fetch_array(${${"GLOBALS"}["bwxlxr"]})) { ${"GLOBALS"}["mvawfmjqccp"] = "row"; $lsambsthxfgd = "row"; $kycwglrul = "data"; $eptvvpebu = "row"; if (empty(${${"GLOBALS"}["mvawfmjqccp"]}["link_field"])) { ${${"GLOBALS"}["fnofpor"]}["link_field"] = "no Record"; } ${$kycwglrul}[] = array("title" => substr(${${"GLOBALS"}["fnofpor"]}["link_field"], 0, 25), "execID" => ${${"GLOBALS"}["fnofpor"]}["execid"], "timestamp" => \Workflow\VtUtils::formatUserDate(${$eptvvpebu}["timestamp"]), "crmid" => ${$lsambsthxfgd}["crmid"], "url" => "index.php?module=" . ${${"GLOBALS"}["kcklyqteqi"]} . "&view=Detail&record=" . ${${"GLOBALS"}["fnofpor"]}["crmid"]); } $response->setResult(array("success" => true, "data" => ${${"GLOBALS"}["lmivvvbjgld"]}, "page" => ${${"GLOBALS"}["tcccbbpfstfn"]}, "totalpages" => ceil(${${"GLOBALS"}["suhtsvbd"]} / ${${"GLOBALS"}["mflbymktjc"]}))); } catch (Exception $exp) { $response->setResult(array("success" => false, "error" => $exp->getMessage())); } $response->emit(); }