~mga/openobject-addons/account_india

import time

from report import report_sxw

import datetime

import pooler

class reservation_detail_report(report_sxw.rml_parse):

    def __init__(self, cr, uid, name, context):

        super(reservation_detail_report, self).__init__(cr, uid, name, context)

        print "dadasdasda"

        self.localcontext.update( {

            'time': time,

            'get_data': self.get_data,

            'get_checkin': self.get_checkin,

            'get_checkout': self.get_checkout,

            'get_room':self.get_room,

            

        })

        self.context=context

        

    def get_data(self,date_start,date_end):

        tids = self.pool.get('hotel.reservation').search(self.cr,self.uid,[('checkin', '>=', date_start),('checkout', '<=', date_end)])

        res = self.pool.get('hotel.reservation').browse(self.cr,self.uid,tids)

        print res

        return res

    

    def get_checkin(self,date_start,date_end):

        tids = self.pool.get('hotel.reservation').search(self.cr,self.uid,[('checkin', '>=', date_start),('checkin', '<=', date_end)])

        res = self.pool.get('hotel.reservation').browse(self.cr,self.uid,tids)

        print res

        return res

    

    def get_checkout(self,date_start,date_end):

        tids = self.pool.get('hotel.reservation').search(self.cr,self.uid,[('checkout', '>=', date_start),('checkout', '<=', date_end)])

        res = self.pool.get('hotel.reservation').browse(self.cr,self.uid,tids)

        print res

        return res

    

    def get_room(self,date_start,date_end):

        

        print "method--------"

        self.cr.execute("select pt.name,count(pt.name) as No_of_times from hotel_reservation as hr " \

                   "inner join hotel_reservation_line as hrl on hrl.line_id=hr.id " \

                   "inner join hotel_reservation_line_room_rel as hrlrr on hrlrr.room_id=hrl.id " \

                   "inner join product_product as pp on pp.product_tmpl_id=hrlrr.hotel_reservation_line_id " \

                   "inner join product_template as pt on pt.id=pp.product_tmpl_id " \

                   "where hr.state<>'draft' and hr.checkin >= %s and hr.checkout <= %s group by pt.name " \

                   ,(date_start,date_end)

                  

                   )

        res2=self.cr.dictfetchall()

        print res2

        return res2

    

        

 

report_sxw.report_sxw('report.reservation.detail', 'hotel.reservation', 'addons/hotel_reservation/report/room_res.rml',parser= reservation_detail_report)

report_sxw.report_sxw('report.checkin.detail', 'hotel.reservation', 'addons/hotel_reservation/report/checkinlist.rml',parser= reservation_detail_report)  

report_sxw.report_sxw('report.checkout.detail', 'hotel.reservation', 'addons/hotel_reservation/report/checkoutlist.rml',parser= reservation_detail_report)            

report_sxw.report_sxw('report.maxroom.detail', 'hotel.reservation', 'addons/hotel_reservation/report/maxroom.rml',parser= reservation_detail_report)