Subversion Repositories DevTools

Rev

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

Rev Author Line No. Line
5506 dpurdie 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4
'|                                                   |
5
'|                          INDEX                    |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
Option explicit
11
' Good idea to set when using redirect
12
Response.Expires = 0   ' always load the page, dont store
13
%>
14
<!--#include file="common/conf.asp"-->
15
<!--#include file="common/globals.asp"-->
16
<!--#include file="common/formating.asp"-->
17
<!--#include file="common/qstr.asp"-->
18
<!--#include file="common/common_subs.asp"-->
19
<%
20
'------------ ACCESS CONTROL ------------------
21
%>
6181 dpurdie 22
<!--#include file="_access_control_login_optional.asp"-->
5506 dpurdie 23
<!--#include file="_access_control_general.asp"-->
24
<%
25
'------------ Variable Definition -------------
26
Dim parMsg
5590 dpurdie 27
Dim msgScript, msgTitle
5506 dpurdie 28
Dim userId
5901 dpurdie 29
Dim pkgCount
5506 dpurdie 30
Dim rsQry
31
Dim rsLastRelease
32
Dim AutomatedPackages, TotalPackages
33
Dim Query_String
34
Dim Auto
35
'------------ Constants Declaration -----------
36
'------------ Variable Init -------------------
37
parMsg = QStrPar("msg")         ' Messages
38
'----------------------------------------------
39
%>
40
<%
41
'-----------------------------------------------------------------------------------------------------------------------
42
Function Get_Messages
43
   Get_Messages = _
44
   " SELECT * FROM message_board WHERE expiry_date > "& ORA_SYSDATE &" OR due_date >= "& ORA_SYSDATE &"+2"
45
End Function
46
'-----------------------------------------------------------------------------------------------------------------------
47
%>
48
<html>
49
   <head>
50
      <title>Release Manager</title>
51
      <link rel="shortcut icon" href="<%=FavIcon%>"/>
52
      <meta http-equiv="Pragma" content="no-cache">
53
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
6579 dpurdie 54
      <link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
55
      <link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
56
      <script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
57
      <script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
5590 dpurdie 58
      <!--#include file="_jquery_includes.asp"-->
5506 dpurdie 59
      <!-- TIPS -->
6579 dpurdie 60
      <script language="JavaScript" src="images/tipster.js?ver=<%=VixVerNum%>"></script>
61
      <script language="JavaScript" src="images/_help_tips.js?ver=<%=VixVerNum%>"></script>
5506 dpurdie 62
      <!-- DROPDOWN MENUS -->
63
      <!--#include file="_menu_def.asp"-->
6579 dpurdie 64
      <script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
5506 dpurdie 65
      <script language="JavaScript" type="text/javascript">
66
      <!--
5901 dpurdie 67
      formTips.tips.h_wip       = stdTip(300, 'Work In Progress', 'These are versions of packages that have not yet been Released.' +
68
                                                                  '<p>The versions are associated with a Release and are considered to be a "Work In Progress".' + 
69
                                                                  '<p>Consider Releasing or Deleting these versions.' 
70
                                                                  );
71
      formTips.tips.h_dangling       = stdTip(300, 'Dangling Versions', 'Dangling package versions are versions of a package that have not been released and are not associated with any Release.' +
5902 dpurdie 72
                                                                  '<p>These are commonly caused by "Removing" a WIP instead of "Destroying" it.' + 
73
                                                                  '<p>Please consider destroying these versions.' 
5901 dpurdie 74
                                                                  );
5506 dpurdie 75
      //-->
76
      </script>
77
      <style type="text/css">
78
      <!--
79
      .style1 {
80
         font-family: Arial, Helvetica, sans-serif;
81
         font-size: 12px;
82
      }
83
      .style3 {
84
         font-size: 11px;
85
         font-family: tahoma, sans-serif;
86
      }
87
      -->
88
      </style>
89
   </head>
6048 dpurdie 90
   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
5506 dpurdie 91
      <!-- HEADER -->
92
      <!--#include file="_header.asp"-->
93
      <!-- BODY ---->
94
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
95
         <tr>
96
            <td width="1%" background="images/bg_home_orange.gif" valign="top">
97
            <!--#include file="_front_explorer.asp"-->
98
            </td>
99
            <td rowspan="2" width="1%" valign="top">
100
               <table width="100%" border="0" cellspacing="0" cellpadding="0">
101
                  <tr>
102
                     <td width="1%">
103
                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
104
                           <tr>
105
                              <td colspan="3">
106
                                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
107
                                    <tr>
