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