Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
includes	[ DIR ]	drwxr-xr-x	2026-03-11 22:58
.htaccess	197 B	-r--r--r--	2026-04-01 03:43
404.php	5.09 KB	-rw-r--r--	2026-03-12 12:29
admin-profile.php	4.68 KB	-rw-r--r--	2026-03-13 19:31
assignments.php	20.91 KB	-rw-r--r--	2026-03-30 15:12
deposits.php	8.48 KB	-rw-r--r--	2026-03-12 13:18
error_log	3.7 KB	-rw-r--r--	2026-03-23 09:01
index.php	137 B	-rw-r--r--	2026-03-12 12:26
index_real.php	3.95 KB	-rw-r--r--	2026-03-13 19:31
login.php	2.46 KB	-rw-r--r--	2026-03-13 19:32
logout.php	88 B	-rw-r--r--	2026-03-11 22:57
maintenance.php	3.68 KB	-rw-r--r--	2026-03-12 12:35
payment-methods.php	7.03 KB	-rw-r--r--	2026-03-12 12:35
plans.php	7.85 KB	-rw-r--r--	2026-03-12 12:35
referrals.php	4.91 KB	-rw-r--r--	2026-03-31 10:44
settings.php	17.83 KB	-rw-r--r--	2026-03-31 10:21
tickets.php	9.89 KB	-rw-r--r--	2026-03-12 13:15
users.php	19.8 KB	-rw-r--r--	2026-03-29 05:10
withdraw-methods.php	8.28 KB	-rw-r--r--	2026-03-12 15:17
withdrawals.php	6.26 KB	-rw-r--r--	2026-03-12 15:18
wp-blog-header.php	2.74 KB	-r--r--r--	2026-04-01 03:43
wp-cron.php	2.74 KB	-rw-r--r--	2026-04-01 03:43

Rename

<?php
require_once '../includes/config.php';
$error = '';
$success = $_SESSION['success'] ?? '';
unset($_SESSION['success']);

// Add new manual assignment
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['add_assignment'])) {
    $topic = trim($_POST['topic']);
    $subject = trim($_POST['subject']);
    $instructions = trim($_POST['instructions']);

if (empty($topic) || empty($subject) || empty($instructions)) {
        $error = "All fields are required to create an assignment.";
    }
    else {
        $stmt = $pdo->prepare("INSERT INTO assignments (topic, subject, instructions, type) VALUES (?, ?, ?, 'manual')");
        $stmt->execute([$topic, $subject, $instructions]);
        $_SESSION['success'] = "Manual Assignment added successfully.";
        header("Location: assignments.php");
        exit;
    }
}

// Bulk Auto Assignment Addition
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['add_bulk_assignments'])) {
    $bulk_text = trim($_POST['bulk_text']);
    if (!empty($bulk_text)) {
        $lines = explode("\n", $bulk_text);
        $count = 0;
        foreach ($lines as $line) {
            $parts = explode("|", $line);
            if (count($parts) >= 3) {
                $topic = trim($parts[0]);
                $subject = trim($parts[1]);
                $instructions = trim($parts[2]);
                
                $stmt = $pdo->prepare("INSERT INTO assignments (topic, subject, instructions, type) VALUES (?, ?, ?, 'auto')");
                $stmt->execute([$topic, $subject, $instructions]);
                $count++;
            }
        }
        $_SESSION['success'] = "$count Auto Assignments added successfully.";
        header("Location: assignments.php");
        exit;
    } else {
        $error = "Bulk data cannot be empty.";
    }
}

// Edit Assignment
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['edit_assignment'])) {
    $id = (int)$_POST['assignment_id'];
    $topic = trim($_POST['topic']);
    $subject = trim($_POST['subject']);
    $instructions = trim($_POST['instructions']);

if (!empty($topic) && !empty($subject) && !empty($instructions)) {
        $pdo->prepare("UPDATE assignments SET topic = ?, subject = ?, instructions = ? WHERE id = ?")->execute([$topic, $subject, $instructions, $id]);
        $_SESSION['success'] = "Assignment updated successfully.";
        header("Location: assignments.php");
        exit;
    }
}

