if(isset($_GET['table'])) { $Table = $_GET['table']; $tpl->assign ('Table', $Table); $QuerySelectStructureList = $Connexion->doQuery ("SELECT ID, StructureName FROM structurelist WHERE TableType = '$Table'"); $StackStructureList = array(); $StackstructureElements = array(); while($RowsStructureList = $QuerySelectStructureList->fetch()) { //Affichage de l'arborescence des structure elements dans les picklist : (elem > elem > elem...) //sélection des elements racine $IDstructurelist = $RowsStructureList->ID; $tpl->assign ('IDstructurelist', $IDstructurelist); $QuerySelectStructureElements = $Connexion->doQuery ("SELECT structureelement.ID, structureelement.Name,structureelement.HasChildFlag FROM structureelement,structurelist WHERE structureelement.StructureListID = structurelist.ID and structurelist.ID = $IDstructurelist and structureelement.ID NOT IN (SELECT RightID FROM zstructureelementstructureelement WHERE LinkTypeID = 1)"); while($Father = $QuerySelectStructureElements->fetch()) { //on pousse les données récupérées dans une pile $StackstructureElements[] = $Father->Name; } array_push($StackStructureList,array($RowsStructureList->ID, $RowsStructureList->StructureName)); } $tpl->assign ('TabStructureElements', $StackstructureElements); $tpl->assign ('TabStructureList', $StackStructureList);
| Structure List | Structure Elements | {foreach from=$TabStructureList item=ObjStructureList}
|---|---|
| {$ObjStructureList[1]} |
|