intresting scenario(please suggest solution)
Posted: Fri Jan 01, 2010 12:47 pm
There are three tables in mysql database
1. Projects
2. Employees
3. Empl_Proj (Assignment of employees to projects
Workflow: Home page display the list of Project to administrator. Administrator click the project which display the page "Employee_project assignment". This page contains list of all employees in the company. (Administrator should be able to distingush which employees from list are already assigned to project and which are not). Administrator can assign employees to project or deassign already assigned employees from project. the final list of assigned employees will be saved in Empl_Proj table of database.
Please suggest the design and code for Employee_project assignment page.
My in-experience opinon was to use the HTML table which have checkbox selected for already assigned employees and uncheck for rest and first delete the records from Empl_Proj table followed by saving the new selected records. but this required java script and looping on html entries and i don't know these both.so if this is the optimal solution please provide code.
1. Projects
2. Employees
3. Empl_Proj (Assignment of employees to projects
Workflow: Home page display the list of Project to administrator. Administrator click the project which display the page "Employee_project assignment". This page contains list of all employees in the company. (Administrator should be able to distingush which employees from list are already assigned to project and which are not). Administrator can assign employees to project or deassign already assigned employees from project. the final list of assigned employees will be saved in Empl_Proj table of database.
Please suggest the design and code for Employee_project assignment page.
My in-experience opinon was to use the HTML table which have checkbox selected for already assigned employees and uncheck for rest and first delete the records from Empl_Proj table followed by saving the new selected records. but this required java script and looping on html entries and i don't know these both.so if this is the optimal solution please provide code.