Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 159
Line 40... Line 40...
40
	If Cint(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
40
	If Cint(NNiss_db) = enumCLEARQUEST_DEVI_ID Then
41
		SQLstr = _
41
		SQLstr = _
42
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
42
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
43
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
43
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
44
	    "        ap.fullname AS approver, si.description"&_
44
	    "        ap.fullname AS approver, si.description"&_
45
		"	FROM devi_prod.admin.software_issue si INNER JOIN"&_
45
    " FROM CQ_DEVI.admin.software_issue si INNER JOIN"&_
46
	    "        devi_prod.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
46
      "        CQ_DEVI.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
47
	    "        devi_prod.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
47
      "        CQ_DEVI.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
48
	    "        devi_prod.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
48
      "        CQ_DEVI.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
49
	    "        devi_prod.admin.users ap ON si.approver = ap.dbid"&_
49
      "        CQ_DEVI.admin.users ap ON si.approver = ap.dbid"&_
50
		"  WHERE si.dbid = "& NNiss_id
50
		"  WHERE si.dbid = "& NNiss_id
51
		
51
 
52
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
52
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
53
		SQLstr = _
53
		SQLstr = _
54
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
54
		" SELECT si.dbid, si.new_num AS iss_num, si.headline AS summary, sdef.name AS status, si.priority AS priority, si.issue_type, si.release_part1, "&_
55
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
55
	    "        si.release_part2, si.release_part3, si.project, si.product AS product, si.package_ref AS package, sb.fullname AS submitter, si.submit_date, ow.fullname AS owner, "&_
56
	    "        ap.fullname AS approver, si.description"&_
56
	    "        ap.fullname AS approver, si.description"&_
57
		"	FROM VT5DM.admin.software_issue si INNER JOIN"&_
57
    " FROM CQ_VT5DM.admin.software_issue si INNER JOIN"&_
58
	    "        VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
58
      "        CQ_VT5DM.admin.statedef sdef ON si.state = sdef.id INNER JOIN"&_
59
	    "        VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
59
      "        CQ_VT5DM.admin.users sb ON si.submitter = sb.dbid INNER JOIN"&_
60
	    "        VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
60
      "        CQ_VT5DM.admin.users ow ON si.owner = ow.dbid INNER JOIN"&_
61
	    "        VT5DM.admin.users ap ON si.approver = ap.dbid"&_
61
      "        CQ_VT5DM.admin.users ap ON si.approver = ap.dbid"&_
62
		"  WHERE si.dbid = "& NNiss_id
62
		"  WHERE si.dbid = "& NNiss_id
63
		
63
 
64
	End If
64
	End If
65
	
65
 
66
	OOrsCQ.ActiveConnection = CQ_conn
66
	OOrsCQ.ActiveConnection = CQ_conn
67
	OOrsCQ.Source = SQLstr
67
	OOrsCQ.Source = SQLstr
68
	OOrsCQ.CursorType = 0
68
	OOrsCQ.CursorType = 0
69
	OOrsCQ.CursorLocation = 2
69
	OOrsCQ.CursorLocation = 2
70
	OOrsCQ.LockType = 3
70
	OOrsCQ.LockType = 3
71
	OOrsCQ.Open()
71
	OOrsCQ.Open()
72
End Sub 
72
End Sub
73
%>
73
%>
74
<%'If parIss_db <> enumCLEARQUEST_DEVI_ID AND parIss_db <> enumCLEARQUEST_VT5DM_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
74
<%'If parIss_db <> enumCLEARQUEST_DEVI_ID AND parIss_db <> enumCLEARQUEST_VT5DM_ID Then Call RaiseMsg ( enum_WMSG_ERROR, "This option is not available for this issue's database!" )%>
75
<%Call Get_Issue_Details (parIss_id, rsCQ )%>
75
<%Call Get_Issue_Details (parIss_id, rsCQ )%>
76
<!--#include file="_menu_def.asp"-->
76
<!--#include file="_menu_def.asp"-->
77
<html>
77
<html>
Line 83... Line 83...
83
<link rel="stylesheet" href="images/navigation.css" type="text/css">
83
<link rel="stylesheet" href="images/navigation.css" type="text/css">
84
<script language="JavaScript" src="images/common.js"></script>
84
<script language="JavaScript" src="images/common.js"></script>
85
</head>
85
</head>
86
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
86
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
87
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
87
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
88
  <tr> 
88
  <tr>
89
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
89
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
90
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span> 
90
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span>
91
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
91
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
92
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
92
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
93
  </tr>
93
  </tr>
94
  <tr> 
94
  <tr>
95
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
95
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
96
    <td valign="top" background="images/bg_form_lightbluedark.gif">
96
    <td valign="top" background="images/bg_form_lightbluedark.gif">
97
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
97
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
98
        <tr> 
98
        <tr>
99
          <td align="right" background="images/bg_lght_gray.gif"><br> 
99
          <td align="right" background="images/bg_lght_gray.gif"><br>
100
            <!-- TABS ------------------------------------------->
100
            <!-- TABS ------------------------------------------->
101
            <%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
101
            <%Call Generate_Tab_Menu ( TABarray4, "Details", "blue" )%>
102
            <!------------------------------------------------------------->
102
            <!------------------------------------------------------------->
103
          </td>
103
          </td>
104
        </tr>
104
        </tr>
Line 108... Line 108...
108
      </table><br>
108
      </table><br>
109
	  <table width="100%" border="0" cellspacing="5" cellpadding="1">
109
	  <table width="100%" border="0" cellspacing="5" cellpadding="1">
110
        <tr>
110
        <tr>
111
          <td background="images/bg_vtree_h1.gif">
111
          <td background="images/bg_vtree_h1.gif">
112
			<table width="100%" border="0" cellspacing="0" cellpadding="2">
112
			<table width="100%" border="0" cellspacing="0" cellpadding="2">
113
              <tr> 
113
              <tr>
114
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
114
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Issue Type</td>
115
                <td background="images/bg_lght_gray.gif">
115
                <td background="images/bg_lght_gray.gif">
116
				  <select name="group_id" class="form_item" disabled>
116
				  <select name="group_id" class="form_item" disabled>
117
                    <option selected><%=rsCQ("issue_type")%></option>
117
                    <option selected><%=rsCQ("issue_type")%></option>
118
					<option><%=String(ddWidth, "_")%></option>
118
					<option><%=String(ddWidth, "_")%></option>
Line 136... Line 136...
136
				  <select name="group_id" class="form_item" disabled>
136
				  <select name="group_id" class="form_item" disabled>
137
                    <option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
137
                    <option selected><%=ToLongDate( rsCQ("submit_date")+1 )%></option>
138
					<option><%=String(ddWidth, "_")%></option>
138
					<option><%=String(ddWidth, "_")%></option>
139
                  </select></td>
139
                  </select></td>
140
              </tr>
140
              </tr>
141
              <tr> 
141
              <tr>
142
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
142
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Project</td>
143
                <td background="images/bg_lght_gray.gif">
143
                <td background="images/bg_lght_gray.gif">
144
				  <select name="group_id" class="form_item" disabled>
144
				  <select name="group_id" class="form_item" disabled>
145
                    <option selected><%=rsCQ("project")%></option>
145
                    <option selected><%=rsCQ("project")%></option>
146
					<option><%=String(ddWidth, "_")%></option>
146
					<option><%=String(ddWidth, "_")%></option>
Line 150... Line 150...
150
				 <select name="group_id" class="form_item" disabled>
150
				 <select name="group_id" class="form_item" disabled>
151
                    <option selected><%=rsCQ("owner")%></option>
151
                    <option selected><%=rsCQ("owner")%></option>
152
					<option><%=String(ddWidth, "_")%></option>
152
					<option><%=String(ddWidth, "_")%></option>
153
                  </select></td>
153
                  </select></td>
154
              </tr>
154
              </tr>
155
              <tr> 
155
              <tr>
156
			  	<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
156
			  	<td align="right" background="images/bg_lght_gray.gif" class="form_field">Product</td>
157
                <td background="images/bg_lght_gray.gif">
157
                <td background="images/bg_lght_gray.gif">
158
				  <select name="group_id" class="form_item" disabled>
158
				  <select name="group_id" class="form_item" disabled>
159
                    <option selected><%=rsCQ("product")%></option>
159
                    <option selected><%=rsCQ("product")%></option>
160
					<option><%=String(ddWidth, "_")%></option>
160
					<option><%=String(ddWidth, "_")%></option>
Line 164... Line 164...
164
				  <select name="group_id" class="form_item" disabled>
164
				  <select name="group_id" class="form_item" disabled>
165
                    <option selected><%=rsCQ("approver")%></option>
165
                    <option selected><%=rsCQ("approver")%></option>
166
					<option><%=String(ddWidth, "_")%></option>
166
					<option><%=String(ddWidth, "_")%></option>
167
                  </select></td>
167
                  </select></td>
168
              </tr>
168
              </tr>
169
			  <tr> 
169
			  <tr>
170
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
170
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Package</td>
171
                <td background="images/bg_lght_gray.gif">
171
                <td background="images/bg_lght_gray.gif">
172
				  <select name="group_id" class="form_item" disabled>
172
				  <select name="group_id" class="form_item" disabled>
173
                    <option selected><%=rsCQ("package")%></option>
173
                    <option selected><%=rsCQ("package")%></option>
174
					<option><%=String(ddWidth, "_")%></option>
174
					<option><%=String(ddWidth, "_")%></option>
175
                  </select></td>
175
                  </select></td>
176
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
176
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
177
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
177
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
178
              </tr>
178
              </tr>
179
              <tr> 
179
              <tr>
180
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
180
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Priority</td>
181
                <td background="images/bg_lght_gray.gif">
181
                <td background="images/bg_lght_gray.gif">
182
				  <select name="group_id" class="form_item" disabled>
182
				  <select name="group_id" class="form_item" disabled>
183
                    <option selected><%=rsCQ("priority")%></option>
183
                    <option selected><%=rsCQ("priority")%></option>
184
					<option><%=String(ddWidth, "_")%></option>
184
					<option><%=String(ddWidth, "_")%></option>
185
                  </select></td>
185
                  </select></td>
186
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
186
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;</td>
187
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
187
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
188
              </tr>
188
              </tr>
189
              <tr> 
189
              <tr>
190
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
190
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">Status</td>
191
                <td background="images/bg_lght_gray.gif">
191
                <td background="images/bg_lght_gray.gif">
192
				  <select name="group_id" class="form_item" disabled>
192
				  <select name="group_id" class="form_item" disabled>
193
                    <option selected><%=rsCQ("status")%></option>
193
                    <option selected><%=rsCQ("status")%></option>
194
					<option><%=String(ddWidth, "_")%></option>
194
					<option><%=String(ddWidth, "_")%></option>
195
                  </select></td>
195
                  </select></td>
196
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp; 
196
                <td align="right" background="images/bg_lght_gray.gif" class="form_field">&nbsp;
197
                </td>
197
                </td>
198
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
198
                <td background="images/bg_lght_gray.gif">&nbsp;</td>
199
              </tr>
199
              </tr>
200
			  <tr> 
200
			  <tr>
201
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
201
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"><br></td>
202
                <td background="images/bg_lght_gray.gif"></td>
202
                <td background="images/bg_lght_gray.gif"></td>
203
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
203
                <td align="right" background="images/bg_lght_gray.gif" class="form_field"></td>
204
                <td background="images/bg_lght_gray.gif"></td>
204
                <td background="images/bg_lght_gray.gif"></td>
205
              </tr>
205
              </tr>
Line 207... Line 207...
207
          </td>
207
          </td>
208
        </tr>
208
        </tr>
209
		<tr>
209
		<tr>
210
          <td background="images/bg_vtree_h1.gif">
210
          <td background="images/bg_vtree_h1.gif">
211
			  <table width="100%" border="0" cellspacing="0" cellpadding="2">
211
			  <table width="100%" border="0" cellspacing="0" cellpadding="2">
212
		        <tr> 
212
		        <tr>
213
		          <td bgcolor="White" class="form_item"><span class="form_field">Description</span><br>
213
		          <td bgcolor="White" class="form_item"><span class="form_field">Description</span><br>
214
		            <div id="LayerDescription" style="height:160px; overflow: auto;"><%=NewLine_To_BR( Server.HTMLEncode( rsCQ("description") ) )%></div>
214
		            <div id="LayerDescription" style="height:160px; overflow: auto;"><%=NewLine_To_BR( Server.HTMLEncode( rsCQ("description") ) )%></div>
215
				  </td>
215
				  </td>
216
		        </tr>
216
		        </tr>
217
		      </table>
217
		      </table>
218
		  </td>
218
		  </td>
219
		</tr>
219
		</tr>
220
      </table>
220
      </table>
221
	  </td>
221
	  </td>
222
  </tr>
222
  </tr>
223
  <tr> 
223
  <tr>
224
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
224
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
225
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
225
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
226
  </tr>
226
  </tr>
227
</table>
227
</table>
228
</body>
228
</body>
229
</html>
229
</html>
230
 
230
 
231
 
231
 
232
<!-- DESTRUCTOR ------->
232
<!-- DESTRUCTOR ------->
233
<!--#include file="common/destructor.asp"-->
-
 
234
233
<!--#include file="common/destructor.asp"-->
-
 
234