//============================= v.634 ========================================= - 2026-04-02 16:52:31 - dirToStoreZip = ../../files/bdc/zippedFiles/3690019572 _________ Destinataires _________ to : pharmaciedewesthoffen@gmail.com cc : benoit.joly@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedewesthoffen@gmail.com not addCC : pharmaciedewesthoffen@gmail.com addCC : benoit.joly@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedewesthoffen@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690019572/20260402_16:52:31/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:31 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690019572_02_04_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690019572_02_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690019572_02_04_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 = 3690019572_02_04_2026_detailLivraisons.png > will add file : 3690019572_02_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:31/3690019572_02_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690019572_02_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690019572_02_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690019572_02_04_2026.pdf > will add file : BDC-engagement_3690019572_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:31/BDC-engagement_3690019572_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690019572_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690019572_02_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690019572_02_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690019572_02_04_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690019572_02_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:31/BDC_XML-engagement_3690019572_02_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690019572_02_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'benoit.joly@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedewesthoffen@gmail.com,benoit.joly@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690019572 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedewesthoffen@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-02 16:52:23 - dirToStoreZip = ../../files/bdc/zippedFiles/3690019572 _________ Destinataires _________ to : pharmaciedewesthoffen@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedewesthoffen@gmail.com not addCC : pharmaciedewesthoffen@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedewesthoffen@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690019572' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690564471 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690019572/20260402_16:52:23/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:23 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GIROPHARM_3690019572_02_04_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_GIROPHARM_3690019572_02_04_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GIROPHARM_3690019572_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690019572/20260402_16:52:23/Contrat_utilisateur_GIROPHARM_3690019572_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GIROPHARM_3690019572_02_04_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 = pharmaciedewesthoffen@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690019572 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedewesthoffen@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 14:42:27 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013002 _________ Destinataires _________ to : saintmauricepharmacie@gmail.com cc : benoit.joly@roche.com emailPharma : saintmauricepharmacie@gmail.com not addCC : saintmauricepharmacie@gmail.com addCC : benoit.joly@roche.com whiteList = saintmauricepharmacie@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013002/20260402_14:42:27/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013002/20260402_14:42:27 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690013002_02_04_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_PHARMAVANCE-GROUPEMENT_3690013002_02_04_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 = oLS3BBRlMWP1ISH2M946fIDXiEIUmplxC8yXLtr0sThTQv1zcjEY5nHcWz6lBRBd nbRecipient = 1 dest = 'benoit.joly@roche.com' whiteList = saintmauricepharmacie@gmail.com,benoit.joly@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013002 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"saintmauricepharmacie@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 14:32:27 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012117 _________ Destinataires _________ to : pharmacie.balzac67@orange.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.balzac67@orange.fr not addCC : pharmacie.balzac67@orange.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmacie.balzac67@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690012117' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085520 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012117/20260402_14:32:27/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:27 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_APSAGIR---EXCEL-PHARMA_3690012117_02_04_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_APSAGIR---EXCEL-PHARMA_3690012117_02_04_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_APSAGIR---EXCEL-PHARMA_3690012117_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:27/Contrat_utilisateur_APSAGIR---EXCEL-PHARMA_3690012117_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_APSAGIR---EXCEL-PHARMA_3690012117_02_04_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 = pharmacie.balzac67@orange.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012117 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.balzac67@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 14:32:21 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012117 _________ Destinataires _________ to : pharmacie.balzac67@orange.fr cc : benoit.joly@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.balzac67@orange.fr not addCC : pharmacie.balzac67@orange.fr addCC : benoit.joly@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.balzac67@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012117/20260402_14:32:21/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:21 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690012117_02-04-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-Speciale-Accu-check_3690012117_02-04-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690012117_02-04-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690012117', 'benoit.joly@roche.com', 'offreSpeciale', '--', '2026-04-02 14:32:21') > will add file : Offre-Speciale-Accu-check_3690012117_02-04-2026.pdf IN : ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:21/Offre-Speciale-Accu-check_3690012117_02-04-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690012117_02-04-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'benoit.joly@roche.com' whiteList = pharmacie.balzac67@orange.fr,benoit.joly@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012117 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.balzac67@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 14:32:08 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012117 _________ Destinataires _________ to : pharmacie.balzac67@orange.fr cc : benoit.joly@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.balzac67@orange.fr not addCC : pharmacie.balzac67@orange.fr addCC : benoit.joly@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.balzac67@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012117/20260402_14:32:08/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:08 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690012117_02_04_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690012117_02_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690012117_02_04_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 = 3690012117_02_04_2026_detailLivraisons.png > will add file : 3690012117_02_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:08/3690012117_02_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690012117_02_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690012117_02_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690012117_02_04_2026.pdf > will add file : BDC-engagement_3690012117_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:08/BDC-engagement_3690012117_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690012117_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690012117_02_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690012117_02_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690012117_02_04_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... MAD is active for this client in else nbSetGuideTotal = 45 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690012117_02_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690012117/20260402_14:32:08/BDC_XML-engagement_3690012117_02_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690012117_02_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'benoit.joly@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.balzac67@orange.fr,benoit.joly@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012117 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.balzac67@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:53:38 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016200 _________ Destinataires _________ to : pharmaciehohberg@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmahohberg@offisecure.com not addCC : pharmaciehohberg@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciehohberg@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690016200' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690782470 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016200/20260402_10:53:38/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016200/20260402_10:53:38 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-PHARM-UPP_3690016200_02_04_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-PHARM-UPP_3690016200_02_04_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SAS-PHARM-UPP_3690016200_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016200/20260402_10:53:38/Contrat_utilisateur_SAS-PHARM-UPP_3690016200_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SAS-PHARM-UPP_3690016200_02_04_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 = pharmaciehohberg@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690016200 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciehohberg@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-04-02 10:53:38 ########## --------- 2026-04-02 10:53:38 --------- - [getLogfile] suffixe = storeFile delegueEmail = benoit.joly@roche.com ##################################################