searchpost
Change-Id: I3b471ad217a958e2e8bf22c005b1a3fd36454151
diff --git a/src/main/java/com/example/g8backend/mapper/PostMapper.java b/src/main/java/com/example/g8backend/mapper/PostMapper.java
index 6db4e67..0cba5c1 100644
--- a/src/main/java/com/example/g8backend/mapper/PostMapper.java
+++ b/src/main/java/com/example/g8backend/mapper/PostMapper.java
@@ -4,10 +4,32 @@
import com.example.g8backend.entity.Post;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
import java.util.List;
@Mapper
public interface PostMapper extends BaseMapper<Post> {
List<Post> getPostsByUserId(@Param("userId") Long userId);
+
+ @Select("<script>" +
+ "SELECT p.* " +
+ "FROM posts p " +
+ "LEFT JOIN post_tag pt ON p.post_id = pt.post_id " +
+ "LEFT JOIN tags t ON pt.tag_id = t.tag_id " +
+ "LEFT JOIN users u ON p.user_id = u.user_id " +
+ "WHERE (p.post_title LIKE CONCAT('%', #{keyword}, '%') OR p.post_content LIKE CONCAT('%', #{keyword}, '%')) " +
+ "<if test='tagIds != null and tagIds.size() > 0'> " +
+ "AND pt.tag_id IN " +
+ "<foreach item='tagId' collection='tagIds' open='(' separator=',' close=')'> " +
+ "#{tagId} " +
+ "</foreach> " +
+ "</if>" +
+ "<if test='author != null'> " +
+ "AND u.user_name = #{author} " +
+ "</if>" +
+ "</script>")
+ List<Post> searchPosts(@Param("keyword") String keyword,
+ @Param("tagIds") List<Long> tagIds, // 改成接受一个tagIds列表
+ @Param("author") String author);
}