1-SI UN APPEL D'UN AJAX N'AFFICHE RIEN DANS L'ONGLET PREVIOUS OU RESPONSE EN PROD ALORS QUE OK EN DEV-->problème d'accent dans les lignes de réponses

SELECT LOG.USER_ROWID, USER_DESCR, time(DATE_TIME) as Heure, date(DATE_TIME) as Date_jour, day_name, month_name, USER_CLT_ID
FROM MYSQL_T_USERS_LOG LOG
INNER JOIN MYSQL_T_USERS USER ON (LOG.USER_ROWID = USER.USER_ROWID)
INNER JOIN MYSQL_T_CALENDAR ON ( date(DATE_TIME)=db_date)
WHERE  USER_PROFIL_ID=5  
ORDER BY DATE_TIME DESC



SELECT date(DATE_TIME) as date_jour, USER_CLT_ID, USER_DESCR,   month_name, day_name, count(DATE_TIME) as NB_CON
FROM MYSQL_T_USERS_LOG LOG
INNER JOIN MYSQL_T_USERS USER ON (LOG.USER_ROWID = USER.USER_ROWID)
INNER JOIN MYSQL_T_CALENDAR ON ( date(DATE_TIME)=db_date)
GROUP BY date(DATE_TIME), USER_CLT_ID, USER_DESCR, month_name, day_name 
ORDER BY date(DATE_TIME) DESC,count(DATE_TIME) DESC




SELECT month_name, USER_CLT_ID, USER_DESCR, count(DATE_TIME) as NB_CON
FROM MYSQL_T_USERS_LOG LOG
INNER JOIN MYSQL_T_USERS USER ON (LOG.USER_ROWID = USER.USER_ROWID)
INNER JOIN MYSQL_T_CALENDAR ON ( date(DATE_TIME)=db_date)
GROUP BY month, USER_CLT_ID, USER_DESCR
ORDER BY month DESC, count(DATE_TIME) DESC


SELECT `TRN_ID`,`TRN_DESC`, B.`CGTR_ID`,B.`CGTR_LBC` ,`TRN_MT` FROM `MYSQL_T_TRANSAC_TVA` A 
LEFT OUTER JOIN MYSQL_T_CATEGO_TRANSAC B ON (A.CGTR_ID = B.CGTR_ID) 
WHERE A.`CLT_ID`=1 AND `EXER_ID`=12016 AND TRN_DESC like '%RETRAIT%' 


SELECT `TRN_ID`,`TRN_DESC`, `CGTR_ID` ,`TRN_MT` ,TRN_CLT_OK_FLG
FROM `MYSQL_T_TRANSAC_TVA` 

WHERE `CLT_ID`=1 AND `EXER_ID`=12016 AND TRN_DESC like '%JAZZPRO REDUC JAZZ%' AND TRN_CLT_OK_FLG=0
WHERE `CLT_ID`=1 AND `EXER_ID`=12016 AND TRN_DESC like '%COTIS JAZZPRO REDUC JAZZ%' AND TRN_CLT_OK_FLG=1

UPDATE `MYSQL_T_TRANSAC_TVA` 
SET TRN_CLT_OK_FLG=1
WHERE `CLT_ID`=1 AND `EXER_ID`=12016 AND TRN_DESC like '%ONLINE COMMERCE%' AND TRN_CLT_OK_FLG=0



UPDATE `MYSQL_T_TRANSAC_TVA` 
SET TRN_CLT_OK_FLG=1 AND CGTR_ID=16
WHERE `CLT_ID`=1 AND `EXER_ID`=12016 AND TRN_DESC like '%JAZZPRO REDUC%' AND TRN_CLT_OK_FLG=0