mes-sdai-server-api/application/api/controller/Process.php

<?php

namespace app\api\controller;

use app\common\controller\Api;
use \think\Request;
use \think\Db;

/**
 * 工序损耗管理接口
 */
class Process extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * 首页
     *
     */
    public function index()
    {
        $this->success('请求成功');
    }
    /**
     * 单个工序损耗接口
     *
     * @ApiMethod GET
     * @params string code
    */
    public function getProcessLoss(){
        if (Request::instance()->isGet() == false){
            $this->error('非法请求');
        }
        $params = Request::instance()->param();
        $code = $params['code'];
        if (!isset($code)){
            $this->error('参数不能为空');
        }
        $where['sys_bh'] = $code;
        $field = 'rtrim(sys_bh) as sys_bh,rtrim(sys_mc) as sys_mc,sys_rate0,sys_rate1,rtrim(适用机型) as remark';
        $data = Db::name('dic_lzsh')->where($where)->field($field)->select();
        $this->success('请求成功',$data);
    }
    /**
     * 获取工序损耗列表接口
     *
     * @ApiParams GET
    */
    public function getProcess(){
        if (Request::instance()->isGet() == false){
            $this->error('非法请求');
        }
        $field = 'Key_,Parent,rtrim(sys_bh) as sys_bh,rtrim(sys_mc) as sys_mc';
        $list = Db::name('dic_lzsh')->field($field)->select();
        $data = [];
        $i = 0;
        foreach ($list as $value){
            if ($value['Parent'] == '0_'){
                $data[$i] = $value;
                //一级菜单
                $data[$i]['child'] = Db::name('dic_lzsh')->where('Parent',$value['Key_'])->field($field)->select();
                foreach ($data[$i]['child'] as $k=>$v){
                    $children = Db::name('dic_lzsh')->where('Parent',$v['Key_'])->field($field)->select();
                    //二级菜单
                    $data[$i]['child'][$k]['children'] =  $children;
                    if (!empty($children)){
                        foreach ($children as $key=>$item){
                            $childrens = Db::name('dic_lzsh')->where('Parent',$item['Key_'])->field($field)->select();
                            //三级菜单
                            $data[$i]['child'][$k]['children'][$key]['childrens'] =  $childrens;
                            if (!empty($childrens)){
                                foreach ($childrens as $k1=>$v1){
                                    $fiveChild = Db::name('dic_lzsh')->where('Parent',$v1['Key_'])->field($field)->select();
                                    $data[$i]['child'][$k]['children'][$key]['childrens'][$k1]['fiveChild'] =  $fiveChild;
                                }
                            }else{
                                $data[$i]['child'][$k]['children'][$key]['childrens'] = [];
                            }
                        }
                    }else{
                        $data[$i]['child'][$k]['children']= [];
                    }
                }
                $i++;
            }
        }
        $this->success('请求成功',$data);
    }
}