Example usage for org.springframework.data.mongodb.core.query Query skip

List of usage examples for org.springframework.data.mongodb.core.query Query skip

  1. HOME
  2. Java
  3. org.springframework
  4. org.springframework.data.mongodb.core.query.*
  5. Query
  6. skip

Introduction

In this page you can find the example usage for org.springframework.data.mongodb.core.query Query skip.

Prototype

long skip

To view the source code for org.springframework.data.mongodb.core.query Query skip.

Click Source Link

Usage

From source file:net.cit.tetrad.resource.ManagementResource.java

private PersonJson setPersonJson(int sEcho, CommonDto dto, String tablenm, int pageNumber, int nPerPage) {
    Class<?> classname = managementDao.getDtoClassNm(tablenm);
    String searchGubun = dto.getSearch_gubun();
    String searchText = dto.getSearch_text();

    Query query = new Query();
    if (isSearch(searchGubun, searchText)) {
        query = getSearchQuery(searchGubun, searchText);
    } else {/* w  ww  .j  a  v a  2s. com*/
        query = sortDate(dto.getLoginAuth(), dto.getLoginUserCode(), tablenm);
    }

    int cnt = (int) monadService.getCount(query, classname);
    query.sort().on("groupBind", Order.ASCENDING);
    List<Object> resultList = monadService.getList(query.skip(pageNumber).limit(nPerPage), classname);

    PersonJson result = new PersonJson();
    result.setsEcho(sEcho);
    result.setiTotalRecords(cnt);
    result.setiTotalDisplayRecords(cnt);
    result.setAaData(resultList);

    return result;
}

From source file:net.cit.tetrad.resource.ManagementResource.java

private PersonJson setPersonGroupJson(int sEcho, CommonDto dto, String tablenm, int pageNumber, int nPerPage) {
    Class<?> classname = managementDao.getDtoClassNm(tablenm);
    String searchGubun = dto.getSearch_gubun();
    String searchText = dto.getSearch_text();

    Query query = new Query();
    if (isSearch(searchGubun, searchText)) {
        query = getSearchQuery(searchGubun, searchText);
    } else {/*www.  j a v a2 s  .c om*/
        query.sort().on("groupBind", Order.ASCENDING);
        //         query.sort().on("reg_date", Order.DESCENDING);
        query.sort().on("groupCode", Order.ASCENDING);
        query.sort().on("deviceCode", Order.ASCENDING);
        query.sort().on("reg_date", Order.DESCENDING);
        //         query = sortDate(dto.getLoginAuth(),dto.getLoginUserCode(),tablenm);
    }

    int cnt = (int) monadService.getCount(query, classname);
    List<Object> resultList = monadService.getList(query.skip(pageNumber).limit(nPerPage), classname);

    PersonJson result = new PersonJson();
    result.setsEcho(sEcho);
    result.setiTotalRecords(cnt);
    result.setiTotalDisplayRecords(cnt);
    result.setAaData(resultList);

    return result;
}

From source file:com.gongpingjia.carplay.service.impl.ActivityServiceImpl.java

/**
 * ???   //from  ww w .j  a v  a 2 s. c om
 * <p/>
 * criteria:
 * city    estabPoint.city
 * phone ? phone user  ? userId   activity
 * fromDate  toDate           createTime
 * pay  -1 ??               ? AA
 * type -1            type ? type
 * transfer  -1       true  false
 *
 * @param json
 * @return
 * @throws ApiException
 */
