Commit | Line | Data |
---|---|---|
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 | * $Id$ |
17 | * | |
18 | */ | |
19 | ||
20 | /** | |
21 | * The CiviCRM duplicate discovery engine is based on an | |
22 | * algorithm designed by David Strauss <david@fourkitchens.com>. | |
23 | */ | |
24 | class CRM_Dedupe_BAO_RuleGroup extends CRM_Dedupe_DAO_RuleGroup { | |
25 | ||
26 | /** | |
100fef9d | 27 | * Ids of the contacts to limit the SQL queries (whole-database queries otherwise) |
518fa0ee | 28 | * @var array |
6a488035 | 29 | */ |
518fa0ee | 30 | public $contactIds = []; |
6a488035 | 31 | |
4c8b4719 | 32 | /** |
33 | * Set the contact IDs to restrict the dedupe to. | |
34 | * | |
35 | * @param array $contactIds | |
36 | */ | |
37 | public function setContactIds($contactIds) { | |
38 | $this->contactIds = $contactIds; | |
39 | } | |
40 | ||
6a488035 | 41 | /** |
100fef9d | 42 | * Params to dedupe against (queries against the whole contact set otherwise) |
518fa0ee | 43 | * @var array |
6a488035 | 44 | */ |
518fa0ee | 45 | public $params = []; |
6a488035 TO |
46 | |
47 | /** | |
fe482240 | 48 | * If there are no rules in rule group. |
518fa0ee | 49 | * @var bool |
6a488035 | 50 | */ |
518fa0ee | 51 | public $noRules = FALSE; |
6a488035 | 52 | |
887c0ec2 | 53 | protected $temporaryTables = []; |
54 | ||
6a488035 TO |
55 | /** |
56 | * Return a structure holding the supported tables, fields and their titles | |
57 | * | |
98997235 TO |
58 | * @param string $requestedType |
59 | * The requested contact type. | |
6a488035 | 60 | * |
a6c01b45 CW |
61 | * @return array |
62 | * a table-keyed array of field-keyed arrays holding supported fields' titles | |
6a488035 | 63 | */ |
49cb3722 | 64 | public static function supportedFields($requestedType) { |
6a488035 TO |
65 | static $fields = NULL; |
66 | if (!$fields) { | |
67 | // this is needed, as we're piggy-backing importableFields() below | |
be2fb01f | 68 | $replacements = [ |
6a488035 TO |
69 | 'civicrm_country.name' => 'civicrm_address.country_id', |
70 | 'civicrm_county.name' => 'civicrm_address.county_id', | |
71 | 'civicrm_state_province.name' => 'civicrm_address.state_province_id', | |
72 | 'gender.label' => 'civicrm_contact.gender_id', | |
73 | 'individual_prefix.label' => 'civicrm_contact.prefix_id', | |
74 | 'individual_suffix.label' => 'civicrm_contact.suffix_id', | |
75 | 'addressee.label' => 'civicrm_contact.addressee_id', | |
76 | 'email_greeting.label' => 'civicrm_contact.email_greeting_id', | |
77 | 'postal_greeting.label' => 'civicrm_contact.postal_greeting_id', | |
698095e2 | 78 | 'civicrm_phone.phone' => 'civicrm_phone.phone_numeric', |
be2fb01f | 79 | ]; |
6a488035 | 80 | // the table names we support in dedupe rules - a filter for importableFields() |
be2fb01f | 81 | $supportedTables = [ |
353ffa53 TO |
82 | 'civicrm_address', |
83 | 'civicrm_contact', | |
84 | 'civicrm_email', | |
85 | 'civicrm_im', | |
86 | 'civicrm_note', | |
87 | 'civicrm_openid', | |
88 | 'civicrm_phone', | |
be2fb01f | 89 | ]; |
6a488035 | 90 | |
be2fb01f | 91 | foreach (['Individual', 'Organization', 'Household'] as $ctype) { |
6a488035 TO |
92 | // take the table.field pairs and their titles from importableFields() if the table is supported |
93 | foreach (CRM_Contact_BAO_Contact::importableFields($ctype) as $iField) { | |
94 | if (isset($iField['where'])) { | |
95 | $where = $iField['where']; | |
96 | if (isset($replacements[$where])) { | |
97 | $where = $replacements[$where]; | |
98 | } | |
99 | list($table, $field) = explode('.', $where); | |
100 | if (!in_array($table, $supportedTables)) { | |
101 | continue; | |
102 | } | |
103 | $fields[$ctype][$table][$field] = $iField['title']; | |
104 | } | |
105 | } | |
49cb3722 | 106 | // Note that most of the fields available come from 'importable fields' - |
107 | // I thought about making this field 'importable' but it felt like there might be unknown consequences | |
108 | // so I opted for just adding it in & securing it with a unit test. | |
1dba397e | 109 | /// Example usage of sort_name - It is possible to alter sort name via hook so 2 organization names might differ as in |
49cb3722 | 110 | // Justice League vs The Justice League but these could have the same sort_name if 'the the' |
111 | // exension is installed (https://github.com/eileenmcnaughton/org.wikimedia.thethe) | |
112 | $fields[$ctype]['civicrm_contact']['sort_name'] = ts('Sort Name'); | |
6a488035 | 113 | // add custom data fields |
0b330e6d | 114 | foreach (CRM_Core_BAO_CustomGroup::getTree($ctype, NULL, NULL, -1) as $key => $cg) { |
6a488035 TO |
115 | if (!is_int($key)) { |
116 | continue; | |
117 | } | |
118 | foreach ($cg['fields'] as $cf) { | |
119 | $fields[$ctype][$cg['table_name']][$cf['column_name']] = $cf['label']; | |
120 | } | |
121 | } | |
122 | } | |
123 | } | |
1cf05c3e | 124 | CRM_Utils_Hook::dupeQuery(CRM_Core_DAO::$_nullObject, 'supportedFields', $fields); |
49cb3722 | 125 | return !empty($fields[$requestedType]) ? $fields[$requestedType] : []; |
6a488035 TO |
126 | } |
127 | ||
128 | /** | |
129 | * Return the SQL query for dropping the temporary table. | |
130 | */ | |
00be9182 | 131 | public function tableDropQuery() { |
6a488035 TO |
132 | return 'DROP TEMPORARY TABLE IF EXISTS dedupe'; |
133 | } | |
134 | ||
135 | /** | |
136 | * Return a set of SQL queries whose cummulative weights will mark matched | |
137 | * records for the RuleGroup::threasholdQuery() to retrieve. | |
138 | */ | |
00be9182 | 139 | public function tableQuery() { |
6a488035 TO |
140 | // make sure we've got a fetched dbrecord, not sure if this is enforced |
141 | if (!$this->name == NULL || $this->is_reserved == NULL) { | |
142 | $this->find(TRUE); | |
143 | } | |
144 | ||
145 | // Reserved Rule Groups can optionally get special treatment by | |
146 | // implementing an optimization class and returning a query array. | |
147 | if ($this->is_reserved && | |
148 | CRM_Utils_File::isIncludable("CRM/Dedupe/BAO/QueryBuilder/{$this->name}.php") | |
149 | ) { | |
6a488035 | 150 | $command = empty($this->params) ? 'internal' : 'record'; |
be2fb01f | 151 | $queries = call_user_func(["CRM_Dedupe_BAO_QueryBuilder_{$this->name}", $command], $this); |
6a488035 TO |
152 | } |
153 | else { | |
154 | // All other rule groups have queries generated by the member dedupe | |
155 | // rules defined in the administrative interface. | |
156 | ||
157 | // Find all rules contained by this script sorted by weight so that | |
158 | // their execution can be short circuited on RuleGroup::fillTable() | |
159 | $bao = new CRM_Dedupe_BAO_Rule(); | |
160 | $bao->dedupe_rule_group_id = $this->id; | |
161 | $bao->orderBy('rule_weight DESC'); | |
162 | $bao->find(); | |
163 | ||
164 | // Generate a SQL query for each rule in the rule group that is | |
165 | // tailored to respect the param and contactId options provided. | |
be2fb01f | 166 | $queries = []; |
6a488035 TO |
167 | while ($bao->fetch()) { |
168 | $bao->contactIds = $this->contactIds; | |
169 | $bao->params = $this->params; | |
170 | ||
171 | // Skipping empty rules? Empty rules shouldn't exist; why check? | |
172 | if ($query = $bao->sql()) { | |
173 | $queries["{$bao->rule_table}.{$bao->rule_field}.{$bao->rule_weight}"] = $query; | |
174 | } | |
175 | } | |
176 | } | |
177 | ||
178 | // if there are no rules in this rule group | |
179 | // add an empty query fulfilling the pattern | |
180 | if (!$queries) { | |
6a488035 | 181 | $this->noRules = TRUE; |
be2fb01f | 182 | return []; |
6a488035 TO |
183 | } |
184 | ||
185 | return $queries; | |
186 | } | |
187 | ||
00be9182 | 188 | public function fillTable() { |
6a488035 TO |
189 | // get the list of queries handy |
190 | $tableQueries = $this->tableQuery(); | |
191 | ||
192 | if ($this->params && !$this->noRules) { | |
887c0ec2 | 193 | $this->temporaryTables['dedupe'] = CRM_Utils_SQL_TempTable::build() |
194 | ->setCategory('dedupe') | |
195 | ->createWithColumns("id1 int, weight int, UNIQUE UI_id1 (id1)")->getName(); | |
1dba397e SL |
196 | $dedupeCopyTemporaryTableObject = CRM_Utils_SQL_TempTable::build() |
197 | ->setCategory('dedupe'); | |
198 | $this->temporaryTables['dedupe_copy'] = $dedupeCopyTemporaryTableObject->getName(); | |
887c0ec2 | 199 | $insertClause = "INSERT INTO {$this->temporaryTables['dedupe']} (id1, weight)"; |
3dc13e46 | 200 | $groupByClause = "GROUP BY id1, weight"; |
1dba397e | 201 | $dupeCopyJoin = " JOIN {$this->temporaryTables['dedupe_copy']} ON {$this->temporaryTables['dedupe_copy']}.id1 = t1.column WHERE "; |
6a488035 TO |
202 | } |
203 | else { | |
887c0ec2 | 204 | $this->temporaryTables['dedupe'] = CRM_Utils_SQL_TempTable::build() |
205 | ->setCategory('dedupe') | |
206 | ->createWithColumns("id1 int, id2 int, weight int, UNIQUE UI_id1_id2 (id1, id2)")->getName(); | |
1dba397e SL |
207 | $dedupeCopyTemporaryTableObject = CRM_Utils_SQL_TempTable::build() |
208 | ->setCategory('dedupe'); | |
209 | $this->temporaryTables['dedupe_copy'] = $dedupeCopyTemporaryTableObject->getName(); | |
887c0ec2 | 210 | $insertClause = "INSERT INTO {$this->temporaryTables['dedupe']} (id1, id2, weight)"; |
3dc13e46 | 211 | $groupByClause = "GROUP BY id1, id2, weight"; |
1dba397e | 212 | $dupeCopyJoin = " JOIN {$this->temporaryTables['dedupe_copy']} ON {$this->temporaryTables['dedupe_copy']}.id1 = t1.column AND {$this->temporaryTables['dedupe_copy']}.id2 = t2.column WHERE "; |
6a488035 TO |
213 | } |
214 | $patternColumn = '/t1.(\w+)/'; | |
be2fb01f | 215 | $exclWeightSum = []; |
6a488035 | 216 | |
6a488035 | 217 | $dao = new CRM_Core_DAO(); |
6a488035 TO |
218 | CRM_Utils_Hook::dupeQuery($this, 'table', $tableQueries); |
219 | ||
220 | while (!empty($tableQueries)) { | |
221 | list($isInclusive, $isDie) = self::isQuerySetInclusive($tableQueries, $this->threshold, $exclWeightSum); | |
222 | ||
223 | if ($isInclusive) { | |
224 | // order queries by table count | |
225 | self::orderByTableCount($tableQueries); | |
226 | ||
227 | $weightSum = array_sum($exclWeightSum); | |
228 | $searchWithinDupes = !empty($exclWeightSum) ? 1 : 0; | |
229 | ||
230 | while (!empty($tableQueries)) { | |
231 | // extract the next query ( and weight ) to be executed | |
232 | $fieldWeight = array_keys($tableQueries); | |
233 | $fieldWeight = $fieldWeight[0]; | |
353ffa53 | 234 | $query = array_shift($tableQueries); |
6a488035 TO |
235 | |
236 | if ($searchWithinDupes) { | |
9742d8f3 SL |
237 | // drop dedupe_copy table just in case if its already there. |
238 | $dedupeCopyTemporaryTableObject->drop(); | |
6a488035 | 239 | // get prepared to search within already found dupes if $searchWithinDupes flag is set |
1dba397e | 240 | $dedupeCopyTemporaryTableObject->createWithQuery("SELECT * FROM {$this->temporaryTables['dedupe']} WHERE weight >= {$weightSum}"); |
6a488035 TO |
241 | |
242 | preg_match($patternColumn, $query, $matches); | |
243 | $query = str_replace(' WHERE ', str_replace('column', $matches[1], $dupeCopyJoin), $query); | |
0226a9f3 AH |
244 | |
245 | // CRM-19612: If there's a union, there will be two WHEREs, and you | |
246 | // can't use the temp table twice. | |
1dba397e | 247 | if (preg_match('/' . $this->temporaryTables['dedupe_copy'] . '[\S\s]*(union)[\S\s]*' . $this->temporaryTables['dedupe_copy'] . '/i', $query, $matches, PREG_OFFSET_CAPTURE)) { |
0226a9f3 | 248 | // Make a second temp table: |
1dba397e SL |
249 | $this->temporaryTables['dedupe_copy_2'] = CRM_Utils_SQL_TempTable::build() |
250 | ->setCategory('dedupe') | |
251 | ->createWithQuery("SELECT * FROM {$this->temporaryTables['dedupe']} WHERE weight >= {$weightSum}") | |
252 | ->getName(); | |
0226a9f3 AH |
253 | // After the union, use that new temp table: |
254 | $part1 = substr($query, 0, $matches[1][1]); | |
1dba397e | 255 | $query = $part1 . str_replace($this->temporaryTables['dedupe_copy'], $this->temporaryTables['dedupe_copy_2'], substr($query, $matches[1][1])); |
0226a9f3 | 256 | } |
6a488035 TO |
257 | } |
258 | $searchWithinDupes = 1; | |
259 | ||
260 | // construct and execute the intermediate query | |
261 | $query = "{$insertClause} {$query} {$groupByClause} ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)"; | |
262 | $dao->query($query); | |
263 | ||
264 | // FIXME: we need to be more acurate with affected rows, especially for insert vs duplicate insert. | |
265 | // And that will help optimize further. | |
266 | $affectedRows = $dao->affectedRows(); | |
6a488035 TO |
267 | |
268 | // In an inclusive situation, failure of any query means no further processing - | |
269 | if ($affectedRows == 0) { | |
270 | // reset to make sure no further execution is done. | |
be2fb01f | 271 | $tableQueries = []; |
6a488035 TO |
272 | break; |
273 | } | |
274 | $weightSum = substr($fieldWeight, strrpos($fieldWeight, '.') + 1) + $weightSum; | |
275 | } | |
276 | // An exclusive situation - | |
277 | } | |
278 | elseif (!$isDie) { | |
279 | // since queries are already sorted by weights, we can continue as is | |
280 | $fieldWeight = array_keys($tableQueries); | |
281 | $fieldWeight = $fieldWeight[0]; | |
353ffa53 TO |
282 | $query = array_shift($tableQueries); |
283 | $query = "{$insertClause} {$query} {$groupByClause} ON DUPLICATE KEY UPDATE weight = weight + VALUES(weight)"; | |
6a488035 TO |
284 | $dao->query($query); |
285 | if ($dao->affectedRows() >= 1) { | |
286 | $exclWeightSum[] = substr($fieldWeight, strrpos($fieldWeight, '.') + 1); | |
287 | } | |
6a488035 TO |
288 | } |
289 | else { | |
290 | // its a die situation | |
291 | break; | |
292 | } | |
293 | } | |
294 | } | |
295 | ||
e0ef6999 | 296 | /** |
4f1f1f2a CW |
297 | * Function to determine if a given query set contains inclusive or exclusive set of weights. |
298 | * The function assumes that the query set is already ordered by weight in desc order. | |
e0ef6999 EM |
299 | * @param $tableQueries |
300 | * @param $threshold | |
301 | * @param array $exclWeightSum | |
302 | * | |
303 | * @return array | |
304 | */ | |
be2fb01f CW |
305 | public static function isQuerySetInclusive($tableQueries, $threshold, $exclWeightSum = []) { |
306 | $input = []; | |
6a488035 TO |
307 | foreach ($tableQueries as $key => $query) { |
308 | $input[] = substr($key, strrpos($key, '.') + 1); | |
309 | } | |
310 | ||
311 | if (!empty($exclWeightSum)) { | |
312 | $input = array_merge($input, $exclWeightSum); | |
313 | rsort($input); | |
314 | } | |
315 | ||
316 | if (count($input) == 1) { | |
be2fb01f | 317 | return [FALSE, $input[0] < $threshold]; |
6a488035 TO |
318 | } |
319 | ||
320 | $totalCombinations = 0; | |
321 | for ($i = 0; $i < count($input); $i++) { | |
be2fb01f | 322 | $combination = [$input[$i]]; |
6a488035 TO |
323 | if (array_sum($combination) >= $threshold) { |
324 | $totalCombinations++; | |
325 | continue; | |
326 | } | |
327 | for ($j = $i + 1; $j < count($input); $j++) { | |
328 | $combination[] = $input[$j]; | |
329 | if (array_sum($combination) >= $threshold) { | |
330 | $totalCombinations++; | |
331 | } | |
332 | } | |
333 | } | |
be2fb01f | 334 | return [$totalCombinations == 1, $totalCombinations <= 0]; |
6a488035 TO |
335 | } |
336 | ||
e0ef6999 | 337 | /** |
fe482240 | 338 | * sort queries by number of records for the table associated with them. |
e0ef6999 EM |
339 | * @param $tableQueries |
340 | */ | |
00be9182 | 341 | public static function orderByTableCount(&$tableQueries) { |
be2fb01f | 342 | static $tableCount = []; |
6a488035 | 343 | |
be2fb01f | 344 | $tempArray = []; |
6a488035 TO |
345 | foreach ($tableQueries as $key => $query) { |
346 | $table = explode(".", $key); | |
347 | $table = $table[0]; | |
348 | if (!array_key_exists($table, $tableCount)) { | |
349 | $query = "SELECT COUNT(*) FROM {$table}"; | |
350 | $tableCount[$table] = CRM_Core_DAO::singleValueQuery($query); | |
351 | } | |
352 | $tempArray[$key] = $tableCount[$table]; | |
353 | } | |
354 | ||
355 | asort($tempArray); | |
356 | foreach ($tempArray as $key => $count) { | |
357 | $tempArray[$key] = $tableQueries[$key]; | |
358 | } | |
359 | $tableQueries = $tempArray; | |
360 | } | |
361 | ||
362 | /** | |
363 | * Return the SQL query for getting only the interesting results out of the dedupe table. | |
364 | * | |
365 | * @$checkPermission boolean $params a flag to indicate if permission should be considered. | |
366 | * default is to always check permissioning but public pages for example might not want | |
367 | * permission to be checked for anonymous users. Refer CRM-6211. We might be beaking | |
368 | * Multi-Site dedupe for public pages. | |
ea3ddccf | 369 | * |
370 | * @param bool $checkPermission | |
371 | * | |
372 | * @return string | |
6a488035 | 373 | */ |
00be9182 | 374 | public function thresholdQuery($checkPermission = TRUE) { |
6a488035 TO |
375 | $this->_aclFrom = ''; |
376 | // CRM-6603: anonymous dupechecks side-step ACLs | |
377 | $this->_aclWhere = ' AND is_deleted = 0 '; | |
378 | ||
379 | if ($this->params && !$this->noRules) { | |
380 | if ($checkPermission) { | |
381 | list($this->_aclFrom, $this->_aclWhere) = CRM_Contact_BAO_Contact_Permission::cacheClause('civicrm_contact'); | |
382 | $this->_aclWhere = $this->_aclWhere ? "AND {$this->_aclWhere}" : ''; | |
383 | } | |
887c0ec2 | 384 | $query = "SELECT {$this->temporaryTables['dedupe']}.id1 as id |
385 | FROM {$this->temporaryTables['dedupe']} JOIN civicrm_contact ON {$this->temporaryTables['dedupe']}.id1 = civicrm_contact.id {$this->_aclFrom} | |
6a488035 TO |
386 | WHERE contact_type = '{$this->contact_type}' {$this->_aclWhere} |
387 | AND weight >= {$this->threshold}"; | |
388 | } | |
389 | else { | |
390 | $this->_aclWhere = ' AND c1.is_deleted = 0 AND c2.is_deleted = 0'; | |
391 | if ($checkPermission) { | |
be2fb01f | 392 | list($this->_aclFrom, $this->_aclWhere) = CRM_Contact_BAO_Contact_Permission::cacheClause(['c1', 'c2']); |
6a488035 TO |
393 | $this->_aclWhere = $this->_aclWhere ? "AND {$this->_aclWhere}" : ''; |
394 | } | |
887c0ec2 | 395 | $query = "SELECT IF({$this->temporaryTables['dedupe']}.id1 < {$this->temporaryTables['dedupe']}.id2, {$this->temporaryTables['dedupe']}.id1, {$this->temporaryTables['dedupe']}.id2) as id1, |
396 | IF({$this->temporaryTables['dedupe']}.id1 < {$this->temporaryTables['dedupe']}.id2, {$this->temporaryTables['dedupe']}.id2, {$this->temporaryTables['dedupe']}.id1) as id2, {$this->temporaryTables['dedupe']}.weight | |
397 | FROM {$this->temporaryTables['dedupe']} JOIN civicrm_contact c1 ON {$this->temporaryTables['dedupe']}.id1 = c1.id | |
398 | JOIN civicrm_contact c2 ON {$this->temporaryTables['dedupe']}.id2 = c2.id {$this->_aclFrom} | |
399 | LEFT JOIN civicrm_dedupe_exception exc ON {$this->temporaryTables['dedupe']}.id1 = exc.contact_id1 AND {$this->temporaryTables['dedupe']}.id2 = exc.contact_id2 | |
d4c8a770 | 400 | WHERE c1.contact_type = '{$this->contact_type}' AND |
6a488035 TO |
401 | c2.contact_type = '{$this->contact_type}' {$this->_aclWhere} |
402 | AND weight >= {$this->threshold} AND exc.contact_id1 IS NULL"; | |
403 | } | |
404 | ||
405 | CRM_Utils_Hook::dupeQuery($this, 'threshold', $query); | |
406 | return $query; | |
407 | } | |
408 | ||
409 | /** | |
dc195289 | 410 | * find fields related to a rule group. |
6a488035 | 411 | * |
c490a46a | 412 | * @param array $params |
77b97be7 | 413 | * |
a6c01b45 CW |
414 | * @return array |
415 | * (rule field => weight) array and threshold associated to rule group | |
6a488035 | 416 | */ |
00be9182 | 417 | public static function dedupeRuleFieldsWeight($params) { |
353ffa53 | 418 | $rgBao = new CRM_Dedupe_BAO_RuleGroup(); |
6a488035 | 419 | $rgBao->contact_type = $params['contact_type']; |
b53cbfbc | 420 | if (!empty($params['id'])) { |
03390e26 | 421 | // accept an ID if provided |
422 | $rgBao->id = $params['id']; | |
423 | } | |
424 | else { | |
425 | $rgBao->used = $params['used']; | |
426 | } | |
6a488035 TO |
427 | $rgBao->find(TRUE); |
428 | ||
429 | $ruleBao = new CRM_Dedupe_BAO_Rule(); | |
430 | $ruleBao->dedupe_rule_group_id = $rgBao->id; | |
431 | $ruleBao->find(); | |
be2fb01f | 432 | $ruleFields = []; |
6a488035 TO |
433 | while ($ruleBao->fetch()) { |
434 | $ruleFields[$ruleBao->rule_field] = $ruleBao->rule_weight; | |
435 | } | |
436 | ||
be2fb01f | 437 | return [$ruleFields, $rgBao->threshold]; |
6a488035 TO |
438 | } |
439 | ||
03390e26 | 440 | /** |
fe482240 | 441 | * Get all of the combinations of fields that would work with a rule. |
ad37ac8e | 442 | * |
443 | * @param array $rgFields | |
444 | * @param int $threshold | |
445 | * @param array $combos | |
446 | * @param array $running | |
03390e26 | 447 | */ |
be2fb01f | 448 | public static function combos($rgFields, $threshold, &$combos, $running = []) { |
03390e26 | 449 | foreach ($rgFields as $rgField => $weight) { |
450 | unset($rgFields[$rgField]); | |
451 | $diff = $threshold - $weight; | |
452 | $runningnow = $running; | |
453 | $runningnow[] = $rgField; | |
454 | if ($diff > 0) { | |
455 | self::combos($rgFields, $diff, $combos, $runningnow); | |
456 | } | |
457 | else { | |
458 | $combos[] = $runningnow; | |
459 | } | |
460 | } | |
461 | } | |
462 | ||
6a488035 TO |
463 | /** |
464 | * Get an array of rule group id to rule group name | |
465 | * for all th groups for that contactType. If contactType | |
466 | * not specified, do it for all | |
467 | * | |
98997235 TO |
468 | * @param string $contactType |
469 | * Individual, Household or Organization. | |
6a488035 | 470 | * |
6a488035 | 471 | * |
a6c01b45 CW |
472 | * @return array |
473 | * id => "nice name" of rule group | |
6a488035 | 474 | */ |
00be9182 | 475 | public static function getByType($contactType = NULL) { |
6a488035 TO |
476 | $dao = new CRM_Dedupe_DAO_RuleGroup(); |
477 | ||
478 | if ($contactType) { | |
479 | $dao->contact_type = $contactType; | |
480 | } | |
481 | ||
482 | $dao->find(); | |
be2fb01f | 483 | $result = []; |
6a488035 | 484 | while ($dao->fetch()) { |
389bcebf | 485 | $title = !empty($dao->title) ? $dao->title : (!empty($dao->name) ? $dao->name : $dao->contact_type); |
01a93ecd DL |
486 | |
487 | $name = "$title - {$dao->used}"; | |
6a488035 TO |
488 | $result[$dao->id] = $name; |
489 | } | |
490 | return $result; | |
491 | } | |
96025800 | 492 | |
2ae26001 | 493 | /** |
494 | * Get the cached contact type for a particular rule group. | |
495 | * | |
496 | * @param int $rule_group_id | |
497 | * | |
498 | * @return string | |
499 | */ | |
500 | public static function getContactTypeForRuleGroup($rule_group_id) { | |
501 | if (!isset(\Civi::$statics[__CLASS__]) || !isset(\Civi::$statics[__CLASS__]['rule_groups'])) { | |
be2fb01f | 502 | \Civi::$statics[__CLASS__]['rule_groups'] = []; |
2ae26001 | 503 | } |
504 | if (empty(\Civi::$statics[__CLASS__]['rule_groups'][$rule_group_id])) { | |
505 | \Civi::$statics[__CLASS__]['rule_groups'][$rule_group_id]['contact_type'] = CRM_Core_DAO::getFieldValue( | |
506 | 'CRM_Dedupe_DAO_RuleGroup', | |
507 | $rule_group_id, | |
508 | 'contact_type' | |
509 | ); | |
510 | } | |
511 | ||
512 | return \Civi::$statics[__CLASS__]['rule_groups'][$rule_group_id]['contact_type']; | |
513 | } | |
514 | ||
6a488035 | 515 | } |