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);