It would be better if I started from the top.
We have an old but very robust Visual Foxpro 9 application. It is an ERP system for Truck Brokerage firms. Well this application has been out for 14 years and was the first windows based brokerage software. Obviously it has gone through a lot of changes in the last 14 years. It currently handles all accounting, interfaces with quickbooks, creates invoices, rate confirmations, email, pdf conversion, document management, and a lot of other functions for the truck brokerage companies.
Because it is currently just a server/client appliation and almost everything is moving to web-based applications, 2 and a half years ago we began rewriting the Visual Foxpro application to a web based application using PHP, AJAX, JSON, JQuery, and a MySQL database.
That wasn't the only reason for the application to be rewritten, the current application has been through many programmers hands in the last 14 years and has some poorly coded methods and practices throughout the program. Also Microsoft will no longer be supporting VFP9 for much longer. Yes it will continue to work fine but when Microsoft stops supporting an applications you have to worry about hot fixes, or at least that has been my experience in the past.
Anyway back to the application and the rewrite, the person in charge of creating the spec sheet for the web-based application really just skimmed the surface of the Visual Foxpro application.
We only have had one developer coding the new web-based application for 2 years. It is currently working and only needs a few more tweaks to finalize the web-application so it is ready for deployment. Well sadly the senior web-developer found a new job.
Being pushed for time we have looked at having the remaining of the work contracted out. One company thinks it is possible to use the code we have now, fix the bugs, separate the database out by customer, so that all the other customer's data isn't stored in the same tables. But this company isn't completely sure if they can handle the immense amount of code already written.
The other contractor company would like to throw away all the work and start over using HTML5 and some frameworks (They have yet to inform me what frameworks they are planning to use, or what database they plan to use). The price they quoted isn't bad but I don't think they will be able to write the application using the spec sheet that was created 2 and a half years ago. The current code we have for the web-based application should be used as a spec sheet if we decide to go with this contracting company. If they use the spec sheet that was created 2 and a half years ago we will end up with an application that doesn't do half of what the current web application does.
If it was up to me I would use HTML5, Node JS, AJAX, and probably a MongoDB for the back-end database.
Any advice would be greatly appreciated.