Subversion Repositories DevTools

Rev

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

Rev 6827 Rev 6873
Line 24... Line 24...
24
Const IMGBG_ROW = "bgcolor='#FFFFFF'"
24
Const IMGBG_ROW = "bgcolor='#FFFFFF'"
25
Const IMG_PONTER = "<img src='images/i_pointer.gif' width='6' height='11' hspace='3'>"
25
Const IMG_PONTER = "<img src='images/i_pointer.gif' width='6' height='11' hspace='3'>"
26
Const IMG_OFFICIAL = "<img src='images/i_locked.gif' width='7' height='10' hspace='5' vspace='2' title='Package has been Released'>"
26
Const IMG_OFFICIAL = "<img src='images/i_locked.gif' width='7' height='10' hspace='5' vspace='2' title='Package has been Released'>"
27
Const IMG_PENDING = "<img src='icons/i_pending.gif' width='7' height='10' hspace='5' vspace='2' title='Package pending autobuild'>"
27
Const IMG_PENDING = "<img src='icons/i_pending.gif' width='7' height='10' hspace='5' vspace='2' title='Package pending autobuild'>"
28
Const IMG_NOT_OFFICIAL = "<img src='images/spacer.gif' width='7' height='10' hspace='5' vspace='2' title='Package not yet released'>"
28
Const IMG_NOT_OFFICIAL = "<img src='images/spacer.gif' width='7' height='10' hspace='5' vspace='2' title='Package not yet released'>"
-
 
29
Const IMG_NOT_BUILDABLE = "<img src='icons/s_unbuildable.png' width='14' height='14' hspace='5' vspace='0' title='Package is not buildable'>"
29
Const IMG_DOWNLOAD = "<img src='images/i_download_small.gif' alt='Download full release notes.' width='16' height='16' hspace='2' border='0'>"
30
Const IMG_DOWNLOAD = "<img src='images/i_download_small.gif' alt='Download full release notes.' width='16' height='16' hspace='2' border='0'>"
30
'------------ Variable Init -------------------
31
'------------ Variable Init -------------------
31
If Request("filter_reset") <> "" Then 
32
If Request("filter_reset") <> "" Then 
32
    parFLpkg_version = "*"
33
    parFLpkg_version = "*"
33
    parFLuser_name   = "*"
34
    parFLuser_name   = "*"
Line 64... Line 65...
64
    "   PV.IS_PATCH," &_
65
    "   PV.IS_PATCH," &_
65
    "   PV.RELEASE_NOTES_INFO," &_
66
    "   PV.RELEASE_NOTES_INFO," &_
66
    "   PV.BUILD_TYPE," &_
67
    "   PV.BUILD_TYPE," &_
67
    "   pv.CREATOR_ID," &_
68
    "   pv.CREATOR_ID," &_
68
    "   pv.OWNER_ID," &_
69
    "   pv.OWNER_ID," &_
-
 
70
    "   pv.BUILD_TYPE," &_
69
    "   NVL2(rc.rtag_id,1,0) as inuse," &_
71
    "   NVL2(rc.rtag_id,1,0) as inuse," &_
70
    "   trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age" &_
72
    "   trunc(SYSDATE - pv.CREATED_STAMP + 0.5) as age" &_
71
    " FROM PACKAGE_VERSIONS PV," &_
73
    " FROM PACKAGE_VERSIONS PV," &_
72
    "      USERS USR,"&_
74
    "      USERS USR,"&_
73
    "      RELEASE_CONTENT rc" &_
75
    "      RELEASE_CONTENT rc" &_
Line 348... Line 350...
348
                    
350
                    
349
                    ' Official/Unofficial case
351
                    ' Official/Unofficial case
350
                    imgLock = IMG_NOT_OFFICIAL
352
                    imgLock = IMG_NOT_OFFICIAL
351
                    'fieldRelease_Date = ""
353
                    'fieldRelease_Date = ""
352
                    'fieldReleased_By = ""
354
                    'fieldReleased_By = ""
-
 
355
                    If (aVersions( rsVB.FieldIndex("build_type"), i ) = "U")  Then
-
 
356
                        imgLock = IMG_NOT_BUILDABLE
353
                    If (aVersions( rsVB.FieldIndex("dlocked"), i ) = "Y")  Then
357
                    ElseIf (aVersions( rsVB.FieldIndex("dlocked"), i ) = "Y")  Then
354
                        imgLock = IMG_OFFICIAL
358
                        imgLock = IMG_OFFICIAL
355
                    ElseIf (aVersions( rsVB.FieldIndex("dlocked"), i ) = "A") Then 
359
                    ElseIf (aVersions( rsVB.FieldIndex("dlocked"), i ) = "A") Then 
356
                        imgLock = IMG_PENDING
360
                        imgLock = IMG_PENDING
357
                    End If
361
                    End If
358
                    
362