protected EmpPersonalDetails toUnwrappedModel(EmpPersonalDetails empPersonalDetails) {
    if (empPersonalDetails instanceof EmpPersonalDetailsImpl) {
      return empPersonalDetails;
    }

    EmpPersonalDetailsImpl empPersonalDetailsImpl = new EmpPersonalDetailsImpl();

    empPersonalDetailsImpl.setNew(empPersonalDetails.isNew());
    empPersonalDetailsImpl.setPrimaryKey(empPersonalDetails.getPrimaryKey());

    empPersonalDetailsImpl.setEmpPersonalDetailsId(empPersonalDetails.getEmpPersonalDetailsId());
    empPersonalDetailsImpl.setEmployeeId(empPersonalDetails.getEmployeeId());
    empPersonalDetailsImpl.setGroupId(empPersonalDetails.getGroupId());
    empPersonalDetailsImpl.setCompanyId(empPersonalDetails.getCompanyId());
    empPersonalDetailsImpl.setUserId(empPersonalDetails.getUserId());
    empPersonalDetailsImpl.setCreateDate(empPersonalDetails.getCreateDate());
    empPersonalDetailsImpl.setModifiedDate(empPersonalDetails.getModifiedDate());
    empPersonalDetailsImpl.setFirstName(empPersonalDetails.getFirstName());
    empPersonalDetailsImpl.setLastName(empPersonalDetails.getLastName());
    empPersonalDetailsImpl.setMiddleName(empPersonalDetails.getMiddleName());
    empPersonalDetailsImpl.setEmployeeNo(empPersonalDetails.getEmployeeNo());
    empPersonalDetailsImpl.setOtherId(empPersonalDetails.getOtherId());
    empPersonalDetailsImpl.setLicenseNo(empPersonalDetails.getLicenseNo());
    empPersonalDetailsImpl.setLicenseExpDate(empPersonalDetails.getLicenseExpDate());
    empPersonalDetailsImpl.setGender(empPersonalDetails.getGender());
    empPersonalDetailsImpl.setMaritalStatus(empPersonalDetails.getMaritalStatus());
    empPersonalDetailsImpl.setNationalityId(empPersonalDetails.getNationalityId());
    empPersonalDetailsImpl.setDateOfBirth(empPersonalDetails.getDateOfBirth());

    return empPersonalDetailsImpl;
  }
  /**
   * Returns an ordered range of all the EmpPersonalDetailses where employeeId = ?.
   *
   * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances.
   * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result
   * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start
   * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}
   * will return the full result set. If <code>orderByComparator</code> is specified, then the query
   * will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and
   * pagination is required (<code>start</code> and <code>end</code> are not {@link
   * com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default
   * ORDER BY logic from {@link com.rknowsys.eapp.hrm.model.impl.EmpPersonalDetailsModelImpl}. If
   * both <code>orderByComparator</code> and pagination are absent, for performance reasons, the
   * query will not have an ORDER BY clause and the returned result set will be sorted on by the
   * primary key in an ascending order.
   *
   * @param employeeId the employee ID
   * @param start the lower bound of the range of EmpPersonalDetailses
   * @param end the upper bound of the range of EmpPersonalDetailses (not inclusive)
   * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
   * @return the ordered range of matching EmpPersonalDetailses
   * @throws SystemException if a system exception occurred
   */
  @Override
  public List<EmpPersonalDetails> findByemployeeId(
      long employeeId, int start, int end, OrderByComparator orderByComparator)
      throws SystemException {
    boolean pagination = true;
    FinderPath finderPath = null;
    Object[] finderArgs = null;

    if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) {
      pagination = false;
      finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_EMPLOYEEID;
      finderArgs = new Object[] {employeeId};
    } else {
      finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_EMPLOYEEID;
      finderArgs = new Object[] {employeeId, start, end, orderByComparator};
    }

    List<EmpPersonalDetails> list =
        (List<EmpPersonalDetails>) FinderCacheUtil.getResult(finderPath, finderArgs, this);

    if ((list != null) && !list.isEmpty()) {
      for (EmpPersonalDetails empPersonalDetails : list) {
        if ((employeeId != empPersonalDetails.getEmployeeId())) {
          list = null;

          break;
        }
      }
    }

    if (list == null) {
      StringBundler query = null;

      if (orderByComparator != null) {
        query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 3));
      } else {
        query = new StringBundler(3);
      }

      query.append(_SQL_SELECT_EMPPERSONALDETAILS_WHERE);

      query.append(_FINDER_COLUMN_EMPLOYEEID_EMPLOYEEID_2);

      if (orderByComparator != null) {
        appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator);
      } else if (pagination) {
        query.append(EmpPersonalDetailsModelImpl.ORDER_BY_JPQL);
      }

      String sql = query.toString();

      Session session = null;

      try {
        session = openSession();

        Query q = session.createQuery(sql);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(employeeId);

        if (!pagination) {
          list = (List<EmpPersonalDetails>) QueryUtil.list(q, getDialect(), start, end, false);

          Collections.sort(list);

          list = new UnmodifiableList<EmpPersonalDetails>(list);
        } else {
          list = (List<EmpPersonalDetails>) QueryUtil.list(q, getDialect(), start, end);
        }

        cacheResult(list);

        FinderCacheUtil.putResult(finderPath, finderArgs, list);
      } catch (Exception e) {
        FinderCacheUtil.removeResult(finderPath, finderArgs);

        throw processException(e);
      } finally {
        closeSession(session);
      }
    }

    return list;
  }