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