| | |
|---|
| | | if (StrUtil.isNotBlank(vo.getFileName())){ |
|---|
| | | queryWrapper.like("acc.filesName", vo.getFileName()); |
|---|
| | | } |
|---|
| | | queryWrapper.orderByAsc("a.deptName,a.empName"); |
|---|
| | | if (StrUtil.equals(vo.getField(),"empName")){ |
|---|
| | | if (StrUtil.equals(vo.getOrder(),"descending")){ |
|---|
| | | queryWrapper.orderByDesc("a.empName"); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.orderByAsc("a.empName"); |
|---|
| | | } |
|---|
| | | }else if(StrUtil.equals(vo.getField(),"empNumb")){ |
|---|
| | | if (StrUtil.equals(vo.getOrder(),"descending")){ |
|---|
| | | queryWrapper.orderByDesc("a.empNumb"); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.orderByAsc("a.empNumb"); |
|---|
| | | } |
|---|
| | | }else if(StrUtil.equals(vo.getField(),"deptName")){ |
|---|
| | | if (StrUtil.equals(vo.getOrder(),"descending")){ |
|---|
| | | queryWrapper.orderByDesc("deptName"); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.orderByAsc("deptName"); |
|---|
| | | } |
|---|
| | | }else if(StrUtil.equals(vo.getField(),"jobName")){ |
|---|
| | | if (StrUtil.equals(vo.getOrder(),"descending")){ |
|---|
| | | queryWrapper.orderByDesc("a.jobName"); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.orderByAsc("a.jobName"); |
|---|
| | | } |
|---|
| | | }else if(StrUtil.equals(vo.getField(),"certificateNumb")){ |
|---|
| | | if (StrUtil.equals(vo.getOrder(),"descending")){ |
|---|
| | | queryWrapper.orderByDesc("a.certificateNumb"); |
|---|
| | | }else{ |
|---|
| | | queryWrapper.orderByAsc("a.certificateNumb"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | queryWrapper.groupBy(" a.delFlag,a.empName,a.empStatus,a.empId,a.certificateNumb,a.empNumb,deptName,a.jobName"); |
|---|
| | | Page<EmpAccessory> page = new Page<>(request.getPageNum(), request.getPageSize()); |
|---|
| | | // String querySql = empAccessoryMapper.getQuerySql(); |
|---|
