wegmeister/databasestorage

此包添加了将表单(或其他输入)的输入存储到数据库并导出存储数据为xlsx的功能。

2.0.4 2024-07-29 10:03 UTC

README

此包添加了将表单提交存储到数据库并将存储数据导出为xlsx、xls、ods、csv或html的功能。

安装

要安装此包,请简单地运行

composer require wegmeister/databasestorage

使用方法

您可以通过以下方式添加DatabaseStorage Finisher:

使用YAML定义添加DatabaseStorage

在表单定义/yaml文件中添加DatabaseStorage finisher

type: 'Neos.Form:Form'
identifier: 'some-identifier'
label: 'My form'
renderables:
  # Your renderables / form fields go here

finishers:
  -
    identifier: 'Wegmeister.DatabaseStorage:DatabaseStorageFinisher'
    options:
      # The identifier is used to group your data in the database.
      # You should avoid using the same identifier twice or your data could become a little messed up.
      identifier: 'my-form-data'

使用Neos表单构建器添加DatabaseStorage

您还可以使用Neos.Form.Builder与DatabaseStorage一起使用。您应该能够简单地添加DatabaseStorage作为表单的finisher。

不要忘记设置一个(唯一的)identifier

使用Fusion表单添加DatabaseStorage

您还可以使用Neos.Fusion.Form操作。

将以下配置添加到您的表单操作定义中

databaseStorage {
    type = '\\Wegmeister\\DatabaseStorage\\FusionForm\\Runtime\\Action\\DatabaseStorageAction'
    options {
        identifier = 'identifier-in-backend'
        formValues = ${data}
    }
}

可用设置

以下设置可用,并可由您的Settings.yaml覆盖。

Wegmeister:
  DatabaseStorage:
    # Creator name of the exported files
    creator: 'die wegmeister gmbh'
    # Title for the exported files
    title: 'Database Export'
    # Subject for the exported files
    subject: 'Database Export'
    # DateTime format if the datetime is included in the export
    datetimeFormat: 'Y-m-d H:i:s'
    # Form element types that should not be stored by the finisher (for Node-based forms)
    nodeTypesIgnoredInFinisher:
      - 'Neos.Form.Builder:Section'
      - 'Neos.Form.Builder:StaticText'
    # Form element types that should not be part of the export (for Node-based forms)
    nodeTypesIgnoredInExport:
      - 'Neos.Form.Builder:Section'
      - 'Neos.Form.Builder:StaticText'
      - 'Neos.Form.Builder:Password'
      - 'Neos.Form.Builder:PasswordWithConfirmation'