{
        Date dateFrom = Date.from(LocalDateTime.of(LocalDate.now(), LocalTime.MIDNIGHT).toInstant(ZoneOffset.UTC));
        Date dateTo = Date.from(LocalDateTime.now().toInstant(ZoneOffset.UTC));

        CriteriaQuery<BigInteger> queryVisa = cb.createQuery(BigInteger.class);
        Root<TransactionGroup> rootVisa = queryVisa.from(TransactionGroup.class);

        queryVisa.select(cb.sum(rootVisa.get(TransactionGroup_.tranAmount)));

        queryVisa.where(
                cb.and(
                        cb.equal(rootVisa.get(TransactionGroup_.merchantId), merchantId),
                        cb.equal(rootVisa.get(TransactionGroup_.cardBrand), CardBrand.VISA),
                        cb.equal(rootVisa.get(TransactionGroup_.tranType), p),
                        cb.between(rootVisa.get(TransactionGroup_.tranTime), dateFrom, dateTo)
                )
        );
        return queryVisa;
    }