private String getSql(String userId, FilterRequestEntity entity){
String table = DBConstant.TableName.TB_OFFLINE_ASSGININFO;
String sql ="select * from "+ table +" where userId = "+"'"+ userId;
StringBuffer stringBuffer =newStringBuffer(sql);if(entity.getProjectIds()!= null && entity.getProjectIds().length !=0){//项目id组合查询,格式如下//select * from table1 where a [not] in (‘值1’,’值2’,’值4’,’值6’)
String[] projectIds = entity.getProjectIds();
StringBuffer buffer =newStringBuffer();for(int i =0; i < projectIds.length; i++){
buffer.append("'"+ projectIds[i]+"'");if(i != projectIds.length -1){
buffer.append(",");}else{
buffer.append(")");}}
stringBuffer.append(" and projectId in ("+ buffer);}if(!StringUtils.isEmpty(entity.getReformOrderCode())){
String code ="reformOrderCode";//根据编号搜索查询,格式如下//select * from table1 where field1 like ’%value1%’
stringBuffer.append(" and "+ code +" like "+"'%"+ entity.getReformOrderCode()+"%'");}if(!StringUtils.isEmpty(entity.getStartTime())){
String startTime = entity.getStartTime()+" 00:00:00";//根据时间区段查询,格式如下//select * from table1 where time between time1 and time2
stringBuffer.append(" and time >= '"+ startTime +"'");}if(!StringUtils.isEmpty(entity.getEndTime())){
String endTime = entity.getEndTime()+" 23:59:59";
stringBuffer.append(" and time <= '"+ endTime +"'");}return stringBuffer.toString();}