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.19 TB

🔧 Quick Actions

✏️ Editing: earnings.php

<?php
/**
 * Reporter Earnings
 */
$activeMenu = 'earnings';
$pageTitle = 'माझी कमाई';

$reporterId = $_SESSION['user_id'];
$tableExists = function ($table) use ($db) {
    return (bool) $db->fetchColumn("SHOW TABLES LIKE ?", [$table]);
};
$hasReporterEarnings = $tableExists('reporter_earnings');
$hasPayouts = $tableExists('payouts');
$hasPaymentMethods = $tableExists('payment_methods');
$summary = ['total_paid' => 0, 'total_pending' => 0, 'total_processing' => 0, 'paid_count' => 0, 'pending_count' => 0];
$payments = [];
$monthlyEarnings = [];
$payouts = [];
$paymentMethods = [];

try {

// Earnings summary
$summary = $hasReporterEarnings ? $db->fetch(
    "SELECT 
        SUM(CASE WHEN payment_status = 'paid' THEN amount ELSE 0 END) as total_paid,
        SUM(CASE WHEN payment_status = 'pending' THEN amount ELSE 0 END) as total_pending,
        SUM(CASE WHEN payment_status = 'processing' THEN amount ELSE 0 END) as total_processing,
        COUNT(CASE WHEN payment_status = 'paid' THEN 1 END) as paid_count,
        COUNT(CASE WHEN payment_status = 'pending' THEN 1 END) as pending_count
     FROM reporter_earnings 
     WHERE reporter_id = ?",
    [$reporterId]
) : ['total_paid' => 0, 'total_pending' => 0, 'total_processing' => 0, 'paid_count' => 0, 'pending_count' => 0];

// Payment history
$payments = $hasReporterEarnings ? $db->fetchAll(
    "SELECT e.*, a.title as article_title, a.slug as article_slug
     FROM reporter_earnings e
     LEFT JOIN news_articles a ON e.article_id = a.id
     WHERE e.reporter_id = ?
     ORDER BY e.created_at DESC
     LIMIT 50",
    [$reporterId]
) : [];

// Monthly breakdown
$monthlyEarnings = $hasReporterEarnings ? $db->fetchAll(
    "SELECT 
        DATE_FORMAT(created_at, '%Y-%m') as month,
        SUM(CASE WHEN payment_status = 'paid' THEN amount ELSE 0 END) as paid,
        SUM(CASE WHEN payment_status = 'pending' THEN amount ELSE 0 END) as pending,
        COUNT(*) as total_articles
     FROM reporter_earnings
     WHERE reporter_id = ?
     GROUP BY DATE_FORMAT(created_at, '%Y-%m')
     ORDER BY month DESC
     LIMIT 12",
    [$reporterId]
) : [];

// Payout history
$payouts = $hasPayouts ? $db->fetchAll(
    "SELECT * FROM payouts 
     WHERE reporter_id = ? 
     ORDER BY created_at DESC
     LIMIT 10",
    [$reporterId]
) : [];

// Payment methods
$paymentMethods = $hasPaymentMethods ? $db->fetchAll(
    "SELECT * FROM payment_methods WHERE user_id = ? AND is_active = 1",
    [$reporterId]
) : [];
} catch (\Throwable $e) {
    error_log('Reporter earnings dashboard 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="grid grid-cols-2 md:grid-cols-4 gap-4 mb-6">
    <div class="bg-gradient-to-br from-green-500 to-green-600 rounded-xl p-6 text-white">
        <p class="text-green-100 text-sm">एकूण कमाई</p>
        <p class="text-3xl font-bold">₹<?php echo number_format($summary['total_paid'] ?: 0); ?></p>
        <p class="text-sm mt-1"><?php echo $summary['paid_count']; ?> बातम्या</p>
    </div>
    
    <div class="bg-gradient-to-br from-yellow-500 to-orange-500 rounded-xl p-6 text-white">
        <p class="text-yellow-100 text-sm">प्रलंबित पेमेंट</p>
        <p class="text-3xl font-bold">₹<?php echo number_format($summary['total_pending'] ?: 0); ?></p>
        <p class="text-sm mt-1"><?php echo $summary['pending_count']; ?> बातम्या</p>
    </div>
    
    <div class="bg-gradient-to-br from-blue-500 to-blue-600 rounded-xl p-6 text-white">
        <p class="text-blue-100 text-sm">प्रक्रियेत</p>
        <p class="text-3xl font-bold">₹<?php echo number_format($summary['total_processing'] ?: 0); ?></p>
    </div>
    
    <div class="bg-gradient-to-br from-purple-500 to-pink-500 rounded-xl p-6 text-white">
        <p class="text-purple-100 text-sm">उपलब्ध कमाई</p>
        <p class="text-3xl font-bold">₹<?php echo number_format(($summary['total_paid'] + $summary['total_pending']) ?: 0); ?></p>
    </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">मासिक कमाई</h3>
            <?php if (!empty($monthlyEarnings)): ?>
            <div class="space-y-3">
                <?php foreach (array_reverse($monthlyEarnings) as $month): 
                    $maxEarning = max(array_column($monthlyEarnings, 'paid')) ?: 1;
                    $width = ($month['paid'] / $maxEarning) * 100;
                ?>
                <div class="flex items-center">
                    <span class="w-24 text-sm text-gray-500"><?php echo date('M Y', strtotime($month['month'] . '-01')); ?></span>
                    <div class="flex-1 mx-4">
                        <div class="bg-gray-100 rounded-full h-6 overflow-hidden">
                            <div class="bg-green-500 h-full rounded-full" style="width: <?php echo $width; ?>"></div>
                        </div>
                    </div>
                    <span class="w-20 text-right font-medium">₹<?php echo number_format($month['paid']); ?></span>
                </div>
                <?php endforeach; ?>
            </div>
            <?php else: ?>
            <p class="text-gray-500 text-center py-8">अद्याप कोणतीही कमाई नोंदवली नाही</p>
            <?php endif; ?>
        </div>
        
        
        <div class="bg-white rounded-xl shadow-sm">
            <div class="p-6 border-b flex justify-between items-center">
                <h3 class="font-bold text-lg">पेमेंट तपशील</h3>
                <div class="flex gap-2">
                    <span class="px-3 py-1 bg-green-100 text-green-700 rounded-full text-xs">
                        View-based: ₹0.05/view
                    </span>
                </div>
            </div>
            <div class="overflow-x-auto">
                <table class="w-full">
                    <thead class="bg-gray-50">
                        <tr>
                            <th class="px-4 py-3 text-left text-sm font-medium text-gray-600">बातमी</th>
                            <th class="px-4 py-3 text-right text-sm font-medium text-gray-600">वाचक</th>
                            <th class="px-4 py-3 text-right text-sm font-medium text-gray-600">रक्कम</th>
                            <th class="px-4 py-3 text-center text-sm font-medium text-gray-600">स्थिती</th>
                            <th class="px-4 py-3 text-right text-sm font-medium text-gray-600">दिनांक</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y">
                        <?php foreach ($payments as $payment): ?>
                        <tr class="hover:bg-gray-50">
                            <td class="px-4 py-3">
                                <a href="/news/<?php echo $payment['article_slug'] ?? '#'; ?>" 
                                   class="text-sm text-blue-600 hover:underline line-clamp-1">
                                    <?php echo $payment['article_title'] ?? 'Unknown'; ?>
                                </a>
                            </td>
                            <td class="px-4 py-3 text-right text-sm"><?php echo number_format($payment['views_count'] ?: 0); ?></td>
                            <td class="px-4 py-3 text-right font-medium">₹<?php echo number_format($payment['amount'], 2); ?></td>
                            <td class="px-4 py-3 text-center">
                                <span class="px-2 py-1 rounded-full text-xs font-medium <?php 
                                    echo $payment['payment_status'] === 'paid' ? 'bg-green-100 text-green-700' : 
                                         ($payment['payment_status'] === 'pending' ? 'bg-yellow-100 text-yellow-700' : 'bg-blue-100 text-blue-700'); 
                                ?>">
                                    <?php 
                                    echo $payment['payment_status'] === 'paid' ? 'पेमेंट झाले' : 
                                         ($payment['payment_status'] === 'pending' ? 'प्रलंबित' : 'प्रक्रियेत'); 
                                    ?>
                                </span>
                            </td>
                            <td class="px-4 py-3 text-right text-sm text-gray-500"><?php echo formatDate($payment['created_at']); ?></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>
            <?php if (!empty($payouts)): ?>
            <div class="space-y-3">
                <?php foreach ($payouts as $payout): ?>
                <div class="p-3 bg-gray-50 rounded-lg">
                    <div class="flex justify-between items-start">
                        <div>
                            <p class="font-medium">₹<?php echo number_format($payout['amount']); ?></p>
                            <p class="text-sm text-gray-500"><?php echo $payout['payment_method']; ?></p>
                        </div>
                        <span class="px-2 py-1 rounded-full text-xs <?php 
                            echo $payout['status'] === 'completed' ? 'bg-green-100 text-green-700' : 
                                 ($payout['status'] === 'pending' ? 'bg-yellow-100 text-yellow-700' : 'bg-gray-100 text-gray-700'); 
                        ?>">
                            <?php echo ucfirst($payout['status']); ?>
                        </span>
                    </div>
                    <p class="text-xs text-gray-400 mt-2"><?php echo formatDate($payout['created_at']); ?></p>
                </div>
                <?php endforeach; ?>
            </div>
            <?php else: ?>
            <p class="text-gray-500 text-center py-4">अद्याप कोणताही पेआउट नाही</p>
            <?php endif; ?>
        </div>
        
        
        <div class="bg-white rounded-xl shadow-sm p-6">
            <div class="flex justify-between items-center mb-4">
                <h3 class="font-bold text-lg">पेमेंट पद्धती</h3>
                <a href="/dashboard/reporter/payment-methods" class="text-blue-600 text-sm hover:underline">+ जोडा</a>
            </div>
            <?php if (!empty($paymentMethods)): ?>
            <div class="space-y-2">
                <?php foreach ($paymentMethods as $method): ?>
                <div class="flex items-center p-3 border rounded-lg">
                    <i class="fas <?php echo $method['type'] === 'upi' ? 'fa-mobile-alt' : 'fa-university'; ?> text-gray-400 mr-3"></i>
                    <div class="flex-1">
                        <p class="font-medium text-sm"><?php echo ucfirst($method['type']); ?></p>
                        <p class="text-xs text-gray-500"><?php echo substr($method['account_number'], 0, 4) . '****'; ?></p>
                    </div>
                    <?php if ($method['is_default']): ?>
                    <span class="text-xs bg-blue-100 text-blue-700 px-2 py-1 rounded">डीफॉल्ट</span>
                    <?php endif; ?>
                </div>
                <?php endforeach; ?>
            </div>
            <?php else: ?>
            <div class="text-center py-4">
                <i class="fas fa-wallet text-gray-300 text-4xl mb-2"></i>
                <p class="text-gray-500 text-sm">पेमेंट पद्धत जोडा</p>
                <a href="/dashboard/reporter/payment-methods/add" 
                   class="inline-block mt-2 bg-blue-600 text-white px-4 py-2 rounded-lg text-sm hover:bg-blue-700">
                    UPI / बँक जोडा
                </a>
            </div>
            <?php endif; ?>
        </div>
        
        
        <div class="bg-gradient-to-br from-indigo-500 to-purple-600 rounded-xl p-6 text-white text-center">
            <h3 class="font-bold text-lg mb-2">पेआउट मागवा</h3>
            <p class="text-sm opacity-90 mb-4">तुमच्या उपलब्ध कमाईची रक्कम मागवा</p>
            <p class="text-3xl font-bold mb-4">₹<?php echo number_format($summary['total_pending'] ?: 0); ?></p>
            <button onclick="requestPayout()" 
                    class="w-full bg-white text-indigo-600 font-medium py-2 rounded-lg hover:bg-gray-100 transition"
                    <?php echo ($summary['total_pending'] < 500) ? 'disabled' : ''; ?>>
                पेआउट मागवा
            </button>
            <?php if ($summary['total_pending'] < 500): ?>
            <p class="text-xs mt-2 opacity-75">किमान ₹500 आवश्यक</p>
            <?php endif; ?>
        </div>
    </div>
</div>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: earnings.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation