seecoder-devcloud/web/src/main/java/seecoder/devcloud/web/dao/tree/TreeNodeMapper.java

package seecoder.devcloud.web.dao.tree;


import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import seecoder.devcloud.web.model.po.TreeNodePO;
import seecoder.devcloud.web.dao.provider.TreeNodeProvider;

import java.util.List;

@Mapper
@Repository
public interface TreeNodeMapper {

    /**
     * 获取所有的TreeNode
     * @return
     */
    @Select({"select * from tree_nodes"})
    @Results(id="treeNodeMap",value = {
            @Result(column = "is_leaf", property = "leaf"),
            @Result(column = "time_to_take", property = "timeToTake"),
            @Result(column = "start_time", property = "startTime"),
            @Result(column = "end_time", property = "endTime"),
            @Result(column = "group_id", property = "groupId"),
            @Result(column = "project_id", property = "projectId"),
            @Result(column = "parent_id", property = "parentId"),
            @Result(column = "state",property = "state"),
            @Result(column = "type",property = "type")
    })
    List<TreeNodePO> listAllTreeNodes();

    /**
     * 根据id获取TreeNode
     * @param id
     * @return
     */
    @Select({"select * from tree_nodes where id = #{id}"})
    @ResultMap(value = "treeNodeMap")
    TreeNodePO getTreeNodeById(@Param("id") int id);

    /**
     * 根据GroupId获取TreeNode
     * @param groupId
     * @return
     */
    @Select({"select * from tree_nodes where group_id = #{groupId}"})
    @ResultMap(value = "treeNodeMap")
    List<TreeNodePO> listTreeNodesByGroupId(@Param("groupId") int groupId);

    /**
     * 根据projectId获取TreeNode
     * @param projectId
     * @return
     */
    @Select({"select * from tree_nodes where project_id = #{projectId}"})
    @ResultMap(value = "treeNodeMap")
    List<TreeNodePO> listTreeNodesByProjectId(@Param("projectId") int projectId);

    /**
     * 插入treeNode
     * @param TreeNodePO
     * @return treeNode的自增主键
     */
    @Insert({"insert into tree_nodes(title, description, type, priority, state, time_to_take, start_time, end_time, is_leaf, group_id,project_id,deep,parent_id) " +
            "VALUES (#{title}, #{description}, #{type}, #{priority}, #{state}, #{timeToTake}, #{startTime}, #{endTime}, #{leaf}, #{groupId},#{projectId},#{deep},#{parentId})"})
    @Options(useGeneratedKeys = true, keyProperty = "id")
    int insertTreeNode(TreeNodePO TreeNodePO);

    /**
     * 更新TreeNode
     * @param TreeNodePO
     * @return
     */
    @UpdateProvider(type = TreeNodeProvider.class,method = "updateTreeNode")
    int updateTreeNode(TreeNodePO TreeNodePO);

}