-------------------------------------------- --------- 2026-06-04 15:19:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 15:08:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 14:59:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-04 14:59:22 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690020144 -------------------------------------------- --------- 2026-06-04 14:57:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-04 14:57:11', '3690020144', 'utilisateur', 'laurene.alagoa@roche.com', '45eTiwUIXWY7AfcxUQSh5Qot2ZZPKaIXr1FT3XcRjIEecbyrMVjisM25OEDZdIrM', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-04 11:22:47 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-04 11:22:47 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690023257', 'laurene.alagoa@roche.com', 'offreGiphar', 'nbOffre=1&qteByRef=08721106001:44#07400870080:4#05208491001:0#07522851171:0#06383599038:0#07203233038:0#03603539150:0#10441577001:0#09504664001:0#09504613001:0#09504729001:0&emailPharma=pharmaesterel@orange.fr&idPharma=3690023257&nomSignataire=PELISSIER&prenomSignataire=YANN', '08721106001:44#07400870080:4#05208491001:0#07522851171:0#06383599038:0#07203233038:0#03603539150:0#10441577001:0#09504664001:0#09504613001:0#09504729001:0', '2026-06-04 11:22:47') -------------------------------------------- --------- 2026-06-04 10:20:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 14:47:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 09:33:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-03 09:33:05 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690028368 ----------------------------------------------------- -- [2026-06-03 09:33:05] [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 ('3690028368', 'laurene.alagoa@roche.com', '2026-06-03 09:33:05', 105886, 2222.76, 0, 48, 24, -1, 48, -1, 42, -1, 0, -1, 0, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-03 09:33:05] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 72 - 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-03 09:33:05', '3690028368', 'produit', 'laurene.alagoa@roche.com', 0, 48, 24, '2026-06-08*2026-09-07*2026-12-07', '0FwnuVbyDFf28QjAWJHrL8pCu0NNnfCSDAXTRtzvtwlxiv48Pg6exehOlEny8jLu', 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 11:53:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 11:48:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-02 11:48:09 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690033773 -------------------------------------------- --------- 2026-06-02 11:43:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-02 11:33:46 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-02 11:33:46 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690030368 -------------------------------------------- --------- 2026-06-02 09:05:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-02 09:05: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 ('3690016784', 'laurene.alagoa@roche.com', '2026-06-02 09:05:25', 105851, 1306.02, 0, 36, 3, -1, 36, -1, 36, -1, 0, -1, 6, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-02 09:05:25] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 39 - 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-02 09:05:25', '3690016784', 'produit', 'laurene.alagoa@roche.com', 0, 36, 3, '2026-06-08*2026-08-03', '8pzwPDH5XB3qZdMzjgAJGg9q4EwK13f7juw31z547mC35Ow9pe9Sui3wgm6BG64E', 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-01 15:39:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 15:22:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 10:14:53 --------- --------- 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 10:14:53', '3690024939', 'utilisateur', 'laurene.alagoa@roche.com', '7O5DRQPCn5V0GXfZhOB5kVdrxr6SKrVdmSWeWqR0Py7qtUtWgAcbyUUm1JiUo2On', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-01 10:05:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 09:16:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-01 09:16:09 ########## --------- 2026-06-01 09:16:09 --------- - [getLogfile] suffixe = toolbox delegueEmail = laurene.alagoa@roche.com ##################################################