public function dtgFunds_Unposted_Bind()
{
$fltArray = $this->objBatch->GetUnpostedBalanceByStewardshipFundId();
if (count($fltArray)) {
$strArrayArray = array();
foreach ($fltArray as $intStewardshipFundId => $fltAmount) {
$strArray = array(StewardshipFund::Load($intStewardshipFundId)->Name, QApplication::DisplayCurrencyHtml($fltAmount));
$strArrayArray[] = $strArray;
}
$this->dtgFunds->DataSource = $strArrayArray;
}
}
protected function Form_Create()
{
$this->lstYear = new QListBox($this);
for ($intYear = 2002; $intYear <= date('Y'); $intYear++) {
$this->lstYear->AddItem($intYear, $intYear, QApplication::PathInfo(0) ? QApplication::PathInfo(0) == $intYear : $intYear == QDateTime::Now()->Year);
}
$this->lstMonth = new QListBox($this);
for ($intMonth = 1; $intMonth <= 12; $intMonth++) {
$dttDate = new QDateTime('2000-' . $intMonth . '-01');
$this->lstMonth->AddItem($dttDate->ToString('MMMM'), $intMonth, QApplication::PathInfo(1) ? QApplication::PathInfo(1) == $intMonth : $intMonth == QDateTime::Now()->Month);
}
$this->lstYear->AddAction(new QChangeEvent(), new QAjaxAction('lstDate_Change'));
$this->lstMonth->AddAction(new QChangeEvent(), new QAjaxAction('lstDate_Change'));
$this->dtgReport = new QDataGrid($this);
$this->dtgReport->AddColumn(new QDataGridColumn('Fund', '<?= $_FORM->RenderRow($_ITEM); ?><?= StewardshipFund::Load($_ITEM[0])->Name; ?>', 'Width=400px'));
$this->dtgReport->AddColumn(new QDataGridColumn('Monthly Total', '<?= QApplication::DisplayCurrency($_ITEM[1]); ?>', 'Width=400px'));
$this->dtgReport->AddColumn(new QDataGridColumn('YTD', '<?= QApplication::DisplayCurrency($_ITEM[2]); ?>', 'Width=400px'));
$this->dttDate = new QDateTime($this->lstYear->SelectedValue . '-' . $this->lstMonth->SelectedValue . '-01');
$this->dttDate->SetTime(null, null, null);
// Get the Data
$objReportArray = StewardshipPost::GetReportByFundAndMonth($this->dttDate);
$objReportYtdArray = StewardshipPost::GetReportYtdByFundForMonth($this->dttDate);
// Setup the data holders
$this->fltTotal = 0;
$this->fltTotalYtd = 0;
$objArray = array();
foreach ($objReportArray as $objLineItem) {
$objFund = StewardshipFund::Load($objLineItem[0]);
if ($objFund->AccountNumber == '7011.010' || substr($objFund->AccountNumber, 0, 1) == '4') {
$this->fltTotal += $objLineItem[1];
$objArray[$objLineItem[0]] = array($objLineItem[0], $objLineItem[1], null);
}
}
foreach ($objReportYtdArray as $objLineItem) {
$objFund = StewardshipFund::Load($objLineItem[0]);
if ($objFund->AccountNumber == '7011.010' || substr($objFund->AccountNumber, 0, 1) == '4') {
$this->fltTotalYtd += $objLineItem[1];
if (array_key_exists($objLineItem[0], $objArray)) {
$objArray[$objLineItem[0]][2] = $objLineItem[1];
} else {
$objArray[$objLineItem[0]] = array($objLineItem[0], null, $objLineItem[1]);
}
}
}
// Bind the data
$this->dtgReport->DataSource = $objArray;
}
/**
* Override method to perform a property "Get"
* This will get the value of $strName
*
* @param string $strName Name of the property to get
* @return mixed
*/
public function __get($strName)
{
switch ($strName) {
///////////////////
// Member Variables
///////////////////
case 'Id':
// Gets the value for intId (Read-Only PK)
// @return integer
return $this->intId;
case 'SignupEntryId':
// Gets the value for intSignupEntryId (Not Null)
// @return integer
return $this->intSignupEntryId;
case 'SignupPaymentTypeId':
// Gets the value for intSignupPaymentTypeId (Not Null)
// @return integer
return $this->intSignupPaymentTypeId;
case 'TransactionDate':
// Gets the value for dttTransactionDate
// @return QDateTime
return $this->dttTransactionDate;
case 'TransactionDescription':
// Gets the value for strTransactionDescription
// @return string
return $this->strTransactionDescription;
case 'Amount':
// Gets the value for fltAmount
// @return double
return $this->fltAmount;
case 'FundingAccount':
// Gets the value for strFundingAccount
// @return string
return $this->strFundingAccount;
case 'DonationStewardshipFundId':
// Gets the value for intDonationStewardshipFundId
// @return integer
return $this->intDonationStewardshipFundId;
case 'AmountDonation':
// Gets the value for fltAmountDonation
// @return double
return $this->fltAmountDonation;
case 'AmountNonDonation':
// Gets the value for fltAmountNonDonation
// @return double
return $this->fltAmountNonDonation;
case 'CreditCardPaymentId':
// Gets the value for intCreditCardPaymentId (Unique)
// @return integer
return $this->intCreditCardPaymentId;
///////////////////
// Member Objects
///////////////////
///////////////////
// Member Objects
///////////////////
case 'SignupEntry':
// Gets the value for the SignupEntry object referenced by intSignupEntryId (Not Null)
// @return SignupEntry
try {
if (!$this->objSignupEntry && !is_null($this->intSignupEntryId)) {
$this->objSignupEntry = SignupEntry::Load($this->intSignupEntryId);
}
return $this->objSignupEntry;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'DonationStewardshipFund':
// Gets the value for the StewardshipFund object referenced by intDonationStewardshipFundId
// @return StewardshipFund
try {
if (!$this->objDonationStewardshipFund && !is_null($this->intDonationStewardshipFundId)) {
$this->objDonationStewardshipFund = StewardshipFund::Load($this->intDonationStewardshipFundId);
}
return $this->objDonationStewardshipFund;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'CreditCardPayment':
// Gets the value for the CreditCardPayment object referenced by intCreditCardPaymentId (Unique)
// @return CreditCardPayment
try {
if (!$this->objCreditCardPayment && !is_null($this->intCreditCardPaymentId)) {
$this->objCreditCardPayment = CreditCardPayment::Load($this->intCreditCardPaymentId);
}
return $this->objCreditCardPayment;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
case '__Restored':
return $this->__blnRestored;
default:
try {
return parent::__get($strName);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
}
/**
* Static Helper Method to Create using PK arguments
* You must pass in the PK arguments on an object to load, or leave it blank to create a new one.
* If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo
* static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to
* edit, or if we are also allowed to create a new one, etc.
*
* @param mixed $objParentObject QForm or QPanel which will be using this StewardshipFundMetaControl
* @param integer $intId primary key value
* @param QMetaControlCreateType $intCreateType rules governing StewardshipFund object creation - defaults to CreateOrEdit
* @return StewardshipFundMetaControl
*/
public static function Create($objParentObject, $intId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit)
{
// Attempt to Load from PK Arguments
if (strlen($intId)) {
$objStewardshipFund = StewardshipFund::Load($intId);
// StewardshipFund was found -- return it!
if ($objStewardshipFund) {
return new StewardshipFundMetaControl($objParentObject, $objStewardshipFund);
} else {
if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) {
throw new QCallerException('Could not find a StewardshipFund object with PK arguments: ' . $intId);
}
}
// If EditOnly is specified, throw an exception
} else {
if ($intCreateType == QMetaControlCreateType::EditOnly) {
throw new QCallerException('No PK arguments specified');
}
}
// If we are here, then we need to create a new record
return new StewardshipFundMetaControl($objParentObject, new StewardshipFund());
}
/**
* Override method to perform a property "Get"
* This will get the value of $strName
*
* @param string $strName Name of the property to get
* @return mixed
*/
public function __get($strName)
{
switch ($strName) {
///////////////////
// Member Variables
///////////////////
case 'Id':
// Gets the value for intId (Read-Only PK)
// @return integer
return $this->intId;
case 'StewardshipContributionId':
// Gets the value for intStewardshipContributionId (Not Null)
// @return integer
return $this->intStewardshipContributionId;
case 'StewardshipFundId':
// Gets the value for intStewardshipFundId (Not Null)
// @return integer
return $this->intStewardshipFundId;
case 'Amount':
// Gets the value for fltAmount
// @return double
return $this->fltAmount;
///////////////////
// Member Objects
///////////////////
///////////////////
// Member Objects
///////////////////
case 'StewardshipContribution':
// Gets the value for the StewardshipContribution object referenced by intStewardshipContributionId (Not Null)
// @return StewardshipContribution
try {
if (!$this->objStewardshipContribution && !is_null($this->intStewardshipContributionId)) {
$this->objStewardshipContribution = StewardshipContribution::Load($this->intStewardshipContributionId);
}
return $this->objStewardshipContribution;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'StewardshipFund':
// Gets the value for the StewardshipFund object referenced by intStewardshipFundId (Not Null)
// @return StewardshipFund
try {
if (!$this->objStewardshipFund && !is_null($this->intStewardshipFundId)) {
$this->objStewardshipFund = StewardshipFund::Load($this->intStewardshipFundId);
}
return $this->objStewardshipFund;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
case '__Restored':
return $this->__blnRestored;
default:
try {
return parent::__get($strName);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
}
$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;
} else {
if ($objContribution->DateCredited->IsLaterOrEqualTo(new QDateTime("4/1/" . $intYear)) && $objContribution->DateCredited->IsEarlierThan(new QDateTime("5/1/" . $intYear))) {
$iMonth = 3;
/**
* Reload this StewardshipFund from the database.
* @return void
*/
public function Reload()
{
// Make sure we are actually Restored from the database
if (!$this->__blnRestored) {
throw new QCallerException('Cannot call Reload() on a new, unsaved StewardshipFund object.');
}
// Reload the Object
$objReloaded = StewardshipFund::Load($this->intId);
// Update $this's local variables to match
$this->MinistryId = $objReloaded->MinistryId;
$this->strName = $objReloaded->strName;
$this->strExternalName = $objReloaded->strExternalName;
$this->strAccountNumber = $objReloaded->strAccountNumber;
$this->strFundNumber = $objReloaded->strFundNumber;
$this->blnActiveFlag = $objReloaded->blnActiveFlag;
$this->blnExternalFlag = $objReloaded->blnExternalFlag;
}
/**
* Override method to perform a property "Get"
* This will get the value of $strName
*
* @param string $strName Name of the property to get
* @return mixed
*/
public function __get($strName)
{
switch ($strName) {
///////////////////
// Member Variables
///////////////////
case 'Id':
// Gets the value for intId (Read-Only PK)
// @return integer
return $this->intId;
case 'SignupFormTypeId':
// Gets the value for intSignupFormTypeId (Not Null)
// @return integer
return $this->intSignupFormTypeId;
case 'MinistryId':
// Gets the value for intMinistryId (Not Null)
// @return integer
return $this->intMinistryId;
case 'Name':
// Gets the value for strName
// @return string
return $this->strName;
case 'Token':
// Gets the value for strToken (Unique)
// @return string
return $this->strToken;
case 'ActiveFlag':
// Gets the value for blnActiveFlag
// @return boolean
return $this->blnActiveFlag;
case 'ConfidentialFlag':
// Gets the value for blnConfidentialFlag
// @return boolean
return $this->blnConfidentialFlag;
case 'Description':
// Gets the value for strDescription
// @return string
return $this->strDescription;
case 'InformationUrl':
// Gets the value for strInformationUrl
// @return string
return $this->strInformationUrl;
case 'SupportEmail':
// Gets the value for strSupportEmail (Not Null)
// @return string
return $this->strSupportEmail;
case 'EmailNotification':
// Gets the value for strEmailNotification
// @return string
return $this->strEmailNotification;
case 'AllowOtherFlag':
// Gets the value for blnAllowOtherFlag
// @return boolean
return $this->blnAllowOtherFlag;
case 'AllowMultipleFlag':
// Gets the value for blnAllowMultipleFlag
// @return boolean
return $this->blnAllowMultipleFlag;
case 'SignupLimit':
// Gets the value for intSignupLimit
// @return integer
return $this->intSignupLimit;
case 'SignupMaleLimit':
// Gets the value for intSignupMaleLimit
// @return integer
return $this->intSignupMaleLimit;
case 'SignupFemaleLimit':
// Gets the value for intSignupFemaleLimit
// @return integer
return $this->intSignupFemaleLimit;
case 'FundingAccount':
// Gets the value for strFundingAccount
// @return string
return $this->strFundingAccount;
case 'DonationStewardshipFundId':
// Gets the value for intDonationStewardshipFundId
// @return integer
return $this->intDonationStewardshipFundId;
case 'DateCreated':
// Gets the value for dttDateCreated (Not Null)
// @return QDateTime
return $this->dttDateCreated;
case 'LoginNotRequiredFlag':
// Gets the value for blnLoginNotRequiredFlag
// @return boolean
return $this->blnLoginNotRequiredFlag;
///////////////////
// Member Objects
///////////////////
///////////////////
// Member Objects
///////////////////
case 'Ministry':
// Gets the value for the Ministry object referenced by intMinistryId (Not Null)
// @return Ministry
try {
if (!$this->objMinistry && !is_null($this->intMinistryId)) {
$this->objMinistry = Ministry::Load($this->intMinistryId);
}
return $this->objMinistry;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'DonationStewardshipFund':
// Gets the value for the StewardshipFund object referenced by intDonationStewardshipFundId
// @return StewardshipFund
try {
if (!$this->objDonationStewardshipFund && !is_null($this->intDonationStewardshipFundId)) {
$this->objDonationStewardshipFund = StewardshipFund::Load($this->intDonationStewardshipFundId);
}
return $this->objDonationStewardshipFund;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'ClassMeeting':
// Gets the value for the ClassMeeting object that uniquely references this SignupForm
// by objClassMeeting (Unique)
// @return ClassMeeting
try {
if ($this->objClassMeeting === false) {
// We've attempted early binding -- and the reverse reference object does not exist
return null;
}
if (!$this->objClassMeeting) {
$this->objClassMeeting = ClassMeeting::LoadBySignupFormId($this->intId);
}
return $this->objClassMeeting;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'EventSignupForm':
// Gets the value for the EventSignupForm object that uniquely references this SignupForm
// by objEventSignupForm (Unique)
// @return EventSignupForm
try {
if ($this->objEventSignupForm === false) {
// We've attempted early binding -- and the reverse reference object does not exist
return null;
}
if (!$this->objEventSignupForm) {
$this->objEventSignupForm = EventSignupForm::LoadBySignupFormId($this->intId);
}
return $this->objEventSignupForm;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
case '_FormProduct':
// Gets the value for the private _objFormProduct (Read-Only)
// if set due to an expansion on the form_product.signup_form_id reverse relationship
// @return FormProduct
return $this->_objFormProduct;
case '_FormProductArray':
// Gets the value for the private _objFormProductArray (Read-Only)
// if set due to an ExpandAsArray on the form_product.signup_form_id reverse relationship
// @return FormProduct[]
return (array) $this->_objFormProductArray;
case '_FormQuestion':
// Gets the value for the private _objFormQuestion (Read-Only)
// if set due to an expansion on the form_question.signup_form_id reverse relationship
// @return FormQuestion
return $this->_objFormQuestion;
case '_FormQuestionArray':
// Gets the value for the private _objFormQuestionArray (Read-Only)
// if set due to an ExpandAsArray on the form_question.signup_form_id reverse relationship
// @return FormQuestion[]
return (array) $this->_objFormQuestionArray;
case '_SignupEntry':
// Gets the value for the private _objSignupEntry (Read-Only)
// if set due to an expansion on the signup_entry.signup_form_id reverse relationship
// @return SignupEntry
return $this->_objSignupEntry;
case '_SignupEntryArray':
// Gets the value for the private _objSignupEntryArray (Read-Only)
// if set due to an ExpandAsArray on the signup_entry.signup_form_id reverse relationship
// @return SignupEntry[]
return (array) $this->_objSignupEntryArray;
case '__Restored':
return $this->__blnRestored;
default:
try {
return parent::__get($strName);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
}
/**
* Override method to perform a property "Get"
* This will get the value of $strName
*
* @param string $strName Name of the property to get
* @return mixed
*/
public function __get($strName)
{
switch ($strName) {
///////////////////
// Member Variables
///////////////////
case 'Id':
// Gets the value for intId (Read-Only PK)
// @return integer
return $this->intId;
case 'PersonId':
// Gets the value for intPersonId (Not Null)
// @return integer
return $this->intPersonId;
case 'StewardshipFundId':
// Gets the value for intStewardshipFundId (Not Null)
// @return integer
return $this->intStewardshipFundId;
case 'DateStarted':
// Gets the value for dttDateStarted
// @return QDateTime
return $this->dttDateStarted;
case 'DateEnded':
// Gets the value for dttDateEnded
// @return QDateTime
return $this->dttDateEnded;
case 'PledgeAmount':
// Gets the value for fltPledgeAmount
// @return double
return $this->fltPledgeAmount;
case 'ContributedAmount':
// Gets the value for fltContributedAmount
// @return double
return $this->fltContributedAmount;
case 'RemainingAmount':
// Gets the value for fltRemainingAmount
// @return double
return $this->fltRemainingAmount;
case 'FulfilledFlag':
// Gets the value for blnFulfilledFlag (Not Null)
// @return boolean
return $this->blnFulfilledFlag;
case 'ActiveFlag':
// Gets the value for blnActiveFlag (Not Null)
// @return boolean
return $this->blnActiveFlag;
///////////////////
// Member Objects
///////////////////
///////////////////
// Member Objects
///////////////////
case 'Person':
// Gets the value for the Person object referenced by intPersonId (Not Null)
// @return Person
try {
if (!$this->objPerson && !is_null($this->intPersonId)) {
$this->objPerson = Person::Load($this->intPersonId);
}
return $this->objPerson;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
case 'StewardshipFund':
// Gets the value for the StewardshipFund object referenced by intStewardshipFundId (Not Null)
// @return StewardshipFund
try {
if (!$this->objStewardshipFund && !is_null($this->intStewardshipFundId)) {
$this->objStewardshipFund = StewardshipFund::Load($this->intStewardshipFundId);
}
return $this->objStewardshipFund;
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
////////////////////////////
// Virtual Object References (Many to Many and Reverse References)
// (If restored via a "Many-to" expansion)
////////////////////////////
case '__Restored':
return $this->__blnRestored;
default:
try {
return parent::__get($strName);
} catch (QCallerException $objExc) {
$objExc->IncrementOffset();
throw $objExc;
}
}
}
