Also, remove orginal _getOmitQuery which was dead code, and merge
_buildOmitQuery into its only remaining caller.
Also, factorise two pieces of code generating omit queries.

- Correctly ignore parent_portal_type condition when all possible
  portal types are listed.
  This typically saves one stock-catalog join.
- Expand node_category_uid into lists of node_uids.
  This saves one very costly stock-catalog join, as nodes member of given
  category should typically be the minority, inciting MySQL query optimiser
  to use the index materialising this join, preventing use of actual stock
  indexes.
  As there should be few nodes involved in accounting reports, listing
  them all and passing them to queries should not matter much.

Also, add support for src__ parameter.
Also, assorted coding style improvements, changes and code factorisation.

Also, simplify code a bit while reading it.

Fixes a bug when select_list is present in related_key_dict_passthrough but
group_by_list is not.
Also, reduce the number of code paths.

Also, reduces dependencies on zpt_* skin folders.

folder_contents is only used by this listbox, and is likely a mistake.

In MySQL, boolean columns are tiny ints with values 0 or 1, so just cast
the python bool into an int.

This only apply for running live tests of a test component that defines
multiple classes

You can use for example,
testStandardConfigurationWorkflow.TestStandardConfiguratorWorkflow in
"Tests" field of "Live Tests" dialog to run only
TestStandardConfiguratorWorkflow test class

Caching the current user during the transaction breaks code that changes user.
getSecurityManager().getUser().getId() is anyway already so fast, and it is
here called so rarely, that it's not worth caching the result.

This method is useful by some scripts of erp5_administration

This is newer codemirror with support to jump to line keybinding https://github.com/codemirror/CodeMirror/issues/3030


/cc @isabelle I don't know if this interfere with 53a4b813 

/reviewed-on !98

I used this procedure :

git clone https://github.com/codemirror/CodeMirror.git --branch 5.13.4
cd CodeMirror

# rename edit to cm_edit # see 54087b03
find . -not -path "./.git*" -type f -exec sed -i 's/addon\/edit\//addon\/cm_edit\//g' {} +
git mv addon/edit addon/cm_edit
git commit -a -m "ERP5: rename addon/edit -> addon/cm_edit"

# upload to zope ( note that I had to mkdir addon explicitly, otherwise I had some 409 Conflicts and 500 Internal Server Error that I did not investigate)
lftp http://login:password@172.17.0.2:2200/erp5/portal_skins/erp5_code_mirror/ -e 'rm -rf codemirror ; mkdir codemirror ; quit' &&\
lftp http://login:password@172.17.0.2:2200/erp5/portal_skins/erp5_code_mirror/codemirror/ -e 'mkdir addon; mput -d * */* */*/* */*/*/* ; quit '

# run portal_alarms/check_skin_cache to set http_cache

[erp5_web_renderjs_ui] form_dialog: do not update navigation history if action redirect to the same document

form_list search widget layout is like a search engine search form (text input and search button next to it)

I do not see why we would need to check again that value !=
self.getTitle because this check is already done in edit, and edit
supports edit_order and force_update.

following up 3d42e2b9 reference is used
only when title is not defined

when no title, fallback to reference then id

On a module, only display the portal_type.

Should fix jio.get/put on ERP5 non editable documents

cancel & cancel_action require now View permission

Breadcrumb page is removed and merge into the Tab page.

The document title is now usually an history navigation back link.

add test case in erp5_ui_test

/reviewed-on nexedi/erp5!90