function run()
{
//---------------------------------------------------------------------
//
//---------------------------------------------------------------------
$displayData = array();
$lYear = $displayData['lYear'] = (int) trim($_POST['ddlYear']);
$lACOID = (int) trim($_POST['rdoACO']);
//------------------------------------------------
// libraries and utilities
//------------------------------------------------
$this->load->model('sponsorship/msponsorship', 'clsSpon');
$this->load->model('sponsorship/msponsor_charge_pay', 'clsSCP');
$this->load->model('admin/madmin_aco', 'clsACO');
$this->load->library('util/dl_date_time', '', 'clsDateTime');
$this->load->helper('dl_util/time_date');
$this->load->helper('dl_util/web_layout');
$params = array('enumStyle' => 'terse', 'clsRpt');
$this->load->library('generic_rpt', $params);
//------------------------------------------------
// ACO Info
//------------------------------------------------
$this->clsACO->loadCountries(false, true, true, $lACOID);
$displayData['cACO'] =& $this->clsACO->countries[0];
//------------------------------------------------
// stripes
//------------------------------------------------
$this->load->model('util/mbuild_on_ready', 'clsOnReady');
$this->clsOnReady->addOnReadyTableStripes();
$this->clsOnReady->closeOnReady();
$displayData['js'] = $this->clsOnReady->strOnReady;
//------------------------------------------------
// load a year's worth of charges/payments
//------------------------------------------------
$this->clsSCP->bUseDateRange = true;
$income = array();
for ($idx = 1; $idx <= 12; ++$idx) {
$income[$idx] = new stdClass();
$this->clsSCP->dteStart = dteMonthStart($idx, $lYear);
$this->clsSCP->dteEnd = dteMonthEnd($idx, $lYear);
$income[$idx]->curCharge = $this->clsSCP->curCumulativeChargeVia_ACOID(null, $lACOID);
$income[$idx]->curPay = $this->clsSCP->curCumulativeSponVia_ACOID(false, null, false, null, $lACOID);
}
$displayData['income'] =& $income;
//--------------------------
// breadcrumbs
//--------------------------
$displayData['pageTitle'] = anchor('main/menu/reports', 'Reports', 'class="breadcrumb"') . ' | ' . anchor('reports/pre_spon_income/showOpts', 'Sponsorship Income', 'class="breadcrumb"') . ' | View Report';
$displayData['title'] = CS_PROGNAME . ' | Reports';
$displayData['nav'] = $this->mnav_brain_jar->navData();
$displayData['mainTemplate'] = 'reports/pre_spon_income_rpt_view';
$this->load->vars($displayData);
$this->load->view('template');
}
function strMonthBetween($lMonth, $lYear)
{
//-------------------------------------------------------------------------
// return a string that represents the timespan encompased by a month
// in mySQL date format
//-------------------------------------------------------------------------
$strStartDate = strPrepDateTime(dteMonthStart($lMonth, $lYear));
$strEndDate = strPrepDateTime(dteMonthEnd($lMonth, $lYear));
return $strStartDate . ' AND ' . $strEndDate;
}
