WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/web/find.asp

 If (parSearchType = "")  OR  (nEnvTab = "") Then
    Call Destroy_All_Objects
    Response.Redirect ("dependencies.asp?rtag_id="& Request("rtag_id"))
 End If
 '==============================================================
+'----------------------------------------------
+'
+Sub InsertJavaScript%>
+<script type="text/javascript" charset="utf-8">
+<%If parSearchType = "2" Then%>
+    var table;
+	$(document).ready(function() {
+    /* Init DataTables */
+        // Format a search string for DataTables
+        // Convert all * into a %
+        function formatSearch(str) {
+			return str.replace(/\*/g,'%');
+        }
+        // Setup - add a text input to each cell within the header row marked with a search class
+        // Must be done  before the dataTable is created as the DOM is changed
+        $('#tfiles .search th').each( function (colIdx) {
+            var title = $(this).text();
+            if ( (title) ) {
+                var el = $('<input id=inp_' + title.toLowerCase() + ' type="search" placeholder="Search ' + title + '" />');
+                $(this).html(el);
+				el.on('keyup change', function(ev) {
+                if (ev.keyCode == 13) { //only on enter keypress (code 13)
+                    table
+                        .column(colIdx)
+                        .search(formatSearch(this.value))
+                        .draw();
+                    }
+                });
+            }
+        });
+        // Add Jason listeners
+        $("#tfiles").on('preXhr.dt', function ( e, settings, data ) {
+            showGlobalProgress();
+         });
+        $("#tfiles").on('xhr.dt', function ( e, settings, data ) {
+            hideGlobalProgress();
+         });
+        // Create the DataTable
+        $.fn.dataTable.ext.errMode = function ( settings, helpPage, message ) {
+            hideGlobalProgress();
+            console.log(message);
+        };
+        var w = window,
+            d = document,
+            e = d.documentElement,
+            g = d.getElementsByTagName('body')[0],
+            x = w.innerWidth || e.clientWidth || g.clientWidth,
+            y = w.innerHeight|| e.clientHeight|| g.clientHeight;
+		var theight = y - $('#tfiles').offset().top - 120;
+//console.log("theight", y , $('#tfiles').offset().top)
+        table = $("#tfiles").dataTable({
+            serverSide: true,
+            deferRender : true,
+            xxxprocessing: true,
+            ajax : {
+                url : "view_by_files_json.asp",
+                type : "POST",
+                data : function (o){
+                           o.filename = formatSearch("<%=parKeyword%>");
+						   o.rtag_id = "<%=parRtagId%>";
+						   o.envtab = "<%=nEnvTab%>"
+                }
+            },
+            dom: "rti",
+            scrollY: theight,
+            scrollCollapse: true,
+			paging: true,
+            scroller: {
+			    loadingIndicator: true,
+                displayBuffer: 9,
+		    },
+            order: [[ 0, "desc" ]],
+            info: true,
+            columns: [
+                { "visible": false },
+                { render :  function ( data, type, row, meta ) {
+					  var sLink = "<%=dpkg_archiveURL%>" + row[3] + "/" +  row[4] + "/" + row[2] + "/" + row[1];
+                      sLink = sLink.replace(/\\+/g,'/') ;
+                      sLink = sLink.replace(/\/+/g,'/') ;
+                      return '<img src="images/rex_images/ext_blank.gif" border="0" hspace="2" align="absmiddle"><a href="'+sLink+'" class=body_link>'+data+'</a>';
+                }},
+                { render :  function ( data, type, row, meta ) {
+                      if ( data  ) {
+                          data = data.replace(/\\+/g, '/');
+                          data = data.replace(/\/+/g,'\\') ;
+                      }
+                      return data;
+                }},null,
+                { render :  function ( data, type, row, meta ) { return '<a href="dependencies.asp?pv_id='+row[0]+'&rtag_id=<%=parRtagId%>" class=body_link>'+data+'</a>';}},
+                null
+            ],
+            columnDefs : [
+                {className: "nowrap", targets : '_all' }
+            ],
+            orderCellsTop : true,
+            initComplete : function () {
+            },
+        }).api();
+        //  Transfer the keyword to the 'file' search item
+    	$('#inp_file').val('<%=parKeyword%>');
+        table.column(1).search( formatSearch("<%=parKeyword%>") );
+	});
+<%End If%>
+</script>
+<%End Sub
+'----------------------------------------------
 %>
 <html>
 <head>
 <title><%=Title(parRtagId)%></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>
+<%bJqueryDataTables = TRUE%>
 <!--#include file="_jquery_includes.asp"-->
 <!-- TIPS -->
 <script language="JavaScript" src="images/tipster.js?ver=<%=VixVerNum%>"></script>
 <script language="JavaScript" src="images/_help_tips.js?ver=<%=VixVerNum%>"></script>
 <!-- DROPDOWN MENUS -->
 <!--#include file="_menu_def.asp"-->
 <script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
+<%Call InsertJavaScript%>
 </head>
 <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
 <!-- HEADER -->
 <!--#include file="_header.asp"-->
 <!-- BODY ---->
                      KeyWord = Replace( Trim(parKeyword), "*", "%" )
                   Else
                      KeyWord = "%"& Trim(parKeyword) &"%"
                   End If
