I need help from a PHP developer to create a Mobile Responsive website.
The purpose of this website is to allow Cafe/Restaurant owners (Users) view live sales stats and a sales report of the business. User accounts are hosted a online MYSQL and Data for Reports are drawn from LOCAL MYSQL DB.
1. User Account Management
1.1 Administrator can creates/modify/delete users with an option to disable the login
1.2 1 User can hold Multiple Sites. Eg, one business owner can have multiple restaurants.
1.3 User - Name, Username, Password, Enable (Y/N), Blocked (Y/N), Note
1.4 Site - IP, DBUsername, DBPassword, DBPort, Enable (Y/N)
1.5 User will login with Username and Password to view Dashboard.
1.6 User has to select a site name if the user has more than one site.
1.7 Option to Switch between Sites for a User to access multiple sites.
1.8 Password abuse protection by account block after “n” number of attempts. (open for suggestions)
2. Dashboard (after login)
Information will drawn from a local database on cafe or restaurant POS. We will port-forward.
Sales Today - Amount and Number of Sales today (Yesterday in small fonts)
This Week - Amount and Number of Sales (Last week in small fonts)
This Month - Amount and Number of Sales (Last month in small fonts)
3. Menu TAB1 - Sales Report (by Category)
Fields - Category Name, Qty, Price, Discounts, Tax, Total
Filters - Date-Time, Customer, User, Category
Date/Time Filter to have quick select options where applicable - Today, Yesterday, This Month, Last Month, Custom From and To Date and Time
Grand Total (Qty, Price, Discounts, Tax, Total)
Option to Download (CSV) Report.
I will provide the Hosting space/Domain
User account management DB for (1) is created here in this hosting space.
You will have a study the MYSQL of the POS system to extract information as information need to be extracted using multiple Tables. I will provide a Sample DB.
I need 3 milestones. Funds only be released upon "completion" of each stage.
1. Create Database, Create Administrator to Mange Users
2. Create the User Login and Dashboard
3. Create a Report (Tab1) with Filters and Total
64 freelancers are bidding on average $330 for this job
We already have built same Point of Sale (POS) applications for many industries. Some of them can be found in our freelancer portfolio and website [url removed, login to view] Ready to discuss it briefly with you.