Subversion Repositories DevTools

Rev

Rev 6793 | Rev 6877 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'|                                                   |
'|                 ADMIN licences                    |
'|                                                   |
'=====================================================
%>
<%
Option explicit
' Good idea to set when using redirect
Response.Expires = 0    ' always load the page, dont store
%>
<!--#include file="common/conf.asp"-->
<!--#include file="common/globals.asp"-->
<!--#include file="common/formating.asp"-->
<!--#include file="common/qstr.asp"-->
<!--#include file="common/common_subs.asp"-->
<!--#include file="sec/Crypt.asp"-->
<!--#include file="common/_form_window_common.asp"-->
<!--#include file="_action_buttons.asp"-->

<!--#include file="class/classActionButtonControl.asp"-->

<%
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login_optional.asp"-->
<!--#include file="_access_control_general.asp"-->
<%
'------------ Variable Definition -------------
Dim canEdit, canDelete, canCreate
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
canEdit = canActionControl("EditBaseViews")
canDelete = canActionControl("DeleteBaseViews")
canCreate = canActionControl("CreateBaseViews")
'----------------------------------------------
%>
<html>
<head>
<title>BaseView Administration</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>
<!--#include file="_jquery_includes.asp"-->
<!-- DROPDOWN MENUS -->
<!--#include file="_menu_def.asp"-->
<script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" >
<!-- HEADER -->
<!--#include file="_header.asp"-->
  <div class="div_table">
    <td>
        <table border="0" cellspacing="1" cellpadding="2" class='stdBrown center_table'>
            <caption>Package Base Views</caption>
            <thead>
            <tr>
            <!-- BASE VIEW DETAILS +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
            <th nowrap >Base View Name</th>
            <th nowrap >Count</th>
            <th nowrap >Edit</th>
            </tr>
            </thead>

      <%
       Dim view_id, name, count, rsQry, SqlQry, rmText

       SqlQry = "select vv.VIEW_ID, vv.VIEW_NAME, count from ( " &_
                "select rc.base_view_id, count(pv.pkg_id) as count from release_content rc, views v, package_versions pv " &_
                "where rc.base_view_id = v.view_id " &_
                "AND rc.pv_id = pv.pv_id " &_
                "and v.BASE_VIEW = 'Y' " &_
                "group by rc.base_view_id " &_
                ") t1 " &_
                "join views vv on t1.base_view_id(+) = vv.view_id where vv.BASE_VIEW = 'Y' " &_
                "order by upper(view_name)"

       Set rsQry = OraDatabase.DbCreateDynaset( SqlQry, ORADYN_DEFAULT )
       While (NOT rsQry.BOF) AND (NOT rsQry.EOF)
          view_id = rsQry("view_id")
          name = rsQry("view_name")
          count = rsQry("count")
          %>
          <tr>  
            <td nowrap><%=name%></td>
            <td nowrap><%=count%></td>
            <%BuildActionButtonClick canEdit, "", "", FALSE, LIMG_EDIT, "MM_openVixIFrame('_wform_edit_baseview.asp?view_id="&view_id&"','Edit Base Name')" %>
            <%BuildActionButtonClick canDelete and isNull(count), "", "", FALSE, LIMG_NDEL, "vixConfirm('Delete the \'Base View\' named \'"&name&"\'',{title : 'Delete Base View', button:'Delete', url: '_DeleteBaseView.asp?view_id="&view_id&"'});" %>
          </tr> 
          <%
          rsQry.MoveNext()
      Wend
      rsQry.Close()
      Set rsQry = nothing
      %>
    <tr>
        <td colspan='3' align=right>    
            <%BuildActionButtonClickRaw canCreate, "&nbsp;New Base View", "", TRUE, _
            "src='images/i_new_group.gif' width='20' height='20' align='absmiddle' border='0'",_
            "MM_openVixIFrame('_wform_new_group.asp?noFrame=1','New Base View Name')" %>
        </td>
    </tr>
</table>
</div>
<!-- FOOTER -->
<!--#include file="_footer.asp"-->
</body>
</html>