Jump to content

Archived

This topic is now archived and is closed to further replies.

Moron

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

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!




Share this post


Link to post
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

Share this post


Link to post
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!



Share this post


Link to post
Share on other sites
I personally hate HTML in emails. Another reason is that someone can prevent having HTML in emails, usually the network guy in a company.

Does your reply mean that you've got it?

Ronald  ;D

Share this post


Link to post
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.

:)

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
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!

:)

Share this post


Link to post
Share on other sites
Before I go: are you certain that your PHP mail (email function) works? You'd better check that.

Ronald  ;D

Share this post


Link to post
Share on other sites
[quote author=ronverdonk link=topic=102615.msg407544#msg407544 date=1154464860]
Before I go: are you certain that your PHP mail (email function) works? You'd better check that.

Ronald   ;D
[/quote]

Yes, we do!

:)

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

×

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.