//============================= v.634 ========================================= - 2026-04-03 15:37:19 - dirToStoreZip = ../../files/bdc/zippedFiles/3690029967 _________ Destinataires _________ to : pharmacoeur92@gmail.com cc : valentin.delinde@roche.com emailPharma : pharmacoeur92@gmail.com not addCC : pharmacoeur92@gmail.com addCC : valentin.delinde@roche.com whiteList = pharmacoeur92@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690029967/20260403_15:37:19/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690029967/20260403_15:37:19 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690029967_03-04-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Accu-Fine_3690029967_03-04-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690029967_03-04-2026.pdf UPDATE Users SET desktopConnexion = '2026-04-03 15:37:19' WHERE login = 'valentin.delinde@roche.com' *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = 1zb58tS6nrlA0nTTNktcx1TZfcmiwc7Rf0dXQy86NJNztrGrhz4iiv1emS6zkz83 nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = pharmacoeur92@gmail.com,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690029967 signWithDocuSign = 1 attachmentToSign = 1 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.634 ========================================= - 2026-04-03 15:05:23 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012595 _________ Destinataires _________ to : blandine.fallet@yahoo.fr cc : valentin.delinde@roche.com emailPharma : blandine.fallet@yahoo.fr not addCC : blandine.fallet@yahoo.fr addCC : valentin.delinde@roche.com whiteList = blandine.fallet@yahoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012595/20260403_15:05:23/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012595/20260403_15:05:23 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SAS-SYNERGIPHAR_3690012595_03_04_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SAS-SYNERGIPHAR_3690012595_03_04_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = UFmQeljPDGxxw949WvENH0wphGvATpTlg8HmRCBdWxk2FHnFVWCNnScPH2XcWbus nbRecipient = 1 dest = 'valentin.delinde@roche.com' whiteList = blandine.fallet@yahoo.fr,valentin.delinde@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012595 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"blandine.fallet@yahoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-03 12:34:47 - dirToStoreZip = ../../files/bdc/zippedFiles/3690030795 _________ Destinataires _________ to : pharmadesgarennes@gmail.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmadesgarennes@gmail.com not addCC : pharmadesgarennes@gmail.com addCC : meylan.contratutilisateur@roche.com whiteList = pharmadesgarennes@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690030795' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690587444 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690030795/20260403_12:34:47/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690030795/20260403_12:34:47 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_QUALIPHAR_3690030795_03_04_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_QUALIPHAR_3690030795_03_04_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_QUALIPHAR_3690030795_03_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690030795/20260403_12:34:47/Contrat_utilisateur_QUALIPHAR_3690030795_03_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_QUALIPHAR_3690030795_03_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = pharmadesgarennes@gmail.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690030795 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadesgarennes@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-02 15:51:24 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013693 _________ Destinataires _________ to : faxpharmacie.timsit@hotmail.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : faxpharmacie.timsit@hotmail.fr not addCC : faxpharmacie.timsit@hotmail.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = faxpharmacie.timsit@hotmail.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013693/20260402_15:51:24/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013693/20260402_15:51:24 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690013693_02_04_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690013693_02_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690013693_02_04_2026.xml fileNameToSend = CPV-EXCLUSIF_3690013693.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 = 3690013693_02_04_2026_detailLivraisons.png > will add file : 3690013693_02_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690013693/20260402_15:51:24/3690013693_02_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690013693_02_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690013693_02_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690013693_02_04_2026.pdf > will add file : BDC-engagement_3690013693_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013693/20260402_15:51:24/BDC-engagement_3690013693_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690013693_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690013693_02_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690013693_02_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690013693_02_04_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... MAD is NOT active for this client in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690013693_02_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690013693/20260402_15:51:24/BDC_XML-engagement_3690013693_02_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690013693_02_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 5/ fileNameToSend = CPV-EXCLUSIF_3690013693.pdf ********* CPV ********** -- CPV 2025 detected -- -- query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690013693.pdf', 'valentin.delinde@roche.com', '2026-04-02 15:51:27', 0, 60, 24, '5', 6, '24.74', 1 ) > will add file : CPV-EXCLUSIF_3690013693.pdf IN : ../../files/bdc/unzippedFiles/3690013693/20260402_15:51:24/CPV-EXCLUSIF_3690013693.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : CPV-EXCLUSIF_3690013693.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 = faxpharmacie.timsit@hotmail.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013693 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"faxpharmacie.timsit@hotmail.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-02 13:19:07 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013534 _________ Destinataires _________ to : pharmacie.saint.exupery@orange.fr cc : valentin.delinde@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.saint.exupery@orange.fr not addCC : pharmacie.saint.exupery@orange.fr addCC : valentin.delinde@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.saint.exupery@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013534/20260402_13:19:07/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013534/20260402_13:19:07 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690013534_02_04_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690013534_02_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690013534_02_04_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690013534_02_04_2026_detailLivraisons.png > will add file : 3690013534_02_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690013534/20260402_13:19:07/3690013534_02_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690013534_02_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690013534_02_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690013534_02_04_2026.pdf > will add file : BDC-engagement_3690013534_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013534/20260402_13:19:07/BDC-engagement_3690013534_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690013534_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690013534_02_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690013534_02_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690013534_02_04_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... MAD is active for this client WILL REWRITE XML SET in else nbSetGuideTotal = 105 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690013534_02_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690013534/20260402_13:19:07/BDC_XML-engagement_3690013534_02_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690013534_02_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'valentin.delinde@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.saint.exupery@orange.fr,valentin.delinde@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013534 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.saint.exupery@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-02 13:18:58 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013534 _________ Destinataires _________ to : pharmacie.saint.exupery@orange.fr cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.saint.exupery@orange.fr not addCC : pharmacie.saint.exupery@orange.fr addCC : meylan.contratutilisateur@roche.com whiteList = pharmacie.saint.exupery@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690013534' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041403 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013534/20260402_13:18:58/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013534/20260402_13:18:58 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_COS_3690013534_02_04_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_COS_3690013534_02_04_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_COS_3690013534_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690013534/20260402_13:18:58/Contrat_utilisateur_COS_3690013534_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_COS_3690013534_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'meylan.contratutilisateur@roche.com' whiteList = pharmacie.saint.exupery@orange.fr,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013534 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.saint.exupery@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-01 09:45:24 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012168 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012168/20260401_09:45:24/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012168/20260401_09:45:24 is NOT Pharma Beta... 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/3690012168/20260401_09:45: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 +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php 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 ============================================================================================================================================// ####### Creation - 2026-04-01 09:45:24 ########## --------- 2026-04-01 09:45:24 --------- - [getLogfile] suffixe = storeFile delegueEmail = valentin.delinde@roche.com ##################################################