espocrm

File: /tank/omv/docker/espocrm/html/custom/Espo/Custom/Resources/metadata/entityDefs/Lead.json

{
    "fields": {
        "cAngebotsdokument": {
            "type": "file",
            "sourceList": [],
            "accept": [],
            "tooltip": true,
            "isCustom": true
        }
    },
    "links": {
        "cAngebotsdokument": {
            "type": "belongsTo",
            "entity": "Attachment",
            "skipOrmDefs": true,
            "utility": true
        },
        "leadObjekte": {
            "type": "hasMany",
            "entity": "CObjekt",
            "foreign": "lead"
        }
    }
}


File: /tank/omv/docker/espocrm/html/custom/Espo/Custom/Resources/metadata/entityDefs/CObjekt.json

{
    "fields": {
        "name": {
            "type": "varchar",
            "required": true,
            "pattern": "$noBadCharacters"
        },
        "description": {
            "type": "text"
        },
        "createdAt": {
            "type": "datetime",
            "readOnly": true
        },
        "modifiedAt": {
            "type": "datetime",
            "readOnly": true
        },
        "createdBy": {
            "type": "link",
            "readOnly": true,
            "view": "views/fields/user"
        },
        "modifiedBy": {
            "type": "link",
            "readOnly": true,
            "view": "views/fields/user"
        },
        "assignedUser": {
            "type": "link",
            "required": false,
            "view": "views/fields/assigned-user"
        },
        "teams": {
            "type": "linkMultiple",
            "view": "views/fields/teams"
        },
        "objektAdresse": {
            "type": "address",
            "viewMap": true,
            "tooltip": true,
            "isCustom": true
        },
        "checkinSystem": {
            "type": "enum",
            "options": [
                "Schlüsselbox",
                "Nuki",
                "Manuell"
            ],
            "default": "Schlüsselbox",
            "tooltip": true,
            "maxLength": 100,
            "isCustom": true
        },
        "baujahr": {
            "type": "int",
            "tooltip": true,
            "isCustom": true
        },
        "genehmigungsstatusZweckentfremdung": {
            "type": "multiEnum",
            "storeArrayValues": true,
            "default": [],
            "options": [
                "Angefragt",
                "Genehmigt",
                "Verweigert"
            ],
            "tooltip": true,
            "isCustom": true
        },
        "zweckentfremdungGeklrt": {
            "type": "bool",
            "tooltip": true,
            "isCustom": true
        },
        "genehmigungsrisiko": {
            "type": "varchar",
            "maxLength": 255,
            "tooltip": true,
            "isCustom": true
        },
        "brandschutzGeprft": {
            "type": "bool",
            "tooltip": true,
            "isCustom": true
        },
        "brandschutzOK": {
            "type": "bool",
            "tooltip": true,
            "isCustom": true
        },
        "capexBudget": {
            "type": "currency",
            "tooltip": true,
            "isCustom": true
        },
        "capexSchtzung": {
            "type": "currency",
            "tooltip": true,
            "isCustom": true
        },
        "revPARLift": {
            "type": "float",
            "tooltip": true,
            "isCustom": true
        }
    },
    "links": {
        "createdBy": {
            "type": "belongsTo",
            "entity": "User"
        },
        "modifiedBy": {
            "type": "belongsTo",
            "entity": "User"
        },
        "assignedUser": {
            "type": "belongsTo",
            "entity": "User"
        },
        "teams": {
            "type": "hasMany",
            "entity": "Team",
            "relationName": "entityTeam",
            "layoutRelationshipsDisabled": true
        },

        // Already available and FUNCTIONING:
        "account": {
            "type": "belongsTo",
            "entity": "Account",
            "foreign": "objekte"
        },

        // Already available and FUNCTIONING (m:n):
        "lieferanten": {
            "type": "hasMany",
            "entity": "CLieferant",
            "relationName": "cObjektCLieferant"
        },

        // NEW: Link to Lead (Interessent)
        "lead": {
            "type": "belongsTo",
            "entity": "Lead",
            "foreign": "leadObjekte"
        },

        // NEW: all cases/damage to this object
        "cases": {
            "type": "hasMany",
            "entity": "Case",
            "foreign": "objekt"
        }
    },
    "collection": {
        "orderBy": "createdAt",
        "order": "desc"
    },
    "indexes": {
        "name": {
            "columns": [
                "name",
                "deleted"
            ]
        },
        "assignedUser": {
            "columns": [
                "assignedUserId",
                "deleted"
            ]
        },
        "createdAt": {
            "columns": [
                "createdAt"
            ]
        },
        "createdAtId": {
            "unique": true,
            "columns": [
                "createdAt",
                "id"
            ]
        }
    }
}


