headers
Phil Greer | 5 Jan 2004 20:12

Re: Create transaction log

Got it worked out in case someone is interested in this functionality.

I made a copy of the mrbs_entry table and named it mrbs_transactions. Could
be called mrbs_log, whatever... I also created a duplicate of
mrbsCreateSingleEntry() function in mrbs_sql.inc and called it
mrbsCreateSingleTransaction() calling the mrbs_transactions table. All table
entries are the same. A call to mrbsCreateSingleTransacions() needs to be
called everywhere mrbsCreateSingleEntry() is called. This would be three
places. One in edit_entry_handler.php and twice in the mrbs_sql.inc within
the mrbsCreateRepeatingEntrys() function (third function from the bottom).

I have one more thing to do yet, and that is to put in a category in the
transaction log for when they delete the entry. Will put in how I do this in
a later post...

So, why did I do this? Well, I am using MRBS it to track time on research
equipment linked to a specific room and we need to have better usage stats
than the ones that are available with mrbs by default. The point is to keep
track of all of the changes in the booking system. If someone books a room
(in my case equipment), then comes back and changes the booking requesting
additional supplies for the room, you loose the original request date. This
same thing happens if you are trying to mark the booking as completed or
cancelled. I know not all people are using this for this purpose, but it is
something that I have found useful so that I can keep track of the resources
used here. 

********************************************
* Phil Greer                               *
* Unix/Network Administrator               *
* MR Research Center                       *
(Continue reading)

Permalink | Reply | 0 comments |
headers
Gavin Walker | 5 Jan 2004 23:20
Picon

Re: repport and type

I have completed and tested a modification which will allow reports to
be filtered on entry types.  (Thanks to Arnaud for his assistance with
this.)  This is implemented as a select box.

I will hopefully have time to commit this chance in the next couple of
days.

I was also thinking of changing the Match Area and Match Room into
select boxes as well, but I am not sure if this would be of interest to
other users or how user-friendly this could be made.

Regards

Gavin.

On Thu, 2003-12-25 at 21:27, Arnaud SICHEL wrote:
> Hello, I allows itself to contact you in order to subject one to you
> fonctionnalitée to mrbs.
> 
> In the report part,  would be interesting to have
> possibilitée to specify the type of reservation (intern, external...)
> in order to refine the report.
> 
> I have to try to add this fonctionnalitée without success.
> 
> thank you
> 
> Arnaud
> 
> [ORIGINAL FRENCH]
(Continue reading)

Permalink | Reply | 0 comments |
headers
pguay | 6 Jan 2004 22:20

School setup question

Im still trying to make work a file that someone send to me to put mrbs to
periode setup. I think the work was base on an older release and i get
nothing on the browser (blank page)

Is there someone using periode instead of hour with the earlier release of
mrbs... i really need to get mrbs working soon teacher of my school are
making pressure.

Thx

Phil
Permalink | Reply | 0 comments |
headers
John Beranek | 7 Jan 2004 14:23

[Fwd: thanks for your software]

Nic, I've forwarded your email to the list, we prefer to do support via 
the list, not to individual developers.

John.

-------- Original Message --------
Subject: thanks for your software
Date: Fri, 12 Dec 2003 12:03:50 -0800
From: Nic Lowe <niclowe <at> users.sourceforge.net>
To: jberanek <at> users.sourceforge.net
CC: <niclowe <at> users.sourceforge.net>

I've written quite a large hack to it that is used for a carshare

booking system

It includes an invoicing layer (with mulitple plan rates for

different 'rooms'='cars')

Plus email confirmations of bookings

Plus added image files to 'rooms'='cars' or 'pod'='parking

spaces'

Plus changed the layout from timeslot down to timeslot across

plus a few other bits and pieces
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Beranek | 7 Jan 2004 14:24

[Fwd: MRBS]

Arnaud, I've forwarded your email to the list, where we prefer to handle 
support requests, instead of emailing individual developers.

John.

-------- Original Message --------
Subject: MRBS
Date: Tue, 09 Dec 2003 12:38:30 +0100
From: Arnaud Sichel <asichel <at> free.fr>
To: jberanek <at> users.sourceforge.net

Hello,

I use MRBS in my company and dedicates remerci for this superb
project.

Do you think of inserting the type in the request for the
report? internal, external?

I have to try to make it but without surrès.

Thank you
Cordially

Arnaud SICHEL

--

-- 
Arnaud SICHEL
CDDP du Maine et Loire
http://www.crdp-nantes.cndp.fr/identite/index49.asp
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Beranek | 7 Jan 2004 14:29

[Fwd: TR : mrbs]

Rachid, I've forwarded your email to the list. We prefer to answer 
requests there rather than with emails to individual developers.

Also, sorry, I don't speak French. (Je ne parle pas français)

John.

-------- Original Message --------
Subject: TR : mrbs
Date: Thu, 6 Nov 2003 11:46:41 +0100
From: Rachid BENALI <benali <at> skynet.be>
To: <jberanek <at> users.sourceforge.net>

Bonjour,

