queryByCondtion
===

    select 
    u.id,u.code,u.name,u.password,u.create_time,u.org_id,u.state,
    u.job_type1,u.job_type0,u.del_flag,u.update_time,u.attachment_id,
    o.name org_name
    from core_user u left join core_org o on u.org_id=o.id where 1=1 and u.del_flag = 0 
    @if(!isEmpty(orgId)){
        and  u.org_id =#orgId#
    @}
     @if(!isEmpty(orgId)){
        and  u.org_id =#orgId#
    @}
    @if(!isEmpty(code)){
        and  u.code like #"%"+code+"%"#
    @}
    @if(!isEmpty(name)){
        and  u.name like #"%"+name+"%"#
    @}
    @if(!isEmpty(state)){
        and  u.state = #state#
    @}
    @if(!isEmpty(jobType0)){
        and  u.job_type0= #jobType0#
    @}
    @if(!isEmpty(jobType1)){
        and  u.job_type1= #jobType1#
    @}
     @if(!isEmpty(startTime)){
            and  u.create_time>= str_to_date(#startTime#,"%Y-%m-%d")
     @}
     @if(!isEmpty(endTime)){
            and  u.create_time< str_to_date(#endTime#,"%Y-%m-%d")
     @}
     union all
     select a.id,a.account_no as code,a.partner_name as name,a.password,a.create_time,a.org_id,a.state,a.job_type1,a.job_type0,a.del_flag,
     a.update_time,a.attachment_id,o.name org_name from xzx_city_partner a
     left join core_org o on a.org_id=o.id where 1=1 and a.del_flag = 0
     @if(!isEmpty(orgId)){
             and  u.org_id =#orgId#
         @}
          @if(!isEmpty(orgId)){
             and  u.org_id =#orgId#
         @}
         @if(!isEmpty(code)){
             and  u.code like #"%"+code+"%"#
         @}
         @if(!isEmpty(name)){
             and  u.name like #"%"+name+"%"#
         @}
         @if(!isEmpty(state)){
             and  u.state = #state#
         @}
         @if(!isEmpty(jobType0)){
             and  u.job_type0= #jobType0#
         @}
         @if(!isEmpty(jobType1)){
             and  u.job_type1= #jobType1#
         @}
          @if(!isEmpty(startTime)){
                 and  u.create_time>= str_to_date(#startTime#,"%Y-%m-%d")
          @}
          @if(!isEmpty(endTime)){
                 and  u.create_time< str_to_date(#endTime#,"%Y-%m-%d")
          @}
     LIMIT #page#, #limit#
    
    
queryByCondtionCount
===
    select count(k.id) from (
       select 
           u.id as id
           from core_user u left join core_org o on u.org_id=o.id where 1=1 and u.del_flag = 0 
           @if(!isEmpty(orgId)){
               and  u.org_id =#orgId#
           @}
            @if(!isEmpty(orgId)){
               and  u.org_id =#orgId#
           @}
           @if(!isEmpty(code)){
               and  u.code like #"%"+code+"%"#
           @}
           @if(!isEmpty(name)){
               and  u.name like #"%"+name+"%"#
           @}
           @if(!isEmpty(state)){
               and  u.state = #state#
           @}
           @if(!isEmpty(jobType0)){
               and  u.job_type0= #jobType0#
           @}
           @if(!isEmpty(jobType1)){
               and  u.job_type1= #jobType1#
           @}
            @if(!isEmpty(startTime)){
                   and  u.create_time>= str_to_date(#startTime#,"%Y-%m-%d")
            @}
            @if(!isEmpty(endTime)){
                   and  u.create_time< str_to_date(#endTime#,"%Y-%m-%d")
            @}
         union all
             select a.user_id as id from xzx_city_partner a
             left join core_org o on a.org_id=o.id where 1=1 and a.del_flag = 0
             @if(!isEmpty(orgId)){
                     and  u.org_id =#orgId#
                 @}
                  @if(!isEmpty(orgId)){
                     and  u.org_id =#orgId#
                 @}
                 @if(!isEmpty(code)){
                     and  u.code like #"%"+code+"%"#
                 @}
                 @if(!isEmpty(name)){
                     and  u.name like #"%"+name+"%"#
                 @}
                 @if(!isEmpty(state)){
                     and  u.state = #state#
                 @}
                 @if(!isEmpty(jobType0)){
                     and  u.job_type0= #jobType0#
                 @}
                 @if(!isEmpty(jobType1)){
                     and  u.job_type1= #jobType1#
                 @}
                  @if(!isEmpty(startTime)){
                         and  u.create_time>= str_to_date(#startTime#,"%Y-%m-%d")
                  @}
                  @if(!isEmpty(endTime)){
                         and  u.create_time< str_to_date(#endTime#,"%Y-%m-%d")
                  @}    
    )k
batchDelUserByIds
===
    update core_user set del_flag = 1 where id in( #join(ids)#)
    
batchUpdateUserState
===
    update core_user set state = #state# where id in( #join(ids)#)
    
queryUserRole
===

* 查询用户所有权限

    select	
    ur.*, u.code as user_code,
    u.name as user_name,
    org.name as org_name, role.name as role_name
    from core_user_role ur
    left join core_org org on org.id = ur.org_id
    left join core_user u on u.id = ur.user_id
    left join core_role role on role.id = ur.role_id
    where u.id=#id# 
    @if(isNotEmpty(orgId)){
    	and org.id=#orgId#
    @}
    @if(isNotEmpty(roleId)){
    	and role.id=#roleId#
    @}