Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak
Technology stack
Back-end: Laravel 10 (REST API, Artisan Console, Service Layer Architecture)
Database: MySQL 8
Documentation: Swagger (OpenAPI)
Other tools: Laravel Scheduler (Cron), Laravel Sanctum (authentication), Laravel Livewire Tables (admin panel), Laravel Excel, GuzzleHttp

- Brief description
Developed a web system for collecting, storing, and managing draft laws from the open data of the Verkhovna Rada of Ukraine. The system also provides a REST API for interaction with front-end applications.

- Key features
1. Data parsing from the Verkhovna Rada API
Integration with data.rada.gov.ua
Regular data updates via Artisan commands and Laravel Scheduler (cron).
Processing of JSON and TSV formats (plenary votes, list of deputies, draft laws, etc.).

2. Saving structure in the database
The project implements the storage of separated entities: draft laws, deputies, votes, factions, plenary sessions.
Relational relationships (hasMany, belongsToMany) are used for correct report and analytics construction.

3. Administrative panel
Built on the basis of Laravel Livewire Tables.

CRUD implemented for managing:
draft laws,
deputies,
factions,
votes.
Filters, sorting, pagination, and search added.

4. REST API for the frontend
A full-fledged API built for interaction with the public frontend (React/Next.js).
All requests are secured with tokens via Laravel Sanctum.

The API implements:
retrieving a list of draft laws,
viewing information on a draft law,
filtering by topics, factions, dates,
retrieving voting results and deputy activity.

5. Swagger documentation
Integrated Swagger-UI for convenient viewing and testing of the API.
Automated documentation generation through PHPDoc comments.
Documentation covers all main routes, request types, and validation.

- My role
Designing the database structure.
Implementing the API parser and storage logic.
Creating the admin panel with Livewire and DataTables.

Building a secure REST API.
Testing functionality.
Writing Swagger documentation.

- Result
The system allows automating the process of monitoring the activities of the Verkhovna Rada, storing historical data, and creating customized queries for the frontend application or analytical purposes.
Work details
Budget 2000 USD
Added 1 April 2025
139 views
Freelancer
Oleksii Lopulenko
Ukraine Odessa
No reviews

Available for hire Available for hire
On the service 7 years