private function _checkField($check)
{
$hokekyg = "check";
$irkmjqniy = "check";
$vuomcowj = "check";
$qxtftfelfc = "checkvalue";
global $adb;
if (${$vuomcowj}["mode"] == "value" || empty(${$hokekyg}["mode"])) {
$ljuuqqmpe = "checkvalue";
$qlncurmce = "check";
${"GLOBALS"}["sjpunfxie"] = "checkvalue";
${$ljuuqqmpe} = ${$qlncurmce}["rawvalue"];
if (strpos(${${"GLOBALS"}["mhtrtpoxqog"]}, "\$") !== false || strpos(${${"GLOBALS"}["sjpunfxie"]}, "?") !== false) {
$kasuqypyri = "objTemplate";
${$kasuqypyri} = new VTTemplate($this->_context);
${${"GLOBALS"}["mhtrtpoxqog"]} = $objTemplate->render(${${"GLOBALS"}["mhtrtpoxqog"]});
}
} elseif (${$irkmjqniy}["mode"] == "function") {
$mslifxq = "parser";
${$mslifxq} = new ExpressionParser(${${"GLOBALS"}["eikcioit"]}["rawvalue"], $this->_context, false);
try {
$parser->run();
} catch (ExpressionException $exp) {
\Workflow2::error_handler(E_EXPRESSION_ERROR, $exp->getMessage(), "", "");
}
${${"GLOBALS"}["mhtrtpoxqog"]} = $parser->getReturn();
}
if (preg_match("/^([0-9]+)x([0-9]+)\$/", ${${"GLOBALS"}["mhtrtpoxqog"]}, ${${"GLOBALS"}["rltbvvdxzi"]})) {
${${"GLOBALS"}["mhtrtpoxqog"]} = ${${"GLOBALS"}["rltbvvdxzi"]}[2];
}
$qpbidpqzyuq = "check";
if (${$qpbidpqzyuq}["field"] != "crmid") {
$opnieudoijq = "result";
$icdvseqgj = "sql";
$wedbbjpbzg = "check";
${"GLOBALS"}["ssickqrh"] = "result";
$lguveyud = "referenceUitypes";
${"GLOBALS"}["fhxqfbe"] = "check";
${$icdvseqgj} = "SELECT columnname, tablename, uitype FROM vtiger_field WHERE (fieldname = ? OR columnname = ?) AND tabid = " . getTabId($this->_module);
${"GLOBALS"}["ufdgmzwrnd"] = "fieldData";
${$opnieudoijq} = $adb->pquery(${${"GLOBALS"}["gewfwuwzyf"]}, array(${${"GLOBALS"}["fhxqfbe"]}["field"], ${$wedbbjpbzg}["field"]), true);
$vnwwwkurvnc = "fieldData";
${${"GLOBALS"}["ufdgmzwrnd"]} = $adb->fetchByAssoc(${${"GLOBALS"}["ssickqrh"]});
if (${$vnwwwkurvnc}["columnname"] == "idlists" && $this->_module == "Emails") {
${${"GLOBALS"}["skdkydufqc"]} = array("vtiger_seactivityrel`.`crmid");
} else {
$dknamdhd = "fieldData";
${${"GLOBALS"}["skdkydufqc"]} = array("" . ${${"GLOBALS"}["chbluaeolj"]}["tablename"] . "`.`" . ${$dknamdhd}["columnname"]);
}
if (in_array(intval(${${"GLOBALS"}["chbluaeolj"]}["uitype"]), VtUtils::${$lguveyud})) {
${"GLOBALS"}["usovmy"] = "fieldData";
${"GLOBALS"}["fcynigpd"] = "modules";
${"GLOBALS"}["mxfotnkuck"] = "modules";
${${"GLOBALS"}["mxfotnkuck"]} = VtUtils::getModuleForReference(getTabId($this->_module), ${${"GLOBALS"}["eikcioit"]}["field"], ${${"GLOBALS"}["usovmy"]}["uitype"]);
if (count(${${"GLOBALS"}["fcynigpd"]}) == 1) {
foreach (${${"GLOBALS"}["mkwcgvqozj"]} as ${${"GLOBALS"}["nrfjjlktok"]}) {
${"GLOBALS"}["ynidmvalhyi"] = "tableName";
$cegjqy = "fieldNames";
${"GLOBALS"}["fjvfyzyeo"] = "tmpFocus";
$npekrqhn = "tableName";
$gbhhegbtpt = "fieldData";
${"GLOBALS"}["iijrcvdcux"] = "check";
${${"GLOBALS"}["fjvfyzyeo"]} = \CRMEntity::getInstance(${${"GLOBALS"}["nrfjjlktok"]});
${$npekrqhn} = "t" . count($this->_joinTables) . "_" . ${${"GLOBALS"}["nrfjjlktok"]} . "_" . ${${"GLOBALS"}["iijrcvdcux"]}["field"] . "";
$this->_joinTables[] = "LEFT JOIN " . $tmpFocus->table_name . " as " . ${${"GLOBALS"}["vudkckyuiho"]} . " ON (`" . ${${"GLOBALS"}["ynidmvalhyi"]} . "`.`" . $tmpFocus->table_index . "` = `" . ${${"GLOBALS"}["skdkydufqc"]}[0] . "`)";
${${"GLOBALS"}["chbluaeolj"]}["tablename"] = ${${"GLOBALS"}["vudkckyuiho"]};
${${"GLOBALS"}["chbluaeolj"]}["columnname"] = $tmpFocus->list_link_field;
${$cegjqy}[] = "" . ${${"GLOBALS"}["chbluaeolj"]}["tablename"] . "`.`" . ${$gbhhegbtpt}["columnname"];
}
}
}
} else {
$qivvqrqqp = "fieldNames";
${$qivvqrqqp} = array("vtiger_crmentity`.`crmid");
}
$kmvwkdvr = "fieldNames";
$this->log("Check field: " . ${${"GLOBALS"}["eikcioit"]}["field"] . " " . ${${"GLOBALS"}["eikcioit"]}["operation"] . " - " . ${$qxtftfelfc});
if (!empty(${${"GLOBALS"}["eikcioit"]}["not"])) {
${"GLOBALS"}["msavtqzgbd"] = "not";
${${"GLOBALS"}["msavtqzgbd"]} = true;
} else {
$plzzuz = "not";
${$plzzuz} = false;
}
${${"GLOBALS"}["dewpeeyj"]} = array();
foreach (${$kmvwkdvr} as ${${"GLOBALS"}["mtsrsml"]}) {
${"GLOBALS"}["pnlaybj"] = "fieldName";
${"GLOBALS"}["rgeraojxbe"] = "tmpSQL";
$gysrpkkbjro = "not";
${"GLOBALS"}["xoeshlppye"] = "tmpSQL";
${"GLOBALS"}["ufiulnugtpse"] = "not";
${"GLOBALS"}["oihhykbnakpg"] = "tmpSQL";
${"GLOBALS"}["jhgyja"] = "fieldName";
$ocjyevynyxer = "fieldName";
$ddtsdwnjdi = "tmpSQL";
${"GLOBALS"}["irkqsiczmnje"] = "fieldName";
${"GLOBALS"}["xzodapm"] = "not";
$wwqfpoc = "tmpSQL";
$firifzks = "fieldName";
${"GLOBALS"}["glhofthvju"] = "fieldName";
$djtrtm = "checkvalue";
$fxmphdvibp = "checkvalue";
$ppsxsaud = "check";
${"GLOBALS"}["ctfovcryrmyx"] = "checkvalue";
switch (${$ppsxsaud}["operation"]) {
case "equal":
${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${$firifzks} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "!" : "") . "= " . $adb->quote(${${"GLOBALS"}["ctfovcryrmyx"]}) . "";
break;
case "contains":
${${"GLOBALS"}["xoeshlppye"]}[] = "`" . ${${"GLOBALS"}["mtsrsml"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "NOT " : "") . "LIKE " . $adb->quote("%" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "%") . "";
break;
case "starts_with":
${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${${"GLOBALS"}["pnlaybj"]} . "` " . (${${"GLOBALS"}["xzodapm"]} ? "NOT " : "") . "LIKE " . $adb->quote(${${"GLOBALS"}["mhtrtpoxqog"]} . "%") . "";
break;
case "ends_with":
${${"GLOBALS"}["oihhykbnakpg"]}[] = "`" . ${${"GLOBALS"}["mtsrsml"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "NOT " : "") . "LIKE " . $adb->quote("%" . ${$fxmphdvibp} . "") . "";
break;
case "bigger":
${$wwqfpoc}[] = "`" . ${${"GLOBALS"}["irkqsiczmnje"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "<=" : ">") . " " . $adb->quote("" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "") . "";
break;
case "lower":
${${"GLOBALS"}["dewpeeyj"]}[] = "`" . ${$ocjyevynyxer} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? ">=" : "<") . " " . $adb->quote("" . ${${"GLOBALS"}["mhtrtpoxqog"]} . "") . "";
break;
case "is_checked":
${$ddtsdwnjdi}[] = "`" . ${${"GLOBALS"}["jhgyja"]} . "` " . (${${"GLOBALS"}["gltggtgnj"]} ? "!" : "") . "= " . $adb->quote("" . ${$djtrtm} . "") . "";
break;
case "is_empty":
if (!${$gysrpkkbjro}) {
$snfeziwysq = "check";
$xbwkmiws = "fieldName";
${${"GLOBALS"}["dewpeeyj"]}[] = "(`" . ${$xbwkmiws} . "` = '' OR`" . ${$snfeziwysq}["field"] . "` = '0')";
} else {
${"GLOBALS"}["pldqrvs"] = "fieldName";
${${"GLOBALS"}["dewpeeyj"]}[] = "(`" . ${${"GLOBALS"}["pldqrvs"]} . "` != '')";
}
break;
case "date_empty":
if (!${${"GLOBALS"}["gltggtgnj"]}) {
$qdiribn = "fieldName";
$bbosypyhslk = "tmpSQL";
${$bbosypyhslk}[] = "(`" . ${${"GLOBALS"}["mtsrsml"]} . "` IS NULL OR DATE(`" . ${$qdiribn} . "`) = '0000-00-00')";
} else {
${"GLOBALS"}["pwcutq"] = "fieldName";
$egvstey = "tmpSQL";
${$egvstey}[] = "(`" . ${${"GLOBALS"}["pwcutq"]} . "` IS NOT NULL AND DATE(`" . ${${"GLOBALS"}["mtsrsml"]} . "`) != '0000-00-00')";
}
break;
case "is_numeric":
${${"GLOBALS"}["rgeraojxbe"]}[] = "(`" . ${${"GLOBALS"}["glhofthvju"]} . "` " . (${${"GLOBALS"}["ufiulnugtpse"]} ? "NOT " : "") . "REGEXP '-?[0-9]+')";
break;
}
}
$this->_sql[] = "((" . implode(") OR (", ${${"GLOBALS"}["dewpeeyj"]}) . "))";
return false;
}
