--------------------------------------------
--------- 2026-04-01 15:55:41 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-04-01 15:55:38] [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 ('3690018726', 'antoine.landrieu@roche.com', '2026-04-01 15:55:38', 
													101022, 
													18661.37,
													0, 
													600, 
													40, 
													-1, 
													600, -1, 
													200, -1, 
													20, -1, 
													6, 
													-1,
													-1, 
													0, 
													40, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-01 15:55:38] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-01 15:55:38', '3690018726', 'produit', 'antoine.landrieu@roche.com', 0, 600, 40, '2026-04-06*2026-08-05*2026-12-07', 'mCEPGNu7cZ7y4fQbdbrfff99CvtyRphd40xBPGKHLevk6j9QlzJ5LPpTEi8LwB4T', 40, 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-04-01 15:52:52 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-04-01 15:22:23 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-04-01 15:22:21 ---------
--------- insertServiceInDb --------------------
query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected)  VALUES ( '2026-04-01 15:22:21', 'antoine.landrieu@roche.com', '3690018654', 'Bilan matériel', '2026-04-01', '-', '0', 0, '10374489001', '', 0, 51893, 1) 

--------------------------------------------
--------- 2026-04-01 15:22:18 ---------
--------- insertServiceInDb --------------------
query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected)  VALUES ( '2026-04-01 15:22:18', 'antoine.landrieu@roche.com', '3690018654', 'Pack réseaux sociaux', '2026-04-01', '-', '0', 0, '09639438001', '', 0, 51893, 1) 
Pack réseaux sociaux detected...
query2 = SELECT email FROM Pharmacies WHERE idPharma = '3690018654' 
email = pharmacie-belledonne@orange.fr
ionosUrl = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
response =   {"status":"OK", "msg":"Email correctement envoyé à : pharmacie-belledonne@orange.fr"}

--------------------------------------------
--------- 2026-04-01 15:22:18 ---------
--------- insertBdcService --------------------
query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-04-01 15:22:18', 'antoine.landrieu@roche.com', '3690018654', 'azLG5ubtVbEjraFuuUYYQizvJFilKBKvXJqbm35JqVLl5oGl21q8b2hc6OvstLoR') 

--------------------------------------------
--------- 2026-04-01 15:21:03 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-04-01 15:21:03 ##########
--------- 2026-04-01 15:21:03 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = antoine.landrieu@roche.com

##################################################