-------------------------------------------- --------- 2026-01-26 11:00:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-26 11:00:29] [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 ('3690025284', 'elise.cottier@roche.com', '2026-01-26 11:00:29', 90622, 4262.86, 0, 95, 45, -1, 95, -1, 70, -1, 2, -1, 4, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-26 11:00:29] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 140 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-26 11:00:29', '3690025284', 'produit', 'elise.cottier@roche.com', 0, 95, 45, '2026-03-02*2026-06-01*2026-09-04*2026-11-02', 'sqbQW3x7cuRSdHCJDOVad7FnEBWhG5cwojpZ5HtGRv6phOBY4XM9aYq9hvOdsKye', 0, 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-01-26 11:00:29] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690025284', 'elise.cottier@roche.com', '6', 'a déjà passé une commande en début d\'année', '2026-01-26 11:00:29') -------------------------------------------- --------- 2026-01-26 10:44:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-26 10:44:50', '3690025284', 'utilisateur', 'elise.cottier@roche.com', 'zCFlyrqznMwikPrz2zUDenPdPyeDImDKxjIrfg3wnh3BBvV3zYL8D9MRE908XmtG', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 14:17:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 11:02:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-23 11:02:12', '3690012653', 'utilisateur', 'elise.cottier@roche.com', 'ZQx0D6TBheuWyhrLQwd3xG0usNUzuOCb2XhchKevxE1jRW0ghv1Z5hOQhbMN1KmJ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 15:43:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-22 15:43: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 ('3690016486', 'elise.cottier@roche.com', '2026-01-22 15:43:31', 90506, 4788.8, 0, 120, 20, -1, 120, -1, 100, -1, 0, -1, 6, -1, -1, 24, 0, 24, -1, -1, 0) ----------------------------------------------------- -- [2026-01-22 15:43:31] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 140 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-22 15:43:31', '3690016486', 'produit', 'elise.cottier@roche.com', 0, 120, 20, '2026-01-26*2026-04-27*2026-07-27*2026-10-26', '9R6ILbd9ZMeNV2pmDfnwPGUaGsSLP3iwEjLHDimxHO5gqdva6KLGJ9IEuv3wE6gu', 48, 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-01-22 14:24:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-22 14:24:37 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690030449 -------------------------------------------- --------- 2026-01-22 14:23:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-22 14:23:11', '3690030449', 'utilisateur', 'elise.cottier@roche.com', 'wCRL7Xdu9TMdlQADcxkFtGx7XDTwANMvRnETjDHvAQATkS0P2kGeFBZef9IO2fQr', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 17:18:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-21 17:18:10 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690038963 -------------------------------------------- --------- 2026-01-21 17:12:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 17:12:06 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690038963', 'elise.cottier@roche.com', 'offreSpeciale', '', '', '2026-01-21 17:12:06') -------------------------------------------- --------- 2026-01-21 17:11:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 17:11:14', '3690038963', 'utilisateur', 'elise.cottier@roche.com', 'IIEz5QOgcaWJmBhziOQ7QGaJOGrgsKzY1IGRFOgqrR2ywLYKp34lEVXSxsCWBZkU', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 17:01:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:53:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-21 16:53: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 ('3690035008', 'elise.cottier@roche.com', '2026-01-21 16:53:56', 90449, 4700.07, 0, 80, 74, -1, 80, -1, 76, -1, 1, -1, 4, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-21 16:53:56] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 154 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-21 16:53:56', '3690035008', 'produit', 'elise.cottier@roche.com', 0, 80, 74, '2026-01-26*2026-04-20*2026-07-20*2026-10-20', 'G8Jw2LV1BVMGVeHZ9TXgV1ZOZLXMO5XiZ6ZdDAqV3v0v223rVQYDjXMIIKJnmW7f', 0, 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-01-21 16:28:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:28:53 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035008', 'elise.cottier@roche.com', 'offreSpeciale', '', '', '2026-01-21 16:28:53') -------------------------------------------- --------- 2026-01-21 16:19:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:19:28 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035008', 'elise.cottier@roche.com', 'offreSpeciale', '', '', '2026-01-21 16:19:28') -------------------------------------------- --------- 2026-01-21 16:18:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 16:18:45', '3690035008', 'utilisateur', 'elise.cottier@roche.com', 'Q1hW3JSA5UX7NB0NSyNQK7QfbR9lVPafYEe0zqU3D4IdsUKGWGgVVS78V61hXWVq', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 16:18:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:17:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:17:01 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035008', 'elise.cottier@roche.com', 'offreSpeciale', '', '', '2026-01-21 16:17:01') -------------------------------------------- --------- 2026-01-21 16:16:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 16:16:23', '3690035008', 'utilisateur', 'elise.cottier@roche.com', 'y9GSlkyQPlPeyj917zFSyOFXpFy1j7nOCM5YkpCVe6abL0W6sz2xQkjEuDKZZuh1', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 16:15:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 16:15:08 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035008', 'elise.cottier@roche.com', 'offreSpeciale', '', '', '2026-01-21 16:15:08') -------------------------------------------- --------- 2026-01-21 16:14:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 16:14:20', '3690035008', 'utilisateur', 'elise.cottier@roche.com', 'WX2iiFsnW2WqQeoiQKC3qNyRS6MmeOQhJRoDeqXe09FeVsBB1wEstQrN4KyVH1eo', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 14:37:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 11:21:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 09:39:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 09:17:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:43:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:26:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 15:04:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 14:19:48 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 10:42:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 14:13:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 14:09:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 10:27:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 09:17:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 15:41:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 11:29:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 09:55:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 15:19:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-14 15:19:19] [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 ('3690018885', 'elise.cottier@roche.com', '2026-01-14 15:19:19', 90167, 2597.83, 0, 40, 40, -1, 40, -1, 30, -1, 2, -1, 6, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-14 15:19:19] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-14 15:19:19', '3690018885', 'produit', 'elise.cottier@roche.com', 0, 40, 40, '2026-01-19*2026-05-04*2026-09-07*2027-01-04', 'Ee9YmnXNttOzKXpNrGGRKp1priqlz0kccrNn7C1u1Xu0rv5fOsxr8YTU5FAHgsNk', 0, 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-01-14 15:01:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 14:34:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 14:34:50', '3690020311', 'utilisateur', 'elise.cottier@roche.com', 'Rc9LfFEQlQzJMQv4QRO1uISJZApx40qXFsyAdpe50X2UhATCcuP6SsEE0RQwMymJ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 14:34:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 14:30:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 14:30:55', '3690020311', 'utilisateur', 'elise.cottier@roche.com', 'BaUmPOM4ocBWvFFcAdB8KedN6aiQBM5KtYte5lLrOVewOZ8BTvbsBt6sKXw3Las3', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 14:07:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 14:06:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 11:49:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 11:49:40', '3690038952', 'utilisateur', 'elise.cottier@roche.com', 'Wi0ptnza60GcmhuTrcnHtOMmFMpjctzAXKP19e88oJvfaZFjmKEdwPHnsymvqX9a', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 11:43:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:26:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:06:43 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:04:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:03:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 15:51:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-12 15:51:24', '3690034464', 'utilisateur', 'elise.cottier@roche.com', 'fHwQbIKkCYajg3j9czknpkdhu0GLC2PgqQs17VOs5pbhbNLVdWEYzCI9Z4Z7Xud5', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 15:51:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 15:48:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-12 15:48:03', '3690034464', 'utilisateur', 'elise.cottier@roche.com', 'TMTNP77FRNDqtXH9kCphWddz10QmlWwkte1Wr97JRdR2453qfv2UtNtvxNuXwICZ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 15:27:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 15:01:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:45:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 15:18:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 15:06:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 10:38:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 10:35:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-09 10:35:23', '3690040413', 'utilisateur', 'elise.cottier@roche.com', 'VgluMTv8zKSJmKbchhstFaF4nSrtj6WOdRivHSihV4f6p4WZwEKBrWO4JosimTOj', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-09 10:32:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 10:16:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-09 10:16:12', '3690033431', 'utilisateur', 'elise.cottier@roche.com', 'YncGDDojG7wr4aUdYMQnJ5zx8p9uUkNjKn7zDR8OwyHzVbjYObXgADOVEU1TV5u3', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-07 16:18:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-07 16:18:03] [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 ('3690040040', 'elise.cottier@roche.com', '2026-01-07 16:18:03', 90006, 4080.53, 2, 100, 10, -1, 102, -1, 80, -1, 2, -1, 21, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-07 16:18:03] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-07 16:18:03', '3690040040', 'produit', 'elise.cottier@roche.com', 2, 100, 10, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', 'plcUKACVm5VLzR61XTf9up5kdKAP2tVYXftUxVTzByb7LejNSSzA9hzu8sp56IFa', 0, 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-01-07 10:40:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 09:57:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 08:33:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 15:16:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 15:07:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 13:29:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 11:05:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 09:54:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 09:45:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 11:44:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-05 11:44:15] [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 ('3690035932', 'elise.cottier@roche.com', '2026-01-05 11:44:15', 89958, 5342.31, 0, 120, 10, -1, 120, -1, 46, -1, 2, -1, 11, -1, -1, 96, 36, 10, -1, -1, 0) ----------------------------------------------------- -- [2026-01-05 11:44:15] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-05 11:44:15', '3690035932', 'produit', 'elise.cottier@roche.com', 0, 120, 10, '2026-01-09*2026-04-09*2026-07-09*2026-10-09', '5WrwIKsrmFKwrpNPyfLH2F5Em0Y2ZwVJDGBCaLpAoIciVbjNKXr5DMENEjNJgBhj', 142, 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-01-05 10:40:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 09:53:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-01-05 09:53:28 ########## --------- 2026-01-05 09:53:28 --------- - [getLogfile] suffixe = toolbox delegueEmail = elise.cottier@roche.com ##################################################