Fix bug in struct filter variable evaluation

When a search contains a struct variable expression for filtering and
the variable references a schema that is not assigned to the current
search but has

Fix bug in struct filter variable evaluation

When a search contains a struct variable expression for filtering and
the variable references a schema that is not assigned to the current
search but has a column with the same name like one from the assigned
schemas, the evaluation of the variable doesn't return the correct
value.

This patch fixes the bug by ensuring that findColumn() returns false
in case the requested schema wasn't found within the assigned schemas.

To make sure the behavior of other callers of findColumn() remains the
same, we introduce a parameter 'strict' to trigger this new behavior
in applyFilterVarsStruct().

There is also a unit test added in a separate commit that explicitely
checks this case.

Signed-off-by: Frieder Schrempf <dev@fris.de>

show more ...

Add an event for custom aggregation table rendering

In order to let plugins provide custom rendering of aggregation data,
we add an event PLUGIN_STRUCT_RENDER_AGGREGATION_TABLE.

Signed-off-by: Frie

Add an event for custom aggregation table rendering

In order to let plugins provide custom rendering of aggregation data,
we add an event PLUGIN_STRUCT_RENDER_AGGREGATION_TABLE.

Signed-off-by: Frieder Schrempf <dev@fris.de>

show more ...

Fix code style violations

Eliminate warnings in PHP 8

Never load serial data in page editor

fixes #535

Previously the page data editor pulled anything from the database associated with the current page id and having rev <= current timestamp. This incl

Never load serial data in page editor

fixes #535

Previously the page data editor pulled anything from the database associated with the current page id and having rev <= current timestamp. This included serial data with rev = 0, which are now excluded.

show more ...

added spaces around the IN operator

Only update page metadata on new revision

Implements a basic comparison of page revisions before update. We used to write to the database on every rendering just because PARSER_METADATA_RENDER is th

Only update page metadata on new revision

Implements a basic comparison of page revisions before update. We used to write to the database on every rendering just because PARSER_METADATA_RENDER is the only event that supplies all the required metadata. An additional database query is better than the redundant save.

Fixes #528

show more ...

Keep serial data intact when revisioning page data with the same schema and id

Remove deselected data in multi fields (serial and global)

Because we were replacing data on update, old values were not deleted.
Now we explicitly clear them before saving new data.

Simpler check for an empty string

Allow deleting all values from a multi field in inline editor

Fixes #439

Puts a mechanism in place to delete any previous values when saving an
empty multi field. This does NOT apply to page data,

Allow deleting all values from a multi field in inline editor

Fixes #439

Puts a mechanism in place to delete any previous values when saving an
empty multi field. This does NOT apply to page data, which is versioned
and should not be deleted on update.

show more ...

refactoring names

To avoid confusion with the Lookup type, the three different ways of
accessing a schema have now the following names:

* page data - for revisioned struct data attached to a page
*

refactoring names

To avoid confusion with the Lookup type, the three different ways of
accessing a schema have now the following names:

* page data - for revisioned struct data attached to a page
* serial data - for an unrevisioned list of struct data attached to a
page
* global data - for an unrevisioned list of struct data not attached to
any page (formaly known as lookup schema)

The editor mechanism used for serial and global data is now called
AggregationEditor

Some reference to lookup schemas is still in the bureaucracy support
part.

show more ...

Create pages when importing serial data

Introduce new factory methods for data access and deprecate old ones

Fix code style violations

Replace hand-crafted SQL queries in CSV import with calls to AccessTable* save methods

Add forgotten grouping column to search queries

This should have been done long ago when rid was introduced

More sensitive check for which version of schema should be loaded

Try not to duplicate data saving methods

Prepare to use unified schema in admin CSV export/import

Fix code style violations

Replace hand-crafted SQL queries in CSV import with calls to AccessTable* save methods

Add forgotten grouping column to search queries

This should have been done long ago when rid was introduced

More sensitive check for which version of schema should be loaded

WIP Try not to duplicate data saving methods