[jira] [Commented] (FINERACT-46) Throw an exception if staff to be deactivated is attached to an entity with status enum id not equal to 600

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/FINERACT-46?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15397387#comment-15397387
 ] 

ASF GitHub Bot commented on FINERACT-46:
----------------------------------------

Github user nazeer1100126 commented on a diff in the pull request:

    https://github.com/apache/incubator-fineract/pull/170#discussion_r72601974
  
    --- Diff: 
fineract-provider/src/main/java/org/apache/fineract/organisation/staff/domain/StaffRepository.java
 ---
    @@ -27,10 +27,36 @@
     
         public final static String FIND_BY_OFFICE_QUERY = "select s from Staff 
s where s.id = :id AND s.office.id = :officeId";
     
    +    public final static String 
IS_ANY_ACTIVE_ENTITY_ASSOCIATED_WITH_STAFF_QUERY = "select " +
    --- End diff --
    
    Instead of adding a native query in StaffRepository, add new method in 
StaffReadPlatformService and use JDBC template to run this query


> Throw an exception if staff to be deactivated is attached to an entity with 
> status enum id not equal to 600
> -----------------------------------------------------------------------------------------------------------
>
>                 Key: FINERACT-46
>                 URL: https://issues.apache.org/jira/browse/FINERACT-46
>             Project: Apache Fineract
>          Issue Type: Improvement
>            Reporter: Emmanuel Nnaa
>            Assignee: Markus Geiss
>
> Throw an exception if staff to be deactivated is attached to an entity with 
> status enum id not equal to 600.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)