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: NewsArticle.php

<?php
namespace App\Models;

// Database class loaded from config/database.php (global namespace)

class NewsArticle {
    private $db;
    
    public function __construct() {
        $this->db = \Database::getInstance();
    }
    
    /**
     * Get article by ID
     */
    public function getById($id) {
        return $this->db->fetch(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en, c.slug as category_slug,
                    l.name_mr as location_name_mr, l.name_en as location_name_en,
                    u.first_name, u.last_name, u.avatar
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             LEFT JOIN locations l ON a.location_id = l.id
             LEFT JOIN users u ON a.reporter_id = u.id
             WHERE a.id = ?",
            [$id]
        );
    }
    
    /**
     * Get article by slug
     */
    public function getBySlug($slug) {
        return $this->db->fetch(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en, c.slug as category_slug,
                    l.name_mr as location_name_mr, l.name_en as location_name_en,
                    u.first_name, u.last_name, u.avatar
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             LEFT JOIN locations l ON a.location_id = l.id
             LEFT JOIN users u ON a.reporter_id = u.id
             WHERE a.slug = ?",
            [$slug]
        );
    }
    
    /**
     * Get articles with filters
     */
    public function getArticles($filters = [], $page = 1, $perPage = 10) {
        $where = ['1=1'];
        $params = [];
        
        if (!empty($filters['status'])) {
            $where[] = 'a.status = ?';
            $params[] = $filters['status'];
        }
        
        if (!empty($filters['category_id'])) {
            $where[] = 'a.category_id = ?';
            $params[] = $filters['category_id'];
        }
        
        if (!empty($filters['location_id'])) {
            $where[] = 'a.location_id = ?';
            $params[] = $filters['location_id'];
        }
        
        if (!empty($filters['reporter_id'])) {
            $where[] = 'a.reporter_id = ?';
            $params[] = $filters['reporter_id'];
        }
        
        if (!empty($filters['search'])) {
            $where[] = '(a.title LIKE ? OR a.content LIKE ?)';
            $params[] = '%' . $filters['search'] . '%';
            $params[] = '%' . $filters['search'] . '%';
        }
        
        $whereClause = implode(' AND ', $where);
        $offset = ($page - 1) * $perPage;
        
        $data = $this->db->fetchAll(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en,
                    u.first_name, u.last_name, u.avatar,
                    u.first_name as reporter_first_name, u.last_name as reporter_last_name
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             LEFT JOIN users u ON a.reporter_id = u.id
             WHERE $whereClause
             ORDER BY a.created_at DESC
             LIMIT $perPage OFFSET $offset",
            $params
        );
        
        $total = $this->db->fetchColumn(
            "SELECT COUNT(*) FROM news_articles a WHERE $whereClause",
            $params
        );
        
        return [
            'data' => $data,
            'total' => $total,
            'per_page' => $perPage,
            'current_page' => $page,
            'total_pages' => ceil($total / $perPage)
        ];
    }
    
    /**
     * Get featured articles
     */
    public function getFeatured($limit = 5) {
        $limit = (int) $limit;
        return $this->db->fetchAll(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             WHERE a.status = 'published' AND a.is_featured = 1
             ORDER BY a.published_at DESC
             LIMIT {$limit}"
        );
    }
    
    /**
     * Get breaking news
     */
    public function getBreakingNews($limit = 3) {
        $limit = (int) $limit;
        return $this->db->fetchAll(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             WHERE a.status = 'published' AND a.is_breaking = 1
             ORDER BY a.published_at DESC
             LIMIT {$limit}"
        );
    }
    
    /**
     * Get trending articles
     */
    public function getTrending($limit = 6) {
        $limit = (int) $limit;
        return $this->db->fetchAll(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             WHERE a.status = 'published'
             ORDER BY a.views_count DESC, a.published_at DESC
             LIMIT {$limit}"
        );
    }
    
    /**
     * Get related articles
     */
    public function getRelated($articleId, $categoryId, $limit = 4) {
        $limit = (int) $limit;
        return $this->db->fetchAll(
            "SELECT a.*, c.name_mr as category_name_mr, c.name_en as category_name_en
             FROM news_articles a
             LEFT JOIN categories c ON a.category_id = c.id
             WHERE a.status = 'published' 
               AND a.id != ? 
               AND a.category_id = ?
             ORDER BY a.published_at DESC
             LIMIT {$limit}",
            [$articleId, $categoryId]
        );
    }
    
    /**
     * Increment views
     */
    public function incrementViews($id) {
        $this->db->query(
            "UPDATE news_articles SET views_count = views_count + 1 WHERE id = ?",
            [$id]
        );
    }
    
    /**
     * Create article
     */
    public function create($data) {
        $fields = [];
        $values = [];
        $params = [];
        
        foreach ($data as $key => $value) {
            $fields[] = $key;
            $values[] = '?';
            $params[] = $value;
        }
        
        $fields[] = 'created_at';
        $values[] = 'NOW()';
        
        $sql = "INSERT INTO news_articles (" . implode(', ', $fields) . ") VALUES (" . implode(', ', $values) . ")";
        $this->db->query($sql, $params);
        
        return $this->db->lastInsertId();
    }
    
    /**
     * Update article
     */
    public function update($id, $data) {
        $fields = [];
        $params = [];
        
        foreach ($data as $key => $value) {
            $fields[] = "$key = ?";
            $params[] = $value;
        }
        
        $params[] = $id;
        
        $sql = "UPDATE news_articles SET " . implode(', ', $fields) . ", updated_at = NOW() WHERE id = ?";
        $this->db->query($sql, $params);
        
        return true;
    }
    
    /**
     * Delete article
     */
    public function delete($id) {
        $this->db->query("DELETE FROM news_articles WHERE id = ?", [$id]);
        return true;
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: NewsArticle.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation