-------------------------------------------- --------- 2026-01-26 11:03:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 10:55:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 10:55:23 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-26 10:55:23', 'alexis.delfolie@roche.com', '3690039460', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) -------------------------------------------- --------- 2026-01-26 10:27:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-26 10:27:20] [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 ('3690039460', 'alexis.delfolie@roche.com', '2026-01-26 10:27:20', 90615, 6763.23, 0, 180, 20, -1, 180, -1, 100, -1, 2, -1, 25, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-26 10:27:20] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-26 10:27:20', '3690039460', 'produit', 'alexis.delfolie@roche.com', 0, 180, 20, '2026-01-30*2026-05-04*2026-08-03*2026-11-09', '', 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-26 09:46:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-26 09:46: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 ('3690022261', 'alexis.delfolie@roche.com', '2026-01-26 09:46:39', 90610, 7276.06, 0, 160, 80, -1, 160, -1, 120, -1, 2, -1, 25, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-26 09:46:39] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 240 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-26 09:46:39', '3690022261', 'produit', 'alexis.delfolie@roche.com', 0, 160, 80, '2026-01-30*2026-05-04*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-26 09:46:37] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690022261', 'alexis.delfolie@roche.com', '1', '', '2026-01-26 09:46:37') -------------------------------------------- --------- 2026-01-26 09:33:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 09:33:50 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690022261', 'alexis.delfolie@roche.com', 'offreAccuFine', 'emailPharma=pharmaciecentraleputtelange@gmail.com&idPharma=3690022261', '', '2026-01-26 09:33:50') -------------------------------------------- --------- 2026-01-26 09:27:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 09:27:58 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690022261', 'alexis.delfolie@roche.com', 'offreSpeciale', '', '', '2026-01-26 09:27:58') -------------------------------------------- --------- 2026-01-26 09: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-26 09:26:15', '3690022261', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-26 09:15:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-26 09:15: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 ('3690011940', 'alexis.delfolie@roche.com', '2026-01-26 09:15:28', 90605, 14364.44, 4, 300, 60, -1, 304, -1, 180, -1, 0, -1, 40, -1, -1, 276, 172, 36, -1, -1, 0) ----------------------------------------------------- -- [2026-01-26 09:15:28] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-26 09:15:28', '3690011940', 'produit', 'alexis.delfolie@roche.com', 4, 300, 60, '2026-01-30*2026-05-04*2026-08-03*2026-11-02', '', 484, 1 )ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), datesLivraison = VALUES(datesLivraison), nbBandelette = VALUES(nbBandelette), nbBandeletteGuide = VALUES(nbBandeletteGuide), nbCassettes = VALUES(nbCassettes), nbAccuFine = VALUES(nbAccuFine), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-26 08:44:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 08:44:33 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690011940', 'alexis.delfolie@roche.com', 'offreSpeciale', '', '', '2026-01-26 08:44:33') -------------------------------------------- --------- 2026-01-26 08:43:38 --------- --------- 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 08:43:37', '3690011940', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 11:12:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 11:04:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 10:04:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:16:47 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:16:46 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 09:16:46', 'alexis.delfolie@roche.com', '3690023820', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) -------------------------------------------- --------- 2026-01-23 09:14:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 16:38:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-22 16:38:21 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690039038 -------------------------------------------- --------- 2026-01-22 16:38: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-22 16:38:18', '3690039038', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 16:38:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 15:36:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 15:32:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 14:43:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 14:43:09', '3690012058', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 13:26:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-21 13:26:02 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690018875 -------------------------------------------- --------- 2026-01-21 13:24:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 13:24:51', '3690018875', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 10:08:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-21 10:08:06 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690039454 -------------------------------------------- --------- 2026-01-21 10:03: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-21 10:03:28', '3690039454', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 15:37:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 15:31:39 --------- --------- 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 15:31:26', '3690012950', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-20 11:34:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 10:11:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-20 10:11: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 ('3690021368', 'alexis.delfolie@roche.com', '2026-01-20 10:11:09', 90369, 9767.49, 0, 240, 84, -1, 240, -1, 155, -1, 5, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-20 10:11:09] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 324 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 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:11:09', '3690021368', 'produit', 'alexis.delfolie@roche.com', 0, 240, 84, '2026-01-26*2026-04-30*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-20 10:11:08] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690021368', 'alexis.delfolie@roche.com', '1', '', '2026-01-20 10:11:08') -------------------------------------------- --------- 2026-01-20 10:11:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 10:10:53 --------- --------- 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:10:52', '3690021368', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-19 13:18:56 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 13:17:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 11:27:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 09:44:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 09:44:06] [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 ('3690037478', 'alexis.delfolie@roche.com', '2026-01-19 09:44:06', 90289, 7859.4, 0, 240, 30, -1, 240, -1, 120, -1, 0, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 09:44:06] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 09:44:06', '3690037478', 'produit', 'alexis.delfolie@roche.com', 0, 240, 30, '2026-02-02*2026-05-04*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-19 09:44:05] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690037478', 'alexis.delfolie@roche.com', '3', '', '2026-01-19 09:44:05') -------------------------------------------- --------- 2026-01-19 09:20:47 --------- --------- 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 09:20:45', '3690037478', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 16:58:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 15:33:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 15:33: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 ('3690014616', 'alexis.delfolie@roche.com', '2026-01-15 15:33:38', 90227, 17280.72, 0, 384, 96, -1, 384, -1, 180, -1, 0, -1, 15, -1, -1, 480, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 15:33:38] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 15:33:38', '3690014616', 'produit', 'alexis.delfolie@roche.com', 0, 384, 96, '2026-01-19*2026-03-02*2026-06-01', '', 480, 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 15:33:37] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690014616', 'alexis.delfolie@roche.com', '1', '', '2026-01-15 15:33:37') -------------------------------------------- --------- 2026-01-15 15:24:21 --------- --------- 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 15:24:20', '3690014616', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 14:48:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 14:48: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 ('3690335588', 'alexis.delfolie@roche.com', '2026-01-15 14:48:02', 90223, 10403.94, 0, 168, 72, -1, 168, -1, 112, -1, 4, -1, 12, -1, -1, 384, 12, 24, 6, -1, 0) ----------------------------------------------------- -- [2026-01-15 14:48:02] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 14:48:02', '3690335588', 'produit', 'alexis.delfolie@roche.com', 0, 168, 72, '2026-01-26*2026-04-27*2026-07-27*2026-10-26', '', 420, 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 14:48:01] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690335588', 'alexis.delfolie@roche.com', '1', '', '2026-01-15 14:48:01') -------------------------------------------- --------- 2026-01-15 13:55:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 13:55: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 ('3690021898', 'alexis.delfolie@roche.com', '2026-01-15 13:55:02', 90207, 6350.46, 0, 174, 45, -1, 174, -1, 90, -1, 0, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 13:55:02] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 13:55:02', '3690021898', 'produit', 'alexis.delfolie@roche.com', 0, 174, 45, '2026-04-08*2026-07-08*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-15 13:55:00] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690021898', 'alexis.delfolie@roche.com', '1', '', '2026-01-15 13:55:00') -------------------------------------------- --------- 2026-01-15 13:40: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-15 13:40:40', '3690021898', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 13:38:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 13:38: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 ('3690025704', 'alexis.delfolie@roche.com', '2026-01-15 13:38:02', 90204, 4947.84, 0, 93, 57, -1, 93, -1, 120, -1, 0, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 13:38:02] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 150 - 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-15 13:38:02', '3690025704', 'produit', 'alexis.delfolie@roche.com', 0, 93, 57, '2026-04-06*2026-06-26*2026-10-05', '', 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 13:35:47 --------- --------- 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 13:35:45', '3690025704', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 13:31:43 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 13:31:42] [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 ('3690016921', 'alexis.delfolie@roche.com', '2026-01-15 13:31:42', 90202, 6565.1, 0, 180, 35, -1, 180, -1, 126, -1, 0, -1, 15, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 13:31:42] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 13:31:42', '3690016921', 'produit', 'alexis.delfolie@roche.com', 0, 180, 35, '2026-04-13*2026-07-13*2026-10-12', '', 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 13:31:41] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690016921', 'alexis.delfolie@roche.com', '6', 'livraison 1 faite ', '2026-01-15 13:31:41') -------------------------------------------- --------- 2026-01-15 13:28:21 --------- --------- 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 13:28:19', '3690016921', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 13:27:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 13:27:11] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690034512', 'alexis.delfolie@roche.com', '2026-01-15 13:27:11', 90200, 4229.4, 0, 126, 15, -1, 126, -1, 72, -1, 1, -1, 15, -1, -1, 0, 0, 0, 1, -1, 0) ----------------------------------------------------- -- [2026-01-15 13:27:11] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 13:27:11', '3690034512', 'produit', 'alexis.delfolie@roche.com', 0, 126, 15, '2026-04-13*2026-07-20*2026-10-26', '', 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 13:27:10] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690034512', 'alexis.delfolie@roche.com', '1', '', '2026-01-15 13:27:10') -------------------------------------------- --------- 2026-01-15 13:23:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 13:23: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-15 13:23:23', '3690034512', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-15 13:23:18', '3690034512', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 13:22:33 --------- --------- 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 13:22:31', '3690034512', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-15 11:55:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 11:41:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 11:41:20 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-15 11:41:20', 'alexis.delfolie@roche.com', '3690016724', 'Diabete et Ramadan', '2026-01-30', '-', '0', 2, '10432217001', '', 1, 51395, 1) -------------------------------------------- --------- 2026-01-15 11:41:20 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-15 11:41:20', 'alexis.delfolie@roche.com', '3690016724', '') -------------------------------------------- --------- 2026-01-15 11:36:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 10:33:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 09:44:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 17:21:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 11:48:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-14 11:48:44] [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 ('3690024287', 'alexis.delfolie@roche.com', '2026-01-14 11:48:44', 90154, 5373.36, 0, 140, 35, -1, 140, -1, 100, -1, 1, -1, 20, -1, -1, 0, 0, 0, 1, -1, 0) ----------------------------------------------------- -- [2026-01-14 11:48:44] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-14 11:48:44', '3690024287', 'produit', 'alexis.delfolie@roche.com', 0, 140, 35, '2026-01-19*2026-05-11*2026-08-17*2026-11-16', '', 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-14 11:48:42] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690024287', 'alexis.delfolie@roche.com', '2', '', '2026-01-14 11:48:42') -------------------------------------------- --------- 2026-01-14 11:32:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 11:32:39', '3690024287', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 09:22:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-14 09:22:23] [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 ('3690017540', 'alexis.delfolie@roche.com', '2026-01-14 09:22:23', 90151, 10297.6, 0, 240, 100, -1, 240, -1, 180, -1, 0, -1, 40, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-14 09:22:23] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-14 09:22:23', '3690017540', 'produit', 'alexis.delfolie@roche.com', 0, 240, 100, '2026-02-02*2026-05-11*2026-08-17*2026-11-16', '', 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-14 09:22:22] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690017540', 'alexis.delfolie@roche.com', '2', '', '2026-01-14 09:22:22') -------------------------------------------- --------- 2026-01-14 09:12:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 09:12:53', '3690017540', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 12:53:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 10:36:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 09:19:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 08:06:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 08:02:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 15:20:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 15:20:19] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690033961', 'alexis.delfolie@roche.com', '2026-01-12 15:20:19', 90086, 8112.03, 0, 160, 100, -1, 160, -1, 136, -1, 1, -1, 10, -1, -1, 24, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 15:20:19] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 15:20:19', '3690033961', 'produit', 'alexis.delfolie@roche.com', 0, 160, 100, '2026-01-16*2026-04-14*2026-07-13*2026-10-07', '', 24, 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:20:17] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690033961', 'alexis.delfolie@roche.com', '2', '', '2026-01-12 15:20:17') -------------------------------------------- --------- 2026-01-12 14:58:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 14:57:10 --------- --------- 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:57:08', '3690033961', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 13:49:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 13:48:06 --------- --------- 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 13:48:04', '3690024201', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 13:43:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 13:42: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 13:42:33', '3690018757', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 12:35:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 12:30:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:53:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 14:54:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 12:08:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 11:34:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 11:29:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-09 11:29:10', '3690022100', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-09 10:39:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 09:56:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-09 09:19:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 18:05:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 18:03:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 18:03:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-08 18:03:56', '3690012417', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-08 18:03:54', '3690012417', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-08 17:50: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-08 17:50:43', '3690012417', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-08 16:47:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 16:46: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-08 16:46:54', '3690019583', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-08 15:05:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 15:05:18 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-08 15:05:18', 'alexis.delfolie@roche.com', '3690020197', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) -------------------------------------------- --------- 2026-01-08 15:04:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 15:04: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 ('3690020197', 'alexis.delfolie@roche.com', '2026-01-08 15:04:08', 90022, 10214.42, 0, 244, 50, -1, 244, -1, 220, -1, 3, -1, 31, -1, -1, 0, 0, 0, 12, -1, 0) ----------------------------------------------------- -- [2026-01-08 15:04:08] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-08 15:04:08', '3690020197', 'produit', 'alexis.delfolie@roche.com', 0, 244, 50, '2026-01-12*2026-04-14*2026-08-17*2026-10-12', '', 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 13:06:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 11:57:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 11:29:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 08:52:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 15:42:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 13:45:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 10:00:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-07 10:00:48] [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 ('3690038966', 'alexis.delfolie@roche.com', '2026-01-07 10:00:48', 89998, 5802.12, 0, 120, 60, -1, 120, -1, 120, -1, 4, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-07 10:00:48] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-07 10:00:48', '3690038966', 'produit', 'alexis.delfolie@roche.com', 0, 120, 60, '2026-01-12*2026-04-13*2026-07-13*2026-11-16', '', 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-07 10:00:47] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690038966', 'alexis.delfolie@roche.com', '2*4', '', '2026-01-07 10:00:47') -------------------------------------------- --------- 2026-01-07 09:44:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-07 09:44:00 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-07 09:44:00', 'alexis.delfolie@roche.com', '3690038966', 'Diabete et Ramadan', '2026-01-07', '-', '0', 3, '10432217001', '', 1, 51378, 1) -------------------------------------------- --------- 2026-01-07 09:44:00 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-07 09:44:00', 'alexis.delfolie@roche.com', '3690038966', '') -------------------------------------------- --------- 2026-01-07 09:37:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-07 09:36:58', '3690038966', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-06 17:24:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 16:00:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 13:35:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 13:32:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-06 13:32:25] [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 ('3690012452', 'alexis.delfolie@roche.com', '2026-01-06 13:32:25', 89983, 7296.6, 0, 135, 45, -1, 135, -1, 90, -1, 0, -1, 15, -1, -1, 240, 20, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-06 13:32:25] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 180 - 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-06 13:32:25', '3690012452', 'produit', 'alexis.delfolie@roche.com', 0, 135, 45, '2026-04-06*2026-07-06*2026-10-05', '', 260, 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-06 13:26:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 13:20: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-06 13:20:01', '3690012452', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-06 12:45:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 11:48:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-06 11:48: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 ('3690014751', 'alexis.delfolie@roche.com', '2026-01-06 11:48:29', 89979, 12818.28, 0, 300, 60, -1, 300, -1, 152, -1, 1, -1, 30, -1, -1, 232, 72, 15, -1, -1, 0) ----------------------------------------------------- -- [2026-01-06 11:48:29] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-06 11:48:29', '3690014751', 'produit', 'alexis.delfolie@roche.com', 0, 300, 60, '2026-03-03*2026-06-01*2026-09-01*2026-12-01', '', 319, 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-06 11:48:27] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690014751', 'alexis.delfolie@roche.com', '0*2', '', '2026-01-06 11:48:27') -------------------------------------------- --------- 2026-01-06 11:34:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 11:26:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-06 11:26:37', '3690014751', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-06 11:25:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 11:25:27 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690014751', 'alexis.delfolie@roche.com', 'offreSpeciale', '', '', '2026-01-06 11:25:27') -------------------------------------------- --------- 2026-01-06 11:24:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 10:53:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-06 10:53: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 ('3690023311', 'alexis.delfolie@roche.com', '2026-01-06 10:53:39', 89970, 10621.06, 0, 240, 40, -1, 240, -1, 120, -1, 2, -1, 20, -1, -1, 264, 48, 20, -1, -1, 0) ----------------------------------------------------- -- [2026-01-06 10:53:39] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-06 10:53:39', '3690023311', 'produit', 'alexis.delfolie@roche.com', 0, 240, 40, '2026-03-10*2026-06-10*2026-09-14*2026-12-14', '', 332, 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-06 10:53:37] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690023311', 'alexis.delfolie@roche.com', '6', 'rétro arrête ', '2026-01-06 10:53:37') -------------------------------------------- --------- 2026-01-06 10:18: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-06 10:18:29', '3690023311', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-06 10:15:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-06 10:15:14 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690023311', 'alexis.delfolie@roche.com', 'offreSpeciale', '', '', '2026-01-06 10:15:14') -------------------------------------------- --------- 2026-01-05 17:27:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 17:24:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-05 17:24:38', '3690335588', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-05 17:20:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 17:19:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-05 17:19:38', '3690016987', 'utilisateur', 'alexis.delfolie@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-05 17:11:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 17:09:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 14:36:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-05 14:12:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-01-05 14:12:00 ########## --------- 2026-01-05 14:12:00 --------- - [getLogfile] suffixe = toolbox delegueEmail = alexis.delfolie@roche.com ##################################################