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

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

// ---------- SMALL HELPER ----------
if (!function_exists('h')) {
    function h($str) {
        return htmlspecialchars((string)$str, ENT_QUOTES, 'UTF-8');
    }
}

// ---------- BASIC SITE NAME ----------
$siteName = get_setting('site_name', 'Jana Sena News');

// ---------- LAST 7 DATES WITH EPAPER ----------
$dates            = [];
$latestDateFromDb = null;

$datesSql = "
    SELECT DISTINCT published_date 
    FROM epapers 
    WHERE is_active = 1
    ORDER BY published_date DESC
    LIMIT 7
";
if ($datesRes = $conn->query($datesSql)) {
    while ($r = $datesRes->fetch_assoc()) {
        if ($latestDateFromDb === null) {
            $latestDateFromDb = $r['published_date']; // first row = latest
        }
        $dates[] = $r['published_date'];
    }
    $datesRes->free();
}

// ---------- WHICH DATE TO SHOW? ----------
$selectedDate = null;

// 1) URL lo ?date= ichite aa date use chey (valid ayithe)
if (!empty($_GET['date'])) {
    $d = $_GET['date'];
    if (in_array($d, $dates, true)) {
        $selectedDate = $d;
    }
}

// 2) otherwise default = latest date from DB
if ($selectedDate === null && $latestDateFromDb !== null) {
    $selectedDate = $latestDateFromDb;
}

// UI kosam nice label
$niceDate = $selectedDate
    ? date('d M Y', strtotime($selectedDate))
    : null;

// ---------- PAGE META (SEO) ----------
if (!empty($niceDate)) {
    // example: "Jana Sena News ePaper – 08 Dec 2025"
    $pageTitle = $siteName . ' ePaper – ' . $niceDate;
    $pageDescription = 'Read ' . $siteName . ' ePaper for ' . $niceDate . '. All city editions available online.';
} else {
    $pageTitle = $siteName . ' ePaper – All Editions';
    $pageDescription = 'Read all available editions of ' . $siteName . ' ePaper. Updated daily with latest city editions.';
}

// keywords override optional (leka pothe header.php default use avthadi)
$pageKeywords = get_setting('default_meta_keywords', 'jana sena, news, politics, telugu, epaper');

// Canonical URL (current page full URL)
$scheme = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http';
$pageCanonical = $scheme . '://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];

// ---------- FETCH ALL EDITIONS FOR SELECTED DATE ----------
$epapers = [];

if ($selectedDate) {
    $sql = "
        SELECT id, title, edition, pdf_url, cover_image, published_date
        FROM epapers
        WHERE is_active = 1
          AND published_date = ?
        ORDER BY edition ASC, id ASC
    ";
    if ($stmt = $conn->prepare($sql)) {
        $stmt->bind_param('s', $selectedDate);
        $stmt->execute();
        $result = $stmt->get_result();

while ($row = $result->fetch_assoc()) {
            $epapers[] = $row;
        }

$stmt->close();
    }
}

$editionCount = count($epapers);

include 'header.php';
?>

/* ----- HEADER ----- */
.ep-header {
    margin-bottom: 18px;
}

.ep-header-row {
    display: flex;
    align-items: center;
    justify-content: center;
    gap: 18px;
    max-width: 980px;
    margin: 0 auto 4px;
}

.ep-header-line {
    flex: 1;
    max-width: 260px;
    height: 1px;
    background: linear-gradient(to right, transparent, #e5e7eb);
}

.ep-header-line.ep-right {
    background: linear-gradient(to right, #e5e7eb, transparent);
}

.ep-header-center {
    text-align: center;
}

.ep-kicker {
    font-size: 0.70rem;
    letter-spacing: .22em;
    text-transform: uppercase;
    color: #6b7280;
    margin-bottom: 4px;
}

.ep-main-title {
    font-size: 1.45rem;
    font-weight: 800;
    color: #111827;
    letter-spacing: .02em;
}

.ep-date-line {
    font-size: 0.86rem;
    color: #4b5563;
    margin-top: 4px;
    text-align: center;
}

.ep-date-line span {
    color: #111827;
    font-weight: 600;
}

/* small chip: Today */
.ep-date-tag {
    display: inline-flex;
    align-items: center;
    gap: 5px;
    padding: 2px 8px;
    border-radius: 999px;
    background: #fee2e2;
    color: #b91c1c;
    font-size: 0.72rem;
    margin-left: 6px;
}

/* ----- DATE SELECTOR ----- */
.ep-date-selector-wrap {
    margin: 12px auto 26px;
    text-align: center;
}

.ep-date-selector-wrap form {
    display: inline-flex;
    align-items: center;
    gap: 8px;
    padding: 4px 10px;
    border-radius: 999px;
    background: rgba(255,255,255,0.85);
    border: 1px solid #e5e7eb;
    box-shadow:
        0 10px 26px rgba(15,23,42,0.08),
        0 0 0 1px rgba(243,244,246,0.9);
}

.ep-date-label {
    font-size: 0.80rem;
    color: #6b7280;
}

.ep-date-selector-wrap select {
    display: inline-block;
    padding: 6px 10px;
    border-radius: 999px;
    border: 1px solid #d1d5db;
    font-size: 0.85rem;
    background: #ffffff;
    min-width: 150px;
}

/* ===== GRID ===== */
.ep-grid {
    display: grid;
    grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));
    gap: 32px;
    justify-items: center;
}

