def get_jd_order(self, bot, msg, orderId, userInfo, puid, raw):
# try:
order_id = int(orderId)
timestr = str(datetime.datetime.now().strftime('%Y-%m-%d %H:%M:%S'))
cm = ConnectMysql()
# 查询订单是否已经提现过了
check_order_sql = "SELECT * FROM taojin_order WHERE order_id='" + str(order_id) + "' AND bot_puid='"+ bot.self.puid +"' AND puid='"+puid+"';"
check_order_res = cm.ExecQuery(check_order_sql)
# 判断该订单是否已经提现
if len(check_order_res) >= 1:
cm.Close()
sendtext = '''
一一一一 订单消息 一一一一
订单【%s】提交成功，请勿重复提交
''' % (order_id)
return sendtext
cm.ExecNonQuery("INSERT INTO taojin_order(wx_bot, username, order_id, completion_time, order_source, puid, bot_puid, status) VALUES('"+ str(bot.self.nick_name) +"', '" + str(userInfo['NickName']) + "', '" + str(order_id) + "', '" + str(timestr) + "', '2', '"+puid+"', '"+ bot.self.puid +"', '1')")
send_text ='''
一一一一 订单消息 一一一一
订单【%s】提交成功，请耐心等待订单结算
结算成功后机器人将自动返利到您个人账户
''' % (order_id)
return send_text
def getGroupJd(self, msg, good_url):
cm = ConnectMysql()
print('开始查询分享商品的信息......', msg['Text'])
wei_info = itchat.search_chatrooms(userName=msg['FromUserName'])
sku_arr = good_url.split('https://item.m.jd.com/product/')
if sku_arr == None:
msg_text = tu.tuling(msg)
print(msg_text)
itchat.send(msg_text, msg['FromUserName'])
return
sku = sku_arr[1].split('.')
res = self.get_good_link(sku[0])
logger.debug(res)
if res['data']['shotCouponUrl'] == '':
text = '''
一一一一返利信息一一一一
【商品名】%s
【京东价】%s元
返利链接:%s
''' % (res['logTitle'], res['logUnitPrice'],
res['data']['shotUrl'])
itchat.send(text, msg['FromUserName'])
insert_sql = "INSERT INTO taojin_query_record(good_title, good_price, good_coupon, username, create_time) VALUES('" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '0', '" + wei_info[
'NickName'] + "', '" + str(time.time()) + "')"
cm.ExecNonQuery(insert_sql)
return
else:
text = '''
一一一一返利信息一一一一
【商品名】%s
【京东价】%s元
【优惠券】%s元
【券后价】%s元
领券链接:%s
''' % (res['logTitle'], res['logUnitPrice'],
res['youhuiquan_price'], res['coupon_price'],
res['data']['shotCouponUrl'])
insert_sql = "INSERT INTO taojin_query_record(good_title, good_price, good_coupon, username, create_time) VALUES('" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '" + res['coupon_price2'] + "', '" + \
wei_info['NickName'] + "', '" + str(time.time()) + "')"
cm.ExecNonQuery(insert_sql)
itchat.send(text, msg['FromUserName'])
return
def get_good_info(self, bot):
cm = ConnectMysql()
self.load_cookies()
page = 1
sku_num = 0
while sku_num < 20:
url = "https://media.jd.com/gotoadv/goods?searchId=2011005331%23%23%23st3%23%23%23kt0%23%23%2378dc30b6-fa14-4c67-900c-235b129ab4bb&pageIndex="+str(page)+"&pageSize=50&property=&sort=&goodsView=&adownerType=&pcRate=&wlRate=&category1=&category=&category3=&condition=1&fromPrice=&toPrice=&dataFlag=0&keyword=&input_keyword=&hasCoupon=1&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC&price=PC"
page += 1
self.logger.debug(page)
res = self.se.get(url)
soup = BeautifulSoup(res.text, 'lxml')
skuList = []
for li in soup.find_all('li', skuid = re.compile('^[0-9]+$')):
sku = li.get('skuid')
exists_sql = "SELECT * FROM taojin_good_info WHERE skuid='"+str(sku)+"' AND bot_puid='"+ bot.self.puid +"';"
is_exists = cm.ExecQuery(exists_sql)
if len(is_exists) != 0:
print('0....')
continue
sku_num += 1
skuList.append(sku)
if skuList == []:
print('[]....')
continue
for item in skuList:
link_info = self.get_good_link(str(item))
# item_image = link_info['data']['qRcode']
item_image = link_info['imgUrl']
# 请求图片
res_img = requests.get(item_image)
img_name = item_image.split('/')
# 拼接图片名
file_name = "images/" + img_name[-1]
fp = open(file_name, 'wb')
# 写入图片
fp.write(res_img.content)
fp.close()
if link_info['data']['shotCouponUrl'] == '':
continue
else:
sql = "INSERT INTO taojin_good_info(wx_bot, skuid, title, image, price, rebate, yhq_price, coupon_price, shoturl, shotcouponurl, status, create_time, bot_puid) VALUES('"+ bot.self.nick_name +"', '" + str(
item) + "', '" + str(link_info['logTitle']) + "', '" + str(item_image) + "', '" + str(
link_info['logUnitPrice']) + "', '" + str(link_info['rebate']) + "', '" + str(
link_info['youhuiquan_price']) + "', '" + str(link_info['coupon_price']) + "', '" + str(
link_info['data']['shotUrl']) + "', '" + str(
link_info['data']['shotCouponUrl']) + "', '1', '" + str(time.time()) + "', '"+ bot.self.puid +"')"
cm.ExecNonQuery(sql)
print("insert success!")
def setData():
cm = ConnectMysql()
# 需要从request对象读取表单内容：
formdata = request.form
username = formdata['username']
for item in formdata:
if item != 'username':
insert_sql = "INSERT INTO taojin_group_message(username, groupid, groupname, create_time) VALUES('"+username+"', '"+item+"', '"+formdata[item]+"', '"+str(time.time())+"')"
cm.ExecNonQuery(insert_sql)
# 执行群发任务
fmm.start_send_msg_thread()
return "添加成功！"
def groupMessages(self, bot):
global bot2
bot2 = bot
time.sleep(10)
yorn = input("是否重新选群？y/n:")
if yorn == 'n':
self.start_send_msg_thread()
return
print('start select groups.....')
# 删除原有群聊数据
cm = ConnectMysql()
select_sql = "DELETE FROM taojin_group_message WHERE bot_puid='" + bot2.self.puid + "';"
cm.ExecNonQuery(select_sql)
group = bot2.groups()
print(group)
template_demo = """
<!DOCTPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>选择群聊</title>
</head>
<body>
<div>
<form action='/formdata' method='post'>
<h2>选择群聊</h2>
<input type="hidden" name="username" value="{{ res }}" />
<input type="hidden" name="bot_puid" value="{{ bot_puid }}" />
<ul>
% for item in items:
<li><input type="checkbox" name="{{ item.user_name }}" value="{{ item.nick_name }}" />{{ item.nick_name }}</li>
%end
</ul>
<h2>输入需要群发内容:</h2>
<textarea name="sendText" rows="3" cols="20"></textarea>
<input type='submit' value='提交' />
</form>
</div>
</body>
</html>
"""
html = template(template_demo,
items=group,
res=bot2.self.nick_name,
bot_puid=bot2.self.puid)
with open('form.html', 'w', encoding='utf-8') as f:
f.write(html)
self.run()
def send_group_meg(self):
cm = ConnectMysql()
res = itchat.web_init()
select_sql = "SELECT * FROM taojin_group_message WHERE username='******'User']['NickName']) + "';"
group_info = cm.ExecQuery(select_sql)
while True:
a = datetime.datetime.now().hour
if int(a) < 8 | int(a) >= 20:
print('时间不够')
continue
print('ok')
time.sleep(300)
data_sql = "SELECT * FROM taojin_good_info WHERE status=1 LIMIT 1"
data1 = cm.ExecQuery(data_sql)
if data1 == ():
mjd.get_good_info()
cm.Close()
cm2 = ConnectMysql()
data = cm2.ExecQuery(data_sql)
text = '''
一一一一优惠信息一一一一
【商品名】%s
【京东价】%s元
【优惠券】%s元
【券后价】%s元
领券链接:%s
请点击链接领取优惠券，下单购买！
''' % (data[0][2], data[0][4], data[0][6], data[0][7], data[0][9])
delete_sql = "UPDATE taojin_good_info SET status='2' WHERE id='" + str(data[0][0]) + "'"
cm.ExecNonQuery(delete_sql)
img_name = data[0][3].split('/')
img_path = "images/" + img_name[-1]
for item in group_info:
time.sleep(2)
itchat.send_image(img_path, item[2])
itchat.send(text, item[2])
def setData():
cm = ConnectMysql()
# 需要从request对象读取表单内容：
formdata = request.form
username = formdata['username']
bot_puid = formdata['bot_puid']
# 把需要群发的信息写入send.txt
with open('send.txt', 'w') as fw: # 写入
fw.write(formdata['sendText'])
# 把群聊信息写入数据库
for item in formdata:
if item != 'username' and item != 'sendText' and item != 'bot_puid':
insert_sql = "INSERT INTO taojin_group_message(username, groupid, groupname, create_time, bot_puid) VALUES('" + username + "', '" + item + "', '" + \
formdata[item] + "', '" + str(time.time()) + "', '" + bot_puid + "')"
cm.ExecNonQuery(insert_sql)
# 执行群发任务
fmm.start_send_msg_thread()
return "添加成功！"
def groupMessages(self):
time.sleep(30)
yorn = input("是否重新选群？y/n:")
if yorn == 'n':
self.start_send_msg_thread()
return
print('start.....')
cm = ConnectMysql()
res = itchat.web_init()
select_sql = "DELETE FROM taojin_group_message WHERE username='******'User']['NickName']) + "';"
cm.ExecNonQuery(select_sql)
group = itchat.get_chatrooms(update=True, contactOnly=False)
template_demo = """
<!DOCTPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>选择群聊</title>
</head>
<body>
<div>
<form action='/formdata' method='post'>
<input type="hidden" name="username" value="{{ res['User']['NickName'] }}" />
% for item in items:
<input type="checkbox" name="{{ item['UserName'] }}" value="{{ item['NickName'] }}" />{{ item['NickName'] }}
%end
<input type='submit' value='提交' />
</form>
</div>
</body>
</html>
"""
html = template(template_demo, items=group, res=res)
with open('form.html', 'w', encoding='utf-8') as f:
f.write(html)
self.run()
def get_group_detail(self, q, msg):
cm = ConnectMysql()
chatrooms = itchat.search_chatrooms(userName=msg['FromUserName'])
try:
t = int(time.time() * 1000)
tb_token = self.se.cookies.get('_tb_token_',
domain="pub.alimama.com")
pvid = '10_%s_1686_%s' % (self.myip, t)
url = 'http://pub.alimama.com/items/search.json?q=%s&_t=%s&auctionTag=&perPageSize=40&shopTag=&t=%s&_tb_token_=%s&pvid=%s' % (
urllib.quote(q.encode('utf8')), t, t, tb_token, pvid)
headers = {
'method': 'GET',
'authority': 'pub.alimama.com',
'scheme': 'https',
'path':
'/items/search.json?%s' % url.split('search.json?')[-1],
'accept': 'application/json, text/javascript, */*; q=0.01',
'x-requested-with': 'XMLHttpRequest',
'user-agent':
'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0',
'referer': 'https://pub.alimama.com',
'accept-encoding': 'gzip, deflate, br',
'accept-language': 'en-US,en;q=0.5',
}
res = self.get_url(url, headers)
print(res.text)
rj = res.json()
if rj['data']['pageList'] != None:
insert_sql = "INSERT INTO taojin_query_record(good_title, good_price, good_coupon, username, create_time) VALUES('" + rj[
'data']['pageList'][0]['title'] + "', '" + str(
rj['data']['pageList'][0]['zkPrice']) + "', '" + str(
rj['data']['pageList'][0]['couponAmount']
) + "', '" + chatrooms['NickName'] + "', '" + str(
time.time()) + "')"
cm.ExecNonQuery(insert_sql)
cm.Close()
return rj['data']['pageList'][0]
else:
return 'no match item'
except Exception as e:
trace = traceback.format_exc()
self.logger.warning("error:{},trace:{}".format(str(e), trace))
def send_group_meg(self):
global bot2
while True:
text = open('send.txt', 'r').read()
# 获取图片
fileArr = [c for a, b, c in os.walk('./groupFile')]
cm = ConnectMysql()
selectSql = "SELECT * FROM taojin_group_message WHERE bot_puid='" + bot2.self.puid + "'"
groupInfo = cm.ExecQuery(selectSql)
for item in groupInfo:
time.sleep(int(config.get('TIME', 'group_send_time')))
group = bot2.groups().search(item[3])[0]
# 获取需要发送的图片
if fileArr[0] != None:
for i in fileArr[0]:
image = 'groupFile/' + i
group.send_image(image)
group.send(text)
time.sleep(int(config.get('TIME', 'group_sleep_time')))
def get_detail2(self, q):
cm = ConnectMysql()
try:
t = int(time.time() * 1000)
tb_token = self.se.cookies.get('_tb_token_',
domain="pub.alimama.com")
pvid = '10_%s_1686_%s' % (self.myip, t)
url = 'http://pub.alimama.com/items/search.json?q=%s&_t=%s&auctionTag=&perPageSize=40&shopTag=&t=%s&_tb_token_=%s&pvid=%s' % (
urllib.quote(q.encode('utf8')), t, t, tb_token, pvid)
headers = {
'method':
'GET',
'authority':
'pub.alimama.com',
'scheme':
'https',
'path':
'/items/search.json?%s' % url.split('search.json?')[-1],
'accept':
'application/json, text/javascript, */*; q=0.01',
'x-requested-with':
'XMLHttpRequest',
'user-agent':
'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0',
'referer':
'https://pub.alimama.com',
'accept-encoding':
'gzip, deflate, sdch, br',
'accept-language':
'zh,en-US;q=0.8,en;q=0.6,zh-CN;q=0.4,zh-TW;q=0.2',
}
res = self.get_url(url, headers)
rj = res.json()
if rj['data']['pageList'] != None:
return rj['data']['pageList'][0]
else:
return 'no match item'
except Exception as e:
trace = traceback.format_exc()
self.logger.warning("error:{},trace:{}".format(str(e), trace))
def getText(self, raw, bot, msg):
wei_info = bot.core.search_friends(userName=msg['FromUserName'])
patternURL = re.compile('^((https|http|ftp|rtsp|mms)?:\/\/)[^\s]+')
pattern_bz = re.compile('^帮助$')
pattern_profile = re.compile('^个人信息$')
pattern_tixian = re.compile('^提现$')
pattern_tuig = re.compile('^推广$')
pattern_proxy = re.compile('^代理$')
appect_friend = re.compile('^我通过了你的朋友验证请求，现在我们可以开始聊天了$')
# 判断是否是URL链接
if patternURL.search(msg['Text']) == None:
pattern_s = re.compile('^搜')
pattern_z = re.compile('^找')
pattern_m = re.compile('^买')
if (pattern_s.search(msg['Text']) != None) | (pattern_z.search(
msg['Text']) != None) | (pattern_m.search(msg['Text']) !=
None):
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
jdurl = quote(config.get('URL', 'jdshopingurl') +
msg['Text'][1:],
safe='/:?=&')
tburl = quote(config.get('URL', 'tbshopingurl') +
msg['Text'][1:],
safe='/:?=&')
res1 = self.movie.getShortUrl(jdurl)
res2 = self.movie.getShortUrl(tburl)
print('WEEWEWEW', msg)
text = '''
一一一一系统消息一一一一
亲,以下是【%s】优惠券集合
京东:%s
淘宝:%s
''' % (msg['Text'][1:], res1, res2)
return text
elif appect_friend.search(msg['Text']) != None:
# 获取生成的备注
ramerkName = self.ort.generateRemarkName(bot)
self.logger.debug(ramerkName)
# 修改备注
bot.core.set_alias(userName=msg['FromUserName'],
alias=ramerkName)
# 被邀请人puid
user_wxid = self.ort.getPuid(bot, msg['FromUserName'])
self.ort.create_user_info(raw,
bot,
msg,
lnivt_code=0,
tool=True,
wxid=user_wxid)
text = '''
Hi~我是24h在线的淘小券机器人
分享【京东商品】
分享【淘口令】
分享【拼多多商品】
回复【互助】查看机器人指令
精准查询全网内部优惠券哦，您也可以访问下边优惠券商城自主查询呢！
京东优惠券商城：
''' + config.get('URL', 'jdshop') + '''
淘宝优惠券商城：
''' + config.get('URL', 'tbshop') + '''
邀请好友得返利说明：
''' + config.get('URL', 'lnvit') + '''
'''
return text
elif ('你已添加了' in msg['Text']) and ('现在可以开始聊天了' in msg['Text']):
arrstr = msg['Text'].split('，')
str = arrstr[0][5:]
self.logger.debug(str)
user = bot.friends().search(str)[0]
self.logger.debug(str, user)
# 获取生成的备注
ramerkName = self.ort.generateRemarkName(bot)
self.logger.debug(ramerkName)
# 修改备注
bot.core.set_alias(nickName=user.user_name, alias=ramerkName)
# 被邀请人puid
user_wxid = user.puid
self.ort.create_user_info(raw,
bot,
msg,
lnivt_code=0,
tool=True,
wxid=user_wxid)
text = '''
Hi~我是24h在线的淘小券机器人
分享【京东商品】
分享【淘口令】
分享【拼多多商品】
回复【互助】查看机器人指令
精准查询全网内部优惠券哦，您也可以访问下边优惠券商城自主查询呢！
京东优惠券商城：
''' + config.get('URL', 'jdshop') + '''
淘宝优惠券商城：
''' + config.get('URL', 'tbshop') + '''
邀请好友得返利说明：
''' + config.get('URL', 'lnvit') + '''
'''
return text
elif pattern_bz.search(msg['Text']) != None:
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
# 帮助操作
text = '''
Hi~我是24h在线的淘小券机器人，用淘小券，免费领取任意淘宝,天猫,京东,拼多多商品优惠券，好用的话记得分享给好友哦
回复【帮助】可查询指信息
回复【提现】申请账户余额提现
回复【推广】可申请机器人代理
回复【个人信息】可看个当前账户信息
回复【买+商品名称】
回复【找+商品名称】
回复【搜+商品名称】查看商品优惠券合集
分享【京东商品】
分享【淘宝淘口令】
分享【拼多多商品】
精准查询商品优惠券和返利信息！
分享【VIP视频链接】免费查看高清VIP视频！
优惠券使用教程：
http://t.cn/RnAKqWW
跑堂优惠券常见问题：
http://t.cn/RnAK1w0
免费看电影方法：
http://t.cn/RnAKMul
京东优惠券商城：
http://jdyhq.ptjob.net
淘宝优惠券商城：
http://xiaoquan.ptjob.net
邀请好友得返利说明：
http://t.cn/RnAKafe
'''
return text
elif pattern_tixian.search(msg['Text']) != None:
cm = ConnectMysql()
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
select_user_sql = "SELECT * FROM taojin_user_info WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
select_user_res = cm.ExecQuery(select_user_sql)
timestr = round(time.time())
timestr2 = repr(timestr)
# 设置提现门槛
if float(select_user_res[0][9]) < int(
config.get('SYS', 'tixianprice')):
text2 = '''
一一一一 提现信息 一一一一
提现申请失败
当前账户余额为%s
最小提现金额为%s元！
''' % (
select_user_res[0][9], config.get(
'SYS', 'tixianprice'))
return text2
adminuser = bot.friends().search(
config.get('ADMIN', 'ADMIN_USER'))[0]
if float(select_user_res[0][9]) > 0:
# 修改余额
update_sql = "UPDATE taojin_user_info SET withdrawals_amount='0', update_time='" + timestr2 + "' WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
total_amount = float(select_user_res[0][6]) + float(
select_user_res[0][9])
update_total_sql = "UPDATE taojin_user_info SET total_rebate_amount='" + repr(
total_amount
) + "',update_time='" + timestr2 + "' WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
# 插入提现日志
insert_current_log_sql = "INSERT INTO taojin_current_log(wx_bot, username, amount, create_time, puid, bot_puid) VALUES('" + bot.self.nick_name + "', '" + wei_info[
'NickName'] + "', '" + repr(
select_user_res[0][9]
) + "', '" + timestr2 + "', '" + raw.sender.puid + "', '" + bot.self.puid + "')"
to_admin_text = '''
一一一一 提现通知 一一一一
机器人：%s
提现人：%s
提现金额：%s元
提现时间：%s
''' % (
bot.self.nick_name, wei_info['NickName'],
select_user_res[0][9],
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()))
cm.ExecNonQuery(update_sql)
cm.ExecNonQuery(update_total_sql)
cm.ExecNonQuery(insert_current_log_sql)
to_user_text = '''
一一一一 提现信息 一一一一
恭喜你成功提现【%s】元
提现金额将以微信红包发放，请耐心等待
''' % (select_user_res[0][9])
adminuser.send(to_admin_text)
return to_user_text
else:
text2 = '''
一一一一 提现信息 一一一一
提现申请失败，账户余额为0！
'''
return text2
elif pattern_profile.search(msg['Text']) != None:
cm = ConnectMysql()
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
user_sql = "SELECT * FROM taojin_user_info WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
user_info = cm.ExecQuery(user_sql)
current = "SELECT sum(amount) FROM taojin_current_log WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
current_info = cm.ExecQuery(current)
# 如果总提现金额不存在，赋值为0
if current_info[0][0] == None:
current_info = 0
else:
current_info = current_info[0][0]
text = '''
一一一一 个人信息 一一一一
总返利金额:%s元
京东返利金额:%s元
淘宝返利金额:%s元
拼多多返利金额:%s元
可提现余额:%s元
累计提现金额:%s元
累计订单量:%s
京东订单量:%s
淘宝订单量:%s
拼多多订单量:%s
总好友返利:%s
总好友个数:%s
''' % (
user_info[0][6], user_info[0][7], user_info[0][8],
user_info[0][25], user_info[0][9], current_info,
user_info[0][11], user_info[0][12], user_info[0][13],
user_info[0][26], user_info[0][19], user_info[0][20])
cm.Close()
return text
elif pattern_tuig.search(msg['Text']) != None:
cm = ConnectMysql()
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
user_sql = "SELECT * FROM taojin_user_info WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "';"
cm.ExecQuery(user_sql)
text = '''
一一一一 推广信息 一一一一
将机器人名片分享到群或者好友
好友添加机器人为好友
您和好友都将获取''' + config.get('BN', 'bn2') + '''元现金奖励
且您将永久享受好友返利10%提成
邀请好友得返利说明：
''' + config.get('URL', 'lnvit') + '''
'''
return text
elif pattern_proxy.search(msg['Text']) != None:
res = self.ort.ishaveuserinfo(bot, msg, raw)
if res['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
text = '''
一一一一系统消息一一一一
点击链接：''' + config.get('URL', 'proxy') + '''
添加好友备注：优惠券代理
客服人员将尽快和您取得联系，请耐心等待!
'''
return text
elif (msg['Text'].isdigit()) and (len(msg['Text']) == 11):
res2 = self.ort.ishaveuserinfo(bot, msg, raw)
if res2['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
res = self.mjd.get_jd_order(bot, msg, msg['Text'], wei_info,
raw.sender.puid, raw)
return res
elif (msg['Text'].isdigit()) and (len(msg['Text']) == 18):
res2 = self.ort.ishaveuserinfo(bot, msg, raw)
if res2['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
res = self.al.order(msg['Text'], raw)
return res
elif ('-' in msg['Text']) and (len(msg['Text'].split('-')[1])
== 15) and (len(msg['Text']) == 22):
res2 = self.ort.ishaveuserinfo(bot, msg, raw)
if res2['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
res = self.pdd.order_pdd(bot, msg, 123456, wei_info,
raw.sender.puid, raw)
return res
else:
if config.get('SYS', 'tl') == 'yes':
msg_text = self.tu.tuling(msg)
self.logger.debug(msg_text)
return msg_text
else:
return
else:
res2 = self.ort.ishaveuserinfo(bot, msg, raw)
if res2['res'] == 'not_info':
self.ort.create_user_info(raw, bot, msg, 0, tool=False)
self.mjd.getJd(raw, bot, msg, msg['Text'])
def getGood(self, raw, msg):
cm = ConnectMysql()
try:
# 获取商品信息，首先获取商品id
arr1 = msg['Text'].split('元')
arr2 = arr1[1].split('拼多多')
good_id = self.getDetail(arr2[0])
if good_id == 'GetGoodIdError':
error_text = '''
一一一一 返利信息 一一一一
亲，当前商品暂无优惠券,建议您换一个商品试试呢,您也可以在下边的优惠券商城中查找哦
京东优惠券商城：
''' + self.config.get('URL', 'jdshop') + '''
淘宝优惠券商城：
''' + self.config.get('URL', 'tbshop') + '''
邀请好友得返利说明：
''' + self.config.get('URL', 'lnvit') + '''
'''
return error_text
pid = self.getPromotion()
if pid == 'GetPromotionIdError':
error_text = '''
一一一一 返利信息 一一一一
亲，当前商品暂无优惠券,建议您换一个商品试试呢,您也可以在下边的优惠券商城中查找哦
京东优惠券商城：
''' + self.config.get('URL', 'jdshop') + '''
淘宝优惠券商城：
''' + self.config.get('URL', 'tbshop') + '''
邀请好友得返利说明：
''' + self.config.get('URL', 'lnvit') + '''
'''
return error_text
pid = pid['result']['promotionChannelList'][0]['pid']
res = self.getLink(good_id['result']['goodsList'][0]['goodsId'],
pid)
good = good_id['result']['goodsList'][0]['goodsId']
# 判断是否有优惠券
if good_id['result']['goodsList'][0]['hasCoupon'] == True:
# 原价
minGroupPrice = float(
int(good_id['result']['goodsList'][0]['minGroupPrice']) /
1000)
# 优惠券
coupon = int(
int(good_id['result']['goodsList'][0]['couponDiscount']) /
1000)
# 卷后价
couponPrice = round(float(minGroupPrice - coupon), 2)
# 返利金额
backPrice = round(((float(
couponPrice *
(int(good_id['result']['goodsList'][0]['promotionRate']) /
1000)))) * float(self.config.get('BN', 'bn3p')), 2)
text = '''
一一一一拼多多返利一一一一
【商品名】%s
【拼多多】%s元
【优惠券】%s元
【劵后价】%s元
【返红包】%s元
领券链接:%s
获取返红包步骤：
1,复制本条消息打开淘宝领券
2,下单后复制订单号发给我
''' % (arr2[0], minGroupPrice, coupon, couponPrice,
backPrice, res['result']['shortUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, skuid, type) VALUES('"+ self.bot.self.nick_name +"', '" + \
arr2[0] + "', '" + str(minGroupPrice) + "', '"+str(coupon)+"', '" + raw.sender.nick_name + "', '" + str(time.time()) + "', '"+ raw.sender.puid +"', '"+ self.bot.self.puid +"', '"+ str(good) +"', '3')"
cm.ExecNonQuery(insert_sql)
return text
else:
# 原价
minGroupPrice = float(
int(good_id['result']['goodsList'][0]['minGroupPrice']) /
1000)
# 返利金额
backPrice = round(((float(
minGroupPrice *
(int(good_id['result']['goodsList'][0]['promotionRate']) /
1000)))) * float(self.config.get('BN', 'bn3p')), 2)
text = '''
一一一一拼多多返利一一一一
【商品名】%s
【拼多多】%s元
【返红包】%s元
返利链接:%s
获取返红包步骤：
1,复制本条消息打开淘宝领券
2,下单后复制订单号发给我
''' % (arr2[0], minGroupPrice, backPrice,
res['result']['shortUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, skuid, type) VALUES('" + self.bot.self.nick_name + "', '" + arr2[
0] + "', '" + str(
minGroupPrice
) + "', '0', '" + raw.sender.nick_name + "', '" + str(
time.time()
) + "', '" + raw.sender.puid + "', '" + self.bot.self.puid + "', '" + str(
good) + "', '3')"
cm.ExecNonQuery(insert_sql)
return text
except Exception as e:
trace = traceback.format_exc()
print("error:{},trace:{}".format(str(e), trace))
def changeInfo(self, msg, info, order_id, userInfo):
cm = ConnectMysql()
# try:
# 查询用户是否有上线
check_user_sql = "SELECT * FROM taojin_user_info WHERE wx_number='" + str(
userInfo['NickName']) + "';"
check_user_res = cm.ExecQuery(check_user_sql)
# 判断是否已经有个人账户，没有返回信息
if len(check_user_res) < 1:
cm.Close()
return {"info": "not_info"}
else:
get_query_sql = "SELECT * FROM taojin_query_record WHERE good_title='" + info[
'skuList'][0]['skuName'] + "'AND username='******' ORDER BY create_time LIMIT 1;"
get_query_info = cm.ExecQuery(get_query_sql)
# 定义SQL语句 查询用户是否已经存在邀请人
# 判断是否已经有邀请人了
if check_user_res and check_user_res[0][16] != 0:
get_parent_sql = "SELECT * FROM taojin_user_info WHERE lnivt_code='" + str(
check_user_res[0][16]) + "';"
get_parent_info = cm.ExecQuery(get_parent_sql)
print(get_parent_info)
add_balance = round(
float(info['skuList'][0]['actualFee']) * 0.3, 2)
withdrawals_amount = round(
float(check_user_res[0][8]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
jd = round(
float(check_user_res[0][6]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
total_rebate_amount = round(
float(check_user_res[0][5]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
save_money = round(
check_user_res[0][9] +
(float(get_query_info[0][2]) -
float(info['skuList'][0]['payPrice'])), 2)
add_parent_balance = round(
float(info['skuList'][0]['actualFee']) * 0.1, 2)
withdrawals_amount2 = round(
float(get_parent_info[0][8]) + float(add_balance) * 0.1, 2)
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', jd_rebate_amount='" + str(jd) +
"', total_rebate_amount='" + str(total_rebate_amount) +
"', update_time='" + str(time.time()) +
"' WHERE wx_number='" + str(userInfo['NickName']) + "';")
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount2) + "', update_time='" +
str(time.time()) + "' WHERE lnivt_code='" +
str(check_user_res[0][16]) + "';")
cm.ExecNonQuery(
"INSERT INTO taojin_order(username, order_id, order_source) VALUES('"
+ str(userInfo['NickName']) + "', '" + str(order_id) +
"', '1')")
args = {
'username': check_user_res[0][1],
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
args2 = {
'username': get_parent_info[0][1],
'rebate_amount': add_parent_balance,
'type': 4,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args2)
parent_user_text = '''
一一一一 推广信息 一一一一
您的好友【%s】又完成了一笔订单，返利提成%s元已发放到您的账户
回复【个人信息】查询账户信息及提成
''' % (check_user_res[0][3], add_parent_balance)
user_text = '''
一一一一系统消息一一一一
订单【%s】已完成！
返利金%s元已发放到您的个人账户！
回复【提现】可申请账户余额提现
回复【个人信息】可看个当前账户信息
分享【京东商品链接】或者【淘口令】精准查询商品优惠券和返利信息！
分享【VIP视频链接】免费查看高清VIP视频！
优惠券使用教程：
http://t.cn/RnAKqWW
京东优惠券网站：
http://jdyhq.ptjob.net
淘宝优惠券网站：
http://tbyhq.ptjob.net
邀请好友得返利：
http://t.cn/RnAKafe
''' % (order_id, add_balance)
cm.Close()
return {
'parent_user_text': parent_user_text,
'user_text': user_text,
'info': 'success',
'parent': get_parent_info[0][1]
}
else:
add_balance = round(
float(info['skuList'][0]['actualFee']) * 0.3, 2)
withdrawals_amount = round(
float(check_user_res[0][8]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
jd = round(
float(check_user_res[0][6]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
total_rebate_amount = round(
float(check_user_res[0][5]) +
float(info['skuList'][0]['actualFee']) * 0.3, 2)
save_money = round(
check_user_res[0][9] +
(float(get_query_info[0][2]) -
float(info['skuList'][0]['payPrice'])), 2)
up_sql = "UPDATE taojin_user_info SET jd_rebate_amount='" + str(
jd) + "', withdrawals_amount='" + str(
withdrawals_amount) + "', save_money='" + str(
save_money) + "', total_rebate_amount='" + str(
total_rebate_amount
) + "', update_time='" + str(
time.time()) + "' WHERE wx_number='" + str(
userInfo['NickName']) + "';"
cm.ExecNonQuery(up_sql)
# cm.ExecNonQuery("UPDATE taojin_user_info SET withdrawals_amount='" + str(withdrawals_amount) + "' WHERE wx_number='" + str(msg['FromUserName']) + "';")
cm.ExecNonQuery(
"INSERT INTO taojin_order(username, order_id, order_source) VALUES('"
+ str(userInfo['NickName']) + "', '" + str(order_id) +
"', '2')")
args = {
'username': check_user_res[0][1],
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
user_text = '''
一一一一 订单消息 一一一一
订单【%s】标记成功，返利金%s已发放到您的账户
回复【个人信息】 查看订单及返利信息
''' % (order_id, add_balance)
cm.Close()
return {
'user_text': user_text,
'info': 'not_parent_and_success'
}
def get_jd_order(self, msg, times, orderId, userInfo):
try:
timestr = re.sub('-', '', times)
order_id = int(orderId)
cm = ConnectMysql()
# 查询订单是否已经提现过了
check_order_sql = "SELECT * FROM taojin_order WHERE order_id='" + str(
order_id) + "';"
check_order_res = cm.ExecQuery(check_order_sql)
# 判断该订单是否已经提现
if len(check_order_res) >= 1:
cm.Close()
send_text = '''
一一一一 订单消息 一一一一
订单【%s】已经成功返利，请勿重复提交订单信息！
回复【个人信息】 查看订单及返利信息
如有疑问！请联系管理员
''' % (order_id)
return {"info": "order_exit", "send_text": send_text}
self.load_cookies()
url = 'https://api.jd.com/routerjson?v=2.0&method=jingdong.UnionService.queryOrderList&app_key=96432331E3ACE521CC0D66246EB4C371&access_token=a67c6103-691c-4691-92a2-4dee41ce0f88&360buy_param_json={"unionId":"2011005331","time":"' + timestr + '","pageIndex":"1","pageSize":"50"}×tamp=' + strftime(
"%Y-%m-%d %H:%M:%S",
gmtime()) + '&sign=E9D115D4769BDF68FE1DF07D33F7720B'
res = requests.get(url)
rj = json.loads(res.text)
print(rj, url)
data = json.loads(
rj['jingdong_UnionService_queryOrderList_responce']['result'])
for item in data['data']:
if order_id == item['orderId']:
res = self.changeInfo(msg, item, order_id, userInfo)
return res
user_text = '''
一一一一订单信息一一一一
订单返利失败！
失败原因：
【1】未确认收货（打开App确认收货后重新发送）
【2】，当前商品不是通过机器人购买
【3】，查询格式不正确(正确格式：2018-03-20,73462222028 )
【4】，订单完成日期错误，请输入正确的订单查询日期
【6】，订单号错误，请输入正确的订单号
请按照提示进行重新操作！
'''
return {'info': 'not_order', 'user_text': user_text}
except Exception as e:
print(e)
return {'info': 'feild'}
def changeInfo(self, msg, info, order_id, userInfo):
try:
cm = ConnectMysql()
# 查询用户是否有上线
check_user_sql = "SELECT * FROM taojin_user_info WHERE wx_number='" + str(
userInfo['NickName']) + "';"
check_user_res = cm.ExecQuery(check_user_sql)
# 判断是否已经有个人账户，没有返回信息
if len(check_user_res) < 1:
cm.Close()
return {"info": "not_info"}
else:
get_query_sql = "SELECT * FROM taojin_query_record WHERE good_title='" + info[
'auctionTitle'] + "'AND username='******' ORDER BY create_time LIMIT 1;"
get_query_info = cm.ExecQuery(get_query_sql)
# 定义SQL语句 查询用户是否已经存在邀请人
# 判断是否已经有邀请人了
if check_user_res and check_user_res[0][16] != 0:
get_parent_sql = "SELECT * FROM taojin_user_info WHERE lnivt_code='" + str(
check_user_res[0][16]) + "';"
get_parent_info = cm.ExecQuery(get_parent_sql)
add_balance = round(float(info['feeString']) * 0.3, 2)
withdrawals_amount = round(
float(check_user_res[0][8]) +
float(info['feeString']) * 0.3, 2)
taobao_rebate_amount = round(
float(check_user_res[0][7]) +
float(info['feeString']) * 0.3, 2)
total_rebate_amount = round(
float(check_user_res[0][5]) +
float(info['feeString']) * 0.3, 2)
save_money = round(
check_user_res[0][9] +
(float(get_query_info[0][2]) -
float(info['realPayFeeString'])) + add_balance, 2)
total_order_num = int(check_user_res[0][10]) + 1
taobao_order_num = int(check_user_res[0][12]) + 1
add_parent_balance = round(
float(info['feeString']) * 0.1, 2)
friends_rebatr = float(
get_parent_info[0][18]) + float(add_balance)
withdrawals_amount2 = round(
float(get_parent_info[0][8]) +
float(add_balance) * 0.1, 2)
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) +
"', total_rebate_amount='" + str(total_rebate_amount) +
"', order_quantity='" + str(total_order_num) +
"', taobao_order_quantity='" + str(taobao_order_num) +
"', update_time='" + str(time.time()) +
"' WHERE wx_number='" + str(userInfo['NickName']) +
"';")
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount2) + "', friends_rebate='" +
str(friends_rebatr) + "', update_time='" +
str(time.time()) + "' WHERE lnivt_code='" +
str(check_user_res[0][16]) + "';")
cm.ExecNonQuery(
"INSERT INTO taojin_order(username, order_id, order_source) VALUES('"
+ str(userInfo['NickName']) + "', '" + str(order_id) +
"', '2')")
args = {
'username': check_user_res[0][1],
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
args2 = {
'username': get_parent_info[0][1],
'rebate_amount': add_parent_balance,
'type': 4,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args2)
parent_user_text = '''
一一一一 推广信息 一一一一
您的好友【%s】又完成了一笔订单，返利提成%s元已发放到您的账户
回复【个人信息】查询账户信息及提成
''' % (check_user_res[0][3], add_parent_balance)
user_text = '''
一一一一系统消息一一一一
订单【%s】已完成！
返利金%s元已发放到您的个人账户！
回复【提现】可申请账户余额提现
回复【个人信息】可看个当前账户信息
分享【京东商品链接】或者【淘口令】精准查询商品优惠券和返利信息！
分享【VIP视频链接】免费查看高清VIP视频！
优惠券使用教程：
http://t.cn/RnAKqWW
京东优惠券网站：
http://jdyhq.ptjob.net
淘宝优惠券网站：
http://tbyhq.ptjob.net
邀请好友得返利：
http://t.cn/RnAKafe
''' % (order_id, add_balance)
return {
'parent_user_text': parent_user_text,
'user_text': user_text,
'info': 'success',
'parent': get_parent_info[0][1]
}
else:
add_balance = round(float(info['feeString']) * 0.3, 2)
withdrawals_amount = round(
float(check_user_res[0][8]) +
float(info['feeString']) * 0.3, 2)
taobao_rebate_amount = round(
float(check_user_res[0][7]) +
float(info['feeString']) * 0.3, 2)
total_rebate_amount = round(
float(check_user_res[0][5]) +
float(info['feeString']) * 0.3, 2)
save_money = round(
check_user_res[0][9] +
(float(get_query_info[0][2]) -
float(info['realPayFeeString'])) + add_balance, 2)
total_order_num = int(check_user_res[0][10]) + 1
taobao_order_num = int(check_user_res[0][12]) + 1
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) +
"', total_rebate_amount='" + str(total_rebate_amount) +
"', order_quantity='" + str(total_order_num) +
"', taobao_order_quantity='" + str(taobao_order_num) +
"', update_time='" + str(time.time()) +
"' WHERE wx_number='" + str(userInfo['NickName']) +
"';")
cm.ExecNonQuery(
"INSERT INTO taojin_order(username, order_id, order_source) VALUES('"
+ str(userInfo['NickName']) + "', '" + str(order_id) +
"', '2')")
args = {
'username': check_user_res[0][1],
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
user_text = '''
一一一一系统消息一一一一
订单【%s】已完成！
返利金%s元已发放到您的个人账户！
回复【提现】可申请账户余额提现
回复【个人信息】可看个当前账户信息
分享【京东商品链接】或者【淘口令】精准查询商品优惠券和返利信息！
分享【VIP视频链接】免费查看高清VIP视频！
优惠券使用教程：
http://t.cn/RnAKqWW
京东优惠券网站：
http://jdyhq.ptjob.net
淘宝优惠券网站：
http://tbyhq.ptjob.net
邀请好友得返利：
http://t.cn/RnAKafe
''' % (order_id, add_balance)
return {
'user_text': user_text,
'info': 'not_parent_and_success'
}
except Exception as e:
self.logger.debug(e)
return {'info': 'feild'}
def order(self, orderId, msg):
"""
用户发送过来订单号，查询订单是否完成，完成并返利
:param orderId:
:return:
"""
# 获取十分钟之前的订单
m10 = (datetime.datetime.now() -
datetime.timedelta(minutes=10)).strftime("%Y-%m-%d %H:%M:%S")
get_order_url = 'http://api.hitui.net/tbk_order?appkey=JoB3RIns&start_time={m}&span=600&session={session}&tk_status=12'\
.format(m=m10, session=config.get('SYS', 'session'))
print('get_order_url', get_order_url)
response = self.se.get(get_order_url)
print(response.text)
adminuser = self.bot2.friends().search(
config.get('ADMIN', 'ADMIN_USER'))[0]
if 'error_response' in response.text:
text_to_user = '''
一一一一返利信息一一一一
返利失败，可能原因：
1,订单错误请检查重新发送
2,当前订单已经失效或取消
3,当前订单并非本渠道购买
'''
text_to_admin = '''
一一一一返利信息一一一一
订单返利失败,订单号为{id}
用户为{user}
'''.format(id=orderId, user=msg.sender.nick_name)
adminuser.send(text_to_admin)
return text_to_user
if str(orderId) not in response.text:
to_user = '''
一一一一返利信息一一一一
返利失败，可能原因：
1,订单错误请检查重新发送
2,当前订单已经失效或取消
3,当前订单并非本渠道购买
'''
return to_user
data = json.loads(
response.text
)['tbk_sc_order_get_response']['results']['n_tbk_order']
for item in data:
if int(item['trade_id']) == int(orderId):
# 计算返利金额
fx = round(
float(item['pub_share_pre_fee']) *
float(config.get('BN', 'bn3t')), 2)
print(fx)
fx_pp = round(float(fx) * float(config.get('BN', 'bn4')), 2)
try:
cm = ConnectMysql()
# 查询用户是否有上线
check_user_sql = "SELECT * FROM taojin_user_info WHERE puid='" + msg.sender.puid + "' AND bot_puid='" + self.bot2.self.puid + "';"
check_user_res = cm.ExecQuery(check_user_sql)
# 定义SQL语句 查询用户是否已经存在邀请人
# 判断是否已经有邀请人了
if check_user_res and check_user_res[0][17] != '0':
# 获取邀请人信息
get_parent_sql = "SELECT * FROM taojin_user_info WHERE lnivt_code='" + str(
check_user_res[0][17]
) + "' AND bot_puid='" + self.bot2.self.puid + "';"
get_parent_info = cm.ExecQuery(get_parent_sql)
# 计算返佣
add_balance = fx
# 累加余额
withdrawals_amount = round(
float(check_user_res[0][9]) + add_balance, 2)
# 累加淘宝总返利
taobao_rebate_amount = round(
float(check_user_res[0][8]) + add_balance, 2)
# 累加总返利
total_rebate_amount = round(
float(check_user_res[0][6]) + add_balance, 2)
jishen = fx
# 计算共节省金额,商品原价减去实际支付价格，加上原有节省金额加上返佣
save_money = round(
check_user_res[0][10] + jishen + add_balance, 2)
# 总订单数加一
total_order_num = int(check_user_res[0][11]) + 1
# 淘宝订单数加一
taobao_order_num = int(check_user_res[0][13]) + 1
# 邀请人返利金额
add_parent_balance = fx_pp
# 给邀请人好友返利加上金额
friends_rebatr = round(
float(get_parent_info[0][19]) +
float(add_parent_balance))
# 邀请人总钱数加上返利金额
withdrawals_amount2 = round(
float(get_parent_info[0][9]) +
float(add_parent_balance), 2)
cm.InsertM(
"UPDATE taojin_user_info SET withdrawals_amount='"
+ str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) +
"', total_rebate_amount='" +
str(total_rebate_amount) + "', order_quantity='" +
str(total_order_num) +
"', taobao_order_quantity='" +
str(taobao_order_num) + "', update_time='" +
str(time.time()) + "' WHERE puid='" +
msg.sender.puid + "' AND bot_puid='" +
self.bot2.self.puid + "';")
cm.InsertM(
"UPDATE taojin_user_info SET withdrawals_amount='"
+ str(withdrawals_amount2) +
"', friends_rebate='" + str(friends_rebatr) +
"', update_time='" + str(time.time()) +
"' WHERE lnivt_code='" +
str(check_user_res[0][17]) + "' AND bot_puid='" +
self.bot2.self.puid + "';")
insert_to_sql = "INSERT INTO taojin_order(wx_bot, username, order_id, status, completion_time, order_source, puid, bot_puid, order_price, total_commission_rate, total_commission_fee) \
VALUES ('" + self.bot2.self.nick_name + "', '" + msg.sender.nick_name + "', '" + str(
orderId) + "', '2','" \
+ item[
'create_time'] + "', '2', '" + msg.sender.puid + "', '" + self.bot2.self.puid + "', '" + str(
item['alipay_total_price']) + "', '" + str(
item['total_commission_rate']) + "' , '" + str(fx) + "')"
# 把订单插入数据库
cm.InsertM(insert_to_sql)
# select_order_num = "SELECT * FROM taojin_order WHERE puid='" + puid + "' AND bot_puid='" + self.bot.self.puid + "'"
# 订单已完成，修改备注
'''order_num = cm.ExecQuery(select_order_num)
if order_num == ():
split_arr = this_user.remark_name.split('_')
new_remark_name = '%s%s%s%s%s%s%s' % (split_arr[0], '_', split_arr[1], '_', 'C', '_', split_arr[3])
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
cm.ExecNonQuery("UPDATE taojin_order SET status=2 WHERE order_id='"+str(orderInfo[1])+"'")
# 累计订单数量
order_nums = cm.ExecQuery(select_order_num)
split_arr2 = this_user.remark_name.split('_')
new_remark_name2 = '%s%s%s%s%s%s%s' % (split_arr2[0], '_', split_arr2[1], '_', split_arr2[2], '_', len(order_nums))
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name2)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name2+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
'''
args = {
'wx_bot': self.bot2.self.nick_name,
'bot_puid': self.bot2.self.puid,
'username': check_user_res[0][4],
'puid': msg.sender.puid,
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
parent_puid = get_parent_info[0][2]
args2 = {
'wx_bot': self.bot2.self.nick_name,
'bot_puid': self.bot2.self.puid,
'username': get_parent_info[0][4],
'puid': parent_puid,
'rebate_amount': add_parent_balance,
'type': 4,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args2)
parent_user_text = '''
一一一一 推广信息 一一一一
好友【%s】又完成一笔订单
返利提成%s元已发放到个人账户
回复【个人信息】可查询账户详情
''' % (check_user_res[0][4],
add_parent_balance)
user_text = '''
一一一一系统消息一一一一
订单【%s】返利成功
返利金%s元已发放到个人账户
回复【个人信息】可查询账户详情
回复【提现】可申请账户余额提现
''' % (orderId, add_balance)
# 提交事务，并关闭数据库连接
cm.CommitMysql()
cm.Close()
parent_user = self.bot2.friends().search(
nick_name=get_parent_info[0][4])[0]
parent_user.send(parent_user_text)
return user_text
else:
add_balance = fx
withdrawals_amount = round(
float(check_user_res[0][9]) + add_balance, 2)
taobao_rebate_amount = round(
float(check_user_res[0][8]) + add_balance, 2)
total_rebate_amount = round(
float(check_user_res[0][6]) + add_balance, 2)
jishen = add_balance
if jishen < 0:
jishen = 0
save_money = round(
check_user_res[0][10] + jishen + add_balance, 2)
total_order_num = int(check_user_res[0][11]) + 1
taobao_order_num = int(check_user_res[0][13]) + 1
cm.InsertM(
"UPDATE taojin_user_info SET withdrawals_amount='"
+ str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) +
"', total_rebate_amount='" +
str(total_rebate_amount) + "', order_quantity='" +
str(total_order_num) +
"', taobao_order_quantity='" +
str(taobao_order_num) + "', update_time='" +
str(time.time()) + "' WHERE puid='" +
msg.sender.puid + "' AND bot_puid='" +
self.bot2.self.puid + "';")
insert_to_sql = "INSERT INTO taojin_order(wx_bot, username, order_id, status, completion_time, order_source, puid, bot_puid, order_price, total_commission_rate, total_commission_fee) \
VALUES ('" + self.bot2.self.nick_name + "', '" + msg.sender.nick_name + "', '" + str(orderId) + "', '2','" \
+ item['create_time'] + "', '2', '" + msg.sender.puid + "', '" + self.bot2.self.puid + "', '" + str(item['alipay_total_price']) + "', '" + str(item['total_commission_rate']) + "' , '" + str(fx) + "')"
# 把订单插入数据库
cm.InsertM(insert_to_sql)
# select_order_num = "SELECT * FROM taojin_order WHERE puid='" + puid + "' AND bot_puid='" + self.bot.self.puid + "'"
# 订单已完成，修改备注
'''order_num = cm.ExecQuery(select_order_num)
if order_num == ():
split_arr = this_user.remark_name.split('_')
new_remark_name = '%s%s%s%s%s%s%s' % (split_arr[0], '_', split_arr[1], '_', 'C', '_', split_arr[3])
self.logger.debug(new_remark_name)
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
cm.ExecNonQuery("UPDATE taojin_order SET status=2 WHERE order_id='"+str(orderInfo[1])+"'")
# 累计订单数量
order_nums = cm.ExecQuery(select_order_num)
split_arr2 = this_user.remark_name.split('_')
new_remark_name2 = '%s%s%s%s%s%s%s' % (split_arr2[0], '_', split_arr2[1], '_', split_arr2[2], '_', len(order_nums))
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name2)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name2+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")'''
args = {
'wx_bot': self.bot2.self.nick_name,
'bot_puid': self.bot2.self.puid,
'username': check_user_res[0][4],
'puid': msg.sender.puid,
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
user_text = '''
一一一一系统消息一一一一
订单【%s】返利成功
返利金%s元已发放到个人账户
回复【个人信息】可查询账户详情
回复【提现】可申请账户余额提现
''' % (orderId, add_balance)
cm.CommitMysql()
cm.Close()
return user_text
except Exception as e:
cm.Rollback()
trace = traceback.format_exc()
self.logger.warning("error:{},trace:{}".format(
str(e), trace))
text_to_admin = '''
一一一一返利信息一一一一
订单返利失败,订单号为{id}
用户为{user}
'''.format(id=orderId,
user=msg.sender.nick_name)
adminuser.send(text_to_admin)
t = '''
一一一一一 订单信息 一一一一一
订单返利失败，以联系管理员
请等待处理！
'''
return t
def getTaobaoOrder(self):
if self.config.get('SYS', 'tb') == 'yes':
while True:
nowtime = time.strftime('%H:%M', time.localtime(time.time()))
if self.config.get('TIME',
'tbend') > nowtime > self.config.get(
'TIME', 'tbstart'):
cm = ConnectMysql()
# 前60天的时间
yesterDay = datetime.date.today() - datetime.timedelta(
days=60)
# 定义订单的几种状态，便于存储
status = {'订单结算': 1, '订单付款': 2, '订单失效': 3, '订单成功': 4}
# 请求订单接口
url = 'http://tuijian.ptjob.net/phpsdk/sdkList/orderGet.php?startTime=' + str(
yesterDay) + '&endTime=' + str(datetime.date.today())
print('!!!!!!!!!!!Order Get Url is', url)
res = self.se.get(url)
# print('Get the orders', res.text)
# 转json
resj = json.loads(res.text)
print(len(resj))
# 数据存入数据库
for item in resj:
is_sql = "SELECT * FROM taojin_get_orders WHERE order_id='" + item[
'cate'] + "';"
# 判断数据是否存在
is_ext = cm.ExecQuery(is_sql)
if is_ext == ():
in_sql = "INSERT INTO taojin_get_orders(order_id, good_id, good_name, good_price, good_num, order_price, order_source, order_status, order_commission, create_time, settlement_time, bot_puid) VALUES('" + str(
item['cate']
) + "', '" + str(
item['good_id']
) + "', '" + item['good_title'] + "', '" + str(
item['good_price']
) + "', '" + str(item['good_num']) + "', '" + str(
item['amount_pay']) + "', '1', '" + str(
status[item['order_state']]
) + "', '" + item[
'commission_percent'] + "', '" + str(
item['add_time']) + "', '" + str(
item['settlement_time']
) + "', '" + self.bot.self.puid + "')"
cm.ExecNonQuery(in_sql)
else:
del_sql = "DELETE FROM taojin_get_orders WHERE order_id='" + item[
'cate'] + "';"
cm.ExecNonQuery(del_sql)
in_sql = "INSERT INTO taojin_get_orders(order_id, good_id, good_name, good_price, good_num, order_price, order_source, order_status, order_commission, create_time, settlement_time, bot_puid) VALUES('" + str(
item['cate']
) + "', '" + str(
item['good_id']
) + "', '" + item['good_title'] + "', '" + str(
item['good_price']
) + "', '" + str(item['good_num']) + "', '" + str(
item['amount_pay']) + "', '1', '" + str(
status[item['order_state']]
) + "', '" + item[
'commission_percent'] + "', '" + str(
item['add_time']) + "', '" + str(
item['settlement_time']
) + "', '" + self.bot.self.puid + "')"
cm.ExecNonQuery(in_sql)
# 获取用户的订单
user_orders = cm.ExecQuery(
"SELECT * FROM taojin_order WHERE status='1' AND order_source = '1' AND bot_puid='"
+ self.bot.self.puid + "' AND completion_time>'" +
str(yesterDay) + "';")
user_orders_id_list = []
for item in user_orders:
user_orders_id_list.append(item[3])
# 把获取到的订单信息收集到list里，方便操作数据
orders_list = []
for item2 in resj:
orders_list.append(item2['cate'])
# 遍历用户订单和获取到的订单对比，根据订单状态不同给用户返利或不返利
for item3 in user_orders_id_list:
if item3 in orders_list:
userOrder = cm.ExecQuery(
"SELECT * FROM taojin_get_orders WHERE order_id="
+ item3 + "")
userOrder2 = cm.ExecQuery(
"SELECT * FROM taojin_order WHERE order_id=" +
item3 + "")
userInfo = cm.ExecQuery(
"SELECT * FROM taojin_user_info WHERE puid='" +
userOrder2[0][7] + "'")
# 根据订单状态进行回复和结算奖金
if userOrder[0][7] == 4 or userOrder[0][7] == 1:
# 已结算
self.changeInfoAlimama(userOrder2[0][7],
userOrder[0])
up_set_sql = "UPDATE taojin_order SET status='2' WHERE order_id='" + str(
item3) + "';"
cm.ExecNonQuery(up_set_sql)
elif userOrder[0][7] == 3:
send_text = '''
---------- 订单信息 -----------
订单【%s】已失效
''' % (item3)
up_set_sql = "UPDATE taojin_order SET status='2' WHERE order_id='" + str(
item3) + "';"
cm.ExecNonQuery(up_set_sql)
user = self.bot.friends().search(
nick_name=userInfo[0][4])[0]
user.send(send_text)
else:
userOrder = cm.ExecQuery(
"SELECT * FROM taojin_order WHERE order_id=" +
item3 + "")
userInfo = cm.ExecQuery(
"SELECT * FROM taojin_user_info WHERE puid='" +
userOrder[0][7] + "'")
send_text = '''
---------订单消息----------
订单【%s】返利失败
该笔订单非通过机器人购买
''' % (item3)
up_set_sql = "UPDATE taojin_order SET status='2' WHERE order_id='" + str(
item3) + "';"
cm.ExecNonQuery(up_set_sql)
user = self.bot.friends().search(
nick_name=userInfo[0][4])[0]
user.send(send_text)
time.sleep(7200)
else:
print('!!!! tb time not start, now time is %s .......' %
nowtime)
time.sleep(1800)
continue
def getJd(self, raw, bot, msg, good_url):
if config.get('SYS', 'jd') == 'no':
text = '''
一一一一系统信息一一一一
亲，暂不支持京东链接哦
'''
return text
cm = ConnectMysql()
try:
# 用户第一次查询，修改备注
query_good = cm.ExecQuery("SELECT * FROM taojin_query_record WHERE puid='"+raw.sender.puid+"' AND bot_puid='"+bot.self.puid+"'")
if query_good == ():
se = re.compile('^(\d+)_(\d+)_\w_(\d)+$')
if se.search(raw.sender.remark_name) == None:
remarkName = self.ort.generateRemarkName(bot)
split_arr2 = remarkName.split('_')
new_remark_name2 = '%s%s%s%s%s%s%s' % (split_arr2[0], '_', split_arr2[1], '_', 'B', '_', split_arr2[3])
bot.core.set_alias(userName=raw.sender.user_name, alias=new_remark_name2)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name2+"' WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "'")
else:
split_arr = raw.sender.remark_name.split('_')
new_remark_name = '%s%s%s%s%s%s%s' % (split_arr[0], '_', split_arr[1], '_', 'B', '_', split_arr[3])
bot.core.set_alias(userName=raw.sender.user_name, alias=new_remark_name)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name+"' WHERE puid='" + raw.sender.puid + "' AND bot_puid='" + bot.self.puid + "'")
print('开始查询分享商品的信息......'+msg['Text'])
bot_puid = bot.self.puid
sku_arr = good_url.split('https://item.m.jd.com/product/')
if sku_arr == None:
if config.get('SYS', 'tl') == 'yes':
msg_text = self.tu.tuling(msg)
return msg_text
else:
return
sku = sku_arr[1].split('.')
res = self.get_good_link(sku[0])
if res['data']['shotCouponUrl'] == '':
text = '''
一一一一京东返利信息一一一一
【商品名】%s
【京东价】%s元
【返红包】%s元
返利链接:%s
获取返红包步骤：
1,点击商品链接并进行下单
2,下完单后复制订单号发给我
''' % (res['logTitle'], res['logUnitPrice'], res['rebate'], res['data']['shotUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, skuid, type) VALUES('"+ bot.self.nick_name +"', '" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '0', '" + raw.sender.nick_name + "', '" + str(time.time()) + "', '"+ raw.sender.puid +"', '"+ bot_puid +"', '"+ res['skuid'] +"', '1')"
cm.ExecNonQuery(insert_sql)
return text
else:
text = '''
一一一一京东返利信息一一一一
【商品名】%s
【京东价】%s元
【优惠券】%s元
【券后价】%s元
【返红包】%s元
领券链接:%s
获取返红包步骤：
1,复制本条消息打开淘宝领券
2,下完单后复制订单号发给我
''' % (
res['logTitle'], res['logUnitPrice'], res['youhuiquan_price'], res['coupon_price'], res['rebate'],
res['data']['shotCouponUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, skuid, type) VALUES('"+ bot.self.nick_name +"', '" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '" + res['coupon_price2'] + "', '" + raw.sender.nick_name + "', '" + str(time.time()) + "', '"+ raw.sender.puid +"', '"+ bot_puid +"', '"+ res['skuid'] +"', '1')"
cm.ExecNonQuery(insert_sql)
return text
except Exception as e:
trace = traceback.format_exc()
self.logger.warning("error:{},trace:{}".format(str(e), trace))
text = '''
一一一一 返利信息 一一一一
亲，当前商品暂无优惠券,建议您换一个商品试试呢,您也可以在下边的优惠券商城中查找哦
京东优惠券商城：
'''+config.get('URL', 'jdshop')+'''
淘宝优惠券商城：
'''+config.get('URL', 'tbshop')+'''
邀请好友得返利说明：
'''+config.get('URL', 'lnvit')+'''
'''
return text
def get_order(self, msg, times, orderId, userInfo):
timestr = re.sub('-', '', times)
order_id = int(orderId)
cm = ConnectMysql()
# 查询用户是否有上线
check_order_sql = "SELECT * FROM taojin_order WHERE order_id='" + str(
order_id) + "';"
check_order_res = cm.ExecQuery(check_order_sql)
# 判断该订单是否已经提现
if len(check_order_res) >= 1:
cm.Close()
send_text = '''
一一一一 订单消息 一一一一
订单【%s】已经成功返利，请勿重复提交订单信息！
回复【个人信息】 查看订单及返利信息
如有疑问！请联系管理员
''' % (msg['Text'])
return {"info": "order_exit", "send_text": send_text}
endTime = time.strftime('%Y-%m-%d', time.localtime(time.time()))
startTime = str((datetime.date.today() - relativedelta(months=+1)))
t = str(round(time.time()))
try:
url = "http://pub.alimama.com/report/getTbkPaymentDetails.json?startTime=" + startTime + "&endTime=" + endTime + "&payStatus=3&queryType=1&toPage=1&perPageSize=50&total=&t=" + t + "&pvid=&_tb_token_=f8b388e3f3e37&_input_charset=utf-8"
headers = {
"Accept": "application/json, text/javascript, */*; q=0.01",
"Accept-Encoding": "gzip, deflate",
"Accept-Language": "zh-CN,zh;q=0.9,en-US;q=0.8,en;q=0.7",
"Cache-Control": "no-cache",
"Content-Type":
"application/x-www-form-urlencoded; charset=UTF-8",
"Host": "pub.alimama.com",
"Pragma": "no-cache",
"Referer":
"http://pub.alimama.com/myunion.htm?spm=a219t.7900221/1.a214tr8.2.3d7c75a560ieiE",
"User-Agent":
"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0",
"X-Requested-With": "XMLHttpRequest"
}
res = self.get_url(url, headers)
res_dict = json.loads(res.text)
print(res_dict, url)
for item in res_dict['data']['paymentList']:
if int(order_id) == int(item['taobaoTradeParentId']):
res = self.changeInfo(msg, item, order_id, userInfo)
return res
user_text = '''
一一一一订单信息一一一一
订单返利失败！
失败原因：
【1】未确认收货（打开App确认收货后重新发送）
【2】当前商品不是通过机器人购买
【3】查询格式不正确(正确格式：2018-03-20,73462222028 )
【4】订单完成日期错误，请输入正确的订单查询日期
【6】订单号错误，请输入正确的订单号
请按照提示进行重新操作！
'''
return {'info': 'not_order', 'user_text': user_text}
except Exception as e:
self.logger.debug(e)
return {"info": "feild"}
def getGroupJd(self, bot, msg, good_url, raw):
if config.get('SYS', 'jd') == 'no':
text = '''
一一一一系统信息一一一一
亲，暂不支持京东链接
'''
return text
cm = ConnectMysql()
try:
wei_info = bot.core.search_chatrooms(userName=msg['FromUserName'])
puid = raw.member.puid
bot_puid = bot.self.puid
sku_arr = good_url.split('https://item.m.jd.com/product/')
if sku_arr == None:
return
sku = sku_arr[1].split('.')
res = self.get_good_link(sku[0])
if res['data']['shotCouponUrl'] == '':
text = '''
一一一一京东返利信息一一一一
【商品名】%s
【京东价】%s元
【返红包】%s元
返利链接:%s
获取返红包步骤：
1,点击商品链接并进行下单
2,点击头像添加机器人好友
3,下完单后复制订单号发给我
''' % (res['logTitle'], res['logUnitPrice'], res['rebate'], res['data']['shotUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, chatroom, skuid, type) VALUES('"+ bot.self.nick_name +"', '" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '0', '" + msg[
'ActualNickName'] + "', '" + str(time.time()) + "', '"+ puid +"', '"+ bot_puid +"', '"+ wei_info['NickName'] +"', '"+ res['skuid'] +"', '1')"
cm.ExecNonQuery(insert_sql)
return text
else:
text = '''
一一一一京东返利信息一一一一
【商品名】%s
【京东价】%s元
【优惠券】%s元
【券后价】%s元
【返红包】%s元
领券链接:%s
获取返红包步骤：
1,复制本条消息打开淘宝领券
2,点击头像添加机器人好友
3,下完单后复制订单号发给我
''' % (
res['logTitle'], res['logUnitPrice'], res['youhuiquan_price'], res['coupon_price'], res['rebate'],
res['data']['shotCouponUrl'])
insert_sql = "INSERT INTO taojin_query_record(wx_bot, good_title, good_price, good_coupon, username, create_time, puid, bot_puid, chatroom, skuid, type) VALUES('"+ bot.self.nick_name +"', '" + \
res['logTitle'] + "', '" + str(res['logUnitPrice']) + "', '" + res['coupon_price2'] + "', '" + \
msg['ActualNickName'] + "', '" + str(time.time()) + "', '"+ puid +"', '"+ bot_puid +"', '"+ wei_info['NickName'] +"', '"+ res['skuid'] +"', '1')"
cm.ExecNonQuery(insert_sql)
return text
except Exception as e:
text = '''
一一一一 返利信息 一一一一
亲，当前商品暂无优惠券,建议您换一个商品试试呢,您也可以在下边的优惠券商城中查找哦
京东优惠券商城：
'''+config.get('URL', 'jdshop')+'''
淘宝优惠券商城：
'''+config.get('URL', 'tbshop')+'''
邀请好友得返利说明：
'''+config.get('URL', 'lnvit')+'''
'''
return text
import random
from libs import utils
from urllib.parse import quote
from itchat.content import *
from libs.mediaJd import MediaJd
from libs.alimama import Alimama
from libs.mysql import ConnectMysql
from bs4 import BeautifulSoup
from libs.groupMessage import FormData
from libs.movie import SharMovie
from libs import utils
from libs.tuling import tuling
from libs.wx_bot import *
from libs.orther import Orther
cm = ConnectMysql()
logger = utils.init_logger()
al = Alimama(logger)
mjd = MediaJd()
tu = tuling()
ort = Orther()
class TextMessage(object):
def __init__(self):
pass
def getText(self, msg):
wei_info = itchat.search_friends(userName=msg['FromUserName'])
bot_info = itchat.search_friends(userName=msg['ToUserName'])
def changeInfoAlimama(self, puid, orderInfo):
try:
cm = ConnectMysql()
# 查询用户是否有上线
check_user_sql = "SELECT * FROM taojin_user_info WHERE puid='" + puid + "' AND bot_puid='" + self.bot.self.puid + "';"
check_user_res = cm.ExecQuery(check_user_sql)
this_user = self.bot.friends().search(
nick_name=check_user_res[0][4])[0]
# 定义SQL语句 查询用户是否已经存在邀请人
# 判断是否已经有邀请人了
if check_user_res and check_user_res[0][17] != '0':
# 获取邀请人信息
get_parent_sql = "SELECT * FROM taojin_user_info WHERE lnivt_code='" + str(
check_user_res[0]
[17]) + "' AND bot_puid='" + self.bot.self.puid + "';"
get_parent_info = cm.ExecQuery(get_parent_sql)
# 计算返佣
add_balance = round(
float(orderInfo[9]) * float(self.config.get('BN', 'bn3t')),
2)
# 累加余额
withdrawals_amount = round(
float(check_user_res[0][9]) + add_balance, 2)
# 累加淘宝总返利
taobao_rebate_amount = round(
float(check_user_res[0][8]) + add_balance, 2)
# 累加总返利
total_rebate_amount = round(
float(check_user_res[0][6]) + add_balance, 2)
jishen = round(
float(orderInfo[4]) * float(orderInfo[5]) -
float(orderInfo[6]))
if jishen < 0:
jishen = 0
# 计算共节省金额,商品原价减去实际支付价格，加上原有节省金额加上返佣
save_money = round(
check_user_res[0][10] + jishen + add_balance, 2)
# 总订单数加一
total_order_num = int(check_user_res[0][11]) + 1
# 淘宝订单数加一
taobao_order_num = int(check_user_res[0][13]) + 1
# 邀请人返利金额
add_parent_balance = round(
float(orderInfo[9]) * float(self.config.get('BN', 'bn4')),
2)
# 给邀请人好友返利加上金额
friends_rebatr = round(
float(get_parent_info[0][19]) + float(add_parent_balance))
# 邀请人总钱数加上返利金额
withdrawals_amount2 = round(
float(get_parent_info[0][9]) + float(add_parent_balance),
2)
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) + "', total_rebate_amount='" +
str(total_rebate_amount) + "', order_quantity='" +
str(total_order_num) + "', taobao_order_quantity='" +
str(taobao_order_num) + "', update_time='" +
str(time.time()) + "' WHERE puid='" + puid +
"' AND bot_puid='" + self.bot.self.puid + "';")
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount2) + "', friends_rebate='" +
str(friends_rebatr) + "', update_time='" +
str(time.time()) + "' WHERE lnivt_code='" +
str(check_user_res[0][17]) + "' AND bot_puid='" +
self.bot.self.puid + "';")
#select_order_num = "SELECT * FROM taojin_order WHERE puid='" + puid + "' AND bot_puid='" + self.bot.self.puid + "'"
# 订单已完成，修改备注
'''order_num = cm.ExecQuery(select_order_num)
if order_num == ():
split_arr = this_user.remark_name.split('_')
new_remark_name = '%s%s%s%s%s%s%s' % (split_arr[0], '_', split_arr[1], '_', 'C', '_', split_arr[3])
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
cm.ExecNonQuery("UPDATE taojin_order SET status=2 WHERE order_id='"+str(orderInfo[1])+"'")
# 累计订单数量
order_nums = cm.ExecQuery(select_order_num)
split_arr2 = this_user.remark_name.split('_')
new_remark_name2 = '%s%s%s%s%s%s%s' % (split_arr2[0], '_', split_arr2[1], '_', split_arr2[2], '_', len(order_nums))
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name2)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name2+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
'''
args = {
'wx_bot': self.bot.self.nick_name,
'bot_puid': self.bot.self.puid,
'username': check_user_res[0][4],
'puid': puid,
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
parent_puid = get_parent_info[0][2]
args2 = {
'wx_bot': self.bot.self.nick_name,
'bot_puid': self.bot.self.puid,
'username': get_parent_info[0][4],
'puid': parent_puid,
'rebate_amount': add_parent_balance,
'type': 4,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args2)
parent_user_text = '''
一一一一 推广信息 一一一一
好友【%s】又完成一笔订单
返利提成%s元已发放到个人账户
回复【个人信息】可查询账户详情
''' % (check_user_res[0][4], add_parent_balance)
user_text = '''
一一一一系统消息一一一一
订单【%s】返利成功
返利金%s元已发放到个人账户
回复【个人信息】可查询账户详情
回复【提现】可申请账户余额提现
''' % (orderInfo[1], add_balance)
cm.Close()
parent_user = self.bot.friends().search(
nick_name=get_parent_info[0][4])[0]
parent_user.send(parent_user_text)
this_user.send(user_text)
else:
add_balance = round(
float(orderInfo[9]) * float(self.config.get('BN', 'bn3t')),
2)
withdrawals_amount = round(
float(check_user_res[0][9]) + add_balance, 2)
taobao_rebate_amount = round(
float(check_user_res[0][8]) + add_balance, 2)
total_rebate_amount = round(
float(check_user_res[0][6]) + add_balance, 2)
jishen = add_balance
if jishen < 0:
jishen = 0
save_money = round(
check_user_res[0][10] + jishen + add_balance, 2)
total_order_num = int(check_user_res[0][11]) + 1
taobao_order_num = int(check_user_res[0][13]) + 1
cm.ExecNonQuery(
"UPDATE taojin_user_info SET withdrawals_amount='" +
str(withdrawals_amount) + "', save_money='" +
str(save_money) + "', taobao_rebate_amount='" +
str(taobao_rebate_amount) + "', total_rebate_amount='" +
str(total_rebate_amount) + "', order_quantity='" +
str(total_order_num) + "', taobao_order_quantity='" +
str(taobao_order_num) + "', update_time='" +
str(time.time()) + "' WHERE puid='" + puid +
"' AND bot_puid='" + self.bot.self.puid + "';")
#select_order_num = "SELECT * FROM taojin_order WHERE puid='" + puid + "' AND bot_puid='" + self.bot.self.puid + "'"
# 订单已完成，修改备注
'''order_num = cm.ExecQuery(select_order_num)
if order_num == ():
split_arr = this_user.remark_name.split('_')
new_remark_name = '%s%s%s%s%s%s%s' % (split_arr[0], '_', split_arr[1], '_', 'C', '_', split_arr[3])
self.logger.debug(new_remark_name)
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")
cm.ExecNonQuery("UPDATE taojin_order SET status=2 WHERE order_id='"+str(orderInfo[1])+"'")
# 累计订单数量
order_nums = cm.ExecQuery(select_order_num)
split_arr2 = this_user.remark_name.split('_')
new_remark_name2 = '%s%s%s%s%s%s%s' % (split_arr2[0], '_', split_arr2[1], '_', split_arr2[2], '_', len(order_nums))
bot.core.set_alias(userName=this_user.user_name, alias=new_remark_name2)
cm.ExecNonQuery("UPDATE taojin_user_info SET remarkname = '"+new_remark_name2+"' WHERE puid='" + puid + "' AND bot_puid='" + bot.self.puid + "'")'''
args = {
'wx_bot': self.bot.self.nick_name,
'bot_puid': self.bot.self.puid,
'username': check_user_res[0][4],
'puid': puid,
'rebate_amount': add_balance,
'type': 3,
'create_time': time.time()
}
# 写入返利日志
cm.InsertRebateLog(args)
user_text = '''
一一一一系统消息一一一一
订单【%s】返利成功
返利金%s元已发放到个人账户
回复【个人信息】可查询账户详情
回复【提现】可申请账户余额提现
''' % (orderInfo[1], add_balance)
cm.Close()
this_user.send(user_text)
except Exception as e:
trace = traceback.format_exc()
self.logger.warning("error:{},trace:{}".format(str(e), trace))
return {'info': 'feild'}
