Subversion Repositories DevTools

Rev

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

Rev 6783 Rev 6793
Line 52... Line 52...
52 
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
 52 
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
53 
</head>
 53 
</head>
54 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
 54 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
55 
<!-- HEADER -->
 55 
<!-- HEADER -->
56 
<!--#include file="_header.asp"-->
 56 
<!--#include file="_header.asp"-->
57 
 
 - 
 
58 
  <%
 - 
 
59 
  '-- FROM START ---------------------------------------------------------------------------------------------------------
 - 
 
60 
  objFormComponent.FormName = "VCSTYPE"
 - 
 
61 
  objFormComponent.Action = ScriptName
 - 
 
62 
  objFormComponent.OnSubmit = "ShowProgress();"
 - 
 
63 
  Call objFormComponent.FormStart()
 - 
 
64 
  %>
- 
 
65 
  <div class="div_table">
 57 
  <div class="div_table">
66 
    <table class="center_table" >
 - 
 
67 
      <tr>
 58 
    <td>
68 
        <td background="images/bg_bage_0a.gif">
 59 
        <table border="0" cellspacing="1" cellpadding="2" class='stdBrown center_table'>
69 
            <div align="center" class=" body_col">Package Base Views</div>
 60 
            <caption>Package Base Views</caption>
70 
            <table width="100%"  border="0" cellspacing="1" cellpadding="2">
 61 
            <thead>
71 
            <tr>
 62 
            <tr>
72 
            <!-- BASE VIEW DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
 63 
            <!-- BASE VIEW DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
73 
            <td background="images/bg_bage_0.gif" align="center"></td>
 64 
            <th nowrap >Base View Name</th>
74 
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">BASE VIEW NAME</td>
 - 
 
75 
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Count</td>
 65 
            <th nowrap >Count</th>
76 
            <td align="left" nowrap background="images/bg_table_col.gif" class="body_col">Edit</td>
 66 
            <th nowrap >Edit</th>
77 
            </tr>
 67 
            </tr>
- 
 
 68 
            </thead>
78 
 
 69 
 
79 
          <%
 70 
      <%
80 
           Dim view_id, name, count, rsQry, SqlQry, rmText
 71 
       Dim view_id, name, count, rsQry, SqlQry, rmText
81 
 
 - 
 
82 
           SqlQry = "select vv.VIEW_ID, vv.VIEW_NAME, count from ( " &_
 - 
 
83 
                    "select rc.base_view_id, count(pv.pkg_id) as count from release_content rc, views v, package_versions pv " &_
 - 
 
84 
                    "where rc.base_view_id = v.view_id " &_
 - 
 
85 
                    "AND rc.pv_id = pv.pv_id " &_
 - 
 
86 
                    "and v.BASE_VIEW = 'Y' " &_
 - 
 
87 
                    "group by rc.base_view_id " &_
 - 
 
88 
                    ") t1 " &_
 - 
 
89 
                    "join views vv on t1.base_view_id(+) = vv.view_id where vv.BASE_VIEW = 'Y' " &_
 - 
 
90 
                    "order by upper(view_name)"
 - 
 
91 
 
 72 
 
92 
           Set rsQry = OraDatabase.DbCreateDynaset( SqlQry, ORADYN_DEFAULT )
 73 
       SqlQry = "select vv.VIEW_ID, vv.VIEW_NAME, count from ( " &_
93 
           While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
 74 
                "select rc.base_view_id, count(pv.pkg_id) as count from release_content rc, views v, package_versions pv " &_
94 
              view_id = rsQry("view_id")
 75 
                "where rc.base_view_id = v.view_id " &_
95 
              name = rsQry("view_name")
 76 
                "AND rc.pv_id = pv.pv_id " &_
96 
              count = rsQry("count")
 77 
                "and v.BASE_VIEW = 'Y' " &_
97 
              %>
 - 
 
98 
              <tr>
- 
 
99 
                <td background="images/bg_bage_0.gif"></td>
 - 
 
100 
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%=name%></td>
 - 
 
101 
                <td bgcolor="#FFFFFF" class="body_row" nowrap><%=count%></td>
 - 
 
102 
                <td bgcolor="#FFFFFF" class="body_row" nowrap style="padding-right:0px">
 - 
 
103 
                  <%If canEdit Then%>
 78 
                "group by rc.base_view_id " &_
104 
                        <a href="javascript:;" onclick="MM_openVixIFrame('_wform_edit_baseview.asp?view_id=<%=view_id%>','Edit Base Name')"><%=LIMG_EDIT%></a>
 - 
 
105 
                  <%Else%>
 79 
                ") t1 " &_
106 
                        <%=LIMG_EDIT_DISABLED%>
 80 
                "join views vv on t1.base_view_id(+) = vv.view_id where vv.BASE_VIEW = 'Y' " &_
