Hello All--
We're looking for speedy development of a PHP form application. There is already a working Javascript for the quote delivery, which you will be reverse engineering. We need this fast. The WRITE to the API can be done later (after the project deadline of 4 days... this is very low priority). The highest priority is the quote/graph generation. I will be selecting a bidder today so we can have a Sunday delivery.

First off, here's the basics:

It is a 7 page form
Users must be able to Save their progress and return to continue
The GUI/Form Layout has already been developed in validating HTML.
A quote for payment must be delivered based on variables. The quote is generated with mathematics similar to the Javascript written earlier and then fed into a chart using Google Chart API to deliver the quote (http://code.google.com/apis/charttools/index.html )
The form, when finished, will write to an API AND and to an SQL database. You will never read from this API, just write to it.

The database that you must check must be imported onto my dedicated Linux server. I have the SQL file as well as the data in columnar format.


I am not looking to disclose too much until a winning bidder has been accepted. The ideal bidder will possess the following qualities:
Proficient in PHP
Proficient in Session, Cookies, and Form processing
Proficient in Javascript
Proficient in English
We are looking for speedy development... a 5 days MAXIMUM excluding the API write, but much prefer 4 days (so... a Sunday delivery).

The GUI is already developed, so you will just be making it work on the backend.

You will be working/developing on a dedicated Linux box with CPanel and PHPMyAdmin.


Here's the specific steps involved in the process:

Finances Page Math (titled “Your Finances”

YourTotalIncome = YourNetPay+PublicAssistance+AlimonyChildSupport
YourTotalExpenses=Addition of all variables/entries starting with “Rent Payment” and ending with “Other Expenses”
TotalDisposableIncomeWithOutDebt=YourTotalIncome-YourTotalExpenses

Accounts Page Math (titled “Your Accounts”
Add “Monthly Payment” for all accounts entered = YourTotalDebtPayments
Add “Balance” for all accounts entered = YourTotalDebt
TotalDisposableIncomeWithDebt = YourTotalIncome-(YourTotalExpenses+YourTotalDebtPayments)
Backend Work on this page for use on the solution page:
Reference:
Dbo.CreditorMasks
Match MASK column to the Account Number entered, referencing the number of digits as well as the numeric prefix. For example, a mask might be 16#######, so I would match this to all account numbers that begin with 16 and are 9 digits long. The MaskLength column contains the length in digits of the MASK. So, a logic sample would be to count the number of digits in the account number and match it to the MASK length, then match the numeric portion of MASK to the account number. The goal is to acquire the CreditorID.
Now, reference dbo.Creditors
Go to the CreditorID calculated from previous logic.
Check the Column titled ReduceInterest. If this column = 0, then check the column titled EliminateInterest. If this column = 0, then the new monthly payment for the creditor = the same as the old monthly payment for the creditor. If the EliminateInterest column = 1, then the NEW APR for that creditor = 0. If the ReduceInterest column = 1, then the NEW APR for the entered creditor = the value from the APR column.
*Please note, users will enter their current APR as a whole percentage (i.e., 4.9%, 5.6%), this needs to be interpreted for all calculations as a numeric value like .049 or .056. *
Now, calculate the OLDMONTHLYPAYMENT and the NEWMONTHLYPAYMENT. The Old Monthly Payment for individual creditors is whatever the user entered for the “Monthly Payment” field on the accounts page.
To acquire the new monthly payment total… mimic that of http://www.yourgfm.com/debt-calculators/debt-management-calculator.shtml in the “WITH debt management” column of “Total of monthly payments.” I have procured the source javascript for this as well, which is included in the attachments. The only thing you have to change is this code is the APR reference. Use the APR we procured when we connected to the dbo.Creditors. This javascript uses a fixed 5% reduction. Other than that, the calculations would be the same.
Solution Page Math (titled “Your Debt Management Solution
Your monthly income Generated from YourTotalIncome on Finances Page
Your monthly expenses Generated from YourTotalExpenses on Finances Page
Your total debt Generated from YourTotalDebt on Accounts Page
Your old monthly payment Generated from YourTotalDebtPayments on Accounts Page
Your new monthly payment: Generated via the “Total of monthly payments with debt management” column referenced here: http://www.yourgfm.com/debt-calculators/debt-management-calculator.shtml

Calculate time to pay off debt using the same calculations on http://www.yourgfm.com/debt-calculators/debt-management-calculator.shtml. Reference the WITH DEBT MANAGEMENT and WITHOUT DEBT MANAGEMENT columns of “Months until debts are paid off.” Chart the timeline comparison using Google Chart API.
Chart the NEW monthly payment and the OLD monthly payment, based on our earlier calculations using Google Chart API.

Add the following exceptions:
If Creditor ID = 0 && DisposableIncome < 201 && DisposableIncombe >1, then APR = 0 & CTAQualified = 1.
This is obviously pseudo code. I don’t want you to “generate” anything with it in the code or do any calculations. Just a placeholder for me for later. What you’re saying is…. If the creditorID is equal to a certain value AND the disposableIncome is less than 200 but greater than 1, then the APR = 0 and the value CTAQualified = 1. Please add a column in the SQL database that you dump all data into called CTA Qualified. This value can always be 0, unless the previously mentioned criteria are met.
As long as the logic is there, and the column storing the CTAQualified flag is there, then that’s all I need. No flags on the front end are necessary.