Jump to content


Photo

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


  • Please log in to reply
12 replies to this topic

#1 Moron

Moron
  • Members
  • PipPipPip
  • Advanced Member
  • 368 posts

Posted 01 August 2006 - 07:36 PM

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!






#2 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 01 August 2006 - 07:43 PM

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

  • 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

Is this correctly understood?

Ronald  ;D
RTFM is an almost extinct art form, it should be subsidized.

#3 Moron

Moron
  • Members
  • PipPipPip
  • Advanced Member
  • 368 posts

Posted 01 August 2006 - 07:55 PM

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

  • Employee fills in FORM1 and submits


Correct.

  • FORM1 generates email to supervisor containing a link to the FORM2
  • Supervisor receives email and clicks on link to FORM2


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

  • 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

Is this correctly understood?

Ronald  ;D


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!





#4 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 01 August 2006 - 07:59 PM

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
RTFM is an almost extinct art form, it should be subsidized.

#5 Moron

Moron
  • Members
  • PipPipPip
  • Advanced Member
  • 368 posts

Posted 01 August 2006 - 08:10 PM

Does your reply mean that you've got it?


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.

:)

#6 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 01 August 2006 - 08:18 PM

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
RTFM is an almost extinct art form, it should be subsidized.

#7 Moron

Moron
  • Members
  • PipPipPip
  • Advanced Member
  • 368 posts

Posted 01 August 2006 - 08:34 PM

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


I can't possibly thank you enough!

:)

#8 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 01 August 2006 - 08:41 PM

Before I go: are you certain that your PHP mail (email function) works? You'd better check that.

Ronald  ;D
RTFM is an almost extinct art form, it should be subsidized.

#9 Moron

Moron
  • Members
  • PipPipPip
  • Advanced Member
  • 368 posts

Posted 01 August 2006 - 08:56 PM

Before I go: are you certain that your PHP mail (email function) works? You'd better check that.

Ronald   ;D


Yes, we do!

:)

#10 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 01 August 2006 - 09:06 PM

Ok, you'll hear from me tomorrow.
RTFM is an almost extinct art form, it should be subsidized.

#11 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 02 August 2006 - 10:13 AM

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
RTFM is an almost extinct art form, it should be subsidized.

#12 BillyBoB

BillyBoB
  • Members
  • PipPipPip
  • Advanced Member
  • 630 posts

Posted 02 August 2006 - 10:20 AM

i could whip the code up real quick

#13 ronverdonk

ronverdonk
  • Members
  • PipPipPip
  • Advanced Member
  • 277 posts
  • LocationNetherlands

Posted 02 August 2006 - 10:25 AM

Whip up?
RTFM is an almost extinct art form, it should be subsidized.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users