From 34c7d903efa4dc06a0f7b38bc5d2d721f80b220d Mon Sep 17 00:00:00 2001 From: liujie <1793218484@qq.com> Date: 星期三, 09 七月 2025 09:04:52 +0800 Subject: [PATCH] 7.8冒烟修改问题 --- ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/UserAccountController.java | 2 ruoyi-system/src/main/java/com/ruoyi/system/model/TbPermit.java | 2 ruoyi-system/src/main/java/com/ruoyi/system/query/MyPushCompanyListQuery.java | 2 ruoyi-system/src/main/resources/mapper/system/TbCompanyMapper.xml | 20 ++ ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyController.java | 81 +++++++--- ruoyi-system/src/main/java/com/ruoyi/system/task/utils/TaskUtil.java | 56 +++++++ ruoyi-system/src/main/java/com/ruoyi/system/vo/CompanyDetailVo.java | 26 +++ ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbOrderServiceImpl.java | 36 +++- ruoyi-system/src/main/java/com/ruoyi/system/model/TbSchedule.java | 2 ruoyi-system/src/main/java/com/ruoyi/system/dto/PushCompanyDto.java | 11 + ruoyi-system/src/main/java/com/ruoyi/system/vo/MyPushCompanyListVo.java | 4 ruoyi-system/src/main/java/com/ruoyi/system/query/CompanyListQuery.java | 2 ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyShopController.java | 9 ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/messageController.java | 14 + ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbCompanyServiceImpl.java | 55 +++++- ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/WxLoginController.java | 26 +++ ruoyi-system/src/main/java/com/ruoyi/system/dto/EditCompanyDto.java | 6 ruoyi-system/src/main/resources/mapper/system/TbOrderMapper.xml | 17 + ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbCompanyMapper.java | 5 ruoyi-applet/src/main/resources/application-test.yml | 2 ruoyi-system/src/main/java/com/ruoyi/system/vo/CustomerInfoVo.java | 7 ruoyi-system/src/main/java/com/ruoyi/system/model/TbMessage.java | 2 ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/OrderController.java | 42 +++- ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbOrderMapper.java | 4 ruoyi-system/src/main/java/com/ruoyi/system/service/TbCompanyService.java | 5 ruoyi-common/src/main/java/com/ruoyi/common/core/domain/model/LoginBody.java | 1 ruoyi-system/src/main/java/com/ruoyi/system/query/MyOrderListQuery.java | 2 ruoyi-system/src/main/java/com/ruoyi/system/service/TbOrderService.java | 7 28 files changed, 371 insertions(+), 77 deletions(-) diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/WxLoginController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/WxLoginController.java index 9dbf926..02ad957 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/WxLoginController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/api/WxLoginController.java @@ -1,5 +1,8 @@ package com.ruoyi.web.controller.api; +import cn.hutool.http.HttpUtil; +import cn.hutool.json.JSONObject; +import cn.hutool.json.JSONUtil; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.core.toolkit.Wrappers; @@ -94,12 +97,18 @@ if(user!=null && user.getStatus()==2){ return AjaxResult.error("登录失败,当前账号已被冻结"); } + String openid = getOpenid(loginBody.getJscode()); + TbUser user1 = tbUserService.getOne(new LambdaQueryWrapper<TbUser>().eq(TbUser::getOpenId, openid).ne(TbUser::getStatus,3).eq(TbUser::getIsDelete, 0)); + if(user1!=null && !loginBody.getPhone().equals(user1.getPhone())){ + return AjaxResult.error("该微信已绑定其他手机号"); + } if(user==null){ TbUser tbUser = new TbUser(); tbUser.setPhone(loginBody.getPhone()); tbUser.setStatus(1); tbUser.setUserName(loginBody.getPhone()); tbUser.setInviteId(loginBody.getInviteUserId()); + tbUser.setOpenId(openid); tbUserService.save(tbUser); user = tbUser; ajax.put("firstRegister",1); @@ -108,6 +117,10 @@ if(StringUtils.isEmpty(user.getInviteId()) && !StringUtils.isEmpty(loginBody.getInviteUserId())){ user.setInviteId(loginBody.getInviteUserId()); } + if(StringUtils.isEmpty(user.getOpenId())){ + user.setOpenId(openid); + } + tbUserService.updateById(user); } LoginUser loginUser = new LoginUser(); loginUser.setUserId(Long.valueOf(user.getId())); @@ -216,6 +229,19 @@ } + public String getOpenid(String jscode) { + String url = "https://api.weixin.qq.com/sns/jscode2session?appid=" + wxConfig.getMemberAppId() + + "&secret=" + wxConfig.getMemberAppSecret() + + "&js_code=" + jscode + + "&grant_type=authorization_code"; + + String result = HttpUtil.get(url); + JSONObject jsonObject = JSONUtil.parseObj(result); + + String openid = jsonObject.getStr("openid"); + + return openid; + } } diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyController.java index 4aa39d2..c79ba47 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyController.java @@ -1,35 +1,32 @@ package com.ruoyi.web.controller.system; -import cn.hutool.core.map.MapUtil; import cn.hutool.http.HttpRequest; import cn.hutool.http.HttpResponse; import cn.hutool.http.HttpUtil; import com.alibaba.fastjson2.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; -import com.fasterxml.jackson.databind.JsonNode; import com.ruoyi.common.core.domain.BasePage; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.domain.model.LoginUser; import com.ruoyi.common.core.redis.RedisCache; +import com.ruoyi.common.redis.service.RedisService; import com.ruoyi.common.utils.QiChaChaUtil; import com.ruoyi.common.utils.StringUtils; -import com.ruoyi.common.utils.http.HttpUtils; import com.ruoyi.framework.web.service.TokenService; -import com.ruoyi.system.dto.*; +import com.ruoyi.system.dto.AddScheduleDto; +import com.ruoyi.system.dto.CompanyUpdateStatusDto; +import com.ruoyi.system.dto.EditCompanyDto; +import com.ruoyi.system.dto.PushCompanyDto; import com.ruoyi.system.model.*; -import com.ruoyi.system.query.CompanyListQuery; import com.ruoyi.system.query.MyPushCompanyListQuery; import com.ruoyi.system.service.*; import com.ruoyi.system.vo.CompanyDetailVo; -import com.ruoyi.system.vo.IndexCompanyListVo; import com.ruoyi.system.vo.MyPushCompanyListVo; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; -import org.apache.poi.ss.formula.functions.T; -import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; @@ -37,6 +34,7 @@ import java.util.Date; import java.util.HashMap; import java.util.List; +import java.util.concurrent.TimeUnit; @Slf4j @RestController @@ -68,41 +66,42 @@ @Autowired private TbCompanyTypeService companyTypeService; - @Autowired - private QiChaChaUtil qiChaChaUtil; - + private RedisCache redisCache; @ApiOperation(value = "获取我发布的公司",tags = {"发布模块"}) @GetMapping("/getMyPushCompanyList") - public R<Page<MyPushCompanyListVo>> getMyPushCompanyList(MyPushCompanyListQuery query) { + public R< HashMap<String, Object>> getMyPushCompanyList(MyPushCompanyListQuery query) { LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); Page<MyPushCompanyListVo> page = tbCompanyService.getMyPushCompanyList(query,userId); - return R.ok(page); + HashMap<String, Object> map = new HashMap<>(); + map.put("data",page); + map = tbCompanyService.getMyPushCompanyListNum(userId,map); + return R.ok(map); } @ApiOperation(value = "获取行业信息",tags = {"发布模块"}) @GetMapping("/getIndustryList") - public R<Page<TbIndustry>> getIndustryList(BasePage page) { - Page<TbIndustry> page1 = industryService.page(new Page<>(page.getPageNum(),page.getPageSize()),new LambdaQueryWrapper<TbIndustry>().orderByDesc(TbIndustry::getOrderNum)); + public R<List<TbIndustry>> getIndustryList() { + List<TbIndustry> page1 = industryService.list(new LambdaQueryWrapper<TbIndustry>().orderByDesc(TbIndustry::getOrderNum)); return R.ok(page1); } @ApiOperation(value = "获取公司类型信息",tags = {"发布模块"}) @GetMapping("/getCompanyTypeList") - public R<Page<TbCompanyType>> getCompanyTypeList(BasePage page) { - Page<TbCompanyType> page1 = companyTypeService.page(new Page<>(page.getPageNum(),page.getPageSize()),new LambdaQueryWrapper<TbCompanyType>().eq(TbCompanyType::getDelFlag,0).orderByDesc(TbCompanyType::getOrderNum)); + public R<List<TbCompanyType>> getCompanyTypeList() { + List<TbCompanyType> page1 = companyTypeService.list(new LambdaQueryWrapper<TbCompanyType>().eq(TbCompanyType::getDelFlag,0).orderByDesc(TbCompanyType::getOrderNum)); return R.ok(page1); } @ApiOperation(value = "获取许可证信息",tags = {"发布模块"}) @GetMapping("/getLicenceList") - public R<Page<TbLicence>> getLicenceList(BasePage page) { - Page<TbLicence> page1 = licenceService.page(new Page<>(page.getPageNum(),page.getPageSize()),new LambdaQueryWrapper<TbLicence>().eq(TbLicence::getDelFlag,0).orderByDesc(TbLicence::getOrderNum)); + public R<List<TbLicence>> getLicenceList() { + List<TbLicence> page1 = licenceService.list(new LambdaQueryWrapper<TbLicence>().eq(TbLicence::getDelFlag,0).orderByDesc(TbLicence::getOrderNum)); return R.ok(page1); } @@ -115,8 +114,8 @@ if (count > 0) { return R.fail("该公司已发布"); } - tbCompanyService.pushCompany(dto,userId); - return R.ok(); + String companyId = tbCompanyService.pushCompany(dto, userId); + return R.ok(companyId); } @ApiOperation(value = "发布前获取公司信息--企查查",tags = {"发布模块"}) @@ -126,10 +125,15 @@ if (count > 0) { return R.fail("该公司已发布"); } + Object cacheObject = redisCache.getCacheObject("push_" + companyName); + if(cacheObject!=null){ + return R.ok(cacheObject); + } Object qiChaChaToken = QiChaChaUtil.getQiChaChaCompanyInfo(companyName); if(qiChaChaToken==null){ return R.fail("查询公司信息失败请联系客服"); } + redisCache.setCacheObject("push_" + companyName, qiChaChaToken, 24, TimeUnit.HOURS); return R.ok(qiChaChaToken); } @@ -157,7 +161,7 @@ } tbCompanyService.editCompany(dto,company,userId); - return R.ok(); + return R.ok(dto.getId()); } @@ -181,6 +185,27 @@ tbCompanyService.updateById(company); return R.ok(); } + + + @ApiOperation(value = "删除公司",tags = {"发布模块"}) + @DeleteMapping("/delete/{id}") + public R<?> delete(@PathVariable("id")String id) { + LoginUser loginUser = tokenService.getLoginUser(); + Long userId = loginUser.getUserId(); + TbCompany company = tbCompanyService.getById(id); + if (company == null || !company.getUserId().equals(userId.toString())) { + return R.fail("非法操作"); + } + long count = orderService.count(new LambdaQueryWrapper<TbOrder>().eq(TbOrder::getCompanyId,id).in(TbOrder::getStatus, 3, 4, 5)); + if (company.getStatus()!=1) { + return R.fail("订单状态不能修改"); + } + company.setIsDelete(1); + tbCompanyService.updateById(company); + return R.ok(); + } + + @ApiOperation(value = "确认订单",tags = {"发布模块"}) @PostMapping("/confirmOrder") @@ -255,7 +280,7 @@ } scheduleService.addSchedule(dto,userId); - messageService.addMessage("您有订单卖家已完成,等待确认", order.getUserId(),order.getId()); + messageService.addMessage("您的订单有新的进度提醒", order.getUserId(),order.getId()); return R.ok(); } @@ -312,10 +337,18 @@ CompanyDetailVo companyDetailVo = tbCompanyService.companyDetail(companyId,userId); Object qiChaChaCompanyExceptionCheck = QiChaChaUtil.getQiChaChaCompanyExceptionCheck(companyDetailVo.getCompanyName()); companyDetailVo.setCompanyExceptionInfo(qiChaChaCompanyExceptionCheck); - + companyDetailVo.setEstablishTime(companyDetailVo.getEstablishTime().substring(0,10)); return R.ok(companyDetailVo); } + + @ApiOperation(value = "公司详情--异常信息",tags = {"发布模块"}) + @GetMapping("/qiChaChaCompanyExceptionCheck") + public R<Object> qiChaChaCompanyExceptionCheck(@RequestParam String companyName) { + Object qiChaChaCompanyExceptionCheck = QiChaChaUtil.getQiChaChaCompanyExceptionCheck(companyName); + return R.ok(qiChaChaCompanyExceptionCheck); + } + @ApiOperation(value = "公司详情--财务征信信息",tags = {"发布模块"}) @GetMapping("/companyDetailDataInfo") public R<Object> companyDetailDataInfo(@RequestParam String companyId) { diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyShopController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyShopController.java index 797c622..3215a2f 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyShopController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/CompanyShopController.java @@ -19,10 +19,7 @@ import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.springframework.beans.factory.annotation.Autowired; -import org.springframework.web.bind.annotation.GetMapping; -import org.springframework.web.bind.annotation.RequestBody; -import org.springframework.web.bind.annotation.RequestMapping; -import org.springframework.web.bind.annotation.RestController; +import org.springframework.web.bind.annotation.*; import javax.validation.Valid; import java.util.List; @@ -51,8 +48,8 @@ @ApiOperation(value = "获取商城首页",tags = {"商城模块"}) - @GetMapping("/getCompanyList") - public R<Page<IndexCompanyListVo>> getCompanyList(@Valid CompanyListQuery query) { + @PostMapping("/getCompanyList") + public R<Page<IndexCompanyListVo>> getCompanyList(@Valid @RequestBody CompanyListQuery query) { LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); Page<IndexCompanyListVo> page = tbCompanyService.getCompanyList(query,userId); diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/OrderController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/OrderController.java index 1cb881e..59b45f7 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/OrderController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/OrderController.java @@ -24,6 +24,7 @@ import javax.validation.Valid; import java.util.Date; +import java.util.HashMap; @Slf4j @RestController @@ -56,14 +57,20 @@ @Autowired private TbUserService userService; + @Autowired + private TbAgreementService agreementService; - @ApiOperation(value = "获取我的订单", tags = {"订单模块"}) + + @ApiOperation(value = "获取我的订单", tags = {"订单模块"},response =MyPushCompanyListVo.class ) @GetMapping("/getMyOrderList") - public R<Page<MyPushCompanyListVo>> getMyOrderList(MyOrderListQuery query) { + public R<HashMap<String, Object>> getMyOrderList(MyOrderListQuery query) { LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); Page<MyPushCompanyListVo> page = orderService.getMyOrderList(query, userId); - return R.ok(page); + HashMap<String, Object> map = new HashMap<>(); + map.put("data",page); + map = orderService.getMyOrderListNum(userId,map); + return R.ok(map); } @@ -74,7 +81,7 @@ */ @ApiOperation(value = "立即支付前填写信息", tags = {"订单模块"}) @PostMapping("/lastPayOrderData") - public R<?> lastPayOrderData(@RequestBody @Valid AddBuyerCompanyInfoDto dto) { + public synchronized R<WxPayMpOrderResult> lastPayOrderData(@RequestBody @Valid AddBuyerCompanyInfoDto dto) { LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); TbOrder tbOrder = orderService.getById(dto.getOrderId()); @@ -96,12 +103,10 @@ if (company == null || company.getStatus() == 2 || company.getIsDelete() == 1) { return R.fail("该公司已下架或者删除"); } - long count = buyerCompanyInfoService.count(new LambdaQueryWrapper<TbBuyerCompanyInfo>().eq(TbBuyerCompanyInfo::getOrderId, dto.getOrderId())); - if (count > 0) { - return R.fail("请勿重复填写"); - } - orderService.lastPayOrderData(tbOrder, dto, userId, company); - return R.ok(); + TbBuyerCompanyInfo one = buyerCompanyInfoService.getOne(new LambdaQueryWrapper<TbBuyerCompanyInfo>().eq(TbBuyerCompanyInfo::getOrderId, dto.getOrderId())); + orderService.lastPayOrderData(tbOrder, dto, userId, company,one); + R<WxPayMpOrderResult> wxPayMpOrderResultR = payOrder(dto.getOrderId()); + return wxPayMpOrderResultR; } @@ -144,7 +149,7 @@ @PostMapping("/placeOrder") public synchronized R<?> placeOrder(String companyId) { if (StringUtils.isEmpty(companyId)) { - R.fail("id不能为空"); + return R.fail("id不能为空"); } LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); @@ -174,6 +179,21 @@ return R.ok(); } + @ApiOperation(value = "下单预定-获取信息", tags = {"订单模块"}) + @GetMapping("/placeOrderInfo") + public R<?> placeOrderInfo(String companyId) { + if (StringUtils.isEmpty(companyId)) { + R.fail("id不能为空"); + } + TbCompany company = companyService.getById(companyId); + String information = company.getInformation(); + HashMap<String, String> map = new HashMap<>(); + map.put("information", information); + TbAgreement one = agreementService.getOne(new LambdaQueryWrapper<TbAgreement>().eq(TbAgreement::getType, 3)); + map.put("agreement", one.getContent()); + return R.ok(map); + } + @ApiOperation(value = "买家完成订单", tags = {"订单模块"}) @PostMapping("/buyerSuccessOrder") diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/UserAccountController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/UserAccountController.java index ba358e1..356a94d 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/UserAccountController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/UserAccountController.java @@ -95,7 +95,7 @@ @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class) public R<?> withdrawal(@RequestBody @Valid UserWithdrawalDto dto) { if(dto.getAmount()<=0){ - return R.fail("提现金额不能小于0"); + return R.fail("提现金额不能小于等于0"); } LoginUser loginUser = tokenService.getLoginUser(); TbUser user = userService.getById(loginUser.getUserId()); diff --git a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/messageController.java b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/messageController.java index e8dde5e..0d8bd16 100644 --- a/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/messageController.java +++ b/ruoyi-applet/src/main/java/com/ruoyi/web/controller/system/messageController.java @@ -11,6 +11,7 @@ import com.ruoyi.system.model.TbUser; import com.ruoyi.system.query.UserMessageQuery; import com.ruoyi.system.service.TbMessageService; +import com.ruoyi.system.service.TbOrderService; import com.ruoyi.system.service.TbUserService; import com.ruoyi.system.vo.InviteUserListVo; import io.swagger.annotations.Api; @@ -21,6 +22,7 @@ import org.springframework.web.bind.annotation.*; import java.util.ArrayList; +import java.util.List; @Slf4j @RestController @@ -37,12 +39,22 @@ @Autowired private TokenService tokenService; + @Autowired + private TbOrderService orderService; + + @ApiOperation(value = "获取用户消息",tags = {"消息模块"}) @GetMapping("/getUserMessage") public R<Page<TbMessage>> getUserMessage(UserMessageQuery query) { LoginUser loginUser = tokenService.getLoginUser(); Long userId = loginUser.getUserId(); - Page<TbMessage> page = messageService.page(new Page<>(query.getPageNum(), query.getPageSize()), new LambdaQueryWrapper<TbMessage>().eq(TbMessage::getUserId, userId)); + Page<TbMessage> page = messageService.page(new Page<>(query.getPageNum(), query.getPageSize()), new LambdaQueryWrapper<TbMessage>().eq(query.getIsRead()!=null, TbMessage::getIsRead, query.getIsRead()).eq(TbMessage::getUserId, userId).orderByDesc(TbMessage::getCreateTime)); + page.getRecords().forEach(item -> { + String companyId = orderService.getById(item.getOrderId()).getCompanyId(); + item.setCompanyId(companyId); + }); + long count = messageService.count(new LambdaQueryWrapper<TbMessage>().eq(TbMessage::getIsRead, 0).eq(TbMessage::getUserId, userId)); + page.setCurrent(count); return R.ok(page); } diff --git a/ruoyi-applet/src/main/resources/application-test.yml b/ruoyi-applet/src/main/resources/application-test.yml index 1d9092f..46759df 100644 --- a/ruoyi-applet/src/main/resources/application-test.yml +++ b/ruoyi-applet/src/main/resources/application-test.yml @@ -208,6 +208,6 @@ mchKey: 5Kb8zX9qR3r4D7Yw3vHnJgLp6sA4cE1M #微信支付商户密钥 keyPath: C:\Users\Admin\Desktop\zsxcert\apiclient_cert.p12 # p12证书的位置 callbackPath: https://api.dshl.vip/WalletApi/WX/callback - notifyUrl: http://127.0.0.1:9081/order/WX/zxsCallback + notifyUrl: http://9ndirhvulyyt.ngrok.xiaomiqiu123.top/order/WX/zxsCallback diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/model/LoginBody.java b/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/model/LoginBody.java index c0c4e9f..493344d 100644 --- a/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/model/LoginBody.java +++ b/ruoyi-common/src/main/java/com/ruoyi/common/core/domain/model/LoginBody.java @@ -35,6 +35,7 @@ private String inviteUserId; @ApiModelProperty(value = "微信授权code") + @NotBlank(message = "微信授权code不能为空") private String jscode; } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/dto/EditCompanyDto.java b/ruoyi-system/src/main/java/com/ruoyi/system/dto/EditCompanyDto.java index 34b3894..45df60f 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/dto/EditCompanyDto.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/dto/EditCompanyDto.java @@ -244,4 +244,10 @@ @ApiModelProperty("开户行信息") @NotNull(message = "请选择开户行信息") private List<TbOpeningBank> openingBanks; + + @ApiModelProperty("登记机关") + private String belongOrg; + + @ApiModelProperty("登记状态") + private String registrationStatus; } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/dto/PushCompanyDto.java b/ruoyi-system/src/main/java/com/ruoyi/system/dto/PushCompanyDto.java index b9b442e..9a826aa 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/dto/PushCompanyDto.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/dto/PushCompanyDto.java @@ -63,7 +63,7 @@ @NotBlank(message = "成立时间不能为空") private String establishTime; /** - * 1个体工商户 2有限公司 3独资 + * 1个体工商户 2 有限公司 3独资 */ @TableField("company_category") @NotNull(message = "请选择公司类型") @@ -76,7 +76,7 @@ @ApiModelProperty("行业id不能为空") private Integer companyIndustryId; /** - * 1一般纳税人 2小规模纳税人 3税务未登记 + * 1一般纳税人 2小规模纳税人 3 税务未登记 */ @NotNull(message = "请选择纳税人类型") @ApiModelProperty("纳税人类型 1一般纳税人 2小规模纳税人 3税务未登记") @@ -241,4 +241,11 @@ @ApiModelProperty("开户行信息") @NotNull(message = "请选择开户行信息") private List<TbOpeningBank> openingBanks; + + + @ApiModelProperty("登记机关") + private String belongOrg; + + @ApiModelProperty("登记状态") + private String registrationStatus; } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbCompanyMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbCompanyMapper.java index 65ba716..7bee685 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbCompanyMapper.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbCompanyMapper.java @@ -8,6 +8,8 @@ import com.ruoyi.system.vo.MyPushCompanyListVo; import org.apache.ibatis.annotations.Param; +import java.util.List; + /** * <p> * 公司消息表 Mapper 接口 @@ -21,4 +23,7 @@ Page<MyPushCompanyListVo> getMyPushCompanyList(@Param("page") Page<MyPushCompanyListVo> page, @Param("query") MyPushCompanyListQuery query, @Param("userId") Long userId); + List<MyPushCompanyListVo> getMyPushCompanyListNum(@Param("userId") Long userId); + + } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbOrderMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbOrderMapper.java index aa4c2fe..1092a99 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbOrderMapper.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TbOrderMapper.java @@ -8,6 +8,8 @@ import com.ruoyi.system.vo.MyPushCompanyListVo; import org.apache.ibatis.annotations.Param; +import java.util.List; + /** * <p> * 订单表 Mapper 接口 @@ -20,4 +22,6 @@ Page<MyPushCompanyListVo> getMyOrderList(@Param("page") Page<MyPushCompanyListVo> page, @Param("query") MyOrderListQuery query, @Param("userId") Long userId); + List<MyPushCompanyListVo> getMyOrderListNum(@Param("userId") Long userId); + } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbMessage.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbMessage.java index 559d166..7fc282c 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbMessage.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbMessage.java @@ -52,5 +52,7 @@ private String orderId; + @TableField(exist = false) + private String companyId; } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbPermit.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbPermit.java index ac63852..df67d0c 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbPermit.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbPermit.java @@ -5,6 +5,7 @@ import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.baomidou.mybatisplus.extension.activerecord.Model; +import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; @@ -53,6 +54,7 @@ @TableField("expire_time") private String expireTime; @TableField("create_time") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date createTime; diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbSchedule.java b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbSchedule.java index 64f48af..06f861c 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/model/TbSchedule.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/model/TbSchedule.java @@ -6,6 +6,7 @@ import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import com.baomidou.mybatisplus.extension.activerecord.Model; +import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import lombok.EqualsAndHashCode; @@ -49,6 +50,7 @@ private String img; @TableField("create_time") @ApiModelProperty("创建时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date createTime; /** * 卖家回复才会有 diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/CompanyListQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/CompanyListQuery.java index 889ab64..f841ebf 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/query/CompanyListQuery.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/CompanyListQuery.java @@ -9,6 +9,7 @@ import javax.validation.constraints.NotBlank; import java.util.List; + @Data @ApiModel("商城首页查询Query") public class CompanyListQuery extends BasePage { @@ -16,7 +17,6 @@ @NotBlank(message = "城市code不能为空") private String cityCode; @ApiModelProperty("区code") - @NotBlank(message = "区code不能为空") private String areaCode; @ApiModelProperty("公司名称") private String companyName; diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/MyOrderListQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/MyOrderListQuery.java index d83c3e1..958fb6b 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/query/MyOrderListQuery.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/MyOrderListQuery.java @@ -3,8 +3,10 @@ import com.ruoyi.common.core.domain.BasePage; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; +import lombok.Data; @ApiModel("发布查询query") +@Data public class MyOrderListQuery extends BasePage { @ApiModelProperty("0待支付 2待确认 4办理中 5已完成") private Integer status; diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/query/MyPushCompanyListQuery.java b/ruoyi-system/src/main/java/com/ruoyi/system/query/MyPushCompanyListQuery.java index 5f2296e..a7041ce 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/query/MyPushCompanyListQuery.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/query/MyPushCompanyListQuery.java @@ -3,8 +3,10 @@ import com.ruoyi.common.core.domain.BasePage; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; +import lombok.Data; @ApiModel("发布查询query") +@Data public class MyPushCompanyListQuery extends BasePage { @ApiModelProperty("1待交易 2待确认 3已确认 4办理中 5已完成") private Integer status; diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TbCompanyService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TbCompanyService.java index 06bae67..b06df72 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TbCompanyService.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TbCompanyService.java @@ -13,6 +13,7 @@ import com.ruoyi.system.vo.MyPushCompanyListVo; import javax.validation.Valid; +import java.util.HashMap; /** * <p> @@ -27,7 +28,7 @@ Page<IndexCompanyListVo> getCompanyList(CompanyListQuery query, Long userId); - void pushCompany(PushCompanyDto dto, Long userId); + String pushCompany(PushCompanyDto dto, Long userId); void editCompany(EditCompanyDto dto, TbCompany company , Long userId); @@ -39,4 +40,6 @@ CompanyDetailVo companyDetail(String companyId, Long userId); + HashMap<String, Object> getMyPushCompanyListNum(Long userId, HashMap<String, Object> map); + } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/TbOrderService.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/TbOrderService.java index 8049619..203f4cf 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/TbOrderService.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/TbOrderService.java @@ -6,12 +6,14 @@ import com.github.binarywang.wxpay.bean.order.WxPayMpOrderResult; import com.github.binarywang.wxpay.exception.WxPayException; import com.ruoyi.system.dto.AddBuyerCompanyInfoDto; +import com.ruoyi.system.model.TbBuyerCompanyInfo; import com.ruoyi.system.model.TbCompany; import com.ruoyi.system.model.TbOrder; import com.ruoyi.system.query.MyOrderListQuery; import com.ruoyi.system.vo.MyPushCompanyListVo; import javax.validation.Valid; +import java.util.HashMap; /** * <p> @@ -37,6 +39,9 @@ void commission(TbOrder order,String userId); - void lastPayOrderData(TbOrder tbOrder, AddBuyerCompanyInfoDto dto, Long userId,TbCompany company); + void lastPayOrderData(TbOrder tbOrder, AddBuyerCompanyInfoDto dto, Long userId,TbCompany company, TbBuyerCompanyInfo one); + + HashMap<String, Object> getMyOrderListNum(Long userId, HashMap<String, Object> map); + } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbCompanyServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbCompanyServiceImpl.java index 48bd695..f88197c 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbCompanyServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbCompanyServiceImpl.java @@ -15,6 +15,7 @@ import com.ruoyi.system.query.MyPushCompanyListQuery; import com.ruoyi.system.service.*; import com.ruoyi.system.vo.*; +import org.apache.poi.ss.formula.functions.T; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @@ -22,6 +23,7 @@ import org.springframework.transaction.annotation.Transactional; import java.util.ArrayList; +import java.util.HashMap; import java.util.List; import java.util.stream.Collectors; @@ -50,6 +52,9 @@ @Autowired private TbScheduleService scheduleService; + + @Autowired + private TbShareholderService shareholderService; @Autowired private TbBuyerCompanyInfoService buyerCompanyInfoService; @@ -86,6 +91,7 @@ } if (query.getRegisteredCapitals() != null && query.getRegisteredCapitals().size() > 0) { + queryWrapper.in(TbCompany::getRegisteredCapital, query.getRegisteredCapitals()); } @@ -159,7 +165,7 @@ @Override @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class) - public void pushCompany(PushCompanyDto dto, Long userId) { + public String pushCompany(PushCompanyDto dto, Long userId) { TbCompany tbCompany = new TbCompany(); BeanUtils.copyProperties(dto, tbCompany); tbCompany.setUserId(userId.toString()); @@ -175,6 +181,7 @@ openingBank.setCompanyId(tbCompany.getId()); openingBankService.save(openingBank); } + return tbCompany.getId(); } @@ -206,10 +213,21 @@ } @Override + public HashMap<String, Object> getMyPushCompanyListNum(Long userId, HashMap<String, Object> map) { + List<MyPushCompanyListVo> list = this.baseMapper.getMyPushCompanyListNum(userId); + map.put("pendingTransaction", list.stream().filter(e -> e.getStatus() == 1).count()); + map.put("toBeConfirmed", list.stream().filter(e -> e.getStatus() == 2).count()); + map.put("confirmed", list.stream().filter(e -> e.getStatus() == 3).count()); + map.put("processing", list.stream().filter(e -> e.getStatus() == 4).count()); + map.put("completed", list.stream().filter(e -> e.getStatus() == 5).count()); + return map; + } + @Override public CompanyDetailVo companyDetail(String companyId, Long userId) { CompanyDetailVo companyDetailVo = new CompanyDetailVo(); TbCompany tbCompany = this.baseMapper.selectById(companyId); BeanUtils.copyProperties(tbCompany, companyDetailVo); + companyDetailVo.setState(tbCompany.getStatus()); TbIndustry industry = industryService.getById(tbCompany.getCompanyIndustryId()); companyDetailVo.setCompanyIndustryName(industry.getName()); @@ -231,7 +249,11 @@ } TbOrder order = orderService.getOne(new LambdaQueryWrapper<TbOrder>().eq(TbOrder::getCompanyId, companyId).gt(TbOrder::getStatus, 0).orderByDesc(TbOrder::getCreateTime).last("limit 1")); - companyDetailVo.setStatus(order.getStatus()); + if(order!=null){ + companyDetailVo.setStatus(order.getStatus()); + companyDetailVo.setSellerFinishTime(order.getSellerFinishTime()); + companyDetailVo.setOrderId(order.getId()); + } List<TbSchedule> list2 = scheduleService.list(new LambdaQueryWrapper<TbSchedule>().eq(TbSchedule::getOrderId, order.getId()).orderByDesc(TbSchedule::getCreateTime)); List<TbSchedule> collect = list2.stream().filter(e -> StringUtils.isEmpty(e.getParentId())).collect(Collectors.toList()); @@ -245,26 +267,31 @@ TbBuyerCompanyInfo one = buyerCompanyInfoService.getOne(new LambdaQueryWrapper<TbBuyerCompanyInfo>().eq(TbBuyerCompanyInfo::getOrderId, order.getId())); CustomerInfoVo customerInfoVo = new CustomerInfoVo(); - BeanUtils.copyProperties(one, customerInfoVo); + if(one!=null){ + BeanUtils.copyProperties(one, customerInfoVo); + String orderId = one.getOrderId(); + List<TbShareholder> list3 = shareholderService.list(new LambdaQueryWrapper<TbShareholder>().eq(TbShareholder::getOrderId, orderId)); + customerInfoVo.setShareHolders(list3); + } companyDetailVo.setCustomerInfoVo(customerInfoVo); companyDetailVo.setEstimatedRevenue(order.getPrice().subtract(order.getCommissionPrice()).subtract(order.getCommissionPlatform())); TbUser user = userService.getById(order.getUserId()); companyDetailVo.setCustomerName(user.getUserName()); - // 异常原因 - List<Object> cacheList = redisCache.getCacheList("abnormal_" + companyId); - if (cacheList.isEmpty()) { - ArrayList<AbnormalVo> abnormalVos = new ArrayList<>(); - for (Object o : cacheList) { - AbnormalVo abnormalVo = JSONObject.parseObject(o.toString(), AbnormalVo.class); - abnormalVos.add(abnormalVo); + // 判断是否要迁区 是否要改名 新增天数 + if(one!=null){ + companyDetailVo.setEstimatedDays(one.getAddDay()+companyDetailVo.getEstimatedDays()); + if(one.getNeedRename()==1){ + companyDetailVo.setSaleMoney( companyDetailVo.getSaleMoney().add(companyDetailVo.getRenameMoney())); } - companyDetailVo.setAbnormalVos(abnormalVos); - }else { - // TODO 企查查 次数查询加数据库 并加入缓存1天过期 - } + if(one.getNewDistrict()==1){ + companyDetailVo.setSaleMoney( companyDetailVo.getSaleMoney().add(companyDetailVo.getRelocationAreaMoney())); + } + } return companyDetailVo; } + + } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbOrderServiceImpl.java b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbOrderServiceImpl.java index 2761b95..f161767 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbOrderServiceImpl.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TbOrderServiceImpl.java @@ -31,6 +31,7 @@ import java.math.RoundingMode; import java.net.InetAddress; import java.util.Date; +import java.util.HashMap; import java.util.List; /** @@ -64,11 +65,24 @@ @Autowired private TbMessageService messageService; + @Autowired + private TbShareholderService shareholderService; + @Override public Page<MyPushCompanyListVo> getMyOrderList(MyOrderListQuery query, Long userId) { Page<MyPushCompanyListVo> page = new Page<>(query.getPageNum(), query.getPageSize()); return this.baseMapper.getMyOrderList(page,query,userId); + } + + @Override + public HashMap<String, Object> getMyOrderListNum(Long userId, HashMap<String, Object> map) { + List<MyPushCompanyListVo> list = this.baseMapper.getMyOrderListNum(userId); + map.put("toBeConfirmed", list.stream().filter(e -> e.getStatus() == 2).count()); + map.put("pendingPayment", list.stream().filter(e -> e.getStatus() == 3).count()); + map.put("processing", list.stream().filter(e -> e.getStatus() == 4).count()); + map.put("completed", list.stream().filter(e -> e.getStatus() == 6).count()); + return map; } @Override @@ -189,9 +203,12 @@ @Override @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class) - public void lastPayOrderData(TbOrder tbOrder, AddBuyerCompanyInfoDto dto, Long userId,TbCompany company) { + public void lastPayOrderData(TbOrder tbOrder, AddBuyerCompanyInfoDto dto, Long userId,TbCompany company, TbBuyerCompanyInfo one) { TbBuyerCompanyInfo tbBuyerCompanyInfo = new TbBuyerCompanyInfo(); BeanUtils.copyProperties(dto,tbBuyerCompanyInfo); + if(one!=null){ + tbBuyerCompanyInfo.setId(one.getId()); + } tbBuyerCompanyInfo.setOrderId(tbOrder.getId()); List<TbShareholder> shareholders = dto.getShareholders(); @@ -207,20 +224,23 @@ addDay = addDay+company.getRelocationAreaDay(); } // 更新订单金额 - if(addMoney.compareTo(BigDecimal.ZERO)>0){ - BigDecimal add = tbOrder.getPrice().add(addMoney); - tbOrder.setPrice(add); - tbOrder.updateById(); - } + BigDecimal add = company.getSaleMoney().add(addMoney); + tbOrder.setPrice(add); + tbOrder.setOrderNo(OrderUtil.getOrderNoForPrefix("ZSX")); + tbOrder.updateById(); + if(addDay>0){ tbBuyerCompanyInfo.setAddDay(addDay); } - tbBuyerCompanyInfo.insert(); + tbBuyerCompanyInfo.insertOrUpdate(); + + shareholderService.remove(new LambdaQueryWrapper<TbShareholder>().eq(TbShareholder::getOrderId, tbOrder.getId())); for (TbShareholder shareholder : shareholders) { shareholder.setOrderId(tbOrder.getId()); shareholder.insert(); } } + /** @@ -247,7 +267,7 @@ InetAddress.getLoopbackAddress().getHostAddress()); wxPayUnifiedOrderRequest.setTradeType("JSAPI"); wxPayUnifiedOrderRequest.setNotifyUrl( - wxProperties.getNotifyUrl() +"mall-hotel-order/WX/callback"); + wxProperties.getNotifyUrl()); WxPayMpOrderResult result = wxPayService.createOrder(wxPayUnifiedOrderRequest); return result; diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/task/utils/TaskUtil.java b/ruoyi-system/src/main/java/com/ruoyi/system/task/utils/TaskUtil.java index d29ca9f..8628e2d 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/task/utils/TaskUtil.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/task/utils/TaskUtil.java @@ -1,12 +1,68 @@ package com.ruoyi.system.task.utils; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.ruoyi.common.core.domain.R; +import com.ruoyi.system.model.TbAccountDetail; +import com.ruoyi.system.model.TbCompany; +import com.ruoyi.system.model.TbOrder; +import com.ruoyi.system.service.TbAccountDetailService; +import com.ruoyi.system.service.TbCompanyService; +import com.ruoyi.system.service.TbOrderService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.scheduling.annotation.Scheduled; import org.springframework.stereotype.Component; + +import java.time.LocalDate; +import java.time.LocalDateTime; +import java.time.format.DateTimeFormatter; +import java.util.Date; +import java.util.List; /** * @author zhibing.pu * @date 2023/7/11 8:39 */ +@Component public class TaskUtil { + @Autowired + private TbOrderService orderService; + @Autowired + private TbCompanyService companyService; + @Autowired + private TbAccountDetailService accountDetailService; + + + + @Scheduled(fixedRate = 60000) + public void confirmOrder() { + String format = LocalDateTime.now().minusDays(5).format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")); + List<TbOrder> list = orderService.list(new LambdaQueryWrapper<TbOrder>().eq(TbOrder::getStatus, 5).le(TbOrder::getSellerFinishTime, format)); + for (TbOrder tbOrder : list) { + successOrder(tbOrder.getId()); + } + } + + private void successOrder(String orderId){ + TbOrder order = orderService.getById(orderId); + TbCompany company = companyService.getById(order.getCompanyId()); + // 订单完成 商品已售卖 + order.setStatus(6); + order.updateById(); + order.setFinishTime( new Date()); + company.setStatus(3); + + // 分佣 + orderService.commission(order, company.getUserId()); + + // 卖家账户明细记录更新 + TbAccountDetail one = accountDetailService.getOne(new LambdaQueryWrapper<TbAccountDetail>().eq(TbAccountDetail::getOrderId, orderId).eq(TbAccountDetail::getCategory, 2)); + if (one != null) { + one.setStatus(2); + one.updateById(); + } + + company.updateById(); + } } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/vo/CompanyDetailVo.java b/ruoyi-system/src/main/java/com/ruoyi/system/vo/CompanyDetailVo.java index d3ddcf4..c0e18f4 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/vo/CompanyDetailVo.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/vo/CompanyDetailVo.java @@ -1,6 +1,7 @@ package com.ruoyi.system.vo; import com.baomidou.mybatisplus.annotation.TableField; +import com.fasterxml.jackson.annotation.JsonFormat; import com.ruoyi.system.model.TbOpeningBank; import com.ruoyi.system.model.TbPermit; import com.ruoyi.system.model.TbSchedule; @@ -51,11 +52,17 @@ @ApiModelProperty("市") private String city; + @ApiModelProperty("市编码") + private String cityCode; + @ApiModelProperty("省") private String province; @ApiModelProperty("区") private String area; + + @ApiModelProperty("区编码") + private String areaCode; @ApiModelProperty("预估天数") private Integer estimatedDays; @@ -151,6 +158,7 @@ private CustomerInfoVo customerInfoVo; @ApiModelProperty("支付时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date payTime; @ApiModelProperty("预估收入") @@ -160,11 +168,27 @@ private String customerName; @ApiModelProperty("确认时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date confirmTime; - @ApiModelProperty("企业经营异常信息 企查查参数说明") private Object companyExceptionInfo; + @ApiModelProperty("实缴资金") + private String paidInFunds; + + @ApiModelProperty("征信报告链接") + private String link; + + + @ApiModelProperty("卖家确认时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") + private Date sellerFinishTime; + + @ApiModelProperty("1上架 2 下架 3已出售 4锁定中") + private Integer state; + + @ApiModelProperty("订单id") + private String orderId; } diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/vo/CustomerInfoVo.java b/ruoyi-system/src/main/java/com/ruoyi/system/vo/CustomerInfoVo.java index c9b4654..c71a43d 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/vo/CustomerInfoVo.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/vo/CustomerInfoVo.java @@ -1,10 +1,12 @@ package com.ruoyi.system.vo; +import com.ruoyi.system.model.TbShareholder; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; +import java.util.List; @Data @ApiModel("客户填写信息Vo") @@ -63,4 +65,9 @@ @ApiModelProperty("添加天数") private Integer addDay; + + @ApiModelProperty("股东信息") + private List<TbShareholder> shareHolders; } + + diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/vo/MyPushCompanyListVo.java b/ruoyi-system/src/main/java/com/ruoyi/system/vo/MyPushCompanyListVo.java index a049276..e558156 100644 --- a/ruoyi-system/src/main/java/com/ruoyi/system/vo/MyPushCompanyListVo.java +++ b/ruoyi-system/src/main/java/com/ruoyi/system/vo/MyPushCompanyListVo.java @@ -1,5 +1,6 @@ package com.ruoyi.system.vo; +import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @@ -17,6 +18,7 @@ private String companyName; @ApiModelProperty("发布时间") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date createTime; @ApiModelProperty("售卖价格") @@ -25,6 +27,6 @@ @ApiModelProperty("订单id") private String orderId; - @ApiModelProperty("状态 -1取消 1待交易 2待确认(预定) 3已确认(待支付) 4办理中 5已完成") + @ApiModelProperty("状态 -1取消 1待交易 2待确认(预定) 3已确认(待支付) 4办理中 5已完成 6已下架") private Integer status; } diff --git a/ruoyi-system/src/main/resources/mapper/system/TbCompanyMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TbCompanyMapper.xml index 238718a..96ff8fa 100644 --- a/ruoyi-system/src/main/resources/mapper/system/TbCompanyMapper.xml +++ b/ruoyi-system/src/main/resources/mapper/system/TbCompanyMapper.xml @@ -50,10 +50,13 @@ <select id="getMyPushCompanyList" resultType="com.ruoyi.system.vo.MyPushCompanyListVo"> select * from ( select t1.id,t1.company_name,t1.create_time,t1.sale_money ,t2.id orderId, - COALESCE(t2.status, 1) AS status + case + when t1.status=2 then 6 + else + COALESCE(t2.status, 1) END AS status from tb_company t1 left join tb_order t2 on t1.id = t2.company_id - where t1.user_id = #{userId} and t2.status >0 + where t1.user_id = #{userId} and t1.is_delete =0 ) as t3 where 1= 1 <if test="query.status!=null"> and t3.status = #{query.status} @@ -62,5 +65,18 @@ </select> + <select id="getMyPushCompanyListNum" resultType="com.ruoyi.system.vo.MyPushCompanyListVo" + parameterType="java.lang.Long"> + select * from ( + select t1.id,t1.company_name,t1.create_time,t1.sale_money ,t2.id orderId, + case when t1.status=2 then 6 + else + COALESCE(t2.status, 1) END AS status + from tb_company t1 + left join tb_order t2 on t1.id = t2.company_id + where t1.user_id = #{userId} and t1.is_delete =0 + ) as t3 where 1= 1 + order by t3.create_time desc + </select> </mapper> diff --git a/ruoyi-system/src/main/resources/mapper/system/TbOrderMapper.xml b/ruoyi-system/src/main/resources/mapper/system/TbOrderMapper.xml index 6201958..6f3cc68 100644 --- a/ruoyi-system/src/main/resources/mapper/system/TbOrderMapper.xml +++ b/ruoyi-system/src/main/resources/mapper/system/TbOrderMapper.xml @@ -15,9 +15,22 @@ </resultMap> <select id="getMyOrderList" resultType="com.ruoyi.system.vo.MyPushCompanyListVo"> - select t1.id orderId,t2.id,t2.compamy_name companyName,t2.create_time createTime,t2.sale_money saleMoney,t2.status + select t1.id orderId,t2.id,t2.company_name companyName,t2.create_time createTime,t2.sale_money saleMoney,t1.status from tb_order t1 left join tb_company t2 on t1.company_id = t2.id - where t2.user_id =#{userId} + where t1.user_id =#{userId} and t2.id is not null + <if test="query.status != null and query.status !=6 "> + and t1.status = #{query.status} + </if> + <if test="query.status != null and query.status ==6 "> + and t1.status in (5,6) + </if> + order by t1.create_time desc + </select> + <select id="getMyOrderListNum" resultType="com.ruoyi.system.vo.MyPushCompanyListVo" + parameterType="java.lang.Long"> + select t1.id orderId,t2.id,t2.company_name companyName,t2.create_time createTime,t2.sale_money saleMoney,t1.status + from tb_order t1 left join tb_company t2 on t1.company_id = t2.id + where t1.user_id =#{userId} and t2.id is not null order by t1.create_time desc </select> -- Gitblit v1.7.1