|  |  |  | 
|---|
|  |  |  | .leftJoin(Member.class,Member::getId,Retention::getMemberId) | 
|---|
|  |  |  | .leftJoin(Member.class,Member::getId,Retention::getMemberId) | 
|---|
|  |  |  | .leftJoin(Company.class,Company::getId,Member::getCompanyId) | 
|---|
|  |  |  | .leftJoin(Category.class,Category::getId,Retention::getCategoryId) | 
|---|
|  |  |  | .selectAs(Company::getCompanyNamePath,Retention::getCompanyName) | 
|---|
|  |  |  | .selectAs(Member::getName,Retention::getName) | 
|---|
|  |  |  | .selectAs(Category::getName,Retention::getCategoryName) | 
|---|
|  |  |  | .selectAs(Member::getPhone,Retention::getPhone) | 
|---|
|  |  |  | .selectAs(Member::getVisitCompanyName,Retention::getVisitCompanyName) | 
|---|
|  |  |  | .and(StringUtils.isNotBlank(pageWrap.getModel().getKeyWords()),w->{ | 
|---|