1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
$requete = ' SELECT
WRKPCSDTA1_OMA_HISCOM.PERIODE,
WRKPCSDTA1_OMA_HISCOM.BCCDZA AS Code_Groupe,
WRKPCSDTA1_OMA_HISCOM.BCAN8X AS Compte_Client,
WRKPCSDTA1_OMA_HISCOM.BCB3CD AS N°_Liasse,
WRKPCSDTA1_OMA_HISCOM.BCB4CD AS Liasse_Rattachée,
WRKPCSDTA1_OMA_HISCOM.BCCRTX AS Signataire,
WRKPCSDTA1_OMA_HISCOM.BCCPNB AS Nb_Terminaux,
WRKPCSDTA1_OMA_HISCOM.BCCONB AS Nb_Lignes,
WRKPCSDTA1_OMA_HISCOM.BCCQNB AS Nb_Accessoires,
WRKPCSDTA1_OMA_HISCOM.BCEBNB AS Nb_Cartes_SIM,
WRKPCSDTA1_OMA_HISCOM.BCCQTX AS Référence_Commandes,
WRKPCSDTA1_OMA_HISCOM.BCB1CD AS Type_Commandes ,
TABLE_PROFIL.Profil_Dise,
Tb_statut_cdes.Code_statut
FROM (WRKPCSDTA1_OMA_HISCOM INNER JOIN Tb_statut_cdes ON WRKPCSDTA1_OMA_HISCOM.BHCNST = Tb_statut_cdes.Code_statut)
INNER JOIN TABLE_PROFIL ON WRKPCSDTA1_OMA_HISCOM.BHCKZJ = TABLE_PROFIL.Profil_DISE
WHERE WRKPCSDTA1_OMA_HISCOM.BCCDZA IN("' . implode('", "', $_POST['code_groupe']) . '")
GROUP BY WRKPCSDTA1_OMA_HISCOM.PERIODE, WRKPCSDTA1_OMA_HISCOM.BCCDZA, WRKPCSDTA1_OMA_HISCOM.BCAN8X,
WRKPCSDTA1_OMA_HISCOM.BCB3CD, WRKPCSDTA1_OMA_HISCOM.BCB4CD, WRKPCSDTA1_OMA_HISCOM.BCCRTX,
WRKPCSDTA1_OMA_HISCOM.BCCPNB, WRKPCSDTA1_OMA_HISCOM.BCCONB, WRKPCSDTA1_OMA_HISCOM.BCCQNB,
WRKPCSDTA1_OMA_HISCOM.BCEBNB, WRKPCSDTA1_OMA_HISCOM.BCCQTX, WRKPCSDTA1_OMA_HISCOM.BCB1CD,TABLE_PROFIL.Profil_Dise,Tb_statut_cdes.Code_statut |
Partager