====== rm28870 PO - "Send Mail" Function doesn't work any longer ======
[[https://cust-projects.seeburger.de/redmine/issues/28870|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 [[https://cust-projects.seeburger.de/redmine/issues/28897|rm28897]] beschrieben. Eine vollständigere Version ist im Notepad++.
* Frank und Volker korrigieren den Fehler (aus [[https://cust-projects.seeburger.de/redmine/issues/28897|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
===== Prozesse =====
==== Alerts ====
=== Forecast Alerts ===
''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'').
=== Testlinks ===
== Forecast ==
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 ==
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 ==
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 ==
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 ==
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\\
== VMI ==
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
==== ASN ====
=== TestLinks ===
40002:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=dffc3048a8e36c31928f77d12c29f9f2
393:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=782f444cd5e0aa9513d01fe994ecca40
==== Demand Details ====
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
=== Testlinks ===
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\\
==== Forecast ====
=== Testlinks ===
== Forecast Summary (Overview) ==
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 Data (Overview) ==
Looong_FC:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45
Forecast_1:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\
== Collab View (Overview) ==
Forecast_1:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\
== Collab View ==
Forecast_1:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\
==== KPI ====
=== Testlinks ===
-/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
==== Material Master Data ====
=== Testlinks ===
== Overview ==
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\\
== Details ==
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\\
==== NCR ====
=== Testlinks ===
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
==== PO ====
=== Testlinks ===
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
==== SBInvoice ====
* **+** 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
=== Testlinks ===
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\\
==== Stock Movements ====
=== Testlinks ===
rm27328_003:\\
http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=2bad89e85b33e6a729092479dc92557c
==== VMI ====
=== Testlinks ===
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
==== Testlinks ====
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
====== Tests ======
* **+** 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