// Delete Assignment
if (isset($_GET['delete_assignment'])) {
    $id = (int)$_GET['delete_assignment'];
    $pdo->prepare("DELETE FROM assignments WHERE id = ?")->execute([$id]);
    $_SESSION['success'] = "Assignment deleted from pool.";
    header("Location: assignments.php");
    exit;
}

// Review Assignment Submission
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['review_action'])) {
    $sub_id = (int)$_POST['submission_id'];
    $action = $_POST['review_action'];

$stmt = $pdo->prepare("SELECT s.*, u.id as user_id, u.email, u.full_name, a.topic 
                           FROM assignment_submissions s 
                           JOIN users u ON s.user_id = u.id 
                           JOIN assignments a ON s.assignment_id = a.id
                           WHERE s.id = ? AND s.status = 'pending'");
    $stmt->execute([$sub_id]);
    $sub = $stmt->fetch();

if ($sub) {
        // Fetch Site Settings for Mailer
        $s_stmt = $pdo->query("SELECT setting_key, setting_value FROM site_settings");
        $site_settings = array();
        while($row = $s_stmt->fetch(PDO::FETCH_ASSOC)) {
            $site_settings[$row['setting_key']] = $row['setting_value'];
        }

if ($action == 'approve') {
            try {
                $pdo->beginTransaction();

// Update submission status
                $pdo->prepare("UPDATE assignment_submissions SET status = 'approved', reviewed_at = CURRENT_TIMESTAMP WHERE id = ?")->execute([$sub_id]);

// Add balance
                $pdo->prepare("UPDATE users SET balance = balance + ?, total_earned = total_earned + ? WHERE id = ?")->execute([$sub['pay_amount'], $sub['pay_amount'], $sub['user_id']]);

// Add transaction
                $pdo->prepare("INSERT INTO transactions (user_id, type, amount, description) VALUES (?, 'assignment_earning', ?, 'Earned from approved assignment')")->execute([$sub['user_id'], $sub['pay_amount']]);

$pdo->commit();

$_SESSION['success'] = "Assignment approved successfully.";
                header("Location: assignments.php");
                exit;
            }
            catch (Exception $e) {
                $pdo->rollBack();
                $error = "Approval failed: " . $e->getMessage();
            }
        }
        elseif ($action == 'reject') {
            $pdo->prepare("UPDATE assignment_submissions SET status = 'rejected', reviewed_at = CURRENT_TIMESTAMP WHERE id = ?")->execute([$sub_id]);
            
            $_SESSION['success'] = "Assignment rejected.";
            header("Location: assignments.php");
            exit;
        }
    }
}

// Now include visual elements
require_once 'includes/header.php';
require_once 'includes/sidebar.php';

// Fetch 50 most recent submissions
$strSub = $pdo->query("SELECT s.*, u.full_name, u.email, a.topic, a.subject FROM assignment_submissions s JOIN users u ON s.user_id = u.id JOIN assignments a ON s.assignment_id = a.id ORDER BY s.id DESC LIMIT 50");
$submissions = $strSub->fetchAll();

// Fetch ALL assignments in pool
$strA = $pdo->query("SELECT * FROM assignments ORDER BY id DESC");
$all_assignments = $strA->fetchAll();

<div class="admin-top-bar">
    <h2>Assignments Management</h2>
    <div class="top-bar-stats">
        <span>Total Assignments: <strong><?php echo count($all_assignments); ?></strong></span>
    </div>
</div>

<?php if ($error): ?>
    <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div>
<?php endif; ?>
<?php if ($success): ?>
    <div class="alert alert-success"><?php echo htmlspecialchars($success); ?></div>
<?php endif; ?>

<div class="admin-main-container">
    
    <div class="card mb-30">
        <div class="card-header">
            <h3>Recent Submissions</h3>
            <span class="text-muted">Review user work and approve/reject earnings</span>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive scroll-box">
                <table class="modern-table">
                    <thead>
                        <tr>
                            <th>User Details</th>
                            <th>Topic</th>
                            <th>Work File</th>
                            <th>Earning</th>
                            <th>Status</th>
                            <th>Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($submissions as $s): ?>
                            <tr>
                                <td>
                                    <div class="user-meta">
                                        <strong><?php echo htmlspecialchars($s['full_name']); ?></strong>
                                    </div>
                                </td>
                                <td><span class="topic-pill"><?php echo htmlspecialchars($s['topic']); ?></span></td>
                                <td>
                                    <a href="<?php echo htmlspecialchars($s['file_path']); ?>" target="_blank" class="btn-text-link"><i class="fas fa-file-pdf"></i> View File</a>
                                </td>
                                <td><span class="price-tag"><?php echo $settings['currency_symbol'] ?? 'Rs'; ?> <?php echo number_format($s['pay_amount'], 2); ?></span></td>
                                <td>
                                    <span class="status-badge <?php echo $s['status']; ?>">
                                        <?php echo ucfirst($s['status']); ?>
                                    </span>
                                </td>
                                <td>
                                    <?php if ($s['status'] == 'pending'): ?>
                                        <div class="action-group">
                                            <form method="POST" style="display:inline;">
                                                <input type="hidden" name="submission_id" value="<?php echo $s['id']; ?>">
                                                <button type="submit" name="review_action" value="approve" class="btn-circle approve" title="Approve"><i class="fas fa-check"></i></button>
                                                <button type="submit" name="review_action" value="reject" class="btn-circle reject" title="Reject"><i class="fas fa-times"></i></button>
                                            </form>
                                        </div>
                                    <?php else: ?>
                                        <span class="reviewed-stamp">Processed</span>
                                    <?php endif; ?>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                        <?php if (empty($submissions)): ?>
                            <tr><td colspan="6" class="no-data">No work submitted yet.</td></tr>
                        <?php endif; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

<div class="setup-grid-row">
        
        <div class="card">
            <div class="card-header">
                <h3 class="text-primary">Create Manual Topic</h3>
                <small class="text-muted">Adds a single topic available for today only</small>
            </div>
            <div class="card-body">
                <form method="POST">
                    <div class="form-group">
                        <label>Title</label>
                        <input type="text" name="topic" class="form-input" required placeholder="e.g. Benefits of Exercise">
                    </div>
                    <div class="form-group">
                        <label>Subject</label>
                        <input type="text" name="subject" class="form-input" required placeholder="e.g. Science">
                    </div>
                    <div class="form-group">
                        <label>Instructions</label>
                        <textarea name="instructions" class="form-input" rows="3" required placeholder="Provide clear steps..."></textarea>
                    </div>
                    <button type="submit" name="add_assignment" class="btn-submit primary">Add Manual Assignment</button>
                </form>
            </div>
        </div>

<div class="card border-dashed">
            <div class="card-header">
                <h3 class="text-success"><i class="fas fa-magic"></i> Bulk Auto Pool</h3>
                <small class="text-muted">Rotates topics daily for automatic work flow</small>
            </div>
            <div class="card-body">
                <form method="POST">
                    <div class="form-group">
                        <label>Topic | Subject | Instructions (One per line)</label>
                        <textarea name="bulk_text" class="form-input monospace" rows="7" placeholder="Yoga | Health | Benefits of Yoga...&#10;Trees | Science | Why trees are important..." required></textarea>
                    </div>
                    <button type="submit" name="add_bulk_assignments" class="btn-submit success">Add to Bulk Pool</button>
                </form>
            </div>
        </div>
    </div>

<div class="card mt-30">
        <div class="card-header">
            <h3>Assignment Pool (<?php echo count($all_assignments); ?> Topics)</h3>
            <span class="text-muted">Complete list of topics in rotation</span>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive scroll-box">
                <table class="modern-table">
                    <thead>
                        <tr>
                            <th>ID</th>
                            <th>Topic & Subject</th>
                            <th>Instructions</th>
                            <th>Type</th>
                            <th>Actions</th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php foreach ($all_assignments as $a): ?>
                            <tr>
                                <td>#<?php echo $a['id']; ?></td>
                                <td>
                                    <div class="topic-meta">
                                        <strong><?php echo htmlspecialchars($a['topic']); ?></strong>
                                        <small><?php echo htmlspecialchars($a['subject']); ?></small>
                                    </div>
                                </td>
                                <td><div class="truncate-instructions"><?php echo htmlspecialchars($a['instructions']); ?></div></td>
                                <td><span class="tag-badge <?php echo $a['type']; ?>"><?php echo ucfirst($a['type']); ?></span></td>
                                <td>
                                    <div class="btn-group-mini">
                                        <button onclick='editAssignment(<?php echo json_encode($a, JSON_HEX_APOS | JSON_HEX_QUOT); ?>)' class="btn-utility edit"><i class="fas fa-edit"></i></button>
                                        <a href="?delete_assignment=<?php echo $a['id']; ?>" onclick="return confirm('Delete permanently?')" class="btn-utility delete"><i class="fas fa-trash"></i></a>
                                    </div>
                                </td>
                            </tr>
                        <?php endforeach; ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div id="editModal" class="modal-overlay">
    <div class="modal-container card">
        <span onclick="closeEdit()" class="modal-close-icon">&times;</span>
        <div class="card-header"><h3>Edit Topic</h3></div>
        <div class="card-body">
            <form method="POST">
                <input type="hidden" name="assignment_id" id="edit_id">
                <div class="form-group">
                    <label>Topic</label>
                    <input type="text" name="topic" id="edit_topic" class="form-input" required>
                </div>
                <div class="form-group">
                    <label>Subject</label>
                    <input type="text" name="subject" id="edit_subject" class="form-input" required>
                </div>
                <div class="form-group">
                    <label>Instructions</label>
                    <textarea name="instructions" id="edit_instructions" class="form-input" rows="5" required></textarea>
                </div>
                <button type="submit" name="edit_assignment" class="btn-submit primary">Update Assignment</button>
            </form>
        </div>
    </div>
</div>

.mb-30 { margin-bottom: 30px; }
.mt-30 { margin-top: 30px; }
.p-0 { padding: 0 !important; }

/* Cards */
.card { background: #151515; border-radius: 12px; border: 1px solid rgba(255,255,255,0.05); overflow: hidden; }
.card-header { padding: 15px 20px; border-bottom: 1px solid rgba(255,255,255,0.05); }
.card-header h3 { font-size: 1rem; color: #fff; margin: 0; }
.card-body { padding: 20px; }
.border-dashed { border-style: dashed !important; border-color: rgba(46, 204, 113, 0.2) !important; }

/* Layout Grid */
.setup-grid-row { display: grid; grid-template-columns: 1fr 1fr; gap: 25px; }
@media (max-width: 992px) { .setup-grid-row { grid-template-columns: 1fr; } }

/* Modern Table */
.table-responsive { width: 100%; overflow-x: auto; }
.scroll-box { max-height: 480px; overflow-y: auto; }
.modern-table { width: 100%; border-collapse: collapse; }
.modern-table th { text-align: left; padding: 12px 20px; background: #1a1a1a; color: #666; font-size: 0.75rem; text-transform: uppercase; letter-spacing: 1px; position: sticky; top: 0; z-index: 10; }
.modern-table td { padding: 15px 20px; border-bottom: 1px solid rgba(255,255,255,0.03); vertical-align: middle; }
.modern-table tr:hover { background: rgba(255,255,255,0.01); }

/* Components */
.user-meta, .topic-meta { display: flex; flex-direction: column; }
.user-meta strong, .topic-meta strong { color: #fff; font-size: 0.9rem; }
.user-meta small, .topic-meta small { color: #888; font-size: 0.75rem; }

.topic-pill { background: rgba(52, 152, 219, 0.1); color: #3498db; padding: 3px 10px; border-radius: 6px; font-size: 0.8rem; }
.price-tag { color: var(--primary-color); font-weight: 700; font-family: monospace; }
.status-badge { padding: 4px 12px; border-radius: 20px; font-size: 0.7rem; font-weight: 700; }
.status-badge.pending { background: rgba(243, 156, 18, 0.1); color: #f39c12; }
.status-badge.approved { background: rgba(46, 204, 113, 0.1); color: #2ecc71; }
.status-badge.rejected { background: rgba(231, 76, 60, 0.1); color: #e74c3c; }

.tag-badge { font-size: 0.65rem; padding: 2px 6px; border-radius: 4px; border: 1px solid; }
.tag-badge.manual { border-color: #3498db; color: #3498db; }
.tag-badge.auto { border-color: #2ecc71; color: #2ecc71; }

.truncate-instructions { max-width: 300px; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; color: #888; font-size: 0.8rem; }

/* Forms & Buttons */
.form-group { margin-bottom: 15px; }
.form-group label { display: block; margin-bottom: 5px; font-size: 0.85rem; color: #aaa; }
.form-input { width: 100%; background: #0f0f0f; border: 1px solid #333; border-radius: 6px; padding: 10px 12px; color: #fff; font-size: 0.9rem; }
.form-input:focus { border-color: var(--primary-color); outline: none; }
.monospace { font-family: 'Courier New', monospace; font-size: 0.8rem; }

.btn-submit { width: 100%; padding: 12px; border-radius: 6px; border: none; font-weight: 700; cursor: pointer; transition: 0.2s; }
.btn-submit.primary { background: var(--primary-color); color: #000; }
.btn-submit.success { background: #2ecc71; color: #fff; }
.btn-submit:hover { opacity: 0.9; transform: translateY(-1px); }

.btn-circle { width: 30px; height: 30px; border-radius: 50%; border: none; cursor: pointer; display: inline-flex; align-items: center; justify-content: center; margin: 0 2px; }
.btn-circle.approve { background: #2ecc71; color: #fff; }
.btn-circle.reject { background: #e74c3c; color: #fff; }

.btn-utility { background: none; border: 1px solid #333; color: #888; width: 30px; height: 30px; border-radius: 4px; cursor: pointer; }
.btn-utility:hover.edit { color: #3498db; border-color: #3498db; }
.btn-utility:hover.delete { color: #e74c3c; border-color: #e74c3c; }

.btn-text-link { color: #3498db; text-decoration: none; font-size: 0.8rem; }
.btn-text-link:hover { text-decoration: underline; }

/* Modal */
.modal-overlay { display: none; position: fixed; top: 0; left: 0; width: 100%; height: 100%; background: rgba(0,0,0,0.9); z-index: 10000; align-items: center; justify-content: center; }
.modal-container { width: 95%; max-width: 500px; position: relative; }
.modal-close-icon { position: absolute; top: 15px; right: 20px; font-size: 1.5rem; color: #888; cursor: pointer; }

.alert { padding: 15px; border-radius: 8px; margin-bottom: 20px; text-align: center; }
.alert-danger { background: rgba(231, 76, 60, 0.1); color: #e74c3c; }
.alert-success { background: rgba(46, 204, 113, 0.1); color: #2ecc71; }

.reviewed-stamp { font-size: 0.7rem; color: #555; text-transform: uppercase; font-weight: bold; }
.no-data { text-align: center; color: #555; padding: 30px !important; }
</style>

<?php require_once 'includes/footer.php'; ?>