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 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_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_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 get_llg():
try:
llgs = db_session.query(LLG).order_by(LLG.name).all()
gen_exp = (dict(name=f.display_name, id=f.id) for f in llgs)
return records_json_envelop(list(gen_exp))
except Exception as e:
return fatal_error_envelop()
def get_districts():
try:
districts = db_session.query(District).order_by(District.name).all()
gen_exp = (dict(name=f.display_name, id=f.id) for f in districts)
return records_json_envelop(list(gen_exp))
except Exception as e:
return fatal_error_envelop()
def get_regions():
try:
provinces = db_session.query(Region).order_by(Region.name).all()
gen_exp = (dict(name=f.display_name, id=f.id) for f in provinces)
return records_json_envelop(list(gen_exp))
except Exception as e:
return fatal_error_envelop()
def get_facilities():
try:
facilities = db_session.query(FacilityType).order_by(FacilityType.name).all()
gen_exp = (dict(name = f.display_name, id=f.id) for f in facilities)
return records_json_envelop(list(gen_exp))
except Exception as e:
return fatal_error_envelop()
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_provinces():
try:
provinces = db_session.query(Province).order_by(Province.name).all()
gen_exp = (p.to_dict() for p in provinces)
return records_json_envelop(list(gen_exp))
except Exception as e:
raise
return fatal_error_envelop()
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_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_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_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_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_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_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_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_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_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_emp_relativetypes():
try:
q = db_session.query(EmployeeRelativeType).all()
except NoResultFound as e:
return record_notfound_envelop()
except Exception as e:
return fatal_error_envelop()
else:
return records_json_envelop(list(row.to_dict() for row in q))
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_employee_types():
try:
types = db_session.query(EmployeeType).all()
tys = (dict(id=ty.id, name=ty.display_name) for ty in types)
except ResultNotFound as e:
return record_notfound_envelop()
except Exception as e:
return fatal_error_envelop()
else:
return records_json_envelop(list(tys))
def get_employees_by_branch(b_id):
try:
employees = db_session.query(Employee).filter(
Employee.employee_branch_id == b_id).filter(
Employee.is_branch == True).all()
except NoResultFound as e:
return record_notfound_envelop()
except Exception as e:
return fatal_error_envelop()
else:
return records_json_envelop(list(emp.to_dict() for emp in employees))
def get_emp_appraisal(id):
try:
bns = db_session.query(EmployeeAppraisal)\
.filter(EmployeeAppraisal.employee_id == id).all()
except NoResultFound:
return record_notfound_envelop()
except Exception:
raise
return fatal_error_envelop()
else:
return records_json_envelop(list(r.to_dict() for r in bns))
def get_employees_by_rank(r_id):
try:
rank = db_session.query(EmployeeCategoryRank).filter(EmployeeCategoryRank.id==r_id).one()
#flatten out the list
employees = itertools.chain.from_iterable(cat.employees for cat in rank.emp_categories)
except NoResultFound as e:
return record_notfound_envelop()
except Exception as e:
return fatal_error_envelop()
else:
return records_json_envelop(list(emp.to_dict() for emp in employees))
