--------------------------------------------
--------- 2026-06-04 11:02:09 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-06-04 11:02:09', '3690025213', 'utilisateur', 'benoit.rutigliano@roche.com', 'vJGRFFcxQrdcvTcjigsifJ1ddbc9qwIIDfTc7tsaY4Drs6AQt0DByNTQhsqWBCCQ', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

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

--------------------------------------------
--------- 2026-06-04 11:00:59 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

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

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-06-04 10:08:19', '3690021693', 'utilisateur', 'benoit.rutigliano@roche.com', 'rhophusHh9Hx2kDQPu1jPn0J55qL7fTLsTg45aEG9kNgrPOBUmOscPzuApb31LgH', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

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

-------------------------------------------------------------------------
--------- 2026-06-02 16:03:01 ----------------------------------------
--------- setContratUtilisateurHasAcGuideValueCommande --------------------
query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690025213

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

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-06-02 16:01:16', '3690025213', 'utilisateur', 'benoit.rutigliano@roche.com', 'eTGAq9XbbWBCdwSX3A8evy3LQacEeH5fpbT3vShEc5PXGLPAnU5Nt9WyafY2MVzz', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

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

-----------------------------------------------------
-- [2026-06-01 14:34:16] [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 ('3690023128', 'benoit.rutigliano@roche.com', '2026-06-01 14:34:16', 
													105832, 
													14893.49,
													0, 
													280, 
													240, 
													-1, 
													280, -1, 
													150, -1, 
													4, -1, 
													16, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-06-01 14:34:16] [insertContrat]  --

-----------------------------------------------------
Will send to webhelp...
- nbTest : 520
- palier : 4
- palierData : 
 getPalierDataByPharma 1 palier = 4
 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-01 14:34:16', '3690023128', 'produit', 'benoit.rutigliano@roche.com', 0, 280, 240, '2026-06-05*2026-08-06*2026-10-06*2027-01-06', 'uUC4CtwAofOwffRpDgemkFGN5bi3SRstynhVKr4BaGx06eua9HCj0HsI3LeqsJUK', 0, 'OR-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)
				
####### Creation - 2026-06-01 14:34:16 ##########
--------- 2026-06-01 14:34:16 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = benoit.rutigliano@roche.com

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