Project

General

Profile

Bug #15091 ยป TestForm(1).json

Jan Haller, 01.12.2022 16:20

 
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
}
    (1-1/1)