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