-------------------------------------------- --------- 2026-06-12 11:36:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-12 10:29:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-12 10:29:01 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-12 10:29:01', 'melanie.ribeiro@roche.com', '3690021250', 'Pack réseaux sociaux', '2026-06-12', '-', '0', 0, '09639438001', '', 1, 52460, 1) Pack réseaux sociaux detected... query2 = SELECT email FROM Pharmacies WHERE idPharma = '3690021250' email = contact@pharmaciedubourg.com ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php response = {"status":"OK", "msg":"Email correctement envoyé à : contact@pharmaciedubourg.com"} -------------------------------------------- --------- 2026-06-12 10:29:01 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-12 10:29:01', 'melanie.ribeiro@roche.com', '3690021250', '') -------------------------------------------- --------- 2026-06-11 15:47:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 15:47:50 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690020290', 'melanie.ribeiro@roche.com', 'offreAccuFine', 'typeOffreSelected=1&emailPharma=kenza.guellab@pharmadesarcades.fr&idPharma=3690020290', '', '2026-06-11 15:47:50') -------------------------------------------- --------- 2026-06-11 13:12:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 11:46:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-11 11:46:57', '3690024183', 'utilisateur', 'melanie.ribeiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-11 11:31:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 17:23:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 17:23:56 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-09 17:23:56', 'melanie.ribeiro@roche.com', '3690035979', 'Animation Diabete & ete', '2026-06-09', '-', '0', 0, '10309539001', '', 1, 52430, 1) -------------------------------------------- --------- 2026-06-09 17:23:56 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-09 17:23:56', 'melanie.ribeiro@roche.com', '3690035979', '2V9Fp2kWFRAtq6WsS6V0qXNi0D8f72jWaXxtW4IOKmj9Jc1QH206oVw6tZCt46H6') -------------------------------------------- --------- 2026-06-09 17:23:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 17:23:02 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035979', 'melanie.ribeiro@roche.com', 'offreSpeciale', '', '', '2026-06-09 17:23:02') -------------------------------------------- --------- 2026-06-04 15:05:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-04 15:05:52 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690021532 -------------------------------------------- --------- 2026-06-04 13:19:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:47:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-04 11:47:57', '3690024157', 'utilisateur', 'melanie.ribeiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-04 10:13:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 10:13:07 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-04 10:13:07', 'melanie.ribeiro@roche.com', '3690024889', 'Animation Diabete & ete', '2026-06-04', '-', '0', 0, '10309539001', '', 1, 52387, 1) -------------------------------------------- --------- 2026-06-04 10:13:07 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-04 10:13:07', 'melanie.ribeiro@roche.com', '3690024889', '') -------------------------------------------- --------- 2026-06-04 06:54:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 13:45:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 09:56:48 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-02 09:56:46 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690021428 ----------------------------------------------------- -- [2026-06-02 09:56:46] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690021428', 'melanie.ribeiro@roche.com', '2026-06-02 09:56:46', 105857, 5290.89, 0, 144, 24, -1, 144, -1, 108, -1, 3, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-02 09:56:46] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-02 09:56:46', '3690021428', 'produit', 'melanie.ribeiro@roche.com', 0, 144, 24, '2026-06-08*2026-09-02*2026-12-02', 'qj4GAkS7RlC25H8L7tsYdacFZSfjNrCpKfTtibq0BIzSrp8C6tJvOTVFNFeUVsqg', 0, 'PGRPTS', 1 )ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), datesLivraison = VALUES(datesLivraison), nbBandelette = VALUES(nbBandelette), nbBandeletteGuide = VALUES(nbBandeletteGuide), nbCassettes = VALUES(nbCassettes), nbAccuFine = VALUES(nbAccuFine), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-02 07:46:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 07:46:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-02 07:46:18 ########## --------- 2026-06-02 07:46:18 --------- - [getLogfile] suffixe = toolbox delegueEmail = melanie.ribeiro@roche.com ##################################################