| | |
| | | if (pageWrap.getModel().getAuditStatus() != null) { |
| | | queryWrapper.eq(DriverInfo::getAuditStatus, pageWrap.getModel().getAuditStatus()); |
| | | } |
| | | // 性别(根据身份证第17位判断) |
| | | if (pageWrap.getModel().getGender() != null) { |
| | | if (pageWrap.getModel().getGender() == 1) { |
| | | queryWrapper.apply("CAST(SUBSTRING(t.IDCARD, 17, 1) AS UNSIGNED) % 2 = 1"); |
| | | } else if (pageWrap.getModel().getGender() == 2) { |
| | | queryWrapper.apply("CAST(SUBSTRING(t.IDCARD, 17, 1) AS UNSIGNED) % 2 = 0"); |
| | | } |
| | | } |
| | | // 创建日期范围 |
| | | if (pageWrap.getModel().getCreateTimeStart() != null) { |
| | | queryWrapper.ge(DriverInfo::getCreateTime, Utils.Date.getStart(pageWrap.getModel().getCreateTimeStart())); |