Merge pull request #17113 from colemanw/restoreApiSql
[civicrm-core.git] / CRM / Contact / Form / Search / Criteria.php
CommitLineData
6a488035
TO
1<?php
2/*
3 +--------------------------------------------------------------------+
bc77d7c0 4 | Copyright CiviCRM LLC. All rights reserved. |
6a488035 5 | |
bc77d7c0
TO
6 | This work is published under the GNU AGPLv3 license with some |
7 | permitted exceptions and without any warranty. For full license |
8 | and copyright information, see https://civicrm.org/licensing |
6a488035 9 +--------------------------------------------------------------------+
d25dd0ee 10 */
6a488035
TO
11
12/**
13 *
14 * @package CRM
ca5cec67 15 * @copyright CiviCRM LLC https://civicrm.org/licensing
6a488035
TO
16 */
17class CRM_Contact_Form_Search_Criteria {
69078420 18
8a4f27dc 19 /**
8c9caddc 20 * @param CRM_Contact_Form_Search_Advanced $form
21 *
22 * @throws \CRM_Core_Exception
bca2ad39 23 * @throws \CiviCRM_API3_Exception
8a4f27dc 24 */
00be9182 25 public static function basic(&$form) {
bca2ad39 26 $form->addSearchFieldMetadata(['Contact' => self::getFilteredSearchFieldMetadata('basic')]);
8c9caddc 27 $form->addFormFieldsFromMetadata();
a39762fd 28 self::setBasicSearchFields($form);
6a488035
TO
29 $form->addElement('hidden', 'hidden_basic', 1);
30
31 if ($form->_searchOptions['contactType']) {
46b3417a 32 $contactTypes = CRM_Contact_BAO_ContactType::getSelectElements();
6a488035
TO
33
34 if ($contactTypes) {
35 $form->add('select', 'contact_type', ts('Contact Type(s)'), $contactTypes, FALSE,
be2fb01f 36 ['id' => 'contact_type', 'multiple' => 'multiple', 'class' => 'crm-select2', 'style' => 'width: 100%;']
6a488035
TO
37 );
38 }
39 }
40
41 if ($form->_searchOptions['groups']) {
42 // multiselect for groups
43 if ($form->_group) {
44 // Arrange groups into hierarchical listing (child groups follow their parents and have indentation spacing in title)
f828fa2c 45 $groupHierarchy = CRM_Contact_BAO_Group::getGroupsHierarchy($form->_group, NULL, '&nbsp;&nbsp;', TRUE);
6a488035
TO
46
47 $form->add('select', 'group', ts('Groups'), $groupHierarchy, FALSE,
be2fb01f 48 ['id' => 'group', 'multiple' => 'multiple', 'class' => 'crm-select2']
6a488035
TO
49 );
50 $groupOptions = CRM_Core_BAO_OptionValue::getOptionValuesAssocArrayFromName('group_type');
51 $form->add('select', 'group_type', ts('Group Types'), $groupOptions, FALSE,
be2fb01f 52 ['id' => 'group_type', 'multiple' => 'multiple', 'class' => 'crm-select2']
6a488035 53 );
353ffa53 54 $form->add('hidden', 'group_search_selected', 'group');
6a488035
TO
55 }
56 }
57
58 if ($form->_searchOptions['tags']) {
59 // multiselect for categories
60 $contactTags = CRM_Core_BAO_Tag::getTags();
61
62 if ($contactTags) {
a39762fd 63 $form->add('select', 'contact_tags', ts('Select Tag(s)'), $contactTags, FALSE,
be2fb01f 64 ['id' => 'contact_tags', 'multiple' => 'multiple', 'class' => 'crm-select2', 'style' => 'width: 100%;']
6a488035
TO
65 );
66 }
67
68 $parentNames = CRM_Core_BAO_Tag::getTagSet('civicrm_contact');
4dff5e17 69 CRM_Core_Form_Tag::buildQuickForm($form, $parentNames, 'civicrm_contact', NULL, TRUE, FALSE);
f828fa2c 70
6a488035 71 $used_for = CRM_Core_OptionGroup::values('tag_used_for');
be2fb01f 72 $tagsTypes = [];
ab8a593e 73 $showAllTagTypes = FALSE;
6a488035
TO
74 foreach ($used_for as $key => $value) {
75 //check tags for every type and find if there are any defined
76 $tags = CRM_Core_BAO_Tag::getTagsUsedFor($key, FALSE, TRUE, NULL);
77 // check if there are tags other than contact type, if no - keep checkbox hidden on adv search
78 // we will hide searching contact by attachments tags until it will be implemented in core
79 if (count($tags) && $key != 'civicrm_file' && $key != 'civicrm_contact') {
80 //if tags exists then add type to display in adv search form help text
1836ab9e 81 $tagsTypes[] = $value;
4eeb9a5b 82 $showAllTagTypes = TRUE;
6a488035
TO
83 }
84 }
85 $tagTypesText = implode(" or ", $tagsTypes);
86 if ($showAllTagTypes) {
be2fb01f 87 $form->add('checkbox', 'all_tag_types', ts('Include tags used for %1', [1 => $tagTypesText]));
353ffa53 88 $form->add('hidden', 'tag_types_text', $tagTypesText);
6a488035
TO
89 }
90 }
91
6a488035
TO
92 //added contact source
93 $form->add('text', 'contact_source', ts('Contact Source'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'contact_source'));
94
95 //added job title
96 $form->addElement('text', 'job_title', ts('Job Title'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'job_title'));
97
6a488035 98 //added internal ID
be2fb01f 99 $form->add('number', 'contact_id', ts('Contact ID'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'id') + ['min' => 1]);
5a0739f2 100 $form->addRule('contact_id', ts('Please enter valid Contact ID'), 'positiveInteger');
6a488035
TO
101
102 //added external ID
103 $form->addElement('text', 'external_identifier', ts('External ID'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'external_identifier'));
104
89595c92 105 if (CRM_Core_Permission::check('access deleted contacts') and Civi::settings()->get('contact_undelete')) {
6a488035
TO
106 $form->add('checkbox', 'deleted_contacts', ts('Search in Trash') . '<br />' . ts('(deleted contacts)'));
107 }
108
109 // add checkbox for cms users only
8a4f27dc 110 $form->addYesNo('uf_user', ts('CMS User?'), TRUE);
6a488035
TO
111
112 // tag all search
113 $form->add('text', 'tag_search', ts('All Tags'));
114
115 // add search profiles
116
117 // FIXME: This is probably a part of profiles - need to be
118 // FIXME: eradicated from here when profiles are reworked.
be2fb01f 119 $types = ['Participant', 'Contribution', 'Membership'];
6a488035
TO
120
121 // get component profiles
be2fb01f 122 $componentProfiles = [];
6a488035
TO
123 $componentProfiles = CRM_Core_BAO_UFGroup::getProfiles($types);
124
125 $ufGroups = CRM_Core_BAO_UFGroup::getModuleUFGroup('Search Profile', 1);
126 $accessibleUfGroups = CRM_Core_Permission::ufGroup(CRM_Core_Permission::VIEW);
127
be2fb01f 128 $searchProfiles = [];
6a488035
TO
129 foreach ($ufGroups as $key => $var) {
130 if (!array_key_exists($key, $componentProfiles) && in_array($key, $accessibleUfGroups)) {
131 $searchProfiles[$key] = $var['title'];
132 }
133 }
134
3c0ec132 135 $form->add('select',
6a488035 136 'uf_group_id',
e2b3c0e3 137 ts('Views For Display Contacts'),
be2fb01f 138 [
317fceb4 139 '0' => ts('- default view -'),
be2fb01f 140 ] + $searchProfiles,
3c0ec132 141 FALSE,
be2fb01f 142 ['class' => 'crm-select2']
6a488035
TO
143 );
144
145 $componentModes = CRM_Contact_Form_Search::getModeSelect();
e30af20d 146 $form->assign('component_mappings', json_encode(CRM_Contact_Form_Search::getModeToComponentMapping()));
6a488035 147 if (count($componentModes) > 1) {
3c0ec132 148 $form->add('select',
6a488035
TO
149 'component_mode',
150 ts('Display Results As'),
3c0ec132 151 $componentModes,
ae1f4229 152 FALSE,
be2fb01f 153 ['class' => 'crm-select2']
6a488035
TO
154 );
155 }
156
3c0ec132 157 $form->addRadio(
6a488035
TO
158 'operator',
159 ts('Search Operator'),
be2fb01f 160 [
eda34f9b
MW
161 CRM_Contact_BAO_Query::SEARCH_OPERATOR_AND => ts('AND'),
162 CRM_Contact_BAO_Query::SEARCH_OPERATOR_OR => ts('OR'),
be2fb01f
CW
163 ],
164 ['allowClear' => FALSE]
6a488035
TO
165 );
166
167 // add the option to display relationships
168 $rTypes = CRM_Core_PseudoConstant::relationshipType();
be2fb01f 169 $rSelect = ['' => ts('- Select Relationship Type-')];
6a488035
TO
170 foreach ($rTypes as $rid => $rValue) {
171 if ($rValue['label_a_b'] == $rValue['label_b_a']) {
172 $rSelect[$rid] = $rValue['label_a_b'];
173 }
174 else {
175 $rSelect["{$rid}_a_b"] = $rValue['label_a_b'];
176 $rSelect["{$rid}_b_a"] = $rValue['label_b_a'];
177 }
178 }
179
180 $form->addElement('select',
181 'display_relationship_type',
182 ts('Display Results as Relationship'),
aae123ba 183 $rSelect,
be2fb01f 184 ['class' => 'crm-select2']
6a488035
TO
185 );
186
187 // checkboxes for DO NOT phone, email, mail
188 // we take labels from SelectValues
189 $t = CRM_Core_SelectValues::privacy();
190 $form->add('select',
191 'privacy_options',
192 ts('Privacy'),
193 $t,
194 FALSE,
be2fb01f 195 [
6a488035
TO
196 'id' => 'privacy_options',
197 'multiple' => 'multiple',
02ddf039 198 'class' => 'crm-select2',
be2fb01f 199 ]
6a488035
TO
200 );
201
202 $form->addElement('select',
203 'privacy_operator',
204 ts('Operator'),
be2fb01f 205 [
6ea503d4 206 'OR' => ts('OR'),
6a488035 207 'AND' => ts('AND'),
be2fb01f 208 ]
6a488035
TO
209 );
210
be2fb01f 211 $options = [
6a488035
TO
212 1 => ts('Exclude'),
213 2 => ts('Include by Privacy Option(s)'),
be2fb01f
CW
214 ];
215 $form->addRadio('privacy_toggle', ts('Privacy Options'), $options, ['allowClear' => FALSE]);
6a488035
TO
216
217 // preferred communication method
38056b36
AS
218 if (Civi::settings()->get('civimail_multiple_bulk_emails')) {
219 $form->addSelect('email_on_hold',
be2fb01f 220 ['entity' => 'email', 'multiple' => 'multiple', 'label' => ts('Email On Hold'), 'options' => CRM_Core_PseudoConstant::emailOnHoldOptions()]);
38056b36
AS
221 }
222 else {
223 $form->add('advcheckbox', 'email_on_hold', ts('Email On Hold'));
224 }
6a488035 225
7cc09daf 226 $form->addSelect('preferred_communication_method',
be2fb01f 227 ['entity' => 'contact', 'multiple' => 'multiple', 'label' => ts('Preferred Communication Method'), 'option_url' => NULL, 'placeholder' => ts('- any -')]);
6a488035
TO
228
229 //CRM-6138 Preferred Language
be2fb01f 230 $form->addSelect('preferred_language', ['class' => 'twenty', 'context' => 'search']);
6a488035
TO
231
232 // Phone search
d79be26c 233 $form->addElement('text', 'phone_numeric', ts('Phone'), CRM_Core_DAO::getAttribute('CRM_Core_DAO_Phone', 'phone'));
b2b0530a 234 $locationType = CRM_Core_PseudoConstant::get('CRM_Core_DAO_Address', 'location_type_id');
b4f964d9 235 $phoneType = CRM_Core_PseudoConstant::get('CRM_Core_DAO_Phone', 'phone_type_id');
be2fb01f
CW
236 $form->add('select', 'phone_location_type_id', ts('Phone Location'), ['' => ts('- any -')] + $locationType, FALSE, ['class' => 'crm-select2']);
237 $form->add('select', 'phone_phone_type_id', ts('Phone Type'), ['' => ts('- any -')] + $phoneType, FALSE, ['class' => 'crm-select2']);
6a488035
TO
238 }
239
8c9caddc 240 /**
241 * Get the metadata for fields to be included on the contact search form.
d7cc9ca9 242 *
243 * @throws \CiviCRM_API3_Exception
8c9caddc 244 */
245 public static function getSearchFieldMetadata() {
246 $fields = [
247 'sort_name' => ['title' => ts('Complete OR Partial Name'), 'template_grouping' => 'basic'],
d7cc9ca9 248 'email' => ['title' => ts('Complete OR Partial Email'), 'entity' => 'Email', 'template_grouping' => 'basic'],
249 'contact_tags' => ['name' => 'contact_tags', 'type' => CRM_Utils_Type::T_INT, 'is_pseudofield' => TRUE, 'template_grouping' => 'basic'],
80b5c9f1 250 'created_date' => ['name' => 'created_date', 'template_grouping' => 'changeLog'],
251 'modified_date' => ['name' => 'modified_date', 'template_grouping' => 'changeLog'],
bca2ad39 252 'birth_date' => ['name' => 'birth_date', 'template_grouping' => 'demographic'],
253 'deceased_date' => ['name' => 'deceased_date', 'template_grouping' => 'demographic'],
95c2e666 254 'is_deceased' => ['is_deceased', 'template_grouping' => 'demographic'],
41b8dd1d 255 'relationship_start_date' => ['name' => 'relationship_start_date', 'template_grouping' => 'relationship'],
256 'relationship_end_date' => ['name' => 'relationship_end_date', 'template_grouping' => 'relationship'],
7d8f464a 257 // PseudoRelationship date field.
258 'relation_active_period_date' => [
259 'name' => 'relation_active_period_date',
260 'type' => CRM_Utils_Type::T_DATE + CRM_Utils_Type::T_TIME,
261 'title' => ts('Active Period'),
262 'table_name' => 'civicrm_relationship',
263 'where' => 'civicrm_relationship.start_date',
264 'where_end' => 'civicrm_relationship.end_date',
265 'html' => ['type' => 'SelectDate', 'formatType' => 'activityDateTime'],
266 'template_grouping' => 'relationship',
267 ],
8c9caddc 268 ];
7d8f464a 269
41b8dd1d 270 $metadata = civicrm_api3('Relationship', 'getfields', [])['values'];
271 $metadata = array_merge($metadata, civicrm_api3('Contact', 'getfields', [])['values']);
8c9caddc 272 foreach ($fields as $fieldName => $field) {
273 $fields[$fieldName] = array_merge(CRM_Utils_Array::value($fieldName, $metadata, []), $field);
274 }
275 return $fields;
276 }
277
bca2ad39 278 /**
279 * Get search field metadata filtered by the template grouping field.
280 *
281 * @param string $filter
282 *
283 * @return array
284 * @throws \CiviCRM_API3_Exception
285 */
286 public static function getFilteredSearchFieldMetadata($filter) {
287 $fields = self::getSearchFieldMetadata();
288 foreach ($fields as $index => $field) {
289 if ($field['template_grouping'] !== $filter) {
290 unset($fields[$index]);
291 }
292 }
293 return $fields;
294 }
295
a39762fd
MD
296 /**
297 * Defines the fields that can be displayed for the basic search section.
298 *
299 * @param CRM_Core_Form $form
bca2ad39 300 *
301 * @throws \CiviCRM_API3_Exception
a39762fd
MD
302 */
303 protected static function setBasicSearchFields($form) {
4b7b1909 304 $searchFields = [];
bca2ad39 305 foreach (self::getFilteredSearchFieldMetadata('basic') as $fieldName => $field) {
306 $searchFields[$fieldName] = $field;
4b7b1909 307 }
308 $form->assign('basicSearchFields', array_merge(self::getBasicSearchFields(), $searchFields));
723e3e6b 309 }
a39762fd 310
723e3e6b 311 /**
312 * Return list of basic contact fields that can be displayed for the basic search section.
313 *
314 */
315 public static function getBasicSearchFields() {
316 $userFramework = CRM_Core_Config::singleton()->userFramework;
317 return [
f73329c4 318 // For now an empty array is still left in place for ordering.
319 'sort_name' => [],
a39762fd
MD
320 'email' => ['name' => 'email'],
321 'contact_type' => ['name' => 'contact_type'],
322 'group' => [
323 'name' => 'group',
324 'template' => 'CRM/Contact/Form/Search/Criteria/Fields/group.tpl',
325 ],
326 'contact_tags' => ['name' => 'contact_tags'],
327 'tag_types_text' => ['name' => 'tag_types_text'],
328 'tag_search' => [
329 'name' => 'tag_search',
330 'help' => ['id' => 'id-all-tags'],
331 ],
332 'tag_set' => [
333 'name' => 'tag_set',
334 'is_custom' => TRUE,
335 'template' => 'CRM/Contact/Form/Search/Criteria/Fields/tag_set.tpl',
336 ],
337 'all_tag_types' => [
338 'name' => 'all_tag_types',
339 'class' => 'search-field__span-3 search-field__checkbox',
69078420 340 'help' => ['id' => 'id-all-tag-types'],
a39762fd
MD
341 ],
342 'phone_numeric' => [
343 'name' => 'phone_numeric',
344 'description' => ts('Punctuation and spaces are ignored.'),
345 ],
346 'phone_location_type_id' => ['name' => 'phone_location_type_id'],
347 'phone_phone_type_id' => ['name' => 'phone_phone_type_id'],
348 'privacy_toggle' => [
349 'name' => 'privacy_toggle',
350 'class' => 'search-field__span-2',
351 'template' => 'CRM/Contact/Form/Search/Criteria/Fields/privacy_toggle.tpl',
352 ],
353 'preferred_communication_method' => [
354 'name' => 'preferred_communication_method',
355 'template' => 'CRM/Contact/Form/Search/Criteria/Fields/preferred_communication_method.tpl',
356 ],
357 'contact_source' => [
358 'name' => 'contact_source',
359 'help' => ['id' => 'id-source', 'file' => 'CRM/Contact/Form/Contact'],
360 ],
361 'job_title' => ['name' => 'job_title'],
362 'preferred_language' => ['name' => 'preferred_language'],
363 'contact_id' => [
364 'name' => 'contact_id',
365 'help' => ['id' => 'id-contact-id', 'file' => 'CRM/Contact/Form/Contact'],
366 ],
367 'external_identifier' => [
368 'name' => 'external_identifier',
369 'help' => ['id' => 'id-external-id', 'file' => 'CRM/Contact/Form/Contact'],
370 ],
371 'uf_user' => [
372 'name' => 'uf_user',
373 'description' => ts('Does the contact have a %1 Account?', [$userFramework]),
374 ],
723e3e6b 375 ];
a39762fd
MD
376 }
377
86538308 378 /**
12fbb7b3 379 * @param CRM_Core_Form $form
86538308 380 */
00be9182 381 public static function location(&$form) {
12fbb7b3 382 $config = CRM_Core_Config::singleton();
6a488035
TO
383 // Build location criteria based on _submitValues if
384 // available; otherwise, use $form->_formValues.
385 $formValues = $form->_submitValues;
386
387 if (empty($formValues) && !empty($form->_formValues)) {
388 $formValues = $form->_formValues;
389 }
390
391 $form->addElement('hidden', 'hidden_location', 1);
392
393 $addressOptions = CRM_Core_BAO_Setting::valueOptions(CRM_Core_BAO_Setting::SYSTEM_PREFERENCES_NAME,
394 'address_options', TRUE, NULL, TRUE
395 );
396
397 $attributes = CRM_Core_DAO::getAttribute('CRM_Core_DAO_Address');
398
be2fb01f
CW
399 $elements = [
400 'street_address' => [ts('Street Address'), $attributes['street_address'], NULL, NULL],
401 'supplemental_address_1' => [ts('Supplemental Address 1'), $attributes['supplemental_address_1'], NULL, NULL],
402 'supplemental_address_2' => [ts('Supplemental Address 2'), $attributes['supplemental_address_2'], NULL, NULL],
403 'supplemental_address_3' => [ts('Supplemental Address 3'), $attributes['supplemental_address_3'], NULL, NULL],
404 'city' => [ts('City'), $attributes['city'], NULL, NULL],
405 'postal_code' => [ts('Postal Code'), $attributes['postal_code'], NULL, NULL],
406 'country' => [ts('Country'), $attributes['country_id'], 'country', FALSE],
407 'state_province' => [ts('State/Province'), $attributes['state_province_id'], 'stateProvince', TRUE],
408 'county' => [ts('County'), $attributes['county_id'], 'county', TRUE],
409 'address_name' => [ts('Address Name'), $attributes['address_name'], NULL, NULL],
410 'street_number' => [ts('Street Number'), $attributes['street_number'], NULL, NULL],
411 'street_name' => [ts('Street Name'), $attributes['street_name'], NULL, NULL],
412 'street_unit' => [ts('Apt/Unit/Suite'), $attributes['street_unit'], NULL, NULL],
413 ];
6a488035 414
2975f0aa 415 $parseStreetAddress = $addressOptions['street_address_parsing'] ?? 0;
6a488035
TO
416 $form->assign('parseStreetAddress', $parseStreetAddress);
417 foreach ($elements as $name => $v) {
418 list($title, $attributes, $select, $multiSelect) = $v;
419
420 if (in_array($name,
be2fb01f 421 ['street_number', 'street_name', 'street_unit']
353ffa53 422 )) {
6a488035
TO
423 if (!$parseStreetAddress) {
424 continue;
425 }
426 }
427 elseif (!$addressOptions[$name]) {
428 continue;
429 }
430
431 if (!$attributes) {
432 $attributes = $attributes[$name];
433 }
434
435 if ($select) {
c927c151
CW
436 if ($select == 'stateProvince' || $select == 'county') {
437 $element = $form->addChainSelect($name);
6a488035
TO
438 }
439 else {
be2fb01f
CW
440 $selectElements = ['' => ts('- any -')] + CRM_Core_PseudoConstant::$select();
441 $element = $form->add('select', $name, $title, $selectElements, FALSE, ['class' => 'crm-select2']);
6a488035
TO
442 }
443 if ($multiSelect) {
444 $element->setMultiple(TRUE);
445 }
446 }
447 else {
448 $form->addElement('text', $name, $title, $attributes);
449 }
450
451 if ($addressOptions['postal_code']) {
be2fb01f
CW
452 $attr = ['class' => 'six'] + (array) CRM_Utils_Array::value('postal_code', $attributes);
453 $form->addElement('text', 'postal_code_low', NULL, $attr + ['placeholder' => ts('From')]);
454 $form->addElement('text', 'postal_code_high', NULL, $attr + ['placeholder' => ts('To')]);
6a488035
TO
455 }
456 }
457
458 // extend addresses with proximity search
4882d275 459 if (CRM_Utils_GeocodeProvider::getUsableClassName()) {
be2fb01f
CW
460 $form->addElement('text', 'prox_distance', ts('Find contacts within'), ['class' => 'six']);
461 $form->addElement('select', 'prox_distance_unit', NULL, [
12fbb7b3 462 'miles' => ts('Miles'),
21dfd5f5 463 'kilos' => ts('Kilometers'),
be2fb01f 464 ]);
12fbb7b3
CW
465 $form->addRule('prox_distance', ts('Please enter positive number as a distance'), 'numeric');
466 }
6a488035 467
be2fb01f 468 $form->addSelect('world_region', ['entity' => 'address', 'context' => 'search']);
6a488035 469
d8a8bb0b 470 // select for location type
b2b0530a 471 $locationType = CRM_Core_PseudoConstant::get('CRM_Core_DAO_Address', 'location_type_id');
be2fb01f 472 $form->add('select', 'location_type', ts('Address Location'), $locationType, FALSE, [
d8a8bb0b
CW
473 'multiple' => TRUE,
474 'class' => 'crm-select2',
475 'placeholder' => ts('Primary'),
be2fb01f 476 ]);
6a488035 477
86a0d21e 478 // custom data extending addresses
be2fb01f 479 CRM_Core_BAO_Query::addCustomFormFields($form, ['Address']);
6a488035
TO
480 }
481
86538308 482 /**
c490a46a 483 * @param CRM_Core_Form $form
86538308 484 */
00be9182 485 public static function activity(&$form) {
6a488035
TO
486 $form->add('hidden', 'hidden_activity', 1);
487 CRM_Activity_BAO_Query::buildSearchForm($form);
488 }
489
86538308 490 /**
c490a46a 491 * @param CRM_Core_Form $form
80b5c9f1 492 *
493 * @throws \CiviCRM_API3_Exception
86538308 494 */
00be9182 495 public static function changeLog(&$form) {
6a488035 496 $form->add('hidden', 'hidden_changeLog', 1);
80b5c9f1 497 $form->addSearchFieldMetadata(['Contact' => self::getFilteredSearchFieldMetadata('changeLog')]);
498 $form->addFormFieldsFromMetadata();
6a488035
TO
499 // block for change log
500 $form->addElement('text', 'changed_by', ts('Modified By'), NULL);
6a488035
TO
501 }
502
86538308 503 /**
c490a46a 504 * @param CRM_Core_Form $form
86538308 505 */
00be9182 506 public static function task(&$form) {
6a488035
TO
507 $form->add('hidden', 'hidden_task', 1);
508 }
509
86538308 510 /**
6e83b317 511 * @param CRM_Core_Form_Search $form
41b8dd1d 512 *
513 * @throws \CiviCRM_API3_Exception
86538308 514 */
00be9182 515 public static function relationship(&$form) {
6a488035 516 $form->add('hidden', 'hidden_relationship', 1);
41b8dd1d 517 $form->addSearchFieldMetadata(['Relationship' => self::getFilteredSearchFieldMetadata('relationship')]);
518 $form->addFormFieldsFromMetadata();
6e83b317 519 $form->add('text', 'relation_description', ts('Description'), ['class' => 'twenty']);
6a488035 520 $allRelationshipType = CRM_Contact_BAO_Relationship::getContactRelationshipType(NULL, NULL, NULL, NULL, TRUE);
be2fb01f 521 $form->add('select', 'relation_type_id', ts('Relationship Type'), ['' => ts('- select -')] + $allRelationshipType, FALSE, ['multiple' => TRUE, 'class' => 'crm-select2']);
6a488035 522 $form->addElement('text', 'relation_target_name', ts('Target Contact'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'sort_name'));
5ea73a9f 523 // relation status
be2fb01f 524 $relStatusOption = [ts('Active'), ts('Inactive'), ts('All')];
6a488035 525 $form->addRadio('relation_status', ts('Relationship Status'), $relStatusOption);
be2fb01f 526 $form->setDefaults(['relation_status' => 0]);
5ea73a9f 527 // relation permission
f871c3a9
AS
528 $allRelationshipPermissions = CRM_Contact_BAO_Relationship::buildOptions('is_permission_a_b');
529 $form->add('select', 'relation_permission', ts('Permissioned Relationship'),
be2fb01f 530 ['' => ts('- select -')] + $allRelationshipPermissions, FALSE, ['multiple' => TRUE, 'class' => 'crm-select2']);
6a488035
TO
531
532 //add the target group
533 if ($form->_group) {
534 $form->add('select', 'relation_target_group', ts('Target Contact(s) in Group'), $form->_group, FALSE,
be2fb01f 535 ['id' => 'relation_target_group', 'multiple' => 'multiple', 'class' => 'crm-select2']
6a488035
TO
536 );
537 }
eea5db81 538
6a488035 539 // add all the custom searchable fields
be2fb01f 540 CRM_Core_BAO_Query::addCustomFormFields($form, ['Relationship']);
6a488035
TO
541 }
542
86538308 543 /**
ac241c34 544 * @param CRM_Core_Form_Search $form
bca2ad39 545 *
546 * @throws \CiviCRM_API3_Exception
86538308 547 */
00be9182 548 public static function demographics(&$form) {
6a488035 549 $form->add('hidden', 'hidden_demographics', 1);
bca2ad39 550 $form->addSearchFieldMetadata(['Contact' => self::getFilteredSearchFieldMetadata('demographic')]);
551 $form->addFormFieldsFromMetadata();
6a488035 552 // radio button for gender
be2fb01f 553 $genderOptions = [];
26cf88b5 554 $gender = CRM_Core_PseudoConstant::get('CRM_Contact_DAO_Contact', 'gender_id');
6a488035
TO
555 foreach ($gender as $key => $var) {
556 $genderOptions[$key] = $form->createElement('radio', NULL,
557 ts('Gender'), $var, $key,
be2fb01f 558 ['id' => "civicrm_gender_{$var}_{$key}"]
6a488035
TO
559 );
560 }
b847e6e7 561 $form->addGroup($genderOptions, 'gender_id', ts('Gender'))->setAttribute('allowClear', TRUE);
6a488035 562
ac241c34 563 $form->add('number', 'age_low', ts('Min Age'), ['class' => 'four', 'min' => 0]);
c4a7c967 564 $form->addRule('age_low', ts('Please enter a positive integer'), 'positiveInteger');
ac241c34 565 $form->add('number', 'age_high', ts('Max Age'), ['class' => 'four', 'min' => 0]);
c4a7c967 566 $form->addRule('age_high', ts('Please enter a positive integer'), 'positiveInteger');
ac241c34 567 $form->add('datepicker', 'age_asof_date', ts('As of'), NULL, FALSE, ['time' => FALSE]);
6a488035
TO
568 }
569
86538308
EM
570 /**
571 * @param $form
572 */
00be9182 573 public static function notes(&$form) {
6a488035
TO
574 $form->add('hidden', 'hidden_notes', 1);
575
be2fb01f 576 $options = [
6a488035
TO
577 2 => ts('Body Only'),
578 3 => ts('Subject Only'),
579 6 => ts('Both'),
be2fb01f 580 ];
6a488035
TO
581 $form->addRadio('note_option', '', $options);
582
583 $form->addElement('text', 'note', ts('Note Text'), CRM_Core_DAO::getAttribute('CRM_Contact_DAO_Contact', 'sort_name'));
584
be2fb01f 585 $form->setDefaults(['note_option' => 6]);
6a488035
TO
586 }
587
588 /**
5a409b50 589 * Generate the custom Data Fields based for those with is_searchable = 1.
6a488035 590 *
5a409b50 591 * @param CRM_Contact_Form_Search $form
e2ce074e 592 *
593 * @throws \CiviCRM_API3_Exception
6a488035 594 */
00be9182 595 public static function custom(&$form) {
6a488035 596 $form->add('hidden', 'hidden_custom', 1);
be2fb01f 597 $extends = array_merge(['Contact', 'Individual', 'Household', 'Organization'],
6a488035
TO
598 CRM_Contact_BAO_ContactType::subTypes()
599 );
600 $groupDetails = CRM_Core_BAO_CustomGroup::getGroupDetail(NULL, TRUE,
601 $extends
602 );
603
604 $form->assign('groupTree', $groupDetails);
605
606 foreach ($groupDetails as $key => $group) {
607 $_groupTitle[$key] = $group['name'];
608 CRM_Core_ShowHideBlocks::links($form, $group['name'], '', '');
609
6a488035
TO
610 foreach ($group['fields'] as $field) {
611 $fieldId = $field['id'];
612 $elementName = 'custom_' . $fieldId;
e2ce074e 613 if ($field['data_type'] === 'Date' && $field['is_search_range']) {
614 $form->addDatePickerRange($elementName, $field['label']);
0b77ccc2
CW
615 }
616 else {
617 CRM_Core_BAO_CustomField::addQuickFormElement($form, $elementName, $fieldId, FALSE, TRUE);
618 }
6a488035
TO
619 }
620 }
6a488035
TO
621 }
622
86538308
EM
623 /**
624 * @param $form
625 */
00be9182 626 public static function CiviCase(&$form) {
6a488035
TO
627 //Looks like obsolete code, since CiviCase is a component, but might be used by HRD
628 $form->add('hidden', 'hidden_CiviCase', 1);
629 CRM_Case_BAO_Query::buildSearchForm($form);
630 }
96025800 631
6a488035 632}