Moron Posted August 1, 2006 Share Posted August 1, 2006 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. Personnelb. The original requestorc. 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! Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 1, 2006 Share Posted August 1, 2006 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 Quote Link to comment Share on other sites More sharing options...
Moron Posted August 1, 2006 Author Share Posted August 1, 2006 [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! Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 1, 2006 Share Posted August 1, 2006 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 Quote Link to comment Share on other sites More sharing options...
Moron Posted August 1, 2006 Author Share Posted August 1, 2006 [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. :) Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 1, 2006 Share Posted August 1, 2006 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 Link to comment Share on other sites More sharing options...
Moron Posted August 1, 2006 Author Share Posted August 1, 2006 [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! :) Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 1, 2006 Share Posted August 1, 2006 Before I go: are you certain that your PHP mail (email function) works? You'd better check that.Ronald ;D Quote Link to comment Share on other sites More sharing options...
Moron Posted August 1, 2006 Author Share Posted August 1, 2006 [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! :) Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 1, 2006 Share Posted August 1, 2006 Ok, you'll hear from me tomorrow. Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 2, 2006 Share Posted August 2, 2006 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 Quote Link to comment Share on other sites More sharing options...
BillyBoB Posted August 2, 2006 Share Posted August 2, 2006 i could whip the code up real quick Quote Link to comment Share on other sites More sharing options...
ronverdonk Posted August 2, 2006 Share Posted August 2, 2006 Whip up? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.