From 3ac30b4c17cf071ce9c66a59c069ab83efae6d2d Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期一, 14 十月 2019 17:44:13 +0800
Subject: [PATCH] Merge branch 'div' of ssh://193.112.35.168:29418/fanli-server into div
---
fanli/src/main/java/com/yeshi/fanli/util/elme/ElmeOrderUtil.java | 82 ++++++++++++++++++++++++++++++++++++++--
1 files changed, 77 insertions(+), 5 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/util/elme/ElmeOrderUtil.java b/fanli/src/main/java/com/yeshi/fanli/util/elme/ElmeOrderUtil.java
index 024f868..4ebb5e3 100644
--- a/fanli/src/main/java/com/yeshi/fanli/util/elme/ElmeOrderUtil.java
+++ b/fanli/src/main/java/com/yeshi/fanli/util/elme/ElmeOrderUtil.java
@@ -1,9 +1,17 @@
package com.yeshi.fanli.util.elme;
import java.io.InputStream;
+import java.math.BigDecimal;
+import java.util.ArrayList;
+import java.util.Date;
import java.util.List;
import com.yeshi.fanli.entity.elme.ElmeOrder;
+import com.yeshi.fanli.util.MoneyBigDecimalUtil;
+import com.yeshi.fanli.util.TimeUtil;
+
+import jxl.Sheet;
+import jxl.Workbook;
public class ElmeOrderUtil {
@@ -14,12 +22,76 @@
* @return
*/
public static List<ElmeOrder> parseOrder(InputStream input) {
+ List<ElmeOrder> list = new ArrayList<>();
+ try {
+ jxl.Workbook rwb = Workbook.getWorkbook(input);
+ Sheet sheet = rwb.getSheet(0);
+ for (int r = 1; r < sheet.getRows(); r++) {
+ ElmeOrder order = new ElmeOrder();
+ for (int c = 0; c < sheet.getColumns(); c++) {
+ String content = sheet.getCell(c, r).getContents();
+ String columnName = sheet.getCell(c, 0).getContents().trim();
+ switch (columnName) {
+ case "娓犻亾鍙�":
+ order.setChannelId(content);
+ break;
+ case "娓犻亾鍚嶇О":
+ order.setChannelName(content);
+ break;
+ case "track_pid":
+ order.setTrackPid(content);
+ break;
+ case "rid":
+ order.setRid(content);
+ break;
+ case "璁㈠崟鏃ユ湡":
+ order.setOrderDate(new Date(TimeUtil.convertToTimeTemp(content, "yyyy-MM-dd")));
+ break;
+ case "璁㈠崟鍙�":
+ order.setOrderId(content.replace("<", "").replace(">", ""));
+ break;
+ case "鏀粯閲戦":
+ order.setPayMoney(new BigDecimal(content));
+ break;
+ case "涓嬪崟鍩庡競":
+ order.setCity(content);
+ break;
+ case "鐢ㄥ埜閲戦":
+ order.setCouponMoney(new BigDecimal(content));
+ break;
+ case "鏄惁鏂板棣栧崟":
+ order.setNewerFirstOrder(Integer.parseInt(content));
+ break;
+ case "鏄惁鏂板澶嶈喘鍗�":
+ order.setNewerRepayOrder(Integer.parseInt(content));
+ break;
+ case "鏄惁浣跨敤娣樺绾㈠寘":
+ order.setTaokeHongBao(Integer.parseInt(content));
+ break;
+ case "鏄惁鏈夊湪浼氬満鍐呰闂ㄥ簵鐨勭偣鍑昏褰�":
+ order.setShopClick(Integer.parseInt(content));
+ break;
+ case "鏄惁棰嗗埜鍚�7澶╁唴棣栧崟":
+ order.setRecieveCoupon7DayFirstOrder(Integer.parseInt(content));
+ break;
+ case "鏄惁6缁撲剑":
+ if ("鏄�".equalsIgnoreCase(content))
+ order.setIsSettle(true);
+ else
+ order.setIsSettle(false);
+ break;
+ }
+ }
+ list.add(order);
+ }
+ rwb.close();
+ } catch (Exception e) {
+ }
+ return list;
+ }
-
-
-
-
- return null;
+ public static BigDecimal getCommission(BigDecimal payMoney) {
+ return MoneyBigDecimalUtil.mul(payMoney, new BigDecimal("0.06"));
}
}
--
Gitblit v1.8.0