fixup! AccountingTransactionModule_getAccountingTransactionList: Workaround poor column mapping for reference filtering.

Use a single query for count and stat methods, caching the result in request
(for lack of a better idea).
Also, stop defining editable columns, as listbox auto-detects such fields
anyway.

AccountingTransactionModule_getAccountingTransactionList: Workaround poor column mapping for reference filtering.

node_category adds a join with catalog which tends to be preferred by query
optimiser over the agrgegate relation (because there are fewer accounts than
there are aggregared documents), which makes displaying a payment group
proportional to the number of payments on the accoutns instead of
proportional to current group's related aggregate list.
Also, drop parent_portal_type condition, as payment lines aggregated to a
group should be children of a Payment Transaction (and it saves one more
join - although much less costly than the node_category one).
Also, make aggregate relation condition strict (there should be no group
sub-objects from which we would want to get related aggregates).

This allows to have a nice default behavior for isDeletable without
the need to bother which arguments we can pass.

Also, make isDeletable of simulation movement supporting keyword arguments
to avoid failures when generic action checking isDeletable is called

The criterion is on indexation_timestamp, not creation date

business process could be acquired from parent, here we only want to select a transformation

mrp: consumption view on production orders, use getAggregatedAmountList and avoid displaying unused variation

Previous code was looking to transformation and checking object inside, but now we have
getAggregatedAmountList which is able to greatly do this job.

Also, do not show stock of variations we are not consuming, it could be very disturbing.

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 nexedi/erp5!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