//============================= v.634 ========================================= - 2026-04-03 15:04:59 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023679 _________ Destinataires _________ to : pharmacie.ginkgo@wanadoo.fr cc : helene.lucas@roche.com emailPharma : pharmacie.ginkgo@wanadoo.fr not addCC : pharmacie.ginkgo@wanadoo.fr addCC : helene.lucas@roche.com whiteList = pharmacie.ginkgo@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023679/20260403_15:04:59/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023679/20260403_15:04:59 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690023679_03_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690023679_03_04_2026.xml fileNameToSend = Engagement_3690023679_03_04_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_3690023679_03_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690023679_03_04_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690023679_03_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690023679_03_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690023679_03_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 = -1 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690023679_03_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690023679/20260403_15:04:59/BDC_XML-engagement_3690023679_03_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690023679_03_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690023679_03_04_2026_detailLivraisons.png > will add file : Engagement_3690023679_03_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690023679/20260403_15:04:59/Engagement_3690023679_03_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690023679_03_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = sqomZD8kreFbEwj9I6DBOl1cEZGkSQOFNdaVTML0PtdztT23HWbAOnOXHS1ZRAaN nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = pharmacie.ginkgo@wanadoo.fr,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690023679 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.ginkgo@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-03 09:42:10 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012188 _________ Destinataires _________ to : pharmadesoliviers@gmail.com cc : helene.lucas@roche.com emailPharma : pharmadesoliviers@gmail.com not addCC : pharmadesoliviers@gmail.com addCC : helene.lucas@roche.com whiteList = pharmadesoliviers@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012188/20260403_09:42:10/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012188/20260403_09:42:10 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690012188_03_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690012188_03_04_2026.xml fileNameToSend = Engagement_3690012188_03_04_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_3690012188_03_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690012188_03_04_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690012188_03_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690012188_03_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690012188_03_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_3690012188_03_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690012188/20260403_09:42:10/BDC_XML-engagement_3690012188_03_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690012188_03_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690012188_03_04_2026_detailLivraisons.png > will add file : Engagement_3690012188_03_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690012188/20260403_09:42:10/Engagement_3690012188_03_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690012188_03_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = xytFAHwoCq5hINdbtETYi5U3kuKUYuvPmgT9eOQN24dDW1pZPASE8DsnHECNJaTO nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = pharmadesoliviers@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690012188 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadesoliviers@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.634 ========================================= - 2026-04-02 11:12:58 - dirToStoreZip = ../../files/bdc/zippedFiles/3690032664 _________ Destinataires _________ to : phciedelafontaine@orange.fr cc : helene.lucas@roche.com,meylan.contrat_pharma@roche.com emailPharma : phciedelafontaine@orange.fr not addCC : phciedelafontaine@orange.fr addCC : helene.lucas@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phciedelafontaine@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690032664/20260402_11:12:58/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690032664/20260402_11:12:58 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690032664_02_04_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690032664_02_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690032664_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 = 3690032664_02_04_2026_detailLivraisons.png > will add file : 3690032664_02_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690032664/20260402_11:12:58/3690032664_02_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690032664_02_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690032664_02_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690032664_02_04_2026.pdf > will add file : BDC-engagement_3690032664_02_04_2026.pdf IN : ../../files/bdc/unzippedFiles/3690032664/20260402_11:12:58/BDC-engagement_3690032664_02_04_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690032664_02_04_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690032664_02_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690032664_02_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690032664_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 = -1 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690032664_02_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690032664/20260402_11:12:58/BDC_XML-engagement_3690032664_02_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690032664_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 = 'helene.lucas@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phciedelafontaine@orange.fr,helene.lucas@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690032664 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phciedelafontaine@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:33:27 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:33:27/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:33:27 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CARLESROMAN.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CARLESROMAN.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:33:27' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'ROMAN', 'CARLES', 'Pharmacien adjoint', '10110674560')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:33:27/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = ZCvFRQZL2MMYvcSDlOIyleC1UCHlWrgbUGS7qfg0PqPWvyWniAEIoWRO23boZiHq nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:32:27 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:32:27/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:32:27 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_EUGENIEHOUPIKIAN.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_EUGENIEHOUPIKIAN.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:32:27' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'HOUPIKIAN', 'EUGENIE', 'Pharmacien adjoint', '10004123880')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:32:27/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = wG1T3ldQOp6CJZu3fe2Ax7pKSxW9PVCffbxM7jV5BNy7sL2XkCyVUQDAwLm99Qwv nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:30:57 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:30:57/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:30:57 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PIERRENAYROLLES.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PIERRENAYROLLES.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:30:57' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'NAYROLLES', 'PIERRE', 'Pharmacien adjoint', '10105799570')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:30:57/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 4SAnjcm1tvcJTDL3c8zenkentxz8fcrB0c5jmCxUK0PsZCLhj9mm55SNEdglIzf6 nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:30:15 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:30:15/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:30:15 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MARIUSCROSET.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MARIUSCROSET.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:30:15' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'CROSET', 'MARIUS', 'Pharmacien adjoint', '10100898567')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:30:15/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = mODlNMn8FS2J23oozKhWh6o7oDToSRkdAk8gMKAcFRjJ7garouPL9d6C4a6iajZ9 nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:29:29 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:29:29/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:29:29 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ALEXANDRECETTE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ALEXANDRECETTE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:29:29' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'CETTE ', 'ALEXANDRE', 'Pharmacien adjoint', '10108666644')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:29:29/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 9zFDm6zTlnPlKa0JBy7bi8H01nMqOdVS8crqIoOpIVEteG5we3zJyytSKEzS6AOB nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:28:48 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:28:48/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:28:48 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MERYLCOHEN.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MERYLCOHEN.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:28:48' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'COHEN', 'MERYL', 'Pharmacien adjoint', '10106972333')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:28:48/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = bbZ48nO3nBa3LgII0qx6Hj7tSV7o05reAKDqyD3QPR4uDv3StuWWb12CcoyiAfpL nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:28:11 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:28:11/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:28:11 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_STEPHANIEFERRY.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_STEPHANIEFERRY.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:28:11' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'FERRY', 'STEPHANIE', 'Pharmacien adjoint', '10000979848')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:28:11/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = pw92LsCwqXH51gsZ54xHlFnTlT6Bg4COH2O6jh0xzb9212dIhq7TpfLqkCJ5lBRi nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:27:26 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:27:26/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:27:26 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CHARLENESERRA.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CHARLENESERRA.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:27:26' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'SERRA', 'CHARLENE', 'Pharmacien adjoint', '10101330735')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:27:26/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = lyPf11DkaHOJE4KuoQ3xUbv5Hnwhfc6ACAPU6H1pKnkvs9cqJdEvGCYTILIM0GBp nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:26:43 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:26:43/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:26:43 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CLEMENTGAILLARD.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CLEMENTGAILLARD.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:26:43' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'GAILLARD', 'CLEMENT', 'Pharmacien adjoint', '10101430568')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:26:43/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = N0SLnFi5SKsCS3dU8OxlVo5f22AD0X8UoqzsZi7IF8xEol7IZc2DNjcg5T3cOdJ9 nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:25:53 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:25:53/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:25:53 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_VINCENTSERRIES.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_VINCENTSERRIES.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:25:53' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'SERRIES', 'VINCENT', 'Pharmacien adjoint', '10111412416')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:25:53/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 3u19cDmirvaYRxlaAEwVstnU7zTcZOl4IxIIdTtI7JK9JekOarphuJXAAO9XLbqE nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:25:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:25:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:25:09 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PIERREADRIENBEAL.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PIERREADRIENBEAL.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:25:09' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'BEAL', 'PIERRE ADRIEN', 'Pharmacien adjoint', '10100830370')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:25:09/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = cpqdxR0Ij8fUo18GnheOiQBS5YEthKToNtG2QrE8JuRgoBKE7cePQCz7NfBHoO8G nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:24:23 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:24:23/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:24:23 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_VERONIQUEPLIEZ.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_VERONIQUEPLIEZ.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:24:23' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'PLIEZ', 'VERONIQUE', 'Pharmacien adjoint', '10002032562')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:24:23/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = E0wXHWpAiZspj5BnDlB2rTmL2KFEUjEk2HMXcDYPM61xxdZng1axCxSZ3yszrfTq nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:23:41 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:23:41/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:23:41 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PAULINELAGACHE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_PAULINELAGACHE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:23:41' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'LAGACHE', 'PAULINE', 'Préparateur', '10111861018')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:23:41/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 4iv42qEU9nEg0hcDmO8cep74kBKlPpeIUvvsWBprxCxqDq7lKGDZDLTRq2L15qbh nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:22:59 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:22:59/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:22:59 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_DELHIACARRIER.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_DELHIACARRIER.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:22:59' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'CARRIER', 'DELHIA', 'Préparateur', '10111861000')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:22:59/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = HEyt39dcVYgGvB18jm0Tall0IeitDMtjBEt7fLalbThR9qAmCcN5NylzcWDyurIu nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:22:15 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:22:15/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:22:15 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ADJARATOURE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ADJARATOURE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:22:15' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'TOURE', 'ADJARA', 'Préparateur', '10108953257')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:22:15/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = l4GNOPvlwfVW4NzqzlvvRVe0GQgfjqZCknkmK4RvPxPRJYACwG1LUa0i9pSRtyb6 nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:21:31 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:21:31/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:21:31 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_EMMAPHILIPPE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_EMMAPHILIPPE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:21:31' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'PHILIPPE', 'EMMA', 'Préparateur', '10110022232 ')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:21:31/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = i36keuDssjUNSjJ3TPOnuwFYirEC66WM9zJ7WAWVZMd9ezOw0B87MBxIS7K33O7b nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:20:44 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:20:44/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:20:44 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ANDRESANTIAGO.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_ANDRESANTIAGO.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:20:44' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'SANTIAGO', 'ANDRE', 'Préparateur', '10108885194')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:20:44/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = fddKEp05tV4xSYNlKgRNGQrtMRLGkarH0QLXk0Jk6xq5IodGBinAipDMfJLcNppB nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:19:53 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:19:53/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:19:53 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_NADEGEFEDE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_NADEGEFEDE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:19:53' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'FEDE', 'NADEGE', 'Préparateur', '10109183854')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:19:53/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = IhhfhfPHapt6N9SP0fYAHyuWi6dGXAIgGqZafZotZCSzpZpTzQ3ZtxLdx2d9M4zx nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:18:56 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:18:56/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:18:56 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_AMANDINEDAVID.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_AMANDINEDAVID.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:18:56' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'DAVID', 'AMANDINE', 'Préparateur', '10108885210')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:18:56/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = Klg2QTES6I7nVZuPsElzMshPo8HwSbgtI6dLfUG77rWBQqmlrIlpxKwruGPt7ijO nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:18:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:18:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:18:16 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CAROLEMONMAGNON.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CAROLEMONMAGNON.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:18:16' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'MONMAGNON', 'CAROLE', 'Préparateur', '10109301944')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:18:16/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = kAUR2f0WdWaCxgEPdgdW2T987CutZniHAqmdHjUAMq50cLrFRj5RHoHTSBNWZlRg nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:17:28 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:17:28/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:17:28 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MELISSABARDINE.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_MELISSABARDINE.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:17:28' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'BARDINE', 'MELISSA', 'Préparateur', '10108935668')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:17:28/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = bQyQQMGmBATzIHJlQtofKQMbnTk74oCQQ3J1idLPbdYohs4WShmTv3J5pgEVqWfq nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:16:46 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:16:46/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:16:46 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_AUDREYALBRAND.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_AUDREYALBRAND.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:16:46' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'ALBRAND', 'AUDREY', 'Préparateur', '10109356773')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:16:46/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 6kc8zbKmGfmC3FyZEuBuHTOQBy84v7yR0x8h5a8ti24wrENm8kBAoLtBLsLmMaSX nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:15:47 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:15:47/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:15:47 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CLAIREPOTHIN.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CLAIREPOTHIN.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:15:47' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'POTHIN', 'CLAIRE', 'Préparateur', '10108903336')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:15:47/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = 8kvesF6TVpASFGhiYWVUX3JdSO89RlhotUmOrTsw90E2U0r36VQGikp2hVrBfagC nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 10:14:49 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013549 _________ Destinataires _________ to : marius.pharmacieducours@gmail.com cc : helene.lucas@roche.com emailPharma : pharmacieducoursmirabeau@gmail.com not addCC : marius.pharmacieducours@gmail.com addCC : helene.lucas@roche.com whiteList = marius.pharmacieducours@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013549/20260402_10:14:49/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013549/20260402_10:14:49 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CamilleRODOSSIO.pdf fileNameToSend = staffCsv_3690013549.csv fileToBeAdded = 2 nbFilesToSend = 4 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Staff_AIX EN PROVENCE_3690013549_30-04-2026_CamilleRODOSSIO.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = staffCsv_3690013549.csv ********* CSV STAFF FILE ********** staffCsv_3690013549.csv dateSelectedOnThisStaff = 2026-04-30 objStaff->dateSelected = 2026-04-30 Il s'agit du mm staff queryCheck = 'SELECT id, dateSelected FROM Staff WHERE idPharma = '3690013549' AND state = '1'' query = 'INSERT INTO Staff (idPharma, indiceTheme, dateSelected, heureSelected, minuteSelected, valeur, pharmaNameSelected, adresseSelected, cpSelected, villeSelected, emailIcpo, dateUpdate) VALUES ('3690013549', '4', '2026-04-30', '12', '00', '25', 'PHARMA MIRABEAU', '17 B. COURS DU COURS MIRABEAU', '13100', 'AIX EN PROVENCE', 'helene.lucas@roche.com', '2026-04-02 10:14:49' )' queryParticipant = 'INSERT INTO StaffParticipant (idStaff, idPharma, nom, prenom, qualite, numRpps) VALUES (697, '3690013549', 'RODOSSIO', 'Camille', 'Préparateur', '10108999441')' ---- > will add file : staffCsv_3690013549.csv IN : ../../files/bdc/unzippedFiles/3690013549/20260402_10:14:49/staffCsv_3690013549.csv File not kbis & not rib Tentative Envoi sur OFSAD de : staffCsv_3690013549.csv... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = OiiDzHFA5gPlJj948PHuDrDfnyLC76VbzWNkiiFVdRZxxTAdKPVbi0J2EnlpguFL nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = marius.pharmacieducours@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013549 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"marius.pharmacieducours@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-02 09:57:05 - dirToStoreZip = ../../files/bdc/zippedFiles/3690013817 _________ Destinataires _________ to : pdh83300@gmail.com cc : helene.lucas@roche.com emailPharma : pdh83300@gmail.com not addCC : pdh83300@gmail.com addCC : helene.lucas@roche.com whiteList = pdh83300@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690013817/20260402_09:57:05/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690013817/20260402_09:57:05 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_CPC---KARE-SANTE_3690013817_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_CPC---KARE-SANTE_3690013817_02_04_2026.pdf ********* CONTRAT UTILISATEUR ********** Will sign docusign... keyForDocusignToken = contratUtilisateurToken MERGE PDF SUCCESS *** END FOR LOOP *** *** END FOR LOOP *** END FOR reached errmsg = creating DocuSignEmail... docuSignToken = CuhY3Z8mQfzszHrUwQsr9eIXnOr4BEeXzbcEIVK9HsNkAApFMWS8BZ0u1qGdHCHN nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = pdh83300@gmail.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690013817 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pdh83300@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-01 17:36:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024683 _________ Destinataires _________ to : dremia@club-internet.fr cc : helene.lucas@roche.com emailPharma : dremia@club-internet.fr not addCC : dremia@club-internet.fr addCC : helene.lucas@roche.com whiteList = dremia@club-internet.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024683/20260401_17:36:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024683/20260401_17:36:01 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_APOTHICAL_3690024683_01_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_APOTHICAL_3690024683_01_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 = MFW2PhCDZmpwx3kjQxNiOFJ4GN3Z66u7EJqHL3MciiaKf9xNj5TGQPdzE0jd2xLq nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = dremia@club-internet.fr,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690024683 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"dremia@club-internet.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-01 15:08:34 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039706 _________ Destinataires _________ to : phdesplatanes@officesecure.com cc : helene.lucas@roche.com emailPharma : phdesplatanes@officesecure.com not addCC : phdesplatanes@officesecure.com addCC : helene.lucas@roche.com whiteList = phdesplatanes@officesecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039706/20260401_15:08:34/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039706/20260401_15:08:34 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-engagement_3690039706_01_04_2026.pdf fileNameToSend = BDC_XML-engagement_3690039706_01_04_2026.xml fileNameToSend = Engagement_3690039706_01_04_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_3690039706_01_04_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690039706_01_04_2026.pdf *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC_XML-engagement_3690039706_01_04_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690039706_01_04_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690039706_01_04_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... MAD is active for this client in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690039706_01_04_2026.xml IN : ../../files/bdc/unzippedFiles/3690039706/20260401_15:08:34/BDC_XML-engagement_3690039706_01_04_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690039706_01_04_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = Engagement_3690039706_01_04_2026_detailLivraisons.png > will add file : Engagement_3690039706_01_04_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690039706/20260401_15:08:34/Engagement_3690039706_01_04_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : Engagement_3690039706_01_04_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully creating DocuSignEmail... docuSignToken = bDaxvEJ83FXopv3AQmhmyleZFblF5uh2EIEC7rsNhjrwSSvYSVxuSXQAB1pENBxo nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = phdesplatanes@officesecure.com,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690039706 signWithDocuSign = 1 attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phdesplatanes@officesecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.633 ========================================= - 2026-04-01 14:49:18 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039706 _________ Destinataires _________ to : homolapb@orange.fr cc : helene.lucas@roche.com emailPharma : homolapb@orange.fr not addCC : homolapb@orange.fr addCC : helene.lucas@roche.com whiteList = homolapb@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039706/20260401_14:49:18/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039706/20260401_14:49:18 is NOT Pharma Beta... is NOT Pharma ROC... ##################### CHECKING ####################### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GIROPHARM_3690039706_01_04_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ######################################################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GIROPHARM_3690039706_01_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 = ACzt7d6aRDOqagzfTDLsULisQTfBU1KZQPdlATPxFOughbbrlAccdvJdXt0yPq52 nbRecipient = 1 dest = 'helene.lucas@roche.com' whiteList = homolapb@orange.fr,helene.lucas@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php idPharma = 3690039706 signWithDocuSign = 1 attachmentToSign = 1 Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"homolapb@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-04-01 14:49:18 ########## --------- 2026-04-01 14:49:18 --------- - [getLogfile] suffixe = storeFile delegueEmail = helene.lucas@roche.com ##################################################