Java tutorial
/* * eGov SmartCity eGovernance suite aims to improve the internal efficiency,transparency, * accountability and the service delivery of the government organizations. * * Copyright (C) 2017 eGovernments Foundation * * The updated version of eGov suite of products as by eGovernments Foundation * is available at http://www.egovernments.org * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see http://www.gnu.org/licenses/ or * http://www.gnu.org/licenses/gpl.html . * * In addition to the terms of the GPL license to be adhered to in using this * program, the following additional terms are to be complied with: * * 1) All versions of this program, verbatim or modified must carry this * Legal Notice. * Further, all user interfaces, including but not limited to citizen facing interfaces, * Urban Local Bodies interfaces, dashboards, mobile applications, of the program and any * derived works should carry eGovernments Foundation logo on the top right corner. * * For the logo, please refer http://egovernments.org/html/logo/egov_logo.png. * For any further queries on attribution, including queries on brand guidelines, * please contact contact@egovernments.org * * 2) Any misrepresentation of the origin of the material is prohibited. It * is required that all modified versions of this material be marked in * reasonable ways as different from the original version. * * 3) This license does not grant any rights to any user of the program * with regards to rights under trademark law for use of the trade names * or trademarks of eGovernments Foundation. * * In case of any queries, you can reach eGovernments Foundation at contact@egovernments.org. * */ package org.egov.pims.commons.service; import org.apache.log4j.Logger; import org.egov.eis.entity.EmployeeView; import org.egov.infra.admin.master.entity.User; import org.egov.infra.admin.master.service.AppConfigValueService; import org.egov.infra.admin.master.service.UserService; import org.egov.infra.exception.ApplicationRuntimeException; import org.egov.pims.commons.Designation; import org.egov.pims.commons.Position; import org.egov.pims.commons.dao.PositionMasterDAO; import org.egov.pims.dao.PersonalInformationHibernateDAO; import org.egov.pims.model.PersonalInformation; import org.egov.pims.utils.EisManagersUtill; import org.hibernate.HibernateException; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.type.IntegerType; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import java.util.ArrayList; import java.util.Date; import java.util.Iterator; import java.util.List; /** * @author Venkatesh.M.J * @version 1.2 * @since 1.2 */ @Service("eisCommonsService") public class EisCommonsServiceImpl implements EisCommonsService { private static final Logger logger = Logger.getLogger(EisCommonsServiceImpl.class); @Autowired private UserService userService; @Autowired private PositionMasterDAO positionMasterDAO; @Autowired private PersonalInformationHibernateDAO pimsDao; @Autowired private AppConfigValueService appConfigValuesService; @PersistenceContext private EntityManager entityManager; public Session getCurrentSession() { return entityManager.unwrap(Session.class); } public void updatePosition(Position position) { try { positionMasterDAO.updatePosition(position); } catch (Exception e) { throw new ApplicationRuntimeException("Exception in deleting Installment." + e.getMessage(), e); } } public Position getPositionById(Integer positionId) { Position pos = null; logger.info("InsidegetPositionById : positionId=" + positionId); try { if (positionId != null) { pos = positionMasterDAO.getPosition(positionId); } return pos; } catch (Exception e) { throw new ApplicationRuntimeException("Exception in deleting Installment." + e.getMessage(), e); } } public Position getPositionByUserId(Long userId) { Position userPosition = null; Date currentDate = new Date(); try { String mainStr = ""; mainStr = " select POS_ID from EG_EIS_EMPLOYEEINFO ev where ev.USER_ID = :userid and ((ev.to_Date is null and ev.from_Date <= :thisDate ) " + " OR (ev.from_Date <= :thisDate AND ev.to_Date >= :thisDate)) and ev.IS_PRIMARY ='Y'"; Query qry = getCurrentSession().createSQLQuery(mainStr).addScalar("POS_ID", IntegerType.INSTANCE); qry.setLong("userid", userId); qry.setDate("thisDate", currentDate); List retList = qry.list(); if (retList != null && !retList.isEmpty()) { Integer posId = null; for (Iterator iter = retList.iterator(); iter.hasNext();) { posId = (Integer) iter.next(); } if (posId != null) { userPosition = getPositionById(posId); } } } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } return userPosition; } public Position getPositionForUserByIdAndDate(Integer userId, Date assignDate) { Position userPosition = null; //PersonalInformation personalInformation = new PersonalInformation(); try { String mainStr = ""; mainStr = " select POS_ID from EG_EIS_EMPLOYEEINFO ev where ev.USER_ID = :userid and ((ev.to_Date is null and ev.from_Date <= :thisDate ) OR (ev.from_Date <= :thisDate AND ev.to_Date > :thisDate))"; Query qry = getCurrentSession().createSQLQuery(mainStr).addScalar("POS_ID", IntegerType.INSTANCE); qry.setInteger("userid", userId); qry.setDate("thisDate", assignDate); List retList = qry.list(); if (retList != null && !retList.isEmpty()) { Integer posId = null; for (Iterator iter = retList.iterator(); iter.hasNext();) { posId = (Integer) iter.next(); } if (posId != null) { userPosition = getPositionById(posId); } } } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } return userPosition; } public User getUserforPosition(Position pos) { User uerImpl = null; try { String mainStr = ""; mainStr = " select USER_ID from EG_EIS_EMPLOYEEINFO ev where ev.POS_ID = :pos and ((ev.to_Date is null and ev.from_Date <= SYSDATE ) OR (ev.from_Date <= SYSDATE AND ev.to_Date > SYSDATE))"; Query qry = getCurrentSession().createSQLQuery(mainStr).addScalar("USER_ID", IntegerType.INSTANCE); if (pos != null) { qry.setEntity("pos", pos); } if (qry.list() != null && !qry.list().isEmpty()) { for (Iterator iter = qry.list().iterator(); iter.hasNext();) { Long userId = (Long) iter.next(); uerImpl = userService.getUserById(userId); } } } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } return uerImpl; } public Boolean isEmployeeAutoGenerateCodeYesOrNo() { String employeeAutoGenCodeYesOrNo = appConfigValuesService.getAppConfigValue("Employee", "EMPAUTOGENERATECODE", "no"); boolean autoGenCode = false; if ("yes".equalsIgnoreCase(employeeAutoGenCodeYesOrNo)) { autoGenCode = true; } return autoGenCode; } public Boolean checkEmpCode(String empCode) { boolean checkEmpCode = false; Query qry = null; try { String main = "from PersonalInformation where employeeCode=:employeeCode"; qry = getCurrentSession().createQuery(main); qry.setString("employeeCode", empCode); if (qry.list() != null && !qry.list().isEmpty()) { checkEmpCode = true; } } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } return checkEmpCode; } public Position getPositionByName(String positionName) { Query qry = null; try { String main = "from Position where name=:positionName"; qry = getCurrentSession().createQuery(main); if (positionName != null && !positionName.equals("")) { qry.setString("positionName", positionName); } return (Position) qry.uniqueResult(); } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } } /** * This method returns the current position id of the user * * @param user the user whose designation is needed. * * * @return the position id as integer */ public Position getCurrentPositionByUser(User user) { Position position = null; try { if (null != user) { PersonalInformation personalInfo = EisManagersUtill.getEmployeeService() .getEmpForUserId(user.getId()); position = EisManagersUtill.getEmployeeService() .getPositionforEmp(personalInfo.getIdPersonalInformation()); } } catch (Exception e) { throw new ApplicationRuntimeException("Exception in getCurrentPositionByUser :" + e.getMessage(), e); } return position; } public User getUserForPosition(Integer posId, Date date) { User user = null; try { String mainStr = ""; mainStr = " select USER_ID from EG_EIS_EMPLOYEEINFO ev where ev.pos_id = :posId and ((ev.to_Date is null and ev.from_Date <= :thisDate ) OR (ev.from_Date <= :thisDate AND ev.to_Date > :thisDate))"; Query qry = getCurrentSession().createSQLQuery(mainStr).addScalar("USER_ID", IntegerType.INSTANCE); qry.setInteger("posId", posId); qry.setDate("thisDate", date); List retList = qry.list(); if (retList != null && !retList.isEmpty()) { Long userId = null; for (Iterator iter = retList.iterator(); iter.hasNext();) { userId = (Long) iter.next(); } if (userId != null) { user = userService.getUserById(userId); } } } catch (HibernateException he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } catch (Exception he) { throw new ApplicationRuntimeException(STR_EXCEPTION + he.getMessage(), he); } return user; } /** * Api to get unique designation based on dept and functionary * @param deptId * @param functionaryId * @return unique designation from view if dept and functionary is 0 * else based on dept and functionary * @throws Exception */ public List<Designation> getDesigantionBasedOnFuncDept(Integer deptId, Integer functionaryId) throws Exception { List<EmployeeView> employeeList = null; List<Designation> desgMstr = new ArrayList<Designation>(); try { String mainStr = ""; String subQry = " from EmployeeView ev "; if (((deptId != null && deptId != 0) && functionaryId == 0)) { subQry += " where ev.deptId = :deptId "; } else if (((functionaryId != null && functionaryId != 0) && deptId == 0)) { subQry += " where ev.functionary =:functionaryId"; } else if (deptId != null && deptId != 0 && functionaryId != null && functionaryId != 0) { subQry += " where ev.deptId = :deptId and ev.functionary =:functionaryId"; } subQry = "select distinct ev.desigId.designationId " + subQry; mainStr = "from Designation dm where dm.id in( " + subQry + " ) "; Query query = getCurrentSession().createQuery(mainStr); if (deptId != null && deptId != 0) { query.setInteger("deptId", deptId); } if (functionaryId != null && functionaryId != 0) { query.setInteger("functionaryId", functionaryId); } desgMstr = (List<Designation>) query.list(); } catch (Exception e) { throw new ApplicationRuntimeException(e.getMessage(), e); } return desgMstr; } /** * Returning temporary assigned employee object by department,designation,functionary,date * @param deptId * @param DesigId * @param functionaryId * @param onDate * @return Employee * @throws Exception */ public PersonalInformation getTempAssignedEmployeeByDeptDesigFunctionaryDate(Integer deptId, Integer desigId, Integer functionaryId, Date onDate) throws Exception { return pimsDao.getTempAssignedEmployeeByDeptDesigFunctionaryDate(deptId, desigId, functionaryId, onDate); } private final static String STR_EXCEPTION = "Exception:"; }