コード例 #1
0
    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)
コード例 #2
0
    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())
コード例 #3
0
    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()
            )
コード例 #4
0
    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)