--------------------------------------------
--------- 2026-04-03 12:07:52 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-------------------------------------------------------------------------
--------- 2026-04-03 12:07:52 ----------------------------------------
--------- setContratUtilisateurHasAcGuideValueCommande --------------------
query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690019504

--------------------------------------------
--------- 2026-04-03 12:06:46 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement)  VALUES ( '2026-04-03 12:06:44', '3690019504', 'utilisateur', 'sarah.teytau@roche.com', '', 1)ON DUPLICATE KEY UPDATE 
				dateSignature 		= VALUES(dateSignature),
				emailIcpo 			= VALUES(emailIcpo),
				docuSignToken 		= VALUES(docuSignToken)
				

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

--------------------------------------------
--------- 2026-04-02 14:48:02 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-04-02 14:48:05] [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 ('3690022446', 'sarah.teytau@roche.com', '2026-04-02 14:48:05', 
													101088, 
													18982.8,
													60, 
													500, 
													80, 
													-1, 
													560, -1, 
													300, -1, 
													4, -1, 
													40, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-02 14:48:05] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-02 14:48:05', '3690022446', 'produit', 'sarah.teytau@roche.com', 60, 500, 80, '2026-06-03*2026-09-02*2027-01-04*2027-04-01', '', 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-04-02 14:48:01] [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 ('3690022446', 'sarah.teytau@roche.com', '2026-04-02 14:48:01', 
													101088, 
													18982.8,
													60, 
													500, 
													80, 
													-1, 
													560, -1, 
													300, -1, 
													4, -1, 
													40, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-02 14:48:01] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-02 14:48:01', '3690022446', 'produit', 'sarah.teytau@roche.com', 60, 500, 80, '2026-06-03*2026-09-02*2027-01-04*2027-04-01', '', 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-04-02 14:47:11 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-04-02 14:47:10] [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 ('3690022446', 'sarah.teytau@roche.com', '2026-04-02 14:47:10', 
													101088, 
													18982.8,
													60, 
													500, 
													80, 
													-1, 
													560, -1, 
													300, -1, 
													4, -1, 
													40, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-02 14:47:10] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-02 14:47:10', '3690022446', 'produit', 'sarah.teytau@roche.com', 60, 500, 80, '2026-06-03*2026-09-02*2027-01-04*2027-04-01', '', 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)
				
####### Creation - 2026-04-02 14:47:10 ##########
--------- 2026-04-02 14:47:10 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = sarah.teytau@roche.com

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