<%@LANGUAGE="VBSCRIPT"%>
<%
'=====================================================
'   form_view_release_licencing.asp
'|                                                   |
'=====================================================
%>
<%
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="common/_form_window_common.asp"-->
<%
' Make sure rtag_id is always present
If Request("rtag_id") = "" Then
    Call Destroy_All_Objects
	Response.Redirect("index.asp")
End If

' Set rfile parameter. This is a return page after Login
Call objPMod.StoreParameter ( "rfile", "form_view_release_licencing.asp" )
'------------ ACCESS CONTROL ------------------
%>
<!--#include file="_access_control_login.asp"-->
<!--#include file="_access_control_general.asp"-->
<%
'------------ Variable Definition -------------
Dim bShowAll
Dim bShowAny
Dim bAllCots
Dim sAllCheck
Dim sAnyCheck
Dim sAllCots
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
bShowAll = Request("ShowAll")
bShowAny = Request("ShowAny")
bAllCots = Request("allCots")

If bAllCots <> "" Then sAllCots = " Checked "
If bShowAny <> "" Then sAnyCheck = " Checked "
If bShowAll <> "" Then sAllCheck = " Checked "

'--------------------------------------------------------------------------------------------------------------------------
'  release_licencing_query_string
'
'  DESCRIPTION
'     Constructs a query string using the provided release tag, designed to elicit
'     a list of PV_ID's, thier package names, versions and extensions, and licencing
'     associations from the release. Only those PV_IDs with one or more licencing
'     associations are returned.
'
'  INPUTS
'     NNrtag_id : The release tag to be used in the query string
'
Function release_licencing_query_string(NNrtag_id)

   release_licencing_query_string = _
                    "WITH AllPkgLic AS " &_
                    "  (SELECT pkg_id, " &_
                    "    listagg(name, ',') within GROUP ( " &_
                    "  ORDER BY name) AS Name " &_
                    "  FROM " &_
                    "    (SELECT pv.pkg_id, " &_
                    "      ld.name, " &_
                    "      row_number() over (partition BY pv.pkg_id, ld.name order by pv.pkg_id) AS rn " &_
                    "    FROM LICENCING lg, " &_
                    "      LICENCES ld , " &_
                    "      package_versions pv " &_
                    "    WHERE lg.pv_id = pv.pv_id " &_
                    "    AND lg.LICENCE = ld.LICENCE " &_
                    "    ) " &_
                    "  WHERE rn = 1 " &_
                    "  GROUP BY pkg_id " &_
                    "  ), " &_
                    "  AllPvIDs AS " &_
                    "  ( SELECT DISTINCT * " &_
                    "  FROM " &_
                    "    ( SELECT pv_id FROM RELEASE_CONTENT rc WHERE rc.rtag_id = :rtag_id " &_
                    "    UNION " &_
                    "    SELECT pv_id FROM work_in_progress wip WHERE wip.rtag_id = :rtag_id " &_
                    "    UNION " &_
                    "    SELECT pv_id " &_
                    "    FROM planned pl " &_
                    "    WHERE pl.rtag_id   = :rtag_id " &_
                    "    AND (pl.operation IS NULL " &_
                    "    OR pl.operation    = 'R') " &_
                    "    ) " &_
                    "  ) " &_
                    "SELECT DISTINCT pv.pv_id, " &_
                    "  pv.pkg_id, " &_
                    "  pkg.pkg_name, " &_
                    "  pv.pkg_version, " &_
                    "  pv.v_ext, " &_
                    "  pv.pv_description, " &_
                    "  lcs.name AS licenceName , " &_
                    "  CASE " &_
                    "    WHEN al.NAME  IS NOT NULL " &_
                    "    AND lcs.name  IS NOT NULL " &_
                    "    AND ( lcs.name = al.NAME ) " &_
                    "    THEN NULL " &_
                    "    ELSE al.NAME " &_
                    "  END AS OTHERLICENSES " &_
                    "FROM AllPvIDs rc, " &_
                    "  package_versions pv, " &_
                    "  packages pkg, " &_
                    "  licencing lcng, " &_
                    "  licences lcs, " &_
                    "  AllPkgLic al " &_
                    "WHERE pv.pv_id   = rc.pv_id " &_
                    "AND pkg.pkg_id   = pv.pkg_id " &_
                    "AND pv.pv_id     = lcng.pv_id (+) " &_
                    "AND lcng.licence = lcs.licence (+) " &_
                    "AND pv.pkg_id    = al.pkg_id(+) " &_
                    "AND ( " &_
                        "(lcng.licence is not null) OR ('" & bShowAll & "' is not null)" &_
                        " OR ( (al.name is not null) AND ('" & bShowAny & "' is not null) )" &_
                        " OR ((UPPER(pv.v_ext) = '.COTS') AND ('" & bAllCots & "' is not null))" &_
                    ") " &_
                    "ORDER BY Upper( pkg.pkg_name), " &_
                    "  Upper(pv.pkg_version) "
