 --
 -- PostgreSQL database dump complete
 --
-

    tanggal date NOT NULL,
    no_anggota character varying(20) NOT NULL,
    jumlah integer NOT NULL,
    keterangan character varying(50) NOT NULL
);

--

    LANGUAGE plpgsql
    AS $$                   
begin
    if(new.kode_simpanan like '%SPSKRL%') then
    update anggota 
    set total_simpanan = total_simpanan + new.jumlah
    where no_anggota = new.no_anggota;
    update anggota
    set total_simpanan_sukarela = total_simpanan_sukarela + new.jumlah
    where no_anggota = new.no_anggota;
    return new;
    
    elsif(new.kode_simpanan like '%SPWJB%') then
    update anggota 
    set total_simpanan = total_simpanan + new.jumlah
    where no_anggota = new.no_anggota;
    update anggota
    set total_simpanan_wajib = total_simpanan_wajib + new.jumlah
    where no_anggota = new.no_anggota;
    return new;
    
    elsif(new.kode_simpanan like '%AMSP%') then
    update anggota 
    set total_simpanan = total_simpanan - new.jumlah
    where no_anggota = new.no_anggota;
    update anggota
    set total_simpanan_sukarela = total_simpanan_sukarela - new.jumlah
    where no_anggota = new.no_anggota;
    return new;

    end if; 
end;
$$;

