<?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)) {