def sync_order(): global modian_handler my_logger.info('同步订单') for modian in global_config.MODIAN_ARRAY: pro_id = modian.group_account_id orders = modian_handler.get_all_orders(modian) for order in orders: user_id = order['user_id'] nickname = order['nickname'] pay_time = order['pay_time'] backer_money = order['backer_money'] oid = uuid.uuid3(uuid.NAMESPACE_OID, str(user_id) + pay_time) # print('oid: %s', oid) rst = mysql_util.select_one( """ select * from `order` where id='%s' """, (str(oid), )) if len(rst) == 0: my_logger.info('该订单不在数据库中') # 每次需要更新一下昵称 mysql_util.query(""" INSERT INTO `supporter` (`id`, `name`) VALUES (%s, '%s') ON DUPLICATE KEY UPDATE `name`='%s' """ % (user_id, nickname, nickname)) mysql_util.query(""" INSERT INTO `order` (`id`, `supporter_id`, `backer_money`, `pay_time`, `pro_id`) VALUES ('%s', %s, %s, '%s', %s); """ % (oid, user_id, backer_money, pay_time, pro_id)) msg = '【机器人补播报】感谢 %s 支持了%s元, %s\n' % ( nickname, backer_money, util.random_str(global_config.MODIAN_POSTSCRIPTS)) # QQHandler.send_to_groups(['483548995'], msg) modian_handler.order_queues[modian.group_account_id].add(oid)
def get_member_room_msg_lite(self): """ 发送成员房间消息(简易版,只提醒在房间里出现) :return: """ time_now = time.time() msg = '' if self.unread_other_member_msg_amount > 0 and len( self.member_room_msg_lite_groups) > 0: if self.last_other_member_msg_time < 0 or time_now - self.last_other_member_msg_time >= 10 * 60: DEBUG('其他成员出现在房间中') member_name = ', '.join(self.other_members_names) QQHandler.send_to_groups(self.member_room_msg_lite_groups, '%s来你们灰的房间里串门啦~' % member_name) self.unread_other_member_msg_amount = 0 self.last_other_member_msg_time = time_now if self.unread_msg_amount > 0 and len( self.member_room_msg_lite_groups) > 0: # 距离上一次提醒时间超过10分钟且有未读消息 if self.last_msg_time < 0 or time_now - self.last_msg_time >= 10 * 60: DEBUG('向大群发送简易版提醒') msg = util.random_str(global_config.ROOM_MSG_LITE_NOTIFY) QQHandler.send_to_groups(self.member_room_msg_lite_groups, msg) INFO(msg) self.unread_msg_amount = 0 else: DEBUG('不向大群发送简易版提醒') self.last_msg_time = time_now else: INFO('最近10分钟内没有未读消息')
def set_password(self, new_password): salt = random_str() password_md5 = md5(new_password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() self.salt = salt self.password = password_final self.save()
def refresh_key(self): session = DBSession() self.key = random_str(32) self.key_time = int(time.time()) session.add(self) session.commit() session.close()
def new(username, nickname, password): salt = random_str() password_md5 = md5(password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() level = USER_LEVEL.NORMAL # 首个用户赋予admin权限 the_time = int(time.time()) ret = User.create( username=username, nickname=nickname, password=password_final, salt=salt, level=level, key=random_str(32), key_time=the_time, ) ret.save() return ret
def new(username, nickname, password): salt = random_str() password_md5 = md5(password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() level = USER_LEVEL.NORMAL # 首个用户赋予admin权限 the_time = int(time.time()) ret = User.create(username=username, nickname=nickname, password=password_final, salt=salt, level=level, key=random_str(32), key_time = the_time, ) ret.save() return ret
def set_password(self, new_password): salt = random_str() password_md5 = md5(new_password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() session = DBSession() self.salt = salt self.password = password_final session.add(self) session.commit() session.close()
def new(cls, username, password): salt = random_str() password_md5 = md5(password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() level = USER_LEVEL.ADMIN if cls.count( ) == 0 else USER_LEVEL.NORMAL # 首个用户赋予admin权限 the_time = int(time.time()) session = DBSession() ret = User( username=username, password=password_final, openid=openid, salt=salt, level=level, key=random_str(32), key_time=the_time, ) session.add(ret) session.commit() session.close() return ret
def new(cls, username, password): salt = random_str() password_md5 = md5(password.encode('utf-8')).hexdigest() password_final = md5((password_md5 + salt).encode('utf-8')).hexdigest() level = USER_LEVEL.ADMIN if cls.count() == 0 else USER_LEVEL.NORMAL # 首个用户赋予admin权限 the_time = int(time.time()) session = DBSession() ret = User(username=username, password=password_final,openid=openid , salt=salt, level=level, key=random_str(32), key_time = the_time, ) session.add(ret) session.commit() session.close() return ret
def get_member_room_msg_lite(self, task): """ 发送成员房间消息提醒(简易版,只提醒在房间里出现) :param task: :return: """ time_now = time.time() msg = '' logger.debug('timenow: %s', time_now) logger.debug('unread_other_member_msg_amount=%s', task.unread_other_member_msg_amount) logger.debug('last_other_member_msg_time: %s', task.last_other_member_msg_time) logger.debug('time_now - self.last_other_member_msg_time: %s', time_now - task.last_other_member_msg_time) if task.unread_other_member_msg_amount > 0 and len( task.member_room_msg_lite_groups) > 0: if task.last_other_member_msg_time < 0 or time_now - task.last_other_member_msg_time >= 10 * 60: logger.debug('其他成员出现在房间中') member_name = ', '.join(task.other_members_names) # QQHandler.send_to_groups(task.member_room_msg_lite_groups, '%s来你们灰的房间里串门啦~' % member_name) task.unread_other_member_msg_amount = 0 task.last_other_member_msg_time = time_now task.other_members_names.clear() logger.debug('unread_msg_amount=%s', task.unread_msg_amount) logger.debug('last_msg_time: %s', task.last_msg_time) logger.debug('time_now - self.last_msg_time: %s', time_now - task.last_msg_time) if task.unread_msg_amount > 0 and len( task.member_room_msg_lite_groups) > 0: # 距离上一次提醒时间超过10分钟且有未读消息 if task.last_msg_time < 0 or time_now - task.last_msg_time >= 10 * 60: logger.debug('向大群发送简易版提醒') msg = util.random_str(global_config.ROOM_MSG_LITE_NOTIFY) if global_config.USING_COOLQ_PRO: msg += '[CQ:image,file=http://wx3.sinaimg.cn/large/789c06f9gy1fq4dl21j0rj20k00k0jsl.jpg]' logger.debug(task.member_room_msg_lite_groups) # QQHandler.send_to_groups(task.member_room_msg_lite_groups, msg) logger.info(msg) else: logger.debug('不向大群发送简易版提醒') task.last_msg_time = time_now task.unread_msg_amount = 0 else: logger.info('最近10分钟内没有未读消息')
def parse_order_details(self, orders, taoba_entity): my_logger.debug('taoba_entity: {}'.format(taoba_entity.taoba_id)) my_logger.debug('keys: {}'.format(self.order_queues.keys())) if len(self.order_queues[taoba_entity.taoba_id]) == 0 and len( orders) == 0: my_logger.debug('订单队列为空') return jiebang_activities = global_config.MODIAN_JIEBANG_ACTIVITIES[ taoba_entity.taoba_id] flag_activities = global_config.MODIAN_FLAG_ACTIVITIES[ taoba_entity.taoba_id] count_flag_activities = global_config.MODIAN_COUNT_FLAG_ACTIVITIES[ taoba_entity.taoba_id] # 查询集资情况 pro_name, current, backer_count = self.get_current_and_target( taoba_entity) project_info = '当前进度: %s元' % current taoba_entity.current = current taoba_entity.title = pro_name # group_account_entity.target = target taoba_entity.support_num = backer_count my_logger.debug('size of order %s queue: %s', taoba_entity.taoba_id, len(self.order_queues[taoba_entity.taoba_id])) for order in orders: user_id = order['userid'] nickname = order['nickname'] pay_time = util.convert_timestamp_to_timestr(order['addtime'] * 1000) single_price = order['amount'] pay_amount = order['nums'] backer_money = single_price listid = int(order['id']) my_logger.debug('oid: %s', listid) if listid in self.order_queues[taoba_entity.taoba_id]: continue my_logger.debug('项目%s队列长度: %s', taoba_entity.taoba_id, len(self.order_queues[taoba_entity.taoba_id])) # 每次需要更新一下昵称 try: mysql_util.query( """ INSERT INTO `supporter` (`id`, `name`) VALUES (%s, %s) ON DUPLICATE KEY UPDATE `id`=%s """, (user_id, nickname, user_id)) except Exception as e: my_logger.exception(e) try: # 创建对象 mysql_util.query( """ INSERT INTO `order` (`id`,`supporter_id`,`backer_money`,`pay_time`, `pro_id`) VALUES (%s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE `id`=%s """, (str(listid), user_id, backer_money, pay_time, taoba_entity.taoba_id, str(listid))) except Exception as e: my_logger.exception(e) msg = '感谢 %s(%s) 支持了%s元, %s\n' % ( nickname, user_id, backer_money, util.random_str(global_config.MODIAN_POSTSCRIPTS)) # daka_rank, support_days = self.find_user_daka_rank(user_id, group_account_entity.pro_id) # if daka_rank != -1 and support_days: # msg += '当前项目已打卡%s天\n' % support_days # if group_account_entity.need_display_rank is True: # jizi_rank, backer_money = self.find_user_jizi_rank(user_id, group_account_entity.pro_id) # if jizi_rank != -1: # msg += '当前项目已集资%s元, 排名: %s' % (backer_money, jizi_rank) # else: # pass # 统计当前人数 count = mysql_util.select_one( """ SELECT COUNT(distinct(`supporter_id`)) FROM `order` WHERE `pro_id`=%s """, (taoba_entity.taoba_id, )) backer_count = count[0] msg += '当前集资人数: %s\n' % backer_count # 抽卡播报 card_report = '' if global_config.MODIAN_CARD_DRAW: card_report = self.card_draw_handler.draw( user_id, nickname, backer_money, pay_time) '''接棒相关''' my_logger.debug('接棒情况更新') for jiebang in jiebang_activities: # if jiebang.start_time > time.time(): # continue my_logger.debug('接棒活动详情: 【%s】', jiebang.name) my_logger.debug('集资金额: %s, 接棒最小金额: %s', backer_money, jiebang.min_stick_amount) if backer_money >= jiebang.min_stick_amount: stick_num = util.compute_stick_num( jiebang.min_stick_amount, backer_money) jiebang.current_stick_num += stick_num jiebang.last_record_time = util.convert_timestamp_to_timestr( int(time.time() * 1000)) # 数据库也要更新 try: mysql_util.query( """ UPDATE jiebang SET `current_stick_num`=%s, `last_record_time`=%s WHERE `name`=%s """, (jiebang.current_stick_num, jiebang.last_record_time, jiebang.name)) except Exception as e: my_logger.error('更新接棒数据失败') my_logger.exception(e) my_logger.debug('数据库接棒数据更新完成') test_msg = '' if jiebang.need_detail == 1: test_msg = '【%s】, 当前第%s棒, 目标%s棒\n' \ % (jiebang.name, jiebang.current_stick_num, jiebang.target_stick_num) elif jiebang.need_detail == 0: test_msg = '【%s】\n' % jiebang.name elif jiebang.need_detail == 2: test_msg = '【%s】, 当前第%s棒\n' \ % (jiebang.name, jiebang.current_stick_num) elif jiebang.need_detail == 3: if stick_num > 1: test_msg = '抽奖号: {}~{}\n'.format( jiebang.current_stick_num - stick_num + 1, jiebang.current_stick_num) else: test_msg = '抽奖号: {}\n'.format( jiebang.current_stick_num) my_logger.debug(test_msg) if len(test_msg) > 0: msg += test_msg # QQHandler.send_to_groups(['483548995'], test_msg) '''金额类flag相关''' my_logger.debug('flag情况更新') flag_test_msgs = '' for flag in flag_activities: my_logger.debug('Flag活动详情: %s', flag.name) my_logger.debug('Flag金额: %s, 结束时间: %s', flag.target_flag_amount, flag.end_time) diff = flag.target_flag_amount - current test_msgs = '【%s】, 目标金额: %s元, ' % (flag.name, flag.target_flag_amount) if diff > 0: test_msgs += '距离目标还差%s元\n' % round(diff, 2) flag_test_msgs += test_msgs else: test_msgs += '已经达成目标\n' my_logger.debug(flag_test_msgs) if len(flag_test_msgs) > 0: pass # QQHandler.send_to_groups(['483548995'], flag_test_msgs) # msg += flag_test_msgs '''人头类flag相关''' my_logger.debug('人头flag情况更新') count_flag_test_msgs = '' for flag in count_flag_activities: my_logger.debug('人头Flag活动详情: %s', flag.name) my_logger.debug('人头Flag目标: %s, 开始时间: %s, 结束时间: %s', flag.target_flag_amount, flag.start_time, flag.end_time) target = flag.target_flag_amount # 统计当前人数 rst = mysql_util.select_one( """ select count(distinct(`supporter_id`)) from `order` where `pro_id` = %s and `pay_time` <= %s and `pay_time` >= %s """, (taoba_entity.taoba_id, flag.end_time, flag.start_time)) # 目标人数为0,代表特殊类flag,只报人数 if target == 0: count_flag_test_msgs += '【%s】, 当前人数: %s ' % (flag.name, rst[0]) else: count_flag_test_msgs += '【%s】, 当前人数: %s, 目标人数: %s ' % ( flag.name, rst[0], flag.target_flag_amount) my_logger.debug(count_flag_test_msgs) if len(count_flag_test_msgs) > 0: # QQHandler.send_to_groups(['483548995'], count_flag_test_msgs) pass # msg += flag_test_msgs msg += '%s\n集资项目: %s\n集资方式: %s\n' % (project_info, pro_name, taoba_entity.link) # msg += jizi_pk_report # if global_config.MODIAN_NEED_DISPLAY_PK: # msg += self.pk_modian_activity() if global_config.USING_COOLQ_PRO is True: my_logger.debug('使用酷Q PRO发送图片') msg += '\n[CQ:image,file={}]\n'.format(taoba_entity.qrcode) # QQHandler.send_to_groups(taoba_entity.broadcast_groups, msg) if card_report: pass # QQHandler.send_to_groups(taoba_entity.broadcast_groups, card_report) # QQHandler.send_to_groups(['483548995'], card_report) # 集五福 # wufu_report = modian_wufu_handler.draw(user_id, nickname, backer_money, pay_time) # if wufu_report: # QQHandler.send_to_groups(group_account_entity.broadcast_groups, wufu_report) self.order_queues[taoba_entity.taoba_id].add(listid) # 更新接棒的数据库 try: my_logger.debug('更新接棒活动信息:') for jiebang in jiebang_activities: my_logger.debug( 'current_stick_num: %s, last_record_time: %s, name: %s', jiebang.current_stick_num, jiebang.last_record_time, jiebang.name) mysql_util.query( """ UPDATE jiebang SET current_stick_num=%s WHERE name=%s """, (jiebang.current_stick_num, jiebang.name)) except Exception as e: my_logger.exception(e)
def generate_session_id(): return random_str(16)
def refresh_key(self): self.key = random_str(32) self.key_time = int(time.time()) self.save()
def onQQMessage(bot, contact, member, content): # 当收到 QQ 消息时被调用 # bot : QQBot 对象,提供 List/SendTo/GroupXXX/Stop/Restart 等接口,详见文档第五节 # contact : QContact 对象,消息的发送者 # member : QContact 对象,仅当本消息为 群或讨论组 消息时有效,代表实际发消息的成员 # content : str 对象,消息内容 # DEBUG('member: %s', str(getattr(member, 'uin'))) # DEBUG('content: %s', content) # DEBUG('contact: %s', contact.ctype) global pocket48_handler if contact.ctype == 'group': if '@ME' in content: # 在群中@机器人 strs = content.split('[@ME]')[1].strip() if strs : id = contact.uin bot.SendTo(contact, pocket48_handler.get_tuling_ai(id, strs)) else: bot.SendTo(contact, util.random_str(global_config.AT_AUTO_REPLY)) elif content.startswith('-'): # 以'-'开头才能触发自动回复 if content == '-version': bot.SendTo(contact, 'QQbot-' + bot.conf.version) elif content == '-票务' or content == '-公演': pocket48_handler.get_current_ticket_info_msg(global_config.TICKET_INFO) elif content == '-屏蔽全部消息' or content == '-屏蔽所有消息': if len(global_config.ACTIVE_MEMBER_ROOM_ID_LIST) > 0: global_config.DEACTIVE_MEMBER_ROOM_ID_LIST = ConfigReader.get_all_member_room_id_list() global_config.ACTIVE_MEMBER_ROOM_ID_LIST = [] QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '已屏蔽全部房间消息') else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '当前已屏蔽全部房间消息,请不要重复输入命令') elif content == '-开启全部消息' or content == '-开启全部消息': if len(global_config.DEACTIVE_MEMBER_ROOM_ID_LIST) > 0: global_config.ACTIVE_MEMBER_ROOM_ID_LIST = ConfigReader.get_all_member_room_id_list() global_config.DEACTIVE_MEMBER_ROOM_ID_LIST = [] pocket48_handler.init_msg_queues(global_config.ACTIVE_MEMBER_ROOM_ID_LIST) QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '已开启全部房间消息') else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '当前已开启全部房间消息,请不要重复输入命令') elif content == '-关闭': bot.SendTo(contact, 'QQ机器人已关闭') bot.Stop() elif '-屏蔽' in content and '消息' in content: if len(global_config.ACTIVE_MEMBER_ROOM_ID_LIST) > 0: name = util.get_order_name(content) # 命令是否包含成员名字 if util.is_name_in_member_list(name): # 屏蔽逻辑 pocket48_handler.deactive_member_by_name(name) else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '屏蔽失败, 无法识别该成员,请确保命令输入正确') else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '当前已屏蔽全部房间消息,无法再进行屏蔽') elif '-开启' in content and '消息' in content: if len(global_config.DEACTIVE_MEMBER_ROOM_ID_LIST) > 0: name = util.get_order_name(content) # 命令是否包含成员名字 if util.is_name_in_member_list(name): # 开启逻辑 pocket48_handler.active_member_by_name(name) else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '开启失败, 无法识别该成员,请确保命令输入正确') else: QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, '当前已开启全部房间消息,无法再进行开启') elif content == '-直播': r = pocket48_handler.get_member_live_msg() pocket48_handler.parse_member_live_now(r, global_config.LIVING_MEMBER_ID_LIST) elif content == '-小黑屋': msg = util.get_black_room_list() QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, msg) elif content == '-小白屋': msg = util.get_white_room_list() QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, msg) elif content == '-使用说明': msg = ''' 机器人使用说明: 一、命令类型(输入一次即可, 没回复可能是机器人没开启 或者 机器人卡住了): (1)'-票务': 查看尚未公演的票务信息. (2)'-直播': 查看所有正在直播的直播间. (3)'-使用说明': 机器人使用说明. (4)'-屏蔽全部(所有)消息': 屏蔽全部成员房间消息. (5)'-开启全部(所有)消息': 开启全部成员房间消息. (6)'-屏蔽' + 成员名字 + '消息': 屏蔽某个成员房间消息. (7)'-开启' + 成员名字 + '消息': 开启某个成员房间消息. (8)'-小黑屋': 查看被屏蔽房间消息的成员. (9)'-小白屋': 查看已开启房间消息的成员 其余命令均无法识别 二、聊天 '@机器人' + 聊天内容: 与图灵机器人聊天 (每天上限1000次, 河内梗完善中...)''' QQHandler.send_to_groups(pocket48_handler.member_room_msg_groups, msg) else: # 无法识别命令 no_such_command = ConfigReader.get_property('profile', 'no_such_command') bot.SendTo(contact, no_such_command)
def parse_order_details(self, orders, modian_entity): if len(self.order_queues[modian_entity.pro_id]) == 0 and len( orders) == 0: my_logger.debug('订单队列为空') return jiebang_activities = global_config.MODIAN_JIEBANG_ACTIVITIES[ modian_entity.pro_id] flag_activities = global_config.MODIAN_FLAG_ACTIVITIES[ modian_entity.pro_id] count_flag_activities = global_config.MODIAN_COUNT_FLAG_ACTIVITIES[ modian_entity.pro_id] # 查询集资情况 target, current, pro_name, backer_count = self.get_current_and_target( modian_entity) project_info = '当前进度: %s元, 目标金额: %s元' % (current, target) modian_entity.current = current modian_entity.title = pro_name modian_entity.target = target modian_entity.support_num = backer_count my_logger.debug('size of order %s queue: %s', modian_entity.pro_id, len(self.order_queues[modian_entity.pro_id])) for order in orders: user_id = order['user_id'] nickname = order['nickname'] pay_time = order['pay_time'] backer_money = order['backer_money'] oid = uuid.uuid3(uuid.NAMESPACE_OID, str(user_id) + pay_time) my_logger.debug('oid: %s', oid) if oid in self.order_queues[modian_entity.pro_id]: continue my_logger.debug('项目%s队列长度: %s', modian_entity.pro_id, len(self.order_queues[modian_entity.pro_id])) # 每次需要更新一下昵称 try: # supporter = Supporter(id=user_id, name=nickname) # self.alchemy_session.merge(supporter) mysql_util.query( """ INSERT INTO `supporter` (`id`, `name`) VALUES (%s, %s) ON DUPLICATE KEY UPDATE `name`=%s """, (user_id, nickname, nickname)) except Exception as e: my_logger.exception(e) try: # 创建对象 # modian_order = ModianOrder(id=str(oid), supporter_id=user_id, backer_money=backer_money, pay_time=pay_time, # pro_id=modian_entity.pro_id) # self.alchemy_session.merge(modian_order) mysql_util.query( """ INSERT INTO `order` (`id`,`supporter_id`,`backer_money`,`pay_time`, `pro_id`) VALUES (%s, %s, %s, %s, %s) ON DUPLICATE KEY UPDATE `id`=%s """, (str(oid), user_id, backer_money, pay_time, modian_entity.pro_id, str(oid))) except Exception as e: my_logger.exception(e) msg = '感谢 %s(%s) 支持了%s元, %s\n' % ( nickname, user_id, backer_money, util.random_str(global_config.MODIAN_POSTSCRIPTS)) daka_rank, support_days = self.find_user_daka_rank( user_id, modian_entity.pro_id) if daka_rank != -1 and support_days: msg += '当前项目已打卡%s天\n' % support_days if modian_entity.need_display_rank is True: jizi_rank, backer_money = self.find_user_jizi_rank( user_id, modian_entity.pro_id) if jizi_rank != -1: msg += '当前项目已集资%s元, 排名: %s' % (backer_money, jizi_rank) else: pass # 统计当前人数 msg += '当前集资人数: %s\n' % backer_count # 抽卡播报 card_report = '' if global_config.MODIAN_CARD_DRAW: card_report = self.card_draw_handler.draw( user_id, nickname, backer_money, pay_time) '''接棒相关''' my_logger.debug('接棒情况更新') for jiebang in jiebang_activities: # if jiebang.start_time > time.time(): # continue my_logger.debug('接棒活动详情: 【%s】', jiebang.name) my_logger.debug('集资金额: %s, 接棒最小金额: %s', backer_money, jiebang.min_stick_amount) if backer_money >= jiebang.min_stick_amount: stick_num = util.compute_stick_num( jiebang.min_stick_amount, backer_money) jiebang.current_stick_num += stick_num jiebang.last_record_time = util.convert_timestamp_to_timestr( int(time.time() * 1000)) # 数据库也要更新 try: mysql_util.query( """ UPDATE jiebang SET `current_stick_num`=%s, `last_record_time`=%s WHERE `name`=%s """, (jiebang.current_stick_num, jiebang.last_record_time, jiebang.name)) except Exception as e: my_logger.error('更新接棒数据失败') my_logger.exception(e) my_logger.debug('数据库接棒数据更新完成') test_msg = '' if jiebang.need_detail == 1: test_msg = '【%s】, 当前第%s棒, 目标%s棒\n' \ % (jiebang.name, jiebang.current_stick_num, jiebang.target_stick_num) elif jiebang.need_detail == 0: test_msg = '【%s】\n' % jiebang.name elif jiebang.need_detail == 2: test_msg = '【%s】, 当前第%s棒\n' \ % (jiebang.name, jiebang.current_stick_num) elif jiebang.need_detail == 3: if stick_num > 1: test_msg = '抽奖号: {}~{}\n'.format( jiebang.current_stick_num - stick_num + 1, jiebang.current_stick_num) else: test_msg = '抽奖号: {}\n'.format( jiebang.current_stick_num) my_logger.debug(test_msg) if len(test_msg) > 0: msg += test_msg QQHandler.send_to_groups(['483548995'], test_msg) '''金额类flag相关''' my_logger.debug('flag情况更新') flag_test_msgs = '' for flag in flag_activities: my_logger.debug('Flag活动详情: %s', flag.name) my_logger.debug('Flag金额: %s, 结束时间: %s', flag.target_flag_amount, flag.end_time) diff = flag.target_flag_amount - current test_msgs = '【%s】, 目标金额: %s元, ' % (flag.name, flag.target_flag_amount) if diff > 0: test_msgs += '距离目标还差%s元\n' % round(diff, 2) flag_test_msgs += test_msgs else: test_msgs += '已经达成目标\n' my_logger.debug(flag_test_msgs) if len(flag_test_msgs) > 0: QQHandler.send_to_groups(['483548995'], flag_test_msgs) # msg += flag_test_msgs '''人头类flag相关''' my_logger.debug('人头flag情况更新') count_flag_test_msgs = '' for flag in count_flag_activities: my_logger.debug('人头Flag活动详情: %s', flag.name) my_logger.debug('人头Flag目标: %s, 开始时间: %s, 结束时间: %s', flag.target_flag_amount, flag.start_time, flag.end_time) target = flag.target_flag_amount # 统计当前人数 rst = mysql_util.select_one( """ select count(distinct(`supporter_id`)) from `order` where `pro_id` = %s and `pay_time` <= %s and `pay_time` >= %s """, (modian_entity.pro_id, flag.end_time, flag.start_time)) # 目标人数为0,代表特殊类flag,只报人数 if target == 0: count_flag_test_msgs += '【%s】, 当前人数: %s ' % (flag.name, rst[0]) else: count_flag_test_msgs += '【%s】, 当前人数: %s, 目标人数: %s ' % ( flag.name, rst[0], flag.target_flag_amount) my_logger.debug(count_flag_test_msgs) if len(count_flag_test_msgs) > 0: QQHandler.send_to_groups(['483548995'], count_flag_test_msgs) # msg += flag_test_msgs msg += '%s\n集资项目: %s\n链接: %s\n' % (project_info, pro_name, modian_entity.link) # msg += jizi_pk_report my_logger.info(msg) if global_config.USING_COOLQ_PRO is True: my_logger.debug('使用酷Q PRO发送图片') msg += '\n[CQ:image,file=http://wx1.sinaimg.cn/large/439a9f3fgy1fpllweknr6j201i01g0lz.jpg]\n' # if global_config.MODIAN_NEED_DISPLAY_PK: # msg += self.pk_modian_activity() QQHandler.send_to_groups(modian_entity.broadcast_groups, msg) if card_report: QQHandler.send_to_groups(modian_entity.broadcast_groups, card_report) # QQHandler.send_to_groups(['483548995'], card_report) self.order_queues[modian_entity.pro_id].add(oid) # 更新接棒的数据库 try: my_logger.debug('更新接棒活动信息:') for jiebang in jiebang_activities: my_logger.debug( 'current_stick_num: %s, last_record_time: %s, name: %s', jiebang.current_stick_num, jiebang.last_record_time, jiebang.name) mysql_util.query( """ UPDATE jiebang SET current_stick_num=%s WHERE name=%s """, (jiebang.current_stick_num, jiebang.name)) except Exception as e: my_logger.exception(e)
def parse_wds_comment2(self, r, wds): """ 对评论进行处理(微打赏接口变更,r变为html) :param r: :param wds: :return: """ PAGE_SIZE = 20 soup = BeautifulSoup(r, 'lxml') # print soup.prettify() comment_list = soup.findAll(name='li') support_num, current, target = self.get_current_and_target(wds) # project_info = '当前进度: %s元, 目标金额: %s元\n当前集资人数: %s\n' % (current, target, support_num) page_num = int(support_num) / PAGE_SIZE + 1 wds_rank_list = [] for i in range(page_num): rank_html = self.get_wds_rank(wds, page=i + 1) if rank_html is None: break soup2 = BeautifulSoup(rank_html, 'lxml') wds_rank_list.extend(soup2.findAll(name='li')) project_info = '当前进度: %s元, 目标金额: %s元\n当前集资人数: %s\n' % ( current, target, len(wds_rank_list)) for comment in comment_list: comment_id = comment.find(class_='add-jubao').get('to_comid') # print comment_id comment_id_queue = self.wds_queue_map[wds] if comment_id in comment_id_queue: continue comment_id_queue.append(comment_id) nickname = comment.find(class_='nick').string nick_sup = comment.find(class_='nick_sup').string user_id = comment.find(class_='add-jubao').get('to_user') msg = '感谢 %s %s, %s\n' % (nickname, nick_sup, util.random_str( global_config.WDS_POSTSCRIPTS)) rank_msg = '' DEBUG('WDS USER ID: %s', user_id) for rank in wds_rank_list: user_a = rank.a['href'] uid = re.findall(r"\d+\.?\d*", user_a)[0] DEBUG('user_a: %s, uid: %s', user_a, uid) if uid == user_id: cur_rank = rank.find(class_='suport_ran').string total_amount = rank.find(class_='money').string total_amount = total_amount.replace('¥ ', '') if wds.need_display_rank is True: rank_msg = "当前累计集资%s元,当前排名: %s\n" % (total_amount, cur_rank) else: rank_msg = "当前累计集资%s元\n" % total_amount break if rank_msg and len(rank_msg) > 0: msg += rank_msg if msg and len(msg) > 0: msg += project_info msg += '集资项目: %s\n链接: %s' % (wds.title, wds.link) QQHandler.send_to_groups(self.wds_notify_groups, msg) INFO('wds_message: %s', msg) DEBUG('集资评论队列: %d', len(comment_id_queue)) time.sleep(3)