1
|
{
|
2
|
"title": "TestForm",
|
3
|
"tableName": "Person",
|
4
|
"parameter": "newButton=t:New",
|
5
|
"recordLockTimeoutSeconds": 900,
|
6
|
"FormElement_ff": [
|
7
|
{
|
8
|
"dynamicUpdate": "yes",
|
9
|
"name": "chbx3",
|
10
|
"label": "Checkbox3",
|
11
|
"type": "checkbox",
|
12
|
"ord": 10,
|
13
|
"tabindex": 0,
|
14
|
"note": "#!report\r\n10 {\r\n sql = SELECT 'p:{{pageAlias:T}}&form=Person&r=30|s|b|t:button' AS _link \r\n}",
|
15
|
"parameter": "checked=yes\r\nunchecked=no\r\n\r\nslaveId = {{ SELECT p.id FROM Person2 AS p WHERE p.id = '{{pId:R0}}'}}\r\n\r\nsqlInsert = {{ INSERT INTO Person2 (`firstName`,`name`) SELECT '{{myFirstName:FR:alnumx}}','{{myName:FR:alnumx}}' WHERE '{{chbx3:FRE:alnumx}}'='yes' }}\r\n\r\nsqlUpdate = {{ UPDATE Person2 AS p SET p.name = '{{myName:FE:alnumx}}', p.firstName='{{myFirstName:FE:alnumx}}' WHERE '{{chbx3:FRE:alnumx}}' = 'yes' AND p.id = {{pId:R0}} }}\r\n\r\nsqlAfter = {{ UPDATE Person AS p SET p.pId = {{slaveId:V}} WHERE p.id = {{id:R0}} AND '{{chbx3:FRE:alnumx}}'='yes' }}"
|
16
|
},
|
17
|
{
|
18
|
"dynamicUpdate": "yes",
|
19
|
"name": "pId",
|
20
|
"label": "Person Tabelle 2",
|
21
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' != 'yes', 'show', 'hidden')}}",
|
22
|
"ord": 20,
|
23
|
"tabindex": 0,
|
24
|
"parameter": "typeAheadSqlPrefetch = SELECT CONCAT(p.name,', ', p.firstName) AS 'value' FROM Person2 AS p WHERE p.id LIKE ? LIMIT 1\r\n\r\ntypeAheadSql = SELECT p.id AS 'id', CONCAT(p.name,', ', p.firstName) AS 'value' FROM Person2 AS p WHERE p.firstName LIKE ? OR p.name LIKE ? LIMIT 100"
|
25
|
},
|
26
|
{
|
27
|
"dynamicUpdate": "yes",
|
28
|
"name": "myPerson2Name",
|
29
|
"label": "Text feld",
|
30
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' != 'yes', 'show', 'hidden')}}",
|
31
|
"ord": 30,
|
32
|
"tabindex": 0,
|
33
|
"value": "{{ SELECT firstName, ' ', name FROM Person2 WHERE id = '{{pId:FR0}}' }}"
|
34
|
},
|
35
|
{
|
36
|
"dynamicUpdate": "yes",
|
37
|
"name": "myFirstName",
|
38
|
"label": "Vorname Neu",
|
39
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' = 'yes', 'show', 'hidden')}}",
|
40
|
"ord": 40,
|
41
|
"tabindex": 0,
|
42
|
"value": "{{SELECT IF('{{myFirstName:FE:alnumx}}' = '' , firstName, '{{myFirstName:FE:alnumx}}') FROM Person2 WHERE id = '{{pId:R0}}'}}"
|
43
|
},
|
44
|
{
|
45
|
"dynamicUpdate": "yes",
|
46
|
"name": "myName",
|
47
|
"label": "Nachname Neu",
|
48
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' = 'yes', 'show', 'hidden')}}",
|
49
|
"ord": 50,
|
50
|
"tabindex": 0,
|
51
|
"value": "{{SELECT IF('{{myName:FE:alnumx}}' = '' , name, '{{myName:FE:alnumx}}') FROM Person2 WHERE id = '{{pId:R0}}'}}"
|
52
|
},
|
53
|
{
|
54
|
"dynamicUpdate": "yes",
|
55
|
"name": "chbx1",
|
56
|
"label": "Checkbox1",
|
57
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' != 'yes', 'show', 'readonly') }}",
|
58
|
"type": "checkbox",
|
59
|
"ord": 60,
|
60
|
"tabindex": 0,
|
61
|
"note": "chbx2: '{{selectBox:FE:alnumx}}' chbx3:'{{chbx3:FE:alnumx}}'",
|
62
|
"parameter": "checked = yes\r\nunchecked = no"
|
63
|
},
|
64
|
{
|
65
|
"dynamicUpdate": "yes",
|
66
|
"name": "firstName",
|
67
|
"label": "Vorname Readonly Test",
|
68
|
"modeSql": "{{SELECT IF('{{chbx3:FRE:alnumx}}' != 'yes', 'show', 'readonly') }}",
|
69
|
"ord": 70,
|
70
|
"tabindex": 0
|
71
|
}
|
72
|
]
|
73
|
}
|