def update_topic_doc():
user_name, msg = TicketBaseService.get_ticket_field_value(
ticket_id, 'make_slides_assignee')
topic_id, msg = TicketBaseService.get_ticket_field_value(
ticket_id, 'topic_id')
slides_file, msg = TicketBaseService.get_ticket_field_value(
ticket_id, 'slides_file')
slides_object = json.loads(slides_file)
update_doc(user_name, topic_id, slides_object[0]['url'],
slides_object[0]['name'])
def update_slides_make_ticket_field():
topic_index, msg = TicketBaseService.get_ticket_field_value(
ticket_id, 'topic_index')
db = pymongo.MongoClient(MONGO_URI)[MONGO_DB_NAME]
topic_doc = db['topics'].find({'index': int(topic_index)})[0]
topic_name = topic_doc.get('title')
topic_id = topic_doc.get('_id')
TicketBaseService.update_ticket_field_value(
ticket_id, {
'topic_name': topic_name,
'topic_id': topic_id,
'title': '课件制作:' + topic_index + '-' + topic_name
})
# 有参考视频的时候提供截图链接
count = db['lessons'].count_documents({
'topic': topic_id,
'internalOnly': True
})
if count > 0:
lessons_doc = db['lessons'].find({
'topic': topic_id,
'internalOnly': True
})[0]
lesson_id = lessons_doc.get('_id')
edit_slides_url = LOONFLOW_YEE_URL + 'yee/#/pcHome/editSlides/' + lesson_id
TicketBaseService.update_ticket_field_value(
ticket_id, {'edit_slides_url': edit_slides_url})
else:
TicketBaseService.update_ticket_state(ticket_id, 9, '脚本')
def demo_script_call():
# 获取工单信息ip地址信息
username, msg = TicketBaseService.get_ticket_field_value(
ticket_id, 'creator') # ticket_id会通过exec传过来
# 你也可以获取工单的其他字段信息，包括自定义字段的值。根据获取的值做后续处理
print(username)
print(action_from)
return True, ''
def demo_script_call():
# ticket_id will passed by globals， you can get ticket info by TicketBaseService.get_ticket_field_value with 'ticket_id' arg
username, msg = TicketBaseService.get_ticket_field_value(ticket_id, 'creator') # ticket_id会通过exec传过来
host_name, msg2 = TicketBaseService.get_ticket_field_value(ticket_id, 'host_name')
if (username and host_name):
# then you can call your own api to create vm
post_data = dict(username=username, host_name=host_name)
resp = requests.post('http://xxxx.com/api/v1.0/vms', json=post_data).json()
if resp.code == 0:
host_ip = resp.data.get('host_ip', '')
# print msg will saved by loonflow in ticket_flow_log record
print('host_ip is {}'.format(host_ip))
return True, ''
else:
raise Exception('create vm fail: {}'.format(resp.msg))
else:
raise Exception('get ticket info fail, username:{}, host_name:{}'.format(msg, msg2))
return True, ''
def run_flow_task(ticket_id, script_id_str, state_id, action_from='loonrobot'):
"""
执行工作流脚本
:param script_id_star:通过脚本id来执行, 保存的是字符串
:param ticket_id:
:param state_id:
:param action_from:
:return:
"""
script_id = int(script_id_str)
ticket_obj = TicketRecord.objects.filter(id=ticket_id,
is_deleted=False).first()
if ticket_obj.participant == script_id_str and ticket_obj.participant_type_id == CONSTANT_SERVICE.PARTICIPANT_TYPE_ROBOT:
## 校验脚本是否合法
# 获取脚本名称
script_obj = WorkflowScript.objects.filter(id=script_id,
is_deleted=False,
is_active=True).first()
if not script_obj:
return False, '脚本未注册或非激活状态'
script_file = os.path.join(settings.MEDIA_ROOT,
script_obj.saved_name.name)
globals = {'ticket_id': ticket_id, 'action_from': action_from}
# 如果需要脚本执行完成后，工单不往下流转(也就脚本执行失败或调用其他接口失败的情况)，需要在脚本中抛出异常
try:
with stdoutIO() as s:
# execfile(script_file, globals) # for python 2
exec(open(script_file).read(), globals)
script_result = True
# script_result_msg = ''.join(s.buflist)
script_result_msg = ''.join(s.getvalue())
except Exception as e:
logger.error(traceback.format_exc())
script_result = False
script_result_msg = e.__str__()
logger.info('*' * 20 + '工作流脚本回调,ticket_id:[%s]' % ticket_id + '*' * 20)
logger.info('*******工作流脚本回调，ticket_id:{}*****'.format(ticket_id))
# 因为上面的脚本执行时间可能会比较长，为了避免db session失效，重新获取ticket对象
ticket_obj = TicketRecord.objects.filter(id=ticket_id,
is_deleted=False).first()
# 新增处理记录,脚本后只允许只有一个后续直连状态
transition_obj = Transition.objects.filter(source_state_id=state_id,
is_deleted=False).first()
new_ticket_flow_dict = dict(
ticket_id=ticket_id,
transition_id=transition_obj.id,
suggestion=script_result_msg,
participant_type_id=CONSTANT_SERVICE.PARTICIPANT_TYPE_ROBOT,
participant='脚本:(id:{}, name:{})'.format(script_obj.id,
script_obj.name),
state_id=state_id,
creator='loonrobot')
TicketBaseService.add_ticket_flow_log(new_ticket_flow_dict)
if not script_result:
# 脚本执行失败，状态不更新,标记任务执行结果
ticket_obj.script_run_last_result = False
ticket_obj.save()
return False, script_result_msg
# 自动执行流转
tar_state_obj = State.objects.filter(
id=transition_obj.destination_state_id, is_deleted=False).first()
if tar_state_obj.participant_type_id == CONSTANT_SERVICE.PARTICIPANT_TYPE_VARIABLE:
if tar_state_obj.participant == 'creator':
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_PERSONAL
destination_participant = ticket_obj.creator
elif tar_state_obj.participant == 'creator_tl':
approver, msg = AccountBaseService.get_user_dept_approver(
ticket_obj.creator)
if len(approver.split(',')) > 1:
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_MULTI
else:
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_PERSONAL
destination_participant = approver
elif tar_state_obj.participant_type_id == CONSTANT_SERVICE.PARTICIPANT_TYPE_FIELD:
destination_participant, msg = TicketBaseService.get_ticket_field_value(
ticket_id, tar_state_obj.participant)
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_PERSONAL
if len(destination_participant.split(',')) > 1:
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_MULTI
elif tar_state_obj.participant_type_id == CONSTANT_SERVICE.PARTICIPANT_TYPE_PARENT_FIELD:
parent_ticket_id = ticket_obj.parent_ticket_id
destination_participant, msg = TicketBaseService.get_ticket_field_value(
parent_ticket_id, tar_state_obj.participant)
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_PERSONAL
if len(destination_participant.split(',')) > 1:
destination_participant_type_id = CONSTANT_SERVICE.PARTICIPANT_TYPE_MULTI
else:
# 其他类型不换算成实际的处理人
destination_participant_type_id = tar_state_obj.participant_type_id
destination_participant = tar_state_obj.participant
ticket_obj.participant = destination_participant
ticket_obj.participant_type_id = destination_participant_type_id
ticket_obj.state_id = tar_state_obj.id
ticket_obj.save()
add_relation, msg = TicketBaseService.get_ticket_dest_relation(
destination_participant_type_id, destination_participant)
if add_relation:
new_relation, msg = TicketBaseService.add_ticket_relation(
ticket_id, add_relation) # 更新关系人信息
logger.info(
'******脚本执行成功,工单基础信息更新完成, ticket_id:{}******'.format(ticket_id))
# 子工单处理
if tar_state_obj.type_id == CONSTANT_SERVICE.STATE_TYPE_END:
if ticket_obj.parent_ticket_id:
sub_ticket_queryset = TicketRecord.objects.filter(
parent_ticket_id=ticket_obj.parent_ticket_id,
is_deleted=False)
sub_ticket_state_id_list = []
for sub_ticket_query0 in sub_ticket_queryset:
sub_ticket_state_id_list.append(sub_ticket_query0.state_id)
if set(sub_ticket_state_id_list) == set([ticket_obj.state_id]):
# 父工单的所有子工单都已处理结束,自动流转父工单
parent_ticket_obj = TicketRecord.objects.filter(
id=ticket_obj.parent_ticket_id,
is_deleted=False).first()
parent_transition_obj = Transition.object.filter(
source_state_id=parent_ticket_obj.state_id,
is_deleted=False).first()
flag, msg = TicketBaseService.handle_ticket(
parent_ticket_obj.id,
dict(username='******',
suggestion='所有子工单都已结束，自动流转',
transition_id=parent_transition_obj.id))
if not flag:
return True, msg
# 下个状态也是脚本处理
if tar_state_obj.participant_type_id == CONSTANT_SERVICE.PARTICIPANT_TYPE_ROBOT:
run_flow_task.apply_async(
args=[ticket_id, tar_state_obj.participant, tar_state_obj.id],
queue='loonflow')
return True, ''
else:
return False, '工单当前处理人为非脚本，不执行脚本'
if flow_id:
url2 = 'http://%s:%s/api/tickets/' % (mcenter_ip, mcenter_port)
params = {
'workflow_ids': flow_id,
'per_page': 10000,
'category': 'all',
'start_time': data["start_time"],
'end_time': data["end_time"]
}
res2 = requests.request(method="GET",
url=url2,
params=params,
headers=headers).json()
id_list = [i["id"] for i in res2['data']['value']]
for ticket in id_list:
creator, nothing = TicketBaseService.get_ticket_field_value(
ticket, 'creator')
ticket_data, nothing = TicketBaseService.get_ticket_field_value(
ticket, 'data')
gmt_created, nothing = TicketBaseService.get_ticket_field_value(
ticket, 'gmt_created')
if ticket_data:
real_data = eval(ticket_data)
for log in real_data:
if log['time']:
if log['type'] != '':
lxtj[type_list[log['type']]] = lxtj.get(
type_list[log['type']], 0) + float(log['time'])
else:
lxtj['未选择类型'] = lxtj.get('未选择类型', 0) + float(
log['time'])
rytj[creator] = rytj.get(creator, 0) + 1
