Added source_trade, source and specialise to more columns and set as searchable columns

Accelerates (at least) Person's jump_to_accounting action.

The category uid should be passed to the query. With this, is possible generate queries like stock.project_uid is NULL.

This script is intended to replace Base_getCurrencyForSection and support
properly the case where there are more than one currency.
Start using it in accounting module view and grouping reference dialog.

- we only want to sum transaction in the period when there is a from date.
- when from date is passed, really get period start date from from date

Some Constraint Property Sheets and Views in core bt5s were defining
properties whose Portal Types (and sometimes their Views as well) were
available in a non-core bt5s.

and remove AccountingTransactionLine_getParentUrl which is not used

This reverts commit 5ec2f886.

Signed-off-by: Arnaud Fontaine <arnaud.fontaine@nexedi.com>

- columns are now searchable
- title display line title if any; for consistency with all other reports
- title is no longer sortable properly. This is a little regression.
- use queries instead of raw where expression

We should also support the case where user cannot access project module

The same grouping reference property is also used for mirror section, so if one side is doing grouping, the group must also be valid for the other side.

omit_balanced_accounts was always displaying 1
omit_empty_accounts should not exist

To display the list of possible accounts we include validated nodes and  nodes that have been previously used on accounting movements. We include 2, because we want the user to be able to issue a report on a node that has been used in the past and is now invalidated.

The problem with this approach is that such query is very slow, when there are a lot of Movements.

Then, with the commit only validated accounts will be considered

This commit is part of 0ee6eae7.

The script ERP5Site_getWorkflowStateItemList that receives the portal type and the state variable (simulation_state/validation_state) as parameters and it will returns the states for the workflow chained to the portal type

With this, is possible set custom references without overwrite accounting_workflow

The new approach is a script named ERP5Site_getWorkflowStateItemList that receives the portal type and the state variable (simulation_state/validation_state) as parameters and it will returns the states for the workflow chained to the portal type. This way all the standard dialogs works out of the box even if you customize a workflow chain

erp5_simulation should not be required for erp5_trade and erp5_accounting as some system do not use simulation.

By changing the section one can enter accounting transaction lines on a
different section bypassing the security because usually only the section at
the transaction level is taken into account for roles assignements.

It is useless to clear the cache in activities, because this would only work when using only one zope instance. Instead, clear the cache in the test for now.

Also add support for own section title and count method.
Update configurator accordingly