Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/buldhanaupdates.com/public_html/app/Views/dashboard/reporter

Free Space:

8.18 TB

🔧 Quick Actions

✏️ Editing: analytics.php

<?php
/**
 * Reporter Analytics
 */
$activeMenu = 'analytics';
$pageTitle = 'माझी कामगिरी';

$reporterId = $_SESSION['user_id'];
$tableExists = function ($table) use ($db) {
    return (bool) $db->fetchColumn("SHOW TABLES LIKE ?", [$table]);
};

// Date range
$period = $_GET['period'] ?? '30';
$fromDate = date('Y-m-d', strtotime("-$period days"));
$overallStats = ['total_articles' => 0, 'total_views' => 0, 'avg_views' => 0, 'max_views' => 0, 'articles_7days' => 0, 'views_7days' => 0];
$categoryStats = [];
$dailyViews = [];
$monthlyStats = [];
$topArticles = [];
$engagementStats = ['total_comments' => 0, 'articles_with_comments' => 0, 'avg_comments_per_article' => 0];

try {

// Overall stats
$overallStats = $db->fetch(
    "SELECT 
        COUNT(*) as total_articles,
        SUM(views_count) as total_views,
        AVG(views_count) as avg_views,
        MAX(views_count) as max_views,
        SUM(CASE WHEN DATE(published_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) THEN 1 ELSE 0 END) as articles_7days,
        SUM(CASE WHEN DATE(published_at) >= DATE_SUB(CURDATE(), INTERVAL 7 DAY) THEN views_count ELSE 0 END) as views_7days
     FROM news_articles 
     WHERE reporter_id = ? AND status = 'published'",
    [$reporterId]
);

// Category performance
$categoryStats = $db->fetchAll(
    "SELECT c.name_mr, c.name_en,
            COUNT(a.id) as article_count,
            SUM(a.views_count) as total_views,
            AVG(a.views_count) as avg_views
     FROM categories c
     JOIN news_articles a ON c.id = a.category_id
     WHERE a.reporter_id = ? AND a.status = 'published'
     GROUP BY c.id
     ORDER BY total_views DESC",
    [$reporterId]
);

// Daily views trend
$dailyViews = $tableExists('page_views') ? $db->fetchAll(
    "SELECT 
        DATE(pv.created_at) as date,
        COUNT(*) as views
     FROM page_views pv
     JOIN news_articles a ON pv.article_id = a.id
     WHERE a.reporter_id = ? AND pv.created_at >= ?
     GROUP BY DATE(pv.created_at)
     ORDER BY date ASC",
    [$reporterId, $fromDate]
) : [];

// Monthly comparison
$monthlyStats = $db->fetchAll(
    "SELECT 
        DATE_FORMAT(published_at, '%Y-%m') as month,
        COUNT(*) as articles,
        SUM(views_count) as views
     FROM news_articles
     WHERE reporter_id = ? AND status = 'published'
     GROUP BY DATE_FORMAT(published_at, '%Y-%m')
     ORDER BY month DESC
     LIMIT 12",
    [$reporterId]
);

// Top performing content
$topArticles = $db->fetchAll(
    "SELECT id, title, slug, featured_image, views_count, 
            category_id, published_at, word_count
     FROM news_articles
     WHERE reporter_id = ? AND status = 'published'
     ORDER BY views_count DESC
     LIMIT 10",
    [$reporterId]
);

// Engagement metrics (comments)
$engagementStats = $tableExists('comments') ? $db->fetch(
    "SELECT 
        COUNT(DISTINCT c.id) as total_comments,
        COUNT(DISTINCT c.article_id) as articles_with_comments,
        AVG(comment_count) as avg_comments_per_article
     FROM comments c
     JOIN news_articles a ON c.article_id = a.id
     JOIN (
         SELECT article_id, COUNT(*) as comment_count 
         FROM comments 
         GROUP BY article_id
     ) cc ON a.id = cc.article_id
     WHERE a.reporter_id = ?",
    [$reporterId]
) : $engagementStats;
} catch (\Throwable $e) {
    error_log('Reporter analytics fallback: ' . $e->getMessage());
}

ob_start();
?>

<div class="mb-6">
    <h1 class="text-2xl font-bold">माझी कामगिरी</h1>
    <p class="text-gray-600">तुमच्या बातम्यांची तपशीलवार आकडेवारी</p>
</div>

