CI-Framework WeChat-Entwicklung – benutzerdefiniertes Menü

<?<span>php

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

}</span>