Jump to content

Introduction....and please help? (Forms-related)


Moron

Recommended Posts

Hi, Folks. I just stumbled across this fine forum and it looked like the right place to ask. I need some serious PHP help (see my username).  ;)

What I'm trying to accomplish is an Employee Leave Management system using PHP with Microsoft SQL, NOT MySQL. This is because we already have PHP talking to MS SQL quite well, but I'm not a coder by "nature."

I want it to work like the following. All must be BROWSER-based.

1. Employee pulls up the Leave Request form on our Intranet and fills it out (PHP and all other functions are already working fine).

2. He/She then clicks Submit.

3. The form arrives in the supervisor's e-mail (MS Exchange/Outlook 2000/2003).

4. Now, the supervisor can click Approve or Decline. There will also be a spot for Comments.

5. Next, the supervisor clicks Submit and it goes to:

a. Personnel

b. The original requestor

c. Anyone else as needed.

6. The entire procedure is stored in a SQL Server database (Version 7, I *think*).

Now, if there is a commercial or shareware product already out there to accomplish these things, I will consider them as well, but I would MUCH rather be able to code it in PHP or adapt it from existing code.

Anybody either seen anything like this or can offer me some insight?

Much obliged!




Link to comment
Share on other sites

Now the process, as I understand it, should be as follows:

[list]
[*]Employee fills in FORM1 and submits
[*]FORM1 generates email to supervisor containing a link to the FORM2
[*]Supervisor receives email and clicks on link to FORM2
[*]Supervisor gets FORM2 screen and fills decline/accept/comments
[*]Supervisor submits forms
[*]FORM2 generates an email and sends to whoever is in the distribution list
[/list]

Is this correctly understood?

Ronald  ;D
Link to comment
Share on other sites

[quote author=ronverdonk link=topic=102615.msg407491#msg407491 date=1154461420]
Now the process, as I understand it, should be as follows:

[list]
[*]Employee fills in FORM1 and submits[/list][/quote]

Correct.

[quote][list][*]FORM1 generates email to supervisor containing a link to the FORM2
[*]Supervisor receives email and clicks on link to FORM2[/list][/quote]

Either it sends a link -OR- sends the form itself. A link sounds a lot easier.

[quote][list][*]Supervisor gets FORM2 screen and fills decline/accept/comments
[*]Supervisor submits forms
[*]FORM2 generates an email and sends to whoever is in the distribution list
[/list]

Is this correctly understood?

Ronald  ;D

[/quote]

You've pretty much got it. Either e-mail notifications are sent with a link to a form needing approval, or the form itself is sent in e-mail. The way you're describing, by sending links, sounds the most feasible.

Thanks!



Link to comment
Share on other sites

[quote author=ronverdonk link=topic=102615.msg407506#msg407506 date=1154462353]
Does your reply mean that you've got it?
[/quote]

Unfortunately, no. I don't know where to begin. I do HTML and Javascript.That's pretty much it. I played with Perl a few years ago, but that's my only experience with anything server-side.

Can you recommend a good starting script or just a generally good starting point? If I can find a script that's close to what I want that I can modify, that would be ideal.

:)
Link to comment
Share on other sites

[quote author=ronverdonk link=topic=102615.msg407526#msg407526 date=1154463484]
I'll have to do some rework on some samples. Will be back within 12 hours with a workeable solution. I'll send the code via a private message from this site. Okay?

Ronald   ;D
[/quote]

I can't possibly thank you enough!

:)
Link to comment
Share on other sites

Moron ....

The private messaging system on this forum is not working (see news at top of screen), so I cannot send you the code that way. I can send it to your email address. If you don't want to show your email address here, send it to me: ronald at goosen-verdonk dot nl

Ronald  ;D
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.