-------------------------------------------- --------- 2025-12-10 14:51:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-09 17:16:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-09 17:05:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2025-12-09 17:05:38', '3690039007', 'utilisateur', 'jessica.pouzet@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2025-12-09 15:29:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-09 15:29:23 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2025-12-09 15:29:23', 'jessica.pouzet@roche.com', '3690013232', 'Diabete et hiver', '2025-12-09', '-', '0', 0, '10706856001', '', 0, 51352, 1) -------------------------------------------- --------- 2025-12-09 15:29:23 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2025-12-09 15:29:23', 'jessica.pouzet@roche.com', '3690013232', 'Bilan matériel', '2025-12-09', '-', '0', 0, '10374489001', '', 0, 51352, 1) -------------------------------------------- --------- 2025-12-09 15:29:23 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2025-12-09 15:29:23', 'jessica.pouzet@roche.com', '3690013232', '') -------------------------------------------- --------- 2025-12-08 17:46:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-08 17:46:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-08 17:46:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-05 14:52:50 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2025-12-05 14:52:49] [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 ('3690012854', 'jessica.pouzet@roche.com', '2025-12-05 14:52:49', 89771, 17365.9, 60, 393, 117, -1, 453, -1, 220, -1, 16, -1, 64, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2025-12-05 14:52:49] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 570 - palier : 4 - palierData : getPalierDataByPharma 1 palier = 4 getPalierDataByPharma 2 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2025-12-05 14:52:49', '3690012854', 'produit', 'jessica.pouzet@roche.com', 60, 393, 117, '2025-12-09*2026-02-09*2026-04-09*2026-06-09*2026-08-10*2026-10-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) -------------------------------------------- --------- 2025-12-05 08:29:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-05 08:25:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-05 08:25:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2025-12-05 08:25:18 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690018537 -------------------------------------------- --------- 2025-12-05 08:25:14 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2025-12-05 08:25:13] [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 ('3690015709', 'jessica.pouzet@roche.com', '2025-12-05 08:25:13', 89745, 3341.96, 0, 0, 100, -1, 0, -1, 50, -1, 3, -1, 8, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2025-12-05 08:25:13] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2025-12-05 08:25:13', '3690015709', 'produit', 'jessica.pouzet@roche.com', 0, 0, 100, '2025-12-08*2026-02-06*2026-04-06*2026-06-08*2026-08-06*2026-10-06', '', 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) -------------------------------------------- --------- 2025-12-03 12:48:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-02 17:53:13 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-02 17:43:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-01 21:44:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-01 21:29:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2025-12-01 21:29:44 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2025-12-01 21:29:44', 'jessica.pouzet@roche.com', '3690021205', 'Sensibilisation avec borne et entretien diabète', '2025-12-01', '-', '0', 0, '10401273001', '', 1, 51349, 1) -------------------------------------------- --------- 2025-12-01 21:29:44 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2025-12-01 21:29:44', 'jessica.pouzet@roche.com', '3690021205', '') ####### Creation - 2025-12-01 21:29:44 ########## --------- 2025-12-01 21:29:44 --------- - [getLogfile] suffixe = toolbox delegueEmail = jessica.pouzet@roche.com ##################################################