cli:franke:erp_integration_next_rest

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
cli:franke:erp_integration_next_rest [2022/03/04 10:08]
m.zingaretti 		cli:franke:erp_integration_next_rest [2024/04/23 15:17] (current)
m.zingaretti [gestione ConfirmationGroup]
Line 2: Line 2:
 Documenti Condivisi: Documenti Condivisi:
  
-{{ :cli:franke:api_s4_production_order.pdf |}} \\+{{ :cli:franke:api_s4_production_order.pdf |}} \\ \\  
 + 
 +Tabella di conversione campi SAP (java) con il modello REST : \\ \\ 
 + 
 +{{ :cli:franke:oee_s4_integration_mapping.xlsx |}} \\ \\ 
  
 il protocollo Rest utilizza Oauth2 quindi le trasmissioni sono attraverso un token, in questo caso và mandato nella header; è di tipo Bearer quindi prevede una chiave fissa "Bearer" prima del Token \\ il protocollo Rest utilizza Oauth2 quindi le trasmissioni sono attraverso un token, in questo caso và mandato nella header; è di tipo Bearer quindi prevede una chiave fissa "Bearer" prima del Token \\
Line 19: Line 23:
 curl --request GET 'https://franke.prod.apimanagement.eu10.hana.ondemand.com/a88a/NEXTOEE/API_PROD_ORDER/ProductionOrder/1000001' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN' curl --request GET 'https://franke.prod.apimanagement.eu10.hana.ondemand.com/a88a/NEXTOEE/API_PROD_ORDER/ProductionOrder/1000001' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN'
  