107 
                  <%End If%>
 81 
                "order by upper(view_name)"
108 
                  <%If canDelete and isNull(count) Then%>
 - 
 
109 
                        <a href='javascript:;' onclick="vixConfirm('Delete the \'Base View\' named \'<%=name%>\'',{title : 'Delete Base View', button:'Delete', url: '_DeleteBaseView.asp?view_id=<%=view_id%>'});"><%=LIMG_NDEL%></a>
 - 
 
110 
 
 82 
 
111 
                  <%Else%>
 - 
 
112 
                        <%=LIMG_NDEL_DISABLED%>
 83 
       Set rsQry = OraDatabase.DbCreateDynaset( SqlQry, ORADYN_DEFAULT )
113 
                  <%End If%>
 84 
       While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
114 
                </td>
 - 
 
115 
              </tr>
- 
 
116 
              <%
 - 
 
117 
              rsQry.MoveNext()
 85 
          view_id = rsQry("view_id")
118 
          Wend
 - 
 
119 
          rsQry.Close()
 86 
          name = rsQry("view_name")
120 
          Set rsQry = nothing
 87 
          count = rsQry("count")
121 
          %>
 88 
          %>
122 
        <tr>
 89 
          <tr>
123 
            <td background="images/bg_bage_0.gif"></td>
 90 
            <td nowrap><%=name%></td>
- 
 
 91 
            <td nowrap><%=count%></td>
124 
            <td bgcolor="#FFFFFF" nowrap colspan="3" class="abtnItem"  align=right>
 92 
            <td nowrap style="padding-right:0px">
125 
            <%If canCreate Then%>
 93 
              <%If canEdit Then%>
- 
 
 94 
                    <a href="javascript:;" onclick="MM_openVixIFrame('_wform_edit_baseview.asp?view_id=<%=view_id%>','Edit Base Name')"><%=LIMG_EDIT%></a>
126 
              <a href="javascript:;"
 95 
              <%Else%>
- 
 
 96 
                    <%=LIMG_EDIT_DISABLED%>
- 
 
 97 
              <%End If%>
127 
                 onclick="MM_openVixIFrame('_wform_new_group.asp?noFrame=1','New Base View Name')">
 98 
              <%If canDelete and isNull(count) Then%>
128 
                <img src="images/i_new_group.gif" width="20" height="20" align="absmiddle" border="0" title="Create New Base View Group">&nbsp;Create New Base View</a>
 99 
                    <a href='javascript:;' onclick="vixConfirm('Delete the \'Base View\' named \'<%=name%>\'',{title : 'Delete Base View', button:'Delete', url: '_DeleteBaseView.asp?view_id=<%=view_id%>'});"><%=LIMG_NDEL%></a>
- 
 
 100 
 
129 
            <%Else%>
 101 
              <%Else%>
130 
                <img class ="lessOpacity" src="images/i_new_group.gif" hspace="2" border="0" align="absmiddle"> &nbsp;Create New Base View
 102 
                    <%=LIMG_NDEL_DISABLED%>
131 
            <%End If%>
 103 
              <%End If%>
132 
            </td>
 104 
            </td>
133 
        </tr>
 105 
          </tr>
- 
 
 106 
          <%
- 
 
 107 
          rsQry.MoveNext()
- 
 
 108 
      Wend
- 
 
 109 
      rsQry.Close()
- 
 
 110 
      Set rsQry = nothing
- 
 
 111 
      %>
134 
    </table>
 112 
    <tr>
135 
    <%=objPMod.ComposeHiddenTags()%>
 113 
        <td colspan='3' align=right>
136 
    <input type="hidden" name="action" value="true">
 114 
        <%If canCreate Then%>
137 
    <%Call objFormComponent.FormEnd()%>
 115 
          <a href="javascript:;"
- 
 
 116 
             onclick="MM_openVixIFrame('_wform_new_group.asp?noFrame=1','New Base View Name')">
- 
 
 117 
            <img src="images/i_new_group.gif" width="20" height="20" align="absmiddle" border="0" title="Create New Base View Group">&nbsp;New Base View</a>
- 
 
 118 
        <%Else%>
- 
 
 119 
            <img class ="lessOpacity" src="images/i_new_group.gif" hspace="2" border="0" align="absmiddle"> &nbsp;Create New Base View
- 
 
 120 
        <%End If%>
- 
 
 121 
        </td>
138 
    </table>
 122 
    </tr>
- 
 
 123 
</table>
139 
    </div>
 124 
</div>
140 
<!-- FOOTER -->
 125 
<!-- FOOTER -->
141 
<!--#include file="_footer.asp"-->
 126 
<!--#include file="_footer.asp"-->
142 
</body>
 127 
</body>
143 
</html>
 128 
</html>