Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-513.24.1.lve.el8.x86_64

PHP Version:

8.2.23

User:

aptodayn

Directory:

/home/aptodayn/uturntime.com

Free Space:

1.4 TB

🔧 Quick Actions

✏️ Editing: epaper_archive.php

<?php
// /janasena/epaper_archive.php
require_once __DIR__ . '/config.php';

function h($s) { return htmlspecialchars($s, ENT_QUOTES, 'UTF-8'); }

$pageTitle = "ePaper Archive - Jana Sena News";
include 'header.php';

// ---------- GET ALL YEARS AVAILABLE ----------
$yearRows = [];
$yRes = $conn->query("
    SELECT DISTINCT YEAR(published_date) AS y
    FROM epapers
    WHERE is_active = 1
    ORDER BY y DESC
");
if ($yRes) {
    while ($r = $yRes->fetch_assoc()) {
        $yearRows[] = (int)$r['y'];
    }
}

// Selected year → default latest year
$year = isset($_GET['year']) ? (int)$_GET['year'] : ($yearRows[0] ?? date('Y'));
if (!$year) { $year = date('Y'); }

// ---------- GET MONTHS IN SELECTED YEAR ----------
$monthRows = [];
$mStmt = $conn->prepare("
    SELECT DISTINCT MONTH(published_date) AS m
    FROM epapers
    WHERE is_active = 1 AND YEAR(published_date) = ?
    ORDER BY m ASC
");
$mStmt->bind_param("i", $year);
$mStmt->execute();
$mRes = $mStmt->get_result();
while ($r = $mRes->fetch_assoc()) {
    $monthRows[] = (int)$r['m'];
}
$mStmt->close();

// Selected month → default latest month in that year
$month = isset($_GET['month']) ? (int)$_GET['month'] : (end($monthRows) ?: date('n'));

// ---------- GET ALL DAYS WITH EPAPER IN THIS MONTH ----------
$days = [];
$dStmt = $conn->prepare("
    SELECT DISTINCT DAY(published_date) AS d
    FROM epapers
    WHERE is_active = 1
      AND YEAR(published_date) = ?
      AND MONTH(published_date) = ?
    ORDER BY d ASC
");
$dStmt->bind_param("ii", $year, $month);
$dStmt->execute();
$dRes = $dStmt->get_result();
while ($r = $dRes->fetch_assoc()) {
    $days[] = (int)$r['d'];
}
$dStmt->close();

// Month name
$monthName = date("F", mktime(0, 0, 0, $month, 1));
?>

.ep-arch-title {
    font-size:1.6rem;
    font-weight:700;
    margin-bottom:12px;
    text-align:center;
}

.ep-arch-year-select {
    text-align:center;
    margin-bottom:20px;
}

.ep-arch-year-select select {
    padding:6px 12px;
    font-size:1rem;
    border-radius:6px;
    border:1px solid #d1d5db;
}

.ep-arch-months {
    display:flex;
    justify-content:center;
    flex-wrap:wrap;
    gap:10px;
    margin-bottom:25px;
}

.ep-arch-month-btn {
    padding:8px 14px;
    border-radius:999px;
    background:#e5e7eb;
    color:#111827;
    text-decoration:none;
    font-weight:600;
}

.ep-arch-month-btn.active {
    background:#052962;
    color:#ffe500;
}

.ep-arch-calendar {
    max-width:500px;
    margin:0 auto;
    text-align:center;
}

.ep-arch-grid {
    display:grid;
    grid-template-columns:repeat(7, 1fr);
    gap:8px;
    margin-top:12px;
}

.ep-arch-day {
    padding:10px 0;
    background:#f3f4f6;
    border-radius:6px;
    font-weight:600;
}

.ep-arch-day.has {
    background:#052962;
    color:#ffe500;
    cursor:pointer;
}

.ep-arch-day.has:hover {
    background:#063b88;
}

.ep-arch-weekday {
    font-weight:700;
    color:#6b7280;
}
</style>

<h1 class="ep-arch-title">ePaper Archive</h1>

<div class="ep-arch-year-select">
        <form method="get" id="yearForm">
            <select name="year" onchange="document.getElementById('yearForm').submit()">
                <?php foreach ($yearRows as $y): ?>
                    <option value="<?= $y ?>" <?= $y == $year ? 'selected':'' ?>>
                        <?= $y ?>
                    </option>
                <?php endforeach; ?>
            </select>
        </form>
    </div>

<div class="ep-arch-months">
        <?php foreach ($monthRows as $m): ?>
            <a href="epaper_archive.php?year=<?= $year ?>&month=<?= $m ?>"
               class="ep-arch-month-btn <?= $m == $month ? 'active':'' ?>">
               <?= date("M", mktime(0,0,0,$m,1)) ?>
            </a>
        <?php endforeach; ?>
    </div>

<div class="ep-arch-calendar">

<div class="ep-arch-grid">
            <?php foreach (["Sun","Mon","Tue","Wed","Thu","Fri","Sat"] as $wd): ?>
                <div class="ep-arch-weekday"><?= $wd ?></div>
            <?php endforeach; ?>
        </div>

<?php
        // Generate calendar grid
        $firstDay = date('w', strtotime("$year-$month-01"));
        $totalDays = date('t', strtotime("$year-$month-01"));
        ?>

<?php for ($d=1; $d <= $totalDays; $d++): ?>
                <?php
                    $hasPaper = in_array($d, $days);
                    $goDate = "$year-$month-" . str_pad($d,2,'0',STR_PAD_LEFT);
                ?>
                <?php if ($hasPaper): ?>
                    <div class="ep-arch-day has"
                         onclick="window.location='epaper.php?date=<?= $goDate ?>'">
                        <?= $d ?>
                    </div>
                <?php else: ?>
                    <div class="ep-arch-day"><?= $d ?></div>
                <?php endif; ?>
            <?php endfor; ?>
        </div>

</div>

<?php include 'footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: epaper_archive.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation