How i retrieve data from total field and summation of total field value will show?
def get_data(self):
query = """select total(this is field name)from cashin_balance(database model name)"""
self.env.cr.execute(query)
query_result = self.env.cr.dictfetchall()
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- 회계
- 재고 관리
- PoS
- Project
- MRP
신고된 질문입니다
1
회신
3936
화면
I think you want to fetch the sum of the total field form the database table.
Try the following query:
SELECT SUM(total) FROM cashin_balance
Sir where i write query and what is the code to get data and how to view
.py file
from odoo import api, models, fields
class CashinBalance(models.Model):
_name = 'cashin.balance'
# _inherit = 'mail.thread'
_description = 'Cash-in Details'
a = fields.Integer('TK.1000')
b = fields.Integer('TK.500')
c = fields.Integer('TK.100')
d = fields.Integer('TK.50')
e = fields.Integer('TK.20')
f = fields.Integer('TK.10')
g = fields.Integer('TK.5')
h = fields.Integer('TK.2')
date = fields.Date()
total = fields.Integer(compute='total_cash', store=True)
# cash = fields.Integer(compute='_get_users', store=True)
@api.depends('a','b','c','d','e','f','g','h')
def total_cash(self):
for expense in self:
expense.total = expense.a * 1000 + expense.b*500 + expense.c*100 + expense.d*50 +expense.e*20 + expense.f*10 + expense.g*5 + expense.h*2
please give the code which will be right
| 관련 게시물 | 답글 | 화면 | 활동 | |
|---|---|---|---|---|
|
Data for relations table
해결 완료
|
|
1
4월 24
|
2227 | |
|
1
8월 22
|
3007 | ||
|
0
5월 17
|
7670 | ||
|
1
3월 15
|
4077 | ||
|
2
3월 15
|
4612 |
