Mysql Database Fixes Asap
I have a database that gathers checked out orders from a website that needs to be completed it is 90% done , it does recognize checked out order compared to previewed orders , it has multi admin levels , its for a essay writing company, basically how it works it the writers log in and get their own log in and password , then they simply grab the checked out orders that come in once done writing the essays then they simply upload it to the database where the proofers can come in and proof the essays out. Also there is a writing manager admin and a regional manager , and just Admin , and a proofing manager admin , all have dif access , all this is all ready done in the database . Right now i have a guy working on it but he needs little more help. All this is all ready done in the database but we are just basically making the database more user friendly. I paid a guy all ready to get it to this point but now i need another to wrap it up and help this guy whos working on finish it up. Larry the guy who is working on it now is basically cleaning up the code to make it easier for the next person to do the database and try to get my user friendly fixes done to it but is taking to long. I have 4 sites that need to be connected to the database. The database need to be in each site so the sites dont link out to another site for SEO purposes i dont want any of my 4 sites linking out to any sites. Please list bid amounts that would cover 2 to 3 weeks of work. Must be able to start asap. I want to finish this project.
PROGRAMMER NOTES FROM WHAT HE DID
‘ve included the “initial” requests jordan made to me about what he wanted done.
I went through and I’m fairly certain I have all the trivial changes completed.
in a nut shell here are the issues(reiterated in detail in the readme)
-the guy did the quick develop based on as I understand it a poor set of specs which were misunderstood. …
there are 213 files, to produce what should be capably accomplished in at least half that.
as an example: there are 2 inbox setups, one for customers(which the previous developer called orders,, i.e it is an inbox for the order, not an inbox for a user) and one for a staff member
… there is a language issue … he used inbox to denote email, and list of inboxes/inboxlist to denote “inbox” as we normally would think of it.
so the code is a hard to read due to the language barrier, and b hard to follow because he apparently hard coded as much as he could get away with.
some of the “relatively” simple and typical things one would do to make the overall architecture standard he DID NOT do. so there is not a user type, and he uses a pseudo-global $staffId to house the staffID or the customer ID depending on which logged in… etc.. and there may be other things I haven’t stumbled across or was too scared to appreciate.
I have done a LOT of programming but I am only slightly familiar with mySQL, (love the crash course) so I have tried to avoid messing with any of the queries and have been focusing on refactoring each page configuration down to a single page so that the changes can be universalized (somewhere between 3 and 10 different pages to view orders depending on what the “user” was intended to see as opposed to one page with flags from a databaseImage removed by sender.)
and somehow by consolidating the left menu pane i broke the login!(yeah i feel stupid, i uploaded all the old archive code and tried again and it is all the same less one line(which shouldn’t do anything?!) so yeah frustrating.
What I need done I have on seperate email and attached images as well for updates to make the database more user friendly.
*Make email system handle 1000 emails a week
*Make reply button work in email system
*Make new menu for writers , proofers , writing Managers , regional managers , proofing managers , so that when they grab an order it till go to my order menu so they know what they have grabbed
*Make payroll system work auto link it to the writers paypal account
*Any more minor fixes needed I might add for 2-3 weeks.
I need this done asap am willing to pay good money for this to be done right. Budget is 1000-2000US to get this done.