Leave management System

[anji4u_19]

Hi frenz,

this is Anji, I want leave management flow and also how to design the database

its urgent....

[Eranga]

Do you have any design? Because you are the only one who knows your requirements.

[fantasy8x]

i need a LMS require:
1. A person should be able to:
Login to the system through the first page of the application
Change the password after logging into the system
See his/her eligibility details ( like how many days of leave he/she is eligible for etc)
Query the leave balance
See his/her leave history since the time he/she jointed the company.
Apply for leave, specifying the from and to dates, reason for taking leave, address for communication while on leave.
See his/her current leave applications and the leave applications that are submitted to him/her for approval or cancellation.
Approve/reject the leave applications that are submitted to him/her.
Withdraw his/her leave application (which has not been approved yet).
Cancel his/her leave ( which has been already approved). This will need to be approved by his/her Superior.
Get help about the leave system on how to use the different features of the system.


THIS IS Exercise me ^^~. plz help :))

[Eranga]

No one here ready to do your homework. You should work on that, and if you stuck with something we'll help you. First show your attempt.

[satkk]

Hi everybody
Im doing an online leave mangement in JSP, as a demonstration, im calculating the leave only for a predefined month say march. But how can i proceed if some one wants leave on March 31, April 1.

The scenario so far is.
An employee can login and view his profile, in his profile he will be able to see his current leave status. say 5 official leave and 2 other.When he takes 1 official leave it will be decreased by 1. But im stuck when it comes to multiple months. How can design a database suiting my need.

So far my db design is as follows
AdminTable
----------
admin_user====PK
admin_passwor

Employee register
-----------------
Employee_ID PK (Will be entered manually, since it will be given @ the time of joining).
name
username
password
contact_details
-------------------

Employee leave table
--------------------

employee_id FK
official_leave
other_leave-------------When he/she takes a leave it will be decreased by 1 or by the no of days. if it approaches zero it will show a message and let the user to contact admin for further assistance.Also if official_leave not equal to zero and other_leave equal to zero, the user can opt a leave under official_leave(dont know whether the whole thing is a blunder, but im a newbie pls help or suggest any ideas).

But the system is only for a predefined month, my problem is when i deal with multiple months, how will be my database or how to change the database


Thanks in advance.

[Eranga]

Basically you no need to conflict with the multiple months. Just what you have to do is, record entries in date format in the database.

[OrangeDog]

Please don't hijack other people's threads and please don't post in unrelated fora. This board is for suggestions and feedback about this website.

[Eranga]

And our FAQ page clearly status about those things. And on the home page too, for each sub-forum we have a simple explanation about it.

[mtyoung]

very sorry to interrupt others thread
but i fail to start new post... by (New Posts)
Eranga, can you tell me how to start new post?

[Eranga]

very sorry to interrupt others thread
but i fail to start new post... by (New Posts)
Eranga, can you tell me how to start new post?

Sorry lol, I didn't get you. What you mean by start a new post? You can start a new thread, start new post not make sense to me.

[mtyoung]

i found out how to start a new thread...
long time have not do that ... forgot...

[Eranga]

Ah, I'm just confusing what you ask about new post start. :)

[longbalan]

My project is Leave Management System
but i don't design database .I don't permision for manager.

[longbalan]

If i want leave application who will received my leave application,if is manager is permision ,how to design database.Manager is employee ?

[longbalan]

every body help me

[longbalan]

thank you very much

[longbalan]

i delevopment by java if every body have source code can send me.Thanks you very much.i can reply data for if have some thing

[longbalan]

My yahoo is longbalan

[longbalan]

thank you for visit my website

[longbalan]

Who can i delevopment soft ware for mobile