File: /tank/omv/docker/espocrm/html/custom/Espo/Custom/Resources/metadata/entityDefs/CLieferant.json

{
    "fields": {
        "name": {
            "type": "varchar",
            "required": true,
            "pattern": "$noBadCharacters"
        },
        "description": {
            "type": "text"
        },
        "createdAt": {
            "type": "datetime",
            "readOnly": true
        },
        "modifiedAt": {
            "type": "datetime",
            "readOnly": true
        },
        "createdBy": {
            "type": "link",
            "readOnly": true,
            "view": "views/fields/user"
        },
        "modifiedBy": {
            "type": "link",
            "readOnly": true,
            "view": "views/fields/user"
        },
        "assignedUser": {
            "type": "link",
            "required": false,
            "view": "views/fields/assigned-user"
        },
        "teams": {
            "type": "linkMultiple",
            "view": "views/fields/teams"
        },
        "lieferantenkategorie": {
            "type": "enum",
            "options": [
                "Reinigung",
                "Wäscheservice",
                "Hausmeister",
                "Schlüsseldienst"
            ],
            "default": "Reinigung",
            "tooltip": true,
            "isCustom": true
        },
        "kostenstellen": {
            "type": "varchar",
            "tooltip": true,
            "isCustom": true
        },
        "zahlungszielTage": {
            "type": "int",
            "tooltip": true,
            "isCustom": true
        },
        "reaktionszeitVereinbart": {
            "type": "varchar",
            "tooltip": true,
            "isCustom": true
        },
        "notfallNummer": {
            "type": "varchar",
            "tooltip": true,
            "isCustom": true
        },
        "einsatzfenster": {
            "type": "varchar",
            "tooltip": true,
            "isCustom": true
        },
        "vertragsdokument": {
            "type": "file",
            "sourceList": [],
            "accept": [],
            "tooltip": true,
            "isCustom": true
        }
    },
    "links": {
        "createdBy": {
            "type": "belongsTo",
            "entity": "User"
        },
        "modifiedBy": {
            "type": "belongsTo",
            "entity": "User"
        },
        "assignedUser": {
            "type": "belongsTo",
            "entity": "User"
        },
        "teams": {
            "type": "hasMany",
            "entity": "Team",
            "relationName": "entityTeam",
            "layoutRelationshipsDisabled": true
        },
        "vertragsdokument": {
            "type": "belongsTo",
            "entity": "Attachment",
            "skipOrmDefs": true,
            "utility": true
        },
        // m:n to objects – I already had that
        "objekte": {
            "type": "hasMany",
            "entity": "CObjekt",
            "relationName": "cObjektCLieferant"
        },
        // NEU: all instances of this Lieferanten
        "cases": {
            "type": "hasMany",
            "entity": "Case",
            "foreign": "lieferant"
        }
    },
    "collection": {
        "orderBy": "createdAt",
        "order": "desc"
    }
}


New File: /tank/omv/docker/espocrm/html/custom/Espo/Custom/Resources/metadata/entityDefs/Case.json

{
    "fields": {},
    "links": {
        "objekt": {
            "type": "belongsTo",
            "entity": "CObjekt"
        },
        "account": {
            "type": "belongsTo",
            "entity": "Account"
        },
        "lieferant": {
            "type": "belongsTo",
            "entity": "CLieferant"
        }
    }
}