cxinv/app/admin/controller/Action.php

<?php
declare (strict_types = 1);
namespace app\admin\controller;
use app\admin\BaseController;
use think\App;
use think\facade\Db;

class Action extends BaseController{
    public function __construct(App $app) {parent::__construct($app);}

    //获取素有菜单列表数据
 public function index(){

        $data = Db::name("admin_menu")->where(["pid"=>0,"status"=>1])->select();
        $result = [];
        if(empty($data)){
            return app_show(0,"获取成功",$result);
        }
        foreach ($data as $key=>$val){
            $val["child"]=[];
            $result[$val['id']] =$val;
        }

        $child =Db::name("admin_menu")->where("pid","<>",0)->where('status',"=",1)->select();
        foreach ($child as $k=>$value){
            $act =Db::name("action")->alias("a")->leftJoin("cfp_action_list l","a.action_code=l.action_code")->field
            ("a.*,action_name")->where(['a.menuid'=>$value['id'],"a.status"=>1])->select();
            $act_data = Db::name("action_field")->where(['menuid'=>$value['id'],"status"=>1])->select();
            $value['action'] = $act;
            $value['action_data'] = $act_data;
            if(array_key_exists($value['pid'],$result)){
                $result[$value['pid']]["child"][]=$value;
            }
        }

        return app_show(0,"获取成功",array_values($result));
    }

    public function ActionList(){
        $page = isset($post['page']) ? intval($post['page']) : 1;
        $size = isset($post['size']) ? intval($post['size']) : 10;

        $count = Db::name("action_list")->count();
        $total = ceil($count/$size)>1 ? ceil($count/$size) : 1;
        $page = $page>=$total?intval($total):$page;
        $list = Db::name("action_list")->page($page,$size)->select();
        $data =['list'=>$list,"count"=>$count];
        return app_show(0,'获取成功',$data);
    }
}