| | |
| | | import com.example.erp.mapper.sd.*; |
| | | import com.example.erp.service.userInfo.LogService; |
| | | import com.example.erp.service.userInfo.SysErrorService; |
| | | import com.fasterxml.jackson.core.JsonProcessingException; |
| | | import com.fasterxml.jackson.databind.ObjectMapper; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | import org.springframework.transaction.interceptor.TransactionAspectSupport; |
| | |
| | | //删除订单工艺表 |
| | | // orderProcessDetailMapper.delete(new LambdaQueryWrapper<OrderProcessDetail>().eq(OrderProcessDetail::getOrderId, order.getOrderId())); |
| | | |
| | | orderDetailMapper.deleteOrderFile(order.getOrderId()); |
| | | |
| | | insertOtherDetail(order.getOrderId(),OrderDetails,orderOtherMoneyList); |
| | | } |
| | | |
| | |
| | | OrderDetails.get(i).setOtherColumns("{}"); |
| | | } |
| | | |
| | | if(OrderDetails.get(i).getFileName()!=null&&!OrderDetails.get(i).getFileName().trim().isEmpty()){ |
| | | orderMapper.saveOrderFile(OrderDetails.get(i).getFileName(), OrderDetails.get(i).getFileData(),orderId,OrderDetails.get(i).getOrderNumber(),OrderDetails.get(i).getFileJson()); |
| | | } |
| | | |
| | | if(OrderDetails.get(i).getShape()==null){ |
| | | OrderDetails.get(i).setShape("1"); |
| | | } |
| | | |
| | | } |
| | | |
| | | |
| | |
| | | |
| | | orderDetails.forEach(orderDetail -> { |
| | | //获取最小弧度 |
| | | OrderGlassDetail orderGlassDetail = orderGlassDetailMapper |
| | | .selectOne(new LambdaQueryWrapper<OrderGlassDetail>() |
| | | List<OrderGlassDetail> orderGlassDetails = orderGlassDetailMapper |
| | | .selectList(new LambdaQueryWrapper<OrderGlassDetail>() |
| | | .eq(OrderGlassDetail::getOrderId, orderId) |
| | | .eq(OrderGlassDetail::getOrderNumber, orderDetail.getOrderNumber()) |
| | | .orderByDesc(OrderGlassDetail::getArc) |
| | | .last("limit 1") |
| | | ); |
| | | //获取当前序号产品Math.cos( |
| | | Product product = productMapper.selectById(orderDetail.getProductId()); |
| | | //内半径 |
| | | Double radius = orderDetail.getBendRadius() - product.getTotalThickness(); |
| | | |
| | | //内片内弧长 |
| | | Double innerArc = orderGlassDetail.getArc() |
| | | -orderGlassDetail.getArc()*product.getTotalThickness()/orderDetail.getBendRadius(); |
| | | for(OrderGlassDetail orderGlassDetail:orderGlassDetails) { |
| | | //获取当前层数与之前层数的厚度 |
| | | Double glassThickness = productMapper |
| | | .getGlassThickness(orderDetail.getProductId(), orderGlassDetail.getTechnologyNumber()); |
| | | //内半径 |
| | | Double radius = orderDetail.getBendRadius() - glassThickness; |
| | | |
| | | //拱高 |
| | | String archRiseS = String.format("%.1f",radius-radius*Math.cos(innerArc/2/radius)); |
| | | Double archRise = Double.parseDouble(archRiseS); |
| | | orderDetail.setArchRise(archRise); |
| | | |
| | | orderDetailMapper.update(null,new LambdaUpdateWrapper<OrderDetail>() |
| | | .set(OrderDetail::getArchRise,archRise) |
| | | .eq(OrderDetail::getId, orderDetail.getId()) |
| | | ); |
| | | //内片内弧长 |
| | | Double innerArc = orderGlassDetails.get(0).getArc() |
| | | - orderGlassDetails.get(0).getArc() * glassThickness / orderDetail.getBendRadius(); |
| | | |
| | | //拱高 |
| | | String archRiseS = String.format("%.1f", radius - radius * Math.cos(innerArc / 2 / radius)); |
| | | Double archRise = Double.parseDouble(archRiseS); |
| | | orderGlassDetailMapper.update(null, new LambdaUpdateWrapper<OrderGlassDetail>() |
| | | .set(OrderGlassDetail::getArchRise, archRise) |
| | | .eq(OrderGlassDetail::getId, orderGlassDetail.getId()) |
| | | ); |
| | | |
| | | // orderDetailMapper.update(null,new LambdaUpdateWrapper<OrderDetail>() |
| | | // .set(OrderDetail::getArchRise,archRise) |
| | | // .eq(OrderDetail::getId, orderDetail.getId()) |
| | | } |
| | | |
| | | }); |
| | | |
| | |
| | | public Map<String,Object> getOrderList(Integer pageNum, Integer pageSize, List<String> selectDate, Map<String,Object> config,Integer orderType) { |
| | | Integer offset = (pageNum-1)*pageSize; |
| | | String endDate = LocalDate.now().toString(); |
| | | String startDate = LocalDate.now().minusDays(15).toString(); |
| | | String startDate = LocalDate.now().minusDays(365).toString(); |
| | | if(selectDate !=null && selectDate.size()==2){ |
| | | if(!selectDate.get(0).isEmpty()){ |
| | | startDate = selectDate.get(0); |
| | |
| | | } |
| | | //删除订单 |
| | | public Integer deleteOrder(String id) { |
| | | return orderMapper.delete( |
| | | orderDetailMapper.deleteOrderFile(id); |
| | | return orderMapper.delete( |
| | | new QueryWrapper<Order>().eq("order_id",id) |
| | | ); |
| | | } |
| | |
| | | Order order = orderMapper.selectOne(new QueryWrapper<Order>().eq("order_id",id)); |
| | | List<OrderDetail> orderDetails = orderDetailMapper.selectList(new QueryWrapper<OrderDetail>().eq("order_id",id)); |
| | | List<OrderOtherMoney> orderOtherMoneyList = orderOtherMoneyMapper.findById(id); |
| | | List<Map<String,String>> orderFileList = orderMapper.selectOrderFileList(id); |
| | | |
| | | |
| | | Map<String,Object> map = new HashMap<>(); |
| | | map.put("order",order); |
| | | map.put("orderDetails",orderDetails); |
| | | map.put("orderOtherMoneyList",orderOtherMoneyList); |
| | | map.put("orderFile",orderFileList); |
| | | return map; |
| | | } |
| | | //订单审核 |
| | |
| | | } |
| | | |
| | | } |
| | | |
| | | public Object uploadDxf(Map<String,Object> object) { |
| | | String fileName = ""; |
| | | if (object.get("fileName") != null) { |
| | | fileName = object.get("fileName").toString(); |
| | | } |
| | | String fileData = ""; |
| | | if (object.get("fileData") != null) { |
| | | fileData = object.get("fileData").toString(); |
| | | } |
| | | byte[] dxfData = Base64.getDecoder().decode(fileData); |
| | | String orderId="NG25010101"; |
| | | Integer orderNumber=1; |
| | | //orderMapper.saveOrderFile(fileName, fileData,orderId,orderNumber); |
| | | return true; |
| | | } |
| | | |
| | | public Map<String,Object> selectUploadDxf(Map<String,Object> object) { |
| | | String orderId = ""; |
| | | if (object.get("orderId") != null) { |
| | | orderId = object.get("orderId").toString(); |
| | | } |
| | | int orderNumber =0; |
| | | if (object.get("orderNumber") != null) { |
| | | orderNumber = Integer.parseInt(object.get("orderNumber").toString()); |
| | | } |
| | | Map<String,Object> map = new HashMap<>(); |
| | | map.put("data",orderMapper.selectOrderFile(orderId,orderNumber)); |
| | | return map; |
| | | } |
| | | |
| | | public boolean updateOrderFile(JSONObject object) throws JsonProcessingException { |
| | | String orderId = ""; |
| | | if (object.get("orderId") != null) { |
| | | orderId = object.get("orderId").toString(); |
| | | } |
| | | int orderNumber =0; |
| | | if (object.get("orderNumber") != null) { |
| | | orderNumber = Integer.parseInt(object.get("orderNumber").toString()); |
| | | } |
| | | String dataBase64 = ""; |
| | | if (object.get("dataBase64") != null) { |
| | | dataBase64 = object.get("dataBase64").toString(); |
| | | } |
| | | String fileJson = null; |
| | | ObjectMapper om = new ObjectMapper(); |
| | | if (object.get("fileJson") != null) { |
| | | fileJson = om.writeValueAsString(object.get("fileJson")); |
| | | } |
| | | Map<String,String> orderFile =orderMapper.selectOrderFile(orderId,orderNumber); |
| | | if(orderFile!=null){ |
| | | orderMapper.updateOrderFile("map.dxf", dataBase64,orderId,orderNumber,fileJson); |
| | | }else{ |
| | | orderMapper.saveOrderFile("map.dxf", dataBase64,orderId,orderNumber,fileJson); |
| | | } |
| | | return true; |
| | | } |
| | | } |