users.yml
4.87 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
select:
select u.user_id, u.name, u.login, u.password, u.email, u.phone, u.photo, u.firstname, u.middlename,
u.lastname, u.roleid, u.create_datetime, u.who_create, u.firmid, u.partner_transid, u.departmentid, u.tab_number, u.name_rod, u.posada_rod,
u.all_obl, u.order_ins, u.prover, u.active, u.birth_date, f.name_firm, f.edrpou, r.rolename, r.classrole, d.department_name, u.passwd_decode
from k2users u
left join k2firms f
on u.firmid=f.firmid
left join k2roles r
on u.roleid=r.roleid
left join k2department d
on u.departmentid=d.departmentid
table: k2users
typeid: 1
rows: 20
sortname: create_datetime
sortorder: desc
caption: <%lnUsers%>
readonly_form:
who_create:
height: 550
form_height: 325
custom_form: true
fields:
user_id:
field: user_id
caption: ID
alias: u.user_id
width: 40
readonly: true
align: left
hidden: true
type_field: text
primary_key: true
order_ins:
field: order_ins
alias: u.order_ins
caption: №
width: 40
readonly: true
align: left
hidden: true
type_field: text
login:
field: login
caption: Email
alias: u.login
width: 100
width_form: 250
readonly: false
align: left
type_field: text
act:
field: " "
alias: u.active
caption: Акт.
width: 95
readonly: true
align: center
type_field: condition
cond:
exp: ($row["active"]==0)
url1: ""
target1: _self
target2: _self
caption1: <button style="color:red" onclick="doAkt('{user_id}')">Активувати</button>
url2: ""
caption2: <button onclick="doAkt('{user_id}')">Вимкнути</button>
2:
field: " "
caption: Зміна пароля
width: 110
readonly: true
align: center
type_field: condition
cond:
exp: (false)
url2: "/?adm=k2adminfunc_changepassword&userid={login}&mode=admin"
caption2: "Змінити"
name:
field: name
alias: u.name
caption: Ім'я
width: 250
readonly: false
align: left
type_field: text
birth_date:
field: birth_date
alias: u.birth_date
caption: Дата<br>народження
width: 100
width_form: 250
readonly: false
align: left
type_field: date
email:
field: email
alias: u.email
caption: Електронна пошта
width: 175
width_form: 250
readonly: false
align: left
type_field: text
phone:
field: phone
alias: u.phone
caption: Номер
width: 100
width_form: 250
readonly: false
align: left
type_field: text
tab_number:
field: tab_number
alias: u.tab_number
caption: Таб. номер
width: 75
width_form: 250
readonly: false
align: left
type_field: text
rolename:
field: rolename
alias: r.rolename
caption: Права
width: 150
width_form: 250
readonly: false
type_field: text
align: left
# type_field: DropDown
multy: false
# sql: "select roleid as k, rolename as v from k2roles where (active='1') order by rolename"
type_fieldform: DropDown
alias_form: roleid
sql_form: select roleid as k, rolename as v from k2roles where (active='1') order by rolename
roleid:
field: roleid
alias: u.roleid
caption:
width: 150
readonly: true
hidden: true
type_field: text
department_name:
field: department_name
alias: d.department_name
caption: Підрозділ
width: 150
width_form: 250
readonly: false
type_field: text
align: left
# type_field: DropDown
multy: false
# sql: "select roleid as k, rolename as v from k2roles where (active='1') order by rolename"
type_fieldform: DropDown
alias_form: departmentid
additems:
'': ---------------
sql_form: select departmentid as k, department_name as v from k2department
departmentid:
field: departmentid
alias: u.departmentid
caption:
width: 150
readonly: true
hidden: true
type_field: text