<!--#include file="./includes/sql.asp"-->
<%
	' Get and validate appid
	Dim appid
	appid = Request.Querystring("appid")

	' Basic validation - must be numeric and positive
	If Not IsNumeric(appid) Or CLng(appid) < 1 Then
		Response.Redirect("displayknowledgebase.asp")
		Response.End
	End If

	' Get the application name
	Dim strSQL, rsApp
	strSQL = "SELECT appid, appname FROM applications WHERE appid = " & CLng(appid) & " AND isactive = 1"
	Set rsApp = objConn.Execute(strSQL)

	If rsApp.EOF Then
		rsApp.Close
		Set rsApp = Nothing
		objConn.Close
		Response.Redirect("displayknowledgebase.asp")
		Response.End
	End If

	Dim appname
	appname = rsApp("appname")
	rsApp.Close
	Set rsApp = Nothing
%>
<!DOCTYPE html>
<html lang="en">
<head>
  <!--#include file="./includes/header.asp"-->
</head>

<%
	Dim theme
	theme = Request.Cookies("theme")
	IF theme = "" THEN
		theme="bg-theme1"
	END IF
%>
<body class="bg-theme <%Response.Write(theme)%>">

<!-- start loader -->
   <div id="pageloader-overlay" class="visible incoming"><div class="loader-wrapper-outer"><div class="loader-wrapper-inner" ><div class="loader"></div></div></div></div>
   <!-- end loader -->
<!-- Start wrapper-->
 <div id="wrapper">
  <!--#include file="./includes/leftsidebar.asp"-->
<!--Start topbar header-->
  <!--#include file="./includes/topbarheader.asp"-->
<!--End topbar header-->
<div class="clearfix"></div>

  <div class="content-wrapper">
    <div class="container-fluid">

      <div class="row mt-3">
        <div class="col-xl-auto">
          <div class="card">
            <div class="card-body">
              <div style="margin-bottom:20px;">
                <div style="display:flex; justify-content:space-between; align-items:center; margin-bottom:15px;">
                  <h5 class="card-title" style="margin:0;">
                    <i class="zmdi zmdi-book"></i> Knowledge Base: <%=Server.HTMLEncode(appname)%>
                  </h5>
                  <button class="btn btn-sm btn-primary" onclick="shareApplication()" title="Share this application">
                    <i class="zmdi zmdi-share"></i> Share
                  </button>
                </div>
                <div style="display:flex; gap:10px; flex-wrap:wrap;">
                  <a href="./displayapplication.asp?appid=<%=appid%>" class="btn btn-info">
                    <i class="zmdi zmdi-info"></i> View Application
                  </a>
                  <a href="./displayknowledgebase.asp" class="btn btn-secondary">
                    <i class="zmdi zmdi-arrow-left"></i> Back to All Articles
                  </a>
                </div>
              </div>

			  <div class="table-responsive">
              <table class="table table-hover">
                <thead>
                  <tr>
                    <th scope="col">Description</th>
                    <th scope="col">Clicks</th>
                    <th scope="col">Last Updated</th>
                  </tr>
                </thead>
                <tbody>

<%
	Dim rs
	strSQL = "SELECT kb.* " &_
			"FROM knowledgebase kb " &_
			"WHERE kb.appid = " & CLng(appid) & " AND kb.isactive = 1 " &_
			"ORDER BY kb.lastupdated DESC"

	Set rs = objconn.Execute(strSQL)

	If rs.EOF Then
		Response.Write("<tr><td colspan='3' class='text-center text-muted'>No articles found for this topic.</td></tr>")
	Else
		Do While Not rs.EOF
			Response.Write("<tr>")
			Response.Write("<td><a href='./displayknowledgearticle.asp?linkid=" & rs("linkid") & "' title='" & Server.HTMLEncode(rs("linkurl") & "") & "'>" & Server.HTMLEncode(rs("shortdescription")) & "</a></td>")
			Response.Write("<td>" & rs("clicks") & "</td>")
			Response.Write("<td>" & rs("lastupdated") & "</td>")
			Response.Write("</tr>")
			rs.MoveNext
		Loop
	End If

	rs.Close
	Set rs = Nothing
	objConn.Close
%>
                </tbody>
              </table>
            </div>
            </div>
          </div>
        </div>
      </div><!--End Row-->

    <!-- End container-fluid-->

    </div><!--End content-wrapper-->
   <!--Start Back To Top Button-->
    <a href="javaScript:void();" class="back-to-top"><i class="fa fa-angle-double-up"></i> </a>
    <!--End Back To Top Button-->

	<!--Start footer-->
	<footer class="footer">
      <div class="container">
        <div class="text-center">
        </div>
      </div>
    </footer>
	<!--End footer-->

  </div><!--End wrapper-->


  <!-- Bootstrap core JavaScript-->
  <script src="assets/js/jquery.min.js"></script>
  <script src="assets/js/popper.min.js"></script>
  <script src="assets/js/bootstrap.min.js"></script>

  <!-- simplebar js -->
  <script src="assets/plugins/simplebar/js/simplebar.js"></script>
  <!-- sidebar-menu js -->
  <script src="assets/js/sidebar-menu.js"></script>

  <!-- Custom scripts -->
  <script src="assets/js/app-script.js"></script>

  <style>
  /* Share toast notification */
  #shareToast {
    position: fixed;
    top: 80px;
    right: 20px;
    z-index: 9999;
    min-width: 300px;
    background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
    color: white;
    padding: 15px 20px;
    border-radius: 8px;
    box-shadow: 0 4px 20px rgba(0,0,0,0.3);
    display: none;
  }
  @keyframes toastSlideIn {
    from { transform: translateX(100%); opacity: 0; }
    to { transform: translateX(0); opacity: 1; }
  }
  @keyframes toastSlideOut {
    from { transform: translateX(0); opacity: 1; }
    to { transform: translateX(100%); opacity: 0; }
  }
  </style>

  <!-- Share toast notification -->
  <div id="shareToast">
    <div style="display: flex; align-items: center;">
      <i class="zmdi zmdi-check-circle" style="font-size: 24px; margin-right: 12px;"></i>
      <div>
        <strong style="display: block; margin-bottom: 5px;">Link Copied!</strong>
        <span style="font-size: 13px; opacity: 0.9;">This link will show the search term and highlight the result</span>
      </div>
    </div>
  </div>

  <script>
  function shareApplication() {
    var shareUrl = window.location.href;

    var temp = document.createElement('textarea');
    temp.value = shareUrl;
    temp.style.position = 'fixed';
    temp.style.left = '-9999px';
    document.body.appendChild(temp);
    temp.select();
    document.execCommand('copy');
    document.body.removeChild(temp);

    showToast();
  }

  function showToast() {
    var toast = document.getElementById('shareToast');
    toast.style.display = 'block';
    toast.style.animation = 'toastSlideIn 0.3s ease-out';

    setTimeout(function() {
      toast.style.animation = 'toastSlideOut 0.3s ease-out';
      setTimeout(function() {
        toast.style.display = 'none';
      }, 300);
    }, 2500);
  }
  </script>

</body>
</html>
