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();
}
