CREATE VIEW dbo.CARI_ANLASMALAR_TOPLAM_ALIMLAR
AS
SELECT 
    CLIENTREF,
    SUM(CASE 
            WHEN TRCODE = 5 AND LINEEXP LIKE '%FIS HESABINDAN%' THEN TRNET 
            ELSE 0 
        END) AS VIRMAN,
    SUM(CASE 
            WHEN TRCODE = 38 THEN TRNET 
            ELSE 0 
        END) AS FATURA,
    SUM(CASE 
            WHEN TRCODE = 33 THEN TRNET 
            ELSE 0 
        END) AS IADE,
    SUM(CASE 
            WHEN TRCODE = 5 AND LINEEXP LIKE '%FIS HESABINDAN%' THEN TRNET 
            WHEN TRCODE = 38 THEN TRNET 
            WHEN TRCODE = 33 THEN -TRNET 
            ELSE 0 
        END) AS TOPLAM
FROM LG_011_07_CLFLINE
WHERE 
    CANCELLED = 0
    AND [SIGN] = 0
    AND TRCODE IN (5, 38, 33)
    AND (TRCODE != 5 OR LINEEXP LIKE '%FIS HESABINDAN%')
GROUP BY CLIENTREF