HRMS-INFO – control system for HR-specialists

Project
HRMS-INFO – control system for HR-specialists, automates the process of selection, training of human resources for the implementation of IT projects.

Development environment

Server environment

Data transfer object

Data access object

Service

Controller

Apache Tiles

Hibernate Query Language
role.user.count = select ur.roleName, count(uu)
from UserRoleVO ur
left join ur.userVOs uu
where ur.customer.id like :cust
and (uu is null or uu.customer.id like :cust)
group by ur.roleName
role.user.without = select count(uu)
from UserVO uu
left join uu.userRoleVOs ur
where uu.customer.id like :cust
and (ur is null or ur.customer.id not like :cust
or ur.customer.id is null)
group by uu.customer.id

Web Application