| | |
|---|
| | | //不包含下级组织 |
|---|
| | | queryWrapper.exists(pageWrap.getModel().getCompanyId()!=null,"select (cm.id) from company_member cm where cm.company_id='"+pageWrap.getModel().getCompanyId()+"' and cm.member_id=t.id"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | if(Objects.nonNull(pageWrap.getModel().getIsSendCopy())&&Constants.equalsInteger(Constants.ONE,pageWrap.getModel().getIsSendCopy())){ |
|---|
| | | queryWrapper.apply(" t.id in ( select MEMBER_ID from managers where ISDELETED= 0 and STATUS = 0 and TYPE = 1 ) "); |
|---|
| | | } |
|---|
| | | |
|---|
| | | queryWrapper.orderByAsc(Member::getCreateDate); |
|---|
| | | PageData<Member> record = PageData.from(memberMapper.selectJoinPage(page,Member.class, queryWrapper)); |
|---|
| | | if(record!=null && record.getRecords()!=null){ |
|---|
