<?php
require_once __DIR__ . "/../model/conexion.php";
class DiagnosticoModel {
private $conn;
public function __construct() {
$this->conn = (new Conexion())->getConexion();
}
public function obtenerDiagnosticos($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 = ?
ORDER BY dp.fecha DESC";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param("s", $cedula);
$stmt->execute();
return $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
}
public function obtenerListaDiagnosticos() {
$sql = "SELECT id, descripcion FROM diagnostico ORDER BY descripcion ASC";
$res = $this->conn->query($sql);
return $res->fetch_all(MYSQLI_ASSOC);
}
public function guardarDiagnostico($data) {
$sql = "INSERT INTO diagnostico_paciente
(cedula, fecha, codigo_diagnostico, origen, entidad, tipo_evento)
VALUES (?, ?, ?, ?, ?, ?)";
$stmt = $this->conn->prepare($sql);
$stmt->bind_param(
"ssssss",
$data['cedula'],
$data['fecha'],
$data['codigo_diagnostico'],
$data['origen'],
$data['entidad'],
$data['tipo_evento']
);
return $stmt->execute();
}
}