WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/_wform_new_patch.asp

 <%@LANGUAGE="VBSCRIPT"%>
 <%
 '=====================================================
 '
 '   _wform_new_patch.asp
 '
 '   This page needs some work
 '   It does some nasty stuff
 '   It accesses packages in dpkg_archive by mapping a drive letter
 '
 '   Ideally it should not access dpkg_archive at all
 '   If it does it should use MSXML2 and access it via http
 '   In this manner it won't need a login password
 '
 '=====================================================
 %>
 <%
 Option explicit
 Response.Expires = 0   ' always load the page, dont store
 'To enable the script timeout to 10 mins
 Server.ScriptTimeout=600
 %>
 <%
 '=====================================================
 '               New Patch
 '=====================================================
 %>
 <!--#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="common/_popup_window_common.asp"-->
 <%
 '------------ ACCESS CONTROL ------------------
 %>
 <!--#include file="_access_control_login.asp"-->
 <!--#include file="_access_control_general.asp"-->
 <!--#include file="_access_control_project.asp"-->
 <%
 '------------ Variable Definition -------------
 Dim parPv_id
 Dim pkg_name
 Dim view_id
 Dim patch_version
 Dim rsQry
 Dim patch_number
 Dim pos,pos2
 Dim newPatch_version
 Dim fs, f, i
 Dim objNetwork, strDriveLetter, strRemotePath, strProfile, CheckDrive
 Dim pkgCredentails, strUser, strPassword
 Dim skip, AlreadyConnected
 Dim newPatchId
 '------------ Constants Declaration -----------
 '------------ Variable Init -------------------
 parPv_id = QStrPar("pv_id")
 strDriveLetter = "R:"
 pkgCredentails = split(PKGARCHIVE_CREDENTIALS,":")
 strUser = pkgCredentails(0)
 strPassword = pkgCredentails(1)
 strRemotePath = "\\" & Get_Archive_Server() & "\dpkg_archive"
 strProfile = "False" ' means do not store in profile leave as false.
 AlreadyConnected = False
 '----------------------------------------------
 %>
 <%
 '--------------------------------------------------------------------------------------------------
 Function SearchAndReplace(s, Str1, Str2)
    Dim pos
    s = s & "" 'Fix Null
    pos = InStr(s, Str1)
    If pos > 0 Then
       s = Mid(s, 1, pos - 1) & Str2 & Mid(s, pos + Len(Str1))
    End If
    SearchAndReplace = s
 End Function
 '--------------------------------------------------------------------------------------------------
 Sub Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
    On Error Resume Next
    OraDatabase.Parameters.Add "PATCH_VERSION",  SSpatchversion,          ORAPARM_INPUT,  ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "PV_ID",          NNpv_id,                 ORAPARM_INPUT,  ORATYPE_NUMBER
    OraDatabase.Parameters.Add "PATCH_ID_LIST",  patchId,                 ORAPARM_INPUT,  ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "USER_ID",        objAccessControl.UserId, ORAPARM_INPUT,  ORATYPE_NUMBER
    OraDatabase.Parameters.Add "RTAG_ID",        Request("rtag_id"),      ORAPARM_INPUT,  ORATYPE_NUMBER
    OraDatabase.Parameters.Add "VIEW_ID",        view_id,                 ORAPARM_INPUT,  ORATYPE_NUMBER
    OraDatabase.Parameters.Add "RET_PATCH_ID",   0,                       ORAPARM_OUTPUT, ORATYPE_NUMBER
    objEH.TryORA ( OraSession )
    OraDatabase.ExecuteSQL _
    "BEGIN "&_
    " PK_PACKAGE.NEW_PATCH( :PATCH_VERSION, :PV_ID, :PATCH_ID_LIST, :USER_ID, :RET_PATCH_ID ); "&_
    "END; "
    '" PK_ENVIRONMENT.ADD_PACKAGE ( :RET_PATCH_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); "&_
    objEH.CatchORA ( OraSession )
    newPatchId = OraDatabase.Parameters("RET_PATCH_ID").Value
    OraDatabase.Parameters.Remove "PATCH_VERSION"
    OraDatabase.Parameters.Remove "PV_ID"
    OraDatabase.Parameters.Remove "PATCH_ID_LIST"
    OraDatabase.Parameters.Remove "USER_ID"
    OraDatabase.Parameters.Remove "RTAG_ID"
    OraDatabase.Parameters.Remove "VIEW_ID"
    OraDatabase.Parameters.Remove "RET_PATCH_ID"
 End Sub
 '--------------------------------------------------------------------------------------------------
 Sub AutoWrite_Reason (patchId, newPatchId)
    On Error Resume Next
    Dim rsTemp, filename, textdata, pos1, pos2, rsQry
    Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS PV, PACKAGES PKG WHERE PKG.PKG_ID = PV.PKG_ID AND PV.PV_ID ="&patchId, ORADYN_DEFAULT)
    Set fs=Server.CreateObject("Scripting.FileSystemObject")
    'Rupesh Testing Start
    Set objNetwork = CreateObject("WScript.Network")
    Set CheckDrive = objNetwork.EnumNetworkDrives()
    For i = 0 To CheckDrive.Count - 1 Step 2
       If CheckDrive.Item(i) = strDriveLetter Then AlreadyConnected = True
    Next
    If AlreadyConnected = True then
       objNetwork.RemoveNetworkDrive strDriveLetter
    End If
    objNetwork.MapNetworkDrive strDriveLetter, strRemotePath, strProfile, strUser, strPassword
    filename = Mid(rsTemp("v_ext"), 2, len(rsTemp("v_ext"))) + "."
    filename = filename + rsTemp("pkg_name") + "."
    filename = filename + Mid(rsTemp("pkg_version"), 1, len(rsTemp("pkg_version")) - 4)
    filename = filename + ".sh"
    Set f=fs.OpenTextFile(""&strDriveLetter&"\"&rsTemp("pkg_name")&"\"&rsTemp("pkg_version")&"\scripts\"&filename&"", 1)
    textdata = f.ReadAll
    pos1 = Instr(textdata, "PATCH_ENV1=")
    pos2 = Instr(textdata, "PATCH_DATE")
    rsTemp.Close()
    Set rsTemp = nothing
    Set rsTemp = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGE_VERSIONS WHERE PV_ID ="&newPatchId, ORADYN_DEFAULT )
    rsTemp.Edit
    rsTemp.Fields("COMMENTS").Value = "Schema Patch - "&Mid(textdata, pos1+11, pos2-(pos1+11))
    rsTemp.Fields("PV_OVERVIEW").Value = rsTemp.Fields("PV_DESCRIPTION").Value
    rsTemp.Fields("IS_BUILD_ENV_REQUIRED").Value = "N"
    Set rsQry = OraDatabase.DbCreateDynaset("SELECT * FROM PACKAGES WHERE PKG_ID ="&rsTemp("pkg_id"), ORADYN_DEFAULT )
    rsTemp.Fields("PKG_LABEL").Value = UCase( Replace(rsTemp("V_EXT"), ".", "") ) &"_"& UCase(rsQry("pkg_name")) &"_R_"& Format_Version( rsTemp("pkg_version"), rsTemp("V_EXT") )
    rsTemp.Update
    f.Close()
    objNetwork.RemoveNetworkDrive strDriveLetter
    Set f = Nothing
    Set fs = Nothing
    Set objNetwork= Nothing
    rsTemp.Close()
    Set rsTemp = Nothing
    rsQry.Close()
    Set rsQry = Nothing
 End Sub
 '--------------------------------------------------------------------------------------------------
 Sub Add_Patch ( NNpv_id, SSpatchversion )
    On Error Resume Next
    OraDatabase.Parameters.Add "PATCH_VERSION", SSpatchversion,          ORAPARM_INPUT, ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "PV_ID",         NNpv_id,                 ORAPARM_INPUT, ORATYPE_NUMBER
    OraDatabase.Parameters.Add "PATCH_ID_LIST", Request("patch_id_list"),ORAPARM_INPUT, ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "USER_ID",       objAccessControl.UserId, ORAPARM_INPUT, ORATYPE_NUMBER
    OraDatabase.Parameters.Add "RTAG_ID",       Request("rtag_id"),      ORAPARM_INPUT, ORATYPE_NUMBER
    OraDatabase.Parameters.Add "VIEW_ID",       view_id,                 ORAPARM_INPUT, ORATYPE_NUMBER
    OraDatabase.Parameters.Add "RET_PATCH_ID",  0,                       ORAPARM_OUTPUT,ORATYPE_NUMBER
    objEH.TryORA ( OraSession )
    OraDatabase.ExecuteSQL _
    "BEGIN "&_
    " PK_PACKAGE.NEW_PATCH( :PATCH_VERSION, :PV_ID, :PATCH_ID_LIST, :USER_ID, :RET_PATCH_ID ); "&_
    "END; "
    '" PK_ENVIRONMENT.ADD_PACKAGE ( :RET_PATCH_ID, :VIEW_ID, :RTAG_ID, :USER_ID ); "&_
    objEH.CatchORA ( OraSession )
    OraDatabase.Parameters.Remove "PATCH_VERSION"
    OraDatabase.Parameters.Remove "PV_ID"
    OraDatabase.Parameters.Remove "PATCH_ID_LIST"
    OraDatabase.Parameters.Remove "USER_ID"
    OraDatabase.Parameters.Remove "RTAG_ID"
    OraDatabase.Parameters.Remove "VIEW_ID"
    OraDatabase.Parameters.Remove "RET_PATCH_ID"
 End Sub
 '-----------------------------------------------------------------------------------------
 Sub Auto_Patch (NNpv_id, SSpatchversions)
    On Error Resume Next
    Dim posComma, posUnderscore, patchId, sspatchversion, value
    If IsNull(SSpatchversions) OR SSpatchversions = "" Then
       Call RaiseMsg(enum_WMSG_ERROR, "Must select at least one Auto Package to perform AutoFill")
    Else
       value = SSpatchversions
       posComma = InStr(SSpatchversions, ",")
       While posComma <> 0
          value = Mid(SSpatchversions, 1, posComma-1)
          posUnderscore = Instr(value, "_")
          If (posUnderscore > 1) Then
             patchId = Mid(value, 1, posUnderscore - 1)
             sspatchversion = Mid(value, posUnderscore + 1, posComma-1)
             Call Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
             Call AutoWrite_Reason (patchId, newPatchId)
             Call Insert_NOT_DONE_Unit_Test (newPatchId)
          End If
          SSpatchversions = Mid(SSpatchversions, posComma + 1, Len(SSpatchversions))
          posComma = InStr(SSpatchversions, ",")
       Wend
       If posComma = 0 Then
          posUnderscore = Instr(SSpatchversions, "_")
          If posUnderscore > 1 Then
             patchId = Mid(SSpatchversions, 1, posUnderscore - 1)
             sspatchversion = Mid(SSpatchversions, posUnderscore + 1)
             Call Auto_Add_Patch (NNpv_id, patchId, sspatchversion, newPatchId)
             Call AutoWrite_Reason(patchId, newPatchId)
             Call Insert_NOT_DONE_Unit_Test (newPatchId)
          End If
       End if
    End if
 End Sub
 '-----------------------------------------------------------------------------------------
 Sub Get_Parent_Details ( NNpv_id, nRtagId, outPkg_name, outDefPatchVersion, outViewId )
    Dim rsTemp, Query_String, tempVersion, V_EXT
    OraDatabase.Parameters.Add "PV_ID",   NNpv_id, ORAPARM_INPUT, ORATYPE_NUMBER
    OraDatabase.Parameters.Add "RTAG_ID", nRtagId, ORAPARM_INPUT, ORATYPE_NUMBER
    Query_String = _
    "  SELECT pkg.pkg_name, pv.pkg_version, pv.V_EXT, rc.BASE_VIEW_ID"&_
    " FROM package_versions pv, "&_
    "      packages pkg,"&_
    "     RELEASE_CONTENT rc"&_
    " WHERE pv.pkg_id = pkg.pkg_id "&_
    "   AND pv.pv_id = :PV_ID"&_
    "   AND rc.RTAG_ID = :RTAG_ID"&_
    "   AND rc.PV_ID = pv.PV_ID"
    Set rsTemp = OraDatabase.CreateDynaset( Query_String, cint(0))
    OraDatabase.Parameters.Remove "PV_ID"
    OraDatabase.Parameters.Remove "RTAG_ID"
    'update fields
    If ((NOT rsTemp.BOF) AND (NOT rsTemp.EOF)) Then
       outPkg_name = rsTemp("pkg_name")
       tempVersion = rsTemp("pkg_version")
       outViewId = rsTemp("base_view_id")
       V_EXT = rsTemp("V_EXT")
    End If
    rsTemp.Close()
    Set rsTemp = nothing
    If IsNull(V_EXT) Then V_EXT = ""
    outDefPatchVersion = Replace( tempVersion, V_EXT, "" ) &".pXXX"& V_EXT
 End Sub
 '------------------------------------------------------------------------------------------------
 Sub Insert_NOT_DONE_Unit_Test (nPv_id)
    ' IN PARAMETERS
    OraDatabase.Parameters.Add "PV_ID",                   nPv_id,                  ORAPARM_INPUT,    ORATYPE_NUMBER
    OraDatabase.Parameters.Add "TEST_TYPE_ID",            enumTEST_TYPE_NOT_DONE,  ORAPARM_INPUT,    ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "TEST_SUMMARY",            NULL,                    ORAPARM_INPUT,    ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "NUMOF_TEST",              NULL,                    ORAPARM_INPUT,    ORATYPE_CHAR
    OraDatabase.Parameters.Add "DPKG_PATH",               NULL,                    ORAPARM_INPUT,    ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "RESULTS",                 NULL,                    ORAPARM_INPUT,    ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "COMPLETION_DATE",         EuroDate ( Date ),       ORAPARM_INPUT,    ORATYPE_VARCHAR2
    OraDatabase.Parameters.Add "COMPLETED_BY",            objAccessControl.UserId, ORAPARM_INPUT,    ORATYPE_NUMBER
    OraDatabase.Parameters.Add "enumTEST_TYPE_AUTOMATIC", NULL,                    ORAPARM_INPUT,    ORATYPE_NUMBER
    OraDatabase.Parameters.Add "enumTEST_TYPE_NOT_DONE",  NULL,                    ORAPARM_INPUT,    ORATYPE_NUMBER
    ' OUT PARAMETERS
    OraDatabase.Parameters.Add "FILENAME", NULL, ORAPARM_OUTPUT, ORATYPE_VARCHAR2
    objEH.TryORA ( OraSession )
    On Error Resume Next
    OraDatabase.ExecuteSQL _
    "BEGIN  New_Unit_Test  ( :PV_ID,"&_
    "                        :TEST_TYPE_ID,"&_
    "                        :TEST_SUMMARY,"&_
    "                        :NUMOF_TEST,"&_
    "                        :DPKG_PATH,"&_
    "                        :RESULTS,"&_
    "                        :COMPLETION_DATE,"&_
    "                        :COMPLETED_BY,"&_
    "                        :enumTEST_TYPE_AUTOMATIC, "&_
    "                        :enumTEST_TYPE_NOT_DONE, "&_
    "                        :FILENAME "&_
    "                    );  END;"
    objEH.CatchORA ( OraSession )
    OraDatabase.Parameters.Remove "PV_ID"
    OraDatabase.Parameters.Remove "TEST_TYPE_ID"
    OraDatabase.Parameters.Remove "TEST_SUMMARY"
    OraDatabase.Parameters.Remove "NUMOF_TEST"
    OraDatabase.Parameters.Remove "DPKG_PATH"
    OraDatabase.Parameters.Remove "RESULTS"
    OraDatabase.Parameters.Remove "COMPLETION_DATE"
    OraDatabase.Parameters.Remove "COMPLETED_BY"
    OraDatabase.Parameters.Remove "enumTEST_TYPE_AUTOMATIC"
    OraDatabase.Parameters.Remove "enumTEST_TYPE_NOT_DONE"
    OraDatabase.Parameters.Remove "FILENAME"
 End Sub
 '------------------------------------------------------------------------------------------------
 %>
 <%
 'Process submition
 Call Get_Parent_Details ( Request("pv_id"),  Request("rtag_id"), pkg_name, patch_version, view_id )
 If CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then
    If Request("btn") = "AutoFill" Then
       Call Auto_Patch (parPv_id, Request("auto_patch_id_list") )
    Else
       Call Add_Patch ( parPv_id, Request("FRversion") )
    End If
    If objEH.Finally Then
       Call OpenInParentWindow ( "patches.asp?pv_id="& parPv_id &"&rtag_id="& parRtag_id )
       Call CloseWindow
    End If
 End If
 %>
 <html>
 <head>
 <script language="javascript">
 function checkAllManual()
 {
   var args = arguments;
   start_point:
   for (var i=0;i<document.forms[0].elements.length;i++)
   {
      found = false;
      var e=document.forms[0].elements[i];
      if ((e.name != 'checkallmanual') && (e.type=='checkbox'))
      {
         for (var j = 0; j < args.length; j++)
            if (args[j] == e.name)
              continue start_point;
        e.checked=document.forms[0].checkallmanual.checked;
     }
   }
 }
 function checkAllAuto()
 {
   var args = arguments;
   start_point:
   for (var i=0;i<document.forms[0].elements.length;i++)
   {
      found = false;
      var e=document.forms[0].elements[i];
      if ((e.name != 'checkallauto') && (e.type=='checkbox'))
      {
         for (var j = 0; j < args.length; j++)
            if (args[j] == e.name)
              continue start_point;
        e.checked=document.forms[0].checkallauto.checked;
     }
   }
 }
 </script>
 <title>Release Manager</title>
-<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
+<link rel="shortcut icon" href="<%=FavIcon%>"/>
-<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
+<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
-<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
+<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
-<link rel="stylesheet" href="images/navigation.css" type="text/css">
+<link rel="stylesheet" href="images/release_manager_style.css" type="text/css">
-<script language="JavaScript" src="images/common.js"></script>
+<link rel="stylesheet" href="images/navigation.css" type="text/css">
-</head>
+<script language="JavaScript" src="images/common.js"></script>
-<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();document.ptch.FRversion.focus();">
+</head>
-<form name="ptch" method="post" action="<%=scriptName%>" onSubmit="MM_validateForm('FRversion','Patch Version','RisPatchVersionStr');return document.MM_returnValue;">
+<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" onload="self.focus();document.ptch.FRversion.focus();">
-   <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
+<form name="ptch" method="post" action="<%=scriptName%>" onSubmit="MM_validateForm('FRversion','Patch Version','RisPatchVersionStr');return document.MM_returnValue;">
-      <%
+   <table width="100%" border="0" cellspacing="0" cellpadding="2" height="100%">
-      OraDatabase.Parameters.Add "PV_ID",    parPv_id, ORAPARM_INPUT, ORATYPE_NUMBER
+      <%
-      OraDatabase.Parameters.Add "RTAG_ID", parRtag_id, ORAPARM_INPUT, ORATYPE_NUMBER
+      OraDatabase.Parameters.Add "PV_ID",    parPv_id, ORAPARM_INPUT, ORATYPE_NUMBER
-      Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPatches.sql"), cint(0))
+      OraDatabase.Parameters.Add "RTAG_ID", parRtag_id, ORAPARM_INPUT, ORATYPE_NUMBER
-      %>
+      Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPatches.sql"), cint(0))
+      %>
-      <tr>
-         <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="21" height="23" hspace="5" border="0"></td>
+      <tr>
-         <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;New Patch</td>
+         <td background="images/lbox_bg_orange.gif" width="1%" height="1%"><img src="images/i_new_pkg_off.gif" width="21" height="23" hspace="5" border="0"></td>
-         <td background="images/lbox_bg_blue.gif" align="right" width="50%">
+         <td background="images/lbox_bg_blue.gif" nowrap width="50%" class="wform_ttl">&nbsp;New Patch</td>
-            <%If rsQry.RecordCount > 0 Then%>
+         <td background="images/lbox_bg_blue.gif" align="right" width="50%">
-               <input type="submit" name="btn" value="AutoFill" class="form_btn_comp">
+            <%If rsQry.RecordCount > 0 Then%>
-            <%End If%>
+               <input type="submit" name="btn" value="AutoFill" class="form_btn_comp">
-            <input type="submit" name="btn" value="Submit" class="form_btn_comp">
+            <%End If%>
-            <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
+            <input type="submit" name="btn" value="Submit" class="form_btn_comp">
-         </td>
+            <input type="reset" name="btn" value="Cancel" class="form_btn_comp" onclick="self.close()">
-         <td background="images/lbox_bg_blue.gif" align="right" width="1%" nowrap>
+         </td>
-            <img src="images/h_trsp_dot.gif" width="5" height="22">
+         <td background="images/lbox_bg_blue.gif" align="right" width="1%" nowrap>
-         </td>
+            <img src="images/h_trsp_dot.gif" width="5" height="22">
-      </tr>
+         </td>
-      <tr>
+      </tr>
-         <td height="100%" width="1%">&nbsp;</td>
+      <tr>
-         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
+         <td height="100%" width="1%">&nbsp;</td>
-            <table width="100%" border="0" cellspacing="1" cellpadding="3">
+         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/bg_form_lightgray.gif">
-               <tr>
+            <table width="100%" border="0" cellspacing="1" cellpadding="3">
-                  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Package</td>
+               <tr>
-                  <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_txt" colspan="4"><%=pkg_name%></td>
+                  <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Package</td>
-               </tr>
+                  <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_txt" colspan="4"><%=pkg_name%></td>
-               <tr>
+               </tr>
-                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Patch Version</td>
+               <tr>
-                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_txt" colspan="4">
+                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field" colspan="2">Patch Version</td>
-                  <input name="FRversion" type="text" class="form_item"  size="30" maxlength="50" value="<%=patch_version%>">
+                  <td nowrap background="images/bg_form_lightbluedark.gif" class="form_txt" colspan="4">
-                  </td>
+                  <input name="FRversion" type="text" class="form_item"  size="30" maxlength="50" value="<%=patch_version%>">
-               </tr>
+                  </td>
-               <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
+               </tr>
-               <%If NOT objEH.Finally Then%>
+               <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-                  <tr>
+               <%If NOT objEH.Finally Then%>
-                     <td class="form_iname" colspan="2">&nbsp;</td>
+                  <tr>
-                     <td>
+                     <td class="form_iname" colspan="2">&nbsp;</td>
-                        <%objEH.DisplayMessage()%>
+                     <td>
-                     </td>
+                        <%objEH.DisplayMessage()%>
-                  </tr>
+                     </td>
-               <%End If%>
+                  </tr>
-               <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
+               <%End If%>
-               <!-- INCLUDE DEPENDENCY PATCHES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
+               <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-               <%If rsQry.RecordCount > 0 Then%>
+               <!-- INCLUDE DEPENDENCY PATCHES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
-                  <tr>
+               <%If rsQry.RecordCount > 0 Then%>
-                     <td nowrap class="body_colb" colspan="6"><br><br>Include Dependency Patches</td>
+                  <tr>
-                  </tr>
+                     <td nowrap class="body_colb" colspan="6"><br><br>Include Dependency Patches</td>
-                  <tr>
+                  </tr>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Manual</td>
+                  <tr>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Manual</td>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Auto</td>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Auto</td>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
-                  </tr>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
-                  <tr>
+                  </tr>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallmanual"   value="Check All"
+                  <tr>
-                        onClick="checkAllManual('auto_patch_id_list', 'checkallauto');">
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallmanual"   value="Check All"
-                     </td>
+                        onClick="checkAllManual('auto_patch_id_list', 'checkallauto');">
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
+                     </td>
                      <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallauto"   value="Check All"
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
-                        onClick="checkAllAuto('patch_id_list', 'checkallmanual');">
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"><INPUT type=checkbox name="checkallauto"   value="Check All"
-                     </td>
+                        onClick="checkAllAuto('patch_id_list', 'checkallmanual');">
-                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
+                     </td>
                      <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
-                  </tr>
+                     <td nowrap background="images/bg_form_lightbluedark.gif" class="form_field"></td>
-               <%End If%>
+                  </tr>
-               <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
+               <%End If%>
+               <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
-                  newPatch_version = patch_version
-                  pos  = InStr(rsQry("pkg_version"), "p")
+                  newPatch_version = patch_version
-                  pos2 = InStrRev(rsQry("pkg_version"), ".")
+                  pos  = InStr(rsQry("pkg_version"), "p")
+                  pos2 = InStrRev(rsQry("pkg_version"), ".")
-                  patch_number = Mid(rsQry("pkg_version"), pos+1, pos2-pos-1)
+                  patch_number = Mid(rsQry("pkg_version"), pos+1, pos2-pos-1)
-                  newPatch_version = SearchAndReplace(newPatch_version, "XXX", patch_number)
-                  %>
+                  newPatch_version = SearchAndReplace(newPatch_version, "XXX", patch_number)
-                  <tr>
+                  %>
-                     <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("patch_id")%>"></td>
+                  <tr>
-                     <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
+                     <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("patch_id")%>"></td>
-                     <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
+                     <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
-                     <td><input type="checkbox" name="auto_patch_id_list" value="<%=rsQry("patch_id")%>_<%=newPatch_version%>"></td>
+                     <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
-                     <td nowrap class="form_txt"><font color="#808080"><b><%=pkg_name%></b></font></td>
+                     <td><input type="checkbox" name="auto_patch_id_list" value="<%=rsQry("patch_id")%>_<%=newPatch_version%>"></td>
-                     <td nowrap class="form_txt"><font color="#808080"><b><%=newPatch_version%></b></font></td>
+                     <td nowrap class="form_txt"><font color="#808080"><b><%=pkg_name%></b></font></td>
-                  </tr>
+                     <td nowrap class="form_txt"><font color="#808080"><b><%=newPatch_version%></b></font></td>
-                  <%
+                  </tr>
-                  rsQry.MoveNext
+                  <%
-               WEnd
+                  rsQry.MoveNext
+               WEnd
-               rsQry.Close
-               Set rsQry = nothing
+               rsQry.Close
-               %>
+               Set rsQry = nothing
+               %>
-               <!-- INCLUDE PACKAGES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
-               <%
+               <!-- INCLUDE PACKAGES +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++  -->
-               Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPackages.sql"), cint(0))
+               <%
-               %>
+               Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("UnusedPackages.sql"), cint(0))
-               <%If rsQry.RecordCount > 0 Then%>
+               %>
-                  <tr>
+               <%If rsQry.RecordCount > 0 Then%>
-                     <td nowrap class="body_colb" colspan="3"><br><br>Include Latest Packages</td>
+                  <tr>
-                  </tr>
+                     <td nowrap class="body_colb" colspan="3"><br><br>Include Latest Packages</td>
-                  <tr>
+                  </tr>
-                     <td width="1%" background="images/bg_form_lightbluedark.gif">&nbsp;</td>
+                  <tr>
-                     <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
+                     <td width="1%" background="images/bg_form_lightbluedark.gif">&nbsp;</td>
-                     <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
+                     <td width="1%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Package</td>
-                  </tr>
+                     <td width="100%" nowrap background="images/bg_form_lightbluedark.gif" class="form_field">Patch Version</td>
-               <%End If%>
+                  </tr>
-               <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
+               <%End If%>
-                  <tr>
+               <%While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))%>
-                     <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("latest_pv_id")%>"></td>
+                  <tr>
-                     <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
+                     <td><input type="checkbox" name="patch_id_list" value="<%=rsQry("latest_pv_id")%>"></td>
-                     <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
+                     <td nowrap class="form_txt"><%=rsQry("pkg_name")%></td>
-                  </tr>
+                     <td nowrap class="form_txt"><%=rsQry("pkg_version")%></td>
-                  <%rsQry.MoveNext
+                  </tr>
-               WEnd
+                  <%rsQry.MoveNext
+               WEnd
-               rsQry.Close
-               Set rsQry = nothing
+               rsQry.Close
-               %>
+               Set rsQry = nothing
-               <%
+               %>
-               OraDatabase.Parameters.Remove "PV_ID"
+               <%
-               OraDatabase.Parameters.Remove "RTAG_ID"
+               OraDatabase.Parameters.Remove "PV_ID"
-               %>
+               OraDatabase.Parameters.Remove "RTAG_ID"
-            </table>
+               %>
-         </td>
+            </table>
-      </tr>
+         </td>
-      <tr>
+      </tr>
-         <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
+      <tr>
-         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
+         <td height="1%" width="1%"><img src="images/h_trsp_dot.gif" width="5" height="5"></td>
-      </tr>
+         <td valign="top" nowrap colspan="3" class="wform_ttl" background="images/lbox_bg_blue.gif"></td>
-   </table>
+      </tr>
-   <input type="hidden" name="pv_id" value="<%=parPv_id%>">
+   </table>
-   <input type="hidden" name="rtag_id" value="<%=parRtag_id%>">
+   <input type="hidden" name="pv_id" value="<%=parPv_id%>">
-   <input type="hidden" name="action" value="true">
+   <input type="hidden" name="rtag_id" value="<%=parRtag_id%>">
-</form>
+   <input type="hidden" name="action" value="true">
-</body>
+</form>
-</html>
+</body>
+</html>
-<!-- DESTRUCTOR ------->
-<!--#include file="common/destructor.asp"-->
+<!-- DESTRUCTOR ------->
+<!--#include file="common/destructor.asp"-->

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/_wform_new_patch.asp @ 5369 – Rev 5268 → 5357