/**
* Create and setup QListBox lstStewardshipContribution
* @param string $strControlId optional ControlId to use
* @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself
* @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query
* @return QListBox
*/
public function lstStewardshipContribution_Create($strControlId = null, QQCondition $objCondition = null, $objOptionalClauses = null)
{
$this->lstStewardshipContribution = new QListBox($this->objParentObject, $strControlId);
$this->lstStewardshipContribution->Name = QApplication::Translate('Stewardship Contribution');
$this->lstStewardshipContribution->Required = true;
if (!$this->blnEditMode) {
$this->lstStewardshipContribution->AddItem(QApplication::Translate('- Select One -'), null);
}
// Setup and perform the Query
if (is_null($objCondition)) {
$objCondition = QQ::All();
}
$objStewardshipContributionCursor = StewardshipContribution::QueryCursor($objCondition, $objOptionalClauses);
// Iterate through the Cursor
while ($objStewardshipContribution = StewardshipContribution::InstantiateCursor($objStewardshipContributionCursor)) {
$objListItem = new QListItem($objStewardshipContribution->__toString(), $objStewardshipContribution->Id);
if ($this->objStewardshipPostLineItem->StewardshipContribution && $this->objStewardshipPostLineItem->StewardshipContribution->Id == $objStewardshipContribution->Id) {
$objListItem->Selected = true;
}
$this->lstStewardshipContribution->AddItem($objListItem);
}
// Return the QListBox
return $this->lstStewardshipContribution;
}
$fltTotalGifts = 0;
$fltTotalAdditionalUniqueGivers = 0;
$fltTotalGiftsOver1000 = 0;
$fltTotalGiftsOver10000 = 0;
$fltTotalAverageGiftSize = 0;
$fltTotalGiftAmount = 0;
$fltTotalGivers = 0;
$objDataGridArray = array();
$objMonthlyTotal = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$objMonthlyCount = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$objOver1000 = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$objOver10000 = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$objUniqueGiver = array(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
$objGiverCount = array(array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array());
$objGiverList = array();
while ($objContribution = StewardshipContribution::InstantiateCursor($objContributionCursor)) {
$objContributionAmtArray = StewardshipContributionAmount::LoadArrayByStewardshipContributionId($objContribution->Id);
foreach ($objContributionAmtArray as $objContributionAmt) {
$strAccountNumber = StewardshipFund::Load($objContributionAmt->StewardshipFundId)->AccountNumber;
if ($strAccountNumber == '7011.010' || substr($strAccountNumber, 0, 1) == '4') {
$iMonth = 0;
$fltTotalGiftAmount += $objContributionAmt->Amount;
$fltTotalGifts++;
if ($objContribution->DateCredited->IsLaterOrEqualTo(new QDateTime("1/1/" . $intYear)) && $objContribution->DateCredited->IsEarlierThan(new QDateTime("2/1/" . $intYear))) {
$iMonth = 0;
} else {
if ($objContribution->DateCredited->IsLaterOrEqualTo(new QDateTime("2/1/" . $intYear)) && $objContribution->DateCredited->IsEarlierThan(new QDateTime("3/1/" . $intYear))) {
$iMonth = 1;
} else {
if ($objContribution->DateCredited->IsLaterOrEqualTo(new QDateTime("3/1/" . $intYear)) && $objContribution->DateCredited->IsEarlierThan(new QDateTime("4/1/" . $intYear))) {
$iMonth = 2;
public function btnCalculateTotal_Click()
{
$this->CalculateQuery($objCondition, $objClauses, $blnQueried);
if ($blnQueried) {
$objContributionCursor = StewardshipContribution::QueryCursor($objCondition, $objClauses);
$fltTotal = 0.0;
while ($objContribution = StewardshipContribution::InstantiateCursor($objContributionCursor)) {
// We need to look at a specific fund, if that was specified
if ($this->lstFund->SelectedValue) {
foreach ($objContribution->GetStewardshipContributionAmountArray() as $objAmount) {
if ($objAmount->StewardshipFundId == $this->lstFund->SelectedValue) {
$fltTotal += $objAmount->Amount;
}
}
} else {
$fltTotal += $objContribution->TotalAmount;
}
}
QApplication::DisplayAlert('Total: ' . QApplication::DisplayCurrency($fltTotal));
} else {
QApplication::DisplayAlert('No query was specified.');
}
$this->btnCalculateTotal->Display = true;
$this->btnCalculateLabel->Display = false;
}
