CustomerConsultationStatisticsDataView.java 697 B

12345678910111213141516171819202122232425262728
  1. package com.cyksj.model.views;
  2. import com.ejlchina.searcher.bean.DbField;
  3. import com.ejlchina.searcher.bean.SearchBean;
  4. import lombok.Getter;
  5. import lombok.Setter;
  6. /**
  7. * 项目名: yhlxj2
  8. * 文件名: CustomerConsultationStatisticsDataView
  9. * 创建者: JavaZou
  10. * 创建时间:2025/2/7 15:17
  11. */
  12. @Getter
  13. @Setter
  14. @SearchBean(tables = "customer_consultation_record ccr left join goods_don g on g.id = ccr.goods_id",
  15. where = ":time:",
  16. groupBy = "ccr.type,ccr.category_name,g.title")
  17. public class CustomerConsultationStatisticsDataView {
  18. @DbField("ccr.type")
  19. private Integer type;
  20. @DbField("ccr.category_name")
  21. private String categoryName;
  22. @DbField("g.title")
  23. private String title;
  24. }