20211108

xiaoyong931011

2021-11-10 66b02aac92f89c9d5df3e75d6d342634092f0dd4

20211108

 gc-shop/src/test/java/com/xzx/gc/CodeTest.java

New file
@@ -0,0 +1,101 @@
package com.xzx.gc;

import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.StrUtil;
import com.github.pagehelper.PageHelper;
import com.xzx.gc.common.constant.Constants;
import com.xzx.gc.entity.AddressInfo;
import com.xzx.gc.shop.dto.QueryGoodsListDto;
import com.xzx.gc.shop.dto.QueryJhyOrderListDto;
import com.xzx.gc.shop.mapper.JhyOrderItemsMapper;
import com.xzx.gc.shop.mapper.JhyOrderMapper;
import com.xzx.gc.shop.mapper.ScoreGoodsMapper;
import com.xzx.gc.shop.vo.JhyOrderItemsVo;
import com.xzx.gc.shop.vo.QueryGoodsListVo;
import com.xzx.gc.shop.vo.QueryJhyOrderListVo;
import lombok.extern.slf4j.Slf4j;
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 javax.annotation.Resource;
import java.util.ArrayList;
import java.util.List;

@Slf4j
@RunWith(SpringRunner.class)
@SpringBootTest(classes = {GcShopApplication.class})
@ActiveProfiles("dev")
public class CodeTest {

    @Autowired
    private ScoreGoodsMapper scoreGoodsMapper;
    @Autowired
    private JhyOrderMapper jhyOrderMapper;
    @Autowired
    private JhyOrderItemsMapper jhyOrderItemsMapper;

    @Test
    public void goodsList(){
        QueryGoodsListDto model = new QueryGoodsListDto();
        String name = model.getName() == null ? "":model.getName();
        int delFlag = model.getDelFlag() == null ? 2:model.getDelFlag();
        int namePx = model.getNamePx() == null ? 7:model.getNamePx();
        int typePx = model.getTypePx() == null ? 2:model.getTypePx();
        PageHelper.startPage(model.getPage(), model.getLimit());

        List<QueryGoodsListVo> maps = scoreGoodsMapper.queryGoodsList(name,delFlag,1,1,namePx,typePx);
        System.out.println(maps.toString());

    }
    @Test
    public void jhyOrderList(){
        QueryJhyOrderListDto model = new QueryJhyOrderListDto();
        List<Integer> status = new ArrayList<>();
        if(CollUtil.isEmpty(model.getStatus())){
            status.add(1);
            status.add(2);
            status.add(3);
            status.add(4);
            status.add(5);
            status.add(6);
            model.setStatus(status);
        }

        List<QueryJhyOrderListVo> maps = jhyOrderMapper.queryOrderList(model);
        if(CollUtil.isNotEmpty(maps)){
            for(QueryJhyOrderListVo queryJhyOrderListVo : maps){
                Long id = queryJhyOrderListVo.getId();
                List<JhyOrderItemsVo> jhyOrderItemsVos = jhyOrderItemsMapper.selectByOrderId(id);
                queryJhyOrderListVo.setJhyOrderItemsVos(jhyOrderItemsVos);

                String orderAddr = queryJhyOrderListVo.getAddress();
                Long userId = queryJhyOrderListVo.getUserId();
                List<AddressInfo> addressInfos = jhyOrderMapper.selectAddRessInfoByUserId(userId);
                if(CollUtil.isNotEmpty(addressInfos)){
                    for(AddressInfo addressInfo : addressInfos){
                        StringBuffer address = new StringBuffer();
                        address.append(addressInfo.getDetailAddress());
                        if (StrUtil.isNotBlank(addressInfo.getTagName())) {
                            address.append(StrUtil.isNotBlank(addressInfo.getHouseName()) ? addressInfo.getHouseName() : "");
                            if (Constants.ADDRESS_TYPE_HOME.equals(addressInfo.getTagName())) {
                                address.append(StrUtil.isNotBlank(addressInfo.getHouseNumber()) ? addressInfo.getHouseNumber() : "");
                                address.append(StrUtil.isNotBlank(addressInfo.getUnitName()) ? addressInfo.getUnitName() : "");
                            }
                        }
                        if (orderAddr.equals(addressInfo.getAddressArea() + address)) {
                            queryJhyOrderListVo.setUnitName(addressInfo.getUnitName());
                            System.out.println(orderAddr);
                            queryJhyOrderListVo.setHouseNumber(addressInfo.getHouseNumber());
                        }
                    }
                }
            }
        }

    }

}

 gc-user/src/test/java/CodeTest.java

@@ -26,6 +26,8 @@
import cn.hutool.poi.excel.ExcelUtil;

import cn.hutool.poi.excel.ExcelWriter;

