bts/php/app/admin/controller/Site.php

<?php
declare (strict_types = 1);

namespace app\admin\controller;


use app\common\controller\Backend;
use lemo\helper\TreeHelper;
use think\facade\Cache;
use think\facade\Db;
use think\facade\Request;
use think\facade\View;
use app\common\model\Laboratory;

class Site  extends Backend
{
    // todo 场地管理

    // 场地列表
    public function index()
    {

        if (Request::isPost()){
            $page=input("page")?:1;
            $limit=input("limit")?:10;
            $name=input("name", '', 'trim');
            $list=Db::name("laboratory")->order("id desc")
                ->where("name","like","%".$name."%")
                ->paginate(['list_rows' => $limit, 'page' => $page])->each(function ($item){
                    $subject_id="";
                    if ($item["subject_id"]){
//                        $where["id"]=["in",$item];
                        $resul=Db::name("subject")->whereIn("id",$item["subject_id"])->column("name");
                        foreach ($resul as $v){
                            if ($subject_id){
                                $subject_id.="/".$v;
                            }else{
                                $subject_id=$v;
                            }
                        }
                    }
                    $item["subject_id"]=$subject_id;
                    return $item;
                })
                ->toArray();

            return $result = ['code' => 0, 'msg' => lang('get info success'), 'data' => $list['data'], 'count' => $list['total']];
        }
        return View::fetch();

    }

    public function text()
    {
        $name=input("name");
//        $list=Db::name("laboratory")->alias("la")->order("id desc")
//            ->leftJoin("subject su","su.id= in subject_id")
////            ->where("la.name","like","%".$name."%")
//            ->paginate(['list_rows' => 10, 'page' => 1])
//            ->filed("la.* ,su.name")
////            ->each(function ($item){
////                $subject_id="";
////                if ($item["subject_id"]){
//////                        $where["id"]=["in",$item];
////                    $resul=Db::name("subject")->whereIn("id",$item["subject_id"])->column("name");
////                    foreach ($resul as $v){
////                        if ($subject_id){
////                            $subject_id.="/".$v;
////                        }else{
////                            $subject_id=$v;
////                        }
////                    }
////                }
////                $item["subject_id"]=$subject_id;
////                return $item;
////            })
//            ->toArray();


        $list=Laboratory::with("subject")->where("name","like","%".$name."%")->order("id desc")->paginate(['list_rows' => 10, 'page' => 1]);
//        $sub=$list->subject;

        json_result(1,"",$list);
}




    // 修改状态
    public function updata_status()
    {
        $id=input("id");
        $where["id"]=$id;
        $result=Db::name("laboratory")->where($where)->find();
        if ($result["status"]==1){
            $update["status"]=0;
        }else{
            $update["status"]=1;
        }
        $res=Db::name("laboratory")->where($where)->update($update);
        if ($res){

            json_result(1,"修改成功");
        }
        json_result(2,"修改失败");
    }


    // 科目
    public function sitetree()
    {
//        $list = Cache::get('SiteTree');
        $id=input("id");
//        if (!$list){
            $subject=Db::name("subject")->field("id,major_id,name")->order("major_id asc")->cache(3600)->select()->toArray();
            foreach ($subject as $k=>$v){
                $subject[$k]["title"]=$v["name"];
                $subject[$k]["pid"]=$v["major_id"];
            }
            $where["id"]=$id;
            $laboratory=Db::name("laboratory")->where($where)->value("subject_id");
            $list=TreeHelper::authChecked($subject,0,$laboratory);
//            Cache::set('SiteTree',$list,3600);
//        }
        $idList=Db::name("subject")->column("id");
        sort($idList);
        $view = [
            'list' => $list,
            'idList' => $idList,
            'group_id' => $id,
        ];
        View::assign($view);
        return View::fetch();
    }


    public function urlk()
    {
        $list = Cache::get('SiteTree');
        json_result(1,"",$list);
    }

    // 修改权限
    public function teacher()
    {
        $rules = Request::post('rules');
        if (empty($rules)) {
            json_result(2,"请选择");
        }
        $data = Request::post();
        $rules = TreeHelper::authNormal($rules);
        $rls = '';
        foreach ($rules as $k=>$v){
            if ($rls){
                $rls.=",".$v['id'];
            }else{
                $rls.=$v['id'];
            }
        }
        $where['id'] = $data['group_id'];
        Db::name("laboratory")->where($where)->update(["subject_id"=>$rls]);

        json_result(1,"操作成功");

    }

}