If strict_language is False, a document having the other language is
chosen if the specified language one is missing.

all_languages=True returns results grouped by (reference, language) so
that we can have several documents for a single reference.

strict_language=False returns results grouped by (reference,) only,
with considering the language priority, thus we have only one document
for a single reference.

catalog: portal_type=None or effective_date=None should mean the good default value in SQLCatalog_getDocumentValueList.

so that the utility script calling this can have arguments like
portal_type=None, **kw and have code like
getDocumentValue(portal_type=portal_type, **kw).

Sections must be in table order: table_0 and table_1 in first section, then
table_3, then table_4 and query_table must be in last query section.

No related key should hardcode "catalog" table name (or any other table
name, for that matter), so just let column mapper work.

Also, simplify code flow by removing unnecessary "if" statements.
Also, simplify returned query tree by removing unnecessary intermediate
ComplexQueries.

Fixed bug reported by nexedi/erp5@a5a2f1cd (comment 38674)

/reviewed-on nexedi/erp5!363

In the previous version, I pass the `editable` parameter on the homepage. This is not work anymore due to other people's changes(possibly due to 6a893b8d and/or 19028f05). After read his code, I move the `editable` to the `gadget_supportrequest_fast_view_dialog_js` page.

One part working on {base_category_id: [document_value_set]}, and the other
producing that structure out of a flat list of (base_category_id-prefixed)
category relative urls.
The former used to be included in the latter, but in some case caller
already has the documents handy instead of only urls, in which case we can
avoid a layer of document lookups.

Site template sections are created without any predicate criterion.
It happens to currently work, but for the wrong reasons. Arm this flag
instead.

follow_up/1 is an invalid relation. follow_up/project_module/1 is a valid
relation.

multimedia contains Sound and Video

Allows producing SQL for inclusion in ZSQLMethods where catalog table would
be already aliased.

registerCatalog method must be avoided whenever possible.

This method only returns caller's input, with catalog schema applied, so
it does not expose data, so "private" is too restrictive.

Add dependency on erp5_item to get now-required related keys.

If the following configuration section is present:

<product-config initsite>
  owner <user-id>
  id <site-id>
  <key> <value>
</product-config>

the ERP5 product automatically creates a site at startup if there's none.
This is done by "extending" AppInitializer (OFS.Application).

<key> is any string parameter accepted by manage_addERP5Site, including new
ones to configure Cloudooo and install bt5. Cloudooo is often required by the
configurator: apart from that, it does not deserve a field on the addERP5Site
form.

This deprecates erp5_promise, at least in its current form, for several reasons:

- Since 7fe14b20, alarms aren't run often
  enough.

- For the configuration of external services like memcached, using an alarm or
  anything not instantaneous to update them is wrong because it poses a risk to
  connect to wrong instances. erp5_promise does not handle the catalog because
  it could not and we have another mechanism for that (userhosts), so let's
  handle other services like the catalog.

- The list of bt5 to have installed is only useful at site creation:
  - either (usually) to install configurators, which in turn decide of the list
    to have installed,
  - or a value provided the user, but SlapOS parameters aren't a place to
    duplicate the ERP5 UI.

- With previous commit, the list of bt5 repositories does not depend anymore
  on the location of the software built by SlapOS, and we also don't want to
  duplicate the UI, so the only case where it would remain useful is when the
  list is changed by the software itself, which almost never happens.
  We'll reimplement the promise as a constraint when necessary.

We end up with the minimum functionality to install a configurator
automatically, and the user does not have to wait anymore for an alarm to be
triggered.

The default site preference in erp5_core does not come anymore with a default
value that was specific to SlapOS. It was not enough for our needs and such
setting should anyway go in a system preference.

Commit 929ac90a and 0de0acb3 use the text editor from `app.officejs.com`. Which is not same domain as the main application. When Selenium tests run with Firefox. If Firefox visit a page which contains an iframe from another domain, it is unable to redirect to another link and complaints `Permission denied to access property "href"`. In order to make the test get pass on the server with FIrefox. Revert the changes the that two commits which described above.

This reverts commit 6e58cc8f.

This was freezing some processes on test nodes. I revert during
bug investigation.

In some cases, a Person.password could be a string instead of
None or PersistentMapping. If string, the code was raising
TypeError.

This reverts commit 9befc11a

Moved the SystemPreference_viewHumanResource form to the erp5_hr template so it is available in other erp5_hr based business templates.

/reviewed-on nexedi/erp5!361

for same reasons as 3954133f users
sometimes want a report with not so many details by in spreadsheet
format.