Rev 5299 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%'===================================================================' User Common'===================================================================%><!--#include file="../class/classTemplateManager.asp"--><!--#include file="../class/classTabControl.asp"--><!--#include file="../class/classActionButtonControl.asp"--><%'------------ VARIABLE DEFINITION -------------Dim parApp_idDim parUser_idDim objUserCollectorDim objBtnControlDim aTabBtnsDef'------------ CONSTANTS DECLARATION -----------Const PARENT_TITLE = "User Accounts"Const LMINUTES_SINCE_LAST_REQUEST = 20 'minutes'------------ VARIABLE INIT -------------------parUser_id = Request("user_id")parApp_id = Request("app_id")Set objUserCollector = CreateObject("Scripting.Dictionary")Set objBtnControl = New ActionButtonControl'------------ CONDITIONS ----------------------'----------------------------------------------%><%'------------ RUN BEFORE PAGE RENDER ----------objPMod.PersistInQryString ("user_id")objPMod.PersistInQryString ("app_id")objPMod.PersistInQryString ("tree")'----------------------------------------------%><%'-----------------------------------------------------------------------------------------------------------------Sub GetUserDetails ( nUser_id, ByRef outobjDetails )Dim rsQry, queryquery = "SELECT * FROM USERS WHERE user_id = "& nUser_idSet rsQry = OraDatabase.DbCreateDynaset( query , ORADYN_DEFAULT )If ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) ThenoutobjDetails.Item ("user_id") = rsQry("user_id")outobjDetails.Item ("full_name") = rsQry("full_name")outobjDetails.Item ("user_name") = rsQry("user_name")outobjDetails.Item ("domain") = rsQry("domain")outobjDetails.Item ("is_disabled") = rsQry("is_disabled")outobjDetails.Item ("user_email") = rsQry("user_email")ElseErr.Raise 8, "Sub GetUserDetails", "Empty record set returned. nUser_id="& nUser_idEnd IfrsQry.CloseSet rsQry = NothingEnd Sub'-----------------------------------------------------------------------------------------------------------------Sub RenderTitle ( objCollector )If objCollector.Item("is_disabled") = enumDB_YES ThenResponse.write LIMG_USER_DISABLED_LRGElseResponse.write LIMG_USER_LRGEnd IfResponse.write "<b>"& objCollector.Item("full_name") &" ["& objCollector.Item("user_name") &"]</b>"End Sub'--------------------------------------------------------------------------------------------------------------------------Function UserOnlineIcon ( sUserOnlineIcon, nLastRequest )If NOT IsNull( sUserOnlineIcon ) ThenIf NOT IsNull( nLastRequest ) ThenIf (TIMER_VALUE - nLastRequest) < LMINUTES_SINCE_LAST_REQUEST Then' User is still onlineUserOnlineIcon = sUserOnlineIconElse' User has not responded within MINUTES_SINCE_LAST_REQUESTUserOnlineIcon = NULLEnd IfElseUserOnlineIcon = sUserOnlineIconEnd IfElseUserOnlineIcon = NULLEnd IfEnd Function'--------------------------------------------------------------------------------------------------------------------------Function LastRequest ( nLastRequest )Dim minDiffIf NOT IsNull( nLastRequest ) ThenminDiff = TIMER_VALUE - nLastRequestIf minDiff < 60 Then' Show in MinutesLastRequest = minDiff &" minutes ago"ElseIf minDiff < 1440 Then' Show in HoursLastRequest = (minDiff \ 60) &" hours ago"ElseIf minDiff < 43800 Then' Show in DaysLastRequest = (minDiff \ 1440) &" days ago"ElseIf minDiff < 525600 Then' Show in MonthsLastRequest = (minDiff \ 43800) &" months ago"Else' Show in YearsLastRequest = (minDiff \ 525600) &" years ago"End IfElseLastRequest = NULLEnd IfEnd Function'--------------------------------------------------------------------------------------------------------------------------'-----------------------------------------------------------------------------------------------------------------%>