Merge branch 'master' of http://10.153.19.25:10105/r/ERP_override
| | |
| | | <tr class="day-in" v-for="(items, index1) in item.productDetail" :key="index1"> |
| | | <td>{{items.orderNumber}}</td> |
| | | <td>{{items.buildingNumber}}</td> |
| | | <td colspan="3" style="font-size: 20px;font-weight: bold;" v-if="items.otherColumns?.S02">{{items.otherColumns?.S02}}</td> |
| | | <td colspan="3" style="font-size: 20px;font-weight: bold;" v-if="items.otherColumns?.S02&&company.companyName!='上海北玻玻璃技术工业有限公司'">{{items.otherColumns?.S02}}</td> |
| | | <td colspan="3" style="font-size: 17px;white-space:nowrap;font-weight: bold;" v-else-if="items.differentSize===1 && items.bendRadius==null"> |
| | | <template v-for="(orderGlassDetail, index1) in items.orderGlassDetails" > |
| | | ({{orderGlassDetail.childWidth}}x{{orderGlassDetail.childHeight}}) |
| | |
| | | {field: 'breakageType', width: 120,title: t('reportingWorks.breakageType'), sortable: true,showOverflow:"ellipsis",filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'breakageReason', width: 100,title: t('reportingWorks.breakageReason'), sortable: true,showOverflow:"ellipsis"}, |
| | | {field: 'breakageQuantity', width: 100,title: t('reportingWorks.quantityBroken'), sortable: true}, |
| | | {field: 'responsiblePersonnel', width: 120,title: t('rework.responsibilityInformation'), sortable: true,showOverflow:"ellipsis",filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'area',width: 100, title: t('reportingWorks.wornArea'), sortable: true}, |
| | | {field: 'project', width: 120,title: t('order.project'), sortable: true,filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'orderId',width: 120, title: t('order.orderId'), sortable: true,filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | |
| | | private String responsibleProcess; |
| | | @ExcelProperty("责任班组") |
| | | private String responsibleTeam; |
| | | @ExcelProperty("责任信息") |
| | | private String responsiblePersonnel; |
| | | @ExcelProperty("报工工序") |
| | | private String thisProcess; |
| | | @ExcelProperty("次破类型") |
| | |
| | | <result column="glass_child" property="glassChild"/> |
| | | <result column="process_id" property="processId"/> |
| | | <result column="code" property="code"/> |
| | | <result column="responsible_personnel" property="responsiblePersonnel"/> |
| | | </resultMap> |
| | | |
| | | |
| | |
| | | dd.responsible_team, |
| | | dd.breakage_type, |
| | | dd.breakage_reason, |
| | | dd.responsible_personnel, |
| | | ROUND((dd.breakage_quantity)) as breakage_quantity, |
| | | round(ogd.child_width * ogd.child_height * (dd.breakage_quantity) / 1000000, 2) as area, |
| | | rw.this_process, |
| | |
| | | <if test="crossProcessBreakingDTO.orderId != null and crossProcessBreakingDTO.orderId != ''"> |
| | | and o.order_id regexp #{crossProcessBreakingDTO.orderId} |
| | | </if> |
| | | <if test="crossProcessBreakingDTO.responsiblePersonnel != null and crossProcessBreakingDTO.responsiblePersonnel != ''"> |
| | | and dd.responsible_personnel regexp #{crossProcessBreakingDTO.responsiblePersonnel} |
| | | </if> |
| | | GROUP BY dd.id |
| | | order by dd.id desc |
| | | limit #{offset},#{pageSize} |
| | |
| | | <if test="crossProcessBreakingDTO.orderId != null and crossProcessBreakingDTO.orderId != ''"> |
| | | and o.order_id regexp #{crossProcessBreakingDTO.orderId} |
| | | </if> |
| | | <if test="crossProcessBreakingDTO.responsiblePersonnel != null and crossProcessBreakingDTO.responsiblePersonnel != ''"> |
| | | and dd.responsible_personnel regexp #{crossProcessBreakingDTO.responsiblePersonnel} |
| | | </if> |
| | | order by dd.id desc |
| | | </select> |
| | | |