-------------------------------------------- --------- 2026-06-12 15:50:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-12 15:50:07 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690020616 -------------------------------------------- --------- 2026-06-12 15:49:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-12 15:49:25', '3690020616', 'utilisateur', 'kilian.fromilhague@roche.com', 'QuvhE05CTlsHU3tFvn3lOPsIrOHUbeqyGPMfpshcKohFZzAJ4DEA8vcLksjrNbU2', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-11 15:25:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 15:00:14 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 14:59:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 14:59:47 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 13:57:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 13:57:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 13:57:17 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690020192', 'kilian.fromilhague@roche.com', 'offreAccuFine', 'typeOffreSelected=1&emailPharma=pierre.paulin@pharmaciequissac.fr&idPharma=3690020192', '', '2026-06-11 13:57:17') -------------------------------------------- --------- 2026-06-11 13:57:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 20:01:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------ --------- 2026-06-10 20:01:12 --------- ------------ insertCpv -------------------- queryDeactivate = UPDATE Cpv SET active = 0 WHERE idPharma = '3690035768' queryCheck = SELECT id FROM Cpv WHERE idPharma = '3690035768' 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', '3690035768', 'kilian.fromilhague@roche.com', '2026-06-10 20:01:12', 30, 120, 80, '17.9', 7, '26.60', 1 ) queryRemoveCiblage = UPDATE Pharmacies SET ciblage = '' WHERE idPharma = '3690035768' ----------------------------------------------------- -- [2026-06-10 20:01:11] [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 ('3690035768', 'kilian.fromilhague@roche.com', '2026-06-10 20:01:11', 106139, 8407.73, 30, 120, 80, -1, 150, -1, 180, -1, 2, -1, 23, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-10 20:01:11] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-10 20:01:11', '3690035768', 'produit', 'kilian.fromilhague@roche.com', 30, 120, 80, '2026-07-06*2026-10-05*2027-01-04*2027-04-05', '02CCSQ8XsFWsf6qOKNuprBT007MqSCsTbf5DYOsoYXFvg2URWqKmzNa28PhVOGbb', 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 14:32:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 09:28:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------ --------- 2026-06-09 09:28:57 --------- ------------ insertCpv -------------------- queryDeactivate = UPDATE Cpv SET active = 0 WHERE idPharma = '3690036288' queryCheck = SELECT id FROM Cpv WHERE idPharma = '3690036288' AND typeCpv = 'Exclusif' AND DATE_FORMAT(dateSignature, '%Y-%m-%d') = '2026-06-09' query = INSERT INTO Cpv (typeCpv, idPharma, emailIcpo, dateSignature, bandelettePerforma, bandeletteGuide, cassette, percentEvol, nbBoiteToSend, priceBandConcurrent, active) VALUES ( 'Exclusif', '3690036288', 'kilian.fromilhague@roche.com', '2026-06-09 09:28:57', 0, 240, 20, '10.6', 23, '25', 1 ) queryRemoveCiblage = UPDATE Pharmacies SET ciblage = '' WHERE idPharma = '3690036288' ----------------------------------------------------- -- [2026-06-09 09:28:56] [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 ('3690036288', 'kilian.fromilhague@roche.com', '2026-06-09 09:28:56', 106063, 9454.29, 0, 240, 20, -1, 240, -1, 180, -1, 4, -1, 26, -1, -1, 10, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-09 09:28:56] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-09 09:28:56', '3690036288', 'produit', 'kilian.fromilhague@roche.com', 0, 240, 20, '2026-06-15*2026-09-14*2026-12-14*2027-03-15', 'QJTWXD232p4fy1DwMl6wPc6MbEHjVIQFywTsFIVWI2pMaw083LkcJjQiMorhFdj0', 10, '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-08 19:25:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 19:23:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 19:23:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 11:22:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 11:21:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 11:21:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-08 11:21:18] [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 ('3690023276', 'kilian.fromilhague@roche.com', '2026-06-08 11:21:18', 106020, 6303.29, 20, 50, 120, -1, 70, -1, 90, -1, 4, -1, 11, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-08 11:21:18] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 190 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 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-08 11:21:18', '3690023276', 'produit', 'kilian.fromilhague@roche.com', 20, 50, 120, '2026-06-12*2026-09-07*2026-12-07', 'fdXaMV899k3hr6tNDp4Lvy1s15Wt2ozP1gGpyizk0cjGp8UftBogJcvCeQVaqsBH', 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-07 23:39:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-07 23:37:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-07 23:36:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-07 23:35:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:30:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:29:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:29:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 09:37:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 21:14:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 21:01:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 21:01:35 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-02 21:01:35', 'kilian.fromilhague@roche.com', '3690013730', 'Sensibilisation avec borne et entretien diabète', '2026-06-02', '-', '0', 4, '10401273001', '', 1, 52379, 1) -------------------------------------------- --------- 2026-06-02 21:01:35 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-02 21:01:35', 'kilian.fromilhague@roche.com', '3690013730', '') -------------------------------------------- --------- 2026-06-02 21:01:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 12:12:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-02 12:12:01 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690035770 -------------------------------------------- --------- 2026-06-02 12:10: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-02 12:10:06', '3690035770', 'utilisateur', 'kilian.fromilhague@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-02 12:09:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 12:08:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 12:08:30 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-02 12:08:30', 'kilian.fromilhague@roche.com', '3690027634', 'Animation Diabete & ete', '2026-06-02', '-', '0', 4, '10309539001', '', 1, 52369, 1) -------------------------------------------- --------- 2026-06-02 12:08:30 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-02 12:08:30', 'kilian.fromilhague@roche.com', '3690027634', '') -------------------------------------------- --------- 2026-06-01 21:07:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 19:15:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-01 19:15:06 ########## --------- 2026-06-01 19:15:06 --------- - [getLogfile] suffixe = toolbox delegueEmail = kilian.fromilhague@roche.com ##################################################