-------------------------------------------- --------- 2026-01-23 16:12:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-23 16:12:23', '3690000002', 'utilisateur', 'helkartite@sqli.com', 'bgPvt1FxfmbYiCHCZSE7MHLjRJJ8h6QcK9et80szrfHQm9hGY8ms9XeNZuOdWpwJ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 12:25:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-01-22 12:25:09 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690000002 -------------------------------------------- --------- 2026-01-22 11:05:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 10:07:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-21 10:07:57] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-21 10:07:57', 90418, 8159.06, 18, 42, 100, -1, 200, -1, 50, -1, 2, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-21 10:07:57] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-21 10:07:57', '3690000002', 'produit', 'helkartite@sqli.com', 18, 42, 100, '2026-01-26*2026-07-15', '', 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-01-21 09:58:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-21 09:58: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 ('3690000002', 'helkartite@sqli.com', '2026-01-21 09:58:26', 90418, 8159.06, 18, 42, 100, -1, 200, -1, 50, -1, 2, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-21 09:58:26] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-21 09:58:26', '3690000002', 'produit', 'helkartite@sqli.com', 18, 42, 100, '2026-01-26*2026-07-16', 'afz504ZPCnlS0SYkSkx2WFlO3v5v58qu2QEwyy2K2lGOn690ET4kkNPFlaCn0MKp', 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-01-19 16:05:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 11:55:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 11:55:27] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-19 11:55:27', 90296, 8106.2, 18, 42, 100, -1, 200, -1, 50, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 11:55:27] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 11:55:27', '3690000002', 'produit', 'helkartite@sqli.com', 18, 42, 100, '2026-01-23*2026-07-15', '87ZJv8pn5OJY3n7nub6swjLgGOa1nPAU9Mbp6JablALzqkuqeprBm0Bi3GNWefnz', 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-01-19 11:54:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 11:54:23] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-19 11:54:23', 90296, 8106.2, 18, 42, 100, -1, 200, -1, 50, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 11:54:23] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 11:54:23', '3690000002', 'produit', 'helkartite@sqli.com', 18, 42, 100, '2026-01-23*2026-07-15', 'cF33xAkjZ434qfki641QDMcB4bNhx0G5VCKv3f0PyrZmYsRzNMhKF1mC5HdBN3Wn', 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-01-19 11:49:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 11:49: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 ('3690000001', 'helkartite@sqli.com', '2026-01-19 11:49:05', 90301, 9532.56, 63, 147, 105, -1, 210, -1, 105, -1, 3, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 11:49:05] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 11:49:05', '3690000001', 'produit', 'helkartite@sqli.com', 63, 147, 105, '2026-01-23*2026-07-23', 'dpy8QCJaA3aAV8zS0YanmzmAPGpyAWg4CNqzJISCGAxJE5u7M45bqkdvkKfryjjf', 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) -------------------------------------------- --------- 2026-01-19 11:39:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 11:21:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 11:21: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 ('3690000002', 'helkartite@sqli.com', '2026-01-19 11:21:16', 90296, 8106.2, 18, 42, 100, -1, 200, -1, 50, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 11:21:16] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-19 11:21:16', '3690000002', 'produit', 'helkartite@sqli.com', 18, 42, 100, '2026-01-23*2026-07-15', '8UMPBAvwK8SDf5zT17lQsHhYtJXRGI0oUzj2VJRJqzUHYdLpaoosTZH4qBEyfzoG', 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-01-15 14:47:14 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 14:47:14] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-15 14:47:14', 90175, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 14:47:14] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 14:47:14', '3690000002', 'produit', 'helkartite@sqli.com', 0, 0, 0, '2026-01-19*2026-07-13', 'vq7FPVvwvuKMLkuLKRCYGpNMGpvM1K17NnKXMj7UEAlLiSFUVTAJSB5toInMIp48', 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-01-15 14:44:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 14:44:42] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-15 14:44:42', 90175, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 14:44:42] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 14:44:42', '3690000002', 'produit', 'helkartite@sqli.com', 0, 0, 0, '2026-01-19*2026-07-13', '', 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-01-15 09:54:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 09:54:58] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-15 09:54:58', 90175, 8681.72, 100, 100, 100, -1, 200, -1, 100, -1, 4, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 09:54:58] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 09:54:58', '3690000002', 'produit', 'helkartite@sqli.com', 100, 100, 100, '2026-01-19*2026-07-13', '', 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-01-15 09:34:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 09:34: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 ('3690000002', 'helkartite@sqli.com', '2026-01-15 09:34:33', 90175, 8681.72, 100, 100, 100, -1, 200, -1, 100, -1, 4, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 09:34:33] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 09:34:33', '3690000002', 'produit', 'helkartite@sqli.com', 100, 100, 100, '2026-01-19*2026-05-15*2026-09-08', 'Hb1DpK9uekETUU1AVZbeEc4r9XyjZNz398i2rEtIjUdjGAdk4FCTzBewlfABLbTQ', 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-01-15 09:23:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 09:23:01] [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 ('3690000002', 'helkartite@sqli.com', '2026-01-15 09:23:01', 90175, 0, 0, 0, 0, -1, 0, -1, 0, -1, 0, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 09:23:01] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-15 09:23:01', '3690000002', 'produit', 'helkartite@sqli.com', 0, 0, 0, '2026-01-19*2026-07-13', 'TlNGwclKRSoPL7Gw2gO1jLjDh1PnBjMj8R5EdFqveqQt3RNXBH8dZppPayD2KNEJ', 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-01-12 14:07:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 14:07:00 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaaa&prenomSignataire=bbb', '', '2026-01-12 14:07:00') -------------------------------------------- --------- 2026-01-12 14:05:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 14:05:29 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaaa&prenomSignataire=bbb', '', '2026-01-12 14:05:29') -------------------------------------------- --------- 2026-01-12 12:01:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 12:01:25 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=bbbb', '', '2026-01-12 12:01:25') -------------------------------------------- --------- 2026-01-12 11:57:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:57:45 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=bbbb', '', '2026-01-12 11:57:45') -------------------------------------------- --------- 2026-01-12 11:56:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:56:38 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:56:38') -------------------------------------------- --------- 2026-01-12 11:56:06 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:56:06') -------------------------------------------- --------- 2026-01-12 11:54:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:54:52 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:54:52') -------------------------------------------- --------- 2026-01-12 11:53:01 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:53:01 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:53:01') -------------------------------------------- --------- 2026-01-12 11:49:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:49:16 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:49:16') -------------------------------------------- --------- 2026-01-12 11:47:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:47:17 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:47:17') -------------------------------------------- --------- 2026-01-12 11:45:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:45:02 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:45:02') -------------------------------------------- --------- 2026-01-12 11:41:08 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:41:08 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:41:08') -------------------------------------------- --------- 2026-01-12 11:39:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:39:20 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:39:20') -------------------------------------------- --------- 2026-01-12 11:38:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:38:00 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000002', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000002&nomSignataire=aaa&prenomSignataire=aaaa', '', '2026-01-12 11:38:00') -------------------------------------------- --------- 2026-01-12 11:18:40 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-12 11:18:40 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690000001', 'helkartite@sqli.com', 'offreAccuFine', 'emailPharma=test@test.fr&idPharma=3690000001&nomSignataire=EL KARTITE aa&prenomSignataire=Houcin', '', '2026-01-12 11:18:40') -------------------------------------------- --------- 2026-01-12 10:58:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 10:58:00] [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 ('3690000001', 'helkartite@sqli.com', '2026-01-12 10:58:00', 90067, 9278.93, 50, 150, 100, -1, 200, -1, 120, -1, 3, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 10:58:00] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 10:58:00', '3690000001', 'produit', 'helkartite@sqli.com', 50, 150, 100, '2026-01-16*2026-07-16', 'KUS1LUtqTLPNUHmnjlhhsXaXjXqeaN2JJfrsq1ECRMLSNA1oMKjMusmLJxixF0cT', 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) -------------------------------------------- --------- 2026-01-12 10:56:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 10:56:57] [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 ('3690000001', 'helkartite@sqli.com', '2026-01-12 10:56:57', 90067, 9278.93, 50, 150, 100, -1, 200, -1, 120, -1, 3, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 10:56:57] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-12 10:56:57', '3690000001', 'produit', 'helkartite@sqli.com', 50, 150, 100, '2026-01-16*2026-07-16', '4CQL5WIQvAYIeN2BABBYLldShukm98SLVo2os6wv5z46s8Vy92XwgiJ1jH0g6VkJ', 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) ####### Creation - 2026-01-12 10:56:57 ########## --------- 2026-01-12 10:56:57 --------- - [getLogfile] suffixe = toolbox delegueEmail = helkartite@sqli.com ##################################################