Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>

<%

'=====================================================

'|                                                   |

'|                    FIXED ISSUES                   |

'|                                                   |

'=====================================================

%>

<%

Option explicit

' Good idea to set when using redirect

Response.Expires = 0   ' always load the page, dont store

%>

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

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

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

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

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

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

<!--#include file="_tabs.asp"-->

<!--#include file="_action_buttons.asp"-->

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

<%

'------------ ACCESS CONTROL ------------------

%>

<!--#include file="_access_control_general.asp"-->

<%

'------------ Variable Definition -------------

Dim pageIsEditable

Dim sectionIsEditable

Dim criticalSectionIsEditable

'------------ Constants Declaration -----------

'------------ Variable Init -------------------

'----------------------------------------------

'-----------------------------------------------------------------------------------------------------------------

Sub fillCommentsWithDifferences ( parPv_id )

   DIM outputString

   DIM rsTemp

   If pkgInfoHash.Item("comments") = "" or isnull(pkgInfoHash.Item("comments")) Then

      OraDatabase.Parameters.Add "PV_ID", parPv_id,    ORAPARM_INPUT, ORATYPE_NUMBER

      If (pkgInfoHash.Item ("last_pv_id") = "") OR IsNull(pkgInfoHash.Item ("last_pv_id")) Then

         OraDatabase.Parameters.Add "OLD_PV_ID",    0,    ORAPARM_INPUT, ORATYPE_NUMBER

      Else

         OraDatabase.Parameters.Add "OLD_PV_ID",    pkgInfoHash.Item ("last_pv_id"),    ORAPARM_INPUT, ORATYPE_NUMBER

      End If

      Set rsTemp = OraDatabase.DbCreateDynaset( GetQuery ( "diff_dependencies.sql" ), cint(0))

      Dim style, icon

      While ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF))

         Select Case CInt(rsTemp("status"))

         Case enumDB_NUM_DIFF_UPDATED

            outputString = outputString & "[UPDATED] " & rsTemp("pkg_name") &" to "& rsTemp("pkg_version") &" ("& rsTemp("previous_version") &")"& VBNewLine

            Case enumDB_NUM_DIFF_NEW

            outputString = outputString & "[NEW] " & rsTemp("pkg_name") &" "& rsTemp("pkg_version") & VBNewLine

         Case enumDB_NUM_DIFF_REMOVED

            outputString = outputString & "[REMOVED] " & rsTemp("pkg_name") &" "& rsTemp("pkg_version") & VBNewLine

         End Select

            rsTemp.MoveNext

      WEnd

      ' An error occured when outputString was longer than 4000 bytes, so this truncates it and adds "..."

      If LenB(outputString) > 4000 Then

         outputString = Left(outputString, 3995)

         outputString = Left(outputString, InStrRev(outputString, vbNewLine)) & vbNewLine & "..."

      End If

      objEH.TryORA ( OraSession )

      On Error Resume Next

      OraDatabase.ExecuteSQL _

      " UPDATE PACKAGE_VERSIONS"&_

      " SET COMMENTS = '"& outputString &"'"&_

      " WHERE PV_ID = :PV_ID "

      objEH.CatchORA ( OraSession )

      pkgInfoHash.Item("comments") = outputString

      rsTemp.Close

      Set rsTemp = nothing

      OraDatabase.Parameters.Remove "PV_ID"

      OraDatabase.Parameters.Remove "OLD_PV_ID"

   End If

End Sub

'-----------------------------------------------------------------------------------------------------------------

'------------------ MAIN LINE --------------------

pageIsEditable = Is_Page_Editable ( pkgInfoHash.Item ("dlocked") )

sectionIsEditable = Is_Section_Editable ()

criticalSectionIsEditable = Is_Critical_Section_Editable ( pkgInfoHash.Item ("dlocked") )

'-------------------------------------------------

If (Request("resetNotes") = "1") AND (parPv_id <> "") Then

   objEH.TryORA ( OraSession )

   On Error Resume Next

   OraDatabase.ExecuteSQL " UPDATE package_versions "&_

                          " SET release_notes_info = '"& enum_RELEASE_NOTES_NOT_FOUND_IN_ARCHIVE &"'"&_

                          " ,modified_stamp = systimestamp" &_

                          " ,modifier_id = " & objAccessControl.UserId &_

                          " WHERE pv_id = "& parPv_id

   objEH.CatchORA ( OraSession )

   ' Really need to log an action too

   ' Really I just want to get rid of the resetNotes bit.

   Response.Redirect ("fixed_issues.asp?pv_id="&parPv_id&"&rtag_id="&parRtag_id)

End If

%>

<html>

<title><%=Title(Request("rtag_id"))%></title>

<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">

<link rel="stylesheet" href="images/navigation.css" type="text/css">

<script language="JavaScript" src="images/common.js"></script>

<script language="JavaScript" src="scripts/remote_scripting.js"></script>

<!-- TIPS -->

<script language="JavaScript" src="images/tipster.js"></script>

