<?php
$intPersonIdByIndvId = array();
foreach (AttributeValue::LoadArrayByAttributeId(2) as $objAttributeValue) {
$intPersonIdByIndvId[$objAttributeValue->TextValue] = $objAttributeValue->PersonId;
}
$objMySqli = new mysqli('localhost', 'root', '', 'alcf_acs');
$objResult = $objMySqli->query('SELECT * FROM awperelt');
$intCount = $objResult->num_rows;
while (QDataGen::DisplayWhileTask('Importing Family Relationships', $intCount) && ($objRow = $objResult->fetch_array())) {
if ($objRow['indvid'] != $objRow['reltindvid']) {
$intRelationshipTypeId = null;
switch (strtolower($objRow['relationship'])) {
case 'mother':
case 'father':
$intRelationshipTypeId = RelationshipType::Parental;
break;
case 'son':
case 'daughter':
$intRelationshipTypeId = RelationshipType::Child;
break;
case 'brother':
case 'sister':
$intRelationshipTypeId = RelationshipType::Sibling;
break;
case 'grandmother':
case 'grandfather':
$intRelationshipTypeId = RelationshipType::Grandparent;
break;
case 'grandchild':
case 'grandson':
/**
* Deletes all associated AttributeValues
* @return void
*/
public function DeleteAllAttributeValues()
{
if (is_null($this->intId)) {
throw new QUndefinedPrimaryKeyException('Unable to call UnassociateAttributeValue on this unsaved Attribute.');
}
// Get the Database Object for this Class
$objDatabase = Attribute::GetDatabase();
// Journaling
if ($objDatabase->JournalingDatabase) {
foreach (AttributeValue::LoadArrayByAttributeId($this->intId) as $objAttributeValue) {
$objAttributeValue->Journal('DELETE');
}
}
// Perform the SQL Query
$objDatabase->NonQuery('
DELETE FROM
`attribute_value`
WHERE
`attribute_id` = ' . $objDatabase->SqlVariable($this->intId) . '
');
}
