| | |
| | | |
| | | |
| | | const handleGetQRCode = async () => { |
| | | console.log(produceList.value) |
| | | for (let i = 0; i < produceList.value.length; i++) { |
| | | |
| | | const technologyNumber = produceList.value[i].detail[0].technologyNumber.toString(); // 转换为字符串以便处理每个字符 |
| | | produceList.value[i].detail[0]["qrcodeList"] = []; // 初始化一个空数组用来存储 QR Code |
| | | |
| | |
| | | alType:'order.alType', |
| | | customerBatch:'order.customerBatch', |
| | | processingNote:'order.processingNote', |
| | | remarks:'product.msg.remarks', |
| | | remarks:'产品备注', |
| | | customerAbbreviation:'customer.customerAbbreviation', |
| | | productAbbreviation:'product.msg.productAbbreviation', |
| | | processId:'processCard.processId', |
| | |
| | | if(user.user.address!==null && user.user.address!==''){ |
| | | titleUploadData.value.thisProcess = user.user.address |
| | | titleUploadData.value.teamsGroupsName = user.user.userName |
| | | if (user.user.address!=='技术部多曲'){ |
| | | groupChangeProcess.value = true |
| | | } |
| | | gridOptions.toolbarConfig.buttons[1].visible=false |
| | | } |
| | | |
| | |
| | | let errorAreaVisible = ref(false) |
| | | let otherMoneyVisible = ref(false) |
| | | let sizeCheckVisible = ref(false) |
| | | const maxTableLen =ref(200) |
| | | const maxTableLen =ref(500) |
| | | let errorArea = ref(0.4) |
| | | const userStore = useUserInfoStore() |
| | | const company = companyInfo() |
| | |
| | | Integer printAddSortCountMp(String processId, Integer orderNumber, Integer technologyNumber, Integer sort, String process); |
| | | |
| | | Boolean printUpdateSortMp(String processId, Integer orderNumber, Integer technologyNumber, Integer sort, String process); |
| | | |
| | | List<Map<String, String>> getPrimaryListLimt(String processId, String technologyNumber, String glassChild, String process); |
| | | } |
| | |
| | | //流程卡表头表尾数据 |
| | | //是否传入合并层数 |
| | | if (printMerge.equals("")||printMerge.equals("null") ){ |
| | | itemmap.put("detail", flowCardMapper.getPrimaryList(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getGlassChild(),flowCard.getProcess())); |
| | | //是否包含切割 |
| | | boolean containsCutting = flowCard.getProcess().contains("切割"); |
| | | if(String.valueOf(flowCard.getTechnologyNumber()).length()>1 && containsCutting){ |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListLike(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getProcess()); |
| | | //boolean containsCutting = flowCard.getProcess().contains("切割"); |
| | | String processSub=flowCard.getProcess().substring(0, 2); |
| | | if(processSub.equals("夹胶") || processSub.equals("中空")){ |
| | | itemmap.put("detail", flowCardMapper.getPrimaryListLimt(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getGlassChild(),flowCard.getProcess())); |
| | | |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailList(flowCard.getProcessId(), flowCard.getTechnologyNumber(),flowCard.getProcess()); |
| | | itemmap.put("detailList", detailList); |
| | | } |
| | | else { |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailList(flowCard.getProcessId(), flowCard.getTechnologyNumber(),flowCard.getProcess()); |
| | | itemmap.put("detail", flowCardMapper.getPrimaryList(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getGlassChild(),flowCard.getProcess())); |
| | | |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListLike(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()),flowCard.getProcess()); |
| | | itemmap.put("detailList", detailList); |
| | | } |
| | | |
| | |
| | | |
| | | |
| | | |
| | | if (technologicalProcess!=null || !technologicalProcess.equals("")){ |
| | | String[] processList = technologicalProcess.split("->"); |
| | | //获取工艺流程第一个工序 |
| | | String interceptProcess = processList[0]; |
| | |
| | | map.put("historyTeams", reportingWorkMapper.historyTeamsMp(processIdStr, process)); |
| | | //历史工序 |
| | | map.put("historyProcess", reportingWorkMapper.SelectHistoryProcessMp(historyProcess, process)); |
| | | } |
| | | |
| | | return map; |
| | | } |
| | | |
| | |
| | | where process is not null |
| | | and process != "" |
| | | GROUP BY order_id,process_id,technology_number,process |
| | | order by order_id,process_id,length(technology_number) |
| | | </select> |
| | | |
| | | <select id="getPrimaryList"> |
| | |
| | | where process is not null |
| | | and process != "" |
| | | GROUP BY order_id,process_id,technology_number,process |
| | | order by order_id,process_id,length(technology_number) |
| | | </select> |
| | | |
| | | <insert id="printAddSortMp"> |
| | |
| | | and technology_number = #{technologyNumber} |
| | | and process = #{process} |
| | | </update> |
| | | |
| | | <select id="getPrimaryListLimt"> |
| | | select o.customer_name, |
| | | o.project, |
| | | #{process} process, |
| | | od.edging_type, |
| | | #{glassChild} as glass_child, |
| | | od.product_name, |
| | | o.processing_note, |
| | | fc.process_id, |
| | | SUM(od.quantity) as quantity, |
| | | round(SUM(ogd.total_area), 2) as gross_area, |
| | | sum(od.weight) as weight, |
| | | #{technologyNumber} as technologyNumber, |
| | | concat(fc.process_id, '/', #{technologyNumber}) as processIdNumber, |
| | | concat('对应我司单号',o.batch) AS otherRemarks |
| | | 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 |
| | | fc.technology_number = ogd.technology_number |
| | | left join sd.order_detail as od on od.order_id = fc.order_id and od.order_number = fc.order_number |
| | | left join sd.`order` as o on o.order_id = fc.order_id |
| | | left join sd.product as p on p.id = od.product_id |
| | | left join (select ogd.order_id, |
| | | ogd.order_number, |
| | | ogd.technology_number, |
| | | ogd.glass_child, |
| | | GROUP_CONCAT(glass_child SEPARATOR ' ') AS concatenated_glass_child |
| | | from sd.order_glass_detail as ogd |
| | | where ogd.order_id = left(#{processId}, 10) |
| | | and position(ogd.technology_number in #{technologyNumber}) |
| | | GROUP BY order_id, order_number) as ogdc |
| | | on ogdc.order_id = ogd.order_id and ogdc.order_number = ogd.order_number and |
| | | ogdc.technology_number = ogd.technology_number |
| | | where fc.process_id = #{processId} |
| | | and position(fc.technology_number in #{technologyNumber}) |
| | | group by fc.process_id limit 1 |
| | | </select> |
| | | </mapper> |
| | |
| | | |
| | | <!-- 查询流程卡工艺流程--> |
| | | <select id="SelectTechnologicalProcess"> |
| | | select ogd.process |
| | | select ifnull((select ogd.process |
| | | from sd.order_glass_detail as ogd |
| | | where ogd.production_id = LEFT(#{processIdStr}, 11) |
| | | and ogd.technology_number=#{technologyStr} |
| | | limit 1 |
| | | limit 1),'') as process |
| | | |
| | | </select> |
| | | |