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
| DECLARE
| clobValue JIMU_REPORT.JSON_STR%TYPE;
|
| BEGIN
| clobValue
| :=
| '{"loopBlockList":[],"area":{"sri":1,"sci":4,"eri":1,"eci":4,"width":160,"height":40},"excel_config_id":"707023101616324608","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","style":22,"rendered":"","config":""},"2":{"text":"工位名称","style":22,"rendered":"","config":""},"3":{"text":"工位组","style":22,"rendered":"","config":""},"4":{"direction":"right","text":"#{output.groupRight(dateCycle)}","style":22,"aggregate":"group","rendered":"","config":"","display":"normal"}},"height":40},"2":{"cells":{"1":{"text":"#{output.group(workstationCode)}","style":27,"aggregate":"group","sort":"desc","completeBlankStatus":false},"2":{"text":"#{output.group(workstationName)}","style":27,"aggregate":"group","sort":"desc","rendered":"","config":""},"3":{"text":"#{output.group(workstationGroup)}","style":27,"aggregate":"group","rendered":"","config":"","sort":"desc"},"4":{"text":"#{output.dynamic(outputCount)}","style":25,"aggregate":"dynamic","rendered":"","config":""}},"height":38},"len":3},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"output.workstationCode","freeze":"A1","dataRectWidth":1334,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"format":"number"},{"format":"number"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#c5e0b3"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#538136"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#71ae47"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#93d051"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#00b04e"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#ffffff"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#a7d08c"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#e3efd9"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":""},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 62%"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 62"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF 6"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF "},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"left","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"right","font":{"size":9,"bold":true}}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":386},"2":{"width":386},"3":{"width":386},"4":{"width":160},"6":{"width":100},"len":50},"merges":[]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707023101616324608;
| clobValue
| :=
| '{"loopBlockList":[],"area":false,"excel_config_id":"707081699497730048","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","merge":[1,0],"height":50,"style":28},"2":{"text":"工位名称","merge":[1,0],"height":50,"style":28},"3":{"merge":[1,0],"height":50,"text":"工位组","style":28},"4":{"merge":[1,0],"height":50,"style":29,"text":"报警次数"},"5":{"text":"#{alarmTime.groupRight(showDate)}","aggregate":"group","direction":"right","style":28,"subtotal":"-1","funcname":"-1"}},"height":40},"2":{"cells":{"5":{"text":"次数合计","style":28}},"height":40},"3":{"cells":{"1":{"text":"#{alarmTime.group(workstationCode)}","style":34,"aggregate":"group","sort":"desc"},"2":{"text":"#{alarmTime.group(workstationName)}","style":34,"aggregate":"group","sort":"desc"},"3":{"text":"#{alarmTime.group(workstationGroup)}","aggregate":"group","style":34,"sort":"desc"},"4":{"style":35,"text":"#{alarmTime.group(alarmCountSum)}","aggregate":"group","sort":"desc"},"5":{"text":"#{alarmTime.dynamic(alarmCount)}","aggregate":"dynamic","style":36,"funcname":"-1","subtotal":"-1","linkIds":"707399928057290752,707399928057290752","rendered":"","config":"","display":"link"}},"height":38},"4":{"cells":{"1":{"merge":[0,2],"height":25,"text":"总计","style":31},"4":{"style":32,"text":"=SUM(E3)"},"5":{"style":32,"text":"=SUM(F3)"}},"height":38},"len":77},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"10","btnList":[1,2,3,4,5,6,8]},"groupField":"alarmTime.workstationCode","freeze":"A1","dataRectWidth":1334,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"align":"center"},{"align":"center","border":{"bottom":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":false},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":14}},{"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":14,"bold":true}},{"font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","textwrap":true,"valign":"middle","font":{"size":9,"bold":true}},{"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","textwrap":true,"valign":"middle","font":{"size":9,"bold":true}},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB","textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":333},"2":{"width":333},"3":{"width":332},"4":{"width":160},"5":{"width":160},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3","B5:D5"]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707081699497730048;
| clobValue
| :=
| '{"loopBlockList":[],"area":{"sri":2,"sci":1,"eri":2,"eci":1,"width":289,"height":38},"excel_config_id":"707168303790407680","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"工位编号","style":12},"2":{"text":"工位名称","style":12},"3":{"text":"工位组","style":12},"4":{"text":"班次名称","style":12},"5":{"aggregate":"group","direction":"right","text":"#{output.groupRight(dateCycle)}","style":12}},"height":40},"2":{"cells":{"1":{"text":"#{output.group(workstationCode)}","aggregate":"group","style":16,"sort":"desc"},"2":{"text":"#{output.group(workstationName)}","aggregate":"group","style":16,"sort":"desc"},"3":{"text":"#{output.group(workstationGroup)}","aggregate":"group","style":16,"sort":"desc"},"4":{"aggregate":"group","text":"#{output.group(shiftName)}","style":16,"sort":"default"},"5":{"aggregate":"dynamic","style":15,"text":"#{output.dynamic(outputCount)}","sort":"asc"}},"height":38},"13":{"cells":{}},"14":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"output.workstationCode","freeze":"A1","dataRectWidth":1332,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#e3efd9"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":""},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 62%"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 62"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF 6"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF "},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":289},"2":{"width":289},"3":{"width":289},"4":{"width":289},"5":{"width":160},"6":{"width":100},"len":50},"merges":[]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707168303790407680;
| clobValue
| :=
| '{"loopBlockList":[],"area":false,"excel_config_id":"707378988669853696","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"报警日期","style":7},"2":{"text":"报警时间","style":7},"3":{"text":"报警代码","style":7},"4":{"text":"报警信息","style":7}},"height":40},"2":{"cells":{"1":{"text":"#{drillAlarmTime.group(showDate)}","aggregate":"group","style":8},"2":{"text":"#{drillAlarmTime.ts}","style":8},"3":{"text":"#{drillAlarmTime.alarmCode}","style":8},"4":{"text":"#{drillAlarmTime.alarmMsg}","style":8}},"height":38},"3":{"cells":{}},"4":{"cells":{}},"9":{"cells":{},"height":25},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"drillAlarmTime.showDate","freeze":"A1","dataRectWidth":1041,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":200},"2":{"width":200},"3":{"width":200},"4":{"width":425},"len":50},"merges":[]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707378988669853696;
| clobValue
| :=
| '{"loopBlockList":[],"area":{"sri":1,"sci":1,"eri":2,"eci":1,"width":300,"height":80},"excel_config_id":"707452299503865856","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{"0":{"style":21,"text":" "},"1":{"style":21,"text":" "},"2":{"style":21,"text":" "},"3":{"style":21,"text":" "}},"height":18},"1":{"cells":{"0":{"style":21,"text":" "},"1":{"merge":[1,0],"height":50,"text":"工位编码","style":18},"2":{"merge":[1,0],"height":50,"text":"工位名称","style":18},"3":{"merge":[1,0],"height":50,"text":"工位组","style":18},"4":{"text":"#{efficiency.groupRight(time)}","aggregate":"group","direction":"right","style":18}},"height":40},"2":{"cells":{"0":{"style":21,"text":" "},"4":{"text":"#{efficiency.groupRight(type)}","aggregate":"group","direction":"right","style":18}},"height":40},"3":{"cells":{"0":{"style":21,"text":" "},"1":{"text":"#{efficiency.group(workstationCode)}","aggregate":"group","style":41,"sort":"desc"},"2":{"text":"#{efficiency.group(workstationName)}","aggregate":"group","style":41,"sort":"desc"},"3":{"text":"#{efficiency.group(workstationNameGroupName)}","aggregate":"group","style":41,"sort":"desc"},"4":{"text":"#{efficiency.dynamic(value)}","aggregate":"dynamic","style":43}},"height":38},"len":4},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"efficiency.workstationCode","freeze":"A1","dataRectWidth":1000,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#E"},{"bgcolor":"#E"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EF"},{"bgcolor":"#EF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFE"},{"bgcolor":"#EFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEF"},{"bgcolor":"#EFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFE"},{"bgcolor":"#EFEFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true}},{"font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":9}},{"font":{"bold":true,"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":12}},{"font":{"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":12}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10}},{"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":true,"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":14}},{"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"bold":false,"size":9}},{"font":{"bold":false}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true,"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"textwrap":true,"align":"right","font":{"size":9}}],"validations":[],"isGroup":true,"cols":{"0":{"width":18},"1":{"width":300},"2":{"width":300},"3":{"width":300},"4":{"width":82},"5":{"width":100},"6":{"width":141},"len":50},"merges":["B2:B3","C2:C3","D2:D3"]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707452299503865856;
| clobValue
| :=
| '{"loopBlockList":[],"area":false,"excel_config_id":"707479561238863872","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"landscape"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"text":"班次","style":7},"2":{"text":"班次名称","style":7},"3":{"text":"报警时间","style":7},"4":{"text":"报警代码","style":7},"5":{"text":"报警信息","style":7}},"height":40},"2":{"cells":{"1":{"text":"#{drillAlarmShift.group(shiftIndexName)}","aggregate":"group","style":8},"2":{"text":"#{drillAlarmShift.group(shiftName)}","aggregate":"group","style":8},"3":{"text":"#{drillAlarmShift.ts}","style":8},"4":{"text":"#{drillAlarmShift.alarmCode}","style":8},"5":{"text":"#{drillAlarmShift.alarmMsg}","style":8}},"height":38},"5":{"cells":{}},"6":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"drillAlarmShift.shiftIndexName","freeze":"A1","dataRectWidth":1041,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":120},"2":{"width":140},"3":{"width":160},"4":{"width":180},"5":{"width":425},"8":{"width":100},"9":{"width":100},"len":50},"merges":[]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707479561238863872;
| clobValue
| :=
| '{"loopBlockList":[],"area":false,"excel_config_id":"707504177185415168","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":12},"1":{"cells":{"1":{"merge":[1,0],"height":50,"text":"工位编号","style":13},"2":{"merge":[1,0],"height":50,"text":"工位名称","style":13},"3":{"merge":[1,0],"height":50,"text":"工位组","style":13},"4":{"merge":[1,0],"height":50,"text":"班次","style":13},"5":{"merge":[1,0],"height":50,"text":"报警次数（合计）","style":13},"6":{"text":"#{alarmShift.groupRight(showDate)}","style":13,"aggregate":"group","direction":"right"}},"height":40},"2":{"cells":{"6":{"text":"当天合计","style":13}},"height":40},"3":{"cells":{"1":{"text":"#{alarmShift.group(workstationCode)}","style":18,"aggregate":"group","sort":"desc"},"2":{"text":"#{alarmShift.group(workstationName)}","style":18,"aggregate":"group","sort":"desc"},"3":{"text":"#{alarmShift.group(workstationGroup)}","style":21,"aggregate":"group","sort":"desc"},"4":{"text":"#{alarmShift.group(shiftName)}","style":18,"aggregate":"group","sort":"default"},"5":{"text":"#{alarmShift.group(alarmCountSum)}","style":19,"aggregate":"group","sort":"default"},"6":{"text":"#{alarmShift.dynamic(alarmCount)}","style":20,"aggregate":"dynamic","linkIds":"707513662478082048","rendered":"","config":"","display":"link","sort":"default"}},"height":38},"4":{"cells":{"1":{"merge":[0,3],"height":25,"text":"总计（次）","style":15},"5":{"text":"=SUM(F3)","style":16},"6":{"text":"=SUM(G3)","style":16}},"height":38},"5":{"cells":{}},"6":{"cells":{}},"7":{"cells":{}},"8":{"cells":{}},"len":100},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"10","btnList":[1,2,3,4,5,6,8]},"groupField":"alarmShift.workstationCode","freeze":"A1","dataRectWidth":1335,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4"},{"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#cce4e4"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9}},{"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#cce4e4","font":{"size":9,"bold":true}},{"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#cce4e4","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9,"bold":true}},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","bgcolor":"#EFEFEF","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9},"color":"#089BAB","textwrap":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","font":{"size":9},"textwrap":true,"valign":"middle"}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":250},"2":{"width":250},"3":{"width":249},"4":{"width":250},"5":{"width":160},"6":{"width":160},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3","F2:F3","B5:E5"]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707504177185415168;
| clobValue
| :=
| '{"loopBlockList":[],"area":{"sri":1,"sci":1,"eri":3,"eci":5,"width":982,"height":118},"excel_config_id":"707520139154034688","printConfig":{"paper":"A4","width":210,"height":297,"definition":1,"isBackend":false,"marginX":10,"marginY":10,"layout":"portrait"},"zonedEditionList":[],"rows":{"0":{"cells":{},"height":16},"1":{"cells":{"0":{"text":""},"1":{"text":"工位编码","style":28,"merge":[1,0]},"2":{"text":"工位名称","style":28,"merge":[1,0]},"3":{"text":"工位组","style":28,"merge":[1,0]},"4":{"text":"班次","style":28,"merge":[1,0]},"5":{"text":"#{efficiency.groupRight(time)}","direction":"right","aggregate":"group","style":28}},"height":40},"2":{"cells":{"1":{"style":25,"text":" "},"2":{"style":25,"text":" "},"3":{"style":25,"text":" "},"4":{"style":25,"text":" "},"5":{"text":"#{efficiency.groupRight(type)}","direction":"right","aggregate":"group","style":28}},"height":40},"3":{"cells":{"1":{"text":"#{efficiency.group(workstationCode)}","style":49,"aggregate":"group","sort":"desc"},"2":{"text":"#{efficiency.group(workstationName)}","style":49,"aggregate":"group","sort":"desc"},"3":{"text":"#{efficiency.group(workstationNameGroupName)}","style":49,"aggregate":"group","sort":"desc"},"4":{"text":"#{efficiency.group(shiftName)}","style":49,"aggregate":"group","sort":"default"},"5":{"text":"#{efficiency.dynamic(value}","aggregate":"select","style":52}},"height":38},"len":4},"dbexps":[],"dicts":[],"rpbar":{"show":true,"pageSize":"","btnList":[1,2,3,4,5,6,8]},"groupField":"efficiency.workstationCode","freeze":"A1","dataRectWidth":998,"displayConfig":{},"background":false,"name":"sheet1","autofilter":{},"styles":[{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#E"},{"bgcolor":"#E"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EF"},{"bgcolor":"#EF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFE"},{"bgcolor":"#EFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEF"},{"bgcolor":"#EFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFE"},{"bgcolor":"#EFEFE"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF"},{"bgcolor":"#EFEFEF"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true},{"align":"center"},{"align":"center","color":"#0a0a0a"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":true},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF"},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":false},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":9}},{"font":{"size":9}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":9,"bold":true}},{"font":{"bold":true}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":9,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10.5,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":10.5}},{"font":{"size":10.5}},{"font":{"bold":true,"size":10.5}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":10.5,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":10,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":10}},{"font":{"size":10}},{"font":{"bold":true,"size":10}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":10,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":10}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","strike":false,"font":{"size":14}},{"font":{"size":14}},{"align":"center","color":"#0a0a0a","bgcolor":"#EFEFEF","border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"font":{"size":14,"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"center","textwrap":true,"font":{"size":14}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","font":{"bold":true},"align":"center"},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":9}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"left","textwrap":true,"font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"align":"right","font":{"size":10.5}},{"border":{"bottom":["thin","#000"],"top":["thin","#000"],"left":["thin","#000"],"right":["thin","#000"]},"bgcolor":"#EFEFEF","align":"center","font":{"size":12,"bold":true}},{"font":{"size":12}}],"validations":[],"isGroup":true,"cols":{"0":{"width":16},"1":{"width":225},"2":{"width":225},"3":{"width":225},"4":{"width":225},"5":{"width":82},"6":{"width":70.8},"7":{"width":70.8},"8":{"width":100},"9":{"width":100},"10":{"width":100},"len":50},"merges":["B2:B3","C2:C3","D2:D3","E2:E3"]}';
| UPDATE JIMU_REPORT T
| SET T.JSON_STR = clobValue
| WHERE ID = 707520139154034688;
| COMMIT;
| END;
|
|
