Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/college/store

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: profile.php

<?php
declare(strict_types=1);
session_start();

include('config.php');

// Check if user is logged in
if (empty($_SESSION['user_id'])) {
  header('Location: login.php');
  exit;
}

$conn = db();
$uid  = (int)$_SESSION['user_id'];

// Get user details
$stmt = $conn->prepare("SELECT * FROM users WHERE id = ?");
$stmt->bind_param('i', $uid);
$stmt->execute();
$user = $stmt->get_result()->fetch_assoc();
$stmt->close();

if (!$user) {
  session_destroy();
  header('Location: login.php');
  exit;
}

/* ===================== Helpers ===================== */
function inr($n): string { return '₹' . number_format((float)$n, 0, '.', ','); }

/** Prefix DB relative paths with admin/ */
function file_url(string $p): string {
  $p = trim($p);
  if ($p === '') return '#';
  if (preg_match('~^https?://~i', $p)) return $p;
  return 'admin/' . ltrim($p, '/');
}

/* Quick stats */
$stats = ['orders'=>0, 'items'=>0, 'spent'=>0.0];

// Count completed orders
$stmt = $conn->prepare('SELECT COUNT(*) AS c FROM orders WHERE user_id=? AND status="Completed"');
$stmt->bind_param('i', $uid);
$stmt->execute();
$stats['orders'] = (int)($stmt->get_result()->fetch_assoc()['c'] ?? 0);
$stmt->close();

// Count purchased items (from completed orders)
$stmt = $conn->prepare('
  SELECT COALESCE(SUM(oi.qty),0) AS qty
  FROM order_items oi
  JOIN orders o ON o.id = oi.order_id
  WHERE o.user_id = ? AND o.status="Completed"
');
$stmt->bind_param('i', $uid);
$stmt->execute();
$stats['items'] = (int)($stmt->get_result()->fetch_assoc()['qty'] ?? 0);
$stmt->close();

// Total spent (from completed orders)
$stmt = $conn->prepare('SELECT COALESCE(SUM(total),0) AS amt FROM orders WHERE user_id=? AND status="Completed"');
$stmt->bind_param('i', $uid);
$stmt->execute();
$stats['spent'] = (float)($stmt->get_result()->fetch_assoc()['amt'] ?? 0.0);
$stmt->close();

/* Purchased books list (available to read) */
$stmt = $conn->prepare('
 SELECT 
    b.id, 
    b.name, 
    b.slug, 
    b.thumbnail_path, 
    b.pdf_path,
    MIN(o.created_at) AS first_purchased_at,
    SUM(oi.qty) AS total_qty
FROM orders o
JOIN order_items oi ON oi.order_id = o.id
JOIN books b ON b.id = oi.book_id
WHERE o.user_id = ?
  AND o.status = "Completed"
GROUP BY 
    b.id, b.name, b.slug, b.thumbnail_path, b.pdf_path
ORDER BY MAX(o.id) DESC;

');
$stmt->bind_param('i', $uid);
$stmt->execute();
$purchasedBooks = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();

/* Latest order (for header) */
$stmt = $conn->prepare('
  SELECT id, order_code, status, total, created_at
  FROM orders
  WHERE user_id=?
  ORDER BY id DESC
  LIMIT 1
');
$stmt->bind_param('i', $uid);
$stmt->execute();
$latestOrder = $stmt->get_result()->fetch_assoc() ?: null;
$stmt->close();
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8" />
  <meta name="viewport" content="width=device-width, initial-scale=1" />
  <title>Profile - Narumalar Academy</title>
  <link rel="apple-touch-icon" sizes="180x180" href="assets/fav/apple-touch-icon.png">
  <link rel="icon" type="image/png" sizes="32x32" href="assets/fav/favicon-32x32.png">
  <link rel="icon" type="image/png" sizes="16x16" href="assets/fav/favicon-16x16.png">
  <link rel="manifest" href="assets/fav/site.webmanifest">
  <meta name="theme-color" content="#0d6efd" />
  <meta name="description" content="Your Narumalar Academy profile" />
  
  <script src="https://cdn.tailwindcss.com"></script>
  <script>
    tailwind.config = {
      theme: {
        extend: {
          colors: {
            dpigreen: '#dc5318ff',
            dpidark: '#0f172a'
          },
          fontFamily: {
            display: ['Inter', 'ui-sans-serif', 'system-ui', 'sans-serif']
          }
        }
      }
    }
  </script>
  <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
  <link href="https://fonts.googleapis.com/css2?family=Inter:wght@400;600;700;800&display=swap" rel="stylesheet">
  
  <script src="https://cdnjs.cloudflare.com/ajax/libs/pdf.js/3.4.120/pdf.min.js"></script>
  <style>
    .ebook-card .thumb { width:100%; height:160px; object-fit:cover; border-radius:8px; }
    .read-btn { background: #0d6efd; color: white; padding: 8px 16px; border-radius: 6px; text-decoration: none; display: inline-block; margin-top: 10px; }
    .read-btn:hover { background: #0b5ed7; color: white; }
    
    /* PDF Viewer Modal Styles */
    .pdf-modal { display: none; position: fixed; z-index: 1050; left: 0; top: 0; width: 100%; height: 100%; overflow: auto; background-color: rgba(0,0,0,0.9); }
    .pdf-modal-content { position: relative; margin: auto; padding: 0; width: 95%; height: 95%; margin-top: 20px; }
    .pdf-modal-header { padding: 10px 16px; background: #343a40; color: white; display: flex; justify-content: space-between; align-items: center; }
    .pdf-modal-body { height: calc(100% - 100px); position: relative; }
    .pdf-controls { padding: 10px; background: #f8f9fa; display: flex; justify-content: center; gap: 10px; }
    .pdf-controls button { padding: 5px 15px; border: 1px solid #ddd; background: white; border-radius: 4px; cursor: pointer; }
    .pdf-controls button:hover { background: #e9ecef; }
    .pdf-viewer-container { width: 100%; height: 100%; overflow: auto; background: #525659; position: relative; }
    .pdf-canvas { display: block; margin: 0 auto; box-shadow: 0 2px 10px rgba(0,0,0,0.3); }
    .close-pdf { color: white; font-size: 28px; font-weight: bold; cursor: pointer; }
    .close-pdf:hover { color: #ccc; }
    
    /* Disable text selection */
    .no-select {
      -webkit-user-select: none;
      -moz-user-select: none;
      -ms-user-select: none;
      user-select: none;
    }
    
    /* Watermark */
    .watermark {
      position: absolute;
      opacity: 0.1;
      font-size: 40px;
      color: red;
      pointer-events: none;
      z-index: 100;
      transform: rotate(-45deg);
      white-space: nowrap;
    }
    
    /* Loading indicator */
    .pdf-loading {
      position: absolute;
      top: 50%;
      left: 50%;
      transform: translate(-50%, -50%);
      color: white;
      font-size: 20px;
    }
    
    /* Page navigation */
    .page-navigation {
      display: flex;
      align-items: center;
      justify-content: center;
      gap: 10px;
      margin-top: 10px;
      color: black;
    }
  </style>
</head>
<body class="font-display text-slate-800 bg-slate-50 no-select">
  
  <?php include('includes/topstrip.php'); ?>

<?php include('includes/header.php'); ?>

<section class="py-12 bg-slate-50">
    <div class="container mx-auto px-4">
      
      <div class="mb-8">
        <div class="bg-white rounded-lg shadow-md p-6">
          <div class="flex flex-col md:flex-row items-center justify-between">
            <div>
              <h1 class="text-2xl font-bold mb-1">Hi, <?= esc($user['full_name'] ?? ($user['email'] ?? 'Reader')) ?> 👋</h1>
              <p class="text-gray-600">Your available (purchased) eBooks.</p>
            </div>
            <?php if (!empty($latestOrder)): ?>
            <div class="text-center md:text-right mt-4 md:mt-0">
              <div class="text-gray-500 text-sm">Last Order</div>
              <div class="font-bold"><?= esc($latestOrder['order_code']) ?></div>
              <div class="text-sm">
                <?= esc(date('d M Y, h:i A', strtotime($latestOrder['created_at']))) ?> ·
                <span class="inline-block px-2 py-1 rounded text-xs 
                  <?= in_array($latestOrder['status'],['paid','completed']) ? 'bg-green-100 text-green-800' : 
                     ($latestOrder['status']==='pending' ? 'bg-yellow-100 text-yellow-800' : 'bg-gray-100 text-gray-800') ?>">
                  <?= esc(ucfirst($latestOrder['status'])) ?>
                </span>
              </div>
            </div>
            <?php endif; ?>
          </div>
        </div>
      </div>

<div class="grid grid-cols-1 md:grid-cols-3 gap-6 mb-8">
        <div class="bg-white rounded-lg shadow-md text-center p-6">
          <h3 class="text-2xl font-bold text-blue-600 mb-1"><?= (int)$stats['orders'] ?></h3>
          <p class="text-gray-600">Total Orders</p>
        </div>
        <div class="bg-white rounded-lg shadow-md text-center p-6">
          <h3 class="text-2xl font-bold text-blue-600 mb-1"><?= (int)$stats['items'] ?></h3>
          <p class="text-gray-600">Total Items</p>
        </div>
        <div class="bg-white rounded-lg shadow-md text-center p-6">
          <h3 class="text-2xl font-bold text-blue-600 mb-1"><?= inr($stats['spent']) ?></h3>
          <p class="text-gray-600">Total Spent</p>
        </div>
      </div>

<div class="bg-white rounded-lg shadow-md p-6">
        <h2 class="text-xl font-bold mb-4">My Purchased Books</h2>

<?php if (empty($purchasedBooks)): ?>
          <div class="text-gray-600 text-center py-8">
            No purchases yet. <a href="index.php" class="text-dpigreen font-semibold hover:underline">Browse eBooks</a>
          </div>
        <?php else: ?>
          <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-3 xl:grid-cols-4 gap-6">
            <?php foreach ($purchasedBooks as $bk): ?>
              <div class="ebook-card border rounded-lg p-4">
                <img class="thumb mb-3" src="<?= esc(file_url((string)$bk['thumbnail_path'])) ?>" alt="<?= esc($bk['name']) ?>">
                <h3 class="font-semibold mb-1" title="<?= esc($bk['name']) ?>" style="min-height: 40px;"><?= esc($bk['name']) ?></h3>
                <div class="text-gray-500 text-sm mb-3">
                  Purchased: <?= esc(date('d M Y', strtotime((string)$bk['first_purchased_at']))) ?> · Qty: <?= (int)$bk['total_qty'] ?>
                </div>
                <a href="#" 
                  class="read-btn view-pdf" 
                  data-pdf="<?= esc(file_url((string)$bk['pdf_path'])) ?>"
                  data-title="<?= esc($bk['name']) ?>">
                  Read Now
                </a>
              </div>
            <?php endforeach; ?>
          </div>
        <?php endif; ?>
      </div>
    </div>
  </section>

<?php include('includes/footer.php'); ?>

<div id="pdfModal" class="pdf-modal">
    <div class="pdf-modal-content">
      <div class="pdf-modal-header">
        <h5 id="pdfModalTitle">PDF Document</h5>
        <span class="close-pdf">&times;</span>
      </div>
      <div class="pdf-modal-body">
        <div class="pdf-controls">
          <button id="prevPage"><</button>
          <span class="page-navigation">Page: <span id="pageNum">1</span> / <span id="pageCount">0</span></span>
          <button id="nextPage">></button>
          <button id="zoomOut">-</button>
          <button id="zoomIn">+</button>
        </div>
        <div class="pdf-viewer-container">
          <div class="pdf-loading">Loading PDF...</div>
          <canvas id="pdfCanvas" class="pdf-canvas"></canvas>
          <div id="watermark" class="watermark"></div>
        </div>
      </div>
    </div>
  </div>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: profile.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation