Merge branch 'JohnFF-patch-1'
[civicrm-core.git] / CRM / Profile / Page / MultipleRecordFieldsListing.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
06b69b18 4 | CiviCRM version 4.5 |
6a488035 5 +--------------------------------------------------------------------+
06b69b18 6 | Copyright CiviCRM LLC (c) 2004-2014 |
6a488035
TO
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
9 | |
10 | CiviCRM is free software; you can copy, modify, and distribute it |
11 | under the terms of the GNU Affero General Public License |
12 | Version 3, 19 November 2007 and the CiviCRM Licensing Exception. |
13 | |
14 | CiviCRM is distributed in the hope that it will be useful, but |
15 | WITHOUT ANY WARRANTY; without even the implied warranty of |
16 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
17 | See the GNU Affero General Public License for more details. |
18 | |
19 | You should have received a copy of the GNU Affero General Public |
20 | License and the CiviCRM Licensing Exception along |
21 | with this program; if not, contact CiviCRM LLC |
22 | at info[AT]civicrm[DOT]org. If you have questions about the |
23 | GNU Affero General Public License or the licensing of CiviCRM, |
24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
25 +--------------------------------------------------------------------+
26*/
27
28/**
29 *
30 * @package CRM
06b69b18 31 * @copyright CiviCRM LLC (c) 2004-2014
6a488035
TO
32 * $Id$
33 *
34 */
35class CRM_Profile_Page_MultipleRecordFieldsListing extends CRM_Core_Page_Basic {
36
37 /**
38 * The action links that we need to display for the browse screen
39 *
40 * @var array
41 * @static
42 */
43 static $_links = NULL;
44
45 protected $_fields = NULL;
46
47 protected $_profileId = NULL;
366fe2a3 48
6a488035
TO
49 protected $_contactId = NULL;
50
366fe2a3 51 protected $_customGroupTitle = NULL;
e41f4660
PJ
52
53 protected $_pageViewType = NULL;
54
55 protected $_contactType = NULL;
fcc8f207 56
6a488035
TO
57 /**
58 * Get BAO Name
59 *
60 * @return string Classname of BAO.
61 */
62 function getBAOName() {
63 return '';
64 }
65
66 /**
67 * Get action Links
68 *
69 * @return array (reference) of action links
70 */
71 function &links() {
e41f4660 72 if (!(self::$_links[$this->_pageViewType])) {
6a488035
TO
73 // helper variable for nicer formatting
74 $links = array();
75
76 $view = array_search(CRM_Core_Action::VIEW, CRM_Core_Action::$_names);
77 $update = array_search(CRM_Core_Action::UPDATE, CRM_Core_Action::$_names);
78 $delete = array_search(CRM_Core_Action::DELETE, CRM_Core_Action::$_names);
366fe2a3 79
1dde099b 80 // names and titles
6a488035
TO
81 $links[CRM_Core_Action::VIEW] = array(
82 'name' => ts('View'),
6a488035
TO
83 'title' => ts('View %1', array( 1 => $this->_customGroupTitle . ' record')),
84 );
85
86 $links[CRM_Core_Action::UPDATE] = array(
87 'name' => ts('Edit'),
6a488035
TO
88 'title' => ts('Edit %1', array( 1 => $this->_customGroupTitle . ' record')),
89 );
90
91 $links[CRM_Core_Action::DELETE] = array(
92 'name' => ts('Delete'),
6a488035
TO
93 'title' => ts('Delete %1', array( 1 => $this->_customGroupTitle . ' record')),
94 );
366fe2a3 95
1dde099b 96 // urls and queryStrings
e41f4660 97 if ($this->_pageViewType == 'profileDataView') {
1dde099b 98 $links[CRM_Core_Action::VIEW]['url'] = 'civicrm/profile/view';
7ab9bfe8 99 $links[CRM_Core_Action::VIEW]['qs'] = "reset=1&id=%%id%%&recordId=%%recordId%%&gid=%%gid%%&multiRecord={$view}";
1dde099b
PJ
100
101 $links[CRM_Core_Action::UPDATE]['url'] = 'civicrm/profile/edit';
7ab9bfe8 102 $links[CRM_Core_Action::UPDATE]['qs'] = "reset=1&id=%%id%%&recordId=%%recordId%%&gid=%%gid%%&multiRecord={$update}";
1dde099b 103
e41f4660 104 $links[CRM_Core_Action::DELETE]['url'] = 'civicrm/profile/edit';
7ab9bfe8 105 $links[CRM_Core_Action::DELETE]['qs'] = "reset=1&id=%%id%%&recordId=%%recordId%%&gid=%%gid%%&multiRecord={$delete}";
1dde099b
PJ
106
107 }
108 elseif ($this->_pageViewType == 'customDataView') {
109 // custom data specific view links
110 $links[CRM_Core_Action::VIEW]['url'] = 'civicrm/contact/view/cd';
525faea3 111 $links[CRM_Core_Action::VIEW]['qs'] = 'reset=1&gid=%%gid%%&cid=%%cid%%&recId=%%recId%%&multiRecordDisplay=single&mode=view';
1dde099b
PJ
112
113 // custom data specific update links
114 $links[CRM_Core_Action::UPDATE]['url'] = 'civicrm/contact/view/cd/edit';
525faea3 115 $links[CRM_Core_Action::UPDATE]['qs'] = 'reset=1&type=%%type%%&groupID=%%groupID%%&entityID=%%entityID%%&cgcount=%%cgcount%%&multiRecordDisplay=single&mode=edit';
1dde099b
PJ
116 // NOTE : links for DELETE action for customDataView is handled in browse
117
118 // copy action
119 $links[CRM_Core_Action::COPY] = array(
120 'name' => ts('Copy'),
121 'title' => ts('Copy %1', array( 1 => $this->_customGroupTitle . ' record')),
122 'url' => 'civicrm/contact/view/cd/edit',
525faea3 123 'qs' => 'reset=1&type=%%type%%&groupID=%%groupID%%&entityID=%%entityID%%&cgcount=%%newCgCount%%&multiRecordDisplay=single&copyValueId=%%cgcount%%&mode=copy'
1dde099b 124 );
e41f4660
PJ
125 }
126
127 self::$_links[$this->_pageViewType] = $links;
6a488035 128 }
e41f4660 129 return self::$_links[$this->_pageViewType];
6a488035
TO
130 }
131
132 /**
133 * Run the page
134 *
135 * This method is called after the page is created. It checks for the type
136 * of action and executes that action. Finally it calls the parent's run
137 * method.
138 *
139 * @return void
140 * @access public
141 *
142 */
143 function run() {
144 // get the requested action, default to 'browse'
145 $action = CRM_Utils_Request::retrieve('action', 'String', $this, FALSE, FALSE);
146
147 // assign vars to templates
148 $this->assign('action', $action);
149 $profileId = CRM_Utils_Request::retrieve('profileId', 'Positive', $this, FALSE);
150 if (!is_array($profileId) && is_numeric($profileId)) {
366fe2a3 151 $this->_profileId = $profileId;
6a488035 152 }
366fe2a3 153
6a488035 154 $this->_contactId = CRM_Utils_Request::retrieve('contactId', 'Positive', $this, FALSE);
e41f4660
PJ
155 $this->_pageViewType = CRM_Utils_Request::retrieve('pageViewType', 'Positive', $this, FALSE, 'profileDataView');
156 $this->_customGroupId = CRM_Utils_Request::retrieve('customGroupId', 'Positive', $this, FALSE, 0);
157 $this->_contactType = CRM_Utils_Request::retrieve('contactType', 'String', $this, FALSE);
6a488035 158 if ($action & CRM_Core_Action::BROWSE) {
366fe2a3 159 //browse
6a488035
TO
160 $this->browse();
161 return;
162 }
163 // parent run
164 return parent::run();
165 }
166
167 /**
168 * Browse the listing
169 *
170 * @return void
171 * @access public
172 */
173 function browse() {
b05a0fb6
PJ
174 $dateFields = NULL;
175 $dateFieldsVals = NULL;
e41f4660 176 if ($this->_pageViewType == 'profileDataView' && $this->_profileId) {
6a488035
TO
177 $fields = CRM_Core_BAO_UFGroup::getFields($this->_profileId, FALSE, NULL,
178 NULL, NULL,
179 FALSE, NULL,
180 FALSE,
181 NULL,
182 CRM_Core_Permission::EDIT
183 );
184 $multiRecordFields = array( );
185 $fieldIDs = NULL;
186 $result = NULL;
187 $multiRecordFieldsWithSummaryListing = CRM_Core_BAO_UFGroup::shiftMultiRecordFields($fields, $multiRecordFields, TRUE);
366fe2a3 188
6a488035
TO
189 $multiFieldId = CRM_Core_BAO_CustomField::getKeyID(key($multiRecordFields));
190 $customGroupId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_CustomField', $multiFieldId, 'custom_group_id');
191 $reached = CRM_Core_BAO_CustomGroup::hasReachedMaxLimit($customGroupId, $this->_contactId);
192 if (!$reached) {
193 $this->assign('contactId', $this->_contactId);
194 $this->assign('gid', $this->_profileId);
195 }
196 $this->assign('reachedMax', $reached);
366fe2a3 197
6a488035
TO
198 if ($multiRecordFieldsWithSummaryListing && !empty($multiRecordFieldsWithSummaryListing)) {
199 $fieldIDs = array_keys($multiRecordFieldsWithSummaryListing);
200 }
201 }
e41f4660
PJ
202 elseif ($this->_pageViewType == 'customDataView') {
203 // require custom group id for _pageViewType of customDataView
204 $customGroupId = $this->_customGroupId;
205 $reached = CRM_Core_BAO_CustomGroup::hasReachedMaxLimit($customGroupId, $this->_contactId);
206 if (!$reached) {
207 $this->assign('contactId', $this->_contactId);
208 $this->assign('customGroupId', $customGroupId);
209 $this->assign('ctype', $this->_contactType);
210 }
211 $this->assign('reachedMax', $reached);
212 // custom group info : this consists of the field title of group fields
213 $groupDetail = CRM_Core_BAO_CustomGroup::getGroupDetail($customGroupId, NULL, CRM_Core_DAO::$_nullObject, TRUE);
214 // field ids of fields in_selector for the custom group id provided
215 $fieldIDs = array_keys($groupDetail[$customGroupId]['fields']);
216 // field labels for headers
217 $fieldLabels = $groupDetail[$customGroupId]['fields'];
218
219 // from the above customGroupInfo we can get $this->_customGroupTitle
220 $this->_customGroupTitle = $groupDetail[$customGroupId]['title'];
221 }
6a488035
TO
222 if ($fieldIDs && !empty($fieldIDs) && $this->_contactId) {
223 $options = array( );
224 $returnProperities = array('html_type', 'data_type', 'date_format', 'time_format');
225 foreach ($fieldIDs as $key => $fieldID) {
e41f4660 226 $fieldIDs[$key] = !is_numeric($fieldID) ? CRM_Core_BAO_CustomField::getKeyID($fieldID) : $fieldID;
6a488035
TO
227 $param = array('id' => $fieldIDs[$key]);
228 $returnValues = array( );
229 CRM_Core_DAO::commonRetrieve('CRM_Core_DAO_CustomField', $param, $returnValues, $returnProperities);
b05a0fb6
PJ
230 if ($returnValues['data_type'] == 'Date') {
231 $dateFields[$fieldIDs[$key]] = 1;
232 }
366fe2a3 233
6a488035
TO
234 $optionValuePairs = CRM_Core_BAO_CustomOption::getCustomOption($fieldIDs[$key]);
235 if (!empty($optionValuePairs)) {
236 foreach ($optionValuePairs as $optionPairs) {
237 $options[$fieldIDs[$key]][$optionPairs['value']] = $optionPairs['label'];
238 }
239 }
366fe2a3 240
6a488035
TO
241 $options[$fieldIDs[$key]]['attributes']['html_type'] = $returnValues['html_type'];
242 $options[$fieldIDs[$key]]['attributes']['data_type'] = $returnValues['data_type'];
366fe2a3 243
244 $options[$fieldIDs[$key]]['attributes']['format'] =
6a488035
TO
245 $options[$fieldIDs[$key]]['attributes']['date_format'] = CRM_Utils_Array::value('date_format', $returnValues);
246 $options[$fieldIDs[$key]]['attributes']['time_format'] = CRM_Utils_Array::value('time_format', $returnValues);
247 }
366fe2a3 248
e41f4660 249 // commonly used for both views i.e profile listing view (profileDataView) and custom data listing view (customDataView)
6a488035 250 $result = CRM_Core_BAO_CustomValueTable::getEntityValues($this->_contactId, NULL, $fieldIDs, TRUE);
366fe2a3 251
e41f4660
PJ
252 if ($this->_pageViewType == 'profileDataView') {
253 if (!empty($fieldIDs)) {
254 //get the group info of multi rec fields in listing view
255 $fieldInput = $fieldIDs;
256 $fieldIdInput = $fieldIDs[0];
257 }
258 else {
259 //if no listing fields exist, take the group title for display
260 $nonListingFieldIds = array_keys($multiRecordFields);
261 $singleField = CRM_Core_BAO_CustomField::getKeyID($nonListingFieldIds[0]);
262 $fieldIdInput = $singleField;
263 $singleField = array($singleField);
264 $fieldInput = $singleField;
265 }
266 $customGroupInfo = CRM_Core_BAO_CustomGroup::getGroupTitles($fieldInput);
267 $this->_customGroupTitle = $customGroupInfo[$fieldIdInput]['groupTitle'];
268 }
269 // $cgcount is defined before 'if' condition as enitiy may have no record
270 // and $cgcount is used to build new record url
271 $cgcount = 1;
272 if ($result && !empty($result)) {
eb2b4bdb 273 $links = self::links();
e41f4660
PJ
274 if ($this->_pageViewType == 'profileDataView') {
275 $pageCheckSum = $this->get('pageCheckSum');
276 if ($pageCheckSum) {
277 foreach ($links as $key => $link) {
278 $links[$key] = $link['qs'] . "&cs=%%cs%%";
279 }
280 }
281 }
282 $linkAction = array_sum(array_keys($this->links()));
1dde099b
PJ
283
284 if ($reached) {
285 unset($links[CRM_Core_Action::COPY]);
286 }
287 $newCgCount = (!$reached) ? count($result) + 1 : NULL;
e41f4660
PJ
288 foreach ($result as $recId => &$value) {
289 foreach ($value as $fieldId => &$val) {
290 if (is_numeric($fieldId)) {
291 $customValue = &$val;
5f1aa3a5 292 if (!empty($dateFields) && array_key_exists($fieldId, $dateFields)) {
b05a0fb6
PJ
293 // formated date capture value capture
294 $dateFieldsVals[$fieldId][$recId] = CRM_Core_BAO_CustomField::getDisplayValue($customValue, $fieldId, $options);
295 }
296 else {
297 // assign to $result
298 $customValue = CRM_Core_BAO_CustomField::getDisplayValue($customValue, $fieldId, $options);
299 }
e41f4660
PJ
300 if (!$customValue) {
301 $customValue = "";
302 }
303
304 $op = NULL;
305 if ($this->_pageViewType == 'profileDataView') {
306 $actionParams = array('recordId' => $recId, 'gid' => $this->_profileId,
7ab9bfe8 307 'id' => $this->_contactId);
e41f4660
PJ
308 $op = 'profile.multiValue.row';
309 }
310 else {
311 // different set of url params
312 $actionParams['gid'] = $actionParams['groupID'] = $this->_customGroupId;
313 $actionParams['cid'] = $actionParams['entityID'] = $this->_contactId;
314 $actionParams['recId'] = $recId;
315 $actionParams['type'] = $this->_contactType;
316 $actionParams['cgcount'] = $cgcount;
1dde099b 317 $actionParams['newCgCount'] = $newCgCount;
eb2b4bdb
PJ
318
319 // DELETE action links
a801aa5c
CW
320 $deleteData = array(
321 'valueID' => $recId,
322 'groupID' => $this->_customGroupId,
323 'contactId' => $this->_contactId,
324 'key' => CRM_Core_Key::get('civicrm/ajax/customvalue'),
325 );
eb2b4bdb 326 $links[CRM_Core_Action::DELETE]['url'] = '#';
a801aa5c
CW
327 $links[CRM_Core_Action::DELETE]['extra'] = ' data-delete_params="'. htmlspecialchars(json_encode($deleteData)) .'"';
328 $links[CRM_Core_Action::DELETE]['class'] = 'delete-custom-row';
e41f4660
PJ
329 }
330 if (!empty($pageCheckSum)) {
331 $actionParams['cs'] = $pageCheckSum;
332 }
eb2b4bdb 333
e41f4660
PJ
334 $value['action'] = CRM_Core_Action::formLink(
335 $links,
336 $linkAction,
337 $actionParams,
338 ts('more'),
339 FALSE,
340 $op,
341 'customValue',
342 $fieldId // not ideal, but the one thing not sent in $actionParams
343 );
344 }
345 }
346 $cgcount++;
347 }
348 }
6a488035 349 }
366fe2a3 350
6a488035
TO
351 $headers = array( );
352 if (!empty($fieldIDs)) {
353 foreach ($fieldIDs as $fieldID) {
e41f4660 354 $headers[$fieldID] = ($this->_pageViewType == 'profileDataView') ? $customGroupInfo[$fieldID]['fieldLabel'] : $fieldLabels[$fieldID]['label'];
6a488035
TO
355 }
356 }
b05a0fb6
PJ
357 $this->assign('dateFields', $dateFields);
358 $this->assign('dateFieldsVals',$dateFieldsVals);
e41f4660 359 $this->assign('cgcount', $cgcount);
6a488035
TO
360 $this->assign('customGroupTitle', $this->_customGroupTitle);
361 $this->assign('headers', $headers);
362 $this->assign('records', $result);
363 }
364
365 /**
366 * Get name of edit form
367 *
368 * @return string classname of edit form
369 */
370 function editForm() {
371 return '';
372 }
373
374 /**
375 * Get edit form name
376 *
377 * @return string name of this page
378 */
379 function editName() {
380 return '';
381 }
382
383 /**
384 * Get user context
385 *
77b97be7
EM
386 * @param null $mode
387 *
6a488035
TO
388 * @return string user context
389 */
390 function userContext($mode = NULL) {
391 return '';
392 }
393}
394