import com.aliyuncs.exceptions.ClientException;

import com.github.pagehelper.PageHelper;

import com.xzx.gc.GcUserApplication;

import com.xzx.gc.common.Result;

import com.xzx.gc.common.constant.Constants;

import com.xzx.gc.common.constant.OrderEnum;

@@ -38,20 +40,26 @@
import com.xzx.gc.common.utils.gdmap.GdTraceUtil;

import com.xzx.gc.common.utils.image.QrCodeBaseUtils;

import com.xzx.gc.common.utils.image.QrCodeGraphicsUtils;

import com.xzx.gc.entity.AddressInfo;

import com.xzx.gc.entity.HomeServiceInfo;

import com.xzx.gc.entity.PartnerFence;

import com.xzx.gc.entity.UserInfo;

import com.xzx.gc.entity.*;

import com.xzx.gc.user.dto.JhyInfoListDto;

import com.xzx.gc.user.service.JhyInfoService;

import com.xzx.gc.user.vo.JhyInfoListVo;

import com.xzx.gc.util.BeanUtils;

import lombok.Data;

import lombok.extern.slf4j.Slf4j;

import net.coobird.thumbnailator.Thumbnails;

import org.apache.commons.lang3.RandomStringUtils;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.locationtech.spatial4j.context.SpatialContext;

import org.locationtech.spatial4j.distance.DistanceUtils;

import org.locationtech.spatial4j.shape.Rectangle;

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 sun.misc.Regexp;

import tk.mybatis.mapper.entity.Example;



import javax.imageio.ImageIO;

import java.awt.*;

@@ -71,8 +79,25 @@
import java.util.regex.Pattern;

import java.util.stream.Collectors;





@Slf4j

@RunWith(SpringRunner.class)

@SpringBootTest(classes = {GcUserApplication.class})

@ActiveProfiles("dev")

public class CodeTest {



    @Autowired

    private JhyInfoService jhyInfoService;



    @Test

    public void jhyList(){

        JhyInfoListDto jhyInfoListDto = new JhyInfoListDto();

        jhyInfoListDto.setPage(1);

        jhyInfoListDto.setLimit(10);

        jhyInfoListDto.setIsJhy(1);

        Map<String, Object> stringObjectMap = jhyInfoService.queryList(jhyInfoListDto);

        System.out.println(stringObjectMap.get("date"));

    }





    @Test

@@ -137,30 +162,32 @@


    @Test

    public void ex(){

        ArrayList<Map<String, Object>> rows = new ArrayList<>();

        String str = null;

        for(int i = 0;i < 100000;i++){

        Map<String, Object> row1 = new LinkedHashMap<>();

        row1.put("姓名", "张三");

        row1.put("年龄", 23);

        row1.put("成绩", 88.32);

        row1.put("是否合格", true);

        row1.put("考试日期", DateUtil.date());



        Map<String, Object> row2 = new LinkedHashMap<>();

        row2.put("姓名", "李四");

        row2.put("年龄", 33);

        row2.put("成绩", 59.50);

        row2.put("是否合格", false);

        row2.put("考试日期", DateUtil.date());



        ArrayList<Map<String, Object>> rows = CollUtil.newArrayList(row1, row2);



        System.out.println(rows);

//                str = "M0"+RandomUtil.randomString(8).toUpperCase();

//                str = "M1"+RandomUtil.randomString(8).toUpperCase();

//                str = "M2"+RandomUtil.randomString(8).toUpperCase();

//                str = "M3"+RandomUtil.randomString(8).toUpperCase();

//                str = "M4"+RandomUtil.randomString(8).toUpperCase();

//                str = "M5"+RandomUtil.randomString(8).toUpperCase();

//                str = "M6"+RandomUtil.randomString(8).toUpperCase();

//                str = "M7"+RandomUtil.randomString(8).toUpperCase();

//                str = "M8"+RandomUtil.randomString(8).toUpperCase();

                str = "M9"+RandomUtil.randomString(8).toUpperCase();

            row1.put("编码", str);

            rows.add(row1);

        }

        Set<Map<String, Object>> maps = RandomUtil.randomEleSet(rows, 10000);

        System.out.println(maps);



        // 通过工具类创建writer

        ExcelWriter writer = ExcelUtil.getWriter("d:/writeMapTest.xlsx");

        ExcelWriter writer = ExcelUtil.getWriter("d:/编码M9.xlsx");

// 合并单元格后的标题行，使用默认标题样式

        writer.merge(row1.size() - 1, "一班成绩单");

//        writer.merge(maps.size() - 1, "编码");

// 一次性写出内容，使用默认样式，强制输出标题

        writer.write(rows, true);

        writer.write(maps, true);

// 关闭writer，释放内存

        writer.close();