def update_user_password(u_id): if not request.json: abort(400) if 'password' not in request.json.keys(): return missing_keys_envelop() try: user = db_session.query(User).filter(User.id == u_id).one() if user is None: return record_notfound_envelop() hashed_pass = hash_password(request.json['password'].encode()) old_hashed_pass = user.password if old_hashed_pass == hashed_pass: return jsonify({ 'message': 'Please dont\'t use old password', 'status': 'fail' }) else: user.password = hashed_pass db_session.add(user) db_session.commit() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return record_updated_envelop('Password updated Successfully')
def get_qualifications_by_emp(id): try: qls = db_session.query(Qualification).filter( Qualification.employee_id == id).all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: quals = ({ 'id': q.id, 'name': q.qualification_name.name if q.qualification_name else '', 'institute_name': q.institute_name if q.institute_name else '', 'city': q.city if q.city else '', 'state': q.state if q.state else '', 'province': q.province if q.province else '', 'country': q.country if q.country else '', 'start_date': str(q.start_date) if q.start_date else '', 'end_date': str(q.end_date) if q.end_date else '', 'qualification_name_id': q.qualification_name_id, 'qualification_name': q.qualification_name.name if q.qualification_name else '' } for q in qls) return records_json_envelop(list(quals))
def get_agencytypes(): try: ats = db_session.query(AgencyType).all() except NoResultFound: return record_notfound_envelop() else: return records_json_envelop(list(a.to_dict() for a in ats))
def wrapper(*args, **kwargs): if 'Token' not in request.headers: return unauthorized_envelop() try: decoded = decode_access_token(request.headers['Token']) print(decoded) if decoded is None: return unauthorized_envelop() except Exception as e: raise e return unauthorized_envelop() else: user_name = decoded['user_name'] try: user = db_session.query(User).filter( User.user_name == user_name).one() role = user.role role = role.to_dict()[key] except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() if role != 'N': return func(*args, **kwargs) else: print('as') return unauthorized_envelop()
def get_facilitytype(id): try: ft = db_session.query(FacilityType).filter(FacilityType.id == id).one() except NoResultFound: return record_notfound_envelop() else: return record_json_envelop(ft.to_dict())
def get_facilitytypes(): try: fts = db_session.query(FacilityType).all() except NoResultFound: return record_notfound_envelop() else: return records_json_envelop(list(ft.to_dict() for ft in fts))
def wrapper(*args, **kwargs): if 'Token' not in request.headers: return unauthorized_envelop() try: decoded = decode_access_token(request.headers.get('token')) if decoded is None: return unauthorized_envelop() except Exception as e: return unauthorized_envelop() else: #role_id = decoded['role_id'] user_name = decoded['user_name'] try: user = db_session.query(User).filter( User.user_name == user_name).one() role = user.role role = role.to_dict()[key] except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: if role == 'W' or role == 'E': return func(*args, **kwargs) else: return unauthorized_envelop()
def handle_branch(branch, emp_branch_id, role_id, user_name, func, *args, **kwargs): print('hdnle branch callsed') if ROLES_PERMISSION[role_id]['permission_two'] == True: return func(*args, **kwargs) else: print('asdasdasdasdasdasd') #go ahead and check the permission that if he can edit for his/her own branch or not if ROLES_PERMISSION[role_id]['permission_four'] == True: try: user = db_session.query(User).filter( User.user_name == user_name).one() emp = user.employee if emp is None: return unauthorized_envelop() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: print('yeasdsadsad') employee_branch_id = emp.employee_branch_id print(employee_branch_id, emp_branch_id) if employee_branch_id == emp_branch_id: print('yeahs') return func(*args, **kwargs) else: return unauthorized_envelop() else: return unauthorized_envelop()
def get_empextras_by_emp(id): try: trs = db_session.query(EmployeeExtra).filter( EmployeeExtra.employee_id == id).all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: trs = ({ 'id': q.id, 'ref_name': q.ref_name if q.ref_name else '', 'ref_address': q.ref_address if q.ref_address else '', 'ref_contact_number': q.ref_contact_number if q.ref_contact_number else '', 'emp_father_name': q.emp_father_name if q.emp_father_name else '', 'emp_mother_name': q.emp_mother_name if q.emp_mother_name else '', 'emp_single': q.emp_single if q.emp_single else '', 'emp_wife_name': q.emp_wife_name if q.emp_wife_name else '', 'emp_num_of_children': q.emp_num_of_children if q.emp_num_of_children else '' } for q in trs) return records_json_envelop(list(trs))
def get_employee(id): try: emp = db_session.query(Employee).filter(Employee.id == id).one() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return jsonify({ 'first_name': emp.first_name if emp.first_name else '', 'middle_name': emp.middle_name if emp.middle_name else '', 'last_name': emp.last_name if emp.last_name else '', 'sex': emp.sex if emp.sex else '', 'date_of_birth': str(emp.date_of_birth) if emp.date_of_birth else '', 'address_one': emp.address_one if emp.address_one else '', 'address_two': emp.address_two if emp.address_two else '', 'village': emp.village if emp.village else '', 'llg': emp.llg if emp.llg else '', 'district': emp.district if emp.district else '', 'province': emp.province if emp.province else '', 'region': emp.region if emp.region else '', 'country': emp.country if emp.country else '', 'email_address': emp.email_address if emp.email_address else '', 'contact_number': emp.contact_number if emp.contact_number else '', 'alt_contact_number': emp.alt_contact_number if emp.alt_contact_number else '', 'age': emp.age if emp.age else '', 'retirement_age': emp.retirement_age if emp.retirement_age else '', 'employement_number': emp.employement_number if emp.employement_number else '', 'salary_step': emp.salary_step if emp.salary_step else '', 'date_of_commencement': str(emp.date_of_commencement) if emp.date_of_commencement else '', 'contract_end_date': emp.contract_end_date if emp.contract_end_date else '', 'id': emp.id if emp.id else '', 'user_id': emp.user_id if emp.user_id else '', 'employee_branch_id': emp.employee_branch_id if emp.employee_branch_id else '' })
def get_institutes(): try: its = db_session.query(Institute).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([it.to_dict() for it in its])
def get_emp_positions(): try: ps = db_session.query(EmployeePosition).all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return records_json_envelop([p.to_dict() for p in ps])
def get_organizer_names(): try: langs = db_session.query(OrganizerName).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([l.to_dict() for l in langs])
def get_users(): try: users = db_session.query(User).filter(User.user_name != 'admin').all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return records_json_envelop(list(user.to_dict() for user in users))
def get_registrationbody_names(): try: langs = db_session.query(RegistrationBodyName).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([l.to_dict() for l in langs])
def get_role_by_id(r_id): try: role = db_session.query(Role).filter(Role.id == r_id).one() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return record_json_envelop(role.to_dict())
def get_roles(): try: roles = db_session.query(Role).all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return records_json_envelop(list(role.to_dict() for role in roles))
def get_divisions(): try: divisions = db_session.query(Division).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop(list(d.to_dict() for d in divisions))
def get_facilities(): try: facs = db_session.query(Facility).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop(list(f.to_dict() for f in facs))
def get_agency(id): try: agency = db_session.query(Agency).filter(Agency.id == id).one() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_envelop_error() else: return record_json_envelop(agency.to_dict())
def get_employee_status(): try: statuses = db_session.query(EmployeeStatus).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([status.to_dict() for status in statuses])
def get_employee_educations(id): try: educations = db_session.query(EmployeeEducation).filter( EmployeeEducation.employee_id == id).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([e.to_dict() for e in educations])
def get_langs_by_employee(id): try: langs = db_session.query(EmployeeLanguage).filter( EmployeeLanguage.employee_id == id).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop([l.to_dict() for l in langs])
def get_facilities_by_factype(f_id): try: fcs = db_session.query(Facility).filter( Facility.facility_type_id == f_id).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop(list(fc.to_dict() for fc in fcs))
def get_provinces_by_region(id): try: provinces = db_session.query(Province).filter( Province.region_id == id).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop(list(p.to_dict() for p in provinces))
def get_districts_by_provincess(r_id, p_id): try: districts = db_session.query(District).filter( District.province_id == p_id).all() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return records_json_envelop(list(d.to_dict() for d in districts))
def get_agencies(): try: agencies = db_session.query(Agency).all() except NoResultFound: return record_notfound_envelop() except Exception: raise return fatal_error_envelop() else: return records_json_envelop(list(a.to_dict() for a in agencies))
def get_employees_of_agencies(): try: employees = db_session.query(Employee).filter(Employee.is_branch==False).all() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return records_json_envelop(list(employee.to_dict() for employee in employees))
def get_division_position(id): try: dv = db_session.query(DivisionPosition).filter( DivisionPosition.id == id).one() except NoResultFound: return record_notfound_envelop() except Exception: return fatal_error_envelop() else: return record_json_envelop(dv.to_dict())
def get_password_policy(): try: pol = db_session.query(PasswordPolicy).filter( PasswordPolicy.id == 1).one() except NoResultFound as e: return record_notfound_envelop() except Exception as e: return fatal_error_envelop() else: return record_json_envelop(pol.to_dict())