Some fixme cleanups

Start unifying schema types

Schemas per se are type agnostic, isLookup property is removed. Data is stored and accessed differently based on how it is entered and retrieved.

The crucial change is i

Start unifying schema types

Schemas per se are type agnostic, isLookup property is removed. Data is stored and accessed differently based on how it is entered and retrieved.

The crucial change is introduction of the composite key of pid and rid. Previous page data utilizes rid = 0 to differentiate itself. Other types, notably lookup, have autoincrementing rid.

Database migration is not implemented yet.

show more ...

change prefix from Abstract to Auto

Prefix Summary type with "Abstract" to hide it in Schema Editor.

Fixes #451

name changed, tests provided

This commit introduces additional comparator: "IN" into struct filter. The syntax is:
structfield IN ("a", "b", "c")
This is simply translated into:
structfield = "a" OR structfield = "b" OR stru

This commit introduces additional comparator: "IN" into struct filter. The syntax is:
structfield IN ("a", "b", "c")
This is simply translated into:
structfield = "a" OR structfield = "b" OR structfield = "c"
I've found the IN syntax more readeable in some situations.

show more ...

Merge pull request #390 from solewniczak/feature-lastsummary-field-in-page-schema

Feature %lastsummary% column in page schema

Fix PHP notices

This commit adds '%lastsummary%' special column for page schemas. The column contains the summary of last page revision.

use prefix/postfix for wiki type. fixes #254

The filter mechanism is the same for text and wiki, but inheritance
didn't make sense, so this was moved to a trait instead.

fix: stop OR filters causing problems

The filters coming from syntax should be grouped together in a subgroup
to that OR-filters cannot undo the filters on latest=1 etc.

Since we cannot know in the

fix: stop OR filters causing problems

The filters coming from syntax should be grouped together in a subgroup
to that OR-filters cannot undo the filters on latest=1 etc.

Since we cannot know in the filter function whether there is already a
subgroup for us to use or which to use, the solution was to give the
correct subgroup to the filter function directly.

Instead of adding another parameter to the already long list of
parameters for that function, I have chosen to give the
QueryBuilderWhere a reference back to the original QueryBuilder.

show more ...

use generated table alias in joins. fixes #246

For joining the multi table, we used the colref of the refrenced multi
column in creating the alias of the joined table. But when referencing
multi col

use generated table alias in joins. fixes #246

For joining the multi table, we used the colref of the refrenced multi
column in creating the alias of the joined table. But when referencing
multi columns from different schemas, the colref can be the same for two
columns. This patch now changes it to make use of the
generateTableAlias() method in our query builder, which makes sure all
aliases are unique.

show more ...

Do not allow Lookup Editor on page schemas. fixes #235

feat: Add `%lasteditor%` col in access-aggregation

Add this column to show the user that last edited a page.

SPR-622

sort case insensitive. fixes #203

correctly use cleaned schema name in search. fixes #199

Merge pull request #167 from cosmocode/shownewrow

Show new row and reset form in Lookup Editor

Check every col for Tid == 0

show new row when adding to lookup

This renders the newly created row and adds it dynamically to the
existing table.

Do not hide rows if table is only pid and/or rev

handle empty rows in Search via new mechanism

special columns are not available for lookups

safeguard against lookup mixing in Search

We can not join lookup schemas with any other schema on pid. Which means
we can not allow selecting more than one lookup schema in Search.

Merge branch 'master' into lookups

* master:
output the key not value for unknown option in ConfigParser
media fields need unique IDs. fixes #152
fixed references to old Integer type
removed

Merge branch 'master' into lookups

* master:
output the key not value for unknown option in ConfigParser
media fields need unique IDs. fixes #152
fixed references to old Integer type
removed Integer type
Version upped
fixed problem with multicolumns and made the param name clearer
added missing schema file
when Page uses titles, sorting should use title #146
Decimal type needs to type cast for order and compare #146
make sure pages are assigned in tests
give types a way to influence sorting
add slight shadow for aggregation images
Fixed multi fields for inline editor
test wildcard adding in Search

show more ...

Merge branch 'master' into inlinedit

* master:
media fields need unique IDs. fixes #152
fixed references to old Integer type
removed Integer type
Version upped
fixed problem with multicolu

Merge branch 'master' into inlinedit

* master:
media fields need unique IDs. fixes #152
fixed references to old Integer type
removed Integer type
Version upped
fixed problem with multicolumns and made the param name clearer
added missing schema file
when Page uses titles, sorting should use title #146
Decimal type needs to type cast for order and compare #146
make sure pages are assigned in tests
give types a way to influence sorting
Version upped
diff needs to compare raw values
test wildcard adding in Search

show more ...