/** * Given a search term, this will try and match all similarly matched individuals. * This will utilize soundex and other indexing methodologies. * * @param string $strName * @param QQCondition $objCondition * @param QQClause[] $objClauses * @param QQNodePerson $objPersonNode * @return void */ public static function PrepareQqForSearch($strName, QQCondition &$objCondition, &$objClauses, QQNodePerson $objPersonNode = null) { if (!$objPersonNode) { $objPersonNode = QQN::Person(); } $strNameItemArray = NameItem::GetNormalizedArrayFromNameString($strName, true); // First, get the applicable NameItem $intNameItemIdArrayArray = array(); foreach ($strNameItemArray as $strNameItem) { $intNameItemIdArray = array(); $strQuery = sprintf("SELECT * FROM name_item WHERE (soundex(name) = soundex('%s') OR name LIKE '%s%%')", mysql_escape_string($strNameItem), mysql_escape_string($strNameItem)); $objNameItemArray = NameItem::InstantiateDbResult(NameItem::GetDatabase()->Query($strQuery)); foreach ($objNameItemArray as $objNameItem) { $intNameItemIdArray[] = $objNameItem->Id; } $intNameItemIdArrayArray[] = $intNameItemIdArray; } // Build the search array from Person $intIndex = 0; foreach ($intNameItemIdArrayArray as $intNameItemIdArray) { if (!count($intNameItemIdArray)) { $objCondition = QQ::None(); return; } $intIndex++; $strAlias = 'assn_' . $intIndex; if ($intIndex == 2) { $objClauses[] = QQ::Distinct(); } $objClauses[] = QQ::CustomFrom('person_nameitem_assn', $strAlias); if (count($intNameItemIdArray) == 1) { $objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQ::CustomNode($strAlias . '.person_id'), $objPersonNode->Id), QQ::Equal(QQ::CustomNode($strAlias . '.name_item_id'), $intNameItemIdArray[0])); } else { $objCondition = QQ::AndCondition($objCondition, QQ::Equal(QQ::CustomNode($strAlias . '.person_id'), $objPersonNode->Id), QQ::In(QQ::CustomNode($strAlias . '.name_item_id'), $intNameItemIdArray)); } } }
/** * Unassociates all People * @return void */ public function UnassociateAllPeople() { if (is_null($this->intId)) { throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAllPersonArray on this unsaved NameItem.'); } // Get the Database Object for this Class $objDatabase = NameItem::GetDatabase(); // Journaling (if applicable) if ($objDatabase->JournalingDatabase) { $objResult = $objDatabase->Query('SELECT `person_id` AS associated_id FROM `person_nameitem_assn` WHERE `name_item_id` = ' . $objDatabase->SqlVariable($this->intId)); while ($objRow = $objResult->GetNextRow()) { $this->JournalPersonAssociation($objRow->GetColumn('associated_id'), 'DELETE'); } } // Perform the SQL Query $objDatabase->NonQuery(' DELETE FROM `person_nameitem_assn` WHERE `name_item_id` = ' . $objDatabase->SqlVariable($this->intId) . ' '); }