Appearance
informat.designer 应用设计相关操作
概述
使用informat.designer对象进行应用设计相关操作
getDefineObject
通过ID查询应用设计模型定义
javascript
informat.designer.getDefineObject(scope, id)1
| 参数 | 类型 | 描述 |
|---|---|---|
| scope | String | 作用域 ,默认作用域是App,其它为scope为模块id |
| id | String | 模型定义ID |
返回值
类型为DefineObject
示例 查询员工数据表模块定义
javascript
informat.designer.getDefineObject('App', 'ho3o7sqabzkc1');1
json
{
"build": 47,
"createTime": "Fri Nov 24 10:23:16 CST 2023",
"disableModuleTitle": false,
"disableModuleVisitHistory": false,
"disableNavBreadcrumb": false,
"draftVersion": 86,
"enableModuleTitleRichtext": false,
"icon": "table",
"id": "ho3o7sqabzkc1",
"isDeleted": false,
"isHiddenMobile": false,
"isHiddenWeb": false,
"key": "staffs",
"name": "员工",
"noteList": [
],
"scope": "App",
"tableSetting": {
"bpmnDeleteRecordWithInstance": false,
"bpmnShowInstance": false,
"createToolBarButtonList": [
],
"dataSourceType": "default",
"enableBpmn": false,
"enableChangeLog": true,
"enableChangeLogOnCreate": false,
"enableComment": true,
"enableDependAccess": false,
"enableDependDelete": false,
"enableDependInsert": false,
"enableDependUpdate": false,
"enableRecycleBin": false,
"fieldGroupList": [
{
"expand": false,
"id": "rqjtx84wlbn4r",
"isDirectory": false,
"key": "rqjtx84wlbn4r",
"name": "获奖情况"
},
{
"expand": false,
"id": "hbi07rszx5bjy",
"isDirectory": false,
"key": "hbi07rszx5bjy",
"name": "请假情况"
},
{
"expand": false,
"id": "l4v7chhzagyj8",
"isDirectory": false,
"key": "l4v7chhzagyj8",
"name": "系统字段"
}
],
"fieldList": [
{
"expand": false,
"icon": "functions",
"id": "i3zmrlz7q633g",
"isDirectory": false,
"key": "recordId",
"name": "ID",
"type": "Formula"
},
{
"expand": false,
"icon": "functions",
"id": "o3wdmzzwy4lbh",
"isDirectory": false,
"key": "seqno",
"name": "seq",
"type": "Formula"
},
{
"expand": false,
"icon": "hashtag",
"id": "r3rjdlv21qddw",
"isDirectory": false,
"key": "staffNo",
"name": "工号",
"type": "ID"
},
{
"expand": false,
"icon": "text",
"id": "kcv33zajbr6qn",
"isDirectory": false,
"key": "name",
"name": "姓名",
"type": "SingleText"
},
{
"expand": false,
"icon": "checkbox-circle",
"id": "pyypptbpcdvop",
"isDirectory": false,
"key": "sex",
"name": "性别",
"type": "ListSelect"
},
{
"expand": false,
"icon": "number-1",
"id": "urx7djdqnp7mf",
"isDirectory": false,
"key": "age",
"name": "年龄",
"type": "Integer"
},
{
"expand": false,
"icon": "star",
"id": "w0xci8e3xl8v9",
"isDirectory": false,
"key": "grade",
"name": "级别",
"type": "Rate"
},
{
"expand": false,
"icon": "checkbox-circle",
"id": "nnw2iiycbpghu",
"isDirectory": false,
"key": "status",
"name": "状态",
"type": "ListSelect"
},
{
"expand": false,
"icon": "attachment",
"id": "qpxzoe9tlo92m",
"isDirectory": false,
"key": "attachment",
"name": "附件",
"type": "Attachment"
},
{
"expand": false,
"icon": "node-tree",
"id": "rebf9ipbjj2jb",
"isDirectory": false,
"key": "area",
"name": "所在地区",
"type": "Cascader"
},
{
"expand": false,
"icon": "pencil",
"id": "bsfu7evwrqi4v",
"isDirectory": false,
"key": "signature",
"name": "手写签名",
"type": "Signature"
},
{
"expand": false,
"icon": "link",
"id": "ff76vrkqz02hc",
"isDirectory": false,
"key": "deptRel",
"name": "所在部门",
"type": "RelationRecord"
},
{
"expand": false,
"icon": "link",
"id": "cce1xkp45cjhb",
"isDirectory": false,
"key": "rewardCount",
"name": "获奖次数",
"type": "RelationRollup"
},
{
"expand": false,
"icon": "link",
"id": "vp1c87b94u4lg",
"isDirectory": false,
"key": "rewardList",
"name": "奖励列表",
"type": "Relation"
},
{
"expand": false,
"icon": "link",
"id": "qrnaq2o3uffbj",
"isDirectory": false,
"key": "leaveLogRel",
"name": "请假列表",
"type": "LookupList"
},
{
"expand": false,
"icon": "link",
"id": "a7nr1z1y871n6",
"isDirectory": false,
"key": "totalLevelDays",
"name": "请假总天数",
"type": "LookupRollup"
},
{
"expand": false,
"icon": "time",
"id": "xspynt2y38x4s",
"isDirectory": false,
"key": "createTime",
"name": "创建时间",
"type": "CreateTime"
},
{
"expand": false,
"icon": "time",
"id": "ychzl2fr9vrta",
"isDirectory": false,
"key": "updateTime",
"name": "最后修改时间",
"type": "LastModifyTime"
},
{
"expand": false,
"icon": "user",
"id": "drjw345d7d6o9",
"isDirectory": false,
"key": "createUser",
"name": "创建人",
"type": "CreateUser"
},
{
"expand": false,
"icon": "user",
"id": "ol07czcyxvzwi",
"isDirectory": false,
"key": "updateUser",
"name": "最后更新人",
"type": "LastModifyUser"
}
],
"fieldStyleList": [
],
"formDisplayWidth": 700,
"formDisplayWidthUnit": "px",
"formFieldStyle": "border",
"formFullSaveAutoClose": false,
"formLabelAlign": "left",
"formLabelWidth": 100,
"formSaveMode": "Field",
"formStyle": "Simple",
"formToolBarButtonList": [
],
"listenerList": [
],
"returnFieldList": [
],
"tableIndexList": [
],
"tableView": {
"bottomToolBarButtonList": [
],
"childrenAsyncLoadAutomaticVarList": [
],
"childrenAsyncLoadEnable": false,
"childrenAutoExpandLevel": 0,
"childrenExpandLevel": 1,
"childrenSelectionStrictly": false,
"childrenShowParent": false,
"childrenShowPathbar": false,
"contextMenuButtonList": [
],
"defaultPageSize": 50,
"disableAutoLoad": false,
"disableFilterCache": false,
"filterConditionList": [
],
"filterList": [
],
"filterPosition": "toolbar",
"filterViewLabelPosition": "top",
"filterViewLabelWidth": 120,
"filterViewType": "none",
"filterViewWidth": 240,
"formCommentVisibleRoleList": [
],
"formDetailVisibleRoleList": [
],
"formFieldConfigList": [
],
"formShowDialogModal": false,
"formShowType": "dialog",
"gridDisplaySetting": {
"autoExpendWhenGroup": true,
"border": "full",
"cellEditMode": "dblclick",
"cellStyleList": [
],
"columnList": [
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "functions",
"id": "i3zmrlz7q633g",
"name": "ID",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "functions",
"id": "o3wdmzzwy4lbh",
"name": "seq",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "hashtag",
"id": "r3rjdlv21qddw",
"name": "工号",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "text",
"id": "kcv33zajbr6qn",
"name": "姓名",
"type": "field",
"width": "200"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "checkbox-circle",
"id": "pyypptbpcdvop",
"name": "性别",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "checkbox-circle",
"id": "nnw2iiycbpghu",
"name": "状态",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "number-1",
"id": "urx7djdqnp7mf",
"name": "年龄",
"type": "field",
"width": "100"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "star",
"id": "w0xci8e3xl8v9",
"name": "级别",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "link",
"id": "ff76vrkqz02hc",
"name": "所在部门",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "attachment",
"id": "qpxzoe9tlo92m",
"name": "附件",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "node-tree",
"id": "rebf9ipbjj2jb",
"name": "所在地区",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "link",
"id": "cce1xkp45cjhb",
"name": "获奖次数",
"type": "field",
"width": "150"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "user",
"id": "drjw345d7d6o9",
"name": "创建人",
"type": "field",
"width": "100"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "time",
"id": "xspynt2y38x4s",
"name": "创建时间",
"type": "field",
"width": "130"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "user",
"id": "ol07czcyxvzwi",
"name": "最后更新人",
"type": "field",
"width": "100"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "time",
"id": "ychzl2fr9vrta",
"name": "最后修改时间",
"type": "field",
"width": "130"
}
],
"customLineHeight": 32,
"defaultShowDetailOpt": false,
"enableHighlightCurrent": false,
"footerAggregateType": "currentPage",
"hideFieldIcon": false,
"hideFooter": false,
"hideHeader": false,
"lineHeight": "min",
"scrollBarPosition": "keep",
"selectionMode": "checkbox",
"stripe": true,
"tableButtonList": [
],
"tableDragSort": false,
"tableIndex": false,
"tableStripe": true
},
"hideToolbar": false,
"listenerList": [
],
"orderByFieldList": [
],
"orderByList": [
],
"paginationPosition": "top",
"paginationStyle": "simple",
"pathFilterList": [
],
"returnFieldList": [
],
"searchChildrenExpandLevel": 0,
"showBottomToolbar": false,
"toolBarButtonList": [
{
"action": "RecordCreate",
"actionSetting": {
"readonlyFieldList": [
],
"valueList": [
],
"hideFieldList": [
],
"hideContinueCreate": false,
"tableId": "ho3o7sqabzkc1",
"defaultContinueCreate": false,
"keepFieldList": [
],
"dialogModal": false
},
"buttonSetting": {
"badgeType": "danger",
"enableConfirm": false,
"hideName": false,
"plain": false,
"round": false,
"type": "default"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"id": "swj3tg8iesu6",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "创建",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
},
{
"action": "RecordDelete",
"actionSetting": {
"recordIdExpression": "${tableSelectedIdList}",
"tableId": "ho3o7sqabzkc1"
},
"buttonSetting": {
"badgeType": "danger",
"confirmMessageExpression": "确定要彻底删除选中的记录吗？",
"enableConfirm": true,
"hideName": false,
"icon": "delete-bin-6",
"plain": false,
"round": false,
"type": "danger"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"disableExpression": "${Array.isEmpty(tableSelectedIdList)}",
"id": "me81s2ptrb30",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "删除记录",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
}
]
}
},
"type": "Table",
"updateTime": "Fri Feb 28 16:29:55 CST 2025",
"updateUser": "zhangsan",
"viewSplitSetting": {
"splitPosition": "right",
"splitSize": 300,
"splitSizeUnit": "px",
"websiteComponentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"websiteType": "website"
}
}1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
getDefineObjectByKey
通过标识符查询应用设计模型定义
javascript
informat.designer.getDefineObjectByKey(scope, key)1
| 参数 | 类型 | 描述 |
|---|---|---|
| scope | String | 作用域,默认作用域是App,其它为scope为模块id |
| key | String | 模型标识符 |
返回值
类型为DefineObject
示例 查询员工数据表模块定义
javascript
informat.designer.getDefineObject('App', 'staff');1
json
与上面接口一样1
getDefineObjectList
查询应用设计模型定义列表
javascript
informat.designer.getDefineObjectList(query)1
类型定义如下
| 参数 | 类型 | 描述 |
|---|---|---|
| ApiDefine | String | API定义 |
| ApplicationOptionDefine | String | 应用选项值定义 |
| ApplicationDefine | String | 应用定义 |
| AutomaticDefine | String | 自动化定义 |
| BpmnProcessDefine | String | 工作流流程定义 |
| DashboardCardDefine | String | 仪表盘卡片定义 |
| DataSourceDefine | String | 数据源定义 |
| FormDesignerDefine | String | 表单设计器定义 |
| I18nDefine | String | 国际化翻译定义 |
| ModuleDefine | String | 应用模块定义 |
| PageDesignerDefine | String | 打印模块定义 |
| RoleDefine | String | 应用角色定义 |
| ScheduleDefine | String | 定时任务定义 |
| ScriptDefine | String | 脚本定义 |
| SurveyItemDefine | String | 问卷调查定义 |
| TableFieldDefine | String | 数据表字段定义 |
| TableFieldGroupDefine | String | 数据表字段分组定义 |
| TableIndexDefine | String | 数据表索引定义 |
| VersionDefine | String | 应用版本说明定义 |
| WebsiteResourceDefine | String | 网站静态资源定义 |
| 参数 | 类型 | 描述 |
|---|---|---|
| query | DefineObjectQuery | 查询对象 |
返回值
类型为Array<DefineObject>
示例 查询应用下所有模块列表
javascript
informat.designer.getDefineObjectList({
type:'ModuleDefine',
pageSize:10000
});1
2
3
4
2
3
4
json
[
{
"build": 60,
"createTime": "Fri Nov 24 12:11:04 CST 2023",
"createUser": "李四",
"disableModuleTitle": false,
"disableModuleVisitHistory": false,
"disableNavBreadcrumb": false,
"draftVersion": 143,
"enableModuleTitleRichtext": false,
"floatButtonList": [
{
"action": "OpenSplitDrawer",
"actionSetting": {
"splitSize": "1000px",
"dialogCloseOnClickModal": false,
"splitWithHeader": false,
"splitDirection": "right",
"splitModal": true,
"splitShowClose": true,
"splitType": "External",
"dialogHideClose": false,
"dialogModal": false,
"websiteType": "website",
"splitCloseOnPressEscape": true,
"dialogCloseOnPressEscape": false,
"showType": "drawer",
"externalUrlVar": "/designer/${app.id}/module/${module.type.toLowerCase()}/${module.id}/Field?nonav=true",
"splitWrapperClosable": true
},
"buttonSetting": {
"badgeType": "danger",
"enableConfirm": false,
"hideName": false,
"icon": "question",
"plain": false,
"round": true,
"type": "danger"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"id": "nszejc2sxhid",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "查看配置项",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
},
{
"action": "OpenSplitDrawer",
"actionSetting": {
"splitSize": "1000px",
"dialogCloseOnClickModal": false,
"splitWithHeader": false,
"splitDirection": "right",
"splitModal": true,
"splitShowClose": true,
"splitType": "External",
"dialogHideClose": false,
"dialogModal": false,
"websiteType": "website",
"splitCloseOnPressEscape": true,
"dialogCloseOnPressEscape": false,
"showType": "drawer",
"externalUrlVar": "/doc/guide/table/relation.html",
"splitWrapperClosable": true
},
"buttonSetting": {
"badgeType": "danger",
"enableConfirm": false,
"hideName": false,
"icon": "question",
"plain": false,
"round": true,
"type": "danger"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"id": "k6k7mlqq57l5",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "查看文档",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
}
],
"icon": "node-tree",
"id": "qgzs6s9pk3i50",
"isDeleted": false,
"isHiddenMobile": false,
"isHiddenWeb": false,
"key": "dataModelOneToManyMain",
"name": "关联列表-主表",
"noteList": [
],
"readme": "### 模块介绍： 一对多关系指一个模型的一条数据和另一个模型的多条数据存在关系，在织信平台中可以通过**关联列表**和**查找列表**两个类型的字段来构建一对多关系。一对多关系最终将会以列表的形式在表单中进行展示。 **关联列表的特性：** 关联列表类型的字段可直接构建数据间的一对多关系，其在数据库中会使用邻接表单独存储，在自动化和脚本中查询记录信息不会返回`关联列表` 的值，需要单独调用自动化步骤或者脚本函数查询。 **查找列表的特性：** 查找列表其实就是将另一个模块的数据以列表的形式展示在当前表单中，需要通过查找列表实现一对多关系的建立需要构建一个数据表作为子表。一般我们都会在子表中使用关联记录关联主表，然后在主表中使用查找列表实现一对多关系的构建。 **关联列表汇总：** 关联列表-子表分组中的`数量`字段是通过关联列表汇总类型字段实现的，此字段可对指定关联列表类型的字段进行汇总计算，支持数量、求和、平均值、最大值、最小值、平均值五种汇总函数。 **查找汇总：** 查找列表-子表汇总分组中的`数量`、`求和`、`数量-条件`字段是通过查找列表汇总类型字段实现的，此字段可对指定数据表中关联到本表的关联记录字段进行查询并汇总计算，支持数量、求和、平均值、最大值、最小值、平均值五种汇总函数。`数量`是对子表中数据的数据进行数量计算；`求和`是对子表中的`数值`进行求和计算；`数量-条件`是对子表中类型为类型1和类型2的数据进行数量计算。 ### 参考文档： 关联列表帮助文档：[关联列表](https://next.informat.cn/doc/guide/table/relation.html) 查找列表帮助文档：[查找列表](https://next.informat.cn/doc/guide/table/lookup-list.html)",
"remark": "该模块展示【关联列表】字段的多种使用样例。可点击工具栏中的<创建记录>按钮进行体验。",
"scope": "App",
"tableSetting": {
"bpmnDeleteRecordWithInstance": false,
"bpmnShowInstance": false,
"createToolBarButtonList": [
],
"dataSourceType": "default",
"enableBpmn": false,
"enableChangeLog": false,
"enableChangeLogOnCreate": false,
"enableComment": false,
"enableDependAccess": false,
"enableDependDelete": false,
"enableDependInsert": false,
"enableDependUpdate": false,
"enableRecycleBin": false,
"fieldGroupList": [
{
"expand": false,
"id": "xy484h1bq4ja4",
"isDirectory": false,
"key": "xy484h1bq4ja4",
"name": "创建完子表的操作"
}
],
"fieldList": [
{
"expand": false,
"icon": "link",
"id": "u038ld3bhymoh",
"isDirectory": false,
"key": "relationListCreate",
"name": "关联列表",
"remark": "<div>新增子表行数据，并提交后设置数值字段的值为100</div>",
"type": "Relation"
},
{
"expand": false,
"icon": "text",
"id": "pd44z71kxht2z",
"isDirectory": false,
"key": "pd44z71kxht2z",
"name": "名称",
"type": "SingleText"
}
],
"fieldStyleList": [
],
"formDisplayWidth": 700,
"formDisplayWidthUnit": "px",
"formFieldStyle": "border",
"formFullSaveAutoClose": false,
"formLabelAlign": "left",
"formLabelWidth": 100,
"formSaveMode": "Field",
"formStyle": "Simple",
"formToolBarButtonList": [
],
"listenerList": [
{
"automaticList": [
"wb2y0zcpea02n"
],
"automaticVarList": [
{
"value": "${formRecord.id}"
}
],
"eventList": [
"form.field.list.loaded",
"form.field.list.reloaded"
],
"id": "mnva0qlta4u8",
"isEnable": true,
"name": "表单子表数据加载完成后调用",
"tableFieldSetting": {
"tableFieldList": [
]
}
}
],
"returnFieldList": [
],
"tableIndexList": [
],
"tableView": {
"bottomToolBarButtonList": [
],
"childrenAsyncLoadAutomaticVarList": [
],
"childrenAsyncLoadEnable": false,
"childrenAutoExpandLevel": 0,
"childrenExpandLevel": 1,
"childrenSelectionStrictly": false,
"childrenShowParent": false,
"childrenShowPathbar": false,
"contextMenuButtonList": [
],
"defaultPageSize": 50,
"disableAutoLoad": false,
"disableFilterCache": false,
"filterConditionList": [
],
"filterList": [
],
"filterPosition": "toolbar",
"filterViewLabelPosition": "top",
"filterViewLabelWidth": 120,
"filterViewType": "none",
"filterViewWidth": 240,
"formCommentVisibleRoleList": [
],
"formDetailVisibleRoleList": [
],
"formFieldConfigList": [
],
"formShowDialogModal": false,
"formShowType": "dialog",
"gridDisplaySetting": {
"autoExpendWhenGroup": true,
"border": "full",
"cellEditMode": "dblclick",
"cellStyleList": [
],
"columnList": [
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "text",
"id": "pd44z71kxht2z",
"name": "名称",
"type": "field",
"width": "200"
},
{
"buttonList": [
],
"children": [
],
"edit": false,
"icon": "link",
"id": "u038ld3bhymoh",
"name": "关联列表",
"type": "field",
"width": "150"
}
],
"customLineHeight": 32,
"defaultShowDetailOpt": false,
"enableHighlightCurrent": false,
"footerAggregateType": "currentPage",
"hideFieldIcon": false,
"hideFooter": false,
"hideHeader": false,
"lineHeight": "min",
"scrollBarPosition": "keep",
"selectionMode": "checkbox",
"stripe": true,
"tableButtonList": [
],
"tableDragSort": false,
"tableIndex": false,
"tableStripe": true
},
"hideToolbar": false,
"listenerList": [
],
"orderByFieldList": [
],
"orderByList": [
],
"paginationPosition": "top",
"paginationStyle": "simple",
"pathFilterList": [
],
"returnFieldList": [
],
"searchChildrenExpandLevel": 0,
"showBottomToolbar": false,
"toolBarButtonList": [
{
"action": "RecordCreate",
"actionSetting": {
"readonlyFieldList": [
],
"valueList": [
],
"hideFieldList": [
],
"hideContinueCreate": false,
"tableId": "qgzs6s9pk3i50",
"defaultContinueCreate": false,
"keepFieldList": [
],
"dialogModal": false
},
"buttonSetting": {
"badgeType": "danger",
"enableConfirm": false,
"hideName": false,
"icon": "menu-add",
"plain": false,
"round": false,
"type": "primary"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"id": "huldgy7bm7ff",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "创建记录",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
},
{
"action": "RecordDelete",
"actionSetting": {
"recordIdExpression": "${tableSelectedIdList}",
"tableId": "qgzs6s9pk3i50"
},
"buttonSetting": {
"badgeType": "danger",
"confirmMessageExpression": "确定要彻底删除选中的记录吗？",
"enableConfirm": true,
"hideName": false,
"icon": "delete-bin-6",
"plain": false,
"round": false,
"type": "danger"
},
"cardSetting": {
"alignItems": "flex-start",
"flexDirection": "row",
"justifyContent": "flex-start"
},
"children": [
],
"componentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"controlType": "button",
"disableExpression": "${Array.isEmpty(tableSelectedIdList)}",
"id": "ypozortrus0y",
"inputSetting": {
"width": 200
},
"isDirectory": false,
"labelSetting": {
"bold": false,
"fontSize": 13
},
"name": "删除记录",
"richtextSetting": {
},
"selectSetting": {
"multiple": false,
"optionList": [
],
"width": 200
},
"switchSetting": {
"type": "primary"
},
"visibleRoleList": [
]
}
]
}
},
"type": "Table",
"updateTime": "Mon Apr 07 15:17:03 CST 2025",
"updateUser": "李四",
"viewSplitSetting": {
"splitPosition": "right",
"splitSize": 300,
"splitSizeUnit": "px",
"websiteComponentSetting": {
"disableShadowDom": false,
"eventHandlerList": [
],
"props": [
]
},
"websiteType": "website"
}
}
]1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537