Examples of com.ufis_as.ek_if.rms.entities.EntDbFltJobTask

com.ufis_as.ek_if.rms.entities.EntDbFltJobTask
The persistent class for the FLT_JOB_TASK database table. @author btr

      msgLogged = Boolean.TRUE;
    }
      
      if (resourceAssignmentType != null){
        EntDbFltJobAssign edpiodEntDbFltJobAssign = new EntDbFltJobAssign();
        EntDbFltJobTask edpiodEntDbFltJobTask = new EntDbFltJobTask();
//        EntDbStaffShift edpiodEntDbStaffShift = new EntDbStaffShift();
        
//        SimpleDateFormat RTCdf = new SimpleDateFormat(HpEKConstants.EKRTC_TIME_FORMAT);
        // convert local time to UTC
//        RTCdf.setTimeZone(HpEKConstants.utcTz);
        
        // check meta
        if (resourceAssignmentType.getMeta() == null){
          LOG.info("Mandatory field Meta is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set message time
        if (resourceAssignmentType.getMeta().getMessageTime() != null){
          edpiodEntDbFltJobAssign.setMsgSendDate(convertXMLGregorianCalendarToDate(resourceAssignmentType.getMeta().getMessageTime()));
        }else {
          LOG.info("Mandatory field message time is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // check messageID
        if (resourceAssignmentType.getMeta().getMessageID() == 0){
          LOG.info("Mandatory field messageID time is 0, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // check message type
        if (resourceAssignmentType.getMeta().getMessageType() == null || "".equals(resourceAssignmentType.getMeta().getMessageType())){
          LOG.info("Mandatory field message type is null or empty string, ResourceShiftType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }else if (!Arrays.asList(messageAssignmentTypeArray).contains(resourceAssignmentType.getMeta().getMessageType())){
          LOG.info("Mandatory field message type {} is in possible value, ResourceShiftType message is rejected", resourceAssignmentType.getMeta().getMessageType());
          
          sendErroNotification(EnumExceptionCodes.EENUM);
          
          return false;
        }
        
        // check messageSubtype
        if (resourceAssignmentType.getMeta().getMessageSubtype() == null || "".equals(resourceAssignmentType.getMeta().getMessageSubtype().trim())){
          LOG.info("Mandatory field messageSubtype is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }else if (!Arrays.asList(messageAssignmentSubtypeArray).contains(resourceAssignmentType.getMeta().getMessageSubtype().toUpperCase().trim())){
          LOG.info("Mandatory field messageSubtype {} is in possible value, resourceAssignmentType message is rejected", resourceAssignmentType.getMeta().getMessageSubtype());
          
          sendErroNotification(EnumExceptionCodes.EENUM);
          
          return false;
        }else {
          resAssignMsgSubType = resourceAssignmentType.getMeta().getMessageSubtype();
        }
        
        // set messageSource
        if (resourceAssignmentType.getMeta().getMessageSource() != null && !"".equals(resourceAssignmentType.getMeta().getMessageSource().trim())){
          if (Arrays.asList(messageSourceArray).contains(resourceAssignmentType.getMeta().getMessageSource().toUpperCase().trim())){
            switch(resourceAssignmentType.getMeta().getMessageSource().toUpperCase().trim()){
              case "EKRTC":
                edpiodEntDbFltJobAssign.setStaffType("EK");
                edpiodEntDbFltJobTask.setStaffType("EK");
                break;
              case "GXRTC":
                edpiodEntDbFltJobAssign.setStaffType("GX");
                edpiodEntDbFltJobTask.setStaffType("GX");
                break;
              case "CSRTC":
                edpiodEntDbFltJobAssign.setStaffType("CS");
                edpiodEntDbFltJobTask.setStaffType("CS");
                break;
            }
          }else{
            LOG.info("Mandatory field messageSource {} is not in possible value, resourceAssignmentType message is rejected", resourceAssignmentType.getMeta().getMessageSource());
            
            sendErroNotification(EnumExceptionCodes.EENUM);
            
              return false;
          }
          
        }else {
          LOG.info("Mandatory field messageSource is null or empty string, ResourceShiftType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set TSK
        if (resourceAssignmentType.getTSK() == null ){
          LOG.info("Mandatory field messageSource is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set AID
        if (resourceAssignmentType.getTSK().getAID() != null && !"".equals(resourceAssignmentType.getTSK().getAID().trim())){
          edpiodEntDbFltJobTask.setTaskId(new BigDecimal(resourceAssignmentType.getTSK().getAID()));
        }else {
          LOG.info("Mandatory field AID is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set TRG (not mandatory for ORI = 0)
        if (resourceAssignmentType.getTSK().getTRG() != null && !"".equals(resourceAssignmentType.getTSK().getTRG().trim())){
          edpiodEntDbFltJobTask.setTaskRuleGrp(resourceAssignmentType.getTSK().getTRG());
        }else {
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
          LOG.info("Mandatory field TRG is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
          }
        }
        
        // set TRQ (not mandatory for ORI = 0)
        if (resourceAssignmentType.getTSK().getTRQ() != null && !"".equals(resourceAssignmentType.getTSK().getTRQ().trim())){
          if (entStartupInitSingleton.isMDTaskReqtListOn()){
          // to check with master data
            switch (edpiodEntDbFltJobTask.getStaffType()){
          case "EK":
            if (!entStartupInitSingleton.getEKASTaskReqtList().contains(resourceAssignmentType.getTSK().getTRQ().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRQ().trim() ,"EKAS");
            }
            break;
          case "GX":
            if (!entStartupInitSingleton.getGXTaskReqtList().contains(resourceAssignmentType.getTSK().getTRQ().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRQ().trim() ,"GX");
            }
            break;
          case "CS":
            if (!entStartupInitSingleton.getCSTaskReqtList().contains(resourceAssignmentType.getTSK().getTRQ().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRQ().trim() ,"CS");
            }
            break;
            }
            
            sendErroNotification(EnumExceptionCodes.WNOMD);
            
        }  
          edpiodEntDbFltJobTask.setTaskRequirementId(resourceAssignmentType.getTSK().getTRQ());
        }else {
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
          LOG.info("Mandatory field TRQ is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
          }
        }
        
        // set TRD
        if (resourceAssignmentType.getTSK().getTRD() != null && !"".equals(resourceAssignmentType.getTSK().getTRD().trim())){
          if (entStartupInitSingleton.isMDTaskReqtListOn()){
          // to check with master data
            switch (edpiodEntDbFltJobTask.getStaffType()){
          case "EK":
            if (!entStartupInitSingleton.getEKASTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"EKAS");
            }
            break;
          case "GX":
            if (!entStartupInitSingleton.getGXTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"GX");
            }
            break;
          case "CS":
            if (!entStartupInitSingleton.getCSTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"CS");
            }
            break;
              }
            
            sendErroNotification(EnumExceptionCodes.WNOMD);
            
          }  
          edpiodEntDbFltJobTask.setTaskDeptId(resourceAssignmentType.getTSK().getTRD());
        }
        
        // set DEP
        if (resourceAssignmentType.getTSK().getDEP() != null && !"".equals(resourceAssignmentType.getTSK().getDEP().trim())){
          if (entStartupInitSingleton.isMDDeptListOn()){
          // to check master data
          switch (edpiodEntDbFltJobTask.getStaffType()){
          case "EK":
            if (!entStartupInitSingleton.getEKASDeptList().contains(resourceAssignmentType.getTSK().getDEP().trim())){
              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getDEP().trim() ,"EKAS");
            }
            break;
          case "GX":
            if (!entStartupInitSingleton.getGXDeptList().contains(resourceAssignmentType.getTSK().getDEP().trim())){
              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getDEP().trim() ,"GX");
            }
            break;
          case "CS":
            if (!entStartupInitSingleton.getCSDeptList().contains(resourceAssignmentType.getTSK().getDEP().trim())){
              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getDEP().trim() ,"CS");
            }
            break;            
            }  
          
          sendErroNotification(EnumExceptionCodes.WNOMD);
          
          }
          edpiodEntDbFltJobTask.setTaskDeptId(resourceAssignmentType.getTSK().getDEP());
        }else {
          LOG.info("Mandatory field DEP is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set TYP
        if (resourceAssignmentType.getTSK().getTYP() != null && !"".equals(resourceAssignmentType.getTSK().getTYP().trim())){
//          // to check master data
//          switch (edpiodEntDbFltJobTask.getStaffType()){
//          case "EK":
//            if (!entStartupInitSingleton.getEKASTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"EKAS");
//            }
//            break;
//          case "GX":
//            if (!entStartupInitSingleton.getGXTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"GX");
//            }
//            break;
//          case "CS":
//            if (!entStartupInitSingleton.getCSTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"CS");
//            }
//            break;            
//          }  
          edpiodEntDbFltJobTask.setTaskType(resourceAssignmentType.getTSK().getTYP());
        }else {
          LOG.info("Mandatory field TYP is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
//        // added according icd 2.0 and Mei's design, when ORI = 0 not related to flight
//        if ("0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
//          LOG.info("ORI = 0, resourceAssignmentType message is rejected");
//          return false;
//        }
        
        // set ORI
        if (resourceAssignmentType.getTSK().getORI() != null && !"".equals(resourceAssignmentType.getTSK().getORI().trim())){
          if (entStartupInitSingleton.isMDTaskGrptypeListOn()){
          // to check master data
          switch (edpiodEntDbFltJobTask.getStaffType()){
          case "EK":
            if (!entStartupInitSingleton.getEKASTaskGrptypeList().contains(resourceAssignmentType.getTSK().getORI().trim())){
              LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getORI().trim() ,"EKAS");
            }
            break;
          case "GX":
            if (!entStartupInitSingleton.getGXTaskGrptypeList().contains(resourceAssignmentType.getTSK().getORI().trim())){
              LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getORI().trim() ,"GX");
            }
            break;
          case "CS":
            if (!entStartupInitSingleton.getCSTaskGrptypeList().contains(resourceAssignmentType.getTSK().getORI().trim())){
              LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getORI().trim() ,"CS");
            }
            break;            
          }  
          
          sendErroNotification(EnumExceptionCodes.WNOMD);
          
          }
          
          edpiodEntDbFltJobTask.setTaskGrpType(resourceAssignmentType.getTSK().getORI());
        }else {
          LOG.info("Mandatory field ORI is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set SNO
        if (resourceAssignmentType.getTSK().getSNO() != 0){
          edpiodEntDbFltJobTask.setTaskNum(new BigDecimal(resourceAssignmentType.getTSK().getSNO()));
        }else {
          LOG.info("Mandatory field SNO is 0, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set MNO
        if (resourceAssignmentType.getTSK().getMNO() != 0){
          edpiodEntDbFltJobTask.setMainTaskNum(new BigDecimal(resourceAssignmentType.getTSK().getMNO()));
        }else {
          LOG.info("Mandatory field MNO is 0, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set RMK
        if (resourceAssignmentType.getTSK().getRMK() != null && !"".equals(resourceAssignmentType.getTSK().getRMK().trim())){
          edpiodEntDbFltJobTask.setTaskRemark(resourceAssignmentType.getTSK().getRMK());
        }
        
        // set STI
        if (resourceAssignmentType.getTSK().getSTI() != null && !"".equals(resourceAssignmentType.getTSK().getSTI())){
          try {
            edpiodEntDbFltJobTask.setTaskActualStartDate(convertStringToDate(resourceAssignmentType.getTSK().getSTI()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date STI, {}", e);
//          LOG.info("Mandatory field STI can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set ETI
        if (resourceAssignmentType.getTSK().getETI() != null){
          try {
            edpiodEntDbFltJobTask.setTaskActualEndDate(convertStringToDate(resourceAssignmentType.getTSK().getETI()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date ETI, {}", e);
//          LOG.info("Mandatory field ETI can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set DUR
        if (resourceAssignmentType.getTSK().getDUR() != null && resourceAssignmentType.getTSK().getDUR() != 0){
          edpiodEntDbFltJobTask.setTaskActualDuration(new BigDecimal(resourceAssignmentType.getTSK().getDUR()));
        }
        
        // set EST
        if (resourceAssignmentType.getTSK().getEST() != null && !"".equals(resourceAssignmentType.getTSK().getEST() )){
          try {
            edpiodEntDbFltJobTask.setTaskPlanStartDate(convertStringToDate(resourceAssignmentType.getTSK().getEST()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date DUR, {}", e);
//          LOG.info("Mandatory field EST can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }else {
          LOG.info("Mandatory field EST is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set LET
        if (resourceAssignmentType.getTSK().getLET() != null && !"".equals(resourceAssignmentType.getTSK().getLET().trim())){
          try {
            edpiodEntDbFltJobTask.setTaskPlanEndDate(convertStringToDate(resourceAssignmentType.getTSK().getLET()));
            // task_plan_duration = task_plan_end_date - task_plan_start_date
            int days = Days.daysBetween(new DateTime(edpiodEntDbFltJobTask.getTaskPlanStartDate()), new DateTime(edpiodEntDbFltJobTask.getTaskPlanEndDate())).getDays();
            int seconds = days * 24 * 60 * 60;
            edpiodEntDbFltJobTask.setTaskPlanDuration(new BigDecimal(seconds));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date LET, {}", e);
//          LOG.info("Mandatory field LET can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }else {
          LOG.info("Mandatory field LET is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set SLO
        if (resourceAssignmentType.getTSK().getSLO() != null && !"".equals(resourceAssignmentType.getTSK().getSLO().trim())){
          edpiodEntDbFltJobTask.setTaskStartLoc(resourceAssignmentType.getTSK().getSLO());
        }else {
          LOG.info("Mandatory field SLO is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set ELO
        if (resourceAssignmentType.getTSK().getELO() != null && !"".equals(resourceAssignmentType.getTSK().getELO().trim())){
          edpiodEntDbFltJobTask.setTaskEndLoc(resourceAssignmentType.getTSK().getELO());
        }else {
          LOG.info("Mandatory field ELO is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set HST
        if (resourceAssignmentType.getTSK().getHST() != null && !"".equals(resourceAssignmentType.getTSK().getHST().trim())){
          edpiodEntDbFltJobTask.setTaskHandlingState(resourceAssignmentType.getTSK().getHST());
        }else {
          LOG.info("Mandatory field HST is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set MWA (not available for DEP =CB)
        if (!"CB".equalsIgnoreCase(resourceAssignmentType.getTSK().getDEP())){
        
        if (resourceAssignmentType.getTSK().getMWA() != null && !"".equals(resourceAssignmentType.getTSK().getMWA().trim())){
          if (entStartupInitSingleton.isMDWorkAreasListOn()){
          // to check with master data
            switch (edpiodEntDbFltJobTask.getStaffType()){
          case "EK":
            if (!entStartupInitSingleton.getEKASWorkAreasList().contains(resourceAssignmentType.getTSK().getMWA().trim())){
              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getMWA().trim() ,"EKAS");
            }
            break;
          case "GX":
            if (!entStartupInitSingleton.getGXWorkAreasList().contains(resourceAssignmentType.getTSK().getMWA().trim())){
              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getMWA().trim() ,"GX");
            }
            break;
          case "CS":
            if (!entStartupInitSingleton.getCSWorkAreasList().contains(resourceAssignmentType.getTSK().getMWA().trim())){
              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getMWA().trim() ,"CS");
            }
            break;
          }
            
            sendErroNotification(EnumExceptionCodes.WNOMD);
            
          }
          edpiodEntDbFltJobTask.setTaskWorkArea(resourceAssignmentType.getTSK().getMWA());
        }
//        else {
//          LOG.info("Mandatory field MWA is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        }
        
        // set SWA
        if (resourceAssignmentType.getTSK().getSWA() != null && !"".equals(resourceAssignmentType.getTSK().getSWA().trim())){
          edpiodEntDbFltJobTask.setTaskSubworkArea(resourceAssignmentType.getTSK().getSWA());
        }
        
        // set WLD
        if (resourceAssignmentType.getTSK().getWLD() != null && resourceAssignmentType.getTSK().getWLD() != 0){
          edpiodEntDbFltJobTask.setTaskWorkloadFactor(new BigDecimal(resourceAssignmentType.getTSK().getWLD()));
        }
        
        // set PRI
        if (resourceAssignmentType.getTSK().getPRI() != 0){
          edpiodEntDbFltJobTask.setTaskPriority(new BigDecimal(resourceAssignmentType.getTSK().getPRI()));
        }
        
        // Attention ! make use of this info to search flight in AFTTAB (AFTTAB.ACT3 or ACT5)
        //  AFT
//        if (resourceAssignmentType.getTSK().getAFT() != null && !"".equals(resourceAssignmentType.getTSK().getAFT().trim())){
//        }
        
           // set STS
        if (resourceAssignmentType.getTSK().getSTS() != null && !"".equals(resourceAssignmentType.getTSK().getSTS().trim())){
//            // to check with master data
//            switch (edpiodEntDbFltJobTask.getStaffType()){
//          case "EK":
//            if (!entStartupInitSingleton.getEKASTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"EKAS");
//            }
//            break;
//          case "GX":
//            if (!entStartupInitSingleton.getGXTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"GX");
//            }
//            break;
//          case "CS":
//            if (!entStartupInitSingleton.getCSTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"CS");
//            }
//            break;
//          }  
          edpiodEntDbFltJobTask.setTaskStatus(resourceAssignmentType.getTSK().getSTS());
        }else {
          LOG.info("Mandatory field STS is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set STT
        if (resourceAssignmentType.getTSK().getSTT() != null && !"".equals(resourceAssignmentType.getTSK().getSTT().trim())){
          if (entStartupInitSingleton.isMDTaskGrptypeListOn()){
        // to check with master data
        switch (edpiodEntDbFltJobTask.getStaffType()){
      case "EK":
        if (!entStartupInitSingleton.getEKASTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"EKAS");
        }
        break;
      case "GX":
        if (!entStartupInitSingleton.getGXTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"GX");
        }
        break;
      case "CS":
        if (!entStartupInitSingleton.getCSTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"CS");
        }
        break;
          }  
        
        sendErroNotification(EnumExceptionCodes.WNOMD);
        
        }
          edpiodEntDbFltJobTask.setSubtaskStatus(resourceAssignmentType.getTSK().getSTT());
        }else {
          LOG.info("Mandatory field STT is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // Attention ! Use this info to form the full flight number (AFTTAB.FLNO)
        // set DNO
//        if (resourceAssignmentType.getTSK().getDNO() != null && !"".equals(resourceAssignmentType.getTSK().getDNO().trim())){
//          // TO CONTINUE>>>>>>
//        }
        
        // Make use of this info to search flight in AFTTAB Convert to UTC prior to search (AFTTAB.STOD)
        // set DFD
//        if (resourceAssignmentType.getTSK().getDFD() != null){
//          // TO CONTINUE>>>>>>
//        }
        
        // Make use of this info to search flight in AFTTAB (AFTTAB.ORG3)
        // set REG
//        if (resourceAssignmentType.getTSK().getREG() != null && !"".equals(resourceAssignmentType.getTSK().getREG().trim())){
//          // TO CONTINUE>>>>>>
//        }


        
        // Make use of this info to search flight in AFTTAB (AFTTAB.ORG3)
           // check DSN (not mandatory for ORI = 0)
        if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
        
        if (resourceAssignmentType.getTSK().getDSN() == null || "".equals(resourceAssignmentType.getTSK().getDSN().trim())){
          LOG.info("Mandatory field DSN is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        }
        
        // Use this info to form the full flight number (AFTTAB.FLNO)
           // check ASN (not mandatory for ORI = 0)
        if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
        
        if (resourceAssignmentType.getTSK().getASN() == null || "".equals(resourceAssignmentType.getTSK().getASN().trim())){
          LOG.info("Mandatory field ASN is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        }
        
        // set SID (chnage to conditional according to version 2)
        if (resourceAssignmentType.getTSK().getSID() != null && !"".equals(resourceAssignmentType.getTSK().getSID().trim())){
          edpiodEntDbFltJobAssign.setShiftId( new BigDecimal(resourceAssignmentType.getTSK().getSID()));
        }
//        else {
//          LOG.info("Mandatory field SID is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        
           // set PRF
        if (resourceAssignmentType.getTSK().getPRF() != null && !"".equals(resourceAssignmentType.getTSK().getPRF().trim())){
          entDbFltJobAssign.setPaxRefNum(resourceAssignmentType.getTSK().getPRF());
        }
        
           // set SLT
        if (resourceAssignmentType.getTSK().getSLT() != null && !"".equals(resourceAssignmentType.getTSK().getSLT().trim())){
          edpiodEntDbFltJobTask.setTaskStartLocType(resourceAssignmentType.getTSK().getSLT());
        }
        
//        // Make use of this info to search flight in AFTTAB (AFTTAB.STOA)
//        // set STA (not mandatory for ORI = 0)
//        if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
//        if (resourceAssignmentType.getTSK().getSTA() != null){
//          // TO CONTINUE>>>>>>
//
//          try {
//            edpiodEntDbFltJobTask.setconvertStringToDate(resourceAssignmentType.getTSK().getDFD()));
//        } catch (ParseException e) {
//          LOG.error("erro when parse String to Date, {}", e);
//          LOG.info("Mandatory field DFD can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
//        }
//        }
//        
//        }
        
        // set AST
        if (resourceAssignmentType.getTSK().getAST() != null && !"".equals(resourceAssignmentType.getTSK().getAST().trim())){
          try {
            edpiodEntDbFltJobTask.setTaskAssignStartDate(convertStringToDate(resourceAssignmentType.getTSK().getAST()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date AST, {}", e);
//          LOG.info("Mandatory field AST can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set AET
        if (resourceAssignmentType.getTSK().getAET() != null && !"".equals(resourceAssignmentType.getTSK().getAET())){
          try {
            edpiodEntDbFltJobTask.setTaskAssignEndDate(convertStringToDate(resourceAssignmentType.getTSK().getAET()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date AET, {}", e);
//          LOG.info("Mandatory field AET can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // Use this info to form the full flight number (AFTTAB.ALC2 or ALC3)
        // AAL (not mandatory for ORI = 0)
        if (resourceAssignmentType.getTSK().getAAL() == null || "".equals(resourceAssignmentType.getTSK().getAAL().trim())){
//          edpiodEntDbFltJobTask.setTaskStatus(resourceAssignmentType.getTSK().getAAL());
          // TO CONTINUE>>>>
              if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
              LOG.info("Mandatory field TRQ is null or empty string, resourceAssignmentType message is rejected");
              
              sendErroNotification(EnumExceptionCodes.EMAND);
              
              return false;
              }
        }
        
        
          // DPN
        if (resourceAssignmentType.getTSK().getDPN() != null && !"".equals(resourceAssignmentType.getTSK().getDPN().trim())){
          edpiodEntDbFltJobTask.setTaskDeptName(resourceAssignmentType.getTSK().getDPN());
        }
        
        // to search flight and set id_flight  
        String org3 = resourceAssignmentType.getTSK().getDSN();
          String des3 = resourceAssignmentType.getTSK().getASN();

View Full Code Here

  
           
           if (existStaffShift != null){
             
             EntDbStaffShift oldEntDbStaffShift = (EntDbStaffShift)SerializationUtils.clone(existStaffShift);
             EntDbFltJobTask oldEntDbFltJobTask = (EntDbFltJobTask)SerializationUtils.clone(entDbFltJobTask);
             
             // staffShift set idFlight and updated
             existStaffShift.setIdFlight(entDbFltJobTask.getIdFlight());
             existStaffShift.setIdFltJobTask(entDbFltJobTask.getId());
             existStaffShift.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
//             dlEKRTCStaffShiftBean.Update(existStaffShift);
             
             // update fltJboAssign
             entDbFltJobAssign.setIdStaffShift(existStaffShift.getId());
             entDbFltJobAssign.setStaffFirstName(existStaffShift.getStaffFirstName());
             entDbFltJobAssign.setStaffName(existStaffShift.getStaffName());
             entDbFltJobAssign.setStaffNumber(existStaffShift.getStaffNumber());
             entDbFltJobAssign.setStaffType(existStaffShift.getStaffType());       
//             dlEKRTCFltJobAssignBean.Update(entDbFltJobAssign);      
             
            // send notification 
            ufisTopicProducer.sendNotification(true, UfisASCommands.URT,
                String.valueOf(entDbFltJobTask.getIdFlight()), oldEntDbFltJobTask, entDbFltJobTask);
            
            ufisTopicProducer.sendNotification(true, UfisASCommands.URT,
                String.valueOf(existStaffShift.getIdFlight()), oldEntDbStaffShift, existStaffShift);
           }
           
           
         }else if ("UPD".equalsIgnoreCase(blHandleEKRTC.getResAssignMsgSubType())){
           
      
           // search record in FltJobTask table
           EntDbFltJobTask existJobTask;
        startTime = System.currentTimeMillis();
        existJobTask = dlEKRTCFltJobTaskBean
            .getExsitRecordX(entDbFltJobTask.getTaskId());
        LOG.info("search records in jobTask table, takes {} ms", System.currentTimeMillis()
            - startTime);


//           // search record in FltJobTask table
//           EntDbFltJobTask existJobTask = dlEKRTCFltJobTaskBean.getExsitRecord(entDbFltJobTask);
//           // search exist record of fltJobTask
//           EntDbFltJobAssign existJobAssign = dlEKRTCFltJobAssignBean.getExsitRecord(existJobTask.getId(), entDbFltJobAssign.getShiftId());
           
           if (existJobTask != null){
             // search exist record of FltJobAssign and StaffShift by idFltJobTask            startTime = System.currentTimeMillis();
             // search record in staffShift table
             
             EntDbFltJobTask oldEntDbFltJobTask = (EntDbFltJobTask)SerializationUtils.clone(existJobTask);
             
             boolean isContainShiftId = false;
             


             List<EntDbStaffShift> existStaffShiftList;
          startTime = System.currentTimeMillis();
          existStaffShiftList = dlEKRTCStaffShiftBean
              .getExsitRecordByidFltJboTaskX(existJobTask.getId());
          LOG.info("search records in staffShift table, takes {} ms", System.currentTimeMillis()
              - startTime);


//               EntDbFltJobTask existJobTask = dlEKRTCFltJobTaskBean.getExsitRecordByJobAssignShiftId(entDbStaffShift.getShiftId());
               List<EntDbFltJobAssign> existJobAssignList;
            startTime = System.currentTimeMillis();
            existJobAssignList = dlEKRTCFltJobAssignBean
                .getExsitRecordX(existJobTask.getId());
            LOG.info("search records in jobAssign table, takes {} ms",
                System.currentTimeMillis() - startTime);


            
              EntDbStaffShift MatchStaffShift = null;
              
            if (existStaffShiftList != null){
            Iterator<EntDbStaffShift> existStaffShiftListIt = existStaffShiftList.iterator();
            while (existStaffShiftListIt.hasNext()){
              EntDbStaffShift StaffShift = existStaffShiftListIt.next();
              if (StaffShift.getShiftId().equals(entDbFltJobAssign.getShiftId())){
                isContainShiftId = true;
                MatchStaffShift = StaffShift;
                break;
              }
            }
            }
            
             if (isContainShiftId){
    
              startTime = System.currentTimeMillis();
              // update jobTask
              Class<EntDbFltJobTask> EntDbFltJobTask = EntDbFltJobTask.class;
              Field[] EntDbFltJobTaskClassFields = EntDbFltJobTask
                  .getDeclaredFields();
              for (Field f : EntDbFltJobTaskClassFields) {
                if (!"id".equalsIgnoreCase(f.getName())
                    && !"serialVersionUID"
                        .equalsIgnoreCase(f.getName())) {
                  setEntityValue(
                      existJobTask,
                      f.getName(),
                      getEntityValue(entDbFltJobTask,
                          f.getName()));
                }
              }
              existJobTask.setRecStatus(" ");
              existJobTask.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
              existJobTask.setUpdatedDate(HpUfisCalendar
                  .getCurrentUTCTime());
              LOG.info("update fltJobTask table, takes {} ms",
                  System.currentTimeMillis() - startTime);
              
              // send notification 
              ufisTopicProducer.sendNotification(true, UfisASCommands.URT,
                  String.valueOf(existJobTask.getIdFlight()), oldEntDbFltJobTask, existJobTask);
              
            EntDbFltJobAssign matchFltJobAssign = null;
               Iterator<EntDbFltJobAssign> existJobAssignListIt = existJobAssignList.iterator();
               while (existJobAssignListIt.hasNext()){
                 EntDbFltJobAssign FltJobAssign = existJobAssignListIt.next();
                 if (FltJobAssign.getShiftId().equals(entDbFltJobAssign.getShiftId())){
                   matchFltJobAssign = FltJobAssign;
                   break;
                 }
               }
               
               if (matchFltJobAssign != null){
           
               startTime = System.currentTimeMillis();
              // update jobAssign
              Class<EntDbFltJobAssign> EntDbFltJobAssign = EntDbFltJobAssign.class;
              Field[] EntDbFltJobAssignClassFields = EntDbFltJobAssign
                  .getDeclaredFields();
              for (Field f : EntDbFltJobAssignClassFields) {
                if (!"id".equalsIgnoreCase(f.getName())
                    && !"serialVersionUID"
                        .equalsIgnoreCase(f.getName())) {
                  setEntityValue(
                      matchFltJobAssign,
                      f.getName(),
                      getEntityValue(entDbFltJobAssign,
                          f.getName()));
                }
              }
              matchFltJobAssign.setRecStatus(" ");
              matchFltJobAssign.setUpdatedDate(HpUfisCalendar
                  .getCurrentUTCTime());
              LOG.info("update fltJobAssign table, takes {} ms",
                  System.currentTimeMillis() - startTime);


//                 dlEKRTCFltJobAssignBean.Update(existJobAssign);
                 }else {
                   LOG.info("existJobAssign is null, jobAssign table will not be updated");
                 }
            
                   if (MatchStaffShift != null){
                    startTime = System.currentTimeMillis();
                     
                   startTime = System.currentTimeMillis();
                // update staffShift
                MatchStaffShift.setIdFlight(existJobTask
                    .getIdFlight());
                MatchStaffShift.setIdFltJobTask(existJobTask
                    .getId());
                LOG.info("update staffShift table, takes {} ms",
                    System.currentTimeMillis() - startTime);
  
                   }
            
             }else{
              startTime = System.currentTimeMillis();
               
               // mark fltJobTask as 'X'
               existJobTask.setRecStatus("X");
               existJobTask.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
               existJobTask.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
               
               Iterator<EntDbStaffShift> existStaffShifListIt = existStaffShiftList.iterator();
               while(existStaffShifListIt.hasNext()){
                 EntDbStaffShift entDbStaffShiftX = existStaffShifListIt.next();
                 // mark existing staffShift  as 'X', delete
                 entDbStaffShiftX.setRecStatus("X");
                 entDbStaffShiftX.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
                 entDbStaffShiftX.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
               }
               
               Iterator<EntDbFltJobAssign> existEntDbFltJobAssignListIt = existJobAssignList.iterator();
               while (existEntDbFltJobAssignListIt.hasNext()){
                 EntDbFltJobAssign entDbFltJobAssignX  = existEntDbFltJobAssignListIt.next();
                 // mark existing fltJobTask  as 'X', delete
                 entDbFltJobAssignX.setRecStatus("X");
                 entDbFltJobAssignX.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
                 entDbFltJobAssignX.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());


               }


              LOG.info("update related staffShift fltJobAssign fltJobTask records to 'X', takes {} ms ", (System.currentTimeMillis() - startTime)); 


              startTime = System.currentTimeMillis();
              // insert new record to fltJobTask and fltJobAssign table
              entDbFltJobTask.setIdFlight(urno);
              dlEKRTCFltJobTaskBean.Persist(entDbFltJobTask);
              entDbFltJobAssign.setIdFlight(urno);
              entDbFltJobAssign.setIdFltJobTask(entDbFltJobTask
                  .getId());
              dlEKRTCFltJobAssignBean.Persist(entDbFltJobAssign);
              LOG.info("insert new record to fltJobTask and fltJobAssign table, takes {} ms",
                  System.currentTimeMillis() - startTime);
    
             }


          
           }
//           else {
//             LOG.info("exist record for JobTask not found, resourceAssignmentType 'UPD' message will be insert as new record");
//             // insert into fltJobTask table
//             entDbFltJobTask.setIdFlight(urno);
//             dlEKRTCFltJobTaskBean.Persist(entDbFltJobTask);
//             // insert into fltJobAssign table
//             entDbFltJobAssign.setIdFlight(urno);
//             entDbFltJobAssign.setIdFltJobTask(entDbFltJobTask.getId());
//             dlEKRTCFltJobAssignBean.Persist(entDbFltJobAssign);
//             
//             startTime = System.currentTimeMillis();
//             // search record in staffShift table
//             EntDbStaffShift existStaffShift = dlEKRTCStaffShiftBean.getExsitRecordByShiftIdX(entDbFltJobAssign.getShiftId());
//             endTime = System.currentTimeMillis();
//            LOG.info("takes {} ms to search records in staffShift table ", (endTime - startTime));
//             
//             if (existStaffShift != null){
//               // staffShift set idFlight and updated
//               existStaffShift.setIdFlight(entDbFltJobTask.getIdFlight());
//               existStaffShift.setIdFltJobTask(entDbFltJobTask.getId());
//               existStaffShift.setUpdatedDate(new Date());
////               dlEKRTCStaffShiftBean.Update(existStaffShift);
//               
//               // update fltJboAssign
//               entDbFltJobAssign.setIdStaffShift(existStaffShift.getId());
//               entDbFltJobAssign.setStaffFirstName(existStaffShift.getStaffFirstName());
//               entDbFltJobAssign.setStaffName(existStaffShift.getStaffName());
//               entDbFltJobAssign.setStaffNumber(existStaffShift.getStaffNumber());
//               entDbFltJobAssign.setStaffType(existStaffShift.getStaffType());       
////               dlEKRTCFltJobAssignBean.Update(entDbFltJobAssign);      
//             }
//           }
         
           
         }else if ("DEL".equalsIgnoreCase(blHandleEKRTC.getResAssignMsgSubType())){


           // search record in FltJobTask table
           EntDbFltJobTask existJobTask;
         startTime = System.currentTimeMillis();
        existJobTask = dlEKRTCFltJobTaskBean
            .getExsitRecordX(entDbFltJobTask.getTaskId());
        LOG.info("search records in jobTask table, takes {} ms", System.currentTimeMillis()
            - startTime);
           
           if (existJobTask != null){
             
             startTime = System.currentTimeMillis();
             // mark task record as deleted, "X"
            // update jobTask
             Class<EntDbFltJobTask> entDbFltJobTaskClass = EntDbFltJobTask.class;
             Field[] entDbFltJobTaskClassFields = entDbFltJobTaskClass.getDeclaredFields();
             for(Field f : entDbFltJobTaskClassFields){
               if (!"id".equalsIgnoreCase(f.getName()) && !"serialVersionUID".equalsIgnoreCase(f.getName())){
                 setEntityValue(existJobTask, f.getName(), getEntityValue(entDbFltJobTask, f.getName()));
               }
             }   
             
             existJobTask.setRecStatus("X");
//             dlEKRTCFltJobTaskBean.Update(existJobTask);
             existJobTask.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
             existJobTask.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
             
             // search exist record of jobAssign
             List<EntDbFltJobAssign> existJobAssignList = dlEKRTCFltJobAssignBean.getExsitRecordX(existJobTask.getId());
             Iterator<EntDbFltJobAssign>  existJobAssignListIt = existJobAssignList.iterator();
             while (existJobAssignListIt.hasNext()){
               EntDbFltJobAssign existFltJobAssign = existJobAssignListIt.next();
               
              // update jobTask
               Class<EntDbFltJobAssign> entDbFltJobAssignClass = EntDbFltJobAssign.class;
               Field[] entDbFltJobAssignClassFields = entDbFltJobAssignClass.getDeclaredFields();
               for(Field f : entDbFltJobAssignClassFields){
                 if (!"id".equalsIgnoreCase(f.getName()) && !"serialVersionUID".equalsIgnoreCase(f.getName())){
                   setEntityValue(existFltJobAssign, f.getName(), getEntityValue(entDbFltJobAssign, f.getName()));
                 }
               }   
            // mark job assign as deleted, "X"
               existFltJobAssign.setIdFlight(existJobTask.getIdFlight());
               existFltJobAssign.setRecStatus("X");
               existFltJobAssign.setUpdatedUser(HpEKConstants.EKRTC_DATA_SOURCE);
//               dlEKRTCFltJobAssignBean.Update(existFltJobAssign);
               existFltJobAssign.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
               
              // send notification 
              ufisTopicProducer.sendNotification(true, UfisASCommands.DET,
                  String.valueOf(existFltJobAssign.getIdFlight()), null, existFltJobAssign);
             }
             
             // search exist record of staffShift
             List<EntDbStaffShift> existStaffShiftList  = dlEKRTCStaffShiftBean.getExsitRecordByidFltJboTaskX(existJobTask.getId());
             Iterator<EntDbStaffShift> existStaffShiftListIt = existStaffShiftList.iterator();
             while (existStaffShiftListIt.hasNext()){
               EntDbStaffShift existStaffShift = existStaffShiftListIt.next();
            // mark staff shift record as deleted, "X"
               existStaffShift.setRecStatus("X");

View Full Code Here

    return em;
  }


  @Override
  public EntDbFltJobTask merge(EntDbFltJobTask fltJobTask) {
    EntDbFltJobTask result = null;
    try {
      result = em.merge(fltJobTask);
    } catch (OptimisticLockException Oexc) {
      LOG.error("OptimisticLockException Entity:{} , Error:{}",
          fltJobTask, Oexc);

View Full Code Here

  }


  @Override
  public EntDbFltJobTask findExistingFltJobTask(BigDecimal idFlight,
      BigDecimal taskId, String staffType) {
    EntDbFltJobTask entFltJobTask = null;
    try{
      Query query = em.createNamedQuery("EntDbFltJobTask.findUniqueFltJobTask");
      query.setParameter("idFlight", idFlight);
      query.setParameter("staffType", staffType);
      query.setParameter("taskId", taskId);
      query.setParameter("recStatus", " ");
      
      List<EntDbFltJobTask> resultList = query.getResultList();
      if(resultList.size()>0){
        entFltJobTask = resultList.get(0);
        LOG.debug("Flight job task is found. ID <{}>", entFltJobTask.getId());
      }
      else
        LOG.debug("Flight job task is not found for idFlight <{}>.", idFlight);
    }catch(Exception ex){
          LOG.debug("ERROR when retrieving existing flt_job_task : {}", ex.toString());

View Full Code Here

      msgLogged = Boolean.TRUE;
    }
      
      if (resourceAssignmentType != null){
        EntDbFltJobAssign edpiodEntDbFltJobAssign = new EntDbFltJobAssign();
        EntDbFltJobTask edpiodEntDbFltJobTask = new EntDbFltJobTask();
//        EntDbStaffShift edpiodEntDbStaffShift = new EntDbStaffShift();
        
//        SimpleDateFormat RTCdf = new SimpleDateFormat(HpEKConstants.EKRTC_TIME_FORMAT);
        // convert local time to UTC
//        RTCdf.setTimeZone(HpEKConstants.utcTz);
        
        // check meta
        if (resourceAssignmentType.getMeta() == null){
          LOG.info("Mandatory field Meta is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set message time
        if (resourceAssignmentType.getMeta().getMessageTime() != null){
          edpiodEntDbFltJobAssign.setMsgSendDate(convertXMLGregorianCalendarToDate(resourceAssignmentType.getMeta().getMessageTime()));
        }else {
          LOG.info("Mandatory field message time is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // check messageID
        if (resourceAssignmentType.getMeta().getMessageID() == 0){
          LOG.info("Mandatory field messageID time is 0, resourceAssignmentType message is rejected");
          return false;
        }
        
        // check message type
        if (resourceAssignmentType.getMeta().getMessageType() == null || "".equals(resourceAssignmentType.getMeta().getMessageType())){
          LOG.info("Mandatory field message type is null or empty string, ResourceShiftType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }else if (!Arrays.asList(messageAssignmentTypeArray).contains(resourceAssignmentType.getMeta().getMessageType())){
          LOG.info("Mandatory field message type {} is in possible value, ResourceShiftType message is rejected", resourceAssignmentType.getMeta().getMessageType());
          
          sendErroNotification(EnumExceptionCodes.EENUM);
          
          return false;
        }
        
        // check messageSubtype
        if (resourceAssignmentType.getMeta().getMessageSubtype() == null || "".equals(resourceAssignmentType.getMeta().getMessageSubtype().trim())){
          LOG.info("Mandatory field messageSubtype is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }else if (!Arrays.asList(messageAssignmentSubtypeArray).contains(resourceAssignmentType.getMeta().getMessageSubtype().toUpperCase().trim())){
          LOG.info("Mandatory field messageSubtype {} is in possible value, resourceAssignmentType message is rejected", resourceAssignmentType.getMeta().getMessageSubtype());
          
          sendErroNotification(EnumExceptionCodes.EENUM);
          
          return false;
        }else {
          resAssignMsgSubType = resourceAssignmentType.getMeta().getMessageSubtype();
        }
        
        // set messageSource
        if (resourceAssignmentType.getMeta().getMessageSource() != null && !"".equals(resourceAssignmentType.getMeta().getMessageSource().trim())){
          if (Arrays.asList(messageSourceArray).contains(resourceAssignmentType.getMeta().getMessageSource().toUpperCase().trim())){
            switch(resourceAssignmentType.getMeta().getMessageSource().toUpperCase().trim()){
              case "ENGRTC":
                edpiodEntDbFltJobAssign.setStaffType("ENGR");
                edpiodEntDbFltJobTask.setStaffType("ENGR");
                break;
            }
          }else{
            LOG.info("Mandatory field messageSource {} is not in possible value, resourceAssignmentType message is rejected", resourceAssignmentType.getMeta().getMessageSource());
            
            sendErroNotification(EnumExceptionCodes.EENUM);
            
              return false;
          }
          
        }else {
          LOG.info("Mandatory field messageSource is null or empty string, ResourceShiftType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set TSK
        if (resourceAssignmentType.getTSK() == null ){
          LOG.info("Mandatory field messageSource is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set AID
        if (resourceAssignmentType.getTSK().getAID() != null && !"".equals(resourceAssignmentType.getTSK().getAID())){
          edpiodEntDbFltJobTask.setTaskId(new BigDecimal(resourceAssignmentType.getTSK().getAID()));
        }else {
          LOG.info("Mandatory field AID is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set TRG
        if (resourceAssignmentType.getTSK().getTRG() != null && !"".equals(resourceAssignmentType.getTSK().getTRG().trim())){
          edpiodEntDbFltJobTask.setTaskRuleGrp(resourceAssignmentType.getTSK().getTRG());
        }else{
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
            LOG.info("Mandatory field TRG is null or empty string, resourceAssignmentType message is rejected");
            
            sendErroNotification(EnumExceptionCodes.EMAND);
            
              return false;
          }
        }
        
        // set TRQ
        if (resourceAssignmentType.getTSK().getTRQ() != null && !"".equals(resourceAssignmentType.getTSK().getTRQ().trim())){
          if (entStartupInitSingleton.isMDTaskReqtListOn()){
          // to check with master data
            switch (edpiodEntDbFltJobTask.getStaffType()){
          case "ENGR":
            if (!entStartupInitSingleton.getENGRTaskReqtList().contains(resourceAssignmentType.getTSK().getTRQ().trim())){
              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRQ().trim() ,"ENGR");
            }
            break;
            }
        }  
          edpiodEntDbFltJobTask.setTaskRequirementId(resourceAssignmentType.getTSK().getTRQ());
        }else {
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
          LOG.info("Mandatory field TRQ is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
          }
        }
        
//        // set TRD
//        if (resourceAssignmentType.getTSK().getTRD() != null && !"".equals(resourceAssignmentType.getTSK().getTRD().trim())){
//          if (entStartupInitSingleton.isMDTaskReqtListOn()){
//          // to check with master data
//            switch (edpiodEntDbFltJobTask.getStaffType()){
//          case "EK":
//            if (!entStartupInitSingleton.getEKASTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
//              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"EKAS");
//            }
//            break;
//          case "GX":
//            if (!entStartupInitSingleton.getGXTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
//              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"GX");
//            }
//            break;
//          case "CS":
//            if (!entStartupInitSingleton.getCSTaskReqtList().contains(resourceAssignmentType.getTSK().getTRD().trim())){
//              LOG.warn("not matching the master data, staffType {}, taskReqtId {}", resourceAssignmentType.getTSK().getTRD().trim() ,"CS");
//            }
//            break;
//              }
//          }  
//          edpiodEntDbFltJobTask.setTaskDeptId(resourceAssignmentType.getTSK().getTRD());
//        }
        
        // set DEP
        if (resourceAssignmentType.getTSK().getDEP() != null && !"".equals(resourceAssignmentType.getTSK().getDEP().trim())){
          if (entStartupInitSingleton.isMDDeptListOn()){
          // to check master data
          switch (edpiodEntDbFltJobTask.getStaffType()){
          case "ENGR":
            if (!entStartupInitSingleton.getENGRDeptList().contains(resourceAssignmentType.getTSK().getDEP().trim())){
              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getDEP().trim() ,"ENGR");
              
              sendErroNotification(EnumExceptionCodes.WNOMD);
              
            }
            break;
          }
          }
          edpiodEntDbFltJobTask.setTaskDeptId(resourceAssignmentType.getTSK().getDEP());
        }else {
          LOG.info("Mandatory field DEP is null or empty string, resourceAssignmentType message is rejected");
          return false;
        }
        
        // set TYP
        if (resourceAssignmentType.getTSK().getTYP() != null && !"".equals(resourceAssignmentType.getTSK().getTYP().trim())){
//          // to check master data
//          switch (edpiodEntDbFltJobTask.getStaffType()){
//          case "EK":
//            if (!entStartupInitSingleton.getEKASTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"EKAS");
//            }
//            break;
//          case "GX":
//            if (!entStartupInitSingleton.getGXTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"GX");
//            }
//            break;
//          case "CS":
//            if (!entStartupInitSingleton.getCSTaskTypesList().contains(resourceAssignmentType.getTSK().getTYP().trim())){
//              LOG.warn("not matching the master data, staffType {}, deptId {}", resourceAssignmentType.getTSK().getTYP().trim() ,"CS");
//            }
//            break;            
//          }  
          edpiodEntDbFltJobTask.setTaskType(resourceAssignmentType.getTSK().getTYP());
        }else {
          LOG.info("Mandatory field TYP is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set ORI
        if (resourceAssignmentType.getTSK().getORI() != null && !"".equals(resourceAssignmentType.getTSK().getORI().trim())){
          if (entStartupInitSingleton.isMDTaskGrptypeListOn()){
          // to check master data
          switch (edpiodEntDbFltJobTask.getStaffType()){
          case "ENGR":
            if (!entStartupInitSingleton.getENGRTaskGrptypeList().contains(resourceAssignmentType.getTSK().getORI().trim())){
              LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getORI().trim() ,"ENGR");
              
              sendErroNotification(EnumExceptionCodes.WNOMD);
            }
            break;
          
          }  
          }
          
          edpiodEntDbFltJobTask.setTaskGrpType(resourceAssignmentType.getTSK().getORI());
        }else {
          LOG.info("Mandatory field ORI is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set SNO
        if (resourceAssignmentType.getTSK().getSNO() != 0){
          edpiodEntDbFltJobTask.setTaskNum(new BigDecimal(resourceAssignmentType.getTSK().getSNO()));
        }else {
          LOG.info("Mandatory field SNO is 0, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set MNO
        if (resourceAssignmentType.getTSK().getMNO() != 0){
          edpiodEntDbFltJobTask.setMainTaskNum(new BigDecimal(resourceAssignmentType.getTSK().getMNO()));
        }else {
          LOG.info("Mandatory field MNO is 0, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set RMK
        if (resourceAssignmentType.getTSK().getRMK() != null && !"".equals(resourceAssignmentType.getTSK().getRMK().trim())){
          edpiodEntDbFltJobTask.setTaskRemark(resourceAssignmentType.getTSK().getRMK());
        }
        
        // set STI
        if (resourceAssignmentType.getTSK().getSTI() != null && !"".equals(resourceAssignmentType.getTSK().getSTI())){
          try {
            edpiodEntDbFltJobTask.setTaskActualStartDate(convertStringToDate(resourceAssignmentType.getTSK().getSTI()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date STI, {}", e);
//          LOG.info("Mandatory field STI can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set ETI
        if (resourceAssignmentType.getTSK().getETI() != null && !"".equals(resourceAssignmentType.getTSK().getETI())){
          try {
            edpiodEntDbFltJobTask.setTaskActualEndDate(convertStringToDate(resourceAssignmentType.getTSK().getETI()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date ETI, {}", e);
//          LOG.info("Mandatory field ETI can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set DUR
        if (resourceAssignmentType.getTSK().getDUR() != 0){
          edpiodEntDbFltJobTask.setTaskActualDuration(new BigDecimal(resourceAssignmentType.getTSK().getDUR()));
        }
        
        // set EST
        if (resourceAssignmentType.getTSK().getEST() != null && !"".equals(resourceAssignmentType.getTSK().getEST())){
          try {
            edpiodEntDbFltJobTask.setTaskPlanStartDate(convertStringToDate(resourceAssignmentType.getTSK().getEST()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date EST, {}", e);
//          LOG.info("Mandatory field EST can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }else {
          LOG.info("Mandatory field EST is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set LET
        if (resourceAssignmentType.getTSK().getLET() != null && !"".equals(resourceAssignmentType.getTSK().getLET())){
          try {
            edpiodEntDbFltJobTask.setTaskPlanEndDate(convertStringToDate(resourceAssignmentType.getTSK().getLET()));
            // task_plan_duration = task_plan_end_date - task_plan_start_date
            int days = Days.daysBetween(new DateTime(edpiodEntDbFltJobTask.getTaskPlanStartDate()), new DateTime(edpiodEntDbFltJobTask.getTaskPlanEndDate())).getDays();
            int seconds = days * 24 * 60 * 60;
            edpiodEntDbFltJobTask.setTaskPlanDuration(new BigDecimal(seconds));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date LET, {}", e);
//          LOG.info("Mandatory field LET can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }else {
          LOG.info("Mandatory field LET is null, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set SLO
        if (resourceAssignmentType.getTSK().getSLO() != null && !"".equals(resourceAssignmentType.getTSK().getSLO().trim())){
          edpiodEntDbFltJobTask.setTaskStartLoc(resourceAssignmentType.getTSK().getSLO());
        }else {
          LOG.info("Mandatory field SLO is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set ELO
        if (resourceAssignmentType.getTSK().getELO() != null && !"".equals(resourceAssignmentType.getTSK().getELO().trim())){
          edpiodEntDbFltJobTask.setTaskEndLoc(resourceAssignmentType.getTSK().getELO());
        }else {
          LOG.info("Mandatory field ELO is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set ARK
        if (resourceAssignmentType.getTSK().getARK() != null && !"".equals(resourceAssignmentType.getTSK().getARK().trim())){
          edpiodEntDbFltJobTask.setTaskCannedMsg(resourceAssignmentType.getTSK().getARK());
        }
        
        // set HST
        if (resourceAssignmentType.getTSK().getHST() != null && !"".equals(resourceAssignmentType.getTSK().getHST().trim())){
          edpiodEntDbFltJobTask.setTaskHandlingState(resourceAssignmentType.getTSK().getHST());
        }else {
          LOG.info("Mandatory field HST is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
        // set MWA
        if (resourceAssignmentType.getTSK().getMWA() != null && !"".equals(resourceAssignmentType.getTSK().getMWA().trim())){
          if (entStartupInitSingleton.isMDWorkAreasListOn()){
          // to check with master data
            switch (edpiodEntDbFltJobTask.getStaffType()){
          case "ENGR":
            if (!entStartupInitSingleton.getENGRWorkAreasList().contains(resourceAssignmentType.getTSK().getMWA().trim())){
              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getMWA() ,"ENGR");
            }
            break;
            }
          }
          edpiodEntDbFltJobTask.setTaskWorkArea(resourceAssignmentType.getTSK().getMWA());
        }
//        else {
//          LOG.info("Mandatory field MWA is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        
        // set SWA
        if (resourceAssignmentType.getTSK().getSWA() != null && !"".equals(resourceAssignmentType.getTSK().getSWA().trim())){
          edpiodEntDbFltJobTask.setTaskSubworkArea(resourceAssignmentType.getTSK().getSWA());
        }
        
        // set WLD
        if (resourceAssignmentType.getTSK().getWLD() != null && resourceAssignmentType.getTSK().getWLD() != 0){
          edpiodEntDbFltJobTask.setTaskWorkloadFactor(new BigDecimal(resourceAssignmentType.getTSK().getWLD()));
        }
     
        // set PRI
        if (resourceAssignmentType.getTSK().getPRI() != null && resourceAssignmentType.getTSK().getPRI() != 0){
          edpiodEntDbFltJobTask.setTaskPriority(new BigDecimal(resourceAssignmentType.getTSK().getPRI()));
        }
        
         // set NRO
        if (resourceAssignmentType.getTSK().getNRO() != null && !"".equals(resourceAssignmentType.getTSK().getNRO().trim())){
          edpiodEntDbFltJobTask.setTaskCategory(resourceAssignmentType.getTSK().getNRO());
        }
        
        // Attention ! make use of this info to search flight in AFTTAB (AFTTAB.ACT3 or ACT5)
//          AFT
//        if (resourceAssignmentType.getTSK().getAFT() != null && !"".equals(resourceAssignmentType.getTSK().getAFT().trim())){
//        }
        // set NRO
//        if (resourceAssignmentType.getTSK().getAFT() != null && !"".equals(resourceAssignmentType.getTSK().getAFT().trim())){
//          edpiodEntDbFltJobTask.setTaskCategory(resourceAssignmentType.getTSK().getAFT());
//        }
        
           // set STS
        if (resourceAssignmentType.getTSK().getSTS() != null && !"".equals(resourceAssignmentType.getTSK().getSTS().trim())){
//            // to check with master data
//            switch (edpiodEntDbFltJobTask.getStaffType()){
//          case "EK":
//            if (!entStartupInitSingleton.getEKASTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"EKAS");
//            }
//            break;
//          case "GX":
//            if (!entStartupInitSingleton.getGXTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"GX");
//            }
//            break;
//          case "CS":
//            if (!entStartupInitSingleton.getCSTaskStatusList().contains(resourceAssignmentType.getTSK().getSTS().trim())){
//              LOG.warn("not matching the master data, staffType {}, workArea {}", resourceAssignmentType.getTSK().getSTS().trim() ,"CS");
//            }
//            break;
//          }  
          edpiodEntDbFltJobTask.setTaskStatus(resourceAssignmentType.getTSK().getSTS());
        }else {
          LOG.info("Mandatory field STS is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
        }
        
//        // set STT
//        if (resourceAssignmentType.getTSK().getSTT() != null && !"".equals(resourceAssignmentType.getTSK().getSTT().trim())){
//          if (entStartupInitSingleton.isMDTaskGrptypeListOn()){
//        // to check with master data
//        switch (edpiodEntDbFltJobTask.getStaffType()){
//      case "EK":
//        if (!entStartupInitSingleton.getEKASTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
//          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"EKAS");
//        }
//        break;
//      case "GX":
//        if (!entStartupInitSingleton.getGXTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
//          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"GX");
//        }
//        break;
//      case "CS":
//        if (!entStartupInitSingleton.getCSTaskGrptypeList().contains(resourceAssignmentType.getTSK().getSTT().trim())){
//          LOG.warn("not matching the master data, staffType {}, taskGrptypeId {}", resourceAssignmentType.getTSK().getSTT().trim() ,"CS");
//        }
//        break;
//          }  
//        }
//          edpiodEntDbFltJobTask.setTaskStatus(resourceAssignmentType.getTSK().getSTT());
//        }else {
//          LOG.info("Mandatory field STT is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        
        // Attention ! Use this info to form the full flight number (AFTTAB.FLNO)
        // set DNO
//        if (resourceAssignmentType.getTSK().getDNO() != null && !"".equals(resourceAssignmentType.getTSK().getDNO().trim())){
//          // TO CONTINUE>>>>>>
//        }
        
        // Make use of this info to search flight in AFTTAB Convert to UTC prior to search (AFTTAB.STOD)
        // set DFD
//        if (resourceAssignmentType.getTSK().getDFD() != null){
//          // TO CONTINUE>>>>>>
//        }
        
        // Make use of this info to search flight in AFTTAB (AFTTAB.ORG3)
        // set REG
//        if (resourceAssignmentType.getTSK().getREG() != null && !"".equals(resourceAssignmentType.getTSK().getREG().trim())){
//          // TO CONTINUE>>>>>>
//        }
        
        // Make use of this info to search flight in AFTTAB (AFTTAB.ORG3)
        // set RAG
        if (resourceAssignmentType.getTSK().getRAG() != null || !"".equals(resourceAssignmentType.getTSK().getRAG().trim())){
          edpiodEntDbFltJobTask.setTaskColorCode(resourceAssignmentType.getTSK().getRAG());
        }
        
        // set CRT
        if (resourceAssignmentType.getTSK().getCRT() != null || !"".equals(resourceAssignmentType.getTSK().getCRT().trim())){
          edpiodEntDbFltJobTask.setTaskCriticalFlag(resourceAssignmentType.getTSK().getCRT());
        }
        
        
           // check DSN
        if (resourceAssignmentType.getTSK().getDSN() == null || "".equals(resourceAssignmentType.getTSK().getDSN().trim())){
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
          LOG.info("Mandatory field DSN is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
          }
        }
        
        // Use this info to form the full flight number (AFTTAB.FLNO)
           // check ASN
        if (resourceAssignmentType.getTSK().getASN() == null || "".equals(resourceAssignmentType.getTSK().getASN().trim())){
          if (!"0".equalsIgnoreCase(resourceAssignmentType.getTSK().getORI())){
          LOG.info("Mandatory field ASN is null or empty string, resourceAssignmentType message is rejected");
          
          sendErroNotification(EnumExceptionCodes.EMAND);
          
          return false;
          }
        }
        
//           // check ANO
//        if (resourceAssignmentType.getTSK().getANO() == null || "".equals(resourceAssignmentType.getTSK().getANO().trim())){
//          LOG.info("Mandatory field ANO is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        
        // set SID
        if (resourceAssignmentType.getTSK().getSID() != null && !"".equals(resourceAssignmentType.getTSK().getSID())){
          edpiodEntDbFltJobAssign.setShiftId( new BigDecimal(resourceAssignmentType.getTSK().getSID()));
        }
//        else {
//          LOG.info("Mandatory field SID is null or empty string, resourceAssignmentType message is rejected");
//          return false;
//        }
        
        
           // set SLT
        if (resourceAssignmentType.getTSK().getSLT() != null && !"".equals(resourceAssignmentType.getTSK().getSLT().trim())){
          edpiodEntDbFltJobTask.setTaskStartLocType(resourceAssignmentType.getTSK().getSLT());
        }
        
        // Make use of this info to search flight in AFTTAB (AFTTAB.STOA)
//        // set STA
//        if (resourceAssignmentType.getTSK().getSTA() != null){
//          // TO CONTINUE>>>>>>
//
////          try {
////            edpiodEntDbFltJobTask.setRTCdf.parse(resourceAssignmentType.getTSK().getDFD()));
////        } catch (ParseException e) {
////          LOG.error("erro when parse String to Date, {}", e);
////          LOG.info("Mandatory field DFD can not be parsed correctly, resourceAssignmentType message is rejected");
////            return false;
////        }
//        }
        
        // set AST
        if (resourceAssignmentType.getTSK().getAST() != null && !"".equals(resourceAssignmentType.getTSK().getAST())){
          try {
            edpiodEntDbFltJobTask.setTaskAssignStartDate(convertStringToDate(resourceAssignmentType.getTSK().getAST()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date AST, {}", e);
//          LOG.info("Mandatory field AST can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }
        }
        
        // set AET
        if (resourceAssignmentType.getTSK().getAET() != null && !"".equals(resourceAssignmentType.getTSK().getAET())){
          try {
            edpiodEntDbFltJobTask.setTaskAssignEndDate(convertStringToDate(resourceAssignmentType.getTSK().getAET()));
        } catch (ParseException e) {
          LOG.error("erro when parse String to Date AET, {}", e);
//          LOG.info("Mandatory field AET can not be parsed correctly, resourceAssignmentType message is rejected");
//            return false;
        }

View Full Code Here

    protected EntityManager getEntityManager() {
        return em;
    }
    
    public EntDbFltJobTask getExsitRecordByJobAssignShiftId(BigDecimal shiftId){
      EntDbFltJobTask existRecord = null;
      
      Query query = em.createNamedQuery("EntDbFltJobTask.findRecordByJobAssignShiftID");
    query.setParameter("shiftId", shiftId);
    
    List<?> resultList = query.getResultList();

View Full Code Here

      return existRecord;
    }
    
    
    public EntDbFltJobTask getExsitRecord(EntDbFltJobTask entDbFltJobTask){
      EntDbFltJobTask existRecord = null;
      
      Query query = em.createNamedQuery("EntDbFltJobTask.findRecord");
    query.setParameter("taskId", entDbFltJobTask.getTaskId());
    query.setParameter("staffType", entDbFltJobTask.getStaffType());
    query.setParameter("idFlight", entDbFltJobTask.getIdFlight());

View Full Code Here

      
      return existRecord;
    }
    
    public EntDbFltJobTask getExsitRecordX(BigDecimal taskId){
      EntDbFltJobTask result = null;
      
        CriteriaBuilder cb = em.getCriteriaBuilder();
         CriteriaQuery<EntDbFltJobTask> cq = cb.createQuery(EntDbFltJobTask.class);
        Root<EntDbFltJobTask> r = cq.from(EntDbFltJobTask.class);
        cq.select(r);

View Full Code Here

    BigDecimal urno = getFlightFromInputFlightId(_input.getFlightId());
    if(urno == null){//flight not found
      LOG.debug("Message dropped..");
      return;
    }
    EntDbFltJobTask entJobTask = null;
    String rec_status = " ";
    
    switch (subType) {
    case "INS": 
      if ("FREE".equalsIgnoreCase(taskInfoStatus))
        rec_status = "X";
      else
        rec_status = " ";


      entJobTask = processFltJobTask(_input, urno, false, rec_status);
      if (entJobTask != null)
        // pass _input to include Audit, Equipment  // as well
        insertAllJobAndShift(_input, entJobTask.getId(), urno, rec_status);
      break;
    case "UPD":
      // 2013-11-21 updated by JGO - when auto and manual mark status as free
      //if ("FREE".equalsIgnoreCase(taskInfoStatus))
      if ("FREE".equalsIgnoreCase(taskInfoStatus)
          || "AUTO".equalsIgnoreCase(taskInfoStatus)
          || "MANUAL".equalsIgnoreCase(taskInfoStatus))
        rec_status = "X";
      else
        rec_status = " ";


      entJobTask = processFltJobTask(_input, urno, true, rec_status);
      if (entJobTask != null)
        processFltJobAndShift(_input, urno, entJobTask.getId(),
            rec_status);
      break;
    case "DEL":
      rec_status = "X";
      entJobTask = processFltJobTask(_input, urno, true, rec_status);
      if (entJobTask != null)
        processFltJobAndShift(_input, urno, entJobTask.getId(),
            rec_status);
      break;
    }
  }

View Full Code Here

   * @param input data RTCAssignmentType
   */
  @TransactionAttribute(TransactionAttributeType.REQUIRES_NEW)
  private EntDbFltJobTask processFltJobTask(RTCAssignmentType _input, BigDecimal idFlight, 
      boolean isUpdate, String recStatus)throws ParseException {
    EntDbFltJobTask inputJobTask = null;
    TaskInfoType taskInfo = _input.getTaskDetails().getTaskInfo();
    TaskTimesType taskTimes = _input.getTaskDetails().getTaskTimes();
    
    /**
     * .. check for Master Data ..
     */
    String type = null;
    for(EntDbMdRmsOrderType orderType : clsEntStartUpInitSingleton.getMdRmsOrderTypeList()){
      if(orderType.getOrderType().equalsIgnoreCase(taskInfo.getType())){
        if(orderType.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
          type = taskInfo.getType(); break;
      }
    }
    if(type == null)
      LOG.debug("Order type <{}> is not found in MdRmsOrderType table.", taskInfo.getType());
    
    String reqId = null;
    for(EntDbMdRmsTaskReqt taskReq : clsEntStartUpInitSingleton.getMdRmsTaskReqtsList()){
      if(taskReq.getTaskReqtId().equalsIgnoreCase(taskInfo.getReqId())){
        if(taskReq.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
          reqId = taskInfo.getReqId(); break;
      }
    }
    if(reqId == null)
      LOG.debug("ReqId <{}> is not found in MdRmsTaskReqt table.", taskInfo.getReqId());
    
    String deptName = null, deptId = null;
    for(EntDbMdRmsDept dept : clsEntStartUpInitSingleton.getMdRmsDeptList()){
      if(dept.getDeptName().trim().equalsIgnoreCase(taskInfo.getDeptName())){
        if(dept.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP)){
          deptName = taskInfo.getDeptName(); 
          deptId = dept.getDeptId(); break;
        }
      }
    }
    if(deptName == null){
      deptId = "0";
      LOG.debug("DepName <{}> is not found in MdRmsDept table.", taskInfo.getDeptName());
    }
    String workArea = null;
    for(EntDbMdRmsWorkArea wArea : clsEntStartUpInitSingleton.getMdRmsWorkAreasList()){
      if(wArea.getWorkArea().trim().equalsIgnoreCase(taskInfo.getWorkArea())){
        if(wArea.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
          workArea = taskInfo.getWorkArea(); break;
      }
    }
    if(workArea == null)
      LOG.debug("Work Area <{}> is not found in MdRmsWorkArea table.", taskInfo.getWorkArea());
    
    String startLoc = null, stau = null;
    for(EntDbMdRmsWorkLoc loc : clsEntStartUpInitSingleton.getMdRmsWorkLocsList()){
      if(loc.getWorkLocationId().equalsIgnoreCase(taskInfo.getStartLoc())){
        if(loc.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
          startLoc = taskInfo.getStartLoc(); 
      }
      if(loc.getWorkLocationId().equalsIgnoreCase(taskInfo.getEndLoc())){
        if(loc.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
          stau = taskInfo.getStartLoc(); 
      }
    }
    if(startLoc == null)
      LOG.debug("Work start location <{}> is not found in MdRmsWorkLoc table.", taskInfo.getStartLoc());
    if(stau == null)
      LOG.debug("Work end location <{}> is not found in MdRmsWorkLoc table.", taskInfo.getEndLoc());
    
    String status = null;
    for(EntDbMdRmsTaskStatus taskStatus : clsEntStartUpInitSingleton.getMdRmsTaskStatusList()){
      if(taskStatus.getTaskStatusId().equalsIgnoreCase(taskInfo.getStatus())){
        if(taskStatus.getStaffTypeCode().equalsIgnoreCase(HpEKConstants.RMS_STAFF_TYPE_ROP))
        status = taskInfo.getStatus(); break;
      }
    }
    if(status == null)
      LOG.debug("Task Status Id <{}> is not found in MdRmsTaskStatus table.", taskInfo.getStatus());
    
    /**
     * UPDATE/INSERT Flight Job Task
     */
    BigDecimal taskId = new BigDecimal(taskInfo.getSubTaskID());
  //  boolean createNew = true;
    if (isUpdate) {
      // find the existing record
      inputJobTask = clsDlFltJobTaskLocal.findExistingFltJobTask(
          idFlight, taskId, HpEKConstants.RMS_STAFF_TYPE_ROP);
      if (inputJobTask != null) {
        inputJobTask.setUpdatedDate(HpUfisCalendar.getCurrentUTCTime());
        inputJobTask.setUpdatedUser(HpEKConstants.RMS_RTC_SOURCE);
        // createNew = false;
      }else{
        //flt Task is null to UPDATE
        LOG.debug("Input job task is not existing to Update. Message dropped.");
        return null;
      }
    } else {
      // insert a new record
      inputJobTask = new EntDbFltJobTask();
      inputJobTask.setCreatedDate(HpUfisCalendar.getCurrentUTCTime());
      inputJobTask.setCreatedUser(HpEKConstants.RMS_RTC_SOURCE);
    }
    /*if(createNew) {
      //insert a new record
      inputJobTask = new EntDbFltJobTask();
      inputJobTask.setCreatedDate(HpUfisCalendar.getCurrentUTCTime());
      inputJobTask.setCreatedUser(HpEKConstants.RMS_RTC_SOURCE);
      inputJobTask.setRecStatus(" ");
    }*/
    
    inputJobTask.setRecStatus(recStatus);    
    inputJobTask.setIdFlight(idFlight);
    inputJobTask.setStaffType(HpEKConstants.RMS_STAFF_TYPE_ROP);
    
    /** TaskInfo **/
    inputJobTask.setTaskId(taskId);
    inputJobTask.setTaskCategory(taskInfo.getCategory());
    inputJobTask.setTaskType(taskInfo.getType());
    inputJobTask.setTaskTypeDesc(taskInfo.getTypeDesc());
    inputJobTask.setTaskRequirementId(taskInfo.getReqId());
    inputJobTask.setTaskRequirementName(taskInfo.getReqName());
    inputJobTask.setTaskDeptId(deptId);
    inputJobTask.setTaskDeptName(taskInfo.getDeptName());
    inputJobTask.setTaskWorkArea(taskInfo.getWorkArea());
    inputJobTask.setTaskStartLoc(taskInfo.getStartLoc());
    inputJobTask.setTaskEndLoc(taskInfo.getEndLoc());
    inputJobTask.setTaskRemark(taskInfo.getRemarks());
    inputJobTask.setTaskDuration(new BigDecimal(taskInfo.getDuration()));
    inputJobTask.setTaskHandlingState(taskInfo.getHandlingState());
    inputJobTask.setTaskStatus(taskInfo.getStatus());
    inputJobTask.setTaskStatusChngTime(convertDateToUTC(taskInfo.getStatusTimestamp()));
    inputJobTask.setTaskCreatedDate(convertDateToUTC(taskInfo.getCreationTime()));
    inputJobTask.setDataSource(HpEKConstants.RMS_RTC_SOURCE);
    
    /** TaskTimes **/
    Date planStartDate = convertDateToUTC(taskTimes.getPlnStartTime());
    Date planEndDate = convertDateToUTC(taskTimes.getPlnEndTime());
    
    inputJobTask.setTaskPlanStartDate(planStartDate);
    inputJobTask.setTaskPlanEndDate(planEndDate);
    inputJobTask.setTaskPlanDuration(new BigDecimal((planEndDate.getTime() - planStartDate.getTime())/1000));


    if(taskTimes.getErlStartTime() != null)//Conditional case
      inputJobTask.setTaskEarlyStartDate(convertDateToUTC(taskTimes.getErlStartTime()));


    if(taskTimes.getLstEndTime() != null)
      inputJobTask.setTaskLatestEndDate(convertDateToUTC(taskTimes.getLstEndTime()));


    if(taskTimes.getEstStartTime() != null)
      inputJobTask.setTaskAssignStartDate(convertDateToUTC(taskTimes.getEstStartTime()));
    
    if(taskTimes.getEstEndTime() != null)
      inputJobTask.setTaskAssignEndDate(convertDateToUTC(taskTimes.getEstEndTime()));
    
    if(taskTimes.getActStartTime() != null)
      inputJobTask.setTaskActualStartDate(convertDateToUTC(taskTimes.getActStartTime()));
    
    if(taskTimes.getActEndTime() != null)
      inputJobTask.setTaskActualEndDate(convertDateToUTC(taskTimes.getActEndTime()));
    
    Date taskActualStartDate = inputJobTask.getTaskActualStartDate();
    Date taskActualEndDate = inputJobTask.getTaskActualEndDate();
    if(taskActualEndDate != null && taskActualStartDate != null)
      inputJobTask.setTaskActualDuration(new BigDecimal((taskActualEndDate.getTime() - taskActualStartDate.getTime())/1000));
    else
      LOG.debug("One of Task Actual Start or End date is empty/null. Duration will be empty.");
    
    EntDbFltJobTask resultFltJobTask = clsDlFltJobTaskLocal.merge(inputJobTask);
    if(resultFltJobTask != null)
      LOG.debug("Input Flt Job Task has been inserted/updated.");
    
    return resultFltJobTask;
  }

View Full Code Here

0 1

TOP

Related Classes of com.ufis_as.ek_if.rms.entities.EntDbFltJobTask

com.ufis_as.ufisapp.ek.eao.DlEKRTCFltJobTaskBean

com.ufis_as.ufisapp.ek.eao.DlFltJobTask

com.ufis_as.ufisapp.ek.intf.ekrtc.BlHandleCedaEKRTC

com.ufis_as.ufisapp.ek.intf.ekrtc.BlHandleEKRTC

com.ufis_as.ufisapp.ek.intf.ekrtc.BlHandleENGRTC

com.ufis_as.ufisapp.ek.intf.rms_rtc.BlHandleRmsRtcROPBean

com.ufis_as.ufisapp.ek.intf.rms_rtc.BlHandleRmsRtcSPHLBean

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.