Passa al contenuto
Odoo Menu
  • Accedi
  • Provalo gratis
  • App
    Finanze
    • Contabilità
    • Fatturazione
    • Note spese
    • Fogli di calcolo (BI)
    • Documenti
    • Firma
    Vendite
    • CRM
    • Vendite
    • Punto vendita Negozio
    • Punto vendita Ristorante
    • Abbonamenti
    • Noleggi
    Siti web
    • Configuratore sito web
    • E-commerce
    • Blog
    • Forum
    • Live chat
    • E-learning
    Supply chain
    • Magazzino
    • Produzione
    • PLM
    • Acquisti
    • Manutenzione
    • Qualità
    Risorse umane
    • Dipendenti
    • Assunzioni
    • Ferie
    • Valutazioni
    • Referral dipendenti
    • Parco veicoli
    Marketing
    • Social marketing
    • E-mail marketing
    • SMS marketing
    • Eventi
    • Marketing automation
    • Sondaggi
    Servizi
    • Progetti
    • Fogli ore
    • Assistenza sul campo
    • Helpdesk
    • Pianificazione
    • Appuntamenti
    Produttività
    • Comunicazioni
    • Approvazioni
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    App di terze parti Odoo Studio Piattaforma cloud Odoo
  • Settori
    Retail
    • Libreria
    • Negozio di abbigliamento
    • Negozio di arredamento
    • Alimentari
    • Ferramenta
    • Negozio di giocattoli
    Cibo e ospitalità
    • Bar e pub
    • Ristorante
    • Fast food
    • Pensione
    • Grossista di bevande
    • Hotel
    Agenzia immobiliare
    • Agenzia immobiliare
    • Studio di architettura
    • Edilizia
    • Gestione immobiliare
    • Impresa di giardinaggio
    • Associazione di proprietari immobiliari
    Consulenza
    • Società di contabilità
    • Partner Odoo
    • Agenzia di marketing
    • Studio legale
    • Selezione del personale
    • Audit e certificazione
    Produzione
    • Tessile
    • Metallo
    • Arredamenti
    • Alimentare
    • Birrificio
    • Ditta di regalistica aziendale
    Benessere e sport
    • Club sportivo
    • Negozio di ottica
    • Centro fitness
    • Centro benessere
    • Farmacia
    • Parrucchiere
    Commercio
    • Tuttofare
    • Hardware e assistenza IT
    • Ditta di installazione di pannelli solari
    • Calzolaio
    • Servizi di pulizia
    • Servizi di climatizzazione
    Altro
    • Organizzazione non profit
    • Ente per la tutela ambientale
    • Agenzia di cartellonistica pubblicitaria
    • Studio fotografico
    • Punto noleggio di biciclette
    • Rivenditore di software
    Carica tutti i settori
  • Community
    Apprendimento
    • Tutorial
    • Documentazione
    • Certificazioni 
    • Formazione
    • Blog
    • Podcast
    Potenzia la tua formazione
    • Programma educativo
    • Scale Up! Business Game
    • Visita Odoo
    Ottieni il software
    • Scarica
    • Versioni a confronto
    • Note di versione
    Collabora
    • Github
    • Forum
    • Eventi
    • Traduzioni
    • Diventa nostro partner
    • Servizi per partner
    • Registra la tua società di contabilità
    Ottieni servizi
    • Trova un partner
    • Trova un contabile
    • Incontra un esperto
    • Servizi di implementazione
    • Testimonianze dei clienti
    • Supporto
    • Aggiornamenti
    GitHub Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Richiedi una demo
  • Prezzi
  • Aiuto

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Contabilità
  • Magazzino
  • PoS
  • Progetti
  • MRP
All apps
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
Assistenza

How to get users timezone for python?

Iscriviti

Ricevi una notifica quando c'è un'attività per questo post

La domanda è stata contrassegnata
moduletimezonecontext
1 Rispondi
36084 Visualizzazioni
Avatar
Laura Jarvenpaa

I have created a module which overwrites some functions on leaves management. This function includes getting employee working schedule from contract and calculating leave length based on the contract (In my company there can be leaves that are less than one day) the times provided by working schedule are just in format: {'time_from': 8.00, 'time_to':18:00} so they don't include any kind of timezone information however dates are transformed into utc time when they are inserted to db and when you compare those times with working schedule times you need to correct timezone to user's timezone.

My code is like this and as you see there is three places where 8 is added on dates to fix this timezone problem which is fine now when our openerp is used in utc+8 but in future we plan to enable using our system outside of our LAN and then there may be people located in different timezones using it so this fix won't help in future:

def _get_number_of_days(self, date_from, date_to, cr, uid, ids, employee_id):

    DATETIME_FORMAT = "%Y-%m-%d %H:%M:%S"
    date_from = datetime.datetime.strptime(date_from, DATETIME_FORMAT)
    date_to = datetime.datetime.strptime(date_to, DATETIME_FORMAT)
    timedelta = date_to - date_from
    working_shift = 86400
    diff_day = float();
    if timedelta.days > 1:
        diff_day += timedelta.days - 1

    if(employee_id):
        contract_pool = self.pool.get('hr.contract')
        active_contract_ids= contract_pool.search(cr, uid, [
        '&',
        ('employee_id', '=', employee_id),
        '|',
        '&',
        ('date_start', '<=', date_to),
        '|',
        ('date_end', '>=', date_to),
        ('date_end', '=', False),
        '&',
        '|',
        ('trial_date_start', '=', False),
        ('trial_date_start', '<=', date_to),
        '|',
        ('trial_date_end', '=', False),
        ('trial_date_end', '>=', date_to),
        ])
        if active_contract_ids:
            contract = contract_pool.browse(cr, uid, active_contract_ids[0])

            cr.execute("select hour_from, hour_to from resource_calendar_attendance where calendar_id = %s and dayofweek = %s order by hour_from;", (contract.working_hours.id, str(date_from.isoweekday())))
            start_timetable = cr.dictfetchall()
            if start_timetable:

                start_working_shift = self.pool.get('resource.calendar').working_hours_on_day(cr, uid, contract.working_hours, date_from)

                if start_working_shift:
                    # add 8 hours to fix timezone                                                                                                        
                    start_time = date_from.hour + 8 + float(date_from.minute)/60
                    if date_to.date() == date_from.date():
                        # add 8 hours to fix timezone                                                                                                    
                        end_time = date_to.hour + 8 + float(date_to.minute)/60
                        if start_time < start_timetable[0]['hour_from'] and end_time > start_timetable[len(start_timetable) - 1]['hour_to']:
                            # leave length is one day because it starts before starting hour and ends after ending hour                                  
                            return 1           
                        else:
                            hours = self._calculate_hours_for_working_day(start_timetable, start_time, end_time)
                            return hours / start_working_shift
                    if start_time < start_timetable[0]['hour_from']:
                            # leave length is one day because it starts before starting hour and ends after ending hour                               
                            diff_day += 1
                    else:
                        end_time = float(start_timetable[len(start_timetable) - 1]['hour_to'])
                        hours = self._calculate_hours_for_working_day(start_timetable, start_time, end_time)
                        diff_day += hours / start_working_shift


            cr.execute("select hour_from, hour_to from resource_calendar_attendance where calendar_id = %s and dayofweek = %s order by hour_from;", (contract.working_hours.id, str(date_to.isoweekday())))
            end_timetable = cr.dictfetchall()
            if end_timetable:
                end_working_shift = self.pool.get('resource.calendar').working_hours_on_day(cr, uid, contract.working_hours, date_to)
                if end_working_shift:
                    start_time = float(end_timetable[0]['hour_from'])
                    # add 8 hours to fix timezone                                                                                                        
                    end_time = date_to.hour + 8 + float(date_to.minute)/60
                    if end_time > start_timetable[len(start_timetable) - 1]['hour_to']:
                        # leave length is one day because it starts before starting hour and ends after ending hour                                      
                        diff_day += 1
                    else:
                        hours = self._calculate_hours_for_working_day(end_timetable, start_time, end_time)
                        diff_day += hours / end_working_shift

        else:
            # tell user that employee don't have contract so leaves can't be  calculated                                                                 
            raise osv.except_osv(_('Error'), _('Employee doesn\'t have contract. Leave request can\'t be done.'))
    else:
        diff_day = timedelta.days + float(timedelta.seconds) / working_shift
    return diff_day

Tried to fix this by adding parameter context for onchange function of the date selection and using pytz to transform these times to right timezone:

active_tz = pytz.timezone(context.get("tz","UTC")

this did not work (found this solution from another module but well as their module didn't work properly either it's not too big surprise that this did not work).

0
Avatar
Abbandona
Avatar
Jeroen Mollers
Risposta migliore

To get the user's timezone you could do something like this in your code:

Version 7.0 code:

import pytz
from openerp import SUPERUSER_ID

# get user's timezone
user_pool = self.pool.get('res.users')
user = user_pool.browse(cr, SUPERUSER_ID, uid)
tz = pytz.timezone(user.partner_id.tz) or pytz.utc

# get localized dates
date_from = pytz.utc.localize(datetime.datetime.strptime(date_from, DATETIME_FORMAT)).astimezone(tz)
date_to   = pytz.utc.localize(datetime.datetime.strptime(date_to, DATETIME_FORMAT)).astimezone(tz)

Users that use version 6.1 should change the code line:

tz = pytz.timezone(user.partner_id.tz) or pytz.utc

into code line:

tz = pytz.timezone(user.context_tz) or pytz.utc
4
Avatar
Abbandona
Laura Jarvenpaa
Autore

Thanks this was helpful but at least in version 7 I had to do following modification on your code: user_pool = self.pool.get('res.partner') user = user_pool.browse(cr, SUPERUSER_ID, uid) tz = pytz.timezone(user.tz) or pytz.utc because timezone info is now in res.partner not in res.users and timezone info provided by that table had to be converted into timezone as it is only string. If you add these modifications to your answer I can mark it as right.

Jeroen Mollers

You are correct. My code was for version 6.1. In your suggested modification you retrieve a partner record based on a user's ID. I suggest to modify my original code from "tz = pytz.timezone(user.context_tz) or pytz.utc" to "tz = pytz.timezone(user.partner_id.tz) or pytz.utc". I have modified my original answer and also included the version 6.1 one in case someone is interested in that one.

Laura Jarvenpaa
Autore

Ok, good to know.

Ashish Singh

when we print "date_from" its display like '2014-08-14 05:25:55+05:30' i am using time-zone 'Asia/Kolkata'

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati
Post correlati Risposte Visualizzazioni Attività
time zone is missing in context when a scheduler method is invoked
timezone scheduler context
Avatar
0
ott 16
4420
context not work ???
context
Avatar
Avatar
1
gen 25
2073
Error when importing module Product Bidding In ECommerce in odoo 17
module
Avatar
Avatar
1
lug 24
2605
Missing required value for the field 'Model' (model_id)
module
Avatar
Avatar
1
gen 24
6491
Time zone problem in python
timezone
Avatar
Avatar
2
apr 23
4094
Community
  • Tutorial
  • Documentazione
  • Forum
Open source
  • Scarica
  • Github
  • Runbot
  • Traduzioni
Servizi
  • Hosting Odoo.sh
  • Supporto
  • Aggiornamenti
  • Sviluppi personalizzati
  • Formazione
  • Trova un contabile
  • Trova un partner
  • Diventa nostro partner
Chi siamo
  • La nostra azienda
  • Branding
  • Contattaci
  • Lavora con noi
  • Eventi
  • Podcast
  • Blog
  • Clienti
  • Note legali • Privacy
  • Sicurezza
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo è un gestionale di applicazioni aziendali open source pensato per coprire tutte le esigenze della tua azienda: CRM, Vendite, E-commerce, Magazzino, Produzione, Fatturazione elettronica, Project Management e molto altro.

Il punto di forza di Odoo è quello di offrire un ecosistema unico di app facili da usare, intuitive e completamente integrate tra loro.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now