General mechanisms to provide notifications for users after database changes.

Analysis of ten reasonably small PDFs takes 24.6 seconds. This makes it difficult to use such features in a responsive web app. The feature is still very useful for offline analysis though.

User requirement / use case:

• Entity is based on existing entity (e.g. Document or Reservation) but needs project specific adaptations (e.g. Plan-Identifier or various project-specific fields such as TestBench etc.). These project specific adaptations change over time.

Requirements:

• Allow configuring additional fields for an entity
• Additional fields can be of type: free-text (single line), text (text field), select (pre-defined, configured values), date, entity (select referring to other, existing entity)
• Additional fields may be dependent on each other (mainly select type), with choices dependent on selected parent field choice ➡️ postpone
• Additional fields may have access rights defined on them (e.g. for select, certain selectable values only available to certain groups / users)
• Additional fields should be populated in index pages of entities to which they are attached
• Additional fields may be required dependent on status (e.g. when creating a Reservation, only a subset of fields is mandatory; When assigning a reservation to the supplier, more fields are mandatory; When assigning a reservation back to the customer, all fields are required) ➡️ postpone

We need to identify:

• Is there a bundle available that solves this?
• If not, do we implement this in CUBE Common Bundle?

• allow to generate a filter url: EmchBerger/projectassistant#753
• allow to save and load filters (in usersettings)
• allow to define filters for everybody (from config or ...)
• auto-generate query from filterdata for simple cases (needs custom attributes like dbTable and dbColumn in filter elements)
• special handling for pre-formatted (as html) values (from xxxEditor)
  generate a glob query which ignores formatting
• To be verified: Return variables directly as $qb->expr()->literal($variable)
• allow filtering for empty value (no text, no choice selected, no date) https://github.com/EmchBerger/projectassistant/issues/375
• ...

Changes of associated entities of the same type should not be displayed.

... and apply in ProjectAssistant and TestManager consequently

Leading to a crash of the application in dev mode.

• method for displaying flag boolean values
• method for displaying null values
• method supporting translation

Write general logic for handling subscriptions. Each subscription is made, when condition associated with it is fulfilled. Then configured message with configured reports for specified recipients is send.

The value for associations is at maximum 255 characters in length (because of column label length in audit_log).
We should at least indicate a shortened value in history.

This generates problems with html code. It is returned incomplete.
Possibilities to handle this case:

• clean up (shortened) html strings with tidy: https://secure.php.net/manual/en/tidy.examples.php#89334
• do not show (all) html formatting: {{ some_html\|striptags('<br><p>') }} {# only keep br and p #}
• do not show all html formatting for shortened texts
• show full value (must be read separately from audit_log)

The changes in the association (when entity is owning side) are only shown when the association is dissociated and associated on the owner.

This is no issue often because

• The associations values (almost) never changes (like tag names)
• The entity is the inverse side (this is handled differently)
• The association is associated and dissociated on every entity change

Because we are improving in associate +dissociate, this bug begins to show up.

When using cube-common-bundle in another project, I get the error message as follows:

The service "cube_common.excel.converter" has a dependency on a non-existent service "phpexcel".


I assume this is missing in the composer.json as dependency.
Version: 1.0.21

When the associations have changed (in the class), DataDogAudit::getAttributeNameForNtoN() throws a ContextErrorException in dev mode.

Possibilities:

• just warn when this happens
• show a note in the audit log (do indicate that something is missing)
• other method to get the correct attribute name
• ...

An exception has been thrown during the rendering of a template ("The _controller value "AppBundle:Dashboard:getGitVersion" maps to a "AppBundle\Controller\DashboardController" class, but this class was not found. Create this class or check the spelling of the class and its namespace.").

Version: 1.0.21

https://github.com/EmchBerger/cube-common-bundle/blame/master/src/DataHandling/CollectionHandler.php#L140 fails when a custom field is of type DateTime.

This has been implemented with #66.

Implement the missing functionality for using in pa:

• load defaults from parameters (defaultUserConfig.colsSelect.SIMILAR_TO_CONTROLLER_NAME)
• do it compatible to https://github.com/EmchBerger/projectassistant/issues/1392 drag-n-drop-table-columns
• ... ?

Possibility to filter serialized or simple array.

In order to dynamically provide columns and rows for Excel reports.

https://github.com/EmchBerger/cube-common-bundle/blob/master/src/DataHandling/Logs/DataDogAudit.php#L26

--> suggest to use constant "KEY_UNCHANGED" instead of KEY_LEFT and suggest to use value "unchanged" for this constant.

• Why are there releases on development branch? Specifically 8e0f0cc
• Why do we have v1.0 branch but no other version branches? I assume: We will create a version branch for v2 (suggest omitting .0) once it exists.
• If my assumption above is not correct: Why are there no branches for v1.1, v1.2, ...?

Configuration:

• make services used outside of Cube Common Bundle public (by default they would be private)
  ("cube_common.filtering", "cube_common.project_version")

Modifying dynamically a table with hidden columns should work automatically or with simple helpers.

maybe

• provide a convenient function to filter the new rows (before inserting)
• do hiding automatically
  • add a change listener to the table (slow)
  • set column to visible collapse, is not supported by many browsers
  • set style in stylesheet (with stylesheet.addRule(), rule.selectorText = xxx, ...)
    set class to each hidable column optionally (when colspan is used)
    https://davidwalsh.name/add-rules-stylesheets
• do column filtering on server side (how??? hiding in twig (macro in filterHelper), read current state in Controller??? )

Entities containing a method called "historicizedFields" (or similar) and contain a field "entityHistory" can be logged with 2 simple calls:

• before changing the entity, initialize the entityHistory service with the entity. Before flushing, pass the entity again with the new status. The service will return an array with the diff and update the entityHistory field of the entity.

Library can get info about:

• size of pages
• format of pages
• which pages are in color

Used for example by making notifications for associated entities.

For each row of a grouped column (same xxxCol class), a separate checkbox is shown. Only show one for all of them.

https://github.com/EmchBerger/projectassistant/issues/1625

• ColSelection: colSelCloseBtn "Close" (line 224 in cubecommon.js)
• Logs: initial change entry when entity exists before activating audit bundle ("UNKNOWN USER", "unknown document versions before")

Implement handling of audit data gathered by DataDogAuditBundle.