CI框架微信開發(fā)-自定義菜單

2019-11-15 01:58:41

字體：大中小

供稿：網(wǎng)友

CI框架微信開發(fā)-自定義菜單

在CI框架下面實現(xiàn)了自定義菜單功能.寫了一個model,一個類庫.順便附帶 access_token的實現(xiàn)方式

<?phpclass Makemenu{    public $menustr;    public function __construct(){    }    public function init(){        $this->dolist();        return  $this->setmenu();    }    PRivate function dolist(){        $CI =& get_instance();        $CI -> load ->model("Menu_model","menu");        $plist = $CI->menu ->isplist();        foreach($plist as $pid){            $pidarr[] = $pid['pid'];        }        $list = $CI->menu ->maketree($CI->menu->getlist());        foreach($list as $btn){            if(in_array($btn['id'],$pidarr)){                //生成不帶key和url的鏈接作為父級菜單                $btn_arr[$btn['id']] = array("type"=>$btn['menutype'],                                                        "name"=>$btn['content']);            }elseif($btn['pid'] == 0){                //生成有操作的一級菜單                $btn_arr[$btn['id']] = array("type"=>$btn['menutype'],                                                        "name"=>$btn['content'],                                                        "key"=>$btn['clickkey'],                                                        "url"=>$btn['url']);            }else{                //生成子菜單                $btn_arr[$btn['pid']]['sub_button'][] = array("type"=>$btn['menutype'],                                                        "name"=>$btn['content'],                                                        "key"=>$btn['clickkey'],                                                        "url"=>$btn['url']);            }        }        $btnarr['button'] = array_values($btn_arr);        $r = $this->menustr = json_encode($btnarr,JSON_UNESCAPED_UNICODE);        return $r;    }    private function setmenu(){        $accesstoken = get_access_token();        $url = "https://api.weixin.QQ.com/cgi-bin/menu/create?access_token={$accesstoken}";        $ch = curl_init();        curl_setopt($ch, CURLOPT_URL, $url);        curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);        curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE);        curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (compatible; MSIE 5.01; Windows NT 5.0)');        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);        curl_setopt($ch, CURLOPT_AUTOREFERER, 1);        curl_setopt($ch, CURLOPT_POSTFIELDS, $this->menustr);        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);        $info = curl_exec($ch);        if (curl_errno($ch)) {            return curl_error($ch);        }        curl_close($ch);        return $info;    }}

上面是library里面的內(nèi)容,主要是根據(jù)數(shù)據(jù)表生成菜單的json串

<?phpclass Menu_model extends CI_Model {    public $table_name;    public function __construct(){        parent::__construct();        $this->load->database();        $this->table_name = "data_menu";    }    public function query($sql){        return $this->db->query($sql);    }    public function getone($id){        $get_sql  = "select * from {$this->table_name} where id = {$id}";        return $this->query($get_sql)->row();    }    public function addone($data){        if(($data['pid'] == 0)&&($this->checksum()>=3)){            //一級菜單不超過3個            return "toomany1";        }elseif(($data['pid']!=0)&&($this->checksum($data['pid']))>=7){            //二級菜單不超過7個            return "toomany2";        }        if(is_array($data)&&!empty($data)){            $keys = "`".implode("`,`",array_keys($data))."`";            $vals = "'".implode("','",array_values($data))."'";            $insert_sql = "insert into {$this->table_name} ($keys) values ($vals)";            return $this->query($insert_sql);        }else{            return false;        }    }    public function del($id){        $infos = $this->getone($id);        $del_sql = "delete from {$this->table_name} where id = {$id} and pid = {$id}";        return $this->query($del_sql);    }    private function checksum($id = ''){        if($id == ''){            $get_sql = "select count(1) as total from {$this->table_name} where pid =0";        }else{            $id = intval($id);            $get_sql = "select count(1) as total from {$this->table_name} where pid ={$id}";        }        $r = $this->db->query($get_sql)->row();        return $r->total;    }    public function getplist(){        //獲取一級菜單        $get_sql = "select * from {$this->table_name} where pid=0 order by menuorder asc";        return $this->db->query($get_sql)->result_array();    }    public function isplist(){        $get_sql = "select pid from {$this->table_name} where pid <> 0 group by pid";        return $this->db->query($get_sql)->result_array();    }    public function getlist(){        $get_sql = "select * from {$this->table_name} where 1 order by pid asc, menuorder asc";        return $this->db->query($get_sql)->result_array();    }    public function maketree($data){        $pids = array();        foreach($data as $k=>$v){            if($v['pid'] == 0){                $pids[$v['id']][] = $v;            }else{                $pids[$v['pid']][] = $v;            }        }        list($t1,$t2,$t3) = array_values($pids);        $r = array_merge_recursive(is_array($t1)?$t1:array(),is_array($t2)?$t2:array(),is_array($t3)?$t3:array());        return $r;    }    public function update($data){        if(is_array($data)&&!empty($data)){            $id = $data['id'];            unset($data['id']);            foreach($data as $k=>$v){                $update_arr[] = "`".$k."` = '".$v."'";            }            $update_fs = implode(",",$update_arr);            $update_sql = "update {$this->table_name} set {$update_fs} where id = {$id}";            return $this->query($update_sql);        }else{            return false;        }    }}

上面是model里面的各種方法.

數(shù)據(jù)庫的表結(jié)構(gòu)如下,附創(chuàng)建表的語句.

CREATE TABLE `menu` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `content` varchar(20) DEFAULT NULL,  `pid` int(11) DEFAULT '0',  `menutype` enum('click','view','scancode_push','scancode_waitmsg','pic_sysphoto','pic_photo_or_album','pic_weixin','location_select') DEFAULT 'view' COMMENT '消息類型',  `url` varchar(200) DEFAULT NULL COMMENT '鏈接地址',  `clickkey` varchar(20) DEFAULT NULL COMMENT '事件KEY',  `menuorder` int(11) DEFAULT NULL COMMENT '排序',  `submenu` tinyint(2) DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8