Dashboard PHP
Dashboard developed with PHP, JS, HTML and CSS with SQL DB
Overview
The Painel SAC is a development designed to address the needs of the Customer Service department, providing a tool that allows customers to register online 24 hours a day. It serves as a bridge between a web form (WordPress) and an internal ERP system called Logix. The web form is used by customers to open Customer Service requests. When the user submits the completed form, it communicates with a REST API (Python - Flask), which validates the customer's data and inserts it into the database. If the customer's CPF (Brazilian identification number) is not already in the database, it creates a new customer entry with all the necessary security measures to comply with the LGPD (Brazilian General Data Protection Law). The Painel SAC runs internally and is used to query customer data, perform various validations, and insert Customer Service requests into the ERP system.
Features
- Online customer registration 24/7
- Integration between a WordPress web form and Logix ERP system
- REST API (Python - Flask) for data validation and database insertion
- Creation of new customer entries if CPF is not already in the database
- Compliance with LGPD regulations
- Internal Painel for customer data querying and validations
- Dashboard with graphical representation of data