-------------------------------------------- --------- 2026-06-11 13:10:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 10:25:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 10:48:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------ --------- 2026-06-10 10:48:32 --------- ------------ insertCpv -------------------- queryDeactivate = UPDATE Cpv SET active = 0 WHERE idPharma = '3690037519' queryCheck = SELECT id FROM Cpv WHERE idPharma = '3690037519' AND typeCpv = 'Exclusif' AND DATE_FORMAT(dateSignature, '%Y-%m-%d') = '2026-06-10' query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690037519', 'lucas.marco@roche.com', '2026-06-10 10:48:32', 36, 84, 120, '20', 18, '23', 1 ) queryRemoveCiblage = UPDATE Pharmacies SET ciblage = '' WHERE idPharma = '3690037519' ----------------------------------------------------- -- [2026-06-10 10:48:31] [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 ('3690037519', 'lucas.marco@roche.com', '2026-06-10 10:48:31', 106109, 8184.64, 0, 140, 120, -1, 140, -1, 120, -1, 9, -1, 17, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-10 10:48:31] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 240 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 getPalierDataByPharma 2 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-10 10:48:31', '3690037519', 'produit', 'lucas.marco@roche.com', 0, 140, 100, '2026-06-15*2026-09-04*2026-12-04*2027-03-05', '', 0, 'BRONZE-AF1', 0 )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-10 10:29:56 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 15:17:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 09:00:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-04 09:00:39 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690035575 -------------------------------------------- --------- 2026-06-04 09:00:08 --------- --------- 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 09:00:06', '3690035575', 'utilisateur', 'lucas.marco@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-04 08:59:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 08:59:39 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035575', 'lucas.marco@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=pharmacimiez@orange.fr&idPharma=3690035575', '', '2026-06-04 08:59:39') -------------------------------------------- --------- 2026-06-03 16:12:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-03 16:12:34 ########## --------- 2026-06-03 16:12:34 --------- - [getLogfile] suffixe = toolbox delegueEmail = lucas.marco@roche.com ##################################################