infantServiceApi/app/system/controller/EducationController.php

<?php

namespace app\system\controller;

use Qiniu\Auth;
use Qiniu\Storage\UploadManager;
use app\model\api\EducationModel;
use think\facade\Db;
use think\Request;


class EducationController
{

    /**
     * 获取所有分类
     * @return \think\response\Json
     */
    public function getCate()
    {
        $items = Db::table('table_education_cate')
            ->where(['status' => 'Y'])
            ->order('sort', 'asc')
            ->column('id,pid,name,sort', 'id');

        $tree = array(); //格式化好的树
        foreach ($items as $key => $item) {
            $items[$key]['oriName'] = $item['name'];
            if (isset($items[$item['pid']])) {
                $items[$item['pid']]['son'][$item['id']] = &$items[$item['id']];
            } else {
                $tree[$item['id']] = &$items[$item['id']];
            }
        }

//        $data = array_values($tree);
//        $msg = '获取分类成功';
        return app('json')->success($tree);
    }



    /**
     * 获取所有文章列表
     * @return \think\response\Json
     */
    public function gteArticleList()
    {
        $excludeCourseId = $this->request->param('exclude_course_id');
        $educationModel = new EducationModel();

        // 获取所有文章列表
        $courseList = $educationModel->getCourseList($excludeCourseId);

        return json([
            'courseList' => $courseList,
        ]);
    }


    /**
     * 获取顶级分类
     *
     * @return array
     */
    public function getTopCate()
    {
        $educationModel = new EducationModel;

        return $educationModel->getTopCate();
    }


    /**
     * 获取指定分类的子分类 ID 列表
     *
     * @param array $cates 分类数组
     * @return array
     */
    public function getSubcatesByTopCate($cates)
    {
        $educationModel = new EducationModel;

        return $educationModel->getSubcatesByTopCate($cates);
    }


    /**
     * 修改分类
     *
     * @param Request $request 请求对象
     * @return \think\response\Json
     */
    public function editCate(Request $request)
    {
        $id = $request->param('id');
        $data = $request->param();

        $educationModel = new EducationModel;
        if ($educationModel->update($data, ['id' => $id])) {
        return json(['code' => 0, 'msg' => '修改成功']);
    } else {
        return json(['code' => -1, 'msg' => '修改失败']);
    }
    }


    /**
     * 增加一个分类
     *
     * @param Request $request 请求对象
     * @return \think\response\Json
     */
    public function cateadd(Request $request)
    {
        $pid = $request->param('id/d', 0);
        if ($request->isPost() && $pid) {
            $name = $request->param('name/s', '');
            $sort = $request->param('sort/d', 0);

            if (!$name) {
                return json(['code' => -1, 'msg' => '分类名称不能为空']);
            }

            $data = [
                'pid' => $pid,
                'name' => $name,
                'sort' => $sort,
            ];

            $educationModel = (new EducationModel())->cate;
        if ($educationModel->addCate($data)) {
            return json(['code' => 0, 'msg' => '保存成功']);
        } else {
            return json(['code' => -1, 'msg' => '保存失败']);
        }
    }

        return json(['code' => 0, 'data' => []]);
    }

    /**
     * 删除一个分类
     */
    public function delcate()
    {

    }
}