Subversion Repositories DevTools

Rev

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

Rev 119 Rev 159
Line 39... Line 39...
39 
	Dim SQLstr
 39 
	Dim SQLstr
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 AS iss_id, si.new_num AS iss_num, si.headline AS summary, his.action_timestamp AS change_stamp, his.user_name, "&_
 42 
		" SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, his.action_timestamp AS change_stamp, his.user_name, "&_
43 
        "        his.action_name, his.new_state"&_
 43 
        "        his.action_name, his.new_state"&_
44 
		"	FROM devi_prod.admin.software_issue si LEFT OUTER JOIN"&_
 44 
    " FROM cq_devi.admin.software_issue si LEFT OUTER JOIN"&_
45 
     	"		 devi_prod.admin.history his ON si.dbid = his.entity_dbid"&_
 45 
      "    cq_devi.admin.history his ON si.dbid = his.entity_dbid"&_
46 
		"  WHERE si.dbid =  "& NNiss_id &_
 46 
		"  WHERE si.dbid =  "& NNiss_id &_
47 
		"  ORDER BY his.action_timestamp"
 47 
		"  ORDER BY his.action_timestamp"
48
48 
 
49 
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
 49 
	ElseIf Cint(NNiss_db) = enumCLEARQUEST_VT5DM_ID Then
50 
		SQLstr = _
 50 
		SQLstr = _
51 
		" SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, his.action_timestamp AS change_stamp, his.user_name, "&_
 51 
		" SELECT si.dbid AS iss_id, si.new_num AS iss_num, si.headline AS summary, his.action_timestamp AS change_stamp, his.user_name, "&_
52 
        "        his.action_name, his.new_state"&_
 52 
        "        his.action_name, his.new_state"&_
53 
		"	FROM VT5DM.admin.software_issue si LEFT OUTER JOIN"&_
 53 
    " FROM CQ_VT5DM.admin.software_issue si LEFT OUTER JOIN"&_
54 
     	"		 VT5DM.admin.history his ON si.dbid = his.entity_dbid"&_
 54 
      "    CQ_VT5DM.admin.history his ON si.dbid = his.entity_dbid"&_
55 
		"  WHERE si.dbid =  "& NNiss_id &_
 55 
		"  WHERE si.dbid =  "& NNiss_id &_
56 
		"  ORDER BY his.action_timestamp"
 56 
		"  ORDER BY his.action_timestamp"
57 
	End If
 57 
	End If
58
58 
 
59 
	OOrsCQ.ActiveConnection = CQ_conn
 59 
	OOrsCQ.ActiveConnection = CQ_conn
60 
	OOrsCQ.Source = SQLstr
 60 
	OOrsCQ.Source = SQLstr
61 
	OOrsCQ.CursorType = 0
 61 
	OOrsCQ.CursorType = 0
62 
	OOrsCQ.CursorLocation = 2
 62 
	OOrsCQ.CursorLocation = 2
63 
	OOrsCQ.LockType = 3
 63 
	OOrsCQ.LockType = 3
64 
	OOrsCQ.Open()
 64 
	OOrsCQ.Open()
65 
End Sub
65 
End Sub
66 
%>
 66 
%>
67 
<%
 67 
<%
68 
Call Get_Issue_Notes ( parIss_db, parIss_id, rsCQ )
 68 
Call Get_Issue_Notes ( parIss_db, parIss_id, rsCQ )
69 
%>
 69 
%>
70 
<!--#include file="_menu_def.asp"-->
 70 
<!--#include file="_menu_def.asp"-->
Line 87... Line 87...
87 
//-->
 87 
//-->
88 
</script>
 88 
</script>
89 
</head>
 89 
</head>
90 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
 90 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();">
91 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
 91 
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
92 
  <tr>
92 
  <tr>
93 
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
 93 
    <td width="1%" background="images/bg_lght_gray.gif">&nbsp;</td>
94 
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span>
94 
    <td width="100%" background="images/bg_lght_gray.gif"><span class="form_field"><br>&nbsp;Issue</span>
95 
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
 95 
      <input name="FRpname" type="text" class="form_item" size="12" value="<%=rsCQ("iss_num")%>" readonly>
96 
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
 96 
      <input name="FRpname2" type="text" class="form_item" size="80" value="<%=rsCQ("summary")%>" readonly> </td>
97 
  </tr>
 97 
  </tr>
98 
  <tr>
98 
  <tr>
99 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
 99 
    <td background="images/bg_lght_gray.gif"><img src="images/h_trsp_dot.gif" width="1" height="400"></td>
100 
    <td valign="top" background="images/bg_form_lightbluedark.gif">
 100 
    <td valign="top" background="images/bg_form_lightbluedark.gif">
101 
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
 101 
	  <table width="100%" border="0" cellspacing="0" cellpadding="0">
102 
        <tr>
102 
        <tr>
103 
          <td align="right" background="images/bg_lght_gray.gif"><br>
103 
          <td align="right" background="images/bg_lght_gray.gif"><br>
