def activitycancle(activity_id): activity = Activity.query.get_or_404(activity_id) if (activity.status == 1 or activity.status == 0) and session.get('is_arra_monitor'): #print Article.query.filter(Article.title==article_title).statement flash({'type': 'success', 'content': '活动已经取消。'}) activity = Activity.query.get_or_404(activity_id) activity.status = 4 duties = Duty.query.filter(Duty.aid == activity_id) worktimestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title remark = activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) subject = mail.activity_cancle_tmpl['subject'] content = mail.activity_cancle_tmpl['content'] % (worktimestr, timestr, venue, title, remark, url, url) for duty in duties: if duty.status == 7 or duty.status == 8: msg_id = mail.send_message(duty.uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, duty.member.name, duty.member.email, msgid=msg_id, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) duty.status = 9 db.session.add(duty) db.session.add(activity) db.session.commit() else: flash({'type': 'danger', 'content': '非法操作,请重试。'}) return redirect(url_for('activitydetail', activity_id=activity_id))
def activityappoint(activity_id, member_uid): activity = Activity.query.get_or_404(activity_id) if activity.status == 1 and session.get('is_arra_monitor'): member = Member.query.get(member_uid) if not Duty.query.filter(Duty.aid == activity_id, Duty.uid == member_uid).count(): duty = Duty() duty.aid = activity_id duty.uid = member_uid duty.status = 4 duty.log = '' duty.appendprocesse('activity_appoint', '排班班长安排值班') db.session.add(duty) db.session.commit() # need or not timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") worktimestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title remark = activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) subject = mail.activity_appoint_tmpl['subject'] content = mail.activity_appoint_tmpl['content'] % (worktimestr, timestr, venue, title, remark, url, url) msg_id = mail.send_message(member_uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, member.name, member.email, msgid=msg_id, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) else: flash({'type': 'danger', 'content': '此人已经安排过值班任务。'}) else: flash({'type': 'danger', 'content': '非法操作,请重试。'}) return redirect(url_for('activitydetail', activity_id=activity_id))
def activityedit(activity_id=0): if request.method == 'POST': form = ActivityForm(request.form) if form.validate_on_submit(): if not form.errors: pass#form.username.errors.append('帐号已存在') #print form.errors if not form.errors: activity = Activity.query.get(form.id.data) if not session.get('is_arra_monitor'): abort(403) if not activity: activity = Activity() info_modify = str(activity.title) != str(form.title.data) or str(activity.venue) != str(form.venue.data) or str(activity.work_start_time) != str(form.work_start_time.data) if info_modify: dutylist = Duty.query.filter(Duty.aid == activity_id).all() worktimestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") worktimestr_new = timeformat_filter(form.work_start_time.data, "%Y-%m-%d %H:%M") timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") timestr_new = timeformat_filter(form.start_time.data, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) venue_new = venuename_filter(form.venue.data) title = activity.title title_new = form.title.data remark = activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) subject = mail.activity_modify_tmpl['subject'] content = mail.activity_modify_tmpl['content'] % (worktimestr, worktimestr_new, timestr, timestr_new, venue, venue_new, title, title_new, remark, url, url) for duty in dutylist: msg_id = mail.send_message(duty.uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, duty.member.name, duty.member.email, msgid=msg_id, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) activity.title = form.title.data activity.remark = form.remark.data activity.venue = form.venue.data activity.work_start_time = form.work_start_time.data activity.start_time = form.start_time.data activity.end_time = form.end_time.data activity.type = form.type.data activity.status = form.status.data activity.hostname = form.hostname.data db.session.add(activity) db.session.commit() flash({'type': 'success', 'content': '保存成功!'}) return redirect('/activitymanage') return render_template('activity/activityedit.html', form=form) else: activity = Activity.query.get(activity_id) if not session.get('is_arra_monitor'): abort(403) form = ActivityForm(obj=activity) if Duty.query.filter(Duty.aid == activity_id).count(): flash({'type': 'warning', 'content': '已有音控员负责此活动,请谨慎操作!'}) return render_template('activity/activityedit.html', form=form)
def register(): """Page: activity detail""" form = RegisterForm() if request.method == 'POST': if form.validate_on_submit(): if form.reqcode.data != config.REQCODE: form.reqcode.errors.append('邀请码错误') if Member.query.filter(Member.uid == form.username.data).count(): form.username.errors.append('帐号已存在') if Member.query.filter(Member.email == form.email.data).count(): form.email.errors.append('电子邮箱已存在') if Member.query.filter(Member.mobile_num == form.mobile_num.data).count(): form.mobile_num.errors.append('手机号码已存在') if not form.errors: key = md5.new() key.update(form.password.data) member = Member() member.uid = form.username.data.upper() member.name = form.name.data member.password = key.hexdigest() member.email = form.email.data member.mobile_num = form.mobile_num.data member.type = 0 member.update_register_time() member.update_lastlogin_time() db.session.add(member) db.session.commit() adminmember = Member.query.get(config.SYS_ADMIN) readmeurl = config.BASE_URL + url_for('articledetail', article_title=config.README_TITLE) admin_url = config.BASE_URL + url_for('memberdetail', member_uid=config.SYS_ADMIN) admin_name = adminmember.name subject = mail.register_tmpl['subject'] content = mail.register_tmpl['content'] % (readmeurl, readmeurl, admin_url, admin_name) msg_id = mail.send_message(member.uid, config.SYS_ADMIN, subject, content, 2) mail.send_mail(subject, content, member.name, member.email, msgid=msg_id, touid=member.uid, uid=member.uid) flash({'type': 'success', 'content': '注册成功,请登陆。'}) if viewtype() == 1: return render_template('site/login_mobile.html', form=form) else: return render_template('site/login.html', form=form) if viewtype() == 1: return render_template('site/register_mobile.html', form=form) else: return render_template('site/register.html', form=form)
def forgetpassword(): if request.method == 'POST': username = request.form['username'].upper() email = request.form['email'] user = Member.query.filter(Member.uid == username, Member.email == email).first() if user: import random reset_password_token = str(random.randint(10000000, 99999999)) session['reset_password_uid'] = username session['reset_password_token'] = reset_password_token url = config.BASE_URL + url_for('resetpassword', token=reset_password_token) subject = mail.webforgetpassword_tmpl['subject'] content = mail.webforgetpassword_tmpl['content'] % (url, url) mail.send_mail(subject, content, username, email, touid=username, uid=username) flash({'type': 'success', 'content': '已经向邮箱中发送了电子邮件,请查收!'}) else: flash({'type': 'error', 'content': '你提供的学号和电子邮件不正确。'}) if viewtype() == 1: return render_template('site/forgetpassword_mobile.html') else: return render_template('site/forgetpassword.html')
def _register(username, password, name, email, mobile): key = md5.new() key.update(password) member = Member() member.uid = username.upper().replace(' ', '') member.name = name.replace(' ', '') member.password = key.hexdigest() member.email = email.replace(' ', '') member.mobile_num = mobile.replace(' ', '') member.type = 0 member.update_register_time() member.update_lastlogin_time() db.session.add(member) db.session.commit() adminmember = Member.query.get(config.SYS_ADMIN) readmeurl = config.BASE_URL + url_for('articledetail', article_title=config.README_TITLE) admin_url = config.BASE_URL + url_for('memberdetail', member_uid=config.SYS_ADMIN) admin_name = adminmember.name subject = mail.register_tmpl['subject'] content = mail.register_tmpl['content'] % (readmeurl, readmeurl, admin_url, admin_name) msg_id = mail.send_message(member.uid, config.SYS_ADMIN, subject, content, 2) mail.send_mail(subject, content, member.name, member.email, msgid=msg_id, touid=member.uid, uid=member.uid)
def activity_spider(content): log = [] url = 'http://cdzl.student.hust.edu.cn/Api' sid2ven = {u'5': 1, u'8': 2, u'10': 3} #Fetch contents if not content: try: if config.HTTP_PROXY: proxy_handler = urllib2.ProxyHandler({"http": config.HTTP_PROXY}) opener = urllib2.build_opener(proxy_handler) urllib2.install_opener(opener) content = urllib2.urlopen(url).read() except: log.append('Can\'t fetch vrs api') content = '{}' #print content #Parse contents activities = json.loads(content) oidlist = [] warnings = [] for act in activities: oid = act['id'] oidlist.append(str(oid)) title = act['activity'] remark = act['remark'] venue = sid2ven[act['sid']] start_time = act['time'] work_start_time = int(act['time']) - 3600 # type = activitytypeclassify(title) type = 0 #if exist sql = 'select id,venue,title,remark,work_start_time,start_time from activity where oid = "%s";' % oid #print sql #print 'test oid:'+oid res = db.session.execute(sql) db.session.commit() if not res.rowcount: title = title.replace(':', '\:') remark = remark.replace(':', '\:') sql = 'insert into activity ( oid, title, remark, venue, work_start_time, start_time, type, status) values ("%s", "%s", "%s", "%s", "%s", "%s", "%s", "1");' % (oid, title, remark, venue, work_start_time, start_time, type) #print sql # help! Done new_obj = db.session.execute(sql) #print new_obj.lastrowid db.session.commit() new_id = new_obj.lastrowid log.append('New record inserted new_id:%s oid=%s.' % (new_id, oid)) else: d = {} for r in res: d = {'id': r[0], 'sid': r[1], 'title': r[2], 'remark': r[3], 'worktime': r[4], 'time': r[5]} #print d if str(title)[:32] != str(d['title'])[:32] or str(remark) != str(d['remark']) or str(venue) != str(d['sid']) or int(start_time) != int(d['time']): #sql = 'update activity set title = "%s", remark = "%s", venue = "%s", start_time = "%s" where oid = "%s";' % (title, remark, venue, start_time, oid) #db.session.execute(sql) #db.session.commit() log.append('Same record exists but modified id: %s oid:%s.' % (d['id'], oid)) if int(d['time']) == int(start_time): timestr_modify = u'%s 不变' % timeformat_filter(d['time'], "%Y-%m-%d %H:%M") else: timestr_modify = u'<strong>%s 变为 %s</strong>' % (timeformat_filter(d['time'], "%Y-%m-%d %H:%M"), timeformat_filter(start_time, "%Y-%m-%d %H:%M")) if d['sid'] == venue: venue_modify = u'%s 不变' % venuename_filter(d['sid']) else: venue_modify = u'<strong>%s 变为 %s</strong>' % (venuename_filter(d['sid']), venuename_filter(venue)) if d['title'] == title: title_modify = u'%s 不变' % d['title'] else: title_modify = u'<strong>%s 变为 %s</strong>' % (d['title'], title) if d['remark'] == remark: remark_modify = u'%s 不变' % d['remark'] else: remark_modify = u'<strong>%s 变为 %s</strong>' % (d['remark'], remark) activity = Activity.query.get(d['id']) url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) #subject = mail.notice_activity_modify_tmpl['subject'] content = mail.notice_activity_modify_tmpl['content'] % (timestr_modify, venue_modify, title_modify, remark_modify, url, url) warnings.append(content) #duty_list = Duty.query.filter(Duty.aid==d['id']).all() #timestr_old = timeformat_filter(d['time'],"%Y-%m-%d %H:%M") #timestr_new = timeformat_filter(start_time,"%Y-%m-%d %H:%M") #venue_old = venuename_filter(d['sid']) #venue_new = venuename_filter(venue) #title_old = d['title'] #title_new = title #activity = Activity.query.get(d['id']) #url = config.BASE_URL + url_for('activitydetail',activity_id=activity.id) #subject = mail.activity_modify_tmpl['subject'] #content = mail.activity_modify_tmpl['content'] % ( timestr_old, timestr_new, venue_old, venue_new, title_old, title_new, remark, url, url ) #for duty in duty_list: # mail.send_message(duty.uid,'ADMIN',subject,content,2) # mail.send_mail(subject, content, duty.uid, duty.member.email) else: pass#log.append('Same record exists ignore' ) #print "MySQL Error [%d]: %s" % (e.args[0], e.args[1]) db.session.commit() if oidlist: #for oid in oidlist: ts = time.localtime() todaytime = int(time.time()) - ts.tm_hour * 3600 - ts.tm_min * 60 - ts.tm_sec oidstr = ','.join(oidlist) sql = 'select id, oid, start_time, venue, title from activity where status != "' + str(CONST.ACTIVITY_CANCELED) + '" and start_time >= "%d" and oid not in( %s);' % (todaytime, oidstr) #print sql res = db.session.execute(sql) for row in res: log.append('Record deleted id: %s oid:%s.' % (row[0], row[1])) timestr = timeformat_filter(row[2], "%Y-%m-%d %H:%M") venue = venuename_filter(row[3]) title = row[4] url = config.BASE_URL + url_for('activitydetail', activity_id=row[0]) #subject = mail.notice_activity_cancel_tmpl['subject'] content = mail.notice_activity_cancel_tmpl['content'] % (timestr, venue, title, url, url) warnings.append(content) log.append('Success on %s.' % time.strftime('%Y-%m-%d %H:%M:%S')) if warnings: now = int(time.time()) nowstr = timeformat_filter(now, "%Y-%m-%d %H:%M:%S") subject = mail.spider_notice_tmpl['subject'] content = mail.spider_notice_tmpl['content'] % nowstr + '<hr />'.join(warnings) for uid in config.ARRA_MONITOR: member = Member.query.get(uid) if notify.is_notify(uid, notify.NOTIFY_MESSAGE, notify.NOTIFY_SPIDER): msg_id = mail.send_message(uid, config.SYS_ADMIN, subject, content, 2) else: msg_id = 0 if notify.is_notify(uid, notify.NOTIFY_EMAIL, notify.NOTIFY_SPIDER): mail.send_mail(subject, content, member.name, member.email, msgid=msg_id) if notify.is_notify(uid, notify.NOTIFY_APP, notify.NOTIFY_SPIDER): push_alias(uid, subject, content=content, msgid=msg_id) pass # TODO app notify if notify.is_notify(uid, notify.NOTIFY_SMS, notify.NOTIFY_SPIDER): pass # return log
def cron(): try: last_cron = int(open(config.BASE_DIR + 'data/last_cron.time', 'r').read()) except: last_cron = 0 now = int(time.time()) nowstr = timeformat_filter(now, "%Y-%m-%d %H:%M:%S") if last_cron / (30 * 60) < now / (30 * 60): now = now / (30 * 60) * (30 * 60) logs = [] # 1 hours before activity start activitylist = Activity.query.filter(Activity.work_start_time == now + 3600, Activity.status == 1).all() for activity in activitylist: work_timestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title remark = activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) subject = mail.activity_nearly_begin_tmpl['subject'] content = mail.activity_nearly_begin_tmpl['content'] % (work_timestr, timestr, venue, title, remark, url, url) # TODO %d or %s ? logs.append("%s: Activity almost start id:%d" % (nowstr, activity.id)) for duty in activity.duties: #print subject, content, duty.member.name, duty.member.email, subject, content if duty.status == 7 or duty.status == 8: mail.send_mail(subject, content, duty.member.name, duty.member.email, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) logs.append("%s: Send mail to %s" % (nowstr, duty.uid)) # on activity start activitylist = Activity.query.filter(Activity.start_time == now, Activity.status == 1).all() dutylist = Duty.query.join(Activity).filter(Activity.start_time == now, Activity.status == 1, or_(Duty.status == 6, Duty.status == 7)).all() for activity in activitylist: logs.append("%s : Activity starts, change activity status id:%d" % (nowstr, activity.id)) activity.status = 2 db.session.add(activity) # TODO other duty status for duty in dutylist: logs.append("%s : Activity starts, change duty status id:%d" % (nowstr, duty.id)) duty.status = 10 db.session.add(duty) db.session.commit() # 6 hours after activity start ts = time.localtime(now) if ts.tm_hour == 20 and ts.tm_min == 0 and ts.tm_sec == 0: # auto sync sync() if ts.tm_hour == 21 and ts.tm_min == 30 and ts.tm_sec == 0: range_start = 86400 + now - 21 * 3600 - 1800 range_end = 2 * 86400 + now + 2 * 3600 + 1800 activitylist = Activity.query.filter(Activity.start_time >= range_start, Activity.start_time < range_end, Activity.status == 1).all() warnings = [] for activity in activitylist: ready_num = 0 for duty in activity.duties: if duty.status in [1, 2, 4, 6, 7]: ready_num += 1 if duty.status in [1, 2, 4]: membername = duty.member.name memberurl = url_for('memberdetail', member_uid=duty.uid) worktimestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) statusname = dutystatusname_filter(duty.status) content = mail.todo_duty_tmpl['content'] % (memberurl, membername, worktimestr, timestr, venue, title, url, url, statusname) warnings.append(content) if ready_num == 0: timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) content = mail.todo_activity_tmpl['content'] % (timestr, venue, title, url, url) warnings.append(content) if warnings: now = int(time.time()) nowstr = timeformat_filter(now, "%Y-%m-%d %H:%M:%S") subject = mail.todo_notice_tmpl['subject'] content = mail.todo_notice_tmpl['content'] + '<hr />'.join(warnings) for uid in config.ARRA_MONITOR: member = Member.query.get(uid) msg_id = mail.send_message(uid, config.SYS_ADMIN, subject, content, 2) mail.send_mail(subject, content, member.name, member.email, msgid=msg_id) if ts.tm_hour == 22 and ts.tm_min == 30 and ts.tm_sec == 0: activitylist = Activity.query.filter(Activity.start_time >= now - 22 * 3600 - 1800, Activity.start_time < now + 3600 + 1800, Activity.status == 2).all() for activity in activitylist: worktimestr = timeformat_filter(activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(activity.venue) title = activity.title remark = activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=activity.id) subject = mail.activity_mark_endtime_tmpl['subject'] content = mail.activity_mark_endtime_tmpl['content'] % (worktimestr, timestr, venue, title, remark, url, url) logs.append("%s : Activity almost end id:%d" % (nowstr, activity.id)) for duty in activity.duties: if duty.status == 10: #print subject, content mail.send_mail(subject, content, duty.member.name, duty.member.email, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) logs.append("%s : Send mail to %s" % (nowstr, duty.uid)) open(config.BASE_DIR + 'data/last_cron.time', 'w').write(str(now)) try: fp = open(config.BASE_DIR + 'log/cron.log', 'a') except: fp = open(config.BASE_DIR + 'log/cron.log', 'w') fp.write("crontab %s : %d\n" % (nowstr, now)) for log in logs: fp.write("%s\n" % log) fp.close() return "now" + str(now) else: try: fp = open(config.BASE_DIR + 'log/cron.log', 'a') except: fp = open(config.BASE_DIR + 'log/cron.log', 'w') fp.write("crontab_last %s : %d\n" % (nowstr, now)) fp.close() return "last_cron" + str(last_cron)
def activityopeartion(opeartion, duty_id): duty = Duty.query.get_or_404(duty_id) if duty.activity.status == 1 and (not Duty.query.filter(Duty.id != duty_id, Duty.uid == session['uid'], Duty.aid == duty.aid).count()) and \ ((session['uid'] == duty.member.uid and opeartion in CONST.duty_status_opeartion_selfuser_mapper[duty.status]) or (session['uid'] != duty.member.uid and opeartion in CONST.duty_status_opeartion_otheruser_mapper[duty.status]) or (session.get('is_arra_monitor') and opeartion in CONST.duty_status_opeartion_monitor_mapper[duty.status])): #print Article.query.filter(Article.title==article_title).statement if request.method == 'POST': reason = request.form['content'] else: reason = '' if CONST.dutyoperationname[opeartion].has_key('require_input') and not reason: flash({'type': 'error', 'content': '请填写申请理由。'}) return redirect(url_for('activitydetail', activity_id=duty.aid)) if opeartion == 'cover_duty': if Duty.query.filter(Duty.uid == session['uid'], Duty.aid == duty.aid).count(): flash({'type': 'danger', 'content': '你在本时间段已经有此活动,请勿重复选班。'}) return redirect(url_for('activitydetail', activity_id=duty.aid)) else: worktimestr = timeformat_filter(duty.activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(duty.activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(duty.activity.venue) title = duty.activity.title remark = duty.activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=duty.activity.id) member_url = config.BASE_URL + url_for('memberdetail', member_uid=session['uid']) member_name = session['name'] subject = mail.cover_duty_tmpl['subject'] content = mail.cover_duty_tmpl['content'] % (member_url, member_name, worktimestr, timestr, venue, title, remark, url, url) msg_id = mail.send_message(duty.uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, duty.member.name, duty.member.email, msgid=msg_id, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) new_duty = Duty(aid=duty.aid, uid=session['uid'], status=6, log='') new_duty.appendprocesse('cover_duty', '') db.session.add(new_duty) elif opeartion == 'approve_apply' or opeartion == 'decline_apply': worktimestr = timeformat_filter(duty.activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(duty.activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(duty.activity.venue) title = duty.activity.title remark = duty.activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=duty.activity.id) if opeartion == 'approve_apply': subject = mail.approve_apply_tmpl['subject'] content = mail.approve_apply_tmpl['content'] % (worktimestr, timestr, venue, title, remark, url, url) else: subject = mail.decline_apply_tmpl['subject'] content = mail.decline_apply_tmpl['content'] % (worktimestr, timestr, venue, title, remark, url, url) msg_id = mail.send_message(duty.uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, duty.member.name, duty.member.email, msgid=msg_id, touid=duty.uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) elif opeartion == 'decline_duty': uname = session['name'] worktimestr = timeformat_filter(duty.activity.work_start_time, "%Y-%m-%d %H:%M") timestr = timeformat_filter(duty.activity.start_time, "%Y-%m-%d %H:%M") venue = venuename_filter(duty.activity.venue) title = duty.activity.title remark = duty.activity.remark url = config.BASE_URL + url_for('activitydetail', activity_id=duty.activity.id) subject = mail.decline_duty_tmpl['subject'] content = mail.decline_duty_tmpl['content'] % (uname, reason, worktimestr, timestr, venue, title, remark, url, url) for uid in config.ARRA_MONITOR: member = Member.query.get(uid) msg_id = mail.send_message(uid, session['uid'], subject, content, 2) mail.send_mail(subject, content, member.name, member.email, msgid=msg_id, touid=uid, uid=duty.uid, dutyid=duty.id, activityid=duty.aid) elif opeartion == 'cancle_task': pass#timestr = timeformat_filter(duty.activity.start_time,"%Y-%m-%d %H:%M") #venue = venuename_filter(duty.activity.venue) #title = duty.activity.title #remark = duty.activity.remark #url = config.BASE_URL + url_for('activitydetail',activity_id=duty.activity.id) #subject = mail.approve_apply_tmpl['subject'] #content = mail.approve_apply_tmpl['content'] % ( timestr, venue, title, remark, url , url ) #msg_id = mail.send_message(duty.uid,session['uid'],subject,content,2) #mail.send_mail(subject, content, duty.member.name, duty.member.email, msg_id) duty.status = CONST.duty_status_opeartion_next[opeartion] duty.appendprocesse(opeartion, reason) db.session.add(duty) db.session.commit() flash({'type': 'success', 'content': '操作成功!'}) else: flash({'type': 'danger', 'content': '非法操作,请重试。'}) return redirect(url_for('activitydetail', activity_id=duty.aid))