1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / sumontech.com / application / models /
Filename : Menu_model.php
back
<?php 
/**
*   this is user controller model
*/
class Menu_model extends CI_Model{

    public $user_id;
    
    function __construct()
    {
        parent::__construct();
        $this->user_id = $this->session->userdata('u_session')['id'];
    }

    //get_menu_type
    public function get_menu_type()
    {
        $query = $this->db->query(" SELECT id,name
                                    FROM portfolio_menu
                                    WHERE parent_id=0
                                ");
        return $query->result_array();

    } 

    //get_parent_name
    public function get_parent_name($parent_id)
    {
        $query = $this->db->query("SELECT name FROM portfolio_menu WHERE id='$parent_id' ");
        $row = $query->row_array();  
        return $row['name'] ; 

    }// end get_type_category 

    //create_new_menu
    public function create_new_menu(){
        if($_POST)
        {
            $data['user_id'] = $this->user_id; 
            $active = $this->input->post("active");
            if($active){ $data['active']=$active; }else{ $data['active']=0 ; }
            $data['parent_id'] = $this->input->post("parent"); 
            $data['name'] = $this->input->post("mname"); 
            $data['menuattr'] = $this->input->post("menuattr"); 
            $data['menu_url'] = $this->input->post("menuurl"); 
            $data['order_by'] = $this->input->post("morder"); 
            $data['description'] = $this->input->post("menudesc"); 

            if($this->db->insert("portfolio_menu",$data)){
                return TRUE; 
            }
        }           
    }


    // get_menus
    public function get_menus(){
        $query = $this->db->query("SELECT m.id,m.name,m.menuattr,m.menu_url,m.order_by,m.description,m.parent_id,m.date,m.active, u.username 
                                    FROM portfolio_menu m, portfolio_user u 
                                    WHERE m.user_id=u.id
                                    ORDER BY m.order_by ASC ");
        return $query->result_array();        
    }
   
    // get_menu_data
    public function get_menu_data($id){
        $query = $this->db->get_where("portfolio_menu",array('id'=>$id));
        return $query->row_array();        
    }

    // /update_menu
    public function update_menu(){
        if($_POST)
        { 
            $m_id = $this->input->post("m_id");  
            $data['user_id'] = $this->user_id; 
            $active = $this->input->post("active");
            if($active){ $data['active']=$active; }else{ $data['active']=0 ; }
            $data['parent_id'] = $this->input->post("parent"); 
            $data['name'] = $this->input->post("mname"); 
            $data['menuattr'] = $this->input->post("menuattr"); 
            $data['menu_url'] = $this->input->post("menuurl"); 
            $data['order_by'] = $this->input->post("morder"); 
            $data['description'] = $this->input->post("menudesc");            

            $this->db->where(array('id' => $m_id));
            if($this->db->update('portfolio_menu', $data)){
                return TRUE;
            }
        }           
    }
   


   


}