Hi,
I want to generate an organization chart for a college.
The order of hierarchy are,
Principal Name
HOD (Head of the Departments) OR Divisions. Depends on the number of departments
Sections (Section Heads)
Lecturers/other staffs. //some staffs belong to whole departments like sweepers. They are shown separately. They are filtered out by using desig_id.
staff_table fields:- staff_id, org_id, fname, lname, desig_id
org_table fields:- org_id, div_id, sec_id
div_table fields:- div_id, div_name
sec_table fields:- sec_id, sec_name
desig_table fields:- desig_id, desig_name
Whenever a new divisions/sections are added they should be shown (sections should be shows under which divisions it belongs to).
I need a single array in which all required values (principal_name, division_names and their heads, section_names and their heads and lecturer_names) are available, so that i can loop it and generate html table or divs and display appropriate values.
For the last 4 days i am looking for a solution. Any kind of solution will be very helpful
Thanks
Displaying chart
Moderator: General Moderators