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); } }