<?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');
<?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";
<?php
ini_set('memory_limit', '1024M');
$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();
}
}
public static function GenerateMinistries()
{
QDataGen::DisplayForEachTaskStart('Generating Minsitries', count(self::$MinistryArray));
foreach (self::$MinistryArray as $strToken => $strMinistry) {
QDataGen::DisplayForEachTaskNext('Generating Minsitries');
$objMinistry = new Ministry();
$objMinistry->Token = $strToken;
$objMinistry->Name = $strMinistry;
$objMinistry->ActiveFlag = true;
$objMinistry->Save();
$objFund = new StewardshipFund();
$objFund->Ministry = $objMinistry;
$objFund->Name = 'Ministry - ' . $objMinistry->Name;
$objFund->AccountNumber = rand(100, 999);
$objFund->Save();
$strArray = array('Member' => GroupRoleType::Participant, 'Participant' => GroupRoleType::Participant, 'Volunteer' => GroupRoleType::Volunteer, 'Leader' => GroupRoleType::Volunteer);
foreach ($strArray as $strName => $intGroupRoleTypeId) {
$objGroupRole = new GroupRole();
$objGroupRole->Ministry = $objMinistry;
$objGroupRole->Name = $strName;
$objGroupRole->GroupRoleTypeId = $intGroupRoleTypeId;
$objGroupRole->Save();
}
}
self::$MinistryArray = Ministry::LoadAll();
QDataGen::DisplayForEachTaskEnd('Generating Minsitries');
}
$objHousehold->Save();
}
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');
}
$objParameters = new QCliParameterProcessor('export-stewardship-roster', 'ALCF Export Stewardship Roster to CSV');
$objParameters->AddDefaultParameter('year', QCliParameterType::Integer, 'The year of giving data to use');
$objParameters->AddDefaultParameter('export_path', QCliParameterType::Path, 'The folder to export to');
$objParameters->Run();
$intYear = $objParameters->GetDefaultValue('year');
$strFolder = $objParameters->GetDefaultValue('export_path');
$fltMinimumAmount = 0;
$objFile = fopen($strFolder . '/contributors.csv', 'w');
fwrite($objFile, 'Salutation,MailingName,CompanyFacilityEtc,Address1,Address2,City,State,ZipCode' . "\r\n");
$objConditions = QQ::All();
// $objConditions = QQ::AndCondition($objConditions,QQ::Equal(QQN::Household()->HeadPerson->CanMailFlag, true));
$objHouseholdCursor = Household::QueryCursor($objConditions, QQ::OrderBy(QQN::Household()->HeadPerson->LastName));
QDataGen::DisplayForEachTaskStart('Generating CSV Row(s) for Household', Household::CountAll());
while ($objHousehold = Household::InstantiateCursor($objHouseholdCursor)) {
QDataGen::DisplayForEachTaskNext('Generating CSV Row(s) for Household');
// Generate for the whole household
if ($objHousehold->CombinedStewardshipFlag) {
if ($objAddress = $objHousehold->GetStewardshipAddress()) {
$intPersonIdArray = StewardshipContribution::GetPersonIdArrayForPersonOrHousehold($objHousehold);
$objContributionAmountArray = StewardshipContribution::GetContributionAmountArrayForPersonArray($intPersonIdArray, $intYear);
$fltAmount = StewardshipContribution::GetContributionAmountTotalForContributionAmountArray($objContributionAmountArray, false);
if ($fltAmount > $fltMinimumAmount) {
$objSpouse = $objHousehold->SpousePerson;
if ($objSpouse) {
// Head person says do not mail, but spouse says mail
// Or if Head person is deceased and spouse says mail
if (!$objHousehold->HeadPerson->CanMailFlag && $objSpouse->CanMailFlag || $objHousehold->HeadPerson->DeceasedFlag && $objSpouse->CanMailFlag) {
fwrite($objFile, EscapeCsv($objSpouse->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 ($objSpouse->DeceasedFlag) {
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";
}
$strContent .= "\r\n\r\n";
$strContent .= 'For other Community-Contributed classes, utilities, and code-snippets';
$objWikiPage = new WikiPage();
$objWikiPage->Content = trim($strContent);
$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 {
<?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');
require_once 'Zend/Loader.php';
Zend_Loader::loadClass('Zend_Pdf');
print "Generating Receipts PDF for " . $intYear . "\r\n";
// Delete Old Files
exec('rm -r -f ' . RECEIPT_PDF_PATH . '/ReceiptsFor' . $intYear . '*.pdf');
// Create the PDF Object for the Single and Multiple-page PDFs
$intSingplePageCount = 1;
$objSinglePagePdf = new Zend_Pdf();
$objMultiplePagePdf = new Zend_Pdf();
$objInvalidAddressPdf = new Zend_Pdf();
$objDeceasedPdf = new Zend_Pdf();
//QQ::All()
$objHouseholdCursor = Household::QueryCursor(QQ::Equal(QQN::Household()->HeadPerson->CanMailFlag, true), QQ::OrderBy(QQN::Household()->HeadPerson->LastName));
QDataGen::DisplayForEachTaskStart('Generating Receipt for Household', Household::CountAll());
while ($objHousehold = Household::InstantiateCursor($objHouseholdCursor)) {
QDataGen::DisplayForEachTaskNext('Generating Receipt for Household');
// Generate for the whole household
if ($objHousehold->CombinedStewardshipFlag) {
if ($objHousehold->GetStewardshipAddress()) {
$intPersonIdArray = StewardshipContribution::GetPersonIdArrayForPersonOrHousehold($objHousehold);
$objContributionAmountArray = StewardshipContribution::GetContributionAmountArrayForPersonArray($intPersonIdArray, $intYear, $intQuarter);
$intEntryCount = count($objContributionAmountArray);
$fltAmount = StewardshipContribution::GetContributionAmountTotalForContributionAmountArray($objContributionAmountArray);
if ($objHousehold->HeadPerson->DeceasedFlag) {
StewardshipContribution::GenerateReceiptInPdf($objDeceasedPdf, $objHousehold, $intYear, $blnAnnual, $intQuarter);
} else {
if ($fltAmount > $fltMinimumAmount) {
if ($intEntryCount > 38) {
StewardshipContribution::GenerateReceiptInPdf($objMultiplePagePdf, $objHousehold, $intYear, $blnAnnual, $intQuarter);
} else {
if ($intEntryCount) {
$objPerson = Person::Load(rand(1, $intMaxPersonId));
// Get a random Message PostDate relatively close to the current dttpostdate we're iterating through
$dttEndRange = QDataGen::GenerateDateTime($dttPostDate, QDateTime::Now());
$dttEndRange = QDataGen::GenerateDateTime($dttPostDate, $dttEndRange);
$dttEndRange = QDataGen::GenerateDateTime($dttPostDate, $dttEndRange);
$dttPostDate = QDataGen::GenerateDateTime($dttPostDate, $dttEndRange);
$objPackage->PostMessage(QDataGen::GenerateContent(rand(1, 3), 10, 30), $objPerson, $dttPostDate);
}
}
QDataGen::DisplayForEachTaskEnd($strTitle);
//////////////////////
// Forum Messages
//////////////////////
QDataGen::DisplayForEachTaskStart($strTopics = 'Generating Forum Messages for Topics', count($objForumTopicArray));
foreach ($objForumTopicArray as $objTopic) {
QDataGen::DisplayForEachTaskNext($strTopics);
// Randomly Select a Number of Messages for this Forum Topic
$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)) {
