Subversion Repositories DevTools

Rev

Rev 6876 | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'   view_by_release.asp
'=====================================================
%>
<%
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"-->
<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login_optional.asp"-->
<!--#include file="_access_control_general.asp"-->
<%
'------------ Variable Definition -------------
Dim rsRep
Dim parKeyword
Dim parBrowse
Dim parBrowseText
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
parKeyword = Request("releasename")
parBrowse = Request("browse")
'----------------------------------------------
%>
<%
'-----------------------------------------------------------------------------------------------------------------------
'-----------------------------------------------------------------------------------------------------------------------
%>
<%
'==================== MAIN LINE ===============================
If (parKeyword = "") AND (parBrowse = "") Then 
    Call Destroy_All_Objects
    Response.Redirect ("index.asp")
End If
parBrowseText = parBrowse
If parBrowse = "*" Then 
    parBrowse = "%"
    parBrowseText = "All Releases"
End If
'==============================================================
%>
<html>
<head>
<title>Release Manager</title>
<link rel="shortcut icon" href="<%=FavIcon%>"/>
<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?ver=<%=VixVerNum%>" type="text/css">
<link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
<script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
<!-- DROPDOWN MENUS -->
<!--#include file="_jquery_includes.asp"-->
<!--#include file="_menu_def.asp"-->
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
<!-- HEADER -->
<!--#include file="_header.asp"-->
<!-- BODY ---->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td class='bg_panel'>
      <!--#include file="_front_explorer.asp"-->
    </td>
    <td rowspan="2" width="1%" valign="top"> 
      <div class='Panel PanelFrame'>
          <div class='headerPanel'>
             Search by Release.&nbsp;
            <%If parBrowse <> "" Then%>
                Index <b><%=parBrowseText%></b>
            <%Else%>
                Results for <b><%=parKeyword%></b> 
            <%End If%>
          </div>
          <div>
    <!-- RELEASE SEARCH ------------------------------------------------>
    <%
      OraDatabase.Parameters.Add "KEYWORD", Trim(parKeyword), ORAPARM_INPUT, ORATYPE_VARCHAR2
      OraDatabase.Parameters.Add "BROWSE", parBrowse, ORAPARM_INPUT, ORATYPE_VARCHAR2
      
      If parBrowse = "" Then
            Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindReleaseName.sql"), 0 )
      Else
            Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("BrowseReleaseName.sql"), 0 )
      End If
      
      OraDatabase.Parameters.Remove "KEYWORD"
      OraDatabase.Parameters.Remove "BROWSE"
    %>
    
    <table width="100%" border="0" cellspacing="1" cellpadding="5" class=stdGrey>
      <%
      If rsRep.RecordCount = 0 Then
        With Response
            .write "<tr>"
            .write "<td class='nowrap' colspan=2>Your search for <b>"& parKeyword & parBrowseText &"</b> did not match any releases.</td>"
            .write "</tr>"
        End With
      Else %>
      <thead>
        <th style="min-width:500px">Release Name</th>
        <th style="min-width:500px">Project Name</th>
      </thead>
      <%
      End If
      
      While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) %>
          <tr> 
            <td nowrap valign="top"><a href="dependencies.asp?rtag_id=<%=rsRep("rtag_id")%>" class="body_link"><%=ReleaseIcon( rsRep("official") )%>&nbsp<%=Highlight_Substring( rsRep("rtag_name"), parKeyword )%></a></td>
            <td nowrap valign="top"><a href="rtree.asp?proj_id=<%=rsRep("proj_id")%>" class="body_link"><%=rsRep("proj_name")%></a></td>
          </tr>
      <%  rsRep.MoveNext
      WEnd
      
      rsRep.Close()
      %>
    </table>
    <br>
    <!------------------------------------------------------------>                     
        </div>
      </div>
    </td>
    <td width="100%">&nbsp;</td>
  </tr>
  <tr> 
    <td class='bg_panel_btm'><img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
    <td>&nbsp;</td>
  </tr>
</table>
<!-- FOOTER -->
<!--#include file="_footer.asp"-->
</body>
</html>