Akal-akalan warga

use db_sik;

create trigger tr_obat_kurangi
on obat_pasien
after insert
as
declare @beli int, @id_obat char(5);
select @beli = qty from inserted;
select @id_obat = id_obat from inserted;
update obat set quantity = quantity - @beli where id_obat = @id_obat;
go

drop trigger tr_obat_kurangi

insert into obat_pasien(id_kunjungan,id_obat,qty) values(2,'o0005',2);

create trigger tr_obat_tambah
on obat_pasien
after delete
as
declare @beli int, @id_obat char(5);
select @beli = qty from deleted;
select @id_obat = id_obat from deleted;
update obat set quantity = quantity + @beli where id_obat = @id_obat;
go

select * from obat_pasien
select * from obat

delete * from obat
----------------------------------------------------------------------------------------------------
create trigger tr_obat_tambah
on obat_pasien
after delete
as
declare @beli int, @id_obat char(5);
select @beli = qty from deleted;
select @id_obat = id_obat from deleted;
exec proc_kurangi_stok @beli,@id_obat
go

create procedure proc_kurangi_stok
@beli int,
@id_obat char(5)
AS
update obat set quantity = quantity + @beli
where id_obat = @id_obat;
GO

---------------------------------------------------------------------------------------------------------------------------

create trigger tr_obat_1
on obat
after insert
as
declare @qty int
select @qty = quantity from inserted;
if @qty > 2
begin
print 'Quantity Lebih'
end
else if @qty < 2
begin
print 'Quantity Kurang'
Rollback Transaction
end
else
begin
print 'Pass'
end
end
go

-----------------------------------------------------------------------------------------------------------------------------