[Corrigé] Affichage ligne de code sur l'écran GESTSUP
Posté : lun. 16 nov. 2015 12:26
Tout d'abord bravo pour le développement de GESTSUP qui fonctionne globalement très bien et est très intuitif d'utilisation.
J'ai depuis peu un petit souci: pour tous les utilisateurs, nous avons les lignes de code qui suivent, qui s'affichent en haut de l'écran.
SELECT DISTINCT tincidents.*
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '12' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '4' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'
ORDER BY id DESC
LIMIT 0, 14
SELECT COUNT(DISTINCT tincidents.id)
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '12' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '4' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'
Merci de regarder le problème.
Cordialement
J'ai depuis peu un petit souci: pour tous les utilisateurs, nous avons les lignes de code qui suivent, qui s'affichent en haut de l'écran.
SELECT DISTINCT tincidents.*
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '12' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '4' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'
ORDER BY id DESC
LIMIT 0, 14
SELECT COUNT(DISTINCT tincidents.id)
FROM tincidents, tstates WHERE tincidents.state=tstates.id AND tincidents.user LIKE '%' AND tincidents.u_group LIKE '%' AND tincidents.technician LIKE '12' AND tincidents.t_group LIKE '%' AND tincidents.techread LIKE '%' AND tincidents.disable='0' AND (tincidents.category LIKE '%') AND tincidents.subcat LIKE '%' AND tincidents.id LIKE '%' AND tincidents.user LIKE '%' AND tincidents.date_create LIKE '%%' AND tincidents.state LIKE '4' AND tincidents.priority LIKE '%' AND tincidents.criticality LIKE '%' AND tincidents.title LIKE '%%%'
Merci de regarder le problème.
Cordialement