Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: wallet-logs.php

<?php 
include('config/db.php');
?>

<!doctype html>
<html lang="en">
<head>
    <title>Wallet Logs & Analytics - Automation Dashboard</title>
    <?php include('links/head.php'); ?>
    <style>
        .stats-card {
            border-radius: 10px;
            color: white;
            padding: 20px;
            margin-bottom: 20px;
            box-shadow: 0 4px 6px rgba(0,0,0,0.1);
            transition: transform 0.3s ease;
        }
        .stats-card:hover {
            transform: translateY(-5px);
        }
        .stats-number {
            font-size: 1.8rem;
            font-weight: bold;
            margin-bottom: 5px;
        }
        .stats-label {
            font-size: 0.9rem;
            opacity: 0.9;
        }
        .growth-indicator {
            font-size: 0.8rem;
            margin-top: 5px;
        }
        .growth-positive {
            color: #28a745;
        }
        .growth-negative {
            color: #dc3545;
        }
        .filter-section {
            background-color: #f8f9fa;
            padding: 20px;
            border-radius: 10px;
            margin-bottom: 20px;
            border-left: 4px solid #727cf5;
        }
        .table-card {
            border-radius: 10px;
            box-shadow: 0 4px 6px rgba(0,0,0,0.1);
            margin-bottom: 20px;
        }
        .table-card .card-header {
            background-color: #fff;
            border-bottom: 1px solid #eee;
            padding: 15px 20px;
            border-radius: 10px 10px 0 0;
        }
        .badge-completed {
            background-color: #28a745;
        }
        .badge-missed {
            background-color: #ffc107;
            color: #212529;
        }
        .badge-no-data {
            background-color: #dc3545;
        }
        .positive-amount {
            color: #28a745;
            font-weight: bold;
        }
        .negative-amount {
            color: #dc3545;
            font-weight: bold;
        }
        .data-highlight {
            font-weight: bold;
            color: #2e59d9;
        }
        .missed-profile {
            background-color: #fff3cd !important;
        }
        .no-data-profile {
            background-color: #f8d7da !important;
        }
        .back-btn {
            margin-bottom: 20px;
            border-radius: 8px;
        }
        .pagination {
            justify-content: center;
            margin-top: 20px;
        }
        .nav-date {
            background: linear-gradient(45deg, #727cf5, #6c5ffc);
            color: white;
            border-radius: 8px;
            padding: 10px 15px;
        }
        .automation-card {
            background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
            color: white;
            border-radius: 15px;
            box-shadow: 0 10px 30px rgba(0,0,0,0.2);
            margin-bottom: 25px;
            overflow: hidden;
        }
        .automation-header {
            padding: 25px;
            text-align: center;
            background: rgba(0,0,0,0.1);
        }
        .automation-content {
            padding: 25px;
        }
        .automation-btn {
            background: linear-gradient(135deg, #00b09b, #96c93d);
            color: white;
            border: none;
            padding: 15px 30px;
            font-size: 1.1em;
            border-radius: 50px;
            cursor: pointer;
            transition: all 0.3s ease;
            display: block;
            width: 100%;
            margin: 15px 0;
            font-weight: bold;
            box-shadow: 0 10px 20px rgba(0,0,0,0.2);
        }
        .automation-btn:hover {
            transform: translateY(-3px);
            box-shadow: 0 15px 30px rgba(0,0,0,0.3);
        }
        .automation-btn:disabled {
            background: #95a5a6;
            cursor: not-allowed;
            transform: none;
            box-shadow: none;
        }
        .automation-status {
            background: rgba(255,255,255,0.1);
            padding: 15px;
            border-radius: 10px;
            margin: 15px 0;
            text-align: center;
        }
        .spinner {
            border: 4px solid rgba(255,255,255,0.3);
            border-top: 4px solid white;
            border-radius: 50%;
            width: 30px;
            height: 30px;
            animation: spin 1s linear infinite;
            margin: 0 auto 10px;
        }
        @keyframes spin {
            0% { transform: rotate(0deg); }
            100% { transform: rotate(360deg); }
        }
        .activity-log {
            background: rgba(0,0,0,0.2);
            border-radius: 10px;
            padding: 15px;
            margin-top: 20px;
            max-height: 200px;
            overflow-y: auto;
        }
        .log-entry {
            padding: 8px 0;
            border-bottom: 1px solid rgba(255,255,255,0.1);
            font-size: 0.9em;
        }
        .log-entry:last-child {
            border-bottom: none;
        }
    </style>
</head>
<body data-sidebar="dark">
    
    <div id="preloader">
        <div id="status">
            <div class="spinner"></div>
        </div>
    </div>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    
                    <div class="row">
                        <div class="col-12">
                            <div class="automation-card">
                                <div class="automation-header">
                                    <h2 class="mb-2">🤖 SBO Automation Control Panel</h2>
                                    <p class="mb-0">Run automated SBO portal processing with one click</p>
                                </div>
                                <div class="automation-content">
                                    <div class="row">
                                        <div class="col-md-8">
                                            <h4 class="mb-3">🚀 Quick Actions</h4>
                                            <p>Process all 43 SBO profiles automatically to fetch latest wallet data and commissions.</p>
                                            <div class="row">
                                                <div class="col-md-4">
                                                    <div class="automation-status">
                                                        <div class="stats-number" id="totalProfiles">43</div>
                                                        <div class="stats-label">Total Profiles</div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="automation-status">
                                                        <div class="stats-number" id="lastRunStatus">-</div>
                                                        <div class="stats-label">Last Run Status</div>
                                                    </div>
                                                </div>
                                                <div class="col-md-4">
                                                    <div class="automation-status">
                                                        <div class="stats-number" id="lastRunTime">-</div>
                                                        <div class="stats-label">Last Run Time</div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                        <div class="col-md-4">
                                            <button class="automation-btn" onclick="runAutomation()" id="runBtn">
                                                🚀 Run SBO Automation Now
                                            </button>
                                            <div class="automation-status" id="loading" style="display: none;">
                                                <div class="spinner"></div>
                                                <p>Starting automation process...</p>
                                                <small>You'll receive an email report when completed</small>
                                            </div>
                                            <div class="result" id="result"></div>
                                        </div>
                                    </div>
                                    
                                    <div class="activity-log" id="activityLog">
                                        <div class="log-entry"><?php echo date('Y-m-d H:i:s'); ?> - System Ready</div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<?php
                    // Get selected date from GET parameter or use today
                    $selected_date = isset($_GET['date']) ? $_GET['date'] : date('Y-m-d');
                    $prev_date = date('Y-m-d', strtotime($selected_date . ' -1 day'));
                    $next_date = date('Y-m-d', strtotime($selected_date . ' +1 day'));
                    
                    // Get current total balance (latest amount for each profile)
                    $current_total_query = "SELECT SUM(total_amount) as current_total FROM (
                        SELECT username, MAX(fetched_at) as latest_fetch 
                        FROM wallet_records_logs 
                        GROUP BY username
                    ) as latest 
                    JOIN wallet_records_logs w ON latest.username = w.username AND latest.latest_fetch = w.fetched_at";
                    $current_total_result = mysqli_query($conn, $current_total_query);
                    $current_total = mysqli_fetch_assoc($current_total_result);
                    
                    // Get today's total and yesterday's total for growth calculation
                    $today_total_query = "SELECT 
                        SUM(COALESCE(task_wallet_amount, 0) + COALESCE(intro_commission, 0)) as today_total
                        FROM wallet_records_logs 
                        WHERE record_date = '$selected_date'";
                    $today_total_result = mysqli_query($conn, $today_total_query);
                    $today_total_data = mysqli_fetch_assoc($today_total_result);
                    
                    $yesterday_total_query = "SELECT 
                        SUM(COALESCE(task_wallet_amount, 0) + COALESCE(intro_commission, 0)) as yesterday_total
                        FROM wallet_records_logs 
                        WHERE record_date = '$prev_date'";
                    $yesterday_total_result = mysqli_query($conn, $yesterday_total_query);
                    $yesterday_total_data = mysqli_fetch_assoc($yesterday_total_result);
                    
                    // Calculate today's growth (difference from yesterday)
                    $today_growth = $today_total_data['today_total'] - $yesterday_total_data['yesterday_total'];
                    $growth_percentage = $yesterday_total_data['yesterday_total'] > 0 ? 
                        (($today_growth / $yesterday_total_data['yesterday_total']) * 100) : 0;
                    
                    // Get today's active profiles count
                    $today_stats_query = "SELECT 
                        COUNT(DISTINCT username) as active_profiles
                        FROM wallet_records_logs 
                        WHERE record_date = '$selected_date'";
                    $today_stats_result = mysqli_query($conn, $today_stats_query);
                    $today_stats = mysqli_fetch_assoc($today_stats_result);
                    
                    // Get all profiles for comparison
                    $all_profiles_query = "SELECT DISTINCT username FROM task_wallet_records";
                    $all_profiles_result = mysqli_query($conn, $all_profiles_query);
                    $total_profile_count = mysqli_num_rows($all_profiles_result);
                    
                    $missed_profiles = $total_profile_count - ($today_stats['active_profiles'] ?? 0);
                    
                    // Get daily totals for the last 7 days with growth calculation
                    $weekly_totals_query = "SELECT 
                        record_date,
                        COUNT(DISTINCT username) as profile_count,
                        SUM(COALESCE(task_wallet_amount, 0)) as daily_task,
                        SUM(COALESCE(intro_commission, 0)) as daily_intro,
                        SUM(COALESCE(task_wallet_amount, 0) + COALESCE(intro_commission, 0)) as daily_total
                        FROM wallet_records_logs 
                        WHERE record_date >= DATE_SUB('$selected_date', INTERVAL 7 DAY)
                        GROUP BY record_date 
                        ORDER BY record_date DESC";
                    $weekly_totals_result = mysqli_query($conn, $weekly_totals_query);
                    $weekly_data = [];
                    while ($row = mysqli_fetch_assoc($weekly_totals_result)) {
                        $weekly_data[$row['record_date']] = $row;
                    }

// ================= PRIME PROFILES CALCULATION =================
                    // Fill this array with ALL 44 prime usernames
                    $prime_profiles = [
                        'SBOVDPN5570549',
                        'SBOVDPN5578047',
                        'SBOVDPN55243342',
                        'SBOVDPN5566931',
                        'SBOVDPN5578253',
                        'SBOVDBN5573975',
                        'SBOVDBN5573944',
                        'SBOVDBN55204739',
                        'SBOVDBN5591476',
                        // TODO: add remaining prime usernames until 44 total
                    ];
                    if (!empty($prime_profiles)) {
                        $prime_list = "'" . implode("','", $prime_profiles) . "'";
                        $prime_totals_query = "SELECT 
                                SUM(total_amount) as prime_total,
                                SUM(task_wallet_amount) as prime_task_total,
                                SUM(intro_commission) as prime_intro_total
                            FROM wallet_records_logs
                            WHERE username IN ($prime_list) 
                            AND record_date = '$selected_date'";
                        $prime_totals_result = mysqli_query($conn, $prime_totals_query);
                        $prime_totals = mysqli_fetch_assoc($prime_totals_result);
                        $prime_total_amount = $prime_totals['prime_total'] ?? 0;
                        // AFTER DEDUCTION TOTALS (NOT raw deduction values)
                        $after_deduct_20 = $prime_total_amount - ($prime_total_amount * 0.20);
                        $after_deduct_15 = $prime_total_amount - ($prime_total_amount * 0.15);
                    } else {
                        $prime_total_amount = 0;
                        $after_deduct_20 = 0;
                        $after_deduct_15 = 0;
                    }
                    $prime_profile_count = count($prime_profiles);
                    // =============================================================
                    ?>

<div class="row">
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #2e59d9, #17a2b8);">
                                <div class="stats-number" id="totalAmount">₹<?php echo number_format($current_total['current_total'] ?? 0, 2); ?></div>
                                <div class="stats-label">Current Total Balance</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #28a745, #20c997);">
                                <div class="stats-number" id="todayTotal">₹<?php echo number_format($today_growth, 2); ?></div>
                                <div class="stats-label">Today's Growth</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #fd7e14, #e83e8c);">
                                <div class="stats-number" id="activeProfiles"><?php echo $today_stats['active_profiles'] ?? 0; ?></div>
                                <div class="stats-label">Active Profiles Today</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #6f42c1, #e83e8c);">
                                <div class="stats-number" id="missedProfiles"><?php echo $missed_profiles; ?></div>
                                <div class="stats-label">Missed Profiles Today</div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #111, #444);">
                                <div class="stats-number"><?php echo $prime_profile_count; ?></div>
                                <div class="stats-label">Prime Profiles Count</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #0d47a1, #1976d2);">
                                <div class="stats-number">₹<?php echo number_format($prime_total_amount, 2); ?></div>
                                <div class="stats-label">Prime Profiles Total Amount</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #c0392b, #e74c3c);">
                                <div class="stats-number">₹<?php echo number_format($after_deduct_20, 2); ?></div>
                                <div class="stats-label">After 20% Deduction</div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="stats-card" style="background: linear-gradient(45deg, #f39c12, #d35400);">
                                <div class="stats-number">₹<?php echo number_format($after_deduct_15, 2); ?></div>
                                <div class="stats-label">After 15% Deduction</div>
                            </div>
                        </div>
                    </div>

<div class="card table-card">
                        <div class="card-header">
                            <h5 class="card-title mb-0">
                                <i class="fas fa-chart-line me-2"></i>7-Day Performance Summary
                            </h5>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered table-hover">
                                    <thead class="table-light">
                                        <tr>
                                            <th>Date</th>
                                            <th>Active Profiles</th>
                                            <th>Daily Growth</th>
                                            <th>Task Income</th>
                                            <th>Intro Income</th>
                                            <th>Daily Total</th>
                                            <th>Completion Rate</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        for ($i = 0; $i < 7; $i++) {
                                            $date = date('Y-m-d', strtotime($selected_date . " -$i days"));
                                            $data = $weekly_data[$date] ?? null;
                                            $is_today = $date == $selected_date;
                                            
                                            echo "<tr" . ($is_today ? ' class="table-primary"' : '') . ">";
                                            echo "<td><strong>" . date('d M Y', strtotime($date)) . "</strong>" . ($is_today ? ' <span class="badge bg-primary">Today</span>' : '') . "</td>";
                                            
                                            if ($data) {
                                                $completion_rate = $total_profile_count > 0 ? ($data['profile_count'] / $total_profile_count) * 100 : 0;
                                                $prev_day_total = $weekly_data[date('Y-m-d', strtotime($date . ' -1 day'))]['daily_total'] ?? 0;
                                                $daily_growth = $data['daily_total'] - $prev_day_total;
                                                $growth_class = $daily_growth >= 0 ? 'positive-amount' : 'negative-amount';
                                                $growth_sign = $daily_growth >= 0 ? '+' : '';
                                                
                                                echo "<td><span class='data-highlight'>{$data['profile_count']}</span>/{$total_profile_count}</td>";
                                                echo "<td class='$growth_class'>{$growth_sign}₹" . number_format($daily_growth, 2) . "</td>";
                                                echo "<td class='positive-amount'>₹" . number_format($data['daily_task'], 2) . "</td>";
                                                echo "<td class='positive-amount'>₹" . number_format($data['daily_intro'], 2) . "</td>";
                                                echo "<td><strong>₹" . number_format($data['daily_total'], 2) . "</strong></td>";
                                                echo "<td>
                                                        <div class='progress' style='height: 8px;'>
                                                            <div class='progress-bar " . ($completion_rate >= 80 ? 'bg-success' : ($completion_rate >= 50 ? 'bg-warning' : 'bg-danger')) . "' 
                                                                 style='width: {$completion_rate}%' title='{$completion_rate}%'>
                                                            </div>
                                                        </div>
                                                        <small>" . number_format($completion_rate, 1) . "%</small>
                                                      </td>";
                                            } else {
                                                echo "<td colspan='6' class='text-center text-muted'><i>No data available</i></td>";
                                            }
                                            echo "</tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

<div class="card table-card">
                        <div class="card-header d-flex justify-content-between align-items-center">
                            <h5 class="card-title mb-0">
                                <i class="fas fa-wallet me-2"></i>Wallet Logs & Analytics
                            </h5>
                            <div class="nav-date">
                                <small>Showing data for: <?php echo date("d M Y", strtotime($selected_date)); ?></small>
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered table-hover" id="walletLogsTable">
                                    <thead class="table-light">
                                        <tr>
                                            <th>#</th>
                                            <th>Username</th>
                                            <th>Profile Name</th>
                                            <th>Task Wallet</th>
                                            <th>Intro Commission</th>
                                            <th>Total Balance</th>
                                            <th>Growth Today</th>
                                            <th>Last Updated</th>
                                            <th>Status</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        // Get wallet logs for selected date with growth calculation
                                        $query = "SELECT 
                                            w.username,
                                            w.profile_name,
                                            w.task_wallet_amount,
                                            w.intro_commission,
                                            w.total_amount,
                                            w.fetched_at,
                                            w.record_date,
                                            CASE 
                                                WHEN w.username IS NOT NULL THEN 'completed'
                                                ELSE 'missed'
                                            END as status
                                          FROM wallet_records_logs w
                                          WHERE w.record_date = '$selected_date'
                                          ORDER BY w.total_amount DESC";
                                        
                                        $result = mysqli_query($conn, $query);
                                        $serial = 1;
                                        
                                        if ($result && mysqli_num_rows($result) > 0) {
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                // Get yesterday's amount for this user to calculate growth
                                                $yesterday_user_query = "SELECT total_amount 
                                                    FROM wallet_records_logs 
                                                    WHERE username = '{$row['username']}' 
                                                    AND record_date = '$prev_date' 
                                                    ORDER BY fetched_at DESC 
                                                    LIMIT 1";
                                                $yesterday_user_result = mysqli_query($conn, $yesterday_user_query);
                                                $yesterday_user_data = mysqli_fetch_assoc($yesterday_user_result);
                                                $yesterday_amount = $yesterday_user_data['total_amount'] ?? 0;
                                                $today_growth_user = $row['total_amount'] - $yesterday_amount;
                                                
                                                $status_class = $row['status'] == 'completed' ? '' : 'missed-profile';
                                                $status_badge = $row['status'] == 'completed' ? 
                                                    '<span class="badge badge-completed">Completed</span>' : 
                                                    '<span class="badge badge-missed">Missed</span>';
                                                
                                                $growth_class = $today_growth_user >= 0 ? 'positive-amount' : 'negative-amount';
                                                $growth_sign = $today_growth_user >= 0 ? '+' : '';

echo "<tr class='$status_class'>";
                                                echo "<td>" . $serial++ . "</td>";
                                                echo "<td><strong>" . htmlspecialchars($row['username']) . "</strong></td>";
                                                echo "<td>" . htmlspecialchars($row['profile_name'] ?? 'N/A') . "</td>";
                                                echo "<td class='positive-amount'>₹" . number_format($row['task_wallet_amount'], 2) . "</td>";
                                                echo "<td class='positive-amount'>₹" . number_format($row['intro_commission'], 2) . "</td>";
                                                echo "<td class='data-highlight'>₹" . number_format($row['total_amount'], 2) . "</td>";
                                                echo "<td class='$growth_class'>{$growth_sign}₹" . number_format($today_growth_user, 2) . "</td>";
                                                echo "<td>" . date('d M Y H:i', strtotime($row['fetched_at'])) . "</td>";
                                                echo "<td>" . $status_badge . "</td>";
                                                echo "<td>
                                                        <button class='btn btn-sm btn-outline-primary view-history' data-username='" . htmlspecialchars($row['username']) . "'>
                                                            <i class='fas fa-history me-1'></i>History
                                                        </button>
                                                      </td>";
                                                echo "</tr>";
                                            }
                                            
                                            // Show missed profiles
                                            $missed_query = "SELECT t.username 
                                              FROM task_wallet_records t 
                                              WHERE t.username NOT IN (
                                                  SELECT username FROM wallet_records_logs WHERE record_date = '$selected_date'
                                              )";
                                            $missed_result = mysqli_query($conn, $missed_query);
                                            
                                            while ($missed_row = mysqli_fetch_assoc($missed_result)) {
                                                echo "<tr class='no-data-profile'>";
                                                echo "<td>" . $serial++ . "</td>";
                                                echo "<td><strong>" . htmlspecialchars($missed_row['username']) . "</strong></td>";
                                                echo "<td class='text-muted'>N/A</td>";
                                                echo "<td class='text-muted'>N/A</td>";
                                                echo "<td class='text-muted'>N/A</td>";
                                                echo "<td class='text-muted'>N/A</td>";
                                                echo "<td class='text-muted'>N/A</td>";
                                                echo "<td class='text-muted'>No Data</td>";
                                                echo "<td><span class='badge badge-no-data'>No Data</span></td>";
                                                echo "<td>
                                                        <button class='btn btn-sm btn-outline-warning view-history' data-username='" . htmlspecialchars($missed_row['username']) . "'>
                                                            <i class='fas fa-history me-1'></i>History
                                                        </button>
                                                      </td>";
                                                echo "</tr>";
                                            }
                                            
                                        } else {
                                            echo "<tr><td colspan='10' class='text-center py-4'><i class='fas fa-exclamation-circle me-2'></i>No wallet logs found for selected date</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>

<div class="row mt-4">
                                <div class="col-md-12 text-center">
                                    <div class="btn-group" role="group">
                                        <a href="?date=<?php echo $prev_date; ?>" class="btn btn-outline-primary">
                                            <i class="fas fa-chevron-left me-1"></i>Previous Day
                                        </a>
                                        <a href="?date=<?php echo date('Y-m-d'); ?>" class="btn btn-primary">
                                            <i class="fas fa-calendar-day me-1"></i>Today
                                        </a>
                                        <a href="?date=<?php echo $next_date; ?>" class="btn btn-outline-primary">
                                            Next Day<i class="fas fa-chevron-right ms-1"></i>
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

</div>
            </div>

<?php include('includes/footer.php') ?>
        </div>
    </div>

<div class="modal fade" id="historyModal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Transaction History - <span id="modalUsername"></span></h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div id="historyContent"></div>
                </div>
            </div>
        </div>
    </div>

<?php include('includes/rightbar.php') ?>
    
    <div class="rightbar-overlay"></div>
    <?php include('links/scripts.php') ?>
    
    <script>
    let isRunning = false;
    
    function runAutomation() {
        if (isRunning) return;
        
        isRunning = true;
        const runBtn = document.getElementById('runBtn');
        const loading = document.getElementById('loading');
        const result = document.getElementById('result');
        
        runBtn.disabled = true;
        runBtn.innerHTML = '⏳ Processing...';
        loading.style.display = 'block';
        
        // Add to activity log
        addLogEntry('🔄 Automation triggered by user');
        
        // Create a simple form to submit
        const formData = new FormData();
        formData.append('action', 'trigger');
        formData.append('user', 'CRM_User');
        
        fetch('github_automation.php', {
            method: 'POST',
            body: formData
        })
        .then(response => response.json())
        .then(data => {
            loading.style.display = 'none';
            
            if (data.success) {
                result.innerHTML = `
                    <div class="alert alert-success mt-3">
                        <h5>✅ Success!</h5>
                        <p>${data.message}</p>
                        <p><strong>Details:</strong> ${data.details}</p>
                    </div>
                `;
                addLogEntry('✅ Automation started successfully');
                
                setTimeout(() => {
                    location.reload();
                }, 5000);
            } else {
                result.innerHTML = `
                    <div class="alert alert-danger mt-3">
                        <h5>❌ Error</h5>
                        <p>${data.message}</p>
                        <p><strong>Details:</strong> ${data.details}</p>
                    </div>
                `;
                addLogEntry('❌ Failed to start automation');
            }
        })
        .catch(error => {
            loading.style.display = 'none';
            result.innerHTML = `
                <div class="alert alert-danger mt-3">
                    <h5>❌ Network Error</h5>
                    <p>Failed to connect to automation service</p>
                    <p><strong>Error:</strong> ${error}</p>
                </div>
            `;
            addLogEntry('❌ Network error occurred');
        })
        .finally(() => {
            isRunning = false;
            runBtn.disabled = false;
            runBtn.innerHTML = '🚀 Run SBO Automation Now';
        });
    }
    
    function addLogEntry(message) {
        const log = document.getElementById('activityLog');
        const entry = document.createElement('div');
        entry.className = 'log-entry';
        entry.textContent = `${new Date().toLocaleString()} - ${message}`;
        log.insertBefore(entry, log.firstChild);
        
        while (log.children.length > 10) {
            log.removeChild(log.lastChild);
        }
    }
    
    function updateStatus() {
        const formData = new FormData();
        formData.append('action', 'status');
        
        fetch('github_automation.php', {
            method: 'POST',
            body: formData
        })
        .then(response => response.json())
        .then(data => {
            if (!data.error) {
                document.getElementById('lastRunStatus').textContent = 
                    data.conclusion ? data.conclusion : data.status;
                document.getElementById('lastRunTime').textContent = 
                    new Date(data.created_at).toLocaleTimeString();
            }
        })
        .catch(console.error);
    }
    
    updateStatus();
    setInterval(updateStatus, 30000);

$(document).ready(function() {
        $('#dateFilter').change(function() {
            window.location.href = '?date=' + $(this).val();
        });
        
        $('#profileFilter').change(function() {
            var filter = $(this).val();
            $('#walletLogsTable tbody tr').show();
            
            if (filter === 'active') {
                $('#walletLogsTable tbody tr').hide();
                $('#walletLogsTable tbody tr:not(.no-data-profile)').show();
            } else if (filter === 'missed') {
                $('#walletLogsTable tbody tr').hide();
                $('#walletLogsTable tbody tr.no-data-profile').show();
            }
        });
        
        $('#refreshBtn').click(function() {
            location.reload();
        });
        
        $('#exportBtn').click(function() {
            var csv = [];
            var rows = document.querySelectorAll("#walletLogsTable tr");
            
            for (var i = 0; i < rows.length; i++) {
                var row = [], cols = rows[i].querySelectorAll("td, th");
                for (var j = 0; j < cols.length - 1; j++) {
                    row.push(cols[j].innerText);
                }
                csv.push(row.join(","));        
            }
            
            var csvFile = new Blob([csv.join("\n")], {type: "text/csv"});
            var downloadLink = document.createElement("a");
            downloadLink.download = "wallet-logs-<?php echo $selected_date; ?>.csv";
            downloadLink.href = window.URL.createObjectURL(csvFile);
            downloadLink.style.display = "none";
            document.body.appendChild(downloadLink);
            downloadLink.click();
        });
        
        $('.view-history').click(function() {
            var username = $(this).data('username');
            $('#modalUsername').text(username);
            
            $.ajax({
                url: 'get_profile_history.php',
                type: 'GET',
                data: {username: username},
                success: function(response) {
                    $('#historyContent').html(response);
                    $('#historyModal').modal('show');
                },
                error: function() {
                    $('#historyContent').html('<div class="alert alert-danger"><i class="fas fa-exclamation-triangle me-2"></i>Error loading transaction history</div>');
                    $('#historyModal').modal('show');
                }
            });
        });
    });
    </script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: wallet-logs.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation