- package org.jleaf.erp.sdm.bo.employeesupervisor;
- import java.util.List;
- import javax.persistence.*;
- import org.jleaf.common.CommonConstants;
- import org.jleaf.erp.sdm.dao.EmployeeSupervisorDao;
- import org.jleaf.core.AbstractBusinessFunction;
- import org.jleaf.core.BusinessFunction;
- import org.jleaf.core.Dto;
- import org.jleaf.core.GeneralConstants;
- import org.jleaf.util.DtoUtil;
- import org.jleaf.core.annotation.ErrorList;
- import org.jleaf.core.annotation.Info;
- import org.jleaf.core.annotation.InfoIn;
- import org.jleaf.core.annotation.InfoOut;
- import org.jleaf.core.dao.QueryBuilder;
- import org.jleaf.util.ValidationUtil;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.jleaf.core.dao.CriteriaHelper;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.stereotype.Service;
- import org.jleaf.erp.sdm.SdmConstants;
- @Service
- @InfoIn(value={
- @Info(name = "tenantId", type = Long.class, description = "Tenant Id", required = true),
- @Info(name = "tenantLoginId", type = Long.class, description = "Tenant Login Id", required = true),
- @Info(name = "userLoginId", type = Long.class, description = "User Login Id", required = true),
- @Info(name = "roleLoginId", type = Long.class, description = "Role Login Id", required = true),
- @Info(name = "datetime", type = String.class, description = "Datetime", required = true),
- @Info(name = "limit", type = Long.class, description = "Limit", required = true),
- @Info(name = "offset", type = Long.class, description = "Offset", required = true),
- @Info(name = "nik", type = String.class, description = "Nik", required = false),
- @Info(name = "supervisor_id", type = String.class, description = "Supervisor_id", required = false)
- })
- @InfoOut(value ={
- @Info(name = "employeeSupervisorList", type = List.class, description = "Employee Supervisor List(id,version,nik,name,supervisorId,supervisorName)",
- required = true)
- })
- @ErrorList(errorKeys={})
- public class GetEmployeeSupervisorList extends AbstractBusinessFunction implements BusinessFunction {
- private static final Logger log = LoggerFactory.getLogger(GetEmployeeSupervisorList.class);
- @Autowired
- private EmployeeSupervisorDao employeeSupervisorDao;
- @SuppressWarnings("unchecked")
- @Override
- public Dto execute(Dto inputDto) throws Exception {
- ValidationUtil.valDtoContainsKey(inputDto,"tenantId");
- ValidationUtil.valDtoContainsKey(inputDto,"tenantLoginId");
- ValidationUtil.valDtoContainsKey(inputDto,"userLoginId");
- ValidationUtil.valDtoContainsKey(inputDto,"roleLoginId");
- ValidationUtil.valDtoContainsKey(inputDto,"datetime");
- ValidationUtil.valDtoContainsKey(inputDto,"limit");
- ValidationUtil.valDtoContainsKey(inputDto,"offset");
- ValidationUtil.valDtoContainsKey(inputDto,"nik");
- ValidationUtil.valDtoContainsKey(inputDto,"supervisor_id");
- Long tenantId = inputDto.getLong("tenantId");
- Long tenantLoginId = inputDto.getLong("tenantLoginId");
- Long userLoginId = inputDto.getLong("userLoginId");
- Long roleLoginId = inputDto.getLong("roleLoginId");
- String datetime = inputDto.getString("datetime");
- Long limit = inputDto.getLong("limit");
- Long offset = inputDto.getLong("offset");
- String nik = inputDto.getString("nik");
- String supervisor_id = inputDto.getString("supervisor_id");
- QueryBuilder builder = new QueryBuilder();
- builder.add(" SELECT A.employee_supervisor_id, A.version, B.nik, B.name, A.supervisor_id, C.name AS supervisorName ");
- builder.add(" FROM hr_employee_spv A ");
- builder.add(" INNER JOIN hr_employee B ON A.employee_id = B.employee_id ");
- builder.add(" INNER JOIN hr_employee C ON A.supervisor_id = C.employee_id ");
- builder.add(" WHERE true ");
- builder.addIfNotEmpty( nik, new QueryBuilder().add(" AND ( ").add(CriteriaHelper.likeExpressionIgnoreCase(nik,"B.nik")).add(" OR ").add(CriteriaHelper.likeExpressionIgnoreCase(nik,"B.name")).add(")").toString());builder.addIfNotEmpty( supervisor_id, new QueryBuilder().add(" AND ( ").add(CriteriaHelper.likeExpressionIgnoreCase(supervisor_id,"A.supervisor_id")).add(")").toString());
- builder.add(" LIMIT :limit OFFSET :offset ");
- log.debug("Query {} --> {}", getClass().getSimpleName(), builder);
- Query query = employeeSupervisorDao.createNativeQuery(builder.toString());
- query.setParameter("limit", limit);
- query.setParameter("offset", offset);
- List<Object[]> result = query.getResultList();
- List<Dto> list = DtoUtil.createDtoListFromArray(result , "id" , "version" , "nik" , "name" , "supervisorId" , "supervisorName" );
- return new Dto().putList("employeeSupervisorList", list);
- }
- @Override
- public String getDescription() {
- return "Get Employee Supervisor List";
- }
- }
[text] BF GetList
Viewer
*** This page was generated with the meta tag "noindex, nofollow". This happened because you selected this option before saving or the system detected it as spam. This means that this page will never get into the search engines and the search bot will not crawl it. There is nothing to worry about, you can still share it with anyone.
Editor
You can edit this paste and save as new:
File Description
- BF GetList
- Paste Code
- 15 Jun-2021
- 4.73 Kb
You can Share it:
Latest Code Pastes