<div class="flex gap-2 mb-6">
    <a href="?period=7" class="px-4 py-2 rounded-lg <?php echo $period == '7' ? 'bg-blue-600 text-white' : 'bg-gray-100 hover:bg-gray-200'; ?>">७ दिवस</a>
    <a href="?period=30" class="px-4 py-2 rounded-lg <?php echo $period == '30' ? 'bg-blue-600 text-white' : 'bg-gray-100 hover:bg-gray-200'; ?>">३० दिवस</a>
    <a href="?period=90" class="px-4 py-2 rounded-lg <?php echo $period == '90' ? 'bg-blue-600 text-white' : 'bg-gray-100 hover:bg-gray-200'; ?>">९० दिवस</a>
    <a href="?period=365" class="px-4 py-2 rounded-lg <?php echo $period == '365' ? 'bg-blue-600 text-white' : 'bg-gray-100 hover:bg-gray-200'; ?>">१ वर्ष</a>
</div>

<div class="grid grid-cols-2 md:grid-cols-4 gap-4 mb-6">
    <div class="bg-white rounded-xl p-6 shadow-sm">
        <div class="flex items-center justify-between">
            <div>
                <p class="text-gray-500 text-sm">एकूण बातम्या</p>
                <p class="text-3xl font-bold"><?php echo $overallStats['total_articles']; ?></p>
            </div>
            <div class="w-12 h-12 bg-blue-100 rounded-lg flex items-center justify-center">
                <i class="fas fa-newspaper text-blue-600 text-xl"></i>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-xl p-6 shadow-sm">
        <div class="flex items-center justify-between">
            <div>
                <p class="text-gray-500 text-sm">एकूण वाचक</p>
                <p class="text-3xl font-bold"><?php echo number_format($overallStats['total_views']); ?></p>
            </div>
            <div class="w-12 h-12 bg-green-100 rounded-lg flex items-center justify-center">
                <i class="fas fa-eye text-green-600 text-xl"></i>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-xl p-6 shadow-sm">
        <div class="flex items-center justify-between">
            <div>
                <p class="text-gray-500 text-sm">सरासरी वाचक</p>
                <p class="text-3xl font-bold"><?php echo number_format($overallStats['avg_views'] ?: 0); ?></p>
            </div>
            <div class="w-12 h-12 bg-yellow-100 rounded-lg flex items-center justify-center">
                <i class="fas fa-chart-bar text-yellow-600 text-xl"></i>
            </div>
        </div>
    </div>
    
    <div class="bg-white rounded-xl p-6 shadow-sm">
        <div class="flex items-center justify-between">
            <div>
                <p class="text-gray-500 text-sm">सर्वोच्च वाचक</p>
                <p class="text-3xl font-bold"><?php echo number_format($overallStats['max_views'] ?: 0); ?></p>
            </div>
            <div class="w-12 h-12 bg-purple-100 rounded-lg flex items-center justify-center">
                <i class="fas fa-trophy text-purple-600 text-xl"></i>
            </div>
        </div>
    </div>
</div>

