PostPushDao.java 2.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152
  1. package com.sqx.modules.resumes.dao;
  2. import com.baomidou.mybatisplus.core.mapper.BaseMapper;
  3. import com.baomidou.mybatisplus.core.metadata.IPage;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.sqx.common.utils.Result;
  6. import com.sqx.modules.resumes.entity.PostDetails;
  7. import com.sqx.modules.resumes.entity.PostPush;
  8. import com.sqx.modules.resumes.vo.CityVo;
  9. import com.sqx.modules.resumes.vo.LetterCity;
  10. import org.apache.ibatis.annotations.Mapper;
  11. import org.apache.ibatis.annotations.Param;
  12. import java.time.LocalDateTime;
  13. import java.util.List;
  14. /**
  15. * @author fang
  16. * @date 2022/8/3
  17. */
  18. @Mapper
  19. public interface PostPushDao extends BaseMapper<PostPush> {
  20. int insertPostPush(PostPush postPush);
  21. IPage<PostPush> getPostPushList(@Param("page") Page<PostPush> page, @Param("lng") Double lng, @Param("lat") Double lat, @Param("postPush") PostPush postPush, @Param("industry") String[] industry, @Param("education") String[] education, @Param("experience") String[] experience, @Param("companyPeople") String[] companyPeople, @Param("salaryRange") String[] salaryRange, @Param("screen") Integer screen, @Param("isDue") Integer isDue);
  22. IPage<PostDetails> selectPostList(Page<PostPush> page, Integer ruleClassifyId, String address, Long userId);
  23. List<LetterCity> getLetter();
  24. List<String> getCityList(@Param("letter") String letter, @Param("city") String city);
  25. List<String> getCountyByCity(@Param("city") String city);
  26. List<String> getHotCity(Integer limitCount);
  27. List<CityVo> getCityCounty();
  28. PostPush selectPostId(@Param("userId") Long userId, @Param("postPushId") Long postPushId, @Param("lng") Double lng, @Param("lat") Double lat);
  29. List<String> getCityCompanyId(@Param("companyId") Long companyId);
  30. List<PostPush> getCompanyClassify(@Param("companyId") Long companyId);
  31. IPage<PostPush> getAdminPostPushList(@Param("pages") Page<PostPush> pages, @Param("postPush") PostPush postPush, @Param("startTime") String startTime, @Param("endTime") String endTime);
  32. List<Object> getHotPost();
  33. List<PostPush> getPostPushListUser(Double lng, Double lat, PostPush postPush, String[] industry, String[] education, String[] experience, String[] companyPeople, String[] salaryRange);
  34. }