General discussion of MRBS (Meeting Room Booking System)

Ed | 4 Jan 2008 04:04

Booking in advance

Hello everyone.  I hope I can get a little help here.

I need 4 things.  One was already answered in the archives.

1.  To prevent booking in the past, today or within the next 14 days.   
I found the fix
for the past and today and modified the ($day < $this_day) to ($day <  
$this_day+14) and
that works.  But, still need help with the next 3 items.

2. Prevent bookings more than 6 months out.  I don't want someone  
booking for next year.  I found a post for 4 months out but didn't  
seem to work for me.  I will continue to tinker with it.

3. The 3 calendar display shows last month, this month and next month.  
  I want to change that to this month and the next 5 months (or  
atleast the next 2 months).

4. Is there any way a user can register and make their booking?  Then  
maybe send them to a another webpage to make a payment (deposit) to  
reserve the day?

This a great program and looks like it will work for our videography business.

Thanks in advance,
Ed

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.

(Continue reading)

headers

Daniel Håkansson | 5 Jan 2008 13:27

Stop time

I am wondering if it is possible to stop the time in mrbs.

What i would like to achive is that for each room there is 10 "days" shown in kolums next to eachother and that the "days" are namne 1-10 and that regardles of that date you log in at mrbs its always the same 10 "days" that are shown.

Kind Regards

Daniel Håkansson

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

Chris Snow | 7 Jan 2008 17:06

Move booking forward 7 days

Hello.

Unfortunately one user has booked several rooms on a two week rotation 
but started with the wrong week!

Does anyone have a query that will move forward (or back) all bookings 
made by a given user by 7 days?

I'd be much obliged!

Chris.

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

headers

John Beranek | 7 Jan 2008 17:19

Re: Move booking forward 7 days

Chris Snow wrote:
> Hello.
> 
> Unfortunately one user has booked several rooms on a two week rotation 
> but started with the wrong week!
> 
> Does anyone have a query that will move forward (or back) all bookings 
> made by a given user by 7 days?

UPDATE mrbs_entry SET
start_time=start_time+(7*60*60*24),end_time=end_time+(7*60*60*24) WHERE
create_by='WHOEVER'

UPDATE mrbs_repeat SET
start_time=start_time+(7*60*60*24),end_time=end_time+(7*60*60*24) WHERE
create_by='WHOEVER'

This won't update the repeat end date as it is. Replace the + with a -
to make the query move the bookings back in time.

Also, as it stands it will change all bookings that user has created,
including ones in the past.

John.

--

-- 
John Beranek                         To generalise is to be an idiot.
http://redux.org.uk/                                 -- William Blake

Attachment (smime.p7s): application/x-pkcs7-signature, 3331 bytes

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

headers

Julian Egelstaff | 7 Jan 2008 19:17

Added copy feature

Hello,

We've recently added a feature to MRBS that lets you copy entries and
series, in addition to editing and deleting them.  The modified files
are here:  http://www.freeformsolutions.ca/temp/mrbs-copy_feature.zip

The changes were very minor, since the edit system is so cleanly
written, nice work!  

Basically, we make two new links on the view_entry page, and those links
have a special flag parameter in the URL to indicate that the entry is
being copied (we used "clone" for the param name, since &copy in the URL
results in a copyright symbol appearing there).

Then, on the edit page, if the clone param is in the URL, we change the
text in the title of the page, and we omit the entry ID so the entry
handler treats the submission as a new entry.  But since an ID was in
the URL, the form is populated with the data from the original entry.

Nice and elegant, and a neat new feature.  I hope you find it useful and
perhaps can include it in a future release.

Feel free to get in touch if there's any questions.

--Julian

=============================================================
Julian Egelstaff   (   Technical Architect ~ Web Applications
647 723-5415 x101   )  Freeform Solutions
=============================================================

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

headers

Chris Snow | 8 Jan 2008 11:03

Re: Move booking forward 7 days

Thanks John.

I added  and timestamp like '2008-01-03%' as they were done on the same 
day and all is now well after some manual tweaking!

Chris.

