CakeFest 2023 More than soccer and samba PGE Digital, a successful CakePHP project in Rio de Jan

For many years the Attorney General's Office of the State of Rio de Janeiro managed its litigation through physical files, resulting in thousands of sheets of paper wasted every year. Moreover, the control of the judicial term, as well as the legal steps of each case were controlled individually in excel spreadsheets by each attorney. And even with the digitalization of the lawsuits by the State Judiciary, the subpoenas were printed by a central sector and sent to each prosecutor of the case, because there was no integration capable of making them available in an individual way, considering factors such as absence due to vacation or health.
To solve all these problems, we used CakePHP to develop a system called PGE Digital (PGE stands for Procuradoria Geral do Estado do Rio de Janeiro or Rio de Janeiro State Prosecutor's Office in Portuguese) whose goal is to make all the activities of the state public attorney's office 100% digital.
Among the main features of the CakePHP Framework used in this project, we highlight the use of Events to automate the formation of dossiers to accompany the lawsuits as soon as the subpoena is received, as well as the use of Commands for integration routines (via SOAP) with the various Brazilian Courts.
The database used is SQL Server and currently consists of more than 150 tables, all reflected in Entities and Tables for the use of the Framework's ORM, as well as the use of apcu for caching.
In addition, hundreds of Components, Helpers and Behaviours were created to facilitate the reuse of various routines.
Finally, the PGE Digital is a success story in a public agency and is already being taken to other Brazilian states as well.