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