We are working in a LAMP environment using InnoDB. You will have 10 to 12 years experience with PHP development. EXPERT knowledge of foreign keys, constraints and referential integrity.
A lot of the work has already been done but here have been changes to the database and the coding needs to be checked to verify everything is working correctly. New items include gross sales, cost and profit; sales; & reseller commission payment reporting at corporate level and a reseller credit update section.
The front end (FE) admin pages allow the re-seller to maintain their company information, company credit card – which is not there now and needs to be added – look at their orders and monthly invoices. Also to view invoice commissions which have been paid and which are owing with column totals. An ability to query orders and invoices for their company or by salesperson if they have any
The salesperson admin pages is a lot more limited and is subset of the re-seller data. The salesperson can maintain his address and contact information and view his orders and invoices only
Commissions obviously will be the most important part of this and we need to provide accurate information on commissions paid and the commissions payable to the re-seller. There is no requirement for the application to generate commission cheques just to provide screen/page queries, printed and email reports
The FE admin pages have 90% of all the data maintainable. We want to use the FE admin pages and expand it to include all the other fields and tables that SafeTracks will use to setup the Re-seller. This would then become the Back End (BE) Admin Page for both where SafeTracks can add new re-sellers or modify existing re-seller discount & commission rates etc. which are disabled to the re-seller
The other thing we want to add is SafeTracks global orders and invoices reporting page. These would include orders and invoices for all re-sellers. SafeTracks is also setup as a re-seller. Customers may also buy directly online without going through any re-seller. So this would be a global sales reporting page with an ability to sort on most columns as well as an ability to input query section parameters
This is also where I think we would run re-seller monthly commissions reports grouped by re-seller to provide the amount of commissions owing by re-seller. We would also need to be able to include a function to update one re-seller, a range of re-sellers or all re-sellers as commissions PAID. We should be able to export this date to a CSV file or Excel file so the date can be used as input into an accounting system.
There will be other reporting requirements needed at a global or SafeTracks level. We have costs tables in the database so we may require Gross Sales, Costs and Gross Profit reporting for a range of time and criteria. This too would need to be exportable in CSV or Excel files.
We have created a Re-seller Credit Card Table which we will need to be incorporated into the page for updating credit card information.
We have updated header, footer, navigation templates which will need to be used. Page uses an older version.
We will not pay 100% up front milestone. Competitive bid will be given preference. Must be able to start now. You agree that you will forfeit your final milestone if yo do not complete the project on an agreed delivery date. Our desired completion date is Dec 31. Excellent English. DAILY UPDATES MANDATORY. Must comply with attached coding standards. Code that does not comply will need to be re-written by you.