Passa al contenuto
Menu
È necessario essere registrati per interagire con la community.
La domanda è stata contrassegnata
3 Risposte
1979 Visualizzazioni

hi am in multi company odoo accounting in v.11 i have 13 company each company have user a i want to know how i can  know the connected user in datatbase , i need it for a report that i created.

Avatar
Abbandona
Autore Risposta migliore

thanks for your reponse but am using query clause to create report  and i want to add consition to get just the connected company because this company get all record 

SELECT
   code as x_compte , account_move_line.name as x_designation ,account_move_line.debit as x_debit ,account_move_line.credit as  x_credit, account_move.narration as x_observation
FROM account_account JOIN account_move_line on account_account.id = account_move_line.account_id
                                    JOIN account_move on account_move_line.move_id   = account_move.id
                                    JOIN res_users on account_move_line.company_id  = res_users.company_id
                                    JOIN login_detail on login_detail.name = res_users.login
where substring (code,1,1) ='5' 

 

Avatar
Abbandona
Risposta migliore

You can get the current user in a variable and print in your report.

current_user_name = self.env.user.name

current_user_id = self.env.user

Avatar
Abbandona
Risposta migliore

in your python code you can get active user id :

current_uid = self._context.get('uid')

user_obj = self.env['res.users'].browse(current_uid)

after that you can access the company or companies of that user (user_obj )

Avatar
Abbandona
Post correlati Risposte Visualizzazioni Attività
3
set 22
7142
1
ago 22
4688
5
feb 20
11964
2
feb 19
2779
0
feb 19
3830