1.2.2

Merge pull request 'patches: v1.2.2' (#56 ) from develop into main
Reviewed-on: #56
2025-01-31 11:42:55 +01:00 · 2025-01-31 10:42:32 +00:00 · 2025-01-31 11:40:59 +01:00 · 2025-01-27 16:26:00 +01:00 · 2025-01-27 15:20:22 +01:00 · 2025-01-27 14:19:55 +00:00
116 changed files with 2523 additions and 635 deletions
--- a/.env.example
+++ b/.env.example
@ -10,6 +10,7 @@ SERVER_PORT = portnumber
 JWT_SECRET = ABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890
 JWT_EXPIRATION = [0-9]*(y|d|h|m|s)
 REFRESH_EXPIRATION = [0-9]*(y|d|h|m|s)
+PWA_REFRESH_EXPIRATION = [0-9]*(y|d|h|m|s)

 MAIL_USERNAME = mail_username
 MAIL_PASSWORD = mail_password
@ -17,5 +18,5 @@ MAIL_HOST = mail_hoststring
 MAIL_PORT = mail_portnumber
 MAIL_SECURE (true|false) // true for port 465, fals for other ports

-CLUB_NAME = clubname
+CLUB_NAME = clubname #default FF Admin
 CLUB_WEBSITE = https://my-club-website-url
--- a/README.md
+++ b/README.md
@ -6,7 +6,7 @@ Administration für Feuerwehren und Vereine (Backend).

 Dieses Projekt, `ff-admin-server`, ist das Backend zur Verwaltung von Mitgliederdaten. Die zugehörige Webapp ist im Repository [ff-admin-ui](https://forgejo.jk-effects.cloud/Ehrenamt/ff-admin) zu finden.

-Eine Demo zusammen mit der `ff-admin` finden Sie unter [ff-admin-demo.jk-effects.cloud](ff-admin-demo.jk-effects.cloud).
+Eine Demo zusammen mit der `ff-admin` finden Sie unter [https://admin-demo.ff-admin.de](https://admin-demo.ff-admin.de).

 ## Installation

@ -20,26 +20,27 @@ Um den Container hochzufahren, erstellen Sie eine `docker-compose.yml` Datei mit
 version: "3"

 services:
-  ff-ff-admin-server:
+  ff-admin-server:
    image: docker.registry.jk-effects.cloud/ehrenamt/ff-admin/server:latest
    container_name: ff_member_administration_server
    restart: unless-stopped
    environment:
-      - DB_TYPE=mysql
-      - DB_HOST=ffm-db
-      - DB_PORT=<number> # fallback ist auf 3306 gesetzt
+      - DB_TYPE=<mysql|sqlite> # default ist auf mysql gesetzt
+      - DB_HOST=ff-db
+      - DB_PORT=<number> # default ist auf 3306 gesetzt
      - DB_NAME=ffadmin
      - DB_USERNAME=administration_backend
      - DB_PASSWORD=<dbuserpasswd>
      - JWT_SECRET=<tobemodified>
-      - JWT_EXPIRATION=<number[m|d] - bsp.:15m>
-      - REFRESH_EXPIRATION=<number[m|d] - bsp.:1d>
+      - JWT_EXPIRATION=<number[m|d] - bsp.:15m> # default ist auf 15m gesetzt
+      - REFRESH_EXPIRATION=<number[m|d] - bsp.:1d> # default ist auf 1d gesetzt
+      - PWA_REFRESH_EXPIRATION=<number[m|d] - bsp.:5d> # default ist auf 5d gesetzt
      - MAIL_USERNAME=<mailadress|username>
      - MAIL_PASSWORD=<password>
      - MAIL_HOST=<url>
-      - MAIL_PORT=<port>
-      - MAIL_SECURE=<boolean>
-      - CLUB_NAME=<tobemodified>
+      - MAIL_PORT=<port> # default ist auf 578 gesetzt
+      - MAIL_SECURE=<boolean> # default ist auf false gesetzt
+      - CLUB_NAME=<tobemodified> # default ist auf FF Admin gesetzt
      - CLUB_WEBSITE=<tobemodified>
    volumes:
      - <volume|local path>:/app/files
--- a/package-lock.json
+++ b/package-lock.json
@ -1,12 +1,12 @@
 {
  "name": "ff-admin-server",
-  "version": "1.0.0",
+  "version": "1.2.2",
  "lockfileVersion": 3,
  "requires": true,
  "packages": {
    "": {
      "name": "ff-admin-server",
-      "version": "1.0.0",
+      "version": "1.2.2",
      "license": "GPL-3.0-only",
      "dependencies": {
        "cors": "^2.8.5",
@ -24,6 +24,7 @@
        "puppeteer": "^23.11.1",
        "qrcode": "^1.5.4",
        "reflect-metadata": "^0.2.2",
+        "rss-parser": "^3.13.0",
        "socket.io": "^4.7.5",
        "speakeasy": "^2.0.0",
        "typeorm": "^0.3.20",
@ -1496,6 +1497,15 @@
      "resolved": "https://registry.npmjs.org/ms/-/ms-2.1.2.tgz",
      "integrity": "sha512-sGkPx+VjMtmA6MX27oA4FBFELFCZZ4S4XqeGOXCv68tT+jb3vk/RyaKWP0PTKyWtmLSM0b+adUTEvbs1PEaH2w=="
    },
+    "node_modules/entities": {
+      "version": "2.2.0",
+      "resolved": "https://registry.npmjs.org/entities/-/entities-2.2.0.tgz",
+      "integrity": "sha512-p92if5Nz619I0w+akJrLZH0MX0Pb5DX39XOwQTtXSdQQOaYH03S1uIQp4mhOZtAXrxq4ViO67YTiLBo2638o9A==",
+      "license": "BSD-2-Clause",
+      "funding": {
+        "url": "https://github.com/fb55/entities?sponsor=1"
+      }
+    },
    "node_modules/env-paths": {
      "version": "2.2.1",
      "resolved": "https://registry.npmjs.org/env-paths/-/env-paths-2.2.1.tgz",
@ -3152,6 +3162,16 @@
        "node": ">= 0.10"
      }
    },
+    "node_modules/rss-parser": {
+      "version": "3.13.0",
+      "resolved": "https://registry.npmjs.org/rss-parser/-/rss-parser-3.13.0.tgz",
+      "integrity": "sha512-7jWUBV5yGN3rqMMj7CZufl/291QAhvrrGpDNE4k/02ZchL0npisiYYqULF71jCEKoIiHvK/Q2e6IkDwPziT7+w==",
+      "license": "MIT",
+      "dependencies": {
+        "entities": "^2.0.3",
+        "xml2js": "^0.5.0"
+      }
+    },
    "node_modules/runes2": {
      "version": "1.1.4",
      "resolved": "https://registry.npmjs.org/runes2/-/runes2-1.1.4.tgz",
@ -3182,6 +3202,12 @@
      "resolved": "https://registry.npmjs.org/safer-buffer/-/safer-buffer-2.1.2.tgz",
      "integrity": "sha512-YZo3K82SD7Riyi0E1EQPojLz7kpepnSQI9IyPbHHg1XXXevb5dJI7tpyN2ADxGcQbHG7vcyRHk0cbwqcQriUtg=="
    },
+    "node_modules/sax": {
+      "version": "1.4.1",
+      "resolved": "https://registry.npmjs.org/sax/-/sax-1.4.1.tgz",
+      "integrity": "sha512-+aWOz7yVScEGoKNd4PA10LZ8sk0A/z5+nXQG5giUO5rprX9jgYsTdov9qCchZiPIZezbZH+jRut8nPodFAX4Jg==",
+      "license": "ISC"
+    },
    "node_modules/semver": {
      "version": "7.6.3",
      "resolved": "https://registry.npmjs.org/semver/-/semver-7.6.3.tgz",
@ -4253,6 +4279,28 @@
        }
      }
    },
+    "node_modules/xml2js": {
+      "version": "0.5.0",
+      "resolved": "https://registry.npmjs.org/xml2js/-/xml2js-0.5.0.tgz",
+      "integrity": "sha512-drPFnkQJik/O+uPKpqSgr22mpuFHqKdbS835iAQrUC73L2F5WkboIRd63ai/2Yg6I1jzifPFKH2NTK+cfglkIA==",
+      "license": "MIT",
+      "dependencies": {
+        "sax": ">=0.6.0",
+        "xmlbuilder": "~11.0.0"
+      },
+      "engines": {
+        "node": ">=4.0.0"
+      }
+    },
+    "node_modules/xmlbuilder": {
+      "version": "11.0.1",
+      "resolved": "https://registry.npmjs.org/xmlbuilder/-/xmlbuilder-11.0.1.tgz",
+      "integrity": "sha512-fDlsI/kFEx7gLvbecc0/ohLG50fugQp8ryHzMTuW9vSa1GJ0XYWKnhsUx7oie3G98+r56aTQIUB4kht42R3JvA==",
+      "license": "MIT",
+      "engines": {
+        "node": ">=4.0"
+      }
+    },
    "node_modules/y18n": {
      "version": "4.0.3",
      "resolved": "https://registry.npmjs.org/y18n/-/y18n-4.0.3.tgz",
--- a/package.json
+++ b/package.json
@ -1,6 +1,6 @@
 {
  "name": "ff-admin-server",
-  "version": "1.0.0",
+  "version": "1.2.2",
  "description": "Feuerwehr/Verein Mitgliederverwaltung Server",
  "main": "dist/index.js",
  "scripts": {
@ -39,6 +39,7 @@
    "puppeteer": "^23.11.1",
    "qrcode": "^1.5.4",
    "reflect-metadata": "^0.2.2",
+    "rss-parser": "^3.13.0",
    "socket.io": "^4.7.5",
    "speakeasy": "^2.0.0",
    "typeorm": "^0.3.20",
--- a/src/command/club/member/communicationCommand.ts
+++ b/src/command/club/member/communicationCommand.ts
@ -1,6 +1,7 @@
 export interface CreateCommunicationCommand {
  preferred: boolean;
  isSMSAlarming: boolean;
+  isSendNewsletter: boolean;
  mobile: string;
  email: string;
  postalCode: string;
@ -16,6 +17,7 @@ export interface UpdateCommunicationCommand {
  id: number;
  preferred: boolean;
  isSMSAlarming: boolean;
+  isSendNewsletter: boolean;
  mobile: string;
  email: string;
  postalCode: string;
--- a/src/command/club/member/communicationCommandHandler.ts
+++ b/src/command/club/member/communicationCommandHandler.ts
@ -14,26 +14,44 @@ export default abstract class CommunicationCommandHandler {
   * @returns {Promise<number>}
   */
  static async create(createCommunication: CreateCommunicationCommand): Promise<number> {
+    let insertId = -1;
    return await dataSource
-      .createQueryBuilder()
-      .insert()
-      .into(communication)
-      .values({
-        preferred: createCommunication.preferred,
-        isSMSAlarming: createCommunication.isSMSAlarming,
-        mobile: createCommunication.mobile,
-        email: createCommunication.email,
-        postalCode: createCommunication.postalCode,
-        city: createCommunication.city,
-        street: createCommunication.street,
-        streetNumber: createCommunication.streetNumber,
-        streetNumberAddition: createCommunication.streetNumberAddition,
-        memberId: createCommunication.memberId,
-        typeId: createCommunication.typeId,
+      .transaction(async (manager) => {
+        await manager
+          .createQueryBuilder()
+          .insert()
+          .into(communication)
+          .values({
+            preferred: createCommunication.preferred,
+            isSMSAlarming: createCommunication.isSMSAlarming,
+            isSendNewsletter: createCommunication.isSendNewsletter,
+            mobile: createCommunication.mobile,
+            email: createCommunication.email,
+            postalCode: createCommunication.postalCode,
+            city: createCommunication.city,
+            street: createCommunication.street,
+            streetNumber: createCommunication.streetNumber,
+            streetNumberAddition: createCommunication.streetNumberAddition,
+            memberId: createCommunication.memberId,
+            typeId: createCommunication.typeId,
+          })
+          .execute()
+          .then((result) => {
+            insertId = result.identifiers[0].id;
+          });
+
+        await manager
+          .createQueryBuilder()
+          .update(communication)
+          .set({
+            isSendNewsletter: false,
+          })
+          .where("memberId = :memberId", { memberId: createCommunication.memberId })
+          .andWhere("id <> :id", { id: insertId })
+          .execute();
      })
-      .execute()
-      .then((result) => {
-        return result.identifiers[0].id;
+      .then(() => {
+        return insertId;
      })
      .catch((err) => {
        throw new InternalException("Failed creating communication", err);
@ -47,22 +65,36 @@ export default abstract class CommunicationCommandHandler {
   */
  static async update(updateCommunication: UpdateCommunicationCommand): Promise<void> {
    return await dataSource
-      .createQueryBuilder()
-      .update(communication)
-      .set({
-        preferred: updateCommunication.preferred,
-        isSMSAlarming: updateCommunication.isSMSAlarming,
-        mobile: updateCommunication.mobile,
-        email: updateCommunication.email,
-        postalCode: updateCommunication.postalCode,
-        city: updateCommunication.city,
-        street: updateCommunication.street,
-        streetNumber: updateCommunication.streetNumber,
-        streetNumberAddition: updateCommunication.streetNumberAddition,
+      .transaction(async (manager) => {
+        await manager
+          .createQueryBuilder()
+          .update(communication)
+          .set({
+            preferred: updateCommunication.preferred,
+            isSMSAlarming: updateCommunication.isSMSAlarming,
+            isSendNewsletter: updateCommunication.isSendNewsletter,
+            mobile: updateCommunication.mobile,
+            email: updateCommunication.email,
+            postalCode: updateCommunication.postalCode,
+            city: updateCommunication.city,
+            street: updateCommunication.street,
+            streetNumber: updateCommunication.streetNumber,
+            streetNumberAddition: updateCommunication.streetNumberAddition,
+          })
+          .where("id = :id", { id: updateCommunication.id })
+          .andWhere("memberId = :memberId", { memberId: updateCommunication.memberId })
+          .execute();
+
+        await manager
+          .createQueryBuilder()
+          .update(communication)
+          .set({
+            isSendNewsletter: false,
+          })
+          .where("memberId = :memberId", { memberId: updateCommunication.memberId })
+          .andWhere("id <> :id", { id: updateCommunication.id })
+          .execute();
      })
-      .where("id = :id", { id: updateCommunication.id })
-      .andWhere("memberId = :memberId", { memberId: updateCommunication.memberId })
-      .execute()
      .then(() => {})
      .catch((err) => {
        throw new InternalException("Failed updating communication", err);
--- a/src/command/club/member/memberCommand.ts
+++ b/src/command/club/member/memberCommand.ts
@ -1,7 +1,5 @@
-import { Salutation } from "../../../enums/salutation";
-
 export interface CreateMemberCommand {
-  salutation: Salutation;
+  salutationId: number;
  firstname: string;
  lastname: string;
  nameaffix: string;
@ -11,7 +9,7 @@ export interface CreateMemberCommand {

 export interface UpdateMemberCommand {
  id: number;
-  salutation: Salutation;
+  salutationId: number;
  firstname: string;
  lastname: string;
  nameaffix: string;
@ -19,11 +17,6 @@ export interface UpdateMemberCommand {
  internalId?: string;
 }

-export interface UpdateMemberNewsletterCommand {
-  id: number;
-  communicationId: number;
-}
-
 export interface DeleteMemberCommand {
  id: number;
 }
--- a/src/command/club/member/memberCommandHandler.ts
+++ b/src/command/club/member/memberCommandHandler.ts
@ -2,12 +2,7 @@ import { dataSource } from "../../../data-source";
 import { communication } from "../../../entity/club/member/communication";
 import { member } from "../../../entity/club/member/member";
 import InternalException from "../../../exceptions/internalException";
-import {
-  CreateMemberCommand,
-  DeleteMemberCommand,
-  UpdateMemberCommand,
-  UpdateMemberNewsletterCommand,
-} from "./memberCommand";
+import { CreateMemberCommand, DeleteMemberCommand, UpdateMemberCommand } from "./memberCommand";

 export default abstract class MemberCommandHandler {
  /**
@ -21,7 +16,7 @@ export default abstract class MemberCommandHandler {
      .insert()
      .into(member)
      .values({
-        salutation: createMember.salutation,
+        salutationId: createMember.salutationId,
        firstname: createMember.firstname,
        lastname: createMember.lastname,
        nameaffix: createMember.nameaffix,
@ -33,7 +28,10 @@ export default abstract class MemberCommandHandler {
        return result.identifiers[0].id;
      })
      .catch((err) => {
-        throw new InternalException("Failed creating member", err);
+        throw new InternalException(
+          `Failed creating member${err.code.includes("ER_DUP_ENTRY") ? " due to duplicate entry for column" : ""}`,
+          err
+        );
      });
  }

@ -43,12 +41,11 @@ export default abstract class MemberCommandHandler {
   * @returns {Promise<void>}
   */
  static async update(updateMember: UpdateMemberCommand): Promise<void> {
-    console.log(updateMember);
    return await dataSource
      .createQueryBuilder()
      .update(member)
      .set({
-        salutation: updateMember.salutation,
+        salutationId: updateMember.salutationId,
        firstname: updateMember.firstname,
        lastname: updateMember.lastname,
        nameaffix: updateMember.nameaffix,
@ -59,52 +56,10 @@ export default abstract class MemberCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed updating member", err);
-      });
-  }
-
-  /**
-   * @description update member newsletter
-   * @param {UpdateMemberCommand} updateMember
-   * @returns {Promise<void>}
-   */
-  static async updateNewsletter(updateMember: UpdateMemberNewsletterCommand): Promise<void> {
-    return await dataSource
-      .createQueryBuilder()
-      .update(member)
-      .set({
-        sendNewsletter: await dataSource
-          .getRepository(communication)
-          .createQueryBuilder("communication")
-          .where("id = :id", { id: updateMember.communicationId })
-          .andWhere("memberId = :memberId", { memberId: updateMember.id })
-          .getOneOrFail(),
-      })
-      .where("id = :id", { id: updateMember.id })
-      .execute()
-      .then(() => {})
-      .catch((err) => {
-        throw new InternalException("Failed updating member", err);
-      });
-  }
-
-  /**
-   * @description update member newsletter to unset
-   * @param {number} memberId
-   * @returns {Promise<void>}
-   */
-  static async unsetNewsletter(memberId: number): Promise<void> {
-    return await dataSource
-      .createQueryBuilder()
-      .update(member)
-      .set({
-        sendNewsletter: null,
-      })
-      .where("id = :id", { id: memberId })
-      .execute()
-      .then(() => {})
-      .catch((err) => {
-        throw new InternalException("Failed updating member", err);
+        throw new InternalException(
+          `Failed updating member${err.code.includes("ER_DUP_ENTRY") ? " due to duplicate entry for column" : ""}`,
+          err
+        );
      });
  }

--- a/src/command/club/member/membershipCommandHandler.ts
+++ b/src/command/club/member/membershipCommandHandler.ts
@ -31,7 +31,7 @@ export default abstract class MembershipCommandHandler {
          .createQueryBuilder()
          .update(membership)
          .set({
-            end: new Date(createMembership.start).setDate(new Date(createMembership.start).getDate() - 1),
+            end: new Date(new Date(createMembership.start).setDate(new Date(createMembership.start).getDate() - 1)),
            terminationReason: "beendet durch neuen Eintrag.",
          })
          .where("end IS NULL")
--- a/src/command/club/protocol/protocolPresenceCommand.ts
+++ b/src/command/club/protocol/protocolPresenceCommand.ts
@ -6,4 +6,5 @@ export interface SynchronizeProtocolPresenceCommand {
 export interface ProtocolPresenceCommand {
  memberId: number;
  absent: boolean;
+  excused: boolean;
 }
--- a/src/command/club/protocol/protocolPresenceCommandHandler.ts
+++ b/src/command/club/protocol/protocolPresenceCommandHandler.ts
@ -74,6 +74,7 @@ export default abstract class ProtocolPresenceCommandHandler {
      .update(protocolPresence)
      .set({
        absent: member.absent,
+        excused: member.excused,
      })
      .where("memberId = :memberId", { memberId: member.memberId })
      .andWhere("protocolId = :protocolId", { protocolId })
--- a/src/command/refreshCommand.ts
+++ b/src/command/refreshCommand.ts
@ -1,5 +1,6 @@
 export interface CreateRefreshCommand {
  userId: number;
+  isFromPwa?: boolean;
 }

 export interface DeleteRefreshCommand {
--- a/src/command/refreshCommandHandler.ts
+++ b/src/command/refreshCommandHandler.ts
@ -1,11 +1,9 @@
 import { dataSource } from "../data-source";
 import { refresh } from "../entity/refresh";
-import { REFRESH_EXPIRATION } from "../env.defaults";
+import { PWA_REFRESH_EXPIRATION, REFRESH_EXPIRATION } from "../env.defaults";
 import InternalException from "../exceptions/internalException";
-import { JWTHelper } from "../helpers/jwtHelper";
 import { StringHelper } from "../helpers/stringHelper";
 import UserService from "../service/user/userService";
-import { JWTRefresh } from "../type/jwtTypes";
 import { CreateRefreshCommand, DeleteRefreshCommand } from "./refreshCommand";
 import ms from "ms";

@ -16,10 +14,6 @@ export default abstract class RefreshCommandHandler {
   * @returns {Promise<string>}
   */
  static async create(createRefresh: CreateRefreshCommand): Promise<string> {
-    // let createRefreshToken: JWTRefresh = {
-    //   userId: createRefresh.userId,
-    // };
-    // const refreshToken = await JWTHelper.create(createRefreshToken);
    const refreshToken = StringHelper.random(32);

    return await dataSource
@ -29,7 +23,9 @@ export default abstract class RefreshCommandHandler {
      .values({
        token: refreshToken,
        user: await UserService.getById(createRefresh.userId),
-        expiry: new Date(Date.now() + ms(REFRESH_EXPIRATION)),
+        expiry: createRefresh.isFromPwa
+          ? new Date(Date.now() + ms(PWA_REFRESH_EXPIRATION))
+          : new Date(Date.now() + ms(REFRESH_EXPIRATION)),
      })
      .execute()
      .then((result) => {
--- a/src/command/settings/award/awardCommandHandler.ts
+++ b/src/command/settings/award/awardCommandHandler.ts
@ -60,7 +60,10 @@ export default abstract class AwardCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting award", err);
+        throw new InternalException(
+          `Failed deleting award ${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/calendarType/calendarTypeCommandHandler.ts
+++ b/src/command/settings/calendarType/calendarTypeCommandHandler.ts
@ -66,7 +66,10 @@ export default abstract class CalendarTypeCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting calendarType", err);
+        throw new InternalException(
+          `Failed deleting calendarType${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/communicationType/communicationTypeCommandHandler.ts
+++ b/src/command/settings/communicationType/communicationTypeCommandHandler.ts
@ -66,7 +66,12 @@ export default abstract class CommunicationTypeCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting communicationType", err);
+        throw new InternalException(
+          `Failed deleting communicationType${
+            err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""
+          }`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/executivePosition/executivePositionCommandHandler.ts
+++ b/src/command/settings/executivePosition/executivePositionCommandHandler.ts
@ -64,7 +64,12 @@ export default abstract class ExecutivePositionCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting executivePosition", err);
+        throw new InternalException(
+          `Failed deleting executivePosition${
+            err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""
+          }`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/membershipStatus/membershipStatusCommandHandler.ts
+++ b/src/command/settings/membershipStatus/membershipStatusCommandHandler.ts
@ -64,7 +64,12 @@ export default abstract class MembershipStatusCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting membershipStatus", err);
+        throw new InternalException(
+          `Failed deleting membershipStatus${
+            err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""
+          }`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/newsletterConfig/newsletterConfigCommand.ts
+++ b/src/command/settings/newsletterConfig/newsletterConfigCommand.ts
@ -4,7 +4,3 @@ export interface SetNewsletterConfigCommand {
  comTypeId: number;
  config: NewsletterConfigType;
 }
-
-export interface DeleteNewsletterConfigCommand {
-  comTypeId: number;
-}
--- a/src/command/settings/newsletterConfig/newsletterConfigCommandHandler.ts
+++ b/src/command/settings/newsletterConfig/newsletterConfigCommandHandler.ts
@ -1,7 +1,7 @@
 import { dataSource } from "../../../data-source";
 import { newsletterConfig } from "../../../entity/settings/newsletterConfig";
 import InternalException from "../../../exceptions/internalException";
-import { DeleteNewsletterConfigCommand, SetNewsletterConfigCommand } from "./newsletterConfigCommand";
+import { SetNewsletterConfigCommand } from "./newsletterConfigCommand";

 export default abstract class NewsletterConfigCommandHandler {
  /**
@ -27,21 +27,4 @@ export default abstract class NewsletterConfigCommandHandler {
        throw new InternalException("Failed setting newsletterConfig", err);
      });
  }
-  /**
-   * @description delete newsletterConfig
-   * @param {DeleteNewsletterConfigCommand} deleteNewsletterConfig
-   * @returns {Promise<void>}
-   */
-  static async delete(deleteNewsletterConfig: DeleteNewsletterConfigCommand): Promise<void> {
-    return await dataSource
-      .createQueryBuilder()
-      .delete()
-      .from(newsletterConfig)
-      .where("comTypeId = :comTypeId", { comTypeId: deleteNewsletterConfig.comTypeId })
-      .execute()
-      .then(() => {})
-      .catch((err) => {
-        throw new InternalException("Failed setting newsletterConfig", err);
-      });
-  }
 }
--- a/src/command/settings/qualification/qualificationCommandHandler.ts
+++ b/src/command/settings/qualification/qualificationCommandHandler.ts
@ -66,7 +66,10 @@ export default abstract class QualificationCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting qualification", err);
+        throw new InternalException(
+          `Failed deleting qualification${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/queryStore/queryStoreCommandHandler.ts
+++ b/src/command/settings/queryStore/queryStoreCommandHandler.ts
@ -63,7 +63,10 @@ export default abstract class QueryStoreCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting queryStore", err);
+        throw new InternalException(
+          `Failed deleting queryStore${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
      });
  }
 }
--- a/src/command/settings/salutation/salutationCommand.ts
+++ b/src/command/settings/salutation/salutationCommand.ts
@ -0,0 +1,12 @@
+export interface CreateSalutationCommand {
+  salutation: string;
+}
+
+export interface UpdateSalutationCommand {
+  id: number;
+  salutation: string;
+}
+
+export interface DeleteSalutationCommand {
+  id: number;
+}
--- a/src/command/settings/salutation/salutationCommandHandler.ts
+++ b/src/command/settings/salutation/salutationCommandHandler.ts
@ -0,0 +1,69 @@
+import { dataSource } from "../../../data-source";
+import { salutation } from "../../../entity/settings/salutation";
+import InternalException from "../../../exceptions/internalException";
+import { CreateSalutationCommand, DeleteSalutationCommand, UpdateSalutationCommand } from "./salutationCommand";
+
+export default abstract class SalutationCommandHandler {
+  /**
+   * @description create salutation
+   * @param {CreateSalutationCommand} createSalutation
+   * @returns {Promise<number>}
+   */
+  static async create(createSalutation: CreateSalutationCommand): Promise<number> {
+    return await dataSource
+      .createQueryBuilder()
+      .insert()
+      .into(salutation)
+      .values({
+        salutation: createSalutation.salutation,
+      })
+      .execute()
+      .then((result) => {
+        return result.identifiers[0].id;
+      })
+      .catch((err) => {
+        throw new InternalException("Failed creating salutation", err);
+      });
+  }
+
+  /**
+   * @description update salutation
+   * @param {UpdateSalutationCommand} updateSalutation
+   * @returns {Promise<void>}
+   */
+  static async update(updateSalutation: UpdateSalutationCommand): Promise<void> {
+    return await dataSource
+      .createQueryBuilder()
+      .update(salutation)
+      .set({
+        salutation: updateSalutation.salutation,
+      })
+      .where("id = :id", { id: updateSalutation.id })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException("Failed updating salutation", err);
+      });
+  }
+
+  /**
+   * @description delete salutation
+   * @param {DeleteSalutationCommand} deleteSalutation
+   * @returns {Promise<void>}
+   */
+  static async delete(deleteSalutation: DeleteSalutationCommand): Promise<void> {
+    return await dataSource
+      .createQueryBuilder()
+      .delete()
+      .from(salutation)
+      .where("id = :id", { id: deleteSalutation.id })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException(
+          `Failed deleting salutation ${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
+      });
+  }
+}
--- a/src/command/settings/template/templateCommandHandler.ts
+++ b/src/command/settings/template/templateCommandHandler.ts
@ -64,7 +64,10 @@ export default abstract class TemplateCommandHandler {
      .execute()
      .then(() => {})
      .catch((err) => {
-        throw new InternalException("Failed deleting template", err);
+        throw new InternalException(
+          `Failed deleting template${err.code.includes("ER_ROW_IS_REFERENCED") ? " due to referenced data" : ""}`,
+          err
+        );
      });
  }
 }
--- a/src/command/user/webapi/webapiCommand.ts
+++ b/src/command/user/webapi/webapiCommand.ts
@ -0,0 +1,19 @@
+export interface CreateWebapiCommand {
+  title: string;
+  token: string;
+  expiry?: Date;
+}
+
+export interface UpdateWebapiCommand {
+  id: number;
+  title: string;
+  expiry?: Date;
+}
+
+export interface UpdateLastUsageWebapiCommand {
+  id: number;
+}
+
+export interface DeleteWebapiCommand {
+  id: number;
+}
--- a/src/command/user/webapi/webapiCommandHandler.ts
+++ b/src/command/user/webapi/webapiCommandHandler.ts
@ -0,0 +1,100 @@
+import { dataSource } from "../../../data-source";
+import { webapi } from "../../../entity/user/webapi";
+import InternalException from "../../../exceptions/internalException";
+import {
+  CreateWebapiCommand,
+  DeleteWebapiCommand,
+  UpdateLastUsageWebapiCommand,
+  UpdateWebapiCommand,
+} from "./webapiCommand";
+
+export default abstract class WebapiCommandHandler {
+  /**
+   * @description create api
+   * @param {CreateWebapiCommand} createWebapi
+   * @returns {Promise<number>}
+   */
+  static async create(createWebapi: CreateWebapiCommand): Promise<number> {
+    return await dataSource
+      .createQueryBuilder()
+      .insert()
+      .into(webapi)
+      .values({
+        token: createWebapi.token,
+        title: createWebapi.title,
+        expiry: createWebapi.expiry,
+      })
+      .execute()
+      .then((result) => {
+        return result.identifiers[0].token;
+      })
+      .catch((err) => {
+        throw new InternalException(
+          `Failed creating api${err.code.includes("ER_DUP_ENTRY") ? " due to duplicate entry for column" : ""}`,
+          err
+        );
+      });
+  }
+
+  /**
+   * @description update api
+   * @param {UpdateWebapiCommand} updateWebapi
+   * @returns {Promise<void>}
+   */
+  static async update(updateWebapi: UpdateWebapiCommand): Promise<void> {
+    return await dataSource
+      .createQueryBuilder()
+      .update(webapi)
+      .set({
+        title: updateWebapi.title,
+        expiry: updateWebapi.expiry,
+      })
+      .where("id = :id", { id: updateWebapi.id })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException(
+          `Failed updating api${err.code.includes("ER_DUP_ENTRY") ? " due to duplicate entry for column" : ""}`,
+          err
+        );
+      });
+  }
+
+  /**
+   * @description update api usage
+   * @param {UpdateLastUsageWebapiCommand} updateWebapi
+   * @returns {Promise<void>}
+   */
+  static async updateUsage(updateWebapi: UpdateLastUsageWebapiCommand): Promise<void> {
+    return await dataSource
+      .createQueryBuilder()
+      .update(webapi)
+      .set({
+        lastUsage: new Date(),
+      })
+      .where("id = :id", { id: updateWebapi.id })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException(`Failed updating api last usage`, err);
+      });
+  }
+
+  /**
+   * @description delete api
+   * @param {DeleteWebapiCommand} deleteWebapi
+   * @returns {Promise<void>}
+   */
+  static async delete(deleteWebapi: DeleteWebapiCommand): Promise<void> {
+    return await dataSource
+      .createQueryBuilder()
+      .delete()
+      .from(webapi)
+      .where("id = :id", { id: deleteWebapi.id })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException("Failed deleting api", err);
+      });
+  }
+}
--- a/src/command/user/webapi/webapiPermissionCommand.ts
+++ b/src/command/user/webapi/webapiPermissionCommand.ts
@ -0,0 +1,16 @@
+import { PermissionString } from "../../../type/permissionTypes";
+
+export interface CreateWebapiPermissionCommand {
+  permission: PermissionString;
+  webapiId: number;
+}
+
+export interface DeleteWebapiPermissionCommand {
+  permission: PermissionString;
+  webapiId: number;
+}
+
+export interface UpdateWebapiPermissionsCommand {
+  webapiId: number;
+  permissions: Array<PermissionString>;
+}
--- a/src/command/user/webapi/webapiPermissionCommandHandler.ts
+++ b/src/command/user/webapi/webapiPermissionCommandHandler.ts
@ -0,0 +1,119 @@
+import { DeleteResult, EntityManager, InsertResult } from "typeorm";
+import { dataSource } from "../../../data-source";
+import { webapiPermission } from "../../../entity/user/webapi_permission";
+import InternalException from "../../../exceptions/internalException";
+import WebapiService from "../../../service/user/webapiService";
+import {
+  CreateWebapiPermissionCommand,
+  DeleteWebapiPermissionCommand,
+  UpdateWebapiPermissionsCommand,
+} from "./webapiPermissionCommand";
+import PermissionHelper from "../../../helpers/permissionHelper";
+import WebapiPermissionService from "../../../service/user/webapiPermissionService";
+import { PermissionString } from "../../../type/permissionTypes";
+
+export default abstract class WebapiPermissionCommandHandler {
+  /**
+   * @description update api permissions
+   * @param {UpdateWebapiPermissionsCommand} updateWebapiPermissions
+   * @returns {Promise<void>}
+   */
+  static async updatePermissions(updateWebapiPermissions: UpdateWebapiPermissionsCommand): Promise<void> {
+    let currentPermissions = (await WebapiPermissionService.getByApi(updateWebapiPermissions.webapiId)).map(
+      (r) => r.permission
+    );
+    return await dataSource.manager
+      .transaction(async (manager) => {
+        let newPermissions = PermissionHelper.getWhatToAdd(currentPermissions, updateWebapiPermissions.permissions);
+        let removePermissions = PermissionHelper.getWhatToRemove(
+          currentPermissions,
+          updateWebapiPermissions.permissions
+        );
+        if (newPermissions.length != 0) {
+          await this.updatePermissionsAdd(manager, updateWebapiPermissions.webapiId, newPermissions);
+        }
+        if (removePermissions.length != 0) {
+          await this.updatePermissionsRemove(manager, updateWebapiPermissions.webapiId, removePermissions);
+        }
+      })
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException("Failed saving api permissions", err);
+      });
+  }
+
+  private static async updatePermissionsAdd(
+    manager: EntityManager,
+    webapiId: number,
+    permissions: Array<PermissionString>
+  ): Promise<InsertResult> {
+    return await manager
+      .createQueryBuilder()
+      .insert()
+      .into(webapiPermission)
+      .values(
+        permissions.map((p) => ({
+          permission: p,
+          webapiId: webapiId,
+        }))
+      )
+      .orIgnore()
+      .execute();
+  }
+
+  private static async updatePermissionsRemove(
+    manager: EntityManager,
+    webapiId: number,
+    permissions: Array<PermissionString>
+  ): Promise<DeleteResult> {
+    return await manager
+      .createQueryBuilder()
+      .delete()
+      .from(webapiPermission)
+      .where("webapiId = :id", { id: webapiId })
+      .andWhere("permission IN (:...permission)", { permission: permissions })
+      .execute();
+  }
+
+  /**
+   * @description grant permission to user
+   * @param {CreateWebapiPermissionCommand} createPermission
+   * @returns {Promise<number>}
+   */
+  static async create(createPermission: CreateWebapiPermissionCommand): Promise<number> {
+    return await dataSource
+      .createQueryBuilder()
+      .insert()
+      .into(webapiPermission)
+      .values({
+        permission: createPermission.permission,
+        webapiId: createPermission.webapiId,
+      })
+      .execute()
+      .then((result) => {
+        return result.identifiers[0].id;
+      })
+      .catch((err) => {
+        throw new InternalException("Failed saving api permission", err);
+      });
+  }
+
+  /**
+   * @description remove permission from api
+   * @param {DeleteWebapiPermissionCommand} deletePermission
+   * @returns {Promise<any>}
+   */
+  static async delete(deletePermission: DeleteWebapiPermissionCommand): Promise<any> {
+    return await dataSource
+      .createQueryBuilder()
+      .delete()
+      .from(webapiPermission)
+      .where("webapiId = :id", { id: deletePermission.webapiId })
+      .andWhere("permission = :permission", { permission: deletePermission.permission })
+      .execute()
+      .then(() => {})
+      .catch((err) => {
+        throw new InternalException("failed api permission removal", err);
+      });
+  }
+}
--- a/src/controller/admin/club/memberController.ts
+++ b/src/controller/admin/club/memberController.ts
@ -15,7 +15,6 @@ import {
  CreateMemberCommand,
  DeleteMemberCommand,
  UpdateMemberCommand,
-  UpdateMemberNewsletterCommand,
 } from "../../../command/club/member/memberCommand";
 import MemberCommandHandler from "../../../command/club/member/memberCommandHandler";
 import {
@ -48,8 +47,8 @@ import {
  UpdateCommunicationCommand,
 } from "../../../command/club/member/communicationCommand";
 import CommunicationCommandHandler from "../../../command/club/member/communicationCommandHandler";
-import {PdfExport} from "../../../helpers/pdfExport";
-import {PermissionModule} from "../../../type/permissionTypes";
+import { PdfExport } from "../../../helpers/pdfExport";
+import { PermissionModule } from "../../../type/permissionTypes";

 /**
 * @description get all members
@ -61,8 +60,13 @@ export async function getAllMembers(req: Request, res: Response): Promise<any> {
  let offset = parseInt((req.query.offset as string) ?? "0");
  let count = parseInt((req.query.count as string) ?? "25");
  let search = (req.query.search as string) ?? "";
+  let noLimit = req.query.noLimit === "true";
+  let ids = ((req.query.ids ?? "") as string)
+    .split(",")
+    .filter((i) => i)
+    .map((i) => parseInt(i));

-  let [members, total] = await MemberService.getAll(offset, count, search);
+  let [members, total] = await MemberService.getAll({ offset, count, search, noLimit, ids });

  res.json({
    members: MemberFactory.mapToBase(members),
@ -85,6 +89,19 @@ export async function getMemberById(req: Request, res: Response): Promise<any> {
  res.json(MemberFactory.mapToSingle(member));
 }

+/**
+ * @description get member statistics by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getMemberStatisticsById(req: Request, res: Response): Promise<any> {
+  const memberId = parseInt(req.params.id);
+  let member = await MemberService.getStatisticsById(memberId);
+
+  res.json(MemberFactory.mapToMemberStatistic(member));
+}
+
 /**
 * @description get memberships by member
 * @param req {Request} Express req object
@ -98,6 +115,19 @@ export async function getMembershipsByMember(req: Request, res: Response): Promi
  res.json(MembershipFactory.mapToBase(memberships));
 }

+/**
+ * @description get member statistics by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getMembershipStatisticsById(req: Request, res: Response): Promise<any> {
+  const memberId = parseInt(req.params.memberId);
+  let member = await MembershipService.getStatisticsById(memberId);
+
+  res.json(MembershipFactory.mapToBaseStatistics(member));
+}
+
 /**
 * @description get membership by member and record
 * @param req {Request} Express req object
@ -227,14 +257,14 @@ export async function getCommunicationByMemberAndRecord(req: Request, res: Respo
 * @returns {Promise<*>}
 */
 export async function createMemberPrintoutList(req: Request, res: Response): Promise<any> {
-  let members = await MemberService.getByRunningMembership()
+  let members = await MemberService.getByRunningMembership();

  let pdf = await PdfExport.renderFile({
    title: "Mitgliederliste",
    template: "member.list",
    saveToDisk: false,
    data: {
-      member: members
+      member: members,
    },
  });

@ -254,7 +284,7 @@ export async function createMemberPrintoutList(req: Request, res: Response): Pro
 * @returns {Promise<*>}
 */
 export async function createMember(req: Request, res: Response): Promise<any> {
-  const salutation = req.body.salutation;
+  const salutationId = parseInt(req.body.salutationId);
  const firstname = req.body.firstname;
  const lastname = req.body.lastname;
  const nameaffix = req.body.nameaffix;
@ -262,7 +292,7 @@ export async function createMember(req: Request, res: Response): Promise<any> {
  const internalId = req.body.internalId;

  let createMember: CreateMemberCommand = {
-    salutation,
+    salutationId,
    firstname,
    lastname,
    nameaffix,
@ -378,6 +408,7 @@ export async function addCommunicationToMember(req: Request, res: Response): Pro
  const memberId = parseInt(req.params.memberId);
  const preferred = req.body.preferred;
  const isSMSAlarming = req.body.isSMSAlarming;
+  const isSendNewsletter = req.body.isNewsletterMain;
  const mobile = req.body.mobile;
  const email = req.body.email;
  const postalCode = req.body.postalCode;
@ -386,11 +417,11 @@ export async function addCommunicationToMember(req: Request, res: Response): Pro
  const streetNumber = req.body.streetNumber;
  const streetNumberAddition = req.body.streetNumberAddition;
  const typeId = req.body.typeId;
-  const isNewsletterMain = req.body.isNewsletterMain;

  let createCommunication: CreateCommunicationCommand = {
    preferred,
    isSMSAlarming,
+    isSendNewsletter,
    mobile,
    email,
    postalCode,
@ -403,14 +434,6 @@ export async function addCommunicationToMember(req: Request, res: Response): Pro
  };
  let id = await CommunicationCommandHandler.create(createCommunication);

-  if (isNewsletterMain) {
-    let updateNewsletter: UpdateMemberNewsletterCommand = {
-      id: memberId,
-      communicationId: id,
-    };
-    await MemberCommandHandler.updateNewsletter(updateNewsletter);
-  }
-
  res.sendStatus(204);
 }

@ -422,7 +445,7 @@ export async function addCommunicationToMember(req: Request, res: Response): Pro
 */
 export async function updateMemberById(req: Request, res: Response): Promise<any> {
  const memberId = parseInt(req.params.id);
-  const salutation = req.body.salutation;
+  const salutationId = parseInt(req.body.salutationId);
  const firstname = req.body.firstname;
  const lastname = req.body.lastname;
  const nameaffix = req.body.nameaffix;
@ -431,7 +454,7 @@ export async function updateMemberById(req: Request, res: Response): Promise<any

  let updateMember: UpdateMemberCommand = {
    id: memberId,
-    salutation,
+    salutationId,
    firstname,
    lastname,
    nameaffix,
@ -564,6 +587,7 @@ export async function updateCommunicationOfMember(req: Request, res: Response):
  const recordId = parseInt(req.params.recordId);
  const preferred = req.body.preferred;
  const isSMSAlarming = req.body.isSMSAlarming;
+  const isSendNewsletter = req.body.isNewsletterMain;
  const mobile = req.body.mobile;
  const email = req.body.email;
  const postalCode = req.body.postalCode;
@ -571,12 +595,12 @@ export async function updateCommunicationOfMember(req: Request, res: Response):
  const street = req.body.street;
  const streetNumber = req.body.streetNumber;
  const streetNumberAddition = req.body.streetNumberAddition;
-  const isNewsletterMain = req.body.isNewsletterMain;

  let updateCommunication: UpdateCommunicationCommand = {
    id: recordId,
    preferred,
    isSMSAlarming,
+    isSendNewsletter,
    mobile,
    email,
    postalCode,
@ -588,18 +612,6 @@ export async function updateCommunicationOfMember(req: Request, res: Response):
  };
  await CommunicationCommandHandler.update(updateCommunication);

-  let currentUserNewsletterMain = await MemberService.getNewsletterById(memberId);
-
-  if (isNewsletterMain) {
-    let updateNewsletter: UpdateMemberNewsletterCommand = {
-      id: memberId,
-      communicationId: recordId,
-    };
-    await MemberCommandHandler.updateNewsletter(updateNewsletter);
-  } else if (currentUserNewsletterMain.sendNewsletter.id == recordId) {
-    await MemberCommandHandler.unsetNewsletter(memberId);
-  }
-
  res.sendStatus(204);
 }

--- a/src/controller/admin/club/newsletterController.ts
+++ b/src/controller/admin/club/newsletterController.ts
@ -6,7 +6,10 @@ import NewsletterDatesFactory from "../../../factory/admin/club/newsletter/newsl
 import NewsletterRecipientsService from "../../../service/club/newsletter/newsletterRecipientsService";
 import NewsletterRecipientsFactory from "../../../factory/admin/club/newsletter/newsletterRecipients";
 import { FileSystemHelper } from "../../../helpers/fileSystemHelper";
-import { CreateNewsletterCommand, SynchronizeNewsletterCommand } from "../../../command/club/newsletter/newsletterCommand";
+import {
+  CreateNewsletterCommand,
+  SynchronizeNewsletterCommand,
+} from "../../../command/club/newsletter/newsletterCommand";
 import NewsletterCommandHandler from "../../../command/club/newsletter/newsletterCommandHandler";
 import { SynchronizeNewsletterDatesCommand } from "../../../command/club/newsletter/newsletterDatesCommand";
 import NewsletterDatesCommandHandler from "../../../command/club/newsletter/newsletterDatesCommandHandler";
@ -18,7 +21,6 @@ import UserService from "../../../service/user/userService";
 import { TemplateHelper } from "../../../helpers/templateHelper";
 import MailHelper from "../../../helpers/mailHelper";
 import { NewsletterEventType, NewsletterHelper } from "../../../helpers/newsletterHelper";
-import { Salutation } from "../../../enums/salutation";

 /**
 * @description get all newsletters
@ -139,7 +141,7 @@ export async function createNewsletterPrintoutPreviewById(req: Request, res: Res
  data.recipient = {
    firstname: recipient.firstname,
    lastname: recipient.lastname,
-    salutation: Salutation.none,
+    salutation: "Anrede",
    nameaffix: "",
    street: "Straße",
    streetNumber: "Hausnummer",
@ -188,15 +190,14 @@ export async function createNewsletter(req: Request, res: Response): Promise<any
 export async function getNewsletterPrintoutProgressById(req: Request, res: Response): Promise<any> {
  let newsletterId = parseInt(req.params.newsletterId);

-  res.setHeader("Content-Type", "text/event-stream");
-  res.setHeader("Cache-Control", "no-cache");
-  res.setHeader("Connection", "keep-alive");
-
-  res.flushHeaders();
+  res.writeHead(200, {
+    "Content-Type": "text/plain",
+    "Transfer-Encoding": "chunked",
+  });

  const progressHandler = (data: NewsletterEventType) => {
    if (data.newsletterId == newsletterId && data.kind == "pdf") {
-      res.write(JSON.stringify(data));
+      res.write(JSON.stringify(data) + "//");
    }
  };

@ -246,7 +247,7 @@ export async function createNewsletterMailPreviewById(req: Request, res: Respons
  data.recipient = {
    firstname: recipient.firstname,
    lastname: recipient.lastname,
-    salutation: Salutation.none,
+    salutation: "Anrede",
    nameaffix: "",
    street: "Straße",
    streetNumber: "Hausnummer",
@ -287,15 +288,14 @@ export async function sendNewsletterById(req: Request, res: Response): Promise<a
 export async function getNewsletterSendingProgressById(req: Request, res: Response): Promise<any> {
  let newsletterId = parseInt(req.params.newsletterId);

-  res.setHeader("Content-Type", "text/event-stream");
-  res.setHeader("Cache-Control", "no-cache");
-  res.setHeader("Connection", "keep-alive");
-
-  res.flushHeaders();
+  res.writeHead(200, {
+    "Content-Type": "text/plain",
+    "Transfer-Encoding": "chunked",
+  });

  const progressHandler = (data: NewsletterEventType) => {
    if (data.newsletterId == newsletterId && data.kind == "mail") {
-      res.write(JSON.stringify(data));
+      res.write(JSON.stringify(data) + "//");
    }
  };

--- a/src/controller/admin/club/protocolController.ts
+++ b/src/controller/admin/club/protocolController.ts
@ -260,7 +260,9 @@ export async function createProtocolPrintoutById(req: Request, res: Response): P
      agenda,
      decisions,
      presence: presence.filter((p) => !p.absent).map((p) => p.member),
-      absent: presence.filter((p) => p.absent).map((p) => p.member),
+      absent: presence.filter((p) => p.absent).map((p) => ({ ...p.member, excused: p.excused })),
+      excused_absent: presence.filter((p) => p.absent && p.excused).map((p) => p.member),
+      unexcused_absent: presence.filter((p) => p.absent && !p.excused).map((p) => p.member),
      votings,
    },
  });
@ -389,6 +391,7 @@ export async function synchronizeProtocolPrecenseById(req: Request, res: Respons
    members: presence.map((p) => ({
      memberId: p.memberId,
      absent: p.absent,
+      excused: p.excused,
    })),
    protocolId,
  };
--- a/src/controller/admin/settings/newsletterConfigController.ts
+++ b/src/controller/admin/settings/newsletterConfigController.ts
@ -2,7 +2,7 @@ import { Request, Response } from "express";
 import NewsletterConfigService from "../../../service/settings/newsletterConfigService";
 import NewsletterConfigFactory from "../../../factory/admin/settings/newsletterConfig";
 import NewsletterConfigCommandHandler from "../../../command/settings/newsletterConfig/newsletterConfigCommandHandler";
-import { DeleteNewsletterConfigCommand, SetNewsletterConfigCommand } from "../../../command/settings/newsletterConfig/newsletterConfigCommand";
+import { SetNewsletterConfigCommand } from "../../../command/settings/newsletterConfig/newsletterConfigCommand";

 /**
 * @description get all newsletterConfigs
@ -47,20 +47,3 @@ export async function setNewsletterConfig(req: Request, res: Response): Promise<

  res.send(id);
 }
-
-/**
- * @description delete award
- * @param req {Request} Express req object
- * @param res {Response} Express res object
- * @returns {Promise<*>}
- */
-export async function deleteNewsletterConfig(req: Request, res: Response): Promise<any> {
-  const comTypeId = parseInt(req.params.comTypeId);
-
-  let deleteNewsletterConfig: DeleteNewsletterConfigCommand = {
-    comTypeId: comTypeId,
-  };
-  await NewsletterConfigCommandHandler.delete(deleteNewsletterConfig);
-
-  res.sendStatus(204);
-}
--- a/src/controller/admin/settings/salutationController.ts
+++ b/src/controller/admin/settings/salutationController.ts
@ -0,0 +1,87 @@
+import { Request, Response } from "express";
+import SalutationService from "../../../service/settings/salutationService";
+import SalutationFactory from "../../../factory/admin/settings/salutation";
+import {
+  CreateSalutationCommand,
+  DeleteSalutationCommand,
+  UpdateSalutationCommand,
+} from "../../../command/settings/salutation/salutationCommand";
+import SalutationCommandHandler from "../../../command/settings/salutation/salutationCommandHandler";
+
+/**
+ * @description get all salutations
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getAllSalutations(req: Request, res: Response): Promise<any> {
+  let salutations = await SalutationService.getAll();
+
+  res.json(SalutationFactory.mapToBase(salutations));
+}
+
+/**
+ * @description get salutation by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getSalutationById(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let salutation = await SalutationService.getById(id);
+
+  res.json(SalutationFactory.mapToSingle(salutation));
+}
+
+/**
+ * @description create new salutation
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function createSalutation(req: Request, res: Response): Promise<any> {
+  const salutation = req.body.salutation;
+
+  let createSalutation: CreateSalutationCommand = {
+    salutation: salutation,
+  };
+  await SalutationCommandHandler.create(createSalutation);
+
+  res.sendStatus(204);
+}
+
+/**
+ * @description update salutation
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function updateSalutation(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  const salutation = req.body.salutation;
+
+  let updateSalutation: UpdateSalutationCommand = {
+    id: id,
+    salutation: salutation,
+  };
+  await SalutationCommandHandler.update(updateSalutation);
+
+  res.sendStatus(204);
+}
+
+/**
+ * @description delete salutation
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function deleteSalutation(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+
+  let deleteSalutation: DeleteSalutationCommand = {
+    id: id,
+  };
+  await SalutationCommandHandler.delete(deleteSalutation);
+
+  res.sendStatus(204);
+}
--- a/src/controller/admin/user/userController.ts
+++ b/src/controller/admin/user/userController.ts
@ -10,6 +10,7 @@ import MailHelper from "../../../helpers/mailHelper";
 import { CLUB_NAME } from "../../../env.defaults";
 import { UpdateUserPermissionsCommand } from "../../../command/user/user/userPermissionCommand";
 import UserPermissionCommandHandler from "../../../command/user/user/userPermissionCommandHandler";
+import BadRequestException from "../../../exceptions/badRequestException";

 /**
 * @description get All users
@ -137,7 +138,11 @@ export async function updateUserRoles(req: Request, res: Response): Promise<any>
 export async function deleteUser(req: Request, res: Response): Promise<any> {
  const id = parseInt(req.params.id);

-  let user = await UserService.getById(id);
+  let { mail, isOwner } = await UserService.getById(id);
+
+  if (isOwner) {
+    throw new BadRequestException("Owner cannot be deleted");
+  }

  let deleteUser: DeleteUserCommand = {
    id: id,
@ -147,7 +152,7 @@ export async function deleteUser(req: Request, res: Response): Promise<any> {
  try {
    // sendmail
    await MailHelper.sendMail(
-      user.mail,
+      mail,
      `Email Bestätigung für Mitglieder Admin-Portal von ${CLUB_NAME}`,
      `Ihr Nutzerkonto des Adminportals wurde erfolgreich gelöscht.`
    );
--- a/src/controller/admin/user/webapiController.ts
+++ b/src/controller/admin/user/webapiController.ts
@ -0,0 +1,155 @@
+import { Request, Response } from "express";
+import WebapiService from "../../../service/user/webapiService";
+import ApiFactory from "../../../factory/admin/user/webapi";
+import WebapiPermissionService from "../../../service/user/webapiPermissionService";
+import PermissionHelper from "../../../helpers/permissionHelper";
+import {
+  CreateWebapiCommand,
+  DeleteWebapiCommand,
+  UpdateWebapiCommand,
+} from "../../../command/user/webapi/webapiCommand";
+import WebapiCommandHandler from "../../../command/user/webapi/webapiCommandHandler";
+import { UpdateWebapiPermissionsCommand } from "../../../command/user/webapi/webapiPermissionCommand";
+import WebapiPermissionCommandHandler from "../../../command/user/webapi/webapiPermissionCommandHandler";
+import { JWTHelper } from "../../../helpers/jwtHelper";
+import { CLUB_NAME } from "../../../env.defaults";
+import { StringHelper } from "../../../helpers/stringHelper";
+
+/**
+ * @description get All apis
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getAllWebapis(req: Request, res: Response): Promise<any> {
+  let apis = await WebapiService.getAll();
+
+  res.json(ApiFactory.mapToBase(apis));
+}
+
+/**
+ * @description get api by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getWebapiById(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let api = await WebapiService.getById(id);
+
+  res.json(ApiFactory.mapToSingle(api));
+}
+
+/**
+ * @description get api token by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getWebapiTokenById(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let { token } = await WebapiService.getTokenById(id);
+
+  res.send(token);
+}
+
+/**
+ * @description get permissions by api
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getWebapiPermissions(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let permissions = await WebapiPermissionService.getByApi(id);
+
+  res.json(PermissionHelper.convertToObject(permissions.map((p) => p.permission)));
+}
+
+/**
+ * @description create new api
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function createWebapi(req: Request, res: Response): Promise<any> {
+  let title = req.body.title;
+  let expiry = req.body.expiry || null;
+
+  let token = await JWTHelper.create(
+    {
+      iss: CLUB_NAME,
+      sub: "api_token_retrieve",
+      aud: StringHelper.random(32),
+    },
+    { useExpiration: false }
+  );
+
+  let createApi: CreateWebapiCommand = {
+    token: token,
+    title: title,
+    expiry: expiry,
+  };
+  await WebapiCommandHandler.create(createApi);
+
+  res.sendStatus(204);
+}
+
+/**
+ * @description update api data
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function updateWebapi(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let title = req.body.title;
+  let expiry = req.body.expiry || null;
+
+  let updateApi: UpdateWebapiCommand = {
+    id: id,
+    title: title,
+    expiry: expiry,
+  };
+  await WebapiCommandHandler.update(updateApi);
+
+  res.sendStatus(204);
+}
+
+/**
+ * @description update api assigned permission strings
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function updateWebapiPermissions(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+  let permissions = req.body.permissions;
+
+  let permissionStrings = PermissionHelper.convertToStringArray(permissions);
+
+  let updateApiPermissions: UpdateWebapiPermissionsCommand = {
+    webapiId: id,
+    permissions: permissionStrings,
+  };
+  await WebapiPermissionCommandHandler.updatePermissions(updateApiPermissions);
+
+  res.sendStatus(204);
+}
+
+/**
+ * @description delete api by id
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function deleteWebapi(req: Request, res: Response): Promise<any> {
+  const id = parseInt(req.params.id);
+
+  let deleteApi: DeleteWebapiCommand = {
+    id: id,
+  };
+  await WebapiCommandHandler.delete(deleteApi);
+
+  res.sendStatus(204);
+}
--- a/src/controller/authController.ts
+++ b/src/controller/authController.ts
@ -8,9 +8,6 @@ import UserService from "../service/user/userService";
 import speakeasy from "speakeasy";
 import UnauthorizedRequestException from "../exceptions/unauthorizedRequestException";
 import RefreshService from "../service/refreshService";
-import UserPermissionService from "../service/user/userPermissionService";
-import PermissionHelper from "../helpers/permissionHelper";
-import RolePermissionService from "../service/user/rolePermissionService";

 /**
 * @description Check authentication status by token
@ -39,6 +36,7 @@ export async function login(req: Request, res: Response): Promise<any> {

  let refreshCommand: CreateRefreshCommand = {
    userId: id,
+    isFromPwa: req.isPWA,
  };
  let refreshToken = await RefreshCommandHandler.create(refreshCommand);

@ -83,6 +81,7 @@ export async function refresh(req: Request, res: Response): Promise<any> {

  let refreshCommand: CreateRefreshCommand = {
    userId: tokenUserId,
+    isFromPwa: req.isPWA,
  };
  let refreshToken = await RefreshCommandHandler.create(refreshCommand);

--- a/src/controller/webapiController.ts
+++ b/src/controller/webapiController.ts
@ -0,0 +1,37 @@
+import { Request, Response } from "express";
+import { JWTHelper } from "../helpers/jwtHelper";
+import { JWTToken } from "../type/jwtTypes";
+import InternalException from "../exceptions/internalException";
+import RefreshCommandHandler from "../command/refreshCommandHandler";
+import { CreateRefreshCommand, DeleteRefreshCommand } from "../command/refreshCommand";
+import UserService from "../service/user/userService";
+import speakeasy from "speakeasy";
+import UnauthorizedRequestException from "../exceptions/unauthorizedRequestException";
+import RefreshService from "../service/refreshService";
+import WebapiService from "../service/user/webapiService";
+import ForbiddenRequestException from "../exceptions/forbiddenRequestException";
+import WebapiCommandHandler from "../command/user/webapi/webapiCommandHandler";
+
+/**
+ * @description Check authentication status by token
+ * @param req {Request} Express req object
+ * @param res {Response} Express res object
+ * @returns {Promise<*>}
+ */
+export async function getWebApiAccess(req: Request, res: Response): Promise<any> {
+  const bearer = req.headers.authorization?.split(" ")?.[1] ?? undefined;
+
+  let { id, expiry } = await WebapiService.getByToken(bearer);
+
+  if (expiry != null && new Date() > new Date(expiry)) {
+    throw new ForbiddenRequestException("api token expired");
+  }
+
+  await WebapiCommandHandler.updateUsage({ id });
+
+  let accessToken = await JWTHelper.buildWebapiToken(bearer, expiry);
+
+  res.json({
+    accessToken,
+  });
+}
--- a/src/data-source.ts
+++ b/src/data-source.ts
@ -66,6 +66,15 @@ import { PostalCode1735927918979 } from "./migrations/1735927918979-postalCode";
 import { ProtocolAbsent1736072179716 } from "./migrations/1736072179716-protocolAbsent";
 import { Memberlist1736079005086 } from "./migrations/1736079005086-memberlist";
 import { ExtendViewValues1736084198860 } from "./migrations/1736084198860-extendViewValues";
+import { FinishInternalIdTransfer1736505324488 } from "./migrations/1736505324488-finishInternalIdTransfer";
+import { ProtocolPresenceExcuse1737287798828 } from "./migrations/1737287798828-protocolPresenceExcuse";
+import { webapi } from "./entity/user/webapi";
+import { webapiPermission } from "./entity/user/webapi_permission";
+import { AddWebapiTokens1737453096674 } from "./migrations/1737453096674-addwebapiTokens";
+import { salutation } from "./entity/settings/salutation";
+import { SalutationAsTable1737796878058 } from "./migrations/1737796878058-salutationAsTable";
+import { UpdateViews1737800468938 } from "./migrations/1737800468938-updateViews";
+import { MoveSendNewsletterFlag1737816852011 } from "./migrations/1737816852011-moveSendNewsletterFlag";

 const dataSource = new DataSource({
  type: DB_TYPE as any,
@ -91,6 +100,7 @@ const dataSource = new DataSource({
    executivePosition,
    membershipStatus,
    qualification,
+    salutation,
    member,
    memberAwards,
    memberExecutivePositions,
@ -115,6 +125,8 @@ const dataSource = new DataSource({
    memberExecutivePositionsView,
    memberQualificationsView,
    membershipView,
+    webapi,
+    webapiPermission,
  ],
  migrations: [
    Initial1724317398939,
@ -142,6 +154,12 @@ const dataSource = new DataSource({
    ProtocolAbsent1736072179716,
    Memberlist1736079005086,
    ExtendViewValues1736084198860,
+    FinishInternalIdTransfer1736505324488,
+    ProtocolPresenceExcuse1737287798828,
+    AddWebapiTokens1737453096674,
+    SalutationAsTable1737796878058,
+    UpdateViews1737800468938,
+    MoveSendNewsletterFlag1737816852011,
  ],
  migrationsRun: true,
  migrationsTransactionMode: "each",
--- a/src/demodata/newsletter.data.ts
+++ b/src/demodata/newsletter.data.ts
@ -1,6 +1,5 @@
 import { calendar } from "../entity/club/calendar";
 import { member } from "../entity/club/member/member";
-import { Salutation } from "../enums/salutation";

 export const newsletterDemoData: {
  title: string;
@ -18,7 +17,9 @@ export const newsletterDemoData: {
      }
    >
  >;
-  recipient: Partial<member & { street: string; streetNumber: string; streetNumberAdd: string }>;
+  recipient: Partial<
+    Omit<member, "salutation"> & { salutation: string; street: string; streetNumber: string; streetNumberAdd: string }
+  >;
 } = {
  title: "Beispiel Newsletter Daten",
  description: "Zusammenfassung der Demodaten.",
@ -63,7 +64,7 @@ export const newsletterDemoData: {
  recipient: {
    firstname: "Julian",
    lastname: "Krauser",
-    salutation: Salutation.sir,
+    salutation: "Herr",
    nameaffix: "",
    street: "Straße",
    streetNumber: "Hausnummer",
--- a/src/entity/club/member/communication.ts
+++ b/src/entity/club/member/communication.ts
@ -13,6 +13,9 @@ export class communication {
  @Column({ type: "boolean", default: false })
  isSMSAlarming: boolean;

+  @Column({ type: "boolean", default: false })
+  isSendNewsletter: boolean;
+
  @Column({ type: "varchar", length: 255, nullable: true })
  mobile: string;

@ -40,17 +43,17 @@ export class communication {
  @Column()
  typeId: number;

-  @ManyToOne(() => communicationType, (communicationType) => communicationType.communications, {
-    nullable: false,
-    onDelete: "RESTRICT",
-    onUpdate: "RESTRICT",
-  })
-  type: communicationType;
-
  @ManyToOne(() => member, (member) => member.awards, {
    nullable: false,
    onDelete: "CASCADE",
    onUpdate: "RESTRICT",
  })
  member: member;
+
+  @ManyToOne(() => communicationType, (communicationType) => communicationType.communications, {
+    nullable: false,
+    onDelete: "RESTRICT",
+    onUpdate: "RESTRICT",
+  })
+  type: communicationType;
 }
--- a/src/entity/club/member/member.ts
+++ b/src/entity/club/member/member.ts
@ -1,32 +1,16 @@
 import { Column, Entity, JoinColumn, ManyToOne, OneToMany, OneToOne, PrimaryColumn } from "typeorm";
-import { Salutation } from "../../../enums/salutation";
 import { membership } from "./membership";
 import { memberAwards } from "./memberAwards";
 import { memberQualifications } from "./memberQualifications";
 import { memberExecutivePositions } from "./memberExecutivePositions";
 import { communication } from "./communication";
-import { CommunicationViewModel } from "../../../viewmodel/admin/club/member/communication.models";
+import { salutation } from "../../settings/salutation";

@Entity()
 export class member {
  @PrimaryColumn({ generated: "increment", type: "int" })
  id: number;

-  @Column({
-    type: "varchar",
-    length: "255",
-    default: Salutation.none.toString(),
-    transformer: {
-      to(value: Salutation) {
-        return value.toString();
-      },
-      from(value: string) {
-        return Salutation[value as keyof typeof Salutation];
-      },
-    },
-  })
-  salutation: Salutation;
-
  @Column({ type: "varchar", length: 255 })
  firstname: string;

@ -42,16 +26,14 @@ export class member {
  @Column({ type: "varchar", length: 255, unique: true, nullable: true })
  internalId?: string;

+  @Column()
+  salutationId: number;
+
  @OneToMany(() => communication, (communications) => communications.member)
  communications: communication[];

-  @OneToOne(() => communication, {
-    nullable: true,
-    onDelete: "SET NULL",
-    onUpdate: "RESTRICT",
-  })
-  @JoinColumn()
-  sendNewsletter?: communication;
+  @ManyToOne(() => salutation, (salutation) => salutation.members)
+  salutation: salutation;

  @OneToMany(() => membership, (membership) => membership.member)
  memberships: membership[];
@ -69,4 +51,5 @@ export class member {
  lastMembershipEntry?: membership;
  preferredCommunication?: Array<communication>;
  smsAlarming?: Array<communication>;
+  sendNewsletter?: communication;
 }
--- a/src/entity/club/member/membership.ts
+++ b/src/entity/club/member/membership.ts
@ -7,12 +7,6 @@ export class membership {
  @PrimaryColumn({ generated: "increment", type: "int" })
  id: number;

-  /**
-   * @deprecated
-   */
-  @Column({ type: "varchar", length: 255, unique: true, nullable: true })
-  internalId?: string;
-
  @Column({ type: "date" })
  start: Date;

--- a/src/entity/club/protocol/protocolPresence.ts
+++ b/src/entity/club/protocol/protocolPresence.ts
@ -13,6 +13,9 @@ export class protocolPresence {
  @Column({ type: "boolean", default: false })
  absent: boolean;

+  @Column({ type: "boolean", default: true })
+  excused: boolean;
+
  @ManyToOne(() => member, {
    nullable: false,
    onDelete: "CASCADE",
--- a/src/entity/club/protocol/protocolPrintout.ts
+++ b/src/entity/club/protocol/protocolPrintout.ts
@ -9,7 +9,7 @@ export class protocolPrintout {
  @Column({ type: "varchar", length: 255 })
  title: string;

-  @Column({ type: "int" })
+  @Column({ type: "int", default: "1" })
  iteration: number;

  @Column({ type: "varchar", length: 255 })
--- a/src/entity/settings/salutation.ts
+++ b/src/entity/settings/salutation.ts
@ -0,0 +1,15 @@
+import { Column, Entity, OneToMany, PrimaryColumn } from "typeorm";
+import { memberAwards } from "../club/member/memberAwards";
+import { member } from "../club/member/member";
+
+@Entity()
+export class salutation {
+  @PrimaryColumn({ generated: "increment", type: "int" })
+  id: number;
+
+  @Column({ type: "varchar", length: 255, unique: true })
+  salutation: string;
+
+  @OneToMany(() => member, (member) => member.salutation)
+  members: member[];
+}
--- a/src/entity/user/webapi.ts
+++ b/src/entity/user/webapi.ts
@ -0,0 +1,26 @@
+import { Column, CreateDateColumn, Entity, OneToMany, PrimaryColumn } from "typeorm";
+import { webapiPermission } from "./webapi_permission";
+
+@Entity()
+export class webapi {
+  @PrimaryColumn({ generated: "increment", type: "int" })
+  id: number;
+
+  @Column({ type: "text", unique: true, select: false })
+  token: string;
+
+  @Column({ type: "varchar", length: 255, unique: true })
+  title: string;
+
+  @CreateDateColumn()
+  createdAt: Date;
+
+  @Column({ type: "datetime", nullable: true })
+  lastUsage?: Date;
+
+  @Column({ type: "date", nullable: true })
+  expiry?: Date;
+
+  @OneToMany(() => webapiPermission, (apiPermission) => apiPermission.webapi)
+  permissions: webapiPermission[];
+}
--- a/src/entity/user/webapi_permission.ts
+++ b/src/entity/user/webapi_permission.ts
@ -0,0 +1,19 @@
+import { Column, Entity, ManyToOne, OneToMany, PrimaryColumn } from "typeorm";
+import { PermissionObject, PermissionString } from "../../type/permissionTypes";
+import { webapi } from "./webapi";
+
+@Entity()
+export class webapiPermission {
+  @PrimaryColumn({ type: "int" })
+  webapiId: number;
+
+  @PrimaryColumn({ type: "varchar", length: 255 })
+  permission: PermissionString;
+
+  @ManyToOne(() => webapi, {
+    nullable: false,
+    onDelete: "CASCADE",
+    onUpdate: "RESTRICT",
+  })
+  webapi: webapi;
+}
--- a/src/enums/salutation.ts
+++ b/src/enums/salutation.ts
@ -1,6 +0,0 @@
-export enum Salutation {
-  sir = "sir",
-  madam = "madam",
-  other = "other",
-  none = "none",
-}
--- a/src/env.defaults.ts
+++ b/src/env.defaults.ts
@ -13,6 +13,7 @@ export const SERVER_PORT = Number(process.env.SERVER_PORT ?? 5000);
 export const JWT_SECRET = process.env.JWT_SECRET ?? "my_jwt_secret_string_ilughfnadiuhgq§$IUZGFVRweiouarbt1oub3h5q4a";
 export const JWT_EXPIRATION = process.env.JWT_EXPIRATION ?? "15m";
 export const REFRESH_EXPIRATION = process.env.REFRESH_EXPIRATION ?? "1d";
+export const PWA_REFRESH_EXPIRATION = process.env.PWA_REFRESH_EXPIRATION ?? "5d";

 export const MAIL_USERNAME = process.env.MAIL_USERNAME ?? "";
 export const MAIL_PASSWORD = process.env.MAIL_PASSWORD ?? "";
@ -20,7 +21,7 @@ export const MAIL_HOST = process.env.MAIL_HOST ?? "";
 export const MAIL_PORT = Number(process.env.MAIL_PORT ?? "587");
 export const MAIL_SECURE = process.env.MAIL_SECURE ?? "false";

-export const CLUB_NAME = process.env.CLUB_NAME ?? "";
+export const CLUB_NAME = process.env.CLUB_NAME ?? "FF Admin";
 export const CLUB_WEBSITE = process.env.CLUB_WEBSITE ?? "";

 export function configCheck() {
@ -35,6 +36,7 @@ export function configCheck() {
  if (JWT_SECRET == "" || typeof JWT_SECRET != "string") throw new Error("set valid value to JWT_SECRET");
  checkMS(JWT_EXPIRATION, "JWT_EXPIRATION");
  checkMS(REFRESH_EXPIRATION, "REFRESH_EXPIRATION");
+  checkMS(PWA_REFRESH_EXPIRATION, "PWA_REFRESH_EXPIRATION");

  if (MAIL_USERNAME == "" || typeof MAIL_USERNAME != "string") throw new Error("set valid value to MAIL_USERNAME");
  if (MAIL_PASSWORD == "" || typeof MAIL_PASSWORD != "string") throw new Error("set valid value to MAIL_PASSWORD");
@ -42,7 +44,6 @@ export function configCheck() {
  if (typeof MAIL_PORT != "number") throw new Error("set valid numeric value to MAIL_PORT");
  if (MAIL_SECURE != "true" && MAIL_SECURE != "false") throw new Error("set 'true' or 'false' to MAIL_SECURE");

-  console.log(CLUB_WEBSITE);
  if (
    CLUB_WEBSITE != "" &&
    !/^(http(s):\/\/.)[-a-zA-Z0-9@:%._\+~#=]{2,256}\.[a-z]{2,6}\b([-a-zA-Z0-9@:%_\+.~#?&//=]*)$/.test(CLUB_WEBSITE)
--- a/src/factory/admin/club/member/communication.ts
+++ b/src/factory/admin/club/member/communication.ts
@ -20,7 +20,7 @@ export default abstract class CommunicationFactory {
      streetNumber: record.streetNumber,
      streetNumberAddition: record.streetNumberAddition,
      type: CommunicationTypeFactory.mapToSingle(record.type),
-      isNewsletterMain: isMain ? isMain : record?.member?.sendNewsletter?.id == record.id,
+      isNewsletterMain: record?.isSendNewsletter,
      isSMSAlarming: record.isSMSAlarming,
    };
  }
--- a/src/factory/admin/club/member/member.ts
+++ b/src/factory/admin/club/member/member.ts
@ -1,5 +1,7 @@
 import { member } from "../../../../entity/club/member/member";
-import { MemberViewModel } from "../../../../viewmodel/admin/club/member/member.models";
+import { MemberStatisticsViewModel, MemberViewModel } from "../../../../viewmodel/admin/club/member/member.models";
+import { memberView } from "../../../../views/memberView";
+import SalutationFactory from "../../settings/salutation";
 import CommunicationFactory from "./communication";
 import MembershipFactory from "./membership";

@ -12,7 +14,7 @@ export default abstract class MemberFactory {
  public static mapToSingle(record: member): MemberViewModel {
    return {
      id: record?.id,
-      salutation: record?.salutation,
+      salutation: SalutationFactory.mapToSingle(record?.salutation),
      firstname: record?.firstname,
      lastname: record?.lastname,
      nameaffix: record?.nameaffix,
@ -40,4 +42,23 @@ export default abstract class MemberFactory {
  public static mapToBase(records: Array<member>): Array<MemberViewModel> {
    return records.map((r) => this.mapToSingle(r));
  }
+
+  /**
+   * @description map view record to MemberMembershipStatisticsViewModel
+   * @param {memberView} record
+   * @returns {MemberStatisticsViewModel}
+   */
+  public static mapToMemberStatistic(record: memberView): MemberStatisticsViewModel {
+    return {
+      id: record.id,
+      salutation: record.salutation,
+      firstname: record.firstname,
+      lastname: record.lastname,
+      nameaffix: record.nameaffix,
+      birthdate: record.birthdate,
+      todayAge: record.todayAge,
+      ageThisYear: record.ageThisYear,
+      exactAge: record.exactAge,
+    };
+  }
 }
--- a/src/factory/admin/club/member/membership.ts
+++ b/src/factory/admin/club/member/membership.ts
@ -1,5 +1,9 @@
 import { membership } from "../../../../entity/club/member/membership";
-import { MembershipViewModel } from "../../../../viewmodel/admin/club/member/membership.models";
+import {
+  MembershipStatisticsViewModel,
+  MembershipViewModel,
+} from "../../../../viewmodel/admin/club/member/membership.models";
+import { membershipView } from "../../../../views/membershipsView";

 export default abstract class MembershipFactory {
  /**
@ -26,4 +30,33 @@ export default abstract class MembershipFactory {
  public static mapToBase(records: Array<membership>): Array<MembershipViewModel> {
    return records.map((r) => this.mapToSingle(r));
  }
+
+  /**
+   * @description map view record to MembershipStatisticsViewModel
+   * @param {membershipView} record
+   * @returns {MembershipStatisticsViewModel}
+   */
+  public static mapToSingleStatistic(record: membershipView): MembershipStatisticsViewModel {
+    return {
+      durationInDays: record.durationInDays,
+      durationInYears: record.durationInYears,
+      status: record.status,
+      statusId: record.statusId,
+      memberId: record.memberId,
+      memberSalutation: record.memberSalutation,
+      memberFirstname: record.memberFirstname,
+      memberLastname: record.memberLastname,
+      memberNameaffix: record.memberNameaffix,
+      memberBirthdate: record.memberBirthdate,
+    };
+  }
+
+  /**
+   * @description map records to MembershipStatisticsViewModel
+   * @param {Array<membershipView>} records
+   * @returns {Array<MembershipStatisticsViewModel>}
+   */
+  public static mapToBaseStatistics(records: Array<membershipView>): Array<MembershipStatisticsViewModel> {
+    return records.map((r) => this.mapToSingleStatistic(r));
+  }
 }
--- a/src/factory/admin/club/protocol/protocolPresence.ts
+++ b/src/factory/admin/club/protocol/protocolPresence.ts
@ -12,6 +12,7 @@ export default abstract class ProtocolPresenceFactory {
    return {
      memberId: record.member.id,
      absent: record.absent,
+      excused: record.excused,
      protocolId: record.protocolId,
    };
  }
--- a/src/factory/admin/settings/salutation.ts
+++ b/src/factory/admin/settings/salutation.ts
@ -0,0 +1,25 @@
+import { salutation } from "../../../entity/settings/salutation";
+import { SalutationViewModel } from "../../../viewmodel/admin/settings/salutation.models";
+
+export default abstract class SalutationFactory {
+  /**
+   * @description map record to salutation
+   * @param {salutation} record
+   * @returns {SalutationViewModel}
+   */
+  public static mapToSingle(record: salutation): SalutationViewModel {
+    return {
+      id: record.id,
+      salutation: record.salutation,
+    };
+  }
+
+  /**
+   * @description map records to salutation
+   * @param {Array<salutation>} records
+   * @returns {Array<SalutationViewModel>}
+   */
+  public static mapToBase(records: Array<salutation>): Array<SalutationViewModel> {
+    return records.map((r) => this.mapToSingle(r));
+  }
+}
--- a/src/factory/admin/user/webapi.ts
+++ b/src/factory/admin/user/webapi.ts
@ -0,0 +1,30 @@
+import { webapi } from "../../../entity/user/webapi";
+import PermissionHelper from "../../../helpers/permissionHelper";
+import { ApiViewModel } from "../../../viewmodel/admin/user/webapi.models";
+
+export default abstract class ApiFactory {
+  /**
+   * @description map record to api
+   * @param {webapi} record
+   * @returns {apiViewModel}
+   */
+  public static mapToSingle(record: webapi): ApiViewModel {
+    return {
+      id: record.id,
+      permissions: PermissionHelper.convertToObject(record.permissions.map((e) => e.permission)),
+      title: record.title,
+      expiry: record.expiry,
+      lastUsage: record.lastUsage,
+      createdAt: record.createdAt,
+    };
+  }
+
+  /**
+   * @description map records to api
+   * @param {Array<webapi>} records
+   * @returns {Array<apiViewModel>}
+   */
+  public static mapToBase(records: Array<webapi>): Array<ApiViewModel> {
+    return records.map((r) => this.mapToSingle(r));
+  }
+}
--- a/src/helpers/dynamicQueryBuilder.ts
+++ b/src/helpers/dynamicQueryBuilder.ts
@ -11,6 +11,7 @@ export default abstract class DynamicQueryBuilder {
    "executivePosition",
    "membershipStatus",
    "qualification",
+    "salutation",
    "member",
    "memberAwards",
    "memberExecutivePositions",
--- a/src/helpers/jwtHelper.ts
+++ b/src/helpers/jwtHelper.ts
@ -6,6 +6,9 @@ import RolePermissionService from "../service/user/rolePermissionService";
 import UserPermissionService from "../service/user/userPermissionService";
 import UserService from "../service/user/userService";
 import PermissionHelper from "./permissionHelper";
+import WebapiService from "../service/user/webapiService";
+import WebapiPermissionService from "../service/user/webapiPermissionService";
+import ms from "ms";

 export abstract class JWTHelper {
  static validate(token: string): Promise<string | jwt.JwtPayload> {
@ -17,13 +20,16 @@ export abstract class JWTHelper {
    });
  }

-  static create(data: JWTData): Promise<string> {
+  static create(
+    data: JWTData,
+    { expOverwrite, useExpiration }: { expOverwrite?: number; useExpiration?: boolean } = { useExpiration: true }
+  ): Promise<string> {
    return new Promise<string>((resolve, reject) => {
      jwt.sign(
        data,
        JWT_SECRET,
        {
-          expiresIn: JWT_EXPIRATION,
+          ...(useExpiration ?? true ? { expiresIn: expOverwrite ?? JWT_EXPIRATION } : {}),
        },
        (err, token) => {
          if (err) reject(err.message);
@ -72,4 +78,35 @@ export abstract class JWTHelper {
        throw new InternalException("Failed accessToken creation", err);
      });
  }
+
+  static async buildWebapiToken(token: string, expiration?: Date): Promise<string> {
+    let { id, title } = await WebapiService.getByToken(token);
+    let webapiPermissions = await WebapiPermissionService.getByApi(id);
+    let webapiPermissionStrings = webapiPermissions.map((e) => e.permission);
+    let permissionObject = PermissionHelper.convertToObject(webapiPermissionStrings);
+
+    let jwtData: JWTToken = {
+      userId: id,
+      mail: "",
+      username: title,
+      firstname: "",
+      lastname: "",
+      isOwner: false,
+      permissions: permissionObject,
+      sub: "webapi_access_token",
+    };
+
+    let overwriteExpiration =
+      ms(JWT_EXPIRATION) < new Date().getTime() - new Date(expiration).getTime()
+        ? null
+        : Date.now() - new Date(expiration).getTime();
+
+    return await JWTHelper.create(jwtData, { expOverwrite: overwriteExpiration, useExpiration: true })
+      .then((result) => {
+        return result;
+      })
+      .catch((err) => {
+        throw new InternalException("Failed webapi accessToken creation", err);
+      });
+  }
 }
--- a/src/helpers/newsletterHelper.ts
+++ b/src/helpers/newsletterHelper.ts
@ -33,12 +33,21 @@ export abstract class NewsletterHelper {
  private static formatJobEmit(
    event: "progress" | "complete",
    kind: "pdf" | "mail",
+    factor: "success" | "failed" | "info",
    newsletterId: number,
    total: number,
    iteration: number,
    msg: string
  ) {
-    this.jobStatus.emit<NewsletterEventType>(event, { kind, newsletterId, total, iteration, msg, date: new Date() });
+    this.jobStatus.emit<NewsletterEventType>(event, {
+      kind,
+      newsletterId,
+      factor,
+      total,
+      iteration,
+      msg,
+      date: new Date(),
+    });
  }

  public static buildData(
@ -91,7 +100,7 @@ export abstract class NewsletterHelper {
            recipient: {
              firstname: recipient.firstname,
              lastname: recipient.lastname,
-              salutation: recipient.salutation,
+              salutation: recipient.salutation.salutation,
              nameaffix: recipient.nameaffix,
              ...(showAdress
                ? {
@ -132,9 +141,7 @@ export abstract class NewsletterHelper {
      }
    }

-    console.log(queryMemberIds);
-
-    let members = await MemberService.getAll(0, 1000);
+    let members = await MemberService.getAll({ noLimit: true });

    return members[0].filter((m) => queryMemberIds.includes(m.id));
  }
@ -171,18 +178,9 @@ export abstract class NewsletterHelper {
        allowedForMail.includes(m.sendNewsletter?.type?.id)
    );

-    this.formatJobEmit("progress", "mail", newsletterId, mailRecipients.length, 0, "starting sending");
+    this.formatJobEmit("progress", "mail", "info", newsletterId, mailRecipients.length, 0, "starting sending");

    for (const [index, rec] of mailRecipients.entries()) {
-      this.formatJobEmit(
-        "progress",
-        "mail",
-        newsletterId,
-        mailRecipients.length,
-        index,
-        `start sending to ${rec.sendNewsletter.email}`
-      );
-
      let data = this.buildData(newsletter, dates, rec);

      const { body } = await TemplateHelper.renderFileForModule({
@ -197,9 +195,10 @@ export abstract class NewsletterHelper {
          this.formatJobEmit(
            "progress",
            "mail",
+            "success",
            newsletterId,
            mailRecipients.length,
-            index,
+            index + 1,
            `successfully sent to ${rec.sendNewsletter.email}`
          );
        })
@ -207,18 +206,19 @@ export abstract class NewsletterHelper {
          this.formatJobEmit(
            "progress",
            "mail",
+            "failed",
            newsletterId,
            mailRecipients.length,
-            index,
+            index + 1,
            `failed to send to ${rec.sendNewsletter.email}`
          );
-          console.log("mail send", err);
        });
    }

    this.formatJobEmit(
      "complete",
      "mail",
+      "info",
      newsletterId,
      mailRecipients.length,
      mailRecipients.length,
@ -249,21 +249,12 @@ export abstract class NewsletterHelper {
      (m) => !notAllowedForPdf.includes(m.sendNewsletter?.type?.id) || m.sendNewsletter == null
    );

-    this.formatJobEmit("progress", "pdf", newsletterId, pdfRecipients.length, 0, "starting sending");
+    this.formatJobEmit("progress", "pdf", "info", newsletterId, pdfRecipients.length + 1, 0, "starting sending");

    for (const [index, rec] of [
      ...pdfRecipients,
      { id: 0, firstname: "Alle Mitglieder", lastname: CLUB_NAME } as member,
    ].entries()) {
-      this.formatJobEmit(
-        "progress",
-        "pdf",
-        newsletterId,
-        pdfRecipients.length,
-        index,
-        `start print for ${rec.lastname}, ${rec.firstname}`
-      );
-
      let data = this.buildData(newsletter, dates, rec, printWithAdress.includes(rec.sendNewsletter?.type?.id));

      await PdfExport.renderFile({
@ -277,9 +268,10 @@ export abstract class NewsletterHelper {
          this.formatJobEmit(
            "progress",
            "pdf",
+            "success",
            newsletterId,
-            pdfRecipients.length,
-            index,
+            pdfRecipients.length + 1,
+            index + 1,
            `successfully printed for ${rec.lastname}, ${rec.firstname}`
          );
        })
@ -287,24 +279,15 @@ export abstract class NewsletterHelper {
          this.formatJobEmit(
            "progress",
            "pdf",
+            "failed",
            newsletterId,
-            pdfRecipients.length,
-            index,
+            pdfRecipients.length + 1,
+            index + 1,
            `failed print for ${rec.lastname}, ${rec.firstname}`
          );
-          console.log("pdf print", err);
        });
    }

-    this.formatJobEmit(
-      "progress",
-      "pdf",
-      newsletterId,
-      pdfRecipients.length,
-      pdfRecipients.length,
-      "starting pdf combine"
-    );
-
    await PdfExport.sqashToSingleFile(
      `newsletter/${newsletter.id}_${newsletter.title.replace(" ", "")}`,
      "allPdfsTogether",
@ -314,9 +297,10 @@ export abstract class NewsletterHelper {
        this.formatJobEmit(
          "progress",
          "pdf",
+          "success",
          newsletterId,
-          pdfRecipients.length,
-          pdfRecipients.length,
+          pdfRecipients.length + 1,
+          pdfRecipients.length + 1,
          "sucessfully combined pdf"
        );
      })
@ -324,20 +308,21 @@ export abstract class NewsletterHelper {
        this.formatJobEmit(
          "progress",
          "pdf",
+          "failed",
          newsletterId,
-          pdfRecipients.length,
-          pdfRecipients.length,
+          pdfRecipients.length + 1,
+          pdfRecipients.length + 1,
          "failed combining pdf"
        );
-        console.log("pdf squash", err);
      });

    this.formatJobEmit(
      "complete",
      "pdf",
+      "info",
      newsletterId,
-      pdfRecipients.length,
-      pdfRecipients.length,
+      pdfRecipients.length + 1,
+      pdfRecipients.length + 1,
      `completed printing process`
    );
  }
--- a/src/helpers/permissionHelper.ts
+++ b/src/helpers/permissionHelper.ts
@ -89,6 +89,19 @@ export default class PermissionHelper {
    };
  }

+  static isAdminMiddleware(): (req: Request, res: Response, next: Function) => void {
+    return (req: Request, res: Response, next: Function) => {
+      const permissions = req.permissions;
+      const isOwner = req.isOwner;
+
+      if (isOwner || permissions.admin) {
+        next();
+      } else {
+        throw new ForbiddenRequestException(`missing admin permission`);
+      }
+    };
+  }
+
  static convertToObject(permissions: Array<PermissionString>): PermissionObject {
    if (permissions.includes("*")) {
      return {
--- a/src/index.ts
+++ b/src/index.ts
@ -12,6 +12,8 @@ declare global {
      username: string;
      isOwner: boolean;
      permissions: PermissionObject;
+      isPWA: boolean;
+      isWebApiRequest: boolean;
    }
  }
 }
--- a/src/middleware/authenticate.ts
+++ b/src/middleware/authenticate.ts
@ -29,10 +29,15 @@ export default async function authenticate(req: Request, res: Response, next: Fu
    throw new InternalException("process failed");
  }

+  if (decoded?.sub == "api_token_retrieve") {
+    throw new BadRequestException("This token is only authorized to get temporary access tokens via GET /api/webapi");
+  }
+
  req.userId = decoded.userId;
  req.username = decoded.username;
  req.isOwner = decoded.isOwner;
  req.permissions = decoded.permissions;
+  req.isWebApiRequest = decoded?.sub == "webapi_access_token";

  next();
 }
--- a/src/middleware/authenticateAPI.ts
+++ b/src/middleware/authenticateAPI.ts
@ -0,0 +1,37 @@
+import { Request, Response } from "express";
+import jwt from "jsonwebtoken";
+import BadRequestException from "../exceptions/badRequestException";
+import UnauthorizedRequestException from "../exceptions/unauthorizedRequestException";
+import InternalException from "../exceptions/internalException";
+import { JWTHelper } from "../helpers/jwtHelper";
+
+export default async function authenticateAPI(req: Request, res: Response, next: Function) {
+  const bearer = req.headers.authorization?.split(" ")?.[1] ?? undefined;
+
+  if (!bearer) {
+    throw new BadRequestException("Provide valid Authorization Header");
+  }
+
+  let decoded: string | jwt.JwtPayload;
+  await JWTHelper.validate(bearer)
+    .then((result) => {
+      decoded = result;
+    })
+    .catch((err) => {
+      if (err == "jwt expired") {
+        throw new UnauthorizedRequestException("Token expired", err);
+      } else {
+        throw new BadRequestException("Failed Authorization Header decoding", err);
+      }
+    });
+
+  if (typeof decoded == "string" || !decoded) {
+    throw new InternalException("process failed");
+  }
+
+  if (decoded?.sub != "api_token_retrieve") {
+    throw new BadRequestException("This route can only be accessed via a api token");
+  }
+
+  next();
+}
--- a/src/middleware/detectPWA.ts
+++ b/src/middleware/detectPWA.ts
@ -0,0 +1,11 @@
+import { Request, Response } from "express";
+
+export default async function detectPWA(req: Request, res: Response, next: Function) {
+  const userAgent = req.headers["user-agent"] || "";
+  if ((userAgent.includes("Mobile") && userAgent.includes("Standalone")) || req.headers["x-pwa-client"] === "true") {
+    req.isPWA = true;
+  } else {
+    req.isPWA = false;
+  }
+  next();
+}
--- a/src/middleware/errorHandler.ts
+++ b/src/middleware/errorHandler.ts
@ -1,6 +1,7 @@
 import { Request, Response } from "express";
 import { ExceptionBase } from "../exceptions/exceptionsBaseType";
 import CustomRequestException from "../exceptions/customRequestException";
+import UnauthorizedRequestException from "../exceptions/unauthorizedRequestException";

 export default function errorHandler(err: ExceptionBase | Error, req: Request, res: Response, next: Function) {
  let status = 500;
@ -11,7 +12,11 @@ export default function errorHandler(err: ExceptionBase | Error, req: Request, r
    msg = err.message;
  }

-  console.log("Handler", err);
+  if (err instanceof CustomRequestException) {
+    console.log("Custom Handler", status, msg);
+  } else {
+    console.log("Error Handler", err);
+  }

  res.status(status).send(msg);
 }
--- a/src/middleware/preventWebApiAccess.ts
+++ b/src/middleware/preventWebApiAccess.ts
@ -0,0 +1,10 @@
+import { Request, Response } from "express";
+import ForbiddenRequestException from "../exceptions/forbiddenRequestException";
+
+export default async function preventWebapiAccess(req: Request, res: Response, next: Function) {
+  if (req.isWebApiRequest) {
+    throw new ForbiddenRequestException("This route cannot be accessed via webapi");
+  } else {
+    next();
+  }
+}
--- a/src/migrations/1734520998539-memberDataViews.ts
+++ b/src/migrations/1734520998539-memberDataViews.ts
@ -8,105 +8,105 @@ export class MemberDataViews1734520998539 implements MigrationInterface {
  name = "MemberDataViews1734520998539";

  public async up(queryRunner: QueryRunner): Promise<void> {
-    await queryRunner.createView(
-      new View({
-        name: "member_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(member)
-            .createQueryBuilder("member")
-            .select("member.id", "id")
-            .addSelect("member.salutation", "salutation")
-            .addSelect("member.firstname", "firstname")
-            .addSelect("member.lastname", "lastname")
-            .addSelect("member.nameaffix", "nameaffix")
-            .addSelect("member.birthdate", "birthdate")
-            .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
-            .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear"),
-      }),
-      true
-    );
-    await queryRunner.createView(
-      new View({
-        name: "member_executive_positions_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(memberExecutivePositions)
-            .createQueryBuilder("memberExecutivePositions")
-            .select("executivePosition.id", "positionId")
-            .addSelect("executivePosition.position", "position")
-            .addSelect("member.id", "memberId")
-            .addSelect("member.salutation", "memberSalutation")
-            .addSelect("member.firstname", "memberFirstname")
-            .addSelect("member.lastname", "memberLastname")
-            .addSelect("member.nameaffix", "memberNameaffix")
-            .addSelect("member.birthdate", "memberBirthdate")
-            .addSelect(
-              "SUM(TIMESTAMPDIFF(DAY, memberExecutivePositions.start, COALESCE(memberExecutivePositions.end, CURRENT_DATE)))",
-              "durationInDays"
-            )
-            .leftJoin("memberExecutivePositions.executivePosition", "executivePosition")
-            .leftJoin("memberExecutivePositions.member", "member")
-            .groupBy("executivePosition.id"),
-      }),
-      true
-    );
-    await queryRunner.createView(
-      new View({
-        name: "member_qualifications_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(memberQualifications)
-            .createQueryBuilder("memberQualifications")
-            .select("qualification.id", "qualificationId")
-            .addSelect("qualification.qualification", "qualification")
-            .addSelect("member.id", "memberId")
-            .addSelect("member.salutation", "memberSalutation")
-            .addSelect("member.firstname", "memberFirstname")
-            .addSelect("member.lastname", "memberLastname")
-            .addSelect("member.nameaffix", "memberNameaffix")
-            .addSelect("member.birthdate", "memberBirthdate")
-            .addSelect(
-              "SUM(TIMESTAMPDIFF(DAY, memberQualifications.start, COALESCE(memberQualifications.end, CURRENT_DATE)))",
-              "durationInDays"
-            )
-            .leftJoin("memberQualifications.qualification", "qualification")
-            .leftJoin("memberQualifications.member", "member")
-            .groupBy("qualification.id"),
-      }),
-      true
-    );
-    await queryRunner.createView(
-      new View({
-        name: "membership_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(membership)
-            .createQueryBuilder("membership")
-            .select("status.id", "statusId")
-            .addSelect("status.status", "status")
-            .addSelect("member.id", "memberId")
-            .addSelect("member.salutation", "memberSalutation")
-            .addSelect("member.firstname", "memberFirstname")
-            .addSelect("member.lastname", "memberLastname")
-            .addSelect("member.nameaffix", "memberNameaffix")
-            .addSelect("member.birthdate", "memberBirthdate")
-            .addSelect(
-              "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
-              "durationInDays"
-            )
-            .leftJoin("membership.status", "status")
-            .leftJoin("membership.member", "member")
-            .groupBy("status.id"),
-      }),
-      true
-    );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "member_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(member)
+    //         .createQueryBuilder("member")
+    //         .select("member.id", "id")
+    //         .addSelect("member.salutation", "salutation")
+    //         .addSelect("member.firstname", "firstname")
+    //         .addSelect("member.lastname", "lastname")
+    //         .addSelect("member.nameaffix", "nameaffix")
+    //         .addSelect("member.birthdate", "birthdate")
+    //         .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
+    //         .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear"),
+    //   }),
+    //   true
+    // );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "member_executive_positions_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(memberExecutivePositions)
+    //         .createQueryBuilder("memberExecutivePositions")
+    //         .select("executivePosition.id", "positionId")
+    //         .addSelect("executivePosition.position", "position")
+    //         .addSelect("member.id", "memberId")
+    //         .addSelect("member.salutation", "memberSalutation")
+    //         .addSelect("member.firstname", "memberFirstname")
+    //         .addSelect("member.lastname", "memberLastname")
+    //         .addSelect("member.nameaffix", "memberNameaffix")
+    //         .addSelect("member.birthdate", "memberBirthdate")
+    //         .addSelect(
+    //           "SUM(TIMESTAMPDIFF(DAY, memberExecutivePositions.start, COALESCE(memberExecutivePositions.end, CURRENT_DATE)))",
+    //           "durationInDays"
+    //         )
+    //         .leftJoin("memberExecutivePositions.executivePosition", "executivePosition")
+    //         .leftJoin("memberExecutivePositions.member", "member")
+    //         .groupBy("executivePosition.id"),
+    //   }),
+    //   true
+    // );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "member_qualifications_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(memberQualifications)
+    //         .createQueryBuilder("memberQualifications")
+    //         .select("qualification.id", "qualificationId")
+    //         .addSelect("qualification.qualification", "qualification")
+    //         .addSelect("member.id", "memberId")
+    //         .addSelect("member.salutation", "memberSalutation")
+    //         .addSelect("member.firstname", "memberFirstname")
+    //         .addSelect("member.lastname", "memberLastname")
+    //         .addSelect("member.nameaffix", "memberNameaffix")
+    //         .addSelect("member.birthdate", "memberBirthdate")
+    //         .addSelect(
+    //           "SUM(TIMESTAMPDIFF(DAY, memberQualifications.start, COALESCE(memberQualifications.end, CURRENT_DATE)))",
+    //           "durationInDays"
+    //         )
+    //         .leftJoin("memberQualifications.qualification", "qualification")
+    //         .leftJoin("memberQualifications.member", "member")
+    //         .groupBy("qualification.id"),
+    //   }),
+    //   true
+    // );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "membership_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(membership)
+    //         .createQueryBuilder("membership")
+    //         .select("status.id", "statusId")
+    //         .addSelect("status.status", "status")
+    //         .addSelect("member.id", "memberId")
+    //         .addSelect("member.salutation", "memberSalutation")
+    //         .addSelect("member.firstname", "memberFirstname")
+    //         .addSelect("member.lastname", "memberLastname")
+    //         .addSelect("member.nameaffix", "memberNameaffix")
+    //         .addSelect("member.birthdate", "memberBirthdate")
+    //         .addSelect(
+    //           "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
+    //           "durationInDays"
+    //         )
+    //         .leftJoin("membership.status", "status")
+    //         .leftJoin("membership.member", "member")
+    //         .groupBy("status.id"),
+    //   }),
+    //   true
+    // );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
-    await queryRunner.dropView("membership_view");
-    await queryRunner.dropView("member_qualifications_view");
-    await queryRunner.dropView("member_executive_positions_view");
-    await queryRunner.dropView("member_view");
+    // await queryRunner.dropView("membership_view");
+    // await queryRunner.dropView("member_qualifications_view");
+    // await queryRunner.dropView("member_executive_positions_view");
+    // await queryRunner.dropView("member_view");
  }
 }
--- a/src/migrations/1735822722235-internalId.ts
+++ b/src/migrations/1735822722235-internalId.ts
@ -18,27 +18,25 @@ export class InternalId1735822722235 implements MigrationInterface {
      })
    );

-    let memberships = await queryRunner.manager.getRepository(membership).find();
-    console.log(memberships);
-    let internalIds = memberships.reduce<{ [key: number]: Array<string> }>((acc, cur) => {
-      let memberId = cur.memberId;
-      let setIds = acc[memberId] ?? [];
-      if (cur?.internalId) {
-        setIds.push(cur.internalId);
-      }
-      acc[memberId] = setIds;
-      return acc;
-    }, {});
+    // let memberships = await queryRunner.manager.getRepository(membership).find();
+    // let internalIds = memberships.reduce<{ [key: number]: Array<string> }>((acc, cur) => {
+    //   let memberId = cur.memberId;
+    //   let setIds = acc[memberId] ?? [];
+    //   if (cur?.internalId) {
+    //     setIds.push(cur.internalId);
+    //   }
+    //   acc[memberId] = setIds;
+    //   return acc;
+    // }, {});

-    console.log(internalIds);
-    for (const [id, value] of Object.entries(internalIds)) {
-      const ids = value.filter((v) => v != null).join(", ");
-      if (ids) {
-        let m = await queryRunner.manager.getRepository(member).findOneByOrFail({ id: parseInt(id) });
-        m.internalId = ids;
-        await queryRunner.manager.getRepository(member).save(m);
-      }
-    }
+    // for (const [id, value] of Object.entries(internalIds)) {
+    //   const ids = value.filter((v) => v != null).join(", ");
+    //   if (ids) {
+    //     let m = await queryRunner.manager.getRepository(member).findOneByOrFail({ id: parseInt(id) });
+    //     m.internalId = ids;
+    //     await queryRunner.manager.getRepository(member).save(m);
+    //   }
+    // }
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
--- a/src/migrations/1736084198860-extendViewValues.ts
+++ b/src/migrations/1736084198860-extendViewValues.ts
@ -8,106 +8,104 @@ export class ExtendViewValues1736084198860 implements MigrationInterface {
  name = "ExtendViewValues1736084198860";

  public async up(queryRunner: QueryRunner): Promise<void> {
-    await queryRunner.dropView("membership_view");
-    await queryRunner.dropView("member_view");
-
-    await queryRunner.createView(
-      new View({
-        name: "member_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(member)
-            .createQueryBuilder("member")
-            .select("member.id", "id")
-            .addSelect("member.salutation", "salutation")
-            .addSelect("member.firstname", "firstname")
-            .addSelect("member.lastname", "lastname")
-            .addSelect("member.nameaffix", "nameaffix")
-            .addSelect("member.birthdate", "birthdate")
-            .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
-            .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear")
-            .addSelect("CONCAT('_', FROM_DAYS(TIMESTAMPDIFF(DAY, member.birthdate, CURDATE())))", "exactAge"),
-      }),
-      true
-    );
-    await queryRunner.createView(
-      new View({
-        name: "membership_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(membership)
-            .createQueryBuilder("membership")
-            .select("status.id", "statusId")
-            .addSelect("status.status", "status")
-            .addSelect("member.id", "memberId")
-            .addSelect("member.salutation", "memberSalutation")
-            .addSelect("member.firstname", "memberFirstname")
-            .addSelect("member.lastname", "memberLastname")
-            .addSelect("member.nameaffix", "memberNameaffix")
-            .addSelect("member.birthdate", "memberBirthdate")
-            .addSelect(
-              "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
-              "durationInDays"
-            )
-            .addSelect(
-              "CONCAT('_', FROM_DAYS(SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))))",
-              "durationInYears"
-            )
-            .leftJoin("membership.status", "status")
-            .leftJoin("membership.member", "member")
-            .groupBy("status.id")
-            .addGroupBy("member.id"),
-      }),
-      true
-    );
+    // await queryRunner.dropView("membership_view");
+    // await queryRunner.dropView("member_view");
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "member_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(member)
+    //         .createQueryBuilder("member")
+    //         .select("member.id", "id")
+    //         .addSelect("member.salutation", "salutation")
+    //         .addSelect("member.firstname", "firstname")
+    //         .addSelect("member.lastname", "lastname")
+    //         .addSelect("member.nameaffix", "nameaffix")
+    //         .addSelect("member.birthdate", "birthdate")
+    //         .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
+    //         .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear")
+    //         .addSelect("CONCAT('_', FROM_DAYS(TIMESTAMPDIFF(DAY, member.birthdate, CURDATE())))", "exactAge"),
+    //   }),
+    //   true
+    // );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "membership_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(membership)
+    //         .createQueryBuilder("membership")
+    //         .select("status.id", "statusId")
+    //         .addSelect("status.status", "status")
+    //         .addSelect("member.id", "memberId")
+    //         .addSelect("member.salutation", "memberSalutation")
+    //         .addSelect("member.firstname", "memberFirstname")
+    //         .addSelect("member.lastname", "memberLastname")
+    //         .addSelect("member.nameaffix", "memberNameaffix")
+    //         .addSelect("member.birthdate", "memberBirthdate")
+    //         .addSelect(
+    //           "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
+    //           "durationInDays"
+    //         )
+    //         .addSelect(
+    //           "CONCAT('_', FROM_DAYS(SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))))",
+    //           "durationInYears"
+    //         )
+    //         .leftJoin("membership.status", "status")
+    //         .leftJoin("membership.member", "member")
+    //         .groupBy("status.id")
+    //         .addGroupBy("member.id"),
+    //   }),
+    //   true
+    // );
  }

  public async down(queryRunner: QueryRunner): Promise<void> {
-    await queryRunner.dropView("membership_view");
-    await queryRunner.dropView("member_view");
-
-    await queryRunner.createView(
-      new View({
-        name: "member_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(member)
-            .createQueryBuilder("member")
-            .select("member.id", "id")
-            .addSelect("member.salutation", "salutation")
-            .addSelect("member.firstname", "firstname")
-            .addSelect("member.lastname", "lastname")
-            .addSelect("member.nameaffix", "nameaffix")
-            .addSelect("member.birthdate", "birthdate")
-            .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
-            .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear"),
-      }),
-      true
-    );
-    await queryRunner.createView(
-      new View({
-        name: "membership_view",
-        expression: (datasource: DataSource) =>
-          datasource
-            .getRepository(membership)
-            .createQueryBuilder("membership")
-            .select("status.id", "statusId")
-            .addSelect("status.status", "status")
-            .addSelect("member.id", "memberId")
-            .addSelect("member.salutation", "memberSalutation")
-            .addSelect("member.firstname", "memberFirstname")
-            .addSelect("member.lastname", "memberLastname")
-            .addSelect("member.nameaffix", "memberNameaffix")
-            .addSelect("member.birthdate", "memberBirthdate")
-            .addSelect(
-              "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
-              "durationInDays"
-            )
-            .leftJoin("membership.status", "status")
-            .leftJoin("membership.member", "member")
-            .groupBy("status.id"),
-      }),
-      true
-    );
+    // await queryRunner.dropView("membership_view");
+    // await queryRunner.dropView("member_view");
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "member_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(member)
+    //         .createQueryBuilder("member")
+    //         .select("member.id", "id")
+    //         .addSelect("member.salutation", "salutation")
+    //         .addSelect("member.firstname", "firstname")
+    //         .addSelect("member.lastname", "lastname")
+    //         .addSelect("member.nameaffix", "nameaffix")
+    //         .addSelect("member.birthdate", "birthdate")
+    //         .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
+    //         .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear"),
+    //   }),
+    //   true
+    // );
+    // await queryRunner.createView(
+    //   new View({
+    //     name: "membership_view",
+    //     expression: (datasource: DataSource) =>
+    //       datasource
+    //         .getRepository(membership)
+    //         .createQueryBuilder("membership")
+    //         .select("status.id", "statusId")
+    //         .addSelect("status.status", "status")
+    //         .addSelect("member.id", "memberId")
+    //         .addSelect("member.salutation", "memberSalutation")
+    //         .addSelect("member.firstname", "memberFirstname")
+    //         .addSelect("member.lastname", "memberLastname")
+    //         .addSelect("member.nameaffix", "memberNameaffix")
+    //         .addSelect("member.birthdate", "memberBirthdate")
+    //         .addSelect(
+    //           "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
+    //           "durationInDays"
+    //         )
+    //         .leftJoin("membership.status", "status")
+    //         .leftJoin("membership.member", "member")
+    //         .groupBy("status.id"),
+    //   }),
+    //   true
+    // );
  }
 }
--- a/src/migrations/1736505324488-finishInternalIdTransfer.ts
+++ b/src/migrations/1736505324488-finishInternalIdTransfer.ts
@ -0,0 +1,23 @@
+import { MigrationInterface, QueryRunner, TableColumn } from "typeorm";
+
+export class FinishInternalIdTransfer1736505324488 implements MigrationInterface {
+  name = "FinishInternalIdTransfer1736505324488";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.dropColumn("membership", "internalId");
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.addColumn(
+      "membership",
+      new TableColumn({
+        name: "internalId",
+        type: "varchar",
+        length: "255",
+        default: null,
+        isNullable: true,
+        isUnique: true,
+      })
+    );
+  }
+}
--- a/src/migrations/1737287798828-protocolPresenceExcuse.ts
+++ b/src/migrations/1737287798828-protocolPresenceExcuse.ts
@ -0,0 +1,21 @@
+import { MigrationInterface, QueryRunner, TableColumn } from "typeorm";
+
+export class ProtocolPresenceExcuse1737287798828 implements MigrationInterface {
+  name = "ProtocolPresenceExcuse1737287798828";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.addColumn(
+      "protocol_presence",
+      new TableColumn({
+        name: "excused",
+        type: "tinyint",
+        default: "1",
+        isNullable: false,
+      })
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.dropColumn("protocol_presence", "excused");
+  }
+}
--- a/src/migrations/1737453096674-addwebapiTokens.ts
+++ b/src/migrations/1737453096674-addwebapiTokens.ts
@ -0,0 +1,55 @@
+import { MigrationInterface, QueryRunner, Table, TableForeignKey } from "typeorm";
+import { DB_TYPE } from "../env.defaults";
+
+export class AddWebapiTokens1737453096674 implements MigrationInterface {
+  name = "AddWebApiTokens1737453096674";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    const variableType_int = DB_TYPE == "mysql" ? "int" : "integer";
+
+    await queryRunner.createTable(
+      new Table({
+        name: "webapi",
+        columns: [
+          { name: "id", type: variableType_int, isPrimary: true, isGenerated: true, generationStrategy: "increment" },
+          { name: "token", type: "text", isUnique: true, isNullable: false },
+          { name: "title", type: "varchar", isUnique: true, length: "255", isNullable: false },
+          { name: "createdAt", type: "datetime", default: "CURRENT_TIMESTAMP(6)", isNullable: false },
+          { name: "lastUsage", type: "datetime", isNullable: true, default: null },
+          { name: "expiry", type: "date", isNullable: true, default: null },
+        ],
+      }),
+      true
+    );
+
+    await queryRunner.createTable(
+      new Table({
+        name: "webapi_permission",
+        columns: [
+          { name: "webapiId", type: variableType_int, isPrimary: true, isNullable: false },
+          { name: "permission", type: "varchar", length: "255", isPrimary: true, isNullable: false },
+        ],
+      }),
+      true
+    );
+
+    await queryRunner.createForeignKey(
+      "webapi_permission",
+      new TableForeignKey({
+        columnNames: ["webapiId"],
+        referencedColumnNames: ["id"],
+        referencedTableName: "webapi",
+        onDelete: "CASCADE",
+        onUpdate: "RESTRICT",
+      })
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    const table = await queryRunner.getTable("webapi_permission");
+    const foreignKey = table.foreignKeys.find((fk) => fk.columnNames.indexOf("webapiId") !== -1);
+    await queryRunner.dropForeignKey("webapi_permission", foreignKey);
+    await queryRunner.dropTable("webapi_permission");
+    await queryRunner.dropTable("webapi");
+  }
+}
--- a/src/migrations/1737796878058-salutationAsTable.ts
+++ b/src/migrations/1737796878058-salutationAsTable.ts
@ -0,0 +1,91 @@
+import { MigrationInterface, QueryRunner, Table, TableForeignKey } from "typeorm";
+import { DB_TYPE } from "../env.defaults";
+import { member } from "../entity/club/member/member";
+import { salutation } from "../entity/settings/salutation";
+
+export class SalutationAsTable1737796878058 implements MigrationInterface {
+  name = "SalutationAsTable1737796878058";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    const variableType_int = DB_TYPE == "mysql" ? "int" : "integer";
+
+    await queryRunner.createTable(
+      new Table({
+        name: "salutation",
+        columns: [
+          { name: "id", type: variableType_int, isPrimary: true, isGenerated: true, generationStrategy: "increment" },
+          { name: "salutation", type: "varchar", length: "255", isUnique: true, isNullable: false },
+        ],
+      }),
+      true
+    );
+
+    // ! has to be sql. Else the column would be dropped and created - resulting in data loss.
+    await queryRunner.query(
+      `ALTER TABLE \`member\` CHANGE \`salutation\` \`salutationId\` varchar(255) NOT NULL DEFAULT ''`
+    );
+
+    // ! has to be sql. Else no data is returned.
+    const existing_salutations = await queryRunner.query(
+      "SELECT DISTINCT salutationId FROM `member` `member` GROUP BY salutationId"
+    );
+
+    for (let s of existing_salutations.map((s: any) => s.salutationId) as Array<string>) {
+      await queryRunner.manager.getRepository(salutation).save({ salutation: s });
+    }
+
+    const salutations = await queryRunner.manager.getRepository(salutation).find();
+
+    for (let salutation of salutations) {
+      await queryRunner.manager
+        .getRepository(member)
+        .createQueryBuilder("member")
+        .update({ salutationId: salutation.id })
+        .where({ salutationId: salutation.salutation })
+        .execute();
+    }
+
+    await queryRunner.query(
+      `ALTER TABLE \`member\` CHANGE \`salutationId\` \`salutationId\` ${variableType_int} NOT NULL`
+    );
+
+    await queryRunner.createForeignKey(
+      "member",
+      new TableForeignKey({
+        columnNames: ["salutationId"],
+        referencedColumnNames: ["id"],
+        referencedTableName: "salutation",
+        onDelete: "RESTRICT",
+        onUpdate: "RESTRICT",
+      })
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    const table = await queryRunner.getTable("member");
+    const foreignKey = table.foreignKeys.find((fk) => fk.columnNames.indexOf("salutationId") !== -1);
+    await queryRunner.dropForeignKey("member", foreignKey);
+
+    // ! has to be sql. Else the column would be dropped and created - resulting in data loss.
+    await queryRunner.query(
+      `ALTER TABLE \`member\` CHANGE \`salutationId\` \`salutationId\` varchar(255) NOT NULL DEFAULT ''`
+    );
+
+    const salutations = await queryRunner.manager.getRepository(salutation).find();
+
+    for (let salutation of salutations) {
+      await queryRunner.manager
+        .getRepository(member)
+        .createQueryBuilder("member")
+        .update({ salutationId: salutation.salutation as unknown as number })
+        .where({ salutationId: salutation.id })
+        .execute();
+    }
+
+    await queryRunner.query(
+      `ALTER TABLE \`member\` CHANGE \`salutationId\` \`salutation\` varchar(255) NOT NULL DEFAULT 'none'`
+    );
+
+    await queryRunner.dropTable("webapi");
+  }
+}
--- a/src/migrations/1737800468938-updateViews.ts
+++ b/src/migrations/1737800468938-updateViews.ts
@ -0,0 +1,233 @@
+import { DataSource, MigrationInterface, QueryRunner, View } from "typeorm";
+import { member } from "../entity/club/member/member";
+import { memberExecutivePositions } from "../entity/club/member/memberExecutivePositions";
+import { memberQualifications } from "../entity/club/member/memberQualifications";
+import { membership } from "../entity/club/member/membership";
+
+export class UpdateViews1737800468938 implements MigrationInterface {
+  name = "UpdateViews1737800468938";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    // await queryRunner.dropView("membership_view");
+    // await queryRunner.dropView("member_executive_positions_view");
+    // await queryRunner.dropView("member_qualifications_view");
+    // await queryRunner.dropView("member_view");
+    await queryRunner.query(`DROP VIEW IF EXISTS membership_view`);
+    await queryRunner.query(`DROP VIEW IF EXISTS member_executive_positions_view`);
+    await queryRunner.query(`DROP VIEW IF EXISTS member_qualifications_view`);
+    await queryRunner.query(`DROP VIEW IF EXISTS member_view`);
+
+    await queryRunner.createView(
+      new View({
+        name: "member_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(member)
+            .createQueryBuilder("member")
+            .select("member.id", "id")
+            .addSelect("member.firstname", "firstname")
+            .addSelect("member.lastname", "lastname")
+            .addSelect("member.nameaffix", "nameaffix")
+            .addSelect("member.birthdate", "birthdate")
+            .addSelect("salutation.salutation", "salutation")
+            .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
+            .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear")
+            .addSelect("CONCAT('_', FROM_DAYS(TIMESTAMPDIFF(DAY, member.birthdate, CURDATE())))", "exactAge")
+            .leftJoin("member.salutation", "salutation"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "member_executive_positions_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(memberExecutivePositions)
+            .createQueryBuilder("memberExecutivePositions")
+            .select("executivePosition.id", "positionId")
+            .addSelect("executivePosition.position", "position")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect("salutation.salutation", "memberSalutation")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, memberExecutivePositions.start, COALESCE(memberExecutivePositions.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .leftJoin("memberExecutivePositions.executivePosition", "executivePosition")
+            .leftJoin("memberExecutivePositions.member", "member")
+            .leftJoin("member.salutation", "salutation")
+            .groupBy("executivePosition.id")
+            .addGroupBy("member.id"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "member_qualifications_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(memberQualifications)
+            .createQueryBuilder("memberQualifications")
+            .select("qualification.id", "qualificationId")
+            .addSelect("qualification.qualification", "qualification")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect("salutation.salutation", "memberSalutation")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, memberQualifications.start, COALESCE(memberQualifications.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .leftJoin("memberQualifications.qualification", "qualification")
+            .leftJoin("memberQualifications.member", "member")
+            .leftJoin("member.salutation", "salutation")
+            .groupBy("qualification.id")
+            .addGroupBy("member.id"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "membership_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(membership)
+            .createQueryBuilder("membership")
+            .select("status.id", "statusId")
+            .addSelect("status.status", "status")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect("salutation.salutation", "memberSalutation")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .addSelect(
+              "CONCAT('_', FROM_DAYS(SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))))",
+              "durationInYears"
+            )
+            .leftJoin("membership.status", "status")
+            .leftJoin("membership.member", "member")
+            .leftJoin("member.salutation", "salutation")
+            .groupBy("status.id")
+            .addGroupBy("member.id"),
+      }),
+      true
+    );
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.dropView("membership_view");
+    await queryRunner.dropView("member_executive_positions_view");
+    await queryRunner.dropView("member_qualifications_view");
+    await queryRunner.dropView("member_view");
+
+    await queryRunner.createView(
+      new View({
+        name: "member_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(member)
+            .createQueryBuilder("member")
+            .select("member.id", "id")
+            .addSelect("member.salutation", "salutation")
+            .addSelect("member.firstname", "firstname")
+            .addSelect("member.lastname", "lastname")
+            .addSelect("member.nameaffix", "nameaffix")
+            .addSelect("member.birthdate", "birthdate")
+            .addSelect("TIMESTAMPDIFF(YEAR, member.birthdate, CURDATE())", "todayAge")
+            .addSelect("YEAR(CURDATE()) - YEAR(member.birthdate)", "ageThisYear")
+            .addSelect("CONCAT('_', FROM_DAYS(TIMESTAMPDIFF(DAY, member.birthdate, CURDATE())))", "exactAge"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "member_executive_positions_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(memberExecutivePositions)
+            .createQueryBuilder("memberExecutivePositions")
+            .select("executivePosition.id", "positionId")
+            .addSelect("executivePosition.position", "position")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.salutation", "memberSalutation")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, memberExecutivePositions.start, COALESCE(memberExecutivePositions.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .leftJoin("memberExecutivePositions.executivePosition", "executivePosition")
+            .leftJoin("memberExecutivePositions.member", "member")
+            .groupBy("executivePosition.id"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "member_qualifications_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(memberQualifications)
+            .createQueryBuilder("memberQualifications")
+            .select("qualification.id", "qualificationId")
+            .addSelect("qualification.qualification", "qualification")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.salutation", "memberSalutation")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, memberQualifications.start, COALESCE(memberQualifications.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .leftJoin("memberQualifications.qualification", "qualification")
+            .leftJoin("memberQualifications.member", "member")
+            .groupBy("qualification.id"),
+      }),
+      true
+    );
+    await queryRunner.createView(
+      new View({
+        name: "membership_view",
+        expression: (datasource: DataSource) =>
+          datasource
+            .getRepository(membership)
+            .createQueryBuilder("membership")
+            .select("status.id", "statusId")
+            .addSelect("status.status", "status")
+            .addSelect("member.id", "memberId")
+            .addSelect("member.salutation", "memberSalutation")
+            .addSelect("member.firstname", "memberFirstname")
+            .addSelect("member.lastname", "memberLastname")
+            .addSelect("member.nameaffix", "memberNameaffix")
+            .addSelect("member.birthdate", "memberBirthdate")
+            .addSelect(
+              "SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))",
+              "durationInDays"
+            )
+            .addSelect(
+              "CONCAT('_', FROM_DAYS(SUM(TIMESTAMPDIFF(DAY, membership.start, COALESCE(membership.end, CURRENT_DATE)))))",
+              "durationInYears"
+            )
+            .leftJoin("membership.status", "status")
+            .leftJoin("membership.member", "member")
+            .groupBy("status.id")
+            .addGroupBy("member.id"),
+      }),
+      true
+    );
+  }
+}
--- a/src/migrations/1737816852011-moveSendNewsletterFlag.ts
+++ b/src/migrations/1737816852011-moveSendNewsletterFlag.ts
@ -0,0 +1,71 @@
+import { MigrationInterface, QueryRunner, TableColumn, TableForeignKey, TableIndex } from "typeorm";
+import { communication } from "../entity/club/member/communication";
+import { member } from "../entity/club/member/member";
+
+export class MoveSendNewsletterFlag1737816852011 implements MigrationInterface {
+  name = "MoveSendNewsletterFlag1737816852011";
+
+  public async up(queryRunner: QueryRunner): Promise<void> {
+    const table = await queryRunner.getTable("member");
+    const foreignKey = table.foreignKeys.find((fk) => fk.columnNames.indexOf("sendNewsletterId") !== -1);
+    await queryRunner.dropForeignKey("member", foreignKey);
+
+    await queryRunner.addColumn(
+      "communication",
+      new TableColumn({ name: "isSendNewsletter", type: "tinyint", isNullable: false, default: 0 })
+    );
+
+    // ! has to be sql. Else no data is returned.
+    const member_newsletter_send = await queryRunner.query("SELECT sendNewsletterId, id FROM `member` `member`");
+
+    for (let assigned of member_newsletter_send.map((mns: any) => ({
+      id: mns.id,
+      sendNewsletterId: mns.sendNewsletterId,
+    })) as Array<{ id: number; sendNewsletterId: number }>) {
+      await queryRunner.manager
+        .getRepository(communication)
+        .createQueryBuilder("communication")
+        .update({ isSendNewsletter: true })
+        .where({ memberId: assigned.id, id: assigned.sendNewsletterId })
+        .execute();
+    }
+
+    await queryRunner.dropColumn("member", "sendNewsletterId");
+  }
+
+  public async down(queryRunner: QueryRunner): Promise<void> {
+    await queryRunner.addColumn(
+      "member",
+      new TableColumn({ name: "sendNewsletterId", type: "int", isNullable: true, isUnique: true, default: null })
+    );
+
+    const member_newsletter_send = await queryRunner.manager
+      .getRepository(communication)
+      .createQueryBuilder("communication")
+      .where("communication.isSendNewsletter = :isSendNewsletter", { isSendNewsletter: true })
+      .getMany();
+
+    for (let assigned of member_newsletter_send.map((mns: any) => ({
+      id: mns.id,
+      memberId: mns.memberId,
+    })) as Array<{ id: number; memberId: number }>) {
+      await queryRunner.query("UPDATE `member` SET sendNewsletterId = ? WHERE id = ?", [
+        assigned.id,
+        assigned.memberId,
+      ]);
+    }
+
+    await queryRunner.createForeignKey(
+      "member",
+      new TableForeignKey({
+        columnNames: ["sendNewsletterId"],
+        referencedColumnNames: ["id"],
+        referencedTableName: "communication",
+        onDelete: "SET NULL",
+        onUpdate: "RESTRICT",
+      })
+    );
+
+    await queryRunner.dropColumn("communication", "isSendNewsletter");
+  }
+}
--- a/src/routes/admin/club/member.ts
+++ b/src/routes/admin/club/member.ts
@ -1,36 +1,38 @@
 import express, { Request, Response } from "express";
 import {
-    addAwardToMember,
-    addCommunicationToMember,
-    addExecutivePositionToMember,
-    addMembershipToMember,
-    addQualificationToMember,
-    createMember,
-    createMemberPrintoutList,
-    deleteAwardOfMember,
-    deleteCommunicationOfMember,
-    deleteExecutivePositionOfMember,
-    deleteMemberById,
-    deleteMembershipOfMember,
-    deleteQualificationOfMember,
-    getAllMembers,
-    getAwardByMemberAndRecord,
-    getAwardsByMember,
-    getCommunicationByMemberAndRecord,
-    getCommunicationsByMember,
-    getExecutivePositionByMemberAndRecord,
-    getExecutivePositionsByMember,
-    getMemberById,
-    getMembershipByMemberAndRecord,
-    getMembershipsByMember,
-    getQualificationByMemberAndRecord,
-    getQualificationsByMember,
-    updateAwardOfMember,
-    updateCommunicationOfMember,
-    updateExecutivePositionOfMember,
-    updateMemberById,
-    updateMembershipOfMember,
-    updateQualificationOfMember,
+  addAwardToMember,
+  addCommunicationToMember,
+  addExecutivePositionToMember,
+  addMembershipToMember,
+  addQualificationToMember,
+  createMember,
+  createMemberPrintoutList,
+  deleteAwardOfMember,
+  deleteCommunicationOfMember,
+  deleteExecutivePositionOfMember,
+  deleteMemberById,
+  deleteMembershipOfMember,
+  deleteQualificationOfMember,
+  getAllMembers,
+  getAwardByMemberAndRecord,
+  getAwardsByMember,
+  getCommunicationByMemberAndRecord,
+  getCommunicationsByMember,
+  getExecutivePositionByMemberAndRecord,
+  getExecutivePositionsByMember,
+  getMemberById,
+  getMembershipByMemberAndRecord,
+  getMembershipsByMember,
+  getMembershipStatisticsById,
+  getMemberStatisticsById,
+  getQualificationByMemberAndRecord,
+  getQualificationsByMember,
+  updateAwardOfMember,
+  updateCommunicationOfMember,
+  updateExecutivePositionOfMember,
+  updateMemberById,
+  updateMembershipOfMember,
+  updateQualificationOfMember,
 } from "../../../controller/admin/club/memberController";
 import PermissionHelper from "../../../helpers/permissionHelper";

@ -44,14 +46,22 @@ router.get("/:id", async (req: Request, res: Response) => {
  await getMemberById(req, res);
 });

+router.get("/:id/statistics", async (req: Request, res: Response) => {
+  await getMemberStatisticsById(req, res);
+});
+
 router.get("/print/namelist", async (req: Request, res: Response) => {
-    await createMemberPrintoutList(req, res);
+  await createMemberPrintoutList(req, res);
 });

 router.get("/:memberId/memberships", async (req: Request, res: Response) => {
  await getMembershipsByMember(req, res);
 });

+router.get("/:memberId/memberships/statistics", async (req: Request, res: Response) => {
+  await getMembershipStatisticsById(req, res);
+});
+
 router.get("/:memberId/membership/:id", async (req: Request, res: Response) => {
  await getMembershipByMemberAndRecord(req, res);
 });
--- a/src/routes/admin/index.ts
+++ b/src/routes/admin/index.ts
@ -6,6 +6,7 @@ import communicationType from "./settings/communicationType";
 import executivePosition from "./settings/executivePosition";
 import membershipStatus from "./settings/membershipStatus";
 import qualification from "./settings/qualification";
+import salutation from "./settings/salutation";
 import calendarType from "./settings/calendarType";
 import queryStore from "./settings/queryStore";
 import template from "./settings/template";
@ -21,6 +22,8 @@ import newsletter from "./club/newsletter";
 import role from "./user/role";
 import user from "./user/user";
 import invite from "./user/invite";
+import api from "./user/webapi";
+import preventWebapiAccess from "../../middleware/preventWebApiAccess";

 var router = express.Router({ mergeParams: true });

@ -41,6 +44,7 @@ router.use(
  membershipStatus
 );
 router.use("/qualification", PermissionHelper.passCheckMiddleware("read", "settings", "qualification"), qualification);
+router.use("/salutation", PermissionHelper.passCheckMiddleware("read", "settings", "salutation"), salutation);
 router.use("/calendartype", PermissionHelper.passCheckMiddleware("read", "settings", "calendar_type"), calendarType);
 router.use("/querystore", PermissionHelper.passCheckMiddleware("read", "settings", "query_store"), queryStore);
 router.use("/template", PermissionHelper.passCheckMiddleware("read", "settings", "template"), template);
@ -60,5 +64,6 @@ router.use("/newsletter", PermissionHelper.passCheckMiddleware("read", "club", "
 router.use("/role", PermissionHelper.passCheckMiddleware("read", "user", "role"), role);
 router.use("/user", PermissionHelper.passCheckMiddleware("read", "user", "user"), user);
 router.use("/invite", PermissionHelper.passCheckMiddleware("read", "user", "user"), invite);
+router.use("/webapi", preventWebapiAccess, PermissionHelper.passCheckMiddleware("read", "user", "webapi"), api);

 export default router;
--- a/src/routes/admin/settings/newsletterConfig.ts
+++ b/src/routes/admin/settings/newsletterConfig.ts
@ -1,6 +1,5 @@
 import express, { Request, Response } from "express";
 import {
-  deleteNewsletterConfig,
  getAllNewsletterConfigs,
  getNewsletterConfigById,
  setNewsletterConfig,
@ -25,12 +24,4 @@ router.put(
  }
 );

-router.delete(
-  "/:comTypeId",
-  PermissionHelper.passCheckMiddleware("create", "settings", "newsletter_config"),
-  async (req: Request, res: Response) => {
-    await deleteNewsletterConfig(req, res);
-  }
-);
-
 export default router;
--- a/src/routes/admin/settings/salutation.ts
+++ b/src/routes/admin/settings/salutation.ts
@ -0,0 +1,45 @@
+import express, { Request, Response } from "express";
+import {
+  createSalutation,
+  deleteSalutation,
+  getAllSalutations,
+  getSalutationById,
+  updateSalutation,
+} from "../../../controller/admin/settings/salutationController";
+import PermissionHelper from "../../../helpers/permissionHelper";
+
+var router = express.Router({ mergeParams: true });
+
+router.get("/", async (req: Request, res: Response) => {
+  await getAllSalutations(req, res);
+});
+
+router.get("/:id", async (req: Request, res: Response) => {
+  await getSalutationById(req, res);
+});
+
+router.post(
+  "/",
+  PermissionHelper.passCheckMiddleware("create", "settings", "salutation"),
+  async (req: Request, res: Response) => {
+    await createSalutation(req, res);
+  }
+);
+
+router.patch(
+  "/:id",
+  PermissionHelper.passCheckMiddleware("update", "settings", "salutation"),
+  async (req: Request, res: Response) => {
+    await updateSalutation(req, res);
+  }
+);
+
+router.delete(
+  "/:id",
+  PermissionHelper.passCheckMiddleware("delete", "settings", "salutation"),
+  async (req: Request, res: Response) => {
+    await deleteSalutation(req, res);
+  }
+);
+
+export default router;
--- a/src/routes/admin/user/webapi.ts
+++ b/src/routes/admin/user/webapi.ts
@ -0,0 +1,64 @@
+import express, { Request, Response } from "express";
+import PermissionHelper from "../../../helpers/permissionHelper";
+import {
+  createWebapi,
+  deleteWebapi,
+  getAllWebapis,
+  getWebapiById,
+  getWebapiPermissions,
+  getWebapiTokenById,
+  updateWebapi,
+  updateWebapiPermissions,
+} from "../../../controller/admin/user/webapiController";
+
+var router = express.Router({ mergeParams: true });
+
+router.get("/", async (req: Request, res: Response) => {
+  await getAllWebapis(req, res);
+});
+
+router.get("/:id", async (req: Request, res: Response) => {
+  await getWebapiById(req, res);
+});
+
+router.get("/:id/token", async (req: Request, res: Response) => {
+  await getWebapiTokenById(req, res);
+});
+
+router.get("/:id/permissions", async (req: Request, res: Response) => {
+  await getWebapiPermissions(req, res);
+});
+
+router.post(
+  "/",
+  PermissionHelper.passCheckMiddleware("create", "user", "webapi"),
+  async (req: Request, res: Response) => {
+    await createWebapi(req, res);
+  }
+);
+
+router.patch(
+  "/:id",
+  PermissionHelper.passCheckMiddleware("update", "user", "webapi"),
+  async (req: Request, res: Response) => {
+    await updateWebapi(req, res);
+  }
+);
+
+router.patch(
+  "/:id/permissions",
+  PermissionHelper.passCheckMiddleware("admin", "user", "webapi"),
+  async (req: Request, res: Response) => {
+    await updateWebapiPermissions(req, res);
+  }
+);
+
+router.delete(
+  "/:id",
+  PermissionHelper.passCheckMiddleware("delete", "user", "webapi"),
+  async (req: Request, res: Response) => {
+    await deleteWebapi(req, res);
+  }
+);
+
+export default router;
--- a/src/routes/index.ts
+++ b/src/routes/index.ts
@ -13,6 +13,12 @@ import reset from "./reset";
 import auth from "./auth";
 import admin from "./admin/index";
 import user from "./user";
+import detectPWA from "../middleware/detectPWA";
+import webapi from "./webapi";
+import authenticateAPI from "../middleware/authenticateAPI";
+import server from "./server";
+import PermissionHelper from "../helpers/permissionHelper";
+import preventWebapiAccess from "../middleware/preventWebApiAccess";

 export default (app: Express) => {
  app.set("query parser", "extended");
@ -25,13 +31,16 @@ export default (app: Express) => {
  app.use(cors());
  app.options("*", cors());

+  app.use(detectPWA);
  app.use("/api/public", publicAvailable);
-  app.use("/api/setup", allowSetup, setup);
-  app.use("/api/reset", reset);
-  app.use("/api/invite", invite);
-  app.use("/api/auth", auth);
+  app.use("/api/setup", preventWebapiAccess, allowSetup, setup);
+  app.use("/api/reset", preventWebapiAccess, reset);
+  app.use("/api/invite", preventWebapiAccess, invite);
+  app.use("/api/auth", preventWebapiAccess, auth);
+  app.use("/api/webapi", authenticateAPI, webapi);
  app.use(authenticate);
  app.use("/api/admin", admin);
-  app.use("/api/user", user);
+  app.use("/api/user", preventWebapiAccess, user);
+  app.use("/api/server", preventWebapiAccess, PermissionHelper.isAdminMiddleware(), server);
  app.use(errorHandler);
 };
--- a/src/routes/server.ts
+++ b/src/routes/server.ts
@ -0,0 +1,35 @@
+import express, { Request, Response } from "express";
+import { FileSystemHelper } from "../helpers/fileSystemHelper";
+import Parser from "rss-parser";
+
+var router = express.Router({ mergeParams: true });
+
+router.get("/version", async (req: Request, res: Response) => {
+  let serverPackage = FileSystemHelper.readTemplateFile("/package.json");
+  let serverJson = JSON.parse(serverPackage);
+  res.send({
+    name: serverJson.name,
+    description: serverJson.description,
+    version: serverJson.version,
+    author: serverJson.author,
+    license: serverJson.license,
+  });
+});
+
+router.get("/settings", async (req: Request, res: Response) => {
+  res.json({});
+});
+
+router.get("/serverrss", async (req: Request, res: Response) => {
+  const parser = new Parser();
+  let feed = await parser.parseURL("https://forgejo.jk-effects.cloud/Ehrenamt/ff-admin-server/releases.rss");
+  res.json(feed);
+});
+
+router.get("/clientrss", async (req: Request, res: Response) => {
+  const parser = new Parser();
+  let feed = await parser.parseURL("https://forgejo.jk-effects.cloud/Ehrenamt/ff-admin/releases.rss");
+  res.json(feed);
+});
+
+export default router;
--- a/src/routes/webapi.ts
+++ b/src/routes/webapi.ts
@ -0,0 +1,10 @@
+import express, { Request, Response } from "express";
+import { getWebApiAccess } from "../controller/webapiController";
+
+var router = express.Router({ mergeParams: true });
+
+router.get("/retrieve", async (req: Request, res: Response) => {
+  await getWebApiAccess(req, res);
+});
+
+export default router;
--- a/src/service/club/calendarService.ts
+++ b/src/service/club/calendarService.ts
@ -12,6 +12,7 @@ export default abstract class CalendarService {
      .getRepository(calendar)
      .createQueryBuilder("calendar")
      .leftJoinAndSelect("calendar.type", "type")
+      .orderBy("starttime", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/club/member/communicationService.ts
+++ b/src/service/club/member/communicationService.ts
@ -14,8 +14,8 @@ export default abstract class CommunicationService {
      .createQueryBuilder("communication")
      .leftJoinAndSelect("communication.type", "communicationType")
      .leftJoinAndSelect("communication.member", "member")
-      .leftJoinAndSelect("member.sendNewsletter", "sendNewsletter")
      .where("communication.memberId = :memberId", { memberId: memberId })
+      .orderBy("communicationType.type", "ASC")
      .getMany()
      .then((res) => {
        return res;
@ -37,7 +37,6 @@ export default abstract class CommunicationService {
      .createQueryBuilder("communication")
      .leftJoinAndSelect("communication.type", "communicationType")
      .leftJoinAndSelect("communication.member", "member")
-      .leftJoinAndSelect("member.sendNewsletter", "sendNewsletter")
      .where("communication.memberId = :memberId", { memberId: memberId })
      .andWhere("communication.id = :recordId", { recordId: recordId })
      .getOneOrFail()
--- a/src/service/club/member/memberAwardService.ts
+++ b/src/service/club/member/memberAwardService.ts
@ -14,6 +14,7 @@ export default abstract class MemberAwardService {
      .createQueryBuilder("memberAwards")
      .leftJoinAndSelect("memberAwards.award", "award")
      .where("memberAwards.memberId = :memberId", { memberId: memberId })
+      .orderBy("award.award", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/club/member/memberExecutivePositionService.ts
+++ b/src/service/club/member/memberExecutivePositionService.ts
@ -14,6 +14,8 @@ export default abstract class MemberExecutivePositionService {
      .createQueryBuilder("memberExecutivePositions")
      .leftJoinAndSelect("memberExecutivePositions.executivePosition", "executivePosition")
      .where("memberExecutivePositions.memberId = :memberId", { memberId: memberId })
+      .orderBy("executivePosition.position", "ASC")
+      .addOrderBy("memberExecutivePositions.start", "DESC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/club/member/memberQualificationService.ts
+++ b/src/service/club/member/memberQualificationService.ts
@ -14,6 +14,7 @@ export default abstract class MemberQualificationService {
      .createQueryBuilder("memberQualifications")
      .leftJoinAndSelect("memberQualifications.qualification", "qualification")
      .where("memberQualifications.memberId = :memberId", { memberId: memberId })
+      .orderBy("qualification.qualification", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/club/member/memberService.ts
+++ b/src/service/club/member/memberService.ts
@ -2,13 +2,26 @@ import { dataSource } from "../../../data-source";
 import { member } from "../../../entity/club/member/member";
 import { membership } from "../../../entity/club/member/membership";
 import InternalException from "../../../exceptions/internalException";
+import { memberView } from "../../../views/memberView";

 export default abstract class MemberService {
  /**
   * @description get all members
   * @returns {Promise<[Array<member>, number]>}
   */
-  static async getAll(offset: number = 0, count: number = 25, search: string = ""): Promise<[Array<member>, number]> {
+  static async getAll({
+    offset = 0,
+    count = 25,
+    search = "",
+    noLimit = false,
+    ids = [],
+  }: {
+    offset?: number;
+    count?: number;
+    search?: string;
+    noLimit?: boolean;
+    ids?: Array<number>;
+  }): Promise<[Array<member>, number]> {
    let query = dataSource
      .getRepository(member)
      .createQueryBuilder("member")
@ -26,8 +39,6 @@ export default abstract class MemberService {
      )
      .leftJoinAndSelect("membership_first.status", "status_first")
      .leftJoinAndSelect("membership_last.status", "status_last")
-      .leftJoinAndSelect("member.sendNewsletter", "sendNewsletter")
-      .leftJoinAndSelect("sendNewsletter.type", "communicationtype")
      .leftJoinAndMapMany(
        "member.preferredCommunication",
        "member.communications",
@ -35,8 +46,16 @@ export default abstract class MemberService {
        "preferredCommunication.preferred = 1"
      )
      .leftJoinAndSelect("preferredCommunication.type", "communicationtype_preferred")
+      .leftJoinAndMapOne(
+        "member.sendNewsletter",
+        "member.communications",
+        "sendNewsletter",
+        "sendNewsletter.isSendNewsletter = 1"
+      )
+      .leftJoinAndSelect("sendNewsletter.type", "communicationtype")
      .leftJoinAndMapMany("member.smsAlarming", "member.communications", "smsAlarming", "smsAlarming.isSMSAlarming = 1")
-      .leftJoinAndSelect("smsAlarming.type", "communicationtype_smsAlarming");
+      .leftJoinAndSelect("smsAlarming.type", "communicationtype_smsAlarming")
+      .leftJoinAndSelect("member.salutation", "salutation");

    if (search != "") {
      search.split(" ").forEach((term, index) => {
@ -54,9 +73,15 @@ export default abstract class MemberService {
      });
    }

+    if (ids.length != 0) {
+      query = query.where({ id: ids });
+    }
+
+    if (!noLimit) {
+      query = query.offset(offset).limit(count);
+    }
+
    return await query
-      .offset(offset)
-      .limit(count)
      .orderBy("member.lastname")
      .addOrderBy("member.firstname")
      .addOrderBy("member.nameaffix")
@ -92,18 +117,23 @@ export default abstract class MemberService {
      )
      .leftJoinAndSelect("membership_first.status", "status_first")
      .leftJoinAndSelect("membership_last.status", "status_last")
-      .leftJoinAndSelect("member.sendNewsletter", "sendNewsletter")
-      .leftJoinAndSelect("sendNewsletter.type", "communicationtype")
      .leftJoinAndMapMany(
        "member.preferredCommunication",
        "member.communications",
        "preferredCommunication",
        "preferredCommunication.preferred = 1"
      )
-
+      .leftJoinAndSelect("preferredCommunication.type", "communicationtype_preferred")
+      .leftJoinAndMapOne(
+        "member.sendNewsletter",
+        "member.communications",
+        "sendNewsletter",
+        "sendNewsletter.isSendNewsletter = 1"
+      )
+      .leftJoinAndSelect("sendNewsletter.type", "communicationtype")
      .leftJoinAndMapMany("member.smsAlarming", "member.communications", "smsAlarming", "smsAlarming.isSMSAlarming = 1")
      .leftJoinAndSelect("smsAlarming.type", "communicationtype_smsAlarming")
-      .leftJoinAndSelect("preferredCommunication.type", "communicationtype_preferred")
+      .leftJoinAndSelect("member.salutation", "salutation")
      .where("member.id = :id", { id: id })
      .getOneOrFail()
      .then((res) => {
@ -114,23 +144,45 @@ export default abstract class MemberService {
      });
  }

+  /**
+   * @description get member statistics by id
+   * @param {number} id
+   * @returns {Promise<memberView>}
+   */
+  static async getStatisticsById(id: number): Promise<memberView> {
+    return await dataSource
+      .getRepository(memberView)
+      .createQueryBuilder("memberView")
+      .where("memberView.id = :id", { id: id })
+      .getOneOrFail()
+      .then((res) => {
+        return res;
+      })
+      .catch((err) => {
+        throw new InternalException("memberView not found by id", err);
+      });
+  }
+
  /**
   * @description get members where membership is setz
   * @returns {Promise<member>}
   */
  static async getByRunningMembership(): Promise<Array<member>> {
    return await dataSource
-        .getRepository(member)
-        .createQueryBuilder("member")
-        .leftJoinAndSelect("member.memberships", "membership")
-        .where("membership.end IS NULL")
-        .getMany()
-        .then((res) => {
-          return res;
-        })
-        .catch((err) => {
-          throw new InternalException("member not found by id", err);
-        });
+      .getRepository(member)
+      .createQueryBuilder("member")
+      .leftJoinAndSelect("member.memberships", "membership")
+      .where("membership.end IS NULL")
+      .orderBy("member.lastname")
+      .addOrderBy("member.firstname")
+      .addOrderBy("member.nameaffix")
+      .getMany()
+      .then((res) => {
+        return res;
+      })
+      .catch((err) => {
+        throw new InternalException("member not found by id", err);
+      });
  }

  /**
@ -142,7 +194,12 @@ export default abstract class MemberService {
    return await dataSource
      .getRepository(member)
      .createQueryBuilder("member")
-      .leftJoinAndSelect("member.sendNewsletter", "sendNewsletter")
+      .leftJoinAndMapOne(
+        "member.sendNewsletter",
+        "member.communications",
+        "sendNewsletter",
+        "sendNewsletter.isSendNewsletter = 1"
+      )
      .where("member.id = :id", { id: id })
      .getOneOrFail()
      .then((res) => {
--- a/src/service/club/member/membershipService.ts
+++ b/src/service/club/member/membershipService.ts
@ -1,6 +1,7 @@
 import { dataSource } from "../../../data-source";
 import { membership } from "../../../entity/club/member/membership";
 import InternalException from "../../../exceptions/internalException";
+import { membershipView } from "../../../views/membershipsView";

 export default abstract class MembershipService {
  /**
@ -45,4 +46,23 @@ export default abstract class MembershipService {
        throw new InternalException("member membership not found by id", err);
      });
  }
+
+  /**
+   * @description get membership statistics by memberId
+   * @param {number} memberId
+   * @returns {Promise<Array<membershipView>>}
+   */
+  static async getStatisticsById(memberId: number): Promise<Array<membershipView>> {
+    return await dataSource
+      .getRepository(membershipView)
+      .createQueryBuilder("membershipView")
+      .where("membershipView.memberId = :memberId", { memberId: memberId })
+      .getMany()
+      .then((res) => {
+        return res;
+      })
+      .catch((err) => {
+        throw new InternalException("membershipView not found by id", err);
+      });
+  }
 }
--- a/src/service/settings/awardService.ts
+++ b/src/service/settings/awardService.ts
@ -12,6 +12,7 @@ export default abstract class AwardService {
    return await dataSource
      .getRepository(award)
      .createQueryBuilder("award")
+      .orderBy("award", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/calendarTypeService.ts
+++ b/src/service/settings/calendarTypeService.ts
@ -11,6 +11,7 @@ export default abstract class CalendarTypeService {
    return await dataSource
      .getRepository(calendarType)
      .createQueryBuilder("calendarType")
+      .orderBy("type", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/communicationTypeService.ts
+++ b/src/service/settings/communicationTypeService.ts
@ -11,6 +11,7 @@ export default abstract class CommunicationTypeService {
    return await dataSource
      .getRepository(communicationType)
      .createQueryBuilder("communicationType")
+      .orderBy("type", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/executivePositionService.ts
+++ b/src/service/settings/executivePositionService.ts
@ -12,6 +12,7 @@ export default abstract class ExecutivePositionService {
    return await dataSource
      .getRepository(executivePosition)
      .createQueryBuilder("executivePosition")
+      .orderBy("position", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/membershipStatusService.ts
+++ b/src/service/settings/membershipStatusService.ts
@ -12,6 +12,7 @@ export default abstract class MembershipStatusService {
    return await dataSource
      .getRepository(membershipStatus)
      .createQueryBuilder("membershipStatus")
+      .orderBy("status", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/newsletterConfigService.ts
+++ b/src/service/settings/newsletterConfigService.ts
@ -13,6 +13,7 @@ export default abstract class NewsletterConfigService {
      .getRepository(newsletterConfig)
      .createQueryBuilder("newsletterConfig")
      .leftJoinAndSelect("newsletterConfig.comType", "comType")
+      .orderBy("comType.type", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/qualification.ts
+++ b/src/service/settings/qualification.ts
@ -13,6 +13,7 @@ export default abstract class QualificationService {
    return await dataSource
      .getRepository(qualification)
      .createQueryBuilder("qualification")
+      .orderBy("qualification", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/queryStoreService.ts
+++ b/src/service/settings/queryStoreService.ts
@ -11,6 +11,7 @@ export default abstract class QueryStoreService {
    return await dataSource
      .getRepository(query)
      .createQueryBuilder("queryStore")
+      .orderBy("title", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/src/service/settings/salutationService.ts
+++ b/src/service/settings/salutationService.ts
@ -0,0 +1,41 @@
+import { dataSource } from "../../data-source";
+import { salutation } from "../../entity/settings/salutation";
+import InternalException from "../../exceptions/internalException";
+
+export default abstract class SalutationService {
+  /**
+   * @description get all salutations
+   * @returns {Promise<Array<salutation>>}
+   */
+  static async getAll(): Promise<Array<salutation>> {
+    return await dataSource
+      .getRepository(salutation)
+      .createQueryBuilder("salutation")
+      .orderBy("salutation", "ASC")
+      .getMany()
+      .then((res) => {
+        return res;
+      })
+      .catch((err) => {
+        throw new InternalException("salutations not found", err);
+      });
+  }
+
+  /**
+   * @description get salutation by id
+   * @returns {Promise<salutation>}
+   */
+  static async getById(id: number): Promise<salutation> {
+    return await dataSource
+      .getRepository(salutation)
+      .createQueryBuilder("salutation")
+      .where("salutation.id = :id", { id: id })
+      .getOneOrFail()
+      .then((res) => {
+        return res;
+      })
+      .catch((err) => {
+        throw new InternalException("salutation not found by id", err);
+      });
+  }
+}
--- a/src/service/settings/templateService.ts
+++ b/src/service/settings/templateService.ts
@ -12,6 +12,7 @@ export default abstract class TemplateService {
    return await dataSource
      .getRepository(template)
      .createQueryBuilder("template")
+      .orderBy("template", "ASC")
      .getMany()
      .then((res) => {
        return res;
--- a/Show more
+++ b/Show more
Author	SHA1	Message	Date
Julian Krauser	1d9970fc56	1.2.2	2025-01-31 11:42:55 +01:00
Julian Krauser	29be563942	Merge pull request 'patches: v1.2.2' (#56 ) from develop into main Reviewed-on: #56	2025-01-31 10:42:32 +00:00
Julian Krauser	fc694aa976	change: newsletter saving	2025-01-31 11:40:59 +01:00
Julian Krauser	7c08251ff6	fix: views drop view is exists	2025-01-27 16:26:00 +01:00
Julian Krauser	7a3a8a9d87	1.2.1	2025-01-27 15:20:22 +01:00
Julian Krauser	3165eb789f	Merge pull request 'patches v1.2.1' (#54 ) from develop into main Reviewed-on: #54	2025-01-27 14:19:55 +00:00
Julian Krauser	ebe587756a	fix: member get by ids	2025-01-27 15:16:12 +01:00
Julian Krauser	b678067874	Merge pull request 'feature/#37-salutation' (#52 ) from feature/#37-salutation into develop Reviewed-on: #52	2025-01-25 11:21:58 +00:00
Julian Krauser	eb78934959	service and query builder	2025-01-25 12:16:20 +01:00
Julian Krauser	1ab4d93d2b	salutation CRUD and controller	2025-01-25 11:58:10 +01:00
Julian Krauser	b55d0554e4	migration update	2025-01-25 11:39:34 +01:00
Julian Krauser	21cf811a56	change salutation to separate table	2025-01-25 10:20:57 +01:00
Julian Krauser	ff651b7d8f	fix: prevent deletion of owner	2025-01-24 09:20:08 +01:00
Julian Krauser	d9132e472b	1.2.0	2025-01-23 13:15:14 +01:00
Julian Krauser	c661a588c5	Merge pull request 'minor v1.2.0' (#51 ) from develop into main Reviewed-on: #51	2025-01-23 12:14:24 +00:00
Julian Krauser	3beeec38f9	Merge pull request 'feature/#43-server-version' (#50 ) from feature/#43-server-version into develop Reviewed-on: #50	2025-01-23 10:59:21 +00:00
Julian Krauser	3d8f1da059	provide server version and rss feeds	2025-01-23 11:21:54 +01:00
Julian Krauser	bbfdc69049	Merge pull request 'feature/#22-API-Tokens' (#49 ) from feature/#22-API-Tokens into develop Reviewed-on: #49	2025-01-22 10:59:46 +00:00
Julian Krauser	a165231c47	jwt gen & rename fixes	2025-01-22 11:57:19 +01:00
Julian Krauser	313785b4ac	renaming api module to webapi	2025-01-22 09:39:31 +01:00
Julian Krauser	0b40b9d92c	permissions & routes with middleware	2025-01-22 09:27:15 +01:00
Julian Krauser	d3870b4c8d	Merge pull request 'feature/#32-Membership-statistics' (#48 ) from feature/#32-Membership-statistics into develop Reviewed-on: #48	2025-01-22 08:06:26 +00:00
Julian Krauser	ba2155d7c3	fix types and params	2025-01-22 08:59:38 +01:00
Julian Krauser	07d31bfe7d	member and membership statistics	2025-01-21 14:49:14 +01:00
Julian Krauser	4568bef10e	api Controller & token	2025-01-21 13:54:52 +01:00
Julian Krauser	36ecccd0dc	controller & factory	2025-01-21 11:47:28 +01:00
Julian Krauser	3f0549bd44	api & permission services and commandHandler	2025-01-21 11:37:28 +01:00
Julian Krauser	ca6dbafaf1	extend api table by id	2025-01-21 11:25:26 +01:00
Julian Krauser	26d2f288e9	add api tables with permission	2025-01-21 11:03:48 +01:00
Julian Krauser	3e256dc2f7	1.1.1	2025-01-20 12:49:04 +01:00
Julian Krauser	bf5aec351c	Merge pull request 'patches v1.1.1' (#46 ) from develop into main Reviewed-on: #46	2025-01-20 11:48:30 +00:00
Julian Krauser	0bbe22e9ae	fix: undefined value on ids search	2025-01-20 12:25:57 +01:00
Julian Krauser	9734149848	extend controller for search	2025-01-20 09:44:03 +01:00
Julian Krauser	28e05c70a9	1.1.0	2025-01-19 13:57:59 +01:00
Julian Krauser	1116b50773	Merge pull request 'minor: v1.1.0' (#45 ) from develop into main Reviewed-on: #45	2025-01-19 12:56:41 +00:00
Julian Krauser	8b59f3b7a8	Merge branch 'main' into develop	2025-01-19 12:56:31 +00:00
Julian Krauser	2d8e8a2e42	Merge pull request 'feature/#40-protocol-presence-status' (#44 ) from feature/#40-protocol-presence-status into develop Reviewed-on: #44	2025-01-19 12:46:46 +00:00
Julian Krauser	eb8f3fef3e	update template	2025-01-19 13:42:18 +01:00
Julian Krauser	b5509ba162	update controller and syncing	2025-01-19 13:19:50 +01:00
Julian Krauser	4dd6fa6d8a	add excused state to protocol presence	2025-01-19 13:14:12 +01:00
Julian Krauser	a4b26013a7	weburl change	2025-01-18 14:58:32 +01:00
Julian Krauser	c803c2a583	1.0.2	2025-01-13 11:23:16 +01:00
Julian Krauser	ba03b6f097	Merge pull request 'patches v1.0.2' (#39 ) from develop into main Reviewed-on: #39	2025-01-13 10:22:29 +00:00
Julian Krauser	e738be4e13	change: update entity files	2025-01-13 11:16:35 +01:00
Julian Krauser	c9b8c3090d	fix: end date update date error	2025-01-13 10:38:44 +01:00
Julian Krauser	a2cc408e85	change: remove unused command	2025-01-13 10:38:25 +01:00
Julian Krauser	d206d7a77c	enhance: provide more details to command delete error	2025-01-13 10:37:53 +01:00
Julian Krauser	03036c8b77	add: sort data	2025-01-12 18:17:54 +01:00
Julian Krauser	1c6c123142	fix: stream newsletter progress to client	2025-01-12 13:21:34 +01:00
Julian Krauser	e1f6b36336	change: removed dev logging	2025-01-12 11:41:22 +01:00
Julian Krauser	916a6da4a0	enhance: allow extended refresh duration to PWAs	2025-01-12 11:41:02 +01:00
Julian Krauser	b1e949dce2	enhance: detect requests of pwa	2025-01-11 14:45:37 +01:00
Julian Krauser	69134b210a	1.0.1	2025-01-10 12:10:33 +01:00
Julian Krauser	0f7516bd3d	Merge pull request 'patches v1.0.1' (#38 ) from develop into main Reviewed-on: #38	2025-01-10 11:10:00 +00:00
Julian Krauser	632a8290ac	wrapping up: membership id transfer	2025-01-10 12:06:24 +01:00
Julian Krauser	c173f917e3	fix: possibly undefined newsletter com	2025-01-10 11:26:48 +01:00
Julian Krauser	55d4a952c3	change: minimize logging on custom errors	2025-01-09 12:38:07 +01:00
Julian Krauser	03cc0f02b7	fix: member sorting at active members	2025-01-08 18:09:22 +01:00