From e8e121f25066c46aa35408af5ffa78f1917639ef Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Thu, 15 Jul 2021 15:05:52 +0800 Subject: [PATCH] Merge branch 'score-shop' of http://120.27.238.55:7000/r/xzx into score-shop --- gc-user/src/main/java/com/xzx/gc/user/vo/OrderItemsVo.java | 34 +++ gc-user/src/main/java/com/xzx/gc/user/vo/ViewDistribInfoVo.java | 46 +++++ gc-user/src/main/java/com/xzx/gc/user/vo/ViewSettingVo.java | 2 gc-user/src/main/java/com/xzx/gc/user/dto/ProhibitDistribDto.java | 14 + gc-user/src/main/java/com/xzx/gc/user/dto/DistribDataListDto.java | 36 ++++ gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java | 15 + gc-user/src/main/java/com/xzx/gc/user/vo/DistribDataListVo.java | 43 ++++ gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java | 28 +++ gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java | 109 ++++++++++-- gc-user/src/main/resources/mapper/user/AccountMapper.xml | 96 ++++++++++ gc-user/src/main/java/com/xzx/gc/user/dto/UserHeadInfoListDto.java | 21 ++ gc-user/src/main/java/com/xzx/gc/user/dto/DistribListDto.java | 2 gc-user/src/main/java/com/xzx/gc/user/dto/ViewDistribInfoDto.java | 11 + gc-user/src/main/java/com/xzx/gc/user/dto/UpdateSettingDto.java | 2 gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java | 65 ++++++ 15 files changed, 494 insertions(+), 30 deletions(-) diff --git a/gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java b/gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java index 2c1bff9..4769299 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java +++ b/gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java @@ -12,9 +12,7 @@ import com.xzx.gc.user.mapper.AccountMapper; import com.xzx.gc.user.mapper.RedPaperRuleMapper; import com.xzx.gc.user.service.DistribService; -import com.xzx.gc.user.vo.DistribInfoListVo; -import com.xzx.gc.user.vo.DistribListVo; -import com.xzx.gc.user.vo.ViewSettingVo; +import com.xzx.gc.user.vo.*; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import io.swagger.annotations.ApiResponse; @@ -126,6 +124,67 @@ return JsonResult.success(distribService.distribInfoList(distribInfoListDto)); } + /** + * 查看团长信息详情-个人信息 + */ + @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/distrib/viewDistribInfo.json") + @ApiResponses({@ApiResponse( code = 200, message = "success", response = ViewDistribInfoVo.class)}) + @ApiOperation(value="团长列表-个人信息详情", notes="test: 仅0有正确返回") + public JsonResult<ViewDistribInfoVo> viewDistribInfo(@RequestBody ViewDistribInfoDto viewDistribInfoDto) { + String id = viewDistribInfoDto.getId(); + AccountInfo accountInfo = accountMapper.selectByPrimaryKey(id); + if(ObjectUtil.isEmpty(accountInfo)){ + return JsonResult.failMessage("账户不存在!"); + } + ViewDistribInfoVo viewDistribInfoVo = distribService.viewDistribInfo(id); + return JsonResult.success(viewDistribInfoVo); + } + + @ApiOperation(value = "团长列表-团队信息") + @ApiResponses( + @ApiResponse(code = 200, message = "success", response = UserHeadInfoVo.class) + ) + @PostMapping(value = Constants.ADMIN_VIEW_PREFIX + "/distrib/userHeadInfoList.json") + public JsonResult<Map<String, Object>> userHeadInfoList(@RequestBody UserHeadInfoListDto userHeadInfoListDto) { + return JsonResult.success(distribService.userHeadInfoList(userHeadInfoListDto)); + } + + @ApiOperation(value = "团长列表-订单详情") + @ApiResponses( + @ApiResponse(code = 200, message = "success", response = OrderItemsVo.class) + ) + @PostMapping(value = Constants.ADMIN_VIEW_PREFIX + "/distrib/orderItemsList.json") + public JsonResult<Map<String, Object>> orderItemsList(@RequestBody UserHeadInfoListDto userHeadInfoListDto) { + return JsonResult.success(distribService.orderItemsList(userHeadInfoListDto)); + } + + /** + * 启用禁用团长 + */ + @PostMapping(Constants.ADMIN_VIEW_PREFIX + "/distrib/prohibitDistrib.json") + @ApiOperation(value="分銷系統管理--启用禁用团长", notes="test: 仅0有正确返回") + public JsonResult prohibitDistrib(@RequestBody ProhibitDistribDto model, HttpServletRequest request) { + String id = model.getId(); + AccountInfo accountInfo = accountMapper.selectByPrimaryKey(id); + if(ObjectUtil.isEmpty(accountInfo)){ + return JsonResult.failMessage("账户不存在!"); + } + distribService.prohibitDistrib(model); + OperationAppLog build = OperationAppLog.builder().appPrograme(CommonEnum.后台.getValue()).opreateName(getAdminName(request)) + .methodName(Constants.USER_MODUL_NAME).operateAction("分銷系統管理--启用禁用团长-"+id).build(); + mqUtil.sendApp(build); + return JsonResult.success("操作成功!"); + } + + @ApiOperation(value = "团长数据") + @ApiResponses( + @ApiResponse(code = 200, message = "success", response = DistribDataListVo.class) + ) + @PostMapping(value = Constants.ADMIN_VIEW_PREFIX + "/distrib/distribDataList.json") + public JsonResult<Map<String, Object>> distribDataList(@RequestBody DistribDataListDto distribDataListDto) { + return JsonResult.success(distribService.distribDataList(distribDataListDto)); + } + } diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/DistribDataListDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/DistribDataListDto.java new file mode 100644 index 0000000..5dad086 --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/DistribDataListDto.java @@ -0,0 +1,36 @@ +package com.xzx.gc.user.dto; + +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +@Data +@ApiModel(value = "DistribDataListDto", description = "加入团长参数接收类") +public class DistribDataListDto { + + @ApiModelProperty(value = "第几页", required = true) + private int page; + + @ApiModelProperty(value = "每一页数量", required = true) + private int limit; + + @ApiModelProperty(value = "查询字段") + private String queryCol; + + @JsonFormat(shape=JsonFormat.Shape.STRING,pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") + @ApiModelProperty(value="开始时间") + private Date reserveTimeStart; + + @JsonFormat(shape=JsonFormat.Shape.STRING,pattern = "yyyy-MM-dd HH:mm:ss",timezone = "GMT+8") + @ApiModelProperty(value="结束时间") + private Date reserveTimeEnd; + + @ApiModelProperty(hidden = true) + private String name; + @ApiModelProperty(hidden = true) + private String Phone; + +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/DistribListDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/DistribListDto.java index 25dc84b..652a0aa 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/dto/DistribListDto.java +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/DistribListDto.java @@ -17,7 +17,9 @@ @ApiModelProperty(value = "查询字段") private String queryCol; + @ApiModelProperty(hidden = true) private String name; + @ApiModelProperty(hidden = true) private String Phone; } diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/ProhibitDistribDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/ProhibitDistribDto.java new file mode 100644 index 0000000..b99b360 --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/ProhibitDistribDto.java @@ -0,0 +1,14 @@ +package com.xzx.gc.user.dto; + +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +public class ProhibitDistribDto { + + @ApiModelProperty(required=true) + private String Id; + + @ApiModelProperty(value ="是否冻结 0:未冻结,1:冻结 " ,required=true) + private Integer status; +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/UpdateSettingDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/UpdateSettingDto.java index 5ba5dee..daae8c1 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/dto/UpdateSettingDto.java +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/UpdateSettingDto.java @@ -23,7 +23,7 @@ //团员完成(FinishOrderNum)单后,团员每完成一单团长获得(pointReward)积分: @ApiModelProperty(value = "团员完成(FinishOrderNum)单后,团员每完成一单团长获得(pointReward)积分:") - private Integer finishOrderNum; +// private Integer finishOrderNum; private Integer pointReward; @ApiModelProperty("0:不启用,1:启用") diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/UserHeadInfoListDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/UserHeadInfoListDto.java new file mode 100644 index 0000000..0164b58 --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/UserHeadInfoListDto.java @@ -0,0 +1,21 @@ +package com.xzx.gc.user.dto; + +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.Date; + +@Data +@ApiModel(value = "UserHeadInfoListDto", description = "参数接收类") +public class UserHeadInfoListDto { + + private String id; + + @ApiModelProperty(value="第几页",required=true) + private int page; + + @ApiModelProperty(value="每一页数量",required=true) + private int limit; +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/dto/ViewDistribInfoDto.java b/gc-user/src/main/java/com/xzx/gc/user/dto/ViewDistribInfoDto.java new file mode 100644 index 0000000..3b04fac --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/dto/ViewDistribInfoDto.java @@ -0,0 +1,11 @@ +package com.xzx.gc.user.dto; + +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +public class ViewDistribInfoDto { + + @ApiModelProperty("id") + private String id; +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java b/gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java index 14236ae..5029c4f 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java +++ b/gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java @@ -1,14 +1,15 @@ package com.xzx.gc.user.mapper; import com.xzx.gc.entity.AccountInfo; +import com.xzx.gc.entity.JhyOrderItems; import com.xzx.gc.entity.OrderInfo; import com.xzx.gc.entity.ScoreDetails; import com.xzx.gc.model.admin.AccountMoneyModel; import com.xzx.gc.model.admin.UserAccountModel; +import com.xzx.gc.user.dto.DistribDataListDto; import com.xzx.gc.user.dto.DistribInfoListDto; import com.xzx.gc.user.dto.DistribListDto; -import com.xzx.gc.user.vo.DistribInfoListVo; -import com.xzx.gc.user.vo.DistribListVo; +import com.xzx.gc.user.vo.*; import com.xzx.gc.util.GcMapper; import org.apache.ibatis.annotations.Param; import org.springframework.stereotype.Repository; @@ -52,5 +53,15 @@ List<DistribListVo> selectDsitribListByQueryCol(@Param("record")DistribListDto distribListDto); List<DistribInfoListVo> selectDsitribInfoListByQueryCol(@Param("record")DistribInfoListDto distribInfoListDto); + + ViewDistribInfoVo selectDistribByAccountId(@Param("id")String id); + + List<UserHeadInfoVo> selectUserHeadInfoByAccountId(@Param("id")String id); + + List<OrderItemsVo> selectOrderItemsByUserId(@Param("userId")String userId); + + List<JhyOrderItems> selectOrderById(@Param("orderId")Long orderId); + + List<DistribDataListVo> distribDataList(DistribDataListDto distribDataListDto); } diff --git a/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java b/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java index 6c58db4..745de6a 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java +++ b/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java @@ -8,19 +8,12 @@ import com.github.pagehelper.PageInfo; import com.xzx.gc.common.exception.RestException; import com.xzx.gc.common.utils.StringUtils; -import com.xzx.gc.entity.AccountInfo; -import com.xzx.gc.entity.SysMessage; -import com.xzx.gc.entity.UserHeadRelate; -import com.xzx.gc.entity.UserShareInfo; -import com.xzx.gc.user.dto.HeadProfitLitDto; -import com.xzx.gc.user.dto.HeadTeamDto; +import com.xzx.gc.entity.*; +import com.xzx.gc.user.dto.*; import com.xzx.gc.user.mapper.*; import com.xzx.gc.user.vo.HeadInfoVo; import com.xzx.gc.user.vo.HeadProfitListVo; import com.xzx.gc.user.vo.HeadTeamVo; -import com.xzx.gc.user.dto.AdddistribDto; -import com.xzx.gc.user.dto.DistribInfoListDto; -import com.xzx.gc.user.dto.DistribListDto; import com.xzx.gc.user.mapper.AccountMapper; import com.xzx.gc.user.mapper.SysMessageMapper; import com.xzx.gc.user.mapper.UserHeadRelateMapper; @@ -28,9 +21,7 @@ import com.xzx.gc.user.vo.*; import cn.hutool.core.util.ObjectUtil; import cn.hutool.core.util.StrUtil; -import com.xzx.gc.entity.RedPaperRule; import com.xzx.gc.model.JsonResult; -import com.xzx.gc.user.dto.UpdateSettingDto; import com.xzx.gc.user.mapper.RedPaperRuleMapper; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; @@ -73,7 +64,7 @@ viewSettingVo.setOrderNumFrist(0); viewSettingVo.setRegularPoint(0); viewSettingVo.setRegularMoneyPercent(BigDecimal.ZERO); - viewSettingVo.setFinishOrderNum(0); +// viewSettingVo.setFinishOrderNum(0); viewSettingVo.setPointReward(0); viewSettingVo.setStatus((short) 0); }else{ @@ -86,7 +77,7 @@ viewSettingVo.setOrderNumFrist(StrUtil.isEmpty(shareRatios.get(1))?0:Integer.parseInt(shareRatios.get(1))); viewSettingVo.setRegularPoint(StrUtil.isEmpty(shareRatios.get(2))?0:Integer.parseInt(shareRatios.get(2))); viewSettingVo.setRegularMoneyPercent(StrUtil.isEmpty(shareRatios.get(3))?BigDecimal.ZERO:new BigDecimal(shareRatios.get(3))); - viewSettingVo.setFinishOrderNum(StrUtil.isEmpty(shareRatios.get(4))?0:Integer.parseInt(shareRatios.get(4))); +// viewSettingVo.setFinishOrderNum(StrUtil.isEmpty(shareRatios.get(4))?0:Integer.parseInt(shareRatios.get(4))); viewSettingVo.setPointReward(StrUtil.isEmpty(shareRatios.get(5))?0:Integer.parseInt(shareRatios.get(5))); viewSettingVo.setStatus(redPaperRule.getStatus()); } @@ -96,7 +87,7 @@ viewSettingVo.setOrderNumFrist(0); viewSettingVo.setRegularPoint(0); viewSettingVo.setRegularMoneyPercent(BigDecimal.ZERO); - viewSettingVo.setFinishOrderNum(0); +// viewSettingVo.setFinishOrderNum(0); viewSettingVo.setPointReward(0); viewSettingVo.setStatus((short) 0); } @@ -180,8 +171,8 @@ stringBuffer.append(regularPoint+","); BigDecimal regularMoneyPercent = ObjectUtil.isEmpty(model.getRegularMoneyPercent()) ? BigDecimal.ZERO : model.getRegularMoneyPercent(); stringBuffer.append(regularMoneyPercent+","); - int finishOrderNum = ObjectUtil.isEmpty(model.getFinishOrderNum()) ? 0 : model.getFinishOrderNum(); - stringBuffer.append(finishOrderNum+","); +// int finishOrderNum = ObjectUtil.isEmpty(model.getFinishOrderNum()) ? 0 : model.getFinishOrderNum(); +// stringBuffer.append(finishOrderNum+","); int pointReward = ObjectUtil.isEmpty(model.getPointReward()) ? 0 : model.getPointReward(); stringBuffer.append(pointReward); redPaperRule.setStatus((short) 0); @@ -203,12 +194,12 @@ stringBuffer.append(regularPoint+","); BigDecimal regularMoneyPercent = ObjectUtil.isEmpty(model.getRegularMoneyPercent()) ? BigDecimal.ZERO : model.getRegularMoneyPercent(); stringBuffer.append(regularMoneyPercent+","); - int finishOrderNum = ObjectUtil.isEmpty(model.getFinishOrderNum()) ? 0 : model.getFinishOrderNum(); - stringBuffer.append(finishOrderNum+","); +// int finishOrderNum = ObjectUtil.isEmpty(model.getFinishOrderNum()) ? 0 : model.getFinishOrderNum(); +// stringBuffer.append(finishOrderNum+","); int pointReward = ObjectUtil.isEmpty(model.getPointReward()) ? 0 : model.getPointReward(); stringBuffer.append(pointReward); redPaperRule.setStatus(model.getStatus()); - redPaperRule.setSharingProfitType("frist_reward,order_num_frist,regular_point,regular_money_percent,finish_order_num,point_reward"); + redPaperRule.setSharingProfitType("first_reward,order_num_first,regular_point,regular_money_percent,finish_order_num,point_reward"); redPaperRule.setShareRatio(stringBuffer.toString()); redPaperRuleMapper.updateByPrimaryKey(redPaperRule); } @@ -268,4 +259,84 @@ return data; } + + public ViewDistribInfoVo viewDistribInfo(String id) { + //获取团长基本信息 + return accountMapper.selectDistribByAccountId(id); + } + + public Map<String, Object> userHeadInfoList(UserHeadInfoListDto userHeadInfoListDto) { + String id = userHeadInfoListDto.getId(); + AccountInfo accountInfo = accountMapper.selectByPrimaryKey(id); + String userId = accountInfo.getUserId(); + PageHelper.startPage(userHeadInfoListDto.getPage(), userHeadInfoListDto.getLimit()); + List<UserHeadInfoVo> userHeadInfoVos = accountMapper.selectUserHeadInfoByAccountId(userId); + if(CollUtil.isNotEmpty(userHeadInfoVos)){ + for(UserHeadInfoVo userHeadInfoVo : userHeadInfoVos){ + String nickname = userHeadInfoVo.getNickname(); + String decode = StringUtils.decode(nickname); + userHeadInfoVo.setNickname(decode); + } + } + PageInfo<UserHeadInfoVo> pageInfo = new PageInfo<>(userHeadInfoVos); + Map<String, Object> data = new HashMap<>(); + int count = Convert.toInt(pageInfo.getTotal()); + data.put("data", userHeadInfoVos); + data.put("count", count); + data.put("code", 0); + return data; + } + + public Map<String, Object> orderItemsList(UserHeadInfoListDto userHeadInfoListDto) { + String id = userHeadInfoListDto.getId(); + AccountInfo accountInfo = accountMapper.selectByPrimaryKey(id); + String userId = accountInfo.getUserId(); + PageHelper.startPage(userHeadInfoListDto.getPage(), userHeadInfoListDto.getLimit()); + List<OrderItemsVo> orderItemsVos = accountMapper.selectOrderItemsByUserId(userId); + if(CollUtil.isNotEmpty(orderItemsVos)){ + for(OrderItemsVo orderItemsVo : orderItemsVos){ + if(ObjectUtil.isNotEmpty(orderItemsVo)){ + Long orderId = orderItemsVo.getOrderId(); + List<JhyOrderItems> jhyOrderItems = accountMapper.selectOrderById(orderId); + if(CollUtil.isNotEmpty(jhyOrderItems)){ + orderItemsVo.setOrderItems(jhyOrderItems); + } + } + } + } + PageInfo<OrderItemsVo> pageInfo = new PageInfo<>(orderItemsVos); + Map<String, Object> data = new HashMap<>(); + int count = Convert.toInt(pageInfo.getTotal()); + data.put("data", orderItemsVos); + data.put("count", count); + data.put("code", 0); + return data; + } + + public void prohibitDistrib(ProhibitDistribDto model) { + Integer status = model.getStatus(); + String id = model.getId(); + AccountInfo accountInfo = accountMapper.selectByPrimaryKey(id); + accountInfo.setIsProhibit(status.toString()); + accountMapper.updateByPrimaryKey(accountInfo); + } + + + public Map<String, Object> distribDataList(DistribDataListDto distribDataListDto) { + PageHelper.startPage(distribDataListDto.getPage(), distribDataListDto.getLimit()); + List<DistribDataListVo> distribDataListVos = accountMapper.distribDataList(distribDataListDto); + if(CollUtil.isNotEmpty(distribDataListVos)){ + for(DistribDataListVo distribDataListVo : distribDataListVos){ + if(ObjectUtil.isNotEmpty(distribDataListVo)){ + } + } + } + PageInfo<DistribDataListVo> pageInfo = new PageInfo<>(distribDataListVos); + Map<String, Object> data = new HashMap<>(); + int count = Convert.toInt(pageInfo.getTotal()); + data.put("data", distribDataListVos); + data.put("count", count); + data.put("code", 0); + return data; + } } diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/DistribDataListVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/DistribDataListVo.java new file mode 100644 index 0000000..b0a052c --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/vo/DistribDataListVo.java @@ -0,0 +1,43 @@ +package com.xzx.gc.user.vo; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +@ApiModel(value = "DistribDataListVo", description = "返回参数类") +public class DistribDataListVo { + + private String id; + + @ApiModelProperty(value = "名称") + private String nickname; + + @ApiModelProperty(value = "手机号码") + private String phone; + + @ApiModelProperty(value = "注册时间") + private String registTime; + + @ApiModelProperty(value = "团员数量") + private Integer cnt; + + @ApiModelProperty(value = "交易单数") + private String orderCnt; + + @ApiModelProperty(value = "累计收益(元)") + private String amount; + + @ApiModelProperty(value = "累计收益积分") + private String score; + + @ApiModelProperty(value = "累计订单重量") + private String kg; + + @ApiModelProperty(value = "累计家电数量") + private String jdsl; + + @ApiModelProperty(value = "是否为团长 1-是 2-否") + private String isHead; + +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/OrderItemsVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/OrderItemsVo.java new file mode 100644 index 0000000..f2481b4 --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/vo/OrderItemsVo.java @@ -0,0 +1,34 @@ +package com.xzx.gc.user.vo; + +import com.xzx.gc.entity.JhyOrderItems; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.math.BigDecimal; +import java.util.List; + +@Data +@ApiModel(value = "OrderItemsVo", description = "团员订单") +public class OrderItemsVo { + + private Long orderId; + + @ApiModelProperty(value="订单编号") + private String orderNo; + + @ApiModelProperty(value="回收品类") + private List<JhyOrderItems> OrderItems; + + @ApiModelProperty(value="订单金额") + private BigDecimal amount; + + @ApiModelProperty(value="积分") + private BigDecimal score; + + @ApiModelProperty(value="积分收益") + private BigDecimal scoreReward; + + @ApiModelProperty(value="环保币收益") + private BigDecimal amountReward; +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java new file mode 100644 index 0000000..fb13e47 --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java @@ -0,0 +1,28 @@ +package com.xzx.gc.user.vo; + +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.math.BigDecimal; + +@Data +@ApiModel(value = "UserHeadInfoVo", description = "团员名单") +public class UserHeadInfoVo { + + @ApiModelProperty(value="名称") + private String nickname; + + @ApiModelProperty(value="联系方式") + private String phone; + + @ApiModelProperty(value="绑定时间") + private String createTime; + + @ApiModelProperty(value="累计金额") + private BigDecimal amount; + + @ApiModelProperty(value="累计单数") + private Integer orderCnt; + +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/ViewDistribInfoVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/ViewDistribInfoVo.java new file mode 100644 index 0000000..2e1cb8f --- /dev/null +++ b/gc-user/src/main/java/com/xzx/gc/user/vo/ViewDistribInfoVo.java @@ -0,0 +1,46 @@ +package com.xzx.gc.user.vo; + +import com.xzx.gc.entity.JhyOrder; +import com.xzx.gc.entity.JhyOrderItems; +import com.xzx.gc.entity.UserHeadRelate; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.math.BigDecimal; +import java.util.List; + +@Data +@ApiModel(value = "ViewDistribInfoVo", description = "团长详情返回参数类") +public class ViewDistribInfoVo { + + private String id; + + @ApiModelProperty(value = "姓名") + private String nickname; + + @ApiModelProperty(value = "联系方式") + private String phone; + + @ApiModelProperty(value = "注册时间") + private String registTime; + + @ApiModelProperty(value = "团员数量") + private Integer cnt; + + @ApiModelProperty(value = "交易单数") + private Integer orderCnt; + + @ApiModelProperty(value = "环保币") + private BigDecimal amount; + + @ApiModelProperty(value = "积分") + private BigDecimal score; +// +// @ApiModelProperty(value = "团员订单") +// private List<OrderItemsVo> OrderItemsVos; +// +// @ApiModelProperty(value = "团员名单") +// private List<UserHeadInfoVo> userHeadInfos; + +} diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/ViewSettingVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/ViewSettingVo.java index 49fc677..423acec 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/vo/ViewSettingVo.java +++ b/gc-user/src/main/java/com/xzx/gc/user/vo/ViewSettingVo.java @@ -24,7 +24,7 @@ //团员完成(FinishOrderNum)单后,团员每完成一单团长获得(pointReward)积分: @ApiModelProperty(value = "团员完成(FinishOrderNum)单后,团员每完成一单团长获得(pointReward)积分:") - private Integer finishOrderNum; +// private Integer finishOrderNum; private Integer pointReward; @ApiModelProperty("开关0:已经关闭,1:正常") diff --git a/gc-user/src/main/resources/mapper/user/AccountMapper.xml b/gc-user/src/main/resources/mapper/user/AccountMapper.xml index cdb5525..1d90ccf 100644 --- a/gc-user/src/main/resources/mapper/user/AccountMapper.xml +++ b/gc-user/src/main/resources/mapper/user/AccountMapper.xml @@ -174,10 +174,10 @@ b.mobile_phone phone, b.regist_time registTime, a.is_head isHead, - (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id GROUP BY head_user_id) cnt, - (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id GROUP BY head_user_id) orderCnt, - (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id GROUP BY head_user_id) amount, - (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id GROUP BY head_user_id) score, + (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id ) cnt, + (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id ) orderCnt, + (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id ) amount, + (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id ) score, a.is_prohibit isProhibit FROM xzx_account_info a @@ -202,4 +202,92 @@ order by id desc </select> + <select id="selectDistribByAccountId" resultType="com.xzx.gc.user.vo.ViewDistribInfoVo"> + SELECT + a.account_id id, + b.nick_name nickname, + b.mobile_phone phone, + b.regist_time registTime, + (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id ) cnt, + (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id ) orderCnt, + (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id ) amount, + (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id ) score + FROM + xzx_account_info a + LEFT JOIN xzx_user_info b on a.user_id = b.user_id + where a.account_id = #{id} + </select> + + <select id="selectUserHeadInfoByAccountId" resultType="com.xzx.gc.user.vo.UserHeadInfoVo"> + SELECT + b.nick_name nickname, + b.mobile_phone phone, + a.CREATED_TIME createTime, + (select IFNULL(count(1), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) orderCnt, + (select IFNULL(sum(amount), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) amount + FROM + xzx_user_head_relate a + LEFT JOIN xzx_user_info b on a.user_id = b.user_id + where a.head_user_id = #{id} + </select> + + <select id="selectOrderItemsByUserId" resultType="com.xzx.gc.user.vo.OrderItemsVo"> + SELECT + b.id orderId, + a.order_no orderNo, + a.score scoreReward, + a.amount amountReward, + sum(c.score) amount + FROM + xzx_user_head_details a + LEFT JOIN xzx_jhy_order b on a.order_no = b.order_no + LEFT JOIN xzx_jhy_order_items c on b.id=c.order_id + where a.head_user_id = #{userId} + </select> + + + + <select id="selectOrderById" resultType="com.xzx.gc.entity.JhyOrderItems"> + SELECT + * + FROM + xzx_jhy_order_items a + where a.order_id = #{orderId} + </select> + + <select id="distribDataList" resultType="com.xzx.gc.user.vo.DistribDataListVo"> + SELECT + a.account_id id, + b.nick_name nickname, + b.mobile_phone phone, + b.regist_time registTime, + a.is_head isHead, + (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id) cnt, + (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id) orderCnt, + (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id) amount, + (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id ) score, + a.is_prohibit isProhibit + FROM + xzx_account_info a + LEFT JOIN xzx_user_info b on a.user_id = b.user_id + <where> + 1=1 + and a.is_head = 1 + <if test="record.name != null and record.name != ''"> + and b.nick_name like concat('%',#{record.name},'%') + </if> + <if test="record.phone != null and record.phone != ''"> + and b.mobile_phone like concat('%',#{record.phone},'%') + </if> + <if test="record.reserveTimeStart != null"> + and b.regist_time >= #{record.reserveTimeStart} + </if> + + <if test="record.reserveTimeEnd != null"> + and b.regist_time <= #{record.reserveTimeEnd} + </if> + </where> + order by id desc +</select> + </mapper> -- Gitblit v1.9.1