Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1
<%@LANGUAGE="VBSCRIPT"%>
2
<%
3
'=====================================================
4169 dpurdie 4
'|
5
'|			          Weekly Report
6
'|      Suspect that this page is inaccessible
7
'|      Jira Issue query will not work - since Jira 6.1 update    
8
'|
119 ghuddy 9
'=====================================================
10
%>
11
 
12
<%
13
Option explicit
14
Response.Expires = 0
15
%>
16
<%
17
'To enable the script timeout to 10 mins
18
Server.ScriptTimeout=600
19
%>
20
<!--#include file="common/conf.asp"-->
21
<!--#include file="common/globals.asp"-->
22
<!--#include file="common/formating.asp"-->
23
<!--#include file="common/qstr.asp"-->
24
<!--#include file="common/common_subs.asp"-->
25
<!--#include file="common/common_dbedit.asp"-->
26
<%
27
'------------ Variable Definition -------------
28
Dim FSO
29
Dim NewTextFile
30
Dim rsRep
31
Dim sqlstr
3975 dpurdie 32
Dim SSsql, retVal, rsCQ, DEVIiss, outJIRASQL
119 ghuddy 33
'------------ Variable Init -------------------
34
Set rsCQ = Server.CreateObject("ADODB.Recordset")
35
%>
36
<%
37
'--------------------------------------------------------------------------------------------------------------------------
38
Sub Javascript()
39
	NewTextFile.WriteLine("<script language=""JavaScript"" type=""text/javascript"">")
40
	NewTextFile.WriteLine("function MM_findObj(n, d) { //v4.0")
41
	NewTextFile.WriteLine("  var p,i,x;")
42
	NewTextFile.WriteLine("  if(!d) d=document; ")
43
	NewTextFile.WriteLine("  if((p=n.indexOf(""?""))>0&&parent.frames.length) {")
44
	NewTextFile.WriteLine("  	d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);")				
45
	NewTextFile.WriteLine("  }")	
46
	NewTextFile.WriteLine("  if(!(x=d[n])&&d.all) x=d.all[n]; ")	
47
	NewTextFile.WriteLine("  for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];")	
48
	NewTextFile.WriteLine("  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);")	
49
	NewTextFile.WriteLine("  if(!x && document.getElementById) x=document.getElementById(n); ")
50
	NewTextFile.WriteLine("  return x;")			
51
	NewTextFile.WriteLine("}")
52
	NewTextFile.WriteLine("function DisplaySPAN(show, x) {")
53
	NewTextFile.WriteLine("	if (show) {")
54
	NewTextFile.WriteLine("		MM_findObj(""spanHideDetails"" + x).style.display = ""block"";")					
55
	NewTextFile.WriteLine("		MM_findObj(""spanPkgInfo"" + x).style.display = ""block"";")	
56
	NewTextFile.WriteLine("		MM_findObj(""spanShowDetails"" + x).style.display = ""none"";")	
57
	NewTextFile.WriteLine("	} else {")	
58
	NewTextFile.WriteLine("		MM_findObj(""spanHideDetails"" + x).style.display = ""none"";")	
59
	NewTextFile.WriteLine("		MM_findObj(""spanPkgInfo"" + x).style.display = ""none"";")	
60
	NewTextFile.WriteLine("		MM_findObj(""spanShowDetails"" + x).style.display = ""block"";")	
61
	NewTextFile.WriteLine("	}")
62
	NewTextFile.WriteLine("}")
63
	NewTextFile.WriteLine("</script>")
64
End Sub
65
'--------------------------------------------------------------------------------------------------------------------------
66
Sub GetFixedIssues(pv_id)
67
 
68
 
69
	Set sqlstr = OraDatabase.DbCreateDynaset("SELECT iss_db, iss_id, iss_state, notes FROM CQ_ISSUES WHERE pv_id="& pv_id &"  AND iss_state = "& enumISSUES_STATE_FIXED, cint(0))						 
70
 
71
	If sqlstr.RecordCount <> 0 Then
72
		NewTextFile.WriteLine()
73
		NewTextFile.WriteLine("<blockquote><blockquote><font size='1' face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Fixed Issues:</font></blockquote></blockquote>")
74
		NewTextFile.WriteLine("<blockquote><blockquote><blockquote><table width='80%' border='1' cellspacing='0' cellpadding='1'>")
