//============================= v.635 ========================================= - 2026-06-11 15:17:12 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032259 _________ Destinataires _________ to : orsolle@yahoo.fr cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : orsolle@yahoo.fr not addCC : orsolle@yahoo.fr addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = orsolle@yahoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032259/20260611_15:17:12/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032259/20260611_15:17:12 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690032259 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690032259_11-06-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_3690032259_11-06-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690032259_11-06-2026.pdf UPDATE Users SET iPadConnexion = '2026-06-11 15:17:12' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690032259_11-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690032259/20260611_15:17:12/Offre-Accu-Fine_3690032259_11-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690032259_11-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = orsolle@yahoo.fr,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690032259 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"orsolle@yahoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-11 12:03:25 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012569 _________ Destinataires _________ to : pharmaciedesfees91700@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedesfees91700@gmail.com not addCC : pharmaciedesfees91700@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedesfees91700@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012569/20260611_12:03:25/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012569/20260611_12:03:25 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690012569 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690012569_11-06-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_3690012569_11-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690012569_11-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690012569', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-11 12:03:25') > will add file : Offre-Speciale-Accu-check_3690012569_11-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690012569/20260611_12:03:25/Offre-Speciale-Accu-check_3690012569_11-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690012569_11-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciedesfees91700@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012569 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedesfees91700@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-11 12:03:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025837 _________ Destinataires _________ to : pharmaciedelapyramide@wanadoo.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedelapyramide@wanadoo.fr not addCC : pharmaciedelapyramide@wanadoo.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedelapyramide@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025837/20260611_12:03:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025837/20260611_12:03:16 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690025837 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690025837_11-06-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_3690025837_11-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690025837_11-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690025837', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-11 12:03:17') > will add file : Offre-Speciale-Accu-check_3690025837_11-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690025837/20260611_12:03:16/Offre-Speciale-Accu-check_3690025837_11-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690025837_11-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciedelapyramide@wanadoo.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690025837 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelapyramide@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-11 12:03:11 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032708 _________ Destinataires _________ to : pharmaciedelamairie@laposte.net cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedelamairie@laposte.net not addCC : pharmaciedelamairie@laposte.net addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedelamairie@laposte.net __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032708' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042094 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032708/20260611_12:03:11/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032708/20260611_12:03:11 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690032708 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_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_3690032708_11_06_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032708/20260611_12:03:11/Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_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 = pharmaciedelamairie@laposte.net,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690032708 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelamairie@laposte.net"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-11 12:03:06 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032708 _________ Destinataires _________ to : pharmaciedelamairie@laposte.net cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedelamairie@laposte.net not addCC : pharmaciedelamairie@laposte.net addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedelamairie@laposte.net __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032708' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042094 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032708/20260611_12:03:06/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032708/20260611_12:03:06 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690032708 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_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_3690032708_11_06_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032708/20260611_12:03:06/Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMAVANCE-GROUPEMENT_3690032708_11_06_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 = pharmaciedelamairie@laposte.net,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690032708 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelamairie@laposte.net"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-10 19:29:21 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018996 _________ Destinataires _________ to : pharmaciemariestuart@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmaciemariestuart@gmail.com not addCC : pharmaciemariestuart@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmaciemariestuart@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018996/20260610_19:29:21/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018996/20260610_19:29:21 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690018996 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_ELSIE-GROUPE_3690018996_10_06_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_ELSIE-GROUPE_3690018996_10_06_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 = bDXqejOa9qX1tYBqZ6gasz2l3jbVGb47dgFxAK5DzeKdjUuQBjYOCBwHLsz5oA5Y nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciemariestuart@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690018996 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciemariestuart@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-10 14:15:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690027707 _________ Destinataires _________ to : pharma.tomasino@live.fr cc : valentin.delinde@roche.com emailPharma : pharma.tomasino@live.fr not addCC : pharma.tomasino@live.fr addCC : valentin.delinde@roche.com whiteList = pharma.tomasino@live.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690027707/20260610_14:15:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690027707/20260610_14:15:45 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690027707 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690027707_10_06_2026.pdf fileNameToSend = BDC_XML-engagement_3690027707_10_06_2026.xml fileNameToSend = Engagement_3690027707_10_06_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_3690027707_10_06_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690027707_10_06_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690027707_10_06_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690027707_10_06_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690027707_10_06_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS palierXml = BRONZE-AF1 will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690027707_10_06_2026.xml IN : ../../files/bdc/unzippedFiles/3690027707/20260610_14:15:45/BDC_XML-engagement_3690027707_10_06_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690027707_10_06_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690027707_10_06_2026_detailLivraisons.png > will add file : Engagement_3690027707_10_06_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690027707/20260610_14:15:45/Engagement_3690027707_10_06_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690027707_10_06_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = gkAd2fMJmEfTBI3knuzJAJhOS5pI8px4buIdXglGVKr4ZgtbWukDXUu87228bvqq nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharma.tomasino@live.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690027707 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharma.tomasino@live.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-10 07:55:43 - dirToStoreZip = ../../files/bdc/zippedFiles/3690017760 _________ Destinataires _________ to : pharmacieplaine94@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmacie.plaine@live.fr not addCC : pharmacieplaine94@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmacieplaine94@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690017760/20260610_07:55:43/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690017760/20260610_07:55:43 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690017760 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_NEOPHARM_3690017760_10_06_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_NEOPHARM_3690017760_10_06_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 = tVtHmFhRiZT9wqnOyHQ3nqdkrpTljl3PDUhrzx2LH4XFjML1RqAkkJm2cp4LvLtd nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacieplaine94@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690017760 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieplaine94@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-09 20:35:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690030795 _________ Destinataires _________ to : pharmadesgarennes@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmadesgarennes@gmail.com not addCC : pharmadesgarennes@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmadesgarennes@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690030795/20260609_20:35:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690030795/20260609_20:35:09 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690030795 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690030795_09-06-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_3690030795_09-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690030795_09-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690030795', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-09 20:35:09') > will add file : Offre-Speciale-Accu-check_3690030795_09-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690030795/20260609_20:35:09/Offre-Speciale-Accu-check_3690030795_09-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690030795_09-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmadesgarennes@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690030795 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadesgarennes@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-09 14:14:33 - dirToStoreZip = ../../files/bdc/zippedFiles/3690027716 _________ Destinataires _________ to : pharmaciedelacerisaie@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedelacerisaie@gmail.com not addCC : pharmaciedelacerisaie@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedelacerisaie@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690027716' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690564471 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690027716/20260609_14:14:33/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690027716/20260609_14:14:33 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690027716 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GIROPHARM_3690027716_09_06_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_3690027716_09_06_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GIROPHARM_3690027716_09_06_2026.pdf IN : ../../files/bdc/unzippedFiles/3690027716/20260609_14:14:33/Contrat_utilisateur_GIROPHARM_3690027716_09_06_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GIROPHARM_3690027716_09_06_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 = pharmaciedelacerisaie@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690027716 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelacerisaie@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-08 16:06:52 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029517 _________ Destinataires _________ to : pharmacie.attal@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmacie.attal@gmail.com not addCC : pharmacie.attal@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmacie.attal@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029517/20260608_16:06:52/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029517/20260608_16:06:52 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690029517 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690029517_08_06_2026.pdf fileNameToSend = BDC_XML-engagement_3690029517_08_06_2026.xml fileNameToSend = Engagement_3690029517_08_06_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_3690029517_08_06_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690029517_08_06_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690029517_08_06_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690029517_08_06_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690029517_08_06_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS palierXml = OR-AF1 will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 30 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690029517_08_06_2026.xml IN : ../../files/bdc/unzippedFiles/3690029517/20260608_16:06:52/BDC_XML-engagement_3690029517_08_06_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690029517_08_06_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690029517_08_06_2026_detailLivraisons.png > will add file : Engagement_3690029517_08_06_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690029517/20260608_16:06:52/Engagement_3690029517_08_06_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690029517_08_06_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 1ckufta6zO3YcUekQuQV4jd3CyQZxNJUGECT9GhaPc3A6yagyTo5aiOZa0WJoTmc nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacie.attal@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690029517 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.attal@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-08 13:24:24 - dirToStoreZip = ../../files/bdc/zippedFiles/3690028117 _________ Destinataires _________ to : pharmasanteclamart@gmail.com cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : pharmasanteclamart@gmail.com not addCC : pharmasanteclamart@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmasanteclamart@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690028117/20260608_13:24:24/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690028117/20260608_13:24:24 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690028117 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690028117_08-06-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_3690028117_08-06-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690028117_08-06-2026.pdf UPDATE Users SET iPadConnexion = '2026-06-08 13:24:24' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690028117_08-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690028117/20260608_13:24:24/Offre-Accu-Fine_3690028117_08-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690028117_08-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmasanteclamart@gmail.com,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690028117 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmasanteclamart@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-08 13:24:19 - dirToStoreZip = ../../files/bdc/zippedFiles/3690028117 _________ Destinataires _________ to : pharmasanteclamart@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmasanteclamart@gmail.com not addCC : pharmasanteclamart@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmasanteclamart@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690028117/20260608_13:24:19/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690028117/20260608_13:24:19 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690028117 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690028117_08-06-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_3690028117_08-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690028117_08-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690028117', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-08 13:24:19') > will add file : Offre-Speciale-Accu-check_3690028117_08-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690028117/20260608_13:24:19/Offre-Speciale-Accu-check_3690028117_08-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690028117_08-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmasanteclamart@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690028117 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmasanteclamart@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-08 13:24:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018699 _________ Destinataires _________ to : pharmacie78.cherif@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie78.cherif@gmail.com not addCC : pharmacie78.cherif@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie78.cherif@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018699/20260608_13:24:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018699/20260608_13:24:16 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690018699 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690018699_08-06-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_3690018699_08-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690018699_08-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690018699', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-08 13:24:16') > will add file : Offre-Speciale-Accu-check_3690018699_08-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690018699/20260608_13:24:16/Offre-Speciale-Accu-check_3690018699_08-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690018699_08-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacie78.cherif@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690018699 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie78.cherif@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-08 13:24:07 - dirToStoreZip = ../../files/bdc/zippedFiles/3690033964 _________ Destinataires _________ to : pharmacieducentre.trappes@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacieducentre.trappes@gmail.com not addCC : pharmacieducentre.trappes@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacieducentre.trappes@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690033964/20260608_13:24:07/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690033964/20260608_13:24:07 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690033964 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690033964_08-06-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_3690033964_08-06-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690033964_08-06-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690033964', 'valentin.delinde@roche.com', 'offreSpeciale', '--', '2026-06-08 13:24:07') > will add file : Offre-Speciale-Accu-check_3690033964_08-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690033964/20260608_13:24:07/Offre-Speciale-Accu-check_3690033964_08-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690033964_08-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacieducentre.trappes@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690033964 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieducentre.trappes@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-03 13:04:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013227 _________ Destinataires _________ to : tbl94@hotmail.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : tbl94@hotmail.fr not addCC : tbl94@hotmail.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = tbl94@hotmail.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013227/20260603_13:04:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013227/20260603_13:04:50 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690013227 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690013227_03_06_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690013227_03_06_2026.pdf fileNameToSend = BDC_XML-engagement_3690013227_03_06_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 = 3690013227_03_06_2026_detailLivraisons.png > will add file : 3690013227_03_06_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690013227/20260603_13:04:50/3690013227_03_06_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690013227_03_06_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690013227_03_06_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690013227_03_06_2026.pdf > will add file : BDC-engagement_3690013227_03_06_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013227/20260603_13:04:50/BDC-engagement_3690013227_03_06_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690013227_03_06_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690013227_03_06_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690013227_03_06_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690013227_03_06_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS palierXml = BRONZE-AF1 will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690013227_03_06_2026.xml IN : ../../files/bdc/unzippedFiles/3690013227/20260603_13:04:50/BDC_XML-engagement_3690013227_03_06_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690013227_03_06_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = tbl94@hotmail.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013227 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"tbl94@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-03 13:04:42 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018917 _________ Destinataires _________ to : pharmaciedelapaix@wanadoo.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedelapaix@wanadoo.fr not addCC : pharmaciedelapaix@wanadoo.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedelapaix@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018917/20260603_13:04:42/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018917/20260603_13:04:42 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690018917 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690018917_03_06_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690018917_03_06_2026.pdf fileNameToSend = BDC_XML-engagement_3690018917_03_06_2026.xml fileNameToSend = CPV-EXCLUSIF_3690018917.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 = 3690018917_03_06_2026_detailLivraisons.png > will add file : 3690018917_03_06_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690018917/20260603_13:04:42/3690018917_03_06_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690018917_03_06_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690018917_03_06_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690018917_03_06_2026.pdf > will add file : BDC-engagement_3690018917_03_06_2026.pdf IN : ../../files/bdc/unzippedFiles/3690018917/20260603_13:04:42/BDC-engagement_3690018917_03_06_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690018917_03_06_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690018917_03_06_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690018917_03_06_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690018917_03_06_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS palierXml = VIP-AF1 will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 100 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690018917_03_06_2026.xml IN : ../../files/bdc/unzippedFiles/3690018917/20260603_13:04:42/BDC_XML-engagement_3690018917_03_06_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690018917_03_06_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = CPV-EXCLUSIF_3690018917.pdf ********* CPV ********** -- CPV 2025 detected -- -- query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690018917', 'valentin.delinde@roche.com', '2026-06-03 13:04:46', 250, 1500, 550, '35.3', 90, '23', 1 ) > will add file : CPV-EXCLUSIF_3690018917.pdf IN : ../../files/bdc/unzippedFiles/3690018917/20260603_13:04:42/CPV-EXCLUSIF_3690018917.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : CPV-EXCLUSIF_3690018917.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedelapaix@wanadoo.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690018917 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelapaix@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-02 15:13:03 - dirToStoreZip = ../../files/bdc/zippedFiles/3690026755 _________ Destinataires _________ to : pharmaciedurondpoint91@gmail.com cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : pharmaciedurondpoint91@gmail.com not addCC : pharmaciedurondpoint91@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmaciedurondpoint91@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690026755/20260602_15:13:03/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690026755/20260602_15:13:03 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690026755 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690026755_02-06-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_3690026755_02-06-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690026755_02-06-2026.pdf UPDATE Users SET iPadConnexion = '2026-06-02 15:13:03' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690026755_02-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690026755/20260602_15:13:03/Offre-Accu-Fine_3690026755_02-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690026755_02-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmaciedurondpoint91@gmail.com,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690026755 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedurondpoint91@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.635 ========================================= - 2026-06-01 15:33:51 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025790 _________ Destinataires _________ to : pharmacielv7m@gmail.com cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : pharmacielv7m@gmail.com not addCC : pharmacielv7m@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmacielv7m@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025790/20260601_15:33:51/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025790/20260601_15:33:51 is NOT Pharma Beta... is NOT Pharma ROC... - Renaming RIB and KBIS files with pharma number prefix : 3690025790 ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690025790_01-06-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_3690025790_01-06-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690025790_01-06-2026.pdf UPDATE Users SET iPadConnexion = '2026-06-01 15:33:51' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690025790_01-06-2026.pdf IN : ../../files/bdc/unzippedFiles/3690025790/20260601_15:33:51/Offre-Accu-Fine_3690025790_01-06-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690025790_01-06-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmacielv7m@gmail.com,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690025790 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacielv7m@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-06-01 15:33:51 ########## --------- 2026-06-01 15:33:51 --------- - [getLogfile] suffixe = storeFile delegueEmail = valentin.delinde@roche.com ##################################################