-
Notifications
You must be signed in to change notification settings - Fork 7
/
RowGrouping.bbj
99 lines (80 loc) · 3.18 KB
/
RowGrouping.bbj
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
rem /**
rem * This file is part of the BBjGridExWidget plugin.
rem * (c) Basis Europe <eu@basis.com>
rem *
rem * For the full copyright and license information, please view the LICENSE
rem * file that was distributed with this source code.
rem */
use ::BBjGridExWidget/BBjGridExWidget.bbj::BBjGridExWidget
use ::BBjGridExWidget/GxColumns.bbj::GxColumn
use ::BBjGridExWidget/GxColumnsToolpanel.bbj::GxColumnsToolpanel
use ::BBjGridExWidget/Demo/assets/Utilities.bbj::GxDemoUtilities
use com.basiscomponents.db.ResultSet
use com.basiscomponents.bc.SqlQueryBC
use com.google.gson.JsonObject
use java.sql.Types
? 'HIDE'
GxDemoUtilities.nagAboutLicense()
declare auto BBjTopLevelWindow wnd!
declare BBjGridExWidget grid!
wnd! = BBjAPI().openSysGui("X0").addWindow(10,10,800,600,"Row Grouping Demo")
wnd!.setCallback(BBjAPI.ON_CLOSE,"byebye")
wnd!.setCallback(BBjAPI.ON_RESIZE,"resize")
cb! = wnd!.addCheckBox(203,12,10,200,22,"Enable Read Only Mode")
cb!.setCallback(BBjAPI.ON_CHECK_OFF,"onUseCheckbox")
cb!.setCallback(BBjAPI.ON_CHECK_ON,"onUseCheckbox")
grid! = new BBjGridExWidget(wnd!,100,0,40,800,560)
rem grouping options
rem =======================
grid!.getOptions().setRowGroupPanelShow(grid!.GRID_GROUPPANEL_SHOW_VISIBLE())
grid!.getOptions().setMultipleSelection(1)
grid!.getOptions().setGroupColumnLabel("My Custom Group")
grid!.getOptions().setShowGroupChildCount(1)
grid!.getOptions().setShowGroupSelectionCheckbox(1)
grid!.getOptions().setGroupSelectsChildren(1)
REM grid!.setGroupUseEntireRow(1)
REM grid!.setGroupMultiAutoColumn(1)
REM cast(GxColumnsToolpanel,grid!.getSidebar().getToolpanels().get("columns")).setSuppressValues(0)
gosub setupGrid
process_events
setupGrid:
declare SqlQueryBC sbc!
sbc! = new SqlQueryBC(BBjAPI().getJDBCConnection("CDStore"))
rs! = sbc!.retrieve("SELECT * FROM CDINVENTORY")
filter! = new com.basiscomponents.db.DataRow()
filter!.setFieldValue("RECORDINGTYPE","cond:<DDD&>=AAD")
rs! = rs!.filterBy(filter!)
grid!.setData(rs!, 1 , 1 , "CDNUMBER")
rem First we group by music type
declare GxColumn musicTypeColumn!
musicTypeColumn! = grid!.getColumn("MUSICTYPE")
musicTypeColumn!.setRowGroup(1)
musicTypeColumn!.setEnableRowGroup(1)
musicTypeColumn!.setRowGroupIndex(0)
rem Second we group by artist
rem @see https://www.ag-grid.com/javascript-grid-cell-expressions/
declare GxColumn artistColumn!
artistColumn! = grid!.getColumn("ARTIST")
artistColumn!.setRowGroup(1)
artistColumn!.setEnableRowGroup(1)
artistColumn!.setRowGroupIndex(1)
artistColumn!.setValueGetterExpression("if(data) return 'Artist : ' + data.ARTIST")
rem Finally we aggreagate by playingtime
rem @see https://www.ag-grid.com/javascript-grid-cell-expressions/
declare GxColumn playingTimeColumn!
playingTimeColumn! = grid!.getColumn("PLAYINGTIME")
playingTimeColumn!.setEnableValue(1)
playingTimeColumn!.setAggFunc("sum")
playingTimeColumn!.setAllowedAggFuncs("sum,min,max")
playingTimeColumn!.setValueGetterExpression("Number(data.PLAYINGTIME)")
return
onUseCheckbox:
useCheckbox! = cb!.isSelected()
grid!.setFunctionsReadOnly(useCheckbox!)
return
resize:
ev! = BBjAPI().getLastEvent()
grid!.setSize(ev!.getWidth(),ev!.getHeight())
return
byebye:
bye