75
		NewTextFile.WriteLine("<tr>")
76
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Issue&nbsp;Id&nbsp;</b></font></td>")
77
		NewTextFile.WriteLine("<td background='#CAC5B8' width='55%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Summary</b></font></td>")
78
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b></I>Issue&nbsp;Type&nbsp;</b></font></td>")
79
		NewTextFile.WriteLine("<td background='#CAC5B8' width='15%' class='form_field'><font size='1' face='tahoma,sans-serif'><b></P>Priority</b></font></td>")
80
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Status</b></font></td>")
81
		NewTextFile.WriteLine("</tr>")
82
 
83
		While ((NOT sqlstr.BOF) AND (NOT sqlstr.EOF))
84
			DEVIiss = "-1"
3975 dpurdie 85
 
119 ghuddy 86
			If CInt(sqlstr("iss_db")) = CInt(enumCLEARQUEST_DEVI_ID) Then
87
				DEVIiss = DEVIiss &","& sqlstr("iss_id")
88
			End If
89
 
90
			SSsql = ReadFile( QUERIES_PATH & "\cq_issues.sql" )
91
			SSsql = Replace( SSsql, "/*enumCLEARQUEST_DEVI_ID*/", enumCLEARQUEST_DEVI_ID)
92
			SSsql = Replace( SSsql, "/*DEVIiss*/", DEVIiss)
93
 
94
			retVal = Get_CQ_Issues ( SSsql, rsCQ )			
95
 
96
			NewTextFile.WriteLine("<tr>")
97
			NewTextFile.WriteLine("<td background='#CAC5B8' nowrap class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("iss_num")&"</b></font></td>")
98
 
99
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&NewLine_To_BR ( To_HTML ( rsCQ("summary") ) )&"</b></font></td>")
100
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("issue_type")&"</b></font></td>")
101
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("priority")&"</b></font></td>")
102
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("Status")&"</b></font></td>")
103
			NewTextFile.WriteLine("</tr>")
104
 
105
			sqlstr.MoveNext
106
 
107
		Wend
108
 
109
		NewTextFile.WriteLine( "                        </table></blockquote></blockquote></blockquote> 		")
110
 
111
	End If
112
 
113
	sqlstr.Close()
114
	Set sqlstr = Nothing
115
 
116
 
117
End Sub
118
'--------------------------------------------------------------------------------------------------------------------------
119
Sub Get_JIRA_Package_Issues ( pv_id )
120
	Dim rsTemp, JIRAiss
121
 
122
	sqlstr = " SELECT *"&_
123
			 " 	 FROM JIRA_ISSUES"&_
124
			 "	WHERE pv_id = "& pv_id 	
125
 
126
	Set rsTemp = OraDatabase.DbCreateDynaset( sqlstr, cint(0))
127
 
128
	If rsTemp.RecordCount <> 0 Then
129
		NewTextFile.WriteLine()
130
		NewTextFile.WriteLine("<blockquote><blockquote><font size='1' face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">JIRA Issues:</font></blockquote></blockquote>")
131
		NewTextFile.WriteLine("<blockquote><blockquote><blockquote><table width='80%' border='1' cellspacing='0' cellpadding='1'>")
132
		NewTextFile.WriteLine("<tr>")
133
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Issue&nbsp;Id&nbsp;</b></font></td>")
134
		NewTextFile.WriteLine("<td background='#CAC5B8' width='55%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Summary</b></font></td>")
135
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b></I>Issue&nbsp;Type&nbsp;</b></font></td>")
136
		NewTextFile.WriteLine("<td background='#CAC5B8' width='15%' class='form_field'><font size='1' face='tahoma,sans-serif'><b></P>Priority</b></font></td>")
137
		NewTextFile.WriteLine("<td background='#CAC5B8' width='10%' class='form_field'><font size='1' face='tahoma,sans-serif'><b>Status</b></font></td>")
138
		NewTextFile.WriteLine("</tr>")		
139
 
140
 
141
 
142
		While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
143
			JIRAiss = "'-1'"
144
 
145
			JIRAiss = JIRAiss &",'"& rsTemp("iss_key")&"'"
146
 
147
			'Construct SQL statement for JIRA database
148
			outJIRASQL = "SELECT I.pkey AS iss_num, I.summary, ISS.pname AS status,  IT.pname as Issue_Type, PR.pname as Priority, I.RESOLUTION "&_
149
			" FROM jiraissue I, issuestatus ISS, issuetype IT, priority PR "&_
150
			" WHERE I.pkey IN ("& JIRAIss &") "&_
151
			" AND I.issuestatus = ISS.ID "&_
152
			" AND IT.ID = I.issuetype "&_
153
			" AND PR.ID = I.PRIORITY "
154
 
155
			retVal = Get_JIRA_Issues ( outJIRASQL, rsCQ )			
156
 
157
			NewTextFile.WriteLine("<tr>")
158
			NewTextFile.WriteLine("<td background='#CAC5B8' nowrap class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("iss_num")&"</b></font></td>")
159
 
160
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&NewLine_To_BR ( To_HTML ( rsCQ("summary") ) )&"</b></font></td>")
161
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("issue_type")&"</b></font></td>")
162
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("priority")&"</b></font></td>")
163
			NewTextFile.WriteLine("<td background='#CAC5B8' class='form_item'><font size='1' color="&chr(34)&"red"&chr(34)&" face='tahoma,sans-serif'><b>"&rsCQ("Status")&"</b></font></td>")
