From 6acf6357094588946b5528f1ef1ed84a0f1037fd Mon Sep 17 00:00:00 2001
From: huliguo <2023611923@qq.com>
Date: 星期五, 13 六月 2025 19:45:27 +0800
Subject: [PATCH] 小程序收付款
---
ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/ShopController.java | 742 +++++++++++++++++++++++++++-----------------------------
1 files changed, 354 insertions(+), 388 deletions(-)
diff --git a/ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/ShopController.java b/ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/ShopController.java
index 02e4ffc..83f385a 100644
--- a/ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/ShopController.java
+++ b/ruoyi-service/ruoyi-other/src/main/java/com/ruoyi/other/controller/ShopController.java
@@ -2,13 +2,22 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper;
+
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ruoyi.account.api.feignClient.AppUserClient;
+import com.ruoyi.account.api.feignClient.AppUserShopClient;
import com.ruoyi.account.api.model.AppUser;
+import com.ruoyi.account.api.model.AppUserShop;
import com.ruoyi.common.core.domain.R;
+import com.ruoyi.common.core.utils.bean.BeanUtils;
+import com.ruoyi.common.core.utils.poi.ExcelUtil;
import com.ruoyi.common.core.web.controller.BaseController;
+import com.ruoyi.common.core.web.page.PageInfo;
import com.ruoyi.common.security.service.TokenService;
import com.ruoyi.common.security.utils.MD5Generator;
import com.ruoyi.common.security.utils.SecurityUtils;
@@ -16,14 +25,15 @@
import com.ruoyi.order.vo.OrderSaleNum;
import com.ruoyi.order.vo.VerifiableShopVo;
import com.ruoyi.other.api.domain.*;
+import com.ruoyi.other.api.dto.ShopAnalysisDTO;
+import com.ruoyi.other.dto.AddGoodsDTO;
+import com.ruoyi.other.enums.PhoneType;
import com.ruoyi.other.mapper.ShopMapper;
+import com.ruoyi.other.mapper.ShopScoreMapper;
import com.ruoyi.other.service.*;
import com.ruoyi.other.util.GeodesyUtil;
import com.ruoyi.other.util.tencentMap.TencentMapUtil;
-import com.ruoyi.other.vo.NearbyShopVO;
-import com.ruoyi.other.vo.SaveWithdrawalAccount;
-import com.ruoyi.other.vo.ShopDetailVO;
-import com.ruoyi.other.vo.ShopStatistics;
+import com.ruoyi.other.vo.*;
import com.ruoyi.system.api.domain.SysUser;
import com.ruoyi.system.api.feignClient.SysUserClient;
import com.ruoyi.system.api.feignClient.UserShopClient;
@@ -32,16 +42,23 @@
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
+import io.swagger.models.auth.In;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.format.annotation.DateTimeFormat;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.CollectionUtils;
import org.springframework.util.StringUtils;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
+import javax.servlet.http.HttpServletResponse;
import java.math.BigDecimal;
import java.math.MathContext;
import java.math.RoundingMode;
+import java.time.LocalDate;
import java.time.LocalDateTime;
+import java.time.LocalTime;
+import java.time.YearMonth;
import java.util.*;
import java.util.stream.Collectors;
@@ -70,7 +87,9 @@
@Resource
private ShopMapper shopMapper;
@Resource
- private UserShopClient userShopClient;
+ private ShopScoreMapper shopScoreMapper;
+ @Resource
+ private AppUserShopClient appUserShopClient;
@Resource
private GoodsService goodsService;
@Resource
@@ -79,12 +98,70 @@
private OrderClient orderClient;
@Resource
private ReceiverBankChannelService receiverBankChannelService;
+ @Resource
+ private ShopScoreService shopScoreService;
+ @Autowired
+ private PhoneService phoneService;
+ /**
+ * 门店打分
+ * @return
+ */
+ @PostMapping("/shopScore")
+ @ApiOperation(value = "门店打分", tags = {"小程序-个人中心"})
+ public R<Void> shopScore(@RequestBody ShopScore shopScore) {
+ if (null==shopScore.getShopId()){
+ return R.fail("门店不能为空");
+ }
+ if (null==shopScore.getScore()){
+ return R.fail("评分不能为空");
+ }
+ //验证门店是否存在
+ Shop one = shopService.getOne(new LambdaQueryWrapper<Shop>().eq(Shop::getId, shopScore.getShopId()).eq(Shop::getStatus, 1).eq(Shop::getDelFlag, 0));
+ if (null == one){
+ return R.fail("门店不存在");
+ }
+ LoginUser loginUserApplet = tokenService.getLoginUserApplet();
+ shopScore.setAppUserId(loginUserApplet.getUserid());
+ ShopScore one1 = shopScoreService.getOne(new LambdaQueryWrapper<ShopScore>().eq(ShopScore::getAppUserId, loginUserApplet.getUserid()));
+ if (null!=one1){
+ return R.fail("不能重复评分");
+ }
+ shopScore.setCreateTime(LocalDateTime.now());
+ shopScoreService.save(shopScore);
+ //计算，更新到门店中
+ //总评分
+ List<BigDecimal> scores = shopScoreMapper.selectList(new LambdaQueryWrapper<ShopScore>().eq(ShopScore::getShopId, shopScore.getShopId())).stream().map(ShopScore::getScore).collect(Collectors.toList());
+ BigDecimal score = getScore(scores);
+ one.setId(shopScore.getShopId().intValue());
+ one.setScore(score.doubleValue());
+ shopMapper.updateById(one);
+ return R.ok();
+ }
+ /**
+ * 计算评分
+ */
+ private BigDecimal getScore(List<BigDecimal> scores) {
+ if (scores == null || scores.isEmpty()) {
+ return BigDecimal.ZERO.setScale(1, RoundingMode.HALF_UP); // 默认返回 0.0
+ }
+
+ // 计算总分
+ BigDecimal totalScore = scores.stream().reduce(BigDecimal.ZERO, BigDecimal::add);
+
+ // 计算平均值，并保留 1 位小数（四舍五入）
+ BigDecimal averageScore = totalScore.divide(
+ new BigDecimal(scores.size()),
+ 1, // 保留 1 位小数
+ RoundingMode.HALF_UP // 四舍五入
+ );
+ return averageScore;
+ }
@PostMapping
- @ApiOperation(value = "新增门店", tags = {"管理后台-门店管理"})
+ @ApiOperation(value = "新增门店", tags = {"后台-门店管理"})
@Transactional(rollbackFor = Exception.class)
public R<Void> add(@RequestBody Shop shop){
String phone = shop.getPhone();
@@ -92,98 +169,25 @@
if (appUser == null){
return R.fail("该手机号未注册");
}
- shop.setShopAllPoint(0);
- shop.setLowerLevelSharePoint(0);
- shop.setSharePoint(0);
- shop.setServerPoint(0);
- shop.setUsePoint(0);
- shop.setGiveawayAllMoney(BigDecimal.ZERO);
- shop.setGiveawayMoney(BigDecimal.ZERO);
- shop.setLowerLevelGiveawayMoney(BigDecimal.ZERO);
- shop.setServerGiveawayMoney(BigDecimal.ZERO);
- shop.setCanWithdrawMoney(BigDecimal.ZERO);
- shop.setWithdrawMoney(BigDecimal.ZERO);
- shop.setOrderNumber(0);
- shop.setServerOrderNumber(0);
- shop.setCustomOrderNumber(0);
+ //添加店铺用户信息
+ shop.setCreateTime(LocalDateTime.now());
shop.setAppUserId(appUser.getId());
- String city = TencentMapUtil.inverseGeographicalAnalysis(shop.getLongitude(), shop.getLatitude(), false);
- if(!StringUtils.hasLength(city)){
- city = "510100";
- }
- shop.setProvinceCode(city.substring(0, 2) + "0000");
- shop.setCityCode(city.substring(0, 4) + "00");
- shop.setDistrictCode(city);
+ //添加门店
shopService.save(shop);
-
- Integer shopId = shop.getId();
-
- appUser.setUserType(2);
- R<Void> editAppUserR = appUserClient.editAppUserById(appUser);
- if (R.isError(editAppUserR)){
- throw new RuntimeException("添加失败");
+ //添加shopuser
+ AppUserShop appUserShop = new AppUserShop();
+ appUserShop.setAppUserId(appUser.getId());
+ appUserShop.setShopId(shop.getId());
+ R appUserShopR = appUserShopClient.insert(appUserShop);
+ if (appUserShopR.getCode()!=200){
+ throw new RuntimeException("添加用户门店关系失败");
}
- //添加门店后台账号和门店关系数据
- SysUser sysUser = sysUserClient.queryUserByUserNameAndRoleType(phone, 2).getData();
- if(null != sysUser){
- sysUser.setAppUserId(appUser.getId());
- sysUserClient.updateUser(sysUser);
-
- UserShop userShop = new UserShop();
- userShop.setUserId(sysUser.getUserId());
- userShop.setShopId(shopId);
- userShop.setRoleType(1);
- List<UserShop> data = userShopClient.getUserShop(userShop).getData();
- if(null == data || data.size() == 0){
- userShop = new UserShop();
- userShop.setUserId(sysUser.getUserId());
- userShop.setShopId(shopId);
- userShop.setRoleType(1);
- userShop.setRoleId(2L);
- userShop.setNickName(sysUser.getNickName());
- userShop.setCreateTime(LocalDateTime.now());
- userShopClient.saveUserShop(userShop);
- }
- }else{
- //添加管理后台账号
- SysUser user = new SysUser();
- user.setDeptId(1L);
- user.setUserName(appUser.getPhone());
- user.setNickName(appUser.getName());
- user.setPhonenumber(appUser.getPhone());
- user.setAvatar(appUser.getAvatar());
- user.setStatus("0");
- user.setDelFlag("0");
- user.setRoleType(2);
- user.setObjectId(shopId);
- user.setAppUserId(appUser.getId());
- String s = MD5Generator.generateMD5(phone.substring(5));
- user.setPassword(s);
- user.setCreateTime(new Date());
- Long userId = sysUserClient.saveShopUser(user).getData();
-
- UserShop userShop = new UserShop();
- userShop.setUserId(userId);
- userShop.setShopId(shopId);
- userShop.setRoleType(1);
- List<UserShop> data = userShopClient.getUserShop(userShop).getData();
- if(null == data || data.size() == 0){
- userShop = new UserShop();
- userShop.setUserId(userId);
- userShop.setShopId(shopId);
- userShop.setRoleType(1);
- userShop.setRoleId(2L);
- userShop.setNickName(user.getNickName());
- userShop.setCreateTime(LocalDateTime.now());
- userShopClient.saveUserShop(userShop);
- }
- }
-
- // 更换下级会员绑定门店
- R<List<AppUser>> lowerShopR = appUserClient.setLowerUserShop(appUser.getId(), shopId);
- if (R.isError(lowerShopR)){
- throw new RuntimeException("更换下级会员绑定门店失败");
- }
+ //添加客服phone
+ Phone phone1 = new Phone();
+ phone1.setType(2);//门店
+ phone1.setPhoneOne(shop.getServiceTel());
+ phone1.setShopId(shop.getId());
+ phoneService.save(phone1);
return R.ok();
}
@@ -192,16 +196,13 @@
@ApiOperation(value = "门店详情", tags = {"管理后台-门店管理"})
public R<Shop> getDetailById(@RequestParam("id") Integer id){
Shop shop = shopService.getById(id);
- if (null != shop.getPid() && shop.getPid()==0){
- shop.setPid(null);
- }
return R.ok(shop);
}
@DeleteMapping("/deleteShop")
@ApiOperation(value = "删除门店", tags = {"管理后台-门店管理"})
public R<Void> deleteShop(@ApiParam("门店id") @RequestParam("id") Integer id){
- List<Goods> list1 = goodsService.list(new LambdaQueryWrapper<Goods>().eq(Goods::getDelFlag, 0).eq(Goods::getAppointStore, 1).eq(Goods::getStatus, 2));
+ List<Goods> list1 = goodsService.list(new LambdaQueryWrapper<Goods>().eq(Goods::getDelFlag, 0).eq(Goods::getStatus, 2));
if(list1.size() > 0){
Set<Integer> collect1 = list1.stream().map(Goods::getId).collect(Collectors.toSet());
long count = goodsShopService.count(new LambdaQueryWrapper<GoodsShop>().eq(GoodsShop::getShopId, id).in(GoodsShop::getGoodsId, collect1));
@@ -212,22 +213,9 @@
Shop shop = shopService.getById(id);
shop.setDelFlag(1);
shopService.updateById(shop);
- // 查询有没有门店绑定这个被删除的门店
- List<Shop> shops = shopService.lambdaQuery().eq(Shop::getPid, shop.getId()).list();
- for (Shop shop1 : shops) {
- LambdaUpdateWrapper<Shop> set = new LambdaUpdateWrapper<Shop>().set(Shop::getPid, null)
- .eq(Shop::getId,shop1.getId());
- shopService.update(set);
- }
- //清除用户绑定当前门店
- appUserClient.clearBindShop(shop.getId());
- //查询门店绑定的平台账号
- UserShop userShop = new UserShop();
- userShop.setShopId(shop.getId());
- List<UserShop> data = userShopClient.getUserShop(userShop).getData();
- if(data.size() > 0){
- //删除门店后台账号和关系数据
- sysUserClient.delShopUser(shop.getId(), 2);
+ R deleteR = appUserShopClient.delete(shop.getId(), shop.getAppUserId());
+ if (deleteR.getCode()!=200){
+ throw new RuntimeException("删除用户门店关系失败");
}
return R.ok();
}
@@ -235,104 +223,60 @@
@PutMapping("/editShop")
@ApiOperation(value = "门店管理-编辑门店", tags = {"管理后台-门店管理"})
public R<Void> editShop(@RequestBody Shop shop){
+
+ //判断是否修改店长
+ Shop byId = shopService.getById(shop.getId());
+
String phone = shop.getPhone();
- if (!shopService.cheUserByPhone(phone)) {
- return R.fail("该手机号未注册");
- }
- if (shop.getPid() != null && shop.getPid() != 0){
- Shop shopP = shopService.getById(shop.getPid());
- if (shopP.getPid()!=null&&shopP.getPid()!=0&& shopP.getPid().equals(shop.getId())){
- return R.fail("门店之间不能互相作为上级门店");
+ if (!phone.equals(byId.getPhone())){
+ //修改店长
+ AppUser appUser = appUserClient.getAppUserByPhone1(phone).getData();
+ if (appUser == null){
+ return R.fail("该手机号未注册");
}
- }
- String city = TencentMapUtil.inverseGeographicalAnalysis(shop.getLongitude(), shop.getLatitude(), false);
- if(!StringUtils.hasLength(city)){
- city = "510100";
- }
- shop.setProvinceCode(city.substring(0, 2) + "0000");
- shop.setCityCode(city.substring(0, 4) + "00");
- shop.setDistrictCode(city);
- Shop old_shop = shopService.getById(shop.getId());
- shopService.updateById(shop);
- //修改管理员
- AppUser appUser = appUserClient.getAppUserById(old_shop.getAppUserId());
-
- //删除后台用户和店铺关系数据
- UserShop userShop = new UserShop();
- userShop.setShopId(shop.getId());
- userShop.setRoleType(1);
- List<UserShop> data = userShopClient.getUserShop(userShop).getData();
- if(null != data && data.size() > 0){
- UserShop userShop1 = data.get(0);
- userShopClient.delUserShop(userShop1);
- //如果当前后台账户关联的店铺是最后一个，删除后台账户
- userShop = new UserShop();
- userShop.setUserId(userShop1.getUserId());
- data = userShopClient.getUserShop(userShop).getData();
- if(data.size() == 0){
- sysUserClient.delSysUserById(userShop1.getUserId());
+
+ Long originalUserId = byId.getAppUserId();
+ //添加用户id到shop信息中
+ shop.setAppUserId(appUser.getId());
+ //删除店铺关系
+ R deleteR = appUserShopClient.delete(shop.getId(), originalUserId);
+ if (deleteR.getCode()!=200){
+ throw new RuntimeException("删除用户门店关系失败");
}
+ //添加shopuser
+ AppUserShop appUserShop = new AppUserShop();
+ appUserShop.setAppUserId(appUser.getId());
+ appUserShop.setShopId(shop.getId());
+ R appUserShopR = appUserShopClient.insert(appUserShop);
+ if (appUserShopR.getCode()!=200){
+ throw new RuntimeException("添加用户门店关系失败");
+ }
+
}
- //添加新管理员
- appUser = appUserClient.getAppUserByPhone1(phone).getData();
- appUser.setUserType(2);
- appUserClient.editAppUserById(appUser);
-
- //修改管理员
- shop.setAppUserId(appUser.getId());
- shopService.updateById(shop);
-
- //添加门店后台账号和门店关系数据
- SysUser sysUser = sysUserClient.queryUserByUserName(phone).getData();
- if(null != sysUser){
- userShop = new UserShop();
- userShop.setShopId(shop.getId());
- userShop.setUserId(sysUser.getUserId());
- data = userShopClient.getUserShop(userShop).getData();
- if(null == data || data.size() == 0){
- userShop = new UserShop();
- userShop.setUserId(sysUser.getUserId());
- userShop.setShopId(shop.getId());
- userShop.setRoleType(1);
- userShop.setRoleId(2L);
- userShop.setNickName(sysUser.getNickName());
- userShop.setCreateTime(LocalDateTime.now());
- userShopClient.saveUserShop(userShop);
- }
- }else{
- //添加管理后台账号
- SysUser user = new SysUser();
- user.setDeptId(1L);
- user.setUserName(appUser.getPhone());
- user.setNickName(appUser.getName());
- user.setPhonenumber(appUser.getPhone());
- user.setAvatar(appUser.getAvatar());
- user.setStatus("0");
- user.setDelFlag("0");
- user.setRoleType(2);
- user.setObjectId(shop.getId());
- user.setAppUserId(appUser.getId());
- user.setPassword(phone.substring(5));
- user.setCreateTime(new Date());
- Long userId = sysUserClient.saveShopUser(user).getData();
-
- userShop = new UserShop();
- userShop.setShopId(shop.getId());
- userShop.setUserId(userId);
- data = userShopClient.getUserShop(userShop).getData();
- if(null == data || data.size() == 0){
- userShop = new UserShop();
- userShop.setUserId(userId);
- userShop.setShopId(shop.getId());
- userShop.setRoleType(1);
- userShop.setRoleId(2L);
- userShop.setNickName(appUser.getName());
- userShop.setCreateTime(LocalDateTime.now());
- userShopClient.saveUserShop(userShop);
- }
+
+ //删除客服电话
+ QueryWrapper<Phone> queryWrapper = new QueryWrapper<>();
+ queryWrapper.eq("shop_id", shop.getId());
+ queryWrapper.eq("type",2);
+ Phone one = phoneService.getOne(queryWrapper);
+ if (!one.getPhoneOne().equals(shop.getServiceTel())){
+ phoneService.removeById(one.getId());
+ //添加客服phone
+ Phone phone1 = new Phone();
+ phone1.setType(2);//门店
+ phone1.setPhoneOne(shop.getServiceTel());
+ phone1.setShopId(shop.getId());
+ phoneService.save(phone1);
}
+
+
+ //修改店铺
+ shopService.updateById(shop);
+
+
return R.ok();
+
}
public static void main(String[] args) {
@@ -349,53 +293,6 @@
}
shop.setStatus(status);
shopService.updateById(shop);
- //处理员工等数据
- if(status == 1){
- UserShop userSh = new UserShop();
- userSh.setShopId(id);
- List<UserShop> data = userShopClient.getUserShop(userSh).getData();
- for (UserShop datum : data) {
- SysUser sysUser = sysUserClient.getSysUser(datum.getUserId()).getData();
- sysUser.setStatus("0");
- sysUserClient.updateUser(sysUser);
- }
- }else{
- //查询门店所有关联数据
- UserShop userSh = new UserShop();
- userSh.setShopId(id);
- List<UserShop> data = userShopClient.getUserShop(userSh).getData();
- for (UserShop datum : data) {
- //查询用户关联的其他店铺
- UserShop userShop = new UserShop();
- userShop.setUserId(datum.getUserId());
- List<UserShop> data1 = userShopClient.getUserShop(userShop).getData();
- List<UserShop> collect = data1.stream().filter(s -> !s.getShopId().equals(id)).collect(Collectors.toList());
- if(collect.size() == 0){
- //如果没有其他店铺，则将用户禁用
- SysUser sysUser = sysUserClient.getSysUser(datum.getUserId()).getData();
- sysUser.setStatus("1");
- sysUserClient.updateUser(sysUser);
- }else{
- List<Integer> shopIds = collect.stream().map(UserShop::getShopId).collect(Collectors.toList());
- List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1)
- .in(Shop::getId, shopIds));
- //如果用户关联的其他门店都禁用了，将用户禁用
- if(list.size() == 0){
- SysUser sysUser = sysUserClient.getSysUser(datum.getUserId()).getData();
- sysUser.setStatus("1");
- sysUserClient.updateUser(sysUser);
- }else{
- //修改默认门店
- SysUser sysUser = sysUserClient.getSysUser(datum.getUserId()).getData();
- if(sysUser.getObjectId().equals(id)){
- sysUser.setObjectId(list.get(0).getId());
- sysUserClient.updateUser(sysUser);
- }
- }
- }
- }
- }
-
return R.ok();
}
@@ -404,10 +301,10 @@
@GetMapping("/list")
@ApiOperation(value = "门店列表", tags = {"管理后台-门店管理"})
- public R<IPage<Shop>> list(@ApiParam("页码") @RequestParam Integer pageNum,@ApiParam("每一页数据大小") Integer pageSize,Shop shop){
+ public R<IPage<Shop>> list(@ApiParam("页码") @RequestParam("pageNum") Integer pageNum,@ApiParam("每一页数据大小") @RequestParam("pageSize") Integer pageSize,Shop shop){
IPage<Shop> shopIPage = shopService.getShopList(pageNum, pageSize, shop);
for (Shop record : shopIPage.getRecords()) {
- record.setLaveUsePoint(record.getLavePoint());
+ record.setFullAddress(record.getAddress()+record.getDetailAddress());
}
return R.ok(shopIPage);
}
@@ -427,7 +324,7 @@
@GetMapping ("/resetPassword")
@ApiOperation(value = "重置密码", tags = {"管理后台-门店管理"})
public R<Void> resetPassword(@RequestParam(value = "ids") String ids) {
- String[] idsArr = ids.split(",");
+ /* String[] idsArr = ids.split(",");
for (String id : idsArr) {
Shop shop = shopService.getById(Integer.valueOf(id));
UserShop userShop = new UserShop();
@@ -438,7 +335,7 @@
String s = MD5Generator.generateMD5(userData.getPhonenumber().substring(5));
userData.setPassword(s);
sysUserClient.resetPassword(userData);
- }
+ }*/
return R.ok();
}
@@ -459,23 +356,29 @@
/**
- * 附近门店列表
+ * 附近门店列表/更多门店
*/
@GetMapping("/nearbyShopList")
- @ApiOperation(value = "附近门店列表", tags = {"小程序-首页"})
+ @ApiOperation(value = "附近门店列表/更多门店", tags = {"小程序-首页"})
public R<List<NearbyShopVO>> nearbyShopList(@ApiParam("经度") @RequestParam BigDecimal longitude,
- @ApiParam("纬度") @RequestParam BigDecimal latitude) {
- return R.ok(shopService.nearbyShopList(longitude, latitude));
+ @ApiParam("纬度") @RequestParam BigDecimal latitude,
+ Shop shop) {
+ return R.ok(shopService.nearbyShopList(longitude, latitude,shop));
}
-
+ /**
+ * 门店详情
+ */
@GetMapping("/shopDetail")
@ApiOperation(value = "门店详情", tags = {"小程序-首页"})
public R<ShopDetailVO> shopDetail(@ApiParam("门店id") @RequestParam Integer shopId,
- @ApiParam("经度") @RequestParam BigDecimal longitude,
- @ApiParam("纬度") @RequestParam BigDecimal latitude) {
+ @ApiParam("经度") @RequestParam(required = false) BigDecimal longitude,
+ @ApiParam("纬度") @RequestParam(required = false) BigDecimal latitude) {
return R.ok(shopService.getShopDetail(shopId, longitude, latitude));
}
+
+
+
/**
@@ -501,8 +404,6 @@
/**
* 根据id获取门店信息
- * @param id
- * @return
*/
@ResponseBody
@PostMapping("/getShopById")
@@ -511,6 +412,9 @@
return R.ok(shop);
}
+ /**
+ * 根据店长id获取门店列表
+ */
@ResponseBody
@PostMapping("/getShopByUserId")
public R<List<Shop>> getShopByUserId(@RequestParam("id") Long id){
@@ -518,11 +422,8 @@
return R.ok(list);
}
-
/**
* 根据店铺管理员电话获取门店数据
- * @param phone
- * @return
*/
@ResponseBody
@PostMapping("/getShopByPhone")
@@ -531,11 +432,7 @@
return R.ok(one);
}
- @PostMapping("/getShopByUserIds")
- public R<List<Shop>> getShopByUserIds(@RequestBody List<Long> userIds){
- List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().in(Shop::getAppUserId, userIds));
- return R.ok(list);
- }
+
/**
* 根据名称查询门店id
@@ -585,7 +482,6 @@
/**
* 编辑门店
- * @param shop
*/
@PostMapping("/updateShop")
public void updateShop(@RequestBody Shop shop){
@@ -593,74 +489,70 @@
}
-
-
- @ResponseBody
- @GetMapping("/getVerifiableShop")
- @ApiOperation(value = "获取可核销门店列表", tags = {"购物车-小程序"})
- public R<List<VerifiableShopVo>> getVerifiableShop(String longitude, String latitude, Integer goodsId){
- String city = TencentMapUtil.inverseGeographicalAnalysis(longitude, latitude, false);
- if(null == city){
- city = "510100";
- }
- city = city.substring(0, 4) + "00";
- LambdaQueryWrapper<Shop> wrapper = new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1).eq(Shop::getCityCode, city);
- if(null != goodsId){
- Goods goods = goodsService.getById(goodsId);
- if(1 == goods.getType() && 1 == goods.getAppointStore()){
- List<Integer> collect = goodsShopService.list(new LambdaQueryWrapper<GoodsShop>().eq(GoodsShop::getGoodsId, goods.getId()))
- .stream().map(GoodsShop::getShopId).collect(Collectors.toList());
- if(collect.size() > 0){
- wrapper.in(Shop::getId, collect);
- }
- }
- }
- List<Shop> list = shopService.list(wrapper);
- List<VerifiableShopVo> verifiableShopVoList = new ArrayList<>();
- for (Shop shop : list) {
- VerifiableShopVo vo = new VerifiableShopVo();
- vo.setId(shop.getId());
- vo.setName(shop.getName());
- vo.setAddress(shop.getAddress());
- vo.setHomePicture(shop.getHomePicture());
- Double wgs84 = GeodesyUtil.getDistance(longitude + "," + latitude, shop.getLongitude() + "," + shop.getLatitude()).get("WGS84");
- vo.setDistance(wgs84.longValue());
- verifiableShopVoList.add(vo);
- }
- verifiableShopVoList.sort(new Comparator<VerifiableShopVo>() {
- @Override
- public int compare(VerifiableShopVo o1, VerifiableShopVo o2) {
- return o1.getDistance().compareTo(o2.getDistance());
- }
- });
- return R.ok(verifiableShopVoList);
- }
-
-
-
@ResponseBody
@GetMapping("/getSysUserShop")
@ApiOperation(value = "获取可切换的门店列表", tags = {"门店后台-首页"})
- public R<List<VerifiableShopVo>> getSysUserShop(){
- Long userid = tokenService.getLoginUser().getUserid();
- UserShop userShop = new UserShop();
- userShop.setUserId(userid);
- List<UserShop> data = userShopClient.getUserShop(userShop).getData();
- List<Integer> collect = data.stream().map(UserShop::getShopId).collect(Collectors.toList());
+ public R<List<VerifiableShopVo>> getSysUserShop(@ApiParam("经度") @RequestParam(required = false) BigDecimal longitude,
+ @ApiParam("纬度") @RequestParam(required = false) BigDecimal latitude){
+ Long userid = tokenService.getLoginUserApplet().getUserid();
+
+ List<AppUserShop> data = appUserShopClient.getUserShopListByUserId(userid).getData();
+ if (null == data || data.isEmpty()) {
+ return R.fail("暂无其他门店可切换");
+ }
+ List<Integer> collect = data.stream().map(AppUserShop::getShopId).collect(Collectors.toList());
List<Shop> shops = shopService.list(new LambdaQueryWrapper<Shop>()
.in(!CollectionUtils.isEmpty(collect),Shop::getId, collect)
.eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1));
+ if (shops == null || shops.isEmpty()) {
+ return R.fail("暂无其他门店可切换");
+ }
List<VerifiableShopVo> list = new ArrayList<>();
for (Shop shop : shops) {
VerifiableShopVo vo = new VerifiableShopVo();
+ BeanUtils.copyProperties(shop, vo);
vo.setId(shop.getId());
vo.setName(shop.getName());
+
+ vo.setHomePicture(shop.getHomePicture());
+ if (null != latitude && null != longitude) {
+ Double wgs84 = GeodesyUtil.getDistance(longitude + "," + latitude, shop.getLongitude() + "," + shop.getLatitude()).get("WGS84");
+ vo.setDistance(wgs84.longValue());
+ }
list.add(vo);
}
return R.ok(list);
}
-
-
+
+ @ResponseBody
+ @GetMapping("/getShopBalance")
+ @ApiOperation(value = "获取门店余额", tags = {"门店后台-首页"})
+ public R<ShopBalanceVO> getShopBalance(@ApiParam("门店id") @RequestParam Integer shopId){
+ return R.ok(shopService.getShopBalance(shopId));
+ }
+
+ @ResponseBody
+ @GetMapping("/getShopBalanceStatementList")
+ @ApiOperation(value = "获取门店余额变动明细", tags = {"门店后台-首页"})
+ public R<PageInfo<ShopBalanceStatementVO>> getShopBalanceStatementList(@ApiParam("变动类型（4=提现，5=订单收入，6=订单退款）") Integer type,
+ @ApiParam("门店id") Integer shopId,
+ @ApiParam("指定日期") @DateTimeFormat(pattern = "yyyy-MM-dd") LocalDate date,
+ Integer pageCurr, Integer pageSize){
+ LocalDateTime startTime = null;
+ LocalDateTime endTime = null;
+ if (date != null) {
+ // 将 createTime 设置为当天的开始时间 (00:00)
+ startTime = date.atStartOfDay();
+
+ // 使用 YearMonth 来获取该月的最后一天
+ YearMonth yearMonth = YearMonth.from(date);
+ LocalDate lastDayOfMonth = yearMonth.atEndOfMonth();
+
+ // 将最后一天转换为 LocalDateTime，并设置为当天的最后一秒 (23:59:59.999)
+ endTime = lastDayOfMonth.atTime(LocalTime.MAX);
+ }
+ return R.ok(shopService.getShopBalanceStatementList(shopId,startTime, endTime, type, pageCurr, pageSize));
+ }
@PostMapping("/saveWithdrawalAccount")
@ApiOperation(value = "保存提现账户", tags = {"门店后台-财务统计-提现明细"})
@@ -670,9 +562,8 @@
}
@PostMapping("/saveWithdrawalAppletAccount")
- @ApiOperation(value = "保存提现账户", tags = {"小程序-个人中心-门店管理-门店钱包"})
+ @ApiOperation(value = "保存提现账户", tags = {"门店后台-首页"})
public R saveWithdrawalAppletAccount(@RequestBody SaveWithdrawalAccount saveWithdrawalAccount){
-
Shop shop = shopService.getById(saveWithdrawalAccount.getShopId());
if(null != shop){
shop.setReceiverAccountNoEnc(saveWithdrawalAccount.getReceiverAccountNoEnc());
@@ -686,18 +577,92 @@
/**
- * 获取所有门店
- * @return
+ * 指定门店商品
*/
- @PostMapping("/getAllShop")
+ @ResponseBody
+ @GetMapping("/getGoodsListByShopId")
+ @ApiOperation(value = "获取门店内商品列表", tags = {"门店后台-首页"})
+ public R<PageInfo<GoodsVO>> getGoodsListByShopId(@ApiParam("门店id")@RequestParam("shopId") Integer shopId,
+ @ApiParam("门店id")@RequestParam("pageCurr") Integer pageCurr,
+ @ApiParam("门店id")@RequestParam("pageSize") Integer pageSize) {
+ PageInfo<GoodsVO> pageInfo = new PageInfo<>(pageCurr, pageSize);
+ List<GoodsVO> goodsList = shopService.getGoodsListByShopId(pageInfo, shopId);
+ return R.ok(pageInfo.setRecords(goodsList));
+ }
+
+ /**
+ * 商品详情
+ */
+ @GetMapping("/goodsDetail/{goodsId}")
+ @ApiOperation(value = "商品详情", tags = {"门店后台-首页"})
+ public R<GoodsVO> goodsDetail(@PathVariable("goodsId") Long goodsId) {
+ return R.ok(shopService.goodsDetail(goodsId));
+ }
+
+ /**
+ * 添加商品
+ */
+ @PostMapping("/addGoods")
+ @ApiOperation(value = "发布商品", tags = {"门店后台-商品管理"})
+ public R<Integer> addGoods(@RequestBody AddGoodsDTO addGoodsDTO) {
+ return R.ok( shopService.addGoodsByShop(addGoodsDTO));
+ }
+
+ /**
+ * 编辑商品
+ */
+ @PostMapping("/editGoods")
+ @ApiOperation(value = "编辑商品", tags = {"门店后台-商品管理"})
+ public R<Integer> editGoods(@RequestBody AddGoodsDTO addGoodsDTO) {
+ return R.ok( shopService.editGoodsByShop(addGoodsDTO));
+ }
+
+
+ /**
+ * 上、下架商品
+ */
+ @PostMapping("/status/{goodsId}")
+ @ApiOperation(value = "上、下架商品", tags = {"门店后台-商品管理"})
+ public R<Void> status(@PathVariable Integer goodsId) {
+ Goods goods = goodsService.getById(goodsId);
+ if (goods == null) {
+ return R.fail("商品不存在");
+ }
+ goodsService.update(new UpdateWrapper<Goods>()
+ .setSql("status = CASE status WHEN 1 THEN 2 WHEN 2 THEN 1 ELSE status END")
+ .eq("id", goodsId));
+ return R.ok();
+ }
+
+ /**
+ * 删除商品
+ */
+ @DeleteMapping("/del/{goodsId}")
+ @ApiOperation(value = "删除商品", tags = {"门店后台-商品管理"})
+ public R<Void> delGoods(@PathVariable Integer goodsId) {
+ Goods goods = goodsService.getOne(new LambdaQueryWrapper<Goods>().eq(Goods::getId, goodsId)
+ .eq(Goods::getStatus, 2).eq(Goods::getDelFlag,0));
+ if (goods == null) {
+ return R.fail("商品不存在");
+ }
+ goodsService.update(new LambdaUpdateWrapper<Goods>().eq(Goods::getId, goodsId).set(Goods::getDelFlag,1));
+
+ return R.ok();
+ }
+
+
+ /**
+ * 获取所有门店
+ */
+ @GetMapping("/getAllShop")
public R<List<Shop>> getAllShop(){
- List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1));
+ List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().select(Shop::getName,Shop::getId).eq(Shop::getDelFlag, 0));
return R.ok(list);
}
@ResponseBody
@GetMapping("/verifyAccountConfiguration")
- @ApiOperation(value = "判断是否有提现账户", tags = {"门店后台-财务管理-提现明细"})
+ @ApiOperation(value = "判断是否有提现账户", tags = {"门店后台-首页"})
public R verifyAccountConfiguration(){
Long userid = tokenService.getLoginUser().getUserid();
SysUser sysUser = sysUserClient.getSysUser(userid).getData();
@@ -734,7 +699,18 @@
return R.ok(list);
}
+ @GetMapping("/getServiceProvider")
+ R<List<String>> getServiceProvider(@RequestParam("appUserId") Long appUserId){
+ LambdaQueryWrapper<Shop> queryWrapper=new LambdaQueryWrapper<>();
+ queryWrapper.eq(Shop::getAppUserId, appUserId);
+ queryWrapper.eq(Shop::getDelFlag,0);
+ List<Shop> shops = shopMapper.selectList(queryWrapper);
+ List<String> collect = shops.stream().map(Shop::getName).distinct().collect(Collectors.toList());
+ return R.ok(collect);
+ }
+
+/*
@GetMapping("/getShopStatistics")
public R<Map<String, BigDecimal> > getShopStatistics(@RequestParam("shopId") Integer shopId){
LambdaQueryWrapper<Shop> queryWrapper = new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1);
@@ -744,76 +720,66 @@
List<Shop> shopList = shopService.list(queryWrapper);
BigDecimal serverGiveawayMoney = BigDecimal.ZERO;
BigDecimal giveawayMoney = BigDecimal.ZERO;
- for (Shop shop : shopList) {
+ */
+/* for (Shop shop : shopList) {
serverGiveawayMoney = serverGiveawayMoney.add(shop.getServerGiveawayMoney());
giveawayMoney = giveawayMoney.add(shop.getGiveawayMoney().add(shop.getLowerLevelGiveawayMoney()));
- }
+ }*//*
+
Map<String, BigDecimal> map = new HashMap<>();
map.put("serverGiveawayMoney", serverGiveawayMoney);
map.put("giveawayMoney", giveawayMoney);
return R.ok(map);
}
+*/
/**
- * 获取指定用户的服务商
- * @return
+ * 获取店铺收益 后台-工作台-收益分析
*/
- @GetMapping("/getServiceProvider")
- public R<Shop> getServiceProvider(@RequestParam("appUserId") Long appUserId){
- //向上找获取第一个开店的门店
- List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1));
- AppUser appUser = appUserClient.getAppUserById(appUserId);
- //上级集合，防止循环关联
- Set<Long> pid = new HashSet<>();
- Shop shop = getSuperiorStore(appUser, list, 1, 1, pid);
- return R.ok(shop);
- }
-
-
-
- public Shop getSuperiorStore(AppUser appUser, List<Shop> list, Integer hierarchy, Integer num, Set<Long> pid){
- if(null == appUser.getInviteUserId()){
- return null;
+ @PostMapping("/getIncomeAnalysis")
+ R<Map<String, Object>> getIncomeAnalysis(@RequestBody ShopAnalysisDTO shopAnalysisDTO){
+ QueryWrapper<Shop> queryWrapper=new QueryWrapper<>();
+ //余额 已提现 提现中 可提现
+ queryWrapper.select("sum(balance) as balance","sum(withdraw_money) as withdrawMoney"
+ ,"sum(withdraw_audit_money) as withdrawAuditMoney","sum(can_withdraw_money) as canWithdrawMoney");
+ queryWrapper.eq("del_flag",0);
+ if (shopAnalysisDTO.getShopId() != null) {
+ queryWrapper.eq("id", shopAnalysisDTO.getShopId());
}
- if(pid.contains(appUser.getInviteUserId())){
- return null;
- }
- AppUser appUser1 = appUserClient.getAppUserById(appUser.getInviteUserId());
- if(null != appUser1){
- Optional<Shop> first = list.stream().filter(shop -> shop.getAppUserId().equals(appUser1.getId())).findFirst();
- if(first.isPresent()){
- if(hierarchy.equals(num)){
- return first.get();
- }
- num++;
- }
- }
- return getSuperiorStore(appUser1, list, hierarchy, num, pid);
+ return R.ok(shopService.getMap(queryWrapper));
}
-
-
-
-
-
-
-
-
+ @PostMapping("/insert")
+ R insert(@RequestBody Shop shop){
+ shopService.save(shop);
+ return R.ok(shop.getId());
+ }
/**
- * 获取指定用户的高级服务商
- * @return
+ * 店铺余额列表
*/
- @GetMapping("/getSuperiorServiceProvider")
- public R<Shop> getSuperiorServiceProvider(@RequestParam("appUserId") Long appUserId){
- //向上找获取第一个开店的门店
- List<Shop> list = shopService.list(new LambdaQueryWrapper<Shop>().eq(Shop::getDelFlag, 0).eq(Shop::getStatus, 1));
- AppUser appUser = appUserClient.getAppUserById(appUserId);
- //上级集合，防止循环关联
- Set<Long> pid = new HashSet<>();
- Shop shop = getSuperiorStore(appUser, list, 2, 1, pid);
- return R.ok(shop);
+
+ @GetMapping("/getBalanceList")
+ @ApiOperation(value = "门店余额列表", tags = {"后台-财务统计-余额列表"})
+ R<PageInfo<ShopBalanceListVO>> getBalanceList(@ApiParam("门店名称")@RequestParam(value = "name",required = false) String name,
+ @ApiParam("当前页")@RequestParam("pageCurr") Integer pageCurr,
+ @ApiParam("分页大小")@RequestParam("pageSize") Integer pageSize){
+ PageInfo<ShopBalanceListVO> pageInfo=shopService.getBalanceList(name,pageCurr,pageSize);
+ return R.ok(pageInfo);
}
+ /**
+ * 导出店铺余额列表
+ */
+
+ @GetMapping("/shopBalanceExcel")
+ @ApiOperation(value = "导出", tags = {"后台-财务统计-余额列表"})
+ void shopBalanceExcel(HttpServletResponse response,@ApiParam("门店名称")@RequestParam(value = "name" ,required = false) String name){
+ List<ShopBalanceExcel> exportList =shopMapper.shopBalanceExcel(name);
+ ExcelUtil<ShopBalanceExcel> util = new ExcelUtil<ShopBalanceExcel>(ShopBalanceExcel.class);
+ util.exportExcel(response, exportList, "店铺余额列表数据");
+ }
+
+
}
--
Gitblit v1.7.1