Subversion Repositories DevTools

Rev

Rev 6376 | Rev 6378 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
3872 dpurdie 1
<%
2
'=====================================================
3
'|                                                   |
6375 dpurdie 4
'|                 Files and Folders                 |
3872 dpurdie 5
'|                 Core implementation               |
6
'|                                                   |
7
'=====================================================
8
%>
9
<%
10
'------------ Variable Definition -------------
11
Dim rsTemp
12
Dim rsQry
13
Dim sLink
14
Dim sSize
6375 dpurdie 15
Dim sCompSize
3872 dpurdie 16
Dim sIcon
17
Dim parComparePvId
18
Dim parCompare
19
Dim sDiffStateIcon
20
Dim sStyle
6376 dpurdie 21
Dim sCompVerText
22
Dim sVerText
3872 dpurdie 23
'------------ Constants Declaration -----------
24
Const LIMG_UPDATED = "<img src='images/i_updated.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Updated'>"
25
Const LIMG_ADDED = "<img src='images/i_added.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Added'>"
26
Const LIMG_REMOVED = "<img src='images/i_removed.gif' width='11' height='11' border='0' hspace='2' align='absmiddle' title='Removed'>"
27
'------------ Variable Init -------------------
28
parComparePvId = Request("compare_pv_id")
29
parCompare = Request("compare")
30
'----------------------------------------------
31
If Request("btn") = "Compare" Then
6375 dpurdie 32
    parCompare = "true"
3872 dpurdie 33
End If
34
'----------------------------------------------
35
%>
6377 dpurdie 36
<script type="text/javascript" charset="utf-8">
37
function toggleTag(tname)
38
{
39
    $( '.tag-' + tname ).toggleClass('display-none');
40
}
41
 
42
function toggleTable(dir)
43
{
44
    $('#fileList tr td:nth-child(2)').each(function(idx, item){
45
        var txt =  item.innerText;
46
        if ( txt.indexOf(dir) == 0 ) {
47
            $(item.closest('tr')).toggleClass('display-none');    
48
        }
49
    });
50
}
51
 
52
</script>
3872 dpurdie 53
<%
54
'--------------------------------------------------------------------------------------------------------------------------------------
55
Sub DisplayMessage ()
6375 dpurdie 56
    If (pkgInfoHash.Item ("dlocked") = "Y") Then
57
        If (InStr(pkgInfoHash.Item ("release_notes_info"),"MSG:") > 0) Then 
58
            Select Case CStr( pkgInfoHash.Item ("release_notes_info") )
59
            Case enum_RELEASE_NOTES_GENERATING
60
                Call DisplayInfo ( "GENERATING_RELEASE_NOTES", "400" )
61
            Case enum_RELEASE_NOTES_NOT_FOUND_IN_ARCHIVE
62
                Call DisplayInfo ( "NOT_FOUND_IN_PKG_ARCHIVE_FILE_GENERATE", "400" )
63
            Case enum_RELEASE_NOTES_FAILED
64
                Call DisplayInfo ( "FAILED_GENERATING_RELEASE_NOTES", "400" )
65
            Case enum_RELEASE_NOTES_NO_PREVIOUS_VERSION
66
                Call DisplayInfo ( "NO_PREVIOUS_VERSION_RELEASE_NOTES", "400" )
4705 dpurdie 67
            Case enum_RELEASE_NOTES_PLACEHOLDER_PACKAGE
68
                Call DisplayInfo ( "RELEASE_NOTES_PLACEHOLDER_PACKAGE", "400" )
6375 dpurdie 69
            End Select
70
 
71
        ElseIf IsNull(pkgInfoHash.Item ("release_notes_info")) Then
72
            Call DisplayInfo ( "GENERATING_RELEASE_NOTES", "400" )
73
 
74
        End If
75
 
76
    End If
3872 dpurdie 77
End Sub
78
'--------------------------------------------------------------------------------------------------------------------------------------
79
Sub DisplayComparePvIdCombo()
6375 dpurdie 80
    Dim rsQry, isOfficial
81
 
6376 dpurdie 82
    sVerText = pkgInfoHash.Item("pkg_version")
83
    sCompVerText = "" 
84
 
6375 dpurdie 85
    ' Define version to compare
86
    If parComparePvId = "" Then
