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