@Override
public ResponseDo getUserActivityList(JSONObject json, String userId) throws ApiException {
    //TODO?
    int draw = json.getInt("draw");
    int start = json.getInt("start");
    int length = json.getInt("length");

    JSONObject resultJson = new JSONObject();

    Query query = new Query();
    Criteria criteria = new Criteria();

    String startTimeStr = json.getString("fromTime");
    String endTimeStr = json.getString("toTime");
    if (StringUtils.isNotEmpty(startTimeStr) && StringUtils.isNotEmpty(endTimeStr)) {
        long startTime = TypeConverUtil.convertToLong("fromTime", startTimeStr, true);
        long endTime = TypeConverUtil.convertToLong("toTime", endTimeStr, true) + 24 * 60 * 60 * 1000;
        criteria.and("createTime").gte(startTime).lte(endTime);
    }

    String phone = json.getString("phone");
    if (StringUtils.isNotEmpty(phone)) {
        User user = userDao.findOne(Query.query(Criteria.where("phone").is(phone)));
        if (null == user || StringUtils.isEmpty(user.getUserId())) {
            throw new ApiException("???");
        }
        criteria.and("userId").is(user.getUserId());
    }

    criteria.and("deleteFlag").is(false);

    String province = json.getString("province");
    if (StringUtils.isNotEmpty(province)) {
        criteria.and("destination.province").is(province);
    }

    String city = json.getString("city");
    if (StringUtils.isNotEmpty(city)) {
        criteria.and("destination.city").is(city);
    }

    String majorType = json.getString("majorType");
    if (StringUtils.isNotEmpty(majorType)) {
        criteria.and("majorType").is(majorType);
    }

    String type = json.getString("type");
    if (StringUtils.isNotEmpty(type) && !StringUtils.equals(type, "-1")) {
        criteria.and("type").is(type);
    }

    String pay = json.getString("pay");
    if (StringUtils.isNotEmpty(pay) && !StringUtils.equals(pay, "-1")) {
        criteria.and("pay").is(pay);
    }

    String transferStr = json.getString("transfer");
    if (StringUtils.isNotEmpty(transferStr) && !StringUtils.equals(transferStr, "-1")) {
        criteria.and("transfer").is(TypeConverUtil.convertToBoolean("transfer", transferStr, true));
    }

    query.addCriteria(criteria);

    long totalNum = activityDao.count(query);

    query.with(new Sort(new Sort.Order(Sort.Direction.DESC, "createTime")));
    query.skip(start).limit(length);
    List<Activity> activityList = activityDao.find(query);

    resultJson.put("draw", draw);
    resultJson.put("recordsFiltered", totalNum);
    resultJson.put("recordsTotal", totalNum);

    if (null == activityList || activityList.isEmpty()) {
        return ResponseDo.buildSuccessResponse(resultJson);
    }

    Set<String> userIdSet = new HashSet<>(activityList.size());
    for (Activity activity : activityList) {
        userIdSet.add(activity.getUserId());
    }

    List<User> userList = userDao.findByIds(userIdSet);

    Map<String, User> userMap = new HashMap<>(userList.size());
    if (null == userList || userList.isEmpty()) {
        throw new ApiException(" ??");
    }
    for (User user : userList) {
        userMap.put(user.getUserId(), user);
    }

    JSONArray jsonArray = new JSONArray();
    for (Activity activity : activityList) {
        JSONObject item = new JSONObject();
        item.put("activityId", activity.getActivityId());
        item.put("nickname", userMap.get(activity.getUserId()).getNickname());
        item.put("phone", userMap.get(activity.getUserId()).getPhone());
        item.put("establish", activity.getEstablish());
        item.put("destination", activity.getDestination());
        item.put("type", activity.getType());
        item.put("pay", activity.getPay());
        item.put("transfer", activity.isTransfer());
        item.put("createTime", activity.getCreateTime());
        item.put("cover", userDao.getCover(activity.getCover(), activity.getUserId()));

        jsonArray.add(item);
    }
    resultJson.put("activityList", jsonArray);

    return ResponseDo.buildSuccessResponse(resultJson);
}

From source file:org.slc.sli.dal.repository.MongoEntityRepository.java

/**
 * @Deprecated "This is a deprecated method that should only be used by the ingestion ID
 *             Normalization code.// ww  w  .  j  a  v  a2  s  .  c o m
 *             It is not tenant-safe meaning clients of this method must include tenantId in the
 *             metaData block"
 */
@Override
@Deprecated
@MigrateEntityCollection
public Iterable<Entity> findByQuery(String collectionName, Query origQuery, int skip, int max) {
    Query query = origQuery == null ? new Query() : origQuery;

    query.skip(skip).limit(max);

    if (subDocs.isSubDoc(collectionName)) {
        return subDocs.subDoc(collectionName).findAll(query);
    }

    return findByQuery(collectionName, query);
}

From source file:org.slc.sli.dal.repository.MongoRepository.java

/**
 * @Deprecated// w  ww  . j  a  v a 2 s .  co m
 *             "This is a deprecated method that should only be used by the ingestion ID
 *             Normalization code.
 *             It is not tenant-safe meaning clients of this method must include tenantId in the
 *             metaData block"
 */
@Override
@Deprecated
public Iterable<T> findByQuery(String collectionName, Query origQuery, int skip, int max) {
    Query query = origQuery == null ? new Query() : origQuery;

    query.skip(skip).limit(max);

    return findByQuery(collectionName, query);
}

From source file:piecework.repository.concrete.ProcessInstanceRepositoryCustomImpl.java

@Override
public Page<ProcessInstance> findByQueryParameters(Set<String> processDefinitionKeys,
        SearchQueryParameters queryParameters, Pageable pageable, Sanitizer sanitizer) {
    // Otherwise, look up all instances that match the query
    Query query = SearchUtility.query(queryParameters, processDefinitionKeys, sanitizer);
    query.skip(pageable.getOffset());
    query.limit(pageable.getPageSize());

    org.springframework.data.mongodb.core.query.Field field = query.fields();

    // Don't include form data in the result unless it's requested
    //        if (! criteria.isIncludeVariables())
    field.exclude("data");

    return findByQuery(query, pageable, true);
}

From source file:vn.chodientu.service.ItemCrawlLogService.java

public DataPage<ItemCrawlLog> search(ItemCrawlLogSearch logSearch) {
    String itemId = logSearch.getItemId();
    String sellerId = logSearch.getSellerId();
    long timeFrom = logSearch.getTimeFrom();
    long timeTo = logSearch.getTimeTo();
    int status = logSearch.getStatus();
    String imgStatus = logSearch.getImageStatus();
    String type = logSearch.getType();
    int pageIndex = logSearch.getPageIndex();
    int pageSize = logSearch.getPageSize();

    Criteria cri = new Criteria();
    if (itemId != null && !itemId.equals("")) {
        cri.and("itemId").is(itemId);
    }//from  w w  w  .  ja v  a  2s . co m
    if (sellerId != null && !sellerId.equals("")) {
        cri.and("sellerId").is(sellerId);
    }
    if (imgStatus != null && !imgStatus.equals("")) {
        switch (imgStatus) {
        case "NO_IMAGE":
            cri.and("imageStatus").is(CrawlImageStatus.NO_IMAGE);
            break;
        case "WAIT_DOWNLOAD":
            cri.and("imageStatus").is(CrawlImageStatus.WAIT_DOWNLOAD);
            break;
        case "DOWNLOAD_SUCCESS":
            cri.and("imageStatus").is(CrawlImageStatus.DOWNLOAD_SUCCESS);
            break;
        case "DOWNLOAD_FAIL":
            cri.and("imageStatus").is(CrawlImageStatus.DOWNLOAD_FAIL);
            break;
        case "SMALL_IMAGE":
            cri.and("imageStatus").is(CrawlImageStatus.SMALL_IMAGE);
            break;
        default:
            break;
        }
    }
    if (type != null && !type.equals("")) {
        switch (type) {
        case "ADD":
            cri.and("type").is(CrawlType.ADD);
            break;
        case "EDIT":
            cri.and("type").is(CrawlType.ADD);
            break;
        default:
            break;
        }
    }
    switch (status) {
    case 0: //everrun
        cri.and("status").is(false);
        break;
    case 1: //running
        cri.and("status").is(true);
        break;
    default:
        break;
    }

    if (timeFrom > 0 && timeTo > 0) {
        cri.and("time").gte(timeFrom).lt(timeTo);
    } else if (timeFrom > 0) {
        cri.and("time").gte(timeFrom);
    } else if (timeTo > 0) {
        cri.and("time").lt(timeTo);
    }
    if (pageIndex <= 0) {
        pageIndex = 0;
    }
    if (pageSize <= 0) {
        pageSize = 50;
    }
    Query query = new Query(cri);
    query.skip(pageIndex * pageSize).limit(pageSize);
    query.with(new Sort(Sort.Direction.DESC, "time"));
    //
    DataPage<ItemCrawlLog> dataPage = new DataPage<>();
    dataPage.setData(crawlLogRepository.find(query));
    dataPage.setPageIndex(pageIndex);
    dataPage.setPageSize(pageSize);
    dataPage.setDataCount(crawlLogRepository.count(query));
    dataPage.setPageCount(dataPage.getDataCount() / pageSize);
    try {
        List<String> listItemIds = new ArrayList<>();
        for (ItemCrawlLog crawlLog : dataPage.getData()) {
            if (crawlLog.getItemId() != null && !crawlLog.getItemId().equals("")) {
                listItemIds.add(crawlLog.getItemId());
            }
            List<String> errMsg = new ArrayList<>();
            List<String> alertMsg = new ArrayList<>();
            for (String errcode : crawlLog.getErrorCode()) {
                errMsg.add(ErrorUtils.getErrorMessage(errcode));
            }
            for (String alertCode : crawlLog.getAlertCode()) {
                alertMsg.add(ErrorUtils.getAlertMessage(alertCode));
            }
            crawlLog.setErrorMessage(errMsg);
            crawlLog.setAlertMessage(alertMsg);
        }
        List<Item> listItems = itemService.list(listItemIds);
        for (ItemCrawlLog crawlLog : dataPage.getData()) {
            for (Item item : listItems) {
                if (item.getId().equals(crawlLog.getItemId())) {
                    crawlLog.setItem(item);
                }
            }
            for (KeyVal64 keyval : crawlLog.getRequest()) {
                String value = StringUtils.newStringUtf8(Base64.decodeBase64(keyval.getValue()));
                if (value != null && !value.equals("")) {
                    value = value.trim();
                }
                keyval.setValue(value);
            }
        }
    } catch (Exception ex) {
        return dataPage;
    }
    return dataPage;

}