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':
case 'granddaughter':
$intRelationshipTypeId = RelationshipType::Grandchild;
break;
}
if ($intRelationshipTypeId) {
$objPerson = Person::Load($intPersonIdByIndvId[$objRow['indvid']]);
$objRelatedPerson = Person::Load($intPersonIdByIndvId[$objRow['reltindvid']]);
if (!Relationship::LoadByPersonIdRelatedToPersonId($objPerson->Id, $objRelatedPerson->Id)) {
$objPerson->AddRelationship($objRelatedPerson, $intRelationshipTypeId);
}
}
}
}
$objParticipationCursor = HouseholdParticipation::QueryCursor(QQ::All());
$intCount = HouseholdParticipation::CountAll();
while (QDataGen::DisplayWhileTask('Recalculating HouseholdParticipation Roles', $intCount) && ($objHouseholdParticipation = HouseholdParticipation::InstantiateCursor($objParticipationCursor))) {
$objHouseholdParticipation->RefreshRole();
}
<?php
$objIndex = Topic::CreateSearchIndex();
QDataGen::DisplayForEachTaskStart($strDescription = 'Generating Index for Topics', Topic::CountAll());
foreach (Topic::LoadAll() as $objTopic) {
QDataGen::DisplayForEachTaskNext($strDescription);
$objTopic->RefreshSearchIndex($objIndex);
}
QDataGen::DisplayForEachTaskEnd($strDescription);
$objIndex->commit();
print $objIndex->count() . " Documents indexed.\r\n";
protected static function GetRandomHeadShot($blnMaleFlag)
{
if (!self::$HeadShotMaleArray) {
// Create the Arrays
self::$HeadShotMaleArray = array();
$objDirectory = opendir(__DEVTOOLS_CLI__ . '/datagen_file_assets/headshots/male');
while ($strFile = readdir($objDirectory)) {
if (substr($strFile, 0, 8) == 'headshot') {
self::$HeadShotMaleArray[] = $strFile;
}
}
self::$HeadShotFemaleArray = array();
$objDirectory = opendir(__DEVTOOLS_CLI__ . '/datagen_file_assets/headshots/female');
while ($strFile = readdir($objDirectory)) {
if (substr($strFile, 0, 8) == 'headshot') {
self::$HeadShotFemaleArray[] = $strFile;
}
}
}
if ($blnMaleFlag) {
return __DEVTOOLS_CLI__ . '/datagen_file_assets/headshots/male/' . QDataGen::GenerateFromArray(self::$HeadShotMaleArray);
} else {
return __DEVTOOLS_CLI__ . '/datagen_file_assets/headshots/female/' . QDataGen::GenerateFromArray(self::$HeadShotFemaleArray);
}
}
<?php
$objParameters = new QCliParameterProcessor('zipcode-locater', 'Zipcode locater Script');
$objParameters->AddDefaultParameter('zipcode', QCliParameterType::String, 'Zipcode to search for');
$objParameters->Run();
$zipcode = $objParameters->GetDefaultValue('zipcode');
$objPersonCursor = Person::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Checking for Persons in zipcode', Person::CountAll());
print "\n";
while ($objPerson = Person::InstantiateCursor($objPersonCursor)) {
QDataGen::DisplayForEachTaskNext('Checking for Persons in zipcode');
if ($objPerson->MembershipStatusTypeId == MembershipStatusType::Member) {
$objAddressArray = $objPerson->GetAllAssociatedAddressArray();
foreach ($objAddressArray as $objAddress) {
if (strstr($objAddress->ZipCode, $zipcode) != false) {
print $objPerson->FirstName . " " . $objPerson->LastName . ": " . $objAddress->Address1 . ", " . $objAddress->City . ", " . $objAddress->ZipCode . "\n";
}
}
}
}
//$test = new Address();
//$test->City
QDataGen::DisplayForEachTaskEnd('Checking for Persons in zipcode');
$objMySqli = new mysqli('localhost', 'root', '', 'alcf_address');
QDataGen::DisplayForEachTaskStart('Cleaning Addresses', Address::CountAll());
foreach (Address::LoadAll() as $objAddress) {
QDataGen::DisplayForEachTaskNext('Cleaning Addresses');
$strQuery = sprintf("SELECT id FROM address WHERE address_1 %s AND address_2 %s AND address_3 %s AND city %s AND state %s AND zip_code %s;", is_null($objAddress->Address1) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address1) . "'", is_null($objAddress->Address2) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address2) . "'", is_null($objAddress->Address3) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->Address3) . "'", is_null($objAddress->City) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->City) . "'", is_null($objAddress->State) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->State) . "'", is_null($objAddress->ZipCode) ? 'IS NULL' : "='" . $objMySqli->escape_string($objAddress->ZipCode) . "'");
$objResult = $objMySqli->Query($strQuery);
if ($objRow = $objResult->fetch_array()) {
$objResult = $objMySqli->Query('SELECT * FROM corrected_address WHERE address_id=' . $objRow['id']);
$objRow = $objResult->fetch_array();
if ($objRow['status_flag'] == 1) {
$objAddress->Address1 = $objRow['address_1'];
$objAddress->Address2 = $objRow['address_2'];
$objAddress->City = $objRow['city'];
$objAddress->State = $objRow['state'];
$objAddress->ZipCode = $objRow['zip_code'];
$objAddress->InvalidFlag = false;
$objAddress->VerificationCheckedFlag = true;
} else {
$objAddress->InvalidFlag = true;
}
$objAddress->Save();
} else {
if (!$objAddress->ValidateUsps()) {
print "NONE FOUND FOR - " . $objAddress->Id . "\r\n";
$objAddress->InvalidFlag = true;
$objAddress->Save();
}
}
}
QDataGen::DisplayForEachTaskEnd('Cleaning Addresses');
/**
* Returns a randomly generated Website URL
* @return string
*/
public static function GenerateWebsiteUrl()
{
$strDomain = QDataGen::GenerateWord();
$strDomain = str_replace(' ', '', $strDomain);
return 'http://www.' . $strDomain . '.' . QDataGen::$TldArray[rand(0, count(QDataGen::$TldArray) - 1)] . '/';
}
}
QDataGen::DisplayForEachTaskEnd('Refreshing Household data');
$objStewardshipCursor = StewardshipContribution::QueryCursor(QQ::All());
QDataGEn::DisplayForEachTaskStart('Refreshing Contributions', StewardshipContribution::CountAll());
while ($objContribution = StewardshipContribution::InstantiateCursor($objStewardshipCursor)) {
QDataGen::DisplayForEachTaskNext('Refreshing Contributions');
$objContribution->RefreshTotalAmount();
}
QDataGen::DisplayForEachTaskEnd('Refreshing Contributions');
$objStewardshipCursor = StewardshipStack::QueryCursor(QQ::All());
QDataGEn::DisplayForEachTaskStart('Refreshing Stacks', StewardshipStack::CountAll());
while ($objStack = StewardshipStack::InstantiateCursor($objStewardshipCursor)) {
QDataGen::DisplayForEachTaskNext('Refreshing Stacks');
$objStack->RefreshActualTotalAmount();
}
QDataGen::DisplayForEachTaskEnd('Refreshing Stacks');
$objStewardshipCursor = StewardshipBatch::QueryCursor(QQ::All());
QDataGEn::DisplayForEachTaskStart('Refreshing Batches', StewardshipBatch::CountAll());
while ($objBatch = StewardshipBatch::InstantiateCursor($objStewardshipCursor)) {
QDataGen::DisplayForEachTaskNext('Refreshing Batches');
$objBatch->PostBalance(Login::Load(1));
}
QDataGen::DisplayForEachTaskEnd('Refreshing Batches');
$objStewardshipCursor = StewardshipPledge::QueryCursor(QQ::All());
QDataGEn::DisplayForEachTaskStart('Refreshing Pledges', StewardshipPledge::CountAll());
while ($objPledge = StewardshipPledge::InstantiateCursor($objStewardshipCursor)) {
QDataGen::DisplayForEachTaskNext('Refreshing Pledges');
$objPledge->Refresh();
}
QDataGen::DisplayForEachTaskEnd('Refreshing Pledges');
$objSpouse = null;
}
fwrite($objFile, EscapeCsv($objSpouse ? $objHousehold->HeadPerson->FirstName . ' and ' . $objSpouse->FirstName : $objHousehold->HeadPerson->FirstName) . ',' . EscapeCsv($objHousehold->StewardshipHouseholdName) . ',' . EscapeCsv($objAddress->Address3) . ',' . EscapeCsv($objAddress->Address1) . ',' . EscapeCsv($objAddress->Address2) . ',' . EscapeCsv($objAddress->City) . ',' . EscapeCsv($objAddress->State) . ',' . EscapeCsv($objAddress->ZipCode) . "\r\n");
}
} else {
if ($objHousehold->HeadPerson->CanMailFlag && !$objHousehold->HeadPerson->DeceasedFlag) {
fwrite($objFile, EscapeCsv($objHousehold->HeadPerson->FirstName) . ',' . EscapeCsv($objHousehold->StewardshipHouseholdName) . ',' . EscapeCsv($objAddress->Address3) . ',' . EscapeCsv($objAddress->Address1) . ',' . EscapeCsv($objAddress->Address2) . ',' . EscapeCsv($objAddress->City) . ',' . EscapeCsv($objAddress->State) . ',' . EscapeCsv($objAddress->ZipCode) . "\r\n");
}
}
}
}
// Generate for each individual in the household
} else {
foreach ($objHousehold->GetHouseholdParticipationArray() as $objParticipation) {
if ($objAddress = $objParticipation->Person->GetStewardshipAddress()) {
$intPersonIdArray = array($objParticipation->Person->Id);
$objContributionAmountArray = StewardshipContribution::GetContributionAmountArrayForPersonArray($intPersonIdArray, $intYear);
$fltAmount = StewardshipContribution::GetContributionAmountTotalForContributionAmountArray($objContributionAmountArray, false);
if ($fltAmount > $fltMinimumAmount) {
$objPerson = $objParticipation->Person;
if ($objPerson->CanMailFlag && !$objPerson->DeceasedFlag) {
fwrite($objFile, EscapeCsv($objPerson->FirstName) . ',' . EscapeCsv($objPerson->ActiveMailingLabel) . ',' . EscapeCsv($objAddress->Address3) . ',' . EscapeCsv($objAddress->Address1) . ',' . EscapeCsv($objAddress->Address2) . ',' . EscapeCsv($objAddress->City) . ',' . EscapeCsv($objAddress->State) . ',' . EscapeCsv($objAddress->ZipCode) . "\r\n");
}
}
}
}
}
}
fclose($objFile);
QDataGen::DisplayForEachTaskEnd('Generating CSV Row(s) for Household');
print "GROUPS\n";
$objGroupCursor = Group::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Checking for email in Group Lists', Group::CountAll());
while ($objGroup = Group::InstantiateCursor($objGroupCursor)) {
QDataGen::DisplayForEachTaskNext('Checking for email in Group Lists');
$objGroupParticipationArr = $objGroup->GetGroupParticipationArray();
foreach ($objGroupParticipationArr as $objGroupParticipant) {
if (in_array($objGroupParticipant->PersonId, $intPersonIdArray)) {
printf("\n%s is in %s: %s\n", $txtEmail, $objGroup->Ministry->Name, $objGroup->Name);
break;
}
}
}
QDataGen::DisplayForEachTaskEnd('Checking for email in Group Lists');
print "COMMUNICATION LISTS\n";
$objCommuncationsCursor = CommunicationList::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Checking for email in Communication Lists', CommunicationList::CountAll());
while ($objCommunicationList = CommunicationList::InstantiateCursor($objCommuncationsCursor)) {
QDataGen::DisplayForEachTaskNext('Checking for email in Communication Lists');
$objCommListArray = $objCommunicationList->GetMemberAsArray();
foreach ($objCommListArray as $objComListEntry) {
if ($objComListEntry[3] == $txtEmail) {
printf("\n%s is in %s: %s\n", $txtEmail, $objCommunicationList->Ministry->Name, $objCommunicationList->Name);
break;
}
}
}
QDataGen::DisplayForEachTaskEnd('Checking for email in Communication Lists');
} else {
print "No email object found\n";
}
$objWikiPage->CompileHtml();
$objWikiItem->CreateNewVersion('Downloads from Old Qcodo.com Website', $objWikiPage, 'Save', array(), Person::Load(1), null);
print "Done.\r\n";
QDataGen::DisplayForEachTaskStart($strTitle = 'Refreshing Topic Stats', Topic::CountAll());
foreach (Topic::LoadAll() as $objTopic) {
QDataGen::DisplayForEachTaskNext($strTitle);
$objTopic->RefreshStats();
}
QDataGen::DisplayForEachTaskEnd($strTitle);
QDataGen::DisplayForEachTaskStart($strTitle = 'Refreshing TopicLink Stats', TopicLink::CountAll());
foreach (TopicLink::LoadAll() as $objTopicLink) {
QDataGen::DisplayForEachTaskNext($strTitle);
$objTopicLink->RefreshStats();
}
QDataGen::DisplayForEachTaskEnd($strTitle);
$objResult = $objDb->query('SELECT * FROM email_topic_person_assn');
while (QDataGen::DisplayWhileTask('Migrating email_topic_person_assn', $objResult->num_rows)) {
$objRow = $objResult->fetch_array();
try {
Topic::GetDatabase()->NonQuery('INSERT INTO email_topic_person_assn(topic_id, person_id) VALUES (' . $objRow['topic_id'] . ',' . $objRow['person_id'] . ');');
} catch (QMySqliDatabaseException $objExc) {
}
}
$objResult = $objDb->query('SELECT * FROM read_topic_person_assn');
while (QDataGen::DisplayWhileTask('Migrating read_topic_person_assn', $objResult->num_rows)) {
$objRow = $objResult->fetch_array();
try {
Topic::GetDatabase()->NonQuery('INSERT INTO read_topic_person_assn(topic_id, person_id) VALUES (' . $objRow['topic_id'] . ',' . $objRow['person_id'] . ');');
} catch (QMySqliDatabaseException $objExc) {
}
}
<?php
$objPersonCursor = Person::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Refreshing Person data (age)', Person::CountAll());
while ($objPerson = Person::InstantiateCursor($objPersonCursor)) {
QDataGen::DisplayForEachTaskNext('Refreshing Person data (age)');
$objPerson->RefreshAge(true);
}
QDataGen::DisplayForEachTaskEnd('Refreshing Person data (age)');
<?php
$objPersonCursor = Person::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Removing Duplicate Addresses from Person', Person::CountAll());
while ($objPerson = Person::InstantiateCursor($objPersonCursor)) {
QDataGen::DisplayForEachTaskNext('Removing Duplicate Addresses from Person');
$objPerson->RemoveDuplicateAddresses();
}
QDataGen::DisplayForEachTaskEnd('Removing Duplicate Addresses from Person');
<?php
$objPersonCursor = Person::QueryCursor(QQ::All());
QDataGen::DisplayForEachTaskStart('Checking for Multiple First Names in Person', Person::CountAll());
print "\n";
while ($objPerson = Person::InstantiateCursor($objPersonCursor)) {
QDataGen::DisplayForEachTaskNext('Checking for Multiple First Names in Person');
$pos = strpos($objPerson->FirstName, " and ");
if ($pos !== false) {
print "Found Multiple First Name: " . $objPerson->FirstName . "\n";
}
$pos = strpos($objPerson->FirstName, "&");
if ($pos !== false) {
print "Found Multiple First Name: " . $objPerson->FirstName . "\n";
}
}
QDataGen::DisplayForEachTaskEnd('Checking for Multiple First Names in Person');
if ($intEntryCount > 38) {
StewardshipContribution::GenerateReceiptInPdf($objMultiplePagePdf, $objParticipation->Person, $intYear, $blnAnnual, $intQuarter);
} else {
if ($intEntryCount) {
StewardshipContribution::GenerateReceiptInPdf($objSinglePagePdf, $objParticipation->Person, $intYear, $blnAnnual, $intQuarter);
}
}
}
}
} else {
StewardshipContribution::GenerateReceiptInPdf($objInvalidAddressPdf, $objParticipation->Person, $intYear, $blnAnnual, $intQuarter);
}
}
}
// Separate into New File?
if (count($objSinglePagePdf->pages) > 500) {
$objSinglePagePdf->save(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Single_' . $intSingplePageCount . '.pdf');
chmod(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Single_' . $intSingplePageCount . '.pdf', 0777);
$objSinglePagePdf = new Zend_Pdf();
$intSingplePageCount++;
}
}
QDataGen::DisplayForEachTaskEnd('Generating Receipt for Household');
$objSinglePagePdf->save(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Single_' . $intSingplePageCount . '.pdf');
chmod(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Single_' . $intSingplePageCount . '.pdf', 0777);
$objMultiplePagePdf->save(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Multiple.pdf');
chmod(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Multiple.pdf', 0777);
$objInvalidAddressPdf->save(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_InvalidAddress.pdf');
chmod(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_InvalidAddress.pdf', 0777);
$objDeceasedPdf->save(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Deceased.pdf');
chmod(RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . $strFileToken . '_Deceased.pdf', 0777);
$intMessageCount = rand(1, GENERATE_MESSAGES_PER_TOPIC_UBOUND);
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
if (rand(0, 1)) {
$intMessageCount = round($intMessageCount / 2);
}
$blnFirstMessage = true;
while (QDataGen::DisplayWhileTask(' - Generating Messages for Topic #' . $objTopic->Id, $intMessageCount, true)) {
$strMessageText = QDataGen::GenerateContent(rand(1, 5));
$objPerson = Person::Load(rand(1, $intMaxPersonId));
$dttDateTime = QDataGen::GenerateDateTime($dttStartDate, QDateTime::Now());
$objTopic->PostMessage($strMessageText, $objPerson, $dttDateTime);
}
// Finally, Refresh this topic's ReplyNumber ordering
$objTopic->RefreshReplyNumbering();
}
QDataGen::DisplayForEachTaskEnd($strTopics);
