2008-07-30 Basic Website with Linkpoint Card Processing

NOTE: The main emphasis of this project it to capture payment info and process it using the Linkpoint API. Please only bid if you have experience working with the Linkpoint payment gateway. Due to my current very busy schedule, I am listing this as a complete project. Typically I only list small portions of a project, and do most of the work myself, but I hope to have this website online and working within a few days, and simply do not have the time to devote to getting it put together myself. The project is pretty basic…a very small informational website, with only 1 product in e-Commerce (no shopping cart needed, nor do I want a full cart system implemented). Please read over the included files to be sure you understand the project completely before placing a bid. All scripting should be in PHP and will be hosted on a Linux & Apache server with [login to view URL] when completed. The database used is MySQL (version 4.1). As with all projects I list on GAF, I will retain full rights to reproduce, modify, and otherwise use all scripting, codes, and other materials that you produce as part of this project without further payment (beyond the project payment) or any notation(s) regarding your authorship of the work. All copyrights are transferred completely to me, as are all rights to derivative work. All pages will plug in $PageContent into an existing html template (see sample files) that will contain navigational links to each of the other “info” pages ([login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL]). I will be re-doing the “template” in pure CSS/XHTML within the next few weeks, so all output ($PageContent) that your codes generate should be written appropriately (no tables, deprecated elements, etc). Any CSS classes you need, please specify in a CSS file with final product, and I will add it to my CSS. The included ZIP file contains the template file ([login to view URL]), and a sample ([login to view URL]) file that is formatted to my specifications as well as the directory structure that will be used and many of the base pages. Also included are text files of the SQL queries that you can use to create the tables to see the data I am collecting and the database structure used. I will provide access to these actual databases via phpMyAdmin and an FTP account on the web server to the winning bidder. I will also provide necessary Linkpoint account information for integration into the account. (note that a link to the LinkPoint API is available in the download as well). [login to view URL] (this contains lots of demo code for you to see how pages are set up) • first step signup (collect phone number and dropdown list to select state, then ajax dropdown of counties within that state)…submit to [login to view URL] [login to view URL] (create this page) • get state and county (if both not already captured from [login to view URL]) • validate that phone number is exactly 10 digits long • allow additional phone numbers to be listed (each with a state and county) for an additional $10 fee each • display “terms of service” agreement and require checkmark confirmation • upon completion, save data in database and forward to [login to view URL] [login to view URL] (create this page) • collect billing name, billing address, email, password, etc and store in database • first phone number is $15…additional numbers are $10 • collect credit card info and process payment through linkpoint (API is provided at [login to view URL]) • Note: An SSL certificate is available on the server to secure the transaction • verify successful payment or payment failure • forward to “thank you” page ([login to view URL]) with order confirmation [login to view URL] • order confirmation and thank you PAGES THAT ARE ALREADY DONE AND DO NOT NEED YOUR ATTENTION: [login to view URL] • (leave blank, I will plug in scripting for this section) [login to view URL] • basic text page (provided) [login to view URL] • basic text page (provided) [login to view URL] • basic text page (provided) [login to view URL] • basic text page (provided) DATABASE STRUCTURE INFO: The following tables will be involved in your scripts (all are included in ZIP as well): TdoDmo_RegionList TdoDmo_ContactInfo TdoDmo_UserAccountData TdoDmo_RegionList contains the States, Counties, and location code (SAMECode) that will be associated with each phone number. It also contains a field to determine if the county is available (Active) for registration. Note: “CountyCode” is not used. FIELDS IN TdoDmo_RegionList TABLE: SAMECode, County, State, CountyCode, Active TdoDmo_UserAccountData contains the personal and billing data for each user. The fields are pretty self-explanatory. Once the site is running, the credit card data will be automatically purged daily for security (you do not need to write the code for this part). The “Password” field should be encrypted using MD5() before storing in database. “TermsAccepted” should be the timestamp when the user agreed to the Terms of Service (checkmark). All the billing information and credit card information can be formatted however Linkpoint references the data, so Linkpoint abbreviations can be used (in other words, the structure of the database table can be modified as needed). FIELDS IN TdoDmo_UserAccountData TABLE: UserId, Password, EmailAddress, FirstName, LastName, TermsAccepted, BillingAddress, BillingCity, BillingState, BillingZip, AccountType, AccountNumber, AccountExpireMonth, AccountExpireYear TdoDmo_ContactInfo contains the info about each registered phone number and the location that it is associated with. When registering a new number, we save the phone number (stripped of all formatting such as hyphens, spaces, parenthesis, etc, down to exactly 10 digits), the SAMECode associated with the State/County selected, the ExpirationDate (one year from the registration date), and the UserId (which is carried over from the TdoDmo_UserAccountData table. Note: “NumberOfChanges” is not used. FIELDS IN TdoDmo_ContactInfo TABLE: PhoneNumber, SAMECode, ExpirationDate, UserId, NumberOfChanges PLEASE CAREFULLY REVIEW ALL ATTACHED AND INCLUDED FILES BEFORE PLACING A BID