| | |
| | | </td> |
| | | |
| | | </tr> |
| | | <tr v-if="company.remarkSwitch=='1'" v-for="(itemremark,index) in item.remarkList" :key="index"> |
| | | <td colspan="29"> |
| | | 编号:{{itemremark.S01}} |
| | | 备注1:{{itemremark.S02}} |
| | | 备注2:{{itemremark.S03}} |
| | | 备注3:{{itemremark.S04}} |
| | | 备注4:{{itemremark.S05}} |
| | | |
| | | </td> |
| | | </tr> |
| | | <tr v-for="(itemtextareas,index) in item.detail" :key="index"> |
| | | <td colspan="29" rowspan="6" style="width: 480px;height: 150px "> |
| | | <td colspan="29" style="width: 480px;height: 150px "> |
| | | <div style="width: 100%;height: 100%;"><textarea style="height: 99%;width: 99%;border: none;;font-size: 12px;overflow: hidden;">{{itemtextareas.processing_note}}</textarea> |
| | | </div> |
| | | </td> |
| | | </tr> |
| | | |
| | | </tfoot> |
| | | </table> |
| | | </div> |
| | |
| | | page-break-inside: auto; |
| | | } |
| | | |
| | | #contentTable thead { |
| | | thead { |
| | | display: table-header-group; |
| | | page-break-inside: avoid; |
| | | } |
| | | |
| | | tfoot { |
| | |
| | | List<Map<String, Object>> selectSortTableMp(String orderId); |
| | | |
| | | String countFlowCard(String orderId); |
| | | |
| | | List<Map<String, Object>> remakList(String processId); |
| | | } |
| | |
| | | itemmap.put("processList", processList); |
| | | // itemmap.put("numberList", numberList); |
| | | itemmap.put("count", flowCardMapper.countFlowCard(flowCard.getOrderId())); |
| | | itemmap.put("remarkList", flowCardMapper.remakList(flowCard.getProcessId())); |
| | | list.add(itemmap); |
| | | |
| | | } |
| | |
| | | <select id="countFlowCard"> |
| | | select count(distinct process_id) from flow_card where order_id = #{orderId} |
| | | </select> |
| | | |
| | | <select id="remakList"> |
| | | SELECT |
| | | JSON_UNQUOTE(JSON_EXTRACT(other_columns, '$.S01')) AS S01, |
| | | JSON_UNQUOTE(JSON_EXTRACT(other_columns, '$.S04')) AS S02, |
| | | JSON_UNQUOTE(JSON_EXTRACT(other_columns, '$.S05')) AS S03, |
| | | JSON_UNQUOTE(JSON_EXTRACT(other_columns, '$.S06')) AS S04, |
| | | JSON_UNQUOTE(JSON_EXTRACT(other_columns, '$.S07')) AS S05 |
| | | FROM flow_card as fc left join sd.order_detail as od on fc.order_id = od.order_id |
| | | and fc.order_number = od.order_number |
| | | WHERE fc.process_id=#{processId} |
| | | GROUP BY fc.order_number |
| | | </select> |
| | | </mapper> |