-#falshback+#flashback
  
 curl --request POST 'https://franke.prod.apimanagement.eu10.hana.ondemand.com:443/a88a/NEXTOEE/API_PROD_ORDER/ConfirmProductionOrder/1000007' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN' --header 'Content-Type: application/json' --data-raw '{ "ConfirmationDate": "2022-01-24T00:00:00","ManufacturingOrder": "1000007", "YieldQuantity": "0",  "ProductionUnit": "PC", "FinalConfirmatio curl --request POST 'https://franke.prod.apimanagement.eu10.hana.ondemand.com:443/a88a/NEXTOEE/API_PROD_ORDER/ConfirmProductionOrder/1000007' --header 'APIKey: API' --header 'Authorization: Bearer TOKEN' --header 'Content-Type: application/json' --data-raw '{ "ConfirmationDate": "2022-01-24T00:00:00","ManufacturingOrder": "1000007", "YieldQuantity": "0",  "ProductionUnit": "PC", "FinalConfirmatio
Line 37: Line 41:
 --> -->
 <xnetagents> <xnetagents>
- <mtp name="nome_mtp" > 
- <netmtp name="maganet" host="127.0.0.1" port="5151" /> 
- </mtp> 
- <super_agents> 
- <!-- <param name="tmmax" value="7000" /> --> 
- <agent lib="/usr/lib/libiasupag.so" create="agentXNet" live="1" name="xnet"> 
- <param name="ipaddr" value="ANY" /> 
- <param name="port" value="6161" /> 
- </agent> 
- </super_agents> 
  <agents>  <agents>
- <!-- Agente gestiore della comunicazione tra framework --> + <!-- ... -->
- <agent lib="/usr/lib/libiautiag.so" create="agentNetMtp" live="1" name="netmtp"> +
- <param name="class0" value="agdb" /> +
- <param name="askp10" value="1" /> +
- <param name="dirask0" value="1" /> +
- <param name="tellp10" value="2" /> +
- <param name="askout0" value="2" /> +
- +
- <param name="class1" value="tpevo" /> +
- <param name="askp11" value="2" />  <!--1=PKT_SEM 2=REC_SEM 0=NONE_SEM --> +
- <param name="dirask1" value="1" /> +
- <param name="askout1" value="2" /> +
- <param name="tellp11" value="2" /> +
- <param name="dirtell1" value="0" /> +
- +
- <param name="class2" value="ctrlpc" /> +
- <param name="askp12" value="0" />  <!--1=PKT_SEM 2=REC_SEM 0=NONE_SEM --> +
- <param name="dirask2" value="0" /> +
- <param name="askout2" value="2" /> +
- <param name="tellp12" value="2" /> +
- <param name="dirtell2" value="0" /> +
- +
- <param name="class3" value="tell_p1_rec" /> +
- <param name="tellp13" value="2" /> +
- +
- <param name="class4" value="tell_p1_rec_ask_p12_pkt_out_pkt" /> +
- <param name="tellp14" value="2" /> +
- <param name="askp14" value="1" /> +
- <param name="askp24" value="1" /> +
- <param name="askout4" value="1" /> +
- +
- <param name="class5" value="tell_p12_pkt_ask_p12_pkt_out_rec" /> +
- <param name="tellp15" value="1" /> +
- <param name="tellp25" value="1" /> +
- <param name="askp15" value="1" /> +
- <param name="askp25" value="1" /> +
- <param name="askout5" value="2" /> +
- +
- <param name="class6" value="tell_p1_rec_ask_out_rec" /> +
- <param name="tellp16" value="2" /> +
- <param name="askout6" value="2" /> +
- +
- <param name="class7" value="ask_out_pkt" /> +
- <param name="askout7" value="1" /> +
- +
- <param name="class8" value="tell_p1_rec_ask_p1_pkt_out_rec" /> +
- <param name="tellp18" value="2" /> +
- <param name="askp18" value="1" /> +
- <param name="askout8" value="2" /> +
- +
- <param name="class9" value="tell_p1_rec_ask_p1_rec_out_pkt" /> +
- <param name="tellp19" value="2" /> +
- <param name="askp19" value="2" /> +
- <param name="askout9" value="1" /> +
- +
- <param name="class10" value="tell_p12_rec_ask_p1_rec_out_rec" /> +
- <param name="tellp110" value="2" /> +
- <param name="tellp210" value="2" /> +
- <param name="askp110" value="2" /> +
- <param name="askout10" value="1" /> +
- +
- <param name="class11" value="tell_p12_pkt_ask_p1_rec_out_rec" /> +
- <param name="tellp111" value="1" /> +
- <param name="tellp211" value="1" /> +
- <param name="askp111" value="2" /> +
- <param name="askout11" value="2" /> +
- +
- <param name="class12" value="ask_p1_rec_out_rec" /> +
- <param name="askp112" value="2" /> +
- <param name="askout12" value="2" /> +
-  +
- <param name="class13" value="tell_p1_rec_ask_p1_rec_out_rec" /> +
- <param name="tellp113" value="2" /> +
- <param name="askp113" value="2" /> +
- <param name="askout13" value="2" /> +
-  +
- <param name="tmwait" value="7200000" /> +
- +
- <param name="ipaddr" value="ANY" /> +
- <param name="port" value="5161" /> +
- </agent> +
- <!-- Agente che gestisce i servizi legati al database  --> +
- <agent lib="/usr/lib/libiautiag.so" create="agentDb" live="1" name="tpevodb"> +
- <param name="libdb" value="/usr/lib/libpgdb.so" /> +
- <param name="libfunc" value="CDb_Create" /> +
- <param name="serverdb" value="127.0.0.1" /> +
- <param name="dbname" value="andon" /> +
- <param name="usr" value="postgres" /> +
- <param name="pwd" value="HMtrs9hY" /> +
- <param name="ipnume" value="127.0.0.1" /> +
- <param name="portnume" value="5002" /> +
- </agent> +
- <!-- Agente che si occupa del carico a magazzino dei lotti --> +
- <agent lib="/usr/lib/libgtrace.so.0.0.0" create="agentSimpMovi" live="0" name="simpmovi"> +
- <param name="agdb" value="tpevodb" /> +
- <param name="agdepo" value="depo" /> +
- <param name="aglotto" value="lotto" /> +
- <param name="causca" value="SCAPR" /> +
- <param name="enabnpsub" value="0" /> +
- <param name="pparam" value="0" /> +
- <param name="tm" value="1000" /> +
- </agent>+
  <!--Agente gestisce l'inserimento degli ordini di produzione, degli articoli e del tempo ciclo dei prodotti-->  <!--Agente gestisce l'inserimento degli ordini di produzione, degli articoli e del tempo ciclo dei prodotti-->
  <agent lib="/usr/lib/libgtrace.so.0.0.0" create="agentInsOp" live="1" name="insop">  <agent lib="/usr/lib/libgtrace.so.0.0.0" create="agentInsOp" live="1" name="insop">
Line 168: Line 61:
 </xnetagents> </xnetagents>
 </code> </code>
 +
 +====== gestione ConfirmationGroup ======
 +La tabella sapinfoubi prende infomazioni riguardo il rueck (codop) e postazione (postazione) da inviare con il metodo POST per il Flashing Back 
 +
 +<code sql>
 +--- drop table sapinfoubi
 +
 +CREATE TABLE public.sapinfoubi (
 +    codop character varying(51) NOT NULL,
 +    codubi character varying(51) NOT NULL,
 +    confgrp character varying(51),
 +    ordope character varying(51)
 +);
 +
 +COMMENT ON TABLE public.sapinfoubi IS 'Tabella informazioni codop-codubi arrivate da SAP';
 +COMMENT ON COLUMN public.sapinfoubi.codop IS 'Rueck Ricevuto da sap';
 +COMMENT ON COLUMN public.sapinfoubi.codubi IS 'codice postazione';
 +COMMENT ON COLUMN public.sapinfoubi.confgrp IS 'ConfirmationGroup da inviare con il flashingback';
 +COMMENT ON COLUMN public.sapinfoubi.ordope IS 'OrderOperation da inviare con il flashingback';
 +
 +ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT sapinfoubi_pkey PRIMARY KEY (codop, codubi);
 +ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codop FOREIGN KEY (codop) REFERENCES public.ordprod(codop) ON UPDATE CASCADE ON DELETE CASCADE;
 +ALTER TABLE ONLY public.sapinfoubi ADD CONSTRAINT ix_sapinfoubi_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE;
 +</code>
 +====== Crezione API ======
 +Generazione API, Avere Get a SAP Universal ID se manca crearlo dalla schermata di accesso \\
 +{{:cli:franke:pasted:20230329-085345.png?600}} \\
 +{{:cli:franke:pasted:20230329-085352.png?600}}
 +
 +Una volta entrato da questo link: \\  \\
 +https://frankeisprod.apibhubenterprise.cfapps.eu10.hana.ondemand.com/product/PRD_NEXTOEE \\ \\
 +Creare una nuova app: \\ \\
 +{{:cli:franke:pasted:20230329-085651.png?600}} \\ 
 +{{:cli:franke:pasted:20230329-085925.png?600}} \\
 +Usare queste nell'agente Rest (AgentRestSAP)
 +
 +
  • cli/franke/erp_integration_next_rest.1646384911.txt.gz
  • Last modified: 2022/03/04 10:08
  • by m.zingaretti