VisualNEO Web - neoTable Plugin Tutorial
neoTable
SinLios
1.0
neoTable Plugin Tutorial
Samsung Galaxy Tab 7
[idnumber],[loginMessage],[miobj],[mydata('BirthDate')],[mydata('City')],[mydata('FirstName')],[mydata('LastName')],[mydata('Notes')],[mydata('Title')],[mydata],[neoTableRow],[password],[selectedRow],[serverResponse],[strlength],[totalRows],[user],[userData('error')],[userData],[value]
True
1024
600
False
False
False
WebApp
False
.thead{
background-color:#eaeaea;
}
.pages{
background:#E0E0E0;
overflow:hidden;
}
strong{
color:#ed792f;
}
h1 strong,h2 strong,h3 strong{
color:#403f3c;
}
en
[AndroidOS,iOS,WindowsPhoneOS]
normal
True
True
False
True
True
False
False
True
False
False
TopCenterApp
neoPhpSetPath "neofunctions.php"
neoTableConfigDB "dataContainer1" "mydb" "Employees" "EmployeeID"
CreateEmptyObject [userData]
ParseJSON "[loginData]" [userData]
SetVar [user] ""
SetVar [password] ""
If [userData('error')] != ""
FocusObject "TextInput1"
SetVar [loginMessage] "Wrong credentials, please try again"
Else
HideObject "loginPanel" "fadeOut" 13
SetVar [loginMessage] "Please enter user and password"
EndIf
[loginData]|STRING|JSON user data from server
If [value] = ""
Return "Empty value not allowed"
Else
StrLen "[value]" [strlength]
If [strlength] > 20
Return "Max length 20 chars"
EndIf
EndIf
[value]|STRING|name to test
If [value] = ""
Return "Empty value not allowed"
Else
StrLen "[value]" [strlength]
If [strlength] > 200
Return "Max length 200 chars"
EndIf
EndIf
SetVar [serverResponse] [resp]
[resp]|STRING|Server response
CreateEmptyObject [miobj]
SetVar [miobj] [resp]
ArrayLen [miobj] [totalRows]
ConsoleLog "Total records: [totalRows]"
neoTableEditColumnAsText "dataContainer1" "3" "popup" "right" "Last name" "" true "testName" true "backFromServer"
neoTableEditColumnAsText "dataContainer1" "4" "popup" "bottom" "First name" "" true "testName" true "backFromServer"
neoTableEditColumnAsSelect "dataContainer1" "5" "popup" "bottom" "Select title" "Sales Representative\nSales Manager\nVice President\nInside Sales Coordinator\nSecretary" "" true "backFromServer"
neoTableEditColumnAsDate "dataContainer1" "6" "bottom" "Select birth date" "mm/dd/yyyy" "mm/dd/yyyy" "Sunday" "en" "" true "backFromServer"
neoTableEditColumnAsCheckList "dataContainer1" "7" "popup" "bottom" "Choose cities" "London\nMadrid\nSeattle\nTacoma\nKirkland\nRedmond\nNew York\nSan Francisco" "" true "backFromServer"
neoTableEditColumnAsTextArea "dataContainer1" "8" "popup" "left" "Add some notes" "" true "testNotes" true "backFromServer"
neoTableResetColumns "dataContainer1"
neoTableSetSelectColumn "dataContainer1" 1 "EmployeeID"
neoTableSetColumn "dataContainer1" 2 "EmployeeID" "Id" "" false false false ""
neoTableSetColumn "dataContainer1" 3 "LastName" "Last name" "" false true true ""
neoTableSetColumn "dataContainer1" 4 "FirstName" "First name" "" false true true ""
neoTableSetColumn "dataContainer1" 5 "Title" "Title" "" false true true ""
neoTableSetColumn "dataContainer1" 6 "BirthDate" "Birth Date" "" false true true ""
neoTableSetColumn "dataContainer1" 7 "City" "Cities" "" false true true ""
neoTableSetColumn "dataContainer1" 8 "Notes" "Notes" "" false true true ""
neoTableInitTable "dataContainer1" "" 0 "Table" true true true true false ""
neoTableLoadData "dataContainer1" [miobj]
EnableObject "PushButtonDeleteRow"
EnableObject "PushButtonAddRow"
[resp]|STRING|JSON Data
CreateEmptyObject [miobj]
SetVar [miobj] [resp]
ArrayLen [miobj] [totalRows]
ConsoleLog "Total records: [totalRows]"
neoTableResetColumns "dataContainer1"
neoTableSetColumn "dataContainer1" 1 "EmployeeID" "Id" "" false false false ""
neoTableSetColumn "dataContainer1" 2 "LastName" "Last name" "" false false true ""
neoTableSetColumn "dataContainer1" 3 "FirstName" "First name" "" false false true ""
neoTableSetColumn "dataContainer1" 4 "Title" "Title" "" false false true ""
neoTableSetColumn "dataContainer1" 5 "BirthDate" "Birth Date" "" false false true ""
neoTableSetColumn "dataContainer1" 6 "City" "Cities" "" false false true ""
neoTableSetColumn "dataContainer1" 7 "Notes" "Notes" "" false false true ""
neoTableInitTable "dataContainer1" "" 0 "Table" true true true true false ""
neoTableLoadData "dataContainer1" [miobj]
EnableObject "PushButtonDeleteRow"
EnableObject "PushButtonAddRow"
[resp]|STRING|Server data
ShowObject "loginPanel" "fadeIn" 13
neoPhpExecSql "mydb" "selectemployees" "" "parsedata"
MasterPage
fadeIn
SetVar [loginMessage] "Please enter user and password"
0px
0px
1024px
88px
0
0px
16px
496px
56px
<strong>neoTable</strong> 2.0
h2
16px
136px
992px
448px
Paragrph1
249px
16px
775px
56px
DataBase edition capabilities
h2
552px
96px
88px
32px
Edit Data
neoPhpExecSql "mydb" "selectemployees" "" "parsedata"
16px
96px
168px
32px
Load Data from DB
glyphicon-cloud-download
neoPhpExecSql "mydb" "selectemployees" "" "parsedata2"
784px
96px
136px
32px
False
Delete Row
glyphicon-trash
danger
neoTableGetSelectedId "dataContainer1" [selectedRow]
If [selectedRow] != undefined
neoPhpExecSql "mydb" "deleteemployeesrow" "[selectedRow]" "loadrecords"
Else
AlertBox "Warning" "Please select a row first.<br>New rows must be reloaded before deleting them" ""
EndIf
648px
96px
128px
32px
False
Add new row
glyphicon-plus-sign
primary
neoPhpExecSql "mydb" "insertemployees" "" "loadrecords"
928px
96px
80px
32px
Logout
neoPhpUserLogOut "userLogout"
0px
0px
1024px
600px
False