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

i was created a module with the constrains for showing warning message. I was followed odoo documentation, the thing is that user cant book the same room at same date.But after my interating code the warning message shows, even i cant able to book the room on different dates.Is it possible to do by two variables passes?? Please give me a solution.

code for constrain is:-

def _check_date(self, cr, uid,ids, context=None):

record = self.search(cr, uid,[('room_id', '=', self.room_id.id),('start', '=', self.start)])

if record:

return False

return True

_constraints = [(_check_date, 'Room already booked',['room_id','start'])]

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

Hello,

instead you can use _sql_constraints  e.g:

_sql_constraints = [

('room_date_unique', 'unique(room_id, start)', 'Configuration Error!'),

]

I hope it'll help

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

Logicious, Please check your start field is just a "date" field not "datetime" , since in datetime field every date will be different from other with atleast some millisecond. Hope it helps

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

@Ahmed and pawan : i am sorry guys.... its working when the 'datetime'  changed to 'date' . But i need 'datetime' as it is. how could i make a constraint for this? Please help me guys


Ảnh đại diện
Huỷ bỏ

If you need the room_id & start_date to be unique 'no same room for the same start date' you can simply add _sql_constraints, you can check this part: https://github.com/odoo/odoo/blob/8.0/addons/account/account.py#L579-L581

Bài viết liên quan Trả lời Lượt xem Hoạt động
3
thg 10 22
9026
1
thg 11 22
3397
0
thg 6 21
5950
0
thg 3 21
2774
2
thg 1 20
21733