4 * Include dataProvider for tests
7 class CRM_Member_BAO_QueryTest
extends CiviUnitTestCase
{
12 * Ensure CiviCase is enabled.
14 public function setUp() {
16 CRM_Core_BAO_ConfigSetting
::enableComponent('CiviCase');
20 * Check that membership type is handled.
22 * We want to see the following syntaxes for membership_type_id field handled:
23 * 1) membership_type_id => 1
25 public function testConvertEntityFieldSingleValue() {
26 $formValues = ['membership_type_id' => 2];
27 $params = CRM_Contact_BAO_Query
::convertFormValues($formValues, 0, FALSE, NULL, ['membership_type_id']);
28 $this->assertEquals(['membership_type_id', '=', 2, 0, 0], $params[0]);
29 $obj = new CRM_Contact_BAO_Query($params);
30 $this->assertEquals(['civicrm_membership.membership_type_id = 2'], $obj->_where
[0]);
34 * Check that membership type is handled.
36 * We want to see the following syntaxes for membership_type_id field handled:
37 * 2) membership_type_id => 5,6
39 * The last of these is the format used prior to converting membership_type_id to an entity reference field.
41 public function testConvertEntityFieldMultipleValueEntityRef() {
42 $formValues = ['membership_type_id' => '1,2'];
43 $params = CRM_Contact_BAO_Query
::convertFormValues($formValues, 0, FALSE, NULL, ['membership_type_id']);
44 $this->assertEquals(['membership_type_id', 'IN', [1, 2], 0, 0], $params[0]);
45 $obj = new CRM_Contact_BAO_Query($params);
46 $this->assertEquals(['civicrm_membership.membership_type_id IN ("1", "2")'], $obj->_where
[0]);
50 * Check that membership type is handled.
52 * We want to see the following syntaxes for membership_type_id field handled:
53 * 3) membership_type_id => array(5,6)
55 * The last of these is the format used prior to converting membership_type_id to an entity reference field. It will
56 * be used by pre-existing smart groups.
58 public function testConvertEntityFieldMultipleValueLegacy() {
59 $formValues = ['membership_type_id' => [1, 2]];
60 $params = CRM_Contact_BAO_Query
::convertFormValues($formValues, 0, FALSE, NULL, ['membership_type_id']);
61 $this->assertEquals(['membership_type_id', 'IN', [1, 2], 0, 0], $params[0]);
62 $obj = new CRM_Contact_BAO_Query($params);
63 $this->assertEquals(['civicrm_membership.membership_type_id IN ("1", "2")'], $obj->_where
[0]);
67 * Check that running convertFormValues more than one doesn't mangle the array.
69 * Unfortunately the convertFormValues & indeed much of the query code is run in pre-process AND post-process.
71 * The convertFormValues function should cope with this until such time as we can rationalise that.
73 public function testConvertEntityFieldMultipleValueEntityRefDoubleRun() {
74 $formValues = ['membership_type_id' => '1,2'];
75 $params = CRM_Contact_BAO_Query
::convertFormValues($formValues, 0, FALSE, NULL, ['membership_type_id']);
76 $this->assertEquals(['membership_type_id', 'IN', [1, 2], 0, 0], $params[0]);
77 $params = CRM_Contact_BAO_Query
::convertFormValues($params, 0, FALSE, NULL, ['membership_type_id']);
78 $this->assertEquals(['membership_type_id', 'IN', [1, 2], 0, 0], $params[0]);
79 $obj = new CRM_Contact_BAO_Query($params);
80 $this->assertEquals(['civicrm_membership.membership_type_id IN ("1", "2")'], $obj->_where
[0]);
84 * Membership Date fields
87 public function membershipDateFields() {
89 $fields[] = ['membership_join_date'];
90 $fields[] = ['membership_start_date'];
91 $fields[] = ['membership_end_date'];
96 * Test generating a correct where clause for date fields as generated by search builder
97 * @dataProvider membershipDateFields
99 public function testMembershipDateWhereSearchBuilder($dateField) {
100 $dbDateField = str_replace('membership_', '', $dateField);
103 1 => [['Membership', $dateField], [''], [''], [''], ['']],
104 2 => [[''], [''], [''], [''], ['']],
105 3 => [[''], [''], [''], [''], ['']],
108 1 => ['<=', '', '', '', ''],
109 2 => ['', '', '', '', ''],
110 3 => ['', '', '', '', ''],
113 1 => ['20200201', '', '', '', ''],
114 2 => ['', '', '', '', '', ''],
115 3 => ['', '', '', '', '', ''],
119 $searchBuilderForm = new CRM_Contact_Form_Search_Builder();
120 $params = [[$dateField, "<=", "20200201", 1, 0]];
121 $this->assertEquals($params, $searchBuilderForm->convertFormValues($formValues));
122 $obj = new CRM_Contact_BAO_Query($params);
123 $this->assertEquals(['civicrm_membership.' . $dbDateField . ' <= \'20200201000000\''], $obj->_where
[1]);