/* ===== CARD LINK ===== */
.ep-card-link {
    position: relative;
    text-decoration: none;
    display: inline-block;
    -webkit-tap-highlight-color: transparent;
}

/* outer white rounded card */
.ep-front-wrap {
    background: #ffffff;
    border-radius: 24px;
    padding: 12px 12px 14px;
    width: 250px;
    box-shadow:
        0 18px 40px rgba(15,23,42,0.40),
        0 0 0 1px rgba(209,213,219,0.90);
    transition:
        transform .16s ease,
        box-shadow .16s ease,
        border-color .16s ease;
    border: 1px solid rgba(209,213,219,0.9);
}

/* cover image area */
.ep-front-inner {
    position: relative;
    width: 100%;
    padding-bottom: 170%;
    border-radius: 20px;
    overflow: hidden;
    background: #020617;
}

.ep-front-inner img {
    position: absolute;
    inset: 0;
    width: 100%;
    height: 100%;
    object-fit: cover;
    display: block;
}

/* city tab */
.ep-city-tab {
    position: absolute;
    top: -18px;
    left: 50%;
    transform: translateX(-50%);
    background: #6b5b57;
    color: #f9fafb;
    padding: 4px 22px;
    border-radius: 999px;
    font-size: 0.78rem;
    font-weight: 700;
    letter-spacing: .18em;
    text-transform: uppercase;
    box-shadow: 0 6px 14px rgba(15,23,42,0.55);
    white-space: nowrap;
}

/* ===== MOBILE – 2 CARDS ===== */
@media (max-width: 767.98px) {

.epaper-page {
        padding-top: 8px;
        padding-bottom: 28px;
    }

.ep-main-title {
        font-size: 1.2rem;
    }

/* ✅ KEY CHANGE HERE */
    .ep-grid {
        grid-template-columns: repeat(2, 1fr); /* 👈 2 cards */
        gap: 14px;
        justify-items: stretch;
    }

.ep-card-link {
        width: 100%;
        display: block;
    }

.ep-front-wrap {
        width: 100%;
        max-width: none;
        padding: 8px;
        border-radius: 16px;
    }

.ep-front-inner {
        padding-bottom: 150%;
        border-radius: 14px;
    }

.ep-city-tab {
        top: -12px;
        padding: 4px 14px;
        font-size: 0.70rem;
        letter-spacing: .14em;
    }
}

/* ===== VERY SMALL PHONES ===== */
@media (max-width: 360px) {
    .ep-grid {
        grid-template-columns: 1fr; /* ultra small lo single card */
    }
}
</style>

<div class="ep-header-center">
                    <div class="ep-kicker">EPAPER EDITIONS</div>
                    <div class="ep-main-title"><?= h($siteName); ?> ePaper</div>
                </div>

<?php if ($niceDate): ?>
                <div class="ep-date-line">
                    <span><?= h($niceDate); ?></span>
                    • <?= h($siteName); ?> all city editions
                    <?php if ($latestDateFromDb && $selectedDate === $latestDateFromDb): ?>
                        <span class="ep-date-tag">TODAY</span>
                    <?php endif; ?>
                    <?php if ($editionCount > 0): ?>
                        &nbsp;• <?= (int)$editionCount; ?> editions
                    <?php endif; ?>
                </div>
            <?php endif; ?>
        </div>

<?php if (!empty($dates)): ?>
            <div class="ep-date-selector-wrap">
                <form method="get" action="epaper.php">
                    <span class="ep-date-label">Select date</span>
                    <select name="date" onchange="this.form.submit()">
                        <?php foreach ($dates as $d): ?>
                            <?php $label = date('d M Y', strtotime($d)); ?>
                            <option value="<?= h($d); ?>"
                                <?= $d === $selectedDate ? 'selected' : ''; ?>>
                                <?= h($label); ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </form>
            </div>
        <?php endif; ?>

<?php if (!empty($epapers)): ?>
            <div class="ep-grid">
                <?php foreach ($epapers as $ep): ?>
                    <?php
                        $editionRaw = trim((string)$ep['edition']);
                        $edition    = $editionRaw !== '' ? strtoupper($editionRaw) : 'EDITION';

$coverPathRaw = trim((string)$ep['cover_image']);
                        $coverPath    = $coverPathRaw !== '' 
                            ? $coverPathRaw 
                            : 'assets/images/epaper-placeholder.jpg';

$cardTitle = $ep['title'] !== '' ? $ep['title'] : ($siteName . ' ' . $edition . ' ePaper');
                    ?>
                    
                    <a href="epaper_view.php?id=<?= (int)$ep['id']; ?>&page=1"
                       class="ep-card-link">
                        <div class="ep-city-tab">
                            <?= h($edition); ?>
                        </div>

<div class="ep-front-wrap">
                            <div class="ep-front-inner">
                                <img src="<?= h($coverPath); ?>"
                                     alt="<?= h($cardTitle); ?>">
                            </div>
                        </div>
                    </a>
                <?php endforeach; ?>
            </div>
        <?php else: ?>
            <div class="alert alert-info text-center mt-4">
                No ePaper is available yet for this date. Please add one from the admin panel.
            </div>
        <?php endif; ?>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: epaper.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation