vwiki

User Tools

Site Tools

Trace:
airs-2531

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
airs-2531 [2019/07/23 08:53] – kalaschnikowairs-2531 [2019/07/23 10:58] (current) – kalaschnikow
Line 1: Line 1:
 +====== 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:
 +<code java>
 +        // 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
 +...
 +
 +</code>
 +
 +
 +
 +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)
 +
 +
 +