| 2 |
rsolanki |
1 |
/* User List*/
|
|
|
2 |
SELECT DECODE ( usr.IS_ONLINE,
|
|
|
3 |
NULL, NULL,
|
|
|
4 |
'<img src="images/i_online.gif" title="User is online at '|| usr.ONLINE_AT ||'" width="16" height="16" border="0" hspace="2">' ) AS user_online,
|
|
|
5 |
DECODE ( usr.IS_DISABLED,
|
|
|
6 |
NULL, 'LIMG_USER',
|
|
|
7 |
'LIMG_USER_DISABLED' ) AS user_image,
|
|
|
8 |
usr.user_id,
|
|
|
9 |
usr.full_name,
|
|
|
10 |
usr.USER_EMAIL,
|
|
|
11 |
usr.USER_NAME,
|
|
|
12 |
usr.DOMAIN,
|
|
|
13 |
usr.LAST_REQUEST
|
|
|
14 |
FROM USERS usr
|
|
|
15 |
WHERE ( /* Full name filter */
|
|
|
16 |
( LOWER( usr.FULL_NAME ) LIKE LOWER( :FULL_NAME ) AND NOT :FULL_NAME IS NULL ) OR
|
|
|
17 |
( usr.FULL_NAME = usr.FULL_NAME AND :FULL_NAME IS NULL )
|
|
|
18 |
)
|
|
|
19 |
OR ( /* Username filter */
|
|
|
20 |
( LOWER( usr.USER_NAME ) LIKE LOWER( :USER_NAME ) AND NOT :USER_NAME IS NULL ) OR
|
|
|
21 |
( usr.USER_NAME = usr.USER_NAME AND :USER_NAME IS NULL )
|
|
|
22 |
)
|
|
|
23 |
OR ( /* Domain filter */
|
|
|
24 |
( LOWER( usr.DOMAIN ) LIKE LOWER( :DOMAIN_NAME ) AND NOT :DOMAIN_NAME IS NULL ) OR
|
|
|
25 |
( usr.DOMAIN = usr.DOMAIN AND :DOMAIN_NAME IS NULL )
|
|
|
26 |
)
|
|
|
27 |
ORDER BY UPPER(usr.FULL_NAME)
|