订单统计 + 资金明细

yujian

2019-11-27 e915a40b79552686b8d8a8cfc48a341fa2c0f518

 fanli/src/main/java/com/yeshi/fanli/controller/admin/ExtractAdminController.java

@@ -1,8 +1,10 @@
package com.yeshi.fanli.controller.admin;



import java.io.OutputStream;

import java.io.PrintWriter;

import java.math.BigDecimal;

import java.net.URLDecoder;

import java.net.URLEncoder;

import java.text.ParseException;

import java.text.SimpleDateFormat;

import java.util.ArrayList;

@@ -13,21 +15,29 @@


import javax.annotation.Resource;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;



import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.multipart.commons.CommonsMultipartFile;

import org.yeshi.utils.DateUtil;

import org.yeshi.utils.IPUtil;

import org.yeshi.utils.JsonUtil;

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

import org.yeshi.utils.wx.WXRedPackUtil;



import com.google.gson.Gson;

import com.google.gson.GsonBuilder;

import com.google.gson.reflect.TypeToken;

import com.yeshi.fanli.controller.admin.utils.AdminUtils;

import com.yeshi.fanli.dto.ChartTDO;

import com.yeshi.fanli.entity.bus.user.Extract;

import com.yeshi.fanli.entity.bus.user.ExtractAuditRecord;

import com.yeshi.fanli.entity.bus.user.HongBaoV2;

import com.yeshi.fanli.entity.bus.user.UserInfo;

import com.yeshi.fanli.entity.bus.user.UserInfoExtra;

import com.yeshi.fanli.entity.common.AdminUser;

import com.yeshi.fanli.exception.ExtractException;

import com.yeshi.fanli.exception.NotExistObjectException;

@@ -35,14 +45,16 @@
import com.yeshi.fanli.log.LogHelper;

import com.yeshi.fanli.service.AdminUserService;

import com.yeshi.fanli.service.inter.config.ConfigService;

import com.yeshi.fanli.service.inter.count.ExtractCountService;

import com.yeshi.fanli.service.inter.count.HongBaoV2CountService;

import com.yeshi.fanli.service.inter.count.UserInfoCountService;

import com.yeshi.fanli.service.inter.money.extract.ExtractAuditRecordService;

import com.yeshi.fanli.service.inter.money.extract.ExtractCountService;

import com.yeshi.fanli.service.inter.money.extract.ExtractService;

import com.yeshi.fanli.service.inter.order.CommonOrderCountService;

import com.yeshi.fanli.service.inter.order.tb.TaoBaoOrderService;

import com.yeshi.fanli.service.inter.order.tb.TaoBaoWeiQuanOrderService;

import com.yeshi.fanli.service.inter.push.PushRecordService;

import com.yeshi.fanli.service.inter.taobao.TaoBaoOrderService;

import com.yeshi.fanli.service.inter.taobao.TaoBaoWeiQuanOrderService;

import com.yeshi.fanli.service.inter.user.ExtractAuditRecordService;

import com.yeshi.fanli.service.inter.user.ExtractService;

import com.yeshi.fanli.service.inter.user.UserInfoExtraService;

import com.yeshi.fanli.tag.PageEntity;

import com.yeshi.fanli.util.Constant;

import com.yeshi.fanli.util.RedisManager;

