Package com.ufis_as.ufisapp.server.oldflightdata.entities

Examples of com.ufis_as.ufisapp.server.oldflightdata.entities.EntDbAfttab


  // for LineDeNA
  @Override
  public EntDbAfttab findDepFlightByFlnoAndDateTime(String flightNumber,
      String scheduledFlightDatetime) {
    EntDbAfttab entDbAfttab = null;

    Query query = em
        .createNamedQuery("EntDbAfttab.findDepFlightByFlnoAndDateTime");
    query.setParameter("fltn", flightNumber);
    query.setParameter("stod", scheduledFlightDatetime);
View Full Code Here


  }

  @Override
  public EntDbAfttab findArrFlightByFlnoAndDateTime(String flightNumber,
      String scheduledFlightDatetime) {
    EntDbAfttab entDbAfttab = null;

    Query query = em
        .createNamedQuery("EntDbAfttab.findArrFlightByFlnoAndDateTime");
    query.setParameter("fltn", flightNumber);
    query.setParameter("stod", scheduledFlightDatetime);
View Full Code Here

    }
    if (flno != null && !"".equals(flno.trim())) {
      query.setParameter("flno", flno.trim());
    }

    EntDbAfttab flight = null;
    try {
      // EntDbAfttab tab = (EntDbAfttab) query.getSingleResult();
      List<EntDbAfttab> list = query.getResultList();
      if (list != null && list.size() > 0) {
        flight = list.get(0);
View Full Code Here

    query.setParameter("stod", flightDate);
    query.setParameter("adid", 'B');
    query.setParameter("org3", HpEKConstants.EK_HOPO);
    query.setParameter("des3", HpEKConstants.EK_HOPO);
    List<EntDbAfttab> resultList = null;
    EntDbAfttab result = null;
    try {
      resultList = query.getResultList();
      if (resultList.size() > 0)
        result = resultList.get(0);
    } catch (Exception ex) {
View Full Code Here

    query.setParameter("stod", flightDate);
    query.setParameter("adidA", 'A');
    query.setParameter("adidD", 'D');

    List<EntDbAfttab> resultList = null;
    EntDbAfttab result = null;
    try {
      resultList = query.getResultList();
      if (resultList.size() > 0)
        result = resultList.get(0);
    } catch (Exception ex) {
View Full Code Here

    if(HpUfisUtils.isNullOrEmptyStr(urno) || HpUfisUtils.isNullOrEmptyStr(ftyp)){
      LOG.debug("Data is missing for (URNO,FTYP) to perform flight connect summary for AFTTAB.");
      return null;
    }
   
    EntDbAfttab entAft = new EntDbAfttab();
    entAft.setUrno(new BigDecimal(urno));
    entAft.setFtyp(HpUfisUtils.isNullOrEmptyStr(ftyp) ? null : ftyp.charAt(0));
    return entAft;
  }
View Full Code Here

   
    List<EntDbFltConnectSummary> fltConnectSummaryList = dlFltConxSummaryBean.findExistingForAllFlights(bagSummary.getIdFlight(), bagSummary.getIdConxFlight());
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record doesn't exist / evaluate Bag connection status
    if(fltConnectSummaryList.isEmpty()) {
      EntDbAfttab entAft = dlAfttabBean.find(bagSummary.getIdFlight());
     
      List<FltConnectionDTO> list = new ArrayList<>();
      FltConnectionDTO dto = new FltConnectionDTO();
      dto.setIdFlight(bagSummary.getIdFlight());
      dto.setIdConxFlight(bagSummary.getIdConxFlight());
      dto.setBagPcs(bagSummary.getBagPcs().intValue());
      list.add(dto);
     
      fltConxProcessBean.process(HpUfisAppConstants.CON_LOAD_BAG_SUMMARY, entAft, list);
     
      return;
    }
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record exists.
    //If ‘Bag connection status’ is blank or ‘no connection’, do processing. Otherwise skip
    //Result is at most 2 - idFlight/arr and idConxFlight/dep OR idConxFlight/arr and idFlight/dep
    for (EntDbFltConnectSummary entDbFltConnectSummary : fltConnectSummaryList) {
      if(HpUfisUtils.isNullOrEmptyStr(entDbFltConnectSummary.getConxStatBag().trim()) || entDbFltConnectSummary.getConxStatBag().trim().equalsIgnoreCase("X")) {
        EntDbAfttab entAft = dlAfttabBean.find(entDbFltConnectSummary.getIdArrFlight());
 
        List<FltConnectionDTO> list = new ArrayList<>();
        FltConnectionDTO dto = new FltConnectionDTO();
        dto.setIdFlight(entDbFltConnectSummary.getIdArrFlight());
        dto.setIdConxFlight(entDbFltConnectSummary.getIdDepFlight());
View Full Code Here

      case HpUfisAppConstants.CON_LOAD_PAX_SUMMARY:
      case HpUfisAppConstants.CON_LOAD_ULD_SUMMARY:
        if (idList != null && idList.size() > 0) {
          for (Object obj : idList) {
            // according to instance type to set process flight
            EntDbAfttab aftRecord = null;
            // if instance of BigDecimal, then find it from afttab
            if (obj instanceof BigDecimal) {
              BigDecimal idFlight = (BigDecimal) obj;
              // SELECT a
              // FROM EntDbAfttab a
View Full Code Here

    BigDecimal idFlight = loadBag.getId_Flight();
    List<EntDbFltConnectSummary> fltConnectSummaryList = dlFltConxSummaryBean.findExistingForAllFlights(idFlight, loadBag.getIdConxFlight());
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record doesn't exist / evaluate Bag connection status
    if(fltConnectSummaryList.isEmpty()) {
      EntDbAfttab entAft = dlAfttabBean.find(idFlight);
     
      List<FltConnectionDTO> list = new ArrayList<>();
      FltConnectionDTO dto = new FltConnectionDTO();
      dto.setIdFlight(idFlight);
      dto.setIdConxFlight(loadBag.getIdConxFlight());
      dto.setBagPcs(1);
      list.add(dto);
     
      fltConxProcessBean.process(HpUfisAppConstants.CON_LOAD_BAG_SUMMARY, entAft, list);
     
      return;
    }
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record exists.
    //If ‘Bag connection status’ is blank or ‘no connection’, do processing. Otherwise skip
    //Result is at most 2 - idFlight/arr and idConxFlight/dep OR idConxFlight/arr and idFlight/dep
    for (EntDbFltConnectSummary entDbFltConnectSummary : fltConnectSummaryList) {
      if(HpUfisUtils.isNullOrEmptyStr(entDbFltConnectSummary.getConxStatBag().trim()) || entDbFltConnectSummary.getConxStatBag().trim().equalsIgnoreCase("X")) {
        EntDbAfttab entAft = dlAfttabBean.find(entDbFltConnectSummary.getIdArrFlight());
 
        List<FltConnectionDTO> list = new ArrayList<>();
        FltConnectionDTO dto = new FltConnectionDTO();
        dto.setIdFlight(entDbFltConnectSummary.getIdArrFlight());
        dto.setIdConxFlight(entDbFltConnectSummary.getIdDepFlight());
View Full Code Here

    BigDecimal idFlight = loadUld.getIdFlight();
    List<EntDbFltConnectSummary> fltConnectSummaryList = dlFltConxSummaryBean.findExistingForAllFlights(idFlight, loadUld.getIdConxFlight());
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record doesn't exist / evaluate ULD connection status
    if(fltConnectSummaryList.isEmpty()) {
      EntDbAfttab entAft = dlAfttabBean.find(loadUld.getIdFlight());
     
      List<FltConnectionDTO> list = new ArrayList<>();
      FltConnectionDTO dto = new FltConnectionDTO();
      dto.setIdFlight(idFlight);
      dto.setIdConxFlight(loadUld.getIdConxFlight());
      dto.setUldPcs(1);
      list.add(dto);
     
      fltConxProcessBean.process(HpUfisAppConstants.CON_LOAD_ULD_SUMMARY, entAft, list);
     
      return;
    }
   
    //Find FLT_CONNECT_SUMMARY with conxflights and record exists.
    //If ‘ULD connection status’ is blank or ‘no connection’, do processing. Otherwise skip
    //Result is at most 2 - idFlight/arr and idConxFlight/dep OR idConxFlight/arr and idFlight/dep
    for (EntDbFltConnectSummary entDbFltConnectSummary : fltConnectSummaryList) {
      if(HpUfisUtils.isNullOrEmptyStr(entDbFltConnectSummary.getConxStatUld().trim()) || entDbFltConnectSummary.getConxStatUld().trim().equalsIgnoreCase("X")) {
        EntDbAfttab entAft = dlAfttabBean.find(entDbFltConnectSummary.getIdArrFlight());
       
        List<FltConnectionDTO> list = new ArrayList<>();
        FltConnectionDTO dto = new FltConnectionDTO();
        dto.setIdFlight(entDbFltConnectSummary.getIdArrFlight());
        dto.setIdConxFlight(entDbFltConnectSummary.getIdDepFlight());
View Full Code Here

TOP

Related Classes of com.ufis_as.ufisapp.server.oldflightdata.entities.EntDbAfttab

Copyright © 2018 www.massapicom. All rights reserved.
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.