rm28870 Divers - "Send Mail" Function doesn't work any longer

• - Änderungen müssen an folgenden Stellen gemacht werden:
  • - SBInvoice
  • - Material Master Data
  • - …
• Test SASUrlHelperTest.testMakeDeepLinkToDocumentDetailsScreen_checkJSONForLinkCreation() korrigieren
• Eine Änderung an der Filterstruktur verursacht den Bug. Die Änderung ist in rm28897 beschrieben. Eine vollständigere Version ist im Notepad++.
• Frank und Volker korrigieren den Fehler (aus rm28897) nur auf der Client-Seite. D.h. es wird wieder knallen.
• Meine Aufgabe ist:
  • die Filter, die auf die “neue” Art gebaut wurden in den Screens richtig parsen.
  • Evtl. eine zentrale Methode dafür schreiben

11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) Caused by: java.lang.NullPointerException
11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) 	at com.seeburger.airsupply.po.client.control.PODetailsDataScreen.getJsonResponse(PODetailsDataScreen.java:144)
11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) 	at com.seeburger.smarti.sui.control.screens.SimpleAjaxScreen.show(SimpleAjaxScreen.java:66)
11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) 	at com.seeburger.smarti.sui.control.screens.SuiTableScreen.show(SuiTableScreen.java:799)
11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) 	at com.seeburger.smarti.sui.searchform.control.screens.SUISearchHandlerScreen.show(SUISearchHandlerScreen.java:269)
11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) 	... 24 more

FCAlertMonitorConnector.getDeepLink() macht einen Deep link.

Beim normalen Fluss bei dem Aufruf von “Details” (Datei fcCollabTabs.js) der Handler für btnFCCollabOverviewCreateCollabDetails leitet an den Screen mit der URL fcCollabDetailsHeader (→ FCCollabDetailsHeaderScreen).

Looong_FC:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8791e7941f003f2911fd0e83f696dee9

Forecast_1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee

Looong_FC_3:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45

Looong_FC:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=4fc511e169f48e938ba9b62f33203b29

PO Alert “GBU_PO_GoodVer003”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e43388f3157d8f490038857628a8a813

PO Alert “GBU_PO_GoodVer004”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b391b93f8766efef8b349acd47a8ef65

MD Alert “VKN_VMI_REGR_C002”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=6ffb9c38bfa485eaabd43a2370514ebe

MD Alert “VVK_VMI_REGR_C001”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=eafe3620f4ecb37eb1403289c12ce145

NCR Alert “VVK_20181115_001_POM”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=befd2ab4fb2d26dbec2a8f5f2a771526

NCR Alert “test12346abcdef”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e11dd93f5846852c7002f038163f1538

SBI Alert “2000017”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=beb7fca90f5a82982c6f7a01203fae9e

SBI Alert “2000018”
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b43267f8e55926cd651ae80fac31b12a

BEH_VMI_REGR_C001:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=85da24786d1646c72ab21f706d85d630

VVK_VMI_REGR_C001:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=a322a51e89cb8e2b9456a614cb5d11af

40002:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=dffc3048a8e36c31928f77d12c29f9f2

393:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=782f444cd5e0aa9513d01fe994ecca40

SELECT * FROM TAIRMATERIAL WHERE CMATERIALID=1582214 -- VVK	
 
SELECT * FROM tPartSeller_VMI WHERE cOrderId=1582214 -- VVK
 
-- VMI Summary statement
WITH alert_status AS (SELECT * FROM (SELECT cobjectreference calertmatid, cpriority, cdateoccurence, ROW_NUMBER() OVER (PARTITION BY cobjectreference ORDER BY cpriority DESC, cdateoccurence ASC) AS rn 
FROM tairalert WHERE ccatid = 1 AND (cdateinactivation IS NULL OR cdateinactivation = 0)) WHERE rn = 1)
SELECT cVMIREFNO,CSTATUS,cStatusRelCalc,CSTOCKONHAND,CALERTDATE,CCONSACTUALSTOCK, CCONSBLOCKEDSTOCK,CCONSQASTOCK,COWNACTUALSTOCK, COWNBLOCKEDSTOCK, COWNQASTOCK, CACTDYNAMICMIN, CACTDYNAMICMAX, CUNCONSUMEDDEMANDSTHROUGHTODAY, CDOCK, cDifToMin, cVMIRefNo, cCoverWithinTransit, cCoverWithoutInTransit, cNextPlannedRecQty, cNextPlannedRecDate, cPriority, cDateOccurence ,CORDERNO, CVERSION,CACTTRANSITQTY, CSUMTRANSITQTY, CINTRANSITBACKLOG,CDEMANDBACKLOG, cDemandBackLogTillToday, CNETDELQTY, CGROSSDELQTY, CNETDELUNITS, cActFinalDeliveryLocation , TAIRPARTNERRELATION.*, TAIRORDERINGOFFICER.*, TAIRMATERIAL.* FROM tAirPartnerRelation, tAirOrderingOfficer, tAirMaterial LEFT JOIN tPartSeller_VMI ON cMaterialId=cOrderId LEFT JOIN alert_status ON cMaterialId=calertmatid  WHERE tAirMaterial.cRelationId_Material=tAirPartnerRelation.cRelationId AND  tAirMaterial.cOrderingOfficerId_Material=tAirOrderingOfficer.cOrderingOfficerId  AND ROWNUM <= 5000  AND (cCustomerPortalGroup IN (1))  AND (cSupplierCPId IN (-1000002,10006106,10006107))  AND cSupplierCGId = 100027 AND CISUNREGSUPPLIER = 0 AND (cMaterialId IN (1582214))  ORDER BY cStatus DESC,cStatusRelCalc DESC, cMaterialId ASC
 
 
-- Demand Details statement
SELECT DISTINCT(cheaderid) FROM TAIRDEMANDS 
INNER JOIN TAIRDEMANDSPOS ON TAIRDEMANDS.CHEADERID = TAIRDEMANDSPOS.CDEMANDSID 
INNER JOIN tAirPartnerRelation ON TAIRDEMANDS.cDemandRelationId = tAirPartnerRelation.CRELATIONID 
INNER JOIN tAirOrderingOfficer ON TAIRDEMANDS.cDemandOrderingOfficerId = tAirOrderingOfficer.CORDERINGOFFICERID 
INNER JOIN TAIRMATERIAL ON TAIRDEMANDS.cDemandMaterialId = TAIRMATERIAL.CMATERIALID 
	WHERE 1 = 1  
	AND ROWNUM <= 5000  
	AND (cCustomerPortalGroup IN (1))  
	AND (cSupplierCPId IN (-1000002,10006106,10006107))  
	AND cSupplierCGId = 100027 
	--AND CISUNREGSUPPLIER = 0 
	AND cHeaderId = 18210 -- -> if I comment it out, I will receive a lot of records
	--AND cIsPending = 0 
	--AND cIsCurrent = 1 
	AND cMaterialId = 1582214

Supplier Material Number: VKN_VMI_REGR_S002
Demand Details:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=cd734519ba9ca1af4fbfc88203fbe439
Demand History:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=fbbc5fb84e9c55e8fb91ba0ccd57c270
MD Alerts:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=3718e2f97d86f9ec0200bf17eb7b5902

Supplier Material Number: VVK_VMI_REGR_S001
Demand Details:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8bffff5465576f1c79c9d37d93463e7e
Demand History:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e31437e31ba1fa23eec944f3b5666a61
MD Alerts:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b82370a1adfc3b62cfab2eca4a0554b3

Looong_FC:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45

Forecast_1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee

Looong_FC:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45

Forecast_1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee

Forecast_1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee

Forecast_1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee

-/2018-10/-/AFR1/…/25,00/1,04
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0ac31164bb262f1aff84ea529347e00b

