1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
$rq_abonne_option=odbc_do($conn,"SELECALL T02.E7B8ZC,T01.CXAN8X,T01.CXHZZE,T01.CXB9ZC,T03.NUGUFX,T03.NUGVFX,T02.E7BUZA,
T04.DYEVZE,T03.NUDWF7,T03.NUG3FX,T03.NUG4FX,T03.NUDXF7,T01.CXB6ZA,T01.CXA3ZB,T01.CXARZF,T01.CXCEZA,T02.E7BUZA
FROM DISACTDTA1.COE7REP T02,DISACTDTA1.COCXREP T01,
SATACTDTA1.FINURED T03,DISACTDTA1.CODYREP T04,
SATACTDTA1.FAFLRED T05,DISACTDTA1.COC1REP T06
WHERE E7B8ZC = CXB8ZC
AND NUB8ZC = CXB8ZC
AND DYBUZA = E7BUZA
AND NUGVFX = FLAAFJ
AND E7CIZA = DYCIZA
AND T01.CXCEZA = T06.C1CEZA
AND T02.E7B3ZB between '$var1' and '$var2'
AND T01.CXCDZA IN('" . implode("','", $_SESSION['code_groupe']) . "')
AND T02.E7B8ZC IN('" . implode("','", $abonnes) . "')
AND T02.E7BUZA IN('" . implode("','", $_POST['check']) . "')
AND CXA3ZB <> 0
AND CXA6ZB = 0
group by E7B8ZC,E7BUZA,CXHZZE,CXB9ZC,NUGUFX,NUGVFX,DYEVZE,CXAN8X,NUDWF7,NUG3FX,
NUG4FX,NUDXF7,CXB6ZA,CXA3ZB,CXARZF,CXCEZA,E7BUZA
"); |
Partager