ANPAD - Events System with User Control

Client
National Association of Postgraduate Studies and Research in Administration (ANPAD) 

Area
Associations

Summarized Problem
ANPAD's need for a system for its website with event information, whose data was in a PostgreSQL database that should be migrated to MySQL. Such a system should have a series of features, for example, registration of users from different groups, and tools for registering for events and staging. 

Summarized Solution
The data migration from ANPAD events system occurred efficiently from PostgreSQL technology to MySQL using the PHP language by Visionnaire's specialized team. Today, ANPAD has a centralized tool that allows it to update the events website and has resources such as user categories, event registrations and room allocation with programming generation. 

Results
With the help of Visionnaire, the migration of data from ANPAD events occurred efficiently from PostgreSQL technology to MySQL. With the solution developed in PHP by Visionnaire, ANPAD has a centralized tool that allows updating the events website and has features such as user categories, events registrations and room allocation with schedule generation. 

Technologies
The main technologies used to develop the system were PHP Symfony for Back-end, Doctrine for data persistence, MVC (Model View Controller) as a design pattern, Twig for rendering, Bootstrap for Back-end and MySQL database (with some tables that need to be queried in PostgreSQL). It is worth mentioning that Visionnaire is also a specialist in Laravel, another framework option for systems that use MVC.

Detailed Problem
The National Association of Postgraduate Studies and Research in Administration, ANPAD, was founded in 1976 by the eight postgraduate programs existing at the time in Brazil and aims to promote teaching, research and generation of knowledge in the field of administrative sciences, accounting and related areas in the country. 

ANPAD needed a system for its website with events information, available in Portuguese, English and Spanish and responsive for smartphones, tablets and desktops. The data was in a PostgreSQL database that had to be migrated to MySQL. This was the first need that Visionnaire met.

The administrative system for the ANPAD events website should make it possible to update information on the website, with a series of resources, for example, the registration of users from different groups (Administrators, Division Coordinators, Theme Leaders and Evaluators) and control of the work evaluation flow according to these four levels of user groups. 

It was also necessary to create a website for participants to register for events, and registrations should be parameterized into categories such as Student, Associate etc. Such a site would also need to have the option of sending a file proving the participant's category in order to release specific discounts depending on the category. 

Another need for ANPAD was a system for staging and programming generation, that is, an area for registering available rooms and times for presenting work with staging for presenting works according to the register of available rooms, registering restrictions on days and times of participants, generation of the schedule after testing, and an online system for issuing certificates with a unique validation code. 

Detailed Solution
Visionnaire met all of ANPAD's needs, being responsible for the system that supplies the association's events website. Data from such events, previously stored in a PostgreSQL database, was migrated to MySQL. 

The administrative system developed by Visionnaire with PHP for ANPAD allows the website information to be updated and includes all required resources, such as user categories and control of the work evaluation process according to these categories. 

An event registration website was also created with options for registration categories such as Student, Associate etc., making it possible to send documents proving the participant's category to apply specific discounts according to the category. 

Visionnaire also complied with ANPAD's requirement for a system for allocating rooms and generating programming, including registering rooms and times available for presenting work, allocating work according to available rooms, restrictions on participants' days and times, generation of programming after allocation, and an online system for issuing certificates with unique validation codes. 

Brochure
Case Brochure  

Presentation
Case Presentation