<?php

declare(strict_types=1);

namespace App\Domain\Account;

/*
CREATE TABLE `account` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customerId` bigint DEFAULT NULL,
  `mitarbeiternr` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `vorname` varchar(200) DEFAULT NULL,
  `email` varchar(200) DEFAULT NULL,
  `passwordHash` varchar(200) DEFAULT NULL,
  `isVerified` tinyint(1) DEFAULT '0',
  `verificationToken` varchar(80) DEFAULT NULL,
  `createdAt` datetime DEFAULT NULL,
  `avatarURL` varchar(200) DEFAULT NULL,
  `username` varchar(200) DEFAULT NULL,
  `type` set('APP_USER','BACKEND_USER') DEFAULT NULL,
  `role` enum('ADMIN','WORK_PREPARER','PROJECT_MANAGER','EMPLOYEE','VISITOR') NOT NULL DEFAULT 'EMPLOYEE',
  `accountgroupid` int DEFAULT NULL COMMENT 'group in company',
  `isDeleted` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;


"id": 5,
  "customerId": 1,
  "mitarbeiternr": null,
  "name": "test",
  "vorname": "Test",
  "email": "test@test.de",
  "passwordHash": "$2y$10$To3sYR0gMSLRoY3HA1v/N.LhrWbw/7PstRy/gVzuS6w5zZ07YpABy",
  "isVerified": 0,
  "verificationToken": "IbYgmawZvFiU7aFbdmi0fCLLwi1NRBttjLGQhaGalZ302arTmXVij1k63QAvZCJa",
  "createdAt": "2023-06-29 15:19:03",
  "avatarURL": null,
  "username": "test",
  "type": "APP_USER",
  "role": "EMPLOYEE",
  "accountgroupid": 1,
  "isDeleted": 0,
*/

class Account
{
    public static array $modifiableColumns = [
        'customerId',
        'mitarbeiternr',
        'name',
        'vorname',
        'email',
        'passwordHash',
        'isVerified',
        'verificationToken',
        'createdAt',
        'avatarURL',
        'username',
        'type',
        'role',
        'accountgroupid',
        'isDeleted',
        'gruppe',
        'sollstunden',
        'stundensatz',
        'auszahlung',
        'auszahlungReeleWS',
        'jahresurlaub',
        'arbeitszeitmodell',
        'auszahlungMonat'
    ];
}