I have the table user which has user_name and manager name.I want to get the user name for who have manager ='test'.I want to get the user who are having ramya as manager and reportee's reportee's related project and customer
users table SNO user_name manager 1 vani Ramya 2 ramya geetha 3 priya ramya 4 mani ramya 5 latha vani 6. hema Anitha
I have the table user which has user_name and manager name.I want to get the user name for who have manager ='test'.I want to get the user who are having ramya as manager and reportee's reportee
users table
SNO user_name manager
1 vani Ramya
2 ramya geetha
3 priya ramya
4 mani ramya
5 latha vani
6. hema Anitha
I want to get the name ramya and ramya's reportee vani,priya and mani and get latha who is having vani as manager who is having ramya as manager. I want to get ramya,vani,priya,mani and latha and fetch the project related to ramya,vani,priya,mani and latha from project table who are the project owner
project table
project_id name customer_code owner
1 x C1 ramya
2 xx c2 vani
3 x1 c2 priya
4 x2 c3 geetha
5 x3 c4 mani
6 x4 c5 latha
I want to get x,xx,x1,x3,x4 from project table.I have fetched hierarchy as
select a.user_name from
users a left join users b
on a.manager=b.user_name
where a.user_name='Ramya' or a.manager='ramya' or b.manager='Ramya'
how to join project table in laravel 5.3
from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2Jl4Z9N
via IFTTT
Aucun commentaire:
Enregistrer un commentaire