public function get_dropdown_list($default_title = '')
{
$sql = "SELECT id, CONCAT(first_name, ' ', last_name) AS title " . " FROM #__staff " . " ORDER BY last_name, first_name";
// echo $sql;exit;
$query = $this->db->query($sql);
return parent::_generate_dropdown_list($query->result(), $default_title);
}
public function get_dropdown_list($default_title = '')
{
$sql = "SELECT id, title " . " FROM #__user_group " . " ORDER BY title";
$query = $this->db->query($sql);
return parent::_generate_dropdown_list($query->result(), $default_title);
}
public function get_dropdown_list($default_title = '')
{
$sql = "SELECT id, fist_name AS title " . " FROM #__register " . " ORDER BY first_name";
$query = $this->db->query($sql);
return parent::_generate_dropdown_list($query->result(), $default_title);
}
public function get_dropdown_list($default_title = '')
{
$sql = "SELECT number, CONCAT('number, ' - ', location) AS title " . " FROM #__postal_district " . " ORDER BY number";
$query = $this->db->query($sql);
return parent::_generate_dropdown_list($query->result(), $default_title);
}
public function get_dropdown_list($default_title = '')
{
$sql = "SELECT id, name AS title " . " FROM #__site " . " WHERE is_published = 'True'" . " ORDER BY name";
$query = $this->db->query($sql);
return parent::_generate_dropdown_list($query->result(), $default_title);
}
public function get_owner_type_dropdown_list($default_title = '')
{
$result = array('None' => 'None', 'Participant' => 'Participant', 'Worksite' => 'Worksite', 'Company' => 'Company');
return parent::_generate_dropdown_list($result, $default_title);
}
