Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
<?php
/*+*******************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
******************************************************************************/
require_once("include/utils/CommonUtils.php");
require_once 'include/Webservices/Utils.php';
require_once 'include/Webservices/DescribeObject.php';
require_once("include/Zend/Json.php");
require_once 'modules/com_vtiger_workflow/expression_engine/VTExpressionsManager.inc';
function vtJsonFields($adb, $request) {
$moduleName = $request['modulename'];
$mem = new VTExpressionsManager($adb);
$fields = $mem->fields($moduleName);
echo Zend_Json::encode(array('moduleFields' => $fields));
}
function vtJsonFunctions($adb) {
$mem = new VTExpressionsManager($adb);
$functions = $mem->expressionFunctions();
echo Zend_Json::encode($functions);
}
function vtJsonDependentModules($adb, $request) {
$moduleName = $request['modulename'];
$result = $adb->pquery("SELECT fieldname, tabid, typeofdata, vtiger_ws_referencetype.type as reference_module FROM vtiger_field
INNER JOIN vtiger_ws_fieldtype ON vtiger_field.uitype = vtiger_ws_fieldtype.uitype
INNER JOIN vtiger_ws_referencetype ON vtiger_ws_fieldtype.fieldtypeid = vtiger_ws_referencetype.fieldtypeid
UNION
SELECT fieldname, tabid, typeofdata, relmodule as reference_module FROM vtiger_field
INNER JOIN vtiger_fieldmodulerel ON vtiger_field.fieldid = vtiger_fieldmodulerel.fieldid", array());
$noOfFields = $adb->num_rows($result);
$dependentFields = array();
// List of modules which will not be supported by 'Create Entity' workflow task
$filterModules = array('Invoice', 'Quotes', 'SalesOrder', 'PurchaseOrder', 'Emails', 'Calendar', 'Events', 'Accounts');
$skipFieldsList = array();
for ($i = 0; $i < $noOfFields; ++$i) {
$tabId = $adb->query_result($result, $i, 'tabid');
$fieldName = $adb->query_result($result, $i, 'fieldname');
$typeOfData = $adb->query_result($result, $i, 'typeofdata');
$referenceModule = $adb->query_result($result, $i, 'reference_module');
$tabModuleName = getTabModuleName($tabId);
if (in_array($tabModuleName, $filterModules))
continue;
if ($referenceModule == $moduleName && $tabModuleName != $moduleName) {
if(!vtlib_isModuleActive($tabModuleName))continue;
$dependentFields[$tabModuleName] = array('fieldname' => $fieldName, 'modulelabel' => getTranslatedString($tabModuleName, $tabModuleName));
} else {
$dataTypeInfo = explode('~', $typeOfData);
if ($dataTypeInfo[1] == 'M') { // If the current reference field is mandatory
$skipFieldsList[$tabModuleName] = array('fieldname' => $fieldName);
}
}
}
foreach ($skipFieldsList as $tabModuleName => $fieldInfo) {
$dependentFieldInfo = $dependentFields[$tabModuleName];
if ($dependentFieldInfo['fieldname'] != $fieldInfo['fieldname']) {
unset($dependentFields[$tabModuleName]);
}
}
$returnValue = array('count' => count($dependentFields), 'entities' => $dependentFields);
echo Zend_Json::encode($returnValue);
}
function vtJsonOwnersList($adb) {
$ownersList = array();
$activeUsersList = get_user_array(false);
$allGroupsList = get_group_array(false);
foreach ($activeUsersList as $userId => $userName) {
$ownersList[] = array('label' => $userName, 'value' => getUserName($userId));
}
foreach ($allGroupsList as $groupId => $groupName) {
$ownersList[] = array('label' => $groupName, 'value' => $groupName);
}
echo Zend_Json::encode($ownersList);
}
global $adb;
$mode = vtlib_purify($_REQUEST['mode']);
if ($mode == 'getfieldsjson') {
vtJsonFields($adb, $_REQUEST);
} elseif ($mode == 'getfunctionsjson') {
vtJsonFunctions($adb);
} elseif ($mode == 'getdependentfields') {
vtJsonDependentModules($adb, $_REQUEST);
} elseif ($mode == 'getownerslist') {
vtJsonOwnersList($adb);
}
?>