def get(self, start, end): start_date = parse_date(start) end_date = parse_date(end) statistics = get_statistics(start_date, end_date) fieldname_mapping = OrderedDict() fieldname_mapping['unit_type'] = 'Type enhet' fieldname_mapping['unit_number'] = 'Enhetskode' fieldname_mapping['unit_name'] = 'Navn på enhet' fieldname_mapping['name'] = 'Navn på lokalet' fieldname_mapping['hours'] = 'Antall timer utlån fra %s til %s' % (start_date.strftime('%d-%m-%Y'), end_date.strftime('%d-%m-%Y')) return output_csv(statistics, 200, fieldname_mapping=fieldname_mapping)
def get(self): organisations = current_app.db_session.query(Organisation) organisations = organisations.filter(Organisation.is_deleted == False) districts = current_app.db_session.query(District) distr = districts.all() d = dict([(dd.id, dd.name) for dd in distr]) orgs = organisations.order_by(Organisation.name).all() marshalled_org = marshal(orgs, organisation_fields_admin_for_report) for org in marshalled_org: if org["recruitment_area"] is not None: org["recruitment_area"] = d.get(int(org["recruitment_area"]), "") if org["area"] is not None: org["area"] = d.get(int(org["area"]), "") return output_csv(marshalled_org, 200, fieldname_mapping=get_fieldname_mapping(), fields_to_ignore=get_fields_to_ignore())
def get(self, soknad_id=None): if soknad_id: soknad = self.soknad_resource.get(soknad_id) ExternalResourceHelper.load_organisation(soknad) ExternalResourceHelper.load_persons([soknad]) ExternalResourceHelper.load_users([soknad]) return output_pdf(soknad, 200, template=u"pdf/soknad.html") # return output_csv(soknad, 200, fieldname_mapping=get_fieldname_mapping(), fields_to_ignore=get_fields_to_ignore()) else: parser = RequestParser() parser.add_argument("id", type=int, action="append", required=True) args = parser.parse_args() soknader = self.soknad_resource.get() soknader = [s for s in soknader if s["id"] in args["id"]] ExternalResourceHelper.load_organisations(soknader) ExternalResourceHelper.load_persons(soknader) ExternalResourceHelper.load_users(soknader) return output_csv( soknader, 200, fieldname_mapping=get_fieldname_mapping(), fields_to_ignore=get_fields_to_ignore() )
def get(self, facilities_ids, start, end): start_date = parse_date(start) end_date = parse_date(end) facilities = facilities_ids.split(",") resource_overview = get_resource_overview(facilities, start_date, end_date) sorted_overview = sorted(resource_overview, key=lambda k: (k['date'], k['resource'].lower(), k['time'])) fieldname_mapping = OrderedDict() fieldname_mapping['weekday'] = 'Ukedag' fieldname_mapping['date'] = 'Dato' fieldname_mapping['resource'] = 'Lokalet' fieldname_mapping['time'] = 'Tid' fieldname_mapping['organisation'] = 'Aktør' fieldname_mapping['person'] = 'Person' fieldname_mapping['to_be_invoiced'] = 'Fakturering?' fieldname_mapping['text'] = 'Søknadstekst' fieldname_mapping['facilitation'] = 'Tilrettelegging' fieldname_mapping['message'] = 'Svar på søknad' fieldname_mapping['comment'] = 'Saksbehandlerens kommentar' fieldname_mapping['blokkering'] = 'Blokkering merknad' return output_csv(sorted_overview, 200, fieldname_mapping=fieldname_mapping)