| | |
| | | List<ApsWeldSeamTemp> apsWeldSeamTemps = apsWeldSeamTempMapper.selectApsWeldSeamTempList(apsWeldSeamTemp); |
| | | int count = 0; |
| | | String[] ids = new String[apsWeldSeamTemps.size()]; |
| | | apsWeldSeamMapper.removeLastBatch(); |
| | | for (int i = 0; i < apsWeldSeamTemps.size(); i++) { |
| | | //记录临时表id |
| | | ids[i] = apsWeldSeamTemps.get(i).getId(); |
| | | ApsWeldSeam apsWeldSeam = new ApsWeldSeam(); |
| | | BeanUtils.copyProperties(apsWeldSeamTemps.get(i), apsWeldSeam); |
| | | //通过工单号查询是否存在数据 |
| | | ApsWeldSeam apsWeldSeam1 = apsWeldSeamMapper.selectApsWeldSeamByWorkOrderNo(apsWeldSeam.getWorkOrderNo()); |
| | | /*ApsWeldSeam apsWeldSeam1 = apsWeldSeamMapper.selectApsWeldSeamByWorkOrderNo(apsWeldSeam.getWorkOrderNo()); |
| | | //当工单号存在则更新数据否则插入数据 |
| | | if (apsWeldSeam1!=null&&apsWeldSeam1.getId()!=null) { |
| | | apsWeldSeam.setId(apsWeldSeam1.getId()); |
| | | apsWeldSeamMapper.updateApsWeldSeam(apsWeldSeam); |
| | | } else { |
| | | } else {*/ |
| | | //插入正式表,并记录 |
| | | apsWeldSeam.setId(IdUtils.fastUUID()); |
| | | apsWeldSeamMapper.insertApsWeldSeam(apsWeldSeam); |
| | | } |
| | | apsWeldSeam.setId(IdUtils.fastUUID()); |
| | | apsWeldSeamMapper.insertApsWeldSeam(apsWeldSeam); |
| | | //} |
| | | count++; |
| | | } |
| | | //插入数量与临时表查询一直则删除临时表数据 |
| | |
| | | |
| | | }); |
| | | echartsList.add(title); |
| | | System.out.println(monthList); |
| | | monthList.forEach(month->{ |
| | | List<String> table = new ArrayList<>(); |
| | | table.add(month+"月"); |
| | |
| | | sb.append(value.get("work_order_name")); |
| | | sb.append("-"); |
| | | sb.append(value.get("classification_name")); |
| | | if(sb.toString().equals(title.get(i))){//列明 |
| | | if(sb.toString().equals(title.get(i)) && month.equals(value.get("produce_month").toString())){ |
| | | table.add(value.get("total_weld_seam").toString()); |
| | | } |
| | | } |