（方法一）以需要推送的模块作为主数据联查
（方法二）通过推送的模块新增数据到本页面
1.分别再其需要推送的模块相关impl层新增
表结构：关联id（物资盘点id/机械盘点id），类型（机械盘点/.物资盘点）
机械盘点impl层，物资盘点推送数据同机械
//竣工内业管理
if("竣工盘点".equals(pmMechanicalCheck.getCheckType())){ //判断盘点类型为竣工盘点可推
PmBeCompletedManage manage = new PmBeCompletedManage();
manage.setManageId(randomStr(32));
manage.setCheckId(pmMechanicalCheck.getCheckId());
manage.setProjectId(pmMechanicalCheck.getItemCode());
manage.setType("机械盘点");
manage.setCreateTime(DateUtils.getNowDate());
pmBeCompletedManageMapper.insertPmBeCompletedManage(manage);
}
2.编辑页数据来源两个及以上模块
（1）分别再需要推送的模块，机械盘点，物资盘点模块写mapper,然后调查询sql（物资盘点同机械）
机械盘点
List selectByCheckId(String 明细id);
（2）编辑详情查询调mapper
//查询机械盘点，物资盘点明细
if("机械盘点".equals(manage.getType())){
List pmMechanicalCheckItems = pmMechanicalCheckItemMapper.selectByCheckId(manage.getCheckId());
manage.setBuildAllotList(pmMechanicalCheckItems);
}else{
List pmStockInventoryItems = pmStockInventoryItemMapper.selectByCheckId(manage.getCheckId());
manage.setMaterialAllotList(pmStockInventoryItems);
}
3.sql，查询条件同一个字段并列，用in 或者or
（1）where item_code = #{itemCode} and bui_type in ('3', '4')
（2）where item_code = #{itemCode} and bui_type ='3' or bui_type = '4'
2. 魔法值，及短信发送
eg: xxx.setFromStatus("0");
提取魔法值：代码中不允许出现魔法值
```java
常量信息中提取定义魔法值
public final static String FROM_STATUS_TWO = "1";
if(UserConstants.FROM_STATUS_TWO.equals(pmBeCompletedBack.getFormStatus())){}
//短信内容可提取出来，以方便维护
private final static String MSG_CONTENT = "您有履约保证金待回收，请在“要求返还日期”之前回收完毕";
//提交操作-发送短信
if(UserConstants.FROM_STATUS_TWO.equals(pmBeCompletedBack.getFormStatus())){
//TODO 项目id暂时无法带出项目经理手机号 chengminqi
List userNumbers = new ArrayList<>();
userNumbers.add("13468569865");
try{
//发送短信
iMmSmsHttpSendService.sendSmsByPost(MSG_CONTENT,userNumbers, MessageType.MESSAGE, new Date(), PassageMode.LOOSE);
}catch (RequiredArgsNotFoundException ex){
ex.printStackTrace();
}
}
3. 多列表，并且每个列表字段都一样，即可把多列表进行融合到一张子表里，用类型进行区分
（1）实体中分别封装列表
//施工方案及预制加工方案-电气列表
private List buildProcessPlanList;
//施工方案及预制加工方案-管道
private List pipeList;
//施工方案及预制加工方案-通风
private List ventilateList;
（2）impl
新增
//施工方案及预制加工方案
List buildProcessPlanList = pmTechnologyPlan.getBuildProcessPlanList(); //电气
buildProcessPlanList.addAll(pmTechnologyPlan.getPipeList()); //管道
buildProcessPlanList.addAll(pmTechnologyPlan.getVentilateList()); //通风
if(buildProcessPlanList !=null){
for(PmBuildProcessPlan detail : buildProcessPlanList){
detail.setTechnologyPlanId(pmTechnologyPlan.getTechnologyPlanId());
pmBuildProcessPlanMapper.insertPmBuildProcessPlan(detail);
}
}
修改
//施工方案及预制加工方案
List buildProcessPlanList = pmTechnologyPlan.getBuildProcessPlanList(); //电气
buildProcessPlanList.addAll(pmTechnologyPlan.getPipeList()); //管道
buildProcessPlanList.addAll(pmTechnologyPlan.getVentilateList()); //通风
//先删除
pmBuildProcessPlanMapper.deleteTechnologyPlanById(pmTechnologyPlan.getTechnologyPlanId());
for(PmBuildProcessPlan detail : buildProcessPlanList){
detail.setTechnologyPlanId(pmTechnologyPlan.getTechnologyPlanId());
pmBuildProcessPlanMapper.insertPmBuildProcessPlan(detail);
}
修改查询
//查询技术方案
PmTechnologyPlan pmTechnologyPlan = pmTechnologyPlanMapper.selectPmTechnologyPlanById(technologyPlanId);
//施工方案及预制加工方案
PmBuildProcessPlan pmBuildProcessPlan = new PmBuildProcessPlan();
pmBuildProcessPlan.setTechnologyPlanId(technologyPlanId);
List list = pmBuildProcessPlanMapper.selectPmBuildProcessPlanList(pmBuildProcessPlan);
List buildProcessPlanList = new ArrayList<>(); //电气
List pipeList = new ArrayList<>(); //管道
List ventilateList = new ArrayList<>(); //通风
for(PmBuildProcessPlan detail: list){
String tableType = detail.getTableType();
switch (tableType){
case "电气": buildProcessPlanList.add(detail); break;
case "管道": pipeList.add(detail); break;
case "通风": ventilateList.add(detail); break;
}
}
pmTechnologyPlan.setBuildProcessPlanList(buildProcessPlanList);
pmTechnologyPlan.setPipeList(pipeList);
pmTechnologyPlan.setVentilateList(ventilateList);
return pmTechnologyPlan;
