Customer management dashboard where customers can run reports on their sales data. Dashboard must be built with PHP.
We are looking to achieve something similar to this: [login to view URL]
Data will be uploaded from Sage200 and from three separate databases. Script must include ability to import this data and save it to a database using a queue system. Additional column on each table should be used to store which database the information has come from.
Sample SQL can be provided where needed..
Table data that will be imported is:
AlternativeItem - Lists products alternative items
AnalysisCode - Analysis code names
AnalysisCodeMapping - Maps analysis codes to SOP, POP, SL, or Stock Items
AnalysisCodeValue - Analysis code values
DocumentStatus - Lists all possible documents status
POPOrderReturn - Header information for purchase orders
POPOrderReturnLine - Detailed line information for purchase orders
POPReceiptReturn - Header information for purchase order receipts
POPReceiptReturnLine - Detailed line information for purchase order receipts
SLCustomerAccount - Customer account details
SLCustomerContact - Customer contact details
SOPAdditionalCharge - List of additional charges
SOPDespatchReceipt - Header information for despatches
SOPDespatchReceiptLine - Detailed line information for despatches
SOPDocDelAddress - List of delivery addresses
SOPInvCredAddress - List of invoice addresses
SOPInvCredDelAddress - List of invoice delivery addresses
SOPInvoiceCredit - Header information for invoices
SOPInvoiceCreditLine - Detailed line information for invoices
SOPOrderReturn - Header information for sales orders
SOPOrderReturnLine - Detailed line information for sales orders
StockItem - Detailed list of stock items
Include cards to show server status of all websites. Check status of all stores every 5 mins and update ServerList entity with current status and date/time last checked.
Server Status Cards Should Include:
Cards to link to each platform if clicked.
Can add this to the menu bar or top bar.
On hover show when last checked.
Dashboard must also have an entity for:
CompanyList - Admin editable list of companies which a user can be associated with. Will be used in generating reports to display on company data the user is associated to.
CustomerPermissions - List of permissions for what each user can do, stored as a group and assigned to a user.
User - List of users with access to dashboard. Links to CompanyList, and CustomerPermissions.
ServerList - Admin editable list of our online stores. Used to store current online status.
ServerStatus - List all checks that have been made. Links to ServerList.
Must include a login system where the user HAS to be logged in to view the dashboard. All other users are redirected to the login page. New accounts should be created from an admin page.
List all part shipped orders and their items, added into a pivot table. Data from all warehouses.
List all part shipped orders and their items, added into a pivot table. Data from a specific warehouse (add [login to view URL] to WHERE clause).
List all part shipped orders and their items and include when stock is expected to arrive into warehouse (will also need to join POPOrderReturn and POPOrderReturnLine tables and return [login to view URL]).
PERFORMANCE DASHBOARD (see images):
List total spend by region, displayed as a chart.
List total orders received by region, displayed as a chart.
List orders despatched by age.
List order despatch status.
List total orders received.
List age of orders not despatched.
102 freelanceri licitează în medie 587£ pentru acest proiect
Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 11+ years of software experience in fortune 500 com Mai multe
Hello, Warm Greetings!! I read your job description completely, and I found my skills relevant to your project. I am a professional web developer with 7 years of programming experience for a multitude of different Mai multe
Hi, Greeting ⭐⭐⭐ [login to view URL] (Portfolio) ⭐⭐⭐ I am proficient in web dashboard development I have good experience of 4+ years in this field and I have done a few projects similar to yours successfully. I Mai multe
Dear Sir, Greetings! -> This is really a nice project as we have already worked on multiple similar project, this looks doable to us. -> We can start on an immediate basis -> Kindly manage to get us the Website acces Mai multe
HI There, I can Develop your Customer management dashboard where customers can run reports on their sales data. Dashboard built with PHP. I'm PHP/MySql Developer thinking out of the box. I have 7 years of experience in Mai multe
We have viewed all the description and interested to design dashboard with all required functions. Please open Message box so that we discuss it in detail. Check some websites of our work [login to view URL] lumin8a Mai multe