+                  If parSearchType = "1" Then
+                     ' Package Search
                   OraDatabase.Parameters.Add "KEYWORD",    KeyWord, ORAPARM_INPUT, ORATYPE_VARCHAR2
                   OraDatabase.Parameters.Add "RTAG_ID",    parRtagId, ORAPARM_INPUT, ORATYPE_NUMBER
                   OraDatabase.Parameters.Add "SEARCH_AREA", nEnvTab, ORAPARM_INPUT, ORATYPE_NUMBER
                   OraDatabase.Parameters.Add "RECORD_SET",   NULL,    ORAPARM_OUTPUT,    ORATYPE_CURSOR
                   OraDatabase.Parameters.Add "PAGE_SIZE",    MaxRows, ORAPARM_INPUT, ORATYPE_NUMBER
-                  If parSearchType = "1" Then
-                     ' Package Search
                      OraDatabase.ExecuteSQL "BEGIN  PK_ENVIRONMENT.FIND_PACKAGE ( :KEYWORD, :RTAG_ID, :SEARCH_AREA, :RECORD_SET );  END;"
-                  ElseIf parSearchType = "2" Then
-                     ' File Search
-                     OraDatabase.ExecuteSQL "BEGIN  PK_ENVIRONMENT.FIND_FILE ( :KEYWORD, :RTAG_ID, :SEARCH_AREA, :PAGE_SIZE, :RECORD_SET );  END;"
-                  End If
                   Set rsRep = OraDatabase.Parameters("RECORD_SET").Value
                   OraDatabase.Parameters.Remove "KEYWORD"
                   OraDatabase.Parameters.Remove "RTAG_ID"
                   OraDatabase.Parameters.Remove "SEARCH_AREA"
                   OraDatabase.Parameters.Remove "PAGE_SIZE"
                   OraDatabase.Parameters.Remove "RECORD_SET"
+                  End If
                   %>
                   <table width="100%"  border="0" cellspacing="0" cellpadding="5">
                      <tr>
                         <td>
                            <%If parSearchType = "1" Then%>
                               <span class="body_sect">Find Package: <%=Trim(parKeyword)%></span>
                            <%ElseIf parSearchType = "2" Then%>
-                              <span class="body_sect">Find File: <%=Trim(parKeyword)%>.</span><span class="body_txt">Showing max. <%=MaxRows%> results.</span>
+                              <span class="body_sect">Find File: <%=Trim(parKeyword)%>.</span><span class="body_txt"></span>
                            <%End If%>
                         </td>
                      </tr>
                   <%If parSearchType = "1" Then%>
                      </table>
                      <br>
                   <%ElseIf parSearchType = "2" Then%>
                      <!-- FILE SEARCH ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
-                     <table width="100%" border="0" cellspacing="1" cellpadding="5" class='stdGrey'>
+                     <table id=tfiles width="100%" border="0" cellspacing="1" cellpadding="2" class='stdGrey'>
                          <thead>
                             <tr>
+							   <th>PvId</th>
-                               <th width="20%" nowrap>File Name</th>
+                               <th width="20%" nowrap>File Name<%=Quick_Help("FindFile")%></th>
                                <th width="20%" nowrap>Path</th>
                                <th width="20%" nowrap>Package&nbsp;Name</th>
                                <th width="20%" nowrap>Version</th>
                                <th width="20%" nowrap>CheckSum&nbsp;(CKSUM)</th>
                             </tr>
+							<tr class=search>
+								<th></th>
+								<th>File</th>
+								<th>Path</th>
+								<th>Package</th>
+								<th>Version</th>
+								<th></th>
+							</tr>
                          </thead>
-                        <%If rsRep.RecordCount = 0 Then%>
-                            <tr>
-                                <td colspan='5'>Found 0 records.</td>
-                            </tr>
-                        <%End If
-                        While ((NOT rsRep.BOF) AND (NOT rsRep.EOF))
-                           If IsNull(rsRep("file_path")) Then
-                              ' DEVI-050252 - must not call Get_Pkg_Short_Info() with a null or empty string, so check the patch_id before doing so.
-                              If IsNull(rsRep("patch_id")) OR rsRep("patch_id") = "" Then
-                                 sLink = dpkg_archiveURL & rsRep("pkg_name") &"/"& rsRep("pkg_version") &"/"& Replace( rsRep("file_name"), "\", "/" )
-                              Else
-                                 Call Get_Pkg_Short_Info(  rsRep("patch_id"), NULL, NULL, sPkgVersion, NULL, NULL, NULL )
-                                 sLink = dpkg_archiveURL & rsRep("pkg_name") &"/"& sPkgVersion &"/"& rsRep("file_name")
-                              End If
-                           Else
-                              sLink = dpkg_archiveURL & rsRep("pkg_name") &"/"& rsRep("pkg_version") &"/"& Replace( rsRep("file_path") & rsRep("file_name"), "\", "/" )
-                           End If
-                           %>
-                           <tr>
-                              <td valign="top"><a href="<%=sLink%>" class="body_link"><%=Highlight_Substring( rsRep("file_name"), Trim(parKeyword) )%></td>
-                              <td nowrap><%=rsRep("file_path")%></td>
-                              <td nowrap><%=rsRep("pkg_name")%></td>
-                              <td nowrap><a href="dependencies.asp?rtag_id=<%=parRtagId%>&pv_id=<%=rsRep("pv_id")%>" class="body_link"><%=rsRep("pkg_version")%></a></td>
-                              <td nowrap><%=rsRep("crc_cksum")%></td>
-                           </tr>
-                           <%  rsRep.MoveNext
-                        WEnd
-                        rsRep.Close()
-                        %>
                      </table>
                      <br>
                      <!-- END OF SEARCH ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                   <%End If%>
                </td>

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/web/find.asp – Rev 6876 → 7291