<script language="JavaScript" src="images/_help_tips.js"></script>

<!-- DROPDOWN MENUS -->

<!--#include file="_menu_def.asp"-->

<script language="JavaScript1.2" src="images/popup_menu.js"></script>

</head>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >

<!-- MENU LAYERS -------------------------------------->

<div id="popmenu" class="menuskin" onMouseover="clearhidemenu();highlightmenu(event,'on')" onMouseout="highlightmenu(event,'off');dynamichide(event)">

  <!----------------------------------------------------->

</div>

<!-- TIPS LAYERS -------------------------------------->

<div id="formTipsLayer" style="position: absolute; z-index: 1000; visibility: hidden; left:0; top: 0; width: 10">&nbsp;</div>

<!----------------------------------------------------->

<!-- HEADER -->

<!--#include file="_header.asp"-->

<!-- BODY ---->

<table width="100%" border="0" cellspacing="0" cellpadding="0">

   <tr>

      <td valign="top" width="1" background="images/bg_bage.gif">

      <!-- LEFT -->

      <!--#include file="_environment.asp"-->

      </td>

      <td width="1" bgcolor="#999999"><img src="images/h_trsp_dot.gif" width="1" height="1"></td>

      <td valign="top" width="100%">

      <!-- MIDDLE -->

      <table width="100%" border="0" cellspacing="0" cellpadding="0">

        <tr>

          <td width="1%" background="images/bg_action_norm.gif"><IMG height=35 src="images/spacer.gif" width=15></td>

          <td width="100%" background="images/bg_action_norm.gif"><%Call RenderActionBar(parRtag_id,parPv_id)%></td>

          <td width="1%" background="images/bg_action_norm.gif"><IMG height=1 src="images/spacer.gif" width=15></td>

        </tr>

        <tr>

          <td background="images/bg_lght_gray.gif"><IMG height="45" src="images/spacer.gif" width=1></td>

          <td background="images/bg_lght_gray.gif"><%Call RenderStatus(parRtag_id,parPv_id)%></td>

          <td background="images/bg_lght_gray.gif">&nbsp;</td>

        </tr>

        <tr>

          <td background="images/bg_lght_gray.gif">&nbsp;</td>

          <td valign="bottom" background="images/bg_lght_gray.gif">

            <table width="100" border="0" cellspacing="0" cellpadding="0">

              <tr>

                <td><IMG height=1 src="images/spacer.gif" width=50></td>

                <td>

              <!-- TABS ------------------------------------->

              <%Call Generate_Tab_Menu ( TABarray1, "Release Notes", "orange" )%>

              </td>

              </tr>

            </table>

          </td>

          <td background="images/bg_lght_gray.gif">&nbsp;</td>

        </tr>

        <tr>

          <td background="images/lbox_bg_orange.gif"><IMG height=35 src="images/spacer.gif" width=1></td>

          <td background="images/lbox_bg_orange.gif">

         <!-- TAB ACTION BUTTONS ------------------------------------->

         <%Call Action_Buttons ( "Release Notes" )%>

         </td>

          <td background="images/lbox_bg_orange.gif">&nbsp;</td>

        </tr>

        <tr>

          <td></td>

          <td valign="top">

         <!-- DETAILS ------------------------------------------------->

         <br>

         <%

         If (pkgInfoHash.Item ("dlocked") = "Y") Then

            If (InStr(pkgInfoHash.Item ("release_notes_info"),"MSG:") > 0) Then

               Select Case CStr( pkgInfoHash.Item ("release_notes_info") )

               Case enum_RELEASE_NOTES_GENERATING

                  Call DisplayInfo ( "GENERATING_RELEASE_NOTES", "400" )

               Case enum_RELEASE_NOTES_NOT_FOUND_IN_ARCHIVE

                  Call DisplayInfo ( "NOT_FOUND_IN_PKG_ARCHIVE_RELEASE_NOTES", "400" )

               Case enum_RELEASE_NOTES_FAILED

                  Call DisplayInfo ( "FAILED_GENERATING_RELEASE_NOTES", "400" )

               Case enum_RELEASE_NOTES_NO_PREVIOUS_VERSION

                  Call DisplayInfo ( "NO_PREVIOUS_VERSION_RELEASE_NOTES", "400" )

               End Select

            ElseIf IsNull(pkgInfoHash.Item ("release_notes_info")) Then

               Call DisplayInfo ( "GENERATE_RELEASE_NOTES", "400" )

            End If

         Else

            Call fillCommentsWithDifferences ( parPv_id )

         End If

         %>

         <!--#include file="_release_notes.asp"-->

         <!-- END DETAILS ------------------------------------------------->

         </td>

          <td>&nbsp;</td>

        </tr>

      </table>

      <!-- END MIDDLE -------->

      </td>

   </tr>

</table>

<!-- FOOTER -->

<!--#include file="_footer.asp"-->

</body>

</html>

<%

Call Destroy_All_Objects

%>