-------------------------------------------- --------- 2026-01-23 14:03:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 14:03:22 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 14:03:22', 'anthony.pinheiro@roche.com', '3690019853', 'Diabete et Ramadan', '2026-01-23', '-', '0', 3, '10432217001', '', 1, 51446, 1) -------------------------------------------- --------- 2026-01-23 14:03:22 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-23 14:03:22', 'anthony.pinheiro@roche.com', '3690019853', '') -------------------------------------------- --------- 2026-01-23 13:54:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 13:52:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-23 13:52:40] [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 ('3690019853', 'anthony.pinheiro@roche.com', '2026-01-23 13:52:40', 90572, 15560.95, 10, 300, 200, -1, 310, -1, 240, -1, 10, -1, 46, -1, -1, 3, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-23 13:52:40] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-23 13:52:40', '3690019853', 'produit', 'anthony.pinheiro@roche.com', 10, 300, 200, '2026-01-27*2026-03-26*2026-06-22*2026-09-21', '', 3, 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-23 13:26: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-23 13:26:16', '3690019853', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 10:29:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:08:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:08:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-23 09:08:46 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690025001 -------------------------------------------- --------- 2026-01-23 09:08:44 --------- --------- 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 09:08:43', '3690025001', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 09:08:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:08:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:08:38 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 09:08:38', 'anthony.pinheiro@roche.com', '3690038535', 'Diabete et Ramadan', '2026-01-22', '-', '0', 3, '10432217001', '', 1, 51443, 1) -------------------------------------------- --------- 2026-01-23 09:08:38 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-23 09:08:38', 'anthony.pinheiro@roche.com', '3690038535', '') -------------------------------------------- --------- 2026-01-23 09:08:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-23 09:08:35] [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 ('3690038535', 'anthony.pinheiro@roche.com', '2026-01-23 09:08:35', 90540, 8410.72, 0, 208, 80, -1, 208, -1, 120, -1, 0, -1, 21, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-23 09:08:35] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-23 09:08:35', '3690038535', 'produit', 'anthony.pinheiro@roche.com', 0, 208, 80, '2026-02-02*2026-05-04*2026-09-02*2026-12-01', '', 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-23 09:08:33] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690038535', 'anthony.pinheiro@roche.com', '3', '', '2026-01-23 09:08:33') -------------------------------------------- --------- 2026-01-23 09:08:30 --------- --------- 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 09:08:28', '3690038535', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 09:08:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:08:24 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 09:08:24', 'anthony.pinheiro@roche.com', '3690029553', 'Diabete et Ramadan', '2026-01-22', '-', '0', 3, '10432217001', '', 0, 51442, 1) -------------------------------------------- --------- 2026-01-23 09:08:24 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-23 09:08:24', 'anthony.pinheiro@roche.com', '3690029553', '') -------------------------------------------- --------- 2026-01-23 09:08:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-23 09:08:21] [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 ('3690029553', 'anthony.pinheiro@roche.com', '2026-01-23 09:08:21', 90538, 9626.46, 0, 260, 60, -1, 260, -1, 110, -1, 3, -1, 46, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-23 09:08:21] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-23 09:08:21', '3690029553', 'produit', 'anthony.pinheiro@roche.com', 0, 260, 60, '2026-01-26*2026-03-20*2026-07-20*2026-10-01', '', 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-20 16:17:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 16:14:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 15:23:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 11:06:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 11:06:28] [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 ('3690023713', 'anthony.pinheiro@roche.com', '2026-01-20 11:06:28', 90381, 4682.73, 5, 100, 60, -1, 105, -1, 48, -1, 1, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 11:06:28] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 165 - 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-20 11:06:28', '3690023713', 'produit', 'anthony.pinheiro@roche.com', 5, 100, 60, '2026-01-26*2026-04-20*2026-07-15*2026-10-09', 'Zw17kILN8zZBchPyFrnSYlWnze0Gdd9dLUwj10yDiDDsnfGTb4IL9L9pFFB8I9sC', 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:53: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-20 10:53:55', '3690023713', 'utilisateur', 'anthony.pinheiro@roche.com', 'ZSWp4DPn96uh3vG8d5FonC8ac2gIXwLURkQxj5zacAsQ0vtGTqLRbCw9lA92Xs53', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 10:37:28 --------- --------- 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:37:27', '3690023713', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 10:24:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 10:24:29 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-20 10:24:29', 'anthony.pinheiro@roche.com', '3690024640', 'Diabete et Ramadan', '2026-01-23', '-', '0', 3, '10432217001', '', 1, 51421, 1) -------------------------------------------- --------- 2026-01-20 10:24:29 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-20 10:24:29', 'anthony.pinheiro@roche.com', '3690024640', '') -------------------------------------------- --------- 2026-01-20 10:24:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 10:24:22] [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 ('3690024640', 'anthony.pinheiro@roche.com', '2026-01-20 10:24:22', 90372, 13256.8, 100, 280, 60, -1, 380, -1, 240, -1, 0, -1, 90, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 10:24:22] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-20 10:24:22', '3690024640', 'produit', 'anthony.pinheiro@roche.com', 100, 280, 60, '2026-01-26*2026-04-20*2026-07-15*2026-10-09', '', 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:24:21] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690024640', 'anthony.pinheiro@roche.com', '2', '', '2026-01-20 10:24:21') -------------------------------------------- --------- 2026-01-20 10:24:17 --------- --------- 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:24:16', '3690024640', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 09:13:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:13:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:13:19 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-20 09:13:19', 'anthony.pinheiro@roche.com', '3690031399', 'Diabete et Ramadan', '2026-01-19', '-', '0', 3, '10432217001', '', 0, 51419, 1) -------------------------------------------- --------- 2026-01-20 09:13:19 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-20 09:13:19', 'anthony.pinheiro@roche.com', '3690031399', '') -------------------------------------------- --------- 2026-01-20 09:13:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 09:13:17] [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 ('3690031399', 'anthony.pinheiro@roche.com', '2026-01-20 09:13:17', 90362, 16705.57, 30, 350, 150, -1, 380, -1, 300, -1, 15, -1, 41, -1, -1, 0, 0, 0, 5, -1, 0) ----------------------------------------------------- -- [2026-01-20 09:13:17] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 530 - palier : 4 - palierData : getPalierDataByPharma 1 palier = 4 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-20 09:13:17', '3690031399', 'produit', 'anthony.pinheiro@roche.com', 30, 350, 150, '2026-01-19*2026-04-20*2026-07-20*2026-10-19', '', 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) ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-20 09:13:16', '3690031400', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) ----------------------------------------------------- -- [2026-01-20 09:13: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 ('3690031400', 'anthony.pinheiro@roche.com', '2026-01-20 09:13:15', 90360, 3194.4, 0, 78, 18, -1, 78, -1, 84, -1, 0, -1, 12, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 09:13:15] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-20 09:13:15', '3690031400', 'produit', 'anthony.pinheiro@roche.com', 0, 78, 18, '2026-01-19*2026-04-16*2026-07-13*2026-10-07', '', 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 09:13:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 09:13:13] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690031400', 'anthony.pinheiro@roche.com', '3', '', '2026-01-20 09:13:13') ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-20 09:13:12', '3690031400', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 09:13:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:13:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 09:13:04 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-20 09:13:04', 'anthony.pinheiro@roche.com', '3690031400', 'Diabete et Ramadan', '2026-01-19', '-', '0', 3, '10432217001', '', 1, 51418, 1) -------------------------------------------- --------- 2026-01-20 09:13:04 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-20 09:13:04', 'anthony.pinheiro@roche.com', '3690031400', '') -------------------------------------------- --------- 2026-01-20 09:13:03 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-20 09:13:03', 'anthony.pinheiro@roche.com', '3690031400', 'Diabete et Ramadan', '2026-01-19', '-', '0', 3, '10432217001', '', 1, 51417, 1) -------------------------------------------- --------- 2026-01-20 09:13:03 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-20 09:13:03', 'anthony.pinheiro@roche.com', '3690031400', '') -------------------------------------------- --------- 2026-01-19 17:35:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 17:35:53 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-19 17:35:53', 'anthony.pinheiro@roche.com', '3690019224', 'Diabete et Ramadan', '2026-02-13', '-', '0', 3, '10432217001', '', 1, 51416, 1) -------------------------------------------- --------- 2026-01-19 17:35:53 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-19 17:35:53', 'anthony.pinheiro@roche.com', '3690019224', 'EFzI59U7HMvMljaJjvroKBIgvNbKFeCHNCEOvwJZKBGieogRWB1n9YkplwNeW3PP') -------------------------------------------- --------- 2026-01-19 17:30:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 17:30: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 ('3690019224', 'anthony.pinheiro@roche.com', '2026-01-19 17:30:34', 90350, 9561.75, 0, 180, 30, -1, 180, -1, 190, -1, 0, -1, 50, -1, -1, 240, 75, 30, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 17:30:34] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 17:30:34', '3690019224', 'produit', 'anthony.pinheiro@roche.com', 0, 180, 30, '2026-02-23*2026-05-25*2026-08-24*2026-11-20', 'dB3kZi6yMLRDJ7rABUrgttrJUAHTcGDDYwvgmR4IVm57AMiWsHLb2rX1avdukodR', 345, 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-19 17:30:34] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690019224', 'anthony.pinheiro@roche.com', '2', '', '2026-01-19 17:30:34') -------------------------------------------- --------- 2026-01-19 17:26:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-19 17:26:16', '3690019224', 'utilisateur', 'anthony.pinheiro@roche.com', 'Eyn9VsKQbYaCv90Xf5yoBErJeotateeh8fw0DBl2J3I0W1cEd87EBXwLTUukoPgP', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 15:32:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 11:04:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 15:32:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 15:13:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 22:04:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 17:19:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 17:19:39] [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 ('3690024348', 'anthony.pinheiro@roche.com', '2026-01-13 17:19:39', 90143, 8112.45, 0, 150, 105, -1, 150, -1, 140, -1, 5, -1, 20, -1, -1, 15, 5, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-13 17:19:39] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-13 17:19:39', '3690024348', 'produit', 'anthony.pinheiro@roche.com', 0, 150, 105, '2026-01-19*2026-05-14*2026-09-08', '', 20, 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-13 17:19:38] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690024348', 'anthony.pinheiro@roche.com', '2', '', '2026-01-13 17:19:38') -------------------------------------------- --------- 2026-01-13 17:19:31 --------- --------- 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 17:19:29', '3690024348', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 17:19:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 17:19:22 --------- --------- 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 17:19:21', '3690030928', 'utilisateur', 'anthony.pinheiro@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 18:44:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 18:44:22] [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 ('3690022438', 'anthony.pinheiro@roche.com', '2026-01-12 18:44:22', 90105, 3954.83, 0, 90, 30, -1, 90, -1, 50, -1, 2, -1, 21, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 18:44:22] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 18:44:22', '3690022438', 'produit', 'anthony.pinheiro@roche.com', 0, 90, 30, '2026-01-16*2026-04-16*2026-07-16*2026-10-16', '', 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 18:43:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 18:43:39] [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 ('3690022438', 'anthony.pinheiro@roche.com', '2026-01-12 18:43:39', 90105, 3954.83, 0, 90, 30, -1, 90, -1, 50, -1, 2, -1, 21, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 18:43:39] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 18:43:39', '3690022438', 'produit', 'anthony.pinheiro@roche.com', 0, 90, 30, '2026-01-16*2026-04-16*2026-07-16*2026-10-16', '', 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-08 16:41:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 15:55:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 11:40:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 17:03:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 16:06:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 16:06:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-06 16:06:35] [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 ('3690038534', 'anthony.pinheiro@roche.com', '2026-01-06 16:06:35', 89986, 5932.57, 0, 150, 20, -1, 150, -1, 100, -1, 2, -1, 16, -1, -1, 0, 0, 0, 1, -1, 0) ----------------------------------------------------- -- [2026-01-06 16:06:35] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-06 16:06:35', '3690038534', 'produit', 'anthony.pinheiro@roche.com', 0, 150, 20, '2026-02-20*2026-06-19*2026-10-16', '', 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) ####### Creation - 2026-01-06 16:06:35 ########## --------- 2026-01-06 16:06:35 --------- - [getLogfile] suffixe = toolbox delegueEmail = anthony.pinheiro@roche.com ##################################################