-------------------------------------------- --------- 2026-01-26 11:03:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 11:03:39 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690014783', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=pharmaciethiers47@gmail.com&idPharma=3690014783&nomSignataire=HERVELEU&prenomSignataire=JEROME', '', '2026-01-26 11:03:39') -------------------------------------------- --------- 2026-01-26 10:16:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 10:16:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-26 10:16:29 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-26 10:16:29', 'romain.valette@roche.com', '3690013110', 'Sensibilisation avec borne et entretien diabète', '2026-01-29', '-', '0', 0, '10401273001', '', 1, 51451, 1) -------------------------------------------- --------- 2026-01-26 10:16:29 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-26 10:16:29', 'romain.valette@roche.com', '3690013110', 'Bilan matériel', '2026-05-04', '-', '0', 0, '10374489001', '', 1, 51451, 1) -------------------------------------------- --------- 2026-01-26 10:16:29 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-26 10:16:29', 'romain.valette@roche.com', '3690013110', 'Dxo9jwekQdYkhqgvSMpbgIEFaeoP0TkbQcKCAT0bVhaPHAgAEyVgq9FFQRJ9pdJS') -------------------------------------------- --------- 2026-01-26 10:08:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-26 10:08:06', '3690013110', 'utilisateur', 'romain.valette@roche.com', 'D8Zp9a5PLVKlV5yyxP1Nc0P00ha5N8yuBQiSojxM79FgMeagWGf77mc2BInKg1gQ', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-26 09:39:38 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 16:21:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 16:21:58 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690015701', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=accueil.pharmaciedes4saisons@gmail.com&idPharma=3690015701&nomSignataire=ERIC&prenomSignataire=FERRIERE', '', '2026-01-23 16:21:58') -------------------------------------------- --------- 2026-01-23 16:21:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 15:46:24 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 15:46:24 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690015701', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=pharmaciedesquatresaisons@orange.fr&idPharma=3690015701&nomSignataire=FERRIERE&prenomSignataire=ERIC', '', '2026-01-23 15:46:24') -------------------------------------------- --------- 2026-01-23 14:04:29 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:43:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:43:24 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 09:43:24', 'romain.valette@roche.com', '3690036658', 'Sensibilisation avec borne et entretien diabète', '2026-01-23', '-', '0', 0, '10401273001', '', 1, 51444, 1) -------------------------------------------- --------- 2026-01-23 09:43:24 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-23 09:43:24', 'romain.valette@roche.com', '3690036658', 'Bilan matériel', '2026-04-13', '-', '0', 0, '10374489001', '', 1, 51444, 1) -------------------------------------------- --------- 2026-01-23 09:43:24 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-23 09:43:24', 'romain.valette@roche.com', '3690036658', 'qnK6tzLBgIOBWp9qFbtVVSkSCOcZDTU9e2w5X1UN7YI4OKALhm7eUTm1cZIkPtBk') -------------------------------------------- --------- 2026-01-23 09:39:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-23 09:39:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-23 09:39:15] [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 ('3690036658', 'romain.valette@roche.com', '2026-01-23 09:39:15', 90546, 2687.04, 0, 60, 24, -1, 60, -1, 60, -1, 0, -1, 20, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-23 09:39:15] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 84 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-01-23 09:39:15', '3690036658', 'produit', 'romain.valette@roche.com', 0, 60, 24, '2026-03-09*2026-05-18*2026-08-10*2026-10-09', 'qS2g6wKlyQgPDuiJpqay6IslCZ7ujseCk6vFnVIbeO6i5oAXB0FYzOmlm12N9tVU', 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-23 09:39:15] [insertInfoComplentairePharma] -- ----------------------------------------------------- query = INSERT INTO PharmaInfoComplementaire (idPharma, emailIcpo, reponses, raisonAutre, dateInsert) VALUES ( '3690036658', 'romain.valette@roche.com', '1', '', '2026-01-23 09:39:15') -------------------------------------------- --------- 2026-01-23 09:19:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-23 09:19:03', '3690036658', 'utilisateur', 'romain.valette@roche.com', 'PJsZACVzr9bWUEcUuT3oogaHoF4N2Csaz31tAkT6yz2f6coKVsP5yYJB6ADpC6E6', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-23 09:12:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 15:42:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 15:41:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-22 15:41:14 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-22 15:41:14', 'romain.valette@roche.com', '3690021946', 'Diabete et Ramadan', '2026-01-22', '-', '0', 0, '10432217001', '', 1, 51436, 1) -------------------------------------------- --------- 2026-01-22 15:41:14 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-22 15:41:14', 'romain.valette@roche.com', '3690021946', 'Sensibilisation avec borne et entretien diabète', '2026-01-26', '-', '0', 0, '10401273001', '', 1, 51436, 1) -------------------------------------------- --------- 2026-01-22 15:41:14 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-22 15:41:14', 'romain.valette@roche.com', '3690021946', 'AxIGVHyH44HSgqpl5m7H6FgdEEFAyvqmL68jeoZymL3WpHrq74PmT9zGCopUwftx') -------------------------------------------- --------- 2026-01-22 15:32:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-22 15:32:42] [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 ('3690021946', 'romain.valette@roche.com', '2026-01-22 15:32:42', 90502, 16170.58, 0, 500, 3, -1, 500, -1, 400, -1, 0, -1, 50, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-22 15:32:42] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 503 - palier : 4 - palierData : getPalierDataByPharma 1 palier = 4 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-01-22 15:32:42', '3690021946', 'produit', 'romain.valette@roche.com', 0, 500, 3, '2026-02-11*2026-04-21*2026-06-10*2026-08-12', 'dbBLaqTfd8ZDK3JSjQz1Ii77wmDVNYsm3ia2cJHJ3nlUXNC5w9MRBLML87imKukk', 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-22 15:17:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-22 15:17:00', '3690021946', 'utilisateur', 'romain.valette@roche.com', '4PLceK2eJrsWxie7A7W0SCotIaXT4w23qfp9ER91vF5NY01b2bUkxA02ZdxvXsv7', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-22 09:24:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 14:43:30 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 14:43:30 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690033241', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=teletransgirondins@gmail.com&idPharma=3690033241&nomSignataire=YOURI&prenomSignataire=DAUCOURT', '', '2026-01-21 14:43:30') -------------------------------------------- --------- 2026-01-21 10:25:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-21 10:25:06', '3690031215', 'utilisateur', 'romain.valette@roche.com', 'qxHvtLbIw1pXIWT1m7iOB5Jl5TEizwUfB6cV4Xv2lBN6o2nx61TiILSUokqoYQVi', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-21 10:20:45 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-21 10:20:43] [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 ('3690031215', 'romain.valette@roche.com', '2026-01-21 10:20:43', 90421, 2582.46, 9, 48, 9, -1, 57, -1, 50, -1, 2, -1, 20, -1, -1, 50, 6, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-21 10:20:43] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 66 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-01-21 10:20:43', '3690031215', 'produit', 'romain.valette@roche.com', 9, 48, 9, '2026-01-26*2026-04-21*2026-07-16*2026-10-12', 'Ccqubx4w14m9b0Edo9M84WZjvmEI38b4h9ZFUODbHS600VAts9Wg6fxhqcyCSsMs', 56, 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-21 09:37:27 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 09:37:27 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690033241', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=teletransgirondins@gmail.com&idPharma=3690033241&nomSignataire=DAUCOURT&prenomSignataire=YOURI', '', '2026-01-21 09:37:27') -------------------------------------------- --------- 2026-01-21 09:35:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-21 09:35:39 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690033241', 'romain.valette@roche.com', 'offreAccuFine', 'emailPharma=teletransgirondins@gmail.com&idPharma=3690033241&nomSignataire=DAUCOURT&prenomSignataire=YOURI', '', '2026-01-21 09:35:39') -------------------------------------------- --------- 2026-01-20 11:19:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-20 11:19:43 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 16:23:51 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 16:13:20 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 15:56:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-19 15:56:09', '3690023720', 'utilisateur', 'romain.valette@roche.com', 'uzUXkw1I7U1qY20Bt3PNpXaYHrMrGwqP1GduawU59KdwELNzX4XPJA7obMv77dLK', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-19 15:08:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 15:01:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 14:36:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 14:36:14 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-19 14:36:13 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-19 14:36:13', 'romain.valette@roche.com', '3690023720', 'Diabete et Ramadan', '2026-01-19', '-', '0', 0, '10432217001', '', 1, 51409, 1) -------------------------------------------- --------- 2026-01-19 14:36:13 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-19 14:36:13', 'romain.valette@roche.com', '3690023720', 'Sensibilisation avec borne et entretien diabète', '2026-04-01', '-', '0', 0, '10401273001', '', 1, 51409, 1) -------------------------------------------- --------- 2026-01-19 14:36:13 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-19 14:36:13', 'romain.valette@roche.com', '3690023720', 'hNZNLepBqTWMFBbSskL7faOB0z4mPG19qWBuiGPqrOtuEY6Ow5sBfcRgB8YDTenm') -------------------------------------------- --------- 2026-01-19 14:32:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-19 14:32:20] [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 ('3690023720', 'romain.valette@roche.com', '2026-01-19 14:32:20', 90319, 1349.62, 0, 35, 6, -1, 35, -1, 29, -1, 2, -1, 11, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-19 14:32:20] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 41 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-01-19 14:32:20', '3690023720', 'produit', 'romain.valette@roche.com', 0, 35, 6, '2026-04-01*2026-07-01*2026-10-01', 'tiDGzB4KxysVrU7gmET1pJ7LxqASzmNiNrBsEjWTpyqJQmUKLAHEd3ZJP8GYpLwz', 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-19 14:18:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-19 14:18:44', '3690023720', 'utilisateur', 'romain.valette@roche.com', 'MzYTjuJuSnNq9wWhYDtTD1bHnw1GyjMSGMbMM4t2LmYw82KwaxXY1YYqK8DFLSpp', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-19 14:14:32 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-19 14:14:32', '3690023720', 'utilisateur', 'romain.valette@roche.com', 'DaxVxxMPGHbVhcRfNyJPSW2Q28K4LsZ8b4rsDy56IDUIkhE6nDShBRarjj3AjSnj', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 16:35:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 15:54:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 15:42:26 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-16 15:42:26', '3690023491', 'utilisateur', 'romain.valette@roche.com', 'nhN3r3UCJovHX80dTs82epv2F5EFSaQlhpfdGeEnvHXHoiBXV9gPQODB2et3Ydo0', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 14:29:58 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-16 14:29:58', '3690035122', 'utilisateur', 'romain.valette@roche.com', '8YejUwXcU7tKJcL8VwAmUYdNkcTAYTIoo9X8fBfaAxcop537ZHWZJqEDv0Ueau08', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-16 11:14:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-16 11:14:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 14:44:09 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 14:44:08 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-15 14:44:08', 'romain.valette@roche.com', '3690036147', 'Sensibilisation avec borne et entretien diabète', '2026-06-08', '-', '0', 0, '10401273001', '', 1, 51401, 1) -------------------------------------------- --------- 2026-01-15 14:44:08 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-01-15 14:44:08', 'romain.valette@roche.com', '3690036147', 'Bilan matériel', '2026-03-16', '-', '0', 0, '10374489001', '', 1, 51401, 1) -------------------------------------------- --------- 2026-01-15 14:44:08 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-01-15 14:44:08', 'romain.valette@roche.com', '3690036147', 'IhtQmXd1ZUZqKFaKejEjg60VZksBAm5Bjs5lMobGDjcetWkqEFN3fVfmaeCelckb') -------------------------------------------- --------- 2026-01-15 14:40:19 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-15 14:39:53 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-15 14:39: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 ('3690036147', 'romain.valette@roche.com', '2026-01-15 14:39:51', 90219, 3045.06, 0, 70, 40, -1, 70, -1, 20, -1, 2, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-15 14:39:51] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 110 - palier : 0 - palierData : getPalierDataByPharma 1 palier = 0 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-01-15 14:39:51', '3690036147', 'produit', 'romain.valette@roche.com', 0, 70, 40, '2026-03-16*2026-06-08*2026-09-14*2026-11-09', 'HCUE03QjkeWRoEDyCjyuY8LD5A0LVUZLQHT8EVFVZUOKX1xOJ0uMXUneKE0E2q1j', 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-15 14:29:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-15 14:29:55', '3690036147', 'utilisateur', 'romain.valette@roche.com', '6FxvYGTfdCReVzjaDQ1Rj7PkAtsOUKDWgOJB6ND9a91DRjhzNwhBJFKbsE7JJu92', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 16:56:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 16:39:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 15:33:18 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-14 15:33: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 ('3690026305', 'romain.valette@roche.com', '2026-01-14 15:33:16', 90171, 4064.12, 0, 103, 24, -1, 103, -1, 88, -1, 2, -1, 30, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-14 15:33:16] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 127 - 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-01-14 15:33:16', '3690026305', 'produit', 'romain.valette@roche.com', 0, 103, 24, '2026-03-02*2026-06-08*2026-09-07', 'wLloNEhZIMAhPP1IhyFIN2Ss9FiM4xvzITLGKkDk78v1FS4hgiFowIo7YABDPqmF', 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-14 15:25:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-14 15:25:55', '3690026305', 'utilisateur', 'romain.valette@roche.com', 'qFQ96RcM1ZzVjCI9OUW0px2C6x2XFgOocnVCJhwdPZGa3YmjDKaXZejl63EPGsZO', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-14 11:04:47 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 11:04:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-14 09:43:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 15:05:34 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 15:05:32] [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 ('3690016484', 'romain.valette@roche.com', '2026-01-13 15:05:32', 90127, 5139.52, 3, 80, 48, -1, 83, -1, 80, -1, 2, -1, 20, -1, -1, 100, 24, 12, -1, -1, 0) ----------------------------------------------------- -- [2026-01-13 15:05:32] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 131 - 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-01-13 15:05:32', '3690016484', 'produit', 'romain.valette@roche.com', 3, 80, 48, '2026-01-19*2026-04-14*2026-07-10*2026-10-05', '0axMdFGXhRdYeikF1Xsbpgu6YUgwhkY6sHqK6CfZCFpDJ2ohpUWXUwU8cAD95W1c', 136, 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-13 15:01:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-13 15:01:07', '3690016484', 'utilisateur', 'romain.valette@roche.com', 'fvqDMMjXJB535Ag7ZyvJt8o3OCCdFyVie4GuuInljGzERlHFZljTTb8HPN78AuyR', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 11:33:23 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-13 11:33:21] [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 ('3690026761', 'romain.valette@roche.com', '2026-01-13 11:33:21', 90121, 3296.43, 0, 80, 20, -1, 80, -1, 40, -1, 2, -1, 16, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-13 11:33:21] [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-13 11:33:21', '3690026761', 'produit', 'romain.valette@roche.com', 0, 80, 20, '2026-01-19*2026-04-17*2026-07-17*2026-10-19', 'o9HNCXKEeOtWRnerqUAhumPEu9JjHLfiL2xuwqT1F2pGfjb5RqLyNoQJd2yeO0wC', 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-13 10:00:42 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 10:00:39 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 08:57:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-13 08:50:05 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-13 08:50:05', '3690026307', 'utilisateur', 'romain.valette@roche.com', 'vMMTmIWOeBPsqK7rksDad9TND9mMXa8Q6RlHxR7gGDZK5DJZdp7lY0hbqdQ9xARa', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-13 08:47:54 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-01-13 08:47:54', '3690026307', 'utilisateur', 'romain.valette@roche.com', 'Zpe0Yv9ypCYJANamYW0JOtJI7Wy5NYv5Kfs5kO0kyP658jdHIkQ6X49GfLQA9qHb', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-01-12 15:48:04 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-12 15: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 ('3690022654', 'romain.valette@roche.com', '2026-01-12 15:48:01', 90090, 5037.43, 10, 90, 10, -1, 100, -1, 60, -1, 2, -1, 16, -1, -1, 110, 35, 10, -1, -1, 0) ----------------------------------------------------- -- [2026-01-12 15:48:01] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 110 - 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-12 15:48:01', '3690022654', 'produit', 'romain.valette@roche.com', 10, 90, 10, '2026-01-23*2026-04-16*2026-07-16*2026-10-16', 'nNNDAkYyqGMXu8Ndb7aJ5RqUAw4MqQ0kIntKBPqmHhDWXvG6EfllnCwHTPvUXruN', 155, 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-09 15:48:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-09 15:48:04] [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 ('3690034999', 'romain.valette@roche.com', '2026-01-09 15:48:04', 90061, 2535.73, 10, 60, 10, -1, 70, -1, 20, -1, 2, -1, 7, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-09 15:48:04] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, isCadence) VALUES ( '2026-01-09 15:48:04', '3690034999', 'produit', 'romain.valette@roche.com', 10, 60, 10, '2026-01-13*2026-04-14*2026-07-13*2026-10-13', 'Q3CbeFXUZ2gscCGFpuRVIgaUEorIECjyYRArsVZ4HNshUxOGkPMZdgbJR4rN5BoQ', 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-08 15:00:57 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-01-08 14:38:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 14:37:57] [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 ('3690030796', 'romain.valette@roche.com', '2026-01-08 14:37:57', 90020, 10743.56, 10, 240, 70, -1, 250, -1, 220, -1, 3, -1, 47, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 14:37:57] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 320 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 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-08 14:37:57', '3690030796', 'produit', 'romain.valette@roche.com', 10, 240, 70, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', 'lUyEwkeHWdINXyx81kbpTqc6jwKidjz5AFtTmYkKpnCn1JEhpxUAuFX96VwS1YMA', 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-08 14:29:36 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 14:29:33] [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 ('3690030796', 'romain.valette@roche.com', '2026-01-08 14:29:33', 90020, 10743.56, 10, 240, 70, -1, 250, -1, 220, -1, 3, -1, 47, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 14:29:33] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 320 - palier : 2 - palierData : getPalierDataByPharma 1 palier = 2 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-08 14:29:33', '3690030796', 'produit', 'romain.valette@roche.com', 10, 240, 70, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', 'W2KomR0OFnU6XnqAM5ULqECTpBqpA5yh2RnyUueV6262cjWrPXnlWbr9W2VFkpPF', 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-08 12:38:22 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 12:38:19] [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 ('3690036656', 'romain.valette@roche.com', '2026-01-08 12:38:19', 90016, 3082.03, 0, 40, 50, -1, 40, -1, 50, -1, 2, -1, 16, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 12:38:19] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 90 - 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-08 12:38:19', '3690036656', 'produit', 'romain.valette@roche.com', 0, 40, 50, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', 'xEFtRDMc3QGOBxDgLrb3H2cwbc9xyyFXoo5CpyCKZDIiX10a2BT2LFqnizV2XHG1', 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-08 11:25:44 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-01-08 11:25:41] [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 ('3690021905', 'romain.valette@roche.com', '2026-01-08 11:25:41', 90010, 5244.02, 0, 110, 40, -1, 110, -1, 85, -1, 5, -1, 25, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-01-08 11:25:41] [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:25:41', '3690021905', 'produit', 'romain.valette@roche.com', 0, 110, 40, '2026-01-12*2026-04-14*2026-07-13*2026-10-12', 'WSsHMFUR05x5YMMzeQEWDEhv8so3U27Q4s2zSj6H3hHGe6AFpGppIMopjJAdTIdC', 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-05 10:39:02 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-01-05 10:39:02 ########## --------- 2026-01-05 10:39:02 --------- - [getLogfile] suffixe = toolbox delegueEmail = romain.valette@roche.com ##################################################