hi everyone,

i am facing a sitution, in developing an employee system. plz help me coding following problem, i have not been able to write a suitable code for it.

An employee fills in a leave request, a record is created for the request. This request doc goes to his supervisor for approval. In case he does not reply within say 5 "working days", then his case is escalated to someone higher in the org. hierarchy. So we need to calculate the escalation period automatically, and send mails as and when appropriate.

Then the system picks up all the unapproved requests, calculates the time elapsed (ie time since no action has been taken on the request), ...
.and if its elapsed 5 "working days", it writes some text (say pending request) to a file. Now these working days can be Mon-Fri or Mon-Sat.

this is the situation i am facing, but i am unable to code it properly,
plz help me with a suitable code.

Where are you running into a problem? Have you even tried writing it? What level of experience do you have? You've got to give us something other than the description of your problem... sorry, but we've all got stuff to do as well, and while we're all perfectly willing to help you out, I don't think anyone is going to do it for you. This sounds like a weighty task, and it doesn't sound like you've attempted to plan it out at all, which is the first step in programming and solving problems. And so, instead of thinking about how you're going to solve this problem with code, I think you should try to solve this problem using logic. Work out a step-by-step plan to execute the task, then code it.

__________________
-Aaron