Customer Reporting Dashboard

Lukket Opslået 1 år siden Betalt ved levering
Lukket 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.

Email

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.

PHP MySQL SQL JavaScript HTML

Projekt ID: #33973659

Om projektet

102 bud Remote projekt Aktiv 1 år siden

102 freelancere byder i gennemsnit £587 timen for dette job

vw580939vw

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

£250 GBP in 15 dage
(185 bedømmelser)
7.5
nishthamarwaha

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

£500 GBP in 12 dage
(115 bedømmelser)
7.4
divumanocha

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

£500 GBP in 7 dage
(96 bedømmelser)
7.2
maamekal

Hi There!! No upfront milestone and 24*7 Support With a 100% money-back guarantee. We are here to provide the best quality solution for all your requirements related to: - Websites design and development - Online Sto Flere

£500 GBP in 7 dage
(176 bedømmelser)
7.1
BitLabs

Hello, I have gone through your outsourced requirements " Customer Reporting Dashboard " and have analyzed that I have right skills ( PHP JavaScript SQL MySQL HTML ) to execute your esteemed project. I will com Flere

£250 GBP in 365 dage
(139 bedømmelser)
6.8
ritu9382

Hello  I am ready to start the job immediately! i have well understood your requirement, as well i have read it carefully top to end, as well i would like to let you know that i have worked on the same project as wel Flere

£430 GBP in 7 dage
(131 bedømmelser)
6.9
larrypaul93

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

£500 GBP in 7 dage
(135 bedømmelser)
7.0
inertiasoftltd

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

£1200 GBP in 20 dage
(66 bedømmelser)
6.7
ognjenstev00

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

£700 GBP in 7 dage
(24 bedømmelser)
6.4
LongVuDinh

***** 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

£500 GBP in 7 dage
(25 bedømmelser)
6.0
markmarkkutsenko

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

£500 GBP in 7 dage
(17 bedømmelser)
5.7
vasylivanovych

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

£500 GBP in 7 dage
(5 bedømmelser)
5.5
Apurva510

Hi there! I hope you are doing well. I am a full stack Website/Mobile App Developer and SEO/Digital Marketing expert. I will do this job for you and start work immediately. You will discuss more here with me. Tha Flere

£500 GBP in 7 dage
(25 bedømmelser)
5.7
NEHABHAT92

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

£500 GBP in 7 dage
(38 bedømmelser)
5.4
BarryCrouch

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

£650 GBP in 7 dage
(28 bedømmelser)
4.9
winexsoft

Hey Adrian, I'm a web developer, and I'm very interested in your job post. I have recently worked for a US-based company as a team leader, where my responsibilities included developing their basic Web-based applicatio Flere

£1200 GBP in 60 dage
(29 bedømmelser)
5.0
FaizMirza2021

 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

£299 GBP på 1 dag
(24 bedømmelser)
4.7
bizmanas

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.

£700 GBP in 7 dage
(10 bedømmelser)
4.1
balirkprogrammva

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

£250 GBP in 7 dage
(8 bedømmelser)
4.2
stefanjanko9

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

£555 GBP in 18 dage
(8 bedømmelser)
3.8