public function get_all()
{
$this->db->select('stories.id, type, headline, state, story, views, image, media, anonymous, user_id, upvote, downvote, date_created, date_modified, status, users.username, users.first_name, users.last_name');
$this->db->join('users', 'stories.user_id = users.id', 'full');
$this->db->order_by('stories.date_created desc');
return parent::get_all();
}
/**
* Get all galleries along with the total number of photos in each gallery
*
* @author Yorick Peterse - PyroCMS Dev Team
* @access public
* @return mixed
*/
public function get_all()
{
$this->db
->select('galleries.*, file_folders.slug as folder_slug, file_folders.name as folder_name')
->join('file_folders', 'file_folders.id = galleries.folder_id', 'left');
$galleries = parent::get_all();
$results = array();
// Loop through each gallery and add the count of photos to the results
foreach ($galleries as $gallery)
{
$count = $this->db
->select('files.id')
->join('galleries', 'galleries.folder_id = files.folder_id', 'left')
->where('files.type', 'i')
->where('galleries.id', $gallery->id)
->count_all_results('files');
$gallery->photo_count = $count;
$results[] = $gallery;
}
// Return the results
return $results;
}
/**
* Return an array of groups
*
*
* @param array $params Optional parameters
* @return array
*/
public function get_all($params = array())
{
if (isset($params['except'])) {
$this->db->where_not_in('name', $params['except']);
}
return parent::get_all();
}
public function get_one()
{
$new = array();
$this->db->limit(1);
$this->db->order_by('create_date', 'desc');
$new = parent::get_all();
return $new[0];
}
public function get_all()
{
$this->db->select('comments.*');
$this->db->select('IF(comments.user_id > 0, IF(u.last_name = "", u.first_name, CONCAT(u.first_name, " ", u.last_name)), comments.name) as name');
$this->db->select('IF(comments.user_id > 0, u.email, comments.email) as email');
$this->db->join('users u', 'comments.user_id = u.id', 'left');
return parent::get_all();
}
public function get_all()
{
$result = parent::get_all();
if ($result) {
array_map(array($this, 'unserialize_fields'), $result);
}
return $result;
}
/**
* Returns an array with currently all modules registered in database
* @return array Array with module names
*/
public function list_db_modules()
{
$modulesDb = parent::get_all();
$dbModules = array();
foreach ($modulesDb as $mod) {
$dbModules[] = $mod->link;
}
return $dbModules;
}
function get_all()
{
$this->db->select('profiles.*, users.*, g.description as group_name, IF(profiles.last_name = "", profiles.first_name, CONCAT(profiles.first_name, " ", profiles.last_name)) as full_name')
->join('groups g', 'g.id = users.group_id')
->join('profiles', 'profiles.user_id = users.id', 'left');
$this->db->group_by('users.id');
return parent::get_all();
}
public function get_promokelas()
{
$this->db->select('promote.idpromo, class.title as "nmclass", class.price, promote.discount, promote.start_date, promote.end_date, promote.description as "desc", promote.title as "prom", foto_produk.thumb');
$this->db->join('class', 'promote.idclass = class.idclass', 'left');
$this->db->join('foto_produk', 'promote.idclass = foto_produk.idclass', 'left');
$this->db->where('promote.end_date >=', date('Y-m-d'));
$this->db->where('promote.status', 1);
$this->db->group_by('promote.idpromo');
return parent::get_all();
}
function get_all()
{
$this->db
->select($this->profile_table.'.*, g.description as group_name, users.*')
->select('IF('.$this->profile_table.'.last_name = "", '.$this->profile_table.'.first_name, CONCAT('.$this->profile_table.'.first_name, " ", '.$this->profile_table.'.last_name)) as full_name', FALSE)
->join('groups g', 'g.id = users.group_id')
->join('profiles', 'profiles.user_id = users.id', 'left')
->group_by('users.id');
return parent::get_all();
}
/**
* Get all members
*
* @author Buonzz
* @access public
* @return mixed
*/
public function get_all()
{
$members = parent::get_all();
$results = array();
// Loop through each member
foreach ($members as $member) {
$results[] = $member;
}
// Return the results
return $results;
}
/**
* Gets all matches
* @param boolean $all If false gets all matches that are not upcoming
* @return object Object with match results
*/
public function get_matches($all = TRUE)
{
if ($all) {
parent::order_by('date', 'DESC');
return parent::get_all();
} else {
parent::order_by('date', 'DESC');
$this->db->select('*');
$this->db->where('status !=', '1');
return $this->db->get('matches')->result();
}
}
public function get_active_forum_labels()
{
$this->_table = 'forum_forums';
$labels = array();
$forums = parent::get_all();
foreach ($forums as $forum) {
if (!in_array($forum->label, $labels)) {
$labels[] = $forum->label;
}
}
return $labels;
}
/**
* Get Pam Module settings.
*
* Takes the work out of grabbing the settings whenever
* we need them. Will also return a single value if
* needed.
*
* @param str $field The settings field to retrieve.
* @return array / str
*/
public function get_settings($field = null)
{
// return value of a single setting
if ($field) {
$settings = parent::get_all();
$settings = $settings[0];
$result = property_exists($settings, $field) ? $settings->{$field} : 'Invalid field.';
} else {
$settings = parent::get_all();
$result = $settings[0];
}
return $result;
}
/**
* Get all galleries along with the total number of photos in each gallery
*
* @author Yorick Peterse - PyroCMS Dev Team
* @access public
* @return mixed
*/
public function get_all()
{
$galleries = parent::get_all();
$results = array();
// Loop through each gallery and add the count of photos to the results
foreach ($galleries as $gallery) {
$count = $this->db->select('id')->where('gallery_id', $gallery->id)->count_all_results('gallery_images');
$gallery->photo_count = $count;
$results[] = $gallery;
}
// Return the results
return $results;
}
public function get_all()
{
$this->db->order_by('slide_order');
return parent::get_all();
}
public function get_slugs()
{
$this->db->select('comments.module, modules.name')->distinct()->join('modules', 'comments.module = modules.slug', 'left');
$slugs = parent::get_all();
$options = array();
if (!empty($slugs)) {
foreach ($slugs as $slug) {
if (!$slug->name && ($pos = strpos($slug->module, '-')) !== FALSE) {
$slug->ori_module = $slug->module;
$slug->module = substr($slug->module, 0, $pos);
}
if (!$slug->name && ($module = $this->module_m->get_by('slug', plural($slug->module)))) {
$slug->name = $module->name;
}
//get the module name
if ($slug->name and $module_names = unserialize($slug->name)) {
if (array_key_exists(CURRENT_LANGUAGE, $module_names)) {
$slug->name = $module_names[CURRENT_LANGUAGE];
} else {
$slug->name = $module_names['en'];
}
if (isset($slug->ori_module)) {
$options[$slug->ori_module] = $slug->name . " ({$slug->ori_module})";
} else {
$options[$slug->module] = $slug->name;
}
} else {
if (isset($slug->ori_module)) {
$options[$slug->ori_module] = $slug->ori_module;
} else {
$options[$slug->module] = $slug->module;
}
}
}
}
asort($options);
return $options;
}
public function get_all($book_id = null, $type = null, $category = null, $is_live = true, $version_datetime = null)
{
return parent::get_all($this->annotations_table, $book_id, $type, $category, $is_live, $version_datetime);
}
function get_all()
{
$this->db->select('users.*, pr.title as role_title, IF(last_name = "", first_name, CONCAT(first_name, " ", last_name)) as full_name')->join('permission_roles pr', 'pr.abbrev = users.role');
return parent::get_all();
}
/**
* Get all user objects
*
* @return object
*/
public function get_all()
{
$this->db->select($this->profile_table . '.*, g.description as group_name, users.*')->join('groups g', 'g.id = users.group_id')->join('profiles', 'profiles.user_id = users.id', 'left')->group_by('users.id');
return parent::get_all();
}
function get_all()
{
$this->db->select('profiles.*, users.*, pr.title as role_title, IF(profiles.last_name = "", profiles.first_name, CONCAT(profiles.first_name, " ", profiles.last_name)) as full_name')->join('groups pr', 'pr.id = users.group_id')->join('profiles', 'profiles.user_id = users.id', 'left');
$this->db->group_by('users.id');
return parent::get_all();
}
public function get_all($fields = '', $where = array())
{
$fields_hack = '*,(SELECT image_path FROM product_images pi WHERE pi.featured = 1 AND pi.product_id = products.product_id) featured_image';
return parent::get_all($fields_hack, $where);
}
