| | |
| | | printProject:null, |
| | | merges:null, |
| | | printFc:null, |
| | | flashback:null |
| | | flashback:null, |
| | | compound:null |
| | | }) |
| | | |
| | | const {currentRoute} = useRouter() |
| | |
| | | if (merges == '') { |
| | | merges = null |
| | | } |
| | | |
| | | //指定层同架 |
| | | let compound = props.compound |
| | | if (compound == '') { |
| | | compound = null |
| | | } |
| | | let name=company.companyName |
| | | |
| | | let printNumberFc = props.printFc |
| | |
| | | } |
| | | }) |
| | | }else{ |
| | | request.post(`/processCard/getSelectPrinting/${merge}/${like}/${merges}/${props.flashback}`, data.value).then((res) => { |
| | | request.post(`/processCard/getSelectPrinting/${merge}/${like}/${merges}/${props.flashback}/${compound}`, data.value).then((res) => { |
| | | if (res.code == 200) { |
| | | load(res.data.data) |
| | | } else { |
| | |
| | | <div id="bj" v-if="printFc=='true'" style="float: right;font-size: 28px">{{ id + 1 }}</div> |
| | | <div id="bj" v-else style="float: right;font-size: 28px"></div> |
| | | <div>{{ company.companyName }}</div> |
| | | <div>生产流程卡<span style="font-weight: bold" v-if="printProject!=null">({{ printProject }})</span></div> |
| | | <div> |
| | | 生产流程卡<span style="font-weight: bold" v-if="printProject!=null">({{ printProject }})</span> |
| | | <span style="font-weight: bold" v-if="props.compound!=null">({{ props.compound }}层同架)</span> |
| | | </div> |
| | | <div style="font-weight: bolder;display: flex;justify-content:space-between"> |
| | | <div> |
| | | 打印人:{{user.user.userName}} |
| | |
| | | selectDetailProcessCard:"流程卡明细查询" |
| | | |
| | | }, |
| | | flashback:'倒叙', |
| | | printCompound:'需要同架的层', |
| | | flashback:'倒序', |
| | | processId:'رقم بطاقة العملية', |
| | | founder:'موزع الرفوف', |
| | | layoutStatus:'الحالة', |
| | |
| | | printFlowCard:"Process card printing", |
| | | selectDetailProcessCard:"Process card details query" |
| | | }, |
| | | flashback:'倒叙', |
| | | printCompound:'需要同架的层', |
| | | flashback:'倒序', |
| | | processId:'Process Card Number', |
| | | founder:'Divider', |
| | | layoutStatus:'Type Setting', |
| | |
| | | selectDetailProcessCard:'프로세스 카드 상세 조회' |
| | | |
| | | }, |
| | | flashback:'倒叙', |
| | | printCompound:'需要同架的层', |
| | | flashback:'倒序', |
| | | processId:'프로세스 카드 번호', |
| | | founder:'분배 작업자', |
| | | layoutStatus:'가공 배치 상태', |
| | |
| | | printFlowCard:"流程卡打印", |
| | | selectDetailProcessCard:"流程卡明细查询" |
| | | }, |
| | | flashback:'倒叙', |
| | | printCompound:'需要同架的层', |
| | | flashback:'倒序', |
| | | processId:'Номер процесса', |
| | | founder:'Диспетчер', |
| | | layoutStatus:'Формат', |
| | |
| | | selectDetailProcessCard:"流程卡明细查询" |
| | | |
| | | }, |
| | | flashback:'倒叙', |
| | | printCompound:'需要同架的层', |
| | | flashback:'倒序', |
| | | processId:'流程卡号', |
| | | founder:'分架员', |
| | | layoutStatus:'排版状态', |
| | |
| | | like: null, |
| | | merge: null, |
| | | printFc:null, |
| | | flashback:null |
| | | flashback:null, |
| | | compound:null |
| | | }) |
| | | |
| | | //标签 |
| | |
| | | |
| | | //倒叙 |
| | | let flashback = ref(1) |
| | | //合架打印 |
| | | let compound = ref(null) |
| | | |
| | | const getTableRow = (row, type) => { |
| | | switch (type) { |
| | |
| | | printRow.value.merge = company.flowCardMerge |
| | | printRow.value.printFc= printFc |
| | | printRow.value.flashback = flashback.value |
| | | printRow.value.compound = compound.value |
| | | // router.push({path: '/main/processCard/printProcess', query: {printList: JSON.stringify(selectRecords),printMerge:printMergeVal}}) |
| | | if(company.companyName=='常州市吉利玻璃有限公司'){ |
| | | dialogTableVisibleStraight.value = true |
| | |
| | | > |
| | | {{ t('processCard.flashback') }} |
| | | </el-checkbox> |
| | | <el-input |
| | | v-model="compound" |
| | | :placeholder="$t('processCard.printCompound')" |
| | | clearable |
| | | style="margin-left:20px; width: 110px;" |
| | | /> |
| | | |
| | | </template> |
| | | <!-- @toolbar-button-click="toolbarButtonClickEvent"--> |
| | | <!-- 下拉显示所有信息插槽--> |
| | |
| | | :printFc="printRow.printFc" |
| | | :merges="printRow.merge" |
| | | :flashback = "printRow.flashback" |
| | | :compound = "printRow.compound" |
| | | style="width: 100%;height: 100%"/> |
| | | </el-dialog> |
| | | |
| | |
| | | const company = companyInfo() |
| | | let hidePrintLabels = company.printLabel.hideButton; |
| | | |
| | | //倒叙 |
| | | let flashback = ref(1) |
| | | //合架打印 |
| | | let compound = ref(null) |
| | | |
| | | const form = reactive({ |
| | | date1: '', |
| | | orderId: '', |
| | |
| | | printMergeVal: null, |
| | | like: null, |
| | | project:null, |
| | | merge: null |
| | | merge: null, |
| | | flashback:null, |
| | | compound:null |
| | | }) |
| | | const getTableRow = (row, type) => { |
| | | switch (type) { |
| | |
| | | case 'edit3' :{ |
| | | printRow.value.project=row.project_no |
| | | printRow.value.merge = company.flowCardMerge |
| | | printRow.value.flashback = flashback.value |
| | | printRow.value.compound = compound.value |
| | | if(company.companyName=='常州市吉利玻璃有限公司'){ |
| | | dialogTableVisibleStraight.value = true |
| | | }else{ |
| | |
| | | :printMerge="printRow.printMergeVal" |
| | | :printProject="printRow.project" |
| | | :merges="printRow.merge" |
| | | :flashback = "printRow.flashback" |
| | | :compound = "printRow.compound" |
| | | style="width: 100%;height: 100%"/> |
| | | </el-dialog> |
| | | |
| | |
| | | } |
| | | |
| | | @ApiOperation("打印流程卡数据查询接口") |
| | | @PostMapping("/getSelectPrinting/{printMerge}/{printLike}/{merge}/{flashback}") |
| | | @PostMapping("/getSelectPrinting/{printMerge}/{printLike}/{merge}/{flashback}/{compound}") |
| | | public Result getSelectPrinting( |
| | | @PathVariable String printMerge, |
| | | @PathVariable String printLike, |
| | | @PathVariable String merge, |
| | | @PathVariable String flashback, |
| | | @PathVariable String compound, |
| | | @RequestBody Map<String, Object> object) { |
| | | return Result.seccess(flowCardService.getSelectPrintingSv(object,printMerge,printLike,merge,flashback)); |
| | | return Result.seccess(flowCardService.getSelectPrintingSv(object,printMerge,printLike,merge,flashback,compound)); |
| | | } |
| | | |
| | | @ApiOperation("工程打印流程卡数据查询接口") |
| | |
| | | List<FlowCardDTO> exportDateProcessMp(List<LocalDate> date); |
| | | |
| | | Integer getSumQuantity(String orderId); |
| | | |
| | | List<Map<String, Object>> getDetailCompoundList(String processId, String technologyNumber, String process, String flashback, String compound); |
| | | |
| | | List<Map<String, Object>> getDetailListLikeCompound(String processId, String s, String process, String flashback, String compound); |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | public Map<String, Object> getSelectPrintingSv(Map<String, Object> object, String printMerge, String printLike, String merge, String flashback) { |
| | | public Map<String, Object> getSelectPrintingSv(Map<String, Object> object, String printMerge, String printLike, String merge, String flashback, String compound) { |
| | | if (printMerge == null) { |
| | | printMerge = ""; |
| | | } |
| | |
| | | //获取工序对应的别称 |
| | | String processName = flowCardMapper.getProcessName(processSub); |
| | | if (processName.equals("stepC") || processName.equals("stepD")) {//工艺是否包含夹胶中空 |
| | | itemmap.put("detail", flowCardMapper.getPrimaryListLimt(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()), flowCard.getGlassChild(), flowCard.getProcess(), flowCard.getOrderId())); |
| | | itemmap.put("detail", flowCardMapper.getPrimaryListLimt(flowCard.getProcessId(), |
| | | String.valueOf(compound != null |
| | | ? compound //同架层 |
| | | : flowCard.getTechnologyNumber()),//正常层 |
| | | flowCard.getGlassChild(), flowCard.getProcess(), flowCard.getOrderId())); |
| | | |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailList(flowCard.getProcessId(), flowCard.getTechnologyNumber(), flowCard.getProcess(),flashback); |
| | | itemmap.put("detailList", detailList); |
| | | if (compound == null |
| | | || "null".equals(compound) |
| | | || compound.trim().isEmpty()){ |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailList(flowCard.getProcessId(), flowCard.getTechnologyNumber(), flowCard.getProcess(),flashback); |
| | | itemmap.put("detailList", detailList); |
| | | }else {//有需要同架的层 |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailCompoundList(flowCard.getProcessId(), flowCard.getTechnologyNumber(), flowCard.getProcess(),flashback,compound); |
| | | itemmap.put("detailList", detailList); |
| | | } |
| | | } else { |
| | | if (merge.equals("1") && flowCard.getMerge().equals(1)) {//否 |
| | | // 检查是否已经处理过该 processId,如果处理过则跳过 |
| | |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListMerge(flowCard.getProcessId(), flowCard.getProcess(),flashback); |
| | | itemmap.put("detailList", detailList); |
| | | } else { |
| | | itemmap.put("detail", flowCardMapper.getPrimaryList(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()), flowCard.getGlassChild(), flowCard.getProcess(), flowCard.getOrderId())); |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListLike(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()), flowCard.getProcess(),flashback); |
| | | itemmap.put("detailList", detailList); |
| | | itemmap.put("detail", flowCardMapper.getPrimaryListLimt(flowCard.getProcessId(), |
| | | String.valueOf(flashback != null |
| | | ? compound //同架层 |
| | | : flowCard.getTechnologyNumber()),//正常层 |
| | | flowCard.getGlassChild(), flowCard.getProcess(), flowCard.getOrderId())); |
| | | if (compound == null |
| | | || "null".equals(compound) |
| | | || compound.trim().isEmpty()){ |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListLike(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()), flowCard.getProcess(),flashback); |
| | | itemmap.put("detailList", detailList); |
| | | }else {//有需要同架的层 |
| | | List<Map<String, Object>> detailList = flowCardMapper.getDetailListLikeCompound(flowCard.getProcessId(), String.valueOf(flowCard.getTechnologyNumber()), flowCard.getProcess(),flashback,compound); |
| | | itemmap.put("detailList", detailList); |
| | | } |
| | | } |
| | | |
| | | } |
| | |
| | | <select id="getSumQuantity"> |
| | | select quantity from sd.`order` where order_id=#{orderId} |
| | | </select> |
| | | |
| | | <select id="getDetailCompoundList"> |
| | | select fc.order_number, |
| | | concat(IF(ROUND(ogd.child_width, 1) = FLOOR(ogd.child_width), FLOOR(ogd.child_width), ROUND(ogd.child_width, 1)), "*", IF(ROUND(child_height, 1) = FLOOR(child_height), FLOOR(child_height), ROUND(child_height, 1))) as child_width, |
| | | SUM(fc.quantity) as quantity, |
| | | round(SUM(ogd.total_area), 2) as total_area, |
| | | SUM(od.perimeter) as perimeter, |
| | | if(od.bend_radius!=null || od.bend_radius!='',od.bend_radius,if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),'')) as bend_radius, |
| | | concat(IFNULL(od.processing_note, ''), IFNULL(od.remarks, '')) as remarks, |
| | | od.other_columns, |
| | | round(ogd.child_width) as width, |
| | | round(ogd.child_height) as height, |
| | | pd.separation, |
| | | #{compound} as technology_number, |
| | | IFNULL(JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S02')),'') as mapNumber, |
| | | od.building_number |
| | | 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.product_detail as pd |
| | | on pd.prod_id = od.product_id and pd.glass_sort = ogd.technology_number |
| | | left join flow_card_sort as fcs |
| | | on fcs.process_id = fc.process_id and fcs.order_number = fc.order_number and |
| | | fcs.technology_number = fc.technology_number |
| | | and fcs.process = #{process} |
| | | where fc.process_id = #{processId} |
| | | and position(fc.technology_number in #{compound}) |
| | | group by fc.process_id, fc.order_number |
| | | <choose> |
| | | <!-- flashback = 1 时正序 --> |
| | | <when test="flashback == 1"> |
| | | ORDER BY |
| | | CASE |
| | | WHEN fcs.sort IS NOT NULL AND fcs.sort <> '' THEN fcs.sort |
| | | ELSE fc.order_number |
| | | END ASC |
| | | </when> |
| | | <!-- flashback != 1 时倒序 --> |
| | | <otherwise> |
| | | ORDER BY |
| | | CASE |
| | | WHEN fcs.sort IS NOT NULL AND fcs.sort <> '' THEN fcs.sort |
| | | ELSE fc.order_number |
| | | END DESC |
| | | </otherwise> |
| | | </choose> |
| | | </select> |
| | | |
| | | <select id="getDetailListLikeCompound"> |
| | | select fc.order_number, |
| | | concat(IF(ROUND(ogd.child_width, 1) = FLOOR(ogd.child_width), FLOOR(ogd.child_width), ROUND(ogd.child_width, 1)), "*", IF(ROUND(child_height, 1) = FLOOR(child_height), FLOOR(child_height), ROUND(child_height, 1))) as child_width, |
| | | sum(fc.quantity) as quantity, |
| | | round(sum(ogd.total_area), 2) as total_area, |
| | | sum(od.perimeter) as perimeter, |
| | | if(od.bend_radius!=null || od.bend_radius!='',od.bend_radius,if(od.shape=2,JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S04')),'')) as bend_radius, |
| | | concat(IFNULL(od.processing_note, ''), IFNULL(od.remarks, '')) as remarks, |
| | | od.other_columns, |
| | | round(ogd.child_width) as width, |
| | | round(ogd.child_height) as height, |
| | | pd.separation, |
| | | #{compound} as technology_number, |
| | | IFNULL(JSON_UNQUOTE(JSON_EXTRACT(od.other_columns, '$.S02')),'') as mapNumber, |
| | | od.building_number |
| | | 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.product_detail as pd |
| | | on pd.prod_id = od.product_id and pd.glass_sort = ogd.technology_number |
| | | left join flow_card_sort as fcs |
| | | on fcs.process_id = fc.process_id and fcs.order_number = fc.order_number and |
| | | fcs.technology_number = fc.technology_number |
| | | and fcs.process = #{process} |
| | | where fc.process_id = #{processId} |
| | | and position(fc.technology_number in #{compound}) |
| | | group by fc.process_id, fc.order_number |
| | | <choose> |
| | | <!-- flashback = 1 时正序 --> |
| | | <when test="flashback == 1"> |
| | | ORDER BY |
| | | CASE |
| | | WHEN fcs.sort IS NOT NULL AND fcs.sort <> '' THEN fcs.sort |
| | | ELSE fc.order_number |
| | | END ASC |
| | | </when> |
| | | <!-- flashback != 1 时倒序 --> |
| | | <otherwise> |
| | | ORDER BY |
| | | CASE |
| | | WHEN fcs.sort IS NOT NULL AND fcs.sort <> '' THEN fcs.sort |
| | | ELSE fc.order_number |
| | | END DESC |
| | | </otherwise> |
| | | </choose> |
| | | </select> |
| | | </mapper> |