-/2018-10/AFR_FAL/AFR1/…/25,00/4,35
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e96336c76e8f4bb0ccc6fb8783e3306a

AME_MD-AFR-0007:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=37a52356c84c26d3c51d4ebe89ba2f93

ABC_2:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0b49b2c647db5c59f1eb6502de8e9a1b

A-LIE-AA-30948:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=804d83e13d8261dc13d52adfda445622

ABC_2:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0b49b2c647db5c59f1eb6502de8e9a1b

A-LIE-AA-30948:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=804d83e13d8261dc13d52adfda445622

VVK_20181218_001_POM:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=f71569398b76abb56e29e17309423af5

SAFRAN Record:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e5d9720e69fce01520e5796b2499cdc9

From “PO Overview” screen

AME_W20008310221/10/10:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=d3d415207eec891ac9c35a4985d9fc00

AME2_EDI_000001/10/1:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=655c580461b5cfb28b9a82aeb35692d6

From “Schedule Lines” (Overview) screen:

AME_W20008310221/20/10:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8a29dcf32841c782f0ba743aceaedaf4

From “Schedule Line details” screen:

AME_W20008310221/30/10:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=67bf0454a7c74d49d1f6da261b9f8d3f

From “Create ASN” screen

PO/VMI Reference: PerfSpr_00000301
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=04abedf6ad01322ed9910a0ad5d2b6b9 PO/VMI Reference: PerfSpr_00000251
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=c1410f9fe636c85d8575658aa07fd6c0

• + Link SBI Overview → Details
• + Link SBI Alerts → Details
• + Send mail SBI Overview
• + Send mail SBI Details (Details)
• + Send mail SBI Details (Header)
• + Send mail SBI Alerts

2000015:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e50c43c90ecd6f9e812ae156fa54a16d

2000016:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=7728b069ccdebd2a6a315411697e5214

2000019:

Send mail from SBI Alert Overview:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=9cf11cc7e500dcf1d7854758c3382071
Send mail from SBI Overview:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=44faf27340e4cae961cd158cd9e0dd63

2000020:

Send mail from SBI Alert Overview:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=09a81d5bf3a0b9d75d9fd51ed75f8d2f
Send mail from SBI Overview:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=997d0c7a023a22340fc0138e6336681d

rm27328_003:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=2bad89e85b33e6a729092479dc92557c

VVK_VMI_REGR_S001:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=450b1bec7e559925362300bbbeae6a94

VKN_VMI_REGR_S002:
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=72fac29e5db7a483a5d46cc1d3ac6a0b

http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=626784327eaa0a377cc25a63f4e453ef

Material: http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=ddc4c69a5d5c1c12e5e922eede3660d3

Order(?): http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=9deb6c1305747f5e51140001c24f0407

VMI Inventory Projection

Supplier Material Number: VVK_VMI_REGR_S001 http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8e7186c62101ad2d4330c45dbfadbf95 → Inventory Projection

• + VMI Demand Details Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + VMI Demand Details Screen Deep Link Generation By Supplier and Access By Authorized Supplier
• + VMI Demand Header Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + VMI Demand Header Screen Deep Link Generation By Supplier and Access By Authorized Supplier

• + VMI Demand History Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + VMI Demand History Screen Deep Link Generation By Supplier and Access By Authorized Supplier

• + Material Details/Overview Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + Material Details/Overview Screen Deep Link Generation By Supplier and Access By Authorized Supplier
• + MD Alerts Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + MD Alerts Screen Deep Link Generation By Supplier and Access By Authorized Supplier

• + SBI Alerts Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + SBI Alerts Screen Deep Link Generation By Supplier and Access By Authorized Supplier
• + SBI Overview Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + SBI Overview Screen Deep Link Generation By Supplier and Access By Authorized Supplier
• + SBI Header Screen Deep Link Generation By Supplier and Access By Authorized Customer
• + SBI Header Screen Deep Link Generation By Supplier and Access By Authorized Supplier