<?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";
$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');
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'); }
} 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->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 { 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);