-------------------------------------------- --------- 2026-06-11 21:18:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-11 21:18:36 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690674821 -------------------------------------------- --------- 2026-06-11 21:17:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-11 21:17:30', '3690674821', 'utilisateur', 'e.marielouise@prespharm-om.fr', '18yKmkP7ajRvuUYuUZSMQKzY27qfdJR7fPkHC0zb1EDVWObUsQpCnfVDp1VddCd3', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-09 00:05:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-06 00:23:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-06 00:23:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-06 00:23:04 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-06 00:23:04', 'e.marielouise@prespharm-om.fr', '3690035537', 'Bilan matériel', '2026-06-05', '-', '0', 0, '10374489001', '', 0, 52408, 1) -------------------------------------------- --------- 2026-06-06 00:23:03 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-06 00:23:03', 'e.marielouise@prespharm-om.fr', '3690035537', 'Pack réseaux sociaux', '2026-06-05', '-', '0', 0, '09639438001', '', 0, 52408, 1) Pack réseaux sociaux detected... query2 = SELECT email FROM Pharmacies WHERE idPharma = '3690035537' email = ph.deris@wanadoo.fr ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php response = {"status":"OK", "msg":"Email correctement envoyé à : ph.deris@wanadoo.fr"} -------------------------------------------- --------- 2026-06-06 00:23:03 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-06 00:23:03', 'e.marielouise@prespharm-om.fr', '3690035537', 'zLicwGZERqFPM32Ky5abbH1Luas6V1Oo0kjzVqiBhuxeeG05rZk59bhOkyQ5A7Ow') -------------------------------------------- --------- 2026-06-06 00:21:48 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-06 00:21:48 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-06 00:21:48', 'e.marielouise@prespharm-om.fr', '3690035537', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) -------------------------------------------- --------- 2026-06-06 00:21:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-06 00:20:59] [insertFormationV2] -- query = INSERT INTO Formation (idPharma, emailIcpo, idInApp, contact, dateFormation, creneau, dateInsert, fromBdc) VALUES ('3690035537', 'e.marielouise@prespharm-om.fr', 35, 'ARIELLE DERIS', '15/09/2026', 'Matin', '2026-06-06 00:20:59', 0 ) -------------------------------------------- --------- 2026-06-06 00:20:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-06 00:20:59] [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 ('3690035537', 'e.marielouise@prespharm-om.fr', '2026-06-06 00:20:59', 106001, 6539.63, 0, 120, 70, -1, 120, -1, 50, -1, 3, -1, 6, -1, -1, 0, 0, 0, 2, -1, 0) ----------------------------------------------------- -- [2026-06-06 00:20:59] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 190 - palier : 1 - palierData : getPalierDataByPharma 1 palier = 1 getPalierDataByPharma 2 Will send to webhelp 2... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-06 00:20:59', '3690035537', 'produit', 'e.marielouise@prespharm-om.fr', 0, 120, 70, '2026-09-15*2027-01-15*2027-05-12', 'yfn5301ZstlZNZbUoHBq8lb6siVd7xa2jUIJRfRhDBJ0YYImqpiSQmftY8Klrn0K', 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-06 00:14:28 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 15:29:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 15:29:48 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-03 15:29:48', 'e.marielouise@prespharm-om.fr', '3690023772', 'Bilan matériel', '2026-06-03', '-', '0', 0, '10374489001', '', 0, 52385, 1) -------------------------------------------- --------- 2026-06-03 15:29:47 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-03 15:29:47', 'e.marielouise@prespharm-om.fr', '3690023772', 'Pack réseaux sociaux', '2026-06-03', '-', '0', 0, '09639438001', '', 0, 52385, 1) Pack réseaux sociaux detected... query2 = SELECT email FROM Pharmacies WHERE idPharma = '3690023772' email = charles.elgea@orange.fr ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php response = {"status":"OK", "msg":"Email correctement envoyé à : charles.elgea@orange.fr"} -------------------------------------------- --------- 2026-06-03 15:29:47 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-03 15:29:47', 'e.marielouise@prespharm-om.fr', '3690023772', 'SqVK9nagX0aC9PsU2eoOZRBlBnCIhvThdZlwJUkVckx8o6UJ346Hv6F4rpv9sbCC') -------------------------------------------- --------- 2026-06-03 15:28:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 15:27:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-03 15:27:09] [insertFormationV2] -- query = INSERT INTO Formation (idPharma, emailIcpo, idInApp, contact, dateFormation, creneau, dateInsert, fromBdc) VALUES ('3690023772', 'e.marielouise@prespharm-om.fr', 35, 'JAMISNA GUIBUS', '21/07/2026', 'Matin', '2026-06-03 15:27:09', 0 ) -------------------------------------------- --------- 2026-06-03 15:27:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-03 15:27: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 ('3690023772', 'e.marielouise@prespharm-om.fr', '2026-06-03 15:27:05', 105900, 10906.35, 0, 280, 60, -1, 280, -1, 80, -1, 5, -1, 25, -1, -1, 0, 0, 0, 1, -1, 0) ----------------------------------------------------- -- [2026-06-03 15:27:05] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 340 - palier : 3 - palierData : getPalierDataByPharma 1 palier = 3 getPalierDataByPharma 2 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 15:27:05', '3690023772', 'produit', 'e.marielouise@prespharm-om.fr', 0, 280, 60, '2026-06-08*2026-09-10*2026-12-10*2027-03-10', '42DtBcWeFcUARsv9DXBmTi6OBTYik5ZeCPSkQE5OcQJr9E1C1TiAyLOtfXb4YzCt', 0, 'ARGENT-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-01 21:50:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 21:50:24 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 21:50:24', 'e.marielouise@prespharm-om.fr', '3690023610', 'Bilan matériel', '2026-06-01', '-', '0', 0, '10374489001', '', 1, 52363, 1) -------------------------------------------- --------- 2026-06-01 21:50:23 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 21:50:23', 'e.marielouise@prespharm-om.fr', '3690023610', 'Pack réseaux sociaux', '2026-06-01', '-', '0', 0, '09639438001', '', 1, 52363, 1) Pack réseaux sociaux detected... query2 = SELECT email FROM Pharmacies WHERE idPharma = '3690023610' email = gerard.largen@pharmacie-cypria.fr ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php response = {"status":"OK", "msg":"Email correctement envoyé à : gerard.largen@pharmacie-cypria.fr"} -------------------------------------------- --------- 2026-06-01 21:50:23 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-01 21:50:23', 'e.marielouise@prespharm-om.fr', '3690023610', 'MtzLUgmae6GYPMGjYtRAtNkIBLlzfLGJBB5g2PF5D4Joetr0hLfXp7rPofFESqBf') -------------------------------------------- --------- 2026-06-01 21:49:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-01 21:49:26 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-01 21:49:26', 'e.marielouise@prespharm-om.fr', '3690023610', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) -------------------------------------------- --------- 2026-06-01 21:48:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-01 21:48:10] [insertFormationV2] -- query = INSERT INTO Formation (idPharma, emailIcpo, idInApp, contact, dateFormation, creneau, dateInsert, fromBdc) VALUES ('3690023610', 'e.marielouise@prespharm-om.fr', 35, 'CYPRIA DAVID', '07/07/2026', 'Matin', '2026-06-01 21:48:10', 0 ) -------------------------------------------- --------- 2026-06-01 21:48:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-01 21:48:06] [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 ('3690023610', 'e.marielouise@prespharm-om.fr', '2026-06-01 21:48:06', 105848, 12063.25, 0, 300, 75, -1, 300, -1, 150, -1, 5, -1, 25, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-01 21:48:06] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-01 21:48:06', '3690023610', 'produit', 'e.marielouise@prespharm-om.fr', 0, 300, 75, '2026-07-10*2026-08-10*2026-09-10*2026-10-12*2026-11-10', 'Kdg2cwfNR9DwI7iBRy1Vgh0xU8uZBqFcdiD2jXz3N8aSPT1CjhewDOoXY9DTRvGU', 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) ####### Creation - 2026-06-01 21:48:06 ########## --------- 2026-06-01 21:48:06 --------- - [getLogfile] suffixe = toolbox delegueEmail = e.marielouise@prespharm-om.fr ##################################################