package com.yeshi.fanli.controller.admin; import java.io.PrintWriter; import java.util.List; import java.util.Map; import javax.annotation.Resource; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.yeshi.utils.JsonUtil; import com.google.gson.Gson; import com.google.gson.GsonBuilder; import com.yeshi.fanli.controller.admin.utils.AdminUtils; import com.yeshi.fanli.dto.ChartTDO; import com.yeshi.fanli.entity.bus.user.UserSystemCouponGiveRecord; import com.yeshi.fanli.service.inter.count.UserSystemCouponCountService; import com.yeshi.fanli.service.inter.user.UserSystemCouponGiveRecordService; import com.yeshi.fanli.tag.PageEntity; import com.yeshi.fanli.util.Constant; import com.yeshi.fanli.util.StringUtil; import com.yeshi.fanli.vo.user.SystemCouponVO; import com.yeshi.fanli.vo.user.UserSystemCouponCountVO; import net.sf.json.JSONArray; import net.sf.json.JSONObject; @Controller @RequestMapping("admin/new/api/v1/userCoupon") public class UserSystemCouponAdminController { @Resource private UserSystemCouponCountService userSystemCouponCountService; @Resource private UserSystemCouponGiveRecordService userSystemCouponGiveRecordService; /** * 用户奖励券列表 * * @param callback * @param pageIndex * @param pageSize * @param key * @param keyType 1-用户id、 2来源 * @param state * @param percent * @param out */ @RequestMapping(value = "listRebateCoupon") public void listRebateCoupon(String callback, Integer pageIndex, Integer pageSize, String key, Integer keyType, Integer state, Integer percent, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } try { List list = userSystemCouponCountService .listRebateCoupon((pageIndex - 1) * pageSize, pageSize, key, keyType, state, percent); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = userSystemCouponCountService.countRebateCoupon(key, keyType, state, percent); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } @RequestMapping(value = "listSystemRebateCoupon") public void listSystemRebateCoupon(String callback, Integer pageIndex, Integer pageSize, String key, Integer sort, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } try { List list = userSystemCouponCountService .listSystemCouponByRebate((pageIndex - 1) * pageSize, pageSize, key, sort); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = userSystemCouponCountService.countSystemCouponRebate(key); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } @RequestMapping(value = "listSystemFreeCoupon") public void listSystemFreeCoupon(String callback, Integer pageIndex, Integer pageSize, String key, Integer sort, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } try { List list = userSystemCouponCountService.listSystemCouponByFree((pageIndex - 1) * pageSize, pageSize, key, sort); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = list.size(); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } /** * 用户奖励券列表 * * @param callback * @param pageIndex * @param pageSize * @param key * @param keyType 1-用户id、 2来源 * @param state * @param percent * @param out */ @RequestMapping(value = "listFreeCoupon") public void listFreeCoupon(String callback, Integer pageIndex, Integer pageSize, String key, Integer keyType, Integer state, Integer activated, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } try { List list = userSystemCouponCountService.listFreeCoupon((pageIndex - 1) * pageSize, pageSize, key, keyType, state, activated); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = userSystemCouponCountService.countFreeCoupon(key, keyType, state, activated); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } /** * 用户奖励券列表 * * @param callback * @param pageIndex * @param pageSize * @param key * @param keyType 1-用户id、 2来源 * @param state * @param percent * @param out */ @RequestMapping(value = "listFreeCouponRecord") public void listFreeCouponRecord(String callback, Integer pageIndex, Integer pageSize, String key, Integer keyType, Integer state, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } try { List list = userSystemCouponCountService .listFreeCouponRecord((pageIndex - 1) * pageSize, pageSize, key, keyType, state); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = userSystemCouponCountService.countFreeCouponRecord(key, keyType, state); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } /** * 查询赠送免券 * @param callback * @param pageIndex * @param pageSize * @param key * @param type 1赠送免单券 、2-奖励券 * @param state * @param out */ @RequestMapping(value = "listGiveCoupon") public void listGiveCoupon(String callback, Integer pageIndex, Integer pageSize, String key, Integer type, Integer state, PrintWriter out) { if (pageIndex == null || pageIndex < 1) { pageIndex = 1; } if (pageSize == null || pageSize < 1) { pageSize = Constant.PAGE_SIZE; } String couponType = null; if (type != null) { if (type == 1) { couponType = "freeCouponGive"; } else if (type == 2){ couponType = "rebatePercentCoupon"; } } try { List list = userSystemCouponGiveRecordService.listGiveRecord((pageIndex - 1) * pageSize, pageSize, couponType, state); if (list == null || list.size() == 0) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("暂无数据")); return; } long count = userSystemCouponGiveRecordService.countGiveRecord(couponType, state); int totalPage = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1); PageEntity pe = new PageEntity(pageIndex, pageSize, count, totalPage); GsonBuilder gsonBuilder = new GsonBuilder(); gsonBuilder.serializeNulls(); Gson gson = gsonBuilder.setDateFormat("yyyy/MM/dd HH:mm:ss").create(); JSONObject data = new JSONObject(); data.put("pe", pe); data.put("result_list", gson.toJson(list)); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("操作异常")); e.printStackTrace(); } } /** * 奖励券数量曲线图 * @param callback * @param dateType * @param year * @param startTime * @param endTime * @param out */ @RequestMapping(value = "getRebateCouponUsedNumCharts") public void getRebateCouponUsedNumCharts(String callback, Integer dateType, String year, String startTime, String endTime, PrintWriter out){ try { String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime); if (validateMsg != null) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg)); return; } JSONObject data = getChartsData(dateType, year, startTime, endTime, 1, null); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("系统异常")); e.printStackTrace(); } } /** * 奖励券数量曲线图 * @param callback * @param dateType * @param year * @param startTime * @param endTime * @param out */ @RequestMapping(value = "getRebateCouponMoneyCharts") public void getRebateCouponMoneyCharts(String callback, Integer dateType, String year, String startTime, String endTime, PrintWriter out){ try { String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime); if (validateMsg != null) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg)); return; } JSONObject data = getChartsData(dateType, year, startTime, endTime, 2, null); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("系统异常")); e.printStackTrace(); } } /** * 奖励券数量曲线图 * @param callback * @param dateType * @param year * @param startTime * @param endTime * @param out */ @RequestMapping(value = "getFreeCouponMoneyCharts") public void getFreeCouponMoneyCharts(String callback, Integer dateType, String year, String startTime, String endTime, Integer coupon, PrintWriter out){ try { if (coupon == null || (coupon.intValue() < 0 && coupon.intValue() > 4)) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("券类型不正确")); return; } String validateMsg = AdminUtils.validateParams(dateType, startTime, endTime); if (validateMsg != null) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult(validateMsg)); return; } String couponType = null; if (coupon == 1) { couponType = "freeCoupon"; } else if (coupon == 2){ couponType = "welfareFreeCoupon"; } else if (coupon == 3){ couponType = "freeCouponBuy"; } JSONObject data = getChartsData(dateType, year, startTime, endTime, 3, couponType); JsonUtil.printMode(out, callback, JsonUtil.loadTrueResult(data)); } catch (Exception e) { JsonUtil.printMode(out, callback, JsonUtil.loadFalseResult("系统异常")); e.printStackTrace(); } } public JSONObject getChartsData(Integer dateType, String year, String startTime, String endTime, int source, String couponType) throws Exception { if (dateType != 1 && (!StringUtil.isNullOrEmpty(startTime) || !StringUtil.isNullOrEmpty(endTime))) { startTime = null; endTime = null; } if (dateType == 1 && year != null) { year = null; } else if (dateType == 2) { if (startTime != null) startTime = null; if (endTime != null) endTime = null; } else if (dateType == 3) { if (year != null) year = null; if (startTime != null) startTime = null; if (endTime != null) endTime = null; } Gson gson = new Gson(); List dateList = AdminUtils.getDateList(dateType, startTime, endTime, year); JSONObject innerList = new JSONObject(); List list = null; if (source == 1) { // 奖励券数量 innerList.put("name", "数量"); list = userSystemCouponCountService.getRebateCouponUsedNumToCharts(dateType, year, startTime, endTime); } else if (source == 2) { // 奖励券金额 innerList.put("name", "金额"); list = userSystemCouponCountService.getRebateCouponMoneyToCharts(dateType, year, startTime, endTime); } else if (source == 3) { // 奖励券金额 innerList.put("name", "金额"); list = userSystemCouponCountService.getFreeCouponMoneyToCharts(dateType, year, startTime, endTime, couponType); } Object objectDate = null; if (dateType != 3) { innerList.put("data", gson.toJson(AdminUtils.dayOrMonthDataFactory(dateType, dateList, list))); } else { // 年视图 Map map = AdminUtils.yearsDataFactory(list); if (objectDate == null) { objectDate = map.get("date"); } innerList.put("data", gson.toJson(map.get("value"))); } JSONArray line_list = new JSONArray(); line_list.add(innerList); JSONObject data = new JSONObject(); if (objectDate != null) { data.put("xAxis_list", gson.toJson(objectDate)); } else { data.put("xAxis_list", gson.toJson(dateList)); } data.put("line_list", line_list); return data; } }