164
			NewTextFile.WriteLine("</tr>")
165
 
166
			rsTemp.MoveNext
167
		WEnd	
168
 
169
		NewTextFile.WriteLine( "                        </table></blockquote></blockquote></blockquote> 		")
170
	End If
171
 
172
 
173
 
174
 
175
 
176
	rsTemp.Close()	
177
	Set rsTemp = nothing
178
 
179
 
180
 
181
End Sub
182
'--------------------------------------------------------------------------------------------------------------------------
183
Sub DisplayComments(pkg_version, comments)
184
 
185
	'NewTextFile.WriteLine("<blockquote><blockquote><font color="&chr(34)&"blue"&chr(34)&" face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Version: "&pkg_version&"</font></blockquote></blockquote>")
186
	If comments <> "" Then
187
		NewTextFile.WriteLine("<blockquote><blockquote><font size='1' face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Comments: </font></blockquote></blockquote>")
188
		NewTextFile.WriteLine("<blockquote><blockquote><blockquote><font size='2' face='tahoma,sans-serif'>"& TextToHTML(comments) &"</font></blockquote></blockquote></blockquote>")
189
	End If	
190
 
191
End Sub
192
'--------------------------------------------------------------------------------------------------------------------------
193
Sub Header() 
194
	NewTextFile.WriteLine("<html>")
195
End Sub
196
'--------------------------------------------------------------------------------------------------------------------------
197
Sub Footer()
198
	NewTextFile.WriteLine("</html>")
199
End Sub
200
'--------------------------------------------------------------------------------------------------------------------------
201
Function  Get_CQ_Issues ( SSsql, OOrsCQ )
202
 
203
	If OOrsCQ.State = 1 Then 
204
		OOrsCQ.Close
205
	End If
206
 
207
	On Error Resume Next
208
	OOrsCQ.ActiveConnection = CQ_conn
209
	OOrsCQ.Source = SSsql
210
	OOrsCQ.CursorType = 0
211
	OOrsCQ.CursorLocation = 2
212
	OOrsCQ.LockType = 3
213
	OOrsCQ.Open()
214
	Get_CQ_Issues = Err.Number
215
 
216
End Function
217
'--------------------------------------------------------------------------------------------------------------------------
218
Function Get_JIRA_Issues ( SSsql, OOrsJIRA )
219
 
220
	If OOrsJIRA.State = 1 Then
221
		OOrsJIRA.Close()
222
	End If
223
 
224
	On Error Resume Next
225
	OOrsJIRA.ActiveConnection = JIRA_conn
226
	OOrsJIRA.Source = SSsql
227
	OOrsJIRA.CursorType = 0
228
	OOrsJIRA.CursorLocation = 2
229
	OOrsJIRA.LockType = 3
230
	OOrsJIRA.Open()
231
	Get_JIRA_Issues = Err.Number
232
 
233
End Function
234
'--------------------------------------------------------------------------------------------------------------------------
235
Public Function TextToHTML ( sString )
236
	Dim mString
237
 
238
	If (sString = "") OR IsNull(sString) Then Exit Function
239
 
240
	mString = Server.HTMLEncode( sString )