John Beranek wrote:
> Chris Snow wrote:
>   
>> Hello.
>>
>> Unfortunately one user has booked several rooms on a two week rotation 
>> but started with the wrong week!
>>
>> Does anyone have a query that will move forward (or back) all bookings 
>> made by a given user by 7 days?
>>     
>
> UPDATE mrbs_entry SET
> start_time=start_time+(7*60*60*24),end_time=end_time+(7*60*60*24) WHERE
> create_by='WHOEVER'
>
> UPDATE mrbs_repeat SET
> start_time=start_time+(7*60*60*24),end_time=end_time+(7*60*60*24) WHERE
> create_by='WHOEVER'
>
> This won't update the repeat end date as it is. Replace the + with a -
> to make the query move the bookings back in time.
>
> Also, as it stands it will change all bookings that user has created,
> including ones in the past.
>
> John.
>
>   
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> ------------------------------------------------------------------------
>
> _______________________________________________
> mrbs-general mailing list
> mrbs-general <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
>   

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

headers

Johan Sundström | 8 Jan 2008 11:28

Change booking-time specification?

Hi!

Is there a way to change the way you specify the length of a booking?  
Instead of specifying hours i would be able to set the end-time as i  
do with the start-time.
Would be easier to count for long bookings..

Cheers /Johan

- -

Johan Sundström
Västerbottens museum
Box 3183
903 04 Umeå

Tel.		090 - 17 18 33
Mobiltel.	070 - 321 84 04
E-post.	johan.sundstrom <at> vbm.se
www	.	http://www.vasterbottensmuseum.se

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

headers

Jennifer Pollard | 8 Jan 2008 11:35

Re: Added copy feature

Julian Egelstaff wrote:
> We've recently added a feature to MRBS that lets you copy entries and
> series, in addition to editing and deleting them.  The modified files
> are here:  http://www.freeformsolutions.ca/temp/mrbs-copy_feature.zip

Oooh, handy!  Thanks for sharing, Julian! :)

-Jen
-- 
Jennifer Pollard
Computer Officer
Faculty of English
University of Cambridge

This e-mail (and any files transmitted with it) is strictly confidential 
and intended only for the use of the individual or organisation to whom 
it is addressed. It may contain information which is privileged. If you 
are not the intended recipient, you are notified that any dissemination, 
distribution or copying of this e-mail is strictly prohibited. If you 
have received this e-mail in error, please notify the sender and destroy 
the original message. Thank you.

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

headers

Sandy Spence | 8 Jan 2008 12:13

Re: Change booking-time specification?

Hi All,

Can I ask for the same feature, it would be nice if you clicked on a start
time, then clicked on the end time before the details page came up with the
start and end time already filled in.

Cheers,

Sandy Spence
====================================
Department of Computer Science - UWA 
Llandinam Building 
Penglais Campus 
Aberystwyth 
Ceredigion 
Wales - UK
SY23 3DB
Tel: (01970)-622433
Fax: (01970)-628536
Home Page

-----Original Message-----
From: mrbs-general-bounces <at> lists.sourceforge.net
[mailto:mrbs-general-bounces <at> lists.sourceforge.net] On Behalf Of Johan
Sundström
Sent: 08 January 2008 10:29
To: General purpose list (support/developers/users)
Subject: [MRBS-general] Change booking-time specification?

Hi!

Is there a way to change the way you specify the length of a booking?  
Instead of specifying hours i would be able to set the end-time as i  
do with the start-time.
Would be easier to count for long bookings..

Cheers /Johan

- -

Johan Sundström
Västerbottens museum
Box 3183
903 04 Umeå

Tel.		090 - 17 18 33
Mobiltel.	070 - 321 84 04
E-post.	johan.sundstrom <at> vbm.se
www	.	http://www.vasterbottensmuseum.se

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

headers

Phil Dunford | 8 Jan 2008 13:14

Re: Added copy feature

Excellent feature and very handy.

Is there a simple way to copy a whole day (all rooms, all bookings) and
paste it to another day. Would be very useful for me, but I'm very much a
PHP novice.

Phil Dunford

Bishop Thomas Grant School

-----Original Message-----
From: mrbs-general-bounces <at> lists.sourceforge.net
[mailto:mrbs-general-bounces <at> lists.sourceforge.net] On Behalf Of Julian
Egelstaff
Sent: 07 January 2008 18:17
To: mrbs-general <at> lists.sourceforge.net
Subject: [MRBS-general] Added copy feature

