Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
8213 Lượt xem

Hello everyone,

Got this code done but it wont work. What should I do to get number of days and weeks ?

Two fields: days and weeks defined as a _computed fields

.....

 _columns = {

'st_date': fields.date('Start date'),

'en_date': fields.date('End date'),

'product': fields.one2many('product.data','check_id', string="Product"),

'days': fields.char(_compute='days_between', string='NoD'),

'weeks': fields.char(_compute='weeks_between', string='NoW'),

}

def days_between(st_date,en_date):

st_date = datetime.strptime('st_date', "%Y-%m-%d")

en_date = datetime.strptime('en_date', "%Y-%m-%d")

return abs((en_date - st_date).days)

print 'test==days'

print days_between('2013-05-06', '2013-06-06')


def weeks_between(st_date,en_date):

weeks = rrule.rrule(rrule.WEEKLY, dtstart=st_date, until=en_date)

return weeks.count()

print 'test==weeks'

print 'weeks between', weeks


.....

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

Dear Dr Obx,

Use below code may be help for you.

from datetime import datetime, timedelta

def _days_between(self, cr, uid, ids, field_name, arg, context=None):

    res = {}

    for cur_data in self.browse(cr, uid, ids, context=context):

        st_date = datetime.strptime(cur_data.st_date, "%Y-%m-%d")

        en_date = datetime.strptime(cur_data.en_date, "%Y-%m-%d")

        res[cur_data.id] = abs((en_date - st_date).days)

    return res

def _weeks_between(self, cr, uid, ids, field_name, arg, context=None):

    res = {}

    for cur_data in self.browse(cr, uid, ids, context=context):

        st_date = datetime.strptime(cur_data.st_date, "%Y-%m-%d")

        en_date = datetime.strptime(cur_data.en_date, "%Y-%m-%d")

        week_day1 = (st_date - timedelta(days=st_date.weekday()))

        week_day2 = (en_date - timedelta(days=en_date.weekday()))

        res[cur_data.id] = (week_day2 - week_day1).days / 7

    return res

_columns = {

'st_date': fields.date('Start date'),

'en_date': fields.date('End date'),

'days': fields.function(_days_between, type='char', string='NoD'),

'weeks': fields.function(_weeks_between, type='char', string='NoW'),

}

Best Regards,

Ankit H Gandhi

Ảnh đại diện
Huỷ bỏ
Tác giả

Thank you Ankit. Checking ;)

Your Welcome Dr Obx !!!

Tác giả

Works beautifully :)

Tác giả

By the way, Ankhit what about months ? will it work same way if I change some details in "weeks ?"

You can get months from start date or end date

Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 11 19
2723
5
thg 3 16
10288
3
thg 9 24
1419
0
thg 12 23
1353
0
thg 10 21
2944