Tiny File Manager

Back Back Up Advanced Editor

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