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

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

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

// ---------- FETCH DISTINCT EDITIONS (CITIES) ----------
$editions = [];
$edRes = $conn->query("
    SELECT DISTINCT edition 
    FROM epapers
    WHERE is_active = 1
      AND edition <> ''
    ORDER BY edition ASC
");
if ($edRes) {
    while ($row = $edRes->fetch_assoc()) {
        $editions[] = $row['edition'];
    }
}

// Selected edition
$selectedEdition = '';
if (!empty($editions)) {
    $editionParam = isset($_GET['edition']) ? trim($_GET['edition']) : '';

if ($editionParam !== '' && in_array($editionParam, $editions, true)) {
        $selectedEdition = $editionParam;
    } else {
        $selectedEdition = $editions[0];
    }
}

// SEO
$siteName = get_setting('site_name', 'Jana Sena News');
if ($selectedEdition !== '') {
    $pageTitle = $selectedEdition . ' ePaper Archive - ' . $siteName;
} else {
    $pageTitle = 'ePaper City Archive - ' . $siteName;
}
$pageDescription = 'Browse city-wise ePaper archives for ' . $siteName . '.';

// ---------- YEARS, MONTHS, DAYS FOR SELECTED EDITION ----------
$yearRows  = [];
$monthRows = [];
$days      = [];
$year      = (int)date('Y');
$month     = (int)date('n');
$monthName = date("F");

if ($selectedEdition !== '') {
    // Years
    $yStmt = $conn->prepare("
        SELECT DISTINCT YEAR(published_date) AS y
        FROM epapers
        WHERE is_active = 1
          AND edition = ?
        ORDER BY y DESC
    ");
    $yStmt->bind_param("s", $selectedEdition);
    $yStmt->execute();
    $yRes = $yStmt->get_result();
    while ($r = $yRes->fetch_assoc()) {
        $yearRows[] = (int)$r['y'];
    }
    $yStmt->close();

if (!empty($yearRows)) {
        // Selected year (GET or latest)
        $year = isset($_GET['year']) ? (int)$_GET['year'] : $yearRows[0];
        if (!in_array($year, $yearRows, true)) {
            $year = $yearRows[0];
        }

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

if (!empty($monthRows)) {
            // Selected month (GET or latest in year)
            $month = isset($_GET['month']) ? (int)$_GET['month'] : end($monthRows);
            if (!in_array($month, $monthRows, true)) {
                $month = end($monthRows);
            }
        }

// Days with ePaper in this edition/year/month
        if (!empty($monthRows)) {
            $dStmt = $conn->prepare("
                SELECT DISTINCT DAY(published_date) AS d
                FROM epapers
                WHERE is_active = 1
                  AND edition = ?
                  AND YEAR(published_date) = ?
                  AND MONTH(published_date) = ?
                ORDER BY d ASC
            ");
            $dStmt->bind_param("sii", $selectedEdition, $year, $month);
            $dStmt->execute();
            $dRes = $dStmt->get_result();
            while ($r = $dRes->fetch_assoc()) {
                $days[] = (int)$r['d'];
            }
            $dStmt->close();
        }

$monthName = date("F", mktime(0, 0, 0, $month, 1));
    }
}

// 🔹 header main margin thaggadaniki flag
$noMainMargin = true;

include 'header.php';
?>

/* header text */
.epcity-title {
    font-size: 1.6rem;
    font-weight: 700;
    margin-bottom: 6px;
    text-align: center;
}
.epcity-sub {
    font-size: 0.90rem;
    color: #6b7280;
    text-align: center;
    margin-bottom: 16px;
}

/* CITY (EDITION) PILLS */
.epcity-city-btns {
    display: flex;
    justify-content: center;
    flex-wrap: wrap;
    gap: 8px;
    margin-bottom: 18px;
}
.epcity-city-btn {
    padding: 7px 16px;
    border-radius: 999px;
    font-size: 0.86rem;
    font-weight: 600;
    background: #e5e7eb;
    color: #111827;
    text-decoration: none;
    border: 1px solid #d1d5db;
}
.epcity-city-btn.active {
    background: #052962;
    color: #ffe500;
    border-color: #052962;
}

/* YEAR SELECTOR */
.epcity-year {
    text-align: center;
    margin-bottom: 16px;
}
.epcity-year select {
    padding: 6px 12px;
    border-radius: 8px;
    border: 1px solid #d1d5db;
}

/* MONTH BUTTONS */
.epcity-months {
    display: flex;
    justify-content: center;
    flex-wrap: wrap;
    gap: 8px;
    margin-bottom: 18px;
}
.epcity-month-btn {
    padding: 6px 12px;
    border-radius: 999px;
    font-size: 0.85rem;
    text-decoration: none;
    background: #e5e7eb;
    color: #111827;
}
.epcity-month-btn.active {
    background: #052962;
    color: #ffe500;
}

/* CALENDAR */
.epcity-calendar {
    max-width: 500px;
    margin: 0 auto;
    text-align: center;
}
.epcity-calendar-title {
    font-size: 1.05rem;
    font-weight: 700;
    margin-bottom: 8px;
}

.epcity-grid {
    display: grid;
    grid-template-columns: repeat(7, 1fr);
    gap: 8px;
}

.epcity-week {
    font-weight: 700;
    color: #6b7280;
    font-size: 0.8rem;
}

.epcity-day {
    padding: 9px 0;
    background: #f3f4f6;
    border-radius: 6px;
    font-weight: 600;
    font-size: 0.9rem;
}

.epcity-day.has {
    background: #052962;
    color: #ffe500;
    cursor: pointer;
}
.epcity-day.has:hover {
    background: #063b88;
}

@media (max-width: 767.98px) {
    .epcity-title {
        font-size: 1.3rem;
    }
    .epcity-wrap {
        padding-top: 6px;
    }
}
</style>

<div class="epcity-header text-center">
        <?php if (empty($editions)): ?>
            <h1 class="epcity-title">ePaper City Archive</h1>
            <p class="epcity-sub">No ePaper editions available yet. Please add ePapers from admin.</p>
        <?php else: ?>
            <h1 class="epcity-title"><?= h($selectedEdition); ?> ePaper Archive</h1>
            <p class="epcity-sub">
                Browse past ePaper issues by date for <?= h($selectedEdition); ?> edition.
            </p>
        <?php endif; ?>
    </div>

<?php if (!empty($editions)): ?>

<div class="epcity-city-btns">
            <?php foreach ($editions as $ed): ?>
                <?php $active = ($ed === $selectedEdition) ? 'active' : ''; ?>
                <a href="epaper_city.php?edition=<?= urlencode($ed); ?>"
                   class="epcity-city-btn <?= $active; ?>">
                    <?= h($ed); ?>
                </a>
            <?php endforeach; ?>
        </div>

<?php if (!empty($yearRows)): ?>

<div class="epcity-year">
                <form method="get" id="cityYearForm">
                    <input type="hidden" name="edition" value="<?= h($selectedEdition); ?>">
                    <select name="year" onchange="document.getElementById('cityYearForm').submit()">
                        <?php foreach ($yearRows as $y): ?>
                            <option value="<?= $y; ?>" <?= $y === $year ? 'selected' : ''; ?>>
                                <?= $y; ?>
                            </option>
                        <?php endforeach; ?>
                    </select>
                </form>
            </div>

<div class="epcity-months">
                <?php foreach ($monthRows as $m): ?>
                    <?php
                        $active = ($m === $month) ? 'active' : '';
                        $monthLabel = date("M", mktime(0, 0, 0, $m, 1));
                    ?>
                    <a href="epaper_city.php?edition=<?= urlencode($selectedEdition); ?>&year=<?= $year; ?>&month=<?= $m; ?>"
                       class="epcity-month-btn <?= $active; ?>">
                        <?= h($monthLabel); ?>
                    </a>
                <?php endforeach; ?>
            </div>

<div class="epcity-calendar">
                <div class="epcity-calendar-title">
                    <?= h($monthName . ' ' . $year); ?>
                </div>

<div class="epcity-grid mb-1">
                    <?php foreach (['Sun','Mon','Tue','Wed','Thu','Fri','Sat'] as $wd): ?>
                        <div class="epcity-week"><?= $wd; ?></div>
                    <?php endforeach; ?>
                </div>

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

<?php for ($d = 1; $d <= $totalDays; $d++): ?>
                        <?php
                            $hasPaper = in_array($d, $days, true);
                            $goDate   = sprintf('%04d-%02d-%02d', $year, $month, $d);
                        ?>
                        <?php if ($hasPaper): ?>
                            <div class="epcity-day has"
                                 onclick="window.location='epaper.php?date=<?= $goDate; ?>'">
                                <?= $d; ?>
                            </div>
                        <?php else: ?>
                            <div class="epcity-day"><?= $d; ?></div>
                        <?php endif; ?>
                    <?php endfor; ?>
                </div>
            </div>

<?php else: ?>
            <div class="alert alert-info text-center mt-3">
                No ePaper issues found for <?= h($selectedEdition); ?> edition yet.
            </div>
        <?php endif; ?>

<?php endif; ?>

</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: epaper_city.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation