/** * 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; }