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

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

-----------------------------------------------------
-- [2026-01-19 11:24:52] [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 ('3690022981', 'salome.meunier@roche.com', '2026-01-19 11:24:52', 
													90297, 
													3503.25,
													0, 
													75, 
													25, 
													-1, 
													75, -1, 
													50, -1, 
													6, -1, 
													8, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-19 11:24:52] [insertContrat]  --

-----------------------------------------------------
Will send to webhelp...
- nbTest : 100
- palier : 0
- palierData : 
 getPalierDataByPharma 1 palier = 0
 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-19 11:24:52', '3690022981', 'produit', 'salome.meunier@roche.com', 0, 75, 25, '2026-01-23*2026-04-23*2026-07-23*2026-10-23', 'AzsnuwAo7tkgTY2hT8fCfvUovnkeNNiFcVYFdAq34hTTF1hjZfHdrtieY7ukTmY2', 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-14 17:17:50 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-07 16:57:59 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-06 17:18:31 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-06 17:18:29] [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 ('3690032646', 'salome.meunier@roche.com', '2026-01-06 17:18:29', 
													89990, 
													3635.55,
													0, 
													92, 
													12, 
													-1, 
													92, -1, 
													60, -1, 
													2, -1, 
													11, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-06 17:18:29] [insertContrat]  --

-----------------------------------------------------
Will send to webhelp...
- nbTest : 104
- palier : 0
- palierData : 
 getPalierDataByPharma 1 palier = 0
 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 17:18:29', '3690032646', 'produit', 'salome.meunier@roche.com', 0, 92, 12, '2026-01-12*2026-04-10*2026-07-10*2026-10-12', 'ackuxRkvxBPsJEVtARXRRe4B6DCuLLzzl3tIktFgGW7kAideqNJJjr68Lq4SpT6H', 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 16:50:51 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-06 16:15:53 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-06 11:45:12 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-06 11:45:12 ---------
--------- insertOffre --------------------
query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690035853', 'salome.meunier@roche.com', 'offreAccuFine', 'emailPharma=pharmaciedesdeuxcroix@gmail.com&idPharma=3690035853&nomSignataire=Lancelin&prenomSignataire=Angèle', '', '2026-01-06 11:45:12') 

--------------------------------------------
--------- 2026-01-06 11:07:02 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-01-06 11:07:02 ##########
--------- 2026-01-06 11:07:02 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = salome.meunier@roche.com

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