| | |
| | | private Query getQuery(DaoQuery daoQuery){ |
| | | List<Criteria> andList=new ArrayList<>(); |
| | | <#list daoQueryColumnDataList as value> |
| | | <#if (value.type!"") == "Date"> |
| | | if(daoQuery.min${value.columnName?cap_first}!=null){ |
| | | andList.add(Criteria.where("${value.columnName}").gte(daoQuery.min${value.columnName?cap_first})); |
| | | } |
| | | if(daoQuery.max${value.columnName?cap_first}!=null){ |
| | | andList.add(Criteria.where("${value.columnName}").lt(daoQuery.max${value.columnName?cap_first})); |
| | | } |
| | | <#else> |
| | | if(daoQuery.${value.columnName}!=null){ |
| | | <#if (value.queryType!"") == "equal"> |
| | | andList.add(Criteria.where("${value.columnName}").is(daoQuery.${value.columnName})); |
| | | andList.add(Criteria.where("${value.columnData.property}").is(daoQuery.${value.columnName})); |
| | | <#elseif (value.queryType!"") == "gt"> |
| | | andList.add(Criteria.where("${value.columnData.property}").gt(daoQuery.${value.columnName})); |
| | | <#elseif (value.queryType!"") == "gte"> |
| | | andList.add(Criteria.where("${value.columnData.property}").gte(daoQuery.${value.columnName})); |
| | | <#elseif (value.queryType!"") == "lt"> |
| | | andList.add(Criteria.where("${value.columnData.property}").lt(daoQuery.${value.columnName})); |
| | | <#elseif (value.queryType!"") == "lte"> |
| | | andList.add(Criteria.where("${value.columnData.property}").lte(daoQuery.${value.columnName})); |
| | | <#else> |
| | | andList.add(Criteria.where("${value.columnName}").regex(daoQuery.${value.columnName})); |
| | | andList.add(Criteria.where("${value.columnData.property}").regex(daoQuery.${value.columnName})); |
| | | </#if> |
| | | } |
| | | </#if> |
| | | </#list> |
| | | Query query=new Query(); |
| | | Criteria[] ands=new Criteria[andList.size()]; |
| | |
| | | public static class DaoQuery{ |
| | | <#if daoQueryColumnDataList??> |
| | | <#list daoQueryColumnDataList as value> |
| | | <#if (value.type!"") == "Date"> |
| | | public ${value.type} min${value.columnName?cap_first}; |
| | | public ${value.type} max${value.columnName?cap_first}; |
| | | <#else> |
| | | public ${value.type} ${value.columnName}; |
| | | </#if> |
| | | </#list> |
| | | </#if> |
| | | public int start; |