'-----------------'); protected $class; protected $style; protected $category; protected $tree; protected $level; protected $child_nodes; function __construct(& $crud_obj = null, $config = null) { if (!isset($crud_obj) or !isset($config)) return false; $this->ci = & get_instance(); $this->grocery_crud_obj = $crud_obj; foreach ($config as $k => $v) { $this->$k = $v; } $segs = $this->ci->uri->segment_array(); if (in_array($this->segment_name, $segs)) $this->category = $segs[(array_search($this->segment_name, $segs) + 1)]; } function get_tree() { if (isset($this->parent_field)) return $this->adjacency_list_r(0, 0); else return $this->get_categories(); } function get_categories() { $this->ci->db->select($this->categories_primary_key . ',' . $this->related_title_field); if($this->order_by) $this->ci->db->order_by($this->order_by); return $this->ci->db->get($this->related_table)->result_array(); } function adjacency_list_r($parent = 0, $level = 0) { $this->level = $level; $this->level++; if($this->order_by) $this->ci->db->order_by($this->order_by); $query = $this->ci->db->get_where($this->related_table, array($this->parent_field => $parent)); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { $row['level'] = $this->level; $this->tree[] = $row; $this->adjacency_list_r($row[$this->categories_primary_key], $this->level); $this->level--; } } return $this->tree; } function get_child_nodes_r($parent = 0) { $this->ci->db->select($this->categories_primary_key); $query = $this->ci->db->get_where($this->related_table, array($this->parent_field => $parent)); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { $this->child_nodes[] = $row[$this->categories_primary_key]; $this->get_child_nodes_r($row[$this->categories_primary_key]); } } return $this->child_nodes; } function create_select() { $this->set_where(); $categories = $this->get_tree(); $select= '

'; $select.= ' '; $select.='

'; $select.= ''; $select.='

'; $select.='

'; return $select; } // for a grocerycrud object function set_where() { if (isset($this->category)) { if (isset($this->parent_field)) { $categories = $this->get_child_nodes_r($this->category); $categories[] = $this->category; $in = NUll; foreach ($categories as $item) $in.= $this->ci->db->escape($item) . ","; $in = substr($in, 0, -1); $where = "`$this->table_name`.`" . $this->sort_field . "` IN(" . $in . ")"; $this->grocery_crud_obj->where($where); } else { $this->grocery_crud_obj->where($this->table_name . '.' . $this->sort_field, $this->category); } } } function render() { $dd = $this->get_dropdown(); $output = $this->grocery_crud_obj->render(); $output->output = $dd . $output->output; return $output; } function get_dropdown() { $select = ''; $state = $this->grocery_crud_obj->getState(); if ($state != 'edit' && $state != 'add') { $select = $this->create_select(); } return $select; } }