INSERT INTO `ver01`(`id`, `version`, `apk_name`, `generate_date`, `note`) VALUES (10, 'ifs.pda.6.4.x.zeson.260110.1', 'ZESON26011001.apk', '2026-01-10 13:49:19', NULL);
DELIMITER //
DROP PROCEDURE if EXISTs `proc_deal_inv22_adj`;//
DELIMITER ;

DELIMITER //
CREATE PROCEDURE `proc_deal_inv22_adj`(IN id_source VARCHAR(60),in ids varchar(60),in types varchar(60),in var_source varchar(60),out int_result int)
begin
 	#盘点单
	declare counts integer default 0;
	declare flag_check varchar(60) ;
	declare check_result varchar(60);
	DECLARE var_serial VARCHAR(60);
	declare dec_qty DECIMAL(20,7);
	declare dec_weight DECIMAL(20,7);
	DECLARE dec_tare DECIMAL(20,7);

	select i22_var_serial,i22_dec_qty,i22_dec_weight,i22_dec_tare 
	into var_serial,dec_qty,dec_weight,dec_tare 
	from inv22 
	where i22_id = ids;

	set int_result = 0;

	update inv31
	set  
	i31_dec_loss = i31_dec_loss + i31_dec_end - dec_weight,
	i31_dec_end = dec_weight,
	i31_dec_tare = dec_tare,
	i31_dec_adj = dec_weight-(i31_dec_in-i31_dec_out ),
	i31_dec_adj_qty = dec_qty-(i31_dec_in_qty-i31_dec_out_qty ),
	i31_date_last_check = NOW()
	where i31_id = var_serial;

	update inv22,inv21 
	set i22_dec_weight_ori =inv21.i21_dec_end
	where inv21.i21_var_serial= inv22.i22_var_serial 
	and inv22.i22_id =ids; 

	update inv21,inv22
	set 
	inv21.i21_dec_end = inv22.i22_dec_weight,
	inv21.i21_dec_tare=inv22.i22_dec_tare,
	inv21.i21_dec_adj=inv22.i22_dec_weight-(inv21.i21_dec_in-inv21.i21_dec_out ),
	inv21.i21_dec_adj_qty=inv22.i22_dec_qty-(inv21.i21_dec_in_qty-inv21.i21_dec_out_qty ),
	i21_date_last_check = NOW()
	where inv21.i21_var_serial= inv22.i22_var_serial 
	and inv22.i22_id = ids;
		
	#删除库存为空的记录
	DELETE FROM inv21 WHERE i21_var_serial = var_serial AND i21_dec_end <= 0;
		
end//
DELIMITER ;