* Class CRM_Dedupe_BAO_QueryBuilder
*/
class CRM_Dedupe_BAO_QueryBuilder {
+
/**
* @param $rg
* @param string $strID1
}
}
+ /**
+ * If a contact list is specified then adjust the query to ensure one contact is in that list.
+ *
+ * Doing an OR join here will lead to a server-killing unindexed query. However, a union will
+ * perform better.
+ *
+ * @param array $contactList
+ * @param string $query
+ * @param string $strID1
+ * @param string $strID2
+ *
+ * @return string
+ */
+ protected static function filterQueryByContactList(array $contactList, $query, $strID1 = 'contact1.id', $strID2 = 'contact2.id') {
+ if (empty($contactList)) {
+ return $query . " AND ($strID1 < $strID2)";
+ }
+ $contactIDs = implode(',', $contactList);
+ return "$query AND $strID1 IN ($contactIDs) AND $strID1 > $strID2
+ UNION $query AND $strID1 > $strID2 AND $strID2 IN ($contactIDs) AND $strID1 NOT IN ($contactIDs)
+ ";
+
+ }
+
}