Je cherche a modifier ce script de mrbs, actuellement il limite le
nombre de réservation par utilisateur par « room » ; je souhaite la même
chose, mais aussi par « area » c a dire : l’utilisateur a droit a un
nombre de réservation mais ne peut réserver plusieurs « room » a la fois
si la limite maximum est atteinte (ex : si une réservation et faite sur
le lieu n°A et que la limitation est a 2 réservation maximum, il peut
encore réserver 1 fois dans les autres room ou dans la même . Mais si la
réservation maximum est a  1 il ne peut pas réserver sur aucun room).

Dans l’exemple ci-dessous, si la réservation max est a 1, il ne peut
plus réserver dans la même room, mais il arrive encore a réserver dans
les autres room (ce que je veux éviter)

function UserRoomMaxBooking($user, $id_room, $number)  {
   // On regarde si le nombre de réservation de la ressource est limité
(Continue reading)

Permalink | Reply | 0 comments |
headers
John Beranek | 7 Jan 2004 14:40

[Fwd: mrbs modification]

Tollie, I've forwarded your email to the list 
(mrbs-general <at> lists.sourceforge.net), where we prefer to handle support 
requests, instead of emailing individual developers.

John.

-------- Original Message --------
Subject: mrbs modification
Date: Tue, 11 Nov 2003 20:11:20 -0800
From: Tollie Mullins <tollie <at> users.sourceforge.net>
To: jberanek <at> users.sourceforge.net
CC: <tollie <at> users.sourceforge.net>

Hello,

Want to know if you have a specification for mrbs.

What I would like to do is modify it slightly to include some

additional fields on the add entry page. So that I can change

the names of the fields and also add more to that page.

Am looking at using mrbs for a reservation system for a very

small bed and breakfast.

reply to tolliem <at> us.ibm.com

--

--
(Continue reading)

Permalink | Reply | 0 comments |
headers
Gavin Walker | 8 Jan 2004 21:56
Picon

Queries about period implementation

As you may be aware I am looking at the changes necessary to support
periods (irregular time intervals).  I have two queries to help guide
the development work:

1) Scenario: Class is two periods long and starts in period 2
   Currently the view entry page would say:
   Start Time: Period 2
   Duration:   2 periods
   End Time:   Period 4

   I would propose to make this say:
   Start Time: Period 2
   Duration:   2 periods
   End Time:   Period 3
   which I believe is the more natural way to express the duration.
   Note: the day/week/month views are unaffected by this.

2) Scenario: Class is last period of Monday and first period of Tuesday
   Would you expect to be able to book this as starting on Monday with
   a duration of 2 periods?

   I would prefer to implement this as two separate bookings but I am
   not sure that this is the behaviour that I would expect if I was
   using MRBS.

   Any thoughts?

Regards

Gavin
(Continue reading)

Permalink | Reply | 7 comments |
headers
John Meskes | 8 Jan 2004 22:49
Picon
Favicon

Re: Queries about period implementation

On 8 Jan 2004 at 20:56, Gavin  Walker wrote:

>    I would propose to make this say:
>    Start Time: Period 2
>    Duration:   2 periods
>    End Time:   Period 3
>    which I believe is the more natural way to express the duration.
>    Note: the day/week/month views are unaffected by this.

I would agree. A period is not a single point in time, like 11:30, but a 
range. This would also allow for non-contiguous times, eg:
p1 9:00-10:15
p2 10:30-12:00
p3 13:30-15:30
Booking p1-2 would end at 12:00 not 13:30

> 2) Scenario: Class is last period of Monday and first period of Tuesday
>    Would you expect to be able to book this as starting on Monday with
>    a duration of 2 periods?
>    I would prefer to implement this as two separate bookings but I am
>    not sure that this is the behaviour that I would expect if I was
>    using MRBS.

Both could be allowed, depending on if you want to keep the room 
during the "non-period" times. Here we have "Day Programs" 
periods 1 to 12 (each 50min+5min gap). Then the space is turned 
over to our "Continuing Education" (night school) Faculty, which 
books rooms by clock time (eg 19:00-21:30).

*** I hope that periods can coexist/interact with clock times!!
(Continue reading)

Permalink | Reply | 6 comments |
headers
Gavin Walker | 9 Jan 2004 00:15
Picon

Re: Queries about period implementation

John

Thank you for the feedback.  Please see my comments/questions below.

On Thu, 2004-01-08 at 21:49, John Meskes wrote:
> > 2) Scenario: Class is last period of Monday and first period of Tuesday
> >    Would you expect to be able to book this as starting on Monday with
> >    a duration of 2 periods?
> >    I would prefer to implement this as two separate bookings but I am
> >    not sure that this is the behaviour that I would expect if I was
> >    using MRBS.
> 
> Both could be allowed, depending on if you want to keep the room 
> during the "non-period" times. Here we have "Day Programs" 
> periods 1 to 12 (each 50min+5min gap). Then the space is turned 
> over to our "Continuing Education" (night school) Faculty, which 
> books rooms by clock time (eg 19:00-21:30).
> 
> *** I hope that periods can coexist/interact with clock times!!
> 
Aaaaagh! Not unless, you can turn your clock times into periods.  What
is your "resolution" for bookings in the evenings?

The approach I have adopted is to assign periods to the minutes between
12:00 and 13:00 on each day.  The name of the period is free form so you
could have names like:
Period 1 - 9:00 to 9:50
Period 2 - 9:55 to 10:45
...
Period 12 - ? to ?
(Continue reading)

Permalink | Reply | 0 comments |

Gmane