87
        If NOT IsNull( pkgInfoHash.Item("last_pv_id") ) Then 
88
            parComparePvId = pkgInfoHash.Item("last_pv_id")
89
        Else
90
            parComparePvId = 0
91
        End If
92
 
93
    End If
94
 
95
    OraDatabase.Parameters.Add "COMPARE_PV_ID", parComparePvId, ORAPARM_INPUT, ORATYPE_NUMBER 
96
    OraDatabase.Parameters.Add "PKG_ID",        pkgInfoHash.Item("pkg_id"), ORAPARM_INPUT, ORATYPE_NUMBER 
97
    OraDatabase.Parameters.Add "V_EXT",         EmptyToNull(pkgInfoHash.Item("v_ext")), ORAPARM_INPUT, ORATYPE_VARCHAR2 
98
 
99
    Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("AllPackageVersions.sql"), cint(0))
100
 
101
    Response.write "<option value=''></option>"
102
 
3872 dpurdie 103
    While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
6375 dpurdie 104
 
105
        If rsQry("dlocked") = "Y" Then
106
            isOfficial = "R&nbsp;"
107
        Else
108
            isOfficial = "&nbsp;&nbsp;&nbsp;&nbsp;"
109
        End If
6376 dpurdie 110
 
111
        If rsQry("selected") <> "" Then
112
            sCompVerText = rsQry("pkg_version")
113
        End If
6375 dpurdie 114
 
115
        Response.write "<option value='"& rsQry("pv_id") &"' "& rsQry("selected") &" >"& isOfficial & rsQry("pkg_version") &"</option>"
116
 
117
        rsQry.MoveNext
3872 dpurdie 118
    WEnd
6375 dpurdie 119
 
120
    ' Clean up
121
    rsQry.Close()
122
    Set rsQry = nothing
123
 
124
    OraDatabase.Parameters.Remove "COMPARE_PV_ID"
125
    OraDatabase.Parameters.Remove "PKG_ID"
126
    OraDatabase.Parameters.Remove "V_EXT"
127
 
3872 dpurdie 128
End Sub
129
'--------------------------------------------------------------------------------------------------------------------------------------
130
Sub GetDiffStateIcon( nDiffState, outIcon, outStyle )
6375 dpurdie 131
    Select Case CInt( nDiffState )
132
        Case enumDB_NUM_DIFF_UPDATED
133
            outIcon  = LIMG_UPDATED
134
            outStyle = "body_rowbold"
135
 
136
        Case enumDB_NUM_DIFF_REMOVED
137
            outIcon = LIMG_REMOVED
138
            outStyle = "body_rowthru"
139
 
140
        Case enumDB_NUM_DIFF_NEW
141
            outIcon = LIMG_ADDED
142
            outStyle = "body_rowbold"
143
 
144
        Case Else
145
            outIcon = ""
146
            outStyle = "body_rowg"
147
    End Select
3872 dpurdie 148
End Sub
149
'--------------------------------------------------------------------------------------------------------------------------------------
150
Sub DisplayDiffSummary( orsQry )
6375 dpurdie 151
    Dim dDiffSummary
152
    Set dDiffSummary = CreateObject("Scripting.Dictionary")
153
 
154
    dDiffSummary.Item ("UPDATED") = 0
155
    dDiffSummary.Item ("REMOVED") = 0
156
    dDiffSummary.Item ("ADDED") = 0
157
 
158
    While ((NOT orsQry.BOF) AND (NOT orsQry.EOF))
159
 
160
        Select Case CInt( orsQry("diff_state") )
161
            Case enumDB_NUM_DIFF_UPDATED
162
                dDiffSummary.Item ("UPDATED") = CInt( dDiffSummary.Item ("UPDATED") ) + 1
163
 
164
            Case enumDB_NUM_DIFF_REMOVED
165
                dDiffSummary.Item ("REMOVED") = CInt( dDiffSummary.Item ("REMOVED") ) + 1
166
 
167
            Case enumDB_NUM_DIFF_NEW
168
                dDiffSummary.Item ("ADDED") = CInt( dDiffSummary.Item ("ADDED") ) + 1
169
 
170
        End Select
171
 
172
        orsQry.MoveNext
173
    WEnd
174
 
175
 
176
    ' Reset cursor
