QueryWrapper<SrmMdmSupplierAll> query = new QueryWrapper<>();
query.eq("DISABLED", Constant.EnabledOrDisabled.ENABLED);
query.eq("EMPLOYEE_CODE", CurrentUserHolder.getCurrentEmployeeCode());
if (StringUtils.isNotEmpty(queryCommonVo.getKeywords())) {
query.and(wrapper -> wrapper.like("VENDOR_FULL_NAME",queryCommonVo.getKeywords())
.or()
.like("VENDOR_CODE", queryCommonVo.getKeywords())
.or()
.like("VENDOR_ID",queryCommonVo.getKeywords()));
}
query.orderByDesc("UPDATE_DATE");
控制台打印sql语句如下:
SELECT * FROM SRM_MDM_SUPPLIER_ALL
WHERE DISABLED = 0
AND EMPLOYEE_CODE = '03426'
AND (VENDOR_FULL_NAME LIKE '%1183%' OR VENDOR_CODE LIKE '%1183%' OR VENDOR_ID LIKE '%1183%')