rendered paste bodyif(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);
<TABLE>
<TH ROWSPAN="1">Structure List<TH ROWSPAN="1">Structure Elements</TH>
{foreach from=$TabStructureList item=ObjStructureList}
<TR class="tr">
<TD class="td">
{$ObjStructureList[1]}
</TD>
<TD class="td">
<table>
<tr>
<select name="SelectElement{$ObjStructureList[0]}">
{foreach from=$TabStructureElements item=ObjStructureElements}
<option>{$ObjStructureElements[0]}</option>
{/foreach} </select>
</tr>
</table>
</TD>
</TR>
{/foreach}
</TABLE>