Tabulator Array JS

[skinkairewalker]

hello everyone !!

have a way to insert line like this > " {id:1, partida:"Desportiva Ferroviaria X Itapemirim", data:"20/02/2020", hora:"20:15", casa:1.91, emp:3.32, fora:3.46, amb:1.75, plusonefive:1.18,plus:"Ver Mais" , gender:"Brazil: Campeonato Capixaba"} " individually with array.add or using SB native commands ?

code >

Code: Select all

  Tabulator::SetAttribute2(#myTabulatorGadget, Tabulator::#TabulatorColumns, Columns())
  
  Protected SampleData
  
  
  
  ! v_sampledata = [
  !		{id:1,  partida:"Desportiva Ferroviaria X Itapemirim", data:"20/02/2020",  hora:"20:15",   casa:1.91, emp:3.32, fora:3.46, amb:1.75, plusonefive:1.18,plus:"Ver Mais" , gender:"Brazil: Campeonato Capixaba"},
  !   {id:2,  partida:"Estrela do Norte X Linhares", data:"20/02/2020",  hora:"20:15",   casa:1.53, emp:3.81, fora:4.98, amb:1.89, plusonefive:1.18,plus:"Ver Mais" , gender:"Brazil: Campeonato Capixaba"},
  !   {id:3,  partida:"Serra X SAO Mateus", data:"20/02/2020",  hora:"20:15",   casa:1.54, emp:3.61, fora:5.35, amb:2.13, plusonefive:1.26,plus:"Ver Mais" , gender:"Brazil: Campeonato Capixaba"},
  !   {id:4,  partida:"Boavista X Flamengo RJ", data:"22/02/2020",  hora:"18:00",   casa:11.3, emp:6.54, fora:1.16, amb:"", plusonefive:"",plus:"Ver Mais" , gender:"Brazil: Campeonato Carioca"},
  !	];  

  
  Tabulator::SetAttribute(#myTabulatorGadget, Tabulator::#TabulatorData, SampleData)

[Peter]

For example, you can use LinkedLists:

Code: Select all

Structure sItem
  id.s
  partida.s
  xdata.s
  hora.s
  casa.s
  emp.s
  fora.s
  amb.s
  plusonefive.s
  plus.s
  gender.s
EndStructure

NewList Items.sItem()

AddElement(Items())
Items()\id = "1"
Items()\partida = "Desportiva Ferroviaria X Itapemirim"
Items()\xdata = "20/02/2020"
Items()\hora = "20:15"
Items()\casa = "1.91"
Items()\emp = "3.32"
Items()\fora = "3.46"
Items()\amb = "1.75"
Items()\plusonefive = "1.18"
Items()\plus = "Ver Mais"
Items()\gender = "Brazil: Campeonato Capixaba"

AddElement(Items())
Items()\id = "2"
Items()\partida = "Estrela do Norte X Linhares"
Items()\xdata = "20/02/2020"
Items()\hora = "20:15"
Items()\casa = "1.53"
Items()\emp = "3.81"
Items()\fora = "4.98"
Items()\amb = "1.89"
Items()\plusonefive = "1.18"
Items()\plus = "Ver Mais"
Items()\gender = "Brazil: Campeonato Capixaba"

; ... and so on

Define SampleData.s

CreateJSON(0)
InsertJSONList(JSONValue(0), Items())
SampleData = ComposeJSON(0)
FreeJSON(0)

Debug SampleData

Please note: There is a data property in your JSON. The SpiderBasic IDE recognizes data as a keyword and converts it to Data (with a capital 'D').
If it is somehow possible, you should use a different name for 'data' or you can outsource the structure to an external file.

Greetings ... Peter

[skinkairewalker]

For example, you can use LinkedLists:

Code: Select all

Structure sItem
  id.s
  partida.s
  xdata.s
  hora.s
  casa.s
  emp.s
  fora.s
  amb.s
  plusonefive.s
  plus.s
  gender.s
EndStructure

NewList Items.sItem()

AddElement(Items())
Items()\id = "1"
Items()\partida = "Desportiva Ferroviaria X Itapemirim"
Items()\xdata = "20/02/2020"
Items()\hora = "20:15"
Items()\casa = "1.91"
Items()\emp = "3.32"
Items()\fora = "3.46"
Items()\amb = "1.75"
Items()\plusonefive = "1.18"
Items()\plus = "Ver Mais"
Items()\gender = "Brazil: Campeonato Capixaba"

AddElement(Items())
Items()\id = "2"
Items()\partida = "Estrela do Norte X Linhares"
Items()\xdata = "20/02/2020"
Items()\hora = "20:15"
Items()\casa = "1.53"
Items()\emp = "3.81"
Items()\fora = "4.98"
Items()\amb = "1.89"
Items()\plusonefive = "1.18"
Items()\plus = "Ver Mais"
Items()\gender = "Brazil: Campeonato Capixaba"

; ... and so on

Define SampleData.s

CreateJSON(0)
InsertJSONList(JSONValue(0), Items())
SampleData = ComposeJSON(0)
FreeJSON(0)

Debug SampleData

Please note: There is a data property in your JSON. The SpiderBasic IDE recognizes data as a keyword and converts it to Data (with a capital 'D').
If it is somehow possible, you should use a different name for 'data' or you can outsource the structure to an external file.

Greetings ... Peter

thanks this working fine !!

[skinkairewalker]

how can i get a values from clicked row ?

[Peter]

how can i get a values from clicked row ?

in your case:

Code: Select all

Procedure TabulatorEvents(o)
  
Select EventType()
  Case Tabulator::#EventType_RowClick
    Debug "#EventType_RowClick"
    Protected SelectedRow.sItem
    ! v_selectedrow = v_o.row.row.data;
    ; now you can work with SelectedRow
  Case ....
    [...]
EndSelect
  
EndProcedure

[skinkairewalker]

how can i get a values from clicked row ?

in your case:

Code: Select all

Procedure TabulatorEvents(o)
  
Select EventType()
  Case Tabulator::#EventType_RowClick
    Debug "#EventType_RowClick"
    Protected SelectedRow.sItem
    ! v_selectedrow = v_o.row.row.data;
    ; now you can work with SelectedRow
  Case ....
    [...]
EndSelect
  
EndProcedure

but how can i print values ?

[Peter]

but how can i print values ?

what do you mean by "print values"? Printing with a printer?

[skinkairewalker]

print on debug , like > Debug(SelectedRow.id)

[skinkairewalker]

screenshot > https://prnt.sc/r70747

code >

Code: Select all

Procedure TabulatorEvents(o)
  
  Select EventType()
    Case Tabulator::#EventType_RowClick
      Debug "#EventType_RowClick"
      Protected SelectedRow.sItem
      Protected Items.s
      ! v_selectedrow = v_o.row.row.data;
      ! v_items=v_selectedrow;
      Debug SelectedRow
      
      Debug items
      
    Case Tabulator::#EventType_RowDblClick
      Debug "#EventType_RowDblClick"
    Case Tabulator::#EventType_RowContext
      Debug "#EventType_RowContext"
    Default
      Debug "EventType(): " + EventType()
  EndSelect
  
  Debug "---------------------------"
  
EndProcedure

[Peter]

Code: Select all

[...]

    Case Tabulator::#EventType_RowClick

      Debug "#EventType_RowClick"

      Protected SelectedRow.sItem

      ! v_selectedrow = v_o.row.row.data;
      
      Debug SelectedRow\id
      Debug SelectedRow\partida
      Debug SelectedRow\xdata
      Debug SelectedRow\hora
      Debug SelectedRow\casa
      Debug SelectedRow\emp
      Debug SelectedRow\fora
      Debug SelectedRow\amb
      Debug SelectedRow\plusonefive
      Debug SelectedRow\plus
      Debug SelectedRow\gender