KuaishouRuleSettlementDataMapper.java 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. package com.ruixuan.isc.mapper;
  2. import com.alibaba.fastjson.JSONArray;
  3. import com.alibaba.fastjson.JSONObject;
  4. import com.ruixuan.isc.entity.KuaishouRuleSettlementData;
  5. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  7. /**
  8. * 【请填写功能名称】Mapper接口
  9. *
  10. * @author ruoyi
  11. * @date 2023-05-16
  12. */
  13. public interface KuaishouRuleSettlementDataMapper {
  14. /**
  15. * 查询【请填写功能名称】
  16. *
  17. * @param id 【请填写功能名称】主键
  18. * @return 【请填写功能名称】
  19. */
  20. public KuaishouRuleSettlementData selectKuaishouRuleSettlementDataById(Long id);
  21. /**
  22. * 查询【请填写功能名称】列表
  23. *
  24. * @param kuaishouRuleSettlementData 【请填写功能名称】
  25. * @return 【请填写功能名称】集合
  26. */
  27. public List<KuaishouRuleSettlementData> selectKuaishouRuleSettlementDataList(KuaishouRuleSettlementData kuaishouRuleSettlementData);
  28. /**
  29. * 新增【请填写功能名称】
  30. *
  31. * @param kuaishouRuleSettlementData 【请填写功能名称】
  32. * @return 结果
  33. */
  34. public int insertKuaishouRuleSettlementData(KuaishouRuleSettlementData kuaishouRuleSettlementData);
  35. /**
  36. * 修改【请填写功能名称】
  37. *
  38. * @param kuaishouRuleSettlementData 【请填写功能名称】
  39. * @return 结果
  40. */
  41. public int updateKuaishouRuleSettlementData(KuaishouRuleSettlementData kuaishouRuleSettlementData);
  42. /**
  43. * 删除【请填写功能名称】
  44. *
  45. * @param id 【请填写功能名称】主键
  46. * @return 结果
  47. */
  48. public int deleteKuaishouRuleSettlementDataById(Long id);
  49. /**
  50. * 批量删除【请填写功能名称】
  51. *
  52. * @param ids 需要删除的数据主键集合
  53. * @return 结果
  54. */
  55. public int deleteKuaishouRuleSettlementDataByIds(Long[] ids);
  56. List<JSONObject> data(@Param("statDate") Long statDate);
  57. List<JSONObject> getRuleList(@Param("ruleId") Long ruleId);
  58. JSONObject lastRule(@Param("relateId") Long relateId, @Param("promoterId") Long promoterId, @Param("ruleId") Long ruleId);
  59. JSONObject getTotalAmount(@Param("ruleId") Long ruleId, @Param("lastSortCount") Integer lastSortCount, @Param("currentSortCount") Integer currentSortCount);
  60. Integer selectIncentiveLog(@Param("relateId") Long relateId, @Param("promoterId") Long promoterId);
  61. void replaceIncentiveLog(@Param("relateId") Long relateId, @Param("promoterId") Long promoterId, @Param("ruleId") Long ruleId, @Param("incentivizedCount") Integer incentivizedCount, @Param("lastIncentivizedCount") Integer lastIncentivizedCount);
  62. JSONObject getTotalByCountAndRuleId(@Param("incentivizedCount") Integer incentivizedCount, @Param("ruleId") Long ruleId);
  63. Integer getMaxRuleCountByRuleId(@Param("ruleId") Long ruleId);
  64. void replaceDatas(@Param("adds") List<KuaishouRuleSettlementData> adds);
  65. List<JSONObject> getSettlementDate(@Param("statDate") Long statDate, @Param("promoterId") Long promoterId, @Param("promoterName") String promoterName);
  66. void updatePromoterStatus(@Param("statDate") Long statDate, @Param("promoterId") Long promoterId, @Param("status") Integer status);
  67. List<JSONObject> getPromoterSettlementDetail(@Param("date") Long date, @Param("promoterId") Long promoterId, @Param("settlementStatus") Integer settlementStatus, @Param("itemId") Long itemId);
  68. JSONObject getRuleJson(Long ruleId);
  69. JSONObject getData();
  70. Integer selectPromoterIncentiveLog(Long promoterId);
  71. void replacePromoterIncentiveLog(@Param("promoterId") Long promoterId, @Param("ruleId") Long ruleId, @Param("incentivizedCount") Integer incentivizedCount, @Param("lastIncentivizedCount") Integer lastIncentivizedCount);
  72. List<JSONObject> getSettlementDataV2(@Param("date") Long date, @Param("promoterId") Long promoterId, @Param("promoterName") String promoterName);
  73. }