基于Json传递数据的Augularjs分页的spring后台代码

@RequestMapping(value = "/shopsUsersAttendance", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
    public HttpEntity<PagedResources<ShopsUsersAttendance>> getAll(@RequestParam(value = "S_ID", required = true) Integer shopId,
                                                                   @RequestParam(value = "SU_ID", required = false) Integer staffId,
                                                                   @RequestParam(value = "MIN_SUA_START", required = false) Long minSuaStart,
                                                                   @RequestParam(value = "PAGE_INDEX", required = false) Integer pageIndex,
                                                                   @RequestParam(value = "PAGE_SIZE", required = false) Integer pageSize,
                                                                   PagedResourcesAssembler assembler) {
        if (minSuaStart == null) {
            minSuaStart = 0l;
        }
        ShopsUsers shopsUsers = this.springDataShopsUsers.getOne(staffId);
        if(pageIndex == 0 || pageSize == 0) {
            Page<ShopsUsersAttendance> shopsUsersAttendancePage = this.springDataShopsUsersAttendance.findBySuaSuIdAndSuaStartGreaterThanOrSuaSuIdAndSuaBossModifyStartGreaterThan(
                    staffId, minSuaStart, shopsUsers.getSuId(), minSuaStart, null);
            return new ResponseEntity<>(assembler.toResource(shopsUsersAttendancePage), HttpStatus.OK);
        }


        PageRequest pageRequest = new PageRequest(pageIndex - 1, pageSize, Sort.Direction.DESC, "suaId");
        Page<ShopsUsersAttendance> shopsUsersAttendancePage = this.springDataShopsUsersAttendance.findBySuaSuIdAndSuaStartGreaterThanOrSuaSuIdAndSuaBossModifyStartGreaterThan(
                staffId, minSuaStart, shopsUsers.getSuId(), minSuaStart, pageRequest);

        return new ResponseEntity<>(assembler.toResource(shopsUsersAttendancePage), HttpStatus.OK);

  }





@Repository
public interface SpringDataShopsUsersAttendance extends JpaRepository<ShopsUsersAttendance, Integer> {
    /**
     *   Spring Data JPA implements:
     */

    Page<ShopsUsersAttendance> findBySuaSuIdAndSuaStartGreaterThanOrSuaSuIdAndSuaBossModifyStartGreaterThan(
            @Param("suaSuId")Integer suaSuId, @Param("suaSuStart")Long suaSuStart, @Param("suaSuId")Integer suaSuId2,
            @Param("suaBossModifyStart")Long suaBossModifyStart, Pageable pageRequest)
            throws DataAccessException;
}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值