Implementação de um sistema de gestão de transporte escolar para a Secretaria de Transporte de Campo Mourão

Abstract

This work focused on the development of the backend and frontend of part of a management system for the Municipal Transportation Department of Campo Mourão, aiming to modernize and decentralize the process of issuing and administering school transport identification cards. The proposal seeks to address recurrent problems in the current workflow, such as difficulties in validating student eligibility, the dependence on tacit knowledge concentrated in a single staff member, and the lack of standardized mechanisms to associate students with bus routes and pickup points. The system aims to provide greater agility, transparency, and autonomy to operators, enabling tasks ranging from the registration of students and guardians to eligibility analysis and the georeferenced definition of pickup points through interactive maps. The system is divided into modules, and this work concentrated on implementing the API and the interface responsible for managing essential entities such as schools, service provider companies, academic calendars, user profiles, and card application requests. On the backend, technologies such as NestJS, TypeScript, PostgreSQL with TypeORM, Zod for validation, and Jest for E2E testing were used, in addition to automated documentation with Swagger, following principles of modular and service-oriented architecture. On the frontend, developed with Next.js, React, Zod, React Query for request handling, and Leaflet for map rendering and manipulation were employed, with a focus on enhancing the operator’s experience when selecting routes and pickup points. The development activities were organized according to the Kanban methodology, with version control and repository management on GitHub. The source code is available in the repositories of the Center for Software Development and Applied Artificial Intelligence Competencies (CCDSIAA). Although some functionalities planned for this stage—such as full card export and complete eligibility validation—were not fully completed, the application request flow and the initial evaluation step have already been implemented, resulting in a functional, testable system with a solid foundation for continued development. This initiative represents a technological solution aligned with the real needs of the Municipal Transportation Department, contributing directly to greater efficiency, standardization, and modernization of school transport management in the municipality.