Cherry-pick from dcac4cc0

The partner_ids fields represents attendees but it's confusing to have twice the same field in search view (opw 607275)

website_quote: renamed validity date to expiry date & adapted the sale order report to display the expiry date in website_quote module instead of sale module

[REF] website_quote: displayed string of validity_date field changed from 'Validity Date' to 'Expiry Date'

As the survey hardcode lot's of views and reports in python, we do not beneficiate from automatic timezone conversions in the webclient.
Hopefully this is fixed in v8 after refactoring of the survey module. opw 608786

On child partner creation of a parent partner, the commercial_partner_id is not computed (and stored) in the create method.
Therefore, we should compute the commercial_partner_id before trying to sync his data

The method  _paypal_form_get_invalid_parameters checks that the params passed by the paypal feedback coroborate with the transaction requested by Odoo.

It looks like the 'receiver_id' is not always passed by the paypal feedback. Therefore, we check this param only if it is available in the paypal feeback.

This issue had as side-effect to not validate the paypal transaction, which remained 'draft' permanently.

Fixes an error introduced in f6fb2b69

If any missing or partially incorrect values cause
an exception other than a psycopg2 error, we should
still catch it, rollback that record and report
the error, rather than letting bubble and fail
without any feedback to the user.

Fixes #1485

When we compute the discount of a product to display (result of product_id_change), we compare prices in the currency of the product while we expect prices in the currency of the pricelist. opw 606188

When a record is created, the magic fields (id, create_date,...) are first removed from the vals as the user should not set a value for these.
However if a value for this is given in default value (e.g. defined in an ir.value), the creation would crash (sql error : column specified more than once) as the magic column would be added again.

Same behavior than in saas-5

These parameters are (or should be) irrelevant for
a search_count(), and they could actually break the
result or make it significantly slower (e.g applying
`order` on large tables).
This fixes a performance regression introduced by
0f43032b.

We could also raise an error offset/limit are
passed in combination with count, but that seems
unnecessary.

Also switched to "SELECT count(1)" for the count
query, as it is simpler and just as fast.
We'd get the same perf with * or any constant value,
as in "SELECT count('me in')", but let's keep it
simple ;-)

Will fix problem where opened dropdown list were hidden behind the modal footer

[FIX] mass_mailing: allow to add a user/email to a specific mailing list and not always the last as previously.

There is no reason to propagate the context in those buttons.

Besides, it leads to issues concerning the email template, rendering the wrong res_id because the active_id was wrongly propagated

Same as for rev 4bad513d, the references were not correctly parsed, added missing regex

and without spaces for vat

[FIX] website_customer: check that country id exists before access the name, else traceback when we come from a non existing id via the url/controller