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:16]
m.zingaretti 		cli:franke:erp_integration_next_rest [2024/04/23 15:17] (current)
m.zingaretti [gestione ConfirmationGroup]
Line 23: 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 41: 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 172: 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.1646385362.txt.gz
  • Last modified: 2022/03/04 10:16
  • by m.zingaretti