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 writes to file appropriately.
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.