| 2 |
rsolanki |
1 |
<%
|
|
|
2 |
'===================================================================
|
|
|
3 |
' User Common
|
|
|
4 |
'===================================================================
|
|
|
5 |
%>
|
|
|
6 |
<!--#include file="../class/classTemplateManager.asp"-->
|
|
|
7 |
<!--#include file="../class/classTabControl.asp"-->
|
|
|
8 |
<!--#include file="../class/classActionButtonControl.asp"-->
|
|
|
9 |
<%
|
|
|
10 |
'------------ VARIABLE DEFINITION -------------
|
|
|
11 |
Dim parApp_id
|
|
|
12 |
Dim parUser_id
|
|
|
13 |
Dim objUserCollector
|
|
|
14 |
Dim objBtnControl
|
|
|
15 |
Dim aTabBtnsDef
|
|
|
16 |
'------------ CONSTANTS DECLARATION -----------
|
|
|
17 |
Const PARENT_TITLE = "User Accounts"
|
|
|
18 |
Const LIMG_ROLE = "<img src='images/i_role.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
19 |
Const LIMG_SPEC_ROLE = "<img src='images/i_spec_role.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
20 |
Const LIMG_DRILL_DOWN = "<img src='images/i_drill_down.gif' width='12' hspace='2' height='14' border='0'>"
|
|
|
21 |
Const LIMG_CONTROL = "<img src='images/i_control.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
22 |
Const LIMG_USER_LRG = "<img src='images/i_user_lrg.gif' width='13' height='17' hspace='2' border='0' align='absmiddle'>"
|
|
|
23 |
Const LIMG_USER_DISABLED_LRG = "<img src='images/i_user_disabled_lrg.gif' width='17' height='18' hspace='2' border='0' align='absmiddle'>"
|
|
|
24 |
Const LIMG_USER = "<img src='images/i_user.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
25 |
Const LIMG_USER_DISABLED = "<img src='images/i_user_disabled.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
26 |
Const LIMG_DISK = "<img src='images/i_disk.gif' width='16' height='16' hspace='4' border='0' align='absmiddle'>"
|
| 6 |
ghuddy |
27 |
Const LIMG_EDIT = "<img src='images/i_edit_no_border.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
28 |
Const LIMG_REMOVE = "<img src='images/i_remove_no_border.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
| 5296 |
dpurdie |
29 |
Const LIMG_DATA_TABLE = "<img src='images/i_data_table.gif' hspace='2' border='0' align='absmiddle' title='See this Control Data Filter (Filter is ON)'>"
|
|
|
30 |
Const LIMG_DATA_TABLE_OFF = "<img src='images/i_data_table_off.gif' hspace='2' border='0' align='absmiddle' title='See this Control Data Filter (Filter is OFF)'>"
|
| 2 |
rsolanki |
31 |
Const LMINUTES_SINCE_LAST_REQUEST = 20 'minutes
|
|
|
32 |
'------------ VARIABLE INIT -------------------
|
|
|
33 |
parUser_id = Request("user_id")
|
|
|
34 |
parApp_id = Request("app_id")
|
|
|
35 |
Set objUserCollector = CreateObject("Scripting.Dictionary")
|
|
|
36 |
Set objBtnControl = New ActionButtonControl
|
|
|
37 |
'------------ CONDITIONS ----------------------
|
|
|
38 |
'----------------------------------------------
|
|
|
39 |
%>
|
|
|
40 |
<%
|
|
|
41 |
'------------ RUN BEFORE PAGE RENDER ----------
|
|
|
42 |
objPMod.PersistInQryString ("user_id")
|
|
|
43 |
objPMod.PersistInQryString ("app_id")
|
|
|
44 |
objPMod.PersistInQryString ("tree")
|
|
|
45 |
'----------------------------------------------
|
|
|
46 |
%>
|
|
|
47 |
<%
|
|
|
48 |
'-----------------------------------------------------------------------------------------------------------------
|
|
|
49 |
Sub GetUserDetails ( nUser_id, ByRef outobjDetails )
|
|
|
50 |
Dim rsQry, query
|
|
|
51 |
query = "SELECT * FROM USERS WHERE user_id = "& nUser_id
|
|
|
52 |
|
|
|
53 |
Set rsQry = OraDatabase.DbCreateDynaset( query , ORADYN_DEFAULT )
|
|
|
54 |
|
|
|
55 |
If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) Then
|
|
|
56 |
outobjDetails.Item ("user_id") = rsQry("user_id")
|
|
|
57 |
outobjDetails.Item ("full_name") = rsQry("full_name")
|
|
|
58 |
outobjDetails.Item ("user_name") = rsQry("user_name")
|
| 6 |
ghuddy |
59 |
outobjDetails.Item ("domain") = rsQry("domain")
|
| 2 |
rsolanki |
60 |
outobjDetails.Item ("is_disabled") = rsQry("is_disabled")
|
| 6 |
ghuddy |
61 |
outobjDetails.Item ("user_email") = rsQry("user_email")
|
| 2 |
rsolanki |
62 |
|
|
|
63 |
Else
|
|
|
64 |
Err.Raise 8, "Sub GetUserDetails", "Empty record set returned. nUser_id="& nUser_id
|
|
|
65 |
|
|
|
66 |
End If
|
|
|
67 |
|
|
|
68 |
rsQry.Close
|
|
|
69 |
Set rsQry = Nothing
|
|
|
70 |
End Sub
|
|
|
71 |
'-----------------------------------------------------------------------------------------------------------------
|
|
|
72 |
Sub RenderTitle ( objCollector )
|
|
|
73 |
If objCollector.Item("is_disabled") = enumDB_YES Then
|
|
|
74 |
Response.write LIMG_USER_DISABLED_LRG
|
|
|
75 |
Else
|
|
|
76 |
Response.write LIMG_USER_LRG
|
|
|
77 |
End If
|
|
|
78 |
|
|
|
79 |
Response.write "<b>"& objCollector.Item("full_name") &" ["& objCollector.Item("user_name") &"]</b>"
|
|
|
80 |
|
|
|
81 |
End Sub
|
|
|
82 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
83 |
Function UserOnlineIcon ( sUserOnlineIcon, nLastRequest )
|
|
|
84 |
If NOT IsNull( sUserOnlineIcon ) Then
|
|
|
85 |
|
|
|
86 |
If NOT IsNull( nLastRequest ) Then
|
|
|
87 |
|
|
|
88 |
|
|
|
89 |
If (TIMER_VALUE - nLastRequest) < LMINUTES_SINCE_LAST_REQUEST Then
|
|
|
90 |
' User is still online
|
|
|
91 |
UserOnlineIcon = sUserOnlineIcon
|
|
|
92 |
Else
|
|
|
93 |
' User has not responded within MINUTES_SINCE_LAST_REQUEST
|
|
|
94 |
UserOnlineIcon = NULL
|
|
|
95 |
End If
|
|
|
96 |
|
|
|
97 |
Else
|
|
|
98 |
UserOnlineIcon = sUserOnlineIcon
|
|
|
99 |
End If
|
|
|
100 |
|
|
|
101 |
Else
|
|
|
102 |
UserOnlineIcon = NULL
|
|
|
103 |
End If
|
|
|
104 |
End Function
|
|
|
105 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
106 |
Function LastRequest ( nLastRequest )
|
|
|
107 |
Dim minDiff
|
|
|
108 |
|
|
|
109 |
If NOT IsNull( nLastRequest ) Then
|
|
|
110 |
minDiff = TIMER_VALUE - nLastRequest
|
|
|
111 |
|
|
|
112 |
If minDiff < 60 Then
|
|
|
113 |
' Show in Minutes
|
|
|
114 |
LastRequest = minDiff &" minutes ago"
|
|
|
115 |
|
|
|
116 |
ElseIf minDiff < 1440 Then
|
|
|
117 |
' Show in Hours
|
|
|
118 |
LastRequest = (minDiff \ 60) &" hours ago"
|
|
|
119 |
|
|
|
120 |
ElseIf minDiff < 43800 Then
|
|
|
121 |
' Show in Days
|
|
|
122 |
LastRequest = (minDiff \ 1440) &" days ago"
|
|
|
123 |
|
|
|
124 |
ElseIf minDiff < 525600 Then
|
|
|
125 |
' Show in Months
|
|
|
126 |
LastRequest = (minDiff \ 43800) &" months ago"
|
|
|
127 |
|
|
|
128 |
Else
|
|
|
129 |
' Show in Years
|
|
|
130 |
LastRequest = (minDiff \ 525600) &" years ago"
|
|
|
131 |
|
|
|
132 |
End If
|
|
|
133 |
|
|
|
134 |
Else
|
|
|
135 |
LastRequest = NULL
|
|
|
136 |
End If
|
|
|
137 |
End Function
|
|
|
138 |
'--------------------------------------------------------------------------------------------------------------------------
|
|
|
139 |
'-----------------------------------------------------------------------------------------------------------------
|
|
|
140 |
%>
|