| | |
| | | @LogSave(operationType = "门店管理", contain = "查询门店") |
| | | public CommonResult<CommonPage<StoreInfoVO>> list(@RequestParam(value = "keyword", required = false) String keyword, |
| | | @RequestParam(value = "pageSize", defaultValue = "5") Integer pageSize, |
| | | @RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum) { |
| | | Page<StoreInfoVO> storeInfoPage = storeInfoService.list(keyword, pageSize, pageNum); |
| | | @RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum, |
| | | @RequestParam(value = "status", required = false) String status |
| | | ) { |
| | | Page<StoreInfoVO> storeInfoPage = storeInfoService.list(keyword, pageSize, pageNum,status); |
| | | return CommonResult.success(CommonPage.restPage(storeInfoPage)); |
| | | } |
| | | |
| | |
| | | @ApiModelProperty("摄像头") |
| | | @TableField("video_id") |
| | | private String videoId; |
| | | |
| | | @ApiModelProperty("店铺状态") |
| | | @TableField("status") |
| | | private String status; |
| | | } |
| | |
| | | |
| | | import lombok.Data; |
| | | import lombok.EqualsAndHashCode; |
| | | import lombok.NoArgsConstructor; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | @Data |
| | | @EqualsAndHashCode(callSuper = false) |
| | | @TableName("ums_video_point") |
| | | @NoArgsConstructor |
| | | public class VideoPoint implements Serializable { |
| | | |
| | | private static final long serialVersionUID = 1L; |
| | |
| | | */ |
| | | public interface StoreInfoMapper extends BaseMapper<StoreInfo> { |
| | | |
| | | Page<StoreInfoVO> selectStorePage(Page<StoreInfo> storeInfoPage, String keyword); |
| | | Page<StoreInfoVO> selectStorePage(Page<StoreInfo> storeInfoPage, String keyword,String status); |
| | | } |
| | |
| | | * @param pageNum 页码 |
| | | * @return 分页实体 |
| | | */ |
| | | Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum); |
| | | Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum,String status); |
| | | |
| | | /** |
| | | * 读取excel文件动态加载文件 |
| | |
| | | |
| | | |
| | | @Override |
| | | public Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum) { |
| | | public Page<StoreInfoVO> list(String keyword, Integer pageSize, Integer pageNum,String status) { |
| | | Page<StoreInfo> storeInfoPage = new Page<>(); |
| | | storeInfoPage.setSize(pageSize); |
| | | storeInfoPage.setCurrent(pageNum); |
| | | Page<StoreInfoVO> page = storeInfoMapper.selectStorePage(storeInfoPage, keyword); |
| | | Page<StoreInfoVO> page = storeInfoMapper.selectStorePage(storeInfoPage, keyword,status); |
| | | page.getRecords().forEach(x->x.setVideoPoint(videoPointMapper.selectById(x.getVideoId()))); |
| | | return page; |
| | | } |
| | |
| | | @TableField("store_score") |
| | | private BigDecimal storeScore; |
| | | |
| | | @ApiModelProperty("门店积分") |
| | | @ApiModelProperty("视频点位") |
| | | @TableField(" relation_video") |
| | | private BigDecimal relationVideo; |
| | | private String relationVideo; |
| | | |
| | | @ApiModelProperty("门店类型") |
| | | @TableField("type") |
| | |
| | | <if test="keyword!=null and keyword!=''"> |
| | | t1.store_name LIKE CONCAT('%', #{keyword}, '%') |
| | | </if> |
| | | <if test="status!=null and status!='' and status!='0' "> |
| | | t1.status = #{status} |
| | | </if> |
| | | </where> |
| | | order by t1.id desc |
| | | </select> |