Please read carefully before you bid:
MySQL database has these tables:
Business_Group, Check_In, Customer, Picture, Prize, Prize_Claim, Store, Store_status, Sign_ups
Each Business_Group can have 1 or more Store (think McDonald's as a Business_Group, it can have many Store locations). Basically when the customer checkin at a store, they receive ONE point, after they receive N points, they can redeem for a Prize. (store owner can set the N)
The check_in table contains which customer checked-in at which store at which time.
We have the customer checkin side done already, Basically I need about 7 PHP pages for the store owner dashboard/panel:
Attached zip has 3 images.
1) see [url removed, login to view], basically the store owner can see how many customer check-in at what time, those graphs should be done using a nice looking graphic library (eg. the mockup uses [url removed, login to view], or you can use something nice looking).
2) see [url removed, login to view], store owner can add/edit/delete prizes (eg. they can add/edit/delete a offer that says redeem a free Burger for 10 points), it should allow upload picture of the prize
3) see [url removed, login to view], Store owner can send email to the Customers who have Check_in at the store before. Store owner can choose who to send to using a dropdown (eg. All customer, or just customer that visited in the last week). We need to log how many emails they sent at what time.
4) Store owner profile page (eg. change email/password/store logo image)
5) Sign up (just capture email address to table Sign_ups)
6) Sign in
7) Forgot password
On top of this, I need a separate log of these things done by the store owner as they happen in log_tables:
- send email
- view analytics
- add/edit/delete prizes
This should be done using 2 parts:
1)a REST API (eg. api/get_checkin will take a logintoken and return JSON for checkin data for the logged in store)
Because later on we want to make iPhone/Android apps so we will need a API anyway.
For the frontend, we really care about user experience, so we should see nice graphes and transitions (eg. nice looking popup confirmation when emails are sent, or when edits to deals are made, etc...) It needs to work in all browsers.
We need everything (API+Frontend) done by July 7th, I will need to see your proposed set of API functions (stating the proposed URL, input, and expected outputs) within 48 hours (MUST deliver this in 48 hours) to make sure we understand completely what's needed. Only bid if you can finish on time.
Please reply or message me on how you plan to build the API (eg. framework or just a REST Util library?) I don't really care as long as it works.
I will provide database schema to the accepted bidder.
23 freelancer đang chào giá trung bình $1257 cho công việc này
We have all the required designer and developer you are looking for and can allocate dedicated resources for your project. You will be very happy and satisfied of our services.