177
    orsQry.MoveFirst()
178
 
179
 
180
    ' Display Summary
181
    Response.write dDiffSummary.Item ("UPDATED") &" -<img src='images/i_updated.gif' width='11' height='11' hspace='3'>Updated, "
182
    Response.write dDiffSummary.Item ("ADDED") &" -<img src='images/i_added.gif' width='11' height='11' hspace='3'>Added, "
183
    Response.write dDiffSummary.Item ("REMOVED") &" -<img src='images/i_removed.gif' width='11' height='11' hspace='3'>Removed"
184
 
3872 dpurdie 185
End Sub
186
'--------------------------------------------------------------------------------------------------------------------------------------
187
%>
6375 dpurdie 188
    <!-- DETAILS ------------------------------------------------->
189
 
190
    <%
191
    ' -- Open Database connection
192
 
6376 dpurdie 193
    If parCompare <> "" Then
194
        OraDatabase.Parameters.Add "PV_ID", parPv_id,   ORAPARM_INPUT, ORATYPE_NUMBER 
195
        OraDatabase.Parameters.Add "COMPARE_PV_ID", parComparePvId, ORAPARM_INPUT, ORATYPE_NUMBER 
6375 dpurdie 196
 
6376 dpurdie 197
        Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ModuleComponentDiff.sql"), cint(0))
198
 
199
        OraDatabase.Parameters.Remove "PV_ID"
200
        OraDatabase.Parameters.Remove "COMPARE_PV_ID"
201
 
6375 dpurdie 202
    Else
6376 dpurdie 203
        OraDatabase.Parameters.Add "PV_ID", parPv_id,   ORAPARM_INPUT, ORATYPE_NUMBER 
6375 dpurdie 204
 
6376 dpurdie 205
        Set rsQry = OraDatabase.DbCreateDynaset( GetQuery("ModuleComponents.sql"), cint(0))
6375 dpurdie 206
 
6376 dpurdie 207
        OraDatabase.Parameters.Remove "PV_ID"
208
 
6375 dpurdie 209
    End If
6376 dpurdie 210
      '
3872 dpurdie 211
      ' If not called from a history tab then we display a dialog to allow comparison
212
      ' with another version
213
    %>
214
    <%If pkgCompare Then %>
6375 dpurdie 215
            <form name="formname" method="get" action="<%=ScriptName%>" onSubmit="ProgressBar.style.visibility='visible';">
216
            <br>                      
6376 dpurdie 217
            <span class="body_colb">Files and Folders</span><br>
218
 
219
            <%If rsQry.Recordcount > 0 Then%>
220
            <table width="100%"  border="0" cellspacing="1" cellpadding="3">
221
              <tr>
222
                <td nowrap class="body_txt">
223
                    Show differences since version
224
                    <select name="compare_pv_id" class="form_item">
225
                    <%Call DisplayComparePvIdCombo()%>
226
                    </select>
227
                    <input name="btn" type="submit" class="form_btn" value="Compare"> 
228
                    <%If parCompare <> "" Then%>
229
                    &nbsp;&nbsp;&nbsp;
230
                    <a class="form_btn" href="<%=scriptName%>?pv_id=<%=parPv_id%>&rtag_id=<%=parRtag_id%>">Show <%=sVerText%></a>
231
                    <a class="form_btn" href="<%=scriptName%>?pv_id=<%=parComparePvId%>&rtag_id=<%=parRtag_id%>">Show <%=sCompVerText%></a>
232
                    <%End If%>
233
                </td>
234
                <td nowrap class="body_txt" align="right">
235
                    <%If parCompare <> "" Then%>
236
                        <%Call DisplayDiffSummary( rsQry ) %>
237
                    <%End If%>
238
                </td>
239
              </tr>
240
            </table>
241
            <hr size="1" noshade color="#999999"> 
242
            <%End If%>                                               
3872 dpurdie 243
    <%End If%>
244
 
245
    <!-- MODULE COMPONENTS ++++++++++++++++++++++++++++++++++++++ -->
6375 dpurdie 246
 
247
 
248
        <!-- ==================================================== -->
249
        <!-- ===================  COMPARE ======================= -->
250
        <!-- ==================================================== -->
251
        <%If parCompare <> "" Then%>
