I am working in SASTRA University & designed FORM for filling up VACATION details of FACULTY MEMBERS & I am new to code writting. I have started learning to write codes using HTML, PHP, CSS & JAVA SCRIPT.
I have created 3 data bases in mysql, one carrying the Staff details, another one for entering VACATION PERIOD and the last one carrying VACATION ELIGIBILITY days for all staff.
What I want to ask is:
The FACULTY MEMBERS are placed in difference Cadres and their VACATION ELIGIBILITY will vary according that. I have designed the form in such a way that, the VACATION ELIGIBILITY will be displayed automatically, if they enter their STAFF ID in the appropriate box.
The ENTIRE VACATION DAYS may be taken in two spells namely spell 1 & spell 2. Spell 1 is compulsory & spell 2 is optional (which means, the entire VACATION may be taken in single spell or in two spells) For Ex., if a staff is having eligibility of 20 days, he may take the entire day in spell 1 itself or he may break it into two spells according to his choice (eg.,7+13 or 2+18 or 16+4, etc...). I have made necessary provisions in the form for inputting the vacation days in spell 1 & 2.
Now, if that Faculty Opts to avail the entire days (eg., 20 days) in spell 1 itself, then after filling the ENTIRE 20 DAYS IN SPELL 1, HE SHOULD NOT BE ALLOWED TO FILL SPELL 2 (must be disabled) & if he opts for two spells (like 7 days in spell1 & 13 days in spell2), he should be able to fill both the spells & AT ANY COST, IT SHOULD NOT EXCEED THE ELIGIBILITY DAYS).
strong textIF IT IS NOT POSSIBLE TO SEND CODES, KINDLY GUIDE ME THE SUITABLE CODING LANGUAGE THAT I CAN USE FOR THIS TASK AND ALSO PROVIDE ME SOME HINT, SO THAT I MAY USE TO COMPLETE MY REQUIREMENT.strong text