batchDelByIds

update core_org set u.del_flag = 1 where u.id in( #join(ids)#)

queryByCondtion

select 
@pageTag(){
o.*
@}
from core_org o where 1=1 and del_flag = 0
@ //数据权限，组织机构对应的对应的字段
@if(!isEmpty(code)){
    and  o.code like #"%"+code+"%"#
@}
@if(!isEmpty(name)){
    and  o.name like #"%"+name+"%"#
@}
@if(!isEmpty(type)){
    and  o.type = #type#
@}
@if(!isEmpty(parentOrgId)){
    and  o.parent_org_id = #parentOrgId#
@}

@pageIgnoreTag(){
       order by o.id
@}

queryUserByCondtion

 select 
@pageTag(){
u.*,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 
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#
@}