综述
在数据分析过程中，常常出现数据预警或者向特殊群体发送预警信息的需求，在此基础上，我分享一下自己的工作经验，实现爬虫控制网页+钉钉机器人实时预警功能。
一、加载包
from selenium import webdriver
from selenium.webdriver.chrome.options import Options
import time
import pandas as pd
#读取文件
import openpyxl
#获取路径
import os
#获取时间
from datetime import datetime
#获取文件名
import ntpath
#模拟点击enter
import keyboard # 模拟按下Enter键keyboard.press_and_release('enter')
from datetime import datetime,timedelta# 查看时间
# 以下包为连接机器人
import requests
import json
#输出markdown
from tabulate import tabulate注：在加载包之前还需注意需下载与自己电脑版本匹配的游览器驱动chromedriver.exe，具体下载过程见https://blog.csdn.net/u011565355/article/details/127931712。（如果游览器版本是127版本之后的点击如下链接ChromeDriver新手教程：Chrome 114到127版本的驱动下载_chromedriver 126.0.6478.127-CSDN博客）只有成功下载好驱动才能够正常的执行代码，控制游览器完成自己想要的操作。
二、控制游览器导出数据
####################
#######导出数据######
####################
os.getcwd()
os.chdir("C:\\Downloads1")#修改工作路径
#配置游览器选项，为了指定游览器下载路径
chrome_options = Options()
chrome_options.add_experimental_option("prefs", {
"download.default_directory": "C:\Downloads",
"download.prompt_for_download": False,
"download.directory_upgrade": True,
"safebrowsing.enabled": True
})
browser = webdriver.Chrome(options=chrome_options)
browser.get('你自己的登录网页链接')
browser.find_element("class name", "extraLoginIcon--OcXlXUKy").click() # 点击跳过
time.sleep(5)
#如下操作为不同网页的登录操作可依据不同网页来选择
browser.find_element("name", 'account').send_keys('123456') # 输入账号
browser.find_element("name", 'password').send_keys('123456') # 输入密码
browser.find_element("class name", "false").click() # 点击登录
time.sleep(15)
#点击筛选按钮
browser.find_element("class name", "next-icon.next-icon-shaixuan.next-medium.zen-senior-search--filter-icon--kDmNWyN").click() # 点击登录
time.sleep(1)
try:
# 选择处理中工单状态
browser.find_element("xpath",'//*[@id="app"]/div[1]/section/section/section/div/div/div[2]/div/div/div/div/div/div/div/div/div/div[1]/div[2]/div[1]/div[1]/div[3]/span/span[1]/span[1]').click()
time.sleep(2)
browser.find_element("xpath",'/html/body/div[4]/div/div/ul/li[6]').click()
time.sleep(4)
#导出数据
browser.find_element("xpath", '//*[@id="e35593a8764a3049236b4759c505ea3b_ZenTableActions"]/div[1]/div/button[2]').click() #
time.sleep(2)
#点击导出按钮
browser.find_element("xpath", "/html/body/div[5]/div[2]/div/div[2]/div[2]/button[1]").click()
time.sleep(25)
browser.find_element("class name", "downs").click() # 点击下载按钮
time.sleep(2)
#下载数据到本地
browser.find_element("xpath", "/html/body/div[5]/div/div[2]/ul/li[1]/div[2]/div/button[1]/span").click() #点击下载
time.sleep(2)
#关闭游览器
browser.quit()
print("代码运行成功！")
except:
# 如果出现错误，则会跳过运行可能会出错的代码，直接执行下面的语句
print("代码运行错误！")
browser.quit()注：如上用Python控制网页自动登录并得到想要的数据，最后下载到指定的文件夹。
三、数据分析
##################
###读入导出的数据##
##################
###查看并修改路径##
os.getcwd()
os.chdir("C:\\Downloads")#修改工作路径
## 定义路径，注意文件夹之间用“\\”最后要有个“\\”
path = os.path.abspath('.')
try:
## 获取所有文件的完整路径名
all_files_path=[]
for root, dirs, files in os.walk(path, topdown=False):
if len(files) > 0:
each_foder_files=[os.path.join(root, x) for x in files]
all_files_path.extend(each_foder_files)
####################
#####批量读取数据#####
####################
data = []
df = pd.DataFrame()
for f in all_files_path:
name = ntpath.basename(f)
workbook = openpyxl.load_workbook(name)
sheet = workbook['工单详情']
for row in sheet.iter_rows(values_only=True):
data.append(row)
each_df = pd.DataFrame(data[1:], columns=data[0])
os.remove(name)
df = df.append(each_df)
#添加找到具体园区
data0 = df["行政城市/园区"].str.split('/', expand=True)
df["主数据园区名"] = data0[2]
data = df
#############
###舆情数据###
#############
os.chdir("C:\\Users\\ALSC\\Desktop\\临时处理\\舆情数据") # 修改工作路径
df1 = pd.read_excel("舆情数据.xlsx", sheet_name="Sheet1", engine="openpyxl")
####################
#######数据分析######
####################
#设置查看今天是星期几
week = datetime.now().weekday()
#设置时间判断
open_day = (datetime.now()).strftime("%Y-%m-%d")
##挑选查看时间
date_total0 = df
#看舆情单数 和 汇总的工单数据分析
gd_sum = date_total0.shape[0]
#平均解决时常
if date_total0["响应耗时"].isnull().any():
date_total0["响应耗时"] = date_total0["响应耗时"].fillna(0)
if date_total0["解决耗时"].isnull().any():
date_total0["解决耗时"] = date_total0["解决耗时"].fillna(0)
date_total0.loc[:, "响应耗时"] = date_total0["响应耗时"].astype(int)#转化格式
date_total0.loc[:, "解决耗时"] = date_total0["解决耗时"].astype(int)#转化格式
gd_rtimemean = round(date_total0["响应耗时"].mean(),2)
gd_rtimemean = gd_rtimemean/60 #平均响应时间min
gd_stimemean = round(date_total0["解决耗时"].mean(),2)
gd_stimemean = gd_stimemean/60 #平均解决时间min
#满意度
gd_manyidu1 = date_total0[date_total0["服务满意度"]=="5"]
gd_manyidu1 = gd_manyidu1.shape[0]#非常满意工单数
#判断是否“响应超时”或者“解决超时”以及“处理中工单”
#解决超时
data_slovecs = data[data["解决是否超时"]=="是"]
data_slovecs_sum = data_slovecs.shape[0]
#响应超时
data_relactcs = data[data["响应是否超时"]=="是"]
data_relactcs_sum = data_relactcs.shape[0]
#处理中工单
data_during = data[data["工单状态"]=="处理中"]
data_during_sum = data_during.shape[0]
###数据重组
#处理中工单
gd_describe2 = []
gd_leimu2 = []
gd_number2 = []
gd_coulp2 = []
gd_people2 = []
gd_peoplenumber2 = []
gd_yuanqu = []
for i in range(0, data_during_sum):
number = data_during.index[i]
a = data_during.loc[number, :]
gd_describe2.append(a["问题/需求描述"])
gd_leimu2.append(a["行政类目"])
gd_number2.append(a["工单编号"])
gd_coulp2.append(a["处理技能组"])
gd_people2.append(a["用户/联系人"])
gd_peoplenumber2.append(a["工号"])
gd_yuanqu.append(a["主数据园区名"])
#列表(园区工单数)table1制作
count = data.groupby("主数据园区名")['工单编号'].count()
table0 = pd.DataFrame(count)
table = tabulate(table0, headers=['主数据园区名', '工单数(单位\单)'], tablefmt='simple')
table1 = table.replace("\n","\n\n")
##舆情--挑选查看时间
con = df1["日期"] == open_day
date_total0 = df1[con]
# 看舆情单数
yq_sum = date_total0.shape[0]
date_total0["类别"]
##数据重组0
yq_lb = []
yq_xz = []
yq_qd = []
yq_yq = []
yq_nr = []
for i in range(0, yq_sum):
number0 = date_total0.index[i]
a0 = date_total0.loc[number0, :]
yq_lb.append(a0["类别"])
yq_xz.append(a0["性质"])
yq_qd.append(a0["渠道"])
yq_yq.append(a0["园区"])
yq_nr.append(a0["内容"])
except:
#############
###舆情数据###
#############
os.chdir("C:\\Users\\ALSC\\Desktop\\临时处理\\舆情数据") # 修改工作路径
df1 = pd.read_excel("舆情数据.xlsx", sheet_name="Sheet1", engine="openpyxl")
####################
#######数据分析######
####################
#设置查看今天是星期几
week = datetime.now().weekday()
#设置时间判断
open_day = (datetime.now()).strftime("%Y-%m-%d")
con = df1["日期"] == open_day
date_total0 = df1[con]
# 看舆情单数
yq_sum = date_total0.shape[0]
date_total0["类别"]
##数据重组0
yq_lb = []
yq_xz = []
yq_qd = []
yq_yq = []
yq_nr = []
for i in range(0, yq_sum):
number0 = date_total0.index[i]
a0 = date_total0.loc[number0, :]
yq_lb.append(a0["类别"])
yq_xz.append(a0["性质"])
yq_qd.append(a0["渠道"])
yq_yq.append(a0["园区"])
yq_nr.append(a0["内容"])
注：上述代码模块选择数据分析所需指标数据，如（数据总数、处理效率、满意程度.....）最后依据自己的需求来进行挑选【本部分内容因业务需求，因人而异】
四、编辑机器人输出
在编辑钉钉机器人方面具体操作见https://juejin.cn/post/7039038229349138462
######################
####编辑机器人输出(0)###
#####################
if yq_sum == 0:
if data_during_sum == 0 and gd_sum != 0:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"截至当日处理中工单总数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum,gd_rtimemean,gd_stimemean,gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"昨天没有未解决的工单，很棒棒👍👍👍,希望大家再接再厉\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 1:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"##### **截至当日处理中工单综述:**\n"
"##### **%s工单综述:**\n" % open_day +
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 2:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 3:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 4:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 5:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 6:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 7:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 8:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 9:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 10:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[9], gd_coulp2[9], gd_number2[9], gd_leimu2[9], gd_people2[9], gd_peoplenumber2[9],gd_leimu2[9], gd_describe2[9]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
else:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
" **时间:[%s]** \n" % open_day +
"##### **小机器人说:** "
"截至当前无任何处理中工单"
"\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:** \n"
"##### **今日无舆情** \n"
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif yq_sum == 1: # 判断舆情
if data_during_sum == 0 and gd_sum != 0:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum,gd_rtimemean,gd_stimemean,gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"昨天没有未解决的工单，很棒棒👍👍👍,希望大家再接再厉\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 1:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 2:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 3:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 4:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 5:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 6:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 7:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 8:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 9:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 10:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[9], gd_coulp2[9], gd_number2[9], gd_leimu2[9], gd_people2[9], gd_peoplenumber2[9],gd_leimu2[9], gd_describe2[9]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
else:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
" **时间:[%s]** \n" % open_day +
"##### **小机器人说:** "
"截至当前无任何处理中工单"
"\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
else: # 2个舆情
if data_during_sum == 0 and gd_sum != 0:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum,gd_rtimemean,gd_stimemean,gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"昨天没有未解决的工单，很棒棒👍👍👍,希望大家再接再厉\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 1:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 2:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 3:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 4:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 5:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 6:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 7:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 8:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 9:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
elif data_during_sum == 10:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
f"{table1}\n"
"##### \n"
"\n **时间:[%s]** \n" % open_day +
"##### **截至当日处理中工单综述:**\n"
"总工单数<font color=#FF0000 size=6 >%d</font>,平均响应时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,平均解决时长<font color=#FF0000 size=6 >%d</font>"
"<font color=#FF0000 size=6 >min</font>,非常满意工单<font color=#32CD32 size=6 >%d</font>单。\n"
% (gd_sum, gd_rtimemean, gd_stimemean, gd_manyidu1) +
"\n①响应超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_relactcs_sum +
"\n②解决超时工单<font color=#FF0000 size=6 >%d</font>单\n" % data_slovecs_sum +
"\n③未解决工单<font color=#FF0000 size=6 >%d</font>单\n" % data_during_sum +
"#####\n**一、截止当日处理中工单:**\n"
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[0], gd_coulp2[0], gd_number2[0], gd_leimu2[0], gd_people2[0], gd_peoplenumber2[0],gd_leimu2[0], gd_describe2[0]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[1], gd_coulp2[1], gd_number2[1], gd_leimu2[1], gd_people2[1], gd_peoplenumber2[1],
gd_leimu2[1], gd_describe2[1]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[2], gd_coulp2[2], gd_number2[2], gd_leimu2[2], gd_people2[2], gd_peoplenumber2[2],gd_leimu2[2], gd_describe2[2]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[3], gd_coulp2[3], gd_number2[3], gd_leimu2[3], gd_people2[3], gd_peoplenumber2[3],gd_leimu2[3], gd_describe2[3]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[4], gd_coulp2[4], gd_number2[4], gd_leimu2[4], gd_people2[4], gd_peoplenumber2[4],gd_leimu2[4], gd_describe2[4]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[5], gd_coulp2[5], gd_number2[5], gd_leimu2[5], gd_people2[5], gd_peoplenumber2[5],gd_leimu2[5], gd_describe2[5]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[6], gd_coulp2[6], gd_number2[6], gd_leimu2[6], gd_people2[6], gd_peoplenumber2[6],gd_leimu2[6], gd_describe2[6]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[7], gd_coulp2[7], gd_number2[7], gd_leimu2[7], gd_people2[7], gd_peoplenumber2[7],gd_leimu2[7], gd_describe2[7]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[8], gd_coulp2[8], gd_number2[8], gd_leimu2[8], gd_people2[8], gd_peoplenumber2[8],gd_leimu2[8], gd_describe2[8]) +
"\n📌 <font color=#FF8C00 size=6 >%s</font> <font color=#32CD32 size=6 >%s</font>请注意,<font color=#FF0000 size=6 >%s</font>号工单。"
"工单类目为<font color=#FF0000 size=6 >%s</font>;由**%s**(**%s**)发起的%s工单,具体问题为**%s**;\n"
% (gd_yuanqu[9], gd_coulp2[9], gd_number2[9], gd_leimu2[9], gd_people2[9], gd_peoplenumber2[9],gd_leimu2[9], gd_describe2[9]) +
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
else:
def push_report(web_hook):
# 定时任务触发钉钉报告推送
key_word = "未解决工单预警"
header = {
"Content-Type": "application/json;charset=UTF-8"
}
message_body = {
"msgtype": "markdown",
"markdown": {
"title": key_word,
"text": ""
" **时间:[%s]** \n" % open_day +
"##### **小机器人说:** "
"截至当日无任何处理中工单"
"\n"
"##### \n"
"##### **内网行政舆情（含阿里内外/本地内外、钉群、行政发帖评论）具体如下:**\n"
"##### 1.今日舆情 **%d** 起\n①类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_sum, yq_lb[0], yq_xz[0], yq_yq[0], yq_qd[0], yq_nr[0]) +
"##### \n"
"##### ②类别为: **%s**\n性质为:<font color=#32CD32 size=6 >%s</font>\n"
"发生园区:**%s**\n渠道是：**%s**\n内容：**%s**\n" % (yq_lb[1], yq_xz[1], yq_yq[1], yq_qd[1], yq_nr[1]) +
"##### [点击查看工单BI看板](https://youshu.alibaba-inc.com/visual/topicview4Legao?id=257443)"
},
"at": {
"atMobiles": [],
"isAtAll": False
}
}
send_data = json.dumps(message_body) # 将字典类型数据转化为json格式
ChatBot = requests.post(url=web_hook, data=send_data, headers=header)
opener = ChatBot.json()
if opener["errmsg"] == "ok":
print(u"%s 通知消息发送成功！" % opener)
else:
print(u"通知消息发送失败，原因：{}".format(opener))
##########
###输出###
##########
if __name__ == '__main__':
# webhook 来自于 获取机器人webhook：复制webhook 中的那个值
webhook = "自己创建机器人的webhook"
push_report(webhook)
注：依据各种情况和需求选择指定的文档进行发送，达到数据预警的效果。
实现效果
1104
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
