CREATE VIEW dbo.PLAS_RAPOR_TUM_TOPLAMLAR
AS
WITH CombinedData AS (SELECT        MAHLAS, MANG, SUM(TOPLAM2024) AS TOPLAM, 'SATIS' AS TUR
                                                      FROM            dbo.RAPOR_PLAS_AYLIK_SATIS
                                                      WHERE        (DEF <> 'TOPLAM SATIS')
                                                      GROUP BY MAHLAS, MANG
                                                      UNION ALL
                                                      SELECT        MAHLAS, MANG, SUM(TOPLAM2024) AS TOPLAM, 'IADE' AS TUR
                                                      FROM            dbo.RAPOR_PLAS_AYLIK_IADE
                                                      GROUP BY MAHLAS, MANG
                                                      UNION ALL
                                                      SELECT        MAHLAS, MANG, SUM(TOPLAM2024) AS TOPLAM, 'PRIM' AS TUR
                                                      FROM            dbo.RAPOR_PLAS_AYLIK_PRIM
                                                      GROUP BY MAHLAS, MANG
                                                      UNION ALL
                                                      SELECT        PGA.PLAS AS MAHLAS, PIS.MANG, SUM(PGA.TOPLAM) AS TOPLAM, 'GIDER' AS TUR
                                                      FROM            dbo.PLASIYER_GIDER_AYLARA_GORE_KALEM_TOPLAM_TABLOSU AS PGA LEFT OUTER JOIN
                                                                               dbo.PLASIYERLER_IADE_SIRALI AS PIS ON PIS.PLAS = PGA.PLAS
                                                      WHERE        (PGA.YIL = 2024)
                                                      GROUP BY PGA.PLAS, PIS.MANG)
    SELECT        MAHLAS, MANG, SUM(CASE WHEN TUR = 'SATIS' THEN TOPLAM ELSE 0 END) AS SATIS, SUM(CASE WHEN TUR = 'IADE' THEN TOPLAM ELSE 0 END) AS IADE, SUM(CASE WHEN TUR = 'PRIM' THEN TOPLAM ELSE 0 END) 
                              AS PRIM, SUM(CASE WHEN TUR = 'GIDER' THEN TOPLAM ELSE 0 END) AS GIDER, SUM(CASE WHEN TUR = 'SATIS' THEN TOPLAM ELSE 0 END) - SUM(CASE WHEN TUR IN ('IADE', 'PRIM', 'GIDER') 
                              THEN TOPLAM ELSE 0 END) AS GENEL
     FROM            CombinedData AS CombinedData_1
     GROUP BY MAHLAS, MANG