Tul xxx Tul

Viewing: ClientProject.php

<?php

class ClientProject extends BaseModel
{
    protected string $table = 'client_projects';
    protected array $fillable = ['client_id','title','description','start_date','end_date','progress','status','priority','updated_at','deleted_at'];

    public function getProjectsByClient(int $clientId): array
    {
        $st=$this->db->prepare('SELECT * FROM client_projects WHERE client_id=:client_id AND deleted_at IS NULL ORDER BY created_at DESC');
        $st->execute(['client_id'=>$clientId]);
        return $st->fetchAll();
    }
    public function getById(int $id): ?array { $st=$this->db->prepare('SELECT * FROM client_projects WHERE id=:id AND deleted_at IS NULL'); $st->execute(['id'=>$id]); return $st->fetch()?:null; }
    public function createProject(array $data): int { return $this->create($data); }
    public function updateProject(int $id,array $data): bool { $data['updated_at']=date('Y-m-d H:i:s'); return $this->update($id,$data); }
    public function softDelete(int $id): bool { return $this->update($id,['deleted_at'=>date('Y-m-d H:i:s')]); }
    public function activeCount(): int { return (int)$this->db->query("SELECT COUNT(*) FROM client_projects WHERE deleted_at IS NULL AND status='en_progreso'")->fetchColumn(); }
    public function overdueCount(): int { return (int)$this->db->query("SELECT COUNT(*) FROM client_projects WHERE deleted_at IS NULL AND end_date IS NOT NULL AND end_date < CURDATE() AND status NOT IN ('finalizado')")->fetchColumn(); }
}

User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64