岗位管理

前端调用后台接口

/** 查询岗位列表 */
getList() {
  this.loading = true;
  listPost(this.queryParams).then(response => {
    this.postList = response.rows;
    this.total = response.total;
    this.loading = false;
  });
}

/**
 * 获取岗位列表
 */
@PreAuthorize("@ss.hasPermi('system:post:list')")
@GetMapping("/list")
public TableDataInfo list(SysPost post)
{
    startPage();
    List<SysPost> list = postService.selectPostList(post);
    return getDataTable(list);
}

List<SysPost> list = postService.selectPostList(post);

/**
 * 查询岗位信息集合
 * 
 * @param post 岗位信息
 * @return 岗位信息集合
 */
@Override
public List<SysPost> selectPostList(SysPost post)
{
    return postMapper.selectPostList(post);
}

postMapper.selectPostList(post);

执行sql：

select post_id, post_code, post_name, post_sort, status, create_by, create_time, remark
from sys_post
<where>
   <if test="postCode != null and postCode != ''">
      AND post_code like concat('%', #{postCode}, '%')
   </if>
   <if test="status != null and status != ''">
      AND status = #{status}
   </if>
   <if test="postName != null and postName != ''">
      AND post_name like concat('%', #{postName}, '%')
   </if>
</where>