Ola
Seemingly I'm getting closer to my app goal for my next project, so here is something for the community again. A grid and there some very few things I like about it too. This is a wrap for this project here.
Quick Reference
ShowCase: Header Filters (onchange / onkeypress events)
Full Table
This is what you get:
1. Sortable columns
2. Table title
3. Table headers themeable with css
3. DropDown
4. Checkbox
5. Pager (limits, number of pages etc)
6. Many interesting events and methods..
It's also possible to set the custom view designer properties when using the designer.
Ok, let me help you to succeed. Let's look at the definition of the component. This is based on gijgo again.
UOENowGridTable
Seemingly I'm getting closer to my app goal for my next project, so here is something for the community again. A grid and there some very few things I like about it too. This is a wrap for this project here.
Quick Reference
- Font Awesome fonts applicable
- Hiding the Pager
- Updating the grid via a timer
- Inline editing using built in CRUD buttons
- Column events e.g. click, mouseenter etc
- Adding own icons and events
- Using MaterialDesign / FontAwesome with Bootstrap
- Grouping data by a particular column value
- Column editors (textbox, combo, checkbox)
- Selection Methods (single / multiple row selections)
- Designer Properties
- Adding Columns to the grid
- Adding Data to grid
- Nested grids
- Connected grids
ShowCase: Header Filters (onchange / onkeypress events)
Full Table
This is what you get:
1. Sortable columns
2. Table title
3. Table headers themeable with css
3. DropDown
4. Checkbox
5. Pager (limits, number of pages etc)
6. Many interesting events and methods..
It's also possible to set the custom view designer properties when using the designer.
Ok, let me help you to succeed. Let's look at the definition of the component. This is based on gijgo again.
UOENowGridTable
- Cancel (pk As String)
cancel operation for primary key - SetDataSource (rows As List) As UOENowGridTable
set data source - GetRecordFromEvent (e As BANanoEvent) As Map
get record from event - SetColumnGroupBy (colField As String) As UOENowGridTable
set columns to group by - SetColumnEditors (colField As List) As UOENowGridTable
set columns editors - SetColumnModeReadOnly (colField As List) As UOENowGridTable
set columns editor mode to readonly - SetColumnModeEditOnly (colField As List) As UOENowGridTable
set columns editor mode to editor only - SetColumnDataSource (colField As String, colDataSource As Object, colValueField As String, colEditField As String) As UOENowGridTable
set columns data source for dropdown - GetByPos (rowPos As Int) As Map
get data for primary key - GetRowsVisible() As List
get all visible rows data - GetRows() As List
get all rows data - GetById (id As String) As Map
get data by id - SearchFor (searchValues As Map)
search the grid, use a map that has the field names and values to search for - Reload
reload, if autoload is false - Clear
clear the data - HideColumn (colName As List)
hide columns via code - ShowColumn (colField As List)
show columns via code - RemoveRow (pk As String)
remove a row by id - CountVisible As Int
count visible records - CountAll As Int
count all records - Refresh As UOENowGridTable
refresh the grid - UpdateRow (rowData As Map)
update an existing row of data - AddColumn (colName As String, colTitle As String, colType As String, colWidth As Int, colSortable As Boolean, colAlign As String) As UOENowGridTable
add a column - AddIcon (colField As String, colTitle As String, colIcon As String, colWidth As String, colAlign As String)
add Icon - AddIconEdit (colField As String, colTitle As String, colWidth As String, colAlign As String)
add edit icon - AddIconDelete (colField As String, colTitle As String, colWidth As String, colAlign As String)
add delete icon - AddTemplate (colField As String, colTitle As String, colTemplate As String, colWidth As String, colSortable As Boolean, colAlign As String)
add template - SetColumnTmpl (colName As String, coltmpl As String) As UOENowGridTable
set the column data template - SetColumnClickEvent (colField As String, stopPropagation As Boolean)
set column click event - SetColumnEvent (colField As String, colEvent As String, stopPropagation As Boolean)
set column event - SetColumnMinWidth (colField As String, colMinWidth As Int, colPriority As Int) As UOENowGridTable
set the column min width - GetSelected As String
get selected record id - GetSelections As List
get all selected record ids - SelectAll
select all records - UnSelectAll
un-select all records - ExpandAll
expand all records - CollapseAll
collapse all records - SetSelected (rowPos As Int)
set a selection - SetColumnName (colField As String, colName As String) As UOENowGridTable
set the column name - SetColumnToolTip (colName As String, colToolTip As String) As UOENowGridTable
set the column tooltip - SetColumnStopPropagation (colName As String, colStopPropagation As Boolean) As UOENowGridTable
set the column stop probagation for events - GetChanges As List
get changed records on table for only changed fields and primary key - SetColumnIcon (colName As String, colIcon As String) As UOENowGridTable
set the column icon - SetColumnHidden (colName As String) As UOENowGridTable
set column visibility - SetColumnSortable (colName As String, colSortable As Boolean) As UOENowGridTable
set column sortable - AddRow (rowData As Map)
add a row dynamically - DownloadCSV (fileName As String)
download data as csv - GetCSV
get data as csv - SetColumnItalic (colName As String) As UOENowGridTable
set header italic - SetColumnHeaderCSS (colName As String, headerCssClass As String) As UOENowGridTable
set header css - SetColumnFilterable (colName As String, colFilter As Boolean) As UOENowGridTable
set column filterable - SetColumnCSS (colName As String, colCSS As String) As UOENowGridTable
set the column class - SetColumnFormat (colName As String, colFormat As String) As UOENowGridTable
set the column data format - Destroy
removes all data and events and keep table and wrapper
Attachments
Last edited: