| | |
|---|
| | | queryWrapper.le(Company::getFsDate, Utils.Date.getEnd(pageWrap.getModel().getFsDate())); |
|---|
| | | } |
|---|
| | | queryWrapper.orderByDesc(Company::getCreateDate); |
|---|
| | | queryWrapper.leftJoin("company t1 on t1.id=t.parant_id"); |
|---|
| | | queryWrapper.leftJoin("company t1 on t1.id=t.parent_id"); |
|---|
| | | queryWrapper.selectAll(Company.class) |
|---|
| | | .select("(select count(m.id) from member m where m.COMPANY_ID=t.id and m.ISDELETED=0) ",Company::getCountNum) |
|---|
| | | .select("(select count(m.id) from yw_account m where m.COMPANY_ID=t.id and m.ISDELETED=0)",Company::getAccountNum) ; |
|---|
