====== Map fields in ModelBuilder (PO) for POBaseModel correctly ====== [[https://tasks.supplyon.de/browse/AIRS-2531|AIRS-2531 Map fields in ModelBuilder (PO) for POBaseModel correctly]] (Jira)\\ [[https://git.seeburger.de/r/c/supplyon/airsupply/+/79699|(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)