//============================= v.632 ========================================= - 2026-01-26 10:55:23 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039460 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contrat_pharma@roche.com emailPharma : phienivet@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039460/20260126_10:55:23/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039460/20260126_10:55:23 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_Diab_Connect_3690039460_26_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_Diab_Connect_3690039460_26_01_2026.pdf ********* DIAB CONNECT ********** ##### ERR DiabConnect :InvalidArgumentException: Page number "8" out of available page range (1 - 7) in /home/pharmavipr/www/webservices/_common/tools/fpdi/src/PdfReader/PdfReader.php:129 Stack trace: #0 /home/pharmavipr/www/webservices/_common/tools/fpdi/src/FpdiTrait.php(260): setasign\Fpdi\PdfReader\PdfReader->getPage(8) #1 /home/pharmavipr/www/webservices/_common/tools/pdf/vendor/jurosh/pdf-merge/src/Jurosh/PDFMerge/PDFMerger.php(80): setasign\Fpdi\Fpdi->importPage(8) #2 /home/pharmavipr/www/webservices/_prod/app/service/storeFile.php(447): Jurosh\PDFMerge\PDFMerger->merge('file', '../../files/bdc...') #3 /home/pharmavipr/www/webservices/_prod/app/webservice.php(215): require_once('/home/pharmavip...') #4 {main} > will add file : Contrat_Diab_Connect_3690039460_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039460/20260126_10:55:23/Contrat_Diab_Connect_3690039460_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_Diab_Connect_3690039460_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039460 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 10:27:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039460 _________ Destinataires _________ to : phienivet@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : phienivet@gmail.com not addCC : phienivet@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phienivet@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039460/20260126_10:27:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039460/20260126_10:27:16 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690039460_26_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690039460_26_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690039460_26_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690039460_26_01_2026_detailLivraisons.png > will add file : 3690039460_26_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690039460/20260126_10:27:16/3690039460_26_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690039460_26_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690039460_26_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690039460_26_01_2026.pdf > will add file : BDC-engagement_3690039460_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039460/20260126_10:27:16/BDC-engagement_3690039460_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690039460_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690039460_26_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690039460_26_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690039460_26_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 24 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690039460_26_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690039460/20260126_10:27:16/BDC_XML-engagement_3690039460_26_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690039460_26_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phienivet@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039460 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phienivet@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 09:46:36 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022261 _________ Destinataires _________ to : pharmaciecentraleputtelange@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciecentraleputtelange@gmail.com not addCC : pharmaciecentraleputtelange@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciecentraleputtelange@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022261/20260126_09:46:36/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022261/20260126_09:46:36 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690022261_26_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690022261_26_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690022261_26_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690022261_26_01_2026_detailLivraisons.png > will add file : 3690022261_26_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:46:36/3690022261_26_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690022261_26_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690022261_26_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690022261_26_01_2026.pdf > will add file : BDC-engagement_3690022261_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:46:36/BDC-engagement_3690022261_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690022261_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690022261_26_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690022261_26_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690022261_26_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 25 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690022261_26_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:46:36/BDC_XML-engagement_3690022261_26_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690022261_26_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciecentraleputtelange@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciecentraleputtelange@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 09:33:50 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022261 _________ Destinataires _________ to : pharmaciecentraleputtelange@gmail.com cc : alexis.delfolie@roche.com,meylan.dccommandes@roche.com emailPharma : pharmaciecentraleputtelange@gmail.com not addCC : pharmaciecentraleputtelange@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.dccommandes@roche.com whiteList = pharmaciecentraleputtelange@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022261/20260126_09:33:50/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022261/20260126_09:33:50 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Accu-Fine_3690022261_26-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Accu-Fine_3690022261_26-01-2026.pdf ********* Offre Accu-Fine ********** Offre-Accu-Fine_3690022261_26-01-2026.pdf UPDATE Users SET iPadConnexion = '2026-01-26 09:33:50' WHERE login = 'alexis.delfolie@roche.com' > will add file : Offre-Accu-Fine_3690022261_26-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:33:50/Offre-Accu-Fine_3690022261_26-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Accu-Fine_3690022261_26-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmaciecentraleputtelange@gmail.com,alexis.delfolie@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciecentraleputtelange@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 09:27:58 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022261 _________ Destinataires _________ to : pharmaciecentraleputtelange@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciecentraleputtelange@gmail.com not addCC : pharmaciecentraleputtelange@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciecentraleputtelange@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022261/20260126_09:27:58/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022261/20260126_09:27:58 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690022261', 'alexis.delfolie@roche.com', 'offreSpeciale', '--', '2026-01-26 09:27:58') > will add file : Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:27:58/Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690022261_26-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'alexis.delfolie@roche.com' whiteList = pharmaciecentraleputtelange@gmail.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciecentraleputtelange@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 09:26:14 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022261 _________ Destinataires _________ to : pharmaciecentraleputtelange@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmaciecentraleputtelange@gmail.com not addCC : pharmaciecentraleputtelange@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmaciecentraleputtelange@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690022261' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690624171 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022261/20260126_09:26:14/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022261/20260126_09:26:14 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690022261_26_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690022261_26_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690022261_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690022261/20260126_09:26:14/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690022261_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690022261_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmaciecentraleputtelange@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022261 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciecentraleputtelange@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 09:15:25 - dirToStoreZip = ../../files/bdc/zippedFiles/3690011940 _________ Destinataires _________ to : pharmadeslacs@orange.fr cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmadeslacs@orange.fr not addCC : pharmadeslacs@orange.fr addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmadeslacs@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690011940/20260126_09:15:25/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690011940/20260126_09:15:25 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690011940_26_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690011940_26_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690011940_26_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690011940_26_01_2026_detailLivraisons.png > will add file : 3690011940_26_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690011940/20260126_09:15:25/3690011940_26_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690011940_26_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690011940_26_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690011940_26_01_2026.pdf > will add file : BDC-engagement_3690011940_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690011940/20260126_09:15:25/BDC-engagement_3690011940_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690011940_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690011940_26_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690011940_26_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690011940_26_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 40 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690011940_26_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690011940/20260126_09:15:25/BDC_XML-engagement_3690011940_26_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690011940_26_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmadeslacs@orange.fr,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690011940 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadeslacs@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 08:44:33 - dirToStoreZip = ../../files/bdc/zippedFiles/3690011940 _________ Destinataires _________ to : pharmadeslacs@orange.fr cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmadeslacs@orange.fr not addCC : pharmadeslacs@orange.fr addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmadeslacs@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690011940/20260126_08:44:33/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690011940/20260126_08:44:33 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690011940', 'alexis.delfolie@roche.com', 'offreSpeciale', '--', '2026-01-26 08:44:33') > will add file : Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690011940/20260126_08:44:33/Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690011940_26-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'alexis.delfolie@roche.com' whiteList = pharmadeslacs@orange.fr,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690011940 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadeslacs@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-26 08:43:37 - dirToStoreZip = ../../files/bdc/zippedFiles/3690011940 _________ Destinataires _________ to : pharmadeslacs@orange.fr cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmadeslacs@orange.fr not addCC : pharmadeslacs@orange.fr addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmadeslacs@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690011940' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041886 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690011940/20260126_08:43:37/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690011940/20260126_08:43:37 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690011940_26_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690011940_26_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690011940_26_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690011940/20260126_08:43:37/Contrat_utilisateur_PHARMABSOLU_3690011940_26_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690011940_26_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmadeslacs@orange.fr,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690011940 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadeslacs@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-23 09:16:46 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023820 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contrat_pharma@roche.com emailPharma : titulaires@pharmaciedescoquelicots.com addCC : Alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023820/20260123_09:16:46/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023820/20260123_09:16:46 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_Diab_Connect_3690023820_23_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_Diab_Connect_3690023820_23_01_2026.pdf ********* DIAB CONNECT ********** ##### ERR DiabConnect :InvalidArgumentException: Page number "8" out of available page range (1 - 7) in /home/pharmavipr/www/webservices/_common/tools/fpdi/src/PdfReader/PdfReader.php:129 Stack trace: #0 /home/pharmavipr/www/webservices/_common/tools/fpdi/src/FpdiTrait.php(260): setasign\Fpdi\PdfReader\PdfReader->getPage(8) #1 /home/pharmavipr/www/webservices/_common/tools/pdf/vendor/jurosh/pdf-merge/src/Jurosh/PDFMerge/PDFMerger.php(80): setasign\Fpdi\Fpdi->importPage(8) #2 /home/pharmavipr/www/webservices/_prod/app/service/storeFile.php(447): Jurosh\PDFMerge\PDFMerger->merge('file', '../../files/bdc...') #3 /home/pharmavipr/www/webservices/_prod/app/webservice.php(215): require_once('/home/pharmavip...') #4 {main} > will add file : Contrat_Diab_Connect_3690023820_23_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690023820/20260123_09:16:46/Contrat_Diab_Connect_3690023820_23_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_Diab_Connect_3690023820_23_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023820 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-22 16:38:18 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039038 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : cleyetmerleyutz@offisecure.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039038/20260122_16:38:18/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039038/20260122_16:38:18 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690039038_22_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690039038_22_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690039038_22_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039038/20260122_16:38:18/Contrat_utilisateur_PHARMABSOLU_3690039038_22_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690039038_22_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039038 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-22 16:38:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039440 _________ Destinataires _________ to : alexis.delfolie@roche.com cc : emailPharma : addCC : alexis.delfolie@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039440/20260122_16:38:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039440/20260122_16:38:09 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.png fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = kbisUpdate.png > will add file : kbisUpdate.png IN : ../../files/bdc/unzippedFiles/3690039440/20260122_16:38:09/kbisUpdate.png KBIS détecté bien envoyé au siège *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 3 dest = 'meylan.clients_dc@roche.com' dest = 'meylan.dccommandes@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = meylan.clients_dc@roche.com,meylan.dccommandes@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039440 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 14:43:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012058 _________ Destinataires _________ to : pharmacieccsd57@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacieccsd57@gmail.com not addCC : pharmacieccsd57@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacieccsd57@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690012058' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012058/20260121_14:43:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012058/20260121_14:43:09 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690012058_21_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690012058_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690012058_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012058/20260121_14:43:09/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690012058_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690012058_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacieccsd57@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012058 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieccsd57@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 13:24:51 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018875 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.baudouin@orange.fr addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018875/20260121_13:24:51/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018875/20260121_13:24:51 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690018875_21_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690018875_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690018875_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690018875/20260121_13:24:51/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690018875_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690018875_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690018875 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.632 ========================================= - 2026-01-21 10:03:28 - dirToStoreZip = ../../files/bdc/zippedFiles/3690039454 _________ Destinataires _________ to : pharmacieaumetz@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacieaumetz@gmail.com not addCC : pharmacieaumetz@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacieaumetz@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690039454' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041886 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690039454/20260121_10:03:28/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690039454/20260121_10:03:28 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690039454_21_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690039454_21_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690039454_21_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690039454/20260121_10:03:28/Contrat_utilisateur_PHARMABSOLU_3690039454_21_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690039454_21_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacieaumetz@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690039454 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieaumetz@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-20 15:31:26 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012950 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacie.killian@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012950/20260120_15:31:26/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012950/20260120_15:31:26 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012950_20_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012950_20_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012950_20_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012950/20260120_15:31:26/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012950_20_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012950_20_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012950 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-20 10:11:07 - dirToStoreZip = ../../files/bdc/zippedFiles/3690021368 _________ Destinataires _________ to : pharmadulion@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmadulion@gmail.com not addCC : pharmadulion@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmadulion@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690021368/20260120_10:11:07/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690021368/20260120_10:11:07 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690021368_20_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690021368_20_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690021368_20_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690021368_20_01_2026_detailLivraisons.png > will add file : 3690021368_20_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690021368/20260120_10:11:07/3690021368_20_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690021368_20_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690021368_20_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690021368_20_01_2026.pdf > will add file : BDC-engagement_3690021368_20_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690021368/20260120_10:11:07/BDC-engagement_3690021368_20_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690021368_20_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690021368_20_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690021368_20_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690021368_20_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690021368_20_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690021368/20260120_10:11:07/BDC_XML-engagement_3690021368_20_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690021368_20_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmadulion@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690021368 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadulion@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-20 10:10:52 - dirToStoreZip = ../../files/bdc/zippedFiles/3690021368 _________ Destinataires _________ to : pharmadulion@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmadulion@gmail.com not addCC : pharmadulion@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmadulion@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690021368' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690041886 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690021368/20260120_10:10:52/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690021368/20260120_10:10:52 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690021368_20_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690021368_20_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690021368_20_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690021368/20260120_10:10:52/Contrat_utilisateur_PHARMABSOLU_3690021368_20_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690021368_20_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmadulion@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690021368 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmadulion@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 13:18:55 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014632 _________ Destinataires _________ to : alexis.delfolie@roche.com cc : emailPharma : addCC : alexis.delfolie@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014632/20260119_13:18:55/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014632/20260119_13:18:55 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.png fileNameToSend = rib.png fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = kbisUpdate.png > will add file : kbisUpdate.png IN : ../../files/bdc/unzippedFiles/3690014632/20260119_13:18:55/kbisUpdate.png KBIS détecté bien envoyé au siège *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = rib.png > will add file : rib.png IN : ../../files/bdc/unzippedFiles/3690014632/20260119_13:18:55/rib.png RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 4 dest = 'alexis.delfolie@roche.com' dest = 'meylan.clients_dc@roche.com' dest = 'france.diabetescare-adv@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = alexis.delfolie@roche.com,meylan.clients_dc@roche.com,france.diabetescare-adv@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014632 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 13:17:54 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014632 _________ Destinataires _________ to : alexis.delfolie@roche.com cc : emailPharma : addCC : alexis.delfolie@roche.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014632/20260119_13:17:54/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014632/20260119_13:17:54 is NOT Pharma Beta... is NOT Pharma ROC... ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.png fileNameToSend = rib.png fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = kbisUpdate.png > will add file : kbisUpdate.png IN : ../../files/bdc/unzippedFiles/3690014632/20260119_13:17:54/kbisUpdate.png KBIS détecté bien envoyé au siège *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = rib.png > will add file : rib.png IN : ../../files/bdc/unzippedFiles/3690014632/20260119_13:17:54/rib.png RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 4 dest = 'alexis.delfolie@roche.com' dest = 'meylan.clients_dc@roche.com' dest = 'france.diabetescare-adv@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = alexis.delfolie@roche.com,meylan.clients_dc@roche.com,france.diabetescare-adv@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014632 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 09:44:03 - dirToStoreZip = ../../files/bdc/zippedFiles/3690037478 _________ Destinataires _________ to : pharmacie.picasso@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.picasso@gmail.com not addCC : pharmacie.picasso@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.picasso@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690037478/20260119_09:44:03/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690037478/20260119_09:44:03 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690037478_19_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690037478_19_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690037478_19_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690037478_19_01_2026_detailLivraisons.png > will add file : 3690037478_19_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690037478/20260119_09:44:03/3690037478_19_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690037478_19_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690037478_19_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690037478_19_01_2026.pdf > will add file : BDC-engagement_3690037478_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690037478/20260119_09:44:03/BDC-engagement_3690037478_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690037478_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690037478_19_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690037478_19_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690037478_19_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690037478_19_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690037478/20260119_09:44:03/BDC_XML-engagement_3690037478_19_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690037478_19_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.picasso@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690037478 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.picasso@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-19 09:20:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690037478 _________ Destinataires _________ to : pharmacie.picasso@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacie.picasso@gmail.com not addCC : pharmacie.picasso@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacie.picasso@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690037478' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690037478/20260119_09:20:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690037478/20260119_09:20:45 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690037478_19_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690037478_19_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690037478_19_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690037478/20260119_09:20:45/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690037478_19_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690037478_19_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacie.picasso@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690037478 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.picasso@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 15:33:36 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014616 _________ Destinataires _________ to : pharma.stecroix@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharma.stecroix@gmail.com not addCC : pharma.stecroix@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharma.stecroix@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014616/20260115_15:33:36/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014616/20260115_15:33:36 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690014616_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690014616_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690014616_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690014616_15_01_2026_detailLivraisons.png > will add file : 3690014616_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690014616/20260115_15:33:36/3690014616_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690014616_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690014616_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690014616_15_01_2026.pdf > will add file : BDC-engagement_3690014616_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690014616/20260115_15:33:36/BDC-engagement_3690014616_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690014616_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690014616_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690014616_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690014616_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690014616_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690014616/20260115_15:33:36/BDC_XML-engagement_3690014616_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690014616_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharma.stecroix@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014616 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharma.stecroix@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 15:24:20 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014616 _________ Destinataires _________ to : pharma.stecroix@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharma.stecroix@gmail.com not addCC : pharma.stecroix@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharma.stecroix@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690014616' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690624171 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014616/20260115_15:24:20/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014616/20260115_15:24:20 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014616_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014616_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014616_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690014616/20260115_15:24:20/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014616_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014616_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharma.stecroix@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014616 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharma.stecroix@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 14:48:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690335588 _________ Destinataires _________ to : pharmacieduwarndt@orange.fr cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacieduwarndt@orange.fr not addCC : pharmacieduwarndt@orange.fr addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacieduwarndt@orange.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690335588/20260115_14:48:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690335588/20260115_14:48:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690335588_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690335588_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690335588_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690335588_15_01_2026_detailLivraisons.png > will add file : 3690335588_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690335588/20260115_14:48:00/3690335588_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690335588_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690335588_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690335588_15_01_2026.pdf > will add file : BDC-engagement_3690335588_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690335588/20260115_14:48:00/BDC-engagement_3690335588_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690335588_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690335588_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690335588_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690335588_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 12 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690335588_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690335588/20260115_14:48:00/BDC_XML-engagement_3690335588_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690335588_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacieduwarndt@orange.fr,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690335588 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieduwarndt@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:54:59 - dirToStoreZip = ../../files/bdc/zippedFiles/3690021898 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciepasteur57180@gmail.com addCC : Alexis.delfolie@roche.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690021898/20260115_13:54:59/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690021898/20260115_13:54:59 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690021898_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690021898_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690021898_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690021898_15_01_2026_detailLivraisons.png > will add file : 3690021898_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690021898/20260115_13:54:59/3690021898_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690021898_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690021898_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690021898_15_01_2026.pdf > will add file : BDC-engagement_3690021898_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690021898/20260115_13:54:59/BDC-engagement_3690021898_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690021898_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690021898_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690021898_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690021898_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690021898_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690021898/20260115_13:54:59/BDC_XML-engagement_3690021898_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690021898_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690021898 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:40:40 - dirToStoreZip = ../../files/bdc/zippedFiles/3690021898 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciepasteur57180@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690021898/20260115_13:40:40/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690021898/20260115_13:40:40 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690021898_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690021898_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690021898_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690021898/20260115_13:40:40/Contrat_utilisateur_PHARMABSOLU_3690021898_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690021898_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690021898 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:38:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025704 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedubreuil@offisecure.com addCC : Alexis.delfolie@roche.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025704/20260115_13:38:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025704/20260115_13:38:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690025704_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690025704_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690025704_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690025704_15_01_2026_detailLivraisons.png > will add file : 3690025704_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690025704/20260115_13:38:00/3690025704_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690025704_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690025704_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690025704_15_01_2026.pdf > will add file : BDC-engagement_3690025704_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025704/20260115_13:38:00/BDC-engagement_3690025704_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690025704_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690025704_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690025704_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690025704_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690025704_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690025704/20260115_13:38:00/BDC_XML-engagement_3690025704_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690025704_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025704 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:35:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690025704 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedubreuil@offisecure.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690025704/20260115_13:35:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690025704/20260115_13:35:45 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690025704_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690025704_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690025704_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690025704/20260115_13:35:45/Contrat_utilisateur_PHARMABSOLU_3690025704_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690025704_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690025704 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:31:40 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016921 _________ Destinataires _________ to : phiedupuitsmax@offisecure.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : phiedupuitsmax@offisecure.com not addCC : phiedupuitsmax@offisecure.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phiedupuitsmax@offisecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016921/20260115_13:31:40/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016921/20260115_13:31:40 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690016921_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690016921_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690016921_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690016921_15_01_2026_detailLivraisons.png > will add file : 3690016921_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690016921/20260115_13:31:40/3690016921_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690016921_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690016921_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690016921_15_01_2026.pdf > will add file : BDC-engagement_3690016921_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016921/20260115_13:31:40/BDC-engagement_3690016921_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690016921_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690016921_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690016921_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690016921_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690016921_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016921/20260115_13:31:40/BDC_XML-engagement_3690016921_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690016921_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phiedupuitsmax@offisecure.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016921 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phiedupuitsmax@offisecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:28:19 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016921 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : phiedupuitsmax@offisecure.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016921/20260115_13:28:19/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016921/20260115_13:28:19 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690016921_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690016921_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690016921_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016921/20260115_13:28:19/Contrat_utilisateur_PHARMABSOLU_3690016921_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690016921_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016921 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:27:09 - dirToStoreZip = ../../files/bdc/zippedFiles/3690034512 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.sauder@wanadoo.fr addCC : Alexis.delfolie@roche.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690034512/20260115_13:27:09/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690034512/20260115_13:27:09 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690034512_15_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690034512_15_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690034512_15_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690034512_15_01_2026_detailLivraisons.png > will add file : 3690034512_15_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690034512/20260115_13:27:09/3690034512_15_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690034512_15_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690034512_15_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690034512_15_01_2026.pdf > will add file : BDC-engagement_3690034512_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690034512/20260115_13:27:09/BDC-engagement_3690034512_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690034512_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690034512_15_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690034512_15_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690034512_15_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690034512_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690034512/20260115_13:27:09/BDC_XML-engagement_3690034512_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690034512_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690034512 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:23:23 - dirToStoreZip = ../../files/bdc/zippedFiles/3690034512 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.sauder@wanadoo.fr addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690034512/20260115_13:23:23/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690034512/20260115_13:23:23 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690034512/20260115_13:23:23/Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690034512 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 13:22:31 - dirToStoreZip = ../../files/bdc/zippedFiles/3690034512 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie.sauder@wanadoo.fr addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690034512/20260115_13:22:31/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690034512/20260115_13:22:31 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690034512/20260115_13:22:31/Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_PHARMABSOLU_3690034512_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690034512 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-15 11:41:20 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016724 _________ Destinataires _________ to : phie.breckelberg@offisecure.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : phie.breckelberg@offisecure.com not addCC : phie.breckelberg@offisecure.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = phie.breckelberg@offisecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016724/20260115_11:41:20/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016724/20260115_11:41:20 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-service_3690016724_15_01_2026.pdf fileNameToSend = Services_XML_3690016724_15_01_2026.xml 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 = BDC-service_3690016724_15_01_2026.pdf ********* SERVICES ********** infoContact = REF found 10432217001 REF poz1 ==> 1.1/ emailBody = Bonjour Madame, Bonjour Monsieur, Je vous remercie pour notre rendez-vous de ce jour. Pour faire suite à notre échange et dans le cadre de notre offre de services Accu-Chek, j’ai le plaisir de confirmer le déclenchement de votre service personnalisé. Je vous remercie de votre confiance et reste à votre entière disposition pour répondre à vos éventuelles questions. Cordialement, ==> 2.1/ emailBody = Bonjour Madame, Bonjour Monsieur, Je vous remercie pour notre rendez-vous de ce jour. Pour faire suite à notre échange et dans le cadre de notre offre de services Accu-Chek, j’ai le plaisir de confirmer le déclenchement de votre service personnalisé.

