On Tue, 2009-08-18 at 21:02 +0430, Behzad wrote: > Based on Ashely's reply, I created the following scheme: > > The table "Rooms" has the following fields. > > - id (PK) > - room_no (varchar) > - status (ENUM: Busy, Reserved) > > the other table, "RoomLogs", has the following fields: > - room_id (the id from above table) > - status_modified_on (date) > - status (enumerated value - 'busy','reserved') > > The problem is to generate a graph to display status of rooms in different > periods of > time (daily, weekly, monthly). > X Axis = Status (Busy, Reserved) > Y Axis = Number of rooms with a certain status (the last status for each > room makes sense) > > > On Tue, Aug 18, 2009 at 8:13 PM, Ralph Deffke <ralph_deffke@xxxxxxxx> wrote: > > > to answer this is in fact not possible on the base of information u give. > > > > I dont think there is a general db outlay for hotels. it depends how the > > "booking" tables are designed. > > > > does the application excist or u are doing a new one? > > > > if it excist, have a look how the availability of a room is calculated and > > then go from there. it would be the same calculation, just with backwards > > dates. > > > > hope that helps > > > > ralph_deffke@xxxxxxxx > > > > > > > > "Behzad" <behzad.eslami@xxxxxxxxx> wrote in message > > news:470fa6660908180745i6bb6a442xd53d2c02fac7bb8d@xxxxxxxxxxxxxxxxx > > > Dear list, > > > e-Greetings! > > > > > > I'm faced with an interesting and challenging problem. > > > > > > Consider a database, designed for a hotel. > > > At any given time, each room has a different status: It's Busy or > > Reserved, > > > or Free. > > > > > > It's easy to retrieve number of Free rooms at the current time. > > > But how can I count the number of rooms that were busy during the last > > week > > > ? > > > > > > I would appreciate if you take a brief moment of your time and share your > > > opinion. > > > > > > Thank you in advance, > > > -b > > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > You should add a 'free' type to the first table (just the first one) to indicate whether a room is free or not also. As for counting the number of rooms that were busy last week, think about what that actually means. Does that mean all rooms that were busy the entire time, all rooms that were busy at least part of the time during that week, etc? Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
