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