Hello,

We've recently added a feature to MRBS that lets you copy entries and
series, in addition to editing and deleting them.  The modified files
are here:  http://www.freeformsolutions.ca/temp/mrbs-copy_feature.zip

The changes were very minor, since the edit system is so cleanly
written, nice work!  

Basically, we make two new links on the view_entry page, and those links
have a special flag parameter in the URL to indicate that the entry is
being copied (we used "clone" for the param name, since &copy in the URL
results in a copyright symbol appearing there).

Then, on the edit page, if the clone param is in the URL, we change the
text in the title of the page, and we omit the entry ID so the entry
handler treats the submission as a new entry.  But since an ID was in
the URL, the form is populated with the data from the original entry.

Nice and elegant, and a neat new feature.  I hope you find it useful and
perhaps can include it in a future release.

Feel free to get in touch if there's any questions.

--Julian

=============================================================
Julian Egelstaff   (   Technical Architect ~ Web Applications
647 723-5415 x101   )  Freeform Solutions
=============================================================

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
mrbs-general mailing list
mrbs-general <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mrbs-general
..

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

25	May 2013
23	April 2013
74	March 2013
58	February 2013
115	January 2013
89	December 2012
80	November 2012
142	October 2012
122	September 2012
98	August 2012
155	July 2012
73	June 2012
99	May 2012
125	April 2012
164	March 2012
56	February 2012
193	January 2012
124	December 2011
103	November 2011
174	October 2011
223	September 2011
156	August 2011
144	July 2011
91	June 2011
106	May 2011
85	April 2011
123	March 2011
130	February 2011
107	January 2011
220	December 2010
289	November 2010
236	October 2010
184	September 2010
143	August 2010
91	July 2010
116	June 2010
49	May 2010
172	April 2010
156	March 2010
54	February 2010
49	January 2010
123	December 2009
156	November 2009
165	October 2009
94	September 2009
104	August 2009
109	July 2009
53	June 2009
88	May 2009
85	April 2009
150	March 2009
133	February 2009
127	January 2009
88	December 2008
58	November 2008
82	October 2008
125	September 2008
70	August 2008
74	July 2008
22	June 2008
37	May 2008
60	April 2008
43	March 2008
40	February 2008
83	January 2008
27	December 2007
29	November 2007
112	October 2007
54	September 2007
93	August 2007
39	July 2007
41	June 2007
24	May 2007
23	April 2007
64	March 2007
55	February 2007
32	January 2007
6	December 2006
12	November 2006
32	October 2006
33	September 2006
16	August 2006
36	July 2006
15	June 2006
23	May 2006
28	April 2006
43	March 2006
100	February 2006
56	January 2006
34	December 2005
17	November 2005
16	October 2005
51	September 2005
64	August 2005
36	July 2005
41	June 2005
52	May 2005
27	April 2005
34	March 2005
32	February 2005
14	January 2005
41	December 2004
33	November 2004
45	October 2004
61	September 2004
47	August 2004
40	July 2004
58	June 2004
106	May 2004
156	April 2004
128	March 2004
57	February 2004
143	January 2004
103	December 2003
125	November 2003
99	October 2003
118	September 2003
47	August 2003
61	July 2003
46	June 2003
56	May 2003
94	April 2003
76	March 2003
19	February 2003
84	January 2003
21	December 2002
25	November 2002
42	October 2002
29	September 2002
29	August 2002
24	July 2002
39	June 2002
71	May 2002
29	April 2002
21	March 2002
16	February 2002
26	January 2002
20	December 2001
29	November 2001
28	October 2001
25	September 2001
22	August 2001
26	July 2001
7	June 2001
32	May 2001
24	April 2001
63	March 2001
132	February 2001
68	January 2001
13	December 2000
30	November 2000
9	October 2000
30	September 2000
19	August 2000
37	July 2000
56	June 2000
11	May 2000

Mon	Tue	Wed	Thu	Fri	Sat	Sun

	1	2	3	4	5	6
7	8	9	10	11	12	13
14	15	16	17	18	19	20
21	22	23	24	25	26	27
28	29	30	31