Find Jobs
Hire Freelancers

PHP / MSSQL Form Submission Page and Submission Edit and View Pages

$250-750 AUD

Cancelled
Posted over 8 years ago

$250-750 AUD

Paid on delivery
Hi, \r\n\r\nSummary -\r\n\r\nWe require a web page that allows users to submit historical events with dates using a web form. The submission is then approved / denied by an administrator account who logs into the admin page. All data that is approved is displayed on another page in a historical timeline format. \r\n\r\n\r\nCore Requirements -\r\n\r\n* Complete within 4 days of acceptance\r\n* Approx. 10-15hrs work is estimated to complete this project \r\n* The web page code is PHP/HTML/CSS/JQUERY. We have create a template which you can use to start with see attached: \\\"[login to view URL]\\\"\r\n* The database is Microsoft SQL Server 2012 (Please do not offer MySQL)\r\n* Form to use [login to view URL] plugin:\r\n - Radio button use: [login to view URL]\r\n - On submission form fades out ([login to view URL]) then uses a progress bar before displaying Thank You message ([login to view URL])\r\n - All pages to be responsive and scale for PC and mobile screen size\r\n* 10% Payment to start\r\n* 30% Payment when files supplied - submission page, timeline page and database for us to test\r\n* 60% Payment when we finish installing on our site, testing and check and make final changes and project is complete\r\n\r\n\r\nDetails -\r\n\r\n1. Web Pages: \r\n\r\nA) Submission page\r\n\r\n* You will set up a submission form page called: [login to view URL]\r\n* The form fields are attached as: \"Table [login to view URL]\"\r\n* The page design is attached as: \\\"Submission Page and Admin Page [login to view URL]\\\"\r\n* There are two categories - Historical Events and Literary Events\r\n* There will be a tick box for AD and BC. It will display the appropriate AD or BC date fields depending on their choice.\r\n* You will need to program it to only allow numbers and validation:\r\n - AD - between 2015 and 0\r\n - BC - between 0 and 14,000,000,000\r\n* By default all submissions are not approved\r\n* On our site this page will sit inside an iframe and our system will already pass the Username, FirstName and LastName variables in to the URL. So the URL you will be working with is: \r\n\r\[login to view URL]\r\n\r\nB) Approval Page\r\n\r\n* You will set up an approval page called: [login to view URL]\r\n* We will implement the admin authentication check. You will just need to set it up so anyone can approve/deny\r\n* The approval page will query all existing submissions and allow the user to delete / alter / approve / deny each submission\r\n* Before delete it will prompt are you sure yes/no. Deleted submissions will be stored in separate Table.\r\n* When user clicks on status it will give a drop down to approve/deny each submission\r\n* When user clicks on edit it will let them edit fields for submission and save changes\r\n* The page design attached: \\\"Submission Page and Admin Page [login to view URL]\\\"\r\n\r\nC) View Page\r\n\r\n* You will create a page that users can view \\\'approved\\\' submissions - [login to view URL]\r\n* Historical Events are on the left and Literary Events are on the right\r\n* It will display the latest AD date at the top and the oldest AD date at the bottom\r\n* Once it reaches BC it will display the latest BC date at the top (1BC) and the oldest BC date at the bottom (5000BC)\r\n* For full details and design see attachment: \"Detailed scope and timeline [login to view URL]\"\r\n\r\n\r\n2. Database:\r\n* You will need to make a database on Microsoft SQL Server 2012 \r\n* The database will contain a \\\'Table\\\' to store all submissions including the username variable which is hidden on the form.\r\n* A \\\'Table\\\' for deleted submissions\r\n* The database will also contain a \\\'View\\\' to display all approved submissions in date order as specified in the attachment. This will associate with the \\\"View Page\\\"\r\n\r\n\r\nIf you are interested please let me know how long this will take you (hours), and when you can complete it by. \r\n\r\nAll quotes over $400 will be rejected.\r\n\r\nThank you,
Project ID: 8951807

About the project

Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of AUSTRALIA
Erina Heights, Australia
5.0
8
Payment method verified
Member since Nov 13, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.