def admin_login(admin, remember):
u = db_session.query(Admin).filter_by(email=admin.email, passwd=admin.passwd).first()
if not u:
raise DaixieError(USER_NOT_EXIST)
admin.id = u.id
login_user(u, remember=remember)
return USER_LOGIN_OK
def user_login(user, remember):
u = db_session.query(User).filter_by(email=user.email).first()
if not u:
raise DaixieError(USER_NOT_EXIST)
if u.passwd != user.passwd:
raise DaixieError(USER_PASSWORD_FAIL)
user.id = u.id
login_user(u, remember=remember)
return USER_LOGIN_OK
def get_transaction_by_id(id):
transaction = db_session.query(Transaction).get(id)
return transaction
def get_all_cs_qq():
cs_list = db_session.query(Admin).filter_by(type=Admin.ADMIN_TYPE.CS).all()
qq_list = list(cs.qq for cs in cs_list)
return dict(qq_list=qq_list)
def get_all_CS():
all_cs = db_session.query(Admin).filter_by(type=Admin.ADMIN_TYPE.CS).all()
return all_cs
def get_cs_by_email(email):
cs = db_session.query(Admin).filter_by(email=email, type=Admin.ADMIN_TYPE.CS).first()
return cs
def get_admin_by_email(email):
cs = db_session.query(Admin).filter_by(email=email).first()
return cs
def get_admin_by_id(id):
admin = db_session.query(Admin).get(id)
return admin
def check_is_activated(user):
u = db_session.query(User).filter_by(email=user.email).first()
if u.activate == User.ACTIVATE.NO:
raise DaixieError(USER_IS_NOT_ACTIVATED)
return USER_ACTIVATE_OK
def get_user_by_email(email):
user = db_session.query(User).filter_by(email=email).first()
return user
def get_user_by_id(id):
user = db_session.query(User).get(id)
return user
def get_all_transaction():
all_transaction_list = db_session.query(Transaction).order_by(Transaction.id.desc()).all()
return all_transaction_list
def get_transaction_by_user_id(user_id):
transaction_list = db_session.query(Transaction).filter_by(user_id=user_id).order_by(Transaction.id.asc()).all()
return transaction_list