108
                                       <td background="images/bg_comp_gear.gif"><img src="images/img_comp_gear_left.jpg" width="436" height="88"></td>
109
                                       <td align="right" background="images/bg_comp_gear.gif"><img src="images/img_comp_gear_right.jpg" width="70" height="88"></td>
110
                                    </tr>
111
                                 </table>
112
                              </td>
113
                              <td background="images/bg_action_norm.gif"></td>
114
                           </tr>
115
                           <tr>
116
                              <td width="1%"><img src="images/h_trsp_dot.gif" width="15" height="518"></td>
117
                              <td width="100%" valign="top" class="body_txt">
118
                                 <br>
119
                                 <!-- MESSAGE BOARD ---------------------------------------------->
120
                                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
121
                                    <tr>
122
                                       <td colspan="2" class="body_sect">Message Board</td>
123
                                    </tr>
124
                                    <tr>
125
                                       <td align="center" width="1%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif">Due Date</td>
126
                                       <td width="100%" background="images/bg_form_lightbluedark.gif" align="right">
5590 dpurdie 127
                                          <a href="javascript:;" onclick="MM_openVixIFrame('_wform_schedule_add.asp','Add Scheduled Task')"><img src="images/i_schedule.gif" width="16" height="15" border="0" hspace="4" vspace="2" alt="Schedule a Task" title="Schedule a Task"></a><a href="javascript:;" onclick="MM_openVixIFrame('_wform_memo_add.asp','Add Memo')"><img src="images/i_memo.gif" width="12" height="15" border="0" hspace="4" vspace="2" alt="Memo" title="Memo"></a>
5506 dpurdie 128
                                       </td>
129
                                    </tr>
130
                                    <%
131
                                    Set rsTemp = OraDatabase.DbCreateDynaset( Get_Messages, cint(0))
132
                                    If rsTemp.RecordCount < 1 Then Response.write "<tr><td colspan='2' class='msgb_item'>&nbsp;No messages at this time.</td></tr>"
133
                                    While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
134
                                       If rsTemp.Fields("due_date") <> "" Then
135
                                          msgScript = "schedule"
5590 dpurdie 136
                                          msgTitle = "Edit Scheduled Task"
5506 dpurdie 137
                                       Else
138
                                          msgScript = "memo"
5590 dpurdie 139
                                          msgTitle = "Edit Memo"
5506 dpurdie 140
                                       End If
141
                                       %>
142
                                       <tr>
143
                                          <td align="center" valign="top" nowrap>
144
                                             <%If rsTemp.Fields("due_date") <> "" Then%>
5590 dpurdie 145
                                             <a href="javascript:;" onClick="MM_openVixIFrame('_wform_<%=msgScript%>_edit.asp?FRmsg_id=<%=rsTemp.Fields("msg_id")%>','<%=msgTitle%>')" class="msgb_item">
5632 dpurdie 146
                                             <%=DisplayDate(rsTemp.Fields("due_date"))%>
5506 dpurdie 147
                                             <br>
148
                                             <img src="images/i_clock.gif" width="14" height="14" border="0">
149
                                             </a>
150
                                             <%Else%>
151
                                             <img src="images/h_trsp_dot.gif" width="1" height="25">
152
                                             <%End If%>
153
                                          </td>
5590 dpurdie 154
                                          <td valign="top"><a href="javascript:;" onClick="MM_openVixIFrame('_wform_<%=msgScript%>_edit.asp?FRmsg_id=<%=rsTemp.Fields("msg_id")%>','<%=msgTitle%>')" class="msgb_item"><%=Replace(rsTemp.Fields("msg_details"), VBNewLine, "<br>")%></a>
5506 dpurdie 155
                                          </td>
156
                                       </tr>
157
                                       <tr>
158
                                          <td colspan="2" background="images/bg_form_lightbluedark.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
159
                                       </tr>
160
                                       <%
161
                                       rsTemp.MoveNext
162
                                      WEnd
163
                                    rsTemp.Close
164
                                    Set rsTemp = nothing
165
                                    %>
166
                                    <tr>
167
                                       <td><img src="images/h_trsp_dot.gif" width="80" height="1"></td>
168
                                       <td align="right"></td>
169
                                    </tr>
170
                                 </table>
171
                                 <!-- MESSAGE BOARD END ---------------------------------------------->
172
                                 <br>
173
                                 <br>
174
                                 <!-- WORK IN PROGRESS ---------------------------------------------->
175
                                 <table width="100%" border="0" cellspacing="1" cellpadding="1">
176
                                    <tr>
