-------------------------------------------- --------- 2026-01-23 11:47:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 10:26:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 10:26:35 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690039918', 'laury.cheynet.lc1@roche.com', 'offreAccuFine', 'emailPharma=pharmaciedegivry@gmail.com&idPharma=3690039918&nomSignataire=Kimenau&prenomSignataire=Marie Sophie', '', '2026-01-23 10:26:35') -------------------------------------------- --------- 2026-01-23 10: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-23 10:14:20', '3690039918', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'HDc04ZO7AgvNQhuiHIzdY1qJn6gVHrpmPoFHqZlGfcneYfXkdMg1BE8IcI967Tke', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 09:54:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-22 09:54:08] [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 ('3690020914', 'laury.cheynet.lc1@roche.com', '2026-01-22 09:54:08', 90473, 2576, 17, 48, 15, -1, 65, -1, 24, -1, 2, -1, 5, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-22 09:54:08] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 80 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 getPalierDataByPharma 2 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-22 09:54:08', '3690020914', 'produit', 'laury.cheynet.lc1@roche.com', 17, 48, 15, '2026-02-03*2026-06-02*2026-09-02', 'gprSPq2hzuAicgtG3uGJECDZ2KztPp7mkKsz4Bx0rlVsdQbZK4TkaiGTfU17GLal', 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-22 09:24:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-22 09:24:34 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690020788 -------------------------------------------- --------- 2026-01-22 09:23:48 --------- --------- 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 09:23:48', '3690020788', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'feZmbA0OQQ6if3LMzLCVnm5WW2bEJN6zJBo5XulXElZUDLStVPBH8YPCMlCPgN4n', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 09:22:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 11:17:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-21 11:17:02] [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 ('3690013498', 'laury.cheynet.lc1@roche.com', '2026-01-21 11:17:02', 90427, 3861.75, 0, 80, 27, -1, 80, -1, 75, -1, 2, -1, 5, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-21 11:17:02] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 107 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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 11:17:02', '3690013498', 'produit', 'laury.cheynet.lc1@roche.com', 0, 80, 27, '2026-01-26*2026-04-27*2026-07-27*2026-10-26', 'TlTdliiRjGwJtMCqDEMrkwLBPJEqEvghRcuqInMT61Y51516ZuBk2kqZvA2Fr67e', 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-20 10:33:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 10:33:30] [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 ('3690039023', 'laury.cheynet.lc1@roche.com', '2026-01-20 10:33:30', 90374, 3024.96, 0, 60, 45, -1, 60, -1, 30, -1, 2, -1, 4, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 10:33:30] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 105 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-20 10:33:30', '3690039023', 'produit', 'laury.cheynet.lc1@roche.com', 0, 60, 45, '2026-05-05*2026-09-02*2026-12-02', 'kg7Kb3FoIvNE7BhaL9t5LfGqPMsIP5lqiTjZkTf2wR1nZvoVFt5aXgvdpxbTi1TB', 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-20 10:33:30] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690039023', 'laury.cheynet.lc1@roche.com', '0', '', '2026-01-20 10:33:30') -------------------------------------------- --------- 2026-01-20 10:18:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-20 10:18:42', '3690039023', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'bYf7TNR2SRcjI0HaY86OjgNp1w44MFozMzO5TJPy9hZ2cWYPsTyNeh8TrM7sldtF', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-19 16:28:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 16:06:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-16 16:06:13] [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 ('3690028976', 'laury.cheynet.lc1@roche.com', '2026-01-16 16:06:13', 90281, 3382.79, 0, 64, 36, -1, 64, -1, 50, -1, 2, -1, 21, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-16 16:06:13] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-16 16:06:13', '3690028976', 'produit', 'laury.cheynet.lc1@roche.com', 0, 64, 36, '2026-01-20*2026-04-20*2026-07-20*2026-10-20', 'Ls4AL0HT9fN01PZnShrsG3UMzlV8qnUazsqFbnfhEPFq2OMa0cliJwwGtEwW8m8R', 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-16 15:37:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-16 15:36:58] [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 ('3690020961', 'laury.cheynet.lc1@roche.com', '2026-01-16 15:36:58', 90278, 1720.98, 0, 42, 15, -1, 42, -1, 30, -1, 0, -1, 2, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-16 15:36:58] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-16 15:36:58', '3690020961', 'produit', 'laury.cheynet.lc1@roche.com', 0, 42, 15, '2026-04-14*2026-07-06*2026-10-12', 'yAN53pMBHpWZGRrCDGCuyM1qsK6zl98tOHMbWoYN55K844HCSQ1cQRS3vOutAfOI', 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-16 15:36:58] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690020961', 'laury.cheynet.lc1@roche.com', '0', '', '2026-01-16 15:36:58') -------------------------------------------- --------- 2026-01-16 15:33:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-16 15:33:19', '3690020961', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'duX9qCAQDIQv21YOeVCUqcH4kgxTdqTrW7p1nYFIfupUhTJity0peID2mABkO147', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 10:52:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-16 10:52:08] [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 ('3690016983', 'laury.cheynet.lc1@roche.com', '2026-01-16 10:52:08', 90256, 1656.63, 0, 40, 10, -1, 40, -1, 40, -1, 1, -1, 12, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-16 10:52:08] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-16 10:52:08', '3690016983', 'produit', 'laury.cheynet.lc1@roche.com', 0, 40, 10, '2026-02-09*2026-05-11*2026-09-07', 'CnH2LkjCKwYChDMiHE8Hic1DUjcvoPPHp7G7HjOsKIJ5Eq0UwF0MEW6zf7mzH9ZT', 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-16 10:52:08] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690016983', 'laury.cheynet.lc1@roche.com', '0', '', '2026-01-16 10:52:08') -------------------------------------------- --------- 2026-01-16 10:50:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-16 10:50:25', '3690016983', 'utilisateur', 'laury.cheynet.lc1@roche.com', '6ftmf3QPZgnsbaVUDkdzAJmuJeG90KNxXLX3gqSjkbXuu8aE9bKbMJnvEJlthMm1', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 10:48:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-16 10:48:34] [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 ('3690016983', 'laury.cheynet.lc1@roche.com', '2026-01-16 10:48:34', 90256, 1656.63, 0, 40, 10, -1, 40, -1, 40, -1, 1, -1, 12, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-16 10:48:34] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-16 10:48:34', '3690016983', 'produit', 'laury.cheynet.lc1@roche.com', 0, 40, 10, '2026-02-09*2026-05-11*2026-09-14', 'AilgyRtrglb8l5eNYJTL8nS8hOkn3Vd7TkDz5wsefHGIYW7uhIcvl6SXj51oQwfB', 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-16 10:48:34] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690016983', 'laury.cheynet.lc1@roche.com', '0', '', '2026-01-16 10:48:34') -------------------------------------------- --------- 2026-01-16 10:42: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-16 10:42:03', '3690016983', 'utilisateur', 'laury.cheynet.lc1@roche.com', '5kxR0dVp45HWsOvIkSYYdmroy3UfmBIVl99b7VB52ZnqTPWwxw25yPmwXkAfZjAf', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 17:25:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 13:42:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 10:56:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 10:56:09] [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 ('3690023802', 'laury.cheynet.lc1@roche.com', '2026-01-15 10:56:09', 90181, 2907.53, 0, 70, 10, -1, 70, -1, 55, -1, 2, -1, 7, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 10:56:09] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 10:56:09', '3690023802', 'produit', 'laury.cheynet.lc1@roche.com', 0, 70, 10, '2026-01-19*2026-04-20*2026-07-20*2026-10-19', 'I4kIURKzvC903XgcRVpNkO0DyjFcp5bVLm7pYchDHcXNxCAiYz4ABHqiLgXyDy42', 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-15 10:15:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 09:48:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 09:48:57] [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 ('3690015719', 'laury.cheynet.lc1@roche.com', '2026-01-15 09:48:57', 90178, 2928.23, 0, 100, 0, -1, 100, -1, 46, -1, 1, -1, 6, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 09:48:57] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 100 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-15 09:48:57', '3690015719', 'produit', 'laury.cheynet.lc1@roche.com', 0, 100, 0, '2026-01-19*2026-04-16*2026-07-13*2026-10-07', 'TMYSaLXLoIV0YUqX5uE61VMleAnNblHRAktqYPLiO6nlpncJuq41uTm8xdkdQ1fe', 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-15 09:48:57] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690015719', 'laury.cheynet.lc1@roche.com', '0', '', '2026-01-15 09:48:57') -------------------------------------------- --------- 2026-01-15 09:43:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-15 09:43:58', '3690015719', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'TsXoXBoz3lnDDRAwzt7SfQppzMEcIgs4ElBeEzXPEf1zHefDtB3K7L9bgoIO7biI', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 16:24: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-13 16:24:15', '3690012054', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'UB9RND54EsscutdYHNuPgIhqessaDjrqb4AIJSQhh59j5k9b7SJSGtR2RiU6nkHt', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 09:38:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 09:37:58] [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 ('3690040050', 'laury.cheynet.lc1@roche.com', '2026-01-13 09:37:58', 90111, 3886.93, 0, 100, 25, -1, 100, -1, 30, -1, 2, -1, 16, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-13 09:37:58] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-13 09:37:58', '3690040050', 'produit', 'laury.cheynet.lc1@roche.com', 0, 100, 25, '2026-01-19*2026-04-17*2026-07-17*2026-10-19', 'WlWPMZCaZnp3GQXNVuoi7SYqs1rRAfDcMKL0lZd09b7sa6oLGg1CostM4dHnZ8Vi', 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-12 17:40:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:35:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 16:23:18 --------- --------- 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 16:23:18', '3690032232', 'utilisateur', 'laury.cheynet.lc1@roche.com', '2LHKchauuJpnZVOyAEbP7cg7tpCYbbi3LQRjDFteDVu8AvPlGPLqnL8BDMnZDkj7', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 16:04:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 16:04:38] [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 ('3690021934', 'laury.cheynet.lc1@roche.com', '2026-01-12 16:04:38', 90094, 4083, 0, 150, 0, -1, 150, -1, 40, -1, 0, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 16:04:38] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 16:04:38', '3690021934', 'produit', 'laury.cheynet.lc1@roche.com', 0, 150, 0, '2026-03-23*2026-06-22*2026-10-05', 'QXiZuAb9LE0kXHMF5Ji4AhM1O5QZSvBTKxvU7bFLIvKmWK6xVZb4EYnmL45FdaiM', 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-12 15:48:08 --------- --------- 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:08', '3690021934', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'EXThOvKdFVVlPerDBTPFrAUJA9cTuk4MiBVeaEzqWYtufHBphvLGmUrNTGptbMj9', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 14:11:34 --------- --------- 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 14:11:34', '3690034373', 'utilisateur', 'laury.cheynet.lc1@roche.com', 'XOWX59r13pX6lnIIy2XGAITgImxYnzjc2aPP4tXSbwO0EhGTWxTlFEHAMz4n5fym', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-08 16:14:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 16:14:49] [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 ('3690014193', 'laury.cheynet.lc1@roche.com', '2026-01-08 16:14:49', 90026, 6142.19, 0, 105, 26, -1, 105, -1, 60, -1, 2, -1, 10, -1, -1, 142, 81, 17, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 16:14:48] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-08 16:14:48', '3690014193', 'produit', 'laury.cheynet.lc1@roche.com', 0, 105, 26, '2026-01-12*2026-04-27*2026-07-27', '1inEtZuqRg1qZseosCDOJu6koVUhNDJdcs6Mi1dyxWWgl53uMkUcJfyXdjcSxkTn', 240, 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-06 15:15:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 14:36:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 11:52:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-01-06 11:52:09 ########## --------- 2026-01-06 11:52:09 --------- - [getLogfile] suffixe = toolbox delegueEmail = laury.cheynet.lc1@roche.com ##################################################