@ApiOperation ( value = "人员账号列表顺序调整功能(上移/下移)" )
@GetMapping ( "/personInfoMoveUp" )
@Log ( option = "人员账号列表顺序调整功能(上移/下移)" , businessType = BusinessType . UPDATE)
public Result personInfoMoveUp ( String oid, String operaType) {
try {
Integer code = personInfoService. personInfoMoveUp ( oid, operaType) ;
if ( code== - 2 ) {
return Result . error ( "未查询到人员账号信息" ) ;
}
return Result . success ( "排序成功" ) ;
} catch ( Exception e) {
log. error ( "人员账号上移/下移异常" , e) ;
return Result . error ( "操作失败" ) ;
}
}
@Override
public Integer personInfoMoveUp(String oid, String operaType) {
PersonInfo personInfo = personInfoMapper.selectById(oid);
if (Objects.isNull(personInfo)) {
return -2;
}
// operaType等于1 上移
if (IsValid.YES.getCode().equals(operaType)) {
// 查询上一条记录的ID
String perviousOid = personInfoMapper.selectPreviousId(personInfo.getSort());
// 不为1 说明有上一条记录进行交换排序值
if (!IsValid.YES.getCode().equals(perviousOid)) {
PersonInfo perviousPersonInfo = personInfoMapper.selectById(perviousOid);
// 将本条记录排序值设为上条
personInfoMapper.updateSortById(personInfo.getOid(), perviousPersonInfo.getSort());
// 将上条记录排序值设为本条
personInfoMapper.updateSortById(perviousPersonInfo.getOid(), personInfo.getSort());
return 2;
}
} else {
// 下移 查询下一条记录的ID
String perviousOid = personInfoMapper.selectNextSort(personInfo.getSort());
// 不为1 说明有下一条记录进行交换排序值
if (!IsValid.YES.getCode().equals(perviousOid)) {
PersonInfo nextPersonInfo = personInfoMapper.selectById(perviousOid);
// 将本条记录排序值设为下条
personInfoMapper.updateSortById(personInfo.getOid(), nextPersonInfo.getSort());
// 将下条记录排序值设为本条
personInfoMapper.updateSortById(nextPersonInfo.getOid(), personInfo.getSort());
return 2;
}
}
return 1;
}
< select id = " selectPreviousId" resultType = " java.lang.String" >
SELECT IFNULL(
(SELECT OID FROM person_info WHERE sort < #{sort}
ORDER BY SORT DESC LIMIT 0,1),1)
</ select>
< select id = " selectNextSort" resultType = " java.lang.String" >
SELECT IFNULL(
(SELECT OID FROM person_info WHERE sort > #{sort}
ORDER BY SORT ASC LIMIT 0,1),1)
</ select>
< update id = " updateSortById" >
update person_info
set sort = #{sort}
where OID = #{oid}
</ update>