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