--------------------------------------------
--------- 2026-06-08 14:45:29 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-06-08 14:45:28 ---------
--------- insertServiceInDb --------------------
query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected)  VALUES ( '2026-06-08 14:45:28', 'vvelia@bipharma.eu', '3690028175', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) 

--------------------------------------------
--------- 2026-06-08 14:45:25 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-06-08 14:45:24 ---------
--------- insertOffre --------------------
query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690028175', 'vvelia@bipharma.eu', 'offreSpeciale', '', '', '2026-06-08 14:45:24') 

--------------------------------------------
--------- 2026-06-08 14:45:15 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-06-08 14:45:13', '3690028175', 'utilisateur', 'vvelia@bipharma.eu', '', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

--------------------------------------------
--------- 2026-06-08 14:45:10 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-06-08 08:28:21 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-06-08 08:28:19 ---------
--------- insertOffre --------------------
query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690030033', 'vvelia@bipharma.eu', 'offreSpeciale', '', '', '2026-06-08 08:28:19') 

--------------------------------------------
--------- 2026-06-04 16:58:44 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-06-04 16:58: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 ('3690027299', 'vvelia@bipharma.eu', '2026-06-04 16:58:42', 
													105957, 
													33959.33,
													0, 
													500, 
													550, 
													-1, 
													500, -1, 
													250, -1, 
													20, -1, 
													31, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													54, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-06-04 16:58:42] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence)  VALUES ( '2026-06-04 16:58:42', '3690027299', 'produit', 'vvelia@bipharma.eu', 0, 500, 550, '2026-06-08', 'wSn5otxo2REwFtSGN1aqH6gF24VOrY5ZFGNpKcOAFmxV3t1dXWDxhd58QCAJhuV3', 0, 'VIP-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-03 14:51:35 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-06-03 14:51:34', '3690539793', 'utilisateur', 'vvelia@bipharma.eu', '', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

--------------------------------------------
--------- 2026-06-01 16:49:32 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-06-01 16:49:32 ##########
--------- 2026-06-01 16:49:32 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = vvelia@bipharma.eu

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