--------------------------------------------
--------- 2026-01-22 16:48:26 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-22 16:48:24] [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 ('3690000002', 'ines.benabid@roche.com', '2026-01-22 16:48:24', 
													90516, 
													9425.4,
													19, 
													44, 
													108, 
													8, 
													210, 10, 
													108, 8, 
													12, 2, 
													114, 
													4,
													6, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-22 16:48:23] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-22 16:48:23', '3690000002', 'produit', 'ines.benabid@roche.com', 19, 44, 108, '2026-01-26*2026-04-21*2026-07-15*2026-12-16', 'eN3faQCi26bKnEli3SeuzMLEoZqU85ZDJiBsk90OwF1hoHWJqyGLRNI0BGlnekNs', 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-01-16 11:45:26 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-16 11:45:23] [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 ('3690000000', 'ines.benabid@roche.com', '2026-01-16 11:45:23', 
													90265, 
													57648.11,
													630, 
													1470, 
													0, 
													-1, 
													2100, -1, 
													250, -1, 
													6, -1, 
													30, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-16 11:45:23] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-16 11:45:23', '3690000000', 'produit', 'ines.benabid@roche.com', 630, 1470, 116, '2026-01-20', 'AikJ5lT0zywjOSLEEfZK7g42YEwLkGshhTVhKy8YGbJJ4jupezsnTHlL31J8fvuJ', 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-12 13:26:54 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-12 13:26:51] [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 ('3690000000', 'ines.benabid@roche.com', '2026-01-12 13:26:51', 
													90075, 
													12045.75,
													200, 
													50, 
													100, 
													-1, 
													250, -1, 
													250, -1, 
													6, -1, 
													10, 
													-1,
													-1, 
													0, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-12 13:26:51] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-12 13:26:51', '3690000000', 'produit', 'ines.benabid@roche.com', 200, 50, 100, '2026-01-16*2026-04-16*2026-07-16*2026-10-16', 'Ai5xZQvRm4ETVCcBHviAjXXDWnuovqFClmnYSRYuCiBDLRxz5ZMFJHREzTaQ1Omb', 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-12 13:20:27 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

--------------------------------------------
--------- 2026-01-12 13:20:27 ---------
--------- insertServiceInDb --------------------
query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected)  VALUES ( '2026-01-12 13:20:27', 'ines.benabid@roche.com', '3690000000', 'Contrat DiabConnect', '0000-00-00', '', '-1', -1, 'contratDiabConnect', '', 0, , 1) 

--------------------------------------------
--------- 2026-01-08 11:35:46 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php

-----------------------------------------------------
-- [2026-01-08 11:35:44] [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 ('3690000001', 'ines.benabid@roche.com', '2026-01-08 11:35:44', 
													90011, 
													2771.81,
													20, 
													10, 
													20, 
													-1, 
													30, -1, 
													10, -1, 
													10, -1, 
													30, 
													-1,
													-1, 
													120, 
													0, 
													0, 
													-1, 
													-1, 
													0)

-----------------------------------------------------
-- [2026-01-08 11:35:44] [insertContrat]  --

-----------------------------------------------------
EVER sent to webhelp...
query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence)  VALUES ( '2026-01-08 11:35:44', '3690000001', 'produit', 'ines.benabid@roche.com', 20, 10, 20, '2026-01-12*2026-07-13', 'sJreNknBN7iNlb1dYpmGob0B8KQbdPQtTlMwzCPyP0B2tSYMu7gZfN7nZs5jhTCE', 120, 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 11:45:15 ---------
--------- callCurl --------------------
- url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php
####### Creation - 2026-01-06 11:45:15 ##########
--------- 2026-01-06 11:45:15 ---------
- [getLogfile] suffixe = toolbox
delegueEmail = ines.benabid@roche.com

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