heyuntao
2023-05-04 fbd6a11a99051f425640bf352842f4a0ecaa7a4d
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
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
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>
        /// 精选货源商品价格变动消息
        /// </summary>
        /// <param name="request"></param>
        /// <returns></returns>
        public static async Task OfferPriceModify(BaseAliMessage request)
        {
            try
            {
                OfferPriceModifyData data = JSONUtil.JsonToObject<OfferPriceModifyData>(request.data.ToString());
                //查询是否有关联铺货商品
                var relationList = new DistributionRelationDAL().ListGet(t => t.SourceProduct == data.offerId && t.ReStatus == 1);
                if (relationList.IsNull() || relationList.Count == 0)
                {
                    return;
                }
                //从接口查询商品信息
                var appSet = new AppsetDAL().ListGet(t => t.Id != null).ToList();
                List<string> ls = new List<string>();
                ls.Add(data.offerId);
                PFTProductDetailRequest proRequest = new PFTProductDetailRequest()
                {
                    offerIds = ls
                };
                var proRsp = AliabaClient.Execute(proRequest, appSet[0].AlibabaToken);
                List<ProductUpdateLog> logList = new List<ProductUpdateLog>();
 
                //处理变动项目
                string updateContent = $"商品价格变动:{data.minPrice / 100}元;";
                if(data.skuUpdateInfos.IsNull())
                {
                    ProductUpdateLog productUpdateLog = new ProductUpdateLog()
                    {
                        Id = TopUtil.GetId().ToString(),
                        CreateTime = DateTime.Now,
                        ProductId = data.offerId,
                        MsgType = request.type,
                        ProcessingStatus = 0,
                        UpdateContent = updateContent,
                        MsgId = request.msgId,
                        YzProductId = relationList[0].YzProduct
                    };
                    productUpdateLog.ProductImg = proRsp.result.result[0].productInfo.image.images[0];
                    productUpdateLog.ProductTitle = proRsp.result.result[0].productInfo.subject;
                    new ProductUpdateLogDAL().Insert(productUpdateLog);
                    return;
                }
                var sku = data.skuUpdateInfos;
 
                var topSku = proRsp.result.result[0].productInfo.skuInfos.Where(t => t.skuId == long.Parse(sku.skuId)).ToList();
                if (!topSku.IsNull() && topSku.Count > 0)
                {
                    updateContent += $"[{topSku[0].attributes[0].attributeName}:{topSku[0].attributes[0].attributeValue}]规格变动:{sku.historyRetailPrice / 100}元;";
                }
                foreach (var item in relationList)
                {
                    ProductUpdateLog productUpdateLog = new ProductUpdateLog()
                    {
                        Id = TopUtil.GetId().ToString(),
                        CreateTime = DateTime.Now,
                        ProductId = data.offerId,
                        MsgType = request.type,
                        ProcessingStatus = 0,
                        UpdateContent = updateContent,
                        MsgId = request.msgId,
                        YzProductId = item.YzProduct
                    };
                    productUpdateLog.ProductImg = proRsp.result.result[0].productInfo.image.images[0];
                    productUpdateLog.ProductTitle = proRsp.result.result[0].productInfo.subject;
                    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)
        {
            try
            {
                TradeMqMessage tradeMqMessage = new TradeMqMessage()
                {
                    MsgType = "ali_trade",
                    MsgBody = message
                };
                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消息处理失败");
            }
        }
    }
}