Hi iwan...
first of all, you should define the diagram level. in your case, you have :
1. President
2. DirMKT
2.1 MGR MKT
3. DirProd
3.1 MGR PROD
3.2 MGR TEC
well, that diagram a little 'not good' because you want make 'President' on
top of all department right ? :). so the diagram level should be :
1. President
1.1 DirMKT
1.1.1 MGR MKT
1.2 DirProd
1.2.1 MGR PROD
1.2.2 MGR TEC
next:
this is a diagram, so you'll need to 'draw' it. the less effort is make some
table, but it will give you a headache in the end ( you want make it dynamic,
right ? :) ).
i suggest you use gd2 library to 'draw' it. you can make a class ( in php5 ) to
create the diagram (according to your diagram level) on the fly. it just the
'tree' matter to coding it :).
i hope it will help you.
regards
-Marga-
----- Original Message -----
From: Iwan.Setiawan
To: [email protected]
Sent: Thursday, October 18, 2007 3:08 PM
Subject: [php_mysql] Organization Diagram / Chart
Hi All...
I would like to askh you all , about how to create Dynamic
organization Diagram with PHP+MYSQL
Sample table:
Dept ID
President 1
DirMKT 2
DirProd 3
MGR MKT 21
MGR PROD 31
MGR TEC 32
contoh struktur organisasi
|-----------|
| President |
|-----|-----|
|
|--------------|-----------------|
| |
|------|------| |------|-------|
| DirMKT | | DirProd |
|------|------| |------|-------|
| |
| |--------------------|------|
| | |
|------|------| |------|-------| |------|-------|
| MGR MKT | | MGR TEC | | MGR PROD |
|-------------| |--------------| |--------------|
but if the data is changed , for exsample MGR TEC are deleted ..
then the strucure should be like this :
|-----------|
| President |
|-----|-----|
|
|--------------|-----------------|
| |
|------|------| |------|-------|
| DirMKT | | DirProd |
|------|------| |------|-------|
| |
| |
| |
|------|------| |------|-------|
| MGR MKT | | MGR PROD |
|-------------| |--------------|
so guys,,... please help me How to create this scheme?
I'm New In PHP but My boss wan me to create this..
please.. Please help Me
regards,
setiawanthea
[Non-text portions of this message have been removed]