欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

thinkphp无限分类模块实现

程序员文章站 2022-08-09 15:34:36
数据表结构如下: 控制器核心代码:

数据表结构如下:

thinkphp无限分类模块实现

 

 

控制器核心代码:

<?php
namespace app\index\controller;
use think\controller;

class goods extends controller
{
    public function product_category()
    {

        return $this->fetch();
    }

    public function product_category_add()
    {
        $m = model('goods_type');
        // 根据paths进行排序
        // \对,进行转义,因为本身是作为分隔符使用
        $data = $m->field("*,concat(path,'\,',id) as paths")->order('paths')->select();
        foreach($data as $k=>$v){
            //根据level的值,决定需要循环几次,生成分割线
            $v['name'] = str_repeat("|------", $v['level']).$v['name'];
        }
        $this->assign('data', $data);

        return $this->fetch();
    }

    //添加分类
    public function goods_type_add(){
        if($_post['name'] === ''){
            echo '<script>alert("添加失败,分类名不能为空");parent.location.href="product_category";</script>';
        }

        //var_dump($_post);
        $data['name'] = $_post['name'];
        $data['pid'] = $_post['pid'];
        $m = model('goods_type');

        if($data['pid'] === "0"){
            //如果是一级分类
            $data['level'] = 1;
            //新增分类的id
            $info = $m->where('1=1')->order('id desc')->find();
            $newid = $info['id']+1;
            $data['path'] = '0,'.$newid;
        }else{
            $pinfo = $m->field('path,level')->where('id',$data['pid'])->select();
            //查找父分类的path和level
            $data['level'] = $pinfo[0]['level']+1;

            //新增分类的id
            $info = $m->where('1=1')->order('id desc')->find();
            $newid = $info['id']+1;
            $data['path'] = $pinfo[0]['path'].','.$newid;
        }

        $res = $m->data($data)->save();
        if($res){
            echo '<script>alert("添加成功");parent.location.href="product_category";</script>';
        }else{
            echo '<script>alert("添加失败");parent.location.href="product_category";</script>';
        }
    }

    //获取分类数据
    public function product_category_ajax(){
        $m = model('goods_type');
        $data = $m->field('id,pid,name')->select();
        echo json_encode($data);
    }

    //删除分类数据
    public function product_category_del(){
        $id = $_get['id'];
        $m = model('goods_type');
        $res = $m->where('pid',$id)->find();
        if($res){
            $str = '该分类下还有子分类,不允许直接删除';
            echo json_encode($str);
        }else{
            $result = $m->where('id',$id)->delete();
            if($result){
                echo 1;
            }else{
                $str = '删除失败';
                echo json_encode($str);
            }
        }
    }
}

 

实现效果

thinkphp无限分类模块实现