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#
  @}