252
            <%If rsQry.Recordcount > 0 Then%>
253
 
6377 dpurdie 254
            <table id="fileList" width="100%"  border="0" cellspacing="1" cellpadding="3">
6376 dpurdie 255
            <tr class="form_field_hdr">
256
              <td width="1"   rowspan="2"></td>
257
              <td width="60%" rowspan="2">Name</td>
258
              <td width="20%" colspan="2" align="center"><%=sVerText%></td>
259
              <td width="20%" colspan="2" align="center"><%=sCompVerText%></td>
6375 dpurdie 260
            </tr>
6376 dpurdie 261
            <tr class="form_field_hdr">
262
              <td align="right">Byte Size</td>
263
              <td align="right">CKSUM</td>
264
              <td align="right">Byte Size</td>
265
              <td align="right">CKSUM</td>
266
            </tr>
6375 dpurdie 267
            <%
268
            While ((NOT rsQry.BOF) AND (NOT rsQry.EOF)) 
6376 dpurdie 269
                Dim sizeStyle : sizeStyle = ""
270
                Dim sumStyle  : sumStyle = ""
271
                Dim diffState : diffState = rsQry("diff_state")
272
                Dim sSum, sCompSum
273
                sSum = rsQry("crc_cksum")
274
                sCompSum = rsQry("comp_crc_cksum") 
275
                sSize = rsQry("byte_size")
276
                sCompSize = rsQry("comp_byte_size")
277
                Call GetDiffStateIcon( diffState, sDiffStateIcon, sStyle )
6375 dpurdie 278
 
279
                ' Find if this is file or folder
6376 dpurdie 280
                If (IsNull(sSum) AND  (sSize = 0)) OR (IsNull(sCompSum) AND (sCompSize = 0)) Then 
6375 dpurdie 281
                    sSize = ""
282
                    sCompSize = ""
283
                    sIcon = "<img src='images/rex_images/_folder.gif' border='0' hspace='3' align='absmiddle'>"
284
                Else
285
                    sSize = rsQry("byte_size")
286
                    sCompSize = rsQry("comp_byte_size")
287
                    sIcon = "<img src='images/rex_images/ext_blank.gif' border='0' hspace='3' align='absmiddle'>"
6376 dpurdie 288
 
289
                    If diffState > 1 OR (sSum <>  sCompSum) Then
290
                        sumStyle = "err_dtl"
291
                    End If
292
 
293
                    If diffState > 1 OR (sSize <> sCompSize) Then
294
                        sizeStyle = "err_dtl"
295
                    End If
296
 
6375 dpurdie 297
                End If
298
 
299
            %>
6376 dpurdie 300
            <tr class="form_item_grey">
301
              <td nowrap ><%=sDiffStateIcon%></td>
302
              <td nowrap class="<%=sStyle%>"><%=sIcon & rsQry("name")%></td>
303
              <td nowrap class="<%=sizeStyle%>" align="right"><%=sSize%></td>
304
              <td nowrap class="<%=sumStyle%>"  align="right"><%=sSum%></td>
305
              <td nowrap class="<%=sizeStyle%>" align="right"><%=sCompSize%></td>
306
              <td nowrap class="<%=sumStyle%>"  align="right"><%=sCompSum%></td>
6375 dpurdie 307
            </tr>
308
            <%
309
                rsQry.MoveNext
310
            WEnd
311
 
312
            rsQry.Close()
313
            Set rsQry = nothing
314
            %>
315
            </table><br>
316
 
317
            <%End If%>
318
        <%Else%>
319
        <!-- ==================================================== -->
320
        <!-- =================== NORMAL FILES =================== -->
321
        <!-- ==================================================== -->
6376 dpurdie 322
            <%If rsQry.Recordcount < 1 Then
323
                ' No files found ...
324
                Call DisplayMessage ()
325
            Else
6375 dpurdie 326
            %>
6377 dpurdie 327
            <table id="fileList" width="100%"  border="0" cellspacing="1" cellpadding="3">
6376 dpurdie 328
            <tr class="form_field_hdr">
6377 dpurdie 329
              <td width="1%" >&nbsp;</td>
6376 dpurdie 330
              <td width="25%" >Name</td>
331
              <td width="25%" align="right">Byte Size</td>
332
              <td width="25%" align="right">CKSUM</td>
