Examples of javax.persistence.criteria.CriteriaBuilder.trim()

Class javax.persistence.criteria.CriteriaBuilder

Examples of javax.persistence.criteria.CriteriaBuilder.trim()

javax.persistence.criteria.CriteriaBuilder.trim()
Create expression to trim blanks from both ends of a string. @param x expression for string to trim @return trim expression

    List<Predicate> filters = new LinkedList<>();
    // alc2
    filters.add(cb.equal(root.get("alc2"), HpEKConstants.EK_ALC2));
    // fltn
    if (HpUfisUtils.isNotEmptyStr(params.getFltn())) {
      filters.add(cb.equal(cb.trim(root.<String> get("fltn")),
          params.getFltn()));
    }
    // regn
    filters.add(cb.equal(cb.trim(root.<String> get("regn")),
        params.getRegn()));

View Full Code Here

    if (HpUfisUtils.isNotEmptyStr(params.getFltn())) {
      filters.add(cb.equal(cb.trim(root.<String> get("fltn")),
          params.getFltn()));
    }
    // regn
    filters.add(cb.equal(cb.trim(root.<String> get("regn")),
        params.getRegn()));
    // ftyp
    filters.add(cb.equal(root.get("ftyp"), HpEKConstants.EK_FTYP_OPERATION));


    // range

View Full Code Here

        filters.add(cb.between(root.<String> get("tifd"),
            ufisCalendarFrom.getCedaString(),
            ufisCalendarTo.getCedaString()));
        // atot (actual takeo-ff time)
        // filters.add(cb.equal(root.<String>get("atot"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
        // aobt (actual off-block time
        // filters.add(cb.equal(root.<String>get("aobt"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
      } else {
        if (ADID.A == adid) {

View Full Code Here

        // atot (actual takeo-ff time)
        // filters.add(cb.equal(root.<String>get("atot"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
        // aobt (actual off-block time
        // filters.add(cb.equal(root.<String>get("aobt"), " "));
        filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
      } else {
        if (ADID.A == adid) {
          // time range
          filters.add(cb.between(root.<String> get("tifa"),
              ufisCalendarFrom.getCedaString(),

View Full Code Here

          filters.add(cb.between(root.<String> get("tifa"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
          if (MSGTYPE.FUEL == egdsMsgType) {
            // aldt
            filters.add(cb.isNotNull(cb.trim(root
                .<String> get("aldt"))));
          }
        } else {
          // time range
          filters.add(cb.between(root.<String> get("tifd"),

View Full Code Here

          // time range
          filters.add(cb.between(root.<String> get("tifd"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
          if (MSGTYPE.FUEL == egdsMsgType) {
            filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
            filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
          }
        }
      }
    } else {

View Full Code Here

          filters.add(cb.between(root.<String> get("tifd"),
              ufisCalendarFrom.getCedaString(),
              ufisCalendarTo.getCedaString()));
          if (MSGTYPE.FUEL == egdsMsgType) {
            filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
            filters.add(cb.isNull(cb.trim(root.<String> get("aobt"))));
          }
        }
      }
    } else {
      // (adid = A And tifa between x and y) or (adid = D And tifd between

View Full Code Here

    List<Predicate> filters = new LinkedList<>();


    filters.add(cb.not(cb.in(root.get("ftyp")).value('X').value('N')
        .value('T')));
    LOG.debug("ftyp not in ('X','N','T')");
    filters.add(cb.isNull(cb.trim(root.<String> get("atot"))));
    LOG.debug("atot is null");


    if (adid != null && !"".equals(adid.trim())) {
      filters.add(cb.equal(root.get("adid"), adid.charAt(0)));
      LOG.debug("adid, {}", adid.charAt(0));

View Full Code Here

        LOG.debug("stod, {}", stodStoa);
      }
    }


    if (regn != null && !"".equals(regn.trim())) {
      filters.add(cb.equal(cb.trim(root.<String> get("regn")), regn));
      LOG.debug("regn, {}", regn);
    }
    if (flno != null && !"".equals(flno.trim())) {
      filters.add(cb.equal(cb.trim(root.<String> get("flno")), flno));
      LOG.debug("flno: {}", flno);

View Full Code Here

    if (regn != null && !"".equals(regn.trim())) {
      filters.add(cb.equal(cb.trim(root.<String> get("regn")), regn));
      LOG.debug("regn, {}", regn);
    }
    if (flno != null && !"".equals(flno.trim())) {
      filters.add(cb.equal(cb.trim(root.<String> get("flno")), flno));
      LOG.debug("flno: {}", flno);
    }


    if (stodStoa == null && adid == null && flno == null) {
      filters.add(cb.not(cb.in(root.get("adid")).value('A')));

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.