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]

Reply via email to