333
              <td width="25%" align="right">MODCRC</td>
6375 dpurdie 334
            </tr>
335
            <%
6377 dpurdie 336
            Dim dClass, nextClass
337
            Dim isHidden
338
            Dim filePath
339
            Dim tag
340
            Dim curDir
341
            Dim sClick
342
            dClass = ""
343
            nextClass = ""
344
            isHidden = FALSE
345
            curDir = ""
346
            sClick =  ""
347
 
348
            Dim knownDirs : knownDirs = Array ("lcov", "doc", "utfResults", "etc" )
349
            Dim item
350
 
351
            While ((NOT rsQry.BOF) AND (NOT rsQry.EOF))
352
                    sLink = dpkg_archiveURL & pkgInfoHash.Item ("pkg_name") &"/"& pkgInfoHash.Item ("pkg_version") &"/"& Replace( rsQry("file_path") & rsQry("file_name"), "\", "/" )
353
                    filePath = rsQry("file_path")
354
                    If IsNull(filePath) Then filePath = ""
355
 
356
                    ' Find if this is file or folder
357
                    If IsNull( rsQry("crc_cksum") )  AND  (rsQry("byte_size") = 0) Then
358
                        ' Is a folder
359
                        ' Should it be a hidden folder
360
                        isHidden = FALSE
361
                        tag = ""
362
                        For Each item in knownDirs
363
                            If filePath = item Then
364
                                isHidden = TRUE
365
                                tag = item
366
                                curDir = item
367
                                sClick =  "onclick=toggleTag('"& tag & "');"
368
                                Exit For
369
                            End If
370
                        Next
371
 
372
                        sSize = ""
373
                        sIcon = "<img src='images/rex_images/_folderopen.gif' border='0' hspace='3' align='absmiddle'>"
374
                        If isHidden Then
375
                            nextClass = "display-none tag-" & tag
376
                            dClass = ""
377
                            sIcon = "<img class='tag-"&tag&" display-none' src='images/rex_images/_folderopen.gif' border='0' hspace='3' align='absmiddle'>"
378
                            sIcon = sIcon + "<img class='tag-"&tag&"' src='images/rex_images/_folder.gif' border='0' hspace='3' align='absmiddle'>"
379
                        End If
380
                    Else
381
                        ' Is a File
382
                        '
383
                        ' We still in directory start with known tag
384
                        '
385
                        If isHidden Then
386
                            If (InStr( filePath, curDir & "/" ) <> 1) Then
387
                                isHidden = FALSE
388
                                tag = ""
389
                                nextClass = ""
390
                                dClass = ""
391
                                curDir = ""
392
                                sClick = ""
393
                            End If
394
                        End If
395
 
396
                        sSize = rsQry("byte_size")
397
                        sIcon = "<img src='images/rex_images/ext_blank.gif' border='0' hspace='3' align='absmiddle'>"
398
                    End If
399
 
400
                %>
401
                <tr class="<%=dClass%> form_field_grey_bg body_txt_gray">
402
                  <td nowrap <%=sClick%>><%=sIcon%></td>
403
                  <td nowrap><a target="_blank" href="<%=sLink%>" class="body_txt_gray_link"><%=filePath & rsQry("file_name")%></a></td>
404
                  <td nowrap align="right"><%=sSize%></td>
405
                  <td nowrap align="right"><%=rsQry("crc_cksum")%></td>
406
                  <td nowrap align="right"><%=rsQry("crc_modcrc")%></td>
407
                </tr>
408
                <%
409
                dClass = nextClass
6375 dpurdie 410
                rsQry.MoveNext
411
            WEnd
412
            rsQry.Close()
413
            Set rsQry = nothing
414
            %>
415
            </table><br>
416
 
417
            <%End If%>
418
        <!-- ==================================================== -->     
419
        <%End If%>      
420
 
3872 dpurdie 421
    <!-- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->   
422
    <%If pkgCompare Then %>
6375 dpurdie 423
        <input type="hidden" name="compare" value="<%=parCompare%>">
424
        <input type="hidden" name="pv_id" value="<%=parPv_Id%>">
425
        <input type="hidden" name="rtag_id" value="<%=parRtag_Id%>">
426
        </form>
427
    <%End If%>      
3872 dpurdie 428