Merge branch 'master' of http://bore.pub:10439/r/ERP_override
| | |
| | | const route = currentRoute.value |
| | | let type = props.type |
| | | let faceOrientation = props.faceOrientation |
| | | if (type==="英文标签" && faceOrientation==="此面为室内面"){ |
| | | faceOrientation='INSIDE' |
| | | } |
| | | else if (type==="英文标签" && faceOrientation==="此面为室外面"){ |
| | | faceOrientation='OUTSIDE' |
| | | } |
| | | let lableType = props.lableType |
| | | data.value.printList = JSON.parse(props.list) |
| | | onMounted(() => { |
| | |
| | | ],//表头按钮 |
| | | |
| | | toolbarConfig: { |
| | | // buttons: [{ |
| | | // |
| | | // }], |
| | | // import: false, |
| | | // export: true, |
| | | // print: true, |
| | | // buttons: [ |
| | | // {code: 'editCheckbox', name: t('basicData.edit'), status: 'primary'}, |
| | | // ], |
| | | zoom: true, |
| | | custom: true |
| | | }, |
| | |
| | | sum(od.weight) as weight, |
| | | #{technologyNumber} as technologyNumber, |
| | | concat(fc.process_id, '/', #{technologyNumber}) as processIdNumber, |
| | | concat("对应我司", TRIM( |
| | | SUBSTRING( |
| | | o.processing_note, |
| | | LOCATE('对应我司', o.processing_note) + CHAR_LENGTH('对应我司') |
| | | )) |
| | | ) AS otherRemarks |
| | | 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 |
| | |
| | | if(od.shape=1,'普形',if(od.shape=2,'异形','')) as shape, |
| | | sum( pd.thickness ) as thickness, |
| | | od.edging_type, |
| | | rwd.completed_quantity, |
| | | ROUND(MAX( ogd.child_width )*MAX( ogd.child_height )*rwd.completed_quantity/1000000,2) as area, |
| | | opd.reporting_work_num as completed_quantity, |
| | | ROUND(MAX( ogd.child_width )*MAX( ogd.child_height )*opd.reporting_work_num/1000000,2) as area, |
| | | od.product_name, |
| | | JSON_UNQUOTE( JSON_EXTRACT( od.other_columns, '$.S01' )) AS code |
| | | FROM |
| | |
| | | sd.product_detail |
| | | WHERE |
| | | detail_type = "glass" |
| | | ) AS pd ON pd.prod_id = od.product_id |
| | | AND pd.glass_sort = rwd.technology_number |
| | | where rw.reviewed_state=1 and rw.reporting_work_time between #{selectTime1} and #{selectTime2} |
| | | ) AS pd ON pd.prod_id = od.product_id AND pd.glass_sort = rwd.technology_number |
| | | LEFT JOIN sd.order_process_detail AS opd ON opd.order_id = o.order_id |
| | | AND opd.process_id = rw.process_id |
| | | AND opd.order_number = ogd.order_number |
| | | AND opd.technology_number = ogd.technology_number |
| | | where opd.reporting_work_num > 0 and rw.reviewed_state=1 and rw.reporting_work_time between #{selectTime1} and #{selectTime2} |
| | | and position(#{selectProcesses} in rw.this_process) |
| | | <if test="teamOutputDTO.thisProcess != null and teamOutputDTO.thisProcess != ''"> |
| | | and rw.this_process regexp #{teamOutputDTO.thisProcess} |
| | |
| | | </if> |
| | | |
| | | GROUP BY |
| | | rwd.order_number, |
| | | rw.this_process, |
| | | rw.teams_groups_name, |
| | | rw.process_id, |
| | | rw.reporting_work_id |
| | | rwd.order_number |
| | | ORDER BY |
| | | rw.this_process, |
| | | rw.process_id, |
| | | rwd.order_number, |
| | | rw.reporting_work_time, |
| | | rw.teams_groups_name, |
| | | rw.process_id |
| | | rw.teams_groups_name |
| | | limit #{offset},#{pageSize}; |
| | | </select> |
| | | |
| | |
| | | sd.product_detail |
| | | WHERE |
| | | detail_type = "glass" |
| | | ) AS pd ON pd.prod_id = od.product_id |
| | | AND pd.glass_sort = rwd.technology_number |
| | | where rw.reviewed_state=1 and rw.reporting_work_time between #{selectTime1} and #{selectTime2} |
| | | ) AS pd ON pd.prod_id = od.product_id AND pd.glass_sort = rwd.technology_number |
| | | LEFT JOIN sd.order_process_detail AS opd ON opd.order_id = o.order_id |
| | | AND opd.process_id = rw.process_id |
| | | AND opd.order_number = ogd.order_number |
| | | AND opd.technology_number = ogd.technology_number |
| | | where opd.reporting_work_num > 0 and rw.reviewed_state=1 and rw.reporting_work_time between #{selectTime1} and #{selectTime2} |
| | | and position(#{selectProcesses} in rw.this_process) |
| | | <if test="teamOutputDTO.thisProcess != null and teamOutputDTO.thisProcess != ''"> |
| | | and rw.this_process regexp #{teamOutputDTO.thisProcess} |