Javashop 7.0 商城订单重复修改办法

本文仅适合Javashop 7.0  版本

需求:重启redis，商城订单重复如何修改

需要建个临时表作为中转。

select * from es_trade where trade_sn in (select order_sn from testa);
select * from es_transaction_record where order_sn in (select order_sn from testa);
select * from es_payment_bill where sn in (select order_sn from testa);
select * from es_pay_log where order_sn in (select order_sn from testa);
select * from es_order_out_status where order_sn in (select order_sn from testa);
select * from es_order_meta where order_sn in (select order_sn from testa);
select * from es_order_log where order_sn in (select order_sn from testa);
select * from es_order_items where order_sn in (select order_sn from testa);
select * from es_groupbuy_quantity_log where order_sn in (select order_sn from testa);
select * from es_bill_item where order_sn in (select order_sn from testa);
select * from es_order where sn in (select order_sn from testa);
select * from shop_statistics.es_sss_order_goods_data where order_sn in (select order_sn from testa);
select * from shop_statistics.es_sss_order_data where sn in (select order_sn from testa);
select * from shop_statistics.es_sss_refund_data where order_sn in (select order_sn from testa);
select * from shop_goods.es_quantity_log where order_sn in (select order_sn from testa);



delete shop_trade.testa;
insert into shop_trade.testa select trade_sn from shop_trade.es_order where FROM_UNIXTIME(create_time, '%Y-%m-%d')='2019-01-31';



update shop_trade.es_refund set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_trade set trade_sn=trade_sn+100000 where trade_sn in (select order_sn from testa);
update shop_trade.es_transaction_record set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_payment_bill set sn=sn+100000 where sn in (select order_sn from testa);
update shop_trade.es_pay_log set order_sn=order_sn+100000,pay_log_sn=pay_log_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_order_out_status set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_order_meta set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_order_log set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_order_items set trade_sn=trade_sn+100000,order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_groupbuy_quantity_log set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_bill_item set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_trade.es_order set trade_sn=trade_sn+100000,sn=sn+100000 where sn in (select order_sn from testa);

update shop_statistics.es_sss_order_goods_data set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_statistics.es_sss_order_data set sn=sn+100000 where sn in (select order_sn from testa);
update shop_statistics.es_sss_refund_data set refund_sn=refund_sn+100000,order_sn=order_sn+100000 where order_sn in (select order_sn from testa);
update shop_goods.es_quantity_log set order_sn=order_sn+100000 where order_sn in (select order_sn from testa);