-------------------------------------------- --------- 2026-04-02 16:52:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-02 16:52:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-04-02 16:52:33] [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 ('3690019572', 'benoit.joly@roche.com', '2026-04-02 16:52:33', 101126, 5900.72, 0, 110, 85, -1, 110, -1, 85, -1, 4, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-02 16:52:33] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 195 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 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-02 16:52:33', '3690019572', 'produit', 'benoit.joly@roche.com', 0, 110, 85, '2026-04-06*2026-07-02*2026-09-07*2026-12-01', '', 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-02 16:52:31 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690019572 ----------------------------------------------------- -- [2026-04-02 16:52:31] [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 ('3690019572', 'benoit.joly@roche.com', '2026-04-02 16:52:31', 101126, 5900.72, 0, 110, 85, -1, 110, -1, 85, -1, 4, -1, 10, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-02 16:52:31] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 195 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 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-02 16:52:31', '3690019572', 'produit', 'benoit.joly@roche.com', 0, 110, 85, '2026-04-06*2026-07-02*2026-09-07*2026-12-01', '', 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-02 16:52:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-02 16:52:22 --------- --------- 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 16:52:23', '3690019572', 'utilisateur', 'benoit.joly@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-04-02 16:52:20', '3690019572', 'utilisateur', 'benoit.joly@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-02 14:43:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-02 14:43:04 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690013002 -------------------------------------------- --------- 2026-04-02 14:42:27 --------- --------- 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 14:42:27', '3690013002', 'utilisateur', 'benoit.joly@roche.com', 'oLS3BBRlMWP1ISH2M946fIDXiEIUmplxC8yXLtr0sThTQv1zcjEY5nHcWz6lBRBd', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-02 14:32:29 --------- --------- 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 14:32:27', '3690012117', 'utilisateur', 'benoit.joly@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-02 14:32:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-02 14:32:21 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690012117', 'benoit.joly@roche.com', 'offreSpeciale', '', '', '2026-04-02 14:32:21') -------------------------------------------- --------- 2026-04-02 14:32:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-02 14:32:12 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690012117 ----------------------------------------------------- -- [2026-04-02 14:32:11] [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 ('3690012117', 'benoit.joly@roche.com', '2026-04-02 14:32:11', 101084, 15915.68, 10, 360, 135, -1, 370, -1, 320, -1, 6, -1, 55, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-04-02 14:32:11] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-04-02 14:32:11', '3690012117', 'produit', 'benoit.joly@roche.com', 10, 360, 135, '2026-04-06*2026-07-06*2026-10-05', '', 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-02 10:53:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-04-02 10:53:40 --------- --------- 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:53:38', '3690016200', 'utilisateur', 'benoit.joly@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-04-02 09:45:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-04-02 09:45:36 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690012729 ####### Creation - 2026-04-02 09:45:36 ########## --------- 2026-04-02 09:45:36 --------- - [getLogfile] suffixe = toolbox delegueEmail = benoit.joly@roche.com ##################################################