def post(self):
weblog.info("%s ,sign in.", self._request_summary())
# weblog.info("tbl_admin:%s", self.localVariable)
userAccount = self.get_argument("userAccount")
password = self.get_argument("password")
inputCode = self.get_argument("inputCode")
user = self.mysqldb().query(
TblAccount.username,
TblAccount.password).filter_by(username=userAccount).first()
if user is None:
return self.write(
json_dumps({
"msg": msg_define.USER_IS_NONE,
"error_code": 1
}))
if user.username != userAccount or user.password != MD5(password):
weblog.error("user password input:{}, ori:{}".format(
user.password, MD5(password)))
return self.write(
json_dumps({
"msg": msg_define.USER_OR_PASSWORD_ERROR,
"error_code": 1
}))
if inputCode.upper() != self.get_secure_cookie("code").decode(
'utf-8').upper():
weblog.error("code you inut:{}, ori code:{}".format(
inputCode.upper(),
self.get_secure_cookie("code").decode('utf-8').upper()))
return self.write(
json_dumps({
"msg": msg_define.VER_CODE_ERROR,
"error_code": 1
}))
# return self.redirect("/download")
# self.set_secure_cookie("user_account", userAccount)
session_id = generate_uuid()
self.set_secure_cookie(SESSION_ID, session_id)
# print("timeout:", self.application.settings['session_timeout'])
self.redis.set(session_id, userAccount,
self.application.settings['session_timeout'])
# session manager
# self.session["user_account"] = userAccount
# self.session.save()
# weblog.info(self.session.get('user_account'))
# weblog.info(self.session.get(self))
return self.write(json_dumps({"msg": "", "error_code": 0}))
def init_user():
from database.tbl_account import TblAccount
account = TblAccount()
account.username = "******"
account.password = MD5("111111")
account.email = "*****@*****.**"
account.userstate = 0
account.userrole = 0
db_session.add(account)
db_session.commit()
db_session.close()
def init_user():
from database.tbl_account import TblAccount
account = TblAccount()
account.loginname = "youth303"
account.nickname = u"青春"
account.password = MD5("303303")
account.email = ""
account.userstate = 0
account.userrole = 2
db_session.add(account)
db_session.commit()
db_session.close()
def init_account():
print('init one account...')
from database.db_config import db_session
from database.tbl_account import TblAccount
from method.data_encode import MD5
account = TblAccount()
account.username = "******"
account.password = MD5("123456")
account.userrole = 0
account.email = "*****@*****.**"
db_session.add(account)
db_session.commit()
db_session.close()
print("add ok")
def init_account():
print('init one account...')
from database.db_config import db_session
from database.tbl_account import TblAccount
from method.data_encode import MD5
account = TblAccount()
account.loginname = "Tornado"
account.nickname = u"飞影"
account.password = MD5("dgj_039103")
account.userrole = 0
account.userstate = 0
account.email = "*****@*****.**"
db_session.add(account)
db_session.commit()
db_session.close()
print("add ok")
def post(self):
loginname = self.get_argument("loginname", None)
nickname = self.get_argument('nickname', None)
password = self.get_argument('password', None)
email = self.get_argument("email", None)
userrole = self.get_argument("userrole", "2")
if loginname == "": loginname = None
if nickname == "": nickname = None
if password == "": password = None
if email == "": email = None
user = self.mysqldb().query(TblAccount).filter(TblAccount.loginname == loginname).first()
if user is None:
adduser = True
else:
adduser = False
if loginname is not None and nickname is not None and password is not None and email is not None:
password = MD5(password)
if adduser:
user = TblAccount()
user.password = password
user.loginname = loginname
user.nickname = nickname
user.email = email
user.userrole = userrole
user.userstate = 0
if adduser:
self.mysqldb().add(user)
try:
self.mysqldb().commit()
return self.write(json_dumps({"error_code": 0, "msg": u"添加成功"}))
except Exception as e:
self.mysqldb().rollbakc()
weblog.error("{}".format(e))
return self.write(json_dumps({"error_code": 1, "msg": u"添加失败"}))
else:
return self.write(json_dumps({"error_code": 1, "msg": u"信息不完整"}))
def post(self):
weblog.info("%s.", self._request_summary())
username = self.get_argument("username", None)
passowrd = self.get_argument("passowrd", None)
useremail = self.get_argument("useremail", None)
userrole = self.get_argument("userrole")
msg = []
if get_user_by_name(self, username) is not None:
msg.append(msg_define.USER_IS_EXIST)
if username is None or username == "":
msg.append(msg_define.USERNAME_IS_EMPTY)
if passowrd is None or check_passord(passowrd) is None:
msg.append(msg_define.USERPASSWORD_INVALID)
if useremail is None or useremail == "":
msg.append(msg_define.USEREMAIL_IS_EMPTY)
elif check_email(useremail) is None:
msg.append(msg_define.USEREMAIL_INVALID)
if msg:
return self.render('admin/useradd.html', message=msg)
else:
try:
new_user = TblAccount()
new_user.username = username
new_user.password = MD5(passowrd)
new_user.email = useremail
new_user.userrole = userrole
new_user.userstate = msg_define.USER_NORMAL
self.mysqldb().add(new_user)
self.mysqldb().commit()
users, total_page = get_user_pagination(self, FIRST_PAGE)
return self.render('admin/usermanage.html',
users=users,
total_page=total_page,
current_page=FIRST_PAGE)
except:
weblog.exception("Add new user error!")
self.mysqldb().rollback()
return self.render('admin/useradd.html', message=msg)
def post(self):
weblog.info("%s ,sign in.", self._request_summary())
weblog.info("tbl_admin:%s", self.localVariable)
userAccount = self.get_argument("userAccount")
password = self.get_argument("password")
inputCode = self.get_argument("inputCode")
user = self.mysqldb().query(TblAccount.username,
TblAccount.password).first()
if user is None:
return self.write(
json_dumps({
"msg": msg_define.USER_IS_NONE,
"error_code": 1
}))
if user.username != userAccount or user.password != MD5(password):
return self.write(
json_dumps({
"msg": msg_define.USER_OR_PASSWORD_ERROR,
"error_code": 1
}))
# return self.redirect("/download")
return self.write(json_dumps({"msg": "", "error_code": 0}))
def post(self):
weblog.info("tbl_admin:%s", self.localVariable)
try:
userAccount = self.get_argument("userAccount", None)
password = self.get_argument("password", None)
inputCode = self.get_argument("inputCode", None)
except Exception as e:
return self.write(
json_dumps({
"msg": USER_IS_NONE,
"error_code": 1
}))
weblog.info("{} {} {}".format(userAccount, password, inputCode))
user = self.mysqldb().query(
TblAccount.loginname, TblAccount.password,
TblAccount.nickname).filter_by(loginname=userAccount).first()
user_update = self.mysqldb().query(TblAccount).filter_by(
loginname=userAccount).first()
if user is None:
return self.write(
json_dumps({
"msg": USER_IS_NONE,
"error_code": 1
}))
if user.loginname != userAccount or user.password != MD5(password):
weblog.error("user password input:{}, ori:{}".format(
user.password, MD5(password)))
return self.write(
json_dumps({
"msg": USER_OR_PASSWORD_ERROR,
"error_code": 1
}))
# secure_code = self.get_secure_cookie('code').decode('utf-8').upper()
if inputCode.upper() == "APP":
if 'Mobile' in self.request.headers['User-Agent']:
weblog.info("mobile login : {}".format(
self.request.headers['User-Agent']))
token = MD5(str(datetime.now().timestamp()) + "APP")
user_update.token = token
user_update.last_logintime = datetime.now()
self.mysqldb().commit()
return self.write(
json_dumps({
"msg": "",
"error_code": 0,
"user": user.loginname,
"token": token
}))
pass
else:
secure_code = self.get_secure_cookie('code')
if secure_code:
secure_code = secure_code.decode('utf-8').upper()
else:
return self.write(
json_dumps({
"msg": VER_CODE_EXPER,
"error_code": 1
}))
if inputCode.upper() != secure_code:
weblog.error("code you inut:{}, ori code:{}".format(
inputCode.upper(),
self.get_secure_cookie("code").decode('utf-8').upper()))
return self.write(
json_dumps({
"msg": VER_CODE_ERROR,
"error_code": 1
}))
user_update.last_logintime = datetime.now()
self.mysqldb().commit()
# self.set_secure_cookie(SESSION_ID, user.loginname, expires=get_expires_datetime(self), expires_days=1)
self.set_secure_cookie(SESSION_ID,
user.loginname,
expires=get_expires_datetime(self),
expires_days=None)
return self.write(
json_dumps({
"msg": "",
"error_code": 0,
"user": user.loginname
}))