DailySalesReportMapper.java 4.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879
  1. package com.goafanti.common.dao;
  2. import java.util.Date;
  3. import java.util.List;
  4. import java.util.Map;
  5. import org.apache.ibatis.annotations.Param;
  6. import org.springframework.ui.ModelMap;
  7. import com.goafanti.common.model.DailySalesReport;
  8. import com.goafanti.report.bo.CountDepMarketingStatisticsBo;
  9. import com.goafanti.report.bo.CountMarketingStatisticsBo;
  10. import com.goafanti.report.bo.DepartmentSalesReportBO;
  11. import com.goafanti.report.bo.PersonalSalesReportBO;
  12. import com.goafanti.report.bo.SomeTimeMarketingBo;
  13. import com.goafanti.report.bo.marketingESBo;
  14. public interface DailySalesReportMapper {
  15. DailySalesReport selectByPrimaryKey(Long id);
  16. List<DailySalesReport> selectAdmins();
  17. List<DailySalesReport> selectDailySalesReports(@Param("startTime") Date startTime, @Param("endTime") Date endTime);
  18. int insertBatch(List<DailySalesReport> list);
  19. int deleteByDate(@Param("createTime") Date createTime);
  20. List<PersonalSalesReportBO> selectSalesPersonalReports(@Param("startTime") Date startTime,
  21. @Param("endTime") Date endTime, @Param("pageNo") Integer pageNo, @Param("pageSize") Integer pageSize,
  22. @Param("orderField") String orderField, @Param("order") String order,
  23. @Param("countField") String countField, @Param("amountField") String amountField,
  24. @Param("depName") String depName, @Param("name") String name, @Param("position") String position);
  25. List<PersonalSalesReportBO> selectPersonalByPage(@Param("pageNo") Integer pageNo,
  26. @Param("pageSize") Integer pageSize, @Param("depName") String depName, @Param("name") String name,
  27. @Param("position") String position);
  28. Long selectSalesPersonalReportsCount(@Param("startTime") Date startTime, @Param("endTime") Date endTime,
  29. @Param("depName") String depName, @Param("name") String name, @Param("position") String position);
  30. List<ModelMap> selectSalesPersonalExtraReports(@Param("startTime") Date startTime, @Param("endTime") Date endTime,
  31. @Param("ids") List<String> ids);
  32. ModelMap selectTotalReports(@Param("startTime") Date startTime, @Param("endTime") Date endTime,
  33. @Param("depName") String depName, @Param("name") String name, @Param("position") String position);
  34. List<DepartmentSalesReportBO> selectSalesDepartmentReports();
  35. List<ModelMap> selectSalesDepartmentExtraReports(@Param("startTime") Date startTime,
  36. @Param("endTime") Date endTime);
  37. List<marketingESBo> findmarketingStatisticsList(@Param("depId")String depId, @Param("dayStart")String dayStart, @Param("dayEnd")String dayEnd,
  38. @Param("weeklyStart")String weeklyStart, @Param("weeklyEnd")String weeklyEnd, @Param("monthStart")String monthStart, @Param("monthEnd")String monthEnd,
  39. @Param("yearStart")String yearStart, @Param("yearEnd")String yearEnd);
  40. List<marketingESBo> marketingDepStatisticsList(@Param("depId")String depId, @Param("dayStart")String dayStart, @Param("dayEnd")String dayEnd,
  41. @Param("weeklyStart")String weeklyStart, @Param("weeklyEnd")String weeklyEnd, @Param("monthStart")String monthStart, @Param("monthEnd")String monthEnd,
  42. @Param("yearStart")String yearStart, @Param("yearEnd")String yearEnd);
  43. CountMarketingStatisticsBo privateCustomersCount(@Param("depId")String depId, @Param("dayStart")String dayStart, @Param("dayEnd")String dayEnd,
  44. @Param("weeklyStart")String weeklyStart, @Param("weeklyEnd")String weeklyEnd, @Param("monthStart")String monthStart, @Param("monthEnd")String monthEnd,
  45. @Param("yearStart")String yearStart, @Param("yearEnd")String yearEnd);
  46. CountMarketingStatisticsBo privateCustomersDepCount(@Param("depId")String depId, @Param("dayStart")String dayStart, @Param("dayEnd")String dayEnd,
  47. @Param("weeklyStart")String weeklyStart, @Param("weeklyEnd")String weeklyEnd, @Param("monthStart")String monthStart, @Param("monthEnd")String monthEnd,
  48. @Param("yearStart")String yearStart, @Param("yearEnd")String yearEnd);
  49. List<SomeTimeMarketingBo> sometimeMarketingStatistics(@Param("depId")String depId, @Param("startTime")String startTime, @Param("endTime")String endTime);
  50. List<SomeTimeMarketingBo> sometimeMarketingDepStatistics(@Param("depId")String depId, @Param("startTime")String startTime, @Param("endTime")String endTime);
  51. SomeTimeMarketingBo countsometimeMarketingStatistics(@Param("depId")String depId, @Param("startTime")String startTime, @Param("endTime")String endTime);
  52. SomeTimeMarketingBo countsometimeMarketingDepStatistics(@Param("depId")String depId, @Param("startTime")String startTime, @Param("endTime")String endTime);
  53. }