@@ -91,6 +103,12 @@


   @Resource

   private TaoBaoWeiQuanOrderService taoBaoWeiQuanOrderService;



   @Resource

   private UserInfoExtraService userInfoExtraService;



   @Resource

   private CommonOrderCountService commonOrderCountService;



   /**

    * 

@@ -382,6 +400,11 @@
            if (adminUser == null) {

               record.setAdminUser(new AdminUser());

            }

            // 查询用户备注信息

            UserInfoExtra extra = userInfoExtraService.getUserInfoExtra(record.getExtract().getUserInfo().getId());

            if (extra != null) {

               record.getExtract().getUserInfo().setStateDesc(extra.getMark());

            }



            int warnLevel = 0;

            Extract extract = record.getExtract();

@@ -390,28 +413,60 @@
               if (extractState != null && extractState == Extract.STATE_NOT_PROCESS) {

                  UserInfo userInfo = extract.getUserInfo();

                  if (userInfo != null) {

                     BigDecimal countTodayMoney = extractService.sumTodayApplyMoney(userInfo.getId());

                     BigDecimal countTodayMoney = extractService.sumTodayApplyMoney(userInfo.getId(),

                           TimeUtil.getGernalTime(extract.getExtractTime()));

                     if (countTodayMoney.compareTo(new BigDecimal(100)) > 0) {

                        warnLevel = 1;

                     }

                  }

               }



            }



            if (record.getExtraInfo() != null) {

               if (record.getExtraInfo().getOrderCount50More() > 0

                     || record.getExtraInfo().getWeiQuanOrderCount() > 0

                     || record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(0)) > 0)

                  warnLevel = 2;

               StringBuffer desc = new StringBuffer();

               desc.append("大于50元订单:" + record.getExtraInfo().getOrderCount50More() + "\n#");

               desc.append("维权订单数:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");

               desc.append("维权订单退回金额:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");

               desc.append("180天安全订单数:" + record.getExtraInfo().getSafeOrderCount());

               if (System.currentTimeMillis() > TimeUtil.convertToTimeTemp("2019-06-21", "yyyy-MM-dd")) {

                  desc.append("大笔订单数:" + record.getExtraInfo().getOrderCount50More() + "\n#");

                  desc.append("维权订单数:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");

                  desc.append("维权订单佣金:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");

                  if (record.getExtraInfo().getOrderCount50More() > 0

                        || record.getExtraInfo().getWeiQuanOrderCount() > 1

                        || record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(10)) >= 0)

                     warnLevel = 2;

               } else {

                  if (record.getExtraInfo().getOrderCount50More() > 0

                        || record.getExtraInfo().getWeiQuanOrderCount() > 0

                        || record.getExtraInfo().getWeiQuanOrderFanAmount().compareTo(new BigDecimal(0)) > 0)

                     warnLevel = 2;

                  desc.append("大于50元订单:" + record.getExtraInfo().getOrderCount50More() + "\n#");

                  desc.append("维权订单数:" + record.getExtraInfo().getWeiQuanOrderCount() + "\n#");

                  desc.append("维权订单退回金额:" + record.getExtraInfo().getWeiQuanOrderFanAmount() + "\n#");

                  desc.append("180天安全订单数:" + record.getExtraInfo().getSafeOrderCount());

               }

               record.setExtraInfoStr(desc.toString());

            }



            // if (warnLevel == 0) {

            // // 查询同店铺商品，同商品订单超过一定数量的

            // List<Integer> typeList = new ArrayList<>();

            // typeList.add(HongBaoV2.TYPE_ZIGOU);

            // long sameGoodsOrderCount =

            // commonOrderCountService.countSameGoodsOrderByUidAndHongBaoType(typeList,

            // record.getExtract().getUserInfo().getId(),

            // Integer.parseInt(configService.get("admin_min_same_goods_order_count")));

            // long sameShopOrderCount =

            // commonOrderCountService.countSameShopOrderByUidAndHongBaoType(typeList,

            // record.getExtract().getUserInfo().getId(),

            // Integer.parseInt(configService.get("admin_min_same_shop_order_count")));

            // if (sameGoodsOrderCount > 0 || sameShopOrderCount > 0) {

            // warnLevel = 3;

            // record.setExtraInfoStr(

            // String.format("同店铺:%s 同商品:%s", sameShopOrderCount,

            // sameGoodsOrderCount));

            // }

            // }



            record.setWarnLevel(warnLevel);



         }



         int count = extractAuditRecordService.getMyAuditedTimeSlotCount(key, state, null, days);

@@ -420,6 +475,8 @@


         GsonBuilder gsonBuilder = new GsonBuilder();

         gsonBuilder.serializeNulls();

         gsonBuilder.setDateFormat("yyyy-MM-dd HH:mm:ss");



         Gson gson = gsonBuilder.create();



         JSONObject data = new JSONObject();

@@ -432,6 +489,27 @@
         e.printStackTrace();

         out.print(JsonUtil.loadFalseResult(e.getMessage()));

      }

   }



   @RequestMapping(value = "getMyAuditedDanger")

   public void getMyAuditedDanger(String callback, Long uid, PrintWriter out) {

      if (uid == null) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("请登录"));

         return;

      }

      // 查询同店铺商品，同商品订单超过一定数量的

      List<Integer> typeList = new ArrayList<>();

      typeList.add(HongBaoV2.TYPE_ZIGOU);

      long sameGoodsOrderCount = commonOrderCountService.countSameGoodsOrderByUidAndHongBaoType(typeList, uid,

            Integer.parseInt(configService.get("admin_min_same_goods_order_count")));

      long sameShopOrderCount = commonOrderCountService.countSameShopOrderByUidAndHongBaoType(typeList, uid,

            Integer.parseInt(configService.get("admin_min_same_shop_order_count")));

      if (sameGoodsOrderCount > 0 || sameShopOrderCount > 0) {

         String text = (String.format("同店铺:%s 同商品:%s", sameShopOrderCount, sameGoodsOrderCount));

         JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(text));

         return;

      }

      JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("店铺/商品无异常"));

   }



   /**

@@ -534,6 +612,13 @@
               surplusTime = DateUtil.dateDiff(formattodayTime, formatTime);

            }



            String mark = "";

            UserInfoExtra userInfoExtra = userInfoExtraService.getUserInfoExtra(extract.getUserInfo().getId());

            if (userInfoExtra != null && !StringUtil.isNullOrEmpty(userInfoExtra.getMark())) {

               mark = "警惕！！ " + userInfoExtra.getMark();

            }



            data.put("mark", mark);

            data.put("extract", extract);

            data.put("beforeMoney", beforeMoney);

            data.put("surplusTime", surplusTime);

@@ -597,6 +682,13 @@
                  surplusTime = DateUtil.dateDiff(formattodayTime, formatTime);

               }



               String mark = "";

               UserInfoExtra userInfoExtra = userInfoExtraService.getUserInfoExtra(extract.getUserInfo().getId());

               if (userInfoExtra != null && !StringUtil.isNullOrEmpty(userInfoExtra.getMark())) {

                  mark = "警惕！！ " + userInfoExtra.getMark();

               }



               data.put("mark", mark);

               data.put("extract", extract);

               data.put("beforeMoney", beforeMoney);

               data.put("surplusTime", surplusTime);

@@ -809,9 +901,8 @@
               innerList.put("name", "驳回数");

            }



            List<Map<String, Object>> list = extractAuditRecordService.countAuditTotal(state, dateType, year,

                  startTime, endTime);



            List<ChartTDO> list = extractAuditRecordService.countAuditTotal(state, dateType, year, startTime,

                  endTime);

            if (dateType != 3) {

               innerList.put("data", gson.toJson(AdminUtils.dayOrMonthDataFactory(dateType, dateList, list)));

            } else {

@@ -823,7 +914,6 @@
               }

               innerList.put("data", gson.toJson(map.get("value")));

            }



            line_list.add(innerList);

         }



@@ -835,9 +925,7 @@
         }



         data.put("line_list", line_list);



         JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));



      } catch (Exception e) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常"));

         e.printStackTrace();

@@ -863,7 +951,6 @@
   @RequestMapping(value = "getExtractApplyMoney")

   public void getExtractApplyMoney(String callback, Integer dateType, String year, String startTime, String endTime,

         PrintWriter out) {



      String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime);

      if (validateMsg != null) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg));

@@ -896,13 +983,11 @@
         List<String> dateList = AdminUtils.getDateList(dateType, startTime, endTime, year);



         Gson gson = new Gson();

         JSONArray line_list = new JSONArray();



         JSONObject innerList = new JSONObject();

         innerList.put("name", "总计");



         List<Map<String, Object>> list = extractAuditRecordService.countExtractApplyMoney(null, dateType, year,

               startTime, endTime);

         List<ChartTDO> list = extractAuditRecordService.countExtractApplyMoney(null, dateType, year, startTime,

               endTime);



         if (dateType != 3) {

            innerList.put("data", gson.toJson(AdminUtils.dayOrMonthDataFactory(dateType, dateList, list)));

@@ -916,6 +1001,7 @@
            innerList.put("data", gson.toJson(map.get("value")));

         }



         JSONArray line_list = new JSONArray();

         line_list.add(innerList);



         JSONObject data = new JSONObject();

@@ -926,9 +1012,7 @@
         }



         data.put("line_list", line_list);



         JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));



      } catch (Exception e) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常"));

         e.printStackTrace();

@@ -956,7 +1040,6 @@
   @RequestMapping(value = "getExtractApplyNumber")

   public void getExtractApplyNumber(String callback, Integer state, Integer dateType, String year, String startTime,

         String endTime, PrintWriter out) {



      String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime);

      if (validateMsg != null) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg));

@@ -984,18 +1067,15 @@
      }



      try {



         Object objectDate = null;

         List<String> dateList = AdminUtils.getDateList(dateType, startTime, endTime, year);



         Gson gson = new Gson();

         JSONArray line_list = new JSONArray();

         List<String> dateList = AdminUtils.getDateList(dateType, startTime, endTime, year);



         JSONObject innerList = new JSONObject();

         innerList.put("name", "总计");



         List<Map<String, Object>> list = extractAuditRecordService.countExtractApplyNumber(null, dateType, year,

               startTime, endTime);

         List<ChartTDO> list = extractAuditRecordService.countExtractApplyNumber(null, dateType, year, startTime,

               endTime);



         if (dateType != 3) {

            innerList.put("data", gson.toJson(AdminUtils.dayOrMonthDataFactory(dateType, dateList, list)));

@@ -1009,6 +1089,7 @@
            innerList.put("data", gson.toJson(map.get("value")));

         }



         JSONArray line_list = new JSONArray();

         line_list.add(innerList);



         JSONObject data = new JSONObject();

@@ -1019,13 +1100,141 @@
         }



         data.put("line_list", line_list);



         JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));



      } catch (Exception e) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常"));

         e.printStackTrace();

      }

   }



   /**

    * 下载提现红包Openid

    * 
    * @param callback

    * @param response

    * @param out

    */

   @RequestMapping(value = "downAutoExtractTxt")

   public void downAutoExtractTxt(String callback, HttpServletResponse response, PrintWriter out) {

      try {

         //List<String> list = extractService.getAutoExtractOpenIds();

         List<String> list = extractService.getAutoExtractOpenIdsTo1212();

         if (list == null || list.size() <= 1) {

            JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无用户满足自动提现条件"));

            return;

         }



         String filepath = "自动提现OpenId " + java.lang.System.currentTimeMillis() + ".txt";

         response.reset();

         response.setContentType("application/octet-stream");

         String fileName = URLDecoder.decode(filepath, "utf-8");

         response.addHeader("Content-Disposition",

               "attachment;" + "filename=\"" + URLEncoder.encode(fileName, "utf-8") + "\"");



         StringBuilder sb = new StringBuilder();

         for (String t : list) {

            sb.append(t + "\r\n");

         }



         String opid_str = sb.toString();

         if (!StringUtil.isNullOrEmpty(opid_str) && opid_str.endsWith("\r\n")) {

            opid_str = opid_str.substring(0, opid_str.length() - 2);

         }



         OutputStream os = response.getOutputStream();

         byte[] byt = opid_str.getBytes();

         os.write(byt);

         os.flush();

         os.close();

      } catch (Exception e) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常"));

         e.printStackTrace();

      }

   }



   /**

    * 上传提现红包Excel

    * 
    * @param file

    * @param out

    */

   @RequestMapping(value = "uploadExcel", method = RequestMethod.POST)

   public void uploadExcel(@RequestParam("file") CommonsMultipartFile file, PrintWriter out) {

      if (file == null) {

         out.print(JsonUtil.loadFalseResult("上传文件不能为空！"));

         return;

      }



      try {

         List<RedPackRecord> list = WXRedPackUtil.readCsv(file.getInputStream());

         extractService.updateManualExtractRecord(list);

         out.print(JsonUtil.loadTrueResult("上传成功"));

      } catch (ExtractException e) {

         out.print(JsonUtil.loadFalseResult(e.getMsg()));

      } catch (Exception e) {

         e.printStackTrace();

         out.print(JsonUtil.loadFalseResult("上传失败"));

      }

   }



	
   public static String getValue(String[] item,int index){

        if(item.length > index){

            String value = item[index];

            return value;

        }

        return "";

    }

	
   /**

    * 预览红包发生人

    * 
    * @param callback

    * @param pageIndex

    * @param out

    */

   @RequestMapping(value = "preAutoUser")

   public void preAutoUser(String callback, Integer pageIndex, PrintWriter out) {

      try {

         //List<UserInfo> list = extractService.preAutoUser();

         List<UserInfo> list = extractService.preAutoUserTo1212();

         if (list == null || list.isEmpty()) {

            JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无用户满足自动提现条件"));

            return;

         }



         if (pageIndex == null || pageIndex < 1) {

            pageIndex = 1;

         }



         Integer pageSize = 100;

         if (pageSize == null || pageSize < 1) {

            pageSize = Constant.PAGE_SIZE;

         }



         int count = list.size();

         int totalPage = count % pageSize == 0 ? count / pageSize : count / pageSize + 1;

         PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage);



         List<UserInfo> listResult = null;

         if (pageIndex < totalPage) {

            int start = (pageIndex - 1) * pageSize;

            listResult = list.subList(start, start + pageSize);

         } else if (pageIndex == totalPage) {

            listResult = list.subList((pageIndex - 1) * pageSize, list.size());

         } else {

            JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("没有更多了"));

            return;

         }



         JSONObject data = new JSONObject();

         data.put("pe", pe);

         data.put("result_list", listResult);

         JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data));

      } catch (Exception e) {

         JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常"));

         e.printStackTrace();

      }

   }

}