def ocr_err_upload(user_id, user_class, upload_date):
"""为管理员上报ocr错误的图片"""
msg = "OCR无法识别以下图片:\n"
err_list = []
err_imgid = []
class_menbers = dbconn.get_class_members(user_class)
for i in range(0, len(class_menbers)):
img_date = dbconn.check_status(class_menbers[i])
if (str(img_date) == str(upload_date)):
img_info = dbconn.get_latest_img_info(class_menbers[i],
upload_date)[0]
#print(img_info)
if (img_info['ocr_err_code'] == 1):
print(img_info)
err_list.append(img_info['file_name'])
err_imgid.append(img_info['imgid'])
for i in range(0, len(err_list)):
cqCode = f"[CQ:image,file=file:{os.getcwd()}/images{err_list[i]}]"
msg += f"id:{err_imgid[i]}\n"
msg += f"{cqCode}\n"
msg += f"数量:{len(err_list)}/{len(class_menbers)}\n"
msg += "可人工核对，操作格式: /admin 核对@id@次数@分数，例如：\n核对id为233，次数66，分数99则输入：/admin 核对@233@66@99"
goapi.sendMsg(user_id, msg)
return msg
def send_alert(group_id, user_class, type='private'):
group_menbers = dbconn.get_class_members(user_class)
current_date = time.strftime("%Y-%m-%d", time.localtime())
alert_users = {}
#user_id:last_date
for user_id in group_menbers:
#print(user_id)
try:
last_date = dbconn.check_status(user_id)
except TypeError:
#还没发过照片
alert_users[user_id] = '无记录'
else:
if (str(last_date) != str(current_date)):
alert_users[user_id] = str(last_date)[5:]
#print(alert_users)
msg = f"今天还有{len(alert_users)}位小可爱未完成哦\n"
if (type == 'private'):
for user_id in alert_users.keys():
last_date = alert_users[user_id]
msg += f"{dbconn.get_user(user_id)['user_name']}({alert_users[user_id]})\n"
msg += f"{user_class} {current_date}\n完成情况:{len(group_menbers)-len(alert_users)}/{len(group_menbers)}"
goapi.sendMsg(group_id, msg)
elif (type == 'group'):
for user_id in alert_users.keys():
last_date = alert_users[user_id]
msg += f"[CQ:at,qq={user_id}]({alert_users[user_id]})\n"
msg += f"{user_class} {current_date}\n完成情况:{len(group_menbers)-len(alert_users)}/{len(group_menbers)}"
goapi.sendGroupMsg(group_id, msg)
def re_register_user(user_id, user_name, user_class):
if (dbconn.re_register_user(user_id, user_name, user_class) == 1):
goapi.sendMsg(user_id, '已更新字段')
else:
goapi.sendMsg(
user_id, '更新字段失败:' +
f"user_id={user_id},user_name={user_name},user_class={user_class}")
def getEvent():
data = request.json
post_type = data.get('post_type')
if (post_type == 'message'):
message_type = data.get('message_type')
#print(data)
message = data.get('message')
user_id = str(data.get('user_id'))
if (message_type == 'private'
and (dbconn.check_register(user_id) == 1 or '注册' in message)):
#仅接收注册用户的消息和注册消息
print(f"--------------------\n接收消息@{user_id}:{message[:20]}")
readMsg(user_id, message)
elif (post_type == 'request'):
request_type = data.get('request_type')
if (request_type == 'friend'):
user_id = str(data.get('user_id'))
comment = str(data.get('comment'))
flag = str(data.get('flag'))
print(f"--------------------\n接收加好友请求@{user_id}:{comment[:20]}")
time.sleep(random.randint(5, 10))
goapi.add_request(flag)
time.sleep(random.randint(5, 10))
goapi.sendMsg(
user_id,
"欢迎！\n请先注册，例如'注册@小明@智科20-2'\n 班级请严格按格式输入，否则可能统计不上哦,另外特别注意'-'是减号不是破折号，也不要加空格"
)
else:
#暂不处理其他类型上报，为防止go-cq报错而设置
pass
return data
def register_user(user_id, user_name, user_class):
if (dbconn.register_user(user_id, user_name, user_class) == 1):
goapi.sendMsg(user_id, '注册成功，现在可以开始上传图片了~')
else:
goapi.sendMsg(
user_id, '注册失败' +
f"user_id={user_id},user_name={user_name},user_class={user_class}")
def list_class_menbers(user_id, user_class):
msg = f"{user_class}成员情况：\n"
ret = dbconn.get_class_members(user_class)
for i in range(0, len(ret)):
msg += f"{ret[i]} {dbconn.get_user(str(ret[i]))['user_name']}\n"
msg += f"共计{str(len(ret))}人"
goapi.sendMsg(user_id, msg)
def register_prompt(user_id, message):
"""用户注册逻辑"""
if ('注册' in message):
err_promot = '输入好像有点问题呢\n注册格式："注册@姓名@班级"'
try:
user_name = message.split('@')[1]
user_class = message.split('@')[2]
#简单过滤用户输入
if not (inputFilter.is_Chinese(user_name)
and inputFilter.check_length(user_name)):
goapi.sendMsg(user_id, err_promot)
return
if not (inputFilter.is_valid(user_class)
and inputFilter.check_length(user_class)):
goapi.sendMsg(user_id, err_promot)
return
except:
goapi.sendMsg(user_id, err_promot)
else:
if (globalDB.check_register(user_id)):
goapi.sendMsg(user_id, '您已注册过啦~')
re_register_user(user_id, user_name, user_class)
else:
register_user(user_id, user_name, user_class)
return
def send_images_info(user_id, user_class):
"""上报班级图片情况（次数和成绩）"""
class_menbers = dbconn.get_class_members(user_class)
today_upload_count = 0
upload_date = time.strftime("%Y-%m-%d", time.localtime())
msg = f"{user_class} {upload_date}情况:\n"
for i in range(0, len(class_menbers)):
if (str(dbconn.check_status(class_menbers[i])) == str(upload_date)):
today_upload_count += 1
img_info = dbconn.get_latest_img_info(class_menbers[i],
upload_date)[0]
if (img_info['ocr_err_code'] == 0):
msg += f"·{dbconn.get_user(class_menbers[i])['user_name']} 次数{img_info['ocr_times']} 分数{img_info['ocr_scores']}\n"
else:
msg += f"·{dbconn.get_user(class_menbers[i])['user_name']} 未识别到\n"
msg += f"共计{today_upload_count}张照片"
goapi.sendMsg(user_id, msg)
return msg
def ocr_err_upload(user_id, user_class, upload_date):
"""为管理员上报ocr错误的图片"""
msg = "OCR无法识别以下图片:\n"
err_list = []
class_menbers = dbconn.get_class_members(user_class)
for i in range(0, len(class_menbers)):
img_date = dbconn.check_status(class_menbers[i])
if (str(img_date) == str(upload_date)):
img_info = dbconn.get_latest_img_info(class_menbers[i],
upload_date)[0]
#print(img_info)
if (img_info['ocr_err_code'] == 1):
print(img_info)
err_list.append(img_info['file_name'])
for i in range(0, len(err_list)):
cqCode = f"[CQ:image,file=file:{os.getcwd()}/images{err_list[i]}]"
msg += f"{cqCode}\n"
msg += f"数量:{len(err_list)}/{len(class_menbers)}"
goapi.sendMsg(user_id, msg)
return msg
def readMsg(user_id, message):
#处理消息核心
user_id = str(user_id)
#管理员列表
admin_list = show_admin()
if ('image' in message):
if (dbconn.check_register(user_id)):
#用户已注册
get_img(user_id, message)
else:
#用户未注册
goapi.sendMsg(
user_id,
'您还没注册呢，请输入例如"注册@小明@智科20-2"\n 班级请严格按格式输入，否则可能统计不上哦,另外特别注意' -
'是减号不是破折号，也不要加空格')
return
if ('注册' in message):
try:
user_name = message.split('@')[1]
user_class = message.split('@')[2]
#简单过滤用户输入
if not (inputFilter.is_Chinese(user_name)
and inputFilter.check_length(user_name)):
goapi.sendMsg(user_id, '输入好像有点问题呢')
return
if not (inputFilter.is_valid(user_class)
and inputFilter.check_length(user_class)):
goapi.sendMsg(user_id, '输入好像有点问题呢')
return
except:
goapi.sendMsg(user_id, '输入好像有点问题呢')
else:
if (dbconn.check_register(user_id)):
goapi.sendMsg(user_id, '您已注册过啦~')
re_register_user(user_id, user_name, user_class)
else:
register_user(user_id, user_name, user_class)
return
if ('/admin' in message):
user_class = dbconn.get_user(user_id)['user_class']
upload_date = time.strftime("%Y-%m-%d", time.localtime())
print(user_id)
if (user_id in admin_list.keys()):
group_id = admin_list[user_id]
if ('群提醒' in message):
send_alert(group_id,
dbconn.get_user(user_id)['user_class'], 'group')
elif ('提醒' in message):
send_alert(user_id,
dbconn.get_user(user_id)['user_class'], 'private')
upload_date = time.strftime("%Y-%m-%d", time.localtime())
time.sleep(1)
#ocr_err_upload(user_id,user_class,upload_date)
ocr_err_upload(user_id, user_class, upload_date)
time.sleep(2)
send_images_info(user_id, user_class)
elif ('打包' in message):
cmp_ret = compress.zip_file(
upload_date,
dbconn.get_user(user_id)['user_class'])
goapi.sendMsg(user_id,
f"---打包完毕---\n共处理:{cmp_ret['file_num']}张照片")
goapi.sendMsg(
user_id,
'下载地址:' + urllib.parse.quote(cmp_ret['file_name']))
elif ('成员' in message):
list_class_menbers(user_id, user_class)
elif ('核对' in message):
goapi.sendMsg(user_id, 'get')
err_imgid = message.split('@')[1]
ocr_times = message.split('@')[2]
ocr_scores = message.split('@')[3]
if (dbconn.err_check):
err_code = dbconn.err_check(err_imgid)
if (err_code):
dbconn.manual_update(ocr_times, ocr_scores, err_imgid)
goapi.sendMsg(
user_id,
f"人工校对完成:{dbconn.get_user_by_migid(err_imgid)}\n参赛次数:{ocr_times}\n积分:{ocr_scores}"
)
elif (err_code == 0):
goapi.sendMsg(user_id, '该图片无需校对，请重新检查输入的id')
elif (err_code == -1):
goapi.sendMsg(
user_id,
f"已经人工校对过了，覆盖校对:\n{dbconn.get_user_by_migid(imgid)}\n参赛次数:{ocr_times}\n积分:{ocr_scores}"
)
else:
goapi.sendMsg(user_id, "目前支持以下管理指令呢：\n群提醒\n提醒\n打包\n成员\n")
else:
goapi.sendMsg(user_id, "无管理权限")
if ('/sudo' in message
and (user_id == '601179193' or user_id == "29242764"
or user_id == "1476821890" or user_id == "3439911708")):
#try:
if ('增加管理员' in message):
admin_id = message.split('@')[1]
group_id = message.split('@')[2]
goapi.sendMsg(user_id, str(add_admin(admin_id, group_id)))
elif ('删除管理员' in message):
admin_id = message.split('@')[1]
goapi.sendMsg(user_id, str(del_admin(admin_id)))
elif ('展示管理员' in message):
goapi.sendMsg(user_id, str(show_admin()))
else:
goapi.sendMsg(user_id, '增加管理员\n删除管理员\n展示管理员')
#except:
#goapi.sendMsg(user_id,'增加管理员\n删除管理员\n展示管理员')
#else:
#pass
return
def get_img(user_id, message):
#从message中解析到图片下载地址，并保存数据库，下载文件
try:
img_url = message.split('url=')[1][0:-1]
user_name = dbconn.get_user(user_id)['user_name']
user_class = dbconn.get_user(user_id)['user_class']
upload_date = time.strftime("%Y-%m-%d", time.localtime())
upload_time = time.strftime("%H:%M:%S", time.localtime())
#修改文件名格式(注意只保存文件名和数据库中显示的file_name改变，目录等名称不变)
file_date = time.strftime("%Y%m%d", time.localtime())
#安全过滤
if not (img_url[0:24] == 'http://c2cpicdw.qpic.cn/'):
goapi.sendMsg(user_id, '图片url解析错误')
return
#判断文件目录是否存在
if not (os.path.exists(f"images/{upload_date}")):
os.mkdir(f"images/{upload_date}")
if not (os.path.exists(f"images/{upload_date}/{user_class}")):
os.mkdir(f"images/{upload_date}/{user_class}")
file_name = f"/{upload_date}/{user_class}/{user_class}班-{user_name}-{file_date}.jpg"
if (dbconn.check_today_upload(user_id, upload_date)):
goapi.sendMsg(user_id, '您今天已经上传过照片啦，已覆盖之前的图片~')
download_img(img_url, file_name)
#print(img_url)
except Exception as err:
goapi.sendMsg(user_id, '图片下载出错了！')
print(err)
else:
print("成功处理图片:" + file_name)
goapi.sendMsg(
user_id,
"成功处理图片，正在识别...\n" + f"{user_class}班-{user_name}-{file_date}.jpg")
"""图片识别部分"""
try:
print(file_name)
ocr_ret = ocrplus.ocr_img("images" + file_name)
ocr_err_code = ocr_ret['err_code']
if (ocr_err_code == 0):
goapi.sendMsg(
user_id,
f"参赛次数:{ocr_ret['个人参赛次数']}\n个人积分:{ocr_ret['个人积分']}")
ocr_times = ocr_ret['个人参赛次数']
ocr_scores = ocr_ret['个人积分']
else:
print("图片无法识别:" + ocr_ret)
#图片识别接口返回无法识别
goapi.sendMsg(user_id, f"OCR无法识别，团支书将人工复核~")
dbconn.insert_img(user_id, file_name, upload_date, upload_time,
'1', '0', '0')
return
except:
#图片识别接口出错
print("OCR接口出错:")
goapi.sendMsg(user_id, f"qwq图片识别出错了！可能是字体原因，请尝试更换字体后重试")
dbconn.insert_img(user_id, file_name, upload_date, upload_time,
'1', '0', '0')
else:
dbconn.insert_img(user_id, file_name, upload_date, upload_time,
ocr_err_code, ocr_times, ocr_scores)
return
def readMsg(user_id, message):
#处理消息核心
user_id = str(user_id)
#管理员列表
admin_list = show_admin()
if ('image' in message):
if (dbconn.check_register(user_id)):
#用户已注册
get_img(user_id, message)
else:
#用户未注册
goapi.sendMsg(user_id,
'您还没注册呢，请输入例如"注册@张三@计科20-2"\n 班级请严格按格式输入，否则可能统计不上哦')
return
if ('注册' in message):
try:
user_name = message.split('@')[1]
user_class = message.split('@')[2]
#简单过滤用户输入
if not (inputFilter.is_Chinese(user_name)
and inputFilter.check_length(user_name)):
goapi.sendMsg(user_id, '输入好像有点问题呢')
return
if not (inputFilter.is_valid(user_class)
and inputFilter.check_length(user_class)):
goapi.sendMsg(user_id, '输入好像有点问题呢')
return
except:
goapi.sendMsg(user_id, '输入好像有点问题呢')
else:
if (dbconn.check_register(user_id)):
goapi.sendMsg(user_id, '您已注册过啦~')
re_register_user(user_id, user_name, user_class)
else:
register_user(user_id, user_name, user_class)
return
if ('/admin' in message):
user_class = dbconn.get_user(user_id)['user_class']
upload_date = time.strftime("%Y-%m-%d", time.localtime())
print(user_id)
if (user_id in admin_list.keys()):
group_id = admin_list[user_id]
if ('群提醒' in message):
send_alert(group_id,
dbconn.get_user(user_id)['user_class'], 'group')
elif ('提醒' in message):
send_alert(user_id,
dbconn.get_user(user_id)['user_class'], 'private')
upload_date = time.strftime("%Y-%m-%d", time.localtime())
time.sleep(1)
#ocr_err_upload(user_id,user_class,upload_date)
ocr_err_upload(user_id, user_class, upload_date)
time.sleep(2)
send_images_info(user_id, user_class)
elif ('打包' in message):
cmp_ret = compress.zip_file(
upload_date,
dbconn.get_user(user_id)['user_class'])
goapi.sendMsg(user_id,
f"---打包完毕---\n共处理:{cmp_ret['file_num']}张照片")
goapi.sendMsg(
user_id, '下载地址:http://static.catop.top:8001/' +
urllib.parse.quote(cmp_ret['file_name']))
elif ('成员' in message):
list_class_menbers(user_id, user_class)
else:
goapi.sendMsg(user_id, "目前支持以下管理指令呢：\n群提醒\n提醒\n打包\n成员\n")
else:
goapi.sendMsg(user_id, "无管理权限")
if ('/sudo' in message
and (user_id == '601179193' or user_id == "29242764")):
#try:
if ('增加管理员' in message):
admin_id = message.split('@')[1]
group_id = message.split('@')[2]
goapi.sendMsg(user_id, str(add_admin(admin_id, group_id)))
elif ('删除管理员' in message):
admin_id = message.split('@')[1]
goapi.sendMsg(user_id, str(del_admin(admin_id)))
elif ('展示管理员' in message):
goapi.sendMsg(user_id, str(show_admin()))
else:
goapi.sendMsg(user_id, '增加管理员\n删除管理员\n展示管理员')
#except:
#goapi.sendMsg(user_id,'增加管理员\n删除管理员\n展示管理员')
#else:
#pass
return
