def update_channel_flag(self):
"""
更新 channel 的标签
参数：channel_id --> channel 的本地Id
rank --> 标志 取值 rank0,rank1,rank2,rank3,rank4,rank5
(白，红，橙，绿，蓝，紫)
:return:
"""
channel_id = self.params.get("channel_id", "")
rank = self.params.get("rank", "")
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
if not channel:
return {"status": 0, "data": "\"channel_id\"不存在！"}
if rank not in ["rank0", "rank1", "rank2", "rank3", "rank4", "rank5"]:
return {"status": 0, "data": "\"rank\"参数的值不在合法值列表中"}
try:
with sessionCM() as session:
Channel.update(session, channel, {"flag": rank})
return {
"status": 1,
"data": "为channel %s 打上了 %s 标签！" % (str(channel_id), str(rank))
}
except Exception, e:
logger.error(traceback.format_exc(e))
return {"status": 0, "data": "打标签失败"}
def update_channel_state(self):
"""
更新 channel 的处理状态 （已处理、未处理）
参数：channel_id --> channel 的本地Id
state --> 状态 0表示未处理、 1表示已处理
:return:
"""
channel_id = self.params.get("channel_id", "")
state = self.params.get("state", "")
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
if not channel:
return {"status": 0, "data": "\"channel id\"不存在！"}
if state not in ["1", "0"]:
return {"status": 0, "data": "\"state\"值只能是字符串0或1！"}
try:
with sessionCM() as session:
Channel.update(session, channel, {"deal_stat", int(state)})
return {"status": 1, "data": "状态更新成功！"}
except Exception, e:
logger.error(traceback.format_exc(e))
return {"status": 0, "data": "状态更新失败！"}
def sync_message_list(self, msg_source, current_page=1, page_size=100):
"""
同步订单留言
:return:
"""
with sessionCM() as session:
while True:
result = self.msg_handler.get_msg_relation_list(
msg_source, current_page, page_size)
print type(result), len(result)
print result
if not result["success"]:
return # result["exception"]
current_page += 1
for relation in result.get("result", []):
print relation
# 判断当前同步下来的Channel是否存在
chanel = Channel.find_by_origin_id(session,
relation["channelId"])
# 若和上次lastMessageId相同，就不用再获取详情
if chanel and relation["lastMessageId"] == chanel[
"last_msg_id"]:
continue
if len(str(relation["messageTime"])) == 13:
last_msg_date_timestamp = long(
str(relation["messageTime"])[:-3])
else:
last_msg_date_timestamp = relation["messageTime"]
# seller_id 只有在卖家发送一条消息之后从summary中获取到，relation["childId"] 只是子账号ID 并不是loginId
chanel = Channel.update(
session,
chanel,
shop_id=self.shop.id,
seller_id=relation["childId"],
seller_name=relation["childName"],
buyer_id=relation["otherLoginId"],
buyer_name=relation["otherName"],
read_stat=relation["readStat"],
deal_stat=relation["dealStat"],
open_date="",
close_date="",
closed_by="",
flag=relation["rank"],
origin_id=relation["channelId"],
msg_source=msg_source,
relation_type="",
relation_id="",
last_msg_id=relation["lastMessageId"],
last_msg_date=time.strftime(
"%Y-%m-%d %H:%M:%S",
time.localtime(last_msg_date_timestamp)),
last_msg_content=relation["lastMessageContent"])
# sync_smt_customer_detail.delay(self, chanel.id, msg_source)
print chanel.id, chanel.seller_id, chanel.seller_name, chanel.last_msg_content
yield chanel.id
if len(result["result"]) == 0:
break
def _deal_with_result(datas):
if isinstance(datas, dict):
datas = [datas]
print "处理Ticket ... "
for ticket in datas:
print ticket
ticket = ticket["Ticket"]
print shop_id
kw = {
"shop_id":
shop_id,
"seller_id":
ticket["merchant_id"],
"seller_name":
"",
"buyer_id":
ticket["UserInfo"]["id"],
"buyer_name":
ticket["UserInfo"]["name"],
"read_stat":
"0",
"deal_stat":
0 if ticket["state_id"] == '4' else 1,
"open_date":
ticket["open_date"],
"close_date":
ticket.get("close-date", ""),
"closed_by":
"",
"flag":
"",
"msg_source":
"",
"origin_id":
ticket["id"],
"relation_id":
ticket["transaction_id"],
"relation_type":
"transaction",
"last_msg_date":
ticket["last_update_date"],
"last_msg_id":
"",
"last_msg_content":
ticket["subject"] + ";" + ticket["sublabel"]
}
with sessionCM() as session:
channel = Channel.find_by_origin_id(session, ticket["id"])
print "更新/生成Ticket ... "
channel = Channel.update(session, channel, **kw)
print "更新Replies ... "
# 直接同步消息内容
self.sync_message_detail(channel, ticket["replies"])
print "更新Replies 完成！"
def appeal_to_wish_support(self):
"""
将消息上诉给WishSupport处理
参数仅仅需要正确的 ticket id
:return:
"""
ticket_id = self.params.get("ticket_id", "")
ticket_handler = WishTicket(self.shop)
with sessionCM() as session:
channel = Channel.find_by_origin_id(session, ticket_id)
if not channel:
return {"status": 0, "data": "\"ticket_id\"不存在！"}
result = ticket_handler.appeal_support_ticket_by_id(
ticket_id=ticket_id)
if result.get("success", ""):
return {"status": 1, "data": "处理成功！"}
else:
return {
"status": 0,
"data": "处理失败！",
"errors": result.get("message", "")
}
def reply_message(self):
"""
回复消息，对应于最新一条消息的回复
需要的参数包括：parent_message_id (被回复的消息ID) , item_id 或是 recipient_id , body
:return:
"""
channel_id = self.params.get("channel_id", "")
body = self.params.get("body", "")
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
ticket_id = channel.origin_id
handler = WishTicket(self.shop)
result = handler.reply_ticket_by_id(ticket_id, body)
print "回复 Ticket ID 为 %s " % channel_id
print result
if result.get("success", ""):
# 是否同步消息
sync_handler = SyncWishCustomer(self.shop)
sync_handler.execute(ticket_id=ticket_id)
return {"status": 1, "message": "回复消息成功！"}
else:
return {
"status": 0,
"message": "回复消息失败！",
"errors": result.get("message", "")
}
def reply_message(self):
"""
回复消息，对应于最新一条消息的回复
需要的参数包括：parent_message_id (被回复的消息ID) , item_id 或是 recipient_id , body
:return:
"""
parent_message_id = self.params.get("parent_message_id", "")
channel_id = self.params.get("channel_id", "")
# recipient_id = self.params.get("recipient_id", "")
body = self.params.get("body", "")
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
if not channel:
return {"status": 0, "message": "无效的channel_id!"}
handler = EbayMessage(self.shop.site_id, self.shop.account)
result = handler.add_message_rtq(
parent_message_id=parent_message_id, item_id=channel.relation_id,
recipient_id=channel.buyer_id, body=body
)
print parent_message_id, channel.relation_id, channel.buyer_id, body
print result
if result.get("Ack", "") == "Success":
# 同步消息
with sessionCM() as session:
Message.create(
session, channel_id=channel.id, origin_id='async',
content=body, image_urls="", receive_time=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"),
source='seller', external_message_id=''
)
return {"status": 1, "message": "回复消息成功！"}
else:
return {"status": 0, "message": "回复消息失败！", "errors": result.get("Errors", "")}
def update_channel_read(self):
"""
更新通道为已读状态
参数 channel_id --> channel 的本地ID
msgSource --> 消息类型 可选参数（message_center/order_msg）
:return:
"""
channel_id = self.params.get("channel_id", "")
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
if not channel:
return {"status": 0, "data": "\"channel_id\"不存在！"}
try:
with sessionCM() as session:
Channel.update(session, channel, {"read_stat", 1})
return {"status": 1, "data": "状态更新成功！"}
except Exception, e:
logger.error(traceback.format_exc(e))
return {"status": 0, "data": "状态更新失败！"}
def close_ticket(self):
"""
关闭 ticket
:return:
"""
ticket_id = self.params.get("channel_id", "")
if not ticket_id:
return {"status": 0, "message": "缺少channel_id!"}
handler = WishTicket(self.shop)
with sessionCM() as session:
ticket = Channel.find_by_id(session, ticket_id)
if not ticket:
return {"status": 0, "message": "无效的channel_id!"}
result = handler.close_ticket_by_id(ticket["origin_id"])
if result.get("success", ""):
Channel.update(session, channel=ticket, closed_by="buyer")
return {"status": 1, "message": "已关闭！"}
else:
return {"status": 0, "message": result.get("message", "关闭失败！")}
def sync_message_detail(self,
channel_id,
msg_source,
current_page=1,
page_size=100):
"""
同步订单留言
:return:
"""
with sessionCM() as session:
channel = Channel.find_by_id(session, channel_id)
# if channel:
# print "通道id为%d, buyer_name: %s " % (channel.id, channel.buyer_name)
additional_flag = False
while True:
print current_page
result = self.msg_handler.get_msg_detail_list(
channel.origin_id, msg_source, current_page, page_size)
print json.dumps(result, indent=2, encoding='utf8')
# raw_input("enter ... ")
if not result["success"]:
return result["exception"]
current_page += 1
for message in result.get("result", []):
old_msg = Message.find_by_origin_id(session, message["id"])
if old_msg:
continue
print "创建新消息..."
Message.create(
session,
channel_id=channel_id,
origin_id=message["id"],
content=message["content"],
image_urls=";".join(
[im["sPath"] for im in message["filePath"]]),
receive_time=time.strftime(
"%Y-%m-%d %H:%M:%S",
time.localtime(long(
str(message["gmtCreate"])[:-3]))),
source="seller" if message["summary"]["senderName"]
== channel.seller_name else "buyer",
external_message_id="")
print "创建消息完成 ！"
if additional_flag:
continue
print "设置关联关系..."
if not channel.relation_type or not channel.relation_id:
print "更新通道..."
Channel.update(session,
channel,
shop_id=self.shop.id,
relation_type=message["messageType"],
relation_id=message["typeId"])
print "创建Attachment..."
Attachment.create(
session,
channel_id=channel_id,
name=message["summary"]["productName"],
image_url=message["summary"]["productImageUrl"],
product_url=message.get("productDetailUrl",
""), # ？？？
order_url=message["summary"]["orderUrl"],
product_id="",
order_id="")
channel.update(session, channel, **{})
additional_flag = True
print "设置关联完成..."
if len(result["result"]) == 0:
break