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

🔧 Quick Actions

✏️ Editing: Ad.php

<?php
namespace App\Models;

/**
 * Advertisement Model
 * Buldhana Updates - Hyperlocal Citizen Journalism Platform
 */

class Ad extends BaseModel {
    protected $table = 'ads';
    protected $fillable = [
        'name', 'type', 'position', 'image', 'code', 'link_url',
        'advertiser_name', 'advertiser_email', 'advertiser_phone',
        'start_date', 'end_date', 'max_impressions', 'max_clicks',
        'is_active', 'created_by'
    ];
    
    /**
     * Get active ads by position
     */
    public function getByPosition(string $position, int $limit = 1): array {
        return $this->db->fetchAll(
            "SELECT * FROM {$this->table} 
             WHERE position = ? 
             AND is_active = 1 
             AND (start_date IS NULL OR start_date <= CURDATE())
             AND (end_date IS NULL OR end_date >= CURDATE())
             AND (max_impressions IS NULL OR impressions_count < max_impressions)
             AND (max_clicks IS NULL OR clicks_count < max_clicks)
             ORDER BY RAND()
             LIMIT {$limit}",
            [$position]
        );
    }
    
    /**
     * Get all positions
     */
    public function getPositions(): array {
        return [
            'header' => 'Header Banner',
            'sidebar_top' => 'Sidebar Top',
            'sidebar_middle' => 'Sidebar Middle',
            'sidebar_bottom' => 'Sidebar Bottom',
            'article_top' => 'Article Top',
            'article_middle' => 'Article Middle',
            'article_bottom' => 'Article Bottom',
            'footer' => 'Footer',
            'popup' => 'Popup',
            'native_1' => 'Native Ad 1',
            'native_2' => 'Native Ad 2'
        ];
    }
    
    /**
     * Increment impression
     */
    public function incrementImpression(int $adId): void {
        $this->db->query(
            "UPDATE {$this->table} SET impressions_count = impressions_count + 1 WHERE id = ?",
            [$adId]
        );
    }
    
    /**
     * Track click
     */
    public function trackClick(int $adId): void {
        $this->db->query(
            "UPDATE {$this->table} SET clicks_count = clicks_count + 1 WHERE id = ?",
            [$adId]
        );
    }
    
    /**
     * Get ad stats
     */
    public function getStats(int $adId): array {
        return $this->db->fetchOne(
            "SELECT impressions_count, clicks_count,
                    (clicks_count / NULLIF(impressions_count, 0) * 100) as ctr
             FROM {$this->table} WHERE id = ?",
            [$adId]
        ) ?: ['impressions_count' => 0, 'clicks_count' => 0, 'ctr' => 0];
    }
    
    /**
     * Render ad HTML
     */
    public function render(string $position): string {
        $ads = $this->getByPosition($position);
        
        if (empty($ads)) {
            return '';
        }
        
        $ad = $ads[0];
        $this->incrementImpression($ad['id']);
        
        $html = '<div class="ad-container ad-' . $position . ' mb-4">';
        
        if (!empty($ad['code'])) {
            $html .= $ad['code'];
        } else {
            $html .= '<a href="/ad/click/' . $ad['id'] . '" target="_blank" rel="nofollow">';
            $html .= '<img src="' . UPLOADS_URL . '/' . $ad['image'] . '" alt="' . htmlspecialchars($ad['name']) . '" class="w-full">';
            $html .= '</a>';
        }
        
        $html .= '</div>';
        
        return $html;
    }
    
    /**
     * Get active ads count
     */
    public function getActiveCount(): int {
        return $this->db->fetchColumn(
            "SELECT COUNT(*) FROM {$this->table} 
             WHERE is_active = 1 
             AND (end_date IS NULL OR end_date >= CURDATE())"
        );
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Ad.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation