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/users

Free Space:

10.18 TB

🔧 Quick Actions

✏️ Editing: purchases.php

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

require_once __DIR__ . '/../includes/config.php';

if (empty($_SESSION['user']['id'])) {
  header('Location: /login.php');
  exit;
}

$conn = db();
$u    = $_SESSION['user'];
$uid  = (int)$u['id'];

/* ===================== Helpers ===================== */
if (!function_exists('esc')) {
  function esc($s){ return htmlspecialchars((string)$s, ENT_QUOTES, 'UTF-8'); }
}
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, '/');
}

/** Confirm this user purchased a given book id */
function user_owns_book(mysqli $conn, int $uid, int $bookId): bool {
  $sql = 'SELECT 1
          FROM orders o
          JOIN order_items oi ON oi.order_id = o.id
          WHERE o.user_id = ? AND oi.book_id = ?
          LIMIT 1';
  $stmt = $conn->prepare($sql);
  $stmt->bind_param('ii', $uid, $bookId);
  $stmt->execute();
  $owns = (bool)$stmt->get_result()->fetch_row();
  $stmt->close();
  return $owns;
}

/* ===================== Data Loading ===================== */

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

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

$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 = ?
');
$stmt->bind_param('i', $uid);
$stmt->execute();
$stats['items'] = (int)($stmt->get_result()->fetch_assoc()['qty'] ?? 0);
$stmt->close();

$stmt = $conn->prepare('SELECT COALESCE(SUM(total),0) AS amt FROM orders WHERE user_id=?');
$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 = ?
  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>
  <?php include __DIR__ . '/includes/head.php'; ?>
  
  <script src="https://cdnjs.cloudflare.com/ajax/libs/pdf.js/3.4.120/pdf.min.js"></script>
  <style>
    .user-sidebar a { display:block; padding:10px 16px; color:#c9d1d9; text-decoration:none; border-radius:6px; }
    .user-sidebar a:hover { background: rgba(255,255,255,.07); color:#fff; }
    .user-sidebar .menu-title { padding: 12px 16px; font-size:12px; text-transform:uppercase; opacity:.7; }
    .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: white;
    }
  </style>
</head>
<body data-sidebar="dark" class="no-select">
<?php include __DIR__ . '/includes/pre-loader.php'; ?>

<div class="vertical-menu">
    <div data-simplebar class="h-100">
      <div id="sidebar-menu">
        <ul class="metismenu list-unstyled user-sidebar" id="side-menu">
          <li class="menu-title">Account</li>
          <li><a href="/users/books.php"><i class="dripicons-device-desktop"></i> <span>My Books</span></a></li>
          <li><a href="/users/profile.php"><i class="dripicons-user"></i> <span>My Profile</span></a></li>
          <li><a href="/logout.php"><i class="dripicons-exit"></i> <span>Logout</span></a></li>
        </ul>
      </div>
    </div>
  </div>

<div class="row">
          <div class="col-md-12">
            <div class="card">
              <div class="card-body d-md-flex align-items-center justify-content-between">
                <div>
                  <h4 class="card-title mb-1">Hi, <?= esc($u['full_name'] ?? ($u['email'] ?? 'Reader')) ?> 👋</h4>
                  <p class="text-muted mb-0">Your available (purchased) eBooks.</p>
                </div>
                <?php if (!empty($latestOrder)): ?>
                <div class="text-end mt-3 mt-md-0">
                  <div class="text-muted small">Last Order</div>
                  <div class="fw-bold"><?= esc($latestOrder['order_code']) ?></div>
                  <div class="small">
                    <?= esc(date('d M Y, h:i A', strtotime($latestOrder['created_at']))) ?> ·
                    <span class="badge bg-<?= in_array($latestOrder['status'],['paid','completed']) ? 'success' : ($latestOrder['status']==='pending' ? 'warning' : 'secondary') ?>">
                      <?= esc(ucfirst($latestOrder['status'])) ?>
                    </span>
                  </div>
                </div>
                <?php endif; ?>
              </div>
            </div>
          </div>
        </div>

<div class="row">
          <div class="col-md-6 col-xl-4">
            <div class="card text-center"><div class="mb-2 card-body text-muted">
              <h3 class="text-primary mt-2"><?= (int)$stats['orders'] ?></h3> Total Orders
            </div></div>
          </div>
          <div class="col-md-6 col-xl-4">
            <div class="card text-center"><div class="mb-2 card-body text-muted">
              <h3 class="text-info mt-2"><?= (int)$stats['items'] ?></h3> Total Items
            </div></div>
          </div>
          <div class="col-md-6 col-xl-4">
            <div class="card text-center"><div class="mb-2 card-body text-muted">
              <h3 class="text-success mt-2"><?= esc(inr($stats['spent'])) ?></h3> Total Spent
            </div></div>
          </div>
        </div>

<div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-body">
                <h4 class="card-title mb-3">My Purchased Books</h4>

<?php if (empty($purchasedBooks)): ?>
                  <div class="text-muted">No purchases yet. <a href="/" class="fw-semibold">Browse eBooks</a></div>
                <?php else: ?>
                  <div class="row">
                    <?php foreach ($purchasedBooks as $bk): ?>
                      <div class="col-sm-6 col-lg-4 col-xl-3 mb-3">
                        <div class="ebook-card p-3 border rounded">
                          <img class="thumb mb-2" src="<?= esc(file_url((string)$bk['thumbnail_path'])) ?>" alt="<?= esc($bk['name']) ?>">
                          <div class="fw-semibold mb-1" title="<?= esc($bk['name']) ?>" style="min-height:40px;"><?= esc($bk['name']) ?></div>
                          <div class="small text-muted mb-2">
                            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>
                      </div>
                    <?php endforeach; ?>
                  </div>
                <?php endif; ?>

</div>
            </div>
          </div>
        </div>

</div>
    </div>

<?php include __DIR__ . '/includes/footer.php'; ?>
  </div>
</div>

<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>

<?php include __DIR__ . '/includes/rightbar.php'; ?>
<?php include __DIR__ . '/includes/scripts.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: purchases.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation