LDAP -&gt; Directory Tree

LDAP -> Directory Tree

stolzyboy

Here is a little background. Where I work, people "report" to their supervisors, team leaders, managers, etc...

We run an LDAP server that has an attributed "reporto" that tells us who reports to who.

I need to create a "tree" like the diagram attached, it's basically going to end up like a Folder directory structure, it'll create an XML file and it'll use JavaScript to create the tree from the XML file, but I need to output the XML file first.

I'm at an impass on how to get it to recursively run through and create the file. I've tried numerous routes, the latest was creating a user-defined array of the ldap_search array results, but alas, it's not working.

I need to start at the top and find who reports to the Pres, then those that report to the pres, find who reports to them and so on down the line.

Negate the need to connect/bind/search LDAP, I have that figured out, unless something different needs to happen with the search to get the results better.

stolzyboy

No LDAP folks here apparently, lol...

NogDog

Not me, anyway. Without any idea what the original data looks like when you retrieve it, I have no specific ideas on how to manipulate it for your needs (other than I feel the need...the need for recursion!).

stolzyboy

there is no specific directory structure at all via LDAP, it is one level, with merely the employees and their reportsto as results from LDAP

ldap_search basically returns an array... and the following is a record of the array based on one person, each person has this

Array
(
[count] => 4
[0] => Array
(
attribute_1=> Array
(
[count] => 1
[0] => fullname
)
[0] => attribute_1

        attribute_2=> Array
            (
                [count] => 1
                [0] => XXXXX        <-supervisors/reports-to number
            )
        [1] => attribute_2

        attribute_3=> Array
            (
                [count] => 1
                [0] => XXXXX         <-employee number
            )
        [2] => attribute_3
    )

)

NogDog

Maybe something like this script at SourceForge is what you need?

stolzyboy

i was going to look at that today, but didn't think it'd be specific enough for my needs... i've been messing with this for a couple days... maybe i'll give it a whirl on monday and see what code i can steal from theirs... i can't get any access to work from outside the network or i'd try now

thanks nog

stolzyboy

nogdod,

here is how the array comes out, there is merely test data in there now, but that is how it comes from LDAP and below is how i'm currently doing it. it works, sort of, but with two thousand plus values, it doesn't run fully, it times out, even after 5 minutes...

can you think of a better way to loop through this, if you run it as it is right now, you'll see the desired results

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
	<title>Untitled</title>
</head>

<body>
<pre>
<?

$arrall = array(array(array("president"),array(1111),array(1111)),array(array("vicepresident"),array(1111),array(2222)),array(array("Manager1"),array(2222),array(3333)),array(array("Manager2"),array(2222),array(4444)),array(array("Supervisor1"),array(3333),array(5555)),array(array("Supervisor2"),array(4444),array(6666)),array(array("Supervisor3"),array(4444),array(7777)),array(array("Supervisor4"),array(4444),array(8888)),array(array("Employee1"),array(5555),array(1212)),array(array("Employee2"),array(7777),array(2323)),array(array("Employee3"),array(6666),array(3434)),array(array("Employee4"),array(6666),array(4545)));


function crawlArray($lastrep) {
	global $arrlisted;
	global $arrall;
	global $treepush;
	$reportsto = $lastrep;
	for($z=0;$z<count($arrall);$z++) {
		if ($arrall[$z][1][0] == $reportsto) {
			echo $treepush . "|_" . $arrall[$z][0][0] . "-" . $reportsto . "-" . $arrall[$z][2][0] . "<br>";
			$lastreport = $reportsto;
			$lasttree = $treepush;
			$reportsto = $arrall[$z][2][0];
			$treepush .= "&nbsp;&nbsp;";
			unset($arrall[$z][1][0]);
			crawlArray($reportsto);
			$reportsto = $lastreport;
			$treepush = $lasttree;
		}
	}
}


for($i=0;$i<count($arrall);$i++) {
	if ($arrall[$i][1][0] == $arrall[$i][2][0]) {
		$toptitle = $arrall[$i][0][0];
		$topreports = $arrall[$i][1][0];
		$topnumber = $arrall[$i][2][0];
	}
}

$treepush = "";
$reportsto = $topnumber;
$arrlisted = array();
crawlArray($reportsto);
?>
</pre>

</body>
</html>

stolzyboy

nevermind, for whatever reason, i had to change this:

for($z=0;$z<count($arrall);$z++)

to this:

$realcount = count($arrall);
for($z=0;$z<$realcount;$z++)

this way it works flawlessly... must have something to do with it not REALLY counting the new array on the recursive function call

NogDog

Glad you got it working. I took a look yesterday, and started to get a headache: it's just similar enough to something I've been struggling with the last few days -- and yet different -- that I just couldn't make myself concentrate on it. 🙂

udendra

maybe this could help:

http://phpldapadmin.sourceforge.net/

stolzyboy

NogDog wrote:
Glad you got it working. I took a look yesterday, and started to get a headache: it's just similar enough to something I've been struggling with the last few days -- and yet different -- that I just couldn't make myself concentrate on it. 🙂

it's working... but... yes, there's a but... I'm trying to now get it work with xloadtree so it's a folder-like drilldown. I got it working like:

pres
|vp
__|manager

and so on... but the way xloadtree works is with xml and obviously xml has closing tags... struggling with how to have it close the tags :/