def zx_list(xmurl, pagenum): #执行列表查询，返回总页数、总条数、每页数据
username = login_tool.login_tools().get_username().decode('utf-8')
xmmc = cache_tool.res_cache(username)
logger.info(xmmc)
if xmmc[0] == None:
xmmc_list = {}
else:
xmmc_list = re.split(r',', xmmc[0])
if xmurl in xmmc_list or xmmc[0] == None:
sql_list = "SELECT zx.c_bh as zxbh,yl.c_ylmc as ylmc,to_char(zx.dt_zxsj, 'yyyy-mm-dd hh24:mi:ss') as zxsj,zx.c_cgl as cgl,zx.c_fgl as fgl,zx.c_tgl as tgl, c_sfci AS zxfs "\
"FROM db_apitesting.t_at_zxxx zx LEFT JOIN db_apitesting.t_at_ylxx yl ON zx.c_bh_yl = yl.c_bh LEFT JOIN db_apitesting.t_at_xmxx xm ON yl.c_bh_xm = xm.c_bh "\
"WHERE xm.c_url = '%s' ORDER BY zx.dt_zxsj DESC, zx.c_bh DESC LIMIT %s OFFSET %s;" % (xmurl, 10, (int(pagenum) - 1)*10)
sql_count = "SELECT count(1) as counts "\
"FROM db_apitesting.t_at_zxxx zx LEFT JOIN db_apitesting.t_at_ylxx yl ON zx.c_bh_yl = yl.c_bh LEFT JOIN db_apitesting.t_at_xmxx xm ON yl.c_bh_xm = xm.c_bh "\
"WHERE xm.c_url = '%s';" % xmurl
try:
project_dict = {}
res_list = all_dbc.pg_select_operator(sql_list)
res_count = all_dbc.pg_select_operator(sql_count)
project_dict['maxpage'] = math.ceil(res_count[0]['counts']/10)
project_dict['maxsize'] = res_count[0]['counts']
project_dict['nowpage'] = int(pagenum)
project_dict['reslist'] = res_list
return jsonify(project_dict)
except Exception as eee:
logger.error(eee)
return jsonify({'result': 'fail'})
else:
abort(403)
def login():
if not request.json or 'username' not in request.json or 'password' not in request.json:
abort(400)
username = request.json['username']
password = request.json['password']
ccc = login_tool.login_tools().user_load(username.strip(), password)
if ccc != False:
return jsonify({'result': 'success', 'msg': '登录成功'})
else:
return jsonify({'result': 'fail', 'msg': '账户或密码错误，请重新输入，或联系管理员重置'})
def reload_cache():
username = login_tool.login_tools().get_username().decode('utf-8')
if username != 'lianglei':
abort(403)
else:
try:
cache_tool.add_cache()
return jsonify({'result': 'success', 'msg': '缓存刷新成功'})
except Exception as eee:
logger.error('缓存刷新失败：' + str(eee))
logger.exception(eee)
return jsonify({'result': 'fail', 'msg': '缓存刷新失败'})
def updatepwd():
if not request.json or 'new_password' not in request.json:
abort(400)
new_password = request.json['new_password']
if 6 <= len(new_password) <= 18:
username = login_tool.login_tools().get_username().decode('utf-8')
res = login_tool.update_password(new_password, username)
if res:
return jsonify({'result': 'success', 'msg': '密码修改成功！'})
else:
return jsonify({'result': 'fail', 'msg': '密码修改失败，请联系管理员！'})
else:
return jsonify({'result': 'fail', 'msg': '密码需在6~18位之间'})
def view_page(ylbh, ylmc):
info = {}
info['ylbh'] = ylbh
ip = cache_tool.res_cache('localip')
wjlj = 'http://' + str(ip) + ':8585/downloadfile/' + str(ylbh)
# wjlj = 'http://' + str(ip) + '/apitest/downloadfile/' + str(ylbh) #生产参数
edit_key_sql = "SELECT c_edit_key as key FROM db_apitesting.t_at_ylxx WHERE c_bh = '%s'" % (
ylbh)
try:
edit_key = all_dbc.pg_select_operator(edit_key_sql)
except Exception as eee:
logger.error('查询edit_key报错：' + str(eee))
logger.warn(wjlj)
info['lj'] = wjlj
info['key'] = edit_key[0]['key']
username = login_tool.login_tools().get_username().decode('utf-8')
info['name'] = username
return render_template('view.html', title=ylmc, info=info)
def add_tc():
if not request.json or 'tc_text' not in request.json:
abort(400)
username = login_tool.login_tools().get_username().decode('utf-8')
if username == 'guest':
return jsonify({'result': 'guest', 'msg': '游客就别吐槽了呗！_(ÒωÓ๑ゝ∠)_'})
tc_text = request.json['tc_text']
tc_id = base_tool.next_id()
name = cache_tool.res_cache(username)[1]
add_tc_sql = "INSERT INTO db_apitesting.c_at_tc (c_id, c_name, c_text, dt_tjsj, c_fkxx, c_fkzt, dt_fksj) VALUES ('%s', '%s', '%s', now(), NULL, '0', NULL);" % (
tc_id, name, tc_text)
try:
all_dbc.pg_insert_operator(add_tc_sql)
except Exception as eee:
logger.error('提交吐槽信息失败：' + str(eee))
logger.exception(eee)
return jsonify({'result': 'fail', 'msg': '吐槽失败！(,,#ﾟДﾟ) 请联系管理员'})
return jsonify({'result': 'success', 'msg': '提交成功'})
def project_list():
username = login_tool.login_tools().get_username().decode('utf-8')
xmmc = cache_tool.res_cache(username)
if xmmc[0] == None:
sql = "SELECT c_bh as xmbh,c_xmmc as xmmc,c_url as xmdz FROM db_apitesting.t_at_xmxx"
sql_count = "SELECT count(1) as counts FROM db_apitesting.t_at_xmxx"
else:
xmmc = xmmc[0].replace(',', '\',\'')
xmmc = '\'' + str(xmmc) + '\''
sql = "SELECT c_bh as xmbh,c_xmmc as xmmc,c_url as xmdz FROM db_apitesting.t_at_xmxx WHERE c_url IN (%s)" % xmmc
sql_count = "SELECT count(1) as counts FROM db_apitesting.t_at_xmxx WHERE c_url IN (%s)" % xmmc
try:
project_dict = {}
res_list = all_dbc.pg_select_operator(sql)
res_count = all_dbc.pg_select_operator(sql_count)
project_dict['maxsize'] = res_count[0]['counts']
project_dict['reslist'] = res_list
return jsonify(project_dict)
except Exception as eee:
logger.error('项目列表接口报错：' + str(eee))
return jsonify({'result': 'fail'})
def logout():
msg = login_tool.login_tools().logout()
return jsonify({'result': 'success', 'msg': msg})