End Function


'--------------------------------------------------------------------------------------------------------------------------
'  PV_ID_ListHTML
'
'  DESCRIPTION
'     Constructs the HTML to render the rows of package names, versions and extensions, and licences
'
Sub PV_ID_ListHTML
   Dim rsQry
   Dim hRef
   Dim pkgVer

   OraDatabase.Parameters.Add "RTAG_ID", parRtag_Id, ORAPARM_INPUT, ORATYPE_NUMBER
   Set rsQry = OraDatabase.DbCreateDynaset( release_licencing_query_string(parRtag_Id), cint(0) )
   OraDatabase.Parameters.Remove "PV_ID"

   '--- Render rows ---
   Do While (NOT rsQry.BOF) AND (NOT rsQry.EOF)

      ' BEGIN ROW
      Response.Write "<tr class='csvData body_rowg top'>"

      ' PACKAGE NAME
      hRef = "view_by_version.asp?pkg_id=" & rsQry("pkg_id")
      Response.Write "<td>"
      Response.Write "<a href=" & hRef & ">" & rsQry("pkg_name")&"</a>"
      Response.Write "</td>"

      ' PACKAGE VERSION
      hRef = "dependencies.asp?pv_id=" & rsQry("pv_id") & "&rtag_id=" & parRtag_Id
      If IsNull(rsQry("v_ext")) Then
         pkgVer = rsQry("pkg_version")
      Else
         pkgVer = Left(rsQry("pkg_version"), Len(rsQry("pkg_version")) - Len(rsQry("v_ext")) )
      End If
      Response.Write "<td><a href=" & hRef & ">" & pkgVer & "</a></td>"

      ' PACKAGE EXTENSION
      Response.Write "<td>" & rsQry("v_ext") & "</td>"

      ' PACKAGE Short Description
      Response.Write "<td>" & rsQry("pv_description") & "</td>"

      ' LICENCE NAME
      Response.Write "<td>" & rsQry("licenceName") & "</td>"

      ' Other Licences
      Response.Write "<td>" & rsQry("otherlicenses") & "</td>"

      ' Edit License
      BuildActionButtonClick canActionControlInProject ("EditPackageLicence") OR canActionControl("MSMaintainer"),_
            "", "Edit License", false, _
            "src='images/i_edit.gif' width='12' height='12' border='0'", _
            "MM_openVixIFrame('_wform_change_licence.asp?pv_id="& rsQry("pv_id") &"&rtag_id="& parRtag_id &"','Change License')"

      ' END ROW
      Response.Write "</tr>"

      rsQry.MoveNext
   Loop

   ' destroy objects
   rsQry.Close()
   Set rsQry = nothing

End Sub

'--------------------------------------------------------------------------------------------------------------------------
Sub LeftPanelContent
   objFormComponent.FormName = "FormName"
   objFormComponent.Method = "get"
   objFormComponent.Action = ScriptName
   Call objFormComponent.FormStart()
%>

<fieldset class="body_rowg fset">
    <legend>Options</legend>
        <input name="showAny" type="checkbox" class="form_btn" <%=sAnyCheck%> value=1 onChange="this.form.submit()">Show Any<%=Quick_Help("h_showAny")%>
    <br><input name="allCots" type="checkbox" class="form_btn" <%=sAllCots%>  value=1 onChange="this.form.submit()">Show All COTS<%=Quick_Help("h_allCots")%>
    <br><input name="showAll" type="checkbox" class="form_btn" <%=sAllCheck%> value=1 onChange="this.form.submit()">Show All<%=Quick_Help("h_showAll")%>
    <br><input name="rtag_id" type="hidden" value=<%=parRtag_Id%>
</fieldset>
   <%
   Call objFormComponent.FormEnd()
   '-- FROM END ----------------------------------------------------------------------------------------------------------------
   %>
