-------------------------------------------- --------- 2026-06-11 17:05:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-11 14:00:48 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-11 14:00:48 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690011890 -------------------------------------------- --------- 2026-06-11 12:51:37 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-11 12:51:36] [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 ('3690012140', 'raouf.chargui@roche.com', '2026-06-11 12:51:36', 106156, 5695.9, 0, 80, 60, -1, 80, -1, 160, -1, 10, -1, 60, -1, -1, 48, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-11 12:51:36] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-11 12:51:36', '3690012140', 'produit', 'raouf.chargui@roche.com', 0, 80, 60, '2026-06-15*2026-08-21*2026-10-27', '', 48, 'PGRPTS', 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-06-11 11:57:07 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-11 11:57:06 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690012140 ----------------------------------------------------- -- [2026-06-11 11:57:06] [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 ('3690012140', 'raouf.chargui@roche.com', '2026-06-11 11:57:06', 106156, 5695.9, 0, 80, 60, -1, 80, -1, 160, -1, 10, -1, 60, -1, -1, 48, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-11 11:57:06] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-11 11:57:06', '3690012140', 'produit', 'raouf.chargui@roche.com', 0, 80, 60, '2026-06-15*2026-08-21*2026-10-27', '', 48, 'PGRPTS', 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-06-10 17:34:21 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-10 14:41:10 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-10 14:41:09] [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 ('3690030019', 'raouf.chargui@roche.com', '2026-06-10 14:41:09', 106123, 11486.95, 0, 250, 80, -1, 250, -1, 260, -1, 6, -1, 44, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-10 14:41:09] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-10 14:41:09', '3690030019', 'produit', 'raouf.chargui@roche.com', 0, 250, 80, '2026-06-15*2026-09-14*2026-12-14*2027-03-15', '', 0, 'ARGENT-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) -------------------------------------------- --------- 2026-06-10 11:41:49 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- -- [2026-06-10 11:41:48] [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 ('3690023424', 'raouf.chargui@roche.com', '2026-06-10 11:41:48', 106117, 17881.77, 0, 420, 120, -1, 420, -1, 400, -1, 20, -1, 70, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-10 11:41:48] [insertContrat] -- ----------------------------------------------------- EVER sent to webhelp... query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, nbBandelette, nbBandeletteGuide, nbCassettes, datesLivraison, docuSignToken, nbAccuFine, palier, isCadence) VALUES ( '2026-06-10 11:41:48', '3690023424', 'produit', 'raouf.chargui@roche.com', 0, 420, 120, '2026-07-01*2026-09-14*2026-12-14*2027-03-15', '', 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) -------------------------------------------- --------- 2026-06-09 13:13:17 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-09 12:09:12 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-09 12:09:10 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690030907 ----------------------------------------------------- -- [2026-06-09 12:09: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 ('3690030907', 'raouf.chargui@roche.com', '2026-06-09 12:09:10', 106080, 2717.32, 10, 48, 20, -1, 58, -1, 80, -1, 0, -1, 15, -1, -1, 0, 0, 0, -1, -1, 0) ----------------------------------------------------- -- [2026-06-09 12:09:10] [insertContrat] -- ----------------------------------------------------- Will send to webhelp... - nbTest : 78 - 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, palier, isCadence) VALUES ( '2026-06-09 12:09:10', '3690030907', 'produit', 'raouf.chargui@roche.com', 10, 48, 20, '2026-06-15*2026-09-01*2026-10-27', '', 0, 'PGRPTS', 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-06-09 11:50:55 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ----------------------------------------------------- query = INSERT INTO Contrats (dateSignature, idPharma, typeContrat, emailIcpo, docuSignToken, isAcGuideGroupement) VALUES ( '2026-06-09 11:50:53', '3690030907', 'utilisateur', 'raouf.chargui@roche.com', '', 1)ON DUPLICATE KEY UPDATE dateSignature = VALUES(dateSignature), emailIcpo = VALUES(emailIcpo), docuSignToken = VALUES(docuSignToken) -------------------------------------------- --------- 2026-06-08 11:18:03 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 11:16:59 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-08 11:16:57 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-08 11:16:57', 'raouf.chargui@roche.com', '3690015287', 'Animation Diabete & ete', '2026-06-08', '-', '0', 1, '10309539001', '', 1, 52412, 1) -------------------------------------------- --------- 2026-06-08 11:16:57 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-08 11:16:57', 'raouf.chargui@roche.com', '3690015287', '') -------------------------------------------- --------- 2026-06-08 11:12:52 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-08 11:12:51 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690015287 -------------------------------------------- --------- 2026-06-05 16:10:15 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 16:10:13 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690025197', 'raouf.chargui@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=pharmacieducentre93400@gmail.com&idPharma=3690025197', '', '2026-06-05 16:10:13') -------------------------------------------- --------- 2026-06-05 16:05:33 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 16:05:30 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-05 16:05:30', 'raouf.chargui@roche.com', '3690013330', 'Animation Diabete & ete', '2026-06-05', '-', '0', 1, '10309539001', '', 1, 52407, 1) -------------------------------------------- --------- 2026-06-05 16:05:30 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-05 16:05:30', 'raouf.chargui@roche.com', '3690013330', '') -------------------------------------------- --------- 2026-06-05 16:03:00 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 16:02:57 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-05 16:02:57', 'raouf.chargui@roche.com', '3690023424', 'Animation Diabete & ete', '2026-06-05', '-', '0', 1, '10309539001', '', 0, 52406, 1) -------------------------------------------- --------- 2026-06-05 16:02:57 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-05 16:02:57', 'raouf.chargui@roche.com', '3690023424', '') -------------------------------------------- --------- 2026-06-05 11:42:25 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 11:42:22 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-05 11:42:22', 'raouf.chargui@roche.com', '3690016600', 'Animation Diabete & ete', '2026-06-05', '-', '0', 1, '10309539001', '', 1, 52403, 1) -------------------------------------------- --------- 2026-06-05 11:42:22 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-05 11:42:22', 'raouf.chargui@roche.com', '3690016600', '') -------------------------------------------- --------- 2026-06-05 10:47:16 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 10:47:13 --------- --------- insertServiceInDb -------------------- query = INSERT INTO Services (dateInsert, emailIcpo, idPharma, nom, dateLivraison, creneau, palier, nbPatientsBascules, ref, infoContact, isGpt, idBdc, selected) VALUES ( '2026-06-05 10:47:13', 'raouf.chargui@roche.com', '3690026322', 'Animation Diabete & ete', '2026-06-05', '-', '0', 1, '10309539001', '', 1, 52401, 1) -------------------------------------------- --------- 2026-06-05 10:47:13 --------- --------- insertBdcService -------------------- query = INSERT INTO ServicesBdc (dateInsert, emailIcpo, idPharma, docuSignToken) VALUES ('2026-06-05 10:47:13', 'raouf.chargui@roche.com', '3690026322', '') -------------------------------------------- --------- 2026-06-05 10:22:11 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 10:22:09 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690026322', 'raouf.chargui@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=rafik.chabani@outlook.fr&idPharma=3690026322', '', '2026-06-05 10:22:09') -------------------------------------------- --------- 2026-06-05 10:19:31 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-05 10:19:29 --------- --------- insertOffre -------------------- query = INSERT INTO Offre (idPharma, emailIcpo, typeOffre, extras, qteByRef, dateInsert) VALUES ( '3690026322', 'raouf.chargui@roche.com', 'offreAccuFine', 'typeOffreSelected=2&emailPharma=rafik.chabani@outlook.fr&idPharma=3690026322', '', '2026-06-05 10:19:29') -------------------------------------------- --------- 2026-06-04 17:32:35 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ------------------------------------------------------------------------- --------- 2026-06-04 17:32:35 ---------------------------------------- --------- setContratUtilisateurHasAcGuideValueCommande -------------------- query = UPDATE Contrats SET isAcGuideGroupement = '2' WHERE idPharma = 3690026476 -------------------------------------------- --------- 2026-06-04 09:44:41 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php -------------------------------------------- --------- 2026-06-03 18:43:06 --------- --------- callCurl -------------------- - url = http://www.pharmavisite.com/webservices/_prod530_com/webservice.php ####### Creation - 2026-06-03 18:43:06 ########## --------- 2026-06-03 18:43:06 --------- - [getLogfile] suffixe = toolbox delegueEmail = raouf.chargui@roche.com ##################################################