public static function getReferenceFieldsForModule($module_name) { global $adb; $relations = array(); $sql = "SELECT tabid, fieldname, fieldlabel, uitype, fieldid FROM vtiger_field WHERE tabid = " . getTabID($module_name) . " AND (uitype = 10 OR uitype = 51 OR uitype = 52 OR uitype = 53 OR uitype = 57 OR uitype = 58 OR uitype = 59 OR uitype = 73 OR uitype = 75 OR uitype = 76 OR uitype = 78 OR uitype = 80 OR uitype = 81 OR uitype = 68)"; $result = $adb->query($sql); while ($row = $adb->fetchByAssoc($result)) { switch ($row["uitype"]) { case "51": $row["module"] = "Accounts"; $relations[] = $row; break; case "52": $row["module"] = "Users"; $relations[] = $row; break; case "53": $row["module"] = "Users"; $relations[] = $row; break; case "57": $row["module"] = "Contacts"; $relations[] = $row; break; case "58": $row["module"] = "Campaigns"; $relations[] = $row; break; case "59": $row["module"] = "Products"; $relations[] = $row; break; case "73": $row["module"] = "Accounts"; $relations[] = $row; break; case "75": $row["module"] = "Vendors"; $relations[] = $row; break; case "81": $row["module"] = "Vendors"; $relations[] = $row; break; case "76": $row["module"] = "Potentials"; $relations[] = $row; break; case "78": $row["module"] = "Quotes"; $relations[] = $row; break; case "80": $row["module"] = "SalesOrder"; $relations[] = $row; break; case "68": $row["module"] = "Accounts"; $relations[] = $row; $row["module"] = "Contacts"; break; case "10": # Possibly multiple relations $result = $adb->pquery('SELECT relmodule FROM `vtiger_fieldmodulerel` WHERE fieldid = ?', array($row["fieldid"])); while ($data = $adb->fetch_array($result)) { $row["module"] = $data["relmodule"]; $relations[] = $row; } break; } } return $relations; }
public static function getReferenceFieldsForModule($module_name) { $qowqrdypnc = "sql"; global $adb; ${${"GLOBALS"}["yyjqckjcwf"]} = array(); ${$qowqrdypnc} = "SELECT tabid, fieldname, fieldlabel FROM vtiger_field WHERE tabid = ? AND (uitype = 10 OR uitype = 51 OR uitype = 52 OR uitype = 53 OR uitype = 57 OR uitype = 58 OR uitype = 59 OR uitype = 73 OR uitype = 75 OR uitype = 76 OR uitype = 78 OR uitype = 80 OR uitype = 81 OR uitype = 68)"; ${"GLOBALS"}["ohevoy"] = "relations"; ${${"GLOBALS"}["rnuyovw"]} = $adb->pquery(${${"GLOBALS"}["fbcyfklnb"]}, array(getTabID(${${"GLOBALS"}["kgrlqorxi"]}))); while (${${"GLOBALS"}["sopxgdjixkr"]} = $adb->fetchByAssoc(${${"GLOBALS"}["rnuyovw"]})) { $iwtpcisfbv = "relations"; ${${"GLOBALS"}["sopxgdjixkr"]}["module"] = self::getModuleName(${${"GLOBALS"}["sopxgdjixkr"]}["tabid"]); ${$iwtpcisfbv}[] = ${${"GLOBALS"}["sopxgdjixkr"]}; } return ${${"GLOBALS"}["ohevoy"]}; }
public static function getReferenceFieldsForModule($module_name) { ${"GLOBALS"}["nclqwpsdr"] = "sql"; $lwtowgpsgn = "module_name"; global $adb; $nxfrcha = "result"; ${${"GLOBALS"}["meksrmbcf"]} = array(); $ttmhqf = "row"; ${${"GLOBALS"}["trhmtwd"]} = "SELECT tabid, fieldname, fieldlabel, uitype, fieldid FROM vtiger_field WHERE tabid = " . getTabID(${$lwtowgpsgn}) . " AND (uitype = 10 OR uitype = 51 OR uitype = 52 OR uitype = 53 OR uitype = 57 OR uitype = 58 OR uitype = 59 OR uitype = 73 OR uitype = 75 OR uitype = 76 OR uitype = 78 OR uitype = 80 OR uitype = 81 OR uitype = 68)"; ${${"GLOBALS"}["yxurcyqzbn"]} = $adb->query(${${"GLOBALS"}["nclqwpsdr"]}); while (${$ttmhqf} = $adb->fetchByAssoc(${$nxfrcha})) { $jdhnxqra = "relations"; ${"GLOBALS"}["imsoinppy"] = "row"; ${"GLOBALS"}["puvbyqak"] = "relations"; $lylamsyutjn = "row"; ${"GLOBALS"}["gooagoyntq"] = "row"; $poowxummgjo = "row"; ${"GLOBALS"}["rkrbhc"] = "row"; $xhkwlfzfjsdy = "row"; $jdhyuubw = "row"; ${"GLOBALS"}["gcjytpdbc"] = "row"; ${"GLOBALS"}["ftowlp"] = "row"; $jitfxd = "row"; ${"GLOBALS"}["xrtcsgnjurn"] = "relations"; $dyydhbugtn = "relations"; $jjpndvrnac = "row"; ${"GLOBALS"}["irlvttvwmgi"] = "relations"; ${"GLOBALS"}["dpeobg"] = "row"; ${"GLOBALS"}["iawmvjo"] = "row"; $nifrgfge = "row"; ${"GLOBALS"}["hsiihxghxmo"] = "relations"; switch (${${"GLOBALS"}["mnxpcyvt"]}["uitype"]) { case "51": ${${"GLOBALS"}["gcjytpdbc"]}["module"] = "Accounts"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["ftowlp"]}; break; case "52": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Users"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "53": ${$jdhyuubw}["module"] = "Users"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "57": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Contacts"; ${${"GLOBALS"}["irlvttvwmgi"]}[] = ${${"GLOBALS"}["iawmvjo"]}; break; case "58": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Campaigns"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${$xhkwlfzfjsdy}; break; case "59": ${${"GLOBALS"}["rkrbhc"]}["module"] = "Products"; ${$jdhnxqra}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "73": ${$lylamsyutjn}["module"] = "Accounts"; ${${"GLOBALS"}["hsiihxghxmo"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "75": ${${"GLOBALS"}["imsoinppy"]}["module"] = "Vendors"; ${${"GLOBALS"}["puvbyqak"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "81": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Vendors"; ${$dyydhbugtn}[] = ${$jitfxd}; break; case "76": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Potentials"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; break; case "78": ${$nifrgfge}["module"] = "Quotes"; ${${"GLOBALS"}["xrtcsgnjurn"]}[] = ${$poowxummgjo}; break; case "80": ${$jjpndvrnac}["module"] = "SalesOrder"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["dpeobg"]}; break; case "68": ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Accounts"; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["mnxpcyvt"]}; ${${"GLOBALS"}["mnxpcyvt"]}["module"] = "Contacts"; break; case "10": ${${"GLOBALS"}["gkebfktvp"]} = \Workflow\VtUtils::pquery("SELECT relmodule FROM `vtiger_fieldmodulerel` WHERE fieldid = ?", array(${${"GLOBALS"}["gooagoyntq"]}["fieldid"])); while (${${"GLOBALS"}["rpgtsocbjybb"]} = $adb->fetch_array(${${"GLOBALS"}["gkebfktvp"]})) { ${"GLOBALS"}["fwuxxjy"] = "data"; ${"GLOBALS"}["dwpnun"] = "row"; ${${"GLOBALS"}["mnxpcyvt"]}["module"] = ${${"GLOBALS"}["fwuxxjy"]}["relmodule"]; ${${"GLOBALS"}["meksrmbcf"]}[] = ${${"GLOBALS"}["dwpnun"]}; } break; } } return ${${"GLOBALS"}["meksrmbcf"]}; }