Specification<AucEvent> spec = (root, query, cb) -> {
            List<Predicate> predicates = new ArrayList<Predicate>();
            //指定机构
            if (agencyId != null && !agencyId.isEmpty() && !"0".equals(agencyId)) {
                Predicate predicate = cb.equal(root.get("agencyId"), agencyId);
                predicates.add(predicate);
            }
            //模糊查询，活动标题
            if (eventTitle != null && !eventTitle.isEmpty()) {
                Predicate predicate = cb.like(root.get("title"), "%"+eventTitle+"%");
                predicates.add(predicate);
            }
            //指定状态，可能为多个状态，or
            if (eventStatus != null && eventStatus.length > 0) {
                List<Predicate> orPredicates = new ArrayList<Predicate>();
                for(String status:eventStatus) {
                    Predicate predicate = cb.equal(root.get("status"), status);
                    orPredicates.add(predicate);
                }
                if (!orPredicates.isEmpty()) {
                    Predicate predicate = cb.or(orPredicates.toArray(new Predicate[0]));
                    predicates.add(predicate);
                }
            }
            if (!predicates.isEmpty()) {
                return cb.and(predicates.toArray(new Predicate[0]));
            } else {
                return null;
            }
        };
        Page<AucEvent> pageresult = aucEventRepository.findAll(spec, pageable);

@Query(value = "SELECT  Max(a.first_type_name) as  acuType, "
            + "sum(CASE b.is_deal WHEN 1 THEN 1 ELSE 0 end) as dealNum, "
            + "SUM(CASE b.is_deal WHEN 1 THEN b.deal_price  ELSE 0 end) as  dealPrice, "
            + "sum(CASE b.is_deal WHEN 4 THEN 1 ELSE 0 end) as  regretDeal, "
            + "ROUND((sum(CASE b.is_deal WHEN 4 THEN 1 ELSE 0 end)/count(b.is_deal))*100,2) as regretDealPercent, "
            + "SUM(CASE b.is_deal WHEN 4 THEN s.bail_price ELSE 0 end) as distrainPrice , "
            + "SUM(CASE b.is_settled when 1 THEN b.deal_price ELSE 0 END) AS isSettedPrice, "
            + "SUM(CASE b.is_settled when 0 THEN b.deal_price ELSE 0 END) AS notSettedPrice  "
            + "FROM  auc_brand as b "
            + "LEFT JOIN   auc_lot as a  on a.id=b.auc_id "
            + "LEFT JOIN   settlement_bail as s  on  b.id=s.brand_id  "
            + "WHERE (DATE_FORMAT(a.crt_time,'%Y-%m-%d %H:%i:%S') "
            + "BETWEEN :startDate AND :endDate) AND  a.agency_id  in (:agencyIds) "
            + "GROUP BY  a.first_type_id ",nativeQuery=true)
    List<Object> findByAgencysAndGroupByTypeAucPriceCountReport(@Param("startDate") String startDate, @Param("endDate") String endDate, @Param("agencyIds") List<Long> agencyIds);