PublicReleaseMapper.java 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778
  1. package com.goafanti.common.dao;
  2. import com.goafanti.admin.bo.OutFinanceCount;
  3. import com.goafanti.common.model.OutPublicReleaseCount;
  4. import com.goafanti.common.model.PublicRelease;
  5. import com.goafanti.customer.bo.MyUserDetailsBo;
  6. import com.goafanti.weChat.bo.*;
  7. import org.apache.ibatis.annotations.Param;
  8. import java.util.Date;
  9. import java.util.List;
  10. public interface PublicReleaseMapper {
  11. int deleteByPrimaryKey(Integer id);
  12. int insert(PublicRelease record);
  13. int insertSelective(PublicRelease record);
  14. PublicRelease selectByPrimaryKey(Integer id);
  15. int updateByPrimaryKeySelective(PublicRelease record);
  16. int updateByPrimaryKey(PublicRelease record);
  17. OutPublicRelease selectDtails(@Param("id") Integer id);
  18. /**
  19. * 需要比对申请人其他公出时间,选择出重复的时间来判断是否生效。
  20. * 1 已有发起时间大于等于选择发起小于选择结束
  21. * 2 已有发起小于选择发起并且已有结束大于选择发起
  22. * 3 已有发起小于选择结束和已有结束大于选择结束
  23. * @param aid 申请人
  24. * @param start 开始时间
  25. * @param end 结束时间
  26. * @return
  27. */
  28. List<Integer> checkTime(@Param("aid")String aid, @Param("start") Date start, @Param("end")Date end);
  29. void updateSignByAidAndUid(@Param("uid") String buyerId, @Param("aid") String salesmanId);
  30. List<OutPublicReleaseCount > getTimeUserFollow(@Param("date")Date date, @Param("now")Date now);
  31. List<OutPublicRelease> publicByOrder(String orderNo);
  32. List<PublicRelease> selectByMainId(@Param("mainId") Integer mainId,@Param("type") Integer type,@Param("aid") String aid);
  33. void updateStatusByMainId(@Param("status") Integer status, @Param("type") Integer type,@Param("mainId") Integer mainId,@Param("aid") String aid);
  34. OutPublicReleaseAndDetails selectDtailsByFid(@Param("ufid")String ufid);
  35. Integer selectCountByaidAndDate(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime);
  36. List<OutFinanceCount> selectByaidAndDate(@Param("aid") String aid, @Param("startTime") String startTime, @Param("endTime") String endTime);
  37. List<PublicRelease> selectByOrderNo(String orderNo);
  38. List<PublicRelease> selectMyNewPublic(String adminId);
  39. OutPublicReleaseList selectOutListBoById(Integer id);
  40. List<PublicRelease> selectAll();
  41. List<releaseAndExpenseCountOut > releaseAndExpenseCount(InputreleaseAndExpenseCount in);
  42. PublicRelease selectSonIdByMain(Integer id);
  43. int selectCountByAssistUnaudited(String aid);
  44. int selectCountByUnaudited(String aid);
  45. int selectCountByOtherUnaudited(String aid);
  46. List<MyUserDetailsBo> selectByUid(String id);
  47. }