NUC0001 Create a PHP application to manage Employees of an organization. There should be two kind of users admin and normal employees. Only admin user can add new employees. Also he should have the facility to list, add, edit and delete employees details. Employee user can view and update their details only. It should have following fields : 1. Employee Name 2. Employee Code [Should be unique] 3. Department <COMBO BOX> : Load all departments from corresponding table. Give following department names directly to table. Software Development, Customer Support, Hardware maintanance 4. Designation <COMBO BOX> : Load designations based on department without page refreshment(using ajax). Give following designations directly to table. Software Development : Project Manager, Project Leader, Sofware Engineer, Tester Customer Support : Support Co-ordinator, Support Head, Support Engineer Hardware maintanance : Maintanance Engineer, Maintanance Head, Maintanance Support 5. Joining Date 6. Address 6. Phone 7. Email 8. Photo <FILE BROWSER> 9. Type <COMBO BOX> [Having values, 1. Permanent 2. Trainee 3. Part-time] If Type is permanant then a section will display to enter following details : 1. Date of birth 2. Mobile Number 3. Permanant Code - User can enter the value here, but while save the data this code should prefixed with employee code too. (For eg:- assume employee code is 'EM1', user entered permanant code as PR100, then in database it should keep as EM1_PR100 and this will consider as the permanant code). This is not editable in Update mode also. 4. Permanant As On (Date field . This date should be greater than or equal to Joining date. Check validations and raise appropriate messages) 10. Login Name 11. Password Here Employee Name, Employee Code, Department, Designation, Joining Date, Type Login Name and Password are mandatory . NuCore Software Solutions Pvt Ltd
NUC0001 If Type is permanant then only Date of birth, Mobile Number, Permanant Code, Permanant As On should be mandatory. Put email/Number validations in corresponding fields. The list interface should show details in a table like as follows : Give filtering criteria for following fields : 1. Department 2. Designation 3. Type 4. Joining Date From 5. Joining Date To Employee Name
Employee Code
Joining Date
Departm Designati Ema Phone Type Photo ent on il
Privillages : Admin user : Add , Update , Delete , View of all Employess. Employee user : Update , View only their own details.
NuCore Software Solutions Pvt Ltd