<%
End Sub
'----------------------------------------------
Sub MainPanelContent
%>
   <table class="embedded_table" style="margin-bottom:20px" width="90%">
      <tr>
         <td>
            <!-- Box Title -->
            <div class="form_ttl nowrap" align="left">
                 VIEW RELEASE LICENCING DETAILS
            </div>
         </td>
      </tr>
      <tr>
         <td>
            <!-- Box Content -->
            <div class="rounded_box">
               <div style="background-color: white;border-left: white solid 10px;border-right: white solid 10px;">
                    <!-- MESSAGE +++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                    <!--#include file="messages/_msg_inline.asp"-->
                    <!-- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -->
                    <table width="100%" class="embedded_table etable underline" id='pkgLicences'>
                        <thead class="body_hcol">
                            <tr>
                              <th valign="top" nowrap >Package Name</th>
                              <th valign="top" nowrap >Package Version</th>
                              <th valign="top" nowrap >Package Extension</th>
                              <th valign="top"        >Short Description</th>
                              <th valign="top" nowrap >Licences<%=Quick_Help("h_licences")%></th>
                              <th valign="top" nowrap >Other Licences<%=Quick_Help("h_other")%></th>
                              <th valign="top" nowrap class="noCsv">Edit</th>
                           </tr>
                        </thead>
                        <tbody>
                           <%Call PV_ID_ListHTML%>
                        </tbody>
                    </table>
               </div>
            </div>
         </td>
      </tr>
   </table>
<%
End Sub
'------------------------------------------------------------------------------
%>
<html>
   <head>
      <title>Release Manager</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>
      <script language="JavaScript" src="scripts/remote_scripting.js?ver=<%=VixVerNum%>"></script>
      <!-- DROPDOWN MENUS -->
      <%bJqueryDataTables = TRUE%>
      <%bCsvExport = True%>
      <!--#include file="_jquery_includes.asp"-->
      <!--#include file="_menu_def.asp"-->
      <script language="JavaScript1.2" src="images/popup_menu.js?ver=<%=VixVerNum%>"></script>
<!-- TIPS -->
<script language="JavaScript" src="images/tipster.js?ver=<%=VixVerNum%>"></script>
<script language="JavaScript" src="images/_help_tips.js?ver=<%=VixVerNum%>"></script>
<script language="JavaScript" type="text/javascript">
<!--
formTips.tips.h_licences       = stdTip(300, 'License', 'A list of licences found on this version of this package' +
                                                          '<p>Licences are specified for a specific version of a package.' + 
                                                          '<p>A package may have several licences and the packages licences may change over time.' 
                                                          );
formTips.tips.h_other       = stdTip(300, 'Other License', 'A list of licences found in others versions of this package, if they differ from the one specified' +
                                                          'for this package.' +
                                                          '<p>Licences are specified for a specific version of a package.' + 
                                                          '<p>A package may have several licences and the packages licences may change over time.' 
                                                          );

formTips.tips.h_showAny       = stdTip(300, 'Show Any', 'Show packages, in this Release, that have a licence in any release, not just this release.');
formTips.tips.h_showAll       = stdTip(300, 'Show All', 'Show all packages in this Release, not just those with a licence.');
formTips.tips.h_allCots       = stdTip(300, 'All COTS', 'Force the inclusion of COTS packages as these should have licencing information.');
</script>
<script language="JavaScript" type="text/javascript">
	$(document).ready(function() {
		/* Init DataTables */

        table = $("#pkgLicences").DataTable({
            "paging":   false,
            "info":     true,
            dom: "frti",
            ordering: true,
            order: [[ 0, "asc" ]],
            lengthChange : false,

            columns: [
               { width: "5%", className: "dt-nowrap"},
               { width: "5%", className: "dt-nowrap"},
               { width: "1%", className: "dt-nowrap"  },
               { orderable: false, searchable: false },
               { className: "dt-nowrap" },
               { width: "1%", orderable: true, className: "dt-nowrap" },
               { width: "40px", orderable: false, searchable: false },
           ],
        });
    });
</script>
   </head>
   <body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0">
      <!-- HEADER -->
      <!--#include file="_header.asp"-->
      <!-- BODY ---->
      <table class="full_table">
         <tr>
            <td width="146px" class="bg_panel" valign="top">
                <%Call LeftPanelContent%>
            </td>
            <td width="100%" rowspan="2" align="center" valign="top" bgcolor="#EEEFEF">
                <%Call MainPanelContent%>
            </td>
         </tr>
         <tr>
            <td class="bg_panel_btm" height="350">
                <img src="images/img_padlock.png" vspace="20" hspace="30"></td>
         </tr>
      </table>
      <!-- FOOTER -->
      <!--#include file="_footer.asp"-->
   </body>
</html>