def rebuildRoomReservationsIndex():
from MaKaC.common.db import DBMgr
from MaKaC.rb_location import CrossLocationDB
from MaKaC.rb_room import RoomBase
from MaKaC.plugins.RoomBooking.default.dalManager import DALManager
from BTrees.OOBTree import OOBTree
DBMgr.getInstance().startRequest()
CrossLocationDB.connect()
root = DALManager.root
resvEx = ReservationBase()
resvEx.isConfirmed = None
allResvs = CrossLocationQueries.getReservations( resvExample = resvEx )
print "There are " + str( len( allResvs ) ) + " resvs and pre-resvs to index..."
c = 0
root[_ROOM_RESERVATIONS_INDEX] = OOBTree()
print "Room => Reservations Index branch created"
for resv in allResvs:
roomReservationsIndexBTree = root[_ROOM_RESERVATIONS_INDEX]
resvs = roomReservationsIndexBTree.get( resv.room.id )
if resvs == None:
resvs = [] # New list of reservations for this room
roomReservationsIndexBTree.insert( resv.room.id, resvs )
resvs.append( resv )
roomReservationsIndexBTree[resv.room.id] = resvs
c += 1
if c % 100 == 0:
print c
CrossLocationDB.commit()
CrossLocationDB.disconnect()
DBMgr.getInstance().endRequest()
def _process( self ):
from MaKaC.rb_room import RoomBase
from datetime import datetime,timedelta
from MaKaC.rb_reservation import ReservationBase
startdt = enddt = datetime.now()
today = startdt.date()
startdt.replace( hour = 0, minute = 0)
enddt.replace( hour = 23, minute = 59)
self._responseUtil.content_type = 'text/xml'
XG = xmlGen.XMLGen()
XG.openTag("response")
rooms = RoomBase.getRooms()
nbRooms = len(rooms)
nbPublicRooms = nbPrivateRooms = nbSemiPrivateRooms = 0
for r in rooms:
if not r.isReservable:
nbPrivateRooms += 1
elif not r.resvsNeedConfirmation:
nbPublicRooms += 1
else:
nbSemiPrivateRooms += 1
self._createIndicator(XG, "total", "total number of managed rooms", nbRooms)
self._createIndicator(XG, "public", "number of public rooms", nbPublicRooms)
self._createIndicator(XG, "semiprivate", "number of semi-private rooms", nbSemiPrivateRooms)
self._createIndicator(XG, "private", "number of private rooms", nbPrivateRooms)
resvex = ReservationBase()
resvex.isConfirmed = True
resvex.isCancelled = False
nbResvs = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
resvex.usesAVC = True
nbAVResvs = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
resvex.needsAVCSupport = True
resvex.needsAssistance = False
nbAVResvsWithSupport = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
self._createIndicator(XG, "nbbookings", "total number of bookings for today", nbResvs)
self._createIndicator(XG, "nbvc", "number of remote collaboration bookings (video or phone conference)", nbAVResvs)
self._createIndicator(XG, "nbvcsupport", "number of remote collaboration bookings with planned IT support", nbAVResvsWithSupport)
XG.closeTag("response")
return XG.getXml()
def _process( self ):
from MaKaC.rb_room import RoomBase
from datetime import datetime,timedelta
from MaKaC.rb_reservation import ReservationBase
startdt = enddt = datetime.now()
today = startdt.date()
startdt.replace( hour = 0, minute = 0)
enddt.replace( hour = 23, minute = 59)
self._req.content_type = "text/xml"
XG = xmlGen.XMLGen()
XG.openTag("response")
rooms = RoomBase.getRooms()
nbRooms = len(rooms)
nbPublicRooms = nbPrivateRooms = nbSemiPrivateRooms = 0
for r in rooms:
if not r.isReservable:
nbPrivateRooms += 1
elif not r.resvsNeedConfirmation:
nbPublicRooms += 1
else:
nbSemiPrivateRooms += 1
self._createIndicator(XG, "total", "total number of managed rooms", nbRooms)
self._createIndicator(XG, "public", "number of public rooms", nbPublicRooms)
self._createIndicator(XG, "semiprivate", "number of semi-private rooms", nbSemiPrivateRooms)
self._createIndicator(XG, "private", "number of private rooms", nbPrivateRooms)
resvex = ReservationBase()
resvex.isConfirmed = True
resvex.isCancelled = False
nbResvs = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
resvex.usesAVC = True
nbAVResvs = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
resvex.needsAVCSupport = True
resvex.needsAssistance = False
nbAVResvsWithSupport = len(ReservationBase.getReservations( resvExample = resvex, days = [ startdt.date() ] ))
self._createIndicator(XG, "nbbookings", "total number of bookings for today", nbResvs)
self._createIndicator(XG, "nbvc", "number of remote collaboration bookings (video or phone conference)", nbAVResvs)
self._createIndicator(XG, "nbvcsupport", "number of remote collaboration bookings with planned IT support", nbAVResvsWithSupport)
XG.closeTag("response")
return XG.getXml()