All pastes #605772 Raw Edit

ced

public text v1 · immutable
·published 2007-07-06 12:45 UTC
rendered paste body
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);





<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>