//============================= v.632 ========================================= - 2026-01-26 10:50:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014665 _________ Destinataires _________ to : montalieu@hellopharmacie.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedemontalieu@offisecure.com not addCC : montalieu@hellopharmacie.com addCC : meylan.contratutilisateur@roche.com whiteList = montalieu@hellopharmacie.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690014665' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690032372 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014665/20260126_10:50:51/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014665/20260126_10:50:51 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690014665_26_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690014665_26_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690014665_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690014665/20260126_10:50:51/Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690014665_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690014665_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = montalieu@hellopharmacie.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014665 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"montalieu@hellopharmacie.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 15:30:41 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016512 _________ Destinataires _________ to : pharmacie.de.ceyzeriat@orange.fr cc : melanie.ribeiro@roche.com emailPharma : pharmacie.de.ceyzeriat@orange.fr not addCC : pharmacie.de.ceyzeriat@orange.fr addCC : melanie.ribeiro@roche.com whiteList = pharmacie.de.ceyzeriat@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016512/20260123_15:30:41/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016512/20260123_15:30:41 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690016512_23_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016512_23_01_2026.xml fileNameToSend = Engagement_3690016512_23_01_2026_detailLivraisons.png fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = BDC-engagement_3690016512_23_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016512_23_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690016512_23_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016512_23_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016512_23_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 40 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690016512_23_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016512/20260123_15:30:41/BDC_XML-engagement_3690016512_23_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016512_23_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690016512_23_01_2026_detailLivraisons.png > will add file : Engagement_3690016512_23_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016512/20260123_15:30:41/Engagement_3690016512_23_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690016512_23_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = aY25pqheFB3qJTn5XNuxEm3FcCFyTp81DURJZCmiQB6MkNBY2dyaRvVbAJujSJOL nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = pharmacie.de.ceyzeriat@orange.fr,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016512 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.de.ceyzeriat@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 14:09:59 - dirToStoreZip = ../../files/bdc/zippedFiles/3690036325 _________ Destinataires _________ to : pharmacie.rives@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmacie.rives@gmail.com not addCC : pharmacie.rives@gmail.com addCC : melanie.ribeiro@roche.com whiteList = pharmacie.rives@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690036325/20260123_14:09:59/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690036325/20260123_14:09:59 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690036325_23_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690036325_23_01_2026.xml fileNameToSend = Engagement_3690036325_23_01_2026_detailLivraisons.png fileNameToSend = rib.pdf fileNameToSend = sepa.pdf fileToBeAdded = 5 nbFilesToSend = 7 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = BDC-engagement_3690036325_23_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690036325_23_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690036325_23_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690036325_23_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690036325_23_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690036325_23_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690036325/20260123_14:09:59/BDC_XML-engagement_3690036325_23_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690036325_23_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690036325_23_01_2026_detailLivraisons.png > will add file : Engagement_3690036325_23_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690036325/20260123_14:09:59/Engagement_3690036325_23_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690036325_23_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = rib.pdf > will add file : rib.pdf IN : ../../files/bdc/unzippedFiles/3690036325/20260123_14:09:59/rib.pdf RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 6/ fileNameToSend = sepa.pdf *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD creating DocuSignEmail... docuSignToken = 7HmmXYNEEKLdBvAh1VfnZRtdTs4vvaDXpiUIFCdK3zwxHJovJsyI4fGajF64xeg2 nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = pharmacie.rives@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690036325 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.rives@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 13:58:51 - dirToStoreZip = ../../files/bdc/zippedFiles/3690036325 _________ Destinataires _________ to : pharmacie.rives@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmacie.rives@gmail.com not addCC : pharmacie.rives@gmail.com addCC : melanie.ribeiro@roche.com whiteList = pharmacie.rives@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690036325/20260123_13:58:51/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690036325/20260123_13:58:51 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690036325_23_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690036325_23_01_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = GjVVXFszfV0mqbZZlACPSC1gdBJOk00ImFenKeREak99AEI5zK0dkxKVfcwc3YTh nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = pharmacie.rives@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690036325 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.rives@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 08:56:06 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016512 _________ Destinataires _________ to : pharmacie.de.ceyzeriat@orange.fr cc : melanie.ribeiro@roche.com,meylan.dccommandes@roche.com emailPharma : pharmacie.de.ceyzeriat@orange.fr not addCC : pharmacie.de.ceyzeriat@orange.fr addCC : melanie.ribeiro@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmacie.de.ceyzeriat@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016512/20260123_08:56:06/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016512/20260123_08:56:06 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690016512_22-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Accu-Fine_3690016512_22-01-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690016512_22-01-2026.pdf UPDATE Users SET iPadConnexion = '2026-01-23 08:56:06' WHERE login = 'melanie.ribeiro@roche.com' > will add file : Offre-Accu-Fine_3690016512_22-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690016512/20260123_08:56:06/Offre-Accu-Fine_3690016512_22-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690016512_22-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'melanie.ribeiro@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmacie.de.ceyzeriat@orange.fr,melanie.ribeiro@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016512 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.de.ceyzeriat@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 08:55:39 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016512 _________ Destinataires _________ to : pharmacie.de.ceyzeriat@orange.fr cc : melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.de.ceyzeriat@orange.fr not addCC : pharmacie.de.ceyzeriat@orange.fr addCC : melanie.ribeiro@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.de.ceyzeriat@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016512/20260123_08:55:39/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016512/20260123_08:55:39 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690016512_22_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690016512_22_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016512_22_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690016512_22_01_2026_detailLivraisons.png > will add file : 3690016512_22_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016512/20260123_08:55:39/3690016512_22_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690016512_22_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690016512_22_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016512_22_01_2026.pdf > will add file : BDC-engagement_3690016512_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016512/20260123_08:55:39/BDC-engagement_3690016512_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690016512_22_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690016512_22_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016512_22_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016512_22_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 40 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690016512_22_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016512/20260123_08:55:39/BDC_XML-engagement_3690016512_22_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016512_22_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'melanie.ribeiro@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.de.ceyzeriat@orange.fr,melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016512 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.de.ceyzeriat@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 08:55:05 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018865 _________ Destinataires _________ to : selpharmaxine@hotmail.fr cc : melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com emailPharma : selpharmaxine@hotmail.fr not addCC : selpharmaxine@hotmail.fr addCC : melanie.ribeiro@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = selpharmaxine@hotmail.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018865/20260123_08:55:05/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018865/20260123_08:55:05 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690018865_22_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690018865_22_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690018865_22_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690018865_22_01_2026_detailLivraisons.png > will add file : 3690018865_22_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690018865/20260123_08:55:05/3690018865_22_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690018865_22_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690018865_22_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690018865_22_01_2026.pdf > will add file : BDC-engagement_3690018865_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690018865/20260123_08:55:05/BDC-engagement_3690018865_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690018865_22_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690018865_22_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690018865_22_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690018865_22_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690018865_22_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690018865/20260123_08:55:05/BDC_XML-engagement_3690018865_22_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690018865_22_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'melanie.ribeiro@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = selpharmaxine@hotmail.fr,melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690018865 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"selpharmaxine@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 08:54:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690033973 _________ Destinataires _________ to : commande.croixblanche@hellopharmacie.com cc : meylan.contratutilisateur@roche.com emailPharma : commande.croixblanche@hellopharmacie.com not addCC : commande.croixblanche@hellopharmacie.com addCC : meylan.contratutilisateur@roche.com whiteList = commande.croixblanche@hellopharmacie.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690033973' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690032372 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690033973/20260123_08:54:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690033973/20260123_08:54:50 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690033973_22_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690033973_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690033973_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690033973/20260123_08:54:50/Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690033973_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690033973_22_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = commande.croixblanche@hellopharmacie.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690033973 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"commande.croixblanche@hellopharmacie.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-20 13:37:37 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016512 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016512/20260120_13:37:37/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016512/20260120_13:37:37 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = photo1.png fileNameToSend = photo2.png fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . ********* Support email ********** . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. ********* Support email ********** .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = photo1.png ********* Support email ********** photo1.png > will add file : photo1.png IN : ../../files/bdc/unzippedFiles/3690016512/20260120_13:37:37/photo1.png File not kbis & not rib PNG détecté *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = photo2.png ********* Support email ********** photo2.png > will add file : photo2.png IN : ../../files/bdc/unzippedFiles/3690016512/20260120_13:37:37/photo2.png File not kbis & not rib PNG détecté *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 3 dest = 'lyon.rochedc.pharmavisite@sqli.com' dest = 'melanie.ribeiro@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,melanie.ribeiro@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 16:52:13 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012784 _________ Destinataires _________ to : clement.icard@hellopharmacie.com cc : meylan.contratutilisateur@roche.com emailPharma : commande.artemare@hellopharmacie.com not addCC : clement.icard@hellopharmacie.com addCC : meylan.contratutilisateur@roche.com whiteList = clement.icard@hellopharmacie.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690012784' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690032372 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012784/20260119_16:52:13/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012784/20260119_16:52:13 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690012784_19_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690012784_19_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690012784_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012784/20260119_16:52:13/Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690012784_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690012784_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = clement.icard@hellopharmacie.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012784 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"clement.icard@hellopharmacie.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-16 13:59:13 - dirToStoreZip = ../../files/bdc/zippedFiles/3690037334 _________ Destinataires _________ to : pharmaciedubourg.moirans@gmail.com cc : melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedubourg.moirans@gmail.com not addCC : pharmaciedubourg.moirans@gmail.com addCC : melanie.ribeiro@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedubourg.moirans@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690037334/20260116_13:59:13/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:13 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690037334_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690037334_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690037334_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690037334_15_01_2026_detailLivraisons.png > will add file : 3690037334_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:13/3690037334_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690037334_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690037334_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690037334_15_01_2026.pdf > will add file : BDC-engagement_3690037334_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:13/BDC-engagement_3690037334_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690037334_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690037334_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690037334_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690037334_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690037334_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:13/BDC_XML-engagement_3690037334_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690037334_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'melanie.ribeiro@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedubourg.moirans@gmail.com,melanie.ribeiro@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690037334 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedubourg.moirans@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-16 13:59:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690037334 _________ Destinataires _________ to : pharmaciedubourg.moirans@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedubourg.moirans@gmail.com not addCC : pharmaciedubourg.moirans@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedubourg.moirans@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690037334' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690782470 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690037334/20260116_13:59:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690037334_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690037334_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SAS-PHARMA-UPP_3690037334_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690037334/20260116_13:59:00/Contrat_utilisateur_SAS-PHARMA-UPP_3690037334_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SAS-PHARMA-UPP_3690037334_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = pharmaciedubourg.moirans@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690037334 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedubourg.moirans@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 16:48:51 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038334 _________ Destinataires _________ to : lapharmaciedugrandlemps@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmaciedgl@perso.alliadis.net not addCC : lapharmaciedugrandlemps@gmail.com addCC : melanie.ribeiro@roche.com whiteList = lapharmaciedugrandlemps@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038334/20260115_16:48:51/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038334/20260115_16:48:51 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690038334_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690038334_15_01_2026.xml fileNameToSend = Engagement_3690038334_15_01_2026_detailLivraisons.png fileNameToSend = sepa.pdf fileToBeAdded = 4 nbFilesToSend = 6 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = BDC-engagement_3690038334_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690038334_15_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690038334_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690038334_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690038334_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 30 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690038334_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690038334/20260115_16:48:51/BDC_XML-engagement_3690038334_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690038334_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690038334_15_01_2026_detailLivraisons.png > will add file : Engagement_3690038334_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690038334/20260115_16:48:51/Engagement_3690038334_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690038334_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = sepa.pdf *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = Vz8EsuSIChHOEe64V60hIIJrfFXjXFMmzMQlU6QkwZm9YTEFHC4r3jakPxJE5biy nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = lapharmaciedugrandlemps@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038334 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"lapharmaciedugrandlemps@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 16:43:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038334 _________ Destinataires _________ to : lapharmaciedugrandlemps@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmaciedgl@perso.alliadis.net not addCC : lapharmaciedugrandlemps@gmail.com addCC : melanie.ribeiro@roche.com whiteList = lapharmaciedugrandlemps@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038334/20260115_16:43:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038334/20260115_16:43:50 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690038334_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690038334_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = KFnKlbOL0kyMoaK0OxFtnNlAS9inwuFZN2sIw5gDchBmrHYwTtq769TcMrkR5vNY nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = lapharmaciedugrandlemps@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038334 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"lapharmaciedugrandlemps@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 16:43:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038334 _________ Destinataires _________ to : lagrandepharmaciedugrandlemps@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmaciedgl@perso.alliadis.net not addCC : lagrandepharmaciedugrandlemps@gmail.com addCC : melanie.ribeiro@roche.com whiteList = lagrandepharmaciedugrandlemps@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038334/20260115_16:43:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038334/20260115_16:43:01 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690038334_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SAS-PHARMA-UPP_3690038334_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = 97LejN5Pq5ChUEd1hAqfeWRbTTOy67EIywnknmMJ6k6Dh36drBoFCAb7TF0D7SIu nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = lagrandepharmaciedugrandlemps@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038334 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"lagrandepharmaciedugrandlemps@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 11:22:05 - dirToStoreZip = ../../files/bdc/zippedFiles/3690036326 _________ Destinataires _________ to : commande.pharmaciederives@hellopharmacie.com cc : meylan.contratutilisateur@roche.com emailPharma : commande.pharmaciederives@hellopharmacie.com not addCC : commande.pharmaciederives@hellopharmacie.com addCC : meylan.contratutilisateur@roche.com whiteList = commande.pharmaciederives@hellopharmacie.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690036326' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690032372 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690036326/20260115_11:22:05/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690036326/20260115_11:22:05 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690036326_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690036326_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690036326_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690036326/20260115_11:22:05/Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690036326_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690036326_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = commande.pharmaciederives@hellopharmacie.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690036326 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"commande.pharmaciederives@hellopharmacie.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-13 15:57:29 - dirToStoreZip = ../../files/bdc/zippedFiles/3690019241 _________ Destinataires _________ to : grandepharmaciedulac@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : grandepharmaciedulac@gmail.com not addCC : grandepharmaciedulac@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = grandepharmaciedulac@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690019241' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690032372 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690019241/20260113_15:57:29/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690019241/20260113_15:57:29 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690019241_13_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690019241_13_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690019241_13_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690019241/20260113_15:57:29/Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690019241_13_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_HELLO-PHARMACIE---RHONE-VALLEE-PHARMACIE_3690019241_13_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = grandepharmaciedulac@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690019241 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"grandepharmaciedulac@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 13:59:10 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013942 _________ Destinataires _________ to : pharmacie.leperrier@gmail.com cc : melanie.ribeiro@roche.com emailPharma : pharmacie.leperrier@gmail.com not addCC : pharmacie.leperrier@gmail.com addCC : melanie.ribeiro@roche.com whiteList = pharmacie.leperrier@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013942/20260108_13:59:10/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013942/20260108_13:59:10 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SUPRAPHARM_3690013942_08_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SUPRAPHARM_3690013942_08_01_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = 7eADZDkwsU2odP6vTQ0dIamuBpIh4x4IHEtmSmW7L5uvwMh03LCYGESXMDZ9T6uk nbRecipient = 1 dest = 'melanie.ribeiro@roche.com' whiteList = pharmacie.leperrier@gmail.com,melanie.ribeiro@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690013942 signWithDocuSign = 1 attachmentToSign = 1 isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.leperrier@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-01-08 13:59:10 ########## --------- 2026-01-08 13:59:10 --------- - [getLogfile] suffixe = storeFile delegueEmail = melanie.ribeiro@roche.com ##################################################