--------------------------------------------
--------- 2026-04-02 23:20:58 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-04-01 15:27:25 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-------------------------------------------------------------------------
--------- 2026-04-01 15:27:25 ----------------------------------------
--------- setContratUtilisateurHasAcGuideValueCommande --------------------
query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690011964

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

-------------------------------------------------------------------------
--------- 2026-04-01 15:23:41 ----------------------------------------
--------- setContratUtilisateurHasAcGuideValueCommande --------------------
query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690021863

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

-------------------------------------------------------------------------
--------- 2026-04-01 15:19:08 ----------------------------------------
--------- setContratUtilisateurHasAcGuideValueCommande --------------------
query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690038617

-----------------------------------------------------
-- [2026-04-01 15:19:07] [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 ('3690038617', 'thomas.degache@roche.com', '2026-04-01 15:19:07', 
													101012, 
													7142.8,
													0, 
													120, 
													100, 
													-1, 
													120, -1, 
													160, -1, 
													0, -1, 
													10, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-01 15:19:07] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-01 15:19:07', '3690038617', 'produit', 'thomas.degache@roche.com', 0, 120, 100, '2026-04-06*2026-07-06*2026-10-06', 'aWj2aY0VX0g6KKWmBJ1bu8I4F11LhuddkglCUS5jUizWTxra78hBciMQw9avp07M', 0, 1 )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-01 14:19:37 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

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

-----------------------------------------------------
-- [2026-04-01 11:37:40] [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 ('3690016556', 'thomas.degache@roche.com', '2026-04-01 11:37:40', 
													100983, 
													6519.27,
													0, 
													180, 
													24, 
													-1, 
													180, -1, 
													150, -1, 
													1, -1, 
													10, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-04-01 11:37:40] [insertContrat]  --

-----------------------------------------------------
Will send to webhelp...
- nbTest : 204
- palier : 1
- palierData : 
 getPalierDataByPharma 1 palier = 1
 getPalierDataByPharma 2
 getPalierDataByPharma 3
Will send to webhelp 2...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-04-01 11:37:40', '3690016556', 'produit', 'thomas.degache@roche.com', 0, 180, 24, '2026-04-06*2026-07-22*2026-10-05', '', 0, 1 )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-01 09:33:12 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-04-01 09:33:12 ##########
--------- 2026-04-01 09:33:12 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = thomas.degache@roche.com

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