Subversion Repositories DevTools

Rev

Rev 6951 | Rev 6953 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6951 Rev 6952
Line 48... Line 48...
48 
'----------------------------------------------
 48 
'----------------------------------------------
49 
Sub InsertJavaScript %>
 49 
Sub InsertJavaScript %>
50 
      <script language="JavaScript" type="text/JavaScript">
 50 
      <script language="JavaScript" type="text/JavaScript">
51 
      $(document).ready(function() {
 51 
      $(document).ready(function() {
52 
 
 52 
 
53 
        // Remove the loading image
 - 
 
54 
        $('#loading').remove();
 - 
 
55 
 
 - 
 
56 
        // Hide the row togglers for rows that do not have any children
 - 
 
57 
        $('.togglerows').each(function(idx, el){
 - 
 
58 
            var v = $(this).closest("tr");
 - 
 
59 
            var pvid = v.data('pvid');
 - 
 
60 
            if ($('.erow_' + pvid).length == 0 ) {
 - 
 
61 
                $(el).css('visibility', 'hidden');
 - 
 
62 
            }
 - 
 
63 
        });
 - 
 
64 
 
 - 
 
65 
        // Attach a function to toggle multiple displays
 - 
 
66 
        $('.togglerows').click(function(){
 - 
 
67 
            var v = $(this).closest("tr");
 - 
 
68 
            var pvid = v.data('pvid');
 - 
 
69 
            $('.erow_' + pvid).toggleClass('display-none');
 - 
 
70 
            v.find('img.togglerows').toggle();
 - 
 
71 
        });
 - 
 
72 
 
 - 
 
73 
        // Generate Row Data from JavaScript data
 53 
        // Generate Row Data from JavaScript data
74 
        function getPkgName ( row, type, set, meta ) {
 54 
        function getPkgName ( row, type, set, meta ) {
75 
          var vis = 'togglerows';
 55 
          var vis = 'togglerows';
76 
          if(typeof row[10] === 'undefined') {
 56 
          if(typeof row[10] === 'undefined') {
77 
            vis = 'invisible'
 57 
            vis = 'invisible'
Line 90... Line 70...
90 
        function getNewerVersion ( row, type, set, meta ) {
 70 
        function getNewerVersion ( row, type, set, meta ) {
91 
          var hRef = "dependencies.asp?pv_id=" + row[7]
 71 
          var hRef = "dependencies.asp?pv_id=" + row[7]
92 
          return "<a href=" + hRef + ">" + row[8] + "</a>"
 72 
          return "<a href=" + hRef + ">" + row[8] + "</a>"
93 
        }
 73 
        }
94 
 
 74 
 
- 
 
 75 
        // Format row of data for extended version display
- 
 
 76 
        // Return as a tr node so that the colums can be added to the current table
- 
 
 77 
        // and have them line up with existing columns
- 
 
 78 
        function format(d){
- 
 
 79 
             var rv = [];
- 
 
 80 
             var dd = d[10];
- 
 
 81 
 
- 
 
 82 
             for (var ii in dd) {
- 
 
 83 
                 row = $('<tr/>');
- 
 
 84 
                 row.append($('<td/>').append( '' ).attr('colspan', '4'));
- 
 
 85 
                 row.append($('<td/>').append( $('<a/>').append( dd[ii][1]).attr('href', 'dependencies.asp?pv_id=' + dd[ii][0]) ));
- 
 
 86 
                 row.append($('<td/>').append( dd[ii][2] ));
- 
 
 87 
                 row.append($('<td/>'));
- 
 
 88 
                 rv.push(row);
- 
 
 89 
             }
- 
 
 90 
             return rv;
- 
 
 91 
        }
- 
 
 92 
 
- 
 
 93 
        var nvTable;
- 
 
 94 
        function loadTable() {
95 
		/* Init DataTables */
 95 
            /* Init DataTables */
96 
        var nvTable = $('#nvtable').DataTable({
 96 
            nvTable = $('#nvtable').DataTable({
97 
            //bLengthChange : false,
 97 
                //bLengthChange : false,
98 
            sDom : "rti",
 98 
                sDom : "rti",
99 
            data : dataSet,
 99 
                data : dataSet,
100 
            columns : [
 100 
                columns : [
101 
            { data : getPkgName },
 101 
                { data : getPkgName },
102 
            { data : getVersion },
 102 
                { data : getVersion },
103 
            { data : [1] },
 103 
                { data : [1] },
104 
            { data : [6] },
 104 
                { data : [6] },
105 
            { data : getNewerVersion },
 105 
                { data : getNewerVersion },
106 
            { data : [9] },
 106 
                { data : [9] },
107 
            { data : null, defaultContent: '' },
 107 
                { data : null, defaultContent: '' },
108 
            ],
108 
                ],
109 
            //"bProcessing": true,
 109 
                scrollCollapse : true,
110 
            //"bRetrieve":true,
 110 
                paging : false,
- 
 
 111 
                "order": [[0,'asc']],
111 
            //"bServerSide": true,
 112 
                "info": true,
112 
            //"sAjaxSource": 'project_log_json.asp',
 113 
                "columnDefs" : [
113 
            //"sScrollY": $( document ).height()- 200,
 114 
                    {className : "dt-nowrap", targets: "_all" },
114 
            //"bDeferRender": true,
 115 
                ],
- 
 
 116 
            });
- 
 
 117 
        }
115 
 
 118 
 
116 
            //"sScrollX": "100%",
 119 
        // Load Data once via AJAX
- 
 
 120 
        var dataSet;
- 
 
 121 
        $.get({
117 
            scrollCollapse : true,
 122 
            url: 'rep_new_versions_json.asp',
118 
            paging : false,
 123 
            dataType : 'json',
119 
            //"iScrollLoadGap": 5,
 124 
            data : {
120 
            //"oScroller": {
 125 
                   rtag_id : <%=parRtagId%>,
121 
			//    "loadingIndicator": true
 126 
                   action : 'getData'
122 
		    //},
 127 
                   },
123 
            "order": [[0,'asc']],
 128 
            success : function(data, textStatus, jqXHR){
124 
            "info": true,
 129 
                console.log('inner success');
125 
            "columnDefs" : [
130 
                dataSet = data.aaData;
126 
                {className : "dt-nowrap", targets: "_all" },
 131 
                loadTable();
127 
            ],
 132 
            }
- 
 
 133 
        }).always( function(){
- 
 
 134 
                    // Remove the loading image
- 
 
 135 
                    $('#loading').remove();
- 
 
 136 
 
- 
 
 137 
        }).fail( function(){
- 
 
 138 
                    console.log('Fail');
128 
        });
 139 
        });
129 
 
 140 
 
- 
 
 141 
 
130 
        //  Add event listener fro opening closing extended version list
 142 
        //  Add event listener fro opening closing extended version list
131 
        $('#nvtable tbody').on('click', 'img.togglerows', function () {
 143 
        $('#nvtable tbody').on('click', 'img.togglerows', function () {
132 
            var tr = $(this).closest('tr');
 144 
            var tr = $(this).closest('tr');
133 
            var row = nvTable.row(tr);
 145 
            var row = nvTable.row(tr);
134 
 
 146 
 
Line 145... Line 157...
145 
                $(this).attr('src', 'images/bt_minus.gif');
 157 
                $(this).attr('src', 'images/bt_minus.gif');
146 
            };
 158 
            };
147 
 
 159 
 
148 
        });
 160 
        });
149 
 
 161 
 
150 
        // Format row of data for extended version display
 162 
       //  Toggle All the extended versions
151 
        // Return as a tr node so that the colums can be added to the current table
 163 
        //  Show/Hide the ALL row togglers for rows that do not have any children
- 
 
 164 
 
- 
 
 165 
        $('#toggleAll').click(function(event){
- 
 
 166 
            event.stopPropagation();
- 
 
 167 
            event.stopImmediatePropagation();
- 
 
 168 
 
- 
 
 169 
            var hide = $(this).hasClass('allOn');
- 
 
 170 
            $(this).attr('src', hide ? 'images/bt_plus.gif' : 'images/bt_minus.gif');
- 
 
 171
- 
 
 172 
            $(this).toggleClass('allOn');
- 
 
 173 
            $('#nvtable tbody img.togglerows').each(function(idx, el){
- 
 
 174 
 
- 
 
 175 
                var tr = $(this).closest('tr');
- 
 
 176 
                var row = nvTable.row(tr);
- 
 
 177 
 
- 
 
 178 
                if ( row.child.isShown() && hide ) {
152 
        // and have them line up with existing columns
 179 
                    // This row is already open - close it
153 
        function format(d){
 180 
                    row.child.hide();
- 
 
 181 
                    tr.removeClass('shown');
- 
 
 182 
                    $(this).attr('src', 'images/bt_plus.gif');
154 
             var rv = [];
 183 
                }
- 
 
 184 
 
- 
 
 185 
                if ( ! row.child.isShown() && !hide ) {
- 
 
 186 
                    // Open this row
- 
 
 187 
                    row.child( format(row.data()) ).show();
- 
 
 188 
                    tr.addClass('shown');
- 
 
 189 
                    $(this).attr('src', 'images/bt_minus.gif');
155 
             var dd = d[10];
 190 
                };
- 
 
 191 
            });
- 
 
 192 
        });
156 
 
 193 
 
157 
             for (var ii in dd) {
 - 
 
158 
                 row = $('<tr/>');
 - 
 
159 
                 row.append($('<td/>').append( '' ).attr('colspan', '4'));
 - 
 
160 
                 row.append($('<td/>').append( $('<a/>').append( dd[ii][1]).attr('href', 'dependencies.asp?pv_id=' + dd[ii][0]) ));
 - 
 
161 
                 row.append($('<td/>').append( dd[ii][2] ));
 - 
 
162 
                 rv.push(row);
 - 
 
163 
             }
 - 
 
164 
             return rv;
 - 
 
165 
        }
 - 
 
166 
      })
 194 
      })
167 
    </script>
 195 
    </script>
168 
<%End Sub
 196 
<%End Sub
169 
'----------------------------------------------
 197 
'----------------------------------------------
170 
'   Generate data as JSON so that it can be manipulated by datatables
 - 
 
171 
'   Could do this with an AJAX call, but ...
 - 
 
172 
Sub GenerateData
 - 
 
173 
    Dim rsQry
 - 
 
174 
 
 - 
 
175 
    OraDatabase.Parameters.Add "RTAG_ID", parRtagId, ORAPARM_INPUT, ORATYPE_NUMBER
 - 
 
176 
    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("rep_new_versions.sql"), 0 )
 - 
 
177 
	OraDatabase.Parameters.Remove "RTAG_ID"
 - 
 
178 
 
 - 
 
179 
    Response.Write "<script type=""text/javascript"" charset=""utf-8"">" + vbCRLF
 - 
 
180 
    Response.Write "var dataSet = [" + vbCRLF
 - 
 
181 
 
 - 
 
182 
    Dim endText, startText
 - 
 
183 
    Dim lastPvId : lastPvId = 0
 - 
 
184 
    Dim isNew, pvId
 - 
 
185 
 
 - 
 
186 
    Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 - 
 
187 
 
 - 
 
188 
        pvId = rsQry("PV_ID")
- 
 
189 
        If lastPvid <> pvId Then
 - 
 
190 
            If StartText <> "" Then
 - 
 
191 
                Response.Write "[" & startText
 - 
 
192 
                If endText <> "" Then
 - 
 
193 
                    Response.Write ",[" & endText & "],"
 - 
 
194 
                End If
 - 
 
195 
                Response.Write "]," + vbCRLF
 - 
 
196 
            End If
 - 
 
197 
            endText = ""
 - 
 
198 
            lastPvId = pvId
 - 
 
199 
 
 - 
 
200 
        ' Capture basic information
 - 
 
201 
        startText =  """" +  pvId + """" &_
 - 
 
202 
                     ",""" +  rsQry("VIEW_NAME") + """" &_
 - 
 
203 
                     ",""" +  rsQry("PKG_ID") + """" &_
 - 
 
204 
                     ",""" +  rsQry("PKG_NAME") + """"&_
 - 
 
205 
                     ",""" +  rsQry("PKG_VERSION") + """" &_
 - 
 
206 
                     ",""" +  rsQry("V_EXT") + """" &_
 - 
 
207 
                     ",""" +  rsQry("CREATED_STAMP") + """" &_
 - 
 
208 
                     ",""" +  rsQry("NEW_PV_ID") + """"  &_
 - 
 
209 
                     ",""" +  rsQry("NEW_PKG_VERSION") + """"  &_
 - 
 
210 
                     ",""" +  rsQry("NEW_CREATED_STAMP") + """"
 - 
 
211 
 
 - 
 
212 
        Else
 - 
 
213 
            ' Capture optional alternate package_versions
 - 
 
214 
            endText = endText &_
 - 
 
215 
                        "[""" +  rsQry("NEW_PV_ID") + """"  &_
 - 
 
216 
                        ",""" +  rsQry("NEW_PKG_VERSION") + """"  &_
 - 
 
217 
                        ",""" +  rsQry("NEW_CREATED_STAMP") + """"  &_
 - 
 
218 
                       "],"
- 
 
219 
        End If
 - 
 
220 
 
 - 
 
221 
    rsQry.MoveNext
 - 
 
222 
    Loop
 - 
 
223 
 
 - 
 
224 
    ' Get the last entry as well
 - 
 
225 
    If StartText <> "" Then
 - 
 
226 
        Response.Write "[" & startText
 - 
 
227 
        If endText <> "" Then
 - 
 
228 
            Response.Write ",[" & endText & "],"
 - 
 
229 
        End If
 - 
 
230 
        Response.Write "]," + vbCRLF
 - 
 
231 
    End If
 - 
 
232 
 
 - 
 
233 
    Response.Write "];"  + vbCRLF
 - 
 
234 
    Response.Write "</script>"  + vbCRLF
 - 
 
235 
    rsQry.close
 - 
 
236 
    Set rsQry = nothing
 - 
 
237 
End Sub
 - 
 
238 
'----------------------------------------------
 - 
 
239 
Sub LeftPanelContent
 198 
Sub LeftPanelContent
240 
%>
 199 
%>
241 
<fieldset class="fset" align="right" style=" border: 1px groove;">
 200 
<fieldset class="fset" align="right" style=" border: 1px groove;">
242 
   <table>
 201 
   <table>
243 
      <tr>
 202 
      <tr>
Line 258... Line 217...
258 
            <!--#include file="messages/_msg_inline.asp"-->
 217 
            <!--#include file="messages/_msg_inline.asp"-->
259 
            <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 218 
            <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
260 
            <div class=textPanel>
 219 
            <div class=textPanel>
261 
                <table id='nvtable' width="100%" class="stdGrey">
 220 
                <table id='nvtable' width="100%" class="stdGrey">
262 
                   <thead>
 221 
                   <thead>
263 
                      <th nowrap >Package Name</th>
 222 
                      <th nowrap><img id='toggleAll' src='images/bt_plus.gif' border='0' align='absmiddle' hspace='3' class='pointer'>Package Name</th>
264 
                      <th nowrap >Version</th>
 223 
                      <th nowrap>Version</th>
265 
                      <th nowrap >Base View</th>
 224 
                      <th nowrap>Base View</th>
266 
                      <th nowrap >Created</th>
 225 
                      <th nowrap>Created</th>
267 
                      <th nowrap >Newer Version</th>
 226 
                      <th nowrap>Newer Version</th>
268 
                      <th nowrap >Created</th>
 227 
                      <th nowrap>Created</th>
269 
                      <th nowrap ></th>
 228 
                      <th nowrap></th>
270 
                   </thead>
 229 
                   </thead>
271 
                    <tr id='loading' >
 230 
                    <tr id='loading' >
272 
                        <td colspan=7 class=tcenter>
 231 
                        <td colspan=7 class=tcenter>
273 
                            <img src='images/transparent-background-loading.gif'>
 232 
                            <img src='images/transparent-background-loading.gif'>
274 
                        </td>
 233 
                        </td>
Line 290... Line 249...
290 
      <link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
 249 
      <link rel="stylesheet" href="images/release_manager_style.css?ver=<%=VixVerNum%>" type="text/css">
291 
      <link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
 250 
      <link rel="stylesheet" href="images/navigation.css?ver=<%=VixVerNum%>" type="text/css">
292 
      <script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
 251 
      <script language="JavaScript" src="images/common.js?ver=<%=VixVerNum%>"></script>
293 
      <!-- DROPDOWN MENUS -->
 252 
      <!-- DROPDOWN MENUS -->
294 
      <%bJqueryDataTables = TRUE%>
 253 
      <%bJqueryDataTables = TRUE%>
- 
 
 254 
      <%sJqueryDataTablesCss="jquery/dataTables.vix.grey.css"%>
295 
      <!--#include file="_jquery_includes.asp"-->
 255 
      <!--#include file="_jquery_includes.asp"-->
296 
      <!--#include file="_menu_def.asp"-->
 256 
      <!--#include file="_menu_def.asp"-->
297 
      <script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
 257 
      <script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
298 
      <%Call InsertJavaScript %>
 258 
      <%Call InsertJavaScript %>
299 
      <%Call GenerateData %>
 - 
 
300 
   </head>
 259 
   </head>
301 
   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
 260 
   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
302 
      <!-- HEADER -->
 261 
      <!-- HEADER -->
303 
      <!--#include file="_header.asp"-->
 262 
      <!--#include file="_header.asp"-->
304 
      <!-- BODY ---->
 263 
      <!-- BODY ---->