En tant que partenaire de Roche Diagnostics, vous bénéficiez d’un suivi et une gestion de vos commandes et services à tout moment par téléphone 04 76 76 30 38, par email meylan.dccommandes@roche.com ou sur www.myaccuchek.fr Je vous remercie de votre confiance et reste à votre entière disposition pour répondre à vos éventuelles questions. Cordialement, **************************** > will add file : BDC-service_3690016724_15_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016724/20260115_11:41:20/BDC-service_3690016724_15_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-service_3690016724_15_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = Services_XML_3690016724_15_01_2026.xml ********* XML BDC SERVICES FILE ********** fileNameToSend = Services_XML_3690016724_15_01_2026.xml > will add file : Services_XML_3690016724_15_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690016724/20260115_11:41:20/Services_XML_3690016724_15_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : Services_XML_3690016724_15_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = phie.breckelberg@offisecure.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016724 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"phie.breckelberg@offisecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-14 11:48:41 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024287 _________ Destinataires _________ to : pharmacie-lorraine@wanadoo.fr cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie-lorraine@wanadoo.fr not addCC : pharmacie-lorraine@wanadoo.fr addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie-lorraine@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024287/20260114_11:48:41/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024287/20260114_11:48:41 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690024287_14_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690024287_14_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690024287_14_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690024287_14_01_2026_detailLivraisons.png > will add file : 3690024287_14_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690024287/20260114_11:48:41/3690024287_14_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690024287_14_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690024287_14_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690024287_14_01_2026.pdf > will add file : BDC-engagement_3690024287_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690024287/20260114_11:48:41/BDC-engagement_3690024287_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690024287_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690024287_14_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690024287_14_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690024287_14_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690024287_14_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690024287/20260114_11:48:41/BDC_XML-engagement_3690024287_14_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690024287_14_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie-lorraine@wanadoo.fr,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690024287 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie-lorraine@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-14 11:32:39 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024287 _________ Destinataires _________ to : pharmacie-lorraine@orange.fr cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacie-lorraine@orange.fr not addCC : pharmacie-lorraine@orange.fr addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacie-lorraine@orange.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690024287' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024287/20260114_11:32:39/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024287/20260114_11:32:39 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690024287_14_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690024287_14_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690024287_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690024287/20260114_11:32:39/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690024287_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690024287_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacie-lorraine@orange.fr,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690024287 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie-lorraine@orange.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-14 09:22:21 - dirToStoreZip = ../../files/bdc/zippedFiles/3690017540 _________ Destinataires _________ to : elisabeth.cransac@wanadoo.fr cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : elisabeth.cransac@wanadoo.fr not addCC : elisabeth.cransac@wanadoo.fr addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = elisabeth.cransac@wanadoo.fr __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690017540/20260114_09:22:21/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690017540/20260114_09:22:21 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690017540_14_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690017540_14_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690017540_14_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690017540_14_01_2026_detailLivraisons.png > will add file : 3690017540_14_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690017540/20260114_09:22:21/3690017540_14_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690017540_14_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690017540_14_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690017540_14_01_2026.pdf > will add file : BDC-engagement_3690017540_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690017540/20260114_09:22:21/BDC-engagement_3690017540_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690017540_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690017540_14_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690017540_14_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690017540_14_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 40 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690017540_14_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690017540/20260114_09:22:21/BDC_XML-engagement_3690017540_14_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690017540_14_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = elisabeth.cransac@wanadoo.fr,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690017540 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"elisabeth.cransac@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-14 09:12:53 - dirToStoreZip = ../../files/bdc/zippedFiles/3690017540 _________ Destinataires _________ to : elisabeth.cransac@wanadoo.fr cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : elisabeth.cransac@wanadoo.fr not addCC : elisabeth.cransac@wanadoo.fr addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = elisabeth.cransac@wanadoo.fr __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690017540' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690017540/20260114_09:12:53/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690017540/20260114_09:12:53 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690017540_14_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690017540_14_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690017540_14_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690017540/20260114_09:12:53/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690017540_14_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690017540_14_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = elisabeth.cransac@wanadoo.fr,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690017540 signWithDocuSign = attachmentToSign = Will try to get fonction fonctionFromDb = Sales Product Specialist DC isPharmaRoc = false CURL response = {"status":"ok", "dest":"elisabeth.cransac@wanadoo.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.631 ========================================= - 2026-01-13 08:06:15 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012073 _________ Destinataires _________ to : pharmaciedelorne57@outlook.fr cc : emailPharma : not addCC : pharmaciedelorne57@outlook.fr not addCC : whiteList = pharmaciedelorne57@outlook.fr, __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012073/20260113_08:06:15/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012073/20260113_08:06:15 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = kbisUpdate.png fileNameToSend = rib.png fileNameToSend = sepa.pdf 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 = kbisUpdate.png > will add file : kbisUpdate.png IN : ../../files/bdc/unzippedFiles/3690012073/20260113_08:06:15/kbisUpdate.png KBIS détecté bien envoyé au siège *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = rib.png > will add file : rib.png IN : ../../files/bdc/unzippedFiles/3690012073/20260113_08:06:15/rib.png RIB détecté adding meylan.clients_dc@roche.com position 1 *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = sepa.pdf > will add file : sepa.pdf IN : ../../files/bdc/unzippedFiles/3690012073/20260113_08:06:15/sepa.pdf File not kbis & not rib *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 4 dest = 'alexis.delfolie@roche.com' dest = 'meylan.clients_dc@roche.com' dest = 'france.diabetescare-adv@roche.com' dest = 'meylan.dccommandes@roche.com' whiteList = pharmaciedelorne57@outlook.fr,,alexis.delfolie@roche.com,meylan.clients_dc@roche.com,france.diabetescare-adv@roche.com,meylan.dccommandes@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012073 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelorne57@outlook.fr"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 15:20:16 - dirToStoreZip = ../../files/bdc/zippedFiles/3690033961 _________ Destinataires _________ to : pharmacieposte.rombas@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacieposte.rombas@gmail.com not addCC : pharmacieposte.rombas@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacieposte.rombas@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690033961/20260112_15:20:16/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690033961/20260112_15:20:16 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690033961_12_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690033961_12_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690033961_12_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690033961_12_01_2026_detailLivraisons.png > will add file : 3690033961_12_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690033961/20260112_15:20:16/3690033961_12_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690033961_12_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690033961_12_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690033961_12_01_2026.pdf > will add file : BDC-engagement_3690033961_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690033961/20260112_15:20:16/BDC-engagement_3690033961_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690033961_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690033961_12_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690033961_12_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690033961_12_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 10 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690033961_12_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690033961/20260112_15:20:16/BDC_XML-engagement_3690033961_12_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690033961_12_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacieposte.rombas@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690033961 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieposte.rombas@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 14:57:08 - dirToStoreZip = ../../files/bdc/zippedFiles/3690033961 _________ Destinataires _________ to : pharmacieposte.rombas@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : nicaise.pharmamoselle@offisecure.com not addCC : pharmacieposte.rombas@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacieposte.rombas@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690033961' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690033961/20260112_14:57:08/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690033961/20260112_14:57:08 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690033961_12_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690033961_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690033961_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690033961/20260112_14:57:08/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690033961_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690033961_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacieposte.rombas@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690033961 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacieposte.rombas@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 13:48:04 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024201 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmafalck@icloud.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024201/20260112_13:48:04/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024201/20260112_13:48:04 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690024201_12_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690024201_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690024201_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690024201/20260112_13:48:04/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690024201_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690024201_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690024201 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-12 13:42:32 - dirToStoreZip = ../../files/bdc/zippedFiles/3690018757 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacie-fleurentin@orange.fr addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690018757/20260112_13:42:32/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690018757/20260112_13:42:32 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690018757_12_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690018757_12_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690018757_12_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690018757/20260112_13:42:32/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690018757_12_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690018757_12_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690018757 signWithDocuSign = attachmentToSign = Will NOT try to get fonction isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-09 11:29:10 - dirToStoreZip = ../../files/bdc/zippedFiles/3690022100 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : ph.auloge@wanadoo.fr addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690022100/20260109_11:29:10/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690022100/20260109_11:29:10 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690022100_09_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690022100_09_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690022100_09_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690022100/20260109_11:29:10/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690022100_09_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690022100_09_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690022100 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 18:03:54 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012417 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedejailly@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012417/20260108_18:03:54/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012417/20260108_18:03:54 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012417/20260108_18:03:54/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012417 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 17:50:43 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012417 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmaciedejailly@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012417/20260108_17:50:43/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012417/20260108_17:50:43 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012417/20260108_17:50:43/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012417_08_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012417 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 16:46:54 - dirToStoreZip = ../../files/bdc/zippedFiles/3690019583 _________ Destinataires _________ to : Alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : phiefleury@gmail.com addCC : Alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690019583/20260108_16:46:54/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690019583/20260108_16:46:54 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690019583_08_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690019583_08_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690019583_08_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690019583/20260108_16:46:54/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690019583_08_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690019583_08_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690019583 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"Alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 15:05:17 - dirToStoreZip = ../../files/bdc/zippedFiles/3690020197 _________ Destinataires _________ to : pharmacie.ste.agathe@offisecure.com cc : meylan.contrat_pharma@roche.com,Alexis.delfolie@roche.com emailPharma : pharmacie.ste.agathe@offisecure.com not addCC : pharmacie.ste.agathe@offisecure.com addCC : meylan.contrat_pharma@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmacie.ste.agathe@offisecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690020197/20260108_15:05:17/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690020197/20260108_15:05:17 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_Diab_Connect_3690020197_08_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_Diab_Connect_3690020197_08_01_2026.pdf ********* DIAB CONNECT ********** ##### ERR DiabConnect :InvalidArgumentException: Page number "8" out of available page range (1 - 7) in /home/pharmavipr/www/webservices/_common/tools/fpdi/src/PdfReader/PdfReader.php:129 Stack trace: #0 /home/pharmavipr/www/webservices/_common/tools/fpdi/src/FpdiTrait.php(260): setasign\Fpdi\PdfReader\PdfReader->getPage(8) #1 /home/pharmavipr/www/webservices/_common/tools/pdf/vendor/jurosh/pdf-merge/src/Jurosh/PDFMerge/PDFMerger.php(80): setasign\Fpdi\Fpdi->importPage(8) #2 /home/pharmavipr/www/webservices/_prod/app/service/storeFile.php(438): Jurosh\PDFMerge\PDFMerger->merge('file', '../../files/bdc...') #3 /home/pharmavipr/www/webservices/_prod/app/webservice.php(214): require_once('/home/pharmavip...') #4 {main} > will add file : Contrat_Diab_Connect_3690020197_08_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690020197/20260108_15:05:17/Contrat_Diab_Connect_3690020197_08_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_Diab_Connect_3690020197_08_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contrat_pharma@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacie.ste.agathe@offisecure.com,meylan.contrat_pharma@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690020197 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.ste.agathe@offisecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 15:04:04 - dirToStoreZip = ../../files/bdc/zippedFiles/3690020197 _________ Destinataires _________ to : pharmacie.ste.agathe@offisecure.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie.ste.agathe@offisecure.com not addCC : pharmacie.ste.agathe@offisecure.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie.ste.agathe@offisecure.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690020197/20260108_15:04:04/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690020197/20260108_15:04:04 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690020197_08_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690020197_08_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690020197_08_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690020197_08_01_2026_detailLivraisons.png > will add file : 3690020197_08_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690020197/20260108_15:04:04/3690020197_08_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690020197_08_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690020197_08_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690020197_08_01_2026.pdf > will add file : BDC-engagement_3690020197_08_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690020197/20260108_15:04:04/BDC-engagement_3690020197_08_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690020197_08_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690020197_08_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690020197_08_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690020197_08_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 30 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690020197_08_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690020197/20260108_15:04:04/BDC_XML-engagement_3690020197_08_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690020197_08_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie.ste.agathe@offisecure.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690020197 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie.ste.agathe@offisecure.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-08 08:52:26 - dirToStoreZip = ../../files/bdc/zippedFiles/3690024426 _________ Destinataires _________ to : helkartite@sqli.com cc : emailPharma : addCC : helkartite@sqli.com not addCC : whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690024426/20260108_08:52:26/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690024426/20260108_08:52:26 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = photo1.png fileNameToSend = photo2.png fileToBeAdded = 2 nbFilesToSend = 4 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . ********* Support email ********** . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. ********* Support email ********** .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = photo1.png ********* Support email ********** photo1.png > will add file : photo1.png IN : ../../files/bdc/unzippedFiles/3690024426/20260108_08:52:26/photo1.png File not kbis & not rib PNG détecté *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = photo2.png ********* Support email ********** photo2.png > will add file : photo2.png IN : ../../files/bdc/unzippedFiles/3690024426/20260108_08:52:26/photo2.png File not kbis & not rib PNG détecté *** END FOR LOOP *** END FOR reached errmsg = debug mode : not sent to OFSAD nbRecipient = 3 dest = 'lyon.rochedc.pharmavisite@sqli.com' dest = 'alexis.delfolie@roche.com' dest = 'ines.benabid@roche.com' whiteList = lyon.rochedc.pharmavisite@sqli.com,alexis.delfolie@roche.com,ines.benabid@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"helkartite@sqli.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-07 10:00:45 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038966 _________ Destinataires _________ to : lapharmaciedelalicorne@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : lapharmaciedelalicorne@gmail.com not addCC : lapharmaciedelalicorne@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = lapharmaciedelalicorne@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038966/20260107_10:00:45/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038966/20260107_10:00:45 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690038966_07_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690038966_07_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690038966_07_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690038966_07_01_2026_detailLivraisons.png > will add file : 3690038966_07_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690038966/20260107_10:00:45/3690038966_07_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690038966_07_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690038966_07_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690038966_07_01_2026.pdf > will add file : BDC-engagement_3690038966_07_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690038966/20260107_10:00:45/BDC-engagement_3690038966_07_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690038966_07_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690038966_07_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690038966_07_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690038966_07_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690038966_07_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690038966/20260107_10:00:45/BDC_XML-engagement_3690038966_07_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690038966_07_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = lapharmaciedelalicorne@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038966 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"lapharmaciedelalicorne@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-07 09:44:00 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038966 _________ Destinataires _________ to : lapharmaciedelalicorne@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : lapharmaciedelalicorne@gmail.com not addCC : lapharmaciedelalicorne@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = lapharmaciedelalicorne@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038966/20260107_09:44:00/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038966/20260107_09:44:00 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = BDC-service_3690038966_07_01_2026.pdf fileNameToSend = Services_XML_3690038966_07_01_2026.xml 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 = BDC-service_3690038966_07_01_2026.pdf ********* SERVICES ********** infoContact = REF found 10432217001 REF poz1 ==> 1.1/ emailBody = Bonjour Madame, Bonjour Monsieur, Je vous remercie pour notre rendez-vous de ce jour. Pour faire suite à notre échange et dans le cadre de notre offre de services Accu-Chek, j’ai le plaisir de confirmer le déclenchement de votre service personnalisé. Je vous remercie de votre confiance et reste à votre entière disposition pour répondre à vos éventuelles questions. Cordialement, ==> 2.1/ emailBody = Bonjour Madame, Bonjour Monsieur, Je vous remercie pour notre rendez-vous de ce jour. Pour faire suite à notre échange et dans le cadre de notre offre de services Accu-Chek, j’ai le plaisir de confirmer le déclenchement de votre service personnalisé.

