Sub FillHermosaProtoA As ABMTable
Dim tbl1 As ABMTable
tbl1.Initialize(page, "tbl2", True, False, True, "tbl1theme")
tbl1.SetHeaders(Array As String("Internal Part No", "Description", "Rev.", "Date Received", "Quantity Received", "Balance", "Qty Out", "Taken By", "Comments", "Update"))
tbl1.SetHeaderThemes(Array As String("headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter", "headerfooter"))
If DBM.GetSQL.IsInitialized Then
Dim sql As SQL
sql = DBM.GetSQL
Else
DBM.InitializeSQLite(File.DirApp, "LabInventory.db", False)
sql = DBM.GetSQL
End If
Dim rs As ResultSet
rs = sql.ExecQuery("SELECT rowid, Internal_PartNo, Description, Revision, Date_Received, Quantity_Received, Taken_By, Balance, Comments FROM HermosaProtoA ORDER BY Date_Received ASC")
Dim n As Int = 0
Do While rs.NextRow
Log($"inside loop getting items"$)
Dim cols As List
Dim rCellThemes As List
rCellThemes.Initialize
cols.Initialize
n = n + 1
If n Mod 2 = 0 Then
cols.Add(rs.GetString("Internal_PartNo"))
rCellThemes.Add("positive2")
cols.Add(rs.GetString("Description"))
rCellThemes.Add("positive2")
cols.Add(rs.GetString("Revision"))
rCellThemes.Add("positive2")
cols.Add(rs.GetString("Date_Received"))
rCellThemes.Add("positive2")
cols.Add(rs.GetString("Quantity_Received"))
rCellThemes.Add("positive")
cols.Add(rs.GetString("Taken_By"))
rCellThemes.Add("positive")
cols.Add(rs.GetString("Balance"))
rCellThemes.Add("positive2")
cols.Add("")
rCellThemes.Add("positive")
Dim val As String = rs.GetString("Comments")
If val = Null Then
val = ""
End If
cols.Add(val)
rCellThemes.Add("positive")
Dim update As ABMButton
update.InitializeFloating(page, "update"&n, "mdi-notification-sync", "")
cols.Add(update)
rCellThemes.Add("buttons")
Else
cols.Add(rs.GetString("Internal_PartNo"))
rCellThemes.Add("nocolor2")
cols.Add(rs.GetString("Description"))
rCellThemes.Add("nocolor2")
cols.Add(rs.GetString("Revision"))
rCellThemes.Add("nocolor2")
cols.Add(rs.GetString("Date_Received"))
rCellThemes.Add("nocolor2")
cols.Add(rs.GetString("Quantity_Received"))
rCellThemes.Add("nocolor")
cols.Add(rs.GetString("Taken_By"))
rCellThemes.Add("positive")
cols.Add(rs.GetString("Balance"))
rCellThemes.Add("nocolor2")
cols.Add("")
rCellThemes.Add("nocolor")
Dim val As String = rs.GetString("Comments")
If val = Null Then
val = ""
End If
cols.Add(val)
rCellThemes.Add("nocolor")
Dim update As ABMButton
update.InitializeFloating(page, "update"&n, "mdi-notification-sync", "")
cols.Add(update)
rCellThemes.Add("buttonsnocolor")
End If
Log("rowid: " & rs.GetString("rowid"))
Log($"column list size ${cols.Size}"$)
tbl1.AddRow("uuid"&rs.GetString("rowid"), cols)
tbl1.SetCellTag(n-1, 0, rs.GetString("rowid"))
tbl1.SetRowThemes(rCellThemes)
Loop
sql.Close
Return tbl1
End Sub