Software and systems
Project status
Interested
Posted at
Location
Budget
Posted by
Description:
To develop the requested system, you can structure the project in two parts: the server, using Horse, and the mobile app, with the three main screens (customer search, product and stock query, and order creation). I will detail the approach for each part:
Backend (Horse Server)
Horse Server Configuration:
Create a basic server in Delphi using Horse.
Add a route to handle customers, products, stock, and orders.
Use the "datasetserialise" libraries to serialize datasets in json and "restrequest4delphi" to perform http requests.
Use Boss to facilitate the management of dependencies and libraries.
Connection to MySQL:
Configure the connection to the company's existing MySQL database.
The host field should be configurable, allowing the app to find the local server on the client.
Suggested endpoints:
/clientes: To search for and list customers (using the partner table).
/Products: To query products and stock (products and prodestq tables).
/Orders: To create and manage orders and quotes (pedprodnf, pedprodnfs, pedprodnfobs tables).
User Validation:
Create a middleware to validate users through the users table when starting the application.
Frontend (Mobile App)
Customer Search Screen:
A simple screen to search for customers with basic filters (name, CPF/CNPJ).
Use the /clientes endpoint to retrieve data from the database.
Product and Stock Query Screen:
Display products with the amount of stock available.
Use the /products endpoint to search for the list and stock.
Sales Order/Quote Screen:
Allow customer and product selection.
Create an order or quote, sending the data to the server via the /orders endpoint.
Host Configuration:
Include a configuration screen in the app so that the user can configure the server host.
Tools Used:
Boss: To manage the libraries, add datasetserialise and restrequest4delphi.
Datasetserialise: To manipulate datasets and convert them to JSON.
Restrequest4delphi: To facilitate HTTP calls between the app and the server.
Do you know a someone who is a good fit for the project? Earn commission by referring freelancers! For every signup you get € 5 directly in your account and when the freelancer is hired through the platform you earn 2 % of the earnings of this freelancer!
Fill in the details of the pro you'd like to recommend:
When the freelancer accepts the invitation this freelancer will automatically be added to your network and you'll earn 2 % over all earnings by this freelancer through the platform. For more information see our Terms and conditions
{{ item.displayDisciplines }}
No interested freelancers yet
{{item.displayDisciplines}}
You have a stand-by account and already responded to 1 project in this subscription period.
Upgrade your account now with just 1 click and respond to unlimited projects.