users.yml
4.38 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
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
detile: k2users_obl
caption: <%lnUsers%>
readonly_form:
who_create:
height: 550
form_height: 325
custom_form: true
fields:
user_id:
field: user_id
caption: ID
width: 40
readonly: true
align: left
hidden: true
order_ins:
field: order_ins
caption: №
width: 40
readonly: true
align: left
hidden: true
login:
field: login
caption: Email
width: 100
width_form: 250
readonly: false
align: left
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
caption: Ім'я
width: 250
readonly: false
align: left
birth_date:
field: 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
phone:
field: phone
caption: Номер
width: 100
width_form: 250
readonly: false
align: left
tab_number:
field: tab_number
caption: Таб. номер
width: 75
width_form: 250
readonly: false
align: left
rolename:
field: rolename
alias: r.rolename
caption: Права
width: 150
width_form: 250
readonly: false
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
caption:
width: 150
readonly: true
hidden: true
department_name:
field: department_name
alias: d.department_name
caption: Підрозділ
width: 150
width_form: 250
readonly: false
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
caption:
width: 150
readonly: true
hidden: true