ALTER PROCEDURE [dbo].[sp_conResultadoAnual]
(@fecini    DATE, 
 @fecfin    DATE, 
 @unineg    INT = 0, 
 @ctaini    VARCHAR(10), 
 @ctafin    VARCHAR(10), 
 @factor    DECIMAL(8, 2),
 @monedaAdicional INT = 0 --1 = montos en moneda adicional, divididos por la tasa de cambio de cada línea (PJ-5935)
)
AS

DECLARE @periodo INT = (SELECT periodo FROM conParametros)


     SELECT 
			cuenta, 
            descripcion + ' (' + CONVERT(varchar(5),periodo) + ')' AS descripcion, 
            COALESCE([1] / @factor, 0) AS enero, 
            COALESCE([2] / @factor, 0) AS febrero, 
            COALESCE([3] / @factor, 0) AS marzo, 
            COALESCE([4] / @factor, 0) AS abril, 
            COALESCE([5] / @factor, 0) AS mayo, 
            COALESCE([6] / @factor, 0) AS junio, 
            COALESCE([7] / @factor, 0) AS julio, 
            COALESCE([8] / @factor, 0) AS agosto, 
            COALESCE([9] / @factor, 0) AS septiembre, 
            COALESCE([10] / @factor, 0) AS octubre, 
            COALESCE([11] / @factor, 0) AS noviembre, 
            COALESCE([12] / @factor, 0) AS diciembre,
			
			COALESCE([1] / @factor, 0)+
			COALESCE([2] / @factor, 0)+
			COALESCE([3] / @factor, 0)+
			COALESCE([4] / @factor, 0)+
			COALESCE([5] / @factor, 0)+
			COALESCE([6] / @factor, 0)+
			COALESCE([7] / @factor, 0)+
			COALESCE([8] / @factor, 0)+
			COALESCE([9] / @factor, 0)+
			COALESCE([10] / @factor, 0)+
			COALESCE([11] / @factor, 0)+
			COALESCE([12] / @factor, 0) AS total

     FROM
     (
          SELECT 
				conComprobantes.cuenta, 
                P.descripcion, 
				conComprobantes.mes,
                CASE P.tipoNaturaleza 
				WHEN 0 THEN  ((debe - haber) / M.divisor )
				WHEN 1 THEN  ((haber - debe) *-1 / M.divisor )
				WHEN 2 THEN  ((debe - haber) *-1 / M.divisor )
				WHEN 3 THEN  (( haber - debe ) / M.divisor )
				END AS saldo,
				conComprobantes.periodo
         FROM conComprobantes
              LEFT OUTER JOIN conPlanCuentas AS P ON conComprobantes.cuenta = P.cuenta AND P.periodo = @periodo
              --Moneda adicional: divisor por línea = tasa de cambio; vale 1 si no se usa, es 0 o es nula (PJ-5935)
              CROSS APPLY (SELECT CASE WHEN @monedaAdicional = 1 AND ISNULL(conComprobantes.tasa_cambio, 0) <> 0 THEN conComprobantes.tasa_cambio ELSE 1 END AS divisor) AS M
         WHERE  (clasificacion = 1)
               AND (fecha BETWEEN @fecini AND @fecfin)
               AND (conComprobantes.cuenta BETWEEN @ctaini AND @ctafin)
			   AND (conComprobantes.uni_negocio = @unineg or @unineg=0)
               AND conComprobantes.clasificacion <> 2
     ) AS T PIVOT(sum(t.saldo) FOR t.mes IN([1], 
                                            [2], 
                                            [3], 
                                            [4], 
                                            [5], 
                                            [6], 
                                            [7], 
                                            [8], 
                                            [9], 
                                            [10], 
                                            [11], 
                                            [12])) PVT
     ORDER BY cuenta ASC;
