File "DiagnosticoModel.php"

Full Path: C:/wamp64/www/casos_medicos1/model/DiagnosticoModel.php
File size: 1.49 KB
MIME-type: text/x-php
Charset: utf-8

<?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();
    }
}