3 +--------------------------------------------------------------------+
5 +--------------------------------------------------------------------+
6 | Copyright CiviCRM LLC (c) 2004-2018 |
7 +--------------------------------------------------------------------+
8 | This file is a part of CiviCRM. |
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. |
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. |
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 +--------------------------------------------------------------------+
31 * @copyright CiviCRM LLC (c) 2004-2018
33 class CRM_Activity_BAO_Query
{
36 * Build select for Case.
38 * @param CRM_Contact_BAO_Query $query
40 public static function select(&$query) {
41 if (!empty($query->_returnProperties
['activity_id'])) {
42 $query->_select
['activity_id'] = 'civicrm_activity.id as activity_id';
43 $query->_element
['activity_id'] = 1;
44 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
47 if (!empty($query->_returnProperties
['activity_type_id'])) {
48 $query->_select
['activity_type_id'] = 'activity_type.value as activity_type_id';
49 $query->_element
['activity_type_id'] = 1;
50 $query->_tables
['civicrm_activity'] = 1;
51 $query->_tables
['activity_type'] = 1;
52 $query->_whereTables
['civicrm_activity'] = 1;
53 $query->_whereTables
['activity_type'] = 1;
56 if (!empty($query->_returnProperties
['activity_type'])) {
57 $query->_select
['activity_type'] = 'activity_type.label as activity_type';
58 $query->_element
['activity_type'] = 1;
59 $query->_tables
['civicrm_activity'] = 1;
60 $query->_tables
['activity_type'] = 1;
61 $query->_whereTables
['civicrm_activity'] = 1;
62 $query->_whereTables
['activity_type'] = 1;
65 if (!empty($query->_returnProperties
['activity_subject'])) {
66 $query->_select
['activity_subject'] = 'civicrm_activity.subject as activity_subject';
67 $query->_element
['activity_subject'] = 1;
68 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
71 if (!empty($query->_returnProperties
['activity_date_time'])) {
72 $query->_select
['activity_date_time'] = 'civicrm_activity.activity_date_time as activity_date_time';
73 $query->_element
['activity_date_time'] = 1;
74 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
77 if (!empty($query->_returnProperties
['activity_status_id'])) {
78 $query->_select
['activity_status_id'] = 'civicrm_activity.status_id as activity_status_id';
79 $query->_element
['activity_status_id'] = 1;
80 $query->_tables
['civicrm_activity'] = 1;
81 $query->_whereTables
['civicrm_activity'] = 1;
84 if (!empty($query->_returnProperties
['activity_status'])) {
85 $query->_select
['activity_status'] = 'activity_status.label as activity_status,
86 civicrm_activity.status_id as status_id';
87 $query->_element
['activity_status'] = 1;
88 $query->_tables
['civicrm_activity'] = 1;
89 $query->_tables
['activity_status'] = 1;
90 $query->_whereTables
['civicrm_activity'] = 1;
91 $query->_whereTables
['activity_status'] = 1;
94 if (!empty($query->_returnProperties
['activity_duration'])) {
95 $query->_select
['activity_duration'] = 'civicrm_activity.duration as activity_duration';
96 $query->_element
['activity_duration'] = 1;
97 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
100 if (!empty($query->_returnProperties
['activity_location'])) {
101 $query->_select
['activity_location'] = 'civicrm_activity.location as activity_location';
102 $query->_element
['activity_location'] = 1;
103 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
106 if (!empty($query->_returnProperties
['activity_details'])) {
107 $query->_select
['activity_details'] = 'civicrm_activity.details as activity_details';
108 $query->_element
['activity_details'] = 1;
109 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
112 if (!empty($query->_returnProperties
['source_record_id'])) {
113 $query->_select
['source_record_id'] = 'civicrm_activity.source_record_id as source_record_id';
114 $query->_element
['source_record_id'] = 1;
115 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
118 if (!empty($query->_returnProperties
['activity_is_test'])) {
119 $query->_select
['activity_is_test'] = 'civicrm_activity.is_test as activity_is_test';
120 $query->_element
['activity_is_test'] = 1;
121 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
124 if (!empty($query->_returnProperties
['activity_campaign_id'])) {
125 $query->_select
['activity_campaign_id'] = 'civicrm_activity.campaign_id as activity_campaign_id';
126 $query->_element
['activity_campaign_id'] = 1;
127 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
130 if (!empty($query->_returnProperties
['activity_engagement_level'])) {
131 $query->_select
['activity_engagement_level'] = 'civicrm_activity.engagement_level as activity_engagement_level';
132 $query->_element
['activity_engagement_level'] = 1;
133 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
136 if (!empty($query->_returnProperties
['source_contact'])) {
137 $query->_select
['source_contact'] = 'source_contact.sort_name as source_contact';
138 $query->_element
['source_contact'] = 1;
139 $query->_tables
['civicrm_activity'] = $query->_tables
['source_contact'] = $query->_whereTables
['source_contact'] = 1;
142 if (!empty($query->_returnProperties
['source_contact_id'])) {
143 $query->_select
['source_contact_id'] = 'source_contact.id as source_contact_id';
144 $query->_element
['source_contact_id'] = 1;
145 $query->_tables
['civicrm_activity'] = $query->_tables
['source_contact'] = $query->_whereTables
['source_contact'] = 1;
148 if (!empty($query->_returnProperties
['activity_result'])) {
149 $query->_select
['activity_result'] = 'civicrm_activity.result as activity_result';
150 $query->_element
['result'] = 1;
151 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
154 if (CRM_Utils_Array
::value('parent_id', $query->_returnProperties
)) {
155 $query->_tables
['parent_id'] = 1;
156 $query->_whereTables
['parent_id'] = 1;
157 $query->_element
['parent_id'] = 1;
160 if (!empty($query->_returnProperties
['activity_priority'])) {
161 $query->_select
['activity_priority'] = 'activity_priority.label as activity_priority,
162 civicrm_activity.priority_id as priority_id';
163 $query->_element
['activity_priority'] = 1;
164 $query->_tables
['activity_priority'] = 1;
165 $query->_whereTables
['activity_priority'] = 1;
166 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
171 * Given a list of conditions in query generate the required where clause.
175 public static function where(&$query) {
176 foreach (array_keys($query->_params
) as $id) {
177 if (substr($query->_params
[$id][0], 0, 9) == 'activity_') {
178 if ($query->_mode
== CRM_Contact_BAO_QUERY
::MODE_CONTACTS
) {
179 $query->_useDistinct
= TRUE;
181 $query->_params
[$id][3];
182 self
::whereClauseSingle($query->_params
[$id], $query);
188 * Where clause for a single field.
190 * @param array $values
191 * @param CRM_Contact_BAO_Query $query
193 public static function whereClauseSingle(&$values, &$query) {
194 list($name, $op, $value, $grouping) = $values;
196 $fields = CRM_Activity_BAO_Activity
::exportableFields();
197 $query->_tables
['civicrm_activity'] = $query->_whereTables
['civicrm_activity'] = 1;
198 if ($query->_mode
& CRM_Contact_BAO_Query
::MODE_ACTIVITY
) {
199 $query->_skipDeleteClause
= TRUE;
203 case 'activity_type_id':
204 case 'activity_status_id':
205 case 'activity_engagement_level':
207 case 'activity_campaign_id':
208 case 'activity_priority_id':
209 // We no longer expect "subject" as a specific criteria (as of CRM-19447),
210 // but we still use activity_subject in Activity.Get API
211 case 'activity_subject':
214 if (in_array($name, array('activity_engagement_level', 'activity_id'))) {
215 $name = $qillName = str_replace('activity_', '', $name);
217 if (in_array($name, array('activity_status_id', 'activity_subject', 'activity_priority_id'))) {
218 $name = str_replace('activity_', '', $name);
219 $qillName = str_replace('_id', '', $qillName);
221 if ($name == 'activity_campaign_id') {
222 $name = 'campaign_id';
225 $dataType = !empty($fields[$qillName]['type']) ? CRM_Utils_Type
::typeToString($fields[$qillName]['type']) : 'String';
227 $query->_where
[$grouping][] = CRM_Contact_BAO_Query
::buildClause("civicrm_activity.$name", $op, $value, $dataType);
228 list($op, $value) = CRM_Contact_BAO_Query
::buildQillForFieldValue('CRM_Activity_DAO_Activity', $name, $value, $op);
229 $query->_qill
[$grouping][] = ts('%1 %2 %3', array(1 => $fields[$qillName]['title'], 2 => $op, 3 => $value));
232 case 'activity_text':
233 self
::whereClauseSingleActivityText($values, $query);
236 case 'activity_type':
237 case 'activity_status':
238 case 'activity_priority':
239 $query->_where
[$grouping][] = CRM_Contact_BAO_Query
::buildClause("$name.label", $op, $value, 'String');
240 list($op, $value) = CRM_Contact_BAO_Query
::buildQillForFieldValue('CRM_Activity_DAO_Activity', $name, $value, $op);
241 $query->_qill
[$grouping][] = ts('%1 %2 %3', array(1 => $fields[$name]['title'], 2 => $op, 3 => $value));
242 $query->_tables
[$name] = $query->_whereTables
[$name] = 1;
245 case 'activity_survey_id':
249 $value = CRM_Utils_Type
::escape($value, 'Integer');
250 $query->_where
[$grouping][] = " civicrm_activity.source_record_id = $value";
251 $query->_qill
[$grouping][] = ts('Survey') . ' - ' . CRM_Core_DAO
::getFieldValue('CRM_Campaign_DAO_Survey', $value, 'title');
254 case 'activity_role':
255 CRM_Contact_BAO_Query
::$_activityRole = $values[2];
256 $activityContacts = CRM_Activity_BAO_ActivityContact
::buildOptions('record_type_id', 'validate');
257 $sourceID = CRM_Utils_Array
::key('Activity Source', $activityContacts);
258 $assigneeID = CRM_Utils_Array
::key('Activity Assignees', $activityContacts);
259 $targetID = CRM_Utils_Array
::key('Activity Targets', $activityContacts);
262 $query->_tables
['civicrm_activity_contact'] = $query->_whereTables
['civicrm_activity_contact'] = 1;
263 if ($values[2] == 1) {
264 $query->_where
[$grouping][] = " civicrm_activity_contact.record_type_id = $sourceID";
265 $query->_qill
[$grouping][] = ts('Activity created by');
267 elseif ($values[2] == 2) {
268 $query->_where
[$grouping][] = " civicrm_activity_contact.record_type_id = $assigneeID";
269 $query->_qill
[$grouping][] = ts('Activity assigned to');
271 elseif ($values[2] == 3) {
272 $query->_where
[$grouping][] = " civicrm_activity_contact.record_type_id = $targetID";
273 $query->_qill
[$grouping][] = ts('Activity targeted to');
278 case 'activity_test':
279 // We don't want to include all tests for sql OR CRM-7827
280 if (!$value ||
$query->getOperator() != 'OR') {
281 $query->_where
[$grouping][] = CRM_Contact_BAO_Query
::buildClause("civicrm_activity.is_test", $op, $value, "Boolean");
283 $query->_qill
[$grouping][] = ts('Activity is a Test');
288 case 'activity_date':
289 case 'activity_date_low':
290 case 'activity_date_high':
291 $query->dateQueryBuilder($values,
292 'civicrm_activity', 'activity_date', 'activity_date_time', ts('Activity Date')
296 case 'activity_taglist':
299 foreach ($taglist as $val) {
301 $val = explode(',', $val);
302 foreach ($val as $tId) {
303 if (is_numeric($tId)) {
310 case 'activity_tags':
311 $value = array_keys($value);
312 $activityTags = CRM_Core_PseudoConstant
::get('CRM_Core_DAO_EntityTag', 'tag_id', array('onlyActive' => FALSE));
315 if (is_array($value)) {
316 foreach ($value as $k => $v) {
317 $names[] = $activityTags[$v];
320 $query->_where
[$grouping][] = "civicrm_activity_tag.tag_id IN (" . implode(",", $value) . ")";
321 $query->_qill
[$grouping][] = ts('Activity Tag %1', array(1 => $op)) . ' ' . implode(' ' . ts('OR') . ' ', $names);
322 $query->_tables
['civicrm_activity_tag'] = $query->_whereTables
['civicrm_activity_tag'] = 1;
325 case 'activity_result':
326 if (is_array($value)) {
328 foreach ($values as $id => $k) {
329 $safe[] = "'" . CRM_Utils_Type
::escape($k, 'String') . "'";
331 $query->_where
[$grouping][] = "civicrm_activity.result IN (" . implode(',', $safe) . ")";
332 $query->_qill
[$grouping][] = ts("Activity Result - %1", array(1 => implode(' or ', $safe)));
338 $query->_where
[$grouping][] = "parent_id.parent_id IS NOT NULL";
339 $query->_qill
[$grouping][] = ts('Activities which have Followup Activities');
341 elseif ($value == 2) {
342 $query->_where
[$grouping][] = "parent_id.parent_id IS NULL";
343 $query->_qill
[$grouping][] = ts('Activities without Followup Activities');
347 case 'followup_parent_id':
349 $query->_where
[$grouping][] = "civicrm_activity.parent_id IS NOT NULL";
350 $query->_qill
[$grouping][] = ts('Activities which are Followup Activities');
352 elseif ($value == 2) {
353 $query->_where
[$grouping][] = "civicrm_activity.parent_id IS NULL";
354 $query->_qill
[$grouping][] = ts('Activities which are not Followup Activities');
358 case 'source_contact':
359 case 'source_contact_id':
360 $columnName = strstr($name, '_id') ?
'id' : 'sort_name';
361 $query->_where
[$grouping][] = CRM_Contact_BAO_Query
::buildClause("source_contact.{$columnName}", $op, $value, CRM_Utils_Type
::typeToString($fields[$name]['type']));
362 list($op, $value) = CRM_Contact_BAO_Query
::buildQillForFieldValue('CRM_Contact_DAO_Contact', $columnName, $value, $op);
363 $query->_qill
[$grouping][] = ts('%1 %2 %3', array(1 => $fields[$name]['title'], 2 => $op, 3 => $value));
369 * @param string $name
373 * @return null|string
375 public static function from($name, $mode, $side) {
378 case 'civicrm_activity':
379 //CRM-7480 we are going to civicrm_activity table either
380 //from civicrm_activity_target or civicrm_activity_assignment.
381 //as component specific activities does not have entry in
382 //activity target table so lets consider civicrm_activity_assignment.
383 $from .= " $side JOIN civicrm_activity_contact
384 ON ( civicrm_activity_contact.contact_id = contact_a.id ) ";
385 $from .= " $side JOIN civicrm_activity
386 ON ( civicrm_activity.id = civicrm_activity_contact.activity_id
387 AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 )";
388 // Do not show deleted contact's activity
389 $from .= " INNER JOIN civicrm_contact
390 ON ( civicrm_activity_contact.contact_id = civicrm_contact.id and civicrm_contact.is_deleted != 1 )";
393 case 'activity_status':
394 $from .= " $side JOIN civicrm_option_group option_group_activity_status ON (option_group_activity_status.name = 'activity_status')";
395 $from .= " $side JOIN civicrm_option_value activity_status ON (civicrm_activity.status_id = activity_status.value
396 AND option_group_activity_status.id = activity_status.option_group_id ) ";
399 case 'activity_type':
400 $from .= " $side JOIN civicrm_option_group option_group_activity_type ON (option_group_activity_type.name = 'activity_type')";
401 $from .= " $side JOIN civicrm_option_value activity_type ON (civicrm_activity.activity_type_id = activity_type.value
402 AND option_group_activity_type.id = activity_type.option_group_id ) ";
405 case 'activity_priority':
406 $from .= " $side JOIN civicrm_option_group option_group_activity_priority ON (option_group_activity_priority.name = 'priority')";
407 $from .= " $side JOIN civicrm_option_value activity_priority ON (civicrm_activity.priority_id = activity_priority.value
408 AND option_group_activity_priority.id = activity_priority.option_group_id ) ";
411 case 'civicrm_activity_tag':
412 $from .= " $side JOIN civicrm_entity_tag as civicrm_activity_tag ON ( civicrm_activity_tag.entity_table = 'civicrm_activity' AND civicrm_activity_tag.entity_id = civicrm_activity.id ) ";
415 case 'source_contact':
416 $activityContacts = CRM_Activity_BAO_ActivityContact
::buildOptions('record_type_id', 'validate');
417 $sourceID = CRM_Utils_Array
::key('Activity Source', $activityContacts);
419 INNER JOIN civicrm_contact source_contact ON
420 (civicrm_activity_contact.contact_id = source_contact.id) AND civicrm_activity_contact.record_type_id = {$sourceID}";
424 $from = "$side JOIN civicrm_activity AS parent_id ON civicrm_activity.id = parent_id.parent_id";
432 * Add all the elements shared between case activity search and advanced search.
434 * @param CRM_Core_Form $form
436 public static function buildSearchForm(&$form) {
437 $form->addSelect('activity_type_id',
438 array('entity' => 'activity', 'label' => ts('Activity Type(s)'), 'multiple' => 'multiple', 'option_url' => NULL, 'placeholder' => ts('- any -'))
441 CRM_Core_Form_Date
::buildDateRange($form, 'activity_date', 1, '_low', '_high', ts('From'), FALSE, FALSE);
442 $form->addElement('hidden', 'activity_date_range_error');
443 $form->addFormRule(array('CRM_Activity_BAO_Query', 'formRule'), $form);
445 $followUpActivity = array(
449 $form->addRadio('parent_id', NULL, $followUpActivity, array('allowClear' => TRUE));
450 $form->addRadio('followup_parent_id', NULL, $followUpActivity, array('allowClear' => TRUE));
451 $activityRoles = array(
453 2 => ts('Assigned to'),
456 $form->addRadio('activity_role', NULL, $activityRoles, array('allowClear' => TRUE));
457 $form->setDefaults(array('activity_role' => 3));
458 $activityStatus = CRM_Core_PseudoConstant
::get('CRM_Activity_DAO_Activity', 'status_id', array('flip' => 1, 'labelColumn' => 'name'));
459 $form->addSelect('status_id',
460 array('entity' => 'activity', 'multiple' => 'multiple', 'option_url' => NULL, 'placeholder' => ts('- any -'))
462 $ssID = $form->get('ssID');
463 $status = array($activityStatus['Completed'], $activityStatus['Scheduled']);
464 //If status is saved in smart group.
465 if (!empty($ssID) && !empty($form->_formValues
['activity_status_id'])) {
466 $status = $form->_formValues
['activity_status_id'];
468 $form->setDefaults(array('status_id' => $status));
470 $form->addElement('text', 'activity_text', ts('Activity Text'), CRM_Core_DAO
::getAttribute('CRM_Contact_DAO_Contact', 'sort_name'));
472 $form->addRadio('activity_option', '', CRM_Core_SelectValues
::activityTextOptions());
473 $form->setDefaults(array('activity_option' => 'both'));
475 $priority = CRM_Core_PseudoConstant
::get('CRM_Activity_DAO_Activity', 'priority_id');
476 $form->addSelect('priority_id',
477 array('entity' => 'activity', 'label' => ts('Priority'), 'multiple' => 'multiple', 'option_url' => NULL, 'placeholder' => ts('- any -'))
480 $form->addYesNo('activity_test', ts('Activity is a Test?'));
481 $activity_tags = CRM_Core_BAO_Tag
::getTags('civicrm_activity');
482 if ($activity_tags) {
483 foreach ($activity_tags as $tagID => $tagName) {
484 $form->_tagElement
= &$form->addElement('checkbox', "activity_tags[$tagID]",
490 $parentNames = CRM_Core_BAO_Tag
::getTagSet('civicrm_activity');
491 CRM_Core_Form_Tag
::buildQuickForm($form, $parentNames, 'civicrm_activity', NULL, TRUE, TRUE);
493 $surveys = CRM_Campaign_BAO_Survey
::getSurveys(TRUE, FALSE, FALSE, TRUE);
495 $form->add('select', 'activity_survey_id', ts('Survey / Petition'),
496 array('' => ts('- none -')) +
$surveys, FALSE,
497 array('class' => 'crm-select2')
501 CRM_Core_BAO_Query
::addCustomFormFields($form, array('Activity'));
503 CRM_Campaign_BAO_Campaign
::addCampaignInComponentSearch($form, 'activity_campaign_id');
505 // Add engagement level CRM-7775.
506 $buildEngagementLevel = FALSE;
507 $buildSurveyResult = FALSE;
508 if (CRM_Campaign_BAO_Campaign
::isCampaignEnable() &&
509 CRM_Campaign_BAO_Campaign
::accessCampaign()
511 $buildEngagementLevel = TRUE;
512 $form->addSelect('activity_engagement_level', array('entity' => 'activity', 'context' => 'search'));
514 // Add survey result field.
515 $optionGroups = CRM_Campaign_BAO_Survey
::getResultSets('name');
516 $resultOptions = array();
517 foreach ($optionGroups as $gid => $name) {
519 $value = CRM_Core_OptionGroup
::values($name);
520 if (!empty($value)) {
521 foreach ($value as $k => $v) {
522 $resultOptions[$v] = $v;
527 // If no survey result options have been created, don't build
528 // the field to avoid clutter.
529 if (count($resultOptions) > 0) {
530 $buildSurveyResult = TRUE;
531 asort($resultOptions);
532 $form->add('select', 'activity_result', ts("Survey Result"),
533 $resultOptions, FALSE,
534 array('id' => 'activity_result', 'multiple' => 'multiple', 'class' => 'crm-select2')
539 $form->assign('buildEngagementLevel', $buildEngagementLevel);
540 $form->assign('buildSurveyResult', $buildSurveyResult);
541 $form->setDefaults(array('activity_test' => 0));
546 * @param bool $includeCustomFields
550 public static function defaultReturnProperties($mode, $includeCustomFields = TRUE) {
552 if ($mode & CRM_Contact_BAO_Query
::MODE_ACTIVITY
) {
556 'contact_sub_type' => 1,
559 'activity_type' => 1,
560 'activity_type_id' => 1,
561 'activity_subject' => 1,
562 'activity_date_time' => 1,
563 'activity_duration' => 1,
564 'activity_location' => 1,
565 'activity_details' => 1,
566 'activity_status' => 1,
567 'activity_priority' => 1,
568 'source_contact' => 1,
569 'source_record_id' => 1,
570 'activity_is_test' => 1,
571 'activity_campaign_id' => 1,
573 'activity_engagement_level' => 1,
577 if ($includeCustomFields) {
578 // also get all the custom activity properties
579 $fields = CRM_Core_BAO_CustomField
::getFieldsForImport('Activity');
580 if (!empty($fields)) {
581 foreach ($fields as $name => $dontCare) {
582 $properties[$name] = 1;
592 * Get the list of fields required to populate the selector.
594 * The default return properties array returns far too many fields for 'everyday use. Every field you add to this array
595 * kills a small kitten so add carefully.
597 public static function selectorReturnProperties() {
601 'contact_sub_type' => 1,
604 'activity_type_id' => 1,
605 'activity_subject' => 1,
606 'activity_date_time' => 1,
607 'activity_status_id' => 1,
608 'source_contact' => 1,
609 'source_record_id' => 1,
610 'activity_is_test' => 1,
611 'activity_campaign_id' => 1,
612 'activity_engagement_level' => 1,
621 * @param array $fields
622 * @param array $files
623 * @param CRM_Core_Form $form
627 public static function formRule($fields, $files, $form) {
630 if (empty($fields['activity_date_low']) ||
empty($fields['activity_date_high'])) {
634 CRM_Utils_Rule
::validDateRange($fields, 'activity_date', $errors, ts('Activity Date'));
636 return empty($errors) ?
TRUE : $errors;
640 * Where/qill clause for notes
642 * @param array $values
644 public static function whereClauseSingleActivityText(&$values, &$query) {
645 list($name, $op, $value, $grouping, $wildcard) = $values;
646 $activityOptionValues = $query->getWhereValues('activity_option', $grouping);
647 $activityOption = CRM_Utils_Array
::value(2, $activityOptionValues, 6);
649 $query->_useDistinct
= TRUE;
651 $label = ts('Activity Text (%1)', array(1 => CRM_Utils_Array
::value($activityOption, CRM_Core_SelectValues
::activityTextOptions())));
653 if ($activityOption %
2 == 0) {
654 $clauses[] = $query->buildClause('civicrm_activity.details', $op, $value, 'String');
656 if ($activityOption %
3 == 0) {
657 $clauses[] = $query->buildClause('civicrm_activity.subject', $op, $value, 'String');
660 $query->_where
[$grouping][] = "( " . implode(' OR ', $clauses) . " )";
661 list($qillOp, $qillVal) = $query->buildQillForFieldValue(NULL, $name, $value, $op);
662 $query->_qill
[$grouping][] = ts("%1 %2 '%3'", array(1 => $label, 2 => $qillOp, 3 => $qillVal));