package org.jeecg.modules.arj.g.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.jeecg.modules.arj.config.AjaxResult; import org.jeecg.modules.arj.entity.*; import org.jeecg.modules.arj.g.entity.*; import org.jeecg.modules.arj.g.service.*; import org.jeecg.modules.arj.g.vo.DiGaiShengChanVo; import org.jeecg.modules.arj.service.FeipinGuanService; import org.jeecg.modules.arj.service.HeadService; import org.jeecg.modules.arj.service.LineChanliangtongjiService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.data.domain.PageImpl; import org.springframework.data.domain.PageRequest; import org.springframework.web.bind.annotation.*; import java.util.List; @Api(tags = "g14-502底盖生产情况报告") @RestController @RequestMapping("/g/diGaiShengChanVoController") public class DiGaiShengChanVoController { @Autowired private HeadService headService; @Autowired private LineChanliangtongjiService lineChanliangtongjiService; @Autowired private Sh14YtFpService sh14YtFpService; @Autowired private Sh14JgFpService sh14JgFpService; @Autowired private Sh14CcFpService sh14CcFpService; @Autowired private Sh14ZjFpService sh14ZjFpService; @Autowired private Sh14GjjFpService sh14GjjFpService; @Autowired private Sh14ZjService sh14ZjService; @Autowired private FeipinGuanService feipinGuanService; /** * 通过ID查询单条数据 * * @param id 主键 * @return 实例对象. */ @ApiOperation("通过ID查询单条数据") @GetMapping("/id") public AjaxResult queryById(String id) { DiGaiShengChanVo shengchanVo = new DiGaiShengChanVo(); Head head = headService.queryById(id); shengchanVo.setHead(head); shengchanVo.setLineChanliangtongji(lineChanliangtongjiService.queryByHeadId(head.getId())); shengchanVo.setFeipinGuan(feipinGuanService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setSh14CcFp(sh14CcFpService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setSh14GjjFp(sh14GjjFpService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setSh14JgFp(sh14JgFpService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setSh14Zj(sh14ZjService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setSh14ZjFp(sh14ZjFpService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); shengchanVo.setYtFp(sh14YtFpService.getOne(new QueryWrapper().eq("head_id" , head.getId()))); return AjaxResult.success(shengchanVo); } /** * 分页查询 * * @param head 筛选条件 * @param pageRequest 分页对象 * @return 查询结果 */ @ApiOperation("分页查询") @GetMapping public AjaxResult paginQuery(Head head, PageRequest pageRequest) { //1.分页参数 long current = pageRequest.getPageNumber(); long size = pageRequest.getPageSize(); //2.分页查询 /*把Mybatis的分页对象做封装转换，MP的分页对象上有一些SQL敏感信息，还是通过spring的分页模型来封装数据吧*/ com.baomidou.mybatisplus.extension.plugins.pagination.Page pageResult = headService.paginQuery(head, current, size); //3. 分页结果组装 List dataList = pageResult.getRecords(); long total = pageResult.getTotal(); PageImpl retPage = new PageImpl(dataList, pageRequest, total); return AjaxResult.success(retPage); } /** * 新增数据 * * @param shengchanVo 实例对象 * @return 实例对象 */ @ApiOperation("新增数据") @PostMapping("/add") public AjaxResult add(@RequestBody DiGaiShengChanVo shengchanVo) { Head h = headService.insert(shengchanVo.getHead()); shengchanVo.setHead(h); if (shengchanVo.getLineChanliangtongji() != null) { shengchanVo.getLineChanliangtongji().setHeadId(h.getId()); lineChanliangtongjiService.save(shengchanVo.getLineChanliangtongji()); } if (shengchanVo.getFeipinGuan() != null) { shengchanVo.getFeipinGuan().setHeadId(h.getId()); feipinGuanService.save(shengchanVo.getFeipinGuan()); } if (shengchanVo.getSh14CcFp() != null) { shengchanVo.getSh14CcFp().setHeadId(h.getId()); sh14CcFpService.save(shengchanVo.getSh14CcFp()); } if (shengchanVo.getSh14GjjFp() != null) { shengchanVo.getSh14GjjFp().setHeadId(h.getId()); sh14GjjFpService.save(shengchanVo.getSh14GjjFp()); } if (shengchanVo.getSh14JgFp() != null) { shengchanVo.getSh14JgFp().setHeadId(h.getId()); sh14JgFpService.save(shengchanVo.getSh14JgFp()); } if (shengchanVo.getSh14Zj() != null) { shengchanVo.getSh14Zj().setHeadId(h.getId()); sh14ZjService.save(shengchanVo.getSh14Zj()); } if (shengchanVo.getSh14ZjFp() != null) { shengchanVo.getSh14ZjFp().setHeadId(h.getId()); sh14ZjFpService.save(shengchanVo.getSh14ZjFp()); } if (shengchanVo.getYtFp() != null) { shengchanVo.getYtFp().setHeadId(h.getId()); sh14YtFpService.save(shengchanVo.getYtFp()); } return AjaxResult.success(h.getId()); } /** * 获取最新数据 * * @return 实例对象 */ @ApiOperation("获取最新数据") @PostMapping("/last") public AjaxResult getlastRecord(String leixing) { Head head = headService.queryLast(leixing == null ? "g14" : leixing); if (head == null) return AjaxResult.error("访问无数据"); DiGaiShengChanVo shengchanVo = new DiGaiShengChanVo(); shengchanVo.setHead(head); shengchanVo.setLineChanliangtongji(lineChanliangtongjiService.queryByHeadId(head.getId())); shengchanVo.setFeipinGuan(feipinGuanService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setSh14CcFp(sh14CcFpService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setSh14GjjFp(sh14GjjFpService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setSh14JgFp(sh14JgFpService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setSh14Zj(sh14ZjService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setSh14ZjFp(sh14ZjFpService.getOne(new QueryWrapper().eq("head_id",head.getId()))); shengchanVo.setYtFp(sh14YtFpService.getOne(new QueryWrapper().eq("head_id",head.getId()))); return AjaxResult.success(shengchanVo); } /** * 更新数据 * * @param shengchanVo 实例对象 * @return 实例对象 */ @ApiOperation("更新数据") @PostMapping("/edit") public AjaxResult edit(@RequestBody DiGaiShengChanVo shengchanVo) { Head h2 = shengchanVo.getHead(); h2.setId(""); Head h = headService.insert(h2); shengchanVo.setHead(h); if (shengchanVo.getLineChanliangtongji() != null) { shengchanVo.getLineChanliangtongji().setHeadId(h.getId()); lineChanliangtongjiService.saveOrUpdate(shengchanVo.getLineChanliangtongji()); } if (shengchanVo.getFeipinGuan() != null) { shengchanVo.getFeipinGuan().setHeadId(h.getId()); feipinGuanService.saveOrUpdate(shengchanVo.getFeipinGuan()); } if (shengchanVo.getSh14CcFp() != null) { shengchanVo.getSh14CcFp().setHeadId(h.getId()); sh14CcFpService.saveOrUpdate(shengchanVo.getSh14CcFp()); } if (shengchanVo.getSh14GjjFp() != null) { shengchanVo.getSh14GjjFp().setHeadId(h.getId()); sh14GjjFpService.saveOrUpdate(shengchanVo.getSh14GjjFp()); } if (shengchanVo.getSh14JgFp() != null) { shengchanVo.getSh14JgFp().setHeadId(h.getId()); sh14JgFpService.saveOrUpdate(shengchanVo.getSh14JgFp()); } if (shengchanVo.getSh14Zj() != null) { shengchanVo.getSh14Zj().setHeadId(h.getId()); sh14ZjService.saveOrUpdate(shengchanVo.getSh14Zj()); } if (shengchanVo.getSh14ZjFp() != null) { shengchanVo.getSh14ZjFp().setHeadId(h.getId()); sh14ZjFpService.saveOrUpdate(shengchanVo.getSh14ZjFp()); } if (shengchanVo.getYtFp() != null) { shengchanVo.getYtFp().setHeadId(h.getId()); sh14YtFpService.saveOrUpdate(shengchanVo.getYtFp()); } return AjaxResult.success(h.getId()); } /** * 废品统计信息 @ApiModelProperty(value = "冲床废品") private int cc_total; @ApiModelProperty(value = "注胶废品") private int zhujiao_total; @ApiModelProperty(value = "光检机废品") private int gyj_total; @ApiModelProperty(value = "集盖废品") private int jg_total; @ApiModelProperty(value = "印废罐") private int fp_total; @ApiModelProperty(value = "质检") private int zj_total; @ApiModelProperty(value = "质检合计") private int hj_total; @ApiModelProperty(value = "head id") private String head_id; */ @ApiOperation("统计废品数据") @PostMapping("/feipinTotal") public AjaxResult feipinTotal(){ Head head = headService.queryLast("g14"); if (head == null) return AjaxResult.error("访问无数据"); GaixianFPTotal gaixianFPTotal = new GaixianFPTotal(); Sh14CcFp sh14CcFp = sh14CcFpService.getOne(new QueryWrapper().eq("head_id",head.getId())); if( sh14CcFp != null ) gaixianFPTotal.setCc_total(sh14CcFp.getTotal()); Sh14GjjFp sh14GjjFp = sh14GjjFpService.getOne(new QueryWrapper().eq("head_id",head.getId())); if(sh14GjjFp != null ) gaixianFPTotal.setGyj_total(sh14GjjFpService.getOne(new QueryWrapper().eq("head_id",head.getId())).getTotal()); Sh14JgFp sh14JgFp = sh14JgFpService.getOne(new QueryWrapper().eq("head_id",head.getId())); if(sh14JgFp != null ) gaixianFPTotal.setJg_total(sh14JgFp.getTotal()); Sh14Zj sh14Zj = sh14ZjService.getOne(new QueryWrapper().eq("head_id",head.getId())); if(sh14Zj!= null ) gaixianFPTotal.setHj_total(sh14Zj.getHj()==null?0:sh14Zj.getHj()); gaixianFPTotal.setZj_total(sh14Zj.getJy()+sh14Zj.getSy()); Sh14ZjFp sh14ZjFp = sh14ZjFpService.getOne(new QueryWrapper().eq("head_id",head.getId())); if( sh14ZjFp != null ) gaixianFPTotal.setZhujiao_total(sh14ZjFp.getTotal()); FeipinGuan feipinGuan = feipinGuanService.getOne(new QueryWrapper().eq("head_id",head.getId())); if( feipinGuan != null ) gaixianFPTotal.setFp_total(feipinGuan.getTotal()); return AjaxResult.success(gaixianFPTotal); } }