|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/* +*********************************************************************************** |
|
4
|
|
|
* The contents of this file are subject to the vtiger CRM Public License Version 1.0 |
|
5
|
|
|
* ("License"); You may not use this file except in compliance with the License |
|
6
|
|
|
* The Original Code is: vtiger CRM Open Source |
|
7
|
|
|
* The Initial Developer of the Original Code is vtiger. |
|
8
|
|
|
* Portions created by vtiger are Copyright (C) vtiger. |
|
9
|
|
|
* All Rights Reserved. |
|
10
|
|
|
* Contributor(s): YetiForce S.A. |
|
11
|
|
|
* *********************************************************************************** */ |
|
12
|
|
|
|
|
13
|
|
|
class Vtiger_RelationAjax_Action extends \App\Controller\Action |
|
14
|
|
|
{ |
|
15
|
|
|
use App\Controller\ClearProcess; |
|
16
|
|
|
use \App\Controller\ExposeMethod; |
|
17
|
|
|
|
|
18
|
|
|
/** {@inheritdoc} */ |
|
19
|
|
|
public function __construct() |
|
20
|
|
|
{ |
|
21
|
|
|
parent::__construct(); |
|
22
|
|
|
$this->exposeMethod('addRelation'); |
|
23
|
|
|
$this->exposeMethod('deleteRelation'); |
|
24
|
|
|
$this->exposeMethod('massDeleteRelation'); |
|
25
|
|
|
$this->exposeMethod('exportToExcel'); |
|
26
|
|
|
$this->exposeMethod('updateRelation'); |
|
27
|
|
|
$this->exposeMethod('getRelatedListPageCount'); |
|
28
|
|
|
$this->exposeMethod('updateFavoriteForRecord'); |
|
29
|
|
|
$this->exposeMethod('calculate'); |
|
30
|
|
|
$this->exposeMethod('massDownload'); |
|
31
|
|
|
$this->exposeMethod('checkFilesIntegrity'); |
|
32
|
|
|
} |
|
33
|
|
|
|
|
34
|
|
|
/** {@inheritdoc} */ |
|
35
|
|
|
public function checkPermission(App\Request $request) |
|
36
|
|
|
{ |
|
37
|
|
|
$userPrivilegesModel = Users_Privileges_Model::getCurrentUserPrivilegesModel(); |
|
38
|
|
|
if (!$request->isEmpty('record', true) && !\App\Privilege::isPermitted($request->getModule(), 'DetailView', $request->getInteger('record'))) { |
|
39
|
|
|
throw new \App\Exceptions\NoPermittedToRecord('ERR_NO_PERMISSIONS_FOR_THE_RECORD', 403); |
|
40
|
|
|
} |
|
41
|
|
|
if (!$request->isEmpty('src_record', true) && !\App\Privilege::isPermitted($request->getModule(), 'DetailView', $request->getInteger('src_record'))) { |
|
42
|
|
|
throw new \App\Exceptions\NoPermittedToRecord('ERR_NO_PERMISSIONS_FOR_THE_RECORD', 403); |
|
43
|
|
|
} |
|
44
|
|
|
if (!$request->isEmpty('related_module', true) && !$userPrivilegesModel->hasModulePermission($request->getByType('related_module', 2))) { |
|
45
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 403); |
|
46
|
|
|
} |
|
47
|
|
|
if (!$request->isEmpty('relatedModule', true) && !\is_array($relatedModule = $request->getByType('relatedModule', 2)) && 'ProductsAndServices' !== $relatedModule) { |
|
48
|
|
|
if ('ModTracker' === $relatedModule) { |
|
49
|
|
|
if (!$userPrivilegesModel->hasModuleActionPermission($request->getModule(), 'ModTracker')) { |
|
50
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 403); |
|
51
|
|
|
} |
|
52
|
|
|
} else { |
|
53
|
|
|
if (!$userPrivilegesModel->hasModulePermission($relatedModule)) { |
|
54
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 403); |
|
55
|
|
|
} |
|
56
|
|
|
} |
|
57
|
|
|
} |
|
58
|
|
|
} |
|
59
|
|
|
|
|
60
|
|
|
/** |
|
61
|
|
|
* Get query for records list from request. |
|
62
|
|
|
* |
|
63
|
|
|
* @param \App\Request $request |
|
64
|
|
|
* |
|
65
|
|
|
* @return \App\QueryGenerator|bool |
|
66
|
|
|
*/ |
|
67
|
|
|
public static function getQuery(App\Request $request) |
|
68
|
|
|
{ |
|
69
|
|
|
return static::getRelationListModel($request)->getRelationQuery(true)->clearFields(); |
|
|
|
|
|
|
70
|
|
|
} |
|
71
|
|
|
|
|
72
|
|
|
public static function getRelationListModel(App\Request $request) |
|
73
|
|
|
{ |
|
74
|
|
|
$parentRecordModel = \Vtiger_Record_Model::getInstanceById($request->getInteger('record'), $request->getModule()); |
|
75
|
|
|
$relationId = $request->isEmpty('relationId') ? false : $request->getInteger('relationId'); |
|
76
|
|
|
$cvId = $request->isEmpty('cvId', true) ? 0 : $request->getByType('cvId', \App\Purifier::ALNUM); |
|
77
|
|
|
$relationListView = Vtiger_RelationListView_Model::getInstance($parentRecordModel, $request->getByType('relatedModule', \App\Purifier::ALNUM), $relationId, $cvId); |
|
78
|
|
|
|
|
79
|
|
|
$selectedIds = $request->getArray('selected_ids', \App\Purifier::ALNUM); |
|
80
|
|
|
if ($selectedIds && 'all' !== $selectedIds[0]) { |
|
|
|
|
|
|
81
|
|
|
$relationListView->getQueryGenerator()->addCondition('id', $selectedIds, 'e'); |
|
82
|
|
|
} |
|
83
|
|
|
if ($request->has('entityState')) { |
|
84
|
|
|
$relationListView->set('entityState', $request->getByType('entityState')); |
|
85
|
|
|
} |
|
86
|
|
|
$operator = 's'; |
|
87
|
|
|
if (!$request->isEmpty('operator', true)) { |
|
88
|
|
|
$operator = $request->getByType('operator'); |
|
89
|
|
|
$relationListView->set('operator', $operator); |
|
90
|
|
|
} |
|
91
|
|
|
if (!$request->isEmpty('search_key', true)) { |
|
92
|
|
|
$searchKey = $request->getByType('search_key', \App\Purifier::ALNUM); |
|
93
|
|
|
$relationListView->set('search_key', $searchKey); |
|
94
|
|
|
$relationListView->set('search_value', App\Condition::validSearchValue($request->getByType('search_value', 'Text'), $relationListView->getQueryGenerator()->getModule(), $searchKey, $operator)); |
|
95
|
|
|
} |
|
96
|
|
|
$searchParams = App\Condition::validSearchParams($request->getByType('relatedModule', \App\Purifier::ALNUM), $request->getArray('search_params')); |
|
97
|
|
|
if (empty($searchParams) || !\is_array($searchParams)) { |
|
98
|
|
|
$searchParams = []; |
|
99
|
|
|
} |
|
100
|
|
|
$relationListView->set('search_params', $relationListView->getQueryGenerator()->parseBaseSearchParamsToCondition($searchParams)); |
|
101
|
|
|
if ($excludedIds = $request->getArray('excluded_ids', \App\Purifier::INTEGER)) { |
|
102
|
|
|
$relationListView->getQueryGenerator()->addCondition('id', $excludedIds, 'n'); |
|
103
|
|
|
} |
|
104
|
|
|
if ($request->getBoolean('isSortActive') && !$request->isEmpty('orderby')) { |
|
105
|
|
|
$relationListView->set('orderby', $request->getArray('orderby', \App\Purifier::STANDARD, [], \App\Purifier::SQL)); |
|
106
|
|
|
} |
|
107
|
|
|
|
|
108
|
|
|
return $relationListView; |
|
109
|
|
|
} |
|
110
|
|
|
|
|
111
|
|
|
/** |
|
112
|
|
|
* Get records list from request. |
|
113
|
|
|
* |
|
114
|
|
|
* @param \App\Request $request |
|
115
|
|
|
* |
|
116
|
|
|
* @return int[] |
|
117
|
|
|
*/ |
|
118
|
|
|
public static function getRecordsListFromRequest(App\Request $request): array |
|
119
|
|
|
{ |
|
120
|
|
|
$selectedIds = $request->getArray('selected_ids', 2); |
|
121
|
|
|
if ($selectedIds && 'all' !== $selectedIds[0]) { |
|
|
|
|
|
|
122
|
|
|
return $selectedIds; |
|
123
|
|
|
} |
|
124
|
|
|
$queryGenerator = static::getQuery($request); |
|
125
|
|
|
return $queryGenerator ? $queryGenerator->createQuery()->column() : []; |
|
126
|
|
|
} |
|
127
|
|
|
|
|
128
|
|
|
/** |
|
129
|
|
|
* Function to add relation for specified source record id and related record id list. |
|
130
|
|
|
* |
|
131
|
|
|
* @param \App\Request $request |
|
132
|
|
|
* |
|
133
|
|
|
* @throws \App\Exceptions\NoPermittedToRecord |
|
134
|
|
|
*/ |
|
135
|
|
|
public function addRelation(App\Request $request) |
|
136
|
|
|
{ |
|
137
|
|
|
$sourceModule = $request->getModule(); |
|
138
|
|
|
$sourceRecordId = $request->getInteger('src_record'); |
|
139
|
|
|
$relatedModule = $request->getByType('related_module', App\Purifier::ALNUM); |
|
140
|
|
|
if (is_numeric($relatedModule)) { |
|
141
|
|
|
$relatedModule = \App\Module::getModuleName($relatedModule); |
|
142
|
|
|
} |
|
143
|
|
|
if (!\App\Privilege::isPermitted($sourceModule, 'DetailView', $sourceRecordId)) { |
|
144
|
|
|
throw new \App\Exceptions\NoPermittedToRecord('ERR_NO_PERMISSIONS_FOR_THE_RECORD', 406); |
|
145
|
|
|
} |
|
146
|
|
|
$sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); |
|
147
|
|
|
if ($request->isEmpty('relationId')) { |
|
148
|
|
|
$relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, Vtiger_Module_Model::getInstance($relatedModule)); |
|
149
|
|
|
} else { |
|
150
|
|
|
$relationModel = Vtiger_Relation_Model::getInstanceById($request->getInteger('relationId')); |
|
151
|
|
|
} |
|
152
|
|
|
$recordIdsToRelate = $request->has('selected_ids') ? $this->getRecordIdsToRelate($request) : $request->getArray('related_record_list', App\Purifier::INTEGER); |
|
153
|
|
|
foreach ($recordIdsToRelate as $relatedRecordId) { |
|
154
|
|
|
if (\App\Privilege::isPermitted($relatedModule, 'DetailView', $relatedRecordId)) { |
|
155
|
|
|
$relationModel->addRelation($sourceRecordId, $relatedRecordId); |
|
156
|
|
|
} |
|
157
|
|
|
} |
|
158
|
|
|
$response = new Vtiger_Response(); |
|
159
|
|
|
$response->setResult(true); |
|
160
|
|
|
$response->emit(); |
|
161
|
|
|
} |
|
162
|
|
|
|
|
163
|
|
|
/** |
|
164
|
|
|
* Get record ids to relate. |
|
165
|
|
|
* |
|
166
|
|
|
* @param App\Request $request |
|
167
|
|
|
* |
|
168
|
|
|
* @return array |
|
169
|
|
|
*/ |
|
170
|
|
|
public function getRecordIdsToRelate(App\Request $request): array |
|
171
|
|
|
{ |
|
172
|
|
|
$cvId = $request->isEmpty('cvId') ? '' : $request->getByType('cvId', App\Purifier::ALNUM); |
|
173
|
|
|
$moduleName = $request->getByType('related_module', App\Purifier::ALNUM); |
|
174
|
|
|
if ((!empty($cvId) && 'undefined' === $cvId) || '0' === $cvId) { |
|
175
|
|
|
$cvId = CustomView_Record_Model::getAllFilterByModule($moduleName)->getId(); |
|
176
|
|
|
} |
|
177
|
|
|
$customViewModel = CustomView_Record_Model::getInstanceById((int) $cvId); |
|
178
|
|
|
if (!$customViewModel) { |
|
|
|
|
|
|
179
|
|
|
return []; |
|
180
|
|
|
} |
|
181
|
|
|
$selectedIds = $request->getArray('selected_ids', App\Purifier::ALNUM); |
|
182
|
|
|
if ($selectedIds && 'all' !== $selectedIds[0]) { |
|
|
|
|
|
|
183
|
|
|
$queryGenerator = new App\QueryGenerator($moduleName); |
|
184
|
|
|
$queryGenerator->initForCustomViewById($cvId); |
|
185
|
|
|
$queryGenerator->addCondition('id', $selectedIds, 'e'); |
|
186
|
|
|
} else { |
|
187
|
|
|
if (!$request->isEmpty('operator')) { |
|
188
|
|
|
$operator = $request->getByType('operator'); |
|
189
|
|
|
$searchKey = $request->getByType('search_key', 'Alnum'); |
|
190
|
|
|
$customViewModel->set('operator', $operator); |
|
191
|
|
|
$customViewModel->set('search_key', $searchKey); |
|
192
|
|
|
$customViewModel->set('search_value', App\Condition::validSearchValue($request->getByType('search_value', App\Purifier::TEXT), $moduleName, $searchKey, $operator)); |
|
193
|
|
|
} |
|
194
|
|
|
if ($request->getBoolean('isSortActive') && !$request->isEmpty('orderby')) { |
|
195
|
|
|
$customViewModel->set('orderby', $request->getArray('orderby', \App\Purifier::STANDARD, [], \App\Purifier::SQL)); |
|
196
|
|
|
} |
|
197
|
|
|
$customViewModel->set('search_params', App\Condition::validSearchParams($moduleName, $request->getArray('search_params'))); |
|
198
|
|
|
if ($advancedConditions = $request->has('advancedConditions') ? $request->getArray('advancedConditions') : []) { |
|
199
|
|
|
$customViewModel->set('advancedConditions', \App\Condition::validAdvancedConditions($advancedConditions)); |
|
200
|
|
|
} |
|
201
|
|
|
$queryGenerator = $customViewModel->getRecordsListQuery($request->getArray('excluded_ids', App\Purifier::ALNUM), $moduleName); |
|
202
|
|
|
|
|
203
|
|
|
$queryGenerator->addNativeCondition( |
|
204
|
|
|
['not in', $queryGenerator->getColumnName('id'), $this->getRelatedRecordIds($request)] |
|
205
|
|
|
); |
|
206
|
|
|
} |
|
207
|
|
|
return $queryGenerator->clearFields()->createQuery()->column(); |
|
208
|
|
|
} |
|
209
|
|
|
|
|
210
|
|
|
/** |
|
211
|
|
|
* Get related record ids. |
|
212
|
|
|
* |
|
213
|
|
|
* @param App\Request $request |
|
214
|
|
|
* |
|
215
|
|
|
* @return \App\Db\Query |
|
216
|
|
|
*/ |
|
217
|
|
|
public function getRelatedRecordIds(App\Request $request): App\Db\Query |
|
218
|
|
|
{ |
|
219
|
|
|
$parentRecordModel = \Vtiger_Record_Model::getInstanceById($request->getInteger('src_record'), $request->getByType('src_module')); |
|
220
|
|
|
$relationId = $request->isEmpty('relationId') ? false : $request->getInteger('relationId'); |
|
221
|
|
|
$cvId = $request->isEmpty('cvId', true) ? 0 : $request->getByType('cvId', \App\Purifier::ALNUM); |
|
222
|
|
|
$relationListView = Vtiger_RelationListView_Model::getInstance($parentRecordModel, $request->getByType('related_module', \App\Purifier::ALNUM), $relationId, $cvId); |
|
223
|
|
|
$queryGenerator = $relationListView->getRelationQuery(true)->clearFields(); |
|
224
|
|
|
return $queryGenerator->createQuery(); |
|
|
|
|
|
|
225
|
|
|
} |
|
226
|
|
|
|
|
227
|
|
|
/** |
|
228
|
|
|
* Function to delete the relation for specified source record id and related record id list. |
|
229
|
|
|
* |
|
230
|
|
|
* @param \App\Request $request |
|
231
|
|
|
* |
|
232
|
|
|
* @throws \App\Exceptions\NoPermittedToRecord |
|
233
|
|
|
*/ |
|
234
|
|
|
public function deleteRelation(App\Request $request) |
|
235
|
|
|
{ |
|
236
|
|
|
$sourceModule = $request->getModule(); |
|
237
|
|
|
$sourceRecordId = $request->getInteger('src_record'); |
|
238
|
|
|
$relatedModule = $request->getByType('related_module', 2); |
|
239
|
|
|
$relatedRecordIdList = $request->getArray('related_record_list', 'Integer'); |
|
240
|
|
|
$sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); |
|
241
|
|
|
if ($request->isEmpty('relationId')) { |
|
242
|
|
|
$relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, Vtiger_Module_Model::getInstance($relatedModule)); |
|
243
|
|
|
} else { |
|
244
|
|
|
$relationModel = Vtiger_Relation_Model::getInstanceById($request->getInteger('relationId')); |
|
245
|
|
|
} |
|
246
|
|
|
$result = false; |
|
247
|
|
|
if ($relationModel->privilegeToDelete()) { |
|
248
|
|
|
foreach ($relatedRecordIdList as $relatedRecordId) { |
|
249
|
|
|
if (\App\Privilege::isPermitted($relatedModule, 'DetailView', $relatedRecordId)) { |
|
250
|
|
|
$result = $relationModel->deleteRelation($sourceRecordId, (int) $relatedRecordId); |
|
251
|
|
|
} |
|
252
|
|
|
} |
|
253
|
|
|
} |
|
254
|
|
|
$response = new Vtiger_Response(); |
|
255
|
|
|
$response->setResult($result); |
|
256
|
|
|
$response->emit(); |
|
257
|
|
|
} |
|
258
|
|
|
|
|
259
|
|
|
/** |
|
260
|
|
|
* This function removes the relationship associated with the module. |
|
261
|
|
|
* |
|
262
|
|
|
* @param \App\Request $request |
|
263
|
|
|
*/ |
|
264
|
|
|
public function massDeleteRelation(App\Request $request) |
|
265
|
|
|
{ |
|
266
|
|
|
$sourceModule = $request->getModule(); |
|
267
|
|
|
$relatedModuleName = $request->getByType('relatedModule', 2); |
|
268
|
|
|
$sourceRecordId = $request->getInteger('src_record'); |
|
269
|
|
|
$parentRecordModel = Vtiger_Record_Model::getInstanceById($sourceRecordId, $sourceModule); |
|
270
|
|
|
$relationId = $request->isEmpty('relationId') ? false : $request->getInteger('relationId'); |
|
271
|
|
|
$cvId = $request->isEmpty('cvId', true) ? 0 : $request->getByType('cvId', 'Alnum'); |
|
272
|
|
|
$relationListView = Vtiger_RelationListView_Model::getInstance($parentRecordModel, $relatedModuleName, $relationId, $cvId); |
|
273
|
|
|
$relationModel = $relationListView->getRelationModel(); |
|
274
|
|
|
if ($relationModel->privilegeToDelete()) { |
|
275
|
|
|
$rows = $this->getRecordsListFromRequest($request); |
|
276
|
|
|
foreach ($rows as $relatedRecordId) { |
|
277
|
|
|
if (\App\Privilege::isPermitted($relatedModuleName, 'DetailView', $relatedRecordId) && $relationModel->privilegeToDelete(null, $relatedRecordId)) { |
|
278
|
|
|
$relationModel->deleteRelation((int) $sourceRecordId, (int) $relatedRecordId); |
|
279
|
|
|
} |
|
280
|
|
|
} |
|
281
|
|
|
} |
|
282
|
|
|
|
|
283
|
|
|
$response = new Vtiger_Response(); |
|
284
|
|
|
$response->setResult(['reloadList' => true]); |
|
285
|
|
|
$response->emit(); |
|
286
|
|
|
} |
|
287
|
|
|
|
|
288
|
|
|
/** |
|
289
|
|
|
* Export relations to excel. |
|
290
|
|
|
* |
|
291
|
|
|
* @param \App\Request $request |
|
292
|
|
|
*/ |
|
293
|
|
|
public function exportToExcel(App\Request $request) |
|
294
|
|
|
{ |
|
295
|
|
|
if (!\App\Privilege::isPermitted($request->getByType('relatedModule', \App\Purifier::ALNUM), 'QuickExportToExcel')) { |
|
296
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 403); |
|
297
|
|
|
} |
|
298
|
|
|
$relationListView = static::getRelationListModel($request); |
|
299
|
|
|
$relatedModuleName = $relationListView->getRelatedModuleModel()->getName(); |
|
300
|
|
|
$headers = $relationListView->getHeaders(); |
|
301
|
|
|
|
|
302
|
|
|
$exportModel = \App\Export\Records::getInstance($relatedModuleName, 'xls') |
|
|
|
|
|
|
303
|
|
|
->setLimit(\App\Config::performance('MAX_NUMBER_EXPORT_RECORDS')) |
|
304
|
|
|
->setFormat(\App\Export\Records::USER_FORMAT); |
|
305
|
|
|
$exportModel->queryGenerator = $relationListView->getRelationQuery(true); |
|
306
|
|
|
$exportModel->setFields(array_keys($headers)); |
|
307
|
|
|
$exportModel->sendHttpHeader(); |
|
308
|
|
|
$exportModel->exportData(); |
|
309
|
|
|
} |
|
310
|
|
|
|
|
311
|
|
|
/** |
|
312
|
|
|
* Function to update the relation for specified source record id and related record id list. |
|
313
|
|
|
* |
|
314
|
|
|
* @param \App\Request $request |
|
315
|
|
|
* |
|
316
|
|
|
* @throws \App\Exceptions\NoPermittedToRecord |
|
317
|
|
|
* @throws \App\Exceptions\NoPermitted |
|
318
|
|
|
*/ |
|
319
|
|
|
public function updateRelation(App\Request $request) |
|
320
|
|
|
{ |
|
321
|
|
|
$sourceModule = $request->getModule(); |
|
322
|
|
|
$sourceRecordId = $request->getInteger('src_record'); |
|
323
|
|
|
$relatedModule = $request->getByType('related_module', 2); |
|
324
|
|
|
$recordsToRemove = $request->getArray('recordsToRemove', 'Integer'); |
|
325
|
|
|
$recordsToAdd = $request->getArray('recordsToAdd', 'Integer'); |
|
326
|
|
|
$categoryToAdd = $request->getArray('categoryToAdd', 'Alnum'); |
|
327
|
|
|
$categoryToRemove = $request->getArray('categoryToRemove', 'Alnum'); |
|
328
|
|
|
$sourceModuleModel = Vtiger_Module_Model::getInstance($sourceModule); |
|
329
|
|
|
if ($request->isEmpty('relationId')) { |
|
330
|
|
|
$relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, Vtiger_Module_Model::getInstance($relatedModule)); |
|
331
|
|
|
} else { |
|
332
|
|
|
$relationModel = Vtiger_Relation_Model::getInstanceById($request->getInteger('relationId')); |
|
333
|
|
|
} |
|
334
|
|
|
if (!empty($recordsToAdd)) { |
|
335
|
|
|
foreach ($recordsToAdd as $relatedRecordId) { |
|
336
|
|
|
if (\App\Privilege::isPermitted($relatedModule, 'DetailView', $relatedRecordId)) { |
|
337
|
|
|
$relationModel->addRelation($sourceRecordId, $relatedRecordId); |
|
338
|
|
|
} |
|
339
|
|
|
} |
|
340
|
|
|
} |
|
341
|
|
|
if (!empty($recordsToRemove)) { |
|
342
|
|
|
if ($relationModel->privilegeToDelete()) { |
|
343
|
|
|
foreach ($recordsToRemove as $relatedRecordId) { |
|
344
|
|
|
$relationModel->deleteRelation((int) $sourceRecordId, (int) $relatedRecordId); |
|
345
|
|
|
} |
|
346
|
|
|
} else { |
|
347
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 406); |
|
348
|
|
|
} |
|
349
|
|
|
} |
|
350
|
|
|
if (!empty($categoryToAdd) && $relationModel->isTreeRelation()) { |
|
351
|
|
|
foreach ($categoryToAdd as $category) { |
|
352
|
|
|
$relationModel->addRelationTree($sourceRecordId, $category); |
|
353
|
|
|
} |
|
354
|
|
|
} |
|
355
|
|
|
if (!empty($categoryToRemove) && $relationModel->isTreeRelation()) { |
|
356
|
|
|
if ($relationModel->privilegeToTreeDelete()) { |
|
357
|
|
|
foreach ($categoryToRemove as $category) { |
|
358
|
|
|
$relationModel->deleteRelationTree($sourceRecordId, $category); |
|
359
|
|
|
} |
|
360
|
|
|
} else { |
|
361
|
|
|
throw new \App\Exceptions\NoPermitted('LBL_PERMISSION_DENIED', 406); |
|
362
|
|
|
} |
|
363
|
|
|
} |
|
364
|
|
|
$response = new Vtiger_Response(); |
|
365
|
|
|
$response->setResult(true); |
|
366
|
|
|
$response->emit(); |
|
367
|
|
|
} |
|
368
|
|
|
|
|
369
|
|
|
/** |
|
370
|
|
|
* Function to get the page count for related list. |
|
371
|
|
|
* |
|
372
|
|
|
* @param \App\Request $request |
|
373
|
|
|
*/ |
|
374
|
|
|
public function getRelatedListPageCount(App\Request $request) |
|
375
|
|
|
{ |
|
376
|
|
|
$moduleName = $request->getModule(); |
|
377
|
|
|
$relatedModuleName = $request->getArray('relatedModule', 'Alnum'); |
|
378
|
|
|
$firstRelatedModuleName = current($relatedModuleName); |
|
379
|
|
|
$parentId = $request->getInteger('record'); |
|
380
|
|
|
if (!\App\Privilege::isPermitted($moduleName, 'DetailView', $parentId)) { |
|
381
|
|
|
throw new \App\Exceptions\NoPermittedToRecord('ERR_NO_PERMISSIONS_FOR_THE_RECORD', 406); |
|
382
|
|
|
} |
|
383
|
|
|
$relationId = $request->isEmpty('relationId') ? false : $request->getInteger('relationId'); |
|
384
|
|
|
$cvId = $request->isEmpty('cvId', true) ? 0 : $request->getByType('cvId', 'Alnum'); |
|
385
|
|
|
$totalCount = 0; |
|
386
|
|
|
$pageCount = 0; |
|
387
|
|
|
if ('ModComments' === $firstRelatedModuleName) { |
|
388
|
|
|
$totalCount = ModComments_Record_Model::getCommentsCount($parentId); |
|
389
|
|
|
} elseif ('ModTracker' === $firstRelatedModuleName) { |
|
390
|
|
|
$count = (int) ($unreviewed = current(ModTracker_Record_Model::getUnreviewed($parentId, false, true))) ? array_sum($unreviewed) : ''; |
|
391
|
|
|
$totalCount = $count ?: ''; |
|
392
|
|
|
} else { |
|
393
|
|
|
$relModules = !empty($relatedModuleName) && \is_array($relatedModuleName) ? $relatedModuleName : []; |
|
394
|
|
|
if ('ProductsAndServices' === $firstRelatedModuleName) { |
|
395
|
|
|
$relModules = ['Products', 'OutsourcedProducts', 'Assets', 'Services', 'OSSOutsourcedServices', 'OSSSoldServices']; |
|
396
|
|
|
} |
|
397
|
|
|
$categoryCount = ['Products', 'OutsourcedProducts', 'Services', 'OSSOutsourcedServices']; |
|
398
|
|
|
$pagingModel = new Vtiger_Paging_Model(); |
|
399
|
|
|
$parentRecordModel = Vtiger_Record_Model::getInstanceById($parentId, $moduleName); |
|
400
|
|
|
$userPrivilegesModel = Users_Privileges_Model::getCurrentUserPrivilegesModel(); |
|
401
|
|
|
foreach ($relModules as $relModule) { |
|
402
|
|
|
if (!$userPrivilegesModel->hasModulePermission($relModule)) { |
|
403
|
|
|
continue; |
|
404
|
|
|
} |
|
405
|
|
|
$relationListView = Vtiger_RelationListView_Model::getInstance($parentRecordModel, $relModule, $relationId, $cvId); |
|
406
|
|
|
if (!$relationListView) { |
|
407
|
|
|
continue; |
|
408
|
|
|
} |
|
409
|
|
|
if ('ProductsAndServices' === $relatedModuleName && \in_array($relModule, $categoryCount)) { |
|
410
|
|
|
$totalCount += (int) $relationListView->getRelatedTreeEntriesCount(); |
|
411
|
|
|
} |
|
412
|
|
|
if ('Calendar' === $relatedModuleName && \App\Config::module($relatedModuleName, 'SHOW_ONLY_CURRENT_RECORDS_COUNT')) { |
|
413
|
|
|
$totalCount += (int) $relationListView->getRelationQuery()->andWhere(['vtiger_activity.status' => Calendar_Module_Model::getComponentActivityStateLabel('current')])->count(); |
|
|
|
|
|
|
414
|
|
|
} else { |
|
415
|
|
|
$totalCount += (int) $relationListView->getRelatedEntriesCount(); |
|
416
|
|
|
} |
|
417
|
|
|
$pageLimit = $pagingModel->getPageLimit(); |
|
418
|
|
|
$pageCount = ceil((int) $totalCount / (int) $pageLimit); |
|
419
|
|
|
} |
|
420
|
|
|
} |
|
421
|
|
|
if (0 == $pageCount) { |
|
422
|
|
|
$pageCount = 1; |
|
423
|
|
|
} |
|
424
|
|
|
$result = []; |
|
425
|
|
|
$result['numberOfRecords'] = $totalCount; |
|
426
|
|
|
$result['page'] = $pageCount; |
|
427
|
|
|
$response = new Vtiger_Response(); |
|
428
|
|
|
$response->setResult($result); |
|
429
|
|
|
$response->emit(); |
|
430
|
|
|
} |
|
431
|
|
|
|
|
432
|
|
|
public function updateFavoriteForRecord(App\Request $request) |
|
433
|
|
|
{ |
|
434
|
|
|
$sourceModuleModel = Vtiger_Module_Model::getInstance($request->getModule()); |
|
435
|
|
|
if ($request->isEmpty('relationId')) { |
|
436
|
|
|
$relationModel = Vtiger_Relation_Model::getInstance($sourceModuleModel, Vtiger_Module_Model::getInstance($request->getByType('relatedModule', 2))); |
|
437
|
|
|
} else { |
|
438
|
|
|
$relationModel = Vtiger_Relation_Model::getInstanceById($request->getInteger('relationId')); |
|
439
|
|
|
} |
|
440
|
|
|
if (!empty($relationModel)) { |
|
441
|
|
|
$result = $relationModel->updateFavoriteForRecord($request->getByType('actionMode'), ['crmid' => $request->getInteger('record'), 'relcrmid' => $request->getInteger('relcrmid')]); |
|
442
|
|
|
} |
|
443
|
|
|
|
|
444
|
|
|
$response = new Vtiger_Response(); |
|
445
|
|
|
$response->setResult((bool) $result); |
|
|
|
|
|
|
446
|
|
|
$response->emit(); |
|
447
|
|
|
} |
|
448
|
|
|
|
|
449
|
|
|
/** |
|
450
|
|
|
* Function for calculating values for a list of related records. |
|
451
|
|
|
* |
|
452
|
|
|
* @param \App\Request $request |
|
453
|
|
|
* |
|
454
|
|
|
* @throws \App\Exceptions\Security |
|
455
|
|
|
* @throws \App\Exceptions\NotAllowedMethod |
|
456
|
|
|
*/ |
|
457
|
|
|
public function calculate(App\Request $request) |
|
458
|
|
|
{ |
|
459
|
|
|
$queryGenerator = static::getQuery($request); |
|
460
|
|
|
$fieldQueryModel = $queryGenerator->getQueryField($request->getByType('fieldName', 2)); |
|
461
|
|
|
$fieldModel = $fieldQueryModel->getField(); |
|
462
|
|
|
if (!$fieldModel->isViewable()) { |
|
463
|
|
|
throw new \App\Exceptions\Security('ERR_NO_ACCESS_TO_THE_FIELD', 403); |
|
464
|
|
|
} |
|
465
|
|
|
if (!$fieldModel->isCalculateField()) { |
|
466
|
|
|
throw new \App\Exceptions\Security('ERR_NOT_SUPPORTED_FIELD', 406); |
|
467
|
|
|
} |
|
468
|
|
|
if ('sum' !== $request->getByType('calculateType')) { |
|
469
|
|
|
throw new \App\Exceptions\NotAllowedMethod('LBL_PERMISSION_DENIED', 406); |
|
470
|
|
|
} |
|
471
|
|
|
|
|
472
|
|
|
$columnName = $fieldQueryModel->getColumnName(); |
|
473
|
|
|
$fieldName = $fieldModel->getName(); |
|
474
|
|
|
$query = $queryGenerator->setFields(['id'])->setDistinct(null)->setGroup('id')->createQuery()->select([$fieldName => new \yii\db\Expression("MAX({$columnName})")]); |
|
475
|
|
|
$value = (new \App\Db\Query())->from(['c' => $query])->sum("c.{$fieldName}"); |
|
476
|
|
|
|
|
477
|
|
|
$response = new Vtiger_Response(); |
|
478
|
|
|
$response->setResult($fieldModel->getDisplayValue($value)); |
|
479
|
|
|
$response->emit(); |
|
480
|
|
|
} |
|
481
|
|
|
|
|
482
|
|
|
/** |
|
483
|
|
|
* Mass download. |
|
484
|
|
|
* |
|
485
|
|
|
* @param App\Request $request |
|
486
|
|
|
*/ |
|
487
|
|
|
public function massDownload(App\Request $request) |
|
488
|
|
|
{ |
|
489
|
|
|
$relatedModuleName = $request->getByType('relatedModule', 2); |
|
490
|
|
|
$records = $this->getRecordsListFromRequest($request); |
|
491
|
|
|
if (1 === \count($records)) { |
|
492
|
|
|
$documentRecordModel = Vtiger_Record_Model::getInstanceById($records[0], $relatedModuleName); |
|
493
|
|
|
$documentRecordModel->downloadFile(); |
|
|
|
|
|
|
494
|
|
|
$documentRecordModel->updateDownloadCount(); |
|
|
|
|
|
|
495
|
|
|
} else { |
|
496
|
|
|
Documents_Record_Model::downloadFiles($records); |
|
497
|
|
|
} |
|
498
|
|
|
} |
|
499
|
|
|
|
|
500
|
|
|
/** |
|
501
|
|
|
* Check many files integrity. |
|
502
|
|
|
* |
|
503
|
|
|
* @param App\Request $request |
|
504
|
|
|
*/ |
|
505
|
|
|
public function checkFilesIntegrity(App\Request $request) |
|
506
|
|
|
{ |
|
507
|
|
|
$relatedModuleName = $request->getByType('relatedModule', 2); |
|
508
|
|
|
$fileNotAvailable = []; |
|
509
|
|
|
$result = ['success' => true]; |
|
510
|
|
|
foreach ($this->getRecordsListFromRequest($request) as $record) { |
|
511
|
|
|
$documentRecordModel = Vtiger_Record_Model::getInstanceById($record, $relatedModuleName); |
|
512
|
|
|
$resultVal = $documentRecordModel->checkFileIntegrity(); |
|
|
|
|
|
|
513
|
|
|
if (!$resultVal) { |
|
514
|
|
|
$fileNotAvailable[] = $documentRecordModel->get('notes_title'); |
|
515
|
|
|
} |
|
516
|
|
|
} |
|
517
|
|
|
if (!empty($fileNotAvailable)) { |
|
518
|
|
|
$result = ['notify' => ['text' => \App\Language::translate('LBL_FILE_NOT_AVAILABLE', $relatedModuleName) . ': <br>- ' . implode('<br>- ', $fileNotAvailable)]]; |
|
519
|
|
|
} |
|
520
|
|
|
$response = new Vtiger_Response(); |
|
521
|
|
|
$response->setResult($result); |
|
522
|
|
|
$response->emit(); |
|
523
|
|
|
} |
|
524
|
|
|
} |
|
525
|
|
|
|