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.
接包方 | 国家/地区 | |
---|---|---|
4
Niclien
|
||
3
Infodigita
|
||
3
Mpla
|
||
2
Nurvo
|
||
2
Glooso
|
||
2
Mainegraphicsonline
|
||
2
Iphonesdkpros
|
||
2
Hardwarrior
|
||
2
Stacyjwx
|
||
2
Neilinglis
(中标)
|
||
2
Alisonb
|
||
2
Binary123
|