Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

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