-------------------------------------------- --------- 2026-06-12 12:30:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 17:02:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 14:06:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 09:35:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 09:35:36 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690039602', 'julie.lafleur@roche.com', 'offreSpeciale', '', '', '2026-06-11 09:35:36') -------------------------------------------- --------- 2026-06-11 09:33:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 09:33:00 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690039123', 'julie.lafleur@roche.com', 'offreSpeciale', '', '', '2026-06-11 09:33:00') -------------------------------------------- --------- 2026-06-11 09:32:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 09:32:08 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690020605', 'julie.lafleur@roche.com', 'offreSpeciale', '', '', '2026-06-11 09:32:08') -------------------------------------------- --------- 2026-06-11 09:29:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 09:29:00 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690023715', 'julie.lafleur@roche.com', 'offreSpeciale', '', '', '2026-06-11 09:29:00') -------------------------------------------- --------- 2026-06-11 08:51:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-11 08:51:39', '3690035967', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-11 08: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-06-11 08:48:05', '3690025023', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-10 11:43:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 11:01:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 11:01:27 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-10 11:01:27', 'julie.lafleur@roche.com', '3690022548', 'Animation Diabete & ete', '2026-06-09', '-', '0', 1, '10309539001', '', 1, 52438, 1) -------------------------------------------- --------- 2026-06-10 11:01:27 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-10 11:01:27', 'julie.lafleur@roche.com', '3690022548', '') -------------------------------------------- --------- 2026-06-10 11:01:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 11:01:22 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-10 11:01:22', 'julie.lafleur@roche.com', '3690023715', 'Animation Diabete & ete', '2026-06-09', '-', '0', 1, '10309539001', '', 1, 52437, 1) -------------------------------------------- --------- 2026-06-10 11:01:22 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-10 11:01:22', 'julie.lafleur@roche.com', '3690023715', '') -------------------------------------------- --------- 2026-06-09 09:04:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-09 09:04:58', '3690040419', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-09 09:03:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-09 09:03:53', '3690034944', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-09 09:03:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-09 09:02:59', '3690023588', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-09 08:58:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-09 08:58:37', '3690019054', 'utilisateur', 'julie.lafleur@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-09 08:40:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-09 08:40:32 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690024456 ----------------------------------------------------- -- [2026-06-09 08:40:32] [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 ('3690024456', 'julie.lafleur@roche.com', '2026-06-09 08:40:32', 106055, 2888.4, 0, 80, 20, -1, 80, -1, 40, -1, 0, -1, 16, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-09 08:40:32] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 100 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 getPalierDataByPharma 2 getPalierDataByPharma 3 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-09 08:40:32', '3690024456', 'produit', 'julie.lafleur@roche.com', 0, 80, 20, '2026-06-12*2026-12-31', '', 0, 'PGRPTS', 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-06-08 15:42:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 15:42:14 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-08 15:42:14', 'julie.lafleur@roche.com', '3690038515', 'Animation Diabete & ete', '2026-06-04', '-', '0', 1, '10309539001', '', 1, 52415, 1) -------------------------------------------- --------- 2026-06-08 15:42:14 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-08 15:42:14', 'julie.lafleur@roche.com', '3690038515', '') -------------------------------------------- --------- 2026-06-04 17:54:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:22:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:22:34 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-04 11:22:34', 'julie.lafleur@roche.com', '3690038637', 'Animation Diabete & ete', '2026-06-04', '-', '0', 1, '10309539001', '', 0, 52390, 1) -------------------------------------------- --------- 2026-06-04 11:22:34 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-04 11:22:34', 'julie.lafleur@roche.com', '3690038637', '') -------------------------------------------- --------- 2026-06-04 10:17:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 10:17:40 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-04 10:17:40', 'julie.lafleur@roche.com', '3690024710', 'Animation Diabete & ete', '2026-06-04', '-', '0', 1, '10309539001', '', 0, 52388, 1) -------------------------------------------- --------- 2026-06-04 10:17:40 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-04 10:17:40', 'julie.lafleur@roche.com', '3690024710', '') -------------------------------------------- --------- 2026-06-03 14:24:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 14:24:19 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-03 14:24:19', 'julie.lafleur@roche.com', '3690023533', 'Animation Diabete & ete', '2026-06-03', '-', '0', 1, '10309539001', '', 0, 52384, 1) -------------------------------------------- --------- 2026-06-03 14:24:19 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-03 14:24:19', 'julie.lafleur@roche.com', '3690023533', '') -------------------------------------------- --------- 2026-06-03 14:24:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-03 14:24:16] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690023533', 'julie.lafleur@roche.com', '2026-06-03 14:24:16', 105897, 4567.19, 0, 130, 10, -1, 130, -1, 52, -1, 2, -1, 13, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-03 14:24:16] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-03 14:24:16', '3690023533', 'produit', 'julie.lafleur@roche.com', 0, 130, 10, '2026-06-08*2026-10-07*2027-02-08', '', 0, 'BRONZE-AF1', 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-06-03 14:24:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 14:24:09 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-03 14:24:09', 'julie.lafleur@roche.com', '3690012582', 'Animation Diabete & ete', '2026-06-03', '-', '0', 1, '10309539001', '', 1, 52383, 1) -------------------------------------------- --------- 2026-06-03 14:24:09 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-03 14:24:09', 'julie.lafleur@roche.com', '3690012582', '') -------------------------------------------- --------- 2026-06-02 19:24:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 19:24:38 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-02 19:24:38', 'julie.lafleur@roche.com', '3690034490', 'Animation Diabete & ete', '2026-06-01', '-', '0', 1, '10309539001', '', 1, 52378, 1) -------------------------------------------- --------- 2026-06-02 19:24:38 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-02 19:24:38', 'julie.lafleur@roche.com', '3690034490', '') -------------------------------------------- --------- 2026-06-01 19:40:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 19:40:21 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 19:40:21', 'julie.lafleur@roche.com', '3690022528', 'Animation Diabete & ete', '2026-06-01', '-', '0', 1, '10309539001', '', 1, 52362, 1) -------------------------------------------- --------- 2026-06-01 19:40:21 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-01 19:40:21', 'julie.lafleur@roche.com', '3690022528', '') -------------------------------------------- --------- 2026-06-01 15:49:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 14:27:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 11:24:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 11:24:33 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 11:24:33', 'julie.lafleur@roche.com', '3690019047', 'Animation Diabete & ete', '2026-06-01', '-', '0', 1, '10309539001', '', 1, 52345, 1) -------------------------------------------- --------- 2026-06-01 11:24:33 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-01 11:24:33', 'julie.lafleur@roche.com', '3690019047', '') -------------------------------------------- --------- 2026-06-01 11:23:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 10:17:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 10:17:33 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 10:17:33', 'julie.lafleur@roche.com', '3690033948', 'Animation Diabete & ete', '2026-06-01', '-', '0', 1, '10309539001', '', 1, 52343, 1) -------------------------------------------- --------- 2026-06-01 10:17:33 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-01 10:17:33', 'julie.lafleur@roche.com', '3690033948', '') -------------------------------------------- --------- 2026-06-01 09:42:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 09:37:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-01 09:37:23 ########## --------- 2026-06-01 09:37:23 --------- - [getLogfile] suffixe = toolbox delegueEmail = julie.lafleur@roche.com ##################################################