The project described below the ****** was completed in 2008. Errors have started to occur recently in the script and must be fixed immediately. The form that is processed by the script is http://www.newburyportmothers.com/submission.php.
Briefly, when a form containing the ad data is submitted two emails should be generated. One email is sent to the email address entered on the form with only the data from the form. This email is OK.
A second email is sent to the site owner with an attachment. This email is not being generated. This project is to debug the script to fix this problem.
This project is urgent and needs to be completed by May 3. I will provide all server login info immediately upon accepting a bid.
Below are the original project requirements:
*******************************************************
GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL database. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.
The development project is in two parts. The workflow below is described to give programmers a better understanding of the project requirements.
Part 1 – AD SALES
The site owner will provide a draft of the ad submission page with the sales form. The programmer will modify the form as needed, create the mySQL data base, develop the data base queries and develop the email processing on the server to implement the features that follow.
1. To submit and pay for an ad the user navigates from other site pages to a landing page that displays Terms and Conditions and the user must select an “I Agree” checkbox to proceed to the submission page. The programmer will not work on this page. The user clicks Next to go the submission form. A validation check is performed on the checkbox to allow the submission page to open. Most of the data entries on the submission form will require validation before the data can be sent.
a. The submission form contains text boxes to enter the required business information. The form also contains selectors for the ad’s size and the starting date and frequency the ad will appear. The programmer will need to ensure that only allowed sizes and frequencies are chosen and that the member discount is applied for pricing of the ad.
b. The form will have a yes/no checkbox to either submit the ad copy with the form or to submit it at a later time. This yes/no data must also be passed to the database.
c. The ad is normally submitted as an attachment to the form. Ads are image files. The form will have a file selector to browse and attach the file from the local disk. The programmer will make this file selector inactive by default so that the user has to choose the yes/no option. When the yes option is selected, the file selector is activated and the user can navigate on the local disk to select the ad file. The file extension is checked to confirm it has an EPS, JPEG or PDF extension. If validation fails, an error box pops open and the form cannot be submitted until the error is corrected.
d. The user chooses the ad size from a drop down menu or radio button list on the form.
e. Ad frequencies include standard half-year (5 months) and full-year (10 month) blocks and single months. Each block or single month plan has a standard price for each ad size. For the half and full year blocks only, both consecutive and non-consecutive, multiple month blocks are a frequency option that the programmer will have to implement. Block prices will be discounted for group members so there will have to be a selector form Members (non-members will be the default).
f. A start month/year will be selected.
f. The existing form will have selectors for all of the above options, but the programmer may have to develop logic to calculate the final price of the ad. The programmer will develop logic to display the final cost of the ad. The cost display should update dynamically when the ad size and/or frequency or member/non-member status is changed.
g. The user clicks on the Pay button and is sent to Paypal with the cost data. The form data is NOT SAVED on the mySQL server UNTIL the payment in step 2 below is completed.
2. The Paypal page is pre-populated with the correct payment amount calculated on the form. After payment is completed the user is returned to the site for further processing of the ad submission.
3. The user is returned to a thank you page on the website. When the page opens the following takes place:
a. All form data are saved to a mySQL database at the web host and the attached image file (if sent) is saved to a folder on server.
b. The programmer creates a server-side script to generate two emails after the data are saved:
– A formatted thank you email is sent to the submitter showing the ad cost, size, frequency and months that the ad will be in the newsletter.
– A formatted notification email is sent to the site owner with all form data as text (field name: data), including the image file if sent.
Part 2 – REPORT GENERATION (programmer to design web page interface and all code):
1. The site administrator securely logs in to the report page.
2. On this page are 2 report generation forms.
a. General Historical Report – the administrator selects the range of month/year dates from a starting date – ending date menu and clicks on the Generate Historical Report button. An Excel style report page is generated that shows all fields for each record. The order of the columns is the same as the submission form. The administrator clicks on the Send Report button and the report is sent as a CSV file attached to an email to the administrator.
b. Monthly Report – This is a standard report for a selected month/year that is similar to the General Report but shows all ads that should run for the selected month (example: an advertiser places a 5 month ad for Jan-May. In March, the Report is run to see what ads should be included in the April newsletter, the administrator needs to see all ads that were submitted for print for that month, regardless of when the ad was originally submitted). The browser displays the report as rows of data with column headings. The administrator clicks on the Send Report button and the report data is sent to the site administrator as a CSV file attached to an email.
– Note: This a an revision of a project that was recently posted. To avoid confusion while the requirements were changing I decided to cancel and resubmit the project –
GENERAL : We are developing a website for a social group that sells ads for its newsletter. After payment is approved, the ad data is submitted via a form to a mySQL data base. The ad copy is an image file that may be submitted with the form to the server. Emails to the submitter and administrator are generated after form data are successfully received. To manage the data, an administrator page allows a standard data base report to be generated for a given month/year and a second report to be generated for a range of months/years.
The development project is in two parts. Here is the workflow we want to implement for both parts:
SALES { NOTE- A draft of the sales page form will be provided to the developer
