1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
import json
import base64
import re
from odoo import _
strftime_to_spreadsheet_time_format_table = {
"%H": "hh",
"%I": "hh",
"%M": "mm",
"%S": "ss",
}
strftime_to_spreadsheet_dateformat_table = {
"%Y": "yyyy",
"%y": "yy",
"%m": "mm",
"%b": "mmm",
"%B": "mmmm",
"%d": "dd",
"%a": "ddd",
"%A": "dddd",
}
def strftime_format_to_spreadsheet_time_format(strf_format):
"""Convert a strftime format to a spreadsheet time format.
"""
twelve_hour_system = False
parts = []
for part in re.finditer(r"(%.)", strf_format):
symbol = part.group(1)
spreadsheet_symbol = strftime_to_spreadsheet_time_format_table.get(symbol)
if spreadsheet_symbol:
parts.append(spreadsheet_symbol)
if symbol == "%I" or symbol == "%p":
twelve_hour_system = True
separator = re.search(r"(:| )", strf_format)
separator = separator.group(1) if separator else ":"
return separator.join(parts) + (" a" if twelve_hour_system else "")
def strftime_format_to_spreadsheet_date_format(strf_format):
"""Convert a strftime format to a spreadsheet date format.
"""
parts = []
for part in re.finditer(r"(%.)", strf_format):
symbol = part.group(1)
spreadsheet_symbol = strftime_to_spreadsheet_dateformat_table.get(symbol)
if spreadsheet_symbol:
parts.append(spreadsheet_symbol)
separator = re.search(r"(/|-| )", strf_format)
separator = separator.group(1) if separator else "/"
return separator.join(parts)
|
