<?php/*
require_once 'Conexion.php';

class DiagnosticoModel {
    private $conn;

    public function __construct() {
        $db = new Conexion();
        $this->conn = $db->getConexion();
    }

    public function getDiagnosticos($cedula) {
        $cedula = $this->conn->real_escape_string($cedula);
       $sql = "SELECT dp.*, d.descripcion AS diagnostico_descripcion
            FROM diagnostico_paciente dp
            LEFT JOIN diagnostico d ON dp.codigo_diagnostico = d.id
            WHERE dp.cedula = '$cedula'
            ORDER BY dp.fecha DESC";
        $res = $this->conn->query($sql);
        return $res ? $res->fetch_all(MYSQLI_ASSOC) : [];
    }

    public function getCatalogo() {
        $sql = "SELECT id, descripcion FROM catalogo_diagnosticos ORDER BY descripcion";
        $res = $this->conn->query($sql);
        return $res ? $res->fetch_all(MYSQLI_ASSOC) : [];
    }
}