package com.vci.test;
|
|
import com.vci.starter.web.annotation.controller.VciUnCheckRight;
|
import com.vci.starter.web.pagemodel.BaseResult;
|
import com.vci.starter.web.pagemodel.Tree;
|
import com.vci.web.service.WebBoServiceI;
|
import org.apache.commons.lang3.StringUtils;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.web.bind.annotation.GetMapping;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RestController;
|
|
import javax.annotation.Resource;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @Description 测试控制器
|
* @Author dangsn
|
* @Date 2024/11/14 10:08
|
*/
|
@RestController
|
@RequestMapping("/dataTestController")
|
public class DataTestController {
|
|
@Resource
|
private WebBoServiceI boServiceI;
|
|
/**
|
* 获取产品
|
* @return
|
*/
|
@VciUnCheckRight
|
@GetMapping("/getProduct")
|
public BaseResult getProduct(){
|
String sql = "select * from platformbtm_workcontext where workcontexttype = 'product'";
|
List<Map> productList = boServiceI.queryByOnlySqlForMap(sql);
|
BaseResult baseResult = new BaseResult();
|
baseResult.setSuccess(true);
|
baseResult.setCode(200);
|
baseResult.setData(productList);
|
return baseResult;
|
}
|
|
/**
|
* 获取ebom信息
|
* @param productNo 产品编号
|
* @param productOid 产品主键
|
* @param parentOid 上级零件主键
|
* @return
|
*/
|
@VciUnCheckRight
|
@GetMapping("/getEbomInfo")
|
public BaseResult getEbomInfo(String productNo, String productOid, String parentOid){
|
if(StringUtils.isBlank(productNo)){
|
return BaseResult.fail("产品编号为空！");
|
}
|
if(StringUtils.isBlank(productOid)){
|
return BaseResult.fail("产品主键为空！");
|
}
|
BaseResult baseResult = new BaseResult();
|
List<Map> ebomList;
|
if(StringUtils.isBlank(parentOid)){
|
String sql = "select * from platformbtm_part t where t.ownproduct = '"+productOid+"' and t.code = '"+productNo+"'";
|
ebomList = boServiceI.queryByOnlySqlForMap(sql);
|
|
}else{
|
String sql = "select p.*,e.oid as eoid from platformbtm_part p left join platformlt_ebom e on p.oid = e.t_oid \n" +
|
"where e.f_oid = '"+parentOid+"' and e.workcontextoid = '"+productOid+"' \n" +
|
"and p.islastr = '1' and p.islastv = '1' order by p.code asc";
|
ebomList = boServiceI.queryByOnlySqlForMap(sql);
|
}
|
List<Tree> treeList = new ArrayList<>();
|
if(!CollectionUtils.isEmpty(ebomList)){
|
for(Map ebom : ebomList){
|
String oid = ebom.get("OID").toString();
|
String id = ebom.get("CODE").toString();
|
String name = ebom.get("NAME").toString();
|
String revisionvalue = ebom.get("REVISIONVALUE").toString();
|
String versionrule = ebom.get("VERSIONRULE").toString();
|
String versionvalue = ebom.get("VERSIONVALUE").toString();
|
String parttype = ebom.get("PARTTYPE").toString();
|
String lcStatus = ebom.get("LCSTATUS").toString();
|
String parttypetext = "";
|
String lcStatusText = "";
|
if(parttype.equals("20")){
|
parttypetext = "产品";
|
}
|
if(parttype.equals("6")){
|
parttypetext = "装配件";
|
}
|
if(parttype.equals("7")){
|
parttypetext = "零件";
|
}
|
if(parttype.equals("8")){
|
parttypetext = "标准件";
|
}
|
if(lcStatus.equals("Editing")){
|
lcStatusText = "编辑中";
|
}
|
if(lcStatus.equals("Published")){
|
lcStatusText = "已发布";
|
}
|
Tree tree = new Tree();
|
tree.setLeaf(false);
|
tree.setExpanded(false);
|
tree.setOid(oid);
|
tree.setId(id);
|
tree.setText(id+" "+name+"["+parttypetext+"]["+revisionvalue+versionrule+versionvalue+"]【"+lcStatusText+"】");
|
if(StringUtils.isNotBlank(parentOid)){
|
tree.setParentId(parentOid);
|
}
|
if(ebom.containsKey("EOID")){
|
Map<String, String> atrrMap = new HashMap<>();
|
atrrMap.put("eoid", ebom.get("EOID").toString());
|
tree.setAttributes(atrrMap);
|
}
|
treeList.add(tree);
|
}
|
}
|
baseResult.setData(treeList);
|
baseResult.setSuccess(true);
|
baseResult.setCode(200);
|
return baseResult;
|
}
|
|
/**
|
* 获取下级零件信息
|
* @param productOid 产品主键
|
* @param parentOid 上级零件主键
|
* @return
|
*/
|
@VciUnCheckRight
|
@GetMapping("/getChildInfo")
|
public BaseResult getChildInfo(String productOid, String parentOid){
|
if(StringUtils.isBlank(productOid)){
|
return BaseResult.fail("产品主键为空！");
|
}
|
if(StringUtils.isBlank(parentOid)){
|
return BaseResult.fail("零件上级主键为空！");
|
}
|
String sql = "select p.*,e.oid as eoid from platformbtm_part p left join platformlt_ebom e on p.oid = e.t_oid \n" +
|
"where e.f_oid = '"+parentOid+"' and e.workcontextoid = '"+productOid+"' \n" +
|
"and p.islastr = '1' and p.islastv = '1' order by p.code asc";
|
List<Map> ebomList = boServiceI.queryByOnlySqlForMap(sql);
|
BaseResult baseResult = new BaseResult();
|
baseResult.setData(ebomList);
|
baseResult.setSuccess(true);
|
return baseResult;
|
}
|
|
/**
|
* 获取零件实例信息
|
* @param productOid 产品主键
|
* @param partOid 零件主键
|
* @param eoid 树节点上的扩展属性eoid的值
|
* @return
|
*/
|
@VciUnCheckRight
|
@GetMapping("/getPartInstance")
|
public BaseResult getPartInstance(String productOid, String partOid, String eoid){
|
if(StringUtils.isBlank(productOid)){
|
return BaseResult.fail("产品主键为空！");
|
}
|
if(StringUtils.isBlank(partOid)){
|
return BaseResult.fail("零件主键为空！");
|
}
|
if(StringUtils.isBlank(eoid)){
|
return BaseResult.fail("EBOM关系主键为空！");
|
}
|
String sql = "select t.* from platformbtm_partinstance t where t.partoid = '"+partOid+"' \n" +
|
"and t.workcontextoid = '"+productOid+"' and t.ebomoid = '"+eoid+"'";
|
List<Map> mapList = boServiceI.queryByOnlySqlForMap(sql);
|
BaseResult baseResult = new BaseResult();
|
baseResult.setData(mapList);
|
baseResult.setSuccess(true);
|
return baseResult;
|
}
|
|
/**
|
* 获取零件基本信息
|
* @param partOid 零件主键
|
* @return
|
*/
|
@GetMapping("/getPartInfo")
|
public BaseResult getPartInfo(String partOid){
|
if(StringUtils.isBlank(partOid)){
|
return BaseResult.fail("零件主键为空！");
|
}
|
String sql = "select * from platformbtm_part where oid = '"+partOid+"'";
|
List<Map> mapList = boServiceI.queryByOnlySqlForMap(sql);
|
BaseResult baseResult = new BaseResult();
|
baseResult.setData(mapList);
|
baseResult.setSuccess(true);
|
return baseResult;
|
}
|
}
|
