Hierarchy loop mysql php

De openkb
Aller à : Navigation, rechercher

Sommaire

Questions

i want to display all users which are below my status.

the lead_id shows my id if i m the manager. all users when registering will have to put the person in charge id(lead-id) but in my case, i m getting only users with my id.

e.g

id name leadid

1 xxx 0

2 aa 1

3 sdd 1

4 fdfs 2

5 fdss s 2

6 fdgd 3

7 erte 4

8 ewr 4

9 fsdrt 4

10 ytr 5

id 1 can view all users

id 2 can view user 4 5 7 8 9 10

id 3 can view 6

id 4 can view 7 8 9

i wish to display all users for each a manager is associated.. for e.g an hr manager needs to gets all his staff regarding hr, but i cant process it

i ve 3 table with 1 user providing user info and 1 for dept_user and 1 for department. the dept_user table consists of user_id, dept_id, lead_id and role. when a user register, he needs to put lead_id which is for the user in charge of the person registering and the role specifies either staff manager or team leader.. A manager can view all the the teamleaders and the users associated with the teamleader.

manager for role 3 and team leader for role2

//get userid from login session

  $memberid = $_SESSION[ SESS_MEMBER_ID ];

//get role from session
$role = $_SESSION[ SESS_ROLE_ID ] 

    while($res = mysql_fetch_array($role)){
 if($role== 3 ){



 $teamleader = mysql_query("select userid from dept_user where lead_id= $member_id ");

         while ($data = mysql_fetch_assoc($teamleader)) {
         $user = mysql_query("select firstname, lastname, email from user where userid in(select userid from dept_user where lead_id=$data)");
            $result = mysql_query($user);
            print $result;
                }
    }
    else if ($role== 2 ){
    $user = mysql_query("select firstname, lastname, email from user where userid in(select userid from dept_user where lead_id= $member_id ");
    print $user;
    }
}

Answers

Source

License : cc by-sa 3.0

http://stackoverflow.com/questions/4050000/hierarchy-loop-mysql-php

Related

Outils personnels
Espaces de noms

Variantes
Actions
Navigation
Outils