--------------------------------------------
--------- 2026-01-20 11:39:09 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-20 11:39:08] [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 ('3690013755', 'thomas.oulhen@roche.com', '2026-01-20 11:39:08', 
													90384, 
													4321.53,
													30, 
													80, 
													10, 
													-1, 
													110, -1, 
													80, -1, 
													2, -1, 
													5, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-20 11:39:08] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-20 11:39:08', '3690013755', 'produit', 'thomas.oulhen@roche.com', 30, 80, 10, '2026-01-26*2026-04-24*2026-07-24*2026-10-26', '', 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-06 10:39:52 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-06 10:39:49] [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 ('3690018646', 'thomas.oulhen@roche.com', '2026-01-06 10:39:49', 
													89969, 
													8524.7,
													20, 
													210, 
													50, 
													-1, 
													230, -1, 
													100, -1, 
													3, -1, 
													9, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													4, 
													0)

-----------------------------------------------------
-- [2026-01-06 10:39:49] [insertContrat]  --

-----------------------------------------------------
Will send to webhelp...
- nbTest : 280
- palier : 2
- palierData : 
 getPalierDataByPharma 1 palier = 2
 getPalierDataByPharma 2
Will send to webhelp 2...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-06 10:39:49', '3690018646', 'produit', 'thomas.oulhen@roche.com', 20, 210, 50, '2026-01-12*2026-04-10*2026-07-10*2026-10-12', 'F7FMlOXm42HkEmNepPTDZ7JLTpAtUFsjgdhIcAXkKuZF1IcqHY9mhDF4GYiZAdQ3', 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-05 11:25:59 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-05 11:24:24 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-02 20:11:38 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-01-02 20:11:38 ##########
--------- 2026-01-02 20:11:38 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = thomas.oulhen@roche.com

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