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())
