def POST(self):
#登录控制
if session.login == 1:
if session.user:
account_name = web.input().account_name
account_username = web.input().account_username
account_work = web.input().account_work
account_email = web.input().account_email
account_phone = web.input().account_phone
account_position = web.input().account_position
account_department = web.input().account_department
account_power1 = web.input().account_power1
account_power2 = web.input().account_power2
account_power3 = web.input().account_power3
account_power4 = web.input().account_power4
account_power = int(account_power1)*1000+int(account_power2)*100+int(account_power3)*10+int(account_power4)
#检查账号信息是否合法
result = account.account_check(account_name, account_username, account_work, account_email, account_phone,account_position,account_department, account_power)
ajax_result = {"statusCode":"300", "message":result}
web.header('Content-Type', 'application/json')
if result == "no error":
account.account_save(account_name,account_username, account_work, account_email, account_phone, account_position, account_department, account_power)
account_list = account.account_list(account_department = '*')
ajax_result = {"statusCode":"200", "message":"账号添加成功", "callbackType":"closeCurrent"}
return json.dumps(ajax_result)
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def POST(self):
#需要接收account_id
if session.login == 1:
if session.user:
account_id = web.input().account_id
account_name = web.input().account_name
account_username = web.input().account_username
account_work = web.input().account_work
account_email = web.input().account_email
account_phone = web.input().account_phone
account_position = web.input().account_position
account_department = web.input().account_department
account_power1 = web.input().account_power1
account_power2 = web.input().account_power2
account_power3 = web.input().account_power3
account_power4 = web.input().account_power4
account_power = int(account_power1)*1000+int(account_power2)*100+int(account_power3)*10+int(account_power4)
#检查输入信息
result = account.account_check(account_name, account_username, account_work, account_email, account_phone,account_position,account_department, account_power)
if result == "no error":
#存储任务信息
account.account_update(account_id, account_name, account_username, account_work, account_email, account_phone, account_position, account_department, account_power)
account_list = account.account_list('*')
ajax_result = {"statusCode":"200", "message":"账号修改成功", "callbackType":"closeCurrent"}
return json.dumps(ajax_result)
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def POST(self):
#添加新用户
if session.login == 1:
if session.user:
account_name = web.input().account_name
account_sex = web.input().account_sex
account_username = web.input().account_username
account_work = web.input().account_work
account_position = web.input().account_position
account_phone = web.input().account_phone
account_address = web.input().account_address
account_email = web.input().account_email
account_department = web.input().account_department
account_power1 = web.input().account_power1
account_power2 = web.input().account_power2
account_power3 = web.input().account_power3
account_power4 = web.input().account_power4
account_power = int(account_power1)*1000+int(account_power2)*100+int(account_power3)*10+int(account_power4)
#检查账号信息是否合法
result = account.account_check(account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power)
ajax_result = {"statusCode":"300", "message":result}
web.header('Content-Type', 'application/json')
if result == "no error":
#将用户信息存储到数据库中
account.account_save(account_name, account_sex, account_username, account_work, account_position, account_phone,account_address,account_email,account_department, account_power)
#这里account_list是干啥的？
account_list = account.account_list(account_department = '*')
ajax_result = {"statusCode":"200", "message":"账号添加成功", "callbackType":"closeCurrent"}
return json.dumps(ajax_result)
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def POST(self):
#需要接收account_id
if session.login == 1:
if session.user:
account_id = web.input().account_id
account_sex = web.input().account_sex
account_name = web.input().account_name
account_username = web.input().account_username
account_work = web.input().account_work
account_email = web.input().account_email
account_phone = web.input().account_phone
account_position = web.input().account_position
account_address = web.input().account_address
account_department = web.input().account_department
account_power1 = web.input().account_power1
account_power2 = web.input().account_power2
account_power3 = web.input().account_power3
account_power4 = web.input().account_power4
account_power = int(account_power1)*1000+int(account_power2)*100+int(account_power3)*10+int(account_power4)
#检查输入信息
result = account.account_check(account_name, account_sex, account_username, account_work,account_position,account_phone, account_address, account_email, account_department, account_power)
if result == "no error":
#存储任务信息
account.account_update(account_name, account_sex, account_username, account_work,account_position,account_phone, account_address, account_email, account_department, account_power,account_id)
account_list = account.account_list('*')
ajax_result = {"statusCode":"200", "message":"账号修改成功", "callbackType":"closeCurrent"}
return json.dumps(ajax_result)
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def mission_search_list(user, arg):
c = data.SQLconn()
conn = MySQLdb.connect(host=c["host"], user=c["user"], passwd=c["passwd"], charset=c["charset"], db=c["db"])
cursor = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
account_list = account.account_list()
account_list = list(account_list)
for i in account_list:
if data.permission_check(user, i, 'mission') == False:
account_list.remove(i)
if i == 'admin':
account_list.remove(i)
# print 'account_list', len(account_list)
search_list = []
for i in account_list:
cursor.execute("SELECT mission_name, mission_publisher, mission_doer, mission_status,\
mission_starttime, mission_plan_end_time, MISSION.mission_id\
FROM MISSION JOIN MISSIONS_DOERS\
ON MISSION.mission_id=MISSIONS_DOERS.mission_id\
WHERE mission_doer='%s' OR mission_publisher='%s'"%\
(i,i))
search_list += list(cursor.fetchall())
cursor.execute("SELECT mission_name, mission_publisher, mission_doer,\
mission_starttime, mission_plan_end_time, mission_id\
FROM HISTORY_MISSION \
WHERE mission_doer='%s' OR mission_publisher='%s'"\
%(i, i))
search_list += list(cursor.fetchall())
# 去除重复,一点处理
mlist = search_list
search_list = list()
for m in mlist:
if m not in search_list:
if 'mission_status' not in m:
m['mission_status'] = '已完成'
search_list.append(m);
if arg == 'all':
# print search_list
return search_list
mlist = list()
for m in search_list:
if arg.search_str == '' or arg.search_str in m['mission_name']:
if arg.mission_publisher == '' or arg.mission_publisher == m['mission_publisher']:
if arg.mission_doer == '' or arg.mission_doer == m['mission_doer']:
if arg.mission_status == '' or arg.mission_status == m['mission_status']:
if arg.mission_start_time == '' or datetime.datetime.strptime(arg.mission_start_time,"%Y-%m-%d").date() <= m['mission_starttime']:
if arg.mission_end_time == '' or datetime.datetime.strptime(arg.mission_end_time,"%Y-%m-%d").date() >= m['mission_plan_end_time']:
mlist.append(m)
return mlist
def POST(self, args):
account_id = web.input().account_id
if session.login == 1:
if session.user:
account.account_delete(account_id)
account_list = account.account_list(account_department = '*')
ajax_result = {"statusCode":"200", "message":"账号删除成功", "callbackType":"closeCurrent"}
return json.dumps(ajax_result)
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def GET(self):
if session.login == 1:
if session.user:
mission_list = mission.mission_search_list(session.user, 'all')
return render_template(
type=session.type,
template_name='search.html',
mission_list = mission_list[0:30],
account_list = account.account_list(),
count = len(mission_list),
arg = [{'page':1}]
)
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def GET(self):
if session.login == 1:
if session.user:
mission_list = mission.mission_search_list(session.user, 'all')
return render_template(
type=session.type,
template_name='search.html',
mission_list = mission_list[0:30],
account_list = account.account_list(),
count = len(mission_list),
arg = [{'page':1}]
)
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def GET(self,args):
if session.login == 1:
if session.user:
args = web.input()
a = account.account_list(args.type)
return render_template(type = session.type,\
template_name = 'account_list.html',\
user=session.user,\
account_list=a,\
length=len(a))
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
#return render_template(type=0,template_name='login.html',error="请重新登录")
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def GET(self):
if session.login==1:
if session.user:
#返回给多选执行者下拉条
account_list = account.account_list(account_department ='*')
return render_template(type=session.type, \
template_name='new_mission.html', \
user=session.user,\
mission_name="",\
mission_content="",\
mission_starttime="",\
mission_plan_end_time="",\
account_list=account_list,\
error="")
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def GET(self):
if session.login==1:
if session.user:
#返回给多选执行者下拉条
account_list = account.account_list(account_department ='*')
return render_template(type=session.type, \
template_name='new_mission.html', \
user=session.user,\
mission_name="",\
mission_content="",\
mission_starttime="",\
mission_plan_end_time="",\
account_list=account_list,\
error="")
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:
return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def POST(self):
if session.login == 1:
if session.user:
arg = web.input()
mission_list_all = mission.mission_search_list(session.user, arg)
if arg.has_key('pageNum'):
page = int(arg.pageNum) - 1
mission_list_cut = mission_list_all[page*30:int(arg.pageNum)*30]
else:
arg['pageNum'] = 1
mission_list_cut = mission_list_all[0:30]
return render_template(
type=session.type,
template_name='search.html',
mission_list = mission_list_cut,
account_list = account.account_list(),
count = len(mission_list_all),
arg = arg
)
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
def POST(self):
if session.login == 1:
if session.user:
arg = web.input()
mission_list_all = mission.mission_search_list(session.user, arg)
if arg.has_key('pageNum'):
page = int(arg.pageNum) - 1
mission_list_cut = mission_list_all[page*30:int(arg.pageNum)*30]
else:
arg['pageNum'] = 1
mission_list_cut = mission_list_all[0:30]
return render_template(
type=session.type,
template_name='search.html',
mission_list = mission_list_cut,
account_list = account.account_list(),
count = len(mission_list_all),
arg = arg
)
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
else:return json.dumps({"statusCode":"301", "message":"会话超时，请重新登录"})