5901 dpurdie 177
                                       <td colspan="4" class="body_sect">Work In Progress<%=Quick_Help("h_wip")%>
178
                                       </td>
5506 dpurdie 179
                                    </tr>
180
                                    <tr>
181
                                       <td width="40%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif">&nbsp;User</td>
182
                                       <td width="50%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif">&nbsp;Package Count</td>
183
                                    </tr>
184
                                    <!-- PERSONAL WORK IN PROGRESS  -->
185
                                    <%
186
                                    If objAccessControl.UserLogedIn Then
187
 
188
                                       OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
189
 
190
                                       Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("WorkInProgressByUser.sql"), cint(0))
191
 
192
                                       OraDatabase.Parameters.Remove "USER_ID"
193
 
194
                                       userId = rsTemp("user_id")
195
                                       %>
196
                                       <tr>
197
                                          <td nowrap>
6615 dpurdie 198
                                          <a href='javascript:;'><img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_WIP_<%=userId%>" class="txt_linked" onClick="ToggleLoadControl ('WIP_<%=userId%>','RequestUserWip.asp?user_id=<%=userId%>');"></a>
6613 dpurdie 199
                                               <%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%>
5506 dpurdie 200
                                          </td>
201
                                          <td nowrap class="body_txt"><%=rsTemp("counter")%></td>
202
                                       </tr>
6613 dpurdie 203
                                       <tr id="TGL_WIP_<%=userId%>" style="display:none;">
204
                                          <td nowrap class="body_txt" colspan="3"><div id="WIP_<%=userId%>"><div><%=enumLOADING%></div></td>
5506 dpurdie 205
                                       </tr>
206
                                       <tr>
207
                                          <td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
208
                                       </tr>
209
                                       <%
210
                                       rsTemp.Close
211
                                       Set rsTemp = nothing
212
                                    End If%>
213
                                 </table>
214
                                 <!--  WORK IN PROGRESS END ------------------------------------------>
5901 dpurdie 215
                                 <!-- DANGLING PACKAGES ---------------------------------------------->
216
                                <%
217
                                pkgCount = 0
218
                                If objAccessControl.UserLogedIn Then
219
                                   OraDatabase.Parameters.Add "USER_ID", objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
220
                                   Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("WorkNotInProgressByUser.sql"), cint(0))
221
                                   OraDatabase.Parameters.Remove "USER_ID"
222
                                   userId = rsTemp("user_id")
223
                                   pkgCount = rsTemp("counter")
224
                                End If    
225
                                %>
226
                                 <table width="100%" border="0" cellspacing="1" cellpadding="1">
227
                                    <tr>
228
                                       <td colspan="4" class="body_sect">Dangling Package Versions
229
                                       <%=Quick_Help("h_dangling")%>
230
                                       <%If pkgCount > 10 Then%>
231
                                            <img src='images/a_warning.gif' width='21' height='21' border='0' title='Unreleased packages that are not in use.'>
232
                                       <%End If%>
233
                                       </td>
234
                                    </tr>
235
                                    <tr>
236
                                       <td width="40%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif">&nbsp;User
237
                                       </td>
238
                                       <td width="50%" nowrap class="body_txt" background="images/bg_form_lightbluedark.gif">&nbsp;Package Count</td>
239
                                    </tr>
240
                                    <%If objAccessControl.UserLogedIn Then %>
241
                                       <tr>
242
                                          <td nowrap>
6615 dpurdie 243
                                            <a href='javascript:;'><img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_DGL_<%=userId%>" class="txt_linked" onClick="ToggleLoadControl('DGL_<%=userId%>','RequestUserDangle.asp?user_id=<%=userId%>');"><%=emailField(enum_imgUserLg & rsTemp("full_name"), rsTemp("user_email"))%></a>
5901 dpurdie 244
                                          </td>
245
                                          <td nowrap class="body_txt"><%=pkgCount%></td>
246
                                       </tr>
6613 dpurdie 247
                                       <tr id="TGL_DGL_<%=userId%>" style="display:none;">
248
                                          <td nowrap class="body_txt" colspan="3"><div id='DGL_<%=userId%>'><%=enumLOADING%></div></td>
5901 dpurdie 249
                                       </tr>
250
                                       <tr>
251
                                          <td colspan="3" background="images/bg_form_lightbluedark_line.gif"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>
252
                                       </tr>
253
                                       <%
254
                                       rsTemp.Close
255
                                       Set rsTemp = nothing
256
                                    End If%>
257
                                 </table>
258
                                 <!-- DANGLING PACKAGES END ------------------------------------------>
5506 dpurdie 259
                                 <br>
