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";
}
