Parameter > sKodeBrg Varchar(20),sKodeGD CHAR(10)

BEGIN
	DECLARE sJmlStock,sHargaAVG DECIMAL(15,2);
	DECLARE sCekSaldo INT; 
	DECLARE sNama,sKodeGol,sSatuan VARCHAR(100);
	
	SELECT COUNT(*) INTO sCekSaldo FROM tb_saldoawal WHERE KodeBrg=sKodeBrg AND KodeGD=sKodeGD;
	IF (sCekSaldo is NULL) or (sCekSaldo = 0) THEN
		SELECT NamaBrg,KodeGol,Satuan,HargaAVG INTO sNama,sKodeGol,sSatuan,sHargaAVG FROM tm_barang WHERE KodeBrg=sKodeBrg;
		INSERT INTO tb_saldoawal (Kodebrg,NamaBrg,KodeGol,KodeGD,Satuan,Konv,SaldoAwal,HargaAvg) VALUES (sKodeBrg,sNama,sKodeGol,sKodeGD,sSatuan,1,0,sHargaAVG);
	END IF;
	IF (select jenisbrg from tm_barang where kodebrg=sKodeBrg)="Inventory" then 
		SELECT 
			(IFNULL(sum(IFNULL(a.saldoawal,0)),0) +
			IFNULL((select sum(IFNULL(b.jml,0) * IFNULL(b.Konv,1)) from tr_beli_d b where a.kodebrg=b.kodebrg AND a.KodeGD=b.KodeGD),0) -
			IFNULL((select sum(IFNULL(c.jml,0) * IFNULL(c.Konv,1)) from tr_retbeli_d c where a.kodebrg=c.kodebrg AND a.KodeGD=c.KodeGD),0) -
			IFNULL((select sum(IFNULL(d.jml,0) * IFNULL(d.Konv,1)) from tr_jualr_d d where a.kodebrg=d.kodebrg AND a.KodeGD=d.KodeGD),0) +
			IFNULL((select sum(IFNULL(e.jml,0) * IFNULL(e.Konv,1)) from tr_retjualr_d e where a.kodebrg=e.kodebrg AND a.KodeGD=e.KodeGD),0) -
			IFNULL((select sum(IFNULL(f.jml,0) * IFNULL(f.Konv,1)) from tr_jual_d f where a.kodebrg=f.kodebrg AND a.KodeGD=f.KodeGD),0) +
			IFNULL((select sum(IFNULL(g.jml,0) * IFNULL(g.Konv,1)) from tr_retjual_d g where a.kodebrg=g.KodeBrg AND a.KodeGD=g.KodeGD),0) -
			IFNULL((select sum(IFNULL(j.jumlah,0) * IFNULL(j.Konv,1)) from tr_pindahgd_d j where a.kodebrg=j.KodeBrg AND a.KodeGD=j.KodeGDAsal),0) +
			IFNULL((select sum(IFNULL(k.jumlah,0) * IFNULL(k.Konv,1)) from tr_pindahgd_d k where a.kodebrg=k.KodeBrg AND a.KodeGD=k.KodeGDTujuan),0) -
			IFNULL((select sum(l.SelisihKurang) from tr_koreksistc_d l where a.kodebrg=l.kodebrg AND a.KodeGD=l.KodeGD),0) +
			IFNULL((select sum(m.SelisihLebih) from tr_koreksistc_d m where a.kodebrg=m.kodebrg AND a.KodeGD=m.KodeGD),0) 
			) INTO sJmlStock
		FROM tb_saldoawal a WHERE a.kodebrg=sKodeBrg AND a.KodeGD=sKodeGD;
		UPDATE tm_stockbrg SET stockakhir=sJmlStock WHERE KodeBrg=sKodeBrg AND KodeGD=sKodeGD;
	END IF; 
END;