zhao_js
2024-01-04 6898a19dcf7f52a1f93f8775cdfafc1685b4ee97
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using AlibabaSDK.Api;
using AlibabaSDK.Domain;
using AlibabaSDK.Request;
using CommonUtil;
using CommonUtil.RabbitMQ;
using Operater.DAL;
using Operater.DbModel;
using Operater.DTO.TopMessage;
using static CommonUtil.DbEnum;
 
namespace Api.MessageReceive.Service
{
    public class AliMessageService
    {
        /// <summary>
        /// 消息入库
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public static async Task RecordMessage(BaseAliMessage request)
        {
            try
            {
                AliMsgHistory aliMsgHistory = new AliMsgHistory()
                {
                    Id = TopUtil.GetId().ToString(),
                    MsgId = request.msgId,
                    GmtBorn = request.gmtBorn.ToDateTime(),
                    UserInfo = request.userInfo,
                    MsgType = request.type,
                    CreateTime = DateTime.Now,
                    Data = request.data.ToString()
                };
                new AliMsgHistoryDAL().Insert(aliMsgHistory);
            }
            catch (Exception e)
            {
                LogUtil.Info(e.ToString(), "1688消息入库错误");
            }
        }
 
        /// <summary>
        /// 精选货源商品下架消息
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
 
        public static async Task OfferQuitHandle(BaseAliMessage request)
        {
            try
            {
                OfferQuitData data = JSONUtil.JsonToObject<OfferQuitData>(request.data.ToString());
                //查询是否有关联铺货商品
                var relationList = new DistributionRelationDAL().ListGet(t => t.SourceProduct == data.offerId && t.ReStatus == 1);
                if (relationList.IsNull() || relationList.Count == 0)
                {
                    return;
                }
                //查询商品信息
                var productInfo = new DistributionHistoryDAL().GetFirst(t => t.ProductId == data.offerId, i => new { i.CreateTime }, OrderType.Desc);
                List<ProductUpdateLog> logList = new List<ProductUpdateLog>();
                foreach (var item in relationList)
                {
                    ProductUpdateLog productUpdateLog = new ProductUpdateLog()
                    {
                        Id = TopUtil.GetId().ToString(),
                        CreateTime = DateTime.Now,
                        UpdateContent = "精选货源商品下架",
                        ProductId = data.offerId,
                        MsgType = request.type,
                        ProcessingStatus = 0,
                        YzProductId = item.YzProduct,
                        MsgId = request.msgId
                    };
                    if (!productInfo.IsNull() && !productInfo.Id.IsNullOrEmpty())
                    {
                        productUpdateLog.ProductImg = productInfo.ProImg;
                        productUpdateLog.ProductTitle = productInfo.ProTitle;
                    }
                    logList.Add(productUpdateLog);
                }
                if (!logList.IsNull() && logList.Count > 0)
                {
                    new ProductUpdateLogDAL().InsertRange(logList);
                }
            }
            catch (Exception e)
            {
                LogUtil.Info($"【消息】{JSONUtil.ObjectToJson(request)}--【错误】{e.ToString()}", "1688消息处理失败");
            }
        }
 
       
        /// <summary>
        /// 1688商品库存变更消息(关系用户视角)
        /// </summary>
        /// <param name="request"></param>
        public static async Task InventoryChange(BaseAliMessage request)
        {
            try
            {
                OfferInventoryChangeListModel change = JSONUtil.JsonToObject<OfferInventoryChangeListModel>(request.data.ToString());
                var changeList = change.OfferInventoryChangeList;
                var list = changeList.Where(t => t.skuOnSale <= 50).ToList();
                if (list.IsNull() || list.Count == 0)
                {
                    return;
                }
                if(changeList[0].skuId==0)
                {
                    return;
                }
                //小于50提醒
                await AliMessageService.RecordMessage(request);
                var changeDis = list.GroupBy(t => new { t.offerId }).Select(t => t.FirstOrDefault()).ToList();
                var disOffids = changeDis.Select(t => t.offerId.ToString()).ToList();
                //查询是否有关联铺货商品
                var relationList = new DistributionRelationDAL().ListGet(t => disOffids.Contains(t.SourceProduct) && t.ReStatus == 1);
                if (relationList.IsNull() || relationList.Count == 0)
                {
                    return;
                }
                List<ProductUpdateLog> logList = new List<ProductUpdateLog>();
                foreach (var re in relationList)
                {
 
                    string context = string.Empty;
                    List<SkuInfosItem> skuInfos = JSONUtil.JsonToObject<List<SkuInfosItem>>(re.AliskuInfo);
                    var skuitem = list.Where(t => t.offerId == long.Parse(re.SourceProduct)).ToList();
                    foreach (var sku in skuitem)
                    {
                        var aliSku = skuInfos.Where(t => t.skuId == sku.skuId).ToList();
                        if (aliSku.IsNull() || aliSku.Count == 0)
                        {
                            continue;
                        }
                        var aliSkuItem = aliSku[0];
                        context += $"【{aliSkuItem.attributes[0].attributeValue}】规格库存:{sku.skuOnSale};";
                    }
                    var productInfo = new DistributionHistoryDAL().GetFirst(t => t.ProductId == re.SourceProduct, i => new { i.CreateTime }, OrderType.Desc);
                    ProductUpdateLog productUpdateLog = new ProductUpdateLog()
                    {
                        Id = TopUtil.GetId().ToString(),
                        CreateTime = DateTime.Now,
                        UpdateContent = context,
                        ProductId = re.SourceProduct,
                        MsgType = request.type,
                        ProcessingStatus = 0,
                        YzProductId = re.YzProduct,
                        MsgId = request.msgId
                    };
                    if (!productInfo.IsNull() && !productInfo.Id.IsNullOrEmpty())
                    {
                        productUpdateLog.ProductImg = productInfo.ProImg;
                        productUpdateLog.ProductTitle = productInfo.ProTitle;
                    }
                    logList.Add(productUpdateLog);
                }
 
                if (!logList.IsNull() && logList.Count > 0)
                {
                    new ProductUpdateLogDAL().InsertRange(logList);
                }
            }
            catch (Exception e)
            {
                LogUtil.Info($"【消息】{JSONUtil.ObjectToJson(request)}--【错误】{e.ToString()}", "1688消息处理失败");
            }
        }
 
        /// <summary>
        /// 订单消息转发
        /// </summary>
        /// <param name="message"></param>
        /// <returns></returns>
        public static async Task TradeMessageSend(string message, BaseAliMessage baseAliMessage)
        {
            try
            {
                TradeMqMessage tradeMqMessage = new TradeMqMessage()
                {
                    MsgType = "ali_trade",
                    MsgBody = message
                };
                if(baseAliMessage.type.StartsWith("PRODUCT_"))
                {
                    tradeMqMessage.MsgType = "ali_product";
                }
                string ret = MQClientFullChannel.SendMessageStatic(0, "trade_interflow", JSONUtil.ObjectToJson(tradeMqMessage));
                if (ret != "ok")
                {
                    LogUtil.Info($"发MQ失败:{message}", "处理失败");
                }
            }
            catch (Exception e)
            {
                LogUtil.Info($"【消息】{message}--【错误】{e.ToString()}", "1688消息处理失败");
            }
        }
    }
}