Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override
| | |
| | | props.lastList.push(list.value[i].data[j]) |
| | | } |
| | | } |
| | | console.log(props) |
| | | } else { |
| | | ElMessage.warning(res.msg) |
| | | router.push("/login") |
| | |
| | | } |
| | | } |
| | | } |
| | | console.log(props) |
| | | } else { |
| | | ElMessage.warning(res.msg) |
| | | } |
| | |
| | | //æ¯ä¸ªåºå·é¢ç§¯ |
| | | collection.total_area = parseFloat((collection.width * collection.height * collection.quantity / 1000000).toFixed(2)) |
| | | totalArea = add(totalArea, collection.total_area) |
| | | totalWeight += collection.width * collection.height * collection.quantity / 1000000 * collection.separation * 2.5 * 1; |
| | | //æ ¹æ®æå å±è®¡ç®éé |
| | | for (let j = 0; j < produceList.value[i].detail.length; j++) { |
| | | if (produceList.value[i].detail[j].technologyNumber.length>1){ |
| | | totalWeight += collection.weight * collection.quantity * 1; |
| | | |
| | | }else { |
| | | totalWeight += collection.width * collection.height * collection.quantity / 1000000 * collection.separation * 2.5 * 1; |
| | | |
| | | } |
| | | } |
| | | |
| | | //æ¯ä¸ªåºå·å¨é¿ |
| | | collection.perimeter = parseFloat(((collection.width * 2 + collection.height * 2) * collection.quantity / 1000).toFixed(3)) |
| | | }); |
| | |
| | | <td class="tdNowrap">åçåç§°ï¼</td> |
| | | <td colspan="3">{{ itemTr.glass_child }}</td> |
| | | <td class="tdNowrap">产ååç§°ï¼</td> |
| | | <td :colspan="2+item.processList.length*2">{{ itemTr.product_name }}</td> |
| | | |
| | | <td v-if="!company.processFontSize" :colspan="2+item.processList.length*2">{{ itemTr.product_name }}</td> |
| | | <td v-else :colspan="2+item.processList.length*2" style="font-size: 18px;">{{ itemTr.product_name }}</td> |
| | | </tr> |
| | | <tr> |
| | | <td rowspan='2'>åºå·</td> |
| | |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'day',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day', |
| | | deliveryDate:15,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·', |
| | |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'year',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day',//å端çæåè´§åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | deliveryDate:7,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·',//æå°çäº§åæ¶éè¦æ¾ç¤ºçååï¼æ²¡æä¸ºç©º |
| | |
| | | msg:'basicData.msg.range9999Dec' |
| | | }, |
| | | orderIdType:'month',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'month',//å端çæåè´§åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | deliveryDate:7,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¼å½¢åæ°',//æå°çäº§åæ¶éè¦æ¾ç¤ºçååï¼æ²¡æä¸ºç©º |
| | |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'year',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æå¹´çæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day',//å端çæåè´§åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | deliveryDate:15,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·',//æå°çäº§åæ¶éè¦æ¾ç¤ºçååï¼æ²¡æä¸ºç©º |
| | |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'day',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day', |
| | | deliveryDate:15,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·', |
| | |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'day',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdTypeLetter:'NG',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:2,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day',//å端çæåè´§åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | deliveryDate:15,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·',//æå°çäº§åæ¶éè¦æ¾ç¤ºçååï¼æ²¡æä¸ºç©º |
| | |
| | | //regexp:/^(0|[1-9][0-9]{0,3}([.][0-9]{1,2})?)$/,//æ£å0.00-9999.99 |
| | | msg:'basicData.msg.range99999Dec2' |
| | | }, |
| | | orderIdType:'year',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdType:'day',//å端çæè®¢åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ,year:æ¯å¹´çæ |
| | | orderIdTypeLetter:'R',//订åå·åé¢åæ¯ |
| | | orderIdTypeMantissa:3,//订åå·å°¾æ°ä¿ç使° orderIdTypeLetteré¿åº¦+orderIdTypeMantissa =4 |
| | | deliveryIdType:'day',//å端çæåè´§åå·ç±»åï¼day:æ¯å¤©çæï¼month:æ¯æçæ |
| | | deliveryDate:15,//订åå建éè´§æ¥æ 天津7天ï¼å¸¸å·7天ï¼ä¹ä¹15å¤©ï¼æ°ç15天 |
| | | columnName:'å¾å·',//æå°çäº§åæ¶éè¦æ¾ç¤ºçååï¼æ²¡æä¸ºç©º |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | const brokenGridKey = ref(0) |
| | | const openedBrokenTable = async () => { |
| | | brokenGridKey.value++ |
| | | await nextTick() |
| | | console.log('breakageType:', titleSelectJson.value.breakageType) |
| | | console.log('breakageReason:', titleSelectJson.value.breakageReason) |
| | |
| | | +brokenRow.glass_child+'.'+brokenRow.order_number+'.'+brokenRow.technology_number" |
| | | style="width: 80%;height:75% "> |
| | | <vxe-grid |
| | | |
| | | :key="brokenGridKey" |
| | | height="400px" |
| | | ref="brokenGrid" |
| | | class="mytable-scrollbar" |
| | |
| | | creator:userStore.user.userName, |
| | | creatorId:userStore.user.userId, |
| | | newOrderId:newOrderId.value, |
| | | position:company.position |
| | | position:company.position, |
| | | orderIdTypeLetter:company.orderIdTypeLetter, |
| | | orderIdTypeMantissa:company.orderIdTypeMantissa |
| | | } |
| | | const grossAreaList = $grid.getTableData().fullData.filter( |
| | | item=>item.grossArea === 0 |
| | |
| | | |
| | | @ApiOperation("å¯å
¥åºçæåæ¥è¯¢æ¥å£") |
| | | @PostMapping("/getSelectWarehousingList") |
| | | @SaCheckPermission("createProductStock.search") |
| | | public Result getSelectWarehousingList(@RequestBody Map<String,String> map){ |
| | | return Result.success(finishedGoodsInventoryService.getSelectWarehousingApp(map.get("processId"))); |
| | | } |
| | | |
| | | @ApiOperation("æåå
¥åºæ¥å£") |
| | | @PostMapping("/addSelectWarehousing") |
| | | @SaCheckPermission("createProductStock.add") |
| | | public Result addSelectWarehousing( @RequestBody Map<String,Object> object){ |
| | | return Result.success(finishedGoodsInventoryService.addSelectWarehousing(object)); |
| | | |
| | |
| | | |
| | | @ApiOperation("å¯åè´§çæåæ¥è¯¢æ¥å£") |
| | | @PostMapping("/getSelectDeliveryDetailList") |
| | | @SaCheckPermission("finishedProductOut.search") |
| | | public Result getSelectDeliveryDetailList(){ |
| | | return Result.success(finishedGoodsInventoryService.getSelectDeliveryDetailApp()); |
| | | } |
| | | |
| | | @ApiOperation("æååºåºæ¥å£") |
| | | @PostMapping("/addDeliveryDetail") |
| | | @SaCheckPermission("finishedProductOut.add") |
| | | public Result addDeliveryDetail( @RequestBody Map<String,Object> object){ |
| | | return Result.success(finishedGoodsInventoryService.addDeliveryDetail(object)); |
| | | } |
| | |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.sql.SQLOutput; |
| | | import java.text.DecimalFormat; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.LocalDate; |
| | |
| | | public boolean saveOrder(Map<String,Object> orderMap) throws Exception { |
| | | JSONObject orderJson = new JSONObject(orderMap); |
| | | String orderIdType = orderJson.getString("orderIdType"); |
| | | String orderIdTypeLetter = orderJson.getString("orderIdTypeLetter"); |
| | | Integer orderIdTypeMantissa = orderJson.getInteger("orderIdTypeMantissa"); |
| | | Order order = JSONObject.parseObject(JSONObject.toJSONString(orderJson.get("title")), Order.class); |
| | | List<OrderDetail> OrderDetails = JSONArray.parseArray(JSONObject.toJSONString(orderJson.get("detail")), OrderDetail.class); |
| | | List<OrderOtherMoney> orderOtherMoneyList = JSONArray.parseArray(JSONObject.toJSONString(orderJson.get("otherMoney")), OrderOtherMoney.class); |
| | |
| | | log.setContent(orderMap.toString()); |
| | | |
| | | if(order.getOrderId() == null || order.getOrderId().isEmpty()){ |
| | | insertOrder(order,OrderDetails,orderOtherMoneyList,orderIdType, (Map<String, String>) orderMap.get("position")); |
| | | insertOrder(order, |
| | | OrderDetails,orderOtherMoneyList,orderIdType, |
| | | (Map<String, String>) orderMap.get("position"), |
| | | orderIdTypeLetter, |
| | | orderIdTypeMantissa |
| | | ); |
| | | log.setFunction("saveOrderå建:"+order.getOrderId()); |
| | | }else { |
| | | updateOrder(order,OrderDetails,orderOtherMoneyList,(Map<String, String>) orderMap.get("position")); |
| | |
| | | return map; |
| | | } |
| | | //çæè®¢åæ°æ® |
| | | public void insertOrder(Order order, List<OrderDetail> OrderDetails, List<OrderOtherMoney> orderOtherMoneyList, String orderIdType, Map<String,String> position) { |
| | | public void insertOrder(Order order, List<OrderDetail> OrderDetails, List<OrderOtherMoney> orderOtherMoneyList, String orderIdType, Map<String,String> position, String orderIdTypeLetter, Integer orderIdTypeMantissa) { |
| | | //æ ¹æ®ä¼ å
¥çå½åæä»½æè
å½å¤©çæè®¢åid |
| | | String orderId = getOrderId(orderIdType); |
| | | String orderId = getOrderId(orderIdType,orderIdTypeLetter,orderIdTypeMantissa); |
| | | //å¾ä¸»è¡¨ææ°æ® |
| | | order.setOrderId(orderId); |
| | | order.setCreateOrder(2); |
| | |
| | | insertOtherDetail(orderId,OrderDetails,orderOtherMoneyList,position); |
| | | } |
| | | |
| | | private String getOrderId(String dateType){ |
| | | private String getOrderId(String dateType, String orderIdTypeLetter, Integer orderIdTypeMantissa){ |
| | | String orderId = null; |
| | | Integer orderIdTypeLetterLen = orderIdTypeLetter.length(); |
| | | Integer count = orderIdTypeLetterLen+orderIdTypeMantissa; |
| | | if(dateType==null || dateType.equals("day")){ |
| | | Integer maxOrderId = orderMapper.selectMaxOrderId(); |
| | | //æ¥è¯¢è®¢åidï¼å¹¶ä¸èªå¢ |
| | | String formattedNumber = String.format("%02d", maxOrderId+1); |
| | | String formattedNumber = String.format("%0"+orderIdTypeMantissa+"d", maxOrderId+1); |
| | | //æ ¼å¼åå½åæ¥æ |
| | | Date currentDate = new Date(); |
| | | SimpleDateFormat dateFormat = new SimpleDateFormat("yyMMdd"); |
| | | String formattedDate = dateFormat.format(currentDate); |
| | | orderId = "NG"+formattedDate+formattedNumber; |
| | | orderId = orderIdTypeLetter+formattedDate+formattedNumber; |
| | | }else if(dateType.equals("month")){ |
| | | Integer maxOrderId = orderMapper.selectMaxOrderIdByMonth(); |
| | | String formattedNumber = String.format("%04d", maxOrderId+1); |
| | | String formattedNumber = String.format("%0"+(orderIdTypeMantissa+2)+"d", maxOrderId+1); |
| | | Date currentDate = new Date(); |
| | | SimpleDateFormat dateFormat = new SimpleDateFormat("yyMM"); |
| | | String formattedDate = dateFormat.format(currentDate); |
| | | orderId = "NG"+formattedDate+formattedNumber; |
| | | orderId = orderIdTypeLetter+formattedDate+formattedNumber; |
| | | |
| | | }else if(dateType.equals("year")){ |
| | | Integer maxOrderId = orderMapper.selectMaxOrderIdByYear(); |
| | | String formattedNumber = String.format("%06d", maxOrderId+1); |
| | | String formattedNumber = String.format("%"+(orderIdTypeMantissa+4)+"d", maxOrderId+1); |
| | | Date currentDate = new Date(); |
| | | SimpleDateFormat dateFormat = new SimpleDateFormat("yy"); |
| | | String formattedDate = dateFormat.format(currentDate); |
| | | orderId = "NG"+formattedDate+formattedNumber; |
| | | orderId = orderIdTypeLetter+formattedDate+formattedNumber; |
| | | } |
| | | return orderId; |
| | | } |
| | |
| | | pd.separation, |
| | | fc.technology_number, |
| | | IFNULL(JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S02')),'') as mapNumber, |
| | | od.building_number |
| | | od.building_number, |
| | | od.weight |
| | | from flow_card as fc |
| | | left join sd.order_glass_detail as ogd |
| | | on fc.order_id = ogd.order_id and fc.order_number = ogd.order_number and |
| | |
| | | pd.separation, |
| | | #{compound} as technology_number, |
| | | IFNULL(JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S02')),'') as mapNumber, |
| | | od.building_number |
| | | od.building_number, |
| | | od.weight |
| | | from flow_card as fc |
| | | left join sd.order_glass_detail as ogd |
| | | on fc.order_id = ogd.order_id and fc.order_number = ogd.order_number and |