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/Models

Free Space:

8.19 TB

🔧 Quick Actions

✏️ Editing: ReporterApplication.php

<?php
namespace App\Models;

/**
 * Reporter Application Model
 * Buldhana Updates - Hyperlocal Citizen Journalism Platform
 */

class ReporterApplication extends BaseModel {
    protected $table = 'reporter_applications';
    protected $fillable = [
        'user_id', 'status', 'aadhaar_number', 'aadhaar_front', 'aadhaar_back',
        'pan_number', 'pan_card', 'photo', 'address_proof', 'experience',
        'expertise_areas', 'languages_known', 'why_reporter', 'samples_links',
        'admin_notes', 'rejection_reason', 'reviewed_at', 'reviewed_by'
    ];
    
    /**
     * Get application by user ID
     */
    public function getByUserId(int $userId): ?array {
        return $this->db->fetchOne(
            "SELECT ra.*, u.first_name, u.last_name, u.email, u.phone
             FROM {$this->table} ra
             JOIN users u ON ra.user_id = u.id
             WHERE ra.user_id = ?",
            [$userId]
        );
    }
    
    /**
     * Check if user has pending application
     */
    public function hasPendingApplication(int $userId): bool {
        return $this->db->fetchColumn(
            "SELECT COUNT(*) FROM {$this->table} WHERE user_id = ? AND status IN ('pending', 'under_review')",
            [$userId]
        ) > 0;
    }
    
    /**
     * Submit new application
     */
    public function submit(array $data): array {
        $userId = $data['user_id'];
        
        // Check if already has pending application
        if ($this->hasPendingApplication($userId)) {
            return ['success' => false, 'message' => 'You already have a pending application'];
        }
        
        // Check if already a reporter
        $user = $this->db->fetchOne(
            "SELECT r.slug FROM users u JOIN roles r ON u.role_id = r.id WHERE u.id = ?",
            [$userId]
        );
        
        if ($user && in_array($user['slug'], ['reporter', 'editor', 'admin', 'super_admin'])) {
            return ['success' => false, 'message' => 'You are already a reporter or have higher privileges'];
        }
        
        // Encode JSON fields
        if (isset($data['expertise_areas'])) {
            $data['expertise_areas'] = json_encode($data['expertise_areas']);
        }
        if (isset($data['languages_known'])) {
            $data['languages_known'] = json_encode($data['languages_known']);
        }
        
        $applicationId = $this->create($data);
        
        // Create notification for admins
        $this->createAdminNotification($userId);
        
        return ['success' => true, 'application_id' => $applicationId];
    }
    
    /**
     * Approve application
     */
    public function approve(int $applicationId, int $adminId, string $notes = ''): array {
        $application = $this->find($applicationId);
        
        if (!$application) {
            return ['success' => false, 'message' => 'Application not found'];
        }
        
        if ($application['status'] === 'approved') {
            return ['success' => false, 'message' => 'Application already approved'];
        }
        
        try {
            $this->beginTransaction();
            
            // Update application status
            $this->update($applicationId, [
                'status' => 'approved',
                'admin_notes' => $notes,
                'reviewed_at' => date('Y-m-d H:i:s'),
                'reviewed_by' => $adminId
            ]);
            
            // Update user role to reporter
            $reporterRoleId = $this->db->fetchColumn("SELECT id FROM roles WHERE slug = 'reporter'");
            $this->db->update('users', ['role_id' => $reporterRoleId], 'id = ?', [$application['user_id']]);
            
            // Create notification for user
            $this->db->insert('notifications', [
                'user_id' => $application['user_id'],
                'type' => 'reporter',
                'title' => 'Congratulations! Reporter Application Approved',
                'message' => 'Your application to become a reporter has been approved. You can now start submitting news articles.',
                'sent_via' => 'in_app'
            ]);
            
            $this->commit();
            
            return ['success' => true, 'message' => 'Application approved successfully'];
        } catch (\Exception $e) {
            $this->rollback();
            return ['success' => false, 'message' => 'Failed to approve application: ' . $e->getMessage()];
        }
    }
    
    /**
     * Reject application
     */
    public function reject(int $applicationId, int $adminId, string $reason): array {
        $application = $this->find($applicationId);
        
        if (!$application) {
            return ['success' => false, 'message' => 'Application not found'];
        }
        
        if ($application['status'] === 'rejected') {
            return ['success' => false, 'message' => 'Application already rejected'];
        }
        
        $this->update($applicationId, [
            'status' => 'rejected',
            'rejection_reason' => $reason,
            'reviewed_at' => date('Y-m-d H:i:s'),
            'reviewed_by' => $adminId
        ]);
        
        // Create notification for user
        $this->db->insert('notifications', [
            'user_id' => $application['user_id'],
            'type' => 'reporter',
            'title' => 'Reporter Application Status',
            'message' => 'Your application was not approved. Reason: ' . $reason,
            'sent_via' => 'in_app'
        ]);
        
        return ['success' => true, 'message' => 'Application rejected'];
    }
    
    /**
     * Get pending applications
     */
    public function getPending(int $page = 1, int $perPage = 20): array {
        $sql = "SELECT ra.*, u.first_name, u.last_name, u.email, u.phone, u.avatar,
                       r.name as role_name, a.first_name as reviewer_first_name, a.last_name as reviewer_last_name
                FROM {$this->table} ra
                JOIN users u ON ra.user_id = u.id
                JOIN roles r ON u.role_id = r.id
                LEFT JOIN users a ON ra.reviewed_by = a.id
                WHERE ra.status IN ('pending', 'under_review')
                ORDER BY ra.submitted_at ASC";
        
        return paginate($sql, [], $page, $perPage);
    }
    
    /**
     * Get all applications with filters
     */
    public function getAll(string $status = null, int $page = 1, int $perPage = 20): array {
        $sql = "SELECT ra.*, u.first_name, u.last_name, u.email, u.phone, u.avatar,
                       a.first_name as reviewer_first_name, a.last_name as reviewer_last_name
                FROM {$this->table} ra
                JOIN users u ON ra.user_id = u.id
                LEFT JOIN users a ON ra.reviewed_by = a.id";
        
        $params = [];
        if ($status) {
            $sql .= " WHERE ra.status = ?";
            $params[] = $status;
        }
        
        $sql .= " ORDER BY ra.created_at DESC";
        
        return paginate($sql, $params, $page, $perPage);
    }
    
    /**
     * Create admin notification
     */
    private function createAdminNotification(int $userId): void {
        $user = $this->db->fetchOne("SELECT first_name, last_name FROM users WHERE id = ?", [$userId]);
        $userName = ($user['first_name'] ?? '') . ' ' . ($user['last_name'] ?? '');
        
        // Get admin users
        $admins = $this->db->fetchAll(
            "SELECT u.id FROM users u 
             JOIN roles r ON u.role_id = r.id 
             WHERE r.slug IN ('admin', 'super_admin')"
        );
        
        foreach ($admins as $admin) {
            $this->db->insert('notifications', [
                'user_id' => $admin['id'],
                'type' => 'admin',
                'title' => 'New Reporter Application',
                'message' => $userName . ' has applied to become a reporter.',
                'sent_via' => 'in_app'
            ]);
        }
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: ReporterApplication.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation