import com.xzx.gc.GcUserApplication;
import com.xzx.gc.entity.AddressInfo;
import com.xzx.gc.entity.OrderDetailInfo;
import com.xzx.gc.entity.OrderInfo;
import com.xzx.gc.entity.UserTargetInfo;
import com.xzx.gc.user.mapper.*;
import com.xzx.gc.user.service.AddressService;
import com.xzx.gc.user.service.UserService;
import com.xzx.gc.user.service.UserTargetInfoService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.ActiveProfiles;
import org.springframework.test.context.junit4.SpringRunner;
import tk.mybatis.mapper.entity.Example;

import java.util.ArrayList;
import java.util.List;


@RunWith(SpringRunner.class)
@SpringBootTest(classes = {GcUserApplication.class})
@ActiveProfiles("fix")
public class FixTest {

    @Autowired
    private UserTargetInfoService userTargetInfoService;


    @Autowired
    private UserTargetInfoMapper userTargetInfoMapper;


    @Autowired
    private UserService userService;


    @Autowired
    private AddressService addressService;

    @Autowired
    private AddressMapper addressMapper;

    @Autowired
    private OrderMapper orderMapper;

    @Autowired
    private OrderDetailMapper orderDetailMapper;

    @Autowired
    private OrderDetailBatchMapper orderDetailBatchMapper;


    @Test
    public void fixtaeget(){
        //修复意向客户的地址问题
        Example example=new Example(UserTargetInfo.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andEqualTo("regsterType",3);
        criteria.andIsNull("provinceId");
        List<UserTargetInfo> userTargetInfo1 = userTargetInfoMapper.selectByExample(example);
        for (UserTargetInfo userTargetInfo : userTargetInfo1) {
            String mobile = userTargetInfo.getMobile();
            AddressInfo addressInfo=new AddressInfo();
            addressInfo.setDelFlag("0");
            addressInfo.setFlag("1");
            addressInfo.setMobilePhone(mobile);
            AddressInfo addressInfo1 = addressMapper.selectOne(addressInfo);
            if(addressInfo1!=null){
                userTargetInfoService.updateTargetUserAddr(addressInfo1);
            }
        }
        System.out.println("修复了"+userTargetInfo1.size()+"条记录");
    }


    @Test
    public void fixOrderAdd(){
        //修复订单地址id
        Example example=new Example(OrderDetailInfo.class);
        Example.Criteria criteria = example.createCriteria();
        criteria.andIsNull("addressId");
        List<OrderDetailInfo> orderDetailInfos = orderDetailMapper.selectByExample(example);

        List<OrderDetailInfo> list=new ArrayList<>();
        for (OrderDetailInfo orderDetailInfo : orderDetailInfos) {
            OrderDetailInfo detailInfo=new OrderDetailInfo();
            String orderId = orderDetailInfo.getOrderId();
            OrderInfo orderInfo = orderMapper.selectByPrimaryKey(orderId);
            String createUserId = orderInfo.getCreateUserId();

            Long addressId;
            AddressInfo addressInfo=new AddressInfo();
            addressInfo.setUserId(createUserId);
            addressInfo.setFlag("1");
            addressInfo.setDelFlag("0");
            AddressInfo addressInfo1 = addressMapper.selectOne(addressInfo);
            if(addressInfo1!=null){
                addressId=addressInfo1.getAddressId();
            }else {
                //找删除的数据里最新的那条
                Example example1=new Example(AddressInfo.class);
                Example.Criteria criteria1 = example1.createCriteria();
                criteria1.andEqualTo("userId",createUserId);
                criteria1.andEqualTo("flag","1");
                example1.orderBy("createTime").desc();
                List<AddressInfo> addressInfos = addressMapper.selectByExample(example1);
                addressId=addressInfos.get(0).getAddressId();
            }

            detailInfo.setOrderId(orderDetailInfo.getOrderId());
            detailInfo.setAddressId(addressId);
            list.add(detailInfo);
        }

        orderDetailBatchMapper.updateBatchByPrimaryKeySelective(list);
    }

}