ALTER TABLE `tm_barang`
ADD COLUMN `Konv4`  double NULL AFTER `Satuan3`,
ADD COLUMN `Satuan4`  varchar(10) NULL AFTER `Konv4`,
ADD COLUMN `KodeBrg4`  varchar(20) NULL AFTER `KodeBrg3`;
ALTER TABLE `tm_barang`
ADD COLUMN `Konv5`  double NULL AFTER `Satuan4`,
ADD COLUMN `Satuan5`  varchar(10) NULL AFTER `Konv5`,
ADD COLUMN `Konv6`  double NULL AFTER `Satuan5`,
ADD COLUMN `Satuan6`  varchar(10) NULL AFTER `Konv6`,
ADD COLUMN `HargaAvg6`  double NULL AFTER `HargaAvg5`,
ADD COLUMN `KodeBrg5`  varchar(20) NULL AFTER `KodeBrg4`,
ADD COLUMN `KodeBrg6`  varchar(20) NULL AFTER `KodeBrg5`;
ALTER TABLE `tm_barang`
ADD COLUMN `HargaSet6`  double NULL AFTER `HargaSet5`;

ALTER TABLE `tm_stockbrg`
ADD COLUMN `Stock4`  double NULL AFTER `Stock3`;

ALTER TABLE `tm_stockbrg`
ADD COLUMN `Stock5`  double NULL AFTER `Stock4`,
ADD COLUMN `Stock6`  double NULL AFTER `Stock5`;


DROP TRIGGER `groupstock`;
CREATE TRIGGER `groupstock` BEFORE UPDATE ON `tm_stockbrg`
FOR EACH ROW begin
if (select ifnull(konv6,0) from tm_barang where kodebrg=new.kodebrg) > 0 then
set new.stock6=new.stockakhir div (select konv6 from tm_barang where kodebrg=new.kodebrg);
end if;
if (select ifnull(konv5,0) from tm_barang where kodebrg=new.kodebrg) > 0 then
set new.stock5=new.stockakhir div (select konv5 from tm_barang where kodebrg=new.kodebrg);
end if;
if (select ifnull(konv4,0) from tm_barang where kodebrg=new.kodebrg) > 0 then
set new.stock4=new.stockakhir div (select konv4 from tm_barang where kodebrg=new.kodebrg);
end if;
if (select ifnull(konv3,0) from tm_barang where kodebrg=new.kodebrg) > 0 then
set new.stock3=new.stockakhir div (select konv3 from tm_barang where kodebrg=new.kodebrg);
end if;
if (select ifnull(konv2,0) from tm_barang where kodebrg=new.kodebrg) > 0 then
set new.stock2=(new.stockakhir - ifnull((new.stock3* (select konv3 from tm_barang where kodebrg=new.kodebrg)),0) ) div  (select konv2 from tm_barang where kodebrg=new.kodebrg);
end if;
if (select ifnull(konv1,0) from tm_barang where kodebrg=new.kodebrg) >0 then
	set new.stock1=(new.stockakhir - 
(
ifnull(new.stock6,0)* (select ifnull(konv6,0) from tm_barang where kodebrg=new.kodebrg) +
ifnull(new.stock5,0)* (select ifnull(konv5,0) from tm_barang where kodebrg=new.kodebrg) +
ifnull(new.stock4,0)* (select ifnull(konv4,0) from tm_barang where kodebrg=new.kodebrg) +
ifnull(new.stock3,0)* (select ifnull(konv3,0) from tm_barang where kodebrg=new.kodebrg) + 
ifnull(new.stock2,0)* (select ifnull(konv2,0) from tm_barang where kodebrg=new.kodebrg)
)) div  (select ifnull(konv1,1000000000000000000000) from tm_barang where kodebrg=new.kodebrg);
end if;
set new.stock0=(new.stockakhir- 
(
ifnull(new.stock6* (select konv6 from tm_barang where kodebrg=new.kodebrg),0) +
ifnull(new.stock5* (select konv5 from tm_barang where kodebrg=new.kodebrg),0) +
ifnull(new.stock4* (select konv4 from tm_barang where kodebrg=new.kodebrg),0) +
ifnull(new.stock3* (select konv3 from tm_barang where kodebrg=new.kodebrg),0) + 
ifnull(new.stock2 *(select konv2 from tm_barang where kodebrg=new.kodebrg),0) + 
ifnull(new.stock1 * (select konv1 from tm_barang where kodebrg=new.kodebrg),0)
)
);
end;