260
                                 <br>
261
                                 <!-- RELEASE METRICS -------------------------------------------------------->
262
                                 <table width="100%" border="0" cellspacing="0" cellpadding="0">
263
                                    <tr>
6613 dpurdie 264
                                       <td class="body_sect">Release Metrics</td>
5506 dpurdie 265
                                    </tr>
266
                                    <tr>
6613 dpurdie 267
                                       <td>
5506 dpurdie 268
                                          <table width="100%" border="0" cellspacing="1" cellpadding="1">
6613 dpurdie 269
                                             <tr class="form_field_bg">
270
                                                <td nowrap class="body_row" valign="top">Project</td>
271
                                                <td nowrap class="body_row" valign="top">Last Built Release</td>
272
                                                <td nowrap class="body_row" valign="top">Completed</td>
273
                                                <td nowrap class="body_row" valign="top">Autobuilt Packages</td>
5506 dpurdie 274
                                             </tr>
275
                                             <%
276
                                             Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ProjectsWithMetrics.sql"), cint(0))
277
 
278
                                             While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
6613 dpurdie 279
                                                 Dim proj_id: proj_id = rsQry("proj_id")
280
                                                OraDatabase.Parameters.Add "PROJ_ID", proj_id, ORAPARM_INPUT, ORATYPE_NUMBER
5506 dpurdie 281
 
282
                                                Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery("ReleaseMetrics.sql"), cint(0))
283
 
284
                                                If rsTemp.RecordCount > 0 Then
285
                                                   Auto=FormatPercent(rsTemp("autobuilt")/rsTemp("total_packages"), 2)
286
                                                End If
287
                                                %>
6613 dpurdie 288
                                                <tr class="form_field_grey_bg">
289
                                                   <td nowrap class="body_row">
6615 dpurdie 290
                                                   <a href='javascript://proj_id=<%=proj_id%>;' class="txt_linked" onClick="ToggleLoadControl('RPM_<%=proj_id%>','RequestProjectRelease.asp?proj_id=<%=rsQry("proj_id")%>');"><img src="images/bt_plus.gif" border="0" align="absmiddle" hspace="3" id="IMG_RPM_<%=proj_id%>"><img src="images/i_world.gif" border="0" align="absmiddle" hspace="3"><%=rsQry("proj_name")%></a>
5506 dpurdie 291
                                                   </td>
6613 dpurdie 292
                                                   <td nowrap class="body_row"><%=rsTemp("rtag_name")%></td>
293
                                                   <td nowrap class="body_row"><%=rsTemp("last_build_time")%></td>
294
                                                   <td nowrap class="body_row">
5506 dpurdie 295
                                                   <%If rsTemp.RecordCount > 0 Then%>
6613 dpurdie 296
                                                        <%=rsTemp("autobuilt")%>/<%=rsTemp("total_packages")%> (<%=Auto%>)
5506 dpurdie 297
                                                   <%End If%>
298
                                                   </td>
299
                                                </tr>
6613 dpurdie 300
                                               <tr id="TGL_RPM_<%=proj_id%>" style="display:none;" class="form_field_grey_bg">
301
                                                  <td nowrap class="body_row" colspan="4"><div id='RPM_<%=proj_id%>'><%=enumLOADING%></div></td>
302
                                               </tr>
5506 dpurdie 303
                                                <%
304
                                                OraDatabase.Parameters.Remove "PROJ_ID"
305
                                                rsTemp.Close()
306
                                                Set rsTemp = Nothing
307
                                                rsQry.MoveNext
308
                                             Wend
309
 
310
                                             rsQry.Close()
311
                                             Set rsQry = Nothing
312
                                             %>
313
                                          </table>
314
                                       </td>
315
                                    </tr>
316
                                 </table>
317
                                 <!-- DASH BOARD END ---------------------------------------------------->
318
                              </td>
319
                              <td width="1%"><img src="images/h_trsp_dot.gif" width="15" height="10"></td>
320
                              <td background="images/bg_action_norm.gif" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="10"></td>
321
                           </tr>
322
                        </table>
323
                     </td>
324
                  </tr>
325
               </table>
326
            </td>
327
            <td width="100%">&nbsp;</td>
328
         </tr>
329
         <tr>
330
            <td valign="bottom" align="center" background="images/bg_home_orange.gif"><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
331
            <td>&nbsp;</td>
332
         </tr>
333
      </table>
334
      <!-- FOOTER -->
5957 dpurdie 335
     <!--#include file="_footer.asp"-->
5506 dpurdie 336
   </body>
337
</html>