| | |
| | | addFlowCardMsg2:'请选择未分架订单打印', |
| | | okFlowCard:'已分架', |
| | | noFlowCard:'未分架', |
| | | mainWidth:'宽高', |
| | | mainHeight:'高宽', |
| | | terminationQuantity:'生产终止数量', |
| | | terminationMsg:'请输入正确的可修改数量', |
| | | maxCompleted:'最大已完工数量', |
| | | }, |
| | | reportingWorks:{ |
| | | page:{ |
| | |
| | | addFlowCardMsg2:'请选择未分架订单打印', |
| | | okFlowCard:'已分架', |
| | | noFlowCard:'未分架', |
| | | mainWidth:'宽高', |
| | | mainHeight:'高宽', |
| | | terminationQuantity:'生产终止数量', |
| | | terminationMsg:'请输入正确的可修改数量', |
| | | maxCompleted:'最大已完工数量', |
| | | }, |
| | | reportingWorks:{ |
| | | page:{ |
| | |
| | | addFlowCardMsg2:'请选择未分架订单打印', |
| | | okFlowCard:'已分架', |
| | | noFlowCard:'未分架', |
| | | mainWidth:'宽高', |
| | | mainHeight:'高宽', |
| | | terminationQuantity:'生产终止数量', |
| | | terminationMsg:'请输入正确的可修改数量', |
| | | maxCompleted:'最大已完工数量', |
| | | }, |
| | | reportingWorks:{ |
| | | page:{ |
| | |
| | | addFlowCardMsg2:'请选择未分架订单打印', |
| | | okFlowCard:'已分架', |
| | | noFlowCard:'未分架', |
| | | mainWidth:'宽高', |
| | | mainHeight:'高宽', |
| | | terminationQuantity:'生产终止数量', |
| | | terminationMsg:'请输入正确的可修改数量', |
| | | maxCompleted:'最大已完工数量', |
| | | }, |
| | | reportingWorks:{ |
| | | page:{ |
| | |
| | | mainHeight:'高宽', |
| | | terminationQuantity:'生产终止数量', |
| | | terminationMsg:'请输入正确的可修改数量', |
| | | maxCompleted:'最大已完工数量', |
| | | }, |
| | | reportingWorks:{ |
| | | page:{ |
| | |
| | | completed.value=res.data.data |
| | | completedOk.value = row.quantity*1 - completed.value*1 |
| | | //弹窗 |
| | | ElMessageBox.prompt( '最大已完工数量:'+completed.value, { |
| | | ElMessageBox.prompt( t('processCard.maxCompleted')+completed.value, { |
| | | confirmButtonText: t('basicData.save'), |
| | | cancelButtonText: t('basicData.cancelButtonText'), |
| | | inputPattern:/^(\d+|)$/, |
| | | inputErrorMessage: t('processCard.terminationMsg'), |
| | | inputValue:row.quantity |
| | | }).then(({ value }) => { |
| | | console.log(completedOk.value, value) |
| | | if (completedOk.value < value ) { |
| | | ElMessage.warning(t('processCard.terminationMsg')) |
| | | return |
| | |
| | | {field: 'order_number', title: t('order.OrderNum') ,filters:[{ data: '' }],slots: { filter: 'num1_filter' },width: 100}, |
| | | {field: 'technology_number', title: t('processCard.technologyNumber') ,filters:[{ data: '' }],slots: { filter: 'num1_filter' },width: 100}, |
| | | {field: 'quantity', title: t('order.quantity'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, width: 80}, |
| | | {field: 'termination_quantity', title: t('processCard.terminationQuantity'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, width: 80}, |
| | | {field: 'child_width', title: t('order.width'),width: 80 }, |
| | | {field: 'child_height', title: t('order.height'),width: 80 }, |
| | | {field: 'area', title: t('order.area') ,showOverflow:"ellipsis",width: 70}, |
| | |
| | | |
| | | List<Map<String,String>> filterOrderProcess(String orderId); |
| | | |
| | | List<Map<String,Integer>> getGlassLRow(String orderId); |
| | | List<Map<String,Object>> getGlassLRow(String orderId); |
| | | |
| | | List<Map<String, String>> filterLastProcess(String orderId, String orderNumber, String technologyNumber,String id); |
| | | |
| | |
| | | } |
| | | |
| | | |
| | | List<Map<String, Integer>> getRowCount = orderProcessDetailMapper.getGlassLRow(orderId); |
| | | List<Map<String, Object>> getRowCount = orderProcessDetailMapper.getGlassLRow(orderId); |
| | | List<Map<String, Integer>> rowCount = new ArrayList<>(); |
| | | columns.forEach(col -> { |
| | | getRowCount.forEach(row -> { |
| | | Map<String, Integer> getRow = new HashMap<>(); |
| | | // { row: 0, col: 1, rowspan: 3, colspan: 0}, |
| | | getRow.put("row", row.get("RowNum")); |
| | | getRow.put("row", ((Number) row.get("RowNum")).intValue()); |
| | | getRow.put("col", col); |
| | | getRow.put("rowspan", row.get("rowCount")); |
| | | getRow.put("rowspan", ((Number) row.get("rowCount")).intValue()); |
| | | getRow.put("colspan", 0); |
| | | rowCount.add(getRow); |
| | | }); |
| | |
| | | map.put("title", uniqueList); |
| | | |
| | | |
| | | List<Map<String, Integer>> getRowCount = orderProcessDetailMapper.getGlassLRow(orderId); |
| | | List<Map<String, Object>> getRowCount = orderProcessDetailMapper.getGlassLRow(orderId); |
| | | List<Map<String, Integer>> rowCount = new ArrayList<>(); |
| | | columns.forEach(col -> { |
| | | getRowCount.forEach(row -> { |
| | | Map<String, Integer> getRow = new HashMap<>(); |
| | | // { row: 0, col: 1, rowspan: 3, colspan: 0}, |
| | | getRow.put("row", row.get("RowNum")); |
| | | getRow.put("row", ((Number) row.get("RowNum")).intValue()); |
| | | getRow.put("col", col); |
| | | getRow.put("rowspan", row.get("rowCount")); |
| | | getRow.put("rowspan", ((Number) row.get("rowCount")).intValue()); |
| | | getRow.put("colspan", 0); |
| | | rowCount.add(getRow); |
| | | }); |
| | |
| | | fc.founder, |
| | | date(fc.splitFrame_time) as splitFrame_time, |
| | | ogd.process, |
| | | c.concatNumber |
| | | c.concatNumber, |
| | | ifnull(fc.termination_quantity,0) as termination_quantity |
| | | 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 |
| | |
| | | c.technology_number, |
| | | b.child_width, |
| | | b.child_height, |
| | | if(c.technology_number=1,c.quantity,0) as quantity, |
| | | if(c.technology_number=1,c.quantity-ifnull(c.termination_quantity,0),0) as quantity, |
| | | |
| | | c.quantity as thisQuantity,/*用于判断是否改变颜色*/ |
| | | c.quantity-ifnull(c.termination_quantity,0) as thisQuantity,/*用于判断是否改变颜色*/ |
| | | e.reportWorkQuantity, |
| | | e.reportWorkQuantityShow, |
| | | e.reportWorkQuantityCount, |
| | | e.reportWorkTime, |
| | | e.broken_num, |
| | | c.quantity as glassQuantity, |
| | | c.quantity-ifnull(c.termination_quantity,0) as glassQuantity, |
| | | |
| | | c.quantity as quantityShow, |
| | | c.quantity*a.area as grossAreaShow, |
| | | c.quantity-ifnull(c.termination_quantity,0) as quantityShow, |
| | | (c.quantity-ifnull(c.termination_quantity,0))*a.area as grossAreaShow, |
| | | ifnull(f.inventory, 0) as inventoryShow, |
| | | round(ifnull(f.inventory, 0) * a.area, 2) as inventoryAreaShow, |
| | | ifnull(dd.quantity, 0) as shippedQuantityShow, |
| | |
| | | on e.process_id = c.process_id |
| | | and e.technology_number = c.technology_number |
| | | and e.order_number = c.order_number |
| | | where a.order_id = #{orderId} and d.create_order>0 |
| | | where a.order_id = #{orderId} and d.create_order>0 and c.quantity-ifnull(c.termination_quantity,0)>0 |
| | | group by c.order_number, |
| | | c.technology_number, |
| | | c.process_id |
| | |
| | | a.product_name, |
| | | b.child_width, |
| | | b.child_height, |
| | | c.quantity, |
| | | c.quantity - ifnull(c.termination_quantity,0) as quantity, |
| | | c.technology_number, |
| | | b.glass_child, |
| | | ifnull(e.reportWorkQuantity, 0) as reportWorkQuantity, |
| | |
| | | and e.order_number=c.order_number |
| | | and e.technology_number = c.technology_number |
| | | left join sd.delivery_detail as dd on dd.order_id = a.order_id and dd.order_number = a.order_number |
| | | where a.order_id = #{orderId} and d.create_order>0 |
| | | where a.order_id = #{orderId} and d.create_order>0 and c.quantity - ifnull(c.termination_quantity,0)>0 |
| | | group by c.order_number,c.technology_number |
| | | ORDER BY a.order_number |
| | | </select> |