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
| <?xml version="1.0" encoding="UTF-8"?>
| <!DOCTYPE sql PUBLIC "sql" "../config/sql.dtd" >
|
| <sqls>
|
| <dataSpace name="user">
| <sql name="getClientUserByPhoneOrName">
| <![CDATA[
| select * from usr where phone = '@{phone}' or name = '@{username}'
| ]]>
| </sql>
|
| <sql name="getUser">
| select usr.id, usr.name, usr.type, usr.caption, usr.phone, usr.rolecode, usr.title,
| org.code as orgcode, org.name as orgname, org.name as orgenname, org.id as orgid,
| '' as emp_id, usr.caption as emp_name, '' as emp_enname,
| '' as emp_title, '' as emp_entitle,
| '' as emp_department, '' as emp_endepartment,
| '' as emp_position
| from usr
| left join org on usr.orgid = org.id
| where usr.active = 'T'
| and @{userfilter} @{orgfilter}
| </sql>
| </dataSpace>
| </sqls>
|
|
