364178 expert database programmer
N/A
Pago na entrega
We need a databse m,ade so all our employees can log into it including the owner. We are a writing company , so we have writers , proofers , writer managers and hiring manager and regional manager and owner , The over all set up of the database will allow the writers to grab oders from 2 sites that are linked to the database , and then upload the order to the proof readers after the writers have written up to the proof readers. Then the proof reader grab the order then when done the proof reader submit it to the finalized section where the writing manager checks it then sends it out. This database will also be like a [url removed, login to view] so everyone will have there own email address and inbox , sent box , and compose box , also this database will have a function for the managers to fire ppl if needed , also when an order is placed when a writer grabs the order the customer will get email the writer email address that took it., then there is my biggest function that is kinda tricky that i need done , We have 2 writing sites so this will gather order from 2 sites 1 is made and runnning the other is not almost done in 3 weeks.
Hard function
Important
· There will be a master section “writer managers / regional /owner can see this section” where all papers that are ordered from our sites will keep track of all orders so we can make sure if a customer ordered a paper also my merchant account email address will be linked to the database in this section so when the customer officially checks out the database will get an email say that customer paid, this way writer managers can make sure the customer checked out. Once the order is checked out by the customer the database will get another email that will have customer name on it and number and email address , this is the tricky part , the database will then need to scan the merchant account email to see if it matches the order forms customer phone number or first name and last name or email address so we know the customer actually checked out then once this happens the database will send the order to the New writing assignments section. If the database notices that customer name or order description matches again from a previous order it will not send that order to the New writing assignments section unless the order description is different that the customer inputed in the order form or if it's the next business day. If the customer wants to order multiple orders they must input different order descriptions each time. This way the database will see this as a new order. Lets say the customer fills the order form out 3 times but doesn't check out but then the 4th time they do the database will send the most recent order form to the New writing assignments section.
*This database will be for multiple writing sites so make sure I can use this for [url removed, login to view] and [url removed, login to view] and all orders will be sent to 1 database.
*When a admin logs in their top and bottom navi bar will have change , they will have more buttons to select. This way writers and proofers don't click on any of those pages.
*All emailing conversations will be stored that writers do.
*Writer managers and regional managers and the owner have access to all the emails of the writers / proofers.
*Regional manager and owner have access to hiring managers emails.
*The database will store all customers email in special section only the owner can access.
*When an order is sent to the database and is sitting and hasn't been taken by a writer after 2 hours it will start blinking red.
*When an order is sent to the database and is sitting and hasn't been taken by a writer after its due date it will be in solid red.
*Only regional , writing managers , owner when they click on an order / essay in any of the sections will be able to see customers email address and name and contact info, writers /proofers can only see customer first name and last name.
Job Type:
* PHP
* MySQL
* CSS
ID do Projeto: #2110015
