Display categories and subcategories

handoyo · October 5th, 2009, 12:03 AM

Hi all,i'm trying to display the categories and the subcategories like this on the admin product page category dropdown

clothes
--shoes
--shirts
etc.
fun
--toys
--games

also the parent cannot be choosed..What should i do to achieve it?Thanks...

myerman · October 6th, 2009, 07:02 PM

look in the mcats model...there should be a function called getCategoriesNav()...I think this grabs all the categories and builds a multidimensional array that you can process....I think that's right. I'm on my way out the door so I may be smokin' the hookah again. :)

Code:

function getCategoriesNav(){
     $data = array();
     $this->db->select('id,name,parentid');
     $this->db->where('status', 'active');
     $this->db->orderby('parentid','asc');
     $this->db->orderby('name','asc');
     $this->db->groupby('parentid,id');
     $Q = $this->db->get('categories');
     if ($Q->num_rows() > 0){
       foreach ($Q->result() as $row){
			if ($row->parentid > 0){
				$data[0][$row->parentid]['children'][$row->id] = $row->name;
			
			}else{
				$data[0][$row->id]['name'] = $row->name;
			}
		}
    }
    $Q->free_result(); 
    return $data; 
 }

handoyo · October 6th, 2009, 11:46 PM

Thanks myerman..By the way,how to change it to so i can use it to dropdown?

myerman · October 7th, 2009, 08:04 AM

In the same model there is a function called getCategoriesDropDown() which should do what you're describing.

Code:

 function getCategoriesDropDown(){
     $data = array();
     $this->db->select('id,name');
     $this->db->where('parentid !=',0);
     $Q = $this->db->get('categories');
     if ($Q->num_rows() > 0){
       foreach ($Q->result_array() as $row){
         $data[$row['id']] = $row['name'];
       }
    }
    $Q->free_result();  
    return $data; 
 }

handoyo · October 7th, 2009, 08:35 AM

Is'n it the same with the default one on admin/products/create controller?Thanks..

myerman · October 7th, 2009, 08:42 AM

No, that one calls the addProduct() function over in MProducts model

handoyo · October 7th, 2009, 11:35 AM

I'll try it myerman..Thanks..