Subversion Repositories DevTools

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                                      view by file                         |
'|                                                   |
'=====================================================
%>
<%
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 parFPkgName, parFPkgVersion
Dim FileName
Dim sLink
'------------ Constants Declaration -----------
Const MaxRows = 100
'------------ Variable Init -------------------
parKeyword = Request("filename")
parFPkgName = RequestDefault("fpkgname", "*")
parFPkgVersion = RequestDefault("fpkgversion", "*")

'----------------------------------------------
%>
<%
'-----------------------------------------------------------------------------------------------------------------------
'-----------------------------------------------------------------------------------------------------------------------
%>
<%
'==================== MAIN LINE ===============================
If (parKeyword = "") Then 
    Call Destroy_All_Objects
    Response.Redirect ("index.asp")
End If
'==============================================================
Sub ShowMainPanel
%>
        <!-- PACKAGE SEARCH ------------------------------------------------>
        <%
        ' Format keyword for search
        If InStr( parKeyword, "*" ) > 0 Then
                ' Use wild cards
                FileName = Replace( parKeyword, "*", "%")
        Else
                ' Wildcard is not used, hence append card to the end for better results
                FileName = parKeyword & "%"
        End If


        OraDatabase.Parameters.Add "FILE_NAME",         FileName, ORAPARM_INPUT, ORATYPE_VARCHAR2
        OraDatabase.Parameters.Add "PKG_NAME",          Replace( parFPkgName, "*", "%" ), ORAPARM_INPUT, ORATYPE_VARCHAR2
        OraDatabase.Parameters.Add "PKG_VERSION",       Replace( parFPkgVersion, "*", "%" ), ORAPARM_INPUT, ORATYPE_VARCHAR2
        OraDatabase.Parameters.Add "PAGE_SIZE",         MaxRows, ORAPARM_INPUT, ORATYPE_NUMBER

        Set rsRep = OraDatabase.DbCreateDynaset( GetQuery("FindFiles.sql"), 0 )

        OraDatabase.Parameters.Remove "FILE_NAME"
        OraDatabase.Parameters.Remove "PKG_NAME"
        OraDatabase.Parameters.Remove "PKG_VERSION"
        OraDatabase.Parameters.Remove "PAGE_SIZE"

        %>
        <table width="100%"  border="0" cellspacing="0" cellpadding="5">
          <tr>
                <td class="body_sect">Files</td>
          </tr>
          <tr>
                <td nowrap class="body_txt">
                        Results for <b><%=parKeyword%></b>. Showing max. <%=MaxRows%> results.
                </td>
          </tr>
        </table>
        <table width="100%" border="0" cellspacing="1" cellpadding="5" class=stdGrey>
        <form name="file_search" method="get" action="<%=ScriptName%>">
          <input type="hidden" name="filename" value="<%=parKeyword%>">
          <input type="hidden" name="listby" value="<%=parListBy%>">
          <thead>
                <tr>
                <th width="20%" nowrap>File</th>
                <th width="40%" nowrap>Path</th>
                <th width="20%" nowrap>Package Name</th>
                <th width="20%" nowrap>Version</th>
                <th width="1%" nowrap>CheckSum&nbsp;(CKSUM)</th>
          </tr>
          <tr>
                <th nowrap></th>
                <th nowrap></th>
                <th nowrap><input name="fpkgname" type="text" class="form_item" size="10" value="<%=parFPkgName%>"></th>
                <th nowrap><input name="fpkgversion" type="text" class="form_item" size="10" value="<%=parFPkgVersion%>"></th>
                <th nowrap></th>
          </tr>
         </thead>
          <%
          If rsRep.RecordCount = 0 Then
                With Response
                        .write "<tr>"
                        .write "<td colspan='5'>Your search <b>"& parKeyword &"</b> did not match any file names.</td>"
                        .write "</tr>"
                End With
          End If
          
          Do While ((NOT rsRep.BOF) AND (NOT rsRep.EOF)) 
                sLink = dpkg_archiveURL & rsRep("pkg_name") &"/"& rsRep("pkg_version") &"/"& Replace( rsRep("file_path") & rsRep("file_name"), "\", "/" )
          %>
                  <tr> 
                        <td nowrap><a href="<%=sLink%>" class="body_link"><img src='images/rex_images/ext_blank.gif' border='0' hspace='2' align='absmiddle'><%=Highlight_Substring( rsRep("file_name"), parKeyword )%></a></td>
                        <td nowrap><%=rsRep("file_path")%></td>
                        <td nowrap><%=rsRep("pkg_name")%></td>
                        <td nowrap><a href="dependencies.asp?pv_id=<%=rsRep("pv_id")%>" class="body_link"><%=rsRep("pkg_version")%></a></td>
                        <td nowrap><%=rsRep("crc_cksum")%></td>
                  </tr>
          <%  
                  rsRep.MoveNext
          Loop
          
          rsRep.Close()
          %>
          <tr> 
                <td colspan="5" background="images/bg_rep_line.gif"><img src="images/spacer.gif" width="1" height="1"></td>
          </tr>
          
          </form>
        </table>
<%
End Sub
%>
<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>
        <!--#include file="_jquery_includes.asp"-->
        <!-- DROPDOWN MENUS -->
        <!--#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 width="20%" class='bg_panel'>
                                <!--#include file="_front_explorer.asp"-->
                                </td>
                                <td rowspan="2" valign="top"> 
                                        <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                <tr> 
                                                        <td >
                                                                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                                                        <tr> 
                                                                                <td width="1%"></td>
                                                                                <td width="100%" align="right"><img src="images/h_trsp_dot.gif" width="1" height="20"></td>
                                                                                <td width="1%"></td>
                                                                        </tr>
                                                                        <tr> 
                                                                                <td bgcolor="#FFFFFF"><img src="images/h_trsp_dot.gif" width="10" height="500"></td>
                                                                                <td bgcolor="#FFFFFF" valign="top"> 
                                                                                        <%Call ShowMainPanel%>
                                                                                        <br>
                                                                                        <!------------------------------------------------------------>                 
                                                                                </td>
                                                                                <td background="images/lbox_bgside_white.gif">&nbsp;</td>
                                                                        </tr>
                                                                </table>
                                                        </td>
                                                </tr>
                                  </table>
                                </td>
                                <td width="11%">&nbsp;</td>
                        </tr>
                        <tr> 
                                <td class='bg_panel_btm' height="350">
                                        <img src="images/img_gear.gif" width="107" height="107" vspace="20" hspace="30"></td>
                                <td></td>
                        </tr>
                </table>
                <!-- FOOTER -->
                <!--#include file="_footer.asp"-->
        </body>
</html>