-------------------------------------------- --------- 2026-08-25 15:08:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------ --------- 2026-08-25 15:08:17 --------- ------------ insertCpv -------------------- queryDeactivate = UPDATE Cpv SET active = 0 WHERE idPharma = '3690012229' queryCheck = SELECT id FROM Cpv WHERE idPharma = '3690012229' AND typeCpv = 'Exclusif' AND DATE_FORMAT(dateSignature, '%Y-%m-%d') = '2026-08-25' query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690012229', 'valentin.delinde@roche.com', '2026-08-25 15:08:17', 0, 60, 20, '23.1', 9, '23', 1 ) queryRemoveCiblage = UPDATE Pharmacies SET ciblage = '' WHERE idPharma = '3690012229' ----------------------------------------------------- -- [2026-08-25 15:08:16] [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 ('3690012229', 'valentin.delinde@roche.com', '2026-08-25 15:08:16', 0, 5045.23, 0, 60, 20, -1, 60, -1, 50, -1, 2, -1, 21, -1, -1, 240, 60, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-08-25 15:08:16] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... gptId = query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, idGpt, isCadence) VALUES ( '2026-08-25 15:08:16', '3690012229', 'produit', 'valentin.delinde@roche.com', 0, 60, 20, '2026-08-31*2026-10-19*2027-01-04*2027-04-05', '', 300, 'BRONZE-AF3', , 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-08-24 20:28:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-24 20:28:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-24 19:22:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-24 19:22:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-24 16:04:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-24 16:04:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-21 10:49:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-21 10:49:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-20 19:20:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-20 19:20:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-20 19:19:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-20 19:19:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-19 14:54:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-19 14:47:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-19 14:47:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-19 10:03:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-19 10:03:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-18 15:41:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-08-18 15:41:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-08-18 15:41:39 ########## --------- 2026-08-18 15:41:39 --------- - [getLogfile] suffixe = toolbox delegueEmail = valentin.delinde@roche.com ##################################################