Customer Reporting Dashboard
£250-750 GBP
Betalt ved levering
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.
Name
Logo
Icon
CustomerPermissions - List of permissions for what each user can do, stored as a group and assigned to a user.
GroupName
CanViewReports
CanViewProducts
CanViewStyles
CanViewSales
CanViewExtendedProductDetails
CanViewProductPrices
CanViewStock
CanViewPurchaseOrders
CanViewPayments
CanViewInvoices
User - List of users with access to dashboard. Links to CompanyList, and CustomerPermissions.
Password
FirstName
LastName
Company
Permissions
ServerList - Admin editable list of our online stores. Used to store current online status.
ServerAddress
ServerStatus
LastChecked
ServerStatus - List all checks that have been made. Links to ServerList.
Server
Status
Checked
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.
REPORTING:
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.
Projekt ID: #33973659
Om projektet
102 freelancere byder i gennemsnit £587 timen for dette job
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 Flere
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 Flere
Hello Wish you a great day I have checked your requirements for the project and I am ready to start ASAP. I am a well-experienced PHP developer I have more than 5 years of experience in this field. My skills ar Flere
Hi dear employer, I have read your description and completely understood your Project and want to discuss more. If you need samples of my work, I can also share when you initiate chat. I am all-rounder and can work w Flere
Good Day, As a senior custom Website developer and PHP Expert, I can surely help you develop a fully functional Customer Reporting Dashboard as per your requirement with 100% job satisfaction. Please share complete det Flere
Hi, there. I am an experienced web developer and have previously worked on several management dashboards, so I will provide you quality work according to your instructions. Please contact me so we can start the work ri Flere
***** Laravel would be good for your app ***** Hello.I know you are looking for a PHP expert to build customer management dashboard. I can build your project more efficient with my knowledge and experience. As an enth Flere
Hello, How are you? I have read your description but it seems too long. I have rich experience in PHP admin/user dashboard development for running sales reports. So I can build the dashboard as the example one as you r Flere
Hey there, I’d like to be considered for your project, " Customer Reporting Dashboard". I have rich experiences in HTML, MySQL, SQL, PHP and JavaScript. For 5 years I’ve worked in web development. I have a deep passi Flere
Hey, Yes, understanding each aspect of the job description, I am available to take up this project and I assure you to complete it within a short period. The main advantage of this job is that i have been professio Flere
Would you like this website to be designed as a SPA (Single Page Application) or not? With this feature, the speed of your website will increase a lot. I'm a full-stack website developer. I have +7 years of experience Flere
Hi there! Thank you for sharing your project requirements; I thoroughly read the project description and would like to be a part of it. To ensure the highest level of quality and client satisfaction, I will work in ac Flere
Hi I have 15 years of experience in sql server database development. Mysql and postgress development. I will be able to help you with the project. Please ping me offline to discuss further.
Hello Adrian. I have read your job post you specifically wrote very carefully. I understand your requirement and I have solutions for the project. But I have some questions to complete your project fully. So I want to Flere
Hi I understnad all the details clearly. As a professional engineer with skills including PHP, MySQL, JavaScript, HTML and SQL, I have rich experience so I can help you perfectly Please contact me to discuss moreabout Flere