def manage_channel_save(request, channel_id=0):
channel_id = int(channel_id)
err_msg = ''
if channel_id == 0:
channel_id = int(request.GET.get('channel_id', '0'))
ajax = request.POST.get('ajax', False)
model = None
if channel_id == 0:
model = Channel()
model.create_time = datetime.datetime.now()
else:
model = center_cache.get_channel_by_id(channel_id)
model.key = request.POST.get('key', '')
model.name = request.POST.get('name', '')
model.username = request.POST.get('username', '')
model.password = request.POST.get('password', '')
if model.key != '' and model.name != '' and model.username != '':
model.save(using='write')
template = 'feedback.html'
else:
template = 'system/manage_channel_edit.html'
err_msg = '所有数据不能为空!'
if ajax:
return HttpResponse(err_msg)
if ajax:
return HttpResponse("操作成功！")
parg = {}
parg["err_msg"] = err_msg
parg["model"] = model
return render_to_response(template, parg)
def manage_channel_remove(request, channel_id=0):
channel_id = int(channel_id)
model = None
if channel_id > 0:
model = center_cache.get_channel_by_id(channel_id)
if model != None:
model.delete(using='write')
return render_to_response('feedback.html')
def login_key(request):
channel_id = int(request.session.get('channel_id', '0'))
try:
channel = center_cache.get_channel_by_id(channel_id)
if request.method == 'POST':
new_key = request.POST.get('key', '')
if new_key != '' and new_key != channel.login_key:
channel.login_key = new_key
channel.save(using='write')
except Exception, e:
print('change login key has error', e)
def index(request):
channel_id = int(request.session.get('channel_id', '0'))
if channel_id > 0:
the_channel = center_cache.get_channel_by_id(channel_id)
try:
role = Role.objects.using('read').get(name='渠道')
list_menu = role.menu.all()
except:
print('发生错误 未添加渠道角色')
parg = {}
parg["the_channel"] = the_channel
parg["list_menu"] = list_menu
return render_to_response('channel/index.html', parg)
def user_password(request, user_id):
user_id = int(user_id)
if request.method == 'POST':
password = request.POST.get('password', '')
if user_id > 0 and password != '':
try:
channel_id = int(request.session.get('channel_id', '0'))
channel = center_cache.get_channel_by_id(channel_id)
the_user = User.objects.using('read').get(
id=user_id, user_type=0, channel_key=channel.key)
the_user.password = md5(password.lower())
the_user.save(using='write')
msg = '操作成功!'
except Exception, e:
print('set password error:', e)
msg = e
def user_lock(request, user_id, is_lock):
model_id = int(user_id)
is_lock = int(is_lock)
if model_id > 0:
channel_id = int(request.session.get('channel_id', '0'))
try:
channel = center_cache.get_channel_by_id(channel_id)
model = User.objects.using('read').get(id=model_id,
channel_key=channel.key)
if is_lock == 1:
if not model.is_lock():
model.status -= 5
else:
if model.is_lock():
model.status += 5
model.save(using='write')
except Exception, e:
print('lock user error:', e)
def manage_channel_edit(request, channel_id=0):
channel_id = int(channel_id)
if channel_id == 0:
channel_id = int(request.GET.get('channel_id', '0'))
model = None
if channel_id == 0:
default_name = request.GET.get('key', '')
model = Channel(id=0,
key=default_name,
name=default_name,
username=default_name,
password='******')
else:
model = center_cache.get_channel_by_id(channel_id)
parg = {}
parg["model"] = model
return render_to_response('system/manage_channel_edit.html', parg)
def change_password_do(request):
old_password = request.POST.get('old_password', '')
new_password = request.POST.get('new_password', '')
template_name = 'channel/change_password.html'
channel_id = int(request.session.get('channel_id', '0'))
err_msg = ''
the_channel = None
if channel_id > 0:
the_channel = center_cache.get_channel_by_id(channel_id)
if the_channel and the_channel.password == old_password:
the_channel.password = new_password
the_channel.save(using='write')
err_msg = u'密码已经修改成功!'
else:
err_msg = u'旧密码输入不正确!'
parg = {}
parg["err_msg"] = err_msg
return render_to_response(template_name, parg)
def question_list(request, user_id=0):
channel_id = int(request.session.get('channel_id', '0'))
sdate = request.GET.get("sdate", "")
edate = request.GET.get("edate", "")
channel = center_cache.get_channel_by_id(channel_id)
server_id = int(
request.GET.get('server_id', request.POST.get('server_id', '0')))
if server_id == 0:
server_id = int(request.session.get("server_id", '0'))
list_server = Server.objects.using('read').filter(channel__id=channel.id)
if server_id == 0 and len(list_server) > 0:
server_id = list_server[0].id
itemServerList = {}
for item in list_server:
itemServerList[item.id] = item.name
if server_id > 0:
server = Server.objects.get(id=server_id)
data_list = []
user_id = request.GET.get('user_id', '')
is_search_id = True
if user_id != '':
try:
user_id = int(user_id)
except:
is_search_id = False
#如果是角色名字查询
if not is_search_id and server_id > 0:
#因为player表分别在不同服务器下面所以要获取该服务器的链接信息
the_db_config = json.loads(server.log_db_config)
conn = MySQLdb.connect(host=the_db_config['host'],
user=the_db_config['user'],
passwd=the_db_config['password'],
db=the_db_config['db'],
charset="utf8")
conn.autocommit(1)
cursor = conn.cursor()
sql = "SELECT id FROM player_%d WHERE player_name LIKE \'%s%%\' " % (
server_id, user_id)
cursor.execute(sql)
player_list = cursor.fetchall()
if 0 < player_list.__len__():
user_id = player_list[0][0]
page_num = int(request.GET.get('page_num', '1'))
page_size = 20
total_record = 0
total_page = 1
if page_num < 1:
page_num = 1
query = None
if user_id != '':
if query != None:
query = query & Q(post_user=user_id)
else:
query = Q(post_user=user_id)
if server_id == 0:
return HttpResponse('请选择服务器')
if server_id > 0:
if query != None:
query = query & Q(server_id=server_id)
else:
query = Q(server_id=server_id)
if query != None:
query = query & Q(channel_id=channel_id)
else:
query = Q(channel_id=channel_id)
if query == None:
total_record = Question.objects.all().count()
data_list = Question.objects.all()[(page_num - 1) *
page_size:page_num * page_size]
else:
total_record = Question.objects.filter(query).count()
if total_record > 0:
data_list = Question.objects.filter(query)[(page_num - 1) *
page_size:page_num *
page_size]
for item in data_list:
if item.server_id > 0:
item.serverName = itemServerList.get(item.server_id, '--')
else:
item.serverName = "--"
if total_record > page_size:
total_page = total_record / page_size
if total_record % page_size > 0:
total_page += 1
parg = {}
parg["channel"] = channel
parg["server_id"] = server_id
parg["user_id"] = user_id
parg["list"] = data_list
parg["list_server"] = list_server
parg["page_num"] = page_num
parg["page_size"] = page_size
parg["total_record"] = total_record
return render_to_response("channel/question_list.html",
parg,
context_instance=RequestContext(
request,
processors=[channel_channelLoginStatus]))
def user_list(request):
page_size = 30
page_num = int(request.GET.get('page_num', '1'))
the_date = datetime.datetime.now()
sdate = request.GET.get('sdate', the_date.strftime('%Y-%m-1'))
edate = request.GET.get('edate', the_date.strftime('%Y-%m-%d'))
if page_num < 1:
page_num = 1
user_key = request.GET.get('key', '')
query = None
server_id = int(request.GET.get('server_id', '0'))
channel_id = int(request.session.get('channel_id', '0'))
if server_id == 0:
server_id = int(request.session.get("server_id", '0'))
query_date = ''
try:
if sdate != '':
sdate = datetime.datetime.strptime(sdate,
'%Y-%m-%d').strftime('%Y-%m-%d')
query_date = ' and create_time>=\'%s\'' % sdate
if edate != '':
edate = datetime.datetime.strptime(edate,
'%Y-%m-%d').strftime('%Y-%m-%d')
query_date = ' and create_time<=\'%s\'' % edate
except:
sdate = ''
edate = ''
channel = center_cache.get_channel_by_id(channel_id)
# server=Server.objects.get(id=server_id)
# try:
# the_db_config = json.loads(server.log_db_config)
# conn = MySQLdb.connect(host=the_db_config['host'],user=the_db_config['user'],passwd=the_db_config['password'],db=the_db_config['db'])
# except:
# # '数据库链接出错!'
# return HttpResponse("连接错误!")
#
# cursor = conn.cursor()
#
# sql1="SELECT count(1) FROM log_create_role WHERE log_server=%s AND log_channel=%s%s"%(server_id,channel_id,query_date)
# sql2="SELECT log_result,log_server,log_channel,log_user,f1,log_time FROM log_create_role WHERE log_server=%s AND log_channel=%s%s"%(server_id,channel_id,query_date)
# cursor.execute(sql1)
#
# total_record=int(cursor.fetchone()[0])
#
# cursor.execute(sql2)
# list=cursor.fetchall()
#
# cursor.close()
query = Q(channel_key=channel.key)
if user_key != '':
key_type = int(request.GET.get('key_type', '0'))
user_key = user_key.replace('\'', '\'\'')
if key_type == 0:
try:
query = query & Q(id=int(user_key))
except:
print('key_value has error')
else:
query = query & Q(username__icontains=user_key)
total_record = User.objects.using('read').filter(query).count()
list_record = []
if total_record > 0:
list_record = User.objects.using('read').filter(
query)[(page_num - 1) * page_size:page_num * page_size]
parg = {}
parg["channel"] = channel
parg["user_key"] = user_key
parg["list_record"] = list_record
parg["page_num"] = page_num
parg["page_size"] = page_size
parg["total_record"] = total_record
return render_to_response('channel/user_list.html',
parg,
context_instance=RequestContext(
request,
processors=[channel_channelLoginStatus]))
def pay_list(request):
page_size = 50
# 获取 “搜索” 参数
page_num = int(request.GET.get('page_num', '1'))
server_id = int(request.GET.get('server_id', '0'))
user_id = 0
try:
user_id = int(request.GET.get('user_id', '0'))
except Exception:
user_id = 0
#the_date = datetime.datetime.now()
sdate = request.GET.get('sdate', '')
edate = request.GET.get('edate', '')
channel_id = int(request.session.get('channel_id',
'0')) # 获取登陆人 channel id
keyword = request.GET.get("keyword", "")
# 获取 “搜索” 参数 END
#获取Server 对象 和 Server列表
list_server = Server.objects.using('read').filter(
channel__id=channel_id) #根据当前channel id 获取服务器列表
itemServerList = {}
for item in list_server:
itemServerList[item.id] = item.name
if server_id == 0: # 获取 Get参数没有 传 server_id 则在 Session 中获取
server_id = int(request.session.get("server_id", '0'))
if server_id == 0 and len(list_server) > 0:
server_id = list_server[0].id
if server_id > 0:
server = Server.objects.using('read').get(id=server_id)
#获取Server 对象 END
channel = center_cache.get_channel_by_id(channel_id) # 获取当前 渠道对象
#获取查询结果
result = get_payDataSource(keyword, user_id, server_id, sdate, edate,
channel, server, page_size, page_num)
list_record = result['dataSource']
total_record = result['total']
#数据处理
STATUS_CHOICES = {
0: '已提交',
1: '已转发',
2: '已支付,金币发放中',
3: '金币发放中',
4: '充值成功,金币已发放'
}
result_list = []
for item in list_record:
item = list(item)
server_id = item[3]
if server_id > 0:
item[3] = itemServerList.get(server_id, '--')
else:
item[3] = "--"
pay_status = item[5]
remark = item[8]
if pay_status < 0:
item[5] = u'失败:%s' % remark
else:
item[5] = STATUS_CHOICES[pay_status]
post_time = item[11]
item[11] = post_time.strftime('%m-%d %H:%M:%S')
result_list.append(item)
parg = {}
parg["channel"] = channel
parg["list_server"] = list_server
parg["keyword"] = keyword
parg["user_id"] = user_id
parg["result_list"] = result_list
parg["page_num"] = page_num
parg["page_size"] = page_size
parg["total_record"] = total_record
return render_to_response('channel/pay_list.html',
parg,
context_instance=RequestContext(
request,
processors=[channel_channelLoginStatus]))
def channel_list_allchannel(request, query_id=1, channel_id=0):
query_id = int(query_id)
query_server = request.GET.getlist("s")
if not QueryResult.objects.using('read').filter(id=query_id).exists():
return HttpResponse("该查询已不存在,已被删除")
the_query = QueryResult.objects.using('read').get(id=query_id)
list_statistic = the_query.statistic.all()
join_results = []
for item in list_statistic:
join_results.append(str(item.id))
channel_id = int(channel_id)
if channel_id == 0:
channel_id = int(request.session.get('channel_id', '0'))
channel = center_cache.get_channel_by_id(channel_id)
list_server = []
if channel != None:
list_server = Server.objects.using('read').filter(
channel__id=channel_id)
for serverItem in list_server:
serverItem.is_show = False
if len(query_server) > 0:
if str(serverItem.id) in query_server:
serverItem.is_show = True
else:
serverItem.is_show = True
where_server = ''
if len(query_server) > 0:
where_server = ' and server_id in (%s)' % (','.join(query_server))
the_date = datetime.datetime.now()
sdate = request.GET.get('sdate', the_date.strftime('%Y-%m-1'))
edate = request.GET.get('edate', the_date.strftime('%Y-%m-%d'))
query_date = ''
try:
if sdate != '':
sdate = datetime.datetime.strptime(sdate,
'%Y-%m-%d').strftime('%Y-%m-%d')
query_date = ' and result_time>=\'%s\'' % sdate
if edate != '':
edate = datetime.datetime.strptime(edate,
'%Y-%m-%d').strftime('%Y-%m-%d')
query_date += ' and result_time<=\'%s\'' % edate
except:
sdate = ''
edate = ''
query_channel = ''
# if channel!=None:
# if channel_id>0:
# query_channel = ' and channel_id=%d'%channel_id
#page_size = 30
#page_num = int(request.GET.get('page_num', '1'))
#list_channel = Channel.objects.using('read').all()
cursor = connections['read'].cursor()
count_sql = 'select count(distinct result_time) result from result where statistic_id in(%s)%s%s%s' % (
','.join(join_results), query_channel, where_server, query_date)
print 'count_sql:'
print count_sql
cursor.execute(count_sql)
total_record = int(cursor.fetchone()[0])
list_record = []
if total_record > 0:
select_str = 'result_time'
for item in join_results:
select_str += ',sum(case when `statistic_id`=%s then result else 0 end) item%s' % (
item, item)
query_sql = 'select %s from result where statistic_id in(%s)%s%s%s group by result_time' % (
select_str, ','.join(join_results), query_channel, where_server,
query_date)
print 'query_sql:'
print(query_sql)
cursor.execute(query_sql)
list_record = cursor.fetchall()
#cursor.close()
parg = {}
parg["channel"] = channel
parg["list_server"] = list_server
parg["sdate"] = sdate
parg["edate"] = edate
parg["list_statistic"] = list_statistic
parg["list_record"] = list_record
parg["the_query"] = the_query
return render_to_response('channel/result_list_allchannel.html',
parg,
context_instance=RequestContext(
request,
processors=[channel_channelLoginStatus]))
def channel_pay_rank_list(request):
channel_id = int(request.session.get('channel_id', '0'))
user_id = request.GET.get("user_id", '')
user_name = request.GET.get("user_name", "")
sdate = request.GET.get("sdate", "")
edate = request.GET.get("edate", "")
server_id = int(request.GET.get('s', '0')) #server_id
page_num = int(request.GET.get("page_num", "1"))
is_search = request.GET.get("is_search", False)
if user_id == "":
user_id = "0"
user_id = int(user_id)
page_size = 50
list_server = Server.objects.using('read').filter(
channel__id=channel_id).order_by("create_time")
if not is_search:
return render_to_response("channel/pay_rank_list.html", locals())
if server_id == 0:
return HttpResponse('请选择服务器')
channel = center_cache.get_channel_by_id(channel_id)
query_where = " a.query_id != '' and a.query_id IS NOT NULL and a.pay_amount != 0 and a.channel_id=%s and a.pay_status=4" % channel.id
try:
if sdate != "":
sdate = datetime.datetime.strptime(
sdate, '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
query_where += " and a.last_time>='%s'" % sdate
if edate != "":
edate = datetime.datetime.strptime(
edate, '%Y-%m-%d %H:%M:%S').strftime('%Y-%m-%d %H:%M:%S')
query_where += " and a.last_time<='%s'" % edate
except:
sdate = ""
edate = ""
query_where += " and a.server_id = %d " % server_id
limit_str = "LIMIT 50"
if user_id > 0:
query_where += " and a.pay_user=%s" % user_id
limit_str = ' '
query_sql = "select a.pay_user,sum(a.pay_amount) total_amount from pay_action a where %s group by pay_user order by total_amount desc %s" % (
query_where, limit_str)
query_count = "select count(distinct pay_user) from pay_action a where %s" % query_where
print "channel_pay_rank_list:"
print query_count
print query_sql
cursor = connections['read'].cursor()
cursor.execute(query_count)
total_record = int(cursor.fetchone()[0])
#raise Exception, query_sql
list_record = []
if total_record > 0:
cursor.execute(query_sql)
list_record = cursor.fetchall()
#cursor.close()
if user_id <= 0:
user_id = ""
parg = {}
parg["channel"] = channel
parg["list_server"] = list_server
parg["server_id"] = server_id
parg["user_id"] = user_id
parg["sdate"] = sdate
parg["edate"] = edate
parg["list_record"] = list_record
return render_to_response("channel/pay_rank_list.html", parg)
def manage_question_list_user(request, user_id=0):
channel_id = int(request.session.get('channel_id', '0'))
channel = center_cache.get_channel_by_id(channel_id)
server_id = 0 #int(request.session.get("server_id",'0'))
data_list = []
user_id = int(user_id)
page_num = int(request.GET.get('page_num', '1'))
question_id = int(request.GET.get('question_id', '0'))
# if int(question_id)>0:
# select_question=Question.objects.get(id=question_id)
page_size = 5
total_record = 0
total_page = 1
if page_num < 1:
page_num = 1
if user_id > 0:
if server_id > 0:
total_record = Question.objects.filter(
post_user__id=user_id,
post_user__channel_key=channel.key,
server_id=server_id).count()
if total_record > 0:
data_list = Question.objects.filter(
post_user__id=user_id,
post_user__channel_key=channel.key,
server_id=server_id)[(page_num - 1) * page_size:page_num *
page_size]
else:
total_record = Question.objects.filter(
post_user__id=user_id,
post_user__channel_key=channel.key).count()
if total_record > 0:
data_list = Question.objects.filter(
post_user__id=user_id,
post_user__channel_key=channel.key)[(page_num - 1) *
page_size:page_num *
page_size]
else:
if server_id > 0:
total_record = Question.objects.filter(
post_user__channel_key=channel.key,
server_id=server_id).count()
if total_record > 0:
data_list = Question.objects.filter(
post_user__channel_key=channel.key,
server_id=server_id)[(page_num - 1) * page_size:page_num *
page_size]
else:
total_record = Question.objects.filter(
post_user__channel_key=channel.key).count()
if total_record > 0:
data_list = Question.objects.filter(
post_user__channel_key=channel.key)[(page_num - 1) *
page_size:page_num *
page_size]
list_server = Server.objects.filter(channel__id=channel.id)
itemServerList = {}
for item in list_server:
itemServerList[item.id] = item.name
for item in data_list:
if item.server_id > 0:
item.serverName = itemServerList.get(item.server_id, '--')
else:
item.serverName = "--"
item.playerName = item.post_user.username
if total_record > page_size:
total_page = total_record / page_size
if total_record % page_size > 0:
total_page += 1
# if int(question_id)>0:
# Log._meta.db_table = 'log_create_role'
# create_role_list=Log.objects.filter(log_user=user_id,log_server=select_question.server_id)
# if len(create_role_list)>0:
# create_role=create_role_list[0]
if int(question_id) > 0:
Log._meta.db_table = 'Users'
selectUser = User.objects.get(id=user_id)
parg = {}
parg["selectUser"] = selectUser
parg["list"] = data_list
parg["page_num"] = page_num
parg["page_size"] = page_size
parg["total_record"] = total_record
return render_to_response('channel/question_user_list.html', parg)