//============================= v.630 ========================================= - 2026-01-23 14:32:42 - dirToStoreZip = ../../files/bdc/zippedFiles/3690017150 _________ Destinataires _________ to : phdelathierache@gmail.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : phdelathierache@gmail.com not addCC : phdelathierache@gmail.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phdelathierache@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690017150/20260123_14:32:42/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:42 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690017150_23_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690017150_23_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690017150_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 = 3690017150_23_01_2026_detailLivraisons.png > will add file : 3690017150_23_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:42/3690017150_23_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690017150_23_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690017150_23_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690017150_23_01_2026.pdf > will add file : BDC-engagement_3690017150_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:42/BDC-engagement_3690017150_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690017150_23_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690017150_23_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690017150_23_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690017150_23_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_3690017150_23_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:42/BDC_XML-engagement_3690017150_23_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690017150_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phdelathierache@gmail.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690017150 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phdelathierache@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-23 14:32:33 - dirToStoreZip = ../../files/bdc/zippedFiles/3690017150 _________ Destinataires _________ to : phdelathierache@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : phdelathierache@gmail.com not addCC : phdelathierache@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = phdelathierache@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690017150' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690588001 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690017150/20260123_14:32:33/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:33 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMA-G8_3690017150_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-G8_3690017150_23_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMA-G8_3690017150_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690017150/20260123_14:32:33/Contrat_utilisateur_PHARMA-G8_3690017150_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMA-G8_3690017150_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 = phdelathierache@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690017150 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phdelathierache@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-22 15:23:02 - dirToStoreZip = ../../files/bdc/zippedFiles/3690036438 _________ Destinataires _________ to : pharmaproville@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : margaux.francois01@sfr.fr not addCC : pharmaproville@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaproville@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690036438' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690036438/20260122_15:23:02/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690036438/20260122_15:23:02 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690036438_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_CALIPHARMA_3690036438_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690036438_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690036438/20260122_15:23:02/Contrat_utilisateur_CALIPHARMA_3690036438_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690036438_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 = pharmaproville@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690036438 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaproville@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-22 15:22:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025401 _________ Destinataires _________ to : pharmaciesorrant@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciesorrant@gmail.com not addCC : pharmaciesorrant@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciesorrant@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690025401' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025401/20260122_15:22:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025401/20260122_15:22:45 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690025401_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_CALIPHARMA_3690025401_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690025401_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025401/20260122_15:22:45/Contrat_utilisateur_CALIPHARMA_3690025401_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690025401_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 = pharmaciesorrant@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025401 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciesorrant@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-21 18:02:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012499 _________ Destinataires _________ to : pharmaciedeliesse@orange.fr cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedeliesse@orange.fr not addCC : pharmaciedeliesse@orange.fr addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedeliesse@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012499/20260121_18:02:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:16 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690012499_21_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690012499_21_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690012499_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 = 3690012499_21_01_2026_detailLivraisons.png > will add file : 3690012499_21_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:16/3690012499_21_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690012499_21_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690012499_21_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690012499_21_01_2026.pdf > will add file : BDC-engagement_3690012499_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:16/BDC-engagement_3690012499_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690012499_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690012499_21_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690012499_21_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690012499_21_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_3690012499_21_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:16/BDC_XML-engagement_3690012499_21_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690012499_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedeliesse@orange.fr,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012499 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedeliesse@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-21 18:02:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012499 _________ Destinataires _________ to : pharmaciedeliesse@orange.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedeliesse@orange.fr not addCC : pharmaciedeliesse@orange.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedeliesse@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690012499' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690315489 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012499/20260121_18:02:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:09 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABULLES_3690012499_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_PHARMABULLES_3690012499_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABULLES_3690012499_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012499/20260121_18:02:09/Contrat_utilisateur_PHARMABULLES_3690012499_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABULLES_3690012499_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 = pharmaciedeliesse@orange.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012499 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedeliesse@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-21 18:01:55 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022415 _________ Destinataires _________ to : pharmacie-fayet@orange.fr cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : fayethugues@yahoo.fr not addCC : pharmacie-fayet@orange.fr addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie-fayet@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022415/20260121_18:01:55/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:55 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690022415_21_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690022415_21_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690022415_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 = 3690022415_21_01_2026_detailLivraisons.png > will add file : 3690022415_21_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:55/3690022415_21_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690022415_21_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690022415_21_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690022415_21_01_2026.pdf > will add file : BDC-engagement_3690022415_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:55/BDC-engagement_3690022415_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690022415_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690022415_21_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690022415_21_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690022415_21_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_3690022415_21_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:55/BDC_XML-engagement_3690022415_21_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690022415_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie-fayet@orange.fr,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022415 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie-fayet@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-21 18:01:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022415 _________ Destinataires _________ to : pharmacie-fayet@orange.fr cc : meylan.contratutilisateur@roche.com emailPharma : fayethugues@yahoo.fr not addCC : pharmacie-fayet@orange.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmacie-fayet@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690022415' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690315489 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022415/20260121_18:01:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:48 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABULLES_3690022415_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_PHARMABULLES_3690022415_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABULLES_3690022415_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690022415/20260121_18:01:48/Contrat_utilisateur_PHARMABULLES_3690022415_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABULLES_3690022415_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 = pharmacie-fayet@orange.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022415 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie-fayet@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-20 14:35:35 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038986 _________ Destinataires _________ to : pharmacie.dehaut@wanadoo.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.dehaut@wanadoo.fr not addCC : pharmacie.dehaut@wanadoo.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmacie.dehaut@wanadoo.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690038986' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038986/20260120_14:35:35/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038986/20260120_14:35:35 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690038986_20_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_CALIPHARMA_3690038986_20_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690038986_20_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690038986/20260120_14:35:35/Contrat_utilisateur_CALIPHARMA_3690038986_20_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690038986_20_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 = pharmacie.dehaut@wanadoo.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038986 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.dehaut@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-19 14:42:52 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039898 _________ Destinataires _________ to : richardprovignon@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : richardprovignon@gmail.com not addCC : richardprovignon@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = richardprovignon@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690039898' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690315447 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039898/20260119_14:42:52/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039898/20260119_14:42:52 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_FORCE-PHARMA_3690039898_19_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_FORCE-PHARMA_3690039898_19_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_FORCE-PHARMA_3690039898_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039898/20260119_14:42:52/Contrat_utilisateur_FORCE-PHARMA_3690039898_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_FORCE-PHARMA_3690039898_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = richardprovignon@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039898 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"richardprovignon@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-19 14:32:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025538 _________ Destinataires _________ to : pharmatilleul@hotmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmatilleul@hotmail.com not addCC : pharmatilleul@hotmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmatilleul@hotmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690025538' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690749911 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025538/20260119_14:32:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025538/20260119_14:32:09 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SIS-OFFICINE_3690025538_19_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SIS-OFFICINE_3690025538_19_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SIS-OFFICINE_3690025538_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025538/20260119_14:32:09/Contrat_utilisateur_SIS-OFFICINE_3690025538_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SIS-OFFICINE_3690025538_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = pharmatilleul@hotmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025538 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmatilleul@hotmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-19 14:32:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690040992 _________ Destinataires _________ to : phlegrand.bouchain@gmail.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : julienlegr@gmail.com not addCC : phlegrand.bouchain@gmail.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phlegrand.bouchain@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690040992/20260119_14:32:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690040992/20260119_14:32:01 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690040992_19_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690040992_19_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690040992_19_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 = 3690040992_19_01_2026_detailLivraisons.png > will add file : 3690040992_19_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690040992/20260119_14:32:01/3690040992_19_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690040992_19_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690040992_19_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690040992_19_01_2026.pdf > will add file : BDC-engagement_3690040992_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690040992/20260119_14:32:01/BDC-engagement_3690040992_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690040992_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690040992_19_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690040992_19_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690040992_19_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_3690040992_19_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690040992/20260119_14:32:01/BDC_XML-engagement_3690040992_19_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690040992_19_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phlegrand.bouchain@gmail.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690040992 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phlegrand.bouchain@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-19 14:31:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690040992 _________ Destinataires _________ to : phlegrand.bouchain@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : julienlegr@gmail.com not addCC : phlegrand.bouchain@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = phlegrand.bouchain@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690040992' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690040992/20260119_14:31:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690040992/20260119_14:31:50 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690040992_19_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690040992_19_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690040992_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690040992/20260119_14:31:50/Contrat_utilisateur_CALIPHARMA_3690040992_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690040992_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = phlegrand.bouchain@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690040992 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phlegrand.bouchain@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-16 16:20:56 - dirToStoreZip = ../../files/bdc/zippedFiles/3690040621 _________ Destinataires _________ to : pharmaciedechauny@gmail.com cc : clement.laloux@roche.com emailPharma : pharmaciedechauny@gmail.com not addCC : pharmaciedechauny@gmail.com addCC : clement.laloux@roche.com whiteList = pharmaciedechauny@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690040621/20260116_16:20:56/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690040621/20260116_16:20:56 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690040621_16_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690040621_16_01_2026.xml fileNameToSend = Engagement_3690040621_16_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_3690040621_16_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690040621_16_01_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690040621_16_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690040621_16_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690040621_16_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 4 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690040621_16_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690040621/20260116_16:20:56/BDC_XML-engagement_3690040621_16_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690040621_16_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690040621_16_01_2026_detailLivraisons.png > will add file : Engagement_3690040621_16_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690040621/20260116_16:20:56/Engagement_3690040621_16_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690040621_16_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 = 8AGa0BbzVvW4gPdHj3u1C9zeEctYATUUPYK18NK9TOxHuZqMGSKoU88vCAxq6kvu nbRecipient = 1 dest = 'clement.laloux@roche.com' whiteList = pharmaciedechauny@gmail.com,clement.laloux@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690040621 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedechauny@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-16 13:37:59 - dirToStoreZip = ../../files/bdc/zippedFiles/3690036949 _________ Destinataires _________ to : pharmaciechasseroyale@perso.alliadis.net cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciechasseroyale@perso.alliadis.net not addCC : pharmaciechasseroyale@perso.alliadis.net addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciechasseroyale@perso.alliadis.net __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690036949' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690036949/20260116_13:37:59/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690036949/20260116_13:37:59 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690036949_16_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_CALIPHARMA_3690036949_16_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690036949_16_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690036949/20260116_13:37:59/Contrat_utilisateur_CALIPHARMA_3690036949_16_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690036949_16_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 = pharmaciechasseroyale@perso.alliadis.net,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690036949 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciechasseroyale@perso.alliadis.net"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-15 16:19:22 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038983 _________ Destinataires _________ to : phieglise@orange.fr cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : phieglise@orange.fr not addCC : phieglise@orange.fr addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phieglise@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038983/20260115_16:19:22/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038983/20260115_16:19:22 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690038983_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690038983_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690038983_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 = 3690038983_15_01_2026_detailLivraisons.png > will add file : 3690038983_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690038983/20260115_16:19:22/3690038983_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690038983_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690038983_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690038983_15_01_2026.pdf > will add file : BDC-engagement_3690038983_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690038983/20260115_16:19:22/BDC-engagement_3690038983_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690038983_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690038983_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690038983_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690038983_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 12 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690038983_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690038983/20260115_16:19:22/BDC_XML-engagement_3690038983_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690038983_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phieglise@orange.fr,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038983 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phieglise@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-15 12:54:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016323 _________ Destinataires _________ to : pharmaciestgeorges59@gmail.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciestgeorges@offisecure.com not addCC : pharmaciestgeorges59@gmail.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciestgeorges59@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016323/20260115_12:54:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016323/20260115_12:54:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690016323_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690016323_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016323_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 = 3690016323_15_01_2026_detailLivraisons.png > will add file : 3690016323_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016323/20260115_12:54:00/3690016323_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690016323_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690016323_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016323_15_01_2026.pdf > will add file : BDC-engagement_3690016323_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016323/20260115_12:54:00/BDC-engagement_3690016323_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690016323_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690016323_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016323_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016323_15_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_3690016323_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016323/20260115_12:54:00/BDC_XML-engagement_3690016323_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016323_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciestgeorges59@gmail.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016323 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciestgeorges59@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-15 12:53:47 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016323 _________ Destinataires _________ to : pharmaciestgeorges59@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciestgeorges@offisecure.com not addCC : pharmaciestgeorges59@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciestgeorges59@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690016323' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016323/20260115_12:53:47/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016323/20260115_12:53:47 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690016323_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_CALIPHARMA_3690016323_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690016323_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016323/20260115_12:53:47/Contrat_utilisateur_CALIPHARMA_3690016323_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690016323_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 = pharmaciestgeorges59@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016323 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciestgeorges59@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-14 15:15:34 - dirToStoreZip = ../../files/bdc/zippedFiles/3690019955 _________ Destinataires _________ to : pharmaciedelarocade@officesecure.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedelarocade@officesecure.com not addCC : pharmaciedelarocade@officesecure.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedelarocade@officesecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690019955/20260114_15:15:34/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690019955/20260114_15:15:34 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690019955_14_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690019955_14_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690019955_14_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 = 3690019955_14_01_2026_detailLivraisons.png > will add file : 3690019955_14_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690019955/20260114_15:15:34/3690019955_14_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690019955_14_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690019955_14_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690019955_14_01_2026.pdf > will add file : BDC-engagement_3690019955_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690019955/20260114_15:15:34/BDC-engagement_3690019955_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690019955_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690019955_14_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690019955_14_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690019955_14_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 25 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690019955_14_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690019955/20260114_15:15:34/BDC_XML-engagement_3690019955_14_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690019955_14_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedelarocade@officesecure.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690019955 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelarocade@officesecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-14 15:11:38 - dirToStoreZip = ../../files/bdc/zippedFiles/3690021130 _________ Destinataires _________ to : pharmaciedelaplace59680@gmail.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedelaplace59680@gmail.com not addCC : pharmaciedelaplace59680@gmail.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedelaplace59680@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690021130/20260114_15:11:39/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690021130/20260114_15:11:39 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690021130_14_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690021130_14_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690021130_14_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 = 3690021130_14_01_2026_detailLivraisons.png > will add file : 3690021130_14_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690021130/20260114_15:11:39/3690021130_14_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690021130_14_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690021130_14_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690021130_14_01_2026.pdf > will add file : BDC-engagement_3690021130_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690021130/20260114_15:11:39/BDC-engagement_3690021130_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690021130_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690021130_14_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690021130_14_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690021130_14_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 3 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690021130_14_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690021130/20260114_15:11:39/BDC_XML-engagement_3690021130_14_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690021130_14_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedelaplace59680@gmail.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690021130 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelaplace59680@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 16:28:40 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016324 _________ Destinataires _________ to : plessietraphael@orange.fr cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : plessietraphael@orange.fr not addCC : plessietraphael@orange.fr addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = plessietraphael@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016324/20260112_16:28:40/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:40 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690016324_12_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690016324_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016324_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 = 3690016324_12_01_2026_detailLivraisons.png > will add file : 3690016324_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:40/3690016324_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690016324_12_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690016324_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016324_12_01_2026.pdf > will add file : BDC-engagement_3690016324_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:40/BDC-engagement_3690016324_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690016324_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690016324_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016324_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016324_12_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 14 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690016324_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:40/BDC_XML-engagement_3690016324_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016324_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = plessietraphael@orange.fr,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016324 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"plessietraphael@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 16:28:32 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016324 _________ Destinataires _________ to : plessietraphael@orange.fr cc : meylan.contratutilisateur@roche.com emailPharma : plessietraphael@orange.fr not addCC : plessietraphael@orange.fr addCC : meylan.contratutilisateur@roche.com whiteList = plessietraphael@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690016324' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016324/20260112_16:28:32/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:32 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690016324_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_CALIPHARMA_3690016324_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690016324_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016324/20260112_16:28:32/Contrat_utilisateur_CALIPHARMA_3690016324_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690016324_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 = plessietraphael@orange.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016324 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"plessietraphael@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 16:28:21 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039983 _________ Destinataires _________ to : pharmaciedequievrechain@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : helene.vekemans@wanadoo.fr not addCC : pharmaciedequievrechain@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmaciedequievrechain@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690039983' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690085527 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039983/20260112_16:28:21/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039983/20260112_16:28:21 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690039983_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_CALIPHARMA_3690039983_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690039983_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039983/20260112_16:28:21/Contrat_utilisateur_CALIPHARMA_3690039983_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690039983_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 = pharmaciedequievrechain@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039983 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedequievrechain@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 16:28:11 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024555 _________ Destinataires _________ to : pharmacie.carette@offisecure.com cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.carette@offisecure.com not addCC : pharmacie.carette@offisecure.com addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.carette@offisecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024555/20260112_16:28:11/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024555/20260112_16:28:11 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690024555_12_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690024555_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690024555_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 = 3690024555_12_01_2026_detailLivraisons.png > will add file : 3690024555_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690024555/20260112_16:28:11/3690024555_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690024555_12_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690024555_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690024555_12_01_2026.pdf > will add file : BDC-engagement_3690024555_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690024555/20260112_16:28:11/BDC-engagement_3690024555_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690024555_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690024555_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690024555_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690024555_12_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 3 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690024555_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690024555/20260112_16:28:11/BDC_XML-engagement_3690024555_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690024555_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 = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.carette@offisecure.com,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690024555 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.carette@offisecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-09 17:39:25 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025696 _________ Destinataires _________ to : phiedesremparts@orange.fr cc : clement.laloux@roche.com,meylan.contrat_pharma@roche.com emailPharma : phiedesremparts@orange.fr not addCC : phiedesremparts@orange.fr addCC : clement.laloux@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phiedesremparts@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025696/20260109_17:39:25/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025696/20260109_17:39:25 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690025696_09_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690025696_09_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690025696_09_01_2026.xml fileNameToSend = CPV-EXCLUSIF_3690025696.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 = 3690025696_09_01_2026_detailLivraisons.png > will add file : 3690025696_09_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690025696/20260109_17:39:25/3690025696_09_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690025696_09_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690025696_09_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690025696_09_01_2026.pdf > will add file : BDC-engagement_3690025696_09_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025696/20260109_17:39:25/BDC-engagement_3690025696_09_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690025696_09_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690025696_09_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690025696_09_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690025696_09_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 3 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690025696_09_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690025696/20260109_17:39:25/BDC_XML-engagement_3690025696_09_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690025696_09_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = CPV-EXCLUSIF_3690025696.pdf ********* CPV ********** -- CPV 2025 detected -- -- query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690025696.pdf', 'clement.laloux@roche.com', '2026-01-09 17:39:29', 0, 66, 15, '1.3', 7, '24.76', 1 ) > will add file : CPV-EXCLUSIF_3690025696.pdf IN : ../../files/bdc/unzippedFiles/3690025696/20260109_17:39:25/CPV-EXCLUSIF_3690025696.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : CPV-EXCLUSIF_3690025696.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'clement.laloux@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phiedesremparts@orange.fr,clement.laloux@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025696 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"phiedesremparts@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-09 10:29:33 - dirToStoreZip = ../../files/bdc/zippedFiles/3690000006 _________ Destinataires _________ to : test@test.fr cc : meylan.contratutilisateur@roche.com emailPharma : test@test.fr a- Erreur : test@test.fr addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690000006/20260109_10:29:33/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690000006/20260109_10:29:33 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CALIPHARMA_3690000006_09_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_CALIPHARMA_3690000006_09_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_CALIPHARMA_3690000006_09_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690000006/20260109_10:29:33/Contrat_utilisateur_CALIPHARMA_3690000006_09_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_CALIPHARMA_3690000006_09_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 = meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690000006 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-01-09 10:29:33 ########## --------- 2026-01-09 10:29:33 --------- - [getLogfile] suffixe = storeFile delegueEmail = clement.laloux@roche.com ##################################################