1 2 3 4 5 6 7 8
|
var requeteOption = recupDataOption(); //ce qu'il y a en haut
var requeteBase = "SELECT N_TFONC as FONCTION, C_SOCIGRAD as CATEGORIE, N_TGRAD as GRADE, N_TTEMPS as STATUT, N_TSEXE as SEXE, N_TSERV4 as POLE, N_TTHEM as DOMAINE, RH_HISTPERS.N_BORGA as ORGANISME, sum(J_REAL) as NBJours FROM RH_HISTPERS WHERE DATDEBSTAG >'$DEBUTSTAG' AND DATFINSTAG < '$FINSTAG' AND C_TTYPE <> '10004' AND C_TSERV4 ";
//var choixCollectivite = "='" + collectivite +"'";//VILLE ou CAPA
var choixCollectivite2 = "IN('HB1CAB1','HB2CAB3','HB2CAB4','HB2CAB1','HB2CAB6','HE2ASS4','HE2ASS6','HE2ASS2','HE2ASS3','HJ2INF2','HP2POP6','HH1DIR1')"; //code pouvant varier en fonction d'un autre select
var requete = requeteBase + choixCollectivite2+ requeteOption + " GROUP BY N_TFONC"; |
Partager