104 
            <!-- TABS ------------------------------------------->
 104 
            <!-- TABS ------------------------------------------->
105 
            <%Call Generate_Tab_Menu ( TABarray4, "History", "blue" )%>
 105 
            <%Call Generate_Tab_Menu ( TABarray4, "History", "blue" )%>
106 
            <!------------------------------------------------------------->
 106 
            <!------------------------------------------------------------->
107 
          </td>
 107 
          </td>
108 
        </tr>
 108 
        </tr>
109 
        <tr>
 109 
        <tr>
110 
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
 110 
          <td background="images/lbox_bg_blue.gif">&nbsp;</td>
111 
        </tr>
 111 
        </tr>
112 
      </table><br>
 112 
      </table><br>
113 
      <table width="100%" border="0" cellspacing="5" cellpadding="1">
 113 
      <table width="100%" border="0" cellspacing="5" cellpadding="1">
114 
        <tr>
114 
        <tr>
115 
          <td background="images/bg_vtree_h1.gif">
 115 
          <td background="images/bg_vtree_h1.gif">
116 
			<div id="LayerHistory" style="height:360px; overflow: auto;">
116 
			<div id="LayerHistory" style="height:360px; overflow: auto;">
117 
		            <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
 117 
		            <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
118 
		              <tr>
 118 
		              <tr>
119 
                        <td valign="top" bgcolor="#FFFFFF">
119 
                        <td valign="top" bgcolor="#FFFFFF">
120 
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
 120 
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
121 
							<tr>
 121 
							<tr>
122 
							  <td background="images/bg_vtree_footer.gif">
122 
							  <td background="images/bg_vtree_footer.gif">
123 
								<table width="100%" border="0" cellspacing="1" cellpadding="2">
 123 
								<table width="100%" border="0" cellspacing="1" cellpadding="2">
124 
								  <tr class="form_field">
124 
								  <tr class="form_field">
125 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">Change Date</td>
 125 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">Change Date</td>
126 
									<td width="100%" nowrap background="images/bg_form_lightgray.gif">User Name</td>
 126 
									<td width="100%" nowrap background="images/bg_form_lightgray.gif">User Name</td>
127 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">Action</td>
 127 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">Action</td>
128 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">New State</td>
 128 
									<td width="1%" nowrap background="images/bg_form_lightgray.gif">New State</td>
129 
								  </tr>
 129 
								  </tr>
130 
								  <%If Not IsNull(rsCQ("change_stamp")) Then%>
 130 
								  <%If Not IsNull(rsCQ("change_stamp")) Then%>
131 
								  <%While (NOT rsCQ.BOF) AND (NOT rsCQ.EOF) %>
 131 
								  <%While (NOT rsCQ.BOF) AND (NOT rsCQ.EOF) %>
132 
								  <tr class="form_item">
132 
								  <tr class="form_item">
133 
									<td bgcolor="#FFFFFF" nowrap><%=Day(rsCQ("change_stamp")) &"-"& MonthName(Month(rsCQ("change_stamp")), TRUE) &"-"& Year(rsCQ("change_stamp")) &" "& FormatDateTime( rsCQ("change_stamp"), 4 )%></td>
 133 
									<td bgcolor="#FFFFFF" nowrap><%=Day(rsCQ("change_stamp")) &"-"& MonthName(Month(rsCQ("change_stamp")), TRUE) &"-"& Year(rsCQ("change_stamp")) &" "& FormatDateTime( rsCQ("change_stamp"), 4 )%></td>
134 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("user_name")%></td>
 134 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("user_name")%></td>
135 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("action_name")%></td>
 135 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("action_name")%></td>
136 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("new_state")%></td>
 136 
									<td bgcolor="#FFFFFF" nowrap><%=rsCQ("new_state")%></td>
137 
								  </tr>
 137 
								  </tr>
Line 143... Line 143...
143 
							</tr>
 143 
							</tr>
144 
						  </table>
 144 
						  </table>
145 
					    </td>
 145 
					    </td>
146 
                      </tr>
 146 
                      </tr>
147 
                   </table>
 147 
                   </table>
148 
            </div>
148 
            </div>
149 
		  </td>
 149 
		  </td>
150 
        </tr>
 150 
        </tr>
151 
      </table><br>
 151 
      </table><br>
152 
	  </td>
 152 
	  </td>
153 
  </tr>
 153 
  </tr>
154 
  <tr>
154 
  <tr>
155 
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
 155 
    <td background="images/bg_lght_gray.gif">&nbsp;</td>
156 
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
 156 
    <td background="images/lbox_bg_blue.gif">&nbsp;</td>
157 
  </tr>
 157 
  </tr>
158 
</table>
 158 
</table>
159 
</body>
 159 
</body>
160 
</html>
 160 
</html>
161 
 
 161 
 
162 
 
 162 
 
163 
<!-- DESTRUCTOR ------->
 163 
<!-- DESTRUCTOR ------->
164 
<!--#include file="common/destructor.asp"-->
 - 
 
165 

            164
            
<!--#include file="common/destructor.asp"-->

          

          

            -
            
 

            165