mongoDB dao

MongoCursor<Document> cursor = null;
List<UserAcqInfo> list = new ArrayList<UserAcqInfo>();
MongoCollection<Document> coll = getCollection(dbName+"_"+100000100, collName_acq);
BasicDBObject where = new BasicDBObject();

if(StringUtils.isNotEmpty(searchQuery.getUserId())){
    where.put("imUserId",  Long.parseLong(searchQuery.getUserId()));
}

if(startTime != 0L && endTime != 0L){
    where.put("traceId", new BasicDBObject("$gte",startTime).append("$lt",endTime + 60 * 60 * 24l));
} else if(startTime != 0L){
    where.put("traceId", new BasicDBObject("$gte",startTime));
} else if(endTime != 0L){
    where.put("traceId", new BasicDBObject("$lt",endTime + 60 * 60 * 24l));
}
        
if(startTime != 0L && endTime != 0L){
    where.append(QueryOperators.AND, new BasicDBObject[]{
            new BasicDBObject().append("traceId",
                    new BasicDBObject().append(QueryOperators.GTE, startTimeL)),
            new BasicDBObject().append("traceId",
                    new BasicDBObject().append(QueryOperators.LT, endTimeL))});
} else if (startTimeL!=0L){
    where.put("traceId", new BasicDBObject().append(QueryOperators.GTE, startTimeL));
} else if (endTimeL!=0L){
    where.put("traceId", new BasicDBObject().append(QueryOperators.LT, endTimeL));
}

long count = coll.count(where);
Bson sort = new BasicDBObject("traceId", -1);
pageInfo.setTotalResult((int)count);
pageInfo.calculate();
if(count <= 0){
    return list;
}

cursor = coll.find(where).sort(sort).skip((pageInfo.getCurrentPage() - 1) * pageInfo.getPageSize()).limit(pageInfo.getPageSize()).iterator();

log.info("DBName:"+dbName+"_100000100"+"; collName:"+collName+"; filter:"+where.toJson().toString());

while (cursor.hasNext()) {
    Document item = cursor.next();
    UserAcqInfo userAcqInfo = (UserAcqInfo) BeanTransUtils.document2Bean(item, UserAcqInfo.class);
    list.add(userAcqInfo);
}
return list;