Subversion Repositories DevTools

Rev

Rev 5374 | Rev 5634 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1
<%
2
'=====================================================
3
'					CONFIG FILE
4
'=====================================================
5
%>
6
<%
7
' -- VARIABLE DEFINITION ------------------------------
8
Dim OraSession, OraDatabase		' DB connection
9
Dim QUERIES_PATH
10
Dim SCRIPT_NAME
15 rsolanki 11
Dim TNS_NAME, DB_AUTHENTICATION
13 rsolanki 12
Dim APP_ROOT
17 rsolanki 13
Dim rootPath
14
Dim scriptName
4807 dpurdie 15
Dim SMTP_HOST
5355 dpurdie 16
Dim ACCESS_MANAGER_URL
17
Dim RELEASE_MANAGER_URL
18
Dim strRelativePath             ' Rel Path from script to URL
19
Dim managerSuiteBase            ' Url to the base of the Manager Suite
20
Dim FavIcon                     ' Favorite Icon
21
Dim RmDebug                     ' Debug Display
22
 
13 rsolanki 23
' -----------------------------------------------------
24
%>
25
<%
26
' -- DATABASE CONNECTIONS -----------------------------
27
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
31 ghuddy 28
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), 0
13 rsolanki 29
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
30
 
31
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
32
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("DEPLOYMENT_MANAGER_LOGIN"), Cint(0))
33
' -----------------------------------------------------
34
%>
35
<%
5355 dpurdie 36
' -- Basic Functions ----------------------------------
37
' --------------------------------------------------------------------------------------
38
' Determine if a variable or Const exists and is not empty
39
'   Use to check if a vbscript variable has been declared and contains a non-empty value
40
Function isDefined( var)
41
    If (not IsEmpty(Eval(var))) AND Eval(var & " <> """"") Then
42
        isDefined = TRUE
43
    Else
44
        isDefined = FALSE
45
   End If
46
End Function
47
 
4807 dpurdie 48
'--------------------------------------------------------------------------------------
49
'Returns the server of the package archive
50
Function Get_Mail_Server()
51
   Dim sqry: sqry = "SELECT * FROM RELEASE_MANAGER.BUILD_SERVICE_CONFIG WHERE SERVICE='MAIL SERVER'"
52
   Dim rsTemp
53
   Set rsTemp = OraDatabase.DbCreateDynaset( sqry , cint(0) )
54
   Get_Mail_Server = rsTemp("config")
55
   rsTemp.Close()
56
   Set rsTemp = Nothing
57
End Function
58
 
5355 dpurdie 59
'--------------------------------------------------------------------------------------
60
'Return a relative path to the server base. Used for relative pathing to 'images'
61
'Assumes server base is two directores below the web serve root (ManageSuite/Release_Manager)
62
Function GetPathToBase()
63
    Dim url,depth,rv,ii
64
    url = request.servervariables("URL")
65
    depth =  len(url) - len(replace(url, "/", ""))
66
    rv = ""
67
    For ii = 4 To depth
68
        rv = rv & "../"
69
    Next
70
    GetPathToBase = rv
71
End Function
72
 
73
' Return a URL to the base of the Manager suite
74
' Assumes this is one directory down from the web server root
75
Function GetManagerSuiteBase
76
    Dim data
77
    data = Split(request.servervariables("URL"),"/")
78
    GetManagerSuiteBase =  "/" & data(1)
79
End Function
80
 
13 rsolanki 81
' -- CONFIGURATIONS -----------------------------------
82
Const APPLICATION_ID = 1  			' Stored in Deployment Manager, [APPLICATIONS] table
83
APP_ROOT = Server.MapPath(".")
31 ghuddy 84
TNS_NAME = Application("TNS_NAME") '"RELEASEM"
15 rsolanki 85
DB_AUTHENTICATION = Application("DEPLOYMENT_MANAGER_LOGIN") '"release_manager_devl/release_manager_devl"								' DEVL schema
13 rsolanki 86
QUERIES_PATH = APP_ROOT &"\queries"
17 rsolanki 87
scriptName = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
88
rootPath = Left( Server.MapPath( scriptName ), InStrRev(Server.MapPath( scriptName ), "\") )
4807 dpurdie 89
SMTP_HOST = Get_Mail_Server()
3947 dpurdie 90
Const ADMIN_EMAIL = "VixIT@vixtechnology.com"
13 rsolanki 91
Const enumDB_PERMISSION_TYPE_VISIBLE = 1		' Stored in Access Manager, [Permission_Types] table
92
Const enumDB_PERMISSION_TYPE_ACTIVE = 2			' Stored in Access Manager, [Permission_Types] table
93
Const enumRELEASES_DAYS_BACK_IN_TIME = 7		' Number of days back in time searching for released products
5355 dpurdie 94
 
95
strRelativePath = GetPathToBase()
96
managerSuiteBase = GetManagerSuiteBase()
97
ACCESS_MANAGER_URL      = ManagerSuiteBase & "/Access_Manager"
98
RELEASE_MANAGER_URL     = ManagerSuiteBase & "/Release_Manager"
5371 dpurdie 99
FavIcon = strRelativePath & "favicons/DM" & Application("FavIconSuffix") & ".png"
5355 dpurdie 100
 
13 rsolanki 101
' -----------------------------------------------------
102
%>
103
<%
104
' -- VARIABLE INITIALISATION --------------------------
105
SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
106
Const enumDB_DIFF_NO_CHANGE = 0
107
Const enumDB_DIFF_UPDATED = 2
108
Const enumDB_DIFF_NEW = 1
109
Const enumDB_DIFF_REMOVED = -1
29 jtweddle 110
Const enumDB_FILTER_COMMENTS = "Filter Comments"
111
Const enumDB_FILTER_ISSUES = "Filter Issues"
13 rsolanki 112
Const enumPRODUCTS_BASE_VIEW_ID = 5					' Release Manager products base view id
23 rsolanki 113
Const enumAUTOPRODUCTS_BASE_VIEW_ID = 2602					' Release Manager auto_products base view id
13 rsolanki 114
' -----------------------------------------------------
115
%>
116
<%
117
' -- CONSTANTS ----------------------------------------
118
Const enumDB_DEFAULT_EMPTY = -1
119
Const enumISSUES_STATE_FIXED = 1
120
Const enumCLEARQUEST_DEVI_ID = 4
23 rsolanki 121
Const enumJIRA_ID = 6
13 rsolanki 122
Const enumISSUES_STATE_IMPORTED = 0
123
Const enumDB_YES = "Y"
124
Const enumDB_NO = "N"
125
Const enumDEFAULT = "default"
126
Const enumCOOKIE_NAME = "DeploymentManager"
127
Const enumSEPARATOR_LABEL = "SEPARATOR_LABLE"
128
Const enumDB_ALL_DATA = 0
129
Const SPACER = "<img src='images/spacer.gif' width='1' height='1'>"
130
Const enumMSSQL_ERROR = "<img src='icons/i_no_db_connection.gif' width='16' height='17' hspace='2' border='0' align='absmiddle' title='3rd party database is off-line'><SPAN class='body_txtr'>Information not currently available.</SPAN>"
131
Const enumSESSION_COPY_TYPE = "COPY_TYPE"
132
Const enumSESSION_COPY_ITEMS = "COPY_ITEMS"
133
Const enumSESSION_COPY_FROM = "COPY_FROM"
134
Const enumLOADING = "Loading..."
4807 dpurdie 135
Const enum_MSG_ERROR    = "msg_error.asp"
136
Const enum_RELMGR_ERRDESCRIPTION = "RELMGR_ERRDESCRIPTION"		' session variable where long error message is stored before display to user
13 rsolanki 137
' -- ACTION TRAIL -------------------------------------
138
Const enumAT_EVENT_COMMENT 	= 0
139
Const enumAT_EVENT_ADDED 	= 1
140
Const enumAT_EVENT_MODIFIED = 2
141
Const enumAT_EVENT_REMOVED 	= 3
142
' -----------------------------------------------------
143
%>
144
<%
145
' -- OO4O ---------------------------------------------
146
const ORATYPE_VARCHAR2 = 1
147
const ORATYPE_NUMBER = 2
148
const ORATYPE_SINT = 3
149
const ORATYPE_FLOAT = 4
150
const ORATYPE_STRING = 5
151
const ORATYPE_VARCHAR = 9
152
const ORATYPE_DATE = 12
153
const ORATYPE_UINT = 68
154
const ORATYPE_RAW = 95
155
const ORATYPE_CHAR = 96
156
const ORATYPE_CHARZ = 97
157
const ORATYPE_MLSLABEL = 105
158
const ORATYPE_OBJECT = 108
159
const ORATYPE_REF = 110
160
const ORATYPE_CLOB = 112
161
const ORATYPE_BLOB = 113
162
const ORATYPE_BFILE = 114
163
const ORATYPE_VARRAY = 247
164
const ORATYPE_TABLE = 248
165
const ORATYPE_CURSOR = 102
166
 
4807 dpurdie 167
const ORALOB_ONE_PIECE = 0 
168
const ORALOB_FIRST_PIECE = 1 
169
const ORALOB_NEXT_PIECE = 2 
170
const ORALOB_LAST_PIECE = 3
13 rsolanki 171
 
4807 dpurdie 172
Const ORALOB_SUCCESS = 0
173
Const ORALOB_NEED_DATA = 99
174
Const ORALOB_NODATA = 100
175
 
31 ghuddy 176
const ORAPARM_INPUT=1
177
const ORAPARM_OUTPUT=2
13 rsolanki 178
const ORAPARM_BOTH=3
179
 
180
const ORADYN_DEFAULT=&H0&
181
' -----------------------------------------------------
182
%>
183
<%
184
' -- ERROR MESSAGES -----------------------------------
185
' -----------------------------------------------------
186
%>
187
<%
188
' -- ICONS --------------------------------------------
189
' -- ICONS SMALL --------------------------------------
190
' -----------------------------------------------------
191
' -- Other Configuration -----------------------------
192
Const enum_RELMGR_COOKIE_DOMAIN = "RELMGR_USER_COOKIES"
193
Const COOKIE_HIDE_FILES_FILTER = "COOKIE_HIDE_FILES_FILTER"
194
Const COOKIE_HIDE_DEPS_FILTER = "COOKIE_HIDE_DEPS_FILTER"
195
Const COOKIE_HIDE_DIFF_FILTER = "COOKIE_HIDE_DIFF_FILTER"
196
Const COOKIE_RELMGR_SHOW_VIEW = "COOKIE_RELMGR_SHOW_VIEW"
197
Const COOKIE_RELEASE_MANAGER_MEMORY = "RELEASE_MANAGER_MEMORY"
198
Const COOKIE_PATCH_OPTIONS_FILTER = "COOKIE_PATCH_OPTIONS_FILTER"
199
%>