moderation_system.php

<?php
class ModerationSystem {
    private $pdo;
    private $currentTime = '2025-06-14 13:33:08';
    private $currentUser = 'imabutahersiddik';

    public function __construct($pdo) {
        $this->pdo = $pdo;
    }

    public function reportContent($type, $contentId, $reason, $details) {
        $stmt = $this->pdo->prepare("
            INSERT INTO reports 
            (content_type, content_id, reporter_id, reason, details, status, created_at)
            VALUES (?, ?, ?, ?, ?, 'pending', ?)
        ");

        return $stmt->execute([
            $type,
            $contentId,
            $_SESSION['user_id'],
            $reason,
            $details,
            $this->currentTime
        ]);
    }

    public function moderateContent($reportId, $action, $notes = '') {
        $stmt = $this->pdo->prepare("
            UPDATE reports
            SET 
                status = ?,
                moderator_id = ?,
                moderation_notes = ?,
                moderated_at = ?
            WHERE id = ?
        ");

        $success = $stmt->execute([
            $action,
            $_SESSION['user_id'],
            $notes,
            $this->currentTime,
            $reportId
        ]);

        if ($success) {
            $report = $this->getReport($reportId);
            $this->takeAction($report, $action);
        }

        return $success;
    }

    private function takeAction($report, $action) {
        switch ($action) {
            case 'remove':
                $this->removeContent($report['content_type'], $report['content_id']);
                break;
            case 'warn':
                $this->warnUser($report['content_type'], $report['content_id']);
                break;
            case 'ban':
                $this->banUser($report['content_type'], $report['content_id']);
                break;
        }
    }

    private function getReport($reportId) {
        $stmt = $this->pdo->prepare("SELECT * FROM reports WHERE id = ?");
        $stmt->execute([$reportId]);
        return $stmt->fetch();
    }

    public function getPendingReports($page = 1, $perPage = 20) {
        $offset = ($page - 1) * $perPage;

        $stmt = $this->pdo->prepare("
            SELECT 
                r.*,
                u1.username as reporter_username,
                u2.username as reported_user,
                CASE 
                    WHEN r.content_type = 'app' THEN (SELECT app_name FROM apps WHERE id = r.content_id)
                    WHEN r.content_type = 'comment' THEN (SELECT content FROM comments WHERE id = r.content_id)
                    ELSE NULL
                END as content_preview
            FROM reports r
            JOIN users u1 ON r.reporter_id = u1.id
            LEFT JOIN users u2 ON r.reported_user_id = u2.id
            WHERE r.status = 'pending'
            ORDER BY r.created_at ASC
            LIMIT ? OFFSET ?
        ");

        $stmt->execute([$perPage, $offset]);
        return $stmt->fetchAll();
    }
}