fanli-server.git

New file
			@@ -0,0 +1,84 @@
			package com.yeshi.fanli.entity.bus.user;

			import java.util.Date;

			import org.yeshi.utils.mybatis.Column;
			import org.yeshi.utils.mybatis.Table;


			/**
			* 券激活进度
			* @author Administrator
			*
			*/
			@Table("yeshi_ec_user_system_coupon_activate")
			public class UserSystemCouponActivate {

			// 初始
			public final static int STATE_INIT = 0;
			// 激活完成
			public final static int STATE_END = 1;

			// 用户券id
			@Column(name = "usca_id")
			private Long id;

			// 已完成数量
			@Column(name = "usca_count")
			private Integer count;

			// 激活状态
			@Column(name = "usca_state")
			private Integer state;

			// 创建时间
			@Column(name = "usca_create_time")
			private Date createTime;

			// 更新时间
			@Column(name = "usca_update_time")
			private Date updateTime;



			public Long getId() {
			return id;
			}

			public void setId(Long id) {
			this.id = id;
			}

			public Integer getCount() {
			return count;
			}

			public void setCount(Integer count) {
			this.count = count;
			}

			public Integer getState() {
			return state;
			}

			public void setState(Integer state) {
			this.state = state;
			}

			public Date getCreateTime() {
			return createTime;
			}

			public void setCreateTime(Date createTime) {
			this.createTime = createTime;
			}

			public Date getUpdateTime() {
			return updateTime;
			}

			public void setUpdateTime(Date updateTime) {
			this.updateTime = updateTime;
			}

			}

New file
			@@ -0,0 +1,74 @@
			package org.yeshi.utils.wx;

			import java.io.BufferedReader;
			import java.io.InputStream;
			import java.io.InputStreamReader;
			import java.util.ArrayList;
			import java.util.List;

			import org.yeshi.utils.entity.wx.RedPackRecord;

			public class WXRedPackUtil {

			public static List<RedPackRecord> readCsv(InputStream inStream) throws Exception {
			List<RedPackRecord> list = new ArrayList<RedPackRecord>();
			RedPackRecord record = null;

			BufferedReader reader = new BufferedReader(new InputStreamReader(inStream, "GBK"));
			// 换成你的文件名
			// BufferedReader reader=new BufferedReader(new InputStreamReader(new
			// FileInputStream(path),"GBK"));

			String line = null;
			// 第一行信息，为标题信息，不用,如果需要，注释掉
			reader.readLine();

			while ((line = reader.readLine()) != null) {
			// CSV格式文件为逗号分隔符文件，这里根据逗号切分
			String item[] = line.split(",");
			// 用户openid
			String openId = getValue(item, 3);
			if (openId == null \|\| openId.trim().length() == 0)
			break;

			record = new RedPackRecord();
			record.setOpenId(openId);
			record.setSendTime(getCsvDate(getValue(item, 0))); // 发送时间
			record.setDetailno(getValue(item, 10)); // 红包订单号
			record.setBillno(getValue(item, 11)); // 商户订单号

			String status = getValue(item, 6);
			if (status != null && status.trim().length() > 0) {
			record.setStatus(status);
			if ("已领取".equals(status)) {
			record.setRcvTime(getCsvDate(getValue(item, 7)));
			} else if ("过期未领退款".equals(status)) {
			record.setRcvTime(getCsvDate(getValue(item, 8)));
			}
			}
			list.add(record);
			}
			return list;
			}

			public static String getValue(String[] item, int index) {
			if (item != null && item.length > index) {
			String value = item[index];
			return value;
			}
			return null;
			}

			public static String getCsvDate(String item) throws Exception {
			if (item == null \|\| item.trim().length() == 0)
			return null;

			if (item.indexOf("/") > 0) {
			item = item.replaceAll("/", "-");
			} else if (item.indexOf("年") > 0) {
			item = item.replaceAll("年", "-").replaceAll("月", "-").replaceAll("日", "");
			}
			return item;
			}

			}

	fanli/src/main/java/com/yeshi/fanli/entity/bus/user/UserSystemCouponActivate.java	84 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	utils/src/main/java/org/yeshi/utils/wx/WXRedPackUtil.java	74 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史