| | |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public void deleteById(Integer id) { |
|---|
| | | retentionMapper.deleteById(id); |
|---|
| | | retentionMapper.update(null,new UpdateWrapper<Retention>().lambda().set(Retention::getIsdeleted,Constants.ONE).eq(Retention::getId,id)); |
|---|
| | | // retentionMapper.deleteById(id); |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | |
|---|
| | | queryWrapper.selectAll(Retention.class) |
|---|
| | | .selectAs(Company::getName,Retention::getCompanyName) |
|---|
| | | .select(" ( SELECT v.company_name FROM visits v WHERE v.member_id = t.member_id and v.status = "+Constants.VisitStatus.signin+" ORDER BY create_date DESC limit 1 ) as visitCompanyName "); |
|---|
| | | queryWrapper.like(number,Retention::getPhone,pageWrap.getModel().getKeyWords()) |
|---|
| | | queryWrapper.eq(Retention::getIsdeleted,Constants.ZERO) |
|---|
| | | .like(number,Retention::getPhone,pageWrap.getModel().getKeyWords()) |
|---|
| | | .like((b||hasWord),Retention::getName,pageWrap.getModel().getKeyWords()) |
|---|
| | | .eq(Objects.nonNull(pageWrap.getModel().getType()), |
|---|
| | | Retention::getType, |
|---|
