콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
3 답글
2163 화면

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.

아바타
취소
작성자 베스트 답변

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' 

 

아바타
취소
베스트 답변

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

아바타
취소
베스트 답변

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 )

아바타
취소
관련 게시물 답글 화면 활동
3
9월 22
7344
1
8월 22
4914
5
2월 20
12222
2
2월 19
2912
0
2월 19
4030