CRM-14106 - Regex targeting the first part of if statements
[civicrm-core.git] / CRM / Event / Form / Search.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
232624b1 4 | CiviCRM version 4.4 |
6a488035
TO
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2013 |
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, |
a5611c8e 24 | see the CiviCRM license FAQ at http://civicrm.org/licensing |
6a488035
TO
25 +--------------------------------------------------------------------+
26*/
27
28/**
29 *
30 * @package CRM
31 * @copyright CiviCRM LLC (c) 2004-2013
32 * $Id$
33 *
34 */
35
36/**
37 * Files required
38 */
39
40/**
41 * This file is for civievent search
42 */
43class CRM_Event_Form_Search extends CRM_Core_Form {
44
45 /**
46 * Are we forced to run a search
47 *
48 * @var int
49 * @access protected
50 */
51 protected $_force;
52
53 /**
54 * name of search button
55 *
56 * @var string
57 * @access protected
58 */
59 protected $_searchButtonName;
60
61 /**
62 * name of print button
63 *
64 * @var string
65 * @access protected
66 */
67 protected $_printButtonName;
68
69 /**
70 * name of action button
71 *
72 * @var string
73 * @access protected
74 */
75 protected $_actionButtonName;
76
77 /**
78 * form values that we will be using
79 *
80 * @var array
81 * @access protected
82 */
83 protected $_formValues;
84
85 /**
86 * the params that are sent to the query
87 *
88 * @var array
89 * @access protected
90 */
91 protected $_queryParams;
92
93 /**
94 * have we already done this search
95 *
96 * @access protected
97 * @var boolean
98 */
99 protected $_done;
100
101 /**
102 * are we restricting ourselves to a single contact
103 *
104 * @access protected
105 * @var boolean
106 */
107 protected $_single = FALSE;
108
109 /**
110 * are we restricting ourselves to a single contact
111 *
112 * @access protected
113 * @var boolean
114 */
115 protected $_limit = NULL;
116
117 /**
118 * what context are we being invoked from
119 *
120 * @access protected
121 * @var string
122 */
123 protected $_context = NULL;
124
125 /**
126 * prefix for the controller
127 *
128 */
129 protected $_prefix = "event_";
130
131 protected $_defaults;
132
133 /**
134 * the saved search ID retrieved from the GET vars
135 *
136 * @var int
137 * @access protected
138 */
139 protected $_ssID;
140
141 /**
142 * processing needed for buildForm and later
143 *
144 * @return void
145 * @access public
146 */
147 function preProcess() {
148 $this->set('searchFormName', 'Search');
149
150 /**
151 * set the button names
152 */
153 $this->_searchButtonName = $this->getButtonName('refresh');
154 $this->_printButtonName = $this->getButtonName('next', 'print');
155 $this->_actionButtonName = $this->getButtonName('next', 'action');
156
157 $this->_done = FALSE;
158 $this->defaults = array();
159
a5611c8e
DL
160 /*
161 * we allow the controller to set force/reset externally, useful when we are being
162 * driven by the wizard framework
6a488035
TO
163 */
164 $this->_reset = CRM_Utils_Request::retrieve('reset', 'Boolean', CRM_Core_DAO::$_nullObject);
165 $this->_force = CRM_Utils_Request::retrieve('force', 'Boolean', $this, FALSE);
166 $this->_limit = CRM_Utils_Request::retrieve('limit', 'Positive', $this);
167 $this->_context = CRM_Utils_Request::retrieve('context', 'String', $this, FALSE, 'search');
168 $this->_ssID = CRM_Utils_Request::retrieve('ssID', 'Positive', $this);
169 $this->assign("context", $this->_context);
170
171 // get user submitted values
172 // get it from controller only if form has been submitted, else preProcess has set this
173 if (!empty($_POST) && !$this->controller->isModal()) {
174 $this->_formValues = $this->controller->exportValues($this->_name);
175 }
176 else {
177 $this->_formValues = $this->get('formValues');
178 }
179
180 if (empty($this->_formValues)) {
181 if (isset($this->_ssID)) {
182 $this->_formValues = CRM_Contact_BAO_SavedSearch::getFormValues($this->_ssID);
183 }
184 }
185
186 if ($this->_force) {
187 $this->postProcess();
188 $this->set('force', 0);
189 }
190
191 $sortID = NULL;
192 if ($this->get(CRM_Utils_Sort::SORT_ID)) {
193 $sortID = CRM_Utils_Sort::sortIDValue($this->get(CRM_Utils_Sort::SORT_ID),
194 $this->get(CRM_Utils_Sort::SORT_DIRECTION)
195 );
196 }
197
198 $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
199 $selector = new CRM_Event_Selector_Search($this->_queryParams,
200 $this->_action,
201 NULL,
202 $this->_single,
203 $this->_limit,
204 $this->_context
205 );
206 $prefix = NULL;
207 if ($this->_context == 'user') {
208 $prefix = $this->_prefix;
209 }
210
211 $this->assign("{$prefix}limit", $this->_limit);
212 $this->assign("{$prefix}single", $this->_single);
213
214 $controller = new CRM_Core_Selector_Controller($selector,
215 $this->get(CRM_Utils_Pager::PAGE_ID),
216 $sortID,
217 CRM_Core_Action::VIEW,
218 $this,
219 CRM_Core_Selector_Controller::TRANSFER,
220 $prefix
221 );
222 $controller->setEmbedded(TRUE);
223 $controller->moveFromSessionToTemplate();
224
225 $this->assign('summary', $this->get('summary'));
226 }
227
228 /**
229 * Build the form
230 *
231 * @access public
232 *
233 * @return void
234 */
235 function buildQuickForm() {
236 $this->addElement('text', 'sort_name', ts('Participant Name or Email'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'sort_name'));
237
238 CRM_Event_BAO_Query::buildSearchForm($this);
239
a5611c8e
DL
240 /*
241 * add form checkboxes for each row. This is needed out here to conform to QF protocol
242 * of all elements being declared in builQuickForm
6a488035
TO
243 */
244 $rows = $this->get('rows');
245 if (is_array($rows)) {
b9599ed0 246 CRM_Core_Resources::singleton()->addScriptFile('civicrm', 'js/crm.livePage.js');
6a488035
TO
247 $lineItems = $eventIds = array();
248 if (!$this->_single) {
249 $this->addElement('checkbox',
250 'toggleSelect',
251 NULL,
252 NULL,
253 array('onclick' => "toggleTaskAction( true ); return toggleCheckboxVals('mark_x_',this);")
254 );
255 }
256 foreach ($rows as $row) {
257 $eventIds[$row['event_id']] = $row['event_id'];
258 if (!$this->_single) {
259 $this->addElement('checkbox', $row['checkbox'],
260 NULL, NULL,
261 array('onclick' => "toggleTaskAction( true ); return checkSelectedBox('" . $row['checkbox'] . "');")
262 );
263 }
264 if (CRM_Event_BAO_Event::usesPriceSet($row['event_id'])) {
265 // add line item details if applicable
266 $lineItems[$row['participant_id']] = CRM_Price_BAO_LineItem::getLineItems($row['participant_id']);
267 }
268 }
269
270 //get actual count only when we are dealing w/ single event.
271 $participantCount = 0;
272 if (count($eventIds) == 1) {
273 //convert form values to clause.
274 $seatClause = array();
59adcdd9
DG
275 // Filter on is_test if specified in search form
276 if (CRM_Utils_Array::value('participant_test', $this->_formValues) == '1' || CRM_Utils_Array::value('participant_test', $this->_formValues) == '0' ) {
277 $seatClause[] = "( participant.is_test = {$this->_formValues['participant_test']} )";
278 }
a7488080 279 if (!empty($this->_formValues['participant_status_id'])) {
6a488035 280 $statuses = array_keys($this->_formValues['participant_status_id']);
6a488035
TO
281 $seatClause[] = '( participant.status_id IN ( ' . implode(' , ', $statuses) . ' ) )';
282 }
a7488080 283 if (!empty($this->_formValues['participant_role_id'])) {
6a488035 284 $roles = array_keys($this->_formValues['participant_role_id']);
59adcdd9 285 $seatClause[] = '( participant.role_id IN ( ' . implode(' , ', $roles) . ' ) )';
6a488035
TO
286 }
287 $clause = NULL;
288 if (!empty($seatClause)) {
289 $clause = implode(' AND ', $seatClause);
290 }
59adcdd9 291
6a488035
TO
292 $participantCount = CRM_Event_BAO_Event::eventTotalSeats(array_pop($eventIds), $clause);
293 }
294 $this->assign('participantCount', $participantCount);
295 $this->assign('lineItems', $lineItems);
296
297 $total = $cancel = 0;
298
299 $permission = CRM_Core_Permission::getPermission();
300
301 $tasks = array('' => ts('- actions -')) + CRM_Event_Task::permissionedTaskTitles($permission);
302 if (isset($this->_ssID)) {
303 if ($permission == CRM_Core_Permission::EDIT) {
304 $tasks = $tasks + CRM_Event_Task::optionalTaskTitle();
305 }
306
307 $savedSearchValues = array(
308 'id' => $this->_ssID,
309 'name' => CRM_Contact_BAO_SavedSearch::getName($this->_ssID, 'title'),
310 );
311 $this->assign_by_ref('savedSearch', $savedSearchValues);
312 $this->assign('ssID', $this->_ssID);
313 }
314
315 $this->add('select', 'task', ts('Actions:') . ' ', $tasks);
316 $this->add('submit', $this->_actionButtonName, ts('Go'),
317 array(
318 'class' => 'form-submit',
319 'id' => 'Go',
320 'onclick' => "return checkPerformAction('mark_x', '" . $this->getName() . "', 0);",
321 )
322 );
323
324 $this->add('submit', $this->_printButtonName, ts('Print'),
325 array(
326 'class' => 'form-submit',
327 'onclick' => "return checkPerformAction('mark_x', '" . $this->getName() . "', 1);",
328 )
329 );
330
331 // need to perform tasks on all or selected items ? using radio_ts(task selection) for it
332 $this->addElement('radio', 'radio_ts', NULL, '', 'ts_sel',
333 array('checked' => 'checked')
334 );
335 $this->addElement('radio', 'radio_ts', NULL, '', 'ts_all',
336 array('onclick' => $this->getName() . ".toggleSelect.checked = false; toggleCheckboxVals('mark_x_',this); toggleTaskAction( true );")
337 );
338 }
339
340 // add buttons
341 $this->addButtons(array(
342 array(
343 'type' => 'refresh',
344 'name' => ts('Search'),
345 'isDefault' => TRUE,
346 ),
347 ));
348 }
349
350 /**
351 * The post processing of the form gets done here.
352 *
353 * Key things done during post processing are
354 * - check for reset or next request. if present, skip post procesing.
355 * - now check if user requested running a saved search, if so, then
356 * the form values associated with the saved search are used for searching.
357 * - if user has done a submit with new values the regular post submissing is
358 * done.
359 * The processing consists of using a Selector / Controller framework for getting the
360 * search results.
361 *
362 * @param
363 *
364 * @return void
365 * @access public
366 */
367 function postProcess() {
368 if ($this->_done) {
369 return;
370 }
371
372 $this->_done = TRUE;
373
374 if (!empty($_POST)) {
375 $this->_formValues = $this->controller->exportValues($this->_name);
376 }
377
378 if (empty($this->_formValues)) {
379 $this->_formValues = $this->controller->exportValues($this->_name);
380 }
381
382 $this->fixFormValues();
383
384 if (isset($this->_ssID) && empty($_POST)) {
385 // if we are editing / running a saved search and the form has not been posted
386 $this->_formValues = CRM_Contact_BAO_SavedSearch::getFormValues($this->_ssID);
387 }
388
d43b88cc
CW
389 // We don't show test records in summaries or dashboards
390 if (empty($this->_formValues['participant_test']) && $this->_force) {
6a488035
TO
391 $this->_formValues["participant_test"] = 0;
392 }
393
394 CRM_Core_BAO_CustomValue::fixFieldValueOfTypeMemo($this->_formValues);
395
396 $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
397
398 $this->set('formValues', $this->_formValues);
399 $this->set('queryParams', $this->_queryParams);
400
401 $buttonName = $this->controller->getButtonName();
402 if ($buttonName == $this->_actionButtonName || $buttonName == $this->_printButtonName) {
403 // check actionName and if next, then do not repeat a search, since we are going to the next page
404
405 // hack, make sure we reset the task values
a5611c8e 406 $stateMachine = $this->controller->getStateMachine();
6a488035
TO
407 $formName = $stateMachine->getTaskFormName();
408 $this->controller->resetPage($formName);
409 return;
410 }
411
412 $sortID = NULL;
413 if ($this->get(CRM_Utils_Sort::SORT_ID)) {
414 $sortID = CRM_Utils_Sort::sortIDValue($this->get(CRM_Utils_Sort::SORT_ID),
415 $this->get(CRM_Utils_Sort::SORT_DIRECTION)
416 );
417 }
418
419 $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
420
421 $selector = new CRM_Event_Selector_Search($this->_queryParams,
422 $this->_action,
423 NULL,
424 $this->_single,
425 $this->_limit,
426 $this->_context
427 );
428
429 $selector->setKey($this->controller->_key);
430
431 $prefix = NULL;
432 if ($this->_context == 'user') {
433 $prefix = $this->_prefix;
434 }
435
436 $this->assign("{$prefix}limit", $this->_limit);
437 $this->assign("{$prefix}single", $this->_single);
438
439 $controller = new CRM_Core_Selector_Controller($selector,
440 $this->get(CRM_Utils_Pager::PAGE_ID),
441 $sortID,
442 CRM_Core_Action::VIEW,
443 $this,
444 CRM_Core_Selector_Controller::SESSION,
445 $prefix
446 );
447 $controller->setEmbedded(TRUE);
448
a5611c8e 449 $query = $selector->getQuery();
6a488035
TO
450 if ($this->_context == 'user') {
451 $query->setSkipPermission(TRUE);
452 }
453 $controller->run();
454 }
455
456 /**
457 * This function is used to add the rules (mainly global rules) for form.
458 * All local rules are added near the element
459 *
355ba699 460 * @return void
6a488035
TO
461 * @access public
462 * @see valid_date
463 */
464 function addRules() {
465 $this->addFormRule(array('CRM_Event_Form_Search', 'formRule'));
466 }
467
468 /**
469 * global validation rules for the form
470 *
471 * @param array $fields posted values of the form
472 * @param array $errors list of errors to be posted back to the form
473 *
474 * @return void
475 * @static
476 * @access public
477 */
478 static function formRule($fields) {
479 $errors = array();
480
481 if ($fields['event_name'] && !is_numeric($fields['event_id'])) {
482 $errors['event_id'] = ts('Please select valid event.');
483 }
484
485 if ($fields['event_type'] && !is_numeric($fields['event_type_id'])) {
486 $errors['event_type'] = ts('Please select valid event type.');
487 }
488 if (!empty($errors)) {
489 return $errors;
490 }
491
492 return TRUE;
493 }
494
495 /**
496 * Set the default form values
497 *
498 * @access protected
499 *
500 * @return array the default array reference
501 */
502 function setDefaultValues() {
503 $defaults = array();
504 $defaults = $this->_formValues;
505 return $defaults;
506 }
507
508 function fixFormValues() {
509 // if this search has been forced
510 // then see if there are any get values, and if so over-ride the post values
511 // note that this means that GET over-rides POST :)
512 $event = CRM_Utils_Request::retrieve('event', 'Positive',
513 CRM_Core_DAO::$_nullObject
514 );
515 if ($event) {
516 $this->_formValues['event_id'] = $event;
517 $this->_formValues['event_name'] = CRM_Event_PseudoConstant::event($event, TRUE);
518 }
519
520 $status = CRM_Utils_Request::retrieve('status', 'String',
521 CRM_Core_DAO::$_nullObject
522 );
523
524 if (isset($status)) {
525 if ($status === 'true') {
526 $statusTypes = CRM_Event_PseudoConstant::participantStatus(NULL, "is_counted = 1");
527 }
528 elseif ($status === 'false') {
529 $statusTypes = CRM_Event_PseudoConstant::participantStatus(NULL, "is_counted = 0");
530 }
531 elseif (is_numeric($status)) {
532 $status = (int) $status;
533 $statusTypes = array($status => CRM_Event_PseudoConstant::participantStatus($status));
534 }
535 $status = array();
536 foreach ($statusTypes as $key => $value) {
537 $status[$key] = 1;
538 }
539 $this->_formValues['participant_status_id'] = $status;
540 }
541
542 $role = CRM_Utils_Request::retrieve('role', 'String',
543 CRM_Core_DAO::$_nullObject
544 );
545
546 if (isset($role)) {
547 if ($role === 'true') {
548 $roleTypes = CRM_Event_PseudoConstant::participantRole(NULL, "filter = 1");
549 }
550 elseif ($role === 'false') {
551 $roleTypes = CRM_Event_PseudoConstant::participantRole(NULL, "filter = 0");
552 }
553 elseif (is_numeric($role)) {
554 $role = (int) $role;
555 $roleTypes = array($role => CRM_Event_PseudoConstant::participantRole($role));
556 }
557 $role = array();
558 foreach ($roleTypes as $key => $value) {
559 $role[$key] = 1;
560 }
561 $this->_formValues['participant_role_id'] = $role;
562 }
563
564 $type = CRM_Utils_Request::retrieve('type', 'Positive',
565 CRM_Core_DAO::$_nullObject
566 );
567 if ($type) {
568 $this->_formValues['event_type'] = $type;
569 }
570
571 $cid = CRM_Utils_Request::retrieve('cid', 'Positive', $this);
572
573 if ($cid) {
574 $cid = CRM_Utils_Type::escape($cid, 'Integer');
575 if ($cid > 0) {
576 $this->_formValues['contact_id'] = $cid;
577
578 // also assign individual mode to the template
579 $this->_single = TRUE;
580 }
581 }
582 }
583
584 function getFormValues() {
585 return NULL;
586 }
587
588 /**
589 * Return a descriptive name for the page, used in wizard header
590 *
591 * @return string
592 * @access public
593 */
594 public function getTitle() {
595 return ts('Find Participants');
596 }
597}
598