/** * Override parent */ public function get_by($where, $joins = array()) { $this->set_table_alias('u'); $this->db->select('u.id, u.email, u.password, u.first_name, u.last_name, u.active, ug.name AS group'); $joins[] = array('user_groups AS ug', 'u.group_id = ug.id'); return parent::get_by($where, $joins); }
public function get_provinsi_id($id) { $data = array(); $this->db->order_by('lokasi_ID', 'esc'); $data = parent::get_by(array('lokasi_kabupatenkota' => 0, 'lokasi_kecamatan' => 0, 'lokasi_kelurahan' => 0, 'lokasi_propinsi' => $id)); return $data; }
public function get_with_join($id = NULL, $single = FALSE) { $this->db->select("packages.*, l.title as package_location, c.title as package_category,s.title as package_scheme,h.title as package_hotel,t.title as package_transport,m.file_name as media_image"); $this->db->join("locations as l", "packages.location_id=l.id", 'left'); $this->db->join("category as c", "packages.category_id=c.id", 'left'); $this->db->join("schemes as s", "packages.scheme_id=s.id", 'left'); $this->db->join("hotels as h", "packages.hotel_id=h.id", 'left'); $this->db->join("transports as t", "packages.transport_id=t.id", 'left'); $this->db->join("medias as m", "packages.image=m.id", 'left'); if ($id) { $where = array('packages.id' => $id); return parent::get_by($where, $single); } else { return parent::get(); } }
public function run($params = array()) { //dump($params); $this->db->select("packages.*, l.title as package_location,\n c.title as package_category,s.title as package_scheme,\n h.title as package_hotel,t.title as package_transport,\n m.file_name as media_image"); $this->db->join("locations as l", "packages.location_id=l.id", 'left'); $this->db->join("category as c", "packages.category_id=c.id", 'left'); $this->db->join("schemes as s", "packages.scheme_id=s.id", 'left'); $this->db->join("hotels as h", "packages.hotel_id=h.id", 'left'); $this->db->join("transports as t", "packages.transport_id=h.id", 'left'); $this->db->join("medias as m", "packages.image=m.id", 'left'); if (isset($params['category_id'])) { $where = array('packages.category_id' => $params['category_id']); $ARRs = parent::get_by($where); } else { $ARRs = parent::get(); } //isset($params['category_id']) ? $where = array('packages.category_id'=>$params['category_id']) : NULL; $str = ''; //dump($ARRs); foreach ($ARRs as $package) { $str .= '<div class="destination-places-grids">'; $str .= '<div class="destination-places-grid last-d-grid" onclick="location.href=\'/package/' . $package->id . '\';">'; $str .= '<div class="dest-place-pic main_box user_style4" data-hipop="two-horizontal">'; $str .= '<img src="' . base_url('wc-upload/gallery') . '/' . $package->media_image . '" title="' . $package->title . '" width="480" height="180" />'; $str .= '<a href="#" class="popup"> </a>'; $str .= '<a href="#" class="popup2"> </a>'; $str .= '</div>'; $str .= '<div class="dest-place-opt">'; $str .= '<ul class="dest-place-opt-fea">'; $str .= '<li><a class="hot" href="#"><span> </span>' . $package->package_hotel . '</a></li>'; $str .= '<li><a class="plain" href="#"><span> </span>' . $package->package_transport . '</a></li>'; $str .= '<li><a class="Breakfast" href="#"><span> </span>' . $package->package_scheme . '</a></li>'; $str .= '<div class="clear"></div>'; $str .= '</ul>'; $str .= '<ul class="dest-place-opt-cast">'; $str .= '<li><a class="d-place" href="#">' . $package->package_location . '</a></li>'; $str .= '<li><a class="d-price" href="#">Starting Form ' . $package->price . '</a></li>'; $str .= '<div class="clear"></div>'; $str .= '</ul>'; $str .= '</div>'; $str .= '</div>'; } $str .= '<div class="clear"></div>'; $str .= '</div>'; return $str; }
public function run($params = array()) { //dump($params); $this->db->select("locations.*, c.title as package_category,m.file_name as media_image"); $this->db->join("category as c", "locations.category_id=c.id", 'left'); $this->db->join("medias as m", "locations.image=m.id", 'left'); if (isset($params['category_id'])) { $where = array('locations.category_id' => $params['category_id']); $ARRs = parent::get_by($where); } else { $ARRs = parent::get(); } //isset($params['category_id']) ? $where = array('packages.category_id'=>$params['category_id']) : NULL; $str = ''; //dump($ARRs); foreach ($ARRs as $package) { $str .= '<div class="destination-places-grids">'; $str .= '<div class="destination-places-grid last-d-grid" onclick="location.href=\'/location/' . $package->id . '\';">'; $str .= '<div class="dest-place-pic main_box user_style4" data-hipop="two-horizontal">'; $str .= '<img src="' . base_url('wc-upload/gallery') . '/' . $package->media_image . '" title="' . $package->title . '" width="480" height="180" />'; $str .= '<a href="#" class="popup"> </a>'; $str .= '<a href="#" class="popup2"> </a>'; $str .= '</div>'; $str .= '<div class="dest-place-opt">'; $str .= '<ul class="dest-place-opt-cast">'; $str .= '<li><a class="d-place" href="#">' . $package->package_category . ' : </a></li>'; $str .= '<li><a class="d-place" href="#"> : ' . $package->title . '</a></li>'; $str .= '<div class="clear"></div>'; $str .= '</ul>'; $str .= '</div>'; $str .= '</div>'; } $str .= '<div class="clear"></div>'; $str .= '</div>'; return $str; }
public function get_archive_link() { $page = parent::get_by(array('template' => 'news_archive'), TRUE); return isset($page->slug) ? $page->slug : ''; }
public function get_topic_forum($topicID = 0) { $this->_table = 'forum_topics'; return parent::get_by('id', $topicID); }
public function get_id_from_slug($slug) { $data = parent::get_by('slug', $slug); return $data->id; }
/** * Get rows where the key matches value * * @param string $key Which column to use on WHERE * @param string $value Value for $key to match * @param string $where_extra Extra clauses for WHERE * @return array DB results. If LIMIT is 1, row_array(); otherwise result_array() */ public function get_by($key = '', $value = '', $where_extra = '') { $where_extra .= $this->sch_sql(); return parent::get_by($key, $value, $where_extra); }