//============================= v.632 ========================================= - 2026-01-23 12:56:09 - 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/20260123_12:56:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:09 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690028117_23_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690028117_23_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690028117_23_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 = 3690028117_23_01_2026_detailLivraisons.png > will add file : 3690028117_23_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:09/3690028117_23_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690028117_23_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690028117_23_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690028117_23_01_2026.pdf > will add file : BDC-engagement_3690028117_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:09/BDC-engagement_3690028117_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690028117_23_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690028117_23_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690028117_23_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690028117_23_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 46 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690028117_23_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:09/BDC_XML-engagement_3690028117_23_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690028117_23_01_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 = pharmasanteclamart@gmail.com,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ 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.632 ========================================= - 2026-01-23 12:56:06 - dirToStoreZip = ../../files/bdc/zippedFiles/3690028117 _________ Destinataires _________ to : pharmasanteclamart@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmasanteclamart@gmail.com not addCC : pharmasanteclamart@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmasanteclamart@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690028117' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042120 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690028117/20260123_12:56:06/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:06 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_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_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:06/Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_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 = pharmasanteclamart@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ 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.632 ========================================= - 2026-01-23 12:56:02 - dirToStoreZip = ../../files/bdc/zippedFiles/3690028117 _________ Destinataires _________ to : pharmasanteclamart@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmasanteclamart@gmail.com not addCC : pharmasanteclamart@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmasanteclamart@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690028117' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042120 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690028117/20260123_12:56:02/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:02 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_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_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690028117/20260123_12:56:02/Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMA-SYNERGIE_3690028117_23_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 = pharmasanteclamart@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ 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.632 ========================================= - 2026-01-22 18:59:02 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025211 _________ Destinataires _________ to : valentin.delinde@roche.com cc : emailPharma : addCC : valentin.delinde@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025211/20260122_18:59:02/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025211/20260122_18:59:02 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.pdf fileNameToSend = rib.pdf fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** 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 = kbisUpdate.pdf > will add file : kbisUpdate.pdf IN : ../../files/bdc/unzippedFiles/3690025211/20260122_18:59:02/kbisUpdate.pdf KBIS détecté bien envoyé au siège *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = rib.pdf > will add file : rib.pdf IN : ../../files/bdc/unzippedFiles/3690025211/20260122_18:59:02/rib.pdf RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 4 dest = 'valentin.delinde@roche.com' dest = 'meylan.clients_dc@roche.com' dest = 'france.diabetescare-adv@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = valentin.delinde@roche.com,meylan.clients_dc@roche.com,france.diabetescare-adv@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025211 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"valentin.delinde@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-22 15:38:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032261 _________ Destinataires _________ to : silvia.klein@hotmail.fr cc : meylan.contratutilisateur@roche.com emailPharma : silvia.klein@hotmail.fr not addCC : silvia.klein@hotmail.fr addCC : meylan.contratutilisateur@roche.com whiteList = silvia.klein@hotmail.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032261' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690646550 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032261/20260122_15:38:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032261/20260122_15:38:45 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_ANTIKA-PHARMA_3690032261_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_ANTIKA-PHARMA_3690032261_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_ANTIKA-PHARMA_3690032261_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032261/20260122_15:38:45/Contrat_utilisateur_ANTIKA-PHARMA_3690032261_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_ANTIKA-PHARMA_3690032261_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 = silvia.klein@hotmail.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"silvia.klein@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-22 15:38:40 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032261 _________ Destinataires _________ to : silvia.klein@hotmail.fr cc : meylan.contratutilisateur@roche.com emailPharma : silvia.klein@hotmail.fr not addCC : silvia.klein@hotmail.fr addCC : meylan.contratutilisateur@roche.com whiteList = silvia.klein@hotmail.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032261' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690646550 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032261/20260122_15:38:40/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032261/20260122_15:38:40 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_ANTIKA-PHARMA_3690032261_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_ANTIKA-PHARMA_3690032261_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_ANTIKA-PHARMA_3690032261_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032261/20260122_15:38:40/Contrat_utilisateur_ANTIKA-PHARMA_3690032261_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_ANTIKA-PHARMA_3690032261_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 = silvia.klein@hotmail.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"silvia.klein@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-22 10:39:04 - dirToStoreZip = ../../files/bdc/zippedFiles/3690026760 _________ Destinataires _________ to : pharmacie.fromentin@wanadoo.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.fromentin@wanadoo.fr not addCC : pharmacie.fromentin@wanadoo.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.fromentin@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690026760/20260122_10:39:04/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690026760/20260122_10:39:04 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690026760_22_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690026760_22_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690026760_22_01_2026.xml fileNameToSend = CPV-AMB_3690026760.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 = 3690026760_22_01_2026_detailLivraisons.png > will add file : 3690026760_22_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690026760/20260122_10:39:04/3690026760_22_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690026760_22_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690026760_22_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690026760_22_01_2026.pdf > will add file : BDC-engagement_3690026760_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690026760/20260122_10:39:04/BDC-engagement_3690026760_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690026760_22_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690026760_22_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690026760_22_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690026760_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_3690026760_22_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690026760/20260122_10:39:04/BDC_XML-engagement_3690026760_22_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690026760_22_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = CPV-AMB_3690026760.pdf ********* CPV ********** -- CPV 2025 detected -- -- query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Ambassadeur', '3690026760.pdf', 'valentin.delinde@roche.com', '2026-01-22 10:39:08', 0, 150, 20, '25.9', 21, '0', 1 ) > will add file : CPV-AMB_3690026760.pdf IN : ../../files/bdc/unzippedFiles/3690026760/20260122_10:39:04/CPV-AMB_3690026760.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : CPV-AMB_3690026760.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 = pharmacie.fromentin@wanadoo.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690026760 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.fromentin@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 17:15:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016656 _________ Destinataires _________ to : valentin.delinde@roche.com cc : emailPharma : addCC : valentin.delinde@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016656/20260121_17:15:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016656/20260121_17:15:48 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.pdf fileNameToSend = rib.pdf fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** 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 = kbisUpdate.pdf > will add file : kbisUpdate.pdf IN : ../../files/bdc/unzippedFiles/3690016656/20260121_17:15:48/kbisUpdate.pdf KBIS détecté bien envoyé au siège *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = rib.pdf > will add file : rib.pdf IN : ../../files/bdc/unzippedFiles/3690016656/20260121_17:15:48/rib.pdf RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 4 dest = 'valentin.delinde@roche.com' dest = 'meylan.clients_dc@roche.com' dest = 'france.diabetescare-adv@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = valentin.delinde@roche.com,meylan.clients_dc@roche.com,france.diabetescare-adv@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016656 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"valentin.delinde@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 15:11:47 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023574 _________ Destinataires _________ to : pharmaciepc94@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciepc94@gmail.com not addCC : pharmaciepc94@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciepc94@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023574/20260121_15:11:47/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:47 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690023574_21_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690023574_21_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690023574_21_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 = 3690023574_21_01_2026_detailLivraisons.png > will add file : 3690023574_21_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:47/3690023574_21_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690023574_21_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690023574_21_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690023574_21_01_2026.pdf > will add file : BDC-engagement_3690023574_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:47/BDC-engagement_3690023574_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690023574_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690023574_21_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690023574_21_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690023574_21_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 31 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690023574_21_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:47/BDC_XML-engagement_3690023574_21_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690023574_21_01_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 = pharmaciepc94@gmail.com,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023574 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciepc94@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 15:11:43 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023574 _________ Destinataires _________ to : pharmaciepc94@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciepc94@gmail.com not addCC : pharmaciepc94@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciepc94@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690023574' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042195 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023574/20260121_15:11:43/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:43 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SUPRAPHARM_3690023574_21_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_3690023574_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SUPRAPHARM_3690023574_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690023574/20260121_15:11:43/Contrat_utilisateur_SUPRAPHARM_3690023574_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SUPRAPHARM_3690023574_21_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 = pharmaciepc94@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023574 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciepc94@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 10:40:06 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029967 _________ Destinataires _________ to : pharmacoeur92@gmail.com cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : pharmacoeur92@gmail.com not addCC : pharmacoeur92@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmacoeur92@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029967/20260121_10:40:06/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029967/20260121_10:40:06 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690029967_21-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_3690029967_21-01-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690029967_21-01-2026.pdf UPDATE Users SET iPadConnexion = '2026-01-21 10:40:06' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690029967_21-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690029967/20260121_10:40:06/Offre-Accu-Fine_3690029967_21-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690029967_21-01-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 = pharmacoeur92@gmail.com,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690029967 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacoeur92@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 10:40:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029967 _________ Destinataires _________ to : pharmacoeur92@gmail.com cc : valentin.delinde@roche.com,meylan.dccommandes@roche.com emailPharma : pharmacoeur92@gmail.com not addCC : pharmacoeur92@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmacoeur92@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029967/20260121_10:40:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029967/20260121_10:40:01 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690029967_21-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_3690029967_21-01-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690029967_21-01-2026.pdf UPDATE Users SET iPadConnexion = '2026-01-21 10:40:01' WHERE login = 'valentin.delinde@roche.com' > will add file : Offre-Accu-Fine_3690029967_21-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690029967/20260121_10:40:01/Offre-Accu-Fine_3690029967_21-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690029967_21-01-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 = pharmacoeur92@gmail.com,valentin.delinde@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690029967 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacoeur92@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 11:36:24 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025199 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025199/20260119_11:36:24/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025199/20260119_11:36:24 is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = photo1.png fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** 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/3690025199/20260119_11:36:24/photo1.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 = 'valentin.delinde@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,valentin.delinde@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = 1 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-15 16:41:43 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032237 _________ Destinataires _________ to : valentin.delinde@roche.com cc : emailPharma : addCC : valentin.delinde@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032237/20260115_16:41:43/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032237/20260115_16:41:43 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.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 = kbisUpdate.pdf > will add file : kbisUpdate.pdf IN : ../../files/bdc/unzippedFiles/3690032237/20260115_16:41:43/kbisUpdate.pdf KBIS détecté bien envoyé au siège *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 3 dest = 'meylan.clients_dc@roche.com' dest = 'meylan.dccommandes@roche.com' dest = 'valentin.delinde@roche.com' whiteList = meylan.clients_dc@roche.com,meylan.dccommandes@roche.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032237 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"valentin.delinde@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 14:11:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029968 _________ Destinataires _________ to : pharmacieprincipalesevres@hotmail.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacieprincipalesevres@hotmail.fr not addCC : pharmacieprincipalesevres@hotmail.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacieprincipalesevres@hotmail.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029968/20260115_14:11:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:45 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690029968_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690029968_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690029968_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 = 3690029968_15_01_2026_detailLivraisons.png > will add file : 3690029968_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:45/3690029968_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690029968_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690029968_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690029968_15_01_2026.pdf > will add file : BDC-engagement_3690029968_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:45/BDC-engagement_3690029968_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690029968_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690029968_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690029968_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690029968_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = -1 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690029968_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:45/BDC_XML-engagement_3690029968_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690029968_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 = 'valentin.delinde@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacieprincipalesevres@hotmail.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690029968 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieprincipalesevres@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 14:11:39 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029968 _________ Destinataires _________ to : pharmacieprincipalesevres@hotmail.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmacieprincipalesevres@hotmail.fr not addCC : pharmacieprincipalesevres@hotmail.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmacieprincipalesevres@hotmail.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690029968' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042195 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029968/20260115_14:11:39/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:39 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SUPRAPHARM_3690029968_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_SUPRAPHARM_3690029968_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SUPRAPHARM_3690029968_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690029968/20260115_14:11:39/Contrat_utilisateur_SUPRAPHARM_3690029968_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SUPRAPHARM_3690029968_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 = pharmacieprincipalesevres@hotmail.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690029968 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieprincipalesevres@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 11:35:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032253 _________ Destinataires _________ to : pharmaciesaintmartin@hotmail.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciesaintmartin@hotmail.fr not addCC : pharmaciesaintmartin@hotmail.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciesaintmartin@hotmail.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032253/20260115_11:35:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:16 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690032253_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690032253_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690032253_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 = 3690032253_15_01_2026_detailLivraisons.png > will add file : 3690032253_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:16/3690032253_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690032253_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690032253_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690032253_15_01_2026.pdf > will add file : BDC-engagement_3690032253_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:16/BDC-engagement_3690032253_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690032253_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690032253_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690032253_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690032253_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 5 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690032253_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:16/BDC_XML-engagement_3690032253_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690032253_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 = 'valentin.delinde@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciesaintmartin@hotmail.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032253 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciesaintmartin@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 11:35:12 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032253 _________ Destinataires _________ to : pharmaciesaintmartin@hotmail.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciesaintmartin@hotmail.fr not addCC : pharmaciesaintmartin@hotmail.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciesaintmartin@hotmail.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032253' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690719793 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032253/20260115_11:35:12/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:12 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_WE-PHARMA_3690032253_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_WE-PHARMA_3690032253_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_WE-PHARMA_3690032253_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:12/Contrat_utilisateur_WE-PHARMA_3690032253_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_WE-PHARMA_3690032253_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 = pharmaciesaintmartin@hotmail.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032253 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciesaintmartin@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 11:35:04 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032253 _________ Destinataires _________ to : pharmaciesaintmartin@hotmail.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciesaintmartin@hotmail.fr not addCC : pharmaciesaintmartin@hotmail.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciesaintmartin@hotmail.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690032253' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690719793 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032253/20260115_11:35:04/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:04 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_WE-PHARMA_3690032253_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_WE-PHARMA_3690032253_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_WE-PHARMA_3690032253_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032253/20260115_11:35:04/Contrat_utilisateur_WE-PHARMA_3690032253_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_WE-PHARMA_3690032253_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 = pharmaciesaintmartin@hotmail.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032253 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciesaintmartin@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-13 11:23:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690027725 _________ Destinataires _________ to : pharmacie.ravanel@caramail.com cc : valentin.delinde@roche.com emailPharma : pharmacie.ravanel@caramail.com not addCC : pharmacie.ravanel@caramail.com addCC : valentin.delinde@roche.com whiteList = pharmacie.ravanel@caramail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690027725/20260113_11:23:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690027725/20260113_11:23:48 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690027725_13_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690027725_13_01_2026.xml fileNameToSend = Engagement_3690027725_13_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_3690027725_13_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690027725_13_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690027725_13_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690027725_13_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690027725_13_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 51 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690027725_13_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690027725/20260113_11:23:48/BDC_XML-engagement_3690027725_13_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690027725_13_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690027725_13_01_2026_detailLivraisons.png > will add file : Engagement_3690027725_13_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690027725/20260113_11:23:48/Engagement_3690027725_13_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690027725_13_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 = ID4883YSQmH2TldNHgCMNPVtnH4Onccjj9ovj1PoDe9tGF5bMRfmGVppViLJHcee nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacie.ravanel@caramail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690027725 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.ravanel@caramail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-13 10:48:11 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025846 _________ Destinataires _________ to : misan579@outlook.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : misan579@outlook.fr not addCC : misan579@outlook.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = misan579@outlook.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025846/20260113_10:48:11/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025846/20260113_10:48:11 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690025846_13_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690025846_13_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690025846_13_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 = 3690025846_13_01_2026_detailLivraisons.png > will add file : 3690025846_13_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690025846/20260113_10:48:11/3690025846_13_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690025846_13_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690025846_13_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690025846_13_01_2026.pdf > will add file : BDC-engagement_3690025846_13_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025846/20260113_10:48:11/BDC-engagement_3690025846_13_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690025846_13_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690025846_13_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690025846_13_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690025846_13_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 6 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690025846_13_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690025846/20260113_10:48:11/BDC_XML-engagement_3690025846_13_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690025846_13_01_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 = misan579@outlook.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025846 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"misan579@outlook.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-12 16:58:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029989 _________ Destinataires _________ to : marc.berthelot971@orange.fr cc : valentin.delinde@roche.com emailPharma : marc.berthelot971@orange.fr not addCC : marc.berthelot971@orange.fr addCC : valentin.delinde@roche.com whiteList = marc.berthelot971@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029989/20260112_16:58:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029989/20260112_16:58:50 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690029989_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690029989_12_01_2026.xml fileNameToSend = Engagement_3690029989_12_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_3690029989_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690029989_12_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690029989_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690029989_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690029989_12_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_3690029989_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690029989/20260112_16:58:50/BDC_XML-engagement_3690029989_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690029989_12_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690029989_12_01_2026_detailLivraisons.png > will add file : Engagement_3690029989_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690029989/20260112_16:58:50/Engagement_3690029989_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690029989_12_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 = wI3tmEzpHB0onKsH1o6tdcQLJK2w9kw5lN0odpsReipnkdMSOFuse23rGE9STIti nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = marc.berthelot971@orange.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690029989 signWithDocuSign = 1 attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"marc.berthelot971@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 15:16:37 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029989 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029989/20260112_15:16:37/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029989/20260112_15:16:37 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = photo1.png fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** 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/3690029989/20260112_15:16:37/photo1.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 = 'valentin.delinde@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,valentin.delinde@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = 1 attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 15:05:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013570 _________ Destinataires _________ to : pharmacieesplanade@yahoo.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacieesplanade@yahoo.com not addCC : pharmacieesplanade@yahoo.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacieesplanade@yahoo.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013570/20260112_15:05:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:48 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690013570_12_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690013570_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690013570_12_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 = 3690013570_12_01_2026_detailLivraisons.png > will add file : 3690013570_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:48/3690013570_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690013570_12_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690013570_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690013570_12_01_2026.pdf > will add file : BDC-engagement_3690013570_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:48/BDC-engagement_3690013570_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690013570_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690013570_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690013570_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690013570_12_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_3690013570_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:48/BDC_XML-engagement_3690013570_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690013570_12_01_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 = pharmacieesplanade@yahoo.com,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690013570 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieesplanade@yahoo.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 15:05:40 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013570 _________ Destinataires _________ to : pharmacieesplanade@yahoo.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacieesplanade@yahoo.com not addCC : pharmacieesplanade@yahoo.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmacieesplanade@yahoo.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690013570' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041541 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013570/20260112_15:05:40/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:40 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_NEXTYPHARM_3690013570_12_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_NEXTYPHARM_3690013570_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_NEXTYPHARM_3690013570_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:40/Contrat_utilisateur_NEXTYPHARM_3690013570_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_NEXTYPHARM_3690013570_12_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 = pharmacieesplanade@yahoo.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690013570 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieesplanade@yahoo.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 15:05:32 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013570 _________ Destinataires _________ to : pharmacieesplanade@yahoo.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacieesplanade@yahoo.com not addCC : pharmacieesplanade@yahoo.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmacieesplanade@yahoo.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690013570' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041541 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013570/20260112_15:05:32/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:32 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_NEXTYPHARM_3690013570_12_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_NEXTYPHARM_3690013570_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_NEXTYPHARM_3690013570_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013570/20260112_15:05:32/Contrat_utilisateur_NEXTYPHARM_3690013570_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_NEXTYPHARM_3690013570_12_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 = pharmacieesplanade@yahoo.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690013570 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieesplanade@yahoo.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 13:49:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690026477 _________ Destinataires _________ to : contact.pharmaciedeprovence@gmail.com cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : contact.pharmaciedeprovence@gmail.com not addCC : contact.pharmaciedeprovence@gmail.com addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = contact.pharmaciedeprovence@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690026477/20260112_13:49:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690026477/20260112_13:49:01 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690026477_12_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690026477_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690026477_12_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 = 3690026477_12_01_2026_detailLivraisons.png > will add file : 3690026477_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690026477/20260112_13:49:01/3690026477_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690026477_12_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690026477_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690026477_12_01_2026.pdf > will add file : BDC-engagement_3690026477_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690026477/20260112_13:49:01/BDC-engagement_3690026477_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690026477_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690026477_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690026477_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690026477_12_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_3690026477_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690026477/20260112_13:49:01/BDC_XML-engagement_3690026477_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690026477_12_01_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 = contact.pharmaciedeprovence@gmail.com,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690026477 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"contact.pharmaciedeprovence@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 13:48:57 - dirToStoreZip = ../../files/bdc/zippedFiles/3690026477 _________ Destinataires _________ to : contact.pharmaciedeprovence@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : contact.pharmaciedeprovence@gmail.com not addCC : contact.pharmaciedeprovence@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = contact.pharmaciedeprovence@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690026477' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690042195 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690026477/20260112_13:48:57/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690026477/20260112_13:48:57 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SUPRAPHARM_3690026477_12_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_3690026477_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SUPRAPHARM_3690026477_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690026477/20260112_13:48:57/Contrat_utilisateur_SUPRAPHARM_3690026477_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SUPRAPHARM_3690026477_12_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 = contact.pharmaciedeprovence@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690026477 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"contact.pharmaciedeprovence@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 09:40:03 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029968 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029968/20260112_09:40:03/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029968/20260112_09:40:03 ########## 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/3690029968/20260112_09:40:03/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/3690029968/20260112_09:40:03/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 = 'valentin.delinde@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,valentin.delinde@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = 1 attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 15:07:32 - dirToStoreZip = ../../files/bdc/zippedFiles/3690042027 _________ Destinataires _________ to : pharmacievn.kealy@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmacievn.kealy@gmail.com not addCC : pharmacievn.kealy@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmacievn.kealy@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690042027/20260108_15:07:32/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690042027/20260108_15:07:32 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_NEXTYPHARM_3690042027_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_NEXTYPHARM_3690042027_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 = mgFmHjGNQ2eAnzV8FqxCUU1zVbI5BGZlsntkfSlxFtUutbItOeBZCBScFs4ForFV nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacievn.kealy@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690042027 signWithDocuSign = 1 attachmentToSign = 1 isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacievn.kealy@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 13:19:35 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016756 _________ Destinataires _________ to : pharmaciejacquesbrel@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmaciejacquesbrel@gmail.com not addCC : pharmaciejacquesbrel@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmaciejacquesbrel@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016756/20260108_13:19:35/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016756/20260108_13:19:35 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690016756_08_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016756_08_01_2026.xml fileNameToSend = Engagement_3690016756_08_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_3690016756_08_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016756_08_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690016756_08_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016756_08_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016756_08_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_3690016756_08_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016756/20260108_13:19:35/BDC_XML-engagement_3690016756_08_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016756_08_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690016756_08_01_2026_detailLivraisons.png > will add file : Engagement_3690016756_08_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016756/20260108_13:19:35/Engagement_3690016756_08_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690016756_08_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 = 4XcEigagycuamhEj96O1qeSc0hfqSVN1sHVz1QiwcjwQNfC28U5N1VJuYLP2SuYN nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciejacquesbrel@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016756 signWithDocuSign = 1 attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciejacquesbrel@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 12:09:35 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032721 _________ Destinataires _________ to : pharmacie.berlioz@orange.fr cc : valentin.delinde@roche.com emailPharma : pharmacie.berlioz@orange.fr not addCC : pharmacie.berlioz@orange.fr addCC : valentin.delinde@roche.com whiteList = pharmacie.berlioz@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032721/20260108_12:09:35/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032721/20260108_12:09:35 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690032721_08_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690032721_08_01_2026.xml fileNameToSend = Engagement_3690032721_08_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_3690032721_08_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690032721_08_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690032721_08_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690032721_08_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690032721_08_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690032721_08_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690032721/20260108_12:09:35/BDC_XML-engagement_3690032721_08_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690032721_08_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690032721_08_01_2026_detailLivraisons.png > will add file : Engagement_3690032721_08_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690032721/20260108_12:09:35/Engagement_3690032721_08_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690032721_08_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 = XYPqlUT5Rtt4bQOYgTzpbR1P6OTm7aWu3cLnb2TfSTf3bWWBIonUjcnCWO71W9Ua nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacie.berlioz@orange.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032721 signWithDocuSign = 1 attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.berlioz@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 12:07:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032721 _________ Destinataires _________ to : pharmacie.berlioz@orange.fr cc : valentin.delinde@roche.com emailPharma : pharmacie.berlioz@orange.fr not addCC : pharmacie.berlioz@orange.fr addCC : valentin.delinde@roche.com whiteList = pharmacie.berlioz@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032721/20260108_12:07:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032721/20260108_12:07:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_WE-PHARMA_3690032721_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_WE-PHARMA_3690032721_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 = YY0D1uwI3sNUuqzwr9riJJAmqAq1PBLvDGjNGkSLhxEfLNtZHbQzORgzeH7W1RM6 nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacie.berlioz@orange.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690032721 signWithDocuSign = 1 attachmentToSign = 1 isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.berlioz@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 12:05:19 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032721 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032721/20260108_12:05:19/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032721/20260108_12:05:19 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = photo1.png fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** 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/3690032721/20260108_12:05:19/photo1.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 = 'valentin.delinde@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,valentin.delinde@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = 1 attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 11:40:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016756 _________ Destinataires _________ to : pharmaciejacquesbrel@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmaciejacquesbrel@gmail.com not addCC : pharmaciejacquesbrel@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmaciejacquesbrel@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016756/20260106_11:40:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016756/20260106_11:40:48 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690016756_06_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016756_06_01_2026.xml fileNameToSend = Engagement_3690016756_06_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_3690016756_06_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016756_06_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690016756_06_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016756_06_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016756_06_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_3690016756_06_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016756/20260106_11:40:48/BDC_XML-engagement_3690016756_06_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016756_06_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690016756_06_01_2026_detailLivraisons.png > will add file : Engagement_3690016756_06_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016756/20260106_11:40:48/Engagement_3690016756_06_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690016756_06_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 = LBJXcGPgi2p7v63U4kKwaGOWXXI546QnmgkuH7HqkjCKGuMmlsdnrqzp9DA1B7gR nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciejacquesbrel@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016756 signWithDocuSign = 1 attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciejacquesbrel@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 11:31:05 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016756 _________ Destinataires _________ to : pharmaciejacquesbrel@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmaciejacquesbrel@gmail.com not addCC : pharmaciejacquesbrel@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmaciejacquesbrel@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016756/20260106_11:31:05/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016756/20260106_11:31:05 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_WE-PHARMA_3690016756_06_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_WE-PHARMA_3690016756_06_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 = jqwwDubKAmYaf8b7EQjp5F4WY3yCkhIUxawPKQKpPvLtq5GEyFW8JXiQ431lbgpD nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmaciejacquesbrel@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016756 signWithDocuSign = 1 attachmentToSign = 1 isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciejacquesbrel@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-01-06 11:31:05 ########## --------- 2026-01-06 11:31:05 --------- - [getLogfile] suffixe = storeFile delegueEmail = valentin.delinde@roche.com ##################################################