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)