| | |
| | | produceList.value[i].detail[0]["qrcodeList"] = []; // 初始化一个空数组用来存储 QR Code |
| | | |
| | | const processId = produceList.value[i].detail[0].process_id; |
| | | const url = `${processId}/${technologyNumber}`; |
| | | console.log(url) |
| | | const url = `${processId}/${technologyNumber}` |
| | | // 生成 QR Code 并存储到数组中 |
| | | const qrcodeData = await QRCode.toDataURL(url); |
| | | produceList.value[i].detail[0]["qrcodeList"].push({ |
| | |
| | | ogd.glass_child, |
| | | fc.patch_state, |
| | | ogd.process |
| | | from (select process_id,count(*) as quantity,order_sort,project_no,layer,patch_state from pp.optimize_detail where project_no = #{printProject} group by process_id,layer) as fc |
| | | from (select process_id,count(*) as quantity,order_sort,project_no,layer,patch_state from pp.optimize_detail where project_no = #{printProject} group by process_id,order_sort,layer) as fc |
| | | left join sd.order_glass_detail as ogd |
| | | on ogd.order_id = SUBSTRING(fc.process_id,1,10) and ogd.order_number = fc.order_sort and |
| | | ogd.technology_number = fc.layer |
| | | left join sd.order_detail as od on od.order_id = SUBSTRING(fc.process_id,1,10) and od.order_number = fc.order_sort |
| | | left join sd.`order` as o on o.order_id = SUBSTRING(fc.process_id,1,10) |
| | | where fc.project_no = #{printProject} |
| | | GROUP BY fc.process_id, ogd.technology_number |
| | | GROUP BY fc.process_id,fc.order_sort, ogd.technology_number |
| | | order by fc.process_id, ogd.technology_number |
| | | </select> |
| | | |