241
	mString = Replace(mString, VBNewLine, "<br>")
242
 
243
	TextToHTML = mString
244
End Function
245
'--------------------------------------------------------------------------------------------------------------------------
246
%>
247
<%
248
If (Request("from_date") = "")  OR  (Request("to_date") = "")  OR  (Request("user") = "") Then
249
 
250
	If (Request("from_date") = "") Then
251
		Response.write "<b>ERROR: Missing Parameter: from_date</b>"
252
	ElseIf (Request("to_date") = "") Then
253
		Response.write "<b>ERROR: Missing Parameter: to_date</b>"
254
	ElseIf (Request("user") = "") Then
255
		Response.write "<b>ERROR: Missing Parameter: user</b>"
256
	End If
257
 
258
Else
259
 
260
	Set FSO=Server.CreateObject("Scripting.FileSystemObject")
261
	Dim report_date
262
	report_date = Replace( Request("to_date"), "/", "" )
263
 
264
	Set NewTextFile=FSO.CreateTextFile(Server.MapPath("weekly_reports\weekly_report_"&Request("user")&"_"&report_date&".html"), true)
265
	Call Header()
266
 
267
	OraDatabase.Parameters.Add "FROM_DATE", Request("from_date"), ORAPARM_INPUT, ORATYPE_STRING
268
	OraDatabase.Parameters.Add "TO_DATE", Request("to_date"), ORAPARM_INPUT, ORATYPE_STRING
269
 
270
	Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("weekly_report.sql"), cint(0) )
271
 
272
	OraDatabase.Parameters.Remove "FROM_DATE"
273
	OraDatabase.Parameters.Remove "TO_DATE"
274
 
275
	Call Javascript()
276
 
277
	NewTextFile.WriteLine("<title>Projects Report Between "&Request("from_date")&" and "&Request("to_date")&"</title>")
278
	NewTextFile.WriteLine("<div align="&chr(34)&"center"&chr(34)&"><font color="&chr(34)&"red"&chr(34)&" size="&chr(34)&"4"&chr(34)&" face="&chr(34)&"Verdana, Arial, Helvetica, sans-serif"&chr(34)&">Projects Report Between "&Request("from_date")&" and "&Request("to_date")&"(Ripple Builds Not Displayed)</font></div><br>")
279
 
280
	While ((NOT rsRep.BOF) AND (NOT rsRep.EOF))
281
		If IsNull(rsRep("proj_name")) Then
282
			NewTextFile.WriteLine("<b>"&rsRep("description")&" Package:"&rsRep("pkg_name")&" Version:"&rsRep("pkg_version")&"</b>")
283
		Else
284
			NewTextFile.WriteLine("<b>Location:"&rsRep("proj_name")&"/"&rsRep("rtag_name")&" Package:"&rsRep("pkg_name")&" Version:"&rsRep("pkg_version")&"</b>")
285
		End If
286
		NewTextFile.WriteLine("<br>")
287
		NewTextFile.WriteLine("<font size='2'><b>Last Released:"&rsRep("modified_stamp")&"</b></font>")
288
		Call DisplayComments(rsRep("pkg_version"), rsRep("comments"))
289
		Call GetFixedIssues(rsRep("pv_id"))
290
		Call Get_JIRA_Package_Issues(rsRep("pv_id"))
291
		NewTextFile.WriteLine("<br>")
292
		rsRep.MoveNext	
293
	Wend
294
	%>
295
 
296
	<%
297
 
298
	rsRep.Close()
299
	Set rsRep = Nothing
300
 
301
	Call Footer()
302
 
303
	NewTextFile.Close()
304
	Set NewTextFile=Nothing
305
 
3959 dpurdie 306
	Dim LocalPath
119 ghuddy 307
	LocalPath = Server.MapPath("weekly_reports\weekly_report_"&Request("user")&"_"&report_date&".html")
308
 
3959 dpurdie 309
    'myMail.AddAddress Request("user")&"@erggroup.com"
310
    Send_Email "Release Manager Notification",_
311
               adminEmail, _
312
               objAccessControl.UserEmail,_
313
               "Projects Report"  , _
314
               "Your requested report...",_
315
               LocalPath
316
 
119 ghuddy 317
 
318
	Response.write "<b>Report Generated Successfully and Emailed!</b>"
319
End If
320
Call Destroy_All_Objects
321
%>