PHP developer required to create function to auto email Purchase Orders from SQL 2005
- or -
Post a project like this3086
$$$
- Posted:
- Proposals: 3
- Remote
- #929313
- Awarded
Description
Experience Level: Expert
General information for the business: Sporting Goods Retailer
Description of requirements/functionality: I use SAP Business One system which runs on a Windows 2008 Server / SQL 2005 Server. I require a the scripting of a PHP function to automate the sending of Purchase Orders to a supplier:
1. Run a SQL query from a scheduled task each day at 5.00pm which creates a dataset of all the POs for a single supplier made on that day. I can provide the syntax for the query.
2. Extract data from the dataset and render into individual PDFs for each PO using the same format as the SAP purchase orders. I can send the successful applicant a copy of the Purchase Order PDF.
3. Attach the properly formatted PDF to an email.
4. Run a another query to a create a dataset of the file attachments relating to each PO, These are using PDF files containing images and are stored in database as file paths.
5. Using the file paths in the dataset attach the appropriate files to each email.
6. Send emails and append emails to the Sent Items folder of an Outlook 365 email account. You may use Outlook 2010 or 2013 which is installed on the server if this is easier?
7. Create summary report of all sent emails and send to specified recipient.
You will be required to work remotely, be able to communicate via Skype and have very strong English language. You may if necesssary dial-in to a network PC and be remotely connected via RDP to the server
Specific technologies required: PHP
OS requirements: Windows
Extra notes:
Description of requirements/functionality: I use SAP Business One system which runs on a Windows 2008 Server / SQL 2005 Server. I require a the scripting of a PHP function to automate the sending of Purchase Orders to a supplier:
1. Run a SQL query from a scheduled task each day at 5.00pm which creates a dataset of all the POs for a single supplier made on that day. I can provide the syntax for the query.
2. Extract data from the dataset and render into individual PDFs for each PO using the same format as the SAP purchase orders. I can send the successful applicant a copy of the Purchase Order PDF.
3. Attach the properly formatted PDF to an email.
4. Run a another query to a create a dataset of the file attachments relating to each PO, These are using PDF files containing images and are stored in database as file paths.
5. Using the file paths in the dataset attach the appropriate files to each email.
6. Send emails and append emails to the Sent Items folder of an Outlook 365 email account. You may use Outlook 2010 or 2013 which is installed on the server if this is easier?
7. Create summary report of all sent emails and send to specified recipient.
You will be required to work remotely, be able to communicate via Skype and have very strong English language. You may if necesssary dial-in to a network PC and be remotely connected via RDP to the server
Specific technologies required: PHP
OS requirements: Windows
Extra notes:
J S.
100% (57)Projects Completed
60
Freelancers worked with
54
Projects awarded
35%
Last project
11 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies