Ditutup

Customer Reporting Dashboard

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.

Kemahiran: PHP, MySQL, SQL, JavaScript, HTML

Tentang Klien:
( 5 ulasan ) Watford, United Kingdom

ID Projek: #33973659

102 pekerja bebas membida secara purata £587 untuk pekerjaan ini

(394 Ulasan)
8.9
(749 Ulasan)
9.4
(562 Ulasan)
8.9
seekdeveloper

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 Lagi

£500 GBP dalam 7 hari
(147 Ulasan)
8.9
(650 Ulasan)
8.5
(414 Ulasan)
8.7
(285 Ulasan)
8.3
sapnathakur14

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 Lagi

£700 GBP dalam 7 hari
(148 Ulasan)
8.0
(125 Ulasan)
8.1
(48 Ulasan)
7.8
(270 Ulasan)
7.5
(311 Ulasan)
7.7
sashast

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 Lagi

£500 GBP dalam 7 hari
(16 Ulasan)
7.6
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 Lagi

£250 GBP dalam 15 hari
(185 Ulasan)
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 Lagi

£500 GBP dalam 12 hari
(115 Ulasan)
7.4
(153 Ulasan)
7.4
(84 Ulasan)
7.7
phpdeveloper100

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 Lagi

£786 GBP dalam 30 hari
(86 Ulasan)
7.5
(152 Ulasan)
6.7
(76 Ulasan)
7.1