def createUser(login, first_name, last_name, password, email,region_id, role_id):
validation_Create_Login(login)
validationLogin(login)
validationFirstName(first_name)
validationLastName(last_name)
validationPassword(password)
validation_create_Email(email)
validationEmail(email)
validationRegionID(region_id)
validationRoleID(role_id)
UserDao.createNewUser(login, first_name, last_name, password, email,role_id, region_id )
def updateUser(user_id, login, first_name, last_name, password, email, role_id, region_id):
validationUserID(user_id)
validationLogin(login)
validation_Edit_Login(user_id, login)
validationFirstName(first_name)
validationLastName(last_name)
validationPassword(password)
validationEmail(email)
validationRegionID(region_id)
validationRoleID(role_id)
UserDao.updateUser(user_id, login, first_name, last_name, password, email, role_id, region_id)
def login_authenticate():
if UserDao.isUserExists(request.form['name'], request.form['password']):
user = UserDao.getUserByLogin(request.form['name'], request.form['password'])
session['login'] = user.login
session['user_id'] = user.id
session['role'] = RoleDao.getRoleByID(user.role_id).name
if session['role'] == 'Customer':
return render_template('my_orders.html',)
if session['role'] == 'Administrator':
return render_template('search_user.html',)
if session['role'] == 'Merchandiser':
return render_template('manage_orders.html',)
if session['role'] == 'Supervisor':
return render_template('product_grid.html',)
else:
error = 'Invalid username/password'
return render_template('login(2).html', error=error)
def users_page(page):
all_rec = UserDao.getAllUsers()
records_per_page = 5
pagination = Pagination(records_per_page, all_rec, page)
prods = pagination.pager()
records_amount = len(all_rec)
users_arr = []
for i in prods:
users_arr.append({'id':i.id,'login': i.login, 'first_name': i.first_name, 'last_name': i.last_name,
'role_id': RoleDao.getRoleByID(i.role_id).name, 'email': i.email,
'region_id': RegionDao.getRegionByID(i.region_id).name})
return make_response(jsonify(users=users_arr, records_amount=records_amount,
records_per_page=records_per_page), 200)
def user_pager():
records_per_page = int(request.args.get('table_size'))
page = int(request.args.get('page'))
search_field = request.args.get('field')
search_criteria = request.args.get('criteria')
search_value = request.args.get('value')
users, records_amount = UserDao.pagerByFilterUsers(page, records_per_page, search_field, search_criteria, search_value)
users_arr = []
for i in users:
users_arr.append({'id':i.id,'login': i.login, 'first_name': i.first_name, 'last_name': i.last_name,
'role_id': RoleDao.getRoleByID(i.role_id).name, 'email': i.email,
'region_id': RegionDao.getRegionByID(i.region_id).name})
return make_response(jsonify(users=users_arr, records_amount=records_amount,
records_per_page=records_per_page), 200)
def order_grid(id):
assingee_list = UserDao.getUserByRoleName('Merchandiser')
assingee_arr = []
for i in assingee_list:
assingee_arr.append({'id': i.id, 'name': i.login})
if id==0:
return render_template('order.html',assingee_arr=assingee_arr,order_id=id)
else:
get_order=Order.get_order(id)
status_id=get_order.status.id
if status_id >=3 and get_order.user_id==session['user_id']:
return render_template('order.html',assingee_arr=assingee_arr,order_id=id)
else:
if (Order.get_order(id).user_id == session["user_id"]) or\
(Order.get_order(id).assignee_id == session["user_id"]):
if (session["role"] == "Merchandiser") and (Order.get_order(id).status.name == "Pending"):
update_order_details(id, gift=False, status="Ordered", delivery_date=None)
return render_template('order_details.html')
else:
return "You have not permission to access this page"
def getListUser():
return UserDao.getAllUsers()
def validate_user_id(id):
if not UserDao.getUserByID(id):
raise NotFoundException("Unable to find user with given id")
def getUserByID(user_id):
validationUserID(user_id)
return UserDao.getUserByID(user_id)
def deleteUser(user_id):
validationUserID(user_id)
UserDao.deleteRecord(user_id)
ProductStock.add_new_record(2,3,310)
ProductStock.add_new_record(4,3,118)
ProductStock.add_new_record(5,3,115)
ProductStock.add_new_record(6,3,125)
RoleDao.createNewRole("Administrator")
RoleDao.createNewRole("Merchandiser")
RoleDao.createNewRole("Supervisor")
RoleDao.createNewRole("Customer")
RegionDao.createNewRegion("North")
RegionDao.createNewRegion("West")
RegionDao.createNewRegion("South")
RegionDao.createNewRegion("East")
UserDao.createNewUser('Max', '1111','Maxim','Sidorov', '*****@*****.**',1,2)
UserDao.createNewUser('Nikol', '1111','Nikolay','Lobanov', '*****@*****.**', 4,1)
UserDao.createNewUser('Vanya', '1111','Ivan','Ivanov', '*****@*****.**', 2,1)
UserDao.createNewUser('Andrew', '1111','Andrew','Petrov', '*****@*****.**', 3,4)
UserDao.createNewUser('Katya', '1111','Ekaterina','Ivanova', '*****@*****.**', 4,3)
UserDao.createNewUser('Roma', '1111','Roman','Melnishin', '*****@*****.**', 2,1)
UserDao.createNewUser('Den', '1111','Dennis','Popov', '*****@*****.**', 3,1)
UserDao.createNewUser('Max90', '1111','Maxim','Smirnov', '*****@*****.**', 4,4)
UserDao.createNewUser('Yaroslav', '1111','Yaroslav','Lobanov', '*****@*****.**', 4,2)
UserDao.createNewUser('Seriy', '1111','Sergey','Lobanov', '*****@*****.**', 1,2)
UserDao.createNewUser('Dona', '1111','Donna','Popova', '*****@*****.**', 3,1)
DeliveryType.add_delivery('Courier')
DeliveryType.add_delivery('Express-mail')
#!/usr/bin/env python
# ---Fill test data for user and related entities----
from models.region_dao import RegionDao
from models.role_dao import RoleDao
from models.user_dao import UserDao
RoleDao.createNewRole("Admin")
RegionDao.createNewRegion("Crimea")
UserDao.createNewUser('Anton', '111','Maxim','Sidorov', '*****@*****.**', 1,1)
UserDao.createNewUser('Vanya', '111','Ivan','Ivanov', '*****@*****.**', 1,1)
UserDao.createNewUser('Andrew', '111','Andrew','Petrov', '*****@*****.**', 1,1)
UserDao.createNewUser('Katya', '111','Ekaterina','Ivanova', '*****@*****.**', 1,1)
for instance in UserDao.getAllUsers():
print(instance.id,instance.login,instance.password,instance.first_name, instance.last_name, instance.email,
RoleDao.getRoleByID(instance.role_id).name, RegionDao.getRegionByID(instance.region_id).name)
def api_user_info():
user_id = session["user_id"]
user_details = UserDao.get_user_info_by_id(user_id)
user_details["user_role"] = session["role"]
return make_response(jsonify(user_details), 200)
