From 867d1b68fcdf6c9a072d3a516368333ad59f2e00 Mon Sep 17 00:00:00 2001 From: 无关风月 <443237572@qq.com> Date: 星期三, 18 十二月 2024 08:46:58 +0800 Subject: [PATCH] Merge branch 'master' of http://120.76.84.145:10101/gitblit/r/java/eyes --- applet/src/main/java/com/jilongda/applet/model/TCouponReceive.java | 4 applet/src/main/java/com/jilongda/applet/mapper/TCouponReceiveMapper.java | 14 ++ applet/src/main/java/com/jilongda/applet/service/TCouponReceiveService.java | 9 + applet/src/main/java/com/jilongda/applet/mapper/TOptometryMapper.java | 14 ++ applet/src/main/java/com/jilongda/applet/controller/TCouponReceiveController.java | 57 +++++++++ manage/src/main/java/com/jilongda/manage/model/TWarehousing.java | 3 applet/src/main/resources/mapping/TOptometryMapper.xml | 17 ++ applet/src/main/java/com/jilongda/applet/vo/TOptometryVO.java | 30 +++++ applet/src/main/java/com/jilongda/applet/mapper/TStoreMapper.java | 2 applet/src/main/java/com/jilongda/applet/service/impl/TOptometryServiceImpl.java | 14 ++ manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java | 4 applet/src/main/java/com/jilongda/applet/service/impl/TCouponReceiveServiceImpl.java | 31 +++++ applet/src/main/java/com/jilongda/applet/controller/TOptometryController.java | 83 +++++++++++++ applet/src/main/java/com/jilongda/applet/vo/TCouponReceiveVO.java | 18 +++ applet/src/main/java/com/jilongda/applet/model/TCoupon.java | 4 applet/src/main/java/com/jilongda/applet/query/TCouponQuery.java | 15 ++ applet/src/main/java/com/jilongda/applet/query/TOptometryQuery.java | 15 ++ applet/src/main/java/com/jilongda/applet/service/TOptometryService.java | 9 + applet/src/main/resources/mapping/TCouponReceiveMapper.xml | 15 ++ manage/src/main/java/com/jilongda/manage/query/TWarehousingDetailQuery.java | 2 20 files changed, 346 insertions(+), 14 deletions(-) diff --git a/applet/src/main/java/com/jilongda/applet/controller/TCouponReceiveController.java b/applet/src/main/java/com/jilongda/applet/controller/TCouponReceiveController.java index 48f2d8f..6ca9fc1 100644 --- a/applet/src/main/java/com/jilongda/applet/controller/TCouponReceiveController.java +++ b/applet/src/main/java/com/jilongda/applet/controller/TCouponReceiveController.java @@ -1,9 +1,23 @@ package com.jilongda.applet.controller; -import org.springframework.web.bind.annotation.RequestMapping; +import com.jilongda.applet.model.TCoupon; +import com.jilongda.applet.model.TCouponReceive; +import com.jilongda.applet.query.TCouponQuery; +import com.jilongda.applet.service.TCouponReceiveService; +import com.jilongda.applet.service.TCouponService; +import com.jilongda.applet.service.TStoreService; +import com.jilongda.applet.utils.LoginInfoUtil; +import com.jilongda.applet.vo.TCouponReceiveVO; +import com.jilongda.common.basic.ApiResult; +import com.jilongda.common.basic.PageInfo; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; -import org.springframework.web.bind.annotation.RestController; +import java.time.LocalDateTime; +import java.util.Objects; /** * <p> @@ -13,9 +27,48 @@ * @author 无关风月 * @since 2024-12-09 */ +@Api(tags = "优惠券记录") @RestController @RequestMapping("/t-coupon-receive") public class TCouponReceiveController { + @Autowired + private TCouponReceiveService tCouponReceiveService; + @Autowired + private TCouponService couponService; + @Autowired + private LoginInfoUtil loginInfoUtil; + @ApiOperation(value = "优惠券列表") + @PostMapping(value = "/pageList") + public ApiResult pageList(@RequestBody TCouponQuery query) { + Integer userId = loginInfoUtil.getUserId(); + query.setUserId(userId); + PageInfo<TCouponReceiveVO> page = tCouponReceiveService.pageList(query); + return ApiResult.success(page); + } + + @ApiOperation(value = "扫码领取优惠券;优惠券id") + @GetMapping(value = "/getCoupons") + public ApiResult getCoupons(@RequestParam Integer id) { + Integer userId = loginInfoUtil.getUserId(); + + // 查询优惠券信息 + TCoupon coupon = couponService.getById(id); + if(Objects.isNull(coupon)){ + return ApiResult.failed("优惠券不存在"); + } + + TCouponReceive tCouponReceive = new TCouponReceive(); + tCouponReceive.setUserId(userId); + tCouponReceive.setCouponId(id); + tCouponReceive.setType(4); + tCouponReceive.setAmount(coupon.getAmount()); + tCouponReceive.setStoreId(coupon.getStoreId()); + tCouponReceive.setEndTime(LocalDateTime.now().plusDays(coupon.getTime())); + tCouponReceive.setAmountCondition(coupon.getAmountCondition()); + tCouponReceive.setStatus(1); + tCouponReceiveService.save(tCouponReceive); + return ApiResult.success(); + } } diff --git a/applet/src/main/java/com/jilongda/applet/controller/TOptometryController.java b/applet/src/main/java/com/jilongda/applet/controller/TOptometryController.java index 821c8a9..1bf6313 100644 --- a/applet/src/main/java/com/jilongda/applet/controller/TOptometryController.java +++ b/applet/src/main/java/com/jilongda/applet/controller/TOptometryController.java @@ -1,9 +1,29 @@ package com.jilongda.applet.controller; -import org.springframework.web.bind.annotation.RequestMapping; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.jilongda.applet.model.TOptometrist; +import com.jilongda.applet.model.TOptometry; +import com.jilongda.applet.model.TOptometryDetail; +import com.jilongda.applet.model.TStore; +import com.jilongda.applet.query.TOptometryQuery; +import com.jilongda.applet.service.TOptometristService; +import com.jilongda.applet.service.TOptometryDetailService; +import com.jilongda.applet.service.TOptometryService; +import com.jilongda.applet.service.TStoreService; +import com.jilongda.applet.utils.LoginInfoUtil; +import com.jilongda.applet.vo.TOptometryVO; +import com.jilongda.common.basic.ApiResult; +import com.jilongda.common.basic.PageInfo; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.beans.BeanUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.*; -import org.springframework.web.bind.annotation.RestController; +import java.util.ArrayList; +import java.util.List; +import java.util.Objects; /** * <p> @@ -13,9 +33,68 @@ * @author 无关风月 * @since 2024-12-09 */ +@Api(tags = "验光单") @RestController @RequestMapping("/t-optometry") public class TOptometryController { + @Autowired + private TOptometryService tOptometryService; + @Autowired + private TOptometryDetailService optometryDetailService; + @Autowired + private TOptometristService optometristService; + @Autowired + private TStoreService storeService; + @Autowired + private LoginInfoUtil loginInfoUtil; + + @ApiOperation(value = "视光档案") + @PostMapping(value = "/pageList") + public ApiResult pageList(@RequestBody TOptometryQuery query) { + Integer userId = loginInfoUtil.getUserId(); + query.setUserId(userId); + PageInfo<TOptometryVO> tOptometryVOPageInfo = tOptometryService.pageList(query); + return ApiResult.success(tOptometryVOPageInfo); + } + + @ApiOperation(value = "视光档案详情") + @GetMapping(value = "/getDetailById") + public ApiResult getDetailById(@RequestParam Integer id) { + TOptometry optometry = tOptometryService.getById(id); + TOptometryVO tOptometryVO = new TOptometryVO(); + BeanUtils.copyProperties(optometry, tOptometryVO); + TOptometrist optometrist = optometristService.getById(optometry.getOptometristId()); + if(Objects.nonNull(optometrist)){ + tOptometryVO.setOptometristName(optometry.getName()); + } + TStore store = storeService.getById(optometry.getStoreId()); + if(Objects.nonNull(store)){ + tOptometryVO.setStoreName(store.getName()); + } + + List<TOptometryDetail> list = optometryDetailService.list(Wrappers.<TOptometryDetail>lambdaQuery().eq(TOptometryDetail::getOptometryId, id)); + List<TOptometryDetail> completeCorrectionList = new ArrayList<>(); + List<TOptometryDetail> prescriptionGlassesList = new ArrayList<>(); + List<TOptometryDetail> oldMirrorInformationList = new ArrayList<>(); + for (TOptometryDetail tOptometryDetail : list) { + switch (tOptometryDetail.getType()){ + case 1: + prescriptionGlassesList.add(tOptometryDetail); + break; + case 2: + completeCorrectionList.add(tOptometryDetail); + break; + default: + oldMirrorInformationList.add(tOptometryDetail); + break; + } + } + tOptometryVO.setCompleteCorrectionList(completeCorrectionList); + tOptometryVO.setPrescriptionGlassesList(prescriptionGlassesList); + tOptometryVO.setOldMirrorInformationList(oldMirrorInformationList); + return ApiResult.success(tOptometryVO); + } + } diff --git a/applet/src/main/java/com/jilongda/applet/mapper/TCouponReceiveMapper.java b/applet/src/main/java/com/jilongda/applet/mapper/TCouponReceiveMapper.java index 977bf5d..7232e3d 100644 --- a/applet/src/main/java/com/jilongda/applet/mapper/TCouponReceiveMapper.java +++ b/applet/src/main/java/com/jilongda/applet/mapper/TCouponReceiveMapper.java @@ -2,6 +2,12 @@ import com.jilongda.applet.model.TCouponReceive; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.jilongda.applet.query.TCouponQuery; +import com.jilongda.applet.vo.TCouponReceiveVO; +import com.jilongda.common.basic.PageInfo; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** * <p> @@ -13,4 +19,12 @@ */ public interface TCouponReceiveMapper extends BaseMapper<TCouponReceive> { + /** + * 分页查询优惠券领取记录 + * @param query + * @param pageInfo + * @return + */ + List<TCouponReceiveVO> pageList(@Param("query") TCouponQuery query, @Param("pageInfo")PageInfo<TCouponReceiveVO> pageInfo); + } diff --git a/applet/src/main/java/com/jilongda/applet/mapper/TOptometryMapper.java b/applet/src/main/java/com/jilongda/applet/mapper/TOptometryMapper.java index 6d2704c..8a84969 100644 --- a/applet/src/main/java/com/jilongda/applet/mapper/TOptometryMapper.java +++ b/applet/src/main/java/com/jilongda/applet/mapper/TOptometryMapper.java @@ -2,6 +2,12 @@ import com.jilongda.applet.model.TOptometry; import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.jilongda.applet.query.TOptometryQuery; +import com.jilongda.applet.vo.TOptometryVO; +import com.jilongda.common.basic.PageInfo; +import org.apache.ibatis.annotations.Param; + +import java.util.List; /** * <p> @@ -13,4 +19,12 @@ */ public interface TOptometryMapper extends BaseMapper<TOptometry> { + /** + * 分页查询 + * @param query + * @param pageInfo + * @return + */ + List<TOptometryVO> pageList(@Param("query") TOptometryQuery query, @Param("pageInfo")PageInfo<TOptometryVO> pageInfo); + } diff --git a/applet/src/main/java/com/jilongda/applet/mapper/TStoreMapper.java b/applet/src/main/java/com/jilongda/applet/mapper/TStoreMapper.java index 8855c42..fa567db 100644 --- a/applet/src/main/java/com/jilongda/applet/mapper/TStoreMapper.java +++ b/applet/src/main/java/com/jilongda/applet/mapper/TStoreMapper.java @@ -5,6 +5,7 @@ import com.jilongda.applet.query.TStoreQuery; import com.jilongda.applet.vo.TStoreVO; import com.jilongda.common.basic.PageInfo; +import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; @@ -17,6 +18,7 @@ * @author 无关风月 * @since 2024-12-09 */ +@Mapper public interface TStoreMapper extends BaseMapper<TStore> { List<TStoreVO> pageList(@Param("query")TStoreQuery query, @Param("pageInfo")PageInfo<TStoreVO> pageInfo); diff --git a/applet/src/main/java/com/jilongda/applet/model/TCoupon.java b/applet/src/main/java/com/jilongda/applet/model/TCoupon.java index f114d28..8cb1f36 100644 --- a/applet/src/main/java/com/jilongda/applet/model/TCoupon.java +++ b/applet/src/main/java/com/jilongda/applet/model/TCoupon.java @@ -46,9 +46,9 @@ @TableField("amount") private BigDecimal amount; - @ApiModelProperty(value = "门店id 字段为null表示全部") + @ApiModelProperty(value = "门店id 字段为null表示全部,逗号分隔") @TableField("storeId") - private Integer storeId; + private String storeId; @ApiModelProperty(value = "有效期(天)最高365") @TableField("time") diff --git a/applet/src/main/java/com/jilongda/applet/model/TCouponReceive.java b/applet/src/main/java/com/jilongda/applet/model/TCouponReceive.java index 83786b6..3de0f57 100644 --- a/applet/src/main/java/com/jilongda/applet/model/TCouponReceive.java +++ b/applet/src/main/java/com/jilongda/applet/model/TCouponReceive.java @@ -50,9 +50,9 @@ @TableField("amount") private BigDecimal amount; - @ApiModelProperty(value = "门店id 字段为null表示全部") + @ApiModelProperty(value = "门店id 字段为null表示全部,逗号分隔") @TableField("storeId") - private Integer storeId; + private String storeId; @ApiModelProperty(value = "有效期截止日期") @TableField("endTime") diff --git a/applet/src/main/java/com/jilongda/applet/query/TCouponQuery.java b/applet/src/main/java/com/jilongda/applet/query/TCouponQuery.java new file mode 100644 index 0000000..3273533 --- /dev/null +++ b/applet/src/main/java/com/jilongda/applet/query/TCouponQuery.java @@ -0,0 +1,15 @@ +package com.jilongda.applet.query; + +import com.jilongda.common.pojo.BasePage; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +@ApiModel(value = "优惠券查询参数") +public class TCouponQuery extends BasePage { + + @ApiModelProperty(value = "用户id 前端忽略") + private Integer userId; + +} diff --git a/applet/src/main/java/com/jilongda/applet/query/TOptometryQuery.java b/applet/src/main/java/com/jilongda/applet/query/TOptometryQuery.java new file mode 100644 index 0000000..b45a80d --- /dev/null +++ b/applet/src/main/java/com/jilongda/applet/query/TOptometryQuery.java @@ -0,0 +1,15 @@ +package com.jilongda.applet.query; + +import com.jilongda.common.pojo.BasePage; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +@ApiModel(value = "验光单查询") +public class TOptometryQuery extends BasePage { + + @ApiModelProperty(value = "用户id 前端忽略") + private Integer userId; + +} diff --git a/applet/src/main/java/com/jilongda/applet/service/TCouponReceiveService.java b/applet/src/main/java/com/jilongda/applet/service/TCouponReceiveService.java index c6fe6fa..6791811 100644 --- a/applet/src/main/java/com/jilongda/applet/service/TCouponReceiveService.java +++ b/applet/src/main/java/com/jilongda/applet/service/TCouponReceiveService.java @@ -2,6 +2,9 @@ import com.jilongda.applet.model.TCouponReceive; import com.baomidou.mybatisplus.extension.service.IService; +import com.jilongda.applet.query.TCouponQuery; +import com.jilongda.applet.vo.TCouponReceiveVO; +import com.jilongda.common.basic.PageInfo; /** * <p> @@ -13,4 +16,10 @@ */ public interface TCouponReceiveService extends IService<TCouponReceive> { + /** + * 优惠券列表 + * @param query + * @return + */ + PageInfo<TCouponReceiveVO> pageList(TCouponQuery query); } diff --git a/applet/src/main/java/com/jilongda/applet/service/TOptometryService.java b/applet/src/main/java/com/jilongda/applet/service/TOptometryService.java index e2e4da6..38b771e 100644 --- a/applet/src/main/java/com/jilongda/applet/service/TOptometryService.java +++ b/applet/src/main/java/com/jilongda/applet/service/TOptometryService.java @@ -2,6 +2,9 @@ import com.jilongda.applet.model.TOptometry; import com.baomidou.mybatisplus.extension.service.IService; +import com.jilongda.applet.query.TOptometryQuery; +import com.jilongda.applet.vo.TOptometryVO; +import com.jilongda.common.basic.PageInfo; /** * <p> @@ -13,4 +16,10 @@ */ public interface TOptometryService extends IService<TOptometry> { + /** + * 视光档案 + * @param query + * @return + */ + PageInfo<TOptometryVO> pageList(TOptometryQuery query); } diff --git a/applet/src/main/java/com/jilongda/applet/service/impl/TCouponReceiveServiceImpl.java b/applet/src/main/java/com/jilongda/applet/service/impl/TCouponReceiveServiceImpl.java index a003d50..6ad6494 100644 --- a/applet/src/main/java/com/jilongda/applet/service/impl/TCouponReceiveServiceImpl.java +++ b/applet/src/main/java/com/jilongda/applet/service/impl/TCouponReceiveServiceImpl.java @@ -1,10 +1,22 @@ package com.jilongda.applet.service.impl; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.jilongda.applet.mapper.TStoreMapper; import com.jilongda.applet.model.TCouponReceive; import com.jilongda.applet.mapper.TCouponReceiveMapper; +import com.jilongda.applet.model.TStore; +import com.jilongda.applet.query.TCouponQuery; import com.jilongda.applet.service.TCouponReceiveService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.jilongda.applet.service.TStoreService; +import com.jilongda.applet.vo.TCouponReceiveVO; +import com.jilongda.common.basic.PageInfo; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.util.StringUtils; + +import java.util.Arrays; +import java.util.List; /** * <p> @@ -16,5 +28,22 @@ */ @Service public class TCouponReceiveServiceImpl extends ServiceImpl<TCouponReceiveMapper, TCouponReceive> implements TCouponReceiveService { - + @Autowired + private TStoreMapper storeMapper; + @Override + public PageInfo<TCouponReceiveVO> pageList(TCouponQuery query) { + PageInfo<TCouponReceiveVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); + List<TCouponReceiveVO> list = this.baseMapper.pageList(query,pageInfo); + for (TCouponReceiveVO tCouponReceiveVO : list) { + if(StringUtils.hasLength(tCouponReceiveVO.getStoreId())){ + List<TStore> tStores = storeMapper.selectList(Wrappers.lambdaQuery(TStore.class) + .in(TStore::getId, Arrays.asList(tCouponReceiveVO.getStoreId().split(",")))); + tCouponReceiveVO.setStoreName(tStores.stream().map(TStore::getName).reduce((a, b) -> a + "," + b).orElse("")); + }else { + tCouponReceiveVO.setStoreName("全部门店"); + } + } + pageInfo.setRecords(list); + return pageInfo; + } } diff --git a/applet/src/main/java/com/jilongda/applet/service/impl/TOptometryServiceImpl.java b/applet/src/main/java/com/jilongda/applet/service/impl/TOptometryServiceImpl.java index eb06032..3061ea2 100644 --- a/applet/src/main/java/com/jilongda/applet/service/impl/TOptometryServiceImpl.java +++ b/applet/src/main/java/com/jilongda/applet/service/impl/TOptometryServiceImpl.java @@ -2,9 +2,15 @@ import com.jilongda.applet.model.TOptometry; import com.jilongda.applet.mapper.TOptometryMapper; +import com.jilongda.applet.query.TOptometryQuery; import com.jilongda.applet.service.TOptometryService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.jilongda.applet.vo.TOptometryVO; +import com.jilongda.applet.vo.TStoreVO; +import com.jilongda.common.basic.PageInfo; import org.springframework.stereotype.Service; + +import java.util.List; /** * <p> @@ -17,4 +23,12 @@ @Service public class TOptometryServiceImpl extends ServiceImpl<TOptometryMapper, TOptometry> implements TOptometryService { + @Override + public PageInfo<TOptometryVO> pageList(TOptometryQuery query) { + PageInfo<TOptometryVO> pageInfo = new PageInfo<>(query.getPageNum(), query.getPageSize()); + List<TOptometryVO> list = this.baseMapper.pageList(query, pageInfo); + pageInfo.setRecords(list); + // 获取列表 + return pageInfo; + } } diff --git a/applet/src/main/java/com/jilongda/applet/vo/TCouponReceiveVO.java b/applet/src/main/java/com/jilongda/applet/vo/TCouponReceiveVO.java new file mode 100644 index 0000000..de82006 --- /dev/null +++ b/applet/src/main/java/com/jilongda/applet/vo/TCouponReceiveVO.java @@ -0,0 +1,18 @@ +package com.jilongda.applet.vo; + +import com.jilongda.applet.model.TCouponReceive; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +@Data +@ApiModel(value = "优惠券领取VO") +public class TCouponReceiveVO extends TCouponReceive { + + @ApiModelProperty(value = "优惠券名称") + private String couponName; + + @ApiModelProperty(value = "门店名称") + private String storeName; + +} diff --git a/applet/src/main/java/com/jilongda/applet/vo/TOptometryVO.java b/applet/src/main/java/com/jilongda/applet/vo/TOptometryVO.java new file mode 100644 index 0000000..05aebe1 --- /dev/null +++ b/applet/src/main/java/com/jilongda/applet/vo/TOptometryVO.java @@ -0,0 +1,30 @@ +package com.jilongda.applet.vo; + +import com.jilongda.applet.model.TOptometry; +import com.jilongda.applet.model.TOptometryDetail; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +import java.util.List; + +@Data +@ApiModel(value = "验光单VO") +public class TOptometryVO extends TOptometry { + + @ApiModelProperty(value = "门店名称") + private String storeName; + + @ApiModelProperty(value = "验光师名称") + private String optometristName; + + @ApiModelProperty(value = "完全矫正") + private List<TOptometryDetail> completeCorrectionList; + + @ApiModelProperty(value = "配镜处方") + private List<TOptometryDetail> prescriptionGlassesList; + + @ApiModelProperty(value = "旧镜信息") + private List<TOptometryDetail> oldMirrorInformationList; + +} diff --git a/applet/src/main/resources/mapping/TCouponReceiveMapper.xml b/applet/src/main/resources/mapping/TCouponReceiveMapper.xml index 9e2b92f..e026d56 100644 --- a/applet/src/main/resources/mapping/TCouponReceiveMapper.xml +++ b/applet/src/main/resources/mapping/TCouponReceiveMapper.xml @@ -22,7 +22,20 @@ <!-- 通用查询结果列 --> <sql id="Base_Column_List"> - id, couponId, userId, type, amount, storeId, endTime, amountCondition, status, createTime, updateTime, createBy, updateBy, isDelete + id, couponId, userId, `type`, amount, storeId, endTime, amountCondition, status, createTime, updateTime, createBy, updateBy, isDelete </sql> + <select id="pageList" resultType="com.jilongda.applet.vo.TCouponReceiveVO"> + select tcr.id, tcr.couponId, tcr.userId, tcr.`type`, tcr.amount, tcr.storeId, tcr.endTime, tcr.amountCondition, tcr.status, + tcr.createTime, tcr.updateTime, tcr.createBy, tcr.updateBy, tcr.isDelete,tc.name as couponName + from t_coupon_receive tcr + left join t_coupon tc on tc.id = tcr.couponId + <where> + <if test="query.userId != null"> + and tcr.userId = #{query.userId} + </if> + AND tcr.isDelete = ${@com.jilongda.common.enums.DisabledEnum@NO.getCode()} + </where> + ORDER BY tcr.status ASC,tcr.createTime DESC + </select> </mapper> diff --git a/applet/src/main/resources/mapping/TOptometryMapper.xml b/applet/src/main/resources/mapping/TOptometryMapper.xml index 26fc32f..ddf5d08 100644 --- a/applet/src/main/resources/mapping/TOptometryMapper.xml +++ b/applet/src/main/resources/mapping/TOptometryMapper.xml @@ -24,7 +24,22 @@ <!-- 通用查询结果列 --> <sql id="Base_Column_List"> - id, code, userId, age, gender, name, phone, optometristId, storeId, status, registerTime, createTime, updateTime, createBy, updateBy, isDelete + id, code, userId, age, gender, `name`, phone, optometristId, storeId, status, registerTime, createTime, updateTime, createBy, updateBy, isDelete </sql> + <select id="pageList" resultType="com.jilongda.applet.vo.TOptometryVO"> + select o.id, o.code, o.userId, o.age, o.gender, o.`name`, o.phone, o.optometristId, o.storeId, o.status, o.registerTime, + o.createTime, o.updateTime, o.createBy, o.updateBy, o.isDelete, + t.name as optometristName, s.name as storeName + from t_optometry o + left join t_optometrist t on o.optometristId = t.id + left join t_store s on o.storeId = s.id + <where> + <if test="query.userId != null"> + and o.userId = #{query.userId} + </if> + AND o.isDelete = ${@com.jilongda.common.enums.DisabledEnum@NO.getCode()} + </where> + ORDER BY o.createTime DESC + </select> </mapper> diff --git a/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java b/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java index 25b91ae..bba637a 100644 --- a/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java +++ b/manage/src/main/java/com/jilongda/manage/controller/TWarehousingController.java @@ -90,7 +90,7 @@ */ @ApiOperation(value = "添加镜架出库,入库,作废,退货") @PostMapping(value = "/outBound") - public ApiResult<String> outBound(@Validated @RequestBody TWarehousingDTO dto) { + public ApiResult<Integer> outBound(@Validated @RequestBody TWarehousingDTO dto) { // 获取当前用户 String username = JwtTokenUtils.getUsername(); dto.setCreateBy(username); @@ -105,7 +105,7 @@ detail.setCode(WarehousingConstant.OUT_BOUND+CodeGenerateUtils.generateVolumeSn()); }); frameWarehousingDetailService.saveBatch(frameWarehousingDetails); - return ApiResult.success(); + return ApiResult.success(dto.getId()); } /** * 添加镜片出库,入库,作废,退货 diff --git a/manage/src/main/java/com/jilongda/manage/model/TWarehousing.java b/manage/src/main/java/com/jilongda/manage/model/TWarehousing.java index ecc38ad..53c04c0 100644 --- a/manage/src/main/java/com/jilongda/manage/model/TWarehousing.java +++ b/manage/src/main/java/com/jilongda/manage/model/TWarehousing.java @@ -13,6 +13,8 @@ import lombok.Data; import lombok.EqualsAndHashCode; +import javax.validation.constraints.NotNull; + /** * <p> * 镜架/镜片出库入库表 @@ -34,6 +36,7 @@ private Integer id; @ApiModelProperty(value = "1=出库,2=入库,3=作废,4=退货") + @NotNull(message = "状态不能为空") @TableField("status") private Integer status; diff --git a/manage/src/main/java/com/jilongda/manage/query/TWarehousingDetailQuery.java b/manage/src/main/java/com/jilongda/manage/query/TWarehousingDetailQuery.java index 2108f54..c085a16 100644 --- a/manage/src/main/java/com/jilongda/manage/query/TWarehousingDetailQuery.java +++ b/manage/src/main/java/com/jilongda/manage/query/TWarehousingDetailQuery.java @@ -6,7 +6,7 @@ import lombok.Data; @Data -@ApiModel(value = "明细记录查询/出入库单Query") +@ApiModel(value = "明细记录查询出入库单Query") public class TWarehousingDetailQuery extends TimeRangePageDTO { @ApiModelProperty(value = "品牌") -- Gitblit v1.7.1