[FIX] hr_timesheet_sheet - search sheet_id for attendance using date in users timezone. As attendances depends on timezone but timesheet have from and to date instead of datetime we have to change the attendance to the same timezone expected for timesheet. And as a Timesheet belongs to a user, we can expect this timesheet to be in the same timezone as its owner. Maybe a timezone field should be added on timesheet. In anycase it make no sense to have all timesheet forced with start and end date as UTC.
[IMP] hr_timesheet_sheet - remove unused variable
[IMP] hr_timesheet_sheet - simplify and improve readability in search for sheet_ids
[IMP] hr_timesheet_sheet - set default timezone as UTC if employee has none
[FIX] hr_timesheet_sheet - remove useless call to AT TIME ZONE in psql request here it isn't current_date but an utc 'timestamp' date. Need a strong tea even if it isn't utc tea time.
[FIX]Fixed the issue of mimetype not detected properly, used python mimetypes module to detect file's mimitype.
Launchpad automatic translations update.
[UPD]
[UPD] resolve conflicts with main branch and fix bug introduced in rev 10015 lp:1313622
[MERGE] [FIX] hr_timesheet_sheet: make it timezone tolerant and avoid errors when comparing datetime and dates, courtesy of Yannick Vaucher (Camptocamp)

The attendance date recieved by the server is in UTC while the user sees it in his timezone. This means that an attendance could be in a timesheet (bounded by dates) for a user but not for the server which would not accept a valid attendance.
The fix will make the check in the user's timezone.

Only the date part of the attendance is kept for comparison as the boundaries are dates objects.
Launchpad automatic translations update.
[FIX] stock: destination location should not be limited to internal as this wizard is also used for incoming and outgoing pickings (opw 606213)
[MERGE] [FIX] mail: make the detection of Content-Type based on filename instead of only offering 'application/octet-stream'. This allows to have a better detection of the software to use by the browser. opw 606233
[FIX] stock: recompute the qty_available based on the location instead of using the one in the result of the browse (opw 606423)

The qty_available field is a function field that uses the information of the context (eg: location) to compute the value. Using the global browse record would return the same qty_available value for each location (and then produce way too many account.move)
[FIX] stock: when delivering a product in average cost, make sure the price_unit on the stock.move is up to date (opw 607272)
Launchpad automatic translations update.
[FIX] mail: avoid catching (transient) MemoryErrors when sending outgoing mail

This would permanently mark the mail as failed while
there is a good chance it will be sent properly next
time it is retried (provided the memory situation
improves or the server/worker has restarted).
[FIX] stock: when delivering a product in average cost, make sure the price_unit on the stock.move is up to date (opw 607272)

The price mentioned on the stock move from the delivery order is the one at the time of the sale order confirmation. On average price, the price can be different when the delivery is actually done. The price will then be refreshed with the one specified on the product.
[FIX] sign in and sign out were broken in rev 10019 as it doesn't provide a date to conversion of attendance time to employee timezone
[MERGE] [FIX] hr_timesheet_sheet: set default date to now when computing date in user's timezone, courtesy of Yannick Vaucher (Camptocamp)

eg: the sign-in/sign-out button on the employee do not provide date yet (value defined in _defaults) and it would broke the computation