function select()
{
if (!$this->_preConstrained) {
parent::select();
} else {
$columns = array('from_date' => ts('From date'), 'to_date' => ts('To Date'), 'renewed' => ts('Renewals'), 'lapsed' => ts('Lapsed'));
foreach ($columns as $column => $title) {
$select[] = " {$column} ";
$this->_columnHeaders[$column] = array('title' => $title);
}
$this->_select = " SELECT " . implode(', ', $select);
}
}
function select()
{
if (!$this->_preConstrained) {
parent::select();
} else {
$columns = array('from_date' => ts('From date'), 'to_date' => ts('To Date'), 'renewed' => ts('Renewed'), 'recovered' => ts('Re-activated'), 'new' => ts('New'));
foreach ($columns as $column => $title) {
$select[] = " {$column} ";
$this->_columnHeaders[$column] = array('title' => $title);
}
$select[] = 'range_name';
$this->_select = " SELECT " . implode(', ', $select);
}
}
function select()
{
if (!$this->_preConstrained) {
parent::select();
} else {
$thisYear = FALSE;
if (strtotime($this->_params['receive_date_from']) >= strtotime('last day of december last year')) {
$thisYear = TRUE;
}
$columns = array('description' => ts(''), 'this_year' => $thisYear ? ts('This Year') : ts('Main Date Range'), 'percent_change' => ts('Percent Change'), 'last_year' => $thisYear ? ts('Last Year') : ts('One year Prior Range'));
foreach ($columns as $column => $title) {
$select[] = " {$column} ";
$this->_columnHeaders[$column] = array('title' => $title);
}
$this->_select = " SELECT " . implode(', ', $select);
}
}
function select()
{
parent::select();
}
