| Line 146... |
Line 146... |
| 146 |
End Function
|
146 |
End Function
|
| 147 |
'----------------------------------------------------------------------------------------------------------------------------------------
|
147 |
'----------------------------------------------------------------------------------------------------------------------------------------
|
| 148 |
' Function returns the number of imported jira issues
|
148 |
' Function returns the number of imported jira issues
|
| 149 |
' and builds a string suitable for querying the jira issues database
|
149 |
' and builds a string suitable for querying the jira issues database
|
| 150 |
Function Get_JIRA_Package_Issues ( NNpv_id, SSsql, DDfixedIss, DDnotesIssDict, nIssState )
|
150 |
Function Get_JIRA_Package_Issues ( NNpv_id, SSsql, DDfixedIss, DDnotesIssDict, nIssState )
|
| 151 |
Dim rsTemp, sqlstr, JIRAIss, retVal
|
151 |
Dim rsTemp, sqlstr, JIRAIss, retVal, joiner
|
| 152 |
|
152 |
|
| 153 |
JIRAIss = "'-1'"
|
153 |
JIRAIss = ""
|
| - |
|
154 |
joiner = ""
|
| 154 |
sqlstr = "SELECT iss_key FROM JIRA_ISSUES WHERE pv_id="& NNpv_id
|
155 |
sqlstr = "SELECT iss_key FROM JIRA_ISSUES WHERE pv_id="& NNpv_id
|
| 155 |
|
156 |
|
| 156 |
Set rsTemp = OraDatabase.DbCreateDynaset( sqlstr, cint(0))
|
157 |
Set rsTemp = OraDatabase.DbCreateDynaset( sqlstr, cint(0))
|
| 157 |
retVal = rsTemp.RecordCount
|
158 |
retVal = rsTemp.RecordCount
|
| 158 |
|
159 |
|
| 159 |
While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
|
160 |
While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))
|
| - |
|
161 |
dim bits
|
| 160 |
JIRAIss = JIRAIss &",'"& rsTemp("iss_key")&"'"
|
162 |
bits = Split( rsTemp("iss_key"), "-" ,2)
|
| - |
|
163 |
JIRAIss = JIRAIss & joiner & "(P.pkey = '" & bits(0) & "' AND I.issuenum = " & bits(1) & ")"
|
| - |
|
164 |
joiner = " OR "
|
| 161 |
rsTemp.MoveNext
|
165 |
rsTemp.MoveNext
|
| 162 |
WEnd
|
166 |
WEnd
|
| 163 |
|
167 |
|
| 164 |
SSsql = "SELECT I.pkey AS iss_num, I.summary, ISS.pname AS state, IT.pname as IssueType, PR.pname as Priority, I.RESOLUTION "&_
|
168 |
SSsql = "SELECT P.pkey AS project, I.issuenum AS iss_num, I.summary, ISS.pname AS state, IT.pname as IssueType, PR.pname as Priority, I.RESOLUTION "&_
|
| 165 |
" FROM jiraissue I, issuestatus ISS, issuetype IT, priority PR "&_
|
169 |
" FROM jiraissue I, issuestatus ISS, issuetype IT, priority PR, project P "&_
|
| 166 |
" WHERE I.pkey IN ("& JIRAIss &") "&_
|
170 |
" WHERE (" & JIRAIss & ")"&_
|
| 167 |
" AND I.issuestatus = ISS.ID "&_
|
171 |
" AND I.issuestatus = ISS.ID "&_
|
| 168 |
" AND IT.ID = I.issuetype "&_
|
172 |
" AND IT.ID = I.issuetype "&_
|
| 169 |
" AND PR.ID = I.PRIORITY "
|
173 |
" AND PR.ID = I.PRIORITY " &_
|
| - |
|
174 |
" AND P.ID = I.project"
|
| - |
|
175 |
|
| - |
|
176 |
'Response.Write("<br>Get_JIRA_Package_Issues" & SSsql )
|
| 170 |
|
177 |
|
| 171 |
rsTemp.Close()
|
178 |
rsTemp.Close()
|
| 172 |
Set rsTemp = nothing
|
179 |
Set rsTemp = nothing
|
| 173 |
|
180 |
|
| 174 |
Get_JIRA_Package_Issues = retVal
|
181 |
Get_JIRA_Package_Issues = retVal
|
| Line 1641... |
Line 1648... |
| 1641 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field">Status</td>
|
1648 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field">Status</td>
|
| 1642 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field">Note</td>
|
1649 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field">Note</td>
|
| 1643 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field"> </td>
|
1650 |
<td bgcolor=#e4e9ec nowrap width="1" class="form_field"> </td>
|
| 1644 |
</tr>
|
1651 |
</tr>
|
| 1645 |
<%If ((NOT rsCQ.BOF) AND (NOT rsCQ.EOF)) Then%>
|
1652 |
<%If ((NOT rsCQ.BOF) AND (NOT rsCQ.EOF)) Then%>
|
| 1646 |
<%While ((NOT rsCQ.BOF) AND (NOT rsCQ.EOF))%>
|
1653 |
<%While ((NOT rsCQ.BOF) AND (NOT rsCQ.EOF))
|
| - |
|
1654 |
dim jiraIssue
|
| - |
|
1655 |
jiraIssue = rsCQ("project") & "-" & rsCQ("iss_num")
|
| - |
|
1656 |
%>
|
| 1647 |
<tr>
|
1657 |
<tr>
|
| 1648 |
<%If rsCQ("resolution") = 1 Then %>
|
1658 |
<%If rsCQ("resolution") = 1 Then %>
|
| 1649 |
<td align="center" nowrap bgcolor=#e4e9ec>
|
1659 |
<td align="center" nowrap bgcolor=#e4e9ec>
|
| 1650 |
<img src="images/i_tick_black.gif" width="7" height="7" vspace="2">
|
1660 |
<img src="images/i_tick_black.gif" width="7" height="7" vspace="2">
|
| 1651 |
</td>
|
1661 |
</td>
|
| 1652 |
<%Else%>
|
1662 |
<%Else%>
|
| 1653 |
<td align="center" nowrap bgcolor=#e4e9ec></td>
|
1663 |
<td align="center" nowrap bgcolor=#e4e9ec></td>
|
| 1654 |
<%End If%>
|
1664 |
<%End If%>
|
| 1655 |
<td bgcolor=#f5f5f5 nowrap class="form_item">
|
1665 |
<td bgcolor=#f5f5f5 nowrap class="form_item">
|
| 1656 |
<a href="<%=JIRA_URL%>/browse/<%=rsCQ("iss_num")%>" target="_blank" class="txt_linked">
|
1666 |
<a href="<%=JIRA_URL%>/browse/<%=jiraIssue%>" target="_blank" class="txt_linked"><%=jiraIssue%></a>
|
| 1657 |
<%=rsCQ("iss_num")%>
|
- |
|
| 1658 |
</a>
|
- |
|
| 1659 |
</td>
|
1667 |
</td>
|
| 1660 |
<td bgcolor=#f5f5f5 class="form_item">JIRA</td>
|
1668 |
<td bgcolor=#f5f5f5 class="form_item">JIRA</td>
|
| 1661 |
<td bgcolor=#f5f5f5 class="form_item"><%=NewLine_To_BR ( To_HTML ( rsCQ("summary") ) )%></td>
|
1669 |
<td bgcolor=#f5f5f5 class="form_item"><%=NewLine_To_BR ( To_HTML ( rsCQ("summary") ) )%></td>
|
| 1662 |
<td nowrap bgcolor=#f5f5f5 class="form_item"><%=rsCQ("issuetype")%></td>
|
1670 |
<td nowrap bgcolor=#f5f5f5 class="form_item"><%=rsCQ("issuetype")%></td>
|
| 1663 |
<td nowrap bgcolor=#f5f5f5 class="form_item"><%=rsCQ("priority")%></td>
|
1671 |
<td nowrap bgcolor=#f5f5f5 class="form_item"><%=rsCQ("priority")%></td>
|
| Line 1667... |
Line 1675... |
| 1667 |
<td align="center" bgcolor=#f5f5f5 class="form_item">
|
1675 |
<td align="center" bgcolor=#f5f5f5 class="form_item">
|
| 1668 |
<img src="images/i_delete_disable.gif" width="13" height="12" hspace="2" border="0">
|
1676 |
<img src="images/i_delete_disable.gif" width="13" height="12" hspace="2" border="0">
|
| 1669 |
</td>
|
1677 |
</td>
|
| 1670 |
<%Else%>
|
1678 |
<%Else%>
|
| 1671 |
<td align="center" bgcolor=#f5f5f5 class="form_item">
|
1679 |
<td align="center" bgcolor=#f5f5f5 class="form_item">
|
| 1672 |
<a href="_remove_jira_issue.asp?iss_link=<%=rsCQ("iss_num")%>&pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>" onClick="return confirmDelete('this issue from Release Manager');">
|
1680 |
<a href="_remove_jira_issue.asp?iss_link=<%=jiraIssue%>&pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>" onClick="return confirmDelete('this issue from Release Manager');">
|
| 1673 |
<img src="images/i_delete.gif" width="13" height="12" hspace="2" border="0" alt="Delete this issue from the list">
|
1681 |
<img src="images/i_delete.gif" width="13" height="12" hspace="2" border="0" alt="Delete this issue from the list">
|
| 1674 |
</a>
|
1682 |
</a>
|
| 1675 |
</td>
|
1683 |
</td>
|
| 1676 |
<%End If%>
|
1684 |
<%End If%>
|
| 1677 |
</tr>
|
1685 |
</tr>
|