<div class="grid grid-cols-1 lg:grid-cols-3 gap-6">
    
    <div class="lg:col-span-2 space-y-6">
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <h3 class="font-bold text-lg mb-4">वाचक वाढ (<?php echo $period; ?> दिवस)</h3>
            <?php if (!empty($dailyViews)): ?>
            <div class="h-64 flex items-end space-x-1">
                <?php 
                $maxViews = max(array_column($dailyViews, 'views'));
                foreach ($dailyViews as $day): 
                    $height = $maxViews > 0 ? ($day['views'] / $maxViews) * 100 : 0;
                ?>
                <div class="flex-1 flex flex-col items-center" title="<?php echo $day['date']; ?>: <?php echo $day['views']; ?> views">
                    <div class="w-full bg-blue-500 rounded-t hover:bg-blue-600 transition-all relative group" style="height: <?php echo max(4, $height); ?>px">
                        <span class="absolute -top-8 left-1/2 transform -translate-x-1/2 bg-gray-800 text-white text-xs px-2 py-1 rounded opacity-0 group-hover:opacity-100 whitespace-nowrap">
                            <?php echo number_format($day['views']); ?>
                        </span>
                    </div>
                    <span class="text-xs text-gray-500 mt-1 rotate-45 origin-left"><?php echo date('d', strtotime($day['date'])); ?></span>
                </div>
                <?php endforeach; ?>
            </div>
            <?php else: ?>
            <div class="h-64 flex items-center justify-center text-gray-400">
                या कालावधीत कोणतीही माहिती उपलब्ध नाही
            </div>
            <?php endif; ?>
        </div>
        
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <h3 class="font-bold text-lg mb-4">श्रेणीनुसार कामगिरी</h3>
            <div class="space-y-4">
                <?php foreach ($categoryStats as $cat): ?>
                <div class="flex items-center">
                    <div class="w-32 text-sm font-medium"><?php echo $cat['name_mr']; ?></div>
                    <div class="flex-1 mx-4">
                        <?php 
                        $maxCatViews = max(array_column($categoryStats, 'total_views'));
                        $width = $maxCatViews > 0 ? ($cat['total_views'] / $maxCatViews) * 100 : 0;
                        ?>
                        <div class="bg-gray-100 rounded-full h-6 overflow-hidden">
                            <div class="bg-gradient-to-r from-blue-500 to-purple-500 h-full rounded-full" style="width: <?php echo $width; ?>"></div>
                        </div>
                    </div>
                    <div class="text-right">
                        <p class="font-bold"><?php echo number_format($cat['total_views']); ?></p>
                        <p class="text-xs text-gray-500"><?php echo $cat['article_count']; ?> बातम्या</p>
                    </div>
                </div>
                <?php endforeach; ?>
            </div>
        </div>
        
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <h3 class="font-bold text-lg mb-4">मासिक ट्रेंड</h3>
            <div class="overflow-x-auto">
                <table class="w-full">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-2 text-left text-sm font-medium text-gray-600">महिना</th>
                            <th class="px-4 py-2 text-right text-sm font-medium text-gray-600">बातम्या</th>
                            <th class="px-4 py-2 text-right text-sm font-medium text-gray-600">वाचक</th>
                            <th class="px-4 py-2 text-right text-sm font-medium text-gray-600">सरासरी</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y">
                        <?php foreach ($monthlyStats as $month): ?>
                        <tr>
                            <td class="px-4 py-3"><?php echo date('F Y', strtotime($month['month'] . '-01')); ?></td>
                            <td class="px-4 py-3 text-right"><?php echo $month['articles']; ?></td>
                            <td class="px-4 py-3 text-right font-medium"><?php echo number_format($month['views']); ?></td>
                            <td class="px-4 py-3 text-right"><?php echo number_format($month['views'] / $month['articles']); ?></td>
                        </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    
    
    <div class="space-y-6">
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <h3 class="font-bold text-lg mb-4">सहभाग आकडेवारी</h3>
            <div class="space-y-4">
                <div class="flex justify-between items-center p-3 bg-gray-50 rounded-lg">
                    <span class="text-gray-600">एकूण टिप्पण्या</span>
                    <span class="font-bold text-lg"><?php echo $engagementStats['total_comments'] ?: 0; ?></span>
                </div>
                <div class="flex justify-between items-center p-3 bg-gray-50 rounded-lg">
                    <span class="text-gray-600">टिप्पणी असलेल्या बातम्या</span>
                    <span class="font-bold text-lg"><?php echo $engagementStats['articles_with_comments'] ?: 0; ?></span>
                </div>
                <div class="flex justify-between items-center p-3 bg-gray-50 rounded-lg">
                    <span class="text-gray-600">सरासरी टिप्पण्या/बातमी</span>
                    <span class="font-bold text-lg"><?php echo number_format($engagementStats['avg_comments_per_article'] ?: 0, 1); ?></span>
                </div>
            </div>
        </div>
        
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <h3 class="font-bold text-lg mb-4">सर्वोत्तम १० बातम्या</h3>
            <div class="space-y-3">
                <?php foreach ($topArticles as $i => $article): ?>
                <div class="flex items-start p-3 hover:bg-gray-50 rounded-lg">
                    <span class="w-6 h-6 rounded-full bg-yellow-500 text-white text-xs flex items-center justify-center font-bold mr-3 flex-shrink-0">
                        <?php echo $i + 1; ?>
                    </span>
                    <div class="flex-1 min-w-0">
                        <a href="/news/<?php echo $article['slug']; ?>" target="_blank" 
                           class="text-sm font-medium text-gray-800 hover:text-blue-600 line-clamp-2">
                            <?php echo $article['title']; ?>
                        </a>
                        <p class="text-xs text-gray-500 mt-1">
                            <?php echo number_format($article['views_count']); ?> views • 
                            <?php echo formatDate($article['published_at']); ?>
                        </p>
                    </div>
                </div>
                <?php endforeach; ?>
            </div>
        </div>
        
        
        <div class="bg-gradient-to-br from-yellow-400 to-orange-500 rounded-xl p-6 text-white text-center">
            <i class="fas fa-star text-4xl mb-3"></i>
            <h3 class="font-bold text-lg">वाढ चांगली आहे!</h3>
            <p class="text-sm opacity-90 mt-2">
                <?php if ($overallStats['total_articles'] >= 50): ?>
                तुम्ही ५०+ बातम्या लिहिल्या आहेत!
                <?php elseif ($overallStats['total_views'] >= 10000): ?>
                १०,०००+ वाचक! उत्कृष्ट!
                <?php else: ?>
                नियमित लेखन चालू ठेवा!
                <?php endif; ?>
            </p>
        </div>
    </div>
</div>

<?php
$content = ob_get_clean();
require VIEWS_PATH . '/layouts/dashboard.php';
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: analytics.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation