--AYLARA GÖRE CARİ - İŞLEMTÜRÜ ANALİZİ
--BU RAPORU CARİ KARTLARA GİRERKEN GELECEL BUTONLAR ALTINA KOYALIM.
 --  sp_SN_Cari_IslemTuru_Analizi 1
 --  sp_SN_Cari_Yil_IslemTuru_Analizi 543,2022

 --  
 select MUSNO ,MUSADI from AMUSTERI WHERE MUSADI LIKE 'MULT%'
 go
create or ALTER PROC sp_SN_Cari_Yil_IslemTuru_Analizi @MUSNO INT , @Y INT
AS 
-- SET @Y=YEAR (GETDATE())
SELECT        AMUSTERI.MUSNO, AMUSTERI.MUSKOD, AMUSTERI.MUSADI, AMUSTERI.YETKILI, AMUSTERI.MUSTEL TEL_1,AMUSTERI.MUSCEP CEP_TEL, ACARI.BAACIKLA AS İşlemTürü, YEAR(ACARI.TARIH) AS YIL,  
                         SUM(ACARI.BORC + ACARI.ALACAK) AS TUTAR, AMUSTERI.MUSBAKIYE AS BAKİYESİ ,AMUSTERI.RISK AS RISK_LIMITI,  AMUSTERI.SaticiKodu, AMUSTERI.SaticiAdi, AMUSTERI.MUSIL, AMUSTERI.MUSILCE,
						AMUSTERI.Mah_Koyu, AMUSTERI.OZELKOD1, AMUSTERI.OZELKOD2, AMUSTERI.OZELKOD3, AMUSTERI.OZELKOD4, AMUSTERI.Tipi
FROM        AMUSTERI     INNER JOIN
                         ACARI ON ACARI.MUSNO = AMUSTERI.MUSNO  WHERE AMUSTERI.MUSNO=@MUSNO AND YEAR(ACARI.TARIH)=@Y
GROUP BY AMUSTERI.MUSNO, ACARI.BAACIKLA, ACARI.MUSNO, YEAR(ACARI.TARIH), AMUSTERI.MUSKOD, AMUSTERI.MUSADI, AMUSTERI.YETKILI, AMUSTERI.MUSTEL, AMUSTERI.MUSCEP, AMUSTERI.MUSIL, 
                         AMUSTERI.MUSILCE,  AMUSTERI.OZELKOD1, AMUSTERI.OZELKOD2, AMUSTERI.OZELKOD3, AMUSTERI.OZELKOD4, AMUSTERI.Tipi, AMUSTERI.Mah_Koyu, AMUSTERI.SaticiKodu, 
                         AMUSTERI.SaticiAdi,AMUSTERI.RISK, AMUSTERI.MUSBAKIYE
ORDER BY  İşlemTürü , YIL 

GO

-- SELECT YEAR (GETDATE ())