-------------------------------------------- --------- 2026-01-26 09:21:01 --------- --------- 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 09:20:59', '3690019648', 'utilisateur', 'sandra.inacio@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 12:45:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 11:31:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 16:05:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-22 16:05: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 ('3690040762', 'sandra.inacio@roche.com', '2026-01-22 16:05:31', 90511, 3841.53, 0, 100, 25, -1, 100, -1, 72, -1, 1, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-22 16:05:31] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 125 - 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 16:05:31', '3690040762', 'produit', 'sandra.inacio@roche.com', 0, 100, 25, '2026-01-26*2026-04-21*2026-07-15*2026-10-08', '', 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-22 15:57:56 --------- --------- 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 15:57:54', '3690040762', 'utilisateur', 'sandra.inacio@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 12:12:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 10:53:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 14:32:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 12:25:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 12:25: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 ('3690018437', 'sandra.inacio@roche.com', '2026-01-20 12:25:29', 90389, 15885.69, 0, 470, 50, -1, 470, -1, 300, -1, 4, -1, 31, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 12:25:29] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-20 12:25:29', '3690018437', 'produit', 'sandra.inacio@roche.com', 0, 470, 50, '2026-01-26*2026-04-24*2026-07-24*2026-10-26', '', 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 10:34:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 10:33:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 10:24:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 15:13:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 15:13:17] [insertFormationV2] -- query = INSERT INTO Formation (idPharma, emailIcpo, idInApp, contact, dateFormation, creneau, dateInsert, fromBdc) VALUES ('3690024614', 'sandra.inacio@roche.com', 30, '', '13/01/2026', 'Matin', '2026-01-13 15:13:17', 0 ) -------------------------------------------- --------- 2026-01-13 15:13:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 15:13:16] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690024614', 'sandra.inacio@roche.com', '2026-01-13 15:13:16', 90129, 9181.66, 0, 220, 60, -1, 220, -1, 120, -1, 3, -1, 27, -1, -1, 40, 20, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-13 15:13:16] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 280 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 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-13 15:13:16', '3690024614', 'produit', 'sandra.inacio@roche.com', 0, 220, 60, '2026-01-19*2026-04-17*2026-07-17*2026-10-19', '', 60, 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-13 14:26:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 10:48:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 10:45:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 09:27:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 12:10:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 12:10:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 10:32:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 15:04:48 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-09 15:04:47] [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 ('3690024318', 'sandra.inacio@roche.com', '2026-01-09 15:04:47', 90060, 9942.72, 0, 160, 160, -1, 160, -1, 170, -1, 4, -1, 38, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-09 15:04:47] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-09 15:04:47', '3690024318', 'produit', 'sandra.inacio@roche.com', 0, 160, 160, '2026-03-02*2026-05-01*2026-08-03*2026-11-02', '', 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-09 15:04:46] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690024318', 'sandra.inacio@roche.com', '1*3', '', '2026-01-09 15:04:46') -------------------------------------------- --------- 2026-01-09 14:57: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-09 14:57:43', '3690024318', 'utilisateur', 'sandra.inacio@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-08 11:51:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 11:51:27] [insertFormationV2] -- query = INSERT INTO Formation (idPharma, emailIcpo, idInApp, contact, dateFormation, creneau, dateInsert, fromBdc) VALUES ('3690016775', 'sandra.inacio@roche.com', 30, '', '08/01/2026', 'Matin', '2026-01-08 11:51:27', 0 ) -------------------------------------------- --------- 2026-01-08 11:51:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 11:51:26] [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 ('3690016775', 'sandra.inacio@roche.com', '2026-01-08 11:51:26', 90013, 18049.79, 0, 425, 115, -1, 425, -1, 275, -1, 4, -1, 61, -1, -1, 140, 90, 10, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 11:51:26] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 540 - 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-08 11:51:26', '3690016775', 'produit', 'sandra.inacio@roche.com', 0, 425, 115, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', '', 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-07 16:28:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 10:51:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 16:33:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-01-06 16:33:23 ########## --------- 2026-01-06 16:33:23 --------- - [getLogfile] suffixe = toolbox delegueEmail = sandra.inacio@roche.com ##################################################