Tiny File Manager

Back Back Up Advanced Editor

<?php
require_once __DIR__ . '/conexion.php';

class ReportesModel
{
    private $conn;

public function __construct()
    {
        $this->conn = (new Conexion())->getConexion();
    }

public function obtenerHojaVida($cedula)
    {
        $sql = "SELECT h.*, 
                       afp.nombre AS afp,
                       eps.nombre AS eps,
                       arl.nombre AS arl,
                       emp.nombre AS empresa,
                       pl.nombre AS planta,
                       e.nombre AS estado
                FROM hoja_vida h
                LEFT JOIN afp afp ON afp.id = h.id_afp
                LEFT JOIN eps eps ON eps.id = h.id_eps
                LEFT JOIN arl arl ON arl.id = h.id_arl
                LEFT JOIN empresa emp ON emp.id = h.id_empresa
                LEFT JOIN planta pl ON pl.id = h.id_planta
                LEFT JOIN estado e ON e.id = h.id_estado
                WHERE h.cedula = ?
                LIMIT 1";
        $stmt = $this->conn->prepare($sql);
        $stmt->bind_param("s", $cedula);
        $stmt->execute();
        $result = $stmt->get_result();
        return $result->fetch_assoc();
    }

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();
        $result = $stmt->get_result();
        return $result->fetch_all(MYSQLI_ASSOC);
    }
}