Odoo Help


How to calculate number of nights for hotel management module in odoo8?

Kapil More
on 7/10/15, 1:51 AM 771 views

Hi, I am working on hotel management module in odoo version 8.

I wish to calculate number of nights stayed between check-in date and check-out date.  

Can anyone help me with this? How to calculate this?

I tried calculating it as per the number of days but not worked for me.

Here is my code,

Defined one class for Hotel Reservation,

class hotel_reservation(osv.Model):

_name = "hotel.reservation"

_rec_name = "reservation_no"

_description = "Reservation"

_order = 'reservation_no desc'

_columns = {

'reservation_no': fields.char('Reservation No', size=64, required=True, readonly=True),

'date_order':fields.datetime('Date Ordered', required=True, readonly=True, states={'draft':[('readonly', False)]}),

'warehouse_id':fields.many2one('stock.warehouse', 'Hotel', readonly=True, required=True, states={'draft':[('readonly', False)]}),

'partner_id':fields.many2one('res.partner', 'Guest Name', readonly=True, required=True, states={'draft':[('readonly', False)]}),

'pricelist_id':fields.many2one('product.pricelist', 'Price List', required=True, readonly=True, states={'draft':[('readonly', False)]}, help="Pricelist for current reservation. "),

'partner_invoice_id':fields.many2one('res.partner', 'Invoice Address', readonly=True, states={'draft':[('readonly', False)]}, help="Invoice address for current reservation. "),

'partner_order_id':fields.many2one('res.partner', 'Ordering Contact', readonly=True, states={'draft':[('readonly', False)]}, help="The name and address of the contact that requested the order or quotation."),

'partner_shipping_id':fields.many2one('res.partner', 'Delivery Address', readonly=True, states={'draft':[('readonly', False)]}, help="Delivery address for current reservation. "),

'checkin': fields.datetime('Expected-Date-Arrival', required=True, readonly=True, states={'draft':[('readonly', False)]}),

'checkout': fields.datetime('Expected-Date-Departure', required=True, readonly=True, states={'draft':[('readonly', False)]}),

'adults':fields.integer('Adults', size=64, readonly=True, states={'draft':[('readonly', False)]}, help='List of adults there in guest list. '),

'children':fields.integer('Children', size=64, readonly=True, states={'draft':[('readonly', False)]}, help='Number of children there in guest list. '),

'reservation_line':fields.one2many('hotel_reservation.line', 'line_id', 'Reservation Line', help='Hotel room reservation details. '),

'state': fields.selection([('draft', 'Draft'), ('confirm', 'Confirm'), ('cancel', 'Cancel'), ('done', 'Done')], 'State', readonly=True),

'folio_id': fields.many2many('hotel.folio', 'hotel_folio_reservation_rel', 'order_id', 'invoice_id', 'Folio'),

'dummy': fields.datetime('Dummy'),


    _defaults = {

        'reservation_no': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'hotel.reservation'),

        'state': lambda *a: 'draft',

        'date_order': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),


Also, 2 on change methods,

def on_change_checkin(self, cr, uid, ids, date_order, checkin_date=time.strftime('%Y-%m-%d %H:%M:%S'), context=None):

if date_order and checkin_date:

if checkin_date < date_order:

raise osv.except_osv(_('Warning'), _('Checkin date should be greater than the current date.'))

return {'value':{}}

def on_change_checkout(self, cr, uid, ids, checkin_date=time.strftime('%Y-%m-%d %H:%M:%S'), checkout_date=time.strftime('%Y-%m-%d %H:%M:%S'), context=None):

if not (checkout_date and checkin_date):

return {'value':{}}

if checkout_date < checkin_date:

raise osv.except_osv(_('Warning'), _('Checkout date should be greater than the Checkin date.'))

delta = datetime.timedelta(days=1)

addDays = datetime.datetime(*time.strptime(checkout_date, '%Y-%m-%d %H:%M:%S')[:5]) + delta

val = {'value':{'dummy':addDays.strftime('%Y-%m-%d %H:%M:%S')}}

return val

On 11/10/16, 1:57 AM

add this after 'dummy': fields.datetime('Dummy'),
    'duration' = fields.Float('Nuité', compute = '_compute_duration',  help="Number of days which will automatically  count from the check-in and check-out date. ", store = True),

and this after

    _defaults = {
        'reservation_no': lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'hotel.reservation'),
        'state': lambda *a: 'draft',
        'date_order': lambda *a: time.strftime('%Y-%m-%d %H:%M:%S'),

    @api.depends('checkout', 'checkin')

    def _compute_duration(self):
         myduration = 0

        chckin = self.checkin

        chckout = self.checkou

        if (chckin and chckout) :
            server_dt = DEFAULT_SERVER_DATETIME_FORMAT

            chkin_dt = datetime.datetime.strptime(chckin, server_dt)

            chkout_dt = datetime.datetime.strptime(chckout, server_dt)

            chkin = chkin_dt.time()

            chkout = chkout_dt.time()

            ckin = chkin_dt.date()

            ckout = chkout_dt.date()

            if (chkout < datetime.time(12, 10, 00, 000000)) :          # If the client leaves the hotel before 12h 10min
                dur = ckout - ckin

                myduration = (dur.total_seconds()) / 86400

            else :
                dur = ckout - ckin

                myduration = ((dur.total_seconds()) / 86400) + 1

            self.duration = myduration

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 7/10/15, 1:51 AM
Seen: 771 times
Last updated: 11/10/16, 1:57 AM