SolPresControl

The java purist enterprise application

Ever found yourself having to keep track of multiple accounting presentations? It's a tedious task, but by using SolPresControl you will only need to login, create a call in for the documents you require, and wait for your registered accountants to turn them in. With no hassle in between, the app keeps track of all the necessary roles and their corresponding permissions:

• Administrators
• General Supervisors
• The supervisors of every accountant
• The accountants

Features

Administrators 💻

• Manage every single detail of any call-in, presentation, or user

General Supervisors 👩‍💼

• Schedule new document call-ins
• Assign supervisors to every accountant

Supervisors 👮

• Supervise your assigned municipalities and accountants
• Keep track of the documents that they have turned in

Accountants 💼

• Create presentations to open call-ins
• Keep track of all the documents that you need to turn in
• Turn in additional documents if needed

Data in the cloud

• When this application was initially used and developed, all data was stored and recovered from Google Cloud Platform. That doesn't mean that you can't use other cloud services or DBMS. You can use any MySQL database without changing the code. And even if you want to use an noSQL one like MongoDB, you can! The only thing you need to do (given that you already have the database running somewhere) is to implement the necessary repositories, and that's it! Nothing else in the code needs to be changed, the magic of interfaces, am I right?

Requirements

• Maven 3.8.4
• JDK 17
• A database server with the schema that's contained in the resources folder. (I used a MySQL one, if you decide to change that, be sure to check if the dialect is the same, don't forget to change the properties file as well)

Data model

• If you need to change the persistence layer to use another kind of database (Maybe a no SQL one) you would need to change the repository layer and implement the following data model in your desired DBMS:

• Spanish cheat sheet:

• Roles: Roles
• Nombre: Name
• Identificador: Identifier
• Clave: Password
• Categoria: Category
• Supervisor: Supervisor
• Representate: Delegate
• Autor: Author
• Municipio: Municipality
• Convocatoria: Call-in
• Documentos: Documents
• Fecha: Date
• Cierre: Closing
• Apertura: Opening
• Opciones: Options
• Usuarios: Users
• Presentacion: Presentations

Take a look at it

Note: Code is spanish-based [Code comments and variable names]