modify

wzy

2021-01-23 7e1f978bec370d032d6ac34bb515750ccc7c193c

modify

 zq-erp/src/main/resources/config/application.properties

@@ -6,8 +6,11 @@

spring.datasource.username=ct_test
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://120.27.238.55:3306/hive_test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8
spring.datasource.url=jdbc:mysql://120.27.238.55:3306/hive_prd?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8

#spring.datasource.username=root
#spring.datasource.password=root
#spring.datasource.url=jdbc:mysql://localhost:3306/hive_plus?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8


spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

 zq-erp/src/test/java/com/matrix/SourceFlowTests.java

@@ -2,14 +2,10 @@

import com.matrix.core.tools.StringUtils;
import com.matrix.system.constance.Dictionary;
import com.matrix.system.hive.bean.MoneyCardUse;
import com.matrix.system.hive.bean.ShoppingGoods;
import com.matrix.system.hive.bean.SysSourceFlow;
import com.matrix.system.hive.bean.SysVipInfo;
import com.matrix.system.hive.dao.MoneyCardUseDao;
import com.matrix.system.hive.dao.ShoppingGoodsDao;
import com.matrix.system.hive.dao.SysSourceFlowDao;
import com.matrix.system.hive.dao.SysVipInfoDao;
import com.matrix.system.hive.bean.*;
import com.matrix.system.hive.dao.*;
import com.matrix.system.hive.service.CodeService;
import com.matrix.system.hive.service.SysOrderService;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
@@ -19,6 +15,7 @@
import org.springframework.transaction.annotation.Transactional;

import javax.sql.DataSource;
import java.math.BigDecimal;
import java.util.List;

/**
@@ -29,7 +26,7 @@
 * @date 2019年2月25日
 */
@RunWith(SpringRunner.class)
@SpringBootTest
@SpringBootTest(classes = {ZqErpApplication.class},webEnvironment =SpringBootTest.WebEnvironment.RANDOM_PORT)
public class SourceFlowTests {

    @Autowired
@@ -102,5 +99,76 @@

    }

    @Autowired
    private SysOrderDao sysOrderDao;

    @Autowired
    private CodeService codeService;

    @Autowired
    private SysOrderItemDao sysOrderItemDao;

    @Autowired
    private SysOrderFlowDao sysOrderFlowDao;

    /**
     * sysOrderFlowDao.xml insert语句需将createTime和updateTime修改
     * SysOrderDao.xml insert语句需将update语句中cashPay加上 or cashPay == 0
     *
     */
    @Test
    public void orderTransfer() {
        SysOrder query = new SysOrder();
        query.setStatu("已付款");
        List<SysOrder> sysOrders = sysOrderDao.selectByModel(query);

        for (SysOrder sysOrder : sysOrders) {
            sysOrder.setCashPay(sysOrder.getZkTotal());
            sysOrder.setCardPay(0);
            sysOrderDao.update(sysOrder);

            List<SysOrderItem> items = sysOrderItemDao.selectByOrderId(sysOrder.getId());

            SysOrderFlow flow = new SysOrderFlow();
            flow.setFlowNo("F" + sysOrder.getOrderNo().substring(1) + "-" + 1);
            if (items.size() <= 0) {
                continue;
            }
            Long goodsId = items.get(0).getGoodsId();
            ShoppingGoods goods = shoppingGoodsDao.selectById(goodsId);

            int j = 1;
            boolean flag = false;
            while (goods == null) {
                if (items.size() <= 1) {
                    flag = true;
                    break;
                }
                goodsId = items.get(j).getGoodsId();
                goods = shoppingGoodsDao.selectById(goodsId);
                j++;
                if (j + 1 >= items.size()) {
                    flag = true;
                    break;
                }
            }

            if (flag) {
                continue;
            }

            flow.setFlowContent(goods.getName().trim() + "等" + items.size() + "件产品");
            flow.setOrderId(sysOrder.getId());
            flow.setAmount(BigDecimal.valueOf(sysOrder.getZkTotal()));
            flow.setVipId(sysOrder.getVipId());
            flow.setFlowType(SysOrderFlow.FLOW_TYPE_BUY);
            flow.setPayMethod("现金");
            flow.setShopId(sysOrder.getShopId());
            flow.setCreateTime(sysOrder.getOrderTime());
            flow.setUpdateTime(sysOrder.getOrderTime());
            flow.setCompanyId(sysOrder.getCompanyId());
            sysOrderFlowDao.insert(flow);
        }
    }

}