<?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) : [];
}
}