En tant que partenaire de Roche Diagnostics, vous bénéficiez d’un suivi et une gestion de vos commandes et services à tout moment par téléphone 04 76 76 30 38, par email meylan.dccommandes@roche.com ou sur www.myaccuchek.fr Je vous remercie de votre confiance et reste à votre entière disposition pour répondre à vos éventuelles questions. Cordialement, **************************** > will add file : BDC-service_3690038966_07_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690038966/20260107_09:44:00/BDC-service_3690038966_07_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-service_3690038966_07_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = Services_XML_3690038966_07_01_2026.xml ********* XML BDC SERVICES FILE ********** fileNameToSend = Services_XML_3690038966_07_01_2026.xml > will add file : Services_XML_3690038966_07_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690038966/20260107_09:44:00/Services_XML_3690038966_07_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : Services_XML_3690038966_07_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = lapharmaciedelalicorne@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038966 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"lapharmaciedelalicorne@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-07 09:36:58 - dirToStoreZip = ../../files/bdc/zippedFiles/3690038966 _________ Destinataires _________ to : lapharmaciedelalicorne@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : lapharmaciedelalicorne@gmail.com not addCC : lapharmaciedelalicorne@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = lapharmaciedelalicorne@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690038966' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690621051 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690038966/20260107_09:36:58/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690038966/20260107_09:36:58 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690038966_07_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690038966_07_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690038966_07_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690038966/20260107_09:36:58/Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690038966_07_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_SYNESIUS-COOPERATIVE_3690038966_07_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = lapharmaciedelalicorne@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690038966 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"lapharmaciedelalicorne@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 13:32:22 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012452 _________ Destinataires _________ to : pharmaciedelacolline57500@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmaciedelacolline57500@gmail.com not addCC : pharmaciedelacolline57500@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmaciedelacolline57500@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012452/20260106_13:32:22/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012452/20260106_13:32:22 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690012452_06_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690012452_06_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690012452_06_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690012452_06_01_2026_detailLivraisons.png > will add file : 3690012452_06_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690012452/20260106_13:32:22/3690012452_06_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690012452_06_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690012452_06_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690012452_06_01_2026.pdf > will add file : BDC-engagement_3690012452_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012452/20260106_13:32:22/BDC-engagement_3690012452_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690012452_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690012452_06_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690012452_06_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690012452_06_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 15 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690012452_06_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690012452/20260106_13:32:22/BDC_XML-engagement_3690012452_06_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690012452_06_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmaciedelacolline57500@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012452 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelacolline57500@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 13:20:01 - dirToStoreZip = ../../files/bdc/zippedFiles/3690012452 _________ Destinataires _________ to : pharmaciedelacolline57500@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : pharmaciedelacolline57500@gmail.com not addCC : pharmaciedelacolline57500@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = pharmaciedelacolline57500@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690012452' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690624171 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690012452/20260106_13:20:01/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690012452/20260106_13:20:01 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012452_06_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012452_06_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012452_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690012452/20260106_13:20:01/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012452_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690012452_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmaciedelacolline57500@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690012452 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmaciedelacolline57500@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 11:48:25 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014751 _________ Destinataires _________ to : ch.pharmaciecentrale@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : ch.pharmaciecentrale@gmail.com not addCC : ch.pharmaciecentrale@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = ch.pharmaciecentrale@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014751/20260106_11:48:25/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014751/20260106_11:48:25 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690014751_06_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690014751_06_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690014751_06_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690014751_06_01_2026_detailLivraisons.png > will add file : 3690014751_06_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690014751/20260106_11:48:25/3690014751_06_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690014751_06_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690014751_06_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690014751_06_01_2026.pdf > will add file : BDC-engagement_3690014751_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690014751/20260106_11:48:25/BDC-engagement_3690014751_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690014751_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690014751_06_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690014751_06_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690014751_06_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 30 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690014751_06_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690014751/20260106_11:48:25/BDC_XML-engagement_3690014751_06_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690014751_06_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = ch.pharmaciecentrale@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014751 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"ch.pharmaciecentrale@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 11:26:37 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014751 _________ Destinataires _________ to : ch.pharmaciecentrale@gmail.com cc : meylan.contratutilisateur@roche.com,Alexis.delfolie@roche.com emailPharma : ch.pharmaciecentrale@gmail.com not addCC : ch.pharmaciecentrale@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : Alexis.delfolie@roche.com whiteList = ch.pharmaciecentrale@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690014751' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690624171 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014751/20260106_11:26:37/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014751/20260106_11:26:37 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014751_06_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014751_06_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014751_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690014751/20260106_11:26:37/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014751_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690014751_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = ch.pharmaciecentrale@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014751 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"ch.pharmaciecentrale@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 11:25:27 - dirToStoreZip = ../../files/bdc/zippedFiles/3690014751 _________ Destinataires _________ to : ch.pharmaciecentrale@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : ch.pharmaciecentrale@gmail.com not addCC : ch.pharmaciecentrale@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = ch.pharmaciecentrale@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690014751/20260106_11:25:27/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690014751/20260106_11:25:27 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690014751', 'alexis.delfolie@roche.com', 'offreSpeciale', '--', '2026-01-06 11:25:27') > will add file : Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690014751/20260106_11:25:27/Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690014751_06-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'alexis.delfolie@roche.com' whiteList = ch.pharmaciecentrale@gmail.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690014751 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"ch.pharmaciecentrale@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 10:53:36 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023311 _________ Destinataires _________ to : pharmacie57740@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie57740@gmail.com not addCC : pharmacie57740@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie57740@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023311/20260106_10:53:36/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023311/20260106_10:53:36 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = 3690023311_06_01_2026_detailLivraisons.png fileNameToSend = BDC-engagement_3690023311_06_01_2026.pdf fileNameToSend = BDC_XML-engagement_3690023311_06_01_2026.xml fileToBeAdded = 3 nbFilesToSend = 5 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = 3690023311_06_01_2026_detailLivraisons.png > will add file : 3690023311_06_01_2026_detailLivraisons.png IN : ../../files/bdc/unzippedFiles/3690023311/20260106_10:53:36/3690023311_06_01_2026_detailLivraisons.png File not kbis & not rib PNG détecté Tentative Envoi sur OFSAD de : 3690023311_06_01_2026_detailLivraisons.png... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 3/ fileNameToSend = BDC-engagement_3690023311_06_01_2026.pdf ********* CONTRAT PRODUIT ********** fileNameToSend = BDC-engagement_3690023311_06_01_2026.pdf > will add file : BDC-engagement_3690023311_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690023311/20260106_10:53:36/BDC-engagement_3690023311_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : BDC-engagement_3690023311_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 4/ fileNameToSend = BDC_XML-engagement_3690023311_06_01_2026.xml ********* XML BDC PRODUIT FILE ********** fileNameToSend = BDC_XML-engagement_3690023311_06_01_2026.xml XML LOADED SUCCESS : BDC_XML-engagement_3690023311_06_01_2026.xml XML LOADED SUCCESS 1 XML LOADED SUCCESS will call insertContrat... will call insertContratProductQte... in else nbSetGuideTotal = 20 isMadActive = setContratUtilisateurHasAcGuideValueCommande NOT CALLED > will add file : BDC_XML-engagement_3690023311_06_01_2026.xml IN : ../../files/bdc/unzippedFiles/3690023311/20260106_10:53:36/BDC_XML-engagement_3690023311_06_01_2026.xml File not kbis & not rib Tentative Envoi sur OFSAD de : BDC_XML-engagement_3690023311_06_01_2026.xml... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contrat_pharma@roche.com' whiteList = pharmacie57740@gmail.com,alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023311 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie57740@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 10:18:28 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023311 _________ Destinataires _________ to : pharmacie57740@gmail.com cc : meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com emailPharma : pharmacie57740@gmail.com not addCC : pharmacie57740@gmail.com addCC : meylan.contratutilisateur@roche.com addCC : alexis.delfolie@roche.com whiteList = pharmacie57740@gmail.com __________________________________ ###### SETTING ID GPT on curl params queryGetPharma = SELECT gptId FROM Pharmacies WHERE idPharma = '3690023311' ID GPT NOT RECEIVED. RETREIVED => idGpt = 3690624171 ###### - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023311/20260106_10:18:28/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023311/20260106_10:18:28 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690023311_06_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690023311_06_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690023311_06_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690023311/20260106_10:18:28/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690023311_06_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690023311_06_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'meylan.contratutilisateur@roche.com' dest = 'alexis.delfolie@roche.com' whiteList = pharmacie57740@gmail.com,meylan.contratutilisateur@roche.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023311 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie57740@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-06 10:15:14 - dirToStoreZip = ../../files/bdc/zippedFiles/3690023311 _________ Destinataires _________ to : pharmacie57740@gmail.com cc : alexis.delfolie@roche.com,meylan.contrat_pharma@roche.com emailPharma : pharmacie57740@gmail.com not addCC : pharmacie57740@gmail.com addCC : alexis.delfolie@roche.com addCC : meylan.contrat_pharma@roche.com whiteList = pharmacie57740@gmail.com __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690023311/20260106_10:15:14/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690023311/20260106_10:15:14 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf ********* Offre-Special-Accu-chek ********** Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf explodedText[0] = du 01/01/2026 explodedText2 = INSERT INTO OffreSpeciale (idPharma, emailIcpo, typeOffre, dateDebutSelected, dateInsert) VALUES ( '3690023311', 'alexis.delfolie@roche.com', 'offreSpeciale', '--', '2026-01-06 10:15:14') > will add file : Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf IN : ../../files/bdc/unzippedFiles/3690023311/20260106_10:15:14/Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Offre-Speciale-Accu-check_3690023311_06-01-2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 1 dest = 'alexis.delfolie@roche.com' whiteList = pharmacie57740@gmail.com,alexis.delfolie@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690023311 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"pharmacie57740@gmail.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-05 17:24:38 - dirToStoreZip = ../../files/bdc/zippedFiles/3690335588 _________ Destinataires _________ to : alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmacieduwarndt@orange.fr addCC : alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690335588/20260105_17:24:38/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690335588/20260105_17:24:38 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690335588_05_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690335588_05_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690335588_05_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690335588/20260105_17:24:38/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690335588_05_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690335588_05_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690335588 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// //============================= v.630 ========================================= - 2026-01-05 17:19:38 - dirToStoreZip = ../../files/bdc/zippedFiles/3690016987 _________ Destinataires _________ to : alexis.delfolie@roche.com cc : meylan.contratutilisateur@roche.com emailPharma : pharmalesallies57@offisecure.com addCC : alexis.delfolie@roche.com addCC : meylan.contratutilisateur@roche.com whiteList = __________________________________ - fName = offlineFiles.zip - 5 - ../../files/bdc/zippedFiles/3690016987/20260105_17:19:38/offlineFiles.zip move_uploaded_file success Open success - dirForExtraction = ../../files/bdc/unzippedFiles/3690016987/20260105_17:19:38 ########## CHECKING ####### fileNameToSend = . fileNameToSend = .. fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690016987_05_01_2026.pdf fileToBeAdded = 1 nbFilesToSend = 3 ########################### ********** STARTING FOR LOOP ***************** 0/ fileNameToSend = . *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 1/ fileNameToSend = .. *** END FOR LOOP *** *** END FOR LOOP *** ********** STARTING FOR LOOP ***************** 2/ fileNameToSend = Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690016987_05_01_2026.pdf ********* CONTRAT UTILISATEUR ********** MERGE PDF SUCCESS > will add file : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690016987_05_01_2026.pdf IN : ../../files/bdc/unzippedFiles/3690016987/20260105_17:19:38/Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690016987_05_01_2026.pdf File not kbis & not rib Tentative Envoi sur OFSAD de : Contrat_utilisateur_GRAND-EST-PHARMA-SRA_3690016987_05_01_2026.pdf... Le serveur OFSAD est en ligne *** END FOR LOOP *** END FOR reached errmsg = File uploaded to OFSAD successfully nbRecipient = 2 dest = 'alexis.delfolie@roche.com' dest = 'meylan.contratutilisateur@roche.com' whiteList = alexis.delfolie@roche.com,meylan.contratutilisateur@roche.com +++++++++++++++ WILL CALL CURL +++++++++++++++++ idPharma = 3690016987 signWithDocuSign = attachmentToSign = isPharmaRoc = false CURL response = {"status":"ok", "dest":"alexis.delfolie@roche.com"} EMAIL SENT +++++++++++++++++++++++++++++++++++ END FILE ============================================================================================================================================// ####### Creation - 2026-01-05 17:19:38 ########## --------- 2026-01-05 17:19:38 --------- - [getLogfile] suffixe = storeFile delegueEmail = alexis.delfolie@roche.com ##################################################