<?php
// app/models/Project.php

class Project {
    private $pdo;

    public function __construct($pdo) {
        $this->pdo = $pdo;
    }

    // Get all projects
    public function getAll() {
        try {
            // FIX: Join with users table to get owner name if needed
            $stmt = $this->pdo->query("SELECT projects.*, users.name as owner_name 
                                       FROM projects 
                                       LEFT JOIN users ON projects.owner_id = users.id 
                                       ORDER BY created_at DESC");
            return $stmt->fetchAll();
        } catch (PDOException $e) {
            return [];
        }
    }

    // THIS WAS MISSING: Create a new project
    public function create($data) {
        $sql = "INSERT INTO projects (name, description, owner_id, start_date, end_date, status) 
                VALUES (:name, :description, :owner_id, :start_date, :end_date, :status)";
        
        $stmt = $this->pdo->prepare($sql);
        
        return $stmt->execute([
            'name' => $data['name'],
            'description' => $data['description'],
            'owner_id' => $data['owner_id'],
            'start_date' => $data['start_date'],
            'end_date' => $data['end_date'],
            'status' => $data['status']
        ]);
    }
    
    // Get active project count (For Dashboard)
    public function countActive() {
        $stmt = $this->pdo->query("SELECT COUNT(*) FROM projects WHERE status = 'active'");
        return $stmt->fetchColumn();
    }
}
?>