package com.matrix;

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 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.annotation.Rollback;
import org.springframework.test.context.junit4.SpringRunner;
import org.springframework.transaction.annotation.Transactional;

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

/**
 * 测试类示例
 * 
 * @author jiangyouyao
 * @email 512061637@qq.com
 * @date 2019年2月25日
 */
@RunWith(SpringRunner.class)
@SpringBootTest
public class SourceFlowTests {

	@Autowired
	DataSource dataSource;

	@Test
	public void contextLoads() {
		System.out.println(dataSource.getClass());
	}


	@Autowired
	private SysSourceFlowDao sysSourceFlowDao;

	@Autowired
	private ShoppingGoodsDao shoppingGoodsDao;


	@Autowired
	private SysVipInfoDao vipInfoDao;



	@Test
	@Transactional
	@Rollback
	public void insertFlow() {
		SysSourceFlow sysSourceFlow=new SysSourceFlow();
		sysSourceFlow.setCreateBy("1");
		sysSourceFlow.setUpdateBy("2");

		sysSourceFlowDao.insert(sysSourceFlow);
	}


	@Test
	@Transactional
	@Rollback(false)
	public void initGoodsPingyin() {

		List<ShoppingGoods> shoppingGoods = shoppingGoodsDao.selectByModel(null);
		shoppingGoods.forEach(shoppingGood -> {
			shoppingGood.setZjm(StringUtils.toHanyuPinyin(shoppingGood.getName())+","+StringUtils.toHeadWordHanyuPinyin(shoppingGood.getName()));
			ShoppingGoods s=new ShoppingGoods();
			s.setId(shoppingGood.getId());
			s.setZjm(shoppingGood.getZjm());
			shoppingGoodsDao.update(s);
		});

	}


	@Test
	@Transactional
	@Rollback(false)
	public void initVipInfoPingyin() {

		List<SysVipInfo> vipInfoList = vipInfoDao.selectByModel(null);
		vipInfoList.forEach(sysVipInfo -> {
			if(StringUtils.isNotBlank(sysVipInfo.getVipName())){
				String name=  sysVipInfo.getVipName().replaceAll("[\\x{10000}-\\x{10FFFF}]", "");
				sysVipInfo.setZjm(StringUtils.toHanyuPinyin(name)+","+StringUtils.toHeadWordHanyuPinyin(name));
				SysVipInfo s=new SysVipInfo();
				s.setId(sysVipInfo.getId());
				s.setZjm(sysVipInfo.getZjm());
				vipInfoDao.update(s);
			}

		});

	}


}