CRM/Activity/Form/Search.php

   1 <?php
   2 /*
   3  +--------------------------------------------------------------------+
   4  | CiviCRM version 5                                                  |
   5  +--------------------------------------------------------------------+
   6  | Copyright CiviCRM LLC (c) 2004-2018                                |
   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
  31  * @copyright CiviCRM LLC (c) 2004-2018
  32  */
  33
  34 /**
  35  * This file is for activity search.
  36  */
  37 class CRM_Activity_Form_Search extends CRM_Core_Form_Search {
  38
  39   /**
  40    * The params that are sent to the query.
  41    *
  42    * @var array
  43    */
  44   protected $_queryParams;
  45
  46   /**
  47    * Are we restricting ourselves to a single contact.
  48    *
  49    * @var boolean
  50    */
  51   protected $_single = FALSE;
  52
  53   /**
  54    * Are we restricting ourselves to a single contact.
  55    *
  56    * @var boolean
  57    */
  58   protected $_limit = NULL;
  59
  60   /**
  61    * Prefix for the controller.
  62    */
  63   protected $_prefix = "activity_";
  64
  65   /**
  66    * The saved search ID retrieved from the GET vars.
  67    *
  68    * @var int
  69    */
  70   protected $_ssID;
  71
  72   /**
  73    * @return string
  74    */
  75   public function getDefaultEntity() {
  76     return 'Activity';
  77   }
  78
  79   /**
  80    * Processing needed for buildForm and later.
  81    */
  82   public function preProcess() {
  83     $this->set('searchFormName', 'Search');
  84
  85     // set the button names
  86     $this->_searchButtonName = $this->getButtonName('refresh');
  87     $this->_actionButtonName = $this->getButtonName('next', 'action');
  88
  89     $this->_done = FALSE;
  90     $this->defaults = array();
  91
  92     $this->loadStandardSearchOptionsFromUrl();
  93
  94     // get user submitted values
  95     // get it from controller only if form has been submitted, else preProcess has set this
  96     if (!empty($_POST) && !$this->controller->isModal()) {
  97       $this->_formValues = $this->controller->exportValues($this->_name);
  98     }
  99     else {
 100       $this->_formValues = $this->get('formValues');
 101
 102       if ($this->_force) {
 103         // If we force the search then merge form values with url values
 104         // and set submit values to form values.
 105         // @todo this is not good security practice. Instead define the fields in metadata & use
 106         // getEntityDefaults.
 107         $this->_formValues = array_merge((array) $this->_formValues, CRM_Utils_Request::exportValues());
 108         $this->_submitValues = $this->_formValues;
 109       }
 110     }
 111
 112     if (empty($this->_formValues)) {
 113       if (isset($this->_ssID)) {
 114         $this->_formValues = CRM_Contact_BAO_SavedSearch::getFormValues($this->_ssID);
 115       }
 116     }
 117
 118     if ($this->_force) {
 119       $this->postProcess();
 120       $this->set('force', 0);
 121     }
 122
 123     $sortID = NULL;
 124     if ($this->get(CRM_Utils_Sort::SORT_ID)) {
 125       $sortID = CRM_Utils_Sort::sortIDValue($this->get(CRM_Utils_Sort::SORT_ID),
 126         $this->get(CRM_Utils_Sort::SORT_DIRECTION)
 127       );
 128     }
 129
 130     $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
 131     $selector = new CRM_Activity_Selector_Search($this->_queryParams,
 132       $this->_action,
 133       NULL,
 134       $this->_single,
 135       $this->_limit,
 136       $this->_context
 137     );
 138     $prefix = NULL;
 139     if ($this->_context == 'user') {
 140       $prefix = $this->_prefix;
 141     }
 142
 143     $this->assign("{$prefix}limit", $this->_limit);
 144     $this->assign("{$prefix}single", $this->_single);
 145
 146     $controller = new CRM_Core_Selector_Controller($selector,
 147       $this->get(CRM_Utils_Pager::PAGE_ID),
 148       $sortID,
 149       CRM_Core_Action::VIEW,
 150       $this,
 151       CRM_Core_Selector_Controller::TRANSFER,
 152       $prefix
 153     );
 154     $controller->setEmbedded(TRUE);
 155     $controller->moveFromSessionToTemplate();
 156
 157     $this->assign('summary', $this->get('summary'));
 158   }
 159
 160   /**
 161    * Build the form object.
 162    */
 163   public function buildQuickForm() {
 164     parent::buildQuickForm();
 165     $this->addSortNameField();
 166
 167     CRM_Activity_BAO_Query::buildSearchForm($this);
 168
 169     $rows = $this->get('rows');
 170     if (is_array($rows)) {
 171       if (!$this->_single) {
 172         $this->addRowSelectors($rows);
 173       }
 174
 175       $this->addTaskMenu(CRM_Activity_Task::permissionedTaskTitles(CRM_Core_Permission::getPermission()));
 176     }
 177
 178   }
 179
 180   /**
 181    * The post processing of the form gets done here.
 182    *
 183    * Key things done during post processing are
 184    *      - check for reset or next request. if present, skip post procesing.
 185    *      - now check if user requested running a saved search, if so, then
 186    *        the form values associated with the saved search are used for searching.
 187    *      - if user has done a submit with new values the regular post submissing is
 188    *        done.
 189    *
 190    * The processing consists of using a Selector / Controller framework for getting the
 191    * search results.
 192    */
 193   public function postProcess() {
 194     if ($this->_done) {
 195       return;
 196     }
 197
 198     $this->_done = TRUE;
 199
 200     if (!empty($_POST)) {
 201       $this->_formValues = $this->controller->exportValues($this->_name);
 202       $specialParams = array(
 203         'activity_type_id',
 204         'status_id',
 205         'priority_id',
 206         'activity_text',
 207       );
 208       $changeNames = array(
 209         'status_id' => 'activity_status_id',
 210         'priority_id' => 'activity_priority_id',
 211       );
 212
 213       CRM_Contact_BAO_Query::processSpecialFormValue($this->_formValues, $specialParams, $changeNames);
 214     }
 215     $this->fixFormValues();
 216
 217     if (isset($this->_ssID) && empty($_POST)) {
 218       // if we are editing / running a saved search and the form has not been posted
 219       $this->_formValues = CRM_Contact_BAO_SavedSearch::getFormValues($this->_ssID);
 220     }
 221
 222     // We don't show test records in summaries or dashboards
 223     if (empty($this->_formValues['activity_test']) && $this->_force) {
 224       $this->_formValues["activity_test"] = 0;
 225     }
 226
 227     CRM_Core_BAO_CustomValue::fixCustomFieldValue($this->_formValues);
 228
 229     $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
 230
 231     $this->set('formValues', $this->_formValues);
 232     $this->set('queryParams', $this->_queryParams);
 233
 234     $buttonName = $this->controller->getButtonName();
 235     if ($buttonName == $this->_actionButtonName) {
 236       // check actionName and if next, then do not repeat a search, since we are going to the next page
 237       // hack, make sure we reset the task values
 238       $stateMachine = $this->controller->getStateMachine();
 239       $formName = $stateMachine->getTaskFormName();
 240       $this->controller->resetPage($formName);
 241       return;
 242     }
 243
 244     $sortID = NULL;
 245     if ($this->get(CRM_Utils_Sort::SORT_ID)) {
 246       $sortID = CRM_Utils_Sort::sortIDValue($this->get(CRM_Utils_Sort::SORT_ID),
 247         $this->get(CRM_Utils_Sort::SORT_DIRECTION)
 248       );
 249     }
 250
 251     $this->_queryParams = CRM_Contact_BAO_Query::convertFormValues($this->_formValues);
 252
 253     $selector = new CRM_Activity_Selector_Search($this->_queryParams,
 254       $this->_action,
 255       NULL,
 256       $this->_single,
 257       $this->_limit,
 258       $this->_context
 259     );
 260     $selector->setKey($this->controller->_key);
 261
 262     $prefix = NULL;
 263     if ($this->_context == 'basic' || $this->_context == 'user') {
 264       $prefix = $this->_prefix;
 265     }
 266
 267     $controller = new CRM_Core_Selector_Controller($selector,
 268       $this->get(CRM_Utils_Pager::PAGE_ID),
 269       $sortID,
 270       CRM_Core_Action::VIEW,
 271       $this,
 272       CRM_Core_Selector_Controller::SESSION,
 273       $prefix
 274     );
 275     $controller->setEmbedded(TRUE);
 276     $query = &$selector->getQuery();
 277
 278     if ($this->_context == 'user') {
 279       $query->setSkipPermission(TRUE);
 280     }
 281     $controller->run();
 282   }
 283
 284   public function fixFormValues() {
 285     if (!$this->_force) {
 286       return;
 287     }
 288
 289     $status = CRM_Utils_Request::retrieve('status', 'String', $this);
 290     if ($status) {
 291       $this->_formValues['activity_status_id'] = $status;
 292       $this->_defaults['activity_status_id'] = $status;
 293     }
 294
 295     $survey = CRM_Utils_Request::retrieve('survey', 'Positive');
 296
 297     if ($survey) {
 298       $this->_formValues['activity_survey_id'] = $this->_defaults['activity_survey_id'] = $survey;
 299       $sid = CRM_Utils_Array::value('activity_survey_id', $this->_formValues);
 300       $activity_type_id = CRM_Core_DAO::getFieldValue('CRM_Campaign_DAO_Survey', $sid, 'activity_type_id');
 301
 302       // since checkbox are replaced by multiple select option
 303       $this->_formValues['activity_type_id'] = $activity_type_id;
 304       $this->_defaults['activity_type_id'] = $activity_type_id;
 305     }
 306     $cid = CRM_Utils_Request::retrieve('cid', 'Positive', $this);
 307
 308     if ($cid) {
 309       $cid = CRM_Utils_Type::escape($cid, 'Integer');
 310       if ($cid > 0) {
 311         $this->_formValues['contact_id'] = $cid;
 312
 313         $activity_role = CRM_Utils_Request::retrieve('activity_role', 'Positive', $this);
 314
 315         if ($activity_role) {
 316           $this->_formValues['activity_role'] = $activity_role;
 317         }
 318         else {
 319           $this->_defaults['sort_name'] = CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_Contact', $cid, 'sort_name');
 320         }
 321         // also assign individual mode to the template
 322         $this->_single = TRUE;
 323       }
 324     }
 325
 326     // Added for membership search
 327
 328     $signupType = CRM_Utils_Request::retrieve('signupType', 'Positive');
 329
 330     if ($signupType) {
 331       $this->_formValues['activity_role'] = 1;
 332       $this->_defaults['activity_role'] = 1;
 333       $activityTypes = CRM_Core_PseudoConstant::activityType(TRUE, FALSE, FALSE, 'name');
 334
 335       $renew = CRM_Utils_Array::key('Membership Renewal', $activityTypes);
 336       $signup = CRM_Utils_Array::key('Membership Signup', $activityTypes);
 337
 338       switch ($signupType) {
 339         case 3: // signups and renewals
 340           $this->_formValues['activity_type_id'][$renew] = 1;
 341           $this->_defaults['activity_type_id'][$renew] = 1;
 342         case 1: // signups only
 343           $this->_formValues['activity_type_id'][$signup] = 1;
 344           $this->_defaults['activity_type_id'][$signup] = 1;
 345           break;
 346
 347         case 2: // renewals only
 348           $this->_formValues['activity_type_id'][$renew] = 1;
 349           $this->_defaults['activity_type_id'][$renew] = 1;
 350           break;
 351       }
 352     }
 353
 354     $dateLow = CRM_Utils_Request::retrieve('dateLow', 'String');
 355
 356     if ($dateLow) {
 357       $dateLow = date('m/d/Y', strtotime($dateLow));
 358       $this->_formValues['activity_date_relative'] = 0;
 359       $this->_defaults['activity_date_relative'] = 0;
 360       $this->_formValues['activity_date_low'] = $dateLow;
 361       $this->_defaults['activity_date_low'] = $dateLow;
 362     }
 363
 364     $dateHigh = CRM_Utils_Request::retrieve('dateHigh', 'String');
 365
 366     if ($dateHigh) {
 367       // Activity date time assumes midnight at the beginning of the date
 368       // This sets it to almost midnight at the end of the date
 369       /*   if ($dateHigh <= 99999999) {
 370       $dateHigh = 1000000 * $dateHigh + 235959;
 371       } */
 372       $dateHigh = date('m/d/Y', strtotime($dateHigh));
 373       $this->_formValues['activity_date_relative'] = 0;
 374       $this->_defaults['activity_date_relative'] = 0;
 375       $this->_formValues['activity_date_high'] = $dateHigh;
 376       $this->_defaults['activity_date_high'] = $dateHigh;
 377     }
 378
 379     // Enable search activity by custom value
 380     // @todo this is not good security practice. Instead define entity fields in metadata &
 381     // use getEntity Defaults
 382     $requestParams = CRM_Utils_Request::exportValues();
 383     foreach (array_keys($requestParams) as $key) {
 384       if (substr($key, 0, 7) != 'custom_') {
 385         continue;
 386       }
 387       elseif (empty($requestParams[$key])) {
 388         continue;
 389       }
 390       $customValue = CRM_Utils_Request::retrieve($key, 'String', $this);
 391       if ($customValue) {
 392         $this->_formValues[$key] = $customValue;
 393         $this->_defaults[$key] = $customValue;
 394       }
 395     }
 396
 397     if (!empty($this->_defaults)) {
 398       $this->setDefaults($this->_defaults);
 399     }
 400   }
 401
 402   /**
 403    * @return null
 404    */
 405   public function getFormValues() {
 406     return NULL;
 407   }
 408
 409   /**
 410    * This virtual function is used to set the default values of various form elements.
 411    *
 412    * @return array|NULL
 413    *   reference to the array of default values
 414    */
 415   public function setDefaultValues() {
 416     return array_merge($this->getEntityDefaults($this->getDefaultEntity()), $this->_formValues);
 417   }
 418
 419   /**
 420    * Return a descriptive name for the page, used in wizard header
 421    *
 422    * @return string
 423    */
 424   public function getTitle() {
 425     return ts('Find Activities');
 426   }
 427
 428   protected function getEntityMetadata() {
 429     return CRM_Activity_BAO_Query::getSearchFieldMetadata();
 430   }
 431
 432 }