application/admin/modelMenuModel.php

<?php
// +-----------------------------------------------------+
// | hyj
// |-----------------------------------------------------+
// | 菜单管理模型
// |-----------------------------------------------------+
// | 2018-06-06 10:22
// +-----------------------------------------------------+
namespace app\admin\model;

use think\Model;

class MenuModel extends Model
{

    // 主键
    protected $pk = 'nav_id';
    
    // 表名
    protected $table = 'tp_menu';

    /**
     * 获取单个字段
     * @param  [type] $where [查询条件]
     * @param  [type] $field [查询字段]
     * @return [type]        [返回]
     */
    public function get_field($where, $field)
    {
        $data = $this->field($field)->where($where)->find();

        return $data->getAttr($field);
    }

    /**
     * 获取单条信息
     * @param  [type] $where [查询条件]
     * @param  [type] $field [查询字段]
     * @return [type]        [返回]
     */
    public function get_info($where, $fields = "*")
    {
        $data = $this->field($fields)->where($where)->find();

        return $data;

    }

    /**
     * 获取多条信息
     * @param  [type] $where [查询条件]
     * @param  [type] $field [查询字段]
     * @return [type]        [返回]
     */
    public function get_list($where, $order = "", $fields = "*")
    {
        $order = empty($order) ? $this->pk." asc" : $order;
        $data  = $this->field($fields)->where($where)->order($order)->select();

        return $data->toArray();
    }    

    /**
     * 获取数量
     * @param $where
     */
    public function get_count($where)
    {
        return $this->where($where)->count();
    }

    /**
     * 插入单条信息
     * @param $param
     */
    public function insert_data($param)
    {
        try{

            $result = $this->create($param, true);

            return (int)$result->{$this->pk};

        }catch(\Exception $e){

            return msg_error($e->getMessage());
        }
    }

    /**
     * 批量编辑信息[插入与修改]
     * @param $param
     */
    public function edit_data_bantch($param)
    {
        try{

            return $this->saveAll($param);

        }catch(\Exception $e){

            return msg_error($e->getMessage());
        }
    }

    /**
     * 更新单条信息
     * @param $param
     */
    public function save_data($param)
    {
        try{

           return $this->update($param);

        }catch(PDOException $e){

            return msg_error($e->getMessage());
        }
    }

    /**
     * 删除数据
     * @param $id
     */
    public function del_data($where)
    {
        try{

            return $this->where($where)->delete();

        }catch(PDOException $e){

            return msg_error($e->getMessage());
        }
    }

    /**
     * 查询获取菜单树
     * @param  [int] $start [开始数值]
     * @param  [int] $size  [查询条数]
     * @return [array]      [菜单树]
     */
    public function get_menu_list_tree($where, $start, $size)
    {
        $sql = "SELECT * FROM 
                (SELECT *,@sort := pid as sort FROM tp_menu WHERE pid > 1
                    UNION
                SELECT *,@sort:= nav_id as sort FROM tp_menu WHERE pid <= 1) as menus
                WHERE {$where}
                ORDER BY sort asc,level asc
                limit {$start},{$size}";

        return $this->query($sql);
    }

    /**
     * 获取菜单数目
     * @return [int] [总菜单数]
     */
    public function count_menu_list_tree($where)
    {
        $sql = "SELECT count(*) as total FROM 
                (SELECT *,@sort := pid as sort FROM tp_menu WHERE pid > 1
                    UNION
                SELECT *,@sort:= nav_id as sort FROM tp_menu WHERE pid <= 1) as menus
                WHERE {$where}
                ORDER BY sort asc,level asc";
        $res = $this->query($sql);

        return $res[0]['total'];
    }
}