-- =============================================
-- Author:		<Yonatan Gaete>
-- Create date: <28/01/2025>
-- Description:	<Cargar datos Inventario MINEDUC>
-- =============================================
CREATE PROCEDURE sp_afiListarInventarioMINEDUC
(
    @id INT,
    @periodo INT,
    @rubro INT
)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    SELECT
        ISNULL(C.codigoInterno, B.codigoInterno) AS ordenAnterior,
        B.codigoInterno AS numero,
        ISNULL(SG.nombre, '') AS nombre,
        B.descripcion,
        B.grupo AS rubro,
        B.estado AS estado,
        ISNULL(R.nombre, '') AS responsableNom,
        ISNULL(R.rut, '0') + '-' + ISNULL(R.dv, '0') AS rutResponsable,
        ISNULL(B.orderCompra, 0) AS ordenCompra,
        ISNULL(D.descripcion, '') AS departamento,
        ISNULL(U.nombre, '') AS ubicacion,
        B.costoCompra AS valorInicial,
        B.fechaCompra AS fechaAdq
    FROM afiBienes B
    LEFT JOIN afiCierrePeriodo C ON C.idActivo = B.id AND C.periodo = @periodo
    INNER JOIN afiEstados E ON E.id = B.estado
    INNER JOIN afiResponsables R ON R.id = B.responsable
    INNER JOIN remDepartamentos D ON D.idDepartamento = B.departamento
    INNER JOIN afiUbicaciones U ON U.id = B.ubicacion
    INNER JOIN afiGrupo G ON B.grupo = G.id
    INNER JOIN afiSubGrupo SG ON B.subgrupo = SG.id
    WHERE (B.id = @id OR @id = 0)
    AND B.grupo = @rubro
    ORDER BY B.codigoInterno; 

END
