print "Age Statistics:\r\n"; foreach ($iAgeStatus as $key => $value) { print $key . ': ,' . $value . "\r\n"; } print "Ethnicity BreakDown:\r\n"; foreach ($iEthnicity as $key => $value) { print $key . ': ,' . $value . "\r\n"; } } foreach ($objMembershipArray as $objMembership) { print EscapeCsv($objMembership->Person->FullName); print ","; if ($bIsExit) { print EscapeCsv($objMembership->DateEnd); print ","; print EscapeCsv($objMembership->TerminationReason); } else { print EscapeCsv($objMembership->DateStart); print ","; print EscapeCsv(GetMaritalStatus($objMembership)); print ","; print EscapeCsv(GetAge($objMembership)); print ","; print EscapeCsv(GetEthnicity($objMembership)); print ","; print EscapeCsv(GetPriorChurch($objMembership)); print ","; print EscapeCsv(GetSalvationDate($objMembership)); } print "\r\n"; }
if ($objSpouse->DeceasedFlag) { $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');
$objSignupProduct = SignupProduct::LoadBySignupEntryIdFormProductId($objSignupEntry->Id, $objFormProduct->Id); if ($objSignupProduct) { print QApplication::DisplayCurrency($objSignupProduct->Amount); } else { print " "; } print ","; } } print QApplication::DisplayCurrency($objSignupEntry->AmountTotal); print ","; print QApplication::DisplayCurrency($objSignupEntry->AmountPaid); print ","; print QApplication::DisplayCurrency($objSignupEntry->AmountBalance); print ","; $strReturn = ''; if ($objSignupEntry->CountSignupPayments()) { $objArray = $objSignupEntry->GetSignupPaymentArray(); $strReturn .= SignupPaymentType::ToString($objArray[0]->SignupPaymentTypeId); } else { $strReturn = 'No payment'; } print EscapeCsv($strReturn); print ","; } if ($objSignupEntry->DateSubmitted) { print EscapeCsv($objSignupEntry->DateSubmitted->ToString('M/D/YYYY')); } print "\r\n"; } }
print EscapeCsv($objGroup->Name); print ","; print EscapeCsv($objPerson->FirstName); print ","; print EscapeCsv($objPerson->LastName); print ","; if ($objPerson->PrimaryEmail) { print EscapeCsv($objPerson->PrimaryEmail->Address); } print ","; print EscapeCsv($objPerson->PrimaryPhoneText); print ","; print EscapeCsv($objPerson->PrimaryAddressText); print ","; print EscapeCsv($objPerson->PrimaryCityText); print ","; print EscapeCsv($objPerson->PrimaryStateText); print ","; print EscapeCsv($objPerson->PrimaryZipCodeText); print ","; print "\r\n"; $intTotalCount++; } } } print "\r\n"; print "\r\n"; print "Total Number of Growth Groups: " . $intGroupCount; print "\r\n"; print "\r\n"; print "Total Count of People in Growth Groups: " . $intTotalCount;
default: $objMinistry = Ministry::LoadByToken($ministrydepartment); if ($objMinistry->Token == $objGroup->MinistryId) { // Get all participants in the group calculateValues($objGroup); } break; } } /**************/ // Disable strict no-cache for IE due to IE issues with downloading no-cache items if (QApplication::IsBrowser(QBrowserType::InternetExplorer)) { header("Pragma:"); header("Expires:"); } header('Content-Type: text/csv'); header('Content-Disposition: attachment; filename=VolunteerReport.csv'); print "Volunteers Report From " . $startDate->__toString('MMM YYYY') . " to " . $endDate->__toString('MMM YYYY') . " \r\n"; print "Department/Ministry: " . QApplication::PathInfo(2) . "\r\n"; print "\r\n"; print "Month and Year, # of Volunteers\r\n"; function EscapeCsv($strString) { return '"' . str_replace('"', '""', $strString) . '"'; } foreach ($monthCount as $key => $value) { print EscapeCsv($key); print ","; print EscapeCsv($value); print "\r\n"; }
print EscapeCsv($objPerson->FirstName); print ","; print EscapeCsv($objPerson->LastName); print ","; if ($objPerson->PrimaryEmail) { print EscapeCsv($objPerson->PrimaryEmail->Address); } print ","; print EscapeCsv($objPerson->PrimaryPhoneText); print ","; print EscapeCsv($objPerson->PrimaryAddressText); print ","; print EscapeCsv($objPerson->PrimaryCityText); print ","; print EscapeCsv($objPerson->PrimaryStateText); print ","; print EscapeCsv($objPerson->PrimaryZipCodeText); print ","; print EscapeCsv($objPerson->CanMailFlag ? "Yes" : "No"); print ","; print EscapeCsv($objPerson->DeceasedFlag ? "Yes" : "No"); print ","; if ($objPerson->DateOfBirth && !$objPerson->DobGuessedFlag) { if ($objPerson->DobYearApproximateFlag) { print EscapeCsv($objPerson->DateOfBirth->ToString('DD-MMM')); } else { print EscapeCsv($objPerson->DateOfBirth->ToString('M/D/YYYY')); } } print "\r\n"; }
print EscapeCsv($objGroupRegistrant->PreferredLocation1); print ","; print EscapeCsv($objGroupRegistrant->PreferredLocation2); print ","; print EscapeCsv($objGroupRegistrant->GroupRole->Name); print ","; $strReturn = ''; foreach (GrowthGroupStructure::LoadAll() as $objGrowthGroupStructure) { if ($objGroupRegistrant->IsGrowthGroupStructureAsGroupstructureAssociated($objGrowthGroupStructure)) { $strReturn .= $objGrowthGroupStructure->Name . ', '; } } $strReturn = substr($strReturn, 0, strlen($strReturn) - 2); print EscapeCsv($strReturn); print ","; print EscapeCsv($objGroupRegistrant->GroupDay); print ","; print EscapeCsv(SourceList::Load($objGroupRegistrant->SourceListId)->Name); print ","; if ($objGroupRegistrant->ProcessedFlag) { print 'Yes'; } else { print 'No'; } print ","; print EscapeCsv($objGroupRegistrant->GroupsPlaced); print ","; print EscapeCsv($objGroupRegistrant->DateProcessed); print ","; print "\r\n"; }