Odoo Help

0

0
3 Answers
2
Avatar

Nikhil Krishnan

--Nikhil Krishnan--
10549
| 7 7 10
Sharjah, 阿拉伯联合酋长国
--Nikhil Krishnan--

-- Nikhilkrishnan --

Exploring new ways in odoo..!
And want to become a key to the new odoo trends.

-> Odoo Consultancy,
-> Functional and Technical Consultant,
-> Requirement Collection and Analysis,
-> Module Customization,
-> Odoo ERP Community Contributor,
-> Handling ERP/Odoo projects,
-> ERP Workshop Facilitator.
Feel happy working with best and good supporting team.

#PITS Family

Nikhil Krishnan

nikhilkrishnan0101@gmail.com

Nikhil Krishnan
2019/3/3 上午12:19

Hi Daniel Abaka,

I think this will help you.

total_days= fields.Integer(compute="_compute_days", string='Days Count', copy=False, default=0, store=True)

    @api.multi
    @api.depends('end_date', 'start_date')
def _compute_days(self): for s in self: if s.end_date and s.start_date:
a = s.end_date - s.start_date s.total_days = a.days else: s.total_days = 0

regards,

Nikhilkrishnan

1
Avatar

Niyas Raphy

--Niyas Raphy--
24539
| 7 7 11
Wayanad, 印度
--Niyas Raphy--

Odoo Techno Functionalist

Feel free to connect :  niyasraphyk@gmail.com

Twitter:https://twitter.com/niyasraphy
LinkedIn: https://www.linkedin.com/in/niyasraphy/
FB:https://www.facebook.com/niyasraphy123

Happy to help :)

Niyas Raphy
2019/3/2 上午10:53

Hi, 

You can make the total days field as a compute field and compute it's values from the entered values. 


Inside the compute function you can get the difference of days by subtracting the dates, see the sample.

If we have d1 as date1 and d2 as date2 , then difference = (d2-d1).days.

 Also see this link: https://stackoverflow.com/questions/151199/how-to-calculate-number-of-days-between-two-given-dates

Thanks

0
Daniel Abaka
2019/3/3 上午12:56

Hi Nikhil krishnan,
Thanks for the support but i'm facing error on this line

s.total_days = a.days
error message there is no attribute for days
10 Comments
Nikhil Krishnan
2019/3/3 上午5:34

Actually i test it in my system and working fine, so can you please show the screen shot of the error. and the python code too.

Nikhil Krishnan
2019/3/3 上午5:37

put

print(a)

print(type(a))

before

s.total_days = a.days

show the result to us.

Daniel Abaka
2019/3/3 下午4:39

Here is my python code

depature_date = fields.Date(string="Depature Date From Work", required=True)

return_date = fields.Date(string="Return Date To Work", required=True)

total_number_of_days = fields.Integer(compute="_compute_days",string="Total Number Of Work Days", copy=False, default=0, store=True)

@api.multi

@api.depends('depature_date','return_date')

def _compute_days(self):

for s in self:

if s.depature_date and s.return_date:

a = s.depature_date + s.return_date

s.total_number_of_days = a.days

else:

s.total_number_of_days = 0

here is the error message

s.total_number_of_days = a.days

AttributeError: 'str' object has no attribute 'days'

Nikhil Krishnan
2019/3/3 下午11:20

a = s.depature_date + s.return_date

why you are adding?

what is your logic? can you explain what is your exact need?

Daniel Abaka
2019/3/4 上午4:14

I'm adding depature_date and return_date to get the total_number_of_days .

Daniel Abaka
2019/3/4 上午5:58

Hello NIKHIL KRISHNAN,

The logic is once depature_date and return_date is selected automatically the total_number_of_days should be counted as total days selected.

I'm this ways i want to add depature_date + return_date to get the total days.

Nikhil Krishnan
2019/3/4 上午7:04

ok fine,

You try with this code.

a = s.return_date - s.depature_date

s.total_number_of_days = a.days

Nikhil Krishnan
2019/3/4 上午7:10

if we add two dates, we can't get a total number of days, differece of dates means the number of days between the two dates. i think you got the idea.

upvotes are appreciated

Daniel Abaka
2019/3/4 上午7:29

NIKHIL KRISHNAN ,

I have try this code and get error

a = s.return_date - s.depature_date

s.total_number_of_days = a.days

Error Message

in _compute_days

a = s.depature_date - s.return_date

TypeError: unsupported operand type(s) for -: 'str' and 'str'

Nikhil Krishnan
2019/3/4 下午11:11

please convert them in to date formate.

Ask a Question
Keep Informed
1 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register
Odoo Training Center

Access to our eLearning platform and experience all Odoo Apps through learning videos, use cases and quizzes.

Test it now