-------------------------------------------- --------- 2026-04-03 15:11:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-03 15:11:39 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690012929 -------------------------------------------- --------- 2026-04-03 14:54:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-03 14:54:17', '3690012929', 'utilisateur', 'romain.valette@roche.com', 'WJZkZplh6tFSVHfNAPatN6HTjJDXbeKshPqPqwh3wpDB5klGzwop1fAnkNgN0OoC', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-03 14:11:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-03 14:11:20', '3690033630', 'utilisateur', 'romain.valette@roche.com', 'TNmy4io06KiAjNpOcaqwLK4D6xEmYG5RjicY6U3hDGSyJKTCvLsrvgNp6V7vdHTI', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-03 12:14:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-03 12:14:40 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690012431 ----------------------------------------------------- -- [2026-04-03 12:14:40] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690012431', 'romain.valette@roche.com', '2026-04-03 12:14:40', 101184, 2116.68, 5, 67, 0, -1, 72, -1, 36, -1, 0, -1, 0, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-03 12:14:40] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-03 12:14:40', '3690012431', 'produit', 'romain.valette@roche.com', 5, 67, 0, '2026-04-07*2026-06-10*2026-08-10*2026-10-09', 'SU2qgXUg9fRfkAgMWdpmyQlBOOCWMcJ5EieGUXkiKaI2TOvGCikF4A6JcCVtimCu', 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-04-03 12:00:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-03 12:00:20', '3690012431', 'utilisateur', 'romain.valette@roche.com', 'IW0KzWr2gzEW3YJSdK3O3mL4RjZDbR5KyJotzQKfXWEgvGBB3daQGH3araysx9qH', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-03 11:34:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-03 11:34:24 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690018659 ----------------------------------------------------- -- [2026-04-03 11:34:24] [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 ('3690018659', 'romain.valette@roche.com', '2026-04-03 11:34:24', 101177, 2808.4, 12, 65, 18, -1, 77, -1, 45, -1, 0, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-03 11:34:24] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-03 11:34:24', '3690018659', 'produit', 'romain.valette@roche.com', 12, 65, 18, '2026-05-11*2026-07-20*2026-10-01*2026-12-01', 'yo5hT6TNt75qSAXBiKHnRdiQlS4XAF30BGC2EisSUeg9MdobMiaIXrnttcMGitRP', 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-04-03 11:05:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-03 11:05:46', '3690018659', 'utilisateur', 'romain.valette@roche.com', 'J0JruvBm7N1a4FV9oyPY1wUojwGWkMSioxQF62iFbuuPomWYv9h3f0i5LVClx5AS', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-03 11:00:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-03 11:00:00 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-04-03 11:00:00', 'romain.valette@roche.com', '3690018659', 'Sensibilisation avec borne et entretien diabète', '2026-05-25', '-', '0', 0, '10401273001', '', 1, 51899, 1) -------------------------------------------- --------- 2026-04-03 11:00:00 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-04-03 11:00:00', 'romain.valette@roche.com', '3690018659', '7p3qU4N6UvmJ73HRaeFumfAQeYXTWyWEhAvacka97MIyDM7kfe5jD5XZjkQHZ1hC') -------------------------------------------- --------- 2026-04-03 10:33:43 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-03 10:33:43 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690039177 -------------------------------------------- --------- 2026-04-03 10:29:56 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-03 10:29:56', '3690039177', 'utilisateur', 'romain.valette@roche.com', 'jAWvOMwHIejyprHGR9Xx8zwOKFXGoYvLCoLcdSq3FNlNH5pIFOVBOxtBDPPhQlPT', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-03 09:58:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-03 09:58:00 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-04-03 09:58:00', 'romain.valette@roche.com', '3690027539', 'Sensibilisation avec borne et entretien diabète', '2026-05-25', '-', '0', 0, '10401273001', '', 1, 51898, 1) -------------------------------------------- --------- 2026-04-03 09:58:00 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-04-03 09:58:00', 'romain.valette@roche.com', '3690027539', 'PTdTsEJufH6sDGlO1KV1GmimLmjeZXRsSnTyB1BUrez1Qtmr6gbO0HYKUYY5Jf2X') -------------------------------------------- --------- 2026-04-03 09:54:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-03 09:54:11 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690027539', 'romain.valette@roche.com', 'offreAccuFine', 'typeOffreSelected=1&emailPharma=labocatalogne@gmail.com&idPharma=3690027539&nomSignataire=LAO&prenomSignataire=JULIE', '', '2026-04-03 09:54:11') -------------------------------------------- --------- 2026-04-02 10:41:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-02 10:41:51 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690040282 -------------------------------------------- --------- 2026-04-02 10:26:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-02 10:26:55', '3690040282', 'utilisateur', 'romain.valette@roche.com', '2xudtQZP9mUrLQtHYq8krzUeWWieGSZpd38jCTijK3RbvryByTtoPpAODnB7ipWT', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-02 09:24:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-02 09:24:16', '3690014059', 'utilisateur', 'romain.valette@roche.com', 'RssbgRUAWoofSmLhRaPXhc4khuWuGqJir0q66LFiHFq7p155crOmFq4aoU7pzeQJ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-01 16:46:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-01 16:46:21 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690021169 ----------------------------------------------------- -- [2026-04-01 16:46:21] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690021169', 'romain.valette@roche.com', '2026-04-01 16:46:21', 101027, 2967.8, 0, 45, 50, -1, 45, -1, 55, -1, 0, -1, 9, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-01 16:46:21] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 95 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-01 16:46:21', '3690021169', 'produit', 'romain.valette@roche.com', 0, 45, 50, '2026-05-11*2026-08-17*2026-10-12', '3akPiK7xKDNseUoEuDZoJz5t4hff2cS9u1Rpn8UHX779N3ZsZMsYbX32mvfTEWO7', 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-04-01 16:36:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-01 16:36:34', '3690021169', 'utilisateur', 'romain.valette@roche.com', 'rOo58UEeAzdJyE8rP3LWuSdbds06G15r2nJHiuelr3jNx6GnjYXWPqBBYSMCdEOb', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-01 16:29:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-01 16:29:15 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-04-01 16:29:15', 'romain.valette@roche.com', '3690021169', 'Sensibilisation avec borne et entretien diabète', '2026-05-25', '-', '0', 0, '10401273001', '', 1, 51894, 1) -------------------------------------------- --------- 2026-04-01 16:29:15 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-04-01 16:29:15', 'romain.valette@roche.com', '3690021169', '7AqbmOrAgoPntEoSdXwcP9LDFVPxy7WnF7dsRQiJXL18tCKOLR27TTltn2l8YiYb') -------------------------------------------- --------- 2026-04-01 15:26:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-01 15:26:23 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690036656 ----------------------------------------------------- -- [2026-04-01 15:26:22] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690036656', 'romain.valette@roche.com', '2026-04-01 15:26:23', 101016, 2052.22, 0, 30, 37, -1, 30, -1, 34, -1, 0, -1, 11, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-01 15:26:22] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 67 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-01 15:26:22', '3690036656', 'produit', 'romain.valette@roche.com', 0, 30, 37, '2026-04-14*2026-07-13*2026-10-12', 'ff9JbHOhdq3AUmBYMMeDz5RX6pSLyth6FyXycQkc9EGPYOyP5r7c6U1wp4SPUONe', 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-04-01 15:22:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-01 15:22:07', '3690036656', 'utilisateur', 'romain.valette@roche.com', 'ee0A8GsEYMYC0xSB1N3dSNXek4ycmHdPX1KzwogVoyLHDhbbZHDXxF7Ptn3JQPJp', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-01 15:21:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-01 15:20:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-01 10:28:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-01 10:10:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-01 10:10:50 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-04-01 10:10:50', 'romain.valette@roche.com', '3690022779', 'Sensibilisation avec borne et entretien diabète', '2026-05-25', '-', '0', 0, '10401273001', '', 1, 51891, 1) -------------------------------------------- --------- 2026-04-01 10:10:50 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-04-01 10:10:50', 'romain.valette@roche.com', '3690022779', 'bcrhHDbXpDEMtOYYsS68z7VLX5cIk9bHRgvdg2Xilp4UY6oOlczCLOudUljjcOwP') -------------------------------------------- --------- 2026-04-01 10:07:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-01 10:07:29 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690022779 ----------------------------------------------------- -- [2026-04-01 10:07: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 ('3690022779', 'romain.valette@roche.com', '2026-04-01 10:07:29', 100968, 5329.98, 1, 140, 30, -1, 141, -1, 100, -1, 4, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-01 10:07:29] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-01 10:07:29', '3690022779', 'produit', 'romain.valette@roche.com', 1, 140, 30, '2026-04-29*2026-07-06*2026-10-05*2026-12-29', 'l8Dy1pCMD5k0L6dG5XCk325DtEJOAh9e1pehkXKVkQbVjwK8e35P1rBWfQ40QKfl', 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-04-01 09:50:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-01 09:50:49', '3690022779', 'utilisateur', 'romain.valette@roche.com', 'TqPhEqG3443AEJ8HTnXDCjINvhlSZMfEsIrKmT9JmUEVl0A19obLeKNHA5ifOWoT', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) ####### Creation - 2026-04-01 09:50:49 ########## --------- 2026-04-01 09:50:49 --------- - [getLogfile] suffixe = toolbox delegueEmail = romain.valette@roche.com ##################################################