How to use

MailStatus

in

cn.sinjinsong.eshop.common.enumeration.mail

@Override
public MailStatus getResult(ResultSet rs, int columnIndex) throws SQLException {
  return MailStatus.getByCode(rs.getInt(columnIndex));
}

@Override
public void setParameter(PreparedStatement ps, int i, MailStatus parameter, JdbcType jdbcType) throws SQLException {
  ps.setInt(i, parameter.getCode());
}

@RequestMapping(value = "/by_target/{targetId}", method = RequestMethod.GET)
@ApiOperation(value = "按照发信人或收信人的id以及发信状态查询站内信信息", notes = "target是指定按照收信人还是发信人查询，可选值是sender和receiver；如果是按照收信人查询，那么必须指定mail_status，可选值为ALL、NOT_VIEWED、VIEWED；如果是按照发信人查询，则不需要给出该参数", response = PageInfo.class)
@ApiResponses(value = {
    @ApiResponse(code = 404, message = "按收信人查询时未给出mail_status"),
    @ApiResponse(code = 404, message = "未指定target")
})
public PageInfo<MailDO> findMails(@PathVariable("targetId") @ApiParam(value = "发信人或收信人的id", required = true) Long targetId,
                 @RequestParam("target") @ApiParam(value = "按照收信人还是发信人查询，可选值是sender和receiver", required = true) String target,
                 @RequestParam(value = "pageNum", required = false, defaultValue = "1") @ApiParam(value = "页码，从1开始，默认为1", required = false) Integer pageNum,
                 @RequestParam(value = "pageSize", required = false, defaultValue = "5") @ApiParam(value = "页的大小，默认为5") Integer pageSize,
                 @RequestParam(value = "mail_status", required = false) @ApiParam(value = "递信状态，如果是按照收信人查询，那么必须指定，可选值为ALL、NOT_VIEWED、VIEWED", required = false) String mailStatus) {
  QueryMailTarget queryTarget = QueryMailTarget.valueOf(StringUtils.upperCase(target));
  if (queryTarget == QueryMailTarget.RECEIVER) {
    if (StringUtils.isEmpty(mailStatus)) {
      throw new MailStatusNotFoundException(targetId);
    }
    return mailService.findByReceiver(targetId, pageNum, pageSize, MailStatus.valueOf(mailStatus.toUpperCase()));
  } else if (queryTarget == QueryMailTarget.SENDER) {
    return mailService.findBySender(targetId, pageNum, pageSize);
  }
  throw new MailTargetNotFoundException(target);
}

@RequestMapping(value = "/by_target/{targetId}/size", method = RequestMethod.GET)
@ApiOperation(value = "按照发信人或收信人的id以及发信状态查询站内信数量", notes = "target是指定按照收信人还是发信人查询，可选值是sender和receiver；如果是按照收信人查询，那么必须指定mail_status，可选值为ALL、NOT_VIEWED、VIEWED；如果是按照发信人查询，则不需要给出该参数", response = PageInfo.class)
@ApiResponses(value = {
    @ApiResponse(code = 404, message = "按收信人查询时未给出mail_status"),
    @ApiResponse(code = 404, message = "未指定target")
})
public Integer findMailsSize(@PathVariable("targetId") @ApiParam(value = "发信人或收信人的id", required = true) Long targetId,
               @RequestParam("target") @ApiParam(value = "按照收信人还是发信人查询，可选值是sender和receiver", required = true) String target,
               @RequestParam(value = "mail_status", required = false) @ApiParam(value = "递信状态，如果是按照收信人查询，那么必须指定，可选值为ALL、NOT_VIEWED、VIEWED", required = false) String mailStatus) {
  QueryMailTarget queryTarget = QueryMailTarget.valueOf(StringUtils.upperCase(target));
  if (queryTarget == QueryMailTarget.RECEIVER) {
    if (StringUtils.isEmpty(mailStatus)) {
      throw new MailStatusNotFoundException(targetId);
    }
    return mailService.findCountByReceiver(targetId, MailStatus.valueOf(mailStatus.toUpperCase()));
  } else if (queryTarget == QueryMailTarget.SENDER) {
    return mailService.findCountBySender(targetId);
  }
  throw new MailTargetNotFoundException(target);
}

@Override
public MailStatus getResult(ResultSet rs, String columnName) throws SQLException {
  return MailStatus.getByCode(rs.getInt(columnName));
}

  @Override
  public MailStatus getResult(CallableStatement cs, int columnIndex) throws SQLException {
    return MailStatus.getByCode(cs.getInt(columnIndex));
  }
}