cli:franke:digital_cic

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:digital_cic [2025/06/19 15:58]
r.fioretti [Richiesta invio email all'owner dell'oggetto] 		cli:franke:digital_cic [2025/06/20 12:10] (current)
admin [Parametri XML]
Line 1674: Line 1674:
 ===== Parametri XML ===== ===== Parametri XML =====
 <code sql> <code sql>
 +<agent lib="/usr/lib/libiadata.so.0.0.0" create="agentData" live="1" name="prepdig">
 + <param name="agdb" value="tpevodb" />
 + <param name="path" value="/code/cpp/sql/digcic" />
 +</agent>
 <agent lib="/usr/lib/libcomhand.so.0.0.0" create="agentOperaCom" live="1" name="operacom"> <agent lib="/usr/lib/libcomhand.so.0.0.0" create="agentOperaCom" live="1" name="operacom">
-            <param name="agdb" value="tpevodb"/> +        <param name="agdb" value="tpevodb"/> 
-            <param name="agch" value="smtp"/> +        <param name="agch" value="smtp"/> 
-            <param name="prefix" value="$" /> +        <param name="prefix" value="$" /> 
-            <param name="suffix" value="" /> +        <param name="suffix" value="$" /> 
-        </agent> +</agent> 
-        <agent lib="/usr/lib/libcomhand.so.0.0.0" create="agentSmtp" live="1" name="smtp"> +<agent lib="/usr/lib/libcomhand.so.0.0.0" create="agentSmtp" live="1" name="smtp"> 
-            <param name="server" value="smtp://smtp-eu.franke.world:587"/> +        <param name="server" value="smtp://smtp-eu.franke.world:587"/> 
-            <param name="usr" value="Franke-DSFM.CH@franke.com"/> +        <param name="usr" value="Franke-DSFM.CH@franke.com"/> 
-            <param name="pw" value="gWvx?GRaqsEutjDaxGcC"/> +        <param name="pw" value="gWvx?GRaqsEutjDaxGcC"/> 
-            <param name="insecure" value="1"/> +        <param name="insecure" value="1"/> 
-            <!-- <param name="cacert" value="/nextdata/code/cfg/certs/franke/dsfm/dsfm.franke.world.ca-bundle"/> --> +        <!-- <param name="cacert" value="/nextdata/code/cfg/certs/franke/dsfm/dsfm.franke.world.ca-bundle"/> --> 
-            <param name="sendmail" value="Franke-DSFM.CH@franke.com"/> +        <param name="sendmail" value="Franke-DSFM.CH@franke.com"/> 
-            <param name="sendname" value="DSFM"/> +        <param name="sendname" value="DSFM"/> 
-            <param name="timeoutconn" value="10"/> +        <param name="timeoutconn" value="10"/> 
-            <param name="timeoutsend" value="60"/> +        <param name="timeoutsend" value="60"/> 
-        </agent> +</agent> 
-         +<agent lib="/usr/lib/libdigcic.so.0.0.0" create="agentActionNotify" live="1" name="actmail"> 
-        <agent lib="/usr/lib/libdigcic.so.0.0.0" create="agentActionNotify" live="1" name="actmail"> +        <param name="agdb" value="tpevodb" /> 
-            <param name="agdb" value="tpevodb" /> +        <param name="agcom" value="operacom" /> 
-            <param name="agcom" value="operacom" /> +        <param name="keynew" value="assign" /> 
-            <param name="keynew" value="assign" /> +        <param name="keydel" value="unassign" /> 
-            <param name="keydel" value="unassign" /> +        <param name="keyrem" value="reminder" /> 
-            <param name="keyrem" value="reminder" /> +        <!-- Ogni tipologia ha un suo messaggio configurato che si identifica con "$TIPO"|"$TIPO_chiamata" ($TIPO_chiamata è la chiave di operacom.key) --> 
-            <!-- Ogni tipologia ha un suo messaggio configurato che si identifica con "$TIPO"|"$TIPO_chiamata" ($TIPO_chiamata è la chiave di operacom.key) --> + <param name="confkeynew" value="S|S_assign,Q|Q_assign" /> 
-     <param name="confkeynew" value="S|S_assign,Q|Q_assign" /> + <param name="confkeydel" value="S|S_unassign" /> 
-     <param name="confkeydel" value="S|S_unassign" /> + <param name="confkeyrem" value="S|S_reminder" /> 
-     <param name="confkeyrem" value="S|S_reminder" /> +        <param name="tm" value="300000" /> 
-            <param name="tm" value="300000" /> +        <param name="agps" value="prepdig" /> 
-        </agent>+</agent>
 </code> </code>
  
Line 1716: Line 1720:
 -- alter table emailsetting add constraint ix_emailsetting_pk PRIMARY KEY (codubi,type,codoperfield); -- alter table emailsetting add constraint ix_emailsetting_pk PRIMARY KEY (codubi,type,codoperfield);
 alter table emailsetting add constraint ix_emailsetting_pk PRIMARY KEY (codubi,msgkey); alter table emailsetting add constraint ix_emailsetting_pk PRIMARY KEY (codubi,msgkey);
 +</code>
 +
 +Aggiunta una tabella per gestire le richieste ed i messaggi. Sono state tolte le chiavi dei messaggi dall'xml e sono state gestite nella tabella actionkeys \\  
 +<code sql>
 +CREATE TABLE public.actionkeys (
 +    type character varying(4) NOT NULL,
 +    operation character varying(250) NOT NULL,
 +    comkey character varying(51)
 +);
 +ALTER TABLE public.actionkeys OWNER TO postgres;
 +COMMENT ON TABLE public.actionkeys IS 'Tabella per la gestione delle azioni di mail';
 +COMMENT ON COLUMN public.actionkeys.type IS 'Tipologia di action';
 +COMMENT ON COLUMN public.actionkeys.operation IS 'Operazione della mail (unassign, assign, reminder)';
 +COMMENT ON COLUMN public.actionkeys.comkey IS 'Campo operacom.key per selezione del messaggio da inviare';
 +
 +INSERT INTO public.actionkeys VALUES ('Q', 'assign', 'Q_assign');
 +INSERT INTO public.actionkeys VALUES ('V', 'assign', 'V_assign');
 +INSERT INTO public.actionkeys VALUES ('H', 'assign', 'H_assign');
 +INSERT INTO public.actionkeys VALUES ('M', 'assign', 'M_assign');
 +INSERT INTO public.actionkeys VALUES ('S', 'assign', 'S_assign');
 +INSERT INTO public.actionkeys VALUES ('W', 'assign', 'W_assign');
 +INSERT INTO public.actionkeys VALUES ('O', 'assign', 'O_assign');
 +INSERT INTO public.actionkeys VALUES ('I', 'assign', 'I_assign');
 +INSERT INTO public.actionkeys VALUES ('Z', 'assign', 'Z_assign');
 +INSERT INTO public.actionkeys VALUES ('J', 'assign', 'J_assign');
 +INSERT INTO public.actionkeys VALUES ('Q', 'unassign', 'Q_unassign');
 +INSERT INTO public.actionkeys VALUES ('V', 'unassign', 'V_unassign');
 +INSERT INTO public.actionkeys VALUES ('H', 'unassign', 'H_unassign');
 +INSERT INTO public.actionkeys VALUES ('M', 'unassign', 'M_unassign');
 +INSERT INTO public.actionkeys VALUES ('S', 'unassign', 'S_unassign');
 +INSERT INTO public.actionkeys VALUES ('W', 'unassign', 'W_unassign');
 +INSERT INTO public.actionkeys VALUES ('O', 'unassign', 'O_unassign');
 +INSERT INTO public.actionkeys VALUES ('I', 'unassign', 'I_unassign');
 +INSERT INTO public.actionkeys VALUES ('Z', 'unassign', 'Z_unassign');
 +INSERT INTO public.actionkeys VALUES ('J', 'unassign', 'J_unassign');
 +INSERT INTO public.actionkeys VALUES ('Q', 'reminder', 'Q_reminder');
 +INSERT INTO public.actionkeys VALUES ('V', 'reminder', 'V_reminder');
 +INSERT INTO public.actionkeys VALUES ('H', 'reminder', 'H_reminder');
 +INSERT INTO public.actionkeys VALUES ('M', 'reminder', 'M_reminder');
 +INSERT INTO public.actionkeys VALUES ('S', 'reminder', 'S_reminder');
 +INSERT INTO public.actionkeys VALUES ('W', 'reminder', 'W_reminder');
 +INSERT INTO public.actionkeys VALUES ('O', 'reminder', 'O_reminder');
 +INSERT INTO public.actionkeys VALUES ('I', 'reminder', 'I_reminder');
 +INSERT INTO public.actionkeys VALUES ('Z', 'reminder', 'Z_reminder');
 +INSERT INTO public.actionkeys VALUES ('J', 'reminder', 'J_reminder');
 +INSERT INTO public.actionkeys VALUES ('JO', 'assign', 'JO_assign');
 +INSERT INTO public.actionkeys VALUES ('JO', 'reminder', 'JO_reminder');
 +INSERT INTO public.actionkeys VALUES ('JO', 'unassign', 'JO_unassign');
 +INSERT INTO public.actionkeys VALUES ('SO', 'assign', 'SO_assign');
 +INSERT INTO public.actionkeys VALUES ('SO', 'reminder', 'SO_reminder');
 +INSERT INTO public.actionkeys VALUES ('SO', 'unassign', 'SO_unassign');
 +INSERT INTO public.actionkeys VALUES ('ZB', 'assign', 'ZB_assign');
 +INSERT INTO public.actionkeys VALUES ('ZB', 'reminder', 'ZB_reminder');
 +INSERT INTO public.actionkeys VALUES ('ZB', 'unassign', 'ZB_unassign');
 +
 +ALTER TABLE ONLY public.actionkeys ADD CONSTRAINT actionkeys_pkey PRIMARY KEY (type, operation);
 +
 </code> </code>
  • cli/franke/digital_cic.1750341500.txt.gz
  • Last modified: 2025/06/19 15:58
  • by r.fioretti