本帖最后由 Crystal.Li 于 2021-5-19 15:04 编辑
问题描述:数据行转列后,列是动态的,即会有多个列产生,如何使用矩表设计使得动态列横向铺满整个表格
数据源如下:
{
"statusCode": 1,
"errCode": null,
"msg": null,
"data": {
"opProductNo": "1141747",
"markerNo": "1141747-001",
"productNo": "1141747",
"pilingNo": "1141747-001",
"factoryName": "湖南新马制衣有限公司",
"customer": "FL-斐乐体育有限公司",
"markerDetailList": [
{
"markerNo": "1141747-001",
"lineSeq": 1,
"markerQty": 4,
"sizeList": [
{
"size": "S",
"count": 1.0,
"sizeSeq": 4,
"id": null,
"isEdit": 0
},
{
"size": "M",
"count": 2.0,
"sizeSeq": 5,
"id": null,
"isEdit": 0
},
{
"size": "L",
"count": 1.0,
"sizeSeq": 6,
"id": null,
"isEdit": 0
}
]
}
],
"pilingDetailList": [
{
"id": "4693559200115625848",
"pilingHeaderId": "5083616810495720619",
"pilingNo": "1141747-001",
"seq": 1,
"productNo": "1141747",
"prodType": "K01",
"style": "FLZZZ1556",
"label": null,
"color": "NV715",
"colorName": "D72传奇蓝",
"layerQty": 0.000000,
"dyeLotCode": "1111",
"sheetQtyPer": 4.0,
"sheetQtySum": 156.0,
"layers": 39,
"lastQty": 4792,
"overCC": 0,
"isAuto": 1,
"sumMarketQty": 156,
"sizeList": [
{
"size": "S",
"count": 39.000000,
"sizeSeq": 0,
"id": null,
"isEdit": 0
},
{
"size": "M",
"count": 78.000000,
"sizeSeq": 0,
"id": null,
"isEdit": 0
},
{
"size": "L",
"count": 39.000000,
"sizeSeq": 0,
"id": null,
"isEdit": 0
}
]
}
],
"bundleDetailList": [
{
"color": "NV715",
"size": "S",
"sizeNo": 1,
"sizeShow": "S-1",
"bundleSeq": 1,
"label": "CN4",
"bundleQty": 39.000000,
"seqStart": 1,
"seqEnd": 39,
"id": "4853171795944786722",
"version": "16212186236960753",
"oldVersion": null,
"timeCreated": "2021-05-17 10:30:23",
"userIdCreated": "admin",
"timeLastMod": "2021-05-17 10:30:23",
"userIdLastMod": "admin",
"clientId": "1"
},
{
"color": "NV715",
"size": "M",
"sizeNo": 1,
"sizeShow": "M-1",
"bundleSeq": 2,
"label": "CN4",
"bundleQty": 39.000000,
"seqStart": 40,
"seqEnd": 78,
"id": "5481080218778072707",
"version": "16212186236973707",
"oldVersion": null,
"timeCreated": "2021-05-17 10:30:23",
"userIdCreated": "admin",
"timeLastMod": "2021-05-17 10:30:23",
"userIdLastMod": "admin",
"clientId": "1"
},
{
"color": "NV715",
"size": "M",
"sizeNo": 2,
"sizeShow": "M-2",
"bundleSeq": 3,
"label": "CN4",
"bundleQty": 39.000000,
"seqStart": 79,
"seqEnd": 117,
"id": "5470236970542223515",
"version": "16212186236980768",
"oldVersion": null,
"timeCreated": "2021-05-17 10:30:23",
"userIdCreated": "admin",
"timeLastMod": "2021-05-17 10:30:23",
"userIdLastMod": "admin",
"clientId": "1"
},
{
"color": "NV715",
"size": "L",
"sizeNo": 1,
"sizeShow": "L-1",
"bundleSeq": 4,
"label": "CN4",
"bundleQty": 39.000000,
"seqStart": 118,
"seqEnd": 156,
"id": "5080753870002824902",
"version": "16212186236987226",
"oldVersion": null,
"timeCreated": "2021-05-17 10:30:23",
"userIdCreated": "admin",
"timeLastMod": "2021-05-17 10:30:23",
"userIdLastMod": "admin",
"clientId": "1"
}
],
"id": "5083616810495720619",
"version": "16212185987678723",
"oldVersion": null,
"timeCreated": "2021-05-17 10:29:58",
"userIdCreated": "admin",
"timeLastMod": "2021-05-17 10:30:23",
"userIdLastMod": "admin",
"clientId": "1"
},
"queryCount": 0
}
效果参考图(见附件):
注:尺码数量明细那里不需要像下面图片那样用圆圈处理,用表格展示亦可
|