AIRS-2531 Map fields in ModelBuilder (PO) for POBaseModel correctly (Jira)
(Gerrit)

com.seeburger.airsupply.po.manager.ModelBuilder.createPOBaseModelCommonFields(bHandleHeaderData, bHandleLineData, model, rs);

• createPOBaseModel(boolean, boolean, ResultSet)
• createPOCollabModel(boolean, boolean, ResultSet, boolean, SASUserContext)
• createPOFullModel(boolean, boolean, ResultSet, SASUserContext) → [OK] da direkt nach dem Aufruf auch createPOOverviewModelCommonFields() aufgerufen wird
• createPOOverviewModel(boolean, boolean, ResultSet, SASUserContext, boolean) → [OK] da direkt nach dem Aufruf auch createPOOverviewModelCommonFields() aufgerufen wird

Setter, die geschoben werden sollen:

        // TAIRPOSCHEDULE
        if (bHandleLineData)
        {
...
            model.setUnitFormat(rs.getBigDecimal("CUNITOFMEASUREFORMAT"));  // POCoreModel 
            model.setUnitBase(rs.getBigDecimal("CBASEOFUNIT"));
...
            model.setPriceUnit(rs.getString("CPRICEUNITMEASURE"));
...
            model.setFitCustMat(rs.getString("CFITCUSTMATERIAL"));
...
            model.setPubSource(rs.getString("CPUBSOURCE"));
...
            model.setIsLineSplitAllowed(rs.getBoolean("CLINESPLITALLOWED"));
...
            model.setShipToName1(rs.getString("CSHIPTONAME1"));
            model.setShipToName2(rs.getString("CSHIPTONAME2"));
            model.setShipToName3(rs.getString("CSHIPTONAME3"));
            model.setShipToName4(rs.getString("CSHIPTONAME4"));
            model.setShipToStreet1(rs.getString("CSHIPTOSTREET1"));
            model.setShipToStreet2(rs.getString("CSHIPTOSTREET2"));
            model.setShipToZip(rs.getString("CSHIPTOZIP"));
            model.setShipToCity(rs.getString("CSHIPTOCITY"));
            model.setShipToCountry(rs.getString("CSHIPTOCOUNTRY"));
...
            model.setSalesPrice( rs.getBigDecimal( "CSALESPRICE" ) );
            model.setSalesPriceCurrency( rs.getString( "CSALESPRICECURRENCY" ) );
            model.setRoutingInstructions( rs.getString( "CROUTINGINSTRUCTIONS" ) );
            model.setEarliestDAOffset( rs.getLong( "CEARLIESTDAOFFSET" ) );
            model.setEarliestDADate( rs.getLong( "CEARLIESTDADATE" ) );
...
            model.setReasonCode( rs.getString( "cReasonCode" ) );
            model.setReasonCodeDescription( rs.getString( "cReasonCodeDescription" ) );
            model.setEstimatedTimeOfArrival(rs.getLong("CETADATE"));                                // POCoreModel      // Not in TAIRPOSCHEDULE, but in TAIRTRANSPORTEVENTS!
            model.setSupplierPickUpDate(rs.getLong("CSUPPLIERPICKUPDATE"));                         // POCoreModel      // Not in TAIRPOSCHEDULE, but in TAIRTRANSPORTEVENTS!
            model.setCustomerPickUpDate(rs.getLong("CCUSTOMERPICKUPDATE"));                         // POCoreModel      // Not in TAIRPOSCHEDULE, but in TAIRTRANSPORTEVENTS!
            model.setRealPickupDate(rs.getLong("CREALPICKUPDATE"));                                 // POCoreModel      // Not in TAIRPOSCHEDULE, but in TAIRTRANSPORTEVENTS!
...
            model.setCustomsDeclarationRequired(rs.getBoolean("CCUSTOMSDECLARATIONREQUIRED"));      // POCoreModel
        }
 
        // TAIRPOHEADER
        if (bHandleHeaderData)
        {
            model.setPoErpDate(rs.getLong("CPOERPDATE"));   // POCoreModel
            model.setOrderType(rs.getString("CORDERTYPE")); // POCoreModel
            model.setOrderSubType(rs.getString("CORDERSUBTYPE"));   // POCoreModel
            model.setDocType(rs.getString("CDOCTYPE")); // POCoreModel
...

Also es muss sichergestellt werden, dass für die Spalten aus den Tabellen TAIRPOHEADER, TAIRPOSCHEDULE, TAIRTRANSPORTEVENTS da sind :

• wenn createPOBaseModelCommonFields() aufgerufen wird
  • createPOBaseModel()
    • PODAOImpl:1475 (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
    • PODAOImpl:8358 (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
  • createPOCollabModel()
    • ModelBuilder.createPOCollabModel():392
      • getPOActionRequiredModels(String, long, int, int, String) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
      • getPOAutoCommitModels(String, int, int, String) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
      • getPOCollabModelList(SASFilter, POSorter, SASUserContext) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
      • getPOFinalizableCollabModels(String, int, int, String) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
      • getPONoReceptionModelsNG(String, long, int, String) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
      • getPOSparesNotifyModels(String, int, int, String) (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
    • PODAOImpl:6116 (not TAIRTRANSPORTEVENTS or VTRANSPORTEVENTS_PO fields!)
    • PODAOImpl:6222 (OK)