-------------------------------------------- --------- 2026-06-12 17:37:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-12 14:01:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-12 13:58:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 15:51:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 12:23:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-11 12:23:13 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690031571 -------------------------------------------- --------- 2026-06-10 11:11:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-10 11:11:48 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690013265 ----------------------------------------------------- -- [2026-06-10 11:11: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 ('3690013265', 'oscar.rietveld@roche.com', '2026-06-10 11:11:48', 106113, 2454.54, 0, 60, 24, -1, 60, -1, 35, -1, 0, -1, 0, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-10 11:11:48] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-10 11:11:48', '3690013265', 'produit', 'oscar.rietveld@roche.com', 0, 60, 24, '2026-06-15*2026-08-13*2026-10-15*2026-12-15', '', 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-10 11:11:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-10 11:11:41', '3690013265', 'utilisateur', 'oscar.rietveld@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-10 10:41:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 21:31:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 09:45:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 10:53:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 10:34:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-05 10:34:26] [insertContratProductQte] -- ----------------------------------------------------- query = INSERT INTO PharmaContratProductsQte (idPharma, emailIcpo, dateInsert, idContrat, caTotal, nbBandelettePerforma, nbBandeletteGuide, nbK7, nbK7Selected, nbBandelettes, nbBandelettesSelected, nbLancettes, nbLancettesSelected, nbKits, nbKitsSelected, nbLecteurs, nbLecteursSelected, nbPatients, nbAccuFine4, nbAccuFine5, nbAccuFine8, safeTProPlus, safeTProUno, isPrepalab) VALUES ('3690012487', 'oscar.rietveld@roche.com', '2026-06-05 10:34:26', 105977, 3847.03, 0, 90, 30, -1, 90, -1, 40, -1, 2, -1, 12, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-05 10:34:26] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-05 10:34:26', '3690012487', 'produit', 'oscar.rietveld@roche.com', 0, 90, 30, '2026-06-08*2026-09-08*2026-12-08*2027-03-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 10:26:56 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-03 10:26:55] [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 ('3690017367', 'oscar.rietveld@roche.com', '2026-06-03 10:26:55', 105887, 5310.8, 0, 85, 90, -1, 85, -1, 85, -1, 0, -1, 0, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-03 10:26:55] [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 10:26:55', '3690017367', 'produit', 'oscar.rietveld@roche.com', 0, 85, 90, '2026-06-25*2026-09-25*2026-12-10', '', 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-02 14:31:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 14:30:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 11:54:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-02 11:54:46 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690023192 -------------------------------------------- --------- 2026-06-02 10:04:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 10:04:04 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-02 10:04:04', 'oscar.rietveld@roche.com', '3690038853', 'Animation Diabete & ete', '2026-06-02', '-', '0', 0, '10309539001', '', 1, 52366, 1) -------------------------------------------- --------- 2026-06-02 10:04:04 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-02 10:04:04', 'oscar.rietveld@roche.com', '3690038853', '') -------------------------------------------- --------- 2026-06-02 09:50:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 09:50:28 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-02 09:50:28', 'oscar.rietveld@roche.com', '3690040051', 'Animation Diabete & ete', '2026-06-02', '-', '0', 0, '10309539001', '', 1, 52365, 1) -------------------------------------------- --------- 2026-06-02 09:50:28 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-02 09:50:28', 'oscar.rietveld@roche.com', '3690040051', '') -------------------------------------------- --------- 2026-06-02 09:48:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 18:08:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 18:07:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 11:07:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 11:07:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-01 11:07:31', '3690023192', 'utilisateur', 'oscar.rietveld@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-01 11:07:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 11:07:23 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690038215', 'oscar.rietveld@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=pharmaciefalay25@gmail.com&idPharma=3690038215', '', '2026-06-01 11:07:23') -------------------------------------------- --------- 2026-06-01 10:24:47 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 10:24:46 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690028710', 'oscar.rietveld@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=pharmaciedesresidencesmadrid@gmail.com&idPharma=3690028710', '', '2026-06-01 10:24:46') ####### Creation - 2026-06-01 10:24:46 ########## --------- 2026-06-01 10:24:46 --------- - [getLogfile] suffixe = toolbox delegueEmail = oscar.rietveld@roche.com ##################################################