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

CRM
e-Commerce
Contabilitate
Inventar
PoS
Proiect
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

I have calculated No of Days from start_date, end_date then show in no of day field, now want to apply arithmetic condition on no of day to add them and return to total day field

#python v14

1 Răspunde

2550 Vizualizări

zahoor Ullah

.py Code

from flectra import models, fields,api,_fromdatetimeimportdatetime, date, timedeltafrom flectra.tools import DEFAULT_SERVER_DATE_FORMAT# from flectra.date import date
classweekreports(models.Model):_name = 'week.task'_description ='Generate Week Base Reports'name=fields.Char(string='Name')total_days = fields.Integer(string="Total Days",store=True)active = fields.Boolean(default=True)number_of_days = fields.One2many('number.of.days','week_task',string='Number of Days')
classNumberOfDays(models.Model):_name = 'number.of.days'week_task = fields.Many2one('week.task', string='Week Tasks')no_of_days = fields.Integer(string="Number of Days")st_date = fields.Date(string='Start Date')end_date = fields.Date(string='End Date')@api.depends('st_date','end_date')@api.onchange('st_date','end_date')defchange_numbber(self):forrecinself:days = 0ifrec.st_date andrec.end_date:duration = datetime.strptime(str(rec.end_date), DEFAULT_SERVER_DATE_FORMAT) - datetime.strptime(str(rec.st_date),DEFAULT_SERVER_DATE_FORMAT)rec.no_of_days = duration.days

.xml Code

<flectra><data><recordid="app_task_id"model="ir.actions.act_window"><fieldname="name">Weeksfield><fieldname="res_model">week.taskfield><fieldname="view_mode">tree,formfield>record><recordid="week_tree"model="ir.ui.view"><fieldname="name">week.task.treefield><fieldname="model">week.taskfield><fieldname="arch"type="xml"><treestring="Weeks"><fieldname='name'/><fieldname="total_days"/><fieldname="active"/>tree>field>record>

<recordid='week_task_form_view'model='ir.ui.view'><fieldname='name'>week.task.form.viewfield><fieldname='model'>week.taskfield><fieldname='arch'type='xml'><form><header>header><sheet><group><group><fieldname='name'/>group><group><fieldname='total_days'/>group>group><notebook><pagestring="NO Of Days"><fieldname="number_of_days"><treestring="No of Days"editable="bottom"><fieldname="st_date"/><fieldname="end_date"/><fieldname="no_of_days"/>tree>field>page>notebook>sheet>form>field>record>
<menuitemid="days_task"name="Days"action="app_task_id"sequence="1"groups="base.group_user"/>data>flectra>

Jainesh Shah(Aktiv Software)

Hello zahoor Ullah,

You can try to compute the method to calculate the total_days field from the number_of_days. I have updated your code with compute method.

Please find code in comment.

I hope This will help you.

Thanks & Regards,
Email: odoo@aktivsoftware.com
Skype: kalpeshmaheshwari

Jainesh Shah(Aktiv Software)

Code Example :

from datetime import datetime

from odoo import api, fields, models
from odoo.tools import DEFAULT_SERVER_DATE_FORMAT

class WeekReports(models.Model):
_name = 'week.task'
_description = 'Generate Week Base Reports'

name = fields.Char(string='Name')
total_days = fields.Integer(string="Total Days", compute="_compute_total_days")
active = fields.Boolean(default=True)
number_of_days = fields.One2many('number.of.days', 'week_task', string='Number of Days')

@api.depends("number_of_days", "number_of_days.no_of_days")
def _compute_total_days(self):
for rec in self:
rec.total_days = sum(rec.number_of_days.mapped("no_of_days"))

class NumberOfDays(models.Model):
_name = 'number.of.days'

week_task = fields.Many2one('week.task', string='Week Tasks')
no_of_days = fields.Integer(string="Number of Days")
st_date = fields.Date(string='Start Date')
end_date = fields.Date(string='End Date')

@api.onchange('st_date', 'end_date')
def change_number(self):
for rec in self:
if rec.st_date and rec.end_date:
duration = datetime.strptime(str(rec.end_date), DEFAULT_SERVER_DATE_FORMAT) - datetime.strptime(
str(rec.st_date), DEFAULT_SERVER_DATE_FORMAT)
rec.no_of_days = duration.days
else:
rec.no_of_days = 0

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
Attached PDF file is not formatted properly v14	1 dec. 25	221
Odoo14 alternative for Automated Translations through Gengo API module v14	3 sept. 25	3707
Odoo Community v14 Slow on High-End Servers, Fast on i5/i7 PCs v14	0 aug. 25	1133
How to Managing Birthdate and Age in Odoo v14	1 aug. 25	3508
Update Initial Stock of Product using XMLRPC API [Odoo14] Rezolvat v14	2 iul. 25	9121

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!