DelphiTools WebPages

Veje mais em https://github.com/RaffaelSchemmer/SistemaVendasBistroCetec

This application was developed , to the CETEC 2019 Bistro Event, that happened in august of 2019 ?? in Flores da Cunha, RS in Brazil.

>> About the Application Architecture and Technologies
The architecture of application was developed to running in three different types of machines and applications. 1?? First machine, are responsible to make a sell. In this machine, we running a Delphi / VCL Windows application. This application implements two complete CRUDs. One, to make a login in the system and two, to make a ticket sell. All the operation of this CRUDs are made using 3 web services (that store DBMS). One WS is related to login. Other WSs are responsible to return some information about the festivity and to receive the data about the selling. This data contains the information about the customer like name/e-mail and others. The aplication are responsible to send a e-mail to customer, that contains a QR-Code ticket of purchase. Our application are security guarantee that all data are encrypted, both in transmission of data as in database storing. 2?? In server (second machine) we have the 5 web services (write in PHP) that response about login, about the festivity and to allow the register a purchase. All this information are stored in a MySQL DBMS. Both Delphi and PHP using the user / password mechanisms guarantee that only the votation machine access the database of votation. The last application 3?? of architecture, is a Delphi/FMX responsible android mobile application that implement two complete CRUDs. One, to make a login in the system and two, to authenticate a ticket. All the operation of this CRUDs are made using 2 web services (that store DBMS). One WS is related to login. Other WSs are responsible to receive a SHA string and to validate that this string is active (nobody uses the QR Ticket) or is inative (somebody uses the QR Ticket one time). If ticket is active, WS turn this ticket inative (put false in DMBS) and return true and the mobile application informs the screen GREEN that allow user to pass. Else, WS turn +1 ocurrence of cheat and return false and the mobile application informs the screen RED that not allow user to pass.

>> Requirements to Installing the Application
In Delphi/VCL application, user need to configure the IPv4, user and password (in source code). This files are availabled in the folder src of project. Remember to recompile the EXE file after this changes. Note that EXE file (only running in windows machines) will read this informations, to call the web service. In the server side you need to run a http service with PHP and a MySQL Server. Remember to import the database.sql of database folder (that create all tables to DB) and to put login.php, insereIngresso.php and consultaIngresso.php in www folder of http service. Lastly, modify the admin and password variables of PHP to match of default user and password defines in MySQL server.