{"id":60,"date":"2025-09-24T14:50:55","date_gmt":"2025-09-24T06:50:55","guid":{"rendered":"http:\/\/wp.buildyou.top\/?p=60"},"modified":"2025-09-24T17:57:43","modified_gmt":"2025-09-24T09:57:43","slug":"%e9%9c%80%e6%b1%82%ef%bc%9a%e4%bd%bf%e7%94%a8mongotemplate%e6%9f%a5%e8%af%a2%e9%9b%86%e5%90%88usertrade%e8%bf%87%e6%bb%a4%e9%87%8d%e5%a4%8d%e6%95%b0%e6%8d%ae","status":"publish","type":"post","link":"https:\/\/wp.buildyou.top\/index.php\/2025\/09\/24\/%e9%9c%80%e6%b1%82%ef%bc%9a%e4%bd%bf%e7%94%a8mongotemplate%e6%9f%a5%e8%af%a2%e9%9b%86%e5%90%88usertrade%e8%bf%87%e6%bb%a4%e9%87%8d%e5%a4%8d%e6%95%b0%e6%8d%ae\/","title":{"rendered":"\u9700\u6c42\uff1a\u4f7f\u7528mongoTemplate\u67e5\u8be2\u96c6\u5408UserTrade,\u8fc7\u6ee4\u91cd\u590d\u6570\u636e"},"content":{"rendered":"\n

\u9700\u6c42\uff1a\u4f7f\u7528mongoTemplate\u67e5\u8be2\u96c6\u5408UserTrade\u6570\u636e\uff0c1.\u67e5\u8be2\u6761\u4ef6\u4e3aassetNoList\uff08\u5b57\u6bb5assetNo\u96c6\u5408\uff09\u3001idList\uff08_id\u96c6\u5408\uff09\u53castate=1\u30022.\u8fc7\u6ee4\u91cd\u590d\u6570\u636e\uff0c\u53ea\u6309assetNo\u8fc7\u6ee4\uff0c3.\u8003\u8651assetNoList\u6216idList\u6709\u53ef\u80fd\u4e3a\u7a7a\uff0c4.\u589e\u52a0\u9700\u6c42\uff0cUserTrade\u96c6\u5408\u6709\u5341\u51e0\u4e2a\u5f88\u591a\u5b57\u6bb5\uff0c\u800c\u6211\u53ea\u9700\u8981\u8fd4\u56de_id\u3001assetNo\u3001userId\u3001templateId\u3001templateName\u3001remarks\u3001tradeNo\u8fd9\u51e0\u4e2a\u5b57\u6bb5\u5373\u53ef\u30025.\u5bf9\u4e8e\u91cd\u590d\u6570\u636e\u884c\uff0cpoint\u8fd4\u56de\u96c6\u5408points\uff0c\u5176\u4ed6\u6761\u4ef6\u4e0d\u53d8<\/p>\n\n\n\n

\/\/ 1. \u52a8\u6001\u6784\u5efa\u67e5\u8be2\u6761\u4ef6\uff08\u5904\u7406\u7a7a\u5217\u8868\uff09
Criteria criteria = Criteria.where(\"state\").is(Constant.DEL_FLAG_NORMAL);
if (idList != null && !idList.isEmpty() && !idList.stream().allMatch(Objects::isNull)) {
    criteria = criteria.and(\"_id\").in(idList);
} else if (assetNoList != null && !assetNoList.isEmpty()) {
    criteria = criteria.and(\"assetNo\").in(assetNoList);
}

\/\/ 2. \u805a\u5408\u6846\u67b6\u5b9e\u73b0\u53bb\u91cd\u548c\u5b57\u6bb5\u6295\u5f71
Aggregation aggregation = Aggregation.newAggregation(
        Aggregation.match(criteria),
        Aggregation.group(\"assetNo\")
                .first(\"_id\").as(\"originalId\")  \/\/ \u4fdd\u7559\u539f\u59cb_id
                .first(\"assetNo\").as(\"assetNo\")
                .first(\"userId\").as(\"userId\")
                .first(\"templateId\").as(\"templateId\")
                .first(\"templateName\").as(\"templateName\")
                .first(\"remarks\").as(\"remarks\")
                .first(\"tradeNo\").as(\"tradeNo\")
                .push(\"$point\").as(\"points\"),
        Aggregation.project(\"assetNo\", \"userId\", \"templateId\", \"templateName\", \"remarks\", \"tradeNo\")
                .and(\"originalId\").as(\"_id\")  \/\/ \u6062\u590d\u539f\u59cb_id
                .andInclude(\"points\")  \/\/ \u5982\u679c\u9700\u8981points
);

\/\/ 3. \u6267\u884c\u805a\u5408\u67e5\u8be2\u5e76\u6620\u5c04\u7ed3\u679c
AggregationResultsresults = mongoTemplate.aggregate(aggregation,\"userTrade\",UserTrade.class);
Listlist = results.getMappedResults();
if(ListUtils.isEmpty(list)){
    continue;
}<\/pre>\n\n\n\n
UserTrade\u5b9e\u4f53\u7c7b<\/p>\n\n\n\n
@Data
@Builder
public class UserTrade {

    \/**
     * \u4e3b\u952eid
     *\/
    private String _id;
    \/**
     * \u4ea4\u6613\u7f16\u53f7
     *\/
    @JsonSerialize(using = ToStringSerializer.class)
    private Long tradeNo;

    \/**
     * \u8d44\u4ea7\u7f16\u53f7
     *\/
    private Long assetNo;
    \/**
     * \u5458\u5de5\u7528\u6237id
     *\/
    private String userId;

    \/**
     * \u767b\u5f55\u8d26\u53f7
     *\/
    private String username;

    \/**
     * \u624b\u673a\u53f7
     *\/
    private String phone;

    \/**
     * \u59d3\u540d
     *\/
    private String name;

    \/**
     * \u5b50\u6a21\u677fid
     *\/
    private Long templateId;

    \/**
     * \u5b50\u6a21\u677f\u540d\u79f0
     *\/
    private String templateName;

    \/**
     * \u5145\u503c\u91d1\u989d
     *\/
    private BigDecimal point;

    \/**
     * \u5269\u4f59\u91d1\u989d
     *\/
    private BigDecimal surplusPoint;

    \/**
     * \u64a4\u56de\u72b6\u6001(0-\u5df2\u64a4\u56de\uff0c1-\u672a\u64a4\u56de\uff09
     *\/
    private Integer state;

    private String stateName;
    \/**
     * \u8fc7\u671f\u65f6\u95f4
     *\/
    private Date expireTime;

    \/**
     * \u4ea4\u6613\u65f6\u95f4
     *\/
    private Date gmtCreate;

    \/**
     * \u4ea4\u6613\u5907\u6ce8
     *\/
    private String remarks;

    \/**
     * \u51bb\u7ed3\u72b6\u6001
     *\/
    private Integer freezeState;

    \/**
     * \u51bb\u7ed3\u72b6\u6001\u540d\u79f0
     *\/
    private String freezeStateName;

    \/**
     * \u7b7e\u540d\u9886\u53d6\u72b6\u6001 0 \u672a\u9886\u53d6  1 \u5df2\u9886\u53d6
     *\/
    private Integer collectState;

    private String collectStateValue;
    \/**
     * \u622a\u6b62\u9886\u53d6\u65f6\u95f4
     *\/
    private Date collectExpireTime;

    \/**
     * \u9886\u53d6\u65f6\u95f4
     *\/
    private Date collectTime;

    \/**
     * \u5206\u914d\u7f16\u53f7\uff08\u6fc0\u6d3b\u5361\u4e13\u6709\uff09
     *\/
    private String allotNumber;

    \/**
     * \u652f\u51fa\u65f6\u95f4
     *\/
    private Date paidTime;

    \/**
     * \u6fc0\u6d3b\u5361\u5361\u53f7
     *\/
    private String assetAccount;

    \/**
     * \u7ed3\u7b97\u7c7b\u578b
     *\/
    private Integer settType;

    \/**
     * \u7ed3\u7b97\u7c7b\u578b 1.\u5148\u7ed3 2.\u540e\u7ed3
     *\/
    private String settTypeName;

    \/**
     * \u8f6c\u5165\u8f6c\u51fa\u64cd\u4f5c\u7684
     * \u539f\u59cb\u6279\u6b21\u7f16\u53f7\uff08reTradeNo\uff0c\u8f6c\u5165\u8bb0\u5f55\u5219\u4e3a\u4ece\u54ea\u4e2a\u6279\u6b21\u8f6c\u5165\u7684\u4ea4\u6613\u7f16\u53f7\uff1b
     * \u8f6c\u51fa\u8bb0\u5f55\u5219\u4ece\u81ea\u5df1\u7684\u54ea\u4e2a\u6279\u6b21\u8f6c\u51fa\u7684\u4ea4\u6613\u7f16\u53f7\uff09
     *\/
    private String reTradeNo;

    \/**
     * \u76ee\u6807\/\u6765\u6e90\u8d44\u4ea7\u7f16\u53f7\uff08reAssetNo,\u8f6c\u5165=\u4ece\u54ea\u6765\uff0c\u8f6c\u51fa=\u5230\u54ea\u53bb\uff09
     *\/
    private Long reAssetNo;

    \/*************************\u6279\u91cf\u64a4\u56de\u7279\u6709\u5b57\u6bb5**************************\/

    private Listpoints;
}<\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u9700\u6c42\uff1a\u4f7f\u7528mongoTemplate\u67e5\u8be2\u96c6\u5408UserTrade\u6570\u636e\uff0c1.\u67e5\u8be2\u6761\u4ef6\u4e3aassetNoList\uff08\u5b57\u6bb5 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"class_list":["post-60","post","type-post","status-publish","format-standard","hentry","category-mongdb"],"_links":{"self":[{"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/posts\/60","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/comments?post=60"}],"version-history":[{"count":7,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/posts\/60\/revisions"}],"predecessor-version":[{"id":77,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/posts\/60\/revisions\/77"}],"wp:attachment":[{"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/media?parent=60"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/categories?post=60"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.buildyou.top\/index